GM_AWD_INV6_VW(SQL View) |
Index Back |
|---|---|
Award Inventory ViewAward Inventory View by PI and status |
| SELECT A.BUSINESS_UNIT , A.EMPLID , A.AWARD_STATUS , A.CONTRACT_NUM , C.SHIP_TO_CUST_ID , A.REF_AWD_NUMBER , B.TOTAL_AWARD_AMT , A.BEGIN_DT , A.END_DT , A.AWARD_TYPE FROM PS_GM_AWARD A , PS_GM_AWD_BUDF2_VW B , PS_CA_CONTR_HDR C WHERE A.CONTRACT_NUM = B.CONTRACT_NUM AND A.CONTRACT_NUM = C.CONTRACT_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | 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 |
| 4 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 5 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 6 | REF_AWD_NUMBER | Character(25) | VARCHAR2(25) NOT NULL | Reference Award Number |
| 7 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 8 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 9 | END_DT | Date(10) | DATE | End Date |
| 10 | AWARD_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Award Type
BOA=Basic Ordering Agreement CLI=Clinical Trial CON=Contract CP=Cooperative Agreement FDP=FDP FIX=Fixed GR=Grant IPA=IPA LIC=License LN=Loan MOU=MOU MTA=MTA NDA=NDA OTH=Other PA=Patent Agreement PO=Purchase Order SB=SubContract TO=Task Order |