GPIT_TDETR_FAM2 (SQL Table)	Index Back
Familiar dependent tax detr. Only info about number of familiar dependent and percentages

GPIT_TDETR_FAM2

(SQL Table)

Familiar dependent tax detr.

Only info about number of familiar dependent and percentages

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON_NAME

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 GPIT_TDETR_TYPE Character(4) VARCHAR2(4) NOT NULL This field is associated to a translate table. The value are four: 1) CH<3 - child aged less than 3 years old 2) CH>3 - child aged more than 3 years old 3) CHAD - child after the first 4) OTHE - other familiar dependents
ALTR=Other dependents
FI<3=Child less than 3 years
FIGL=Children
FIOP=Child after the first
HAND=Disabled children

4 GPIT_APPLIED_RATE Number(7,3) DECIMAL(6,3) NOT NULL This field is used in different table. It has 3 decimals. Depending on the context, a different lable can be chosen. For example it is used as Percent to apply for a SCAGLIONE. The scaglione is a range of money for which a mandatory percent must be applied.

5 GPIT_NUMBER_2 Number(2,0) SMALLINT NOT NULL This field is used in different tables as integer of 2 digits. Depending on the context, a different lable can be chosen. For example it is used in the Irpef Additional and Tax detraction tables.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GPIT_TDETR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field is associated to a translate table. The value are four: 1) CH<3 - child aged less than 3 years old 2) CH>3 - child aged more than 3 years old 3) CHAD - child after the first 4) OTHE - other familiar dependents ALTR=Other dependents FI<3=Child less than 3 years FIGL=Children FIOP=Child after the first HAND=Disabled children
4	GPIT_APPLIED_RATE	Number(7,3)	DECIMAL(6,3) NOT NULL	This field is used in different table. It has 3 decimals. Depending on the context, a different lable can be chosen. For example it is used as Percent to apply for a SCAGLIONE. The scaglione is a range of money for which a mandatory percent must be applied.
5	GPIT_NUMBER_2	Number(2,0)	SMALLINT NOT NULL	This field is used in different tables as integer of 2 digits. Depending on the context, a different lable can be chosen. For example it is used in the Irpef Additional and Tax detraction tables.