UPG_PLIST_COPY

(SQL Table)
Index Back

Upgrade: Pension

This is a temp table clone of PA_CLC_PROCLIST 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 EFFDT Date(10) DATE Effective Date

Default Value: PA_PROC.EFFDT

5 PROC_EXEC_ORD_NUM Number(3,0) SMALLINT NOT NULL Process Execution Order Number
6 PROC_SEQ_NUM Number(4,0) SMALLINT NOT NULL Auto Process Sequence
7 PROC_TYPE Character(1) VARCHAR2(1) NOT NULL Process Type
C=Custom Statement
R=Function Result
U=User Code
8 PROC_NAME Character(10) VARCHAR2(10) NOT NULL Process Name
9 EXPOSE_INT_CD Character(1) VARCHAR2(1) NOT NULL Panel Exposed/Internal Func
E=Exposed
I=Internal

Default Value: I

10 FLD_CNT Number(3,0) SMALLINT NOT NULL Field Count
11 PROC_PREV_ELIG_CD Character(1) VARCHAR2(1) NOT NULL Process Previously Eligible Co

Y/N Table Edit

Default Value: N

12 EXEC_ONLY_CD Character(1) VARCHAR2(1) NOT NULL Execute

Y/N Table Edit

Default Value: N

13 OVERRIDE_IND Character(1) VARCHAR2(1) NOT NULL Override Indicator
14 DESCR Character(30) VARCHAR2(30) NOT NULL Description