OPRIDRUN_CNTL_IDPLAN_TYPEDEDCDPrompt Table: DEDUCTION_TBL
DED_CLASSA=After-Tax
B=Before-Tax
L=QC Taxable Benefit
N=Nontaxable Benefit
P=Nontaxable Btax Benefit
T=Taxable Benefit
RC_TAX960MA(SQL Table) |
Index Back |
|---|---|
TAX960ST.SQR - MAAdditional Run Control for TAX960ST for Massachusetts. Users can choose the Deduction Codes that will be included in Retirement Contributions. |
| # | 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 | 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. |
| 4 | DEDCD |
Character(6) | VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table: DEDUCTION_TBL |
| 5 | DED_CLASS |
Character(1) | VARCHAR2(1) NOT NULL |
Deduction Classification
A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit |