OSP AWARD COMMENT Table
Contains OSP Award Comments. An award can have no comments or multiple comments of various Comment Type. When joining this table with OSP Award table in Brio, use an unequal join so that awards with no comments are retrieved. You will probably want to limit by Comment Type.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMENT_TEXT |
Comments entered by OSP relevant to the administration of a particular award, for a variety of comment types. They may specifiy cost sharing details, frequency of required fiscal reporting, special indirect cost rates, etc. Extremely long comments may be truncated by BrioQuery, but complete text of comments may be found in Coeus. |
VARCHAR2 |
600 |
COMMENT_TYPE |
OSP enters comments in Coeus relevant to project administration. This field identifies the type of comment (Cost Sharing, Fiscal Report, General, Indirect Cost, Intellectual Property, etc) and also enables the user to limit or search for specific types of comments. The actual comments are in the COMMENT_TEXT field. |
VARCHAR2 |
30 |
MIT_AWARD_KEY |
Key used to join tables with facts about OSP Awards. This field should be used only for joining data, NOT for reporting. |
VARCHAR2 |
10 |
MIT_AWARD_NUMBER |
A unique 10 digit number assigned to an award by MIT (OSP). |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |