|
TABLE DETAIL REFERENCE:
|
||
|
(US VERSION)
|
||
| FIELD NAME | TYPE | LENGTH | QRY | MOD | INS | REQ INS | VALIDATE | REL |
|---|---|---|---|---|---|---|---|---|
| ListID | Varchar | 36 | True | False | False | N/A | String | |
| TimeCreated | Timestamp | 27 | True | False | False | N/A | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | Timestamp | 27 | True | False | False | N/A | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | Varchar | 16 | True | False | False | N/A | String | |
| Name | Varchar | 41 | True | False | False | N/A | String | |
| IsActive | Bit | 5 | True | True | True | No | 1 0 true false | |
| Salutation | Varchar | 15 | True | True | True | No | String | |
| FirstName | Varchar | 25 | True | True | True | No | String | |
| MiddleName | Varchar | 5 | True | True | True | No | String | |
| LastName | Varchar | 25 | True | True | True | No | String | |
| EmployeeAddressAddr1 | Varchar | 41 | True | True | True | No | String | |
| EmployeeAddressAddr2 | Varchar | 41 | True | True | True | No | String | |
| EmployeeAddressCity | Varchar | 31 | True | True | True | No | String | |
| EmployeeAddressState | Varchar | 21 | True | True | True | No | String | |
| EmployeeAddressPostalCode | Varchar | 13 | True | True | True | No | String | |
| PrintAs | Varchar | 41 | True | True | True | No | String | |
| Phone | Varchar | 21 | True | True | True | No | String | |
| Mobile | Varchar | 21 | True | True | True | No | String | |
| Pager | Varchar | 21 | True | True | True | No | String | |
| PagerPIN | Varchar | 10 | True | True | True | No | String | |
| AltPhone | Varchar | 21 | True | True | True | No | String | |
| Fax | Varchar | 21 | True | True | True | No | String | |
| SSN | Varchar | 15 | True | False | True | No | String | |
| Varchar | 1023 | True | True | True | No | String | ||
| EmployeeType | Varchar | 9 | True | False | True | No | Regular Officer Statutory Owner | |
| Gender | Varchar | 6 | True | False | True | No | Female Male | |
| HiredDate | Date | 10 | True | False | True | No | CCCC-MM-DD | |
| ReleasedDate | Date | 10 | True | False | True | No | CCCC-MM-DD | |
| BirthDate | Date | 10 | True | True | True | No | CCCC-MM-DD | |
| AccountNumber | Varchar | 99 | True | True | True | No | String | |
| Notes | Varchar | 4096 | True | True | True | No | String | |
| BillingRateRefListID | Varchar | 36 | True | False | True | No | String | |
| BillingRateRefFullName | Varchar | 31 | True | True | True | No | String | |
| PayrollInfoPayPeriod | Varchar | 11 | True | True | True | No | Daily Weekly Biweekly Semimonthly Monthly Quarterly Yearly | |
| PayrollInfoClassRefListID | Varchar | 36 | True | False | True | No | String | |
| PayrollInfoClassRefFullName | Varchar | 159 | True | True | True | No | String | |
| PayrollInfoEarningsClearEarnings | Bit | 5 | True | True | True | No | 1 0 true false | |
| PayrollInfoUseTimeDataToCreatePaychecks | Varchar | 16 | True | True | True | No | NotSet UseTimeData DoNotUseTimeData | |
| PayrollInfoSickHoursHoursAvailable | Double | 15 | True | True | True | No | PTnHnMnS | |
| PayrollInfoSickHoursAccrualPeriod | Varchar | 19 | True | True | True | No | BeginningOfYear EveryPaycheck EveryHourOnPaycheck | |
| PayrollInfoSickHoursHoursAccrued | Double | 15 | True | True | True | No | PTnHnMnS | |
| PayrollInfoSickHoursMaximumHours | Double | 15 | True | True | True | No | PTnHnMnS | |
| PayrollInfoSickHoursIsResettingHoursEachNewYear | Bit | 5 | True | True | True | No | 1 0 true false | |
| PayrollInfoSickHoursHoursUsed | Double | 15 | True | True | True | No | PTnHnMnS | |
| PayrollInfoSickHoursAccrualStartDate | Date | 10 | True | True | True | No | CCCC-MM-DD | |
| PayrollInfoVacationHoursHoursAvailable | Double | 15 | True | True | True | No | PTnHnMnS | |
| PayrollInfoVacationHoursAccrualPeriod | Varchar | 19 | True | True | True | No | BeginningOfYear EveryPaycheck EveryHourOnPaycheck | |
| PayrollInfoVacationHoursHoursAccrued | Double | 15 | True | True | True | No | PTnHnMnS | |
| PayrollInfoVacationHoursMaximumHours | Double | 15 | True | True | True | No | PTnHnMnS | |
| PayrollInfoVacationHoursIsResetHoursEachNewYear | Bit | 5 | True | True | True | No | 1 0 true false | |
| PayrollInfoVacationHoursHoursUsed | Double | 15 | True | True | True | No | PTnHnMnS | |
| PayrollInfoVacationHoursAccrualStartDate | Date | 10 | True | True | True | No | CCCC-MM-DD |
