SPR_MOSAWD_FACT

(SQL Table)
Index Back

Minority Owned Supplier Awards

Minority Owned Supplier Awards

# 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 SPR_HUB_AI_F Number(5,0) INTEGER NOT NULL Native American - Female
4 SPR_HUB_AI_M Number(5,0) INTEGER NOT NULL Native American - Male
5 SPR_HUB_AS_F Number(5,0) INTEGER NOT NULL HUB- Asian Pasific - Female
6 SPR_HUB_AS_M Number(5,0) INTEGER NOT NULL HUB- Asian Pasific - Males
7 SPR_HUB_BL_F Number(5,0) INTEGER NOT NULL Black American - Female
8 SPR_HUB_BL_M Number(5,0) INTEGER NOT NULL Black American - Male
9 SPR_HUB_HI_F Number(5,0) INTEGER NOT NULL Hispanic American - Female
10 SPR_HUB_HI_M Number(5,0) INTEGER NOT NULL Hispanic American - Male
11 SPR_HUB_WO Number(5,0) INTEGER NOT NULL Woman Owned
12 SPR_HUB_TOTAL Number(5,0) INTEGER NOT NULL HUB Totals