EmployeeEarning Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
ID12VARCHAR115
ListID12VARCHAR36TrueFalseFalseFalse%sListID1.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s1.0US, CA, UK
Name12VARCHAR41TrueFalseFalseFalse%s1.0US, CA, UK
IsActive-7BIT2TrueTrueTrueFalse
1
0
true
false
1.0US, CA, UK
Salutation12VARCHAR15TrueTrueTrueFalse%s1.0US, CA, UK
FirstName12VARCHAR25TrueTrueTrueFalse%s1.0US, CA, UK
MiddleName12VARCHAR25TrueTrueTrueFalse%s1.0US, CA, UK
LastName12VARCHAR25TrueTrueTrueFalse%s12.0US, CA, UK
JobTitle12VARCHAR41TrueTrueTrueFalse%s13.0US, CA, UK
SupervisorRef_ListID12VARCHAR36TrueTrueTrueFalse%s1.0US, CA, UK
SupervisorRef_FullName12VARCHAR209TrueTrueTrueFalse%s1.0US, CA, UK
Department12VARCHAR91TrueTrueTrueFalse%s13.0US, CA, UK
Description12VARCHAR1023TrueTrueTrueFalse%s13.0US, CA, UK
TargetBonus2NUMERIC15TrueTrueTrueFalse%10.2f13.0US, CA, UK
EmployeeAddress_Addr112VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
EmployeeAddress_Addr212VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
EmployeeAddress_City12VARCHAR31TrueTrueTrueFalse%s1.0US, CA, UK
EmployeeAddress_State12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
EmployeeAddress_PostalCode12VARCHAR13TrueTrueTrueFalse%s1.0US, CA, UK
PrintAs12VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
Phone12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
Mobile12VARCHAR21TrueTrueTrueFalse%s2.1US, CA, UK
Pager12VARCHAR21TrueTrueTrueFalse%s2.1US, CA, UK
PagerPIN12VARCHAR10TrueTrueTrueFalse%s1.1US, CA, UK
AltPhone12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
Fax12VARCHAR21TrueTrueTrueFalse%s2.1US, CA, UK
SSN12VARCHAR11TrueFalseTrueFalse%s2.0US, CA, UK
Email12VARCHAR1023TrueTrueTrueFalse%s1.0US, CA, UK
AdditionalContactRef_ContactName112VARCHAR40TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactValue112VARCHAR255TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactName212VARCHAR40TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactValue212VARCHAR255TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactName312VARCHAR40TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactValue412VARCHAR255TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactName412VARCHAR40TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactValue412VARCHAR255TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactName512VARCHAR40TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactValue512VARCHAR255TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactName612VARCHAR40TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactValue612VARCHAR255TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactName712VARCHAR40TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactValue712VARCHAR255TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactName812VARCHAR40TrueTrueTrueFalse%s12.0US, CA, UK
AdditionalContactRef_ContactValue812VARCHAR255TrueTrueTrueFalse%s12.0US, CA, UK
EmergencyContacts_PrimaryContact_ContactName12VARCHAR401.0US, CA, UK
EmergencyContacts_PrimaryContact_ContactValue12VARCHAR2551.0US, CA, UK
EmergencyContacts_PrimaryContact_Relation12VARCHAR81.0US, CA, UK
EmergencyContacts_SecondaryContact_ContactName12VARCHAR401.0US, CA, UK
EmergencyContacts_SecondaryContact_ContactValue12VARCHAR2551.0US, CA, UK
EmergencyContacts_SecondaryContact_Relation12VARCHAR81.0US, CA, UK
EmployeeType12VARCHAR9TrueFalseTrueFalse
Regular
Officer
Statutory
Owner
1.0US, CA, UK
PartOrFullTime12VARCHAR8TrueTrueTrueFalse
PartTime
FullTime
13.0US
Exempt12VARCHAR9TrueTrueTrueFalse
Exempt
NonExempt
13.0US
KeyEmployee12VARCHAR3TrueTrueTrueFalse
Yes
No
13.0US
Gender12VARCHAR6TrueFalseTrueFalse
Female
Male
1.0US, CA, UK
HiredDate91DATE10TrueFalseTrueFalseCCCC-MM-DD1.0US, CA, UK
OriginalHireDate91DATE10TrueTrueTrueFalseCCCC-MM-DD13.0US
AdjustedServiceDate91DATE10TrueTrueTrueFalseCCCC-MM-DD13.0US
ReleasedDate91DATE10TrueFalseTrueFalseCCCC-MM-DD1.0US, CA, UK
BirthDate91DATE6TrueTrueTrueFalseCCCC-MM-DD2.0US
USCitizen12VARCHAR3TrueTrueTrueFalse
Yes
No
13.0US
Ethnicity12VARCHAR15TrueTrueTrueFalse
AmericianIndian
Asian
Black
Hawaiian
Hispanic
White
TwoOrMoreRaces
13.0US
Disabled12VARCHAR3TrueTrueTrueFalse
Yes
No
13.0US, CA, UK
DisabilityDesc12VARCHAR25TrueTrueTrueFalse%s13.0US
OnFile12VARCHAR3TrueTrueTrueFalse
Yes
No
13.0US
WorkAuthExpireDate91DATE10TrueTrueTrueFalseCCCC-MM-DD13.0US
USVeteran12VARCHAR3TrueTrueTrueFalse
Yes
No
13.0US
MilitaryStatus12VARCHAR7TrueTrueTrueFalse
Active
Reserve
13.0US
AccountNumber12VARCHAR99TrueTrueTrueFalse%s13.0US, CA, UK
Notes12VARCHAR4095TrueTrueTrueFalse%s2.1US, CA, UK
BillingRateRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID6.0US, CA, UK
BillingRateRef_FullName12VARCHAR31TrueTrueTrueFalse%sFullName6.0US, CA, UK
PayrollInfo_PayPeriod12VARCHAR11TrueTrueTrueFalse
Daily
Weekly
Biweekly
Semimonthly
Monthly
Quarterly
Yearly
2.0US, CA, UK
PayrollInfo_ClassRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID2.0US, CA, UK
PayrollInfo_ClassRef_FullName12VARCHAR159TrueTrueTrueFalse%sFullName2.0US, CA, UK
PayrollInfo_ClearEarnings-7BIT2TrueTrueTrueFalse1
0
true
false
2.0US, CA, UK
PayrollInfo_Earnings_SeqNo4INTEGER9TrueFalseFalseFalseSubSeqNo2.0US, CA, UK
PayrollInfo_Earnings_PayrollItemWageRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID2.0US, CA, UK
PayrollInfo_Earnings_PayrollItemWageRef_FullName12VARCHAR36TrueTrueTrueFalse%sName2.0US, CA, UK
PayrollInfo_Earnings_Rate2NUMERIC18TrueTrueTrueFalse%10.5f2.0US, CA, UK
PayrollInfo_Earnings_RatePercent2NUMERIC18TrueTrueTrueFalse%10.5f2.0US, CA, UK
PayrollInfo_UseTimeDataToCreatePaychecks12VARCHAR16TrueTrueTrueFalse
NotSet
UseTimeData
DoNotUseTimeData
3.0US, CA, UK
PayrollInfo_SickHours_HoursAvailable12VARCHAR15TrueTrueTrueFalsePTnHnMnS2.0US, CA, UK
PayrollInfo_SickHours_AccrualPeriod12VARCHAR19TrueTrueTrueFalse
BeginningOfYear
EveryPaycheck
EveryHourOnPaycheck
2.0US, CA, UK
PayrollInfo_SickHours_HoursAccrued8VARCHAR8TrueTrueTrueFalsePTnHnMnS2.0US, CA, UK
PayrollInfo_SickHoursMaximumHours12VARCHAR15TrueTrueTrueFalsePTnHnMnS2.0US, CA, UK
PayrollInfo_SickHours_IsResettingHoursEachNewYear-7BIT2TrueTrueTrueFalse
1
0
true
false
2.0US, CA, UK
PayrollInfo_SickHours_HoursUsed12VARCHAR15TrueTrueTrueFalsePTnHnMnS5.0US, CA, UK
PayrollInfo_SickHours_AccrualStartDate91DATE10TrueTrueTrueFalseCCCC-MM-DD5.0US, CA, UK
PayrollInfo_VacationHours_HoursAvailable12VARCHAR151.0US, CA, UK
PayrollInfo_VacationHours_AccrualPeriod12VARCHAR191.0US, CA, UK
PayrollInfo_VacationHours_HoursAccrued12VARCHAR15TrueTrueTrueFalsePTnHnMnS1.0US, CA, UK
PayrollInfo_VacationHours_MaximumHours12VARCHAR15TrueTrueTrueFalsePTnHnMnS1.0US, CA, UK
PayrollInfo_VacationHours_IsResettingHoursEachNewYear-7BIT2TrueTrueTrueFalse1.0US, CA, UK
PayrollInfo_VacationHours_HoursUsed12VARCHAR15TrueTrueTrueFalsePTnHnMnS1.0US, CA, UK
PayrollInfo_VacationHours_AccrualStartDate91DATE10TrueTrueTrueFalseCCCC-MM-DD1.0US, CA, UK
ExternalGUID12VARCHAR40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}8.0US, CA, UK
RQUseCachedID-7BIT2
CFBDay12VARCHAR255TrueTrueTrueFalse%s1.0US, CA, UK
CFDateoflastraise12VARCHAR255TrueTrueTrueFalse%s1.0US, CA, UK
CFSpousesName12VARCHAR255TrueTrueTrueFalse%s1.0US, CA, UK