XCC_USER_OVERRIDES_GT

This table stores the override information for the current user on the control budgets, journal sources, and journal categories being processed by the current funds reservation.

Details

• Schema: FUSION

• Object owner: XCC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
XCC_USER_OVERRIDES_GT_PK	CONTROL_BUDGET_ID, JE_SOURCE_CODE, JE_CATEGORY_CODE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CONTROL_BUDGET_ID	NUMBER		18	Yes	Control budget for which the override information is being collected.
JE_SOURCE_CODE	VARCHAR2	25		Yes	Journal source for which override information is being gathered. Contains a single space if funds reservation is being run for a product other than general ledger or subledger accounting.
JE_CATEGORY_CODE	VARCHAR2	25		Yes	Journal category for which override information is being gathered. Contains a single space if funds reservation is being run for a product other than general ledger or subledger accounting.
OVERRIDE_AMOUNT	NUMBER			Yes	Largest override amount the current user is allowed to override for this control budget, journal source, and journal category.
OTHER_OVERRIDE_AMOUNT	NUMBER			Yes	Largest override amount any user is allowed to override for this control budget, journal source, and journal category.
OTHER_CLOSED_OVERRIDE_AMOUNT	NUMBER			Yes	Largest override amount, that a user with access to override the closed periods, is allowed to override for this control budget, journal source, and journal category.
MAXIMUM_OVERRIDE_AMOUNT	NUMBER			Yes	The maximum override amount allowed for this control budget.
OVERRIDE_CLOSED_PERIOD_FLAG	VARCHAR2	1		Yes	Indicates whether the current user is allowed to override closed periods.
OTHER_OVERRIDE_CLOSED_FLAG	VARCHAR2	1		Yes	Indicates whether any user is allowed to override closed periods.

Indexes

Index	Uniqueness	Columns
XCC_USER_OVERRIDES_GT_U1	Unique	CONTROL_BUDGET_ID, JE_SOURCE_CODE, JE_CATEGORY_CODE