SIC_CD_SRCH_LNG

(SQL View)
 Index Back

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

  • Related Language Record for SIC_CODE_SRCH

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