Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| tPayrollEmployeeDeclarationSeq | int | 4 | √ | null |
|
|
||
| ID | int | 4 | null |
|
|
|||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
||
| CreatedByID | int | 4 | √ | null |
|
|
||
| CreatedBy | varchar | 100 | √ | null |
|
|
||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| ModifiedByID | int | 4 | √ | null |
|
|
||
| ModifiedBy | varchar | 100 | √ | null |
|
|
||
| DeclarationDate | datetime | 16,3 | √ | null |
|
|
||
| DeclarationType | varchar | 15 | null |
|
|
|||
| DeclarationCountryCode | varchar | 5 | √ | null |
|
|
||
| TFNStatus | varchar | 15 | √ | null |
|
|
||
| TaxFileNumber | int | 4 | √ | null |
|
|
||
| PaymentBasis | varchar | 15 | √ | null |
|
|
||
| ResidentialStatus | varchar | 15 | √ | null |
|
|
||
| WorkEntitlement | varchar | 15 | √ | null |
|
|
||
| TaxScale | varchar | 3 | √ | null |
|
|
||
| TaxScaleTaxOfficeCode | varchar | 10 | √ | null |
|
|
||
| EmploymentStatus | varchar | 1 | √ | null |
|
|
||
| TaxFreeThresholdClaimedFlag | bit | 1 | √ | null |
|
|
||
| HELPFlag | bit | 1 | √ | null |
|
|
||
| FinancialSupplementDebtFlag | bit | 1 | √ | null |
|
|
||
| TaxOffsetAmount | money | 21,4 | √ | null |
|
|
||
| SeniorTaxOffsetClaim | varchar | 15 | √ | null |
|
|
||
| SignedByEmployeeFlag | bit | 1 | √ | null |
|
|
||
| SignedBy | varchar | 100 | √ | null |
|
|
||
| GovernmentSendStatus | varchar | 15 | √ | null |
|
|
||
| PayrollGovtSubmissionSeq | int | 4 | √ | null |
|
|
||
| KiwiSaverStatus | varchar | 15 | √ | null |
|
|
||
| KiwiSaverStatusDescription | varchar | 50 | √ | null |
|
|
||
| KiwiSaverStatusIRDCode | varchar | 15 | √ | null |
|
|
||
| SLCIRFlag | bit | 1 | √ | null |
|
|
||
| SLBORFlag | bit | 1 | √ | null |
|
|
||
| Name | varchar | 50 | √ | null |
|
|
||
| Surname | varchar | 30 | √ | null |
|
|
||
| Given1 | varchar | 20 | √ | null |
|
|
||
| Given2 | varchar | 50 | √ | null |
|
|
||
| Title | varchar | 30 | √ | null |
|
|
||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||
| varchar | 100 | √ | null |
|
|
|||
| Phone | varchar | 15 | √ | null |
|
|
||
| PhoneCountryCode | varchar | 15 | √ | null |
|
|
||
| PhoneCountryAlpha3Code | varchar | 3 | √ | null |
|
|
||
| PhoneAreaCode | varchar | 15 | √ | null |
|
|
||
| PhoneExtension | varchar | 15 | √ | null |
|
|
||
| MobilePhone | varchar | 15 | √ | null |
|
|
||
| MobilePhoneCountryCode | varchar | 15 | √ | null |
|
|
||
| MobilePhoneCountryAlpha3Code | varchar | 3 | √ | null |
|
|
||
| MobilePhoneAreaCode | varchar | 15 | √ | null |
|
|
||
| MobilePhoneExtension | varchar | 15 | √ | null |
|
|
||
| AddressUnitType | varchar | 15 | √ | null |
|
|
||
| AddressUnitNumber | varchar | 15 | √ | null |
|
|
||
| AddressStreetNumber | varchar | 15 | √ | null |
|
|
||
| AddressStreetName | varchar | 40 | √ | null |
|
|
||
| AddressSuburb | varchar | 80 | √ | null |
|
|
||
| AddressState | varchar | 15 | √ | null |
|
|
||
| AddressPostcode | varchar | 5 | √ | null |
|
|
||
| AddressCountryCode | varchar | 15 | √ | null |
|
|
||
| AddressCountryAlpha3Code | varchar | 3 | √ | null |
|
|
||
| DeclarationStartDate | datetime | 16,3 | √ | null |
|
|
||
| DeclarationEndDate | datetime | 16,3 | √ | null |
|
|
||
| BirthDateYYYYMMDD | nvarchar | 200 | null |
|
|
|||
| DeclarationDateYYYYMMDD | nvarchar | 200 | null |
|
|
|||
| DeclarationStartDateYYYYMMDD | nvarchar | 200 | null |
|
|
|||
| DeclarationEndDateYYYYMMDD | nvarchar | 200 | null |
|
|
|||
| IncludeNextExportFlag | bit | 1 | √ | null |
|
|
Table contained 0 rows