T5ITIP

Maternity table | #other | Component: Italy

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (16)
Other (24)
🔗 Relations (26)

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
UNIMI	Unit of measure for the integration of protected actions	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
TPGD1	Public holiday type - Sunday - not reimbursed by INPS	Show values
TPGD2	Public holiday type - Sunday - not reimbursed by INPS	Show values
TPGD3	Public holiday type - Sunday - not reimbursed by INPS	Show values
TPGD4	Public holiday type - Sunday - not reimbursed by INPS	Show values

Column Name	Description	Domain name
GGCOR	Standard days accruals/month	P15_GGCOR
GGSN1	Weekday not reimbursed by INPS	P15_GGSNI
GGSN2	Weekday not reimbursed by INPS	P15_GGSNI
MPARF	Opt.maternity leave: max.no.of months from act.delivery date	P15_MPARE
GGIND	Max.number of payable days	P15_GGIND
GGSI1	Weekday not reimbursed by INPS	P15_GGSNI
GGSI2	Weekday not reimbursed by INPS	P15_GGSNI
TPG1	Opt. maternity: public holiday type not reimbursed by INPS	P15_TPGFN
TPG2	Opt. maternity: public holiday type not reimbursed by INPS	P15_TPGFN
TPG3	Opt. maternity: public holiday type not reimbursed by INPS	P15_TPGFN
TPG4	Opt. maternity: public holiday type not reimbursed by INPS	P15_TPGFN
TPG5	Opt. maternity: public holiday type not reimbursed by INPS	P15_TPGFN
TPG6	Opt. maternity: public holiday type not reimbursed by INPS	P15_TPGFN
TPG7	Opt. maternity: public holiday type not reimbursed by INPS	P15_TPGFN
TPG8	Opt. maternity: public holiday type not reimbursed by INPS	P15_TPGFN
TPG9	Opt. maternity: public holiday type not reimbursed by INPS	P15_TPGFN
TPG10	Opt. maternity: public holiday type not reimbursed by INPS	P15_TPGFN
TPGF1	Public holiday type - Sunday - not reimbursed by INPS	P15_TPGDI
TPGF2	Public holiday type - Sunday - not reimbursed by INPS	P15_TPGDI
TPGF3	Public holiday type - Sunday - not reimbursed by INPS	P15_TPGDI
TPGF4	Public holiday type - Sunday - not reimbursed by INPS	P15_TPGDI
GGLI1	Max no. of days for company integration	P15_GGLIA
GGLI2	Max no. of days for company integration	P15_GGLIA
GGLI3	Max no. of days for company integration	P15_GGLIA

Master Data Relations \| to Other Relations ↓	Join Conditions
Client	`T5ITIP.MANDT == T000.MANDT`
Wage type: unpaid days ? ? Client Wage type: unpaid days	`T5ITIP.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIP.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIP.MANDT == T512W.MANDT` `T5ITIP.WTGN1 == T512W.LGART`
Wage type: unpaid days ? ? Client Wage type: unpaid days	`T5ITIP.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIP.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIP.MANDT == T512W.MANDT` `T5ITIP.WTGN2 == T512W.LGART`
Wage-type company integration 1 ? ? Client Wage-type company integration 1	`T5ITIP.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIP.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIP.MANDT == T512W.MANDT` `T5ITIP.WTIA1 == T512W.LGART`
Wage-type company integration 1 ? ? Client Wage-type company integration 1	`T5ITIP.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIP.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIP.MANDT == T512W.MANDT` `T5ITIP.WTIA2 == T512W.LGART`
Wage-type company integration 1 ? ? Client Wage-type company integration 1	`T5ITIP.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIP.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIP.MANDT == T512W.MANDT` `T5ITIP.WTIA3 == T512W.LGART`
Wage-type company integration 2 ? ? Client Wage-type company integration 2	`T5ITIP.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIP.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIP.MANDT == T512W.MANDT` `T5ITIP.WTIAD == T512W.LGART`
Wage type: company integration - Optional Maternity ? ? Client Wage type: company integration - Optional Maternity	`T5ITIP.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIP.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIP.MANDT == T512W.MANDT` `T5ITIP.WTIAZ == T512W.LGART`
Wage type: INPS reimbursement - Optional maternity ? ? Client Wage type: INPS reimbursement - Optional maternity	`T5ITIP.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIP.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIP.MANDT == T512W.MANDT` `T5ITIP.WTICI == T512W.LGART`
Wage type: company integration ? ? Client Wage type: company integration	`T5ITIP.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIP.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIP.MANDT == T512W.MANDT` `T5ITIP.WTINA == T512W.LGART`
Wage type: INPS reimbursement ? ? Client Wage type: INPS reimbursement	`T5ITIP.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIP.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIP.MANDT == T512W.MANDT` `T5ITIP.WTINI == T512W.LGART`

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