AUC_PAR_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 ,a.auc_status FROM ps_auc_hdr a ,PS_RESP_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 | 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 |