[Home] [Help] [Dependency Information]
Object Name: | HR_PATTERN_PURPOSE_USAGES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.HR_PATTERN_PURPOSE_USAGES |
Subobject Name: | |
Status: | VALID |
Predefined data specifying the valid combinations of entities and
pattern purposes for work patterns. For example, 'Resource Schedule'
may be a purpose which is only valid with 'Location' and 'Schedulable
Resource', whilst 'Work pattern' may be a purpose which is valid with
'Organization', 'Person' and 'Assignment'. Each row of this table
specifies a valid combination of one purpose with one entity.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_PATTERN_PURPOSE_USAGES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | PURPOSE_USAGE_ID |
HR_PATTERN_PURPOSE_USAGES_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ENTITY_NAME
PATTERN_PURPOSE |
HR_PATTERN_PURPOSE_USAGES_UK2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PATTERN_PURPOSE
HIERARCHY_LEVEL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURPOSE_USAGE_ID | NUMBER | Yes | System-generated primary key column. | |
ENTITY_NAME | VARCHAR2 | (30) | Yes | Name of the entity. Validated by lookup (SCHEDULABLE ENTITY). |
PATTERN_PURPOSE | VARCHAR2 | (30) | Yes | Purpose of a pattern which is valid with the entity name. Validated by lookup (PATTERN PURPOSE). |
HIERARCHY_LEVEL | NUMBER | Yes | Patterns may be inherited from higher level entities. The level is specified here. | |
OBJECT_VERSION_NUMBER | NUMBER | System-generated version of row. Increments by one with each update. | ||
CREATED_BY | NUMBER | Standard Who column. | ||
CREATION_DATE | DATE | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | Standard Who column. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column. | ||
LAST_UPDATE_DATE | DATE | Standard Who column. |
Cut, paste (and edit) the following text to query this object:
SELECT PURPOSE_USAGE_ID
, ENTITY_NAME
, PATTERN_PURPOSE
, HIERARCHY_LEVEL
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
FROM HR.HR_PATTERN_PURPOSE_USAGES;
HR.HR_PATTERN_PURPOSE_USAGES does not reference any database object
HR.HR_PATTERN_PURPOSE_USAGES is referenced by following:
|
|
|