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_EXCEPTION_USAGES

Object Details

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

Repeating patterns may have exceptions (eg a Bank Holiday Monday
in a normal Monday-Friday working week). These exceptions may be
applied either to whole calendars (eg the 'Night Shift Calendar'), or
to individual users of that calendar (eg 'Fred Bloggs' or 'Finance
Department'). Exceptions applied to a calendar are inherited by all
users of that calendar, whilst exceptions applied to an individual
are specific to that individual. The application of a particular
exception is recorded in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Primary Key: HR_EXCEPTION_USAGES_PK

EXCEPTION_USAGE_ID

Unique Key: HR_EXU_UK01

EXCEPTION_ID
CALENDAR_ID

Unique Key: HR_EXU_UK02

EXCEPTION_ID
CALENDAR_USAGE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_EXCEPTION_USAGES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXCEPTION_USAGE_ID
HR_EXCEPTION_USAGES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXCEPTION_ID CALENDAR_ID
HR_EXCEPTION_USAGES_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXCEPTION_ID CALENDAR_USAGE_ID
HR_EXCEPTION_USAGES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALENDAR_USAGE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_EXCEPTION_USAGES		HR_CALENDARS	HR_EXCEPTION_USAGES CALENDAR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXCEPTION_ID	NUMBER		Yes	Foreign key to HR_PATTERN_EXCEPTIONS.
EXCEPTION_USAGE_ID	NUMBER		Yes	System-generated primary key column.
EXCEPTION_REASON	VARCHAR2	(2000)		Reason for applying the exception.
CALENDAR_ID	NUMBER			Foreign key to HR_CALENDARS. This column and calendar_usage_id are mutually exclusive.
CALENDAR_USAGE_ID	NUMBER			Foreign key to HR_CALENDAR_USAGES. This column and calendar_id are mutually exclusive.
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
,      EXCEPTION_USAGE_ID
,      EXCEPTION_REASON
,      CALENDAR_ID
,      CALENDAR_USAGE_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM HR.HR_EXCEPTION_USAGES;

Dependencies

[top of page]

HR.HR_EXCEPTION_USAGES does not reference any database object

HR.HR_EXCEPTION_USAGES is referenced by following:

APPS: HR_EXCEPTION_USAGES; HR_EXCEPTION_USAGES_WHO
PUBLIC: HR_EXCEPTION_USAGES