BENEFIT_PLANE=Exposed
I=Internal
Default Value: I
E=Excluded
I=Installed
Default Value: I
Y/N Table Edit
Default Value: N
PA_FR_PROCUSE_V(SQL View) |
Index Back |
|---|---|
Functn Reslt View for Proc Use |
| select a.benefit_plan, b.functn_name, b.functn_seq_num, a.functn_result_nm, b.expose_int_cd, b.proc_install_cd, b.fld_cnt, a.descr, b.proc_prev_elig_cd from ps_pa_fnc_rslt_tbl a, PS_PA_FUNCTN b where a.functn_name=b.functn_name |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 2 | FUNCTN_NAME | Character(10) | VARCHAR2(10) NOT NULL | Function Name |
| 3 | FUNCTN_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Function Sequence Number |
| 4 | FUNCTN_RESULT_NM | Character(10) | VARCHAR2(10) NOT NULL | Function Result Name |
| 5 | EXPOSE_INT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Panel Exposed/Internal Functn
E=Exposed I=Internal Default Value: I |
| 6 | PROC_INSTALL_CD | Character(1) | VARCHAR2(1) NOT NULL |
Process Installed Code
E=Excluded I=Installed Default Value: I |
| 7 | FLD_CNT | Number(3,0) | SMALLINT NOT NULL | Field Count |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | PROC_PREV_ELIG_CD | Character(1) | VARCHAR2(1) NOT NULL |
Process Previously Eligible Co
Y/N Table Edit Default Value: N |