GM_WC_AWDEXP_VW(SQL View) |
Index Back |
|---|---|
Contracts set to expireContracts set to expire. |
| SELECT CA_HDR.BUSINESS_UNIT , CA_HDR.CONTRACT_NUM , CA_HDR.DESCR , CA_HDR.CA_STATUS , CA_DT.START_DT , CA_DT.END_DT , CA_HDR.SOLD_TO_CUST_ID , CA_HDR.CONTRACT_TYPE , CA_HDR.CONTRACT_ADMIN , AWD.AWARD_STATUS , AWD.GM_BEGIN_DT , AWD.GM_END_DT , AWD.EMPLID , AWD.POST_ADMIN , %DateDiff(%CurrentDateIn, CA_DT.END_DT) FROM PS_CA_HDR_DT_VW CA_DT , PS_CA_CONTR_HDR CA_HDR LEFT OUTER JOIN PS_GM_AWARD AWD ON CA_HDR.CONTRACT_NUM = AWD.CONTRACT_NUM WHERE CA_HDR.CONTRACT_NUM = CA_DT.CONTRACT_NUM AND CA_HDR.CA_PROC_STATUS = 'A' ORDER BY CA_DT.END_DT ASC,CA_HDR.CONTRACT_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | CA_STATUS | Character(24) | VARCHAR2(24) NOT NULL | Contract Status |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | End Date |
| 7 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 8 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL |
Contract Type
Default Value: BUS_UNIT_TBL_CA.CONTRACT_TYPE Prompt Table: CA_TYPE_TBL |
| 9 | CONTRACT_ADMIN | Character(40) | VARCHAR2(40) NOT NULL |
Contract Administrator defined on CABU.
Default Value: BUS_UNIT_TBL_CA.CONTRACT_ADMIN Prompt Table: MEMBER_VW |
| 10 | AWARD_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Award Status
ACP=Accepted CLS=Closed HOL=Holding NEG=Under Negotiation PEN=Pending PRE=Pre-Award REF=Refused TER=Terminated TRA=Transfer WTH=Withdrawn Default Value: ACP |
| 11 | GM_BEGIN_DT | Date(10) | DATE |
Begin Date
Default Value: GM_PROPOSAL.BEGIN_DT |
| 12 | GM_END_DT | Date(10) | DATE |
End Date
Default Value: GM_PROPOSAL.END_DT |
| 13 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 14 | POST_ADMIN | Character(11) | VARCHAR2(11) NOT NULL | Post Award Administrator |
| 15 | DAYS_DUE | Signed Number(5,0) | DECIMAL(4) NOT NULL | Days to Expire |