AUC_OPT_LNST_VW(SQL View) |
Index Back |
|---|
| SELECT a.probinst , a.sso_bidln_index , %Round(%decdiv(SUM(a.sso_vndr_qty), SUM(os.sso_num_awarded)), 6) , SUM(os.sso_qty_over ) , SUM(os.sso_qty_under ) , SUM(os.sso_num_awarded ) , SUM(os.sso_vndr_over ) , SUM(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 GROUP BY a.probinst , a.sso_bidln_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_AWARD_QTY | Number(17,6) | DECIMAL(16,6) NOT NULL | Award Quantity |
| 4 | SSO_QTY_OVER | Number(17,6) | DECIMAL(16,6) NOT NULL | quantity over upper bound |
| 5 | SSO_QTY_UNDER | Number(17,6) | DECIMAL(16,6) NOT NULL | qty under lower bound |
| 6 | SSO_NUM_AWARDED | Number(10,0) | DECIMAL(10) NOT NULL | num awarded suppliers |
| 7 | SSO_VNDR_OVER | Number(10,0) | DECIMAL(10) NOT NULL | num supplier over upper bound |
| 8 | SSO_VNDR_UNDER | Number(10,0) | DECIMAL(10) NOT NULL | num supplier under lower bound |