CTI_PNL_LBL_LVW

(SQL View)
 Index Back

CTI Panel Field labels

Date Initials Issue Description 020603 dms IR528069001 New related language record

SELECT K.CTI_TRANSACTION , K.CTI_SRCH_FIELD , A.PANELNAME , F.LANGUAGE_CD , F.LONGNAME FROM PS_CTI_REC_KEYS K , PS_CTI_PS_ACTIONS A , PSDBFLDLABLLANG 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 for CTI_PNL_LBLS_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_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name