PENSION_PLN_TBL(SQL Table) |
Index Back |
|---|---|
Pension Benefit Plan ParametrsPENSION_PLN_TBL is a record that defines the attributes of a Canadian pension plan, including type of pension and contribution parameters (employer vs. employee percentages). The contribution rates applicable to a plan are defined separately on associated PENSION_RTE_TBL records. Both record types are populated online through the Pension Plan Table panel. |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | ERNCD_SPCL | Character(3) | VARCHAR2(3) NOT NULL |
Special Accumulator Code
Prompt Table: SPCL_EARNS_TBL |
| 5 | PENS_RT_TBL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Pension Rate Table Type
F=Fixed Rate N=None S=Slide Rate Default Value: N |
| 6 | EE_PCT_UNDER_YMPE | Number(7,3) | DECIMAL(6,3) NOT NULL | Contributions Up To YMPE |
| 7 | ER_PCT_UNDER_YMPE | Number(7,3) | DECIMAL(6,3) NOT NULL | ER Pct for Earns under YMPE |
| 8 | EE_PCT_OVER_YMPE | Number(7,3) | DECIMAL(6,3) NOT NULL | Contributions Over YMPE |
| 9 | ER_PCT_OVER_YMPE | Number(7,3) | DECIMAL(6,3) NOT NULL | ER Pct for Earns over YMPE |
| 10 | PCT_UP_TO_STEP | Number(7,3) | DECIMAL(6,3) NOT NULL | Pct up to Contribution Step |
| 11 | PCT_OVER_STEP | Number(7,3) | DECIMAL(6,3) NOT NULL | Pct Over Contribution Step |
| 12 | COORDINATE_CPP | Character(1) | VARCHAR2(1) NOT NULL |
Coordinate with CPP
Y/N Table Edit Default Value: N |
| 13 | VOLUN_CNTR_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL |
Voluntary Contributns Allowed
Y/N Table Edit Default Value: N |
| 14 | PENSION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Pension Type
B=Defined Benefit M=Money Purchase N=Non Qualified Q=Qualified |
| 15 | PLAN_REG_NO | Character(11) | VARCHAR2(11) NOT NULL | Plan Registration Number |
| 16 | PENSION_YTD_BASED | Character(1) | VARCHAR2(1) NOT NULL |
Based on Actual YTD
Y/N Table Edit Default Value: N |
| 17 | PA_PCT_UNDER_YMPE | Number(7,3) | DECIMAL(6,3) NOT NULL | PA Pct for Earns Under YMPE |
| 18 | PA_PCT_OVER_YMPE | Number(7,3) | DECIMAL(6,3) NOT NULL | PA Pct for Earns over YMPE |
| 19 | PA_EXCLUDE_FROM | Number(10,2) | DECIMAL(9,2) NOT NULL | PA Exclude Earnings From |
| 20 | PA_EXCLUDE_TO | Number(10,2) | DECIMAL(9,2) NOT NULL | PA Exclude Earnings To |
| 21 | PA_BEN_ENT_CEILING | Number(10,2) | DECIMAL(9,2) NOT NULL | PA Benefit Entitlement Ceiling |
| 22 | PA_ANNUAL_BASE_HRS | Number(8,2) | DECIMAL(7,2) NOT NULL | PA Annual Base Hours |
| 23 | PLN_YR_BEGIN_MONTH | Number(2,0) | SMALLINT NOT NULL |
Month Plan Year Begins
Default Value: 1 |
| 24 | PLN_YR_BEGIN_DAY | Number(2,0) | SMALLINT NOT NULL |
Day Plan Year Begins
Default Value: 1 |
| 25 | PLN_YR_END_MONTH | Number(2,0) | SMALLINT NOT NULL |
Month Plan Year Ends
Default Value: 12 |
| 26 | PLN_YR_END_DAY | Number(2,0) | SMALLINT NOT NULL |
Day Plan Year Ends
Default Value: 31 |
| 27 | PEN_CNTRB_STEP | Number(11,0) | DECIMAL(11) NOT NULL | Pension Contribution Step |
| 28 | PA_CB_CONT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow Contingent Beneficiaries
Y/N Table Edit Default Value: N |
| 29 | PA_MDIB_RULE | Character(1) | VARCHAR2(1) NOT NULL |
MDIB Rule Should Apply
Y/N Table Edit Default Value: N |
| 30 | PA_MDIB_AGE_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
MDIB Age Difference
Prompt Table: PA_ALIAS_USE |