PLAN_TYPEBENEFIT_PLANPrompt Table: BENEF_PLAN_TBL
DEDCDPY_MOD_BENDEDVW(SQL View) |
Index Back |
|---|---|
Current Deductions in Ben PlanThis view is used to show all deductions in the currently in a benefit plan. |
| SELECT DISTINCT B.Plan_Type ,B.Benefit_Plan ,B.Dedcd ,C.Descr ,C.Descrshort FROM PS_Ben_Defn_Optn B , PS_DEDUCTION_TBL C WHERE (B.EffDt = ( SELECT MAX(X.EffDt) FROM PS_Ben_Defn_Optn X WHERE X.Plan_Type = B.Plan_Type AND X.Benefit_Plan = B.Benefit_Plan AND X.Dedcd = B.Dedcd AND X.EffDt <= %CurrentDateIn)) AND C.Plan_Type = B.Plan_Type AND C.Dedcd = B.Dedcd AND (C.EffDt = ( SELECT MAX(D.EffDt) FROM PS_DEDUCTION_TBL D WHERE D.Plan_Type = C.Plan_Type AND D.Dedcd = C.Dedcd AND D.EffDt <= B.EffDt)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: BENEF_PLAN_TBL |
| 3 | DEDCD |
Character(6) | VARCHAR2(6) NOT NULL | Deduction Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |