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_WORK_SHIFTS

Object Details

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

A location to define an employee's work shifts on which all earnings
are based.
Provides an unlimited number of shifts with early or late start and
stop times including any grace periods.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXT_WORK_SHIFTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHT_ID TWS_ID SEQ_NO
HXT_WORK_SHIFTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIFT_DIFF_OVRRD_ID
HXT_WORK_SHIFTS_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TWS_ID WEEK_DAY
HXT_WORK_SHIFTS_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OFF_SHIFT_PREM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SHT_ID	NUMBER	(15)	Yes	Shifts foreign key
TWS_ID	NUMBER	(15)	Yes	Work plan foreign key
WEEK_DAY	VARCHAR2	(3)		Day of the week
SEQ_NO	NUMBER	(1)	Yes	Sequance day will show up in work shift
EARLY_START	NUMBER	(4)		Early shift start time
LATE_STOP	NUMBER	(4)		Late shift stop time
CREATED_BY	NUMBER	(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
OFF_SHIFT_PREM_ID	NUMBER	(9)		PAY_ELEMENT_TYPES_F foreign key
SHIFT_DIFF_OVRRD_ID	NUMBER	(9)		PAY_ELEMENT_TYPES_F foreign key

Query Text

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


SELECT SHT_ID
,      TWS_ID
,      WEEK_DAY
,      SEQ_NO
,      EARLY_START
,      LATE_STOP
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OFF_SHIFT_PREM_ID
,      SHIFT_DIFF_OVRRD_ID
FROM HXT.HXT_WORK_SHIFTS;

Dependencies

[top of page]

HXT.HXT_WORK_SHIFTS does not reference any database object

HXT.HXT_WORK_SHIFTS is referenced by following:

APPS: HXT_WORK_SHIFTS; HXT_WORK_SHIFTS_WHO