DBA Data[Home] [Help] [Dependency Information]

TABLE: HXT.HXT_WEEKLY_WORK_SCHEDULES

Object Details
Object Name: HXT_WEEKLY_WORK_SCHEDULES
Object Type: TABLE
Owner: HXT
FND Design Data: TableHXT.HXT_WEEKLY_WORK_SCHEDULES
Subobject Name:
Status: VALID


A location to define a company's various employee work plans.
Assigning a new work plan is easily done throughout the pay year. The
work plan indicates the employees shift for each day.
An employee's work shif is the foundation for all earnings.
Provides an unlimited number of plans with early or late start and
stop times including any grace periods. Multiple work plans may be
effective during the pay period.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HXT_WEEKLY_WORK_SCHEDULES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
HXT_WEEKLY_WORK_SCHEDULES_UK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnBUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER (15) Yes System generated work plan primary key
NAME VARCHAR2 (80) Yes Work plan name
START_DAY VARCHAR2 (3) Yes The day of the week this schedule will start.
DATE_FROM DATE
Yes First effective date
DESCRIPTION VARCHAR2 (255)
Work plan description
DATE_TO DATE

Last effective date
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
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
Query Text

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


SELECT ID
,      NAME
,      START_DAY
,      DATE_FROM
,      DESCRIPTION
,      DATE_TO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      BUSINESS_GROUP_ID
FROM HXT.HXT_WEEKLY_WORK_SCHEDULES;

Dependencies

[top of page]

HXT.HXT_WEEKLY_WORK_SCHEDULES does not reference any database object

HXT.HXT_WEEKLY_WORK_SCHEDULES is referenced by following:

SchemaAPPS
SynonymHXT_WEEKLY_WORK_SCHEDULES
TriggerHXT_WEEKLY_WORK_SCHEDULES_WHO