eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GMS.GMS_AWARDS_ALL

Object Details

Object Name:	GMS_AWARDS_ALL
Object Type:	TABLE
Owner:	GMS
FND Design Data:	GMS.GMS_AWARDS_ALL
Subobject Name:
Status:	VALID

GMS_AWARDS_ALL stores the higest level of information about grants received from a funding agency for execution of projects, including the rules for billing and revenue generation, and terms and conditions associated with the award. Users can maintain the indirect cost rates, cost allowability, billing and revenue generation rules, and workflow controls for various notifications.
This table also maintains award template information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_AWARDS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AWARD_ID
GMS_AWARDS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	AWARD_NUMBER
GMS_AWARDS_U3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AWARD_ID	NUMBER	(15)	Yes	Unique identifier for an award. Primary key.
AWARD_NUMBER	VARCHAR2	(15)	Yes	Number input by user to identify the award
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
AWARD_SHORT_NAME	VARCHAR2	(30)	Yes	Award short name
AWARD_FULL_NAME	VARCHAR2	(240)		Award full name
FUNDING_SOURCE_ID	NUMBER	(15)		Identifier for funding source that originates the award
START_DATE_ACTIVE	DATE			First effective date of award
END_DATE_ACTIVE	DATE			Last effective date of award
CLOSE_DATE	DATE			Close date of award
FUNDING_SOURCE_AWARD_NUMBER	VARCHAR2	(30)		Award number from funding source
AWARD_PURPOSE_CODE	VARCHAR2	(30)		Award code which describes the purpose of an award
STATUS	VARCHAR2	(30)		Award status
ALLOWABLE_SCHEDULE_ID	NUMBER	(15)		Identifier for allowable schedule of the award
IDC_SCHEDULE_ID	NUMBER	(15)		Identifier for indirect cost rate schedule of the award
REVENUE_DISTRIBUTION_RULE	VARCHAR2	(30)		Revenue distribution rule for the award. Values are Cost or Event.
BILLING_FREQUENCY	VARCHAR2	(30)		Award billing frequency
BILLING_DISTRIBUTION_RULE	VARCHAR2	(30)		Billing distribution rule for the award. Values are Cost or Event.
BILLING_FORMAT	VARCHAR2	(30)		Printing option for the invoice generated. Possible values are: NO_PRINT ( No Print), PRINT_INVOICE ( Print Invoice), EDI ( Electronic Data Interface), LOC ( Letter of Credit Drawdown) , AGENCY ( Agency Specific form)
BILLING_TERM	NUMBER	(15)		Award billing term
AWARD_PROJECT_ID	NUMBER	(15)		Award project identifier
AGREEMENT_ID	NUMBER	(15)		Identifier of agreement that binds to the award
AWARD_TEMPLATE_FLAG	VARCHAR2	(10)		Indicates if record is an award template or an award. Immediate indicates an award template and Deferred indicates an award.
PREAWARD_DATE	DATE			Pre-award date
AWARD_MANAGER_ID	NUMBER	(15)		No longer used
REQUEST_ID	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
AGENCY_SPECIFIC_FORM	VARCHAR2	(60)		Agency specified form name for billing format
BILL_TO_CUSTOMER_ID	NUMBER	(15)		Identifier of the bill-to-customer that is used in billing format
TRANSACTION_NUMBER	VARCHAR2	(60)		Used in billing format
AMOUNT_TYPE	VARCHAR2	(4)		Amount type for budgetary control. PTD indicates Period to Date, PJTD indicates Project to Date, and YTD indicates Year to Date.
BOUNDARY_CODE	VARCHAR2	(2)		Boundary code for budgetary control. Y indicates Year, P indicates Period, and PJ indicates Project.
FUND_CONTROL_LEVEL_AWARD	VARCHAR2	(30)		B indicates Absolute, D indicates Advisory, and N indicates None.
FUND_CONTROL_LEVEL_TASK	VARCHAR2	(30)		B indicates Absolute, D indicates Advisory, and N indicates None.
FUND_CONTROL_LEVEL_RES_GRP	VARCHAR2	(30)		B indicates Absolute, D indicates Advisory, and N indicates None.
FUND_CONTROL_LEVEL_RES	VARCHAR2	(30)		B indicates Absolute, D indicates Advisory, and N indicates None.
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
TEMPLATE_START_DATE_ACTIVE	DATE			Start date from which template is active
TEMPLATE_END_DATE_ACTIVE	DATE			End date to which template is active
TYPE	VARCHAR2	(30)		Award type
ORG_ID	NUMBER	(15)		Operating unit identifier for multiple organization
COST_IND_SCH_FIXED_DATE	DATE			Fixed date for indirect cost rate schedule
LABOR_INVOICE_FORMAT_ID	NUMBER	(15)		Labor invoice format identifier
NON_LABOR_INVOICE_FORMAT_ID	NUMBER	(15)		Non-labor invoice format identifier
BILL_TO_ADDRESS_ID	NUMBER	(15)		Billing address identifier for customer
SHIP_TO_ADDRESS_ID	NUMBER	(15)		Shipping address identifier for customer
LOC_BILL_TO_ADDRESS_ID	NUMBER	(15)		Billing address identifier for letter of credit customer
LOC_SHIP_TO_ADDRESS_ID	NUMBER			Shipping address identifier for letter of credit customer
AWARD_ORGANIZATION_ID	NUMBER	(15)		Award organization identifier
HARD_LIMIT_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether revenue for projects funded by this award can exceed the allocated funding amount
BILLING_OFFSET	NUMBER	(15)		Number of days that elapse between the award start date and the date of the award's first invoice
BILLING_CYCLE_ID	NUMBER	(15)		Descriptive name of the billing cycle
BUDGET_WF_ENABLED_FLAG	VARCHAR2	(1)		Flag indicates whether workflow is enabled for budget baselining, reports notification, and installment activation for an award.
PROPOSAL_ID	NUMBER	(15)		Grants Proposal identifier from which an award is created. This column links a proposal in Oracle Grants Proposal to an award in Oracle Grants Accounting.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield segment column
INVOICE_LIMIT_FLAG	VARCHAR2	(1)	Yes	Flag indicates whether invoice for projects funded by this award can exceed the allocated funding amount

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AWARD_ID
,      AWARD_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      AWARD_SHORT_NAME
,      AWARD_FULL_NAME
,      FUNDING_SOURCE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CLOSE_DATE
,      FUNDING_SOURCE_AWARD_NUMBER
,      AWARD_PURPOSE_CODE
,      STATUS
,      ALLOWABLE_SCHEDULE_ID
,      IDC_SCHEDULE_ID
,      REVENUE_DISTRIBUTION_RULE
,      BILLING_FREQUENCY
,      BILLING_DISTRIBUTION_RULE
,      BILLING_FORMAT
,      BILLING_TERM
,      AWARD_PROJECT_ID
,      AGREEMENT_ID
,      AWARD_TEMPLATE_FLAG
,      PREAWARD_DATE
,      AWARD_MANAGER_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      AGENCY_SPECIFIC_FORM
,      BILL_TO_CUSTOMER_ID
,      TRANSACTION_NUMBER
,      AMOUNT_TYPE
,      BOUNDARY_CODE
,      FUND_CONTROL_LEVEL_AWARD
,      FUND_CONTROL_LEVEL_TASK
,      FUND_CONTROL_LEVEL_RES_GRP
,      FUND_CONTROL_LEVEL_RES
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TEMPLATE_START_DATE_ACTIVE
,      TEMPLATE_END_DATE_ACTIVE
,      TYPE
,      ORG_ID
,      COST_IND_SCH_FIXED_DATE
,      LABOR_INVOICE_FORMAT_ID
,      NON_LABOR_INVOICE_FORMAT_ID
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      LOC_BILL_TO_ADDRESS_ID
,      LOC_SHIP_TO_ADDRESS_ID
,      AWARD_ORGANIZATION_ID
,      HARD_LIMIT_FLAG
,      BILLING_OFFSET
,      BILLING_CYCLE_ID
,      BUDGET_WF_ENABLED_FLAG
,      PROPOSAL_ID
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      INVOICE_LIMIT_FLAG
FROM GMS.GMS_AWARDS_ALL;

Dependencies

[top of page]

GMS.GMS_AWARDS_ALL does not reference any database object

GMS.GMS_AWARDS_ALL is referenced by following:

GMS: GMS_AWARDS_ALL#