CTI_REC_KEY_LVW

(SQL View)
 Index Back

CTI Record keys language view

Date Initials Issue Description 021704 kpn 691500000 Rel lang view for CTI_REC_KEY_VW

SELECT k.cti_transaction , k.cti_ps_srch_rec , k.cti_srch_field , l.language_cd , l.longname FROM ps_cti_rec_keys k , PSDBFLDLABL d , PSDBFLDLABLlang l , psrecfield r WHERE d.fieldname = k.cti_srch_field AND d.fieldname = l.fieldname AND d.label_id = l.label_id AND d.default_label = 1 AND r.recname = k.cti_ps_srch_rec AND r.fieldname = k.cti_srch_field

  • Related Language Record for CTI_REC_KEYS_VW

  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name