[Home] [Help] [Dependency Information]
Object Name: | HR_PATTERN_CONSTRUCTIONS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.HR_PATTERN_CONSTRUCTIONS |
Subobject Name: | |
Status: | VALID |
Each row of this table represents a single period of time within a
repeating time-based pattern or other time-based pattern. For the
specified period of time, the pattern declares an availability (eg 'AT
WORK', 'OFF DUTY' etc) which applies. The sequence number enables the
order of the rows within a pattern to be constructed.
A pattern may be constructed using either predefined pattern bits or
by using other existing patterns to simplify the production of more
complex patterns. If an existing pattern is used in a pattern
construction row, it indicates that that pattern must be substituted
into this point in the new pattern. Consequently, no availability may
be specified on the row as it is derived from the component pattern.
If a pattern bit is specified, then the availability specified
applies for that period of time only.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_PATTERN_CONSTRUCTIONS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | PATTERN_CONSTRUCTION_ID |
HR_PATTERN_CONSTRUCTIONS_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SEQUENCE_NO
PATTERN_ID |
HR_PATTERN_CONSTRUCTIONS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PATTERN_BIT_ID |
HR_PATTERN_CONSTRUCTIONS_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PATTERN_ID |
HR_PATTERN_CONSTRUCTIONS_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMPONENT_PATTERN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PATTERN_CONSTRUCTION_ID | NUMBER | Yes | System-generated primary key column. | |
SEQUENCE_NO | NUMBER | Yes | The order of this row within its parent pattern. | |
AVAILABILITY | VARCHAR2 | (30) | The availability applicable for the duration of the specified pattern bit. This may not be specified if no pattern_bit_id is specified. | |
PATTERN_ID | NUMBER | Yes | Foreign key to HR_PATTERNS. The pattern for which this construction is a part. | |
PATTERN_BIT_ID | NUMBER | Foreign key to HR_PATTERN_BITS. | ||
COMPONENT_PATTERN_ID | NUMBER | Foreign key to HR_PATTERNS (PATTERN_ID). Identifies a pattern whose construction must be substituted into this point of the parent pattern. | ||
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_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | Standard Who column. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column. |
Cut, paste (and edit) the following text to query this object:
SELECT PATTERN_CONSTRUCTION_ID
, SEQUENCE_NO
, AVAILABILITY
, PATTERN_ID
, PATTERN_BIT_ID
, COMPONENT_PATTERN_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM HR.HR_PATTERN_CONSTRUCTIONS;
HR.HR_PATTERN_CONSTRUCTIONS does not reference any database object
HR.HR_PATTERN_CONSTRUCTIONS is referenced by following:
|
|
|