SCR_IND_ORG_VW

(SQL View)
Index Back

Request for Change SIC codes


SELECT SETID ,VENDOR_ID ,SIC_CD_QUAL ,SIC_CODE , 'N' FROM PS_VNDR_HDR_IND_CL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 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
4 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code

Prompt Table: SIC_CODE_VW2

5 SCR_USR_ACTION Character(1) VARCHAR2(1) NOT NULL Action
A=Add
D=Remove
U=Update