FND Design Data [Home] [Help]

Table: JTF_CAL_SHIFT_CONSTRUCTS

Product: JTF - CRM Foundation
Description: Shift patterns comprising of start and end times for a particular day, availability type, and effectivity.
Implementation/DBA Data: TableJTF.JTF_CAL_SHIFT_CONSTRUCTS
Primary Key: JTF_CAL_SHIFTC_PK
  1. ColumnSHIFT_CONSTRUCT_ID
Primary Key: JTF_CAL_SHIFT_CONSTRUCTS_PK
  1. ColumnSHIFT_CONSTRUCT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_CAL_SHIFT_CONSTRUCTS FK Joins to Table% JTF_CAL_SHIFT_CONSTRUCTS.SHIFT_ID
JTF_CAL_SHIFT_CONSTRUCTS FK Joins to TableJTF_CAL_SHIFTS_B JTF_CAL_SHIFT_CONSTRUCTS.SHIFT_ID
TableJTF_TASK_ASSIGNMENTS FK Joins to JTF_CAL_SHIFT_CONSTRUCTS JTF_TASK_ASSIGNMENTS.SHIFT_CONSTRUCT_ID