GMS_AWARD_HEADERS_B_
Grants Award Header Table. Top level component in a Grants and is used to capture award related information like award type, award purpose etc.
Details
-
Schema: FUSION
-
Object owner: GMS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GMS_AWARD_HEADERS_B_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ID | NUMBER | 18 | Yes | Primary Key, Unique identifier of award header | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit Id | ||
| SPONSOR_ID | NUMBER | 18 | Sponsor Party Id (From GMS_SPONSORS table) | ||
| AWARD_TYPE | VARCHAR2 | 30 | Award Type | ||
| AWARD_PURPOSE_CODE | VARCHAR2 | 30 | Award Purpose | ||
| PRINCIPAL_INVESTIGATOR_ID | NUMBER | 18 | Principal Investigator | ||
| CFDA_NUMBER | NUMBER | 18 | Cfda Number | ||
| IDC_SCHEDULE_ID | NUMBER | 18 | Award default burden schedule | ||
| PRE_AWARD_DATE | DATE | Pre-award spending date | |||
| CLOSE_DATE | DATE | Award Close Date | |||
| COST_IND_SCH_FIXED_DATE | DATE | Indirect Cost schedule fixed date | |||
| PROPOSAL_ID | NUMBER | 18 | Proposal id | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| EXPANDED_AUTH_FLAG | VARCHAR2 | 1 | Expanded authority flag | ||
| VALIDATE_STATUS | VARCHAR2 | 1 | Validation Status, N -- for Not validated, C -- Clean, E -- Error, W -- Warning, P -- Pending Calendar Update. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| AWARD_OWNING_ORG_ID | NUMBER | 18 | Award Owning Organization | ||
| INSTITUTION_ID | NUMBER | 18 | Awarded Institution | ||
| SPONSOR_AWARD_NUMBER | VARCHAR2 | 30 | Sponsor Award Number | ||
| LAST_VALIDATED | TIMESTAMP | LAST_VALIDATED | |||
| FT_FROM_DATE | DATE | Flow Through - From Date | |||
| PREV_AWARD_ID | NUMBER | 18 | Previous award ID | ||
| FT_PRIMARY_SPONSOR | NUMBER | 18 | Flow Through - Primary Sponsor | ||
| PREV_AWARD_RENEWAL_INPRG | VARCHAR2 | 5 | Previous award Renewal In Progress Flag | ||
| COI_INST_POLICY_COMPLIANT | VARCHAR2 | 5 | Conflict Of Interest Policy Compliance Flag | ||
| FT_IS_FEDERAL | VARCHAR2 | 5 | Flow Through - Is Federal Flag | ||
| PREV_AWARD_ABR | VARCHAR2 | 5 | Previous award - Accomplishment Based Renewal | ||
| COI_REVIEW_COMPLETED | VARCHAR2 | 5 | Conflict Of Interest Review Completion Status | ||
| FT_TO_DATE | DATE | Flow Through - To Date | |||
| PREV_AWARD_BU | NUMBER | 18 | Previous award Business Unit | ||
| FT_AMOUNT | NUMBER | Flow Through - Amount | |||
| COI_APPROVAL_DATE | DATE | Conflict Of Interest Approval Date | |||
| PRE_AWARD_SPENDING_ALLOWED | VARCHAR2 | 5 | Previous Award - Spending Allowed Flag | ||
| IS_INTELL_PROP_REPORTED | VARCHAR2 | 5 | Intellectual Property Reported Flag | ||
| TEMPLATE_FLAG | VARCHAR2 | 1 | Flag used to distinguish a template from award | ||
| SOURCE_TEMPLATE_ID | NUMBER | 16 | Id of template from which the award is created | ||
| SOURCE_AWARD_ID | NUMBER | 18 | Denotes the Source Award from which this award was copied | ||
| IFS_APPROVER_ID | NUMBER | 18 | Approver id for Cost shared by internal funding source. | ||
| IFS_APPROVAL_DATE | DATE | Approval date for cost shared by internal funding source. | |||
| IFS_SPONSOR_APPROVAL_REQ_FLAG | VARCHAR2 | 1 | Indiate whether approval required by sponsor for cost share by internal funding source or not. | ||
| SUMMARY_REQUEST_ID | NUMBER | 18 | Summarization ESS Request Id. | ||
| AWARD_SOURCE | VARCHAR2 | 20 | Holds the method by which an award is created. Possible Values:- UI, FBDI, WEBSERVICE, FSM(for templates | ||
| CREATED_FROM | VARCHAR2 | 20 | Holds the source from which the award is created. The value would be BLANK for award templates. Possible Values:- BLANK, EXPRESS_AWARD, FROM_TEMPLATE, FROM_AWARD | ||
| DC_REQUEST_ID | NUMBER | 18 | Unique identifier of the request to update the contract dates and control budget period dates as the award dates and award budget period dates. | ||
| DC_STAGE | VARCHAR2 | 30 | Identifies the processing stage to update the contract dates and control budget period dates. | ||
| AMENDMENT_EFFECTIVE_DATE | DATE | Effective date of the amendment. | |||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GMS_AWARD_HEADERS_B_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, ID |
| GMS_AWARD_HEADERS_B_N1_ | Non Unique | Default | ID |