Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | √ | null |
|
|
||
| Category | varchar | 5 | √ | null |
|
|
||
| EmploymentStatus | varchar | 1 | √ | null |
|
|
||
| EmploymentStatusDescription | varchar | 50 | √ | null |
|
|
||
| EmploymentStatusContractFlag | smallint | 2 | √ | null |
|
|
||
| EmploymentStatusSynergyMeaning | varchar | 10 | √ | null |
|
|
||
| NameInternal | varchar | 100 | √ | null |
|
|
||
| NameExternal | varchar | 100 | √ | null |
|
|
||
| LegalFullName | varchar | 150 | √ | null |
|
|
||
| Surname | varchar | 30 | √ | null |
|
|
||
| Preferred | varchar | 20 | √ | null |
|
|
||
| PreferredFormal | varchar | 20 | √ | null |
|
|
||
| Given1 | varchar | 20 | √ | null |
|
|
||
| Given2 | varchar | 50 | √ | null |
|
|
||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||
| MailNamePrimary | varchar | 100 | √ | null |
|
|
||
| AddressComma | varchar | 200 | √ | null |
|
|
||
| AddressFull | varchar | 200 | √ | null |
|
|
||
| AddressDPID | varchar | 8 | √ | null |
|
|
||
| AddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| AddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| AddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| HomeAddressComma | varchar | 200 | √ | null |
|
|
||
| HomeAddressFull | varchar | 200 | √ | null |
|
|
||
| HomeAddressDPID | varchar | 8 | √ | null |
|
|
||
| HomeAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| HomeAddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| HomeAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| Phone | varchar | 15 | √ | null |
|
|
||
| Fax | varchar | 15 | √ | null |
|
|
||
| MobilePhone | varchar | 15 | √ | null |
|
|
||
| DefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| ValidAddressFlag | smallint | 2 | √ | null |
|
|
||
| ReceivesMailFlag | smallint | 2 | √ | null |
|
|
||
| SuperPaymentFrequency | varchar | 15 | null |
|
|
|||
| SuperReportCode | varchar | 30 | null |
|
|
|||
| SuperReportDescription | varchar | 40 | null |
|
|
|||
| PayCode | varchar | 10 | √ | null |
|
|
||
| PayCodeDescription | varchar | 50 | √ | null |
|
|
||
| PayCodeShortDescription | varchar | 15 | √ | null |
|
|
||
| PayCodeType | varchar | 3 | √ | null |
|
|
||
| GroupCertificateSection | varchar | 5 | √ | null |
|
|
||
| PayrollYear | smallint | 2 | √ | null |
|
|
||
| PostingNumber | int | 4 | √ | null |
|
|
||
| PostingDate | datetime | 16,3 | √ | null |
|
|
||
| SuperMemberNumber | varchar | 20 | null |
|
|
|||
| PayFactor | decimal | 12,8 | √ | null |
|
|
||
| PayAmount | money | 21,4 | √ | null |
|
|
||
| SuperContributionTax | money | 21,4 | √ | null |
|
|
||
| ReferenceSuperBase | money | 21,4 | √ | null |
|
|
||
| SuperFundCode | varchar | 15 | √ | null |
|
|
||
| SuperFundDescription | varchar | 100 | √ | null |
|
|
||
| StandardPayCodeDescription | varchar | 50 | √ | null |
|
|
Table contained 0 rows