GVT_AUTH_VL2_VW

(SQL View)
 Index Back

NOA/Authority 1 Validation

Used as prompt record for Authrority 1 and Authority 2 fields

SELECT A.GVT_NOA_CODE , A.GVT_LEGAL_AUTH , A.EFFDT , A.EFF_STATUS , B.DESCR25 || B.DESCR25_2 , B.DESCR25 || B.DESCR25_2 FROM PS_GVT_AUTH_VAL_1 A , PS_GVT_LEGAL_AUTH B WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_GVT_AUTH_VAL_1 A_ED WHERE A.GVT_NOA_CODE = A_ED.GVT_NOA_CODE AND A.GVT_LEGAL_AUTH = A_ED.GVT_LEGAL_AUTH AND A_ED.EFFDT <= %CurrentDateIn AND A.EFF_STATUS='A' ) AND A.GVT_LEGAL_AUTH = B.GVT_LEGAL_AUTH AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_GVT_LEGAL_AUTH B_ED WHERE B.GVT_LEGAL_AUTH = B_ED.GVT_LEGAL_AUTH AND B_ED.EFFDT <= A.EFFDT)

  • Related Language Record: GVT_AUTH_LN2_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
    2 GVT_LEGAL_AUTH Character(3) VARCHAR2(3) NOT NULL Legal Authority Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 GVT_PAR_AUTH_1_DES Character(50) VARCHAR2(50) NOT NULL Authority 1 Description
    6 GVT_PAR_AUTH_2_DES Character(50) VARCHAR2(50) NOT NULL Authority 1 Description