CALC_NAMEBENEFIT_PLANUPG_PA_CALC_MAP(SQL Table) |
Index Back |
|---|---|
Upgrade: PensionThis record is used during upgrade from 7.51 to 8.3. It is used by the client to "map" Pension calculations that have conflicting assumptions into new CALC_NAMEs. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALC_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Calculation Name |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 3 | UPG_NEW_CALC_NAME | Character(20) | VARCHAR2(20) NOT NULL | Map Conflicting Calculations |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | EARN_ASSUMP_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Earnings Amount |
| 6 | HRS_ASSMP_AMT | Number(4,0) | SMALLINT NOT NULL | Hours Amount |
| 7 | WAGE_BASE_ESCAL_RT | Number(6,2) | DECIMAL(5,2) NOT NULL | Wage Base Escalation Rate |
| 8 | SALSC_ASMP_INC_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Salary Scale Percent Increase |
| 9 | CPI_ASMP_INC_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | CPI Percent Increase |