[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
JTF.JTF_CAL_SHIFT_CONSTRUCTS does not reference any database object
JTF.JTF_CAL_SHIFT_CONSTRUCTS is referenced by following:
|
|
|