PA_PROC_ADJ_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 AND ((A.FUNCTN_NAME = 'SERVICE' AND A.FLD_NAME = 'SERVICE_AMOUNT') OR (A.FUNCTN_NAME = 'BENCALC' AND A.FLD_NAME = 'BEN_AMT'))

# 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