Search Results igs_ps_fac_asg_task_pk

Overview

IGS_PS_FAC_ASG_TASK is a transactional table within the Oracle E-Business Suite Student System (IGS) product family, owned by the IGS schema. Its documented purpose is to store the tasks assigned to faculty members. In the broader Oracle Student System data model, faculty workload and assignment records underpin scheduling, teaching-load analysis, and rollover processing between academic periods. This table sits beneath the faculty workload header, holding the discrete task-type assignments that constitute a faculty member's workload record.

The ETRM metadata classifies this object, using a heuristic Data Vault model derived from its foreign key structure, as a link. This is a modeling suggestion rather than a physical fact: the table acts as an associative entity connecting a faculty workload record to a specific faculty task type, and the natural candidate key is the combination of those two references. It carries descriptive and process-control attributes (such as default workload and confirmation flags), so it also exhibits satellite-like characteristics, but its primary function is to resolve a many-to-many style assignment between workload and task definition.

Key Information Stored

The documented physical schema contains twelve columns. The most significant are summarized below.

• FAC_WL_ID — The faculty workload identifier. This is a foreign key referencing IGS_PS_FAC_WL and forms the first component of the composite primary key. It ties each task assignment to the parent workload record.
• FACULTY_TASK_TYPE — The category of task assigned. This is a foreign key referencing IGS_PS_FAC_TASK_TYP and forms the second component of the composite primary key. Together with FAC_WL_ID, it defines uniqueness.
• DEPT_BUDGET_CD — A departmental budget code, indicating the funding or organizational unit associated with the task assignment.
• DEFAULT_WL — A default workload value or indicator applied to the assignment.
• CONFIRMED_IND — A confirmation flag indicating whether the assignment has been validated or committed.
• NUM_ROLLOVER_PERIOD — The number of periods over which the assignment rolls forward.
• ROLLOVER_FLAG — Indicates whether the assignment participates in rollover processing to a subsequent period.
• CREATED_BY, CREATION_DATE — Standard Oracle audit columns recording the creating user and timestamp; present in the documented schema.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns recording the last modifying user, timestamp, and session login.

The surrogate primary key is defined by constraint IGS_PS_FAC_ASG_TASK_PK, spanning (FAC_WL_ID, FACULTY_TASK_TYPE). A unique index, IGS_PS_FAC_ASG_TASK_U1, is documented over the same two columns, confirming the business-key candidate as the workload-to-task-type combination.

Common Use Cases and Queries

Typical reporting scenarios include listing all task assignments for a given faculty workload record, identifying unconfirmed assignments, and analyzing assignments subject to rollover. A representative query joining to the task type reference table follows:

• SELECT t.FAC_WL_ID, t.FACULTY_TASK_TYPE, t.DEPT_BUDGET_CD, t.CONFIRMED_IND, t.ROLLOVER_FLAG FROM IGS.IGS_PS_FAC_ASG_TASK t WHERE t.FAC_WL_ID = :workload_id;
• SELECT t.FAC_WL_ID, y.DESCRIPTION FROM IGS.IGS_PS_FAC_ASG_TASK t, IGS.IGS_PS_FAC_TASK_TYP y WHERE t.FACULTY_TASK_TYPE = y.FACULTY_TASK_TYPE AND t.CONFIRMED_IND = 'N';
• SELECT t.FAC_WL_ID, t.FACULTY_TASK_TYPE, t.NUM_ROLLOVER_PERIOD FROM IGS.IGS_PS_FAC_ASG_TASK t WHERE t.ROLLOVER_FLAG = 'Y';

These patterns support faculty workload verification, funding-code reconciliation by department, and preparation of the rollover process between academic sessions.

Related Objects

• IGS_PS_FAC_WL — The parent faculty workload table; joined via IGS_PS_FAC_ASG_TASK.FAC_WL_ID.
• IGS_PS_FAC_TASK_TYP — The task type reference table; joined via IGS_PS_FAC_ASG_TASK.FACULTY_TASK_TYPE. This is the lookup that supplies task descriptions and category context.
• Constraint IGS_PS_FAC_ASG_TASK_PK — The primary key constraint enforcing uniqueness of the workload-to-task combination.
• Unique Index IGS_PS_FAC_ASG_TASK_U1 — The supporting unique index over (FAC_WL_ID, FACULTY_TASK_TYPE).

Because the documented schema is limited to the two foreign key relationships, additional dependent objects such as workload assignment APIs or student system views should be confirmed against the specific 12.1.1 or 12.2.2 instance before reliance.