GPFR_DACDVW_LNG

(SQL View)
 Index Back

Releated langauge view DADS

Releated langauge view for DADS Codes. This is used as the prompt in the DADS update pages.

SELECT A.GPFR_DA_DATTYP , A.GPFR_DA_CODE , A.LANGUAGE_CD , A.GPFR_DA_DESCR FROM PS_GPFR_DA_COD_LNG A , PS_GPFR_DA_CODE B WHERE A.GPFR_DA_DATTYP = B.GPFR_DA_DATTYP AND A.GPFR_DA_CODE = B.GPFR_DA_CODE AND B.GPFR_DA_STATUS = 'A'

  • Related Language Record for GPFR_DA_CODE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_DA_DATTYP Character(10) VARCHAR2(10) NOT NULL DADS related field
    2 GPFR_DA_CODE Character(10) VARCHAR2(10) NOT NULL DADS related field
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field