GPDE_SI_REG_LNG

(SQL View)
 Index Back

Rellang for Region Prompt

Rellang for Region Prompt on EE SI Data

SELECT C.GPDE_SI_REGION , A.LANGUAGE_CD , A.EFFDT , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEMLANG A , PS_GPDE_SI_REG_VW C WHERE A.FIELDNAME = 'GPDE_SI_REGION' AND A.FIELDVALUE = C.GPDE_SI_REGION

  • Related Language Record for GPDE_SI_REG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPDE_SI_REGION Character(1) VARCHAR2(1) NOT NULL Region
    0=General
    1=East
    2=West
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description