T5ITIC

Marriage leave table | #other | Component: Italy

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (11)
Other (3)
🔗 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
GGNO1	Weekday to be excluded from leave	Show values
GGNO2	Weekday to be excluded from leave	Show values
TPGG1	Type of public holiday to be excluded from marriage leave	Show values
TPGG2	Type of public holiday to be excluded from marriage leave	Show values
TPGG3	Type of public holiday to be excluded from marriage leave	Show values
TPGG4	Type of public holiday to be excluded from marriage leave	Show values
TPGG5	Type of public holiday to be excluded from marriage leave	Show values
TPGG6	Type of public holiday to be excluded from marriage leave	Show values
TPGG7	Type of public holiday to be excluded from marriage leave	Show values
TPGG8	Type of public holiday to be excluded from marriage leave	Show values

Column Name	Description	Domain name
GGMAX	Max no. of consecutive days for marriage leave	P15_GGMAX
HCMAX	Max.no.of continuous hours for marriage leave	P15_HCMAX
GGMII	Max no. of paid days INPS	P15_GGMII

Master Data Relations \| to Other Relations ↓	Join Conditions
Client	`T5ITIC.MANDT == T000.MANDT`
Wage type: unpaid leave ? ? Client Wage type: unpaid leave	`T5ITIC.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIC.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIC.MANDT == T512W.MANDT` `T5ITIC.WTHCN == T512W.LGART`
Wage type: paid leave hours ? ? Client Wage type: paid leave hours	`T5ITIC.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIC.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIC.MANDT == T512W.MANDT` `T5ITIC.WTHCR == T512W.LGART`
Wage-type Max. days reimbursed by INPS ? ? Client Wage-type Max. days reimbursed by INPS	`T5ITIC.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIC.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIC.MANDT == T512W.MANDT` `T5ITIC.WTIIN == T512W.LGART`

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