SIC_CODE_SRCH

(SQL View)
 Index Back

SIC Code Search Vw


SELECT A.SIC_CD_QUAL , B.XLATSHORTNAME FROM PS_SIC_CODE_TBL A , PSXLATITEM B WHERE A.SIC_CD_QUAL = A.PARENT_SIC_CODE AND B.FIELDNAME = 'SIC_CD_QUAL' AND A.SIC_CD_QUAL = B.FIELDVALUE AND B.EFF_STATUS <> 'I' AND B.EFFDT <= %CurrentDateIn

  • Related Language Record: SIC_CD_SRCH_LNG

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