GVT_LEGA_LNG_VW

(SQL View)
 Index Back

View of Legal Authority Tbl

This is a view of the legal authority table. Its fields are used as related-display fields on the GVT_JOB_DATA0 panel to populate the GVT_PAR_AUTH_D2 and GVT_PAR_AUTH_D2_2 fields. Related Language view for GVT_LEG_AUTH_VW.

SELECT A.GVT_LEGAL_AUTH, A.EFFDT, AL.LANGUAGE_CD, AL.DESCR25, AL.DESCR25_2 FROM PS_GVT_LEGAL_AUTH A, PS_GVT_LEGAL_LANG AL WHERE A.GVT_LEGAL_AUTH = AL.GVT_LEGAL_AUTH AND A.EFFDT = AL.EFFDT

  • Related Language Record for GVT_LEG_AUTH_VW

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

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR25 Character(25) VARCHAR2(25) NOT NULL Short description
    5 DESCR25_2 Character(25) VARCHAR2(25) NOT NULL Description part 2