Table of Contents

Search

  1. Preface
  2. Workday Connector
  3. Workday connections
  4. Workday operations
  5. Mappings and mapping tasks with Workday
  6. Appendix A: Workday data type reference
  7. Appendix B: General considerations when using Workday V2 Connector
  8. Appendix C: Workday target approaches

Workday V2 Connector

Workday V2 Connector

Workday and transformation data types

Workday and transformation data types

The following table lists the Workday data types that
Data Integration
supports and the corresponding transformation data types:
Workday Data Type
Transformation Data Type
Range
anyURI
String
1 to 104,857,600 characters
base64Binary
Binary
1 to 104,857,600 bytes
boolean
String
1 to 104,857,600 characters
byte
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
date
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
dateTime
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
decimal
Decimal
Precision 1 to 28; scale 0 to 28
double
Double
Precision 15, scale 0
duration
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
ENTITIES
String
1 to 104,857,600 characters
ENTITY
String
1 to 104,857,600 characters
float
Double
Precision 15, scale 0
gDay
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
gMonth
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
gMonthDay
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
gYear
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
gYearMonth
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
hexBinary
Binary
1 to 104,857,600 bytes
ID
String
1 to 104,857,600 characters
IDREF
String
1 to 104,857,600 characters
IDREFS
String
1 to 104,857,600 characters
int
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
integer
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
language
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
long
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19; scale 0
Name
String
1 to 104,857,600 characters
NCName
String
1 to 104,857,600 characters
negativeInteger
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
NMTOKEN
String
1 to 104,857,600 characters
NMTOKENS
String
1 to 104,857,600 characters
nonNegativeInteger
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
nonPositiveInteger
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
normalizedString
String
1 to 104,857,600 characters
NOTATION
String
1 to 104,857,600 characters
positiveInteger
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
QName
String
1 to 104,857,600 characters
short
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
string
String
1 to 104,857,600 characters
time
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
token
String
1 to 104,857,600 characters
unsignedByte
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
unsignedInt
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0
unsignedLong
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19; scale 0
unsignedShort
Integer
-2,147,483,648 to 2,147,483,647
Precision 10; scale 0