GM_424_RR_FTR(SQL View) |
Index Back |
|---|---|
424 header record |
| SELECT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , B.OPPORTUNITY_NUM , CASE WHEN B.SUBMIT_DTTM IS NULL THEN %CurrentDateTimeIn ELSE B.SUBMIT_DTTM END , CASE WHEN B.SUBMIT_DTTM IS NULL THEN %CurrentDateIn ELSE %DatePart(B.SUBMIT_DTTM) END , CASE WHEN B.SUBMIT_DTTM IS NULL THEN %CurrentTimeIn ELSE %TimePart(B.SUBMIT_DTTM) END , B.TRACKING_NBR , E.NAME , ' ' FROM PS_GM_XML_PROP_TBL A , PS_GM_PROPOSAL B , PS_GM_EC_PERS_SO E WHERE A.PROPOSAL_ID = B.PROPOSAL_ID AND A.VERSION_ID = B.VERSION_ID AND A.OPRID = E.OPRID AND A.RUN_CNTL_ID = E.RUN_CNTL_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 | SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Report Submitted On - DateTime |
| 7 | SUBMIT_DT | Date(10) | DATE | Date Submitted |
| 8 | AUC_TIME | Time(15) | TIMESTAMP | Time |
| 9 | TRACKING_NBR | Character(30) | VARCHAR2(30) NOT NULL | Tracking Number |
| 10 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 11 | STR_DT | Character(26) | VARCHAR2(26) NOT NULL | Submit Date Time |