Skip to main content
PP

MPEmployee

MYOB.AdvancedLive.People.Objects.PPScreensMPAT4001MPES3012MPPP2250MPPP2310MPPP2330MPPP2340MPPP4021Release 2025.2

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

Field NameTypeDisplay NameForeign Key
AcctCD
nvarchar(30)Employee ID-
Description:No description available
BAccountIDDefault Navigation
intEmployee IDEPEmployee
Description:No description available
BaseNZTimesheetDayLeaveConversionOption
nvarchar(2)Convert FBAPS leave quantity using-
Description:No description available
CashAccountBranchIDDefault NavigationNonexistent in DB
int?BranchBranch
Description:No description available
CashAccountIDDefault Navigation
intCash Account-
Description:No description available
CountryIDDefault NavigationNonexistent in DB
stringCountryCountry
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated byUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated date (UTC)-
Description:No description available
DefaultFBAPSRateMethod
nvarchar(6)FBAPS Rate-
Description:No description available
DefaultPayFrequencyNonexistent in DB
int?Pay Frequency-
Description:No description available
DepartmentDescriptionNonexistent in DB
stringDepartment-
Description:No description available
EmployeeClassDescriptionNonexistent in DB
stringEmployee Class-
Description:No description available
EmployeeEndDate
datetimeEmployee end date-
Description:No description available
EmployeeID
intEmployee ID-
Description:No description available
EmployeeNameNonexistent in DB
stringEmployee name-
Description:No description available
EmployeeProfileIDDefault Navigation
intEmployee ProfileMPEmployeeProfile
Description:No description available
EmployeeStartDate
datetimeEmployee start date-
Description:No description available
ExcludeFromLeaveReduction
bitLeave does not reduce income-
Description:No description available
ExcludeFromPayRunCreation
bitExclude employee when creating a new Pay Run-
Description:No description available
ExcludeFromShowingSalary
bitExclude from Showing Annual Salary-
Description:No description available
ExternalAcctCD
nvarchar(30)External Employee ID-
Description:No description available
FBAPSAgreedRate
decimalFBAPS Agreed Daily Rate-
Description:No description available
HasCIRNonexistent in DB
bool?Commissioner's Instalment Rate-
Description:No description available
HasLeaveLoading
bitEntitled to Leave Loading-
Description:No description available
IncludeHoursConversionInPayslip
bitDisplay Annual leave balances in Hours on the Payslip (Based on 'DOW' Employee's weekly hours)-
Description:No description available
IsAUNonexistent in DB
bool?-
Description:No description available
IsAdditionalLevyNonexistent in DB
bool?Medical levy surcharge (MLS)-
Description:No description available
IsDailyCasualNonexistent in DB
bool?Daily Casual-
Description:No description available
IsInLongOperationNonexistent in DB
bool?-
Description:No description available
IsNZNonexistent in DB
bool?-
Description:No description available
IsPayable
bitInclude in Pay Run-
Description:No description available
IsPaymentSummaryTypeOverriden
bitOverride PS Type-
Description:No description available
IsRDPForPublicHolidayWorked
bitFor Public holidays worked, use RDP 'Standard Rate'-
Description:No description available
IsTaxFreeThresholdNonexistent in DB
bool?Tax-free threshold (TFT)-
Description:No description available
IsTaxationAUVisibleNonexistent in DB
bool?-
Description:No description available
IsTaxationNZVisibleNonexistent in DB
bool?-
Description:No description available
IsWFMLeaveRosterFeatureOnNonexistent in DB
bool?-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast modified byUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast modified date-
Description:No description available
LeavePayRateType
nvarchar(2)Ordinary Weekly Pay Rate-
Description:No description available
MedicareLevySurchargeRateNonexistent in DB
stringMedical surcharge rate-
Description:No description available
MedicareLevySurchargeTierNonexistent in DB
stringMLS tier-
Description:No description available
MidnightShiftHandling
nvarchar(2)Put shift hours across midnight towards-
Description:No description available
MidnightShiftHandlingTimeGap
intConsider midnight timesheets as continuous when the time between is less than or equal to-
Description:No description available
NonWorkingDayBasedOnTimesheet
bitUntick working day if no timesheets in import-
Description:No description available
NoteID
uniqueidentifierNote ID-
Description:No description available
NumberOfHoursNonexistent in DB
decimal?Default Number of hours-
Description:No description available
OWPSpecialRate
decimalOWP Special Rate ($)-
Description:No description available
ParentBAccountIDDefault NavigationNonexistent in DB
int?BranchBranch
Description:No description available
PayGroupCDNonexistent in DB
stringPay Group ID-
Description:No description available
PaymentMethodIDDefault Navigation
nvarchar(10)Payment MethodPaymentMethod
Description:No description available
PaymentSummaryType
nvarchar(100)Payment summary type-
Description:No description available
PayrollReportingCompanyIDDefault Navigation
intReporting CompanyPXAccess.Organization
Description:No description available
PayrollTaxExempt API
bitEmployee is exempt from Payroll Tax-
Description:No description available
PayrollTaxStateBranch API Nonexistent in DB
string-
Description:No description available
PayrollTaxStateEmployeeAddress API Nonexistent in DB
string-
Description:No description available
PayrollTaxStateJurisdictionOption API
nvarchar(10)-
Description:No description available
PayrollTaxStateJurisdictionOverride API Default Navigation
nvarchar(10)State IDState
Description:No description available
PreviousPayrollID
nvarchar(200)Previous Payroll ID-
Description:No description available
RDPSource
nvarchar(2)RDP Source-
Description:No description available
RateNonexistent in DB
decimal?Default Rate-
Description:No description available
Rehire
bitRehire-
Description:No description available
SelectedNonexistent in DB
bool?Selected-
Description:No description available
StandardPayDescriptionNonexistent in DB
stringPay Group Description-
Description:No description available
StandardPayIDDefault NavigationNonexistent in DB
int?Pay Details forMPStandardPay
Description:No description available
TStamp
timestamp-
Description:No description available
TaxScaleNonexistent in DB
stringTax Scale-
Description:No description available
TimesheetDayLeaveConversionOptionNonexistent in DB
stringConvert FBAPS leave quantity using-
Description:No description available
TimesheetDayLeaveConversionOptionDescriptionNonexistent in DB
string-
Description:No description available
UpdateCompletedPaysPaymentSummaryTypeNonexistent in DB
bool?Update all completed pay(s)-
Description:No description available
UpdateOpenPaysPaymentSummaryTypeNonexistent in DB
bool?Update open pay(s)-
Description:No description available
UsrMPATEmployeeStatus
nvarcharOnboarding Status-
Description:No description available
UsrMPATIsFromWFM
bitIs From WFM-
Description:No description available
UsrMPATWFMEditableFieldsNonexistent in DB
bool?Edit WFM fields-
Description:No description available
WorkPatternSource
nvarchar(1)Work Pattern Source-
Description:No description available
WorkPatternSourceInstructionsNonexistent in DB
string-
Description:No description available