GPCH_CA_DTMP4

(SQL Table)
Index Back

Child Allowance Temp Record

Child Allowance Temp Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

Prompt Table: GPCH_CA_DATA_VW

3 GPCH_EA_DATEFROM Date(10) DATE Begin Date
4 GPCH_CA_TYPE Number(2,0) SMALLINT NOT NULL Field to store Allowance Type.
5 GPCH_CA_CR_STORNO Character(2) VARCHAR2(2) NOT NULL Reduced End Date
6 GPCH_EA_AMOUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
7 GPCH_EA_DATETO Date(10) DATE Begin Date Maternity
8 GPCH_CA_RELATION Character(2) VARCHAR2(2) NOT NULL Field for Family Relationship.
10=Mother
11=Stepmother
12=FosterMother
13=Sister
14=GrandMother
20=Father
21=Stepfather
22=FosterFather
23=Brother
24=Grandfather
9 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
10 GPCH_CA_CA_ELIG Character(1) VARCHAR2(1) NOT NULL Child Allowance
11 BIRTHDATE Date(10) DATE Date of Birth
12 NAME Character(50) VARCHAR2(50) NOT NULL Name
13 STUDENT Character(1) VARCHAR2(1) NOT NULL Student
N=No
Y=Yes

Y/N Table Edit

14 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

Y/N Table Edit

15 GPCH_EA_PERIODEAMO Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
16 GPCH_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL Pay Year
17 EXCLUDE Character(1) VARCHAR2(1) NOT NULL Exclude

Y/N Table Edit