PA_SSV_DEFAULTS(SQL Table) |
Index Back |
|---|---|
Web Calc Default ParametersThis is an one record table containing web calculation default parameters. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL |
Web Calculation Name
WEB=Web Calculation Defaults Default Value: WEB |
|
| 2 | ASOFDATE | Date(10) | DATE |
As of Date
Default Value: %date |
| 3 | CALC_ALL_PLANS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Calculate All Plans
Y/N Table Edit Default Value: Y |
| 4 | VERBOSE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Detailed Worksheet
Y/N Table Edit Default Value: Y |
| 5 | EXT_EMPL_DATA_IND | Character(1) | VARCHAR2(1) NOT NULL |
Load External Employee Data
Y/N Table Edit Default Value: N |
| 6 | PA_SVC_RESTORE | Character(1) | VARCHAR2(1) NOT NULL |
Grant Full Service Credit
Y/N Table Edit Default Value: N |
| 7 | HRS_ASSMP_AMT | Number(4,0) | SMALLINT NOT NULL | Hours Amount |
| 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_EARNS | Character(1) | VARCHAR2(1) NOT NULL |
Allow User Earnings
Y/N Table Edit Default Value: N |
| 11 | ALLOW_USER_HOURS | Character(1) | VARCHAR2(1) NOT NULL |
Allow User Hours
Y/N Table Edit Default Value: N |
| 12 | ALLOW_USER_SALARY | Character(1) | VARCHAR2(1) NOT NULL |
Allow User Salary Increase
Y/N Table Edit Default Value: N |
| 13 | EARN_ASSUMP_LIMIT | Number(16,2) | DECIMAL(15,2) NOT NULL | Maximum Earnings Amount |
| 14 | HRS_ASSMP_LIMIT | Number(4,0) | SMALLINT NOT NULL | Maximum Hours Amount |
| 15 | SALSC_ASMP_INC_LIM | Number(5,2) | DECIMAL(4,2) NOT NULL | Maximum Salary Increase |
| 16 | WAGE_SALSC_ADJ_PCT | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | Wage Base = Salary Increase + |
| 17 | BEN_CMCMNT_AGE_LIM | Number(5,2) | DECIMAL(4,2) NOT NULL | Maximum BCD Age/YY.MM |
| 18 | PA_WEB_RETENTION | Number(2,0) | SMALLINT NOT NULL |
Web Results Retention Months
Default Value: 14 |
| 19 | PA_WEB_INSTRUCT | Long Character | CLOB | Instructions to User |