GM_424_RR_HDR(SQL View) |
Index Back |
|---|---|
424 header record |
| SELECT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , B.OPPORTUNITY_NUM , B.DESCR254 , B.CFDA , B.DATE_FROM , B.DATE_TO , ' ' , B.COMPETITION_ID , D.NAME1 , B.TITLE56 , B.SUBMISSION_TITLE FROM PS_GM_XML_PROP_TBL A , PS_GM_PROPOSAL B , PS_GM_EC_INST C , PS_CUSTOMER D WHERE A.PROPOSAL_ID = B.PROPOSAL_ID AND A.VERSION_ID = B.VERSION_ID AND A.OPRID = C.OPRID AND A.RUN_CNTL_ID = C.RUN_CNTL_ID AND C.SETID = D.SETID AND B.CUST_ID = D.CUST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PROPOSAL_ID | Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 4 | VERSION_ID | Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 5 | OPPORTUNITY_NUM | Character(100) | VARCHAR2(100) NOT NULL | Opportunity Number |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | CFDA | Character(15) | VARCHAR2(15) NOT NULL | CFDA |
| 8 | DATE_FROM | Date(10) | DATE | Date From |
| 9 | DATE_TO | Date(10) | DATE | Date To |
| 10 | HASH_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Hash Value |
| 11 | GM_COMPETITIONID | Character(100) | VARCHAR2(100) NOT NULL | Competition ID |
| 12 | GM_AGENCY_NAME | Character(60) | VARCHAR2(60) NOT NULL | Agency Name |
| 13 | GM_ACTIVITYTITLE | Character(120) | VARCHAR2(120) NOT NULL | Activity Title |
| 14 | SUBMISSION_TITLE | Character(240) | VARCHAR2(240) NOT NULL | Submission Title |