EMPLIDPrompt Table: PERSONAL_DATA
GPCH_SI_PROV_CDPrompt Table: GPCH_PK_PROV2VW
GPCH_PK_EIFJH_WGPCH_PK_EIPIBPAY_ENTITYPrompt Table: GP_PYENT
GPCH_AL_CPAY_ENDDTPrompt Table: GPCH_RP_DATE_VW
GPCH_PK_IND_VW(SQL View) |
Index Back |
|---|---|
Upload Staging TablePension Interface Upload Staging Table |
| SELECT EMPLID , GPCH_SI_PROV_CD , GPCH_PK_EIFJH_W , GPCH_PK_EIPIB , PAY_ENTITY , GPCH_AL_CPAY_ENDDT FROM %Table(GPCH_RP_PK021) WHERE GPCH_SI_PROV_TYPE = '6' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | GPCH_SI_PROV_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Provider Code
Prompt Table: GPCH_PK_PROV2VW |
| 3 | GPCH_PK_EIFJH_W |
Date(10) | DATE NOT NULL | Billing date |
| 4 | GPCH_PK_EIPIB |
Character(10) | VARCHAR2(10) NOT NULL | Emplid |
| 5 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
| 6 | GPCH_AL_CPAY_ENDDT |
Date(10) | DATE NOT NULL |
Current Pay End Date
Prompt Table: GPCH_RP_DATE_VW |