Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | 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 |
|
|
||
| ReceivesMagazineFlag | smallint | 2 | √ | null |
|
|
||
| ReceivesSolicitationFlag | smallint | 2 | √ | null |
|
|
||
| ReceivesRaffleFlag | smallint | 2 | √ | null |
|
|
||
| EmploymentCategory | varchar | 5 | √ | null |
|
|
||
| EmploymentStatus | varchar | 1 | √ | null |
|
|
||
| EmploymentStatusDescription | varchar | 50 | √ | null |
|
|
||
| EmploymentStatusContractFlag | smallint | 2 | √ | null |
|
|
||
| EmploymentStatusSynergyMeaning | varchar | 10 | √ | null |
|
|
||
| StartDate | datetime | 16,3 | √ | null |
|
|
||
| TerminatedFlag | smallint | 2 | √ | null |
|
|
||
| TerminationDate | datetime | 16,3 | √ | null |
|
|
||
| PayrollYear | smallint | 2 | null |
|
|
|||
| PayGroup | varchar | 5 | √ | null |
|
|
||
| PayGroupDescription | varchar | 40 | √ | null |
|
|
||
| PayFrequencyCode | varchar | 5 | √ | null |
|
|
||
| PayFrequencyDescription | varchar | 20 | √ | null |
|
|
||
| TaxScaleCode | varchar | 3 | √ | null |
|
|
||
| TaxScaleDescription | varchar | 50 | √ | null |
|
|
||
| YTDTotalTaxation | money | 21,4 | null |
|
|
|||
| YTDNettPay | money | 21,4 | null |
|
|
|||
| YTDGrossPay | money | 21,4 | null |
|
|
|||
| YTDHECS | money | 21,4 | null |
|
|
|||
| YTDHELP | money | 21,4 | null |
|
|
|||
| YTDSuperContributionTax | money | 21,4 | null |
|
|
|||
| TaxFileNumber | int | 4 | √ | null |
|
|
||
| TaxDependantRebate | money | 21,4 | √ | null |
|
|
||
| TaxHECSFlag | smallint | 2 | √ | null |
|
|
||
| TaxHELPFlag | smallint | 2 | √ | null |
|
|
||
| FringeBenefitsTax | money | 21,4 | √ | null |
|
|
||
| ReferenceSuperBase | money | 21,4 | √ | null |
|
|
||
| AnnualAllowance | money | 21,4 | √ | null |
|
|
||
| AnnualSalary | money | 21,4 | √ | null |
|
|
||
| CalculateAnnualSalaryFlag | smallint | 2 | √ | null |
|
|
||
| AnnualBudget | money | 21,4 | √ | null |
|
|
||
| Comment | varchar | 4000 | √ | null |
|
|
||
| PreviousNettPay | money | 21,4 | null |
|
|
|||
| GroupCertPrintedFlag | smallint | 2 | √ | null |
|
|
||
| GroupCertATONotifiedFlag | smallint | 2 | √ | null |
|
|
||
| GroupCertPrintedDate | datetime | 16,3 | √ | null |
|
|
||
| GroupCertATONotifiedDate | datetime | 16,3 | √ | null |
|
|
||
| EmergencyName | varchar | 80 | √ | null |
|
|
||
| EmergencyPhone | varchar | 15 | √ | null |
|
|
||
| Gender | varchar | 15 | √ | null |
|
|
Table contained 0 rows