CTI_PS_ACTIONS

(SQL Table)
 Index Back

CTI Transfer page definitions

Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration Copied from FIN database.

  • Related Language Record: CTI_PS_ACT_LANG

  • Parent Record Of CTI_REC_KEYS CTI_REC_KEYS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CTI_TRANSACTION Character(5) VARCHAR2(5) NOT NULL The CTI transaction for this unit of work.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 FOREIGN_TRANS Character(1) VARCHAR2(1) NOT NULL Foreign Transaction................................
    N=No
    Y=Yes

    Default Value: N

    4 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

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

    Prompt Table: CTI_MENU_VW

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

    Prompt Table: CTI_BAR_VW

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

    Prompt Table: CTI_CMPNT_VW

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

    Prompt Table: CTI_PNL_VW

    9 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

    10 SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name
    11 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

    Prompt Table: RDT_TMPL_FAMILY