BENEFIT_PLANEFFDTDefault Value: PA_PROC.EFFDT
PROC_SEQ_NUMC=Custom Statement
R=Function Result
U=User Code
E=Exposed
I=Internal
Default Value: I
E=Excluded
I=Installed
Default Value: I
Y/N Table Edit
Default Value: N
PA_PROC_USE_VW(SQL View) |
Index Back |
|---|---|
View of Pa Proc Use |
| select benefit_plan ,effdt ,proc_seq_num ,proc_type ,proc_name ,proc_exec_ord_num ,expose_int_cd ,proc_install_cd ,fld_cnt ,descr ,proc_prev_elig_cd from PS_PA_PROC_USE where functn_name <> 'CONSOLIDTE' and functn_name <> 'CONSOLIDTH' and functn_name <> 'CONSOLIDTC' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: PA_PROC.EFFDT |
| 3 | PROC_SEQ_NUM |
Number(4,0) | SMALLINT NOT NULL | Auto Process Sequence |
| 4 | PROC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Process Type
C=Custom Statement R=Function Result U=User Code |
| 5 | PROC_NAME | Character(10) | VARCHAR2(10) NOT NULL | Process Name |
| 6 | PROC_EXEC_ORD_NUM | Number(3,0) | SMALLINT NOT NULL | Process Execution Order Number |
| 7 | EXPOSE_INT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Panel Exposed/Internal Func
E=Exposed I=Internal Default Value: I |
| 8 | PROC_INSTALL_CD | Character(1) | VARCHAR2(1) NOT NULL |
Process Installed Code
E=Excluded I=Installed Default Value: I |
| 9 | FLD_CNT | Number(3,0) | SMALLINT NOT NULL | Field Count |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | PROC_PREV_ELIG_CD | Character(1) | VARCHAR2(1) NOT NULL |
Process Previously Eligible Co
Y/N Table Edit Default Value: N |