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 | PA_WEB_CALC_NAME | 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 |