eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.HR_PATTERN_EXCEPTIONS

Object Details

Object Name:	HR_PATTERN_EXCEPTIONS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_PATTERN_EXCEPTIONS
Subobject Name:
Status:	VALID

A repeating pattern may be overridden by irregular events, for example
a company holiday may interrupt the normal cycle of a work pattern.
Exceptions may be simple, eg one day off, or complex, eg shifts during
Christmas week. By defining a pattern, it is possible to specify
simple or complex periods of time and the availability at each point
in the period. That pattern may then be used to override another
pattern for a specified period of time.
When an exception pattern is applied to a repeating pattern from a
given date and time, the repeating cycle will be interrupted by the
exceptional pattern for one iteration and then the original pattern
will resume.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Primary Key: HR_PATTERN_EXCEPTIONS_PK

EXCEPTION_ID

Unique Key: HR_PAE_UK01

PATTERN_ID
EXCEPTION_NAME
EXCEPTION_START_TIME

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_PATTERN_EXCEPTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXCEPTION_ID
HR_PATTERN_EXCEPTIONS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PATTERN_ID EXCEPTION_NAME EXCEPTION_START_TIME

Columns

Name	Datatype	Length	Mandatory	Comments
EXCEPTION_ID	NUMBER		Yes	System-generated primary key column.
PATTERN_ID	NUMBER		Yes	Foreign key to HR_PATTERNS.
EXCEPTION_NAME	VARCHAR2	(80)	Yes	Unique name of this exception, eg 'Thanksgiving Day 1996'.
EXCEPTION_START_TIME	DATE		Yes	The start date and time from which the exception will be applied.
EXCEPTION_END_TIME	DATE		Yes	The end date and time of the exception (derived from the start time and the duration of the pattern).
EXCEPTION_CATEGORY	VARCHAR2	(30)		A category for the exception (eg Company Holidays). Validated by lookup (EXCEPTION CATEGORY).
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.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXCEPTION_ID
,      PATTERN_ID
,      EXCEPTION_NAME
,      EXCEPTION_START_TIME
,      EXCEPTION_END_TIME
,      EXCEPTION_CATEGORY
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM HR.HR_PATTERN_EXCEPTIONS;

Dependencies

[top of page]

HR.HR_PATTERN_EXCEPTIONS does not reference any database object

HR.HR_PATTERN_EXCEPTIONS is referenced by following:

APPS: HR_PATTERN_EXCEPTIONS; HR_PATTERN_EXCEPTIONS_WHO
PUBLIC: HR_PATTERN_EXCEPTIONS