CTI_PNL_LBLS_VW

(SQL View)
 Index Back

CTI Panel Field labels

Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration 020603 dms IR528069001 Add related language record

SELECT K.CTI_TRANSACTION , K.CTI_SRCH_FIELD , A.PANELNAME , F.LONGNAME FROM PS_CTI_REC_KEYS K , PS_CTI_PS_ACTIONS A , PSDBFLDLABL F , PSPNLFIELD P WHERE K.CTI_TRANSACTION = A.CTI_TRANSACTION AND P.PNLNAME = A.PANELNAME AND P.FIELDNAME = K.CTI_SRCH_FIELD AND F.FIELDNAME = P.FIELDNAME AND F.LABEL_ID = P.LABEL_ID

  • Related Language Record: CTI_PNL_LBL_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_SRCH_FIELD Character(18) VARCHAR2(18) NOT NULL Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration
    3 PANELNAME Character(18) VARCHAR2(18) NOT NULL Panelname
    4 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name