CTI_REC_KEYS

(SQL Table)
Index Back

CTI Record keys

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

  • 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

    Y/N Table Edit

    Default Value: N

    5 CTI_SEARCH_BOX Number(6,0) INTEGER NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    6 CTI_LIST_BOX Number(6,0) INTEGER NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    7 CTI_ALT_SRCH_KEY Number(6,0) INTEGER NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    8 CTI_XLAT_EDIT Number(6,0) INTEGER NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    9 CTI_USE_PNL_LBL Character(1) VARCHAR2(1) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration

    Y/N Table Edit

    10 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number