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_BURDEN_COMPONENTS

Object Details

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

GMS_BURDEN_COMPONENTS stores the burden amounts by component for each raw expenditure item picked up during the revenue or billing process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_BURDEN_COMPONENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AWARD_PROJECT_ID BURDEN_COST_CODE EVENT_TYPE EXPENDITURE_ITEM_ID ADL_LINE_NUM REQUEST_ID
GMS_BURDEN_COMPONENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_ID EVENT_TYPE BURDEN_COST_CODE
GMS_BURDEN_COMPONENTS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVENUE_ACCUMULATED EVENT_TYPE
GMS_BURDEN_COMPONENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_PROJECT_ID REQUEST_ID EVENT_TYPE
GMS_BURDEN_COMPONENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_PROJECT_ID EVENT_NUM EVENT_TYPE EXPENDITURE_ITEM_ID BURDEN_COST_CODE
GMS_BURDEN_COMPONENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVENUE_ACCUMULATED

Columns

Name	Datatype	Length	Mandatory	Comments
ACTUAL_PROJECT_ID	NUMBER	(15)		Unique identifier of project against which raw transaction was recorded
ACTUAL_TASK_ID	NUMBER	(15)		Unique identifier of task against which raw transaction was recorded
AMOUNT	NUMBER	(22)		Burden amount
AWARD_PROJECT_ID	NUMBER	(15)	Yes	Unique identifier of award project
BURDEN_COST_CODE	VARCHAR2	(30)		Burden or indirect cost code
BURDEN_EXP_TYPE	VARCHAR2	(30)		Expenditure type mapped to burden cost code
CREATED_BY	NUMBER			Standard Who column
CREATION_DATE	DATE			Standard Who column
EVENT_NUM	NUMBER	(15)		Unique identifier of expenditure item processed for billing or revenue
EVENT_TYPE	VARCHAR2	(30)		Event type of the event being created. Revenue indicates revenue generation events, and Invoice indicates billing events.
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	Unique identifier of expenditure item processed for billing or revenue
EXPENDITURE_ORG_ID	NUMBER	(15)		Unique identifier of organization to which raw transaction was charged
ADL_LINE_NUM	NUMBER	(15)	Yes	Award distribution line number
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)	Yes	Unique identifier of expenditure item processed for billing or revenue
REVENUE_ACCUMULATED	VARCHAR2	(1)		Flag indicates the revenue accumulation status for Award Status Inquiry
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)		Resource list member identifier to which the burden component is mapped to

Query Text

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


SELECT ACTUAL_PROJECT_ID
,      ACTUAL_TASK_ID
,      AMOUNT
,      AWARD_PROJECT_ID
,      BURDEN_COST_CODE
,      BURDEN_EXP_TYPE
,      CREATED_BY
,      CREATION_DATE
,      EVENT_NUM
,      EVENT_TYPE
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ORG_ID
,      ADL_LINE_NUM
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      REVENUE_ACCUMULATED
,      RESOURCE_LIST_MEMBER_ID
FROM GMS.GMS_BURDEN_COMPONENTS;

Dependencies

[top of page]

GMS.GMS_BURDEN_COMPONENTS does not reference any database object

GMS.GMS_BURDEN_COMPONENTS is referenced by following:

GMS: GMS_BURDEN_COMPONENTS#