USF_CD_QUALBUS=Business Types
PSC=Public Service Codes
SBA=SBA Business Types
USA=NAICS Code
USE=NAICS Exception Codes
USP=Primary NAICS Codes
USF_VNDR_CODELANGUAGE_CDUSF_CD_TBL_LANG(SQL Table) |
Index Back |
|---|---|
SAM CodesStores SAM codes and their definitions. This record is maintained by the customer to provide code descriptions for codes imported via the SAM load file process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | USF_VNDR_CODE |
Character(40) | VARCHAR2(40) NOT NULL | Vendor CCR Codes |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |