WCS_SO_DBFLD_LV

(SQL View)
 Index Back

WCS SO Field Descriptions Lang

Used to retrieve field description for Configurable Matrix Sources where the Source Type is Related Employee Information.

SELECT WCSL.HCMD_CLASSID , WCSL.HCMD_ATTRIBID , WCS.FIELDNAME , WCSL.LANGUAGE_CD , WCSL.DESCR FROM PS_HCMD_OATT_LNG WCSL, PS_HCMD_OATT_TBL WCS, PSDBFIELD PS WHERE WCSL.HCMD_CLASSID = WCS.HCMD_CLASSID AND WCSL.HCMD_ATTRIBID = WCS.HCMD_ATTRIBID AND PS.FIELDNAME = WCS.FIELDNAME

  • Related Language Record for WCS_SO_DBFLD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HCMD_CLASSID Character(12) VARCHAR2(12) NOT NULL EI_CLASSID
    2 HCMD_ATTRIBID Character(30) VARCHAR2(30) NOT NULL Created by Eric Solberg 2/18/02 Attribute name as defined by object descriptor
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description