CALC_NAMERUN_CNTL_IDEMPLIDBENEFIT_PLANPA_SUMMARY_PLAN(SQL Table) |
Index Back |
|---|---|
Calculation RecapThis is a system table for the Calculation Recap. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALC_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Calculation Name |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 5 | PLAN_QUAL | Character(1) | VARCHAR2(1) NOT NULL | Qualified Plan Count |
| 6 | PLAN_NONQUAL | Character(1) | VARCHAR2(1) NOT NULL | Non Qualified Plan Count |
| 7 | PLAN_415 | Character(1) | VARCHAR2(1) NOT NULL | Plans limted by 415 |
| 8 | PLAN_QDRO | Character(1) | VARCHAR2(1) NOT NULL | Plan Limited by QDRO |
| 9 | PLAN_NORM_FORM | Number(12,2) | DECIMAL(11,2) NOT NULL | Plan Normal Form Amount |