T5ITII

Sickness handling c/INPS table | #other | Component: Italy

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (13)
Other (18)
🔗 Relations (25)

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
TPF1	Public holiday type not reimbursed by INPS	Show values
TPF2	Public holiday type not reimbursed by INPS	Show values
TPF3	Public holiday type not reimbursed by INPS	Show values
TPF4	Public holiday type not reimbursed by INPS	Show values
TPF5	Public holiday type not reimbursed by INPS	Show values
TPF6	Public holiday type not reimbursed by INPS	Show values
TPF7	Public holiday type not reimbursed by INPS	Show values
TPF8	Public holiday type not reimbursed by INPS	Show values
TPF9	Public holiday type not reimbursed by INPS	Show values
TPF10	Public holiday type not reimbursed by INPS	Show values
RIDO1	Hospitalization reduction coefficient	Show values
RIDO2	Hospitalization reduction coefficient	Show values

Column Name	Description	Domain name
GGLM1	INPS sickness category: max no. of days	P15_GGLMA
GGLM2	INPS sickness category: max no. of days	P15_GGLMA
GGLM3	INPS sickness category: max no. of days	P15_GGLMA
GGLM4	INPS sickness category: max no. of days	P15_GGLMA
GGLM5	INPS sickness category: max no. of days	P15_GGLMA
GGCAR	INPS grace days	P15_GGCAR
GGLMA	Max no. of paid sick days per year	P15_GGLIM
GGSN1	Sickness: weekday not reimbursed by INPS	P15_GGSNI
GGSN2	Sickness: weekday not reimbursed by INPS	P15_GGSNI
TPGD1	Public holiday type - Sunday - not reimbursed by INPS	P15_TPGDI
TPGD2	Public holiday type - Sunday - not reimbursed by INPS	P15_TPGDI
TPGD3	Public holiday type - Sunday - not reimbursed by INPS	P15_TPGDI
TPGD4	Public holiday type - Sunday - not reimbursed by INPS	P15_TPGDI
GGSN3	Sickness: weekday not reimbursed by INPS	P15_GGSNI
GGSN4	Sickness: weekday not reimbursed by INPS	P15_GGSNI
GGSN5	Sickness: weekday not reimbursed by INPS	P15_GGSNI
GGSN6	Sickness: weekday not reimbursed by INPS	P15_GGSNI
GGSN7	Sickness: weekday not reimbursed by INPS	P15_GGSNI

Master Data Relations \| to Other Relations ↓	Join Conditions
Client	`T5ITII.MANDT == T000.MANDT`
Wage-type sickness c/INPS advance payment ? ? Client Wage-type sickness c/INPS advance payment	`T5ITII.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITII.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITII.MANDT == T512W.MANDT` `T5ITII.WTAMI == T512W.LGART`
Wage type: grace days ? ? Client Wage type: grace days	`T5ITII.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITII.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITII.MANDT == T512W.MANDT` `T5ITII.WTGGC == T512W.LGART`
Wage type: maximum number of days in the year ? ? Client Wage type: maximum number of days in the year	`T5ITII.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITII.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITII.MANDT == T512W.MANDT` `T5ITII.WTGLM == T512W.LGART`
Wage type: unpaid days ? ? Client Wage type: unpaid days	`T5ITII.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITII.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITII.MANDT == T512W.MANDT` `T5ITII.WTGNI == T512W.LGART`
Wage type: reimbursement / INPS sickness category ? ? Client Wage type: reimbursement / INPS sickness category	`T5ITII.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITII.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITII.MANDT == T512W.MANDT` `T5ITII.WTMA1 == T512W.LGART`
Wage type: reimbursement / INPS sickness category ? ? Client Wage type: reimbursement / INPS sickness category	`T5ITII.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITII.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITII.MANDT == T512W.MANDT` `T5ITII.WTMA2 == T512W.LGART`
Wage type: reimbursement / INPS sickness category ? ? Client Wage type: reimbursement / INPS sickness category	`T5ITII.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITII.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITII.MANDT == T512W.MANDT` `T5ITII.WTMA3 == T512W.LGART`
Wage type: reimbursement / INPS sickness category ? ? Client Wage type: reimbursement / INPS sickness category	`T5ITII.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITII.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITII.MANDT == T512W.MANDT` `T5ITII.WTMA4 == T512W.LGART`
Wage type: reimbursement / INPS sickness category ? ? Client Wage type: reimbursement / INPS sickness category	`T5ITII.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITII.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITII.MANDT == T512W.MANDT` `T5ITII.WTMA5 == T512W.LGART`

Other Relations \| to Master Data Relations ↑	Join Conditions
Absence/attendance category ? Absence/attendance category ? Client	`T5ITII.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITII.ABS1 == T554P.ABSTP` `T5ITII.[column in domain "MOABW"] == T554P.MOABW` `T5ITII.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITII.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITII.ABS2 == T554P.ABSTP` `T5ITII.[column in domain "MOABW"] == T554P.MOABW` `T5ITII.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITII.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITII.ABS3 == T554P.ABSTP` `T5ITII.[column in domain "MOABW"] == T554P.MOABW` `T5ITII.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITII.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITII.ABS4 == T554P.ABSTP` `T5ITII.[column in domain "MOABW"] == T554P.MOABW` `T5ITII.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITII.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITII.ABS5 == T554P.ABSTP` `T5ITII.[column in domain "MOABW"] == T554P.MOABW` `T5ITII.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITII.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITII.ABS6 == T554P.ABSTP` `T5ITII.[column in domain "MOABW"] == T554P.MOABW` `T5ITII.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITII.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITII.ABS7 == T554P.ABSTP` `T5ITII.[column in domain "MOABW"] == T554P.MOABW` `T5ITII.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITII.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITII.ABS8 == T554P.ABSTP` `T5ITII.[column in domain "MOABW"] == T554P.MOABW` `T5ITII.MANDT == T554P.MANDT`
Percentage type Percentage type ? ? Client	`T5ITII.ABY1 == T5ITI3.ABSTY` `T5ITII.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITII.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITII.MANDT == T5ITI3.MANDT`
Percentage type Percentage type ? ? Client	`T5ITII.ABY2 == T5ITI3.ABSTY` `T5ITII.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITII.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITII.MANDT == T5ITI3.MANDT`
Percentage type Percentage type ? ? Client	`T5ITII.ABY3 == T5ITI3.ABSTY` `T5ITII.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITII.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITII.MANDT == T5ITI3.MANDT`
Percentage type Percentage type ? ? Client	`T5ITII.ABY4 == T5ITI3.ABSTY` `T5ITII.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITII.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITII.MANDT == T5ITI3.MANDT`
Percentage type Percentage type ? ? Client	`T5ITII.ABY5 == T5ITI3.ABSTY` `T5ITII.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITII.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITII.MANDT == T5ITI3.MANDT`
Pay scale type ? Pay scale type	`T5ITII.MANDT == T510A.MANDT` `T5ITII.[column in domain "MOLGA"] == T510A.MOLGA` `T5ITII.TRFAR == T510A.TRFAR`
Pay Scale Area ? Client Pay Scale Area	`T5ITII.[column in domain "MOLGA"] == T510G.MOLGA` `T5ITII.MANDT == T510G.MANDT` `T5ITII.TRFGB == T510G.TRFGB`