BENEFIT_PLANPROC_SEQ_NUMEFFDTFUNCTN_NAMEFUNCTN_SEQ_NUMFLD_SEQ_NUMPA_PROC_FLD_VW(SQL View) |
Index Back |
|---|---|
Result Fields in Procs - New |
| SELECT A.BENEFIT_PLAN, A.PROC_SEQ_NUM, A.EFFDT, A.FUNCTN_NAME, A.FUNCTN_SEQ_NUM, A.FLD_SEQ_NUM, B.PROC_EXEC_ORD_NUM, B.PROC_NAME, A.FLD_NAME, A.FLD_PICTURE, A.FLD_TYPE, A.FLD_CODE FROM PS_PA_PROC_U_FLD_1 A, PS_PA_PROC_USE B WHERE A.BENEFIT_PLAN = B.BENEFIT_PLAN AND A.PROC_SEQ_NUM = B.PROC_SEQ_NUM AND A.EFFDT = B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 2 | PROC_SEQ_NUM |
Number(4,0) | SMALLINT NOT NULL | Auto Process Sequence |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | FUNCTN_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Function Name |
| 5 | FUNCTN_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Function Sequence Number |
| 6 | FLD_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Field Sequence Number |
| 7 | PROC_EXEC_ORD_NUM | Number(3,0) | SMALLINT NOT NULL | Process Execution Order Number |
| 8 | PROC_NAME | Character(10) | VARCHAR2(10) NOT NULL | Process Name |
| 9 | FLD_NAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 10 | FLD_PICTURE | Character(10) | VARCHAR2(10) NOT NULL | Picture Format |
| 11 | FLD_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Field Type |
| 12 | FLD_CODE | Character(1) | VARCHAR2(1) NOT NULL | Field Code |