GVT_FA_CANDT_VW

(SQL View)
 Index Back

Cancel Info for Fluid Approval

This view would fetch information required to display the PAR cancellation information in fluid approvals.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , PC.GVT_NOA_CODE , NOAC.DESCR25 , PC.GVT_LEG_AUTH_1 , PC.GVT_PAR_AUTH_D1 ||' ' || PC.GVT_PAR_AUTH_D1_2 , PC.GVT_LEG_AUTH_2 , PC.GVT_PAR_AUTH_D2 || ' ' || PC.GVT_PAR_AUTH_D2_2 FROM PS_GVT_JOB A , PS_GVT_PAR_CANCEL PC , PS_GVT_NOAC_TBL NOAC WHERE A.EMPLID = PC.EMPLID AND A.EMPL_RCD = PC.EMPL_RCD AND A.EFFDT = PC.EFFDT AND A.EFFSEQ = PC.EFFSEQ AND A.ACTION = NOAC.ACTION AND A.GVT_NOA_CODE = NOAC.GVT_NOA_CODE AND %EffdtCheck(GVT_NOAC_TBL,NOAC,A.EFFDT) AND NOAC.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: NEW

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
6 DESCR25 Character(25) VARCHAR2(25) NOT NULL Short description
7 GVT_LEG_AUTH_1 Character(3) VARCHAR2(3) NOT NULL Legal Authority (1)
8 GVT_PAR_AUTH_1_DES Character(50) VARCHAR2(50) NOT NULL Authority 1 Description
9 GVT_LEG_AUTH_2 Character(3) VARCHAR2(3) NOT NULL Legal Authority (2)
10 GVT_PAR_AUTH_2_DES Character(50) VARCHAR2(50) NOT NULL Authority 1 Description