MPNewDepartingEmployeesBatchItem

MYOB.AdvancedLive.People.Objects.PPRelease 2025.2

No summary is documented for this DAC in the release source.

60 of 60 fields

	Field Name	Type	Display Name	Foreign Key
	`AcctCD`Nonexistent in DB	`string`	Employee ID	-
Description:No description available
	`BankAccountAccount`	`nvarchar(8)`	Bank account – account	-
Description:No description available
	`BankAccountBank`	`nvarchar(2)`	Bank account – bank	-
Description:No description available
	`BankAccountBranch`	`nvarchar(4)`	Bank account – branch	-
Description:No description available
	`BankAccountReferenceNumber`	`nvarchar`	Bank account – reference number	-
Description:No description available
	`BankAccountSuffix`	`nvarchar(4)`	Bank account – suffix	-
Description:No description available
	`BranchCD`	`nvarchar(30)`	Branch	-
Description:No description available
	`City`	`nvarchar(200)`	City	-
Description:No description available
	`Country`	`nvarchar(30)`	Country	-
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created by	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created date (UTC)	-
Description:No description available
	`DateOfChange`	`datetime`	Date of Change	-
Description:No description available
	`DateOptOutNoticeSignedByEmployee`	`datetime`	Date opt-out notice signed by the employee	-
Description:No description available
	`DaytimePhoneAreaCode`	`nvarchar(10)`	Daytime phone area code	-
Description:No description available
	`DaytimePhoneCountryCode`	`nvarchar(3)`	Daytime phone country code	-
Description:No description available
	`DaytimePhoneExtension`	`nvarchar(20)`	Daytime phone extension	-
Description:No description available
	`DaytimePhoneNumber`	`nvarchar(30)`	Daytime phone	-
Description:No description available
	`EmailAddress`	`nvarchar(510)`	Email	-
Description:No description available
	`EmployeeDOBDateTime`	`datetime`	Date of birth	-
Description:No description available
	`EmployeeEndDate`	`datetime`	End Date	-
Description:No description available
	`EmployeeExemptIncome`	`nvarchar(4)`	Employee Exempt Income	-
Description:No description available
	`EmployeeFullName`Nonexistent in DB	`string`	Employee name on EI return	-
Description:No description available
	`EmployeeID`	`int`	Employee ID	-
Description:No description available
	`EmployeeOptedOutFromKiwiSaver`	`bit`	Employee opted-out from KiwiSaver	-
Description:No description available
	`EmployeeStartDate`	`datetime`	Start date	-
Description:No description available
	`EmployeeTitle`	`nvarchar(50)`	Title	-
Description:No description available
	`Firstname`	`nvarchar(50)`	First name(s)	-
Description:No description available
	`IRBatchID`	`int`	Batch ID	MPNewDepartingEmployeesBatch
Description:No description available
	`IRBatchItemID`	`int`	Batch item ID	-
Description:No description available
	`IRDNumber`	`nvarchar(20)`	IRD number	-
Description:No description available
	`IRDUpdateDate`	`datetime`	IRD ND End Date	-
Description:No description available
	`IsAU`Nonexistent in DB	`bool?`		-
Description:No description available
	`IsExtraRow`Nonexistent in DB	`bool?`		-
Description:No description available
	`IsNZ`Nonexistent in DB	`bool?`		-
Description:No description available
	`KiwiSaverEligibility`	`nvarchar(2)`	KiwiSaver Eligibility	-
Description:No description available
	`KiwiStatus`	`nvarchar(2)`	KiwiSaver Status	-
Description:No description available
	`LastModifiedByID`Default Navigation	`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
	`LateOptOutReason`	`nvarchar(10)`	Late Opt-out Reason	-
Description:No description available
	`MiddleName`	`nvarchar(50)`	Middle name	-
Description:No description available
	`MobilePhoneAreaCode`	`nvarchar(10)`	Mobile phone area code	-
Description:No description available
	`MobilePhoneCountryCode`	`nvarchar(3)`	Mobile phone country code	-
Description:No description available
	`MobilePhoneExtension`	`nvarchar(20)`	Mobile extension	-
Description:No description available
	`MobilePhoneNumber`	`nvarchar(30)`	Mobile phone	-
Description:No description available
	`NameOfAccountHolder`	`nvarchar(31)`	Name of account holder	-
Description:No description available
	`OrganizationID`	`int`		-
Description:No description available
	`OtherLateOptOutReason`	`nvarchar(500)`	Other late opt-out reason	-
Description:No description available
	`PostCode`	`nvarchar(60)`	Post code	-
Description:No description available
	`State`	`nvarchar(12)`	State	-
Description:No description available
	`StreetName`	`nvarchar(510)`	Street name	-
Description:No description available
	`StreetNumber`	`nvarchar(60)`	Street number	-
Description:No description available
	`Surname`	`nvarchar(50)`	Last Name	-
Description:No description available
	`TStamp`	`timestamp`		-
Description:No description available
	`TaxCode`	`nvarchar(10)`	Tax code	-
Description:No description available
	`TaxationNZIsSLBOR`	`bit`	SLBOR	-
Description:No description available
	`TaxationNZIsSLCIR`	`bit`	SLCIR	-
Description:No description available
	`UnitNumber`	`nvarchar(60)`	Unit number	-
Description:No description available
	`UnitType`	`nvarchar(50)`	Unit type	-
Description:No description available