SIC_CODE_VW2_LG

(SQL View)
 Index Back

SIC Code View - RLR

ICE 2010360000 -- cmh 09/07/2010 -- added DESCR100

SELECT DISTINCT A.SIC_CD_QUAL , A.SIC_CODE , A.LANGUAGE_CD , A.DESCR100 , %Substring(A.DESCR100 , 1 ,30) FROM PS_SIC_CODE_LNG A UNION SELECT DISTINCT 'USP' , B.SIC_CODE , B.LANGUAGE_CD , B.DESCR100 , %Substring(B.DESCR100 , 1 ,30) FROM PS_SIC_CODE_LNG B WHERE B.SIC_CD_QUAL = 'USA' UNION SELECT DISTINCT 'USE' , C.SIC_CODE , C.LANGUAGE_CD , C.DESCR100 , %Substring(C.DESCR100 , 1 ,30) FROM PS_SIC_CODE_LNG C WHERE C.SIC_CD_QUAL = 'USA'

  • Related Language Record for SIC_CODE_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SIC_CD_QUAL Character(3) VARCHAR2(3) NOT NULL SIC Code Type
    ANZ=Australia-New Zealand SIC Code
    CAN=Canadian NAICS Codes
    GER=German SIC Codes
    NAF=French SIC Codes
    SIC=US SIC Codes
    UK=UK 92 SIC Codes
    USA=US - NAICS Codes
    USE=NAICS Exception Codes
    USP=Primary NAICS Codes
    2 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description