[Home] [Help] [Dependency Information]
Object Name: | PAY_EVENT_QUALIFIERS_F |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_EVENT_QUALIFIERS_F |
Subobject Name: | |
Status: | VALID |
PAY_EVENT_QUALIFIERS_F holds the definition to qualify events for element entries or assignments. This table is seeded by the Development Groups.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_EVENT_QUALIFIERS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
EVENT_QUALIFIER_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_QUALIFIER_ID | NUMBER | (9) | Yes | System generated primary key column |
EFFECTIVE_START_DATE | DATE | Yes | Effective Start Date | |
EFFECTIVE_END_DATE | DATE | Yes | Effective End Date | |
DATED_TABLE_ID | NUMBER | (15) | Yes | Foreign key to PAY_DATED_TABLES. |
COLUMN_NAME | VARCHAR2 | (30) | Yes | COLUMN_NAME contains the column that this qualifier is for. |
QUALIFIER_NAME | VARCHAR2 | (80) | Yes | This is the User name for the Qualification |
LEGISLATION_CODE | VARCHAR2 | (30) | Foreign Key to FND_TERRITORIES | |
BUSINESS_GROUP_ID | NUMBER | (9) | Foreign key to HR_ORGANIZATION_UNITS | |
COMPARISON_COLUMN | VARCHAR2 | (2000) | COMPARISON_COLUMN holds the column name or value definition that is used for the comparision in the event qualification | |
QUALIFIER_DEFINITION | VARCHAR2 | (2000) | QUALIFIER_DEFINITION holds the select portion of the statement that is used to qualify the event. | |
QUALIFIER_WHERE_CLAUSE | VARCHAR2 | (2000) | QUALIFIER_DEFINITION holds the from/where portion of the statement that is used to qualify the event. | |
ENTRY_QUALIFICATION | VARCHAR2 | (2000) | ASSIGNMENT_QUALIFICATION is used to determine whether this particular event is valid for a specified element_entry | |
ASSIGNMENT_QUALIFICATION | VARCHAR2 | (2000) | ASSIGNMENT_QUALIFICATION is used to determine whether this particular event is valid for a specified assignment | |
MULTI_EVENT_SQL | VARCHAR2 | (2000) | MULTI_EVENT_SQL contains a select statement that is used to identify potential rows that need to have the comparison performed. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Standard Object Version Number |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
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). |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_QUALIFIER_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DATED_TABLE_ID
, COLUMN_NAME
, QUALIFIER_NAME
, LEGISLATION_CODE
, BUSINESS_GROUP_ID
, COMPARISON_COLUMN
, QUALIFIER_DEFINITION
, QUALIFIER_WHERE_CLAUSE
, ENTRY_QUALIFICATION
, ASSIGNMENT_QUALIFICATION
, MULTI_EVENT_SQL
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM HR.PAY_EVENT_QUALIFIERS_F;
HR.PAY_EVENT_QUALIFIERS_F does not reference any database object
HR.PAY_EVENT_QUALIFIERS_F is referenced by following:
|
|
|