OPRIDRUN_CNTL_IDPrompt Table: RDED_LOADED_VW
A=Benefits Administration
B=Benefit Deduction
G=General Deduction
J=Job Change
M=Mass Request
P=Benefit Program Change
E=Employee ID
T=Request Type
Default Value: E
RDEDSQR_RUNCTL(SQL Table) |
Index Back |
|---|---|
RetroDed Request Rpt Run CntlThis is the run control used in the Retro Deductions report SQRs. |
| # | 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_END_DT | Date(10) | DATE |
Retro Pay - Pay End Date
Prompt Table: RDED_LOADED_VW |
| 4 | RETRODED_RQST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Retro Ded Request Type
A=Benefits Administration B=Benefit Deduction G=General Deduction J=Job Change M=Mass Request P=Benefit Program Change |
| 5 | RDEDSQR_SORT | Character(1) | VARCHAR2(1) NOT NULL |
Sort Class for Retroded SQR
E=Employee ID T=Request Type Default Value: E |