GPCHDEP_TMP(SQL Table) |
Index Back |
---|---|
Dependent/Benef AllowancesGPCHDEP_TMP is used to hold sum of various allowances for a perticular year to be reported |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DEPENDENT_BENEF | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Prompt Table: DEPENDENT_VW |
2 | GPCH_RP_AMOUNT2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
3 | GPCH_RP_AMOUNT3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
4 | GPCH_RP_AMOUNT4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |