CTI_REC_KEYS_VW

(SQL View)
 Index Back

CTI Record keys view

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

SELECT k.cti_transaction , k.cti_ps_srch_rec , k.cti_srch_field , k.cti_use_parm , ' ' , k.cti_search_box , k.cti_list_box , k.cti_alt_srch_key , k.cti_xlat_edit , k.cti_use_pnl_lbl , d.longname , r.edittable , k.fieldnum FROM ps_cti_rec_keys k , PSDBFLDLABL d , psrecfield r WHERE d.fieldname = k.cti_srch_field AND d.default_label = 1 AND r.recname = k.cti_ps_srch_rec AND r.fieldname = k.cti_srch_field

  • Related Language Record: CTI_REC_KEY_LVW

  • Parent record: CTI_PS_ACTIONS

    • # 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 CTI_PS_SRCH_REC Character(15) VARCHAR2(15) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    3 CTI_SRCH_FIELD Character(18) VARCHAR2(18) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    4 CTI_USE_PARM Character(1) VARCHAR2(1) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    5 CTI_IVR_KEYFIELD Character(18) VARCHAR2(18) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    6 CTI_SEARCH_BOX Number(6,0) INTEGER NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    7 CTI_LIST_BOX Number(6,0) INTEGER NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    8 CTI_ALT_SRCH_KEY Number(6,0) INTEGER NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    9 CTI_XLAT_EDIT Number(6,0) INTEGER NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    10 CTI_USE_PNL_LBL Character(1) VARCHAR2(1) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    11 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    12 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table
    13 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number