CAF_FCT_PVPT_VW

(SQL View)
 Index Back

Prompt Fields of PVG factors

This view is used as prompt table of CAF_FCT_PVPTTBL. It contains the prompt fields of the Pivot Grids used by CAF factors.

SELECT DISTINCT F.CAF_CONFIG_TYPE , F.CAF_CONFIG_ID , F.CAF_FACTOR_ID , F.PTPPB_PAGELET_ID , S.PTPPB_VALUE , PT.PTPG_UNIQPROMPFLD , PT.PTPG_QRYPROMPNAME , PT.FIELDNAME FROM PS_CAF_FACTOR_TBL F , PS_PTPPB_DS_SETTGS S ,PSPGQRYPROMPT PT WHERE F.CAF_FACTOR_TYPE = 'PG' AND F.PTPPB_PAGELET_ID = S.PTPPB_PAGELET_ID AND F.EFF_STATUS = 'A' AND S.PTPPB_VALUE = PT.PTPG_PGRIDNAME AND PT.PTPG_VIEWNAME LIKE PT.PTPG_PGRIDNAME %Concat '%'

  • Parent record: CAF_CONFIG_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAF_CONFIG_TYPE Character(4) VARCHAR2(4) NOT NULL Analysis Type
    RTBL=Real Time Bottom Line
    SYS=System
    USER=User Defined
    2 CAF_CONFIG_ID Character(30) VARCHAR2(30) NOT NULL Analysis ID
    3 CAF_FACTOR_ID Character(30) VARCHAR2(30) NOT NULL Factor ID
    4 PTPPB_PAGELET_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID
    5 PTPPB_VALUE Character(150) VARCHAR2(150) NOT NULL Default Value
    6 PTPG_UNIQPROMPFLD Character(30) VARCHAR2(30) NOT NULL Unique Prompt Name
    7 PTPG_QRYPROMPNAME Character(30) VARCHAR2(30) NOT NULL Query Prompt Name
    8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).