tPayrollEmployeeDeclaration


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tPayrollEmployeeDeclarationSeq int identity 4 √ null
ID int 4 null
CreatedDate datetime 16,3 √ null
CreatedByID int 4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
DeclarationDate datetime 16,3 √ null
DeclarationType varchar 15 null
TFNStatus varchar 15 √ null
TaxFileNumber varchar 80 √ null
PaymentBasis varchar 15 √ null
ResidentialStatus varchar 15 √ null
TaxScale varchar 3 √ null
EmploymentStatus varchar 1 √ null
TaxFreeThresholdClaimedFlag bit 1 √ null
HELPFlag bit 1 √ null
FinancialSupplementDebtFlag bit 1 √ null
TaxOffsetAmount varchar 80 √ null
SeniorTaxOffsetClaim varchar 15 √ null
SignedByEmployeeFlag bit 1 √ null
SignedBy varchar 100 √ null
GovernmentSendStatus varchar 15 √ null
PayrollGovtSubmissionSeq int 4 √ null
WorkEntitlement varchar 15 √ null
KiwiSaverStatus varchar 15 √ 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
Email varchar 100 √ null
Phone varchar 15 √ null
PhoneCountryCode varchar 15 √ null
PhoneAreaCode varchar 15 √ null
PhoneExtension varchar 15 √ null
MobilePhone varchar 15 √ null
MobilePhoneCountryCode varchar 15 √ 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
DeclarationEndDate datetime 16,3 √ null
SLCIRFlag bit 1 √ null
SLBORFlag bit 1 √ null
DeclarationStartDate datetime 16,3 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_tPayrollEmployeeDeclaration Primary key Asc tPayrollEmployeeDeclarationSeq
AK_tPayrollEmployeeDeclaration_ID Performance Asc ID