CAF_ACTION_TBL

(SQL Table)
Index Back

  • Related Language Record: CAF_ACTION_LNG
  • 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_ACTION_ID Character(30) VARCHAR2(30) NOT NULL Action ID
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: I

    5 CAF_ACTION_NAME Character(48) VARCHAR2(48) NOT NULL Action Name
    6 CAF_ACTION_LVL Character(2) VARCHAR2(2) NOT NULL Action Level
    C=Analysis
    D=Factor Data
    E=Entity
    ES=Selected Entities
    F=Factor
    FS=Common Factors
    7 CAF_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Action Type
    A=App Class
    C=Component
    F=Filter

    Default Value: C

    8 CAF_ACT_HANDLER_ID Character(30) VARCHAR2(30) NOT NULL Action Handler

    Prompt Table: CAF_HNDLR_A_VW

    9 CAF_ACT_HNDLR_PARM Character(254) VARCHAR2(254) NOT NULL Action Handler Parameter
    10 CAF_FACTOR_ID Character(30) VARCHAR2(30) NOT NULL Factor ID

    Prompt Table: CAF_FACTOR_TBL

    11 CAF_CONFIG_FLG Character(1) VARCHAR2(1) NOT NULL Configure Action

    Y/N Table Edit

    12 CAF_ENT_KEY_MAP Character(254) VARCHAR2(254) NOT NULL Key Map
    13 CAF_MODE_USED_FLG Character(1) VARCHAR2(1) NOT NULL Used in Mode
    A=Analysis
    B=Both
    C=Comparison

    Default Value: B

    14 CAF_NAVIGATE_TYPE Character(1) VARCHAR2(1) NOT NULL Navigation Type
    M=Modal
    N=New Page
    R=Replace Page

    Default Value: M

    15 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    16 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

    Prompt Table: PRCSBARNAME_VW

    17 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

    Prompt Table: PSMENUITEM_VW2

    18 ITEMPANELNAME Character(30) VARCHAR2(30) NOT NULL Panel Name
    19 MENU_ACTION Character(1) VARCHAR2(1) NOT NULL Menu Action

    Prompt Table: CAF_MENU_ACT_VW

    20 FILTER_ID Character(10) VARCHAR2(10) NOT NULL Filter criteria identification

    Prompt Table: CAF_FLTRDEFN_VW