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: JTF.JTF_CAL_SHIFT_CONSTRUCTS

Object Details

Object Name:	JTF_CAL_SHIFT_CONSTRUCTS
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_CAL_SHIFT_CONSTRUCTS
Subobject Name:
Status:	VALID

Each row PATTERN CONSTRUCTION represents a single period of time within a repeating time-based PATTERN or other time-based pattern. For the specified period of time, the PATTERN declares an availability (e.g., At Work or Off Duty etc) which applies. The sequence number enables the
order of the rows within a PATTERN CONSTUCTION to be constructed. A pattern may be constructed using either predefined pattern bits or by using other existing patterns to simplify the production of more complex patterns. If an existing pattern is used in a pattern construction row, it indicates that that pattern must be substituted into this point in the new pattern. Consequently, no availability may
be specified on the row as it is derived from the component pattern.
EXAMPLE
Given that the office staff work 9 am to 5 pm Monday through Friday and 10 am to 2 pm on Saturday with Sunday off, this entity would contain the following records.
Seq. No. Availability Begin Time End Time Pattern Element
1 Y 09:00 05:00 Day
2 Y 09:00 05:00 Day
3 Y 09:00 05:00 Day
4 Y 09:00 05:00 Day
5 Y 09:00 05:00 Day
6 Y 10:00 14:00 Day
7 N 00:00 00:00 Day
Note that the Pattern Start Weekday on which this PATTERN CONSTRUCTION starts is contained in PATTERN.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_CAL_SHIFT_CONSTRUCTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHIFT_CONSTRUCT_ID
JTF_CAL_SHIFT_CONSTRUCTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIFT_ID
JTF_CAL_SHIFT_CONSTRUCTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AVAILABILITY_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
SHIFT_CONSTRUCT_ID	NUMBER		Yes	Primary Key column. Standard Oracle Applications unique key. A number starting at 10,000 and being incremented by one for each new row in the table.
SHIFT_ID	NUMBER		Yes	Foreign Key to JTF_CAL_SHIFTS_B.
UNIT_OF_TIME_VALUE	VARCHAR2	(240)	Yes	Day of the week
BEGIN_TIME	DATE		Yes	Start time for this shift construct.
END_TIME	DATE		Yes	End time for this shift construct.
START_DATE_ACTIVE	DATE			Effective start date of this shift construct
END_DATE_ACTIVE	DATE			Effective end date of this shift construct
AVAILABILITY_TYPE_CODE	VARCHAR2	(240)	Yes	Whether Available as "Regular", "Full-Time", or "StandBy". Foreign Key to FND_LOOKUP_VALUES.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential number used for database locking control when using HTML as a user interface
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
SECURITY_GROUP_ID	NUMBER			Column used for Applications Hosting purposes

Query Text

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


SELECT SHIFT_CONSTRUCT_ID
,      SHIFT_ID
,      UNIT_OF_TIME_VALUE
,      BEGIN_TIME
,      END_TIME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      AVAILABILITY_TYPE_CODE
,      CREATED_BY
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      SECURITY_GROUP_ID
FROM JTF.JTF_CAL_SHIFT_CONSTRUCTS;

Dependencies

[top of page]

JTF.JTF_CAL_SHIFT_CONSTRUCTS does not reference any database object

JTF.JTF_CAL_SHIFT_CONSTRUCTS is referenced by following:

JTF: JTF_CAL_SHIFT_CONSTRUCTS#