OPRIDBUSINESS_UNITVENDOR_IDA=Asian American
AI=American Indian
AS=Asian Pacific
B=African American
BL=Black
H=Hispanic American
HI=Hispanic
N=Native American
OT=Other
WH=White
NO=No
YES=Yes
SPR_MOSDTL_FACT(SQL Table) |
Index Back |
|---|---|
Minority Owned Supplier Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | ETHNIC_CATEGORY | Character(2) | VARCHAR2(2) NOT NULL |
Ethnic Category
A=Asian American AI=American Indian AS=Asian Pacific B=African American BL=Black H=Hispanic American HI=Hispanic N=Native American OT=Other WH=White |
| 5 | IS_WOMAN_OWNED | Character(3) | VARCHAR2(3) NOT NULL |
Woman Owned
NO=No YES=Yes |
| 6 | SPR_BIDS_RECV | Number(5,0) | INTEGER NOT NULL | # of Bids Received |
| 7 | SPR_WO_AWARDED | Number(5,0) | INTEGER NOT NULL | Workorder/Contracts Awarded |