GPS_DEP_BEN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	GPS_CHILD_ALLOW_NR	Character(50)	VARCHAR2(50) NOT NULL	Child Allow. Nbr
3	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default Default Value: 01
4	HRDE_AI_VALIDC_DEU	Character(50)	VARCHAR2(50) NOT NULL	Accident Insurance Valid Characters.
5	GPDE_DV_TIME	Time(15)	TIMESTAMP	Timestamp for DateTime Comparisons. Default Value: %time
6	GPDE_AL_SEQCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence
7	ALLOW_IND	Character(1)	VARCHAR2(1) NOT NULL	Allow Y/N Table Edit Default Value: N
8	GPS_ALLOW_IND	Character(1)	VARCHAR2(1) NOT NULL	Child Allowance Eligiblity Type 0=Not Eligible 1=Eligible 2=Counting Child 3=Eligible with Correction 4=Correction
9	GPS_EMPLID_PAYEE	Character(11)	VARCHAR2(11) NOT NULL	Germanin Public Sector Employee. Prompt Table: PERSON_NAME
10	GPS_EMPL_RCD_PAYEE	Number(3,0)	SMALLINT NOT NULL	Employee Record: Employment to be paid out. Default Value: 0 Prompt Table: GPS_JOB_CURR_VW
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
12	GPS_BASE_AMOUNT	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Child Allownace Base Amount
13	GPS_CORR_AMOUNT	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Child Allownace Correction Amount. Used By ADP for Retro Purposes.