Results for “jtf_task_assignments”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_TASK_ASSIGNMENTS is a core CRM Foundation table in the JTF schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the resource assignments associated with a task, capturing which resource (person, group, or object) is responsible for performing a given task, along with scheduling, effort, travel, status, and device-synchronization attributes. The table is central to task management and field service workflows in EBS, linking the generic task definition held in JTF_TASKS_B to concrete assignees, calendar constructs, and downstream debrief and requirement records.

From a Data Vault modeling perspective, the mined foreign-key structure classifies JTF_TASK_ASSIGNMENTS as satellite-leaning. Its role as a dependent child of JTF_TASKS_B and holder of descriptive attributes supports this classification as a modeling suggestion rather than a prescriptive architectural directive.

Key Information Stored

TASK_ASSIGNMENT_ID is the surrogate primary key, backed by the JTF_TASK_ASSIGNMENTS_PK constraint and reinforced by the unique index JTF_TASK_ASSIGNMENTS_U1, which makes it the sole documented business-key candidate on this column. Notable attributes include:

• TASK_ID — foreign key to JTF_TASKS_B, identifying the parent task.
• RESOURCE_TYPE_CODE — foreign key to JTF_OBJECTS_B, indicating the type of assignee.
• RESOURCE_ID — the specific resource (person, group, or object) assigned.
• ASSIGNMENT_STATUS_ID — foreign key to IRC_ASSIGNMENT_STATUSES, tracking assignment state.
• ACTUAL_START_DATE / ACTUAL_END_DATE — recorded execution timings for the assignment.
• ACTUAL_EFFORT / ACTUAL_EFFORT_UOM — effort consumed and its unit of measure.
• BOOKING_START_DATE / BOOKING_END_DATE — reserved time window for the resource.
• SHIFT_CONSTRUCT_ID — foreign key to JTF_CAL_SHIFT_CONSTRUCTS, tying assignment to a calendar shift.
• SCHED_TRAVEL_DISTANCE / SCHED_TRAVEL_DURATION / ACTUAL_TRAVEL_* — planned and actual travel metrics.
• ASSIGNEE_ROLE — the role played by the assignee on the task.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org access.
• OBJECT_CAPACITY_ID — foreign key to CAC_SR_OBJECT_CAPACITY.
• SHOW_ON_CALENDAR / FREE_BUSY_TYPE — calendar display and availability indicators.

Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER) and fifteen ATTRIBUTE columns support concurrency control and extensibility.

Common Use Cases and Queries

Typical uses include task workload reporting, assignment status tracking, field resource scheduling, and calendar integration. A common query pattern retrieves all assignments for a task:

• SELECT task_assignment_id, resource_id, assignment_status_id, actual_start_date, actual_end_date FROM jtf_task_assignments WHERE task_id = :task_id;
• Joining to JTF_TASKS_B and IRC_ASSIGNMENT_STATUSES yields descriptive task names and readable statuses for operational dashboards.
• Travel and effort columns feed utilization and cost analysis reports for field service organizations.
• Security-group filtering is applied in multi-org implementations to enforce data visibility.

Related Objects

The most significant related objects, based on documented foreign-key relationships, include:

• JTF_TASKS_B — parent task; joined via TASK_ID.
• JTF_OBJECTS_B — resource type lookup; joined via RESOURCE_TYPE_CODE.
• JTF_CAL_SHIFT_CONSTRUCTS — calendar shift definition; joined via SHIFT_CONSTRUCT_ID.
• IRC_ASSIGNMENT_STATUSES — assignment status lookup; joined via ASSIGNMENT_STATUS_ID.
• FND_SECURITY_GROUPS — access control; joined via SECURITY_GROUP_ID.
• CAC_SR_OBJECT_CAPACITY — capacity reference; joined via OBJECT_CAPACITY_ID.
• CSF_DEBRIEF_HEADERS — child debrief records referencing TASK_ASSIGNMENT_ID.
• CSP_REQUIREMENT_HEADERS — child requirement records referencing TASK_ASSIGNMENT_ID.