Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PayrollGovtSubmissionEmployeeSeq | int | 4 | null |
|
|
|||
| PayrollGovtSubmissionSeq | int | 4 | null |
|
|
|||
| VersionNumber | int | 4 | √ | null |
|
|
||
| EmployeeID | int | 4 | null |
|
|
|||
| Payload | xml | 1073741823 | √ | null |
|
|
||
| ApprovedFlag | bit | 1 | √ | null |
|
|
||
| GenerationResult | varchar | 2147483647 | √ | null |
|
|
||
| PayloadType | varchar | 15 | null |
|
|
|||
| TaxFileNumber | varchar | 9 | √ | null |
|
|
||
| AustralianBusinessNumber | varchar | 12 | √ | null |
|
|
||
| EmploymentPayrollNumber | varchar | 10 | √ | null |
|
|
||
| FamilyName | varchar | 40 | √ | null |
|
|
||
| GivenName | varchar | 40 | √ | null |
|
|
||
| OtherGivenName | varchar | 40 | √ | null |
|
|
||
| BirthDay | varchar | 10 | √ | null |
|
|
||
| BirthMonth | varchar | 10 | √ | null |
|
|
||
| BirthYear | varchar | 10 | √ | null |
|
|
||
| AddressLine1 | varchar | 40 | √ | null |
|
|
||
| AddressLine2 | varchar | 40 | √ | null |
|
|
||
| AddressLocalityName | varchar | 40 | √ | null |
|
|
||
| AddressStateOrTerritory | varchar | 40 | √ | null |
|
|
||
| AddressPostcode | varchar | 5 | √ | null |
|
|
||
| AddressCountry | varchar | 15 | √ | null |
|
|
||
| ElectronicMailAddress | varchar | 100 | √ | null |
|
|
||
| TelephoneMinimal | varchar | 15 | √ | null |
|
|
||
| EmploymentStart | varchar | 20 | √ | null |
|
|
||
| EmploymentEnd | varchar | 20 | √ | null |
|
|
||
| PayrollPeriodStartDate | varchar | 20 | √ | null |
|
|
||
| PayrollPeriodEndDate | varchar | 20 | √ | null |
|
|
||
| PayrollEventFinal | varchar | 20 | √ | null |
|
|
||
| IndividualNonBusinessGross | varchar | 20 | √ | null |
|
|
||
| CommunityDevelopmentEmploymentProject | varchar | 20 | √ | null |
|
|
||
| IndividualNonBusinessTaxWithheld | varchar | 20 | √ | null |
|
|
||
| ExemptForeignEmploymentIncome | varchar | 20 | √ | null |
|
|
||
| VoluntaryAgreementGross | varchar | 20 | √ | null |
|
|
||
| VoluntaryAgreementTaxWithheld | varchar | 20 | √ | null |
|
|
||
| LabourHireArrangementPaymentGross | varchar | 20 | √ | null |
|
|
||
| LabourHireArrangementPaymentTaxWithheld | varchar | 20 | √ | null |
|
|
||
| SpecifiedByRegulationPaymentGross | varchar | 20 | √ | null |
|
|
||
| SpecifiedByRegulationPaymentTaxWithheld | varchar | 20 | √ | null |
|
|
||
| JointPetroleumDevelopmentAreaPaymentGross | varchar | 20 | √ | null |
|
|
||
| JointPetroleumDevelopmentAreaPaymentWithholding | varchar | 20 | √ | null |
|
|
||
| JointPetroleumDevelopmentAreaPaymentTaxWithheld | varchar | 20 | √ | null |
|
|
||
| WorkingHolidayMakerGross | varchar | 20 | √ | null |
|
|
||
| WorkingHolidayMakerTaxWithheld | varchar | 20 | √ | null |
|
|
||
| PaymentToForeignResidentGross | varchar | 20 | √ | null |
|
|
||
| PaymentToForeignResidentForeignWithholding | varchar | 20 | √ | null |
|
|
||
| PaymentToForeignResidentTaxWithheld | varchar | 20 | √ | null |
|
|
||
| LumpSumAC | varchar | 20 | √ | null |
|
|
||
| LumpSumA | varchar | 20 | √ | null |
|
|
||
| LumpSumB | varchar | 20 | √ | null |
|
|
||
| LumpSumD | varchar | 20 | √ | null |
|
|
||
| LumpSumE | varchar | 20 | √ | null |
|
|
||
| EmployerContributionsSuperannuationGuarantee | varchar | 20 | √ | null |
|
|
||
| OrdinaryTimeEarnings | varchar | 20 | √ | null |
|
|
||
| EmployerReportable | varchar | 20 | √ | null |
|
|
||
| TaxableIncomeFringeBenefitsReportable | varchar | 20 | √ | null |
|
|
||
| ExemptIncomeFringeBenefitsReportable | varchar | 20 | √ | null |
|
|
||
| PaymentArrangementTermination | varchar | 20 | √ | null |
|
|
||
| ResidencyTaxPurposesPersonStatus | varchar | 50 | √ | null |
|
|
||
| PaymentArrangementPaymentBasis | varchar | 20 | √ | null |
|
|
||
| TaxOffsetClaimTaxFreeThreshold | varchar | 20 | √ | null |
|
|
||
| IncomeTaxPayAsYouGoWithholdingStudyAndTrainingLoanRepayment | varchar | 20 | √ | null |
|
|
||
| StudentLoanStudentFinancialSupplementScheme | varchar | 20 | √ | null |
|
|
||
| StatementAccepted | varchar | 20 | √ | null |
|
|
||
| SignatureDate | varchar | 20 | √ | null |
|
|
Table contained 0 rows