AUC_OPT_STAT_VW(SQL View) |
Index Back |
|---|
| SELECT a.probinst , a.sso_bidln_index , a.sso_vndr_index , bli.sso_item_index , os.sso_award_qty , os.sso_qty_over , os.sso_qty_under , os.sso_num_awarded , os.sso_vndr_over , os.sso_vndr_under FROM ps_sso_award a INNER JOIN ps_sso_bidln_item bli ON bli.probinst = a.probinst AND bli.sso_bidln_index = a.sso_bidln_index INNER JOIN PS_SSO_ORDER_STAT os ON os.probinst = a.probinst AND os.sso_item_index = bli.sso_item_index |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | SSO_BIDLN_INDEX | Number(10,0) | DECIMAL(10) NOT NULL | Bid Line Index |
| 3 | SSO_VNDR_INDEX | Number(10,0) | DECIMAL(10) NOT NULL | Supplier Index |
| 4 | SSO_ITEM_INDEX | Number(10,0) | DECIMAL(10) NOT NULL | item index |
| 5 | SSO_AWARD_QTY | Number(17,6) | DECIMAL(16,6) NOT NULL | Award Quantity |
| 6 | SSO_QTY_OVER | Number(17,6) | DECIMAL(16,6) NOT NULL | quantity over upper bound |
| 7 | SSO_QTY_UNDER | Number(17,6) | DECIMAL(16,6) NOT NULL | qty under lower bound |
| 8 | SSO_NUM_AWARDED | Number(10,0) | DECIMAL(10) NOT NULL | num awarded suppliers |
| 9 | SSO_VNDR_OVER | Number(10,0) | DECIMAL(10) NOT NULL | num supplier over upper bound |
| 10 | SSO_VNDR_UNDER | Number(10,0) | DECIMAL(10) NOT NULL | num supplier under lower bound |