GP_PIN_CHART_VW

(SQL View)
 Index Back

Prompt View for Chart Fields

This is used for the Chart Fields prompt view. Prompts for all system elements and variable elements with the chart field indicator set to 'Y'. In addition, the sub-record with the EFFDT field is used because the variable elements are effectived dated whereas system elements are not effectived dated. Therefore, a dummy date and effective status for system element were joined.

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

  • Related Language Record: GP_PIN_CHRT_LVW

    • # 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 EFFDT Date(10) DATE Effective Date
    4 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code