[Home] [Help] [Dependency Information]
Object Name: | HR_CALENDARS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.HR_CALENDARS |
Subobject Name: | |
Status: | VALID |
A calendar based on a repeating pattern. By assigning a
repeating pattern to a start date, the pattern can be derived as it
would be on any given date after the start date. The same
pattern may be used for many calendars, perhaps time-shifted by,
for example, 8 hours to represent different shift patterns.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_CALENDARS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CALENDAR_ID |
HR_CALENDARS_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CALENDAR_NAME |
HR_CALENDARS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PATTERN_ID |
Table | |
Foreign Table | Foreign Key Column | HR_CALENDAR_USAGES | HR_CALENDARS | HR_CALENDAR_USAGES CALENDAR_ID | HR_EXCEPTION_USAGES | HR_CALENDARS | HR_EXCEPTION_USAGES CALENDAR_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_ID | NUMBER | Yes | System-generated primary key column. | |
CALENDAR_NAME | VARCHAR2 | (80) | Yes | Unique name to identify the calendar. |
PATTERN_START_POSITION | NUMBER | Yes | The sequence number of the pattern construction at which the calendar starts. | |
CALENDAR_START_TIME | DATE | Yes | The start date and time of the calendar. | |
PATTERN_ID | NUMBER | Yes | Foreign key to HR_PATTERNS. | |
OBJECT_VERSION_NUMBER | NUMBER | System-generated version of row. Increments by one with each update. | ||
CREATION_DATE | DATE | Standard Who column. | ||
CREATED_BY | NUMBER | Standard Who column. | ||
LAST_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | Standard Who column. |
Cut, paste (and edit) the following text to query this object:
SELECT CALENDAR_ID
, CALENDAR_NAME
, PATTERN_START_POSITION
, CALENDAR_START_TIME
, PATTERN_ID
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
FROM HR.HR_CALENDARS;
HR.HR_CALENDARS does not reference any database object
HR.HR_CALENDARS is referenced by following:
|
|
|