USF_UEIDUSF_EFT_INDUSF_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_CODEDUNS_NUMBERUSF_DUNS_PLUS4USF_VNDR_CD(SQL Table) |
Index Back |
|---|---|
USF Code Values |
| # | 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 | EXPIRATION_DATE | Date(10) | DATE | Expiration Date |
| 8 | USF_DUNS_PLUS4 |
Character(4) | VARCHAR2(4) NOT NULL | DUNS Suffix |