GPCH_CA_DTMP4(SQL Table) |
Index Back |
---|---|
Child Allowance Temp RecordChild 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 |