GPNZ_PDR_RC(SQL Table) |
Index Back |
|---|---|
Run CNTL- Process CR8 PRD DataRun control record for Process Create prd data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 3 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GPNZ_PAYET_DVW |
| 4 | GPNZ_PDR_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Year code |
| 5 | GPNZ_PDR_PRC | Character(2) | VARCHAR2(2) NOT NULL |
Process By field for PDR
CG=Calendar Group ID EM=Employee ID GL=Group List PE=Pay Entity PG=Pay Group SL=Stream List Default Value: PE |
| 6 | PYMT_DT | Date(10) | DATE | Payment Date |
| 7 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPNZ_PDR_CA_DVW |
| 8 | GROUP_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL |
Group List
Prompt Table: GP_GRP_LIST_VW |
| 9 | GPNZ_PDR_RNTYP | Character(3) | VARCHAR2(3) NOT NULL |
PDR Run Type
AMD=Amendment NRM=Original OVR=Override Default Value: NRM |