SIC_CODE_VW2

(SQL View)
 Index Back

SIC Code View


SELECT DISTINCT A.SIC_CD_QUAL , A.SIC_CODE , A.DESCR100 , %Substring(A.DESCR100 , 1 ,30) FROM PS_SIC_CODE_TBL A UNION SELECT DISTINCT 'USP' , B.SIC_CODE , B.DESCR100 , %Substring(B.DESCR100 , 1 ,30) FROM PS_SIC_CODE_TBL B WHERE B.SIC_CD_QUAL = 'USA' UNION SELECT DISTINCT 'USE' , C.SIC_CODE , C.DESCR100 , %Substring(C.DESCR100 , 1 ,30) FROM PS_SIC_CODE_TBL C WHERE C.SIC_CD_QUAL = 'USA' UNION ALL SELECT DISTINCT USF_CD_QUAL , USF_VNDR_CODE , 'LONG DESCRIPTION OF ' %Concat USF_CD_QUAL %Concat '-' %Concat USF_VNDR_CODE , 'DESCR ' %Concat USF_CD_QUAL %Concat '-' %Concat USF_VNDR_CODE FROM PS_USF_VNDR_CD WHERE USF_CD_QUAL LIKE 'US%'

  • Related Language Record: SIC_CODE_VW2_LG

    • # 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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description