TABLE DETAIL REFERENCE: Employee
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
| Name | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| IsActive | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
| FirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| MiddleName | 12 | VARCHAR | 5 | True | True | True | False | %s | |
| LastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| JobTitle | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| EmployeeAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| PrintAs | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| Phone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Mobile | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Pager | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| PagerPIN | 12 | VARCHAR | 10 | True | True | True | False | %s | |
| AltPhone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Fax | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| SSN | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| SIN | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| NiNumber | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| MaritalStatus | 12 | VARCHAR | 6 | True | False | False | False | Single Married | |
| 12 | VARCHAR | 1023 | True | True | True | False | %s | ||
| EmployeeType | 12 | VARCHAR | 9 | True | False | True | False | Regular Officer Statutory Owner | |
| Gender | 12 | VARCHAR | 6 | True | False | True | False | Female Male | |
| Sex | 12 | VARCHAR | 6 | True | False | True | False | Female Male | |
| HiredDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| ReleasedDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| BirthDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| AccountNumber | 12 | VARCHAR | 99 | True | True | True | False | %s | |
| Notes | 12 | VARCHAR | 4096 | True | True | True | False | %s | |
| BillingRateRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| BillingRateRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| PayrollInfoPayPeriod | 12 | VARCHAR | 11 | True | True | True | False | Daily Weekly Biweekly Semimonthly Monthly Quarterly Yearly | |
| PayrollInfoClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PayrollInfoClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| PayrollInfoUseTimeDataToCreatePaychecks | 12 | VARCHAR | 16 | True | True | True | False | NotSet UseTimeData DoNotUseTimeData | |
| PayrollInfoSickHoursHoursAvailable | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursAccrualPeriod | 12 | VARCHAR | 19 | True | True | True | False | BeginningOfYear EveryPaycheck EveryHourOnPaycheck | |
| PayrollInfoSickHoursHoursAccrued | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursMaximumHours | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursIsResettingHoursEachNewYear | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PayrollInfoSickHoursHoursUsed | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursAccrualStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| PayrollInfoVacationHoursHoursAvailable | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursAccrualPeriod | 12 | VARCHAR | 19 | True | True | True | False | BeginningOfYear EveryPaycheck EveryHourOnPaycheck | |
| PayrollInfoVacationHoursHoursAccrued | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursMaximumHours | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursIsResetHoursEachNewYear | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PayrollInfoVacationHoursHoursUsed | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursAccrualStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD |