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: HXT.HXT_SHIFTS

Object Details

Object Name:	HXT_SHIFTS
Object Type:	TABLE
Owner:	HXT
FND Design Data:	HXT.HXT_SHIFTS
Subobject Name:
Status:	VALID

Defines company shifts based on a twenty-four hour clock. Shifts are
created with start and stop times. Work Plan, work Schedule, and Shift
are all used to calculate the number of hours paid. Shift hours are
determined by Shift Stop Hours minus Shift Start Hours.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXT_SHIFTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
HXT_SHIFTS_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER	(15)	Yes	System generated shift primary key
NAME	VARCHAR2	(80)	Yes	Shift name
HOURS	NUMBER	(7)		Hours
STANDARD_START	NUMBER	(4)		Start time of the shift
STANDARD_STOP	NUMBER	(4)		Stop time of the shift
EFFECTIVE_START_DATE	DATE		Yes	First effective date
CODE	VARCHAR2	(5)		Shift code
DESCRIPTION	VARCHAR2	(255)		Description
EFFECTIVE_END_DATE	DATE		Yes	Last efffective date
CREATED_BY	VARCHAR2	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
EARLY_START	NUMBER	(4)		Time period that overtime is not paid
LATE_STOP	NUMBER	(4)		Time period that overtime is not paid

Query Text

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


SELECT ID
,      NAME
,      HOURS
,      STANDARD_START
,      STANDARD_STOP
,      EFFECTIVE_START_DATE
,      CODE
,      DESCRIPTION
,      EFFECTIVE_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      EARLY_START
,      LATE_STOP
FROM HXT.HXT_SHIFTS;

Dependencies

[top of page]

HXT.HXT_SHIFTS does not reference any database object

HXT.HXT_SHIFTS is referenced by following:

APPS: HXT_SHIFTS; HXT_SHIFTS_WHO