T5ITIA

Nursing table | #other | Component: Italy

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (1)
Other (4)
🔗 Relations (12)

Column Name	Description
MANDT FK	Client
TRFAR FK	Pay scale type
TRFGB FK	Pay Scale Area
TRFKZ	ES grouping for collective agreement provision
TPTRA	Absence treatment type	Show values
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
TPTRA	Absence treatment type	Show values

Column Name	Description	Domain name
HALR1	Paid nursing hours	P15_HALLR
HALR2	Paid nursing hours	P15_HALLR
HMINA	Minimun no. of worked hours for nursing	P15_HMINA
MPART	Month range from delivery date	P15_MPART

Master Data Relations \| to Other Relations ↓	Join Conditions
Client	`T5ITIA.MANDT == T000.MANDT`
Wage type: paid nursing hours ? ? Client Wage type: paid nursing hours	`T5ITIA.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIA.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIA.MANDT == T512W.MANDT` `T5ITIA.WTHAL == T512W.LGART`
Wage type: unpaid hours above day limit ? ? Client Wage type: unpaid hours above day limit	`T5ITIA.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIA.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIA.MANDT == T512W.MANDT` `T5ITIA.WTNRL == T512W.LGART`
Wage-type unpaid hours outside months range ? ? Client Wage-type unpaid hours outside months range	`T5ITIA.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIA.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIA.MANDT == T512W.MANDT` `T5ITIA.WTNRM == T512W.LGART`

Other Relations \| to Master Data Relations ↑	Join Conditions
Absence/attendance category ? Absence/attendance category ? Client	`T5ITIA.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITIA.ABST1 == T554P.ABSTP` `T5ITIA.[column in domain "MOABW"] == T554P.MOABW` `T5ITIA.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITIA.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITIA.ABST2 == T554P.ABSTP` `T5ITIA.[column in domain "MOABW"] == T554P.MOABW` `T5ITIA.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITIA.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITIA.ABST3 == T554P.ABSTP` `T5ITIA.[column in domain "MOABW"] == T554P.MOABW` `T5ITIA.MANDT == T554P.MANDT`
Percentage type Percentage type ? ? Client	`T5ITIA.ABSY1 == T5ITI3.ABSTY` `T5ITIA.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITIA.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITIA.MANDT == T5ITI3.MANDT`
Percentage type Percentage type ? ? Client	`T5ITIA.ABSY2 == T5ITI3.ABSTY` `T5ITIA.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITIA.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITIA.MANDT == T5ITI3.MANDT`
Percentage type Percentage type ? ? Client	`T5ITIA.ABSY3 == T5ITI3.ABSTY` `T5ITIA.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITIA.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITIA.MANDT == T5ITI3.MANDT`
Pay scale type ? Pay scale type	`T5ITIA.MANDT == T510A.MANDT` `T5ITIA.[column in domain "MOLGA"] == T510A.MOLGA` `T5ITIA.TRFAR == T510A.TRFAR`
Pay Scale Area ? Client Pay Scale Area	`T5ITIA.[column in domain "MOLGA"] == T510G.MOLGA` `T5ITIA.MANDT == T510G.MANDT` `T5ITIA.TRFGB == T510G.TRFGB`