pvPayrollEmployeeSuperannuationExportStandardValues


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