PA_SP_BNC_DFLTS(SQL View) |
Index Back |
|---|---|
Calculation Inputs by PlanThis is a parameter table containing Calc Input Parameters which are plan specific. |
| SELECT PA_SP_CLC_TYPE ,EFFDT ,CONT_ASMP_PCT ,CALC_ALL_PLANS_CD ,VERBOSE_MODE ,EXT_EMPL_DATA_IND ,PA_SVC_RESTORE ,WAGE_BASE_ESCAL_RT ,CPI_ASMP_INC_PCT ,ALLOW_USER_SALARY ,SALSC_ASMP_INC_LIM ,WAGE_SALSC_ADJ_PCT ,BEN_CMCMNT_AGE_LIM ,PA_WEB_RETENTION FROM PS_PA_SP_CLC_DFLTS WHERE PA_SP_CLC_TYPE = 'B' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PA_SP_CLC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
SP Calculation Type
B=Benefit Calculation C=Cost Calculation |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | CONT_ASMP_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Assumed Contributions Pct |
| 4 | CALC_ALL_PLANS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Calculate All Plans
Y/N Table Edit Default Value: N |
| 5 | VERBOSE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Detailed Worksheet
Y/N Table Edit Default Value: N |
| 6 | EXT_EMPL_DATA_IND | Character(1) | VARCHAR2(1) NOT NULL |
Load External Employee Data
Y/N Table Edit Default Value: N |
| 7 | PA_SVC_RESTORE | Character(1) | VARCHAR2(1) NOT NULL |
Grant Full Service Credit
Y/N Table Edit Default Value: N |
| 8 | WAGE_BASE_ESCAL_RT | Number(6,2) | DECIMAL(5,2) NOT NULL | Wage Base Escalation Rate |
| 9 | CPI_ASMP_INC_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | CPI Percent Increase |
| 10 | ALLOW_USER_SALARY | Character(1) | VARCHAR2(1) NOT NULL |
Allow User Salary Increase
Y/N Table Edit Default Value: N |
| 11 | SALSC_ASMP_INC_LIM | Number(5,2) | DECIMAL(4,2) NOT NULL | Max Salary Increase Percent |
| 12 | WAGE_SALSC_ADJ_PCT | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | Percent Salary Increase |
| 13 | BEN_CMCMNT_AGE_LIM | Number(5,2) | DECIMAL(4,2) NOT NULL | Maximum BCD Age/YY.MM |
| 14 | PA_WEB_RETENTION | Number(2,0) | SMALLINT NOT NULL |
Web Results Retention Months
Default Value: 14 |