EMPLIDBENEFIT_PLANPA_PLAN_DT_VW(SQL View) |
Index Back |
|---|---|
Plan date tbl + description |
| select a.emplid ,a.benefit_plan ,a.effdt ,b.descr ,a.curr_elig_dt ,a.curr_prtc_dt ,a.erly_ret_red_dt ,a.norm_ret_dt ,a.vesting_dt from ps_pa_plan_dt_tbl a ,PS_PA_PEN_PLAN_VW b where a.benefit_plan = b.benefit_plan |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | CURR_ELIG_DT | Date(10) | DATE | Current Eligibility |
| 6 | CURR_PRTC_DT | Date(10) | DATE | Current Participation Date |
| 7 | ERLY_RET_RED_DT | Date(10) | DATE | Early Ret Date - Reduced |
| 8 | NORM_RET_DT | Date(10) | DATE | Normal Retirement Date |
| 9 | VESTING_DT | Date(10) | DATE | Date of First Vesting |