OPRIDRUN_CNTL_IDPAY_ENTITYPrompt Table: GPNZ_RCN_P_VW
10=Calendar Group
20=Payment Date
10=Employee Detail
20=Organizational Summary
Prompt Table: GPNZ_RCN_CAL_VW
Prompt Table: GPNZ_RCN_PD_VW
Prompt Table: GPNZ_LIS_SET_VW
Y/N Table Edit
GPNZ_RCN_RC(SQL Table) |
Index Back |
|---|---|
PDR Recon RunControl RecordGPNZL - PDR Recon RunControl Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GPNZ_RCN_P_VW |
| 4 | GPNZ_RCN_RUN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Reconciliaiton Run by parameters
10=Calendar Group 20=Payment Date |
| 5 | GPNZ_RCN_RPT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
report run by parameters for reconciliaiton
10=Employee Detail 20=Organizational Summary |
| 6 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPNZ_RCN_CAL_VW |
| 7 | PYMT_DT | Date(10) | DATE |
Payment Date
Prompt Table: GPNZ_RCN_PD_VW |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 9 | COUNTRY2 | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 10 | GP_ELN_SET | Character(15) | VARCHAR2(15) NOT NULL |
Element Set
Prompt Table: GPNZ_LIS_SET_VW |
| 11 | GPNZ_RCN_VR | Character(2) | VARCHAR2(2) NOT NULL |
Field created for GPNZL - Recon report
Y/N Table Edit |