OPRIDRUN_CNTL_IDGTL_DPL_EFFECTD=Add to Dependent Life
G=Add to Group Term Life
N=No Imputed Income Calculated
Prompt Table: BENEF_PLAN_TBL
Prompt Table: DEDUCTION_TBL
IMP_GTL_DPL(SQL Table) |
Index Back |
|---|---|
Imputed Income Run ControlThe Imputed Income Calculation Run Control record manages the imputed income calculation 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 | GTL_DPL_EFFECT |
Character(1) | VARCHAR2(1) NOT NULL |
GTL/DPL Effect - Impute Income
D=Add to Dependent Life G=Add to Group Term Life N=No Imputed Income Calculated |
| 4 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 5 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: BENEF_PLAN_TBL |
| 6 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table: DEDUCTION_TBL |