RDEDEXTR_RUNCTL(SQL Table) |
Index Back |
|---|---|
Retro Ded Extract Run ControlThis is the run control used in the Retro Deductions extract/calc process. |
| # | 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 | BATCH_RUN_ID | Character(10) | VARCHAR2(10) NOT NULL | Batch Run ID |
| 4 | PROCESS_INDIVIDUAL | Character(1) | VARCHAR2(1) NOT NULL |
Process Individual Retro
Y/N Table Edit Default Value: N |
| 5 | INDIVIDUAL_ALL | Character(1) | VARCHAR2(1) NOT NULL |
All Individual
Y/N Table Edit Default Value: N |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: RETRODED_RQE_VW |
| 7 | PROCESS_MASS | Character(1) | VARCHAR2(1) NOT NULL |
Process Mass Retro ?
Y/N Table Edit Default Value: N |
| 8 | 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 Y/N Table Edit Default Value: N |
| 9 | MASS_RETRO_RQST_ID | Character(5) | VARCHAR2(5) NOT NULL |
Mass Retro Request ID
Prompt Table: RETRODEDMAS_VW |