USF_CODE_VW

(SQL View)
 Index Back

SAM Code Decsriptions

Uses SIC_CODE_TBL for NAICS codes when enabled at installation

SELECT V.USF_UEID , V.USF_EFT_IND , V.USF_CD_QUAL , V.USF_VNDR_CODE , V.DUNS_NUMBER , V.USF_DODAAC , C.DESCR , 'A' , V.USF_DUNS_PLUS4 FROM PS_INSTALLATION_FD I , PS_USF_VNDR_CD V LEFT OUTER JOIN PS_USF_CD_TBL C ON C.USF_CD_QUAL = V.USF_CD_QUAL AND C.USF_VNDR_CODE = V.USF_VNDR_CODE WHERE I.USF_NAICS_FLG = 'N' OR V.USF_CD_QUAL NOT IN ('USA', 'USE', 'USP') UNION ALL SELECT V.USF_UEID , V.USF_EFT_IND , V.USF_CD_QUAL , V.USF_VNDR_CODE , V.DUNS_NUMBER , V.USF_DODAAC , S.DESCR100 , CASE WHEN S.SIC_CD_QUAL IS NULL THEN 'C' ELSE 'B' END , V.USF_DUNS_PLUS4 FROM PS_INSTALLATION_FD I , PS_USF_VNDR_CD V LEFT OUTER JOIN PS_SIC_CODE_TBL S ON S.SIC_CD_QUAL = V.USF_CD_QUAL AND S.SIC_CODE = V.USF_VNDR_CODE WHERE I.USF_NAICS_FLG = 'Y' AND V.USF_CD_QUAL IN ('USA', 'USE', 'USP')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USF_UEID Character(12) VARCHAR2(12) NOT NULL Unique Entity Identifier
2 USF_EFT_IND Character(4) VARCHAR2(4) NOT NULL Entity EFT Indicator
3 USF_CD_QUAL Character(4) VARCHAR2(4) NOT NULL Codetype
BUS=Business Types
PSC=Public Service Codes
SBA=SBA Business Types
USA=NAICS Code
USE=NAICS Exception Codes
USP=Primary NAICS Codes
4 USF_VNDR_CODE Character(40) VARCHAR2(40) NOT NULL Vendor CCR Codes
5 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
6 USF_DODAAC Character(9) VARCHAR2(9) NOT NULL Department of Defense Activity Address Code
7 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
8 SOURCE_FLAG Character(1) VARCHAR2(1) NOT NULL Team member created from
6=Primavera P6
G=Proposal Management
M=MSP
P=Projects online
R=Resource Management
9 USF_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix