GPFR_DVALVW_LNG

(SQL View)
 Index Back

Releated langauge view Data Ty

Releated langauge view for Data TYpe Codes. This is used as the prompt in the Update DSN Data pages.

SELECT A.COUNTRY ,A.GPFR_AF_APPL ,A.GPFR_DA_DATTYP ,A.GPFR_AF_APPL_VER ,A.GPFR_DA_CODE ,A.LANGUAGE_CD ,A.DESCR254 FROM PS_GPFR_DT_VAL_LNG A , PS_GPFR_DT_VALUES B WHERE A.COUNTRY=B.COUNTRY AND A.GPFR_AF_APPL=B.GPFR_AF_APPL AND A.GPFR_DA_DATTYP = B.GPFR_DA_DATTYP AND A.GPFR_AF_APPL_VER=B.GPFR_AF_APPL_VER AND A.GPFR_DA_CODE = B.GPFR_DA_CODE AND B.GPFR_DA_STATUS='A'

  • Related Language Record for GPFR_DT_VAL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: GPFR_DATA_TYPES.COUNTRY

    Prompt Table: COUNTRY_TBL

    2 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application

    Default Value: GPFR_DATA_TYPES.GPFR_AF_APPL

    Prompt Table: GPFR_AF_APPL

    3 GPFR_DA_DATTYP Character(10) VARCHAR2(10) NOT NULL DADS related field
    4 GPFR_AF_APPL_VER1 Number(8,0) INTEGER NOT NULL Application Framework - Application
    5 GPFR_DA_CODE Character(10) VARCHAR2(10) NOT NULL DADS related field
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254