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: HR.PAY_TEMPLATE_EXCLUSION_RULES

Object Details

Object Name:	PAY_TEMPLATE_EXCLUSION_RULES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_TEMPLATE_EXCLUSION_RULES
Subobject Name:
Status:	VALID

PAY_TEMPLATE_EXCLUSION_RULES controls the exclusion
of an object from an Element Template. The exclusion can
exclude a formula result rule, an element input value
(thereby excluding everything that refers to the same element
input value within the same Element Template), a balance feed,
a balance type (thereby excluding the balance type, its defined
balances, its balance classifications, and any feeds to it), or an
Element (thereby excluding the element, everything that refers
to the element and its input values within the same element
template).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_TEMPLATE_EXCLUSION_RUL_PK

EXCLUSION_RULE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_TEMPLATE_EXCLUSION_RUL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXCLUSION_RULE_ID
PAY_TEMPLATE_EXCLUSION_RUL_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_TEMPLATE_EXCLUSION_RULES	PAY_ELEMENT_TEMPLATES	PAY_TEMPLATE_EXCLUSION_RULES TEMPLATE_ID
PAY_SHADOW_BALANCE_FEEDS	PAY_TEMPLATE_EXCLUSION_RULES	PAY_SHADOW_BALANCE_FEEDS EXCLUSION_RULE_ID
PAY_SHADOW_BALANCE_TYPES	PAY_TEMPLATE_EXCLUSION_RULES	PAY_SHADOW_BALANCE_TYPES EXCLUSION_RULE_ID
PAY_SHADOW_ELEMENT_TYPES	PAY_TEMPLATE_EXCLUSION_RULES	PAY_SHADOW_ELEMENT_TYPES EXCLUSION_RULE_ID
PAY_SHADOW_ELE_TYPE_USAGES	PAY_TEMPLATE_EXCLUSION_RULES	PAY_SHADOW_ELE_TYPE_USAGES EXCLUSION_RULE_ID
PAY_SHADOW_FORMULA_RULES	PAY_TEMPLATE_EXCLUSION_RULES	PAY_SHADOW_FORMULA_RULES EXCLUSION_RULE_ID
PAY_SHADOW_GU_BAL_EXCLUSIONS	PAY_TEMPLATE_EXCLUSION_RULES	PAY_SHADOW_GU_BAL_EXCLUSIONS EXCLUSION_RULE_ID
PAY_SHADOW_INPUT_VALUES	PAY_TEMPLATE_EXCLUSION_RULES	PAY_SHADOW_INPUT_VALUES EXCLUSION_RULE_ID
PAY_SHADOW_ITERATIVE_RULES	PAY_TEMPLATE_EXCLUSION_RULES	PAY_SHADOW_ITERATIVE_RULES EXCLUSION_RULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXCLUSION_RULE_ID	NUMBER	(9)	Yes	System generated primary key column.
TEMPLATE_ID	NUMBER	(9)	Yes	Foreign key to PAY_ELEMENT_TEMPLATES.
FLEXFIELD_COLUMN	VARCHAR2	(30)	Yes	Configuration flexfield column on template against which the rule
EXCLUSION_VALUE	VARCHAR2	(150)	Yes	Value of configuration flexfield column for the exclusion to take
DESCRIPTION	VARCHAR2	(240)		Description of why this exclusion rule is present.
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object version number column.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.

Query Text

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


SELECT EXCLUSION_RULE_ID
,      TEMPLATE_ID
,      FLEXFIELD_COLUMN
,      EXCLUSION_VALUE
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_TEMPLATE_EXCLUSION_RULES;

Dependencies

[top of page]

HR.PAY_TEMPLATE_EXCLUSION_RULES does not reference any database object

HR.PAY_TEMPLATE_EXCLUSION_RULES is referenced by following:

APPS: PAY_TEMPLATE_EXCLUSION_RULES; PAY_TEMPLATE_EXCLUSION_RUL_WHO
PUBLIC: PAY_TEMPLATE_EXCLUSION_RULES