GP_PIN_CHRT_LVW

(SQL View)
 Index Back

Rel.Lng View- Chart Field PINs

Related Langauge view for the Chart Field PINs.

SELECT CTRY.COUNTRY , PIN.PIN_NUM , LANG.LANGUAGE_CD , %DateIn('1900-01-01') , LANG.PIN_NM , LANG.DESCR FROM PS_GP_COUNTRY CTRY , PS_GP_PIN PIN , PS_GP_SYSTEM_PIN SYS , PS_GP_PIN_LANG LANG WHERE PIN.PIN_NUM < 50000000 AND (PIN.USED_BY = 'A' OR PIN.COUNTRY = CTRY.COUNTRY) AND PIN.PIN_NUM = SYS.PIN_NUM AND PIN.PIN_NUM = LANG.PIN_NUM AND SYS.CHART_FLD_IND = 'Y' UNION SELECT CTRY.COUNTRY , PIN.PIN_NUM , LANG.LANGUAGE_CD , VAR.EFFDT , LANG.PIN_NM , LANG.DESCR FROM PS_GP_COUNTRY CTRY , PS_GP_PIN PIN , PS_GP_VARIABLE VAR , PS_GP_PIN_LANG LANG WHERE PIN.PIN_NUM < 50000000 AND (PIN.USED_BY = 'A' OR PIN.COUNTRY = CTRY.COUNTRY) AND PIN.PIN_NUM = VAR.PIN_NUM AND PIN.PIN_NUM = LANG.PIN_NUM AND VAR.CHART_FLD_IND = 'Y' AND VAR.EFF_STATUS = 'A'

  • Related Language Record for GP_PIN_CHART_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE Effective Date
    5 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description