# |
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
|