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 |