GPIT_TDETR_FAM1

#	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	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Prompt Table: PERSON_NAME
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	GPIT_CON_FIG_DETR	Character(1)	VARCHAR2(1) NOT NULL	Spouse Red or Child instead of 1=Dependant spouse 2=Dependant child place of
6	GPIT_REF_SALARY	Number(17,6)	DECIMAL(16,6) NOT NULL	Salary of reference. It is mandatory in order to calculate the right Scaglioni to use.
7	GPIT_TDETR_ALTRED	Number(17,6)	DECIMAL(16,6) NOT NULL	Other income from depend. work
8	GPIT_ESENZ_ESP	Character(1)	VARCHAR2(1) NOT NULL	exempt taxation for assigee in/out Y/N Table Edit Default Value: N
9	GPIT_TDETR_DISAB	Character(1)	VARCHAR2(1) NOT NULL	Familiar Disable Y/N Table Edit Default Value: N
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: EUR Prompt Table: CURRENCY_CD_TBL
11	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A