T5ITI2

INPS general data table | #other | Component: Italy

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

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

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description

Column Name	Description	Domain name
GGCOR	Standard days accruals/month	P15_GGCOR
GGCOM	Standard days accruals/month	P15_GGCOR
PERNE	Net calculation percentage	P15_PERNE
PERLO	Gross calculation percentage	P15_PERLO

Master Data Relations \| to Other Relations ↓	Join Conditions
Client	`T5ITI2.MANDT == T000.MANDT`
Wage type: days of paid absences ? ? Client Wage type: days of paid absences	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTGAR == T512W.LGART`
Wage type: leave days ? ? Client Wage type: leave days	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTGFR == T512W.LGART`
Wage type: non-working days ? ? Client Wage type: non-working days	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTGFS == T512W.LGART`
Wage type: worked days ? ? Client Wage type: worked days	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTGLA == T512W.LGART`
Wage type: unpaid days ? ? Client Wage type: unpaid days	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTGNR == T512W.LGART`
Wage type: days of paid leave ? ? Client Wage type: days of paid leave	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTGPR == T512W.LGART`
Wage type: 6th day covered by health insurance fund ? ? Client Wage type: 6th day covered by health insurance fund	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTGSG == T512W.LGART`
Wage type: hourly rate ? ? Client Wage type: hourly rate	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTPOR == T512W.LGART`
Wage type: basic pay ? ? Client Wage type: basic pay	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTRBA == T512W.LGART`
Wage type: accruals ? ? Client Wage type: accruals	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTRT1 == T512W.LGART`
Wage type: accruals ? ? Client Wage type: accruals	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTRT2 == T512W.LGART`
Wage type: accruals ? ? Client Wage type: accruals	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTRT3 == T512W.LGART`
Wage type: accruals ? ? Client Wage type: accruals	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTRT4 == T512W.LGART`
Wage-type deduction for new hirings ? ? Client Wage-type deduction for new hirings	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTTNA == T512W.LGART`
Wage-type qualification/deduction variables ? ? Client Wage-type qualification/deduction variables	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTVCO == T512W.LGART`
Wage-type qualification/deduction variables ? ? Client Wage-type qualification/deduction variables	`T5ITI2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITI2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITI2.MANDT == T512W.MANDT` `T5ITI2.WTVCT == T512W.LGART`

Other Relations \| to Master Data Relations ↑	Join Conditions
Pay scale type ? Pay scale type	`T5ITI2.MANDT == T510A.MANDT` `T5ITI2.[column in domain "MOLGA"] == T510A.MOLGA` `T5ITI2.TRFAR == T510A.TRFAR`
Pay Scale Area ? Client Pay Scale Area	`T5ITI2.[column in domain "MOLGA"] == T510G.MOLGA` `T5ITI2.MANDT == T510G.MANDT` `T5ITI2.TRFGB == T510G.TRFGB`