CP_MTXUCVW3_LNG

(SQL View)
Index Back

CP Matrix User Code View RLR

View of CP_USERCD_LANG 3

SELECT SETID , CP_USER_CD , CP_USER_VALUE , LANGUAGE_CD , LONG_DESC FROM PS_CP_USERCD_LANG

  • Related Language Record for CP_MTX_UC_VW3
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CP_USER_CD_3 Character(10) VARCHAR2(10) NOT NULL Matrix Value List 3 Field
    3 CP_USER_VALUE Character(18) VARCHAR2(18) NOT NULL User Values Field
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LONG_DESC Character(50) VARCHAR2(50) NOT NULL Long Description