BENEFIT_PROGRAMEFFDTDefault Value: %date
DEDCDBEN_PROG_GNLDED(SQL View) |
Index Back |
|---|---|
Cur General Deducts in BenProgThis view shows all general deductions active in the current benefit program. |
| SELECT A.Benefit_Program ,A.EffDt ,B.Dedcd ,C.Descr ,C.Descrshort FROM PS_BEN_DEFN_PGM A, PS_Ben_Defn_Optn B, PS_Deduction_Tbl C WHERE A.Benefit_Program = B.Benefit_Program AND A.Effdt = B.Effdt AND A.Eff_Status = 'A' AND B.Option_Type = 'D' 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 <= A.EffDt) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BENEFIT_PROGRAM |
Character(3) | VARCHAR2(3) NOT NULL | Defines a collection of benefit plans and their associated rate and calculation rules. |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 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 |