PA_CLC_ADJUST

(SQL Table)
Index Back

Calc Input Adjustment Values

This is a parameter table containing Calc Input Adjustment Values which are plan specific.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CALC_NAME Character(20) VARCHAR2(20) NOT NULL Calculation Name
2 CALC_SEQ_NUM Number(9,0) DECIMAL(9) NOT NULL Calc Seq Num
3 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
4 PROC_EXEC_ORD_NUM Number(3,0) SMALLINT NOT NULL Process Execution Order Number
5 PROC_SEQ_NUM Number(4,0) SMALLINT NOT NULL Auto Process Sequence
6 FUNCTN_NAME Character(10) VARCHAR2(10) NOT NULL Function Name
7 FUNCTN_SEQ_NUM Number(3,0) SMALLINT NOT NULL Function Sequence Number
8 FLD_SEQ_NUM Number(3,0) SMALLINT NOT NULL Field Sequence Number
9 PROC_NAME Character(10) VARCHAR2(10) NOT NULL Process Name
10 FLD_NAME Character(18) VARCHAR2(18) NOT NULL Field Name
11 FLD_PICTURE Character(10) VARCHAR2(10) NOT NULL Picture Format
12 FLD_TYPE Character(1) VARCHAR2(1) NOT NULL Field Type
13 FLD_TYPE_SDEC Signed Number(17,6) DECIMAL(15,6) NOT NULL Fld Type Decimal
14 FLD_CODE Character(1) VARCHAR2(1) NOT NULL Field Code

Default Value: N

15 OVERRIDE_IND Character(1) VARCHAR2(1) NOT NULL Override Indicator

Y/N Table Edit

Default Value: N