TRACKING_NBRAGT=Agency Tracking Number Assign
PRC=Processing
RAG=Received by Agency
REC=Received
REJ=Rejected with Errors
VAL=Validated
GM_PROP_APPL_VW(SQL View) |
Index Back |
|---|
| SELECT TRACKING_NBR , BUSINESS_UNIT ,PROPOSAL_ID ,VERSION_ID ,APPLICATION_STATUS ,STATUS_DTTM ,TRACKING_NBR1 ,SUBMIT_DTTM FROM PS_GM_PROPOSAL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRACKING_NBR |
Character(30) | VARCHAR2(30) NOT NULL | Tracking Number |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PROPOSAL_ID | Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 4 | VERSION_ID | Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 5 | APPLICATION_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Grants.gov processing status
AGT=Agency Tracking Number Assign PRC=Processing RAG=Received by Agency REC=Received REJ=Rejected with Errors VAL=Validated |
| 6 | STATUS_DTTM | DateTime(26) | TIMESTAMP | 05/13/02 EGS (CN#PL900-1): Added |
| 7 | TRACKING_NBR1 | Character(30) | VARCHAR2(30) NOT NULL | Tracking Number |
| 8 | SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Report Submitted On - DateTime |