EMPLIDBUSINESS_UNIT_PROPCONTRACT_NUMPrompt Table: CA_CNTR_SRCH_VW
PROJECT_IDGM_AWD_BUDP_VW(SQL View) |
Index Back |
|---|---|
Prop Prof Budget Labor DetailThis view is used to identify the Proposals associated with all PI's. This enables the system to determine the 'Other Pending Support' credited to a particular PI. This view is used in GM_EDI Application Engine. |
| SELECT %Substring(T.TEAM_MEMBER ,1,11) ,T.BUSINESS_UNIT ,A.CONTRACT_NUM ,T.PROJECT_ID , A.VERSION_ID ,T.PERCENTAGE ,P.DESCR ,A.PROPOSAL_ID ,A.BEGIN_DT ,A.END_DT ,A.EMPLID ,A.NAME ,B.BILL_TO_CUST_ID ,F.TOTAL_AWARD_AMT , T.APPT_TYPE_MTH_CAL , T.APPT_TYPE_MTH_ACAD , T.APPT_TYPE_MTH_SUMR FROM PS_PROJECT_TEAM T , PS_PROJECT P , PS_GM_AWARD A , PS_CA_CONTR_HDR B , PS_GM_CA_DTL_PJ_VW C , PS_GM_AWD_BUDF_VW F WHERE T.BUSINESS_UNIT=P.BUSINESS_UNIT AND T.PROJECT_ID=P.PROJECT_ID AND P.GRANT_FLG='Y' AND P.BUSINESS_UNIT=C.BUSINESS_UNIT_PC AND P.PROJECT_ID=C.PROJECT_ID AND C.CONTRACT_NUM=A.CONTRACT_NUM AND C.BUSINESS_UNIT_PC=A.BUSINESS_UNIT AND C.BUSINESS_UNIT_PC=B.BUSINESS_UNIT AND C.CONTRACT_NUM=B.CONTRACT_NUM AND B.BUSINESS_UNIT=F.BUSINESS_UNIT_PROP AND B.CONTRACT_NUM=F.CONTRACT_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BUSINESS_UNIT_PROP |
Character(5) | VARCHAR2(5) NOT NULL | Proposal Business Unit |
| 3 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CNTR_SRCH_VW |
| 4 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 5 | VERSION_ID | Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 6 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | PROPOSAL_ID_TO | Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 9 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 10 | END_DT | Date(10) | DATE | End Date |
| 11 | EMPLID_RELATED | Character(11) | VARCHAR2(11) NOT NULL | Related People ID |
| 12 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 13 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 14 | TOTAL_AWARD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Award Amount |
| 15 | APPT_TYPE_MTH_CAL | Number(6,2) | DECIMAL(5,2) NOT NULL | Calendar Appointment Months |
| 16 | APPT_TYPE_MTH_ACAD | Number(6,2) | DECIMAL(5,2) NOT NULL | Academic Appointment Months |
| 17 | APPT_TYPE_MTH_SUMR | Number(6,2) | DECIMAL(5,2) NOT NULL | Summer Appointment Months |