UPG_PLIST_COPY(SQL Table) |
Index Back |
---|---|
Upgrade: PensionThis 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 | Character(20) | VARCHAR2(20) NOT NULL | Calculation Name | |
2 | Number(9,0) | DECIMAL(9) NOT NULL | Calc Seq Num | |
3 | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan | |
4 | Date(10) | DATE |
Effective Date
Default Value: PA_PROC.EFFDT |
|
5 | Number(3,0) | SMALLINT NOT NULL | Process Execution Order Number | |
6 | 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 |