RTROUNDO_RUNCTL(SQL Table) |
Index Back |
|---|---|
Retropay Undo RuncontrolRetropay Undo Runcontrol |
| # | 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 | RETRO_PAY_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Retro Processing Option
A=Online (All Employees) M=Mass Retro O=On or Off-Cycle Q=Selected Sequence Number S=Online (Selected Employees) Default Value: Q |
| 4 | MASS_ALL | Character(1) | VARCHAR2(1) NOT NULL |
Mass Retro Request Calculation Option
N=Selected Mass Retro Request ID Y=All Mass Retro Request IDs Default Value: N |
| 5 | MASS_RETRO_RQST_ID | Character(5) | VARCHAR2(5) NOT NULL |
Mass Retro Request ID
Prompt Table: MASS_RETRO_RQST |
| 6 | RUN_ID | Character(10) | VARCHAR2(10) NOT NULL |
Pay Run ID
Prompt Table: PAY_RUN_TBL |
| 7 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 8 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 9 | PAY_END_DT | Date(10) | DATE |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
| 10 | UNDO_TO_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Specifies the status to which retro request should be changed
C=Calculated N=Not Processed W=Cancelled/ Withdrawn Default Value: C |
| 11 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |