EODP_PVTDSV_VW

(SQL View)
 Index Back

Data Source value Prompt

Data Source value Prompt in Pivot filter

SELECT PG.PTPG_DSVALUE , QD.DESCR FROM PSPGSETTINGS PG , PSQRYDEFN QD WHERE QD.QRYNAME = PG.PTPG_DSVALUE UNION SELECT PG.PTPG_DSVALUE ,PD.DESCR FROM PSPGSETTINGS PG , PSPNLGRPDEFN PD WHERE PD.PNLGRPNAME = PG.PTPG_DSVALUE

  • Related Language Record: EODP_PVTDSV_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTPG_DSVALUE Character(30) VARCHAR2(30) NOT NULL Data Source Value

    Prompt Table: %EDITTABLE

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description