Employee Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ListID 12 VARCHAR 36 True False False False %s ListID 1.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 1.0 US, CA, UK
Name 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 1.0 US, CA, UK
Salutation 12 VARCHAR 15 True True True False %s 1.0 US, CA, UK
FirstName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
MiddleName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
LastName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
JobTitle 12 VARCHAR 41 True True True False %s 12.0 US, CA, UK
SupervisorRef_ListID 12 VARCHAR 36 True True True False %s 13.0 US
SupervisorRef_FullName 12 VARCHAR 159 True True True False %s 13.0 US
Department 12 VARCHAR 91 True True True False %s 13.0 US
Description 12 VARCHAR 1023 True True True False %s 13.0 US
TargetBonus 2 NUMERIC 15 True True True False %10.2f 13.0 US
EmployeeAddress_Addr1 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
EmployeeAddress_Addr2 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
EmployeeAddress_City 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
EmployeeAddress_State 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
EmployeeAddress_PostalCode 12 VARCHAR 13 True True True False %s 1.0 US, CA, UK
PrintAs 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
Phone 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
Mobile 12 VARCHAR 21 True True True False %s 2.1 US, CA, UK
Pager 12 VARCHAR 21 True True True False %s 2.1 US, CA, UK
PagerPIN 12 VARCHAR 10 True True True False %s 2.1 US, CA, UK
AltPhone 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
Fax 12 VARCHAR 21 True True True False %s 2.1 US, CA, UK
SSN 12 VARCHAR 11 True False True False %s 2.0 US, CA, UK
SSN 12 VARCHAR 11 True False True False %s 2.0 US, CA, UK
Email 12 VARCHAR 1023 True True True False %s 1.0 US, CA, UK
AdditionalContactRef_ContactName1 12 VARCHAR 40 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactValue1 12 VARCHAR 255 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactName2 12 VARCHAR 40 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactValue2 12 VARCHAR 255 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactName3 12 VARCHAR 40 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactValue4 12 VARCHAR 255 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactName4 12 VARCHAR 40 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactValue4 12 VARCHAR 255 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactName5 12 VARCHAR 40 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactValue5 12 VARCHAR 255 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactName6 12 VARCHAR 40 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactValue6 12 VARCHAR 255 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactName7 12 VARCHAR 40 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactValue7 12 VARCHAR 255 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactName8 12 VARCHAR 40 True True True False %s 12.0 US, CA, UK
AdditionalContactRef_ContactValue8 12 VARCHAR 255 True True True False %s 12.0 US, CA, UK
EmployeeType 12 VARCHAR 9 True False True False
Regular
Officer
Statutory
Owner
 1.0 US, CA, UK
PartOrFullTime 12 VARCHAR 8 True True True False
PartTime
FullTime
 13.0 US
Exempt 12 VARCHAR 9 True True True False
Exempt
NonExempt
 13.0 US
KeyEmployee 12 VARCHAR 3 True True True False
Yes
No
 13.0 US
Gender 12 VARCHAR 6 True False True False
Female
Male
 1.0 US, CA, UK
HiredDate 91 DATE 10 True False True False CCCC-MM-DD 1.0 US, CA, UK
OriginalHireDate 91 DATE 10 True True True False CCCC-MM-DD 13.0 US
AdjustedServiceDate 91 DATE 10 True True True False CCCC-MM-DD 13.0 US
ReleasedDate 91 DATE 10 True False True False CCCC-MM-DD 1.0 US, CA, UK
BirthDate 91 DATE 6 True True True False CCCC-MM-DD 2.0 US
USCitizen 12 VARCHAR 3 True True True False
Yes
No
 13.0 US
Ethnicity 12 VARCHAR 15 True True True False
AmericianIndian
Asian
Black
Hawaiian
Hispanic
White
TwoOrMoreRaces
 13.0 US
Disabled 12 VARCHAR 3 True True True False
Yes
No
 13.0 US, CA, UK
DisabilityDesc 12 VARCHAR 25 True True True False %s 13.0 US
OnFile 12 VARCHAR 3 True True True False
Yes
No
 13.0 US
WorkAuthExpireDate 91 DATE 6 True True True False CCCC-MM-DD 13.0 US
USVeteran 12 VARCHAR 3 True True True False
Yes
No
 13.0 US
MilitaryStatus 12 VARCHAR 7 True True True False
Active
Reserve
 13.0 US
AccountNumber 12 VARCHAR 99 True True True False %s 13.0 US, CA, UK
Notes 12 VARCHAR 4095 True True True False %s 2.1 US, CA, UK
BillingRateRef_ListID 12 VARCHAR 36 True True True False %s ListID 6.0 US, CA, UK
BillingRateRef_FullName 12 VARCHAR 31 True True True False %s FullName 6.0 US, CA, UK
PayrollInfo_PayPeriod 12 VARCHAR 11 True True True False
Daily
Weekly
Biweekly
Semimonthly
Monthly
Quarterly
Yearly
 2.0 US, CA, UK
PayrollInfo_ClassRef_ListID 12 VARCHAR 36 True True True False %s ListID 2.0 US, CA, UK
PayrollInfo_ClassRef_FullName 12 VARCHAR 31 True True True False %s FullName 2.0 US, CA, UK
PayrollInfo_IsUsingTimeDataToCreatePaychecks -7 BIT 2 2.0 US, CA, UK
PayrollInfo_UseTimeDataToCreatePaychecks 12 VARCHAR 16 True True True False
NotSet
UseTimeData
DoNotUseTimeData
 3.0 US, CA, UK
PayrollInfo_SickHours_HoursAvailable 12 VARCHAR 15 True True True False PTnHnMnS 2.0 US, CA, UK
PayrollInfo_SickHours_AccrualPeriod 12 VARCHAR 19 True True True False
BeginningOfYear
EveryPaycheck
EveryHourOnPaycheck
 2.0 US, CA, UK
PayrollInfo_SickHours_HoursAccrued 8 VARCHAR 8 True True True False PTnHnMnS 2.0 US, CA, UK
PayrollInfo_SickHoursMaximumHours 12 VARCHAR 15 True True True False PTnHnMnS 2.0 US, CA, UK
PayrollInfo_SickHours_IsResettingHoursEachNewYear -7 BIT 2 True True True False
1
0
true
false
 2.0 US, CA, UK
PayrollInfo_SickHours_HoursUsed 12 VARCHAR 15 True True True False PTnHnMnS 5.0 US, CA, UK
PayrollInfo_SickHours_AccrualStartDate 91 DATE 10 True True True False CCCC-MM-DD 5.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 True False True False {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} 8.0 US, CA, UK
CFBDay 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK
CFDateoflastraise 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK
CFSpousesName 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK