Search Results igs_ps_fac_asg_task_u1

Overview

The IGS.IGS_PS_FAC_ASG_TASK table is a core transactional entity within the Oracle E-Business Suite (EBS) Student Systems / Higher Education module (IGS schema). It stores the individual task assignments associated with faculty workload records, enabling institutions to decompose a faculty member's total assigned workload into discrete, quantified task components such as teaching, research, administrative duties, or other categories defined at the institution. Each row represents one faculty task type assigned to a specific faculty workload record, along with its default workload value, confirmation status, and rollover attributes.

Because the table carries a composite primary key and resolves the many-to-many relationship between faculty workload records (IGS_PS_FAC_WL) and faculty task types (IGS_PS_FAC_TASK_TYP), it functions as an associative bridge. Under a Data Vault modeling heuristic, this object is classified as a link — it connects two business hubs (faculty workload and faculty task type) and carries descriptive context attributes such as budget code and workload value. This classification is a modeling suggestion derived from the foreign key structure rather than an Oracle-imposed designation.

Key Information Stored

The table contains twelve documented columns, of which the following are of greatest operational significance:

• FAC_WL_ID (NUMBER, 15) — Foreign key to the parent table IGS_PS_FAC_WL. Identifies the faculty workload record to which the task is attached. Part of the composite primary key and of the unique index IGS_PS_FAC_ASG_TASK_U1.
• FACULTY_TASK_TYPE (VARCHAR2, 30) — The task type assigned to the faculty member. Also part of the composite primary key and the U1 unique index, and a foreign key to IGS_PS_FAC_TASK_TYP.
• DEPT_BUDGET_CD (VARCHAR2, 30) — Department budget code. A defaulted value that may be overridden by the user.
• DEFAULT_WL (NUMBER) — The default workload value for the given faculty task type; overridable.
• CONFIRMED_IND (VARCHAR2) — Indicator determining whether the task has been confirmed. Only confirmed tasks contribute to the total workload calculation, making this a critical control flag for reporting.
• NUM_ROLLOVER_PERIOD (NUMBER) — The number of times the task must be rolled over; valid values are zero or greater than zero.
• ROLLOVER_FLAG (VARCHAR2) — Denotes whether the record was sourced for rollover (S), created as a result of rollover (D), or is not applicable (NULL).

The surrogate primary key IGS_PS_FAC_ASG_TASK_PK spans (FAC_WL_ID, FACULTY_TASK_TYPE), and the unique business-key candidate IGS_PS_FAC_ASG_TASK_U1 mirrors these two columns. The remaining columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are standard WHO audit columns.

Common Use Cases and Queries

Typical usage centers on workload reporting, confirmation tracking, and rollover processing. To retrieve all tasks for a given faculty workload record:

• SELECT FACULTY_TASK_TYPE, DEFAULT_WL, CONFIRMED_IND FROM IGS.IGS_PS_FAC_ASG_TASK WHERE FAC_WL_ID = :p_fac_wl_id;
• Aggregate confirmed workload per faculty: SELECT FAC_WL_ID, SUM(DEFAULT_WL) FROM IGS.IGS_PS_FAC_ASG_TASK WHERE CONFIRMED_IND = 'Y' GROUP BY FAC_WL_ID;
• Identify rollover candidates: SELECT * FROM IGS.IGS_PS_FAC_ASG_TASK WHERE ROLLOVER_FLAG = 'S' OR NUM_ROLLOVER_PERIOD > 0;
• Join to the task type master to resolve descriptions: ... FROM IGS.IGS_PS_FAC_ASG_TASK T, IGS.IGS_PS_FAC_TASK_TYP Y WHERE T.FACULTY_TASK_TYPE = Y.FACULTY_TASK_TYPE.

Reporting extracts commonly join to IGS_PS_FAC_WL to obtain the faculty member identifier and roll up DEFAULT_WL by task type for institutional workload analytics.

Related Objects

• IGS.IGS_PS_FAC_WL — Parent table; joined via FAC_WL_ID. Provides the faculty workload header context.
• IGS.IGS_PS_FAC_TASK_TYP — Task type master; joined via FACULTY_TASK_TYPE. Supplies valid task type definitions and descriptions.
• APPS.IGS_PS_FAC_ASG_TASK — The APPS-layer synonym/view through which application code and concurrent programs access the base table.
• Index IGS_PS_FAC_ASG_TASK_U1 — Unique index on (FAC_WL_ID, FACULTY_TASK_TYPE) in tablespace APPS_TS_TX_IDX, enforcing the enforced natural key.
• Primary key IGS_PS_FAC_ASG_TASK_PK — Composite constraint on (FAC_WL_ID, FACULTY_TASK_TYPE).

The table resides in the APPS_TS_TX_DATA tablespace with PCT_FREE 10 and is owned by the IGS schema. Neither the table itself nor its columns reference additional database objects beyond the two foreign keys listed above.