T5QPBS5A

HR AU PS:Australian Leave Loading | #other | Component: Public Sector

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates (5)
☰ Categorical (5)
Other (4)
🔗 Relations (11)

Column Name	Description
MANDT FK	Client
MOPGK	Employee Subgroup Grouping for Time Quota Types
MOZKO	Grouping of Personnel Subareas for Time Quota Types
MOBDE	Grouping of Personnel Subareas for Time Recording
KTART FK	Absence Quota Type
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date
LLDBD	HR AU PS:Leave Loading Year Begin Date
LLDED	HR AU PS:Leave Loading Year End Date
PYDAT	Payment made on a fixed date

Column Name	Description
LDTYP	Calculation and Payment method	Show values
LLDOP	Option for unpaid leave loading	Show values
ABSDY	Include absence days for minimum number of days	Show values
CALDY	Include calendar days within the absence period	Show values
PAIDE	Leave Loading based on previous or current entitlement	Show values

Column Name	Description	Domain name
LLDYR	HR AU PS:Leave Loading Year	NUMC04
MINDC	HR AU PS:Mini no. of leave taken to be eligible for LLD	NUMC3
LLPER	Leave Loading Percentage	P13Q_LLPER
MINAB	Mini no of multi absences taken within the leave loading yr	NUMC03

Master Data Relations	Join Conditions
Attendance or Absence Type Attendance or Absence Type Client ? ?	`T5QPBS5A.AWA01 == T554S.SUBTY` `T5QPBS5A.MANDT == T554S.MANDT` `T5QPBS5A.[column in domain "MOABW"] == T554S.MOABW` `T5QPBS5A.[column in domain "ENDDA"] == T554S.ENDDA`
Attendance or Absence Type Attendance or Absence Type Client ? ?	`T5QPBS5A.AWA02 == T554S.SUBTY` `T5QPBS5A.MANDT == T554S.MANDT` `T5QPBS5A.[column in domain "MOABW"] == T554S.MOABW` `T5QPBS5A.[column in domain "ENDDA"] == T554S.ENDDA`
Attendance or Absence Type Attendance or Absence Type Client ? ?	`T5QPBS5A.AWA03 == T554S.SUBTY` `T5QPBS5A.MANDT == T554S.MANDT` `T5QPBS5A.[column in domain "MOABW"] == T554S.MOABW` `T5QPBS5A.[column in domain "ENDDA"] == T554S.ENDDA`
Attendance or Absence Type Attendance or Absence Type Client ? ?	`T5QPBS5A.AWA04 == T554S.SUBTY` `T5QPBS5A.MANDT == T554S.MANDT` `T5QPBS5A.[column in domain "MOABW"] == T554S.MOABW` `T5QPBS5A.[column in domain "ENDDA"] == T554S.ENDDA`
Attendance or Absence Type Attendance or Absence Type Client ? ?	`T5QPBS5A.AWA05 == T554S.SUBTY` `T5QPBS5A.MANDT == T554S.MANDT` `T5QPBS5A.[column in domain "MOABW"] == T554S.MOABW` `T5QPBS5A.[column in domain "ENDDA"] == T554S.ENDDA`
Dependent Quota for varying percentage link ? Grouping of Personnel Subareas for Time Quota Types Dependent Quota for varying percentage link Employee Subgroup Grouping for Time Quota Types	`T5QPBS5A.MANDT == T556A.MANDT` `T5QPBS5A.[column in domain "ENDDA"] == T556A.ENDDA` `T5QPBS5A.MOZKO == T556A.MOZKO` `T5QPBS5A.DEKTA == T556A.KTART` `T5QPBS5A.MOPGK == T556A.MOPGK`
validate quota ? Grouping of Personnel Subareas for Time Quota Types Absence Quota Type Employee Subgroup Grouping for Time Quota Types	`T5QPBS5A.MANDT == T556A.MANDT` `T5QPBS5A.[column in domain "ENDDA"] == T556A.ENDDA` `T5QPBS5A.MOZKO == T556A.MOZKO` `T5QPBS5A.KTART == T556A.KTART` `T5QPBS5A.MOPGK == T556A.MOPGK`
Leave loading payment wage type. ? ? Client Leave loading payment wage type.	`T5QPBS5A.[column in domain "MOLGA"] == T512W.MOLGA` `T5QPBS5A.[column in domain "ENDDA"] == T512W.ENDDA` `T5QPBS5A.MANDT == T512W.MANDT` `T5QPBS5A.LLWTY == T512W.LGART`
client	`T5QPBS5A.MANDT == T000.MANDT`
Valuation basis for Leave Loading ? ? Client Valuation basis for Leave Loading	`T5QPBS5A.[column in domain "MOLGA"] == T512W.MOLGA` `T5QPBS5A.[column in domain "ENDDA"] == T512W.ENDDA` `T5QPBS5A.MANDT == T512W.MANDT` `T5QPBS5A.VALBA == T512W.LGART`

Other Relations \| to Master Data Relations ↑	Join Conditions
Absence type grouping ? ? Absence type grouping	`T5QPBS5A.MANDT == T5QPBS5C.MANDT` `T5QPBS5A.[column in domain "MOABW"] == T5QPBS5C.MOABW` `T5QPBS5A.[column in domain "AWART"] == T5QPBS5C.AWART` `T5QPBS5A.ABSGR == T5QPBS5C.ABSGR`