EMPLIDPrompt Table: PERSON
DEPENDENT_BENEF01=default
Prompt Table: GPCH_CA_DATA_VW
GPCH_CA_REFNBRO=Offset
S=System Generated
U=User Reported
GPCH_CA_XML_STR(SQL Table) |
Index Back |
|---|---|
Child Allowance View CHEOverrides for eAHV: ReferenceNbr and Exclude |
| # | 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_CA_REFNBR |
Character(20) | VARCHAR2(20) NOT NULL | Zentral Reg Reference Number |
| 4 | GPCH_CA_TYPE | Number(2,0) | SMALLINT NOT NULL | Field to store Allowance Type. |
| 5 | GPCH_CA_CR_BGN | Date(10) | DATE | Reduced End Date |
| 6 | GPCH_CA_CR_END | Date(10) | DATE | Reduced End Date |
| 7 | RUN_OPEN_TS | DateTime(26) | TIMESTAMP | Records the time when processing was first initiated for a given calendar group |
| 8 | RUN_FINALIZED_TS | DateTime(26) | TIMESTAMP | Finalized Timestamp |
| 9 | GPCH_CA_STRNO_DONE | Character(1) | VARCHAR2(1) NOT NULL | Reduced End Date |
| 10 | GPCH_EG_ISSU_DAT | Date(10) | DATE | Issued Date. |
| 11 | SOURCE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates the source of payable time.
S - system generated
U - User entered
O - Offset
O=Offset S=System Generated U=User Reported |