|
TABLE DETAIL REFERENCE:
|
||
|
(AUSTRALIA/NZ 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 | |
| EmployeeAddressPostalCode | Varchar | 13 | True | True | True | No | String | |
| PrintAs | Varchar | 41 | True | True | True | No | String | |
| Phone | Varchar | 21 | True | True | True | No | String | |
| AltPhone | Varchar | 21 | True | True | True | No | String | |
| NiNumber | Varchar | 15 | True | False | True | No | String | |
| MaritalStatus | Varchar | 6 | True | False | True | No | Single Married | |
| Varchar | 1023 | True | True | True | No | String | ||
| EmployeeType | Varchar | 9 | True | False | True | No | Regular Officer Statutory Owner | |
| Sex | 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 | |
| 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 | |
| PayrollInfoVacationHoursVacationPayAvailable | Decimal | 11 | True | True | True | No | 8.2 | |
| PayrollInfoVacationHoursVacationPayUsed | Decimal | 11 | True | True | True | No | 8.2 | |
| PayrollInfoVacationHoursRetainOrPayEveryPeriod | Varchar | 19 | True | True | True | No | Retain PayEveryPeriod | |
| PayrollInfoVacationHoursVacationPercentage | Decimal | 13 | True | True | True | No | 7.5 | |
| PayrollInfoVacationHoursPayrollItemVacationRefListID | Varchar | 36 | True | False | True | No | String | |
| PayrollInfoVacationHoursPayrollItemVacationRefFullName | Varchar | 31 | True | True | True | No | String |
