Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
PayrollYear | smallint | 2 | null |
|
|
|||
EmployeeID | int | 4 | null |
|
|
|||
EmployeeSurname | varchar | 30 | null |
|
|
|||
EmployeeGiven1 | varchar | 20 | null |
|
|
|||
EmployeeGiven2 | varchar | 50 | null |
|
|
|||
EmployeeGivenNames | varchar | 71 | √ | null |
|
|
||
EmployeeTitle | varchar | 30 | null |
|
|
|||
EmployeeSuffix | varchar | 20 | null |
|
|
|||
EmployeeGender | varchar | 15 | null |
|
|
|||
EmployeeGenderATOSexCode | varchar | 1 | null |
|
|
|||
EmployeeBirthDate | datetime | 16,3 | √ | null |
|
|
||
EmployeeEmailCommunityDefault | varchar | 201 | null |
|
|
|||
EmployeeEmailPayrollDefault | varchar | 201 | √ | null |
|
|
||
EmployeeATOAddressType | varchar | 3 | null |
|
|
|||
EmployeeHomeAddress1 | varchar | 40 | √ | null |
|
|
||
EmployeeHomeAddress2 | varchar | 40 | √ | null |
|
|
||
EmployeeHomeAddress3 | varchar | 40 | √ | null |
|
|
||
EmployeeHomeAddressCountry | varchar | 40 | √ | null |
|
|
||
EmployeeHomeAddressPostcode | varchar | 5 | √ | null |
|
|
||
EmployeeHomeAddressState | varchar | 30 | √ | null |
|
|
||
EmployeeHomeAddressStateShort | varchar | 5 | √ | null |
|
|
||
EmployeeHomeAddressSuburb | varchar | 40 | √ | null |
|
|
||
EmployeeATOPostalAddressType | varchar | 3 | null |
|
|
|||
EmployeePostalAddress1 | varchar | 40 | √ | null |
|
|
||
EmployeePostalAddress2 | varchar | 40 | √ | null |
|
|
||
EmployeePostalAddress3 | varchar | 40 | √ | null |
|
|
||
EmployeePostalAddressCountry | varchar | 40 | √ | null |
|
|
||
EmployeePostalAddressPostcode | varchar | 5 | √ | null |
|
|
||
EmployeePostalAddressState | varchar | 30 | √ | null |
|
|
||
EmployeePostalAddressStateShort | varchar | 5 | √ | null |
|
|
||
EmployeePostalAddressSuburb | varchar | 40 | √ | null |
|
|
||
EmployeeMemberJoinedDate | datetime | 16,3 | √ | null |
|
|
||
EmployeeMemberNumber | varchar | 20 | √ | null |
|
|
||
EmployeeMobilePhoneDefault | varchar | 15 | null |
|
|
|||
EmployeeMobilePhoneDefaultAreaCode | varchar | 20 | √ | null |
|
|
||
EmployeeMobilePhoneDefaultNoAreaCode | varchar | 20 | √ | null |
|
|
||
EmployeeMobilePhoneDefaultATOTypeCode | varchar | 1 | null |
|
|
|||
EmployeeOccupationDescription | varchar | 50 | null |
|
|
|||
EmployeePhone | varchar | 15 | √ | null |
|
|
||
EmployeePhoneAreaCode | varchar | 20 | √ | null |
|
|
||
EmployeePhoneNoAreaCode | varchar | 20 | √ | null |
|
|
||
EmployeePhoneATOTypeCode | varchar | 1 | null |
|
|
|||
EmployeePhoneDefault | varchar | 15 | √ | null |
|
|
||
EmployeePhoneDefaultAreaCode | varchar | 20 | √ | null |
|
|
||
EmployeePhoneDefaultNoAreaCode | varchar | 20 | √ | null |
|
|
||
EmployeePhoneDefaultATOTypeCode | varchar | 1 | null |
|
|
|||
EmployeeSalaryEffectiveFromDate | datetime | 16,3 | √ | null |
|
|
||
EmployeeStartDate | datetime | 16,3 | √ | null |
|
|
||
EmployeeJobPositionDescription | varchar | 80 | √ | null |
|
|
||
EmployeeAnnualSalary | money | 21,4 | √ | null |
|
|
||
EmployeeEmploymentStatusCode | varchar | 1 | √ | null |
|
|
||
EmployeeEmploymentStatus | varchar | 50 | √ | null |
|
|
||
EmployeeEmploymentStatusSuperExportValue | varchar | 15 | √ | null |
|
|
||
EmployeeTaxFileNumber | int | 4 | √ | null |
|
|
||
EmployeeTaxFileNumberATONotProvidedIndicator | varchar | 1 | null |
|
|
|||
EmployeeTerminationDate | datetime | 16,3 | √ | null |
|
|
||
EmployeeTerminationReasonCode | varchar | 15 | √ | null |
|
|
||
EmployeeTerminationReason | varchar | 50 | √ | null |
|
|
||
EntityABN | varchar | 11 | null |
|
|
|||
EntityName | varchar | 60 | null |
|
|
|||
FundCode | varchar | 15 | √ | null |
|
|
||
FundName | varchar | 100 | √ | null |
|
|
||
FundABN | varchar | 20 | √ | null |
|
|
||
FundEmployerNumber | varchar | 30 | √ | null |
|
|
||
FundNickname | varchar | 15 | √ | null |
|
|
||
FundESA | varchar | 100 | √ | null |
|
|
||
FundSPIN | varchar | 20 | √ | null |
|
|
||
FundUSI | varchar | 20 | √ | null |
|
|
||
FundIdentifier | varchar | 20 | √ | null |
|
|
||
FundBankBSB | varchar | 8 | √ | null |
|
|
||
FundBankAccount | varchar | 15 | √ | null |
|
|
||
FundBPAYBillerCode | varchar | 30 | √ | null |
|
|
||
FundBPAYCRN | varchar | 30 | √ | null |
|
|
||
tPayrollEmployeeSuperannuationFundSeq | int | 4 | √ | null |
|
|
Table contained 0 rows