TABLE DETAIL REFERENCE: Employee
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 41TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
FirstName12 VARCHAR 25TrueTrueTrueFalse%s
MiddleName12 VARCHAR 5TrueTrueTrueFalse%s
LastName12 VARCHAR 25TrueTrueTrueFalse%s
JobTitle12 VARCHAR 41TrueTrueTrueFalse%s
SupervisorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SupervisorRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
Department12 VARCHAR 31TrueTrueTrueFalse%s
Description12 VARCHAR 64TrueTrueTrueFalse%s
TargetBonus3 DECIMAL 15TrueTrueTrueFalse%10.2f
EmployeeAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
EmployeeAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
EmployeeAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
EmployeeAddressState12 VARCHAR 21TrueTrueTrueFalse%s
EmployeeAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
EmployeeAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
EmployeeAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
PrintAs12 VARCHAR 41TrueTrueTrueFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
Mobile12 VARCHAR 21TrueTrueTrueFalse%s
Pager12 VARCHAR 21TrueTrueTrueFalse%s
PagerPIN12 VARCHAR 10TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Fax12 VARCHAR 21TrueTrueTrueFalse%s
SSN12 VARCHAR 11TrueFalseTrueFalse%s
SIN12 VARCHAR 11TrueFalseTrueFalse%s
NiNumber12 VARCHAR 11TrueFalseTrueFalse%s
MaritalStatus12 VARCHAR 6TrueFalseFalseFalse
Single
Married
Email12 VARCHAR 1023TrueTrueTrueFalse%s
AdditionalContactRef1ContactName12 VARCHAR 40TrueTrueTrueFalse%s
AdditionalContactRef1ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
AdditionalContactRef2ContactName12 VARCHAR 40TrueTrueTrueFalse%s
AdditionalContactRef2ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
AdditionalContactRef3ContactName12 VARCHAR 40TrueTrueTrueFalse%s
AdditionalContactRef3ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
AdditionalContactRef4ContactName12 VARCHAR 40TrueTrueTrueFalse%s
AdditionalContactRef4ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
AdditionalContactRef5ContactName12 VARCHAR 40TrueTrueTrueFalse%s
AdditionalContactRef5ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
AdditionalContactRef6ContactName12 VARCHAR 40TrueTrueTrueFalse%s
AdditionalContactRef6ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
AdditionalContactRef7ContactName12 VARCHAR 40TrueTrueTrueFalse%s
AdditionalContactRef7ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
AdditionalContactRef8ContactName12 VARCHAR 40TrueTrueTrueFalse%s
AdditionalContactRef8ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
EmergencyContactsPrimaryContactName12 VARCHAR 41TrueTrueTrueFalse%s
EmergencyContactsPrimaryContactValue12 VARCHAR 255TrueTrueTrueFalse%s
EmergencyContactsPrimaryContactRelation12 VARCHAR 9TrueTrueTrueFalse
Spouse
Partner
Mother
Father
Sister
Brother
Son
Daughter
Friend
Other
EmergencyContactsSecondaryContactName12 VARCHAR 41TrueTrueTrueFalse%s
EmergencyContactsSecondaryContactValue12 VARCHAR 255TrueTrueTrueFalse%s
EmergencyContactsSecondaryContactRelation12 VARCHAR 9TrueTrueTrueFalse
Spouse
Partner
Mother
Father
Sister
Brother
Son
Daughter
Friend
Other
EmployeeType12 VARCHAR 9TrueFalseTrueFalse
Regular
Officer
Statutory
Owner
PartOrFullTime12 VARCHAR 9TrueTrueTrueFalse
PartTime
FullTime
Exempt12 VARCHAR 9TrueTrueTrueFalse
Exempt
NonExempt
KeyEmployee12 VARCHAR 9TrueTrueTrueFalse
Yes
No
Gender12 VARCHAR 6TrueFalseTrueFalse
Female
Male
Sex12 VARCHAR 6TrueFalseTrueFalse
Female
Male
HiredDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
OriginalHireDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
AdjustedServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ReleasedDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
BirthDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
USCitizen12 VARCHAR 9TrueTrueTrueFalse
Yes
No
Ethnicity12 VARCHAR 15TrueTrueTrueFalse
AmericianIndian
Asian
Black
Hawaiian
Hispanic
White
TwoOrMoreRaces
Disabled12 VARCHAR 9TrueTrueTrueFalse
Yes
No
DisabilityDesc12 VARCHAR 25TrueTrueTrueFalse%s
OnFile12 VARCHAR 9TrueTrueTrueFalse
Yes
No
WorkAuthExpireDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
USVeteran12 VARCHAR 9TrueTrueTrueFalse
Yes
No
MilitaryStatus12 VARCHAR 9TrueTrueTrueFalse
Active
Reserve
AccountNumber12 VARCHAR 99TrueTrueTrueFalse%s
Notes12 VARCHAR 4096TrueTrueTrueFalse%s
BillingRateRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
BillingRateRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
PayrollInfoPayPeriod12 VARCHAR 11TrueTrueTrueFalse
Daily
Weekly
Biweekly
Semimonthly
Monthly
Quarterly
Yearly
PayrollInfoClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayrollInfoClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
PayrollInfoUseTimeDataToCreatePaychecks12 VARCHAR 16TrueTrueTrueFalse
NotSet
UseTimeData
DoNotUseTimeData
PayrollInfoSickHoursHoursAvailable8 DOUBLE 8TrueTrueTrueFalsePTnHnMnS
PayrollInfoSickHoursAccrualPeriod12 VARCHAR 19TrueTrueTrueFalse
BeginningOfYear
EveryPaycheck
EveryHourOnPaycheck
PayrollInfoSickHoursHoursAccrued8 DOUBLE 8TrueTrueTrueFalsePTnHnMnS
PayrollInfoSickHoursMaximumHours8 DOUBLE 8TrueTrueTrueFalsePTnHnMnS
PayrollInfoSickHoursIsResettingHoursEachNewYear-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PayrollInfoSickHoursHoursUsed8 DOUBLE 8TrueTrueTrueFalsePTnHnMnS
PayrollInfoSickHoursAccrualStartDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
PayrollInfoVacationHoursHoursAvailable8 DOUBLE 8TrueTrueTrueFalsePTnHnMnS
PayrollInfoVacationHoursAccrualPeriod12 VARCHAR 19TrueTrueTrueFalse
BeginningOfYear
EveryPaycheck
EveryHourOnPaycheck
PayrollInfoVacationHoursHoursAccrued8 DOUBLE 8TrueTrueTrueFalsePTnHnMnS
PayrollInfoVacationHoursMaximumHours8 DOUBLE 8TrueTrueTrueFalsePTnHnMnS
PayrollInfoVacationHoursIsResetHoursEachNewYear-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PayrollInfoVacationHoursHoursUsed8 DOUBLE 8TrueTrueTrueFalsePTnHnMnS
PayrollInfoVacationHoursAccrualStartDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ExternalGUID12 VARCHAR 40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}