FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
ListIDtruefalsetruefalsefalse
TimeCreatedtruefalsetruefalsefalse
TimeModifiedtruefalsetruefalsefalse
EditSequencetruefalsetruefalsefalse
Nametruefalsetruefalsefalse
IsActivetruetrueoptionaltrueoptional
Salutationtruetrueoptionaltrueoptional
FirstNametruetrueoptionaltrueoptional
MiddleNametruetrueoptionaltrueoptional
LastNametruetrueoptionaltrueoptional
Suffixtruefalseoptionalfalseoptional
JobTitletruetrueoptionaltrueoptional
SupervisorRef_ListIDtruetrueoptionaltrueoptional
SupervisorRef_FullNametruetrueoptionaltrueoptional
TargetBonustruetrueoptionaltrueoptional
Departmenttruetrueoptionaltrueoptional
Descriptiontruetrueoptionaltrueoptional
EmployeeAddress_Addr1truetrueoptionaltrueoptional
EmployeeAddress_Addr2truetrueoptionaltrueoptional
EmployeeAddress_Citytruetrueoptionaltrueoptional
EmployeeAddress_Statetruetrueoptionaltrueoptional
EmployeeAddress_PostalCodetruetrueoptionaltrueoptional
EmployeeAddress_Countrytruetrueoptionaltrueoptional
PrintAstruetrueoptionaltrueoptional
Phonetruetrueoptionaltrueoptional
Mobiletruetrueoptionaltrueoptional
Pagertruetrueoptionaltrueoptional
PagerPINtruetrueoptionaltrueoptional
AltPhonetruetrueoptionaltrueoptional
Faxtruetrueoptionaltrueoptional
SSNtruefalseoptionaltrueoptional
Emailtruetrueoptionaltrueoptional
EmergContactPrimaryNametruetrueoptionaltrueoptional
EmergContactPrimaryValuetruetrueoptionaltrueoptional
EmergContactPrimaryRelationtruetrueoptionaltrueoptional
EmergContactSecondaryNametruetrueoptionaltrueoptional
EmergContactSecondaryValuetruetrueoptionaltrueoptional
EmergContactSecondaryRelationtruetrueoptionaltrueoptional
EmployeeTypetruetrueoptionaltrueoptional
Gendertruefalseoptionaltrueoptional
HiredDatetruefalseoptionaltrueoptional
ReleasedDatetruetrueoptionaltrueoptional
BirthDatetruetrueoptionaltrueoptional
AccountNumbertruetrueoptionaltrueoptional
Notestruetrueoptionaltrueoptional
BillingRateRef_ListIDtruetrueoptionaltrueoptional
BillingRateRef_FullNametruetrueoptionaltrueoptional
PartOrFullTimetruetrueoptionaltrueoptional
Exempttruetrueoptionaltrueoptional
KeyEmployeetruetrueoptionaltrueoptional
OriginalHireDatetruetrueoptionaltrueoptional
AdjustedServiceDatetruetrueoptionaltrueoptional
USCitizentruetrueoptionaltrueoptional
Ethnicitytruetrueoptionaltrueoptional
Disabledtruetrueoptionaltrueoptional
DisabilityDesctruetrueoptionaltrueoptional
OnFiletruetrueoptionaltrueoptional
WorkAuthExpireDatetruetrueoptionaltrueoptional
USVeterantruetrueoptionaltrueoptional
MilitaryStatustruetrueoptionaltrueoptional
PayPeriodtruefalseoptionaltrueoptional
ClassRef_ListIDtruetrueoptionaltrueoptional
ClassRef_FullNametruetrueoptionaltrueoptional
ClearEarningstruefalseoptionaltrueoptional
IsUsingTimeDataToCreatePaycheckstruetrueoptionaltrueoptional
UseTimeDataToCreatePaycheckstruetrueoptionaltrueoptional
SH_HoursAvailabletruetrueoptionaltrueoptional
SH_AccrualPeriodtruetrueoptionaltrueoptional
SH_HoursAccruedtruetrueoptionaltrueoptional
SH_MaximumHourstruetrueoptionaltrueoptional
SH_IsResettingHoursEachNewYeartruetrueoptionaltrueoptional
SH_HoursUsedtruetrueoptionaltrueoptional
SH_AccrualStartDatetruetrueoptionaltrueoptional
VH_HoursAvailabletruetrueoptionaltrueoptional
VH_AccrualPeriodtruetrueoptionaltrueoptional
VH_HoursAccruedtruetrueoptionaltrueoptional
VH_MaximumHourstruetrueoptionaltrueoptional
VH_IsResettingHoursEachNewYeartruetrueoptionaltrueoptional
VH_HoursUsedtruetrueoptionaltrueoptional
VH_AccrualStartDatetruetrueoptionaltrueoptional
CustomField1truetrueoptionaltrueoptional
CustomField2truetrueoptionaltrueoptional
CustomField3truetrueoptionaltrueoptional
CustomField4truetrueoptionaltrueoptional
CustomField5truetrueoptionaltrueoptional
CustomField6truetrueoptionaltrueoptional
CustomField7truetrueoptionaltrueoptional
CustomField8truetrueoptionaltrueoptional
CustomField9truetrueoptionaltrueoptional
CustomField10truetrueoptionaltrueoptional
CustomField11truetrueoptionaltrueoptional
CustomField12truetrueoptionaltrueoptional
CustomField13truetrueoptionaltrueoptional
CustomField14truetrueoptionaltrueoptional
CustomField15truetrueoptionaltrueoptional
ExternalGUIDtruetrueoptionaltrueoptional
UserDatauser field
Operationadd,update,delete
  • AdditionalContactRet
  • AdditionalNotesRet
  • EarningsRet

SH -> SickHours VH ->VacationHours

Powered by BetterDocs