CAF_CONFIGFL_VW

(SQL View)
 Index Back

SELECT C1.CAF_CONFIG_TYPE , C1.CAF_CONFIG_ID , C1.CAF_CONFIG_TITLE , C1.CAF_ENTITY_NAME , C1.CAF_CMP_MENUNAME , C1.CAF_OBJECTOWNERID FROM PS_CAF_CONFIG_TBL C1 WHERE C1.EFF_STATUS = 'A' AND NOT EXISTS ( SELECT 'X' FROM PS_CAF_CFG_FL_TBL C2 WHERE C1.CAF_CONFIG_TYPE = C2.CAF_CONFIG_TYPE AND C1.CAF_CONFIG_ID = C2.CAF_CONFIG_ID )

  • Related Language Record: CAF_CONFIG_LVW

    • # 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

    Default Value: USER

    2 CAF_CONFIG_ID Character(30) VARCHAR2(30) NOT NULL Analysis ID

    Prompt Table: CAF_CONFIG_VW

    3 CAF_CONFIG_TITLE Character(80) VARCHAR2(80) NOT NULL Analysis Title
    4 CAF_ENTITY_NAME Character(80) VARCHAR2(80) NOT NULL Entity Label
    5 CAF_CMP_MENUNAME Character(30) VARCHAR2(30) NOT NULL Display Menu Name

    Prompt Table: PSMENUDEFN

    6 CAF_OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Additional valid values are from OBJECTOWNERID

    Prompt Table: CAF_OBJOWNID_VW