PP
MPPaymentSummaryBatchItemEmployeeDetails
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ABN | nvarchar(30) | Australian Business Number (ABN) | - | |
Description:No description available | ||||
AddressLine1 | nvarchar(200) | Address 1 | - | |
Description:No description available | ||||
AddressLine2 | nvarchar(200) | Address 2 | - | |
Description:No description available | ||||
AustralianResidentDescriptionNonexistent in DB | string | Residency | - | |
Description:No description available | ||||
BranchCD | nvarchar(30) | Branch | - | |
Description:No description available | ||||
CessationReasonNonexistent in DB | string | Cessation Reason | - | |
Description:No description available | ||||
ContractorType | nvarchar(50) | Contract type | - | |
Description:No description available | ||||
CountryID | nvarchar(10) | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created by | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created date (UTC) | - | |
Description:No description available | ||||
DateOfBirth | datetime | Date of birth | - | |
Description:No description available | ||||
Email | nvarchar(200) | - | ||
Description:No description available | ||||
EmployeeCD | nvarchar(30) | Employee ID | - | |
Description:No description available | ||||
EmployeeEndDateNonexistent in DB | DateTime? | Employee End Date | - | |
Description:No description available | ||||
EmployeeFullNameNonexistent in DB | string | Name | - | |
Description:No description available | ||||
EmployeeID | int | - | ||
Description:No description available | ||||
EmployeeStartDateNonexistent in DB | DateTime? | Employee Start Date | - | |
Description:No description available | ||||
FileIDNonexistent in DB | Guid? | FileID | - | |
Description:No description available | ||||
FirstMiddleNames | nvarchar(200) | Given Names | - | |
Description:No description available | ||||
FirstName | nvarchar(100) | First Name | - | |
Description:No description available | ||||
GivenNames | nvarchar(300) | Given Names | - | |
Description:No description available | ||||
IsAUNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsActive | bit | Active | - | |
Description:No description available | ||||
IsAustralianResident | bit | Residency | - | |
Description:No description available | ||||
IsFBTExempt | bit | Is FBT Exempt | - | |
Description:No description available | ||||
IsHelpOrTSL | bit | Help Or TSL | - | |
Description:No description available | ||||
IsNZNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsSFSS | bit | SFSS | - | |
Description:No description available | ||||
IsTFNSignedByPayee | bit | TFND Signed By Payee | - | |
Description:No description available | ||||
IsTaxFreeThreshold | bit | Tax-free or threshold | - | |
Description:No description available | ||||
IsTerminated | bit | Termination | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last modified by | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last modified date | - | |
Description:No description available | ||||
LodgementID | nvarchar(100) | Lodgement ID | - | |
Description:No description available | ||||
LodgementStatus | nvarchar(100) | Submission Status | - | |
Description:No description available | ||||
MiddleName | nvarchar(100) | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | Note ID | - | |
Description:No description available | ||||
OrganizationCDNonexistent in DB | string | Company | - | |
Description:No description available | ||||
OrganizationID | int | - | ||
Description:No description available | ||||
PSARType | nvarchar(1) | - | ||
Description:No description available | ||||
PayBasis | nvarchar(40) | Employment Basis | - | |
Description:No description available | ||||
PayBasisDescriptionNonexistent in DB | string | Employment Basis | - | |
Description:No description available | ||||
PaymentPeriodNonexistent in DB | string | Payment Period | - | |
Description:No description available | ||||
PaymentSummaryBatchID | int | MPPaymentSummaryBatch | ||
Description:No description available | ||||
PaymentSummaryBatchItemEmployeeDetailsID | int | Batch Item ID | - | |
Description:No description available | ||||
PaymentSummaryPeriodEndDate | datetime | - | ||
Description:No description available | ||||
PaymentSummaryPeriodStartDate | datetime | - | ||
Description:No description available | ||||
PaymentSummaryType | nvarchar(30) | Payment Summary Type | - | |
Description:No description available | ||||
PhoneNumber | nvarchar(50) | Phone Number | - | |
Description:No description available | ||||
PostCode | nvarchar(10) | Postcode | - | |
Description:No description available | ||||
PreviousPayrollID | nvarchar | Previous Payroll ID | - | |
Description:No description available | ||||
QualifyingEarningsYTD | decimal | - | ||
Description:No description available | ||||
ReportableBranchABNNonexistent in DB | string | - | ||
Description:No description available | ||||
SelectEmployeeNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SettingEmailPaymentSummary | bit | Email PaymentSummary | - | |
Description:No description available | ||||
SettingEmailPaymentSummaryNotification | bit | Email PaymentSummary Notification | - | |
Description:No description available | ||||
SettingEmailPaymentSummaryNotificationRecipient | nvarchar(255) | Email PaymentSummary Notification Recipient | - | |
Description:No description available | ||||
SettingEmailPaymentSummaryRecipient | nvarchar(255) | Email PaymentSummary Recipient | - | |
Description:No description available | ||||
SettingLastEmailedByIDNonexistent in DB | Guid? | Last Emailed by ID | - | |
Description:No description available | ||||
SettingLastEmailedByName | nvarchar(255) | Last Emailed By Name | - | |
Description:No description available | ||||
SettingLastEmailedDate | datetime | Last Emailed Date | - | |
Description:No description available | ||||
SettingLastNotifiedByIDNonexistent in DB | Guid? | Last Notified by ID | - | |
Description:No description available | ||||
SettingLastNotifiedByName | nvarchar(255) | Last Notified By Name | - | |
Description:No description available | ||||
SettingLastNotifiedDate | datetime | Last Notified Date | - | |
Description:No description available | ||||
SettingLastPrintedByIDNonexistent in DB | Guid? | Last Printed by ID | - | |
Description:No description available | ||||
SettingLastPrintedByName | nvarchar(255) | Last Printed By Name | - | |
Description:No description available | ||||
SettingLastPrintedDate | datetime | Last Printed Date | - | |
Description:No description available | ||||
SettingPaymentSummaryType | nvarchar(100) | Payment Summary Type | - | |
Description:No description available | ||||
SettingPrintPaymentSummary | bit | Print PaymentSummary | - | |
Description:No description available | ||||
SettingUseDefaultEmailForNotification | bit | Use Default Email For Notification | - | |
Description:No description available | ||||
SettingUseDefaultEmailForPaymentSummary | bit | Use Default Email For PaymentSummary | - | |
Description:No description available | ||||
State | nvarchar(20) | State | - | |
Description:No description available | ||||
SubmissionStatusNonexistent in DB | string | Submission Status | - | |
Description:No description available | ||||
Suburb | nvarchar(100) | Suburb | - | |
Description:No description available | ||||
Surname | nvarchar(100) | Last Name | - | |
Description:No description available | ||||
TFNDStatus | nvarchar | TFN Status | - | |
Description:No description available | ||||
TFNSignatureDate | datetime | TFND Signature Date | - | |
Description:No description available | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
TaxFileNumber | nvarchar | Tax File Number (TFN) | - | |
Description:No description available | ||||
TaxFileNumberStatus | nvarchar(40) | - | ||
Description:No description available | ||||
TaxOffsetClaimTotal | decimal | - | ||
Description:No description available | ||||
TaxOffsetTotalNonexistent in DB | decimal? | Tax Offset Total | - | |
Description:No description available | ||||
TaxScale | int | Tax Scale | - | |
Description:No description available | ||||
TaxTreatmentCode | nvarchar(30) | Tax Treatment Code | - | |
Description:No description available | ||||
TaxationAUIsWHM | bit | Income type | - | |
Description:No description available | ||||
TotalPreTaxDeduction | decimal | Total Pretax Deduction | - | |
Description:No description available | ||||
TotalTaxWithheld | decimal | Total Tax Withheld | - | |
Description:No description available | ||||
TotalTaxableIncome | decimal | - | ||
Description:No description available | ||||