AUC_AWD_P2_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT c.bidder_id ,a.auc_id , a.business_unit ,a.auc_version ,a.auc_round ,a.auc_name ,a.auc_dttm_start ,a.auc_dttm_finish ,( SELECT b.percentage FROM ps_AUC_AWARD_DT_VW b WHERE a.auc_id= b.auc_id AND a.auc_version=b.auc_version AND a.auc_round=b.auc_round AND a.business_unit = b.business_unit AND b.bidder_id=c.bidder_id AND B.BIDDER_LOC=C.BIDDER_LOC),a.auc_status FROM PS_AUC_HDR a,ps_auc_disp_hdr C WHERE a.auc_id= C.auc_id AND a.auc_version=C.auc_version AND a.auc_round=c.auc_round AND a.business_unit = C.business_unit |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BIDDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 2 | AUC_ID | Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | AUC_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
| 5 | AUC_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 6 | AUC_NAME | Character(50) | VARCHAR2(50) NOT NULL | Event Name |
| 7 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 8 | END_DATE | Date(10) | DATE | End Date |
| 9 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 10 | AUC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Event Status
A=Awarded C=Collaborating Event D=Collaborating Bid Analysis E=Evaluating F=RFI Reviewed I=Pending RFI Review N=Not Awarded O=Open P=Posted Q=Paused R=Pending Scheduled Review S=Pending Post Approval T=Pending Award U=Pending Award Approval W=Post to Third Party Failed X=Cancelled Z=Inactive Version |