DLT_WRK_ESP_VW

(SQL View)
 Index Back

ESP Delta Work Type View

ESP Work Type Codes for Delta, using XML_XLAT_CODE = 'WRK'

SELECT %Substring(XML_XLAT_VALUE,1,2) , DESCR50 FROM PS_XML_XLATITEM WHERE XML_XLAT_CODE = 'WRK'

  • Related Language Record: DLT_WRK_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DLT_WORK_TYPE_ESP Character(2) VARCHAR2(2) NOT NULL Work Type
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50