CTI_PS_ACTIONS

(SQL Table)
 Index Back

CTI Transfer page definitions

Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration

  • Related Language Record: CTI_PS_ACT_LANG

  • Parent Record Of CTI_PNL_LBLS_VW CTI_PNL_LBL_LVW CTI_REC_KEYS CTI_REC_KEYS_VW CTI_REC_KEY_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CTI_TRANSACTION Character(5) VARCHAR2(5) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 CTI_PS_SRCH_REC Character(15) VARCHAR2(15) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration

    Prompt Table: PSRECDEFN

    4 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: CTI_MENU_VW

    5 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

    Prompt Table: CTI_BAR_VW

    6 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

    Prompt Table: CTI_CMPNT_VW

    7 PANELNAME Character(18) VARCHAR2(18) NOT NULL Panelname

    Prompt Table: CTI_PNL_VW

    8 CTI_ACTION Character(1) VARCHAR2(1) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    A=Add
    U=Update/Inquiry

    Default Value: U

    9 SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name
    10 FOREIGN_TRANS Character(1) VARCHAR2(1) NOT NULL Foreign Transaction

    Y/N Table Edit

    Default Value: N