[Home] [Help] [Dependency Information]
Object Name: | IGW_AWARDS |
---|---|
Object Type: | TABLE |
Owner: | IGW |
FND Design Data: | IGW.IGW_AWARDS |
Subobject Name: | |
Status: | VALID |
IGW_AWARDS stores data that can be transferred to Grants Accounting as awards. A funded proposal can be transferred as multiple awards and installments.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGW_AWARDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PROPOSAL_AWARD_ID |
IGW_AWARDS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PROPOSAL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPOSAL_AWARD_ID | NUMBER | (15) | Yes | Award or installment identifier |
PROPOSAL_ID | NUMBER | (15) | Yes | Proposal identifier |
AWARD_TEMPLATE_ID | NUMBER | (15) | Award template identifier | |
AWARD_ID | NUMBER | (15) | Award identifier | |
AWARD_NUMBER | VARCHAR2 | (15) | Award number | |
AWARD_SHORT_NAME | VARCHAR2 | (30) | Award short name | |
AWARD_FULL_NAME | VARCHAR2 | (240) | Award full name | |
FUNDING_SOURCE_ID | NUMBER | (15) | Funding source identifier | |
FUNDING_SOURCE_AWARD_NUMBER | VARCHAR2 | (30) | Funding source award number | |
START_DATE | DATE | Active start date for installment | ||
END_DATE | DATE | Active end date for installment | ||
CLOSE_DATE | DATE | Close date for installment | ||
AWARD_TYPE | VARCHAR2 | (30) | Award type. Possible values are Federal Grant, Private Grant, Purchase Orders, Service Agreement, State Grant, and Verbal Agreement. | |
AWARD_PURPOSE_CODE | VARCHAR2 | (30) | Code entered by user, which describes the purpose of an award. Examples include Research and Training. | |
AWARD_ORGANIZATION_ID | NUMBER | (15) | Award organization identifier | |
AWARD_STATUS_CODE | VARCHAR2 | (30) | Award status code. Possible values are Active, Closed, AT_RISK for At Risk, and ON_HOLD for On Hold. | |
AWARD_MANAGER_ID | NUMBER | (15) | Award Manager identifier | |
REVENUE_DISTRIBUTION_RULE | VARCHAR2 | (30) | Revenue distribution rule. This can be one of two types: event and cost. | |
BILLING_DISTRIBUTION_RULE | VARCHAR2 | (30) | Billing distribution rule. This can be one of two types: event and cost. | |
BILLING_TERM_ID | NUMBER | (15) | Award billing term | |
BILLING_CYCLE_ID | NUMBER | (15) | Billing cycle identifier | |
LABOR_INVOICE_FORMAT_ID | NUMBER | (15) | Labor invoice format identifier | |
NON_LABOR_INVOICE_FORMAT_ID | NUMBER | (15) | Non-labor invoice format identifier | |
ALLOWABLE_SCHEDULE_ID | NUMBER | (15) | Identifier for allowable schedule of the award | |
INDIRECT_SCHEDULE_ID | NUMBER | (15) | Identifier for indirect cost rate schedule of the award | |
AMOUNT_TYPE_CODE | VARCHAR2 | (30) | Amount type code for budgetary control. PTD indicates Period to Date, PJTD indicates Project to Date, and YTD indicates Year to Date. | |
BOUNDARY_CODE | VARCHAR2 | (30) | Boundary code for budgetary control. Y indicates Year, P indicates Period, and PJ indicates Project. | |
TRANSFERRED_FLAG | VARCHAR2 | (1) | This indicates whether an award has been transferred to Grants Accounting. Possible values are Y and N. | |
TRANSFER_AS | VARCHAR2 | (30) | This indicates whether the information has been transfered as a new award or as an installment of an existing award. Possible values are A for Award and I for Installment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
RECORD_VERSION_NUMBER | NUMBER | (15) | Yes | Field for storing locking sequence number |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
TEMPORARY_FLAG | VARCHAR2 | (1) | Flag to identify temporary records created during Award Transfer process |
Cut, paste (and edit) the following text to query this object:
SELECT PROPOSAL_AWARD_ID
, PROPOSAL_ID
, AWARD_TEMPLATE_ID
, AWARD_ID
, AWARD_NUMBER
, AWARD_SHORT_NAME
, AWARD_FULL_NAME
, FUNDING_SOURCE_ID
, FUNDING_SOURCE_AWARD_NUMBER
, START_DATE
, END_DATE
, CLOSE_DATE
, AWARD_TYPE
, AWARD_PURPOSE_CODE
, AWARD_ORGANIZATION_ID
, AWARD_STATUS_CODE
, AWARD_MANAGER_ID
, REVENUE_DISTRIBUTION_RULE
, BILLING_DISTRIBUTION_RULE
, BILLING_TERM_ID
, BILLING_CYCLE_ID
, LABOR_INVOICE_FORMAT_ID
, NON_LABOR_INVOICE_FORMAT_ID
, ALLOWABLE_SCHEDULE_ID
, INDIRECT_SCHEDULE_ID
, AMOUNT_TYPE_CODE
, BOUNDARY_CODE
, TRANSFERRED_FLAG
, TRANSFER_AS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, RECORD_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TEMPORARY_FLAG
FROM IGW.IGW_AWARDS;
IGW.IGW_AWARDS does not reference any database object
IGW.IGW_AWARDS is referenced by following:
|
|
|