CONTRACT_NUMGM_MD_AWARD_VW(SQL View) |
Index Back |
|---|---|
Award DetailsThis view contains the date, reference award number and federal award id of an award. |
| SELECT BUSINESS_UNIT , CONTRACT_NUM , TITLE56 , BEGIN_DT , END_DT , REF_AWD_NUMBER , FED_AWD_ID_NUMBER , EMPLID FROM PS_GM_AWARD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Award ID |
| 3 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |
| 4 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 5 | END_DT | Date(10) | DATE | End Date |
| 6 | REF_AWD_NUMBER | Character(25) | VARCHAR2(25) NOT NULL | Reference Award Number |
| 7 | FED_AWD_ID_NUMBER | Character(50) | VARCHAR2(50) NOT NULL | Federal Award Identification Number for Grants use. Added in enhancement bug number 18492701. |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |