GVT_AUTH_LNG_VW

(SQL View)
Index Back

NOA/Authority 1 Validation

Related Language view for GVT_AUTH_VAL_VW.

SELECT A.GVT_NOA_CODE , A.GVT_LEGAL_AUTH , A.EFFDT , B.LANGUAGE_CD , B.DESCR25 , B.DESCR25_2 FROM PS_GVT_AUTH_VAL_1 A , PS_GVT_LEGAL_LANG B WHERE A.GVT_LEGAL_AUTH = B.GVT_LEGAL_AUTH AND A.EFFDT = B.EFFDT

  • Related Language Record for GVT_AUTH_CAN_VW GVT_AUTH_VAL_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR25 Character(25) VARCHAR2(25) NOT NULL Description - Part 1
    6 DESCR25_2 Character(25) VARCHAR2(25) NOT NULL Description - Part 2