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: TablePAY.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_TEMPLATE_EXCLUSION_RUL_PK
  1. ColumnEXCLUSION_RULE_ID
  2. ColumnZD_EDITION_NAME
Indexes
Index Type Uniqueness Tablespace Column
PAY_TEMPLATE_EXCLUSION_RUL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXCLUSION_RULE_ID
ColumnZD_EDITION_NAME
PAY_TEMPLATE_EXCLUSION_RUL_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_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.
ZD_EDITION_NAME VARCHAR2 (30) Yes
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
,      ZD_EDITION_NAME
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:

SchemaHR
ViewPAY_TEMPLATE_EXCLUSION_RULES#