PA_SSV_DEFAULTS

(SQL Table)
Index Back

Web Calc Default Parameters

This 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