UPG_PRFLD_COPY

(SQL Table)
Index Back

Upgrade: Pension

This is a temp table clone of PA_CLC_PRFLD_1 for use during data conversion.

# 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 EFFDT Date(10) DATE Effective Date
7 FUNCTN_NAME Character(10) VARCHAR2(10) NOT NULL Function Name
8 FUNCTN_SEQ_NUM Number(3,0) SMALLINT NOT NULL Function Sequence Number
9 FLD_SEQ_NUM Number(3,0) SMALLINT NOT NULL Field Sequence Number
10 PROC_NAME Character(10) VARCHAR2(10) NOT NULL Process Name
11 FLD_NAME Character(18) VARCHAR2(18) NOT NULL Field Name
12 FLD_PICTURE Character(10) VARCHAR2(10) NOT NULL Picture Format
13 FLD_TYPE Character(1) VARCHAR2(1) NOT NULL Field Type
14 FLD_TYPE_CHAR Character(4) VARCHAR2(4) NOT NULL Character Value
15 FLD_TYPE_DEC Number(16,6) DECIMAL(15,6) NOT NULL Decimal Value
16 FLD_TYPE_DATE Date(10) DATE Date Value
17 FLD_CODE Character(1) VARCHAR2(1) NOT NULL Field Code

Default Value: N

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

Y/N Table Edit

Default Value: N