BUSINESS_UNIT_PCPrompt Table: SP_BU_PC_NONVW
PROJECT_IDDefault Value: GM_AWD_PROJT_VW.PROJECT_ID
Prompt Table: SP_PROJ_NONVW
Prompt Table: VENDOR_VW
C=Cost Reimbursement
F=Fixed Price
N=Not Applicable
O=Other
P=Fixed Price Plus Fee
GM_PT_PRJ_VN_VW(SQL View) |
Index Back |
|---|---|
Award Subrecipents View |
| SELECT A.BUSINESS_UNIT_PC , A.PROJECT_ID , A.VENDOR_ID , B.NAME1 , A.SUBCONTRACT_TYPE , A.SUB_METHOD_CHOSEN , A.START_DT , A.END_DT , SUM(A.THIRD_PRTY_AMT) , C.CURRENCY_CD FROM PS_GM_AWD_PRJ_VNDR A , PS_VENDOR B , PS_GM_AWARD C WHERE B.VENDOR_ID = A.VENDOR_ID AND A.SUBRECIPIENT_ST = 'F' AND B.SETID = ( SELECT CTRL.SETID FROM PS_SET_CNTRL_REC CTRL WHERE CTRL.SETCNTRLVALUE =A.BUSINESS_UNIT_PC AND CTRL.RECNAME = 'VENDOR' ) AND C.CONTRACT_NUM = A.CONTRACT_NUM GROUP BY A.BUSINESS_UNIT_PC , A.PROJECT_ID , A.VENDOR_ID , B.NAME1 , A.SUBCONTRACT_TYPE , A.SUB_METHOD_CHOSEN , A.START_DT , A.END_DT, C.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: GM_AWD_PROJT_VW.PROJECT_ID Prompt Table: SP_PROJ_NONVW |
| 3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_VW |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | SUBCONTRACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Subcontract Type
C=Cost Reimbursement F=Fixed Price N=Not Applicable O=Other P=Fixed Price Plus Fee |
| 6 | SUB_METHOD_CHOSEN | Character(30) | VARCHAR2(30) NOT NULL | Method Chosen |
| 7 | START_DT | Date(10) | DATE | Start Date |
| 8 | END_DT | Date(10) | DATE | End Date |
| 9 | THIRD_PRTY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Third Party Amount |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |