Search Results igs_ps_fac_task_typ




Overview
Explore in AI Chat

Overview

IGS_PS_FAC_TASK_TYP is a reference (lookup) table within the Oracle E-Business Suite IGS — Student System product family. In the context of Oracle EBS 12.1.1 and 12.2.2, the Student System module is documented as Obsolete in the ETRM repository, meaning that the object is retained for historical, upgrade, or data-migration reference rather than for active functional configuration in the current release. The table stores Faculty Task types and their corresponding default workloads. Each row defines a category of faculty task (for example, a teaching, supervisory, or administrative duty) together with the standard default workload value associated with that task category. These defaults are subsequently consumed when faculty assignment tasks are recorded, allowing the system to pre-populate the expected workload without manual entry.

The documented physical schema identifies the table owner as IGS with 10 columns. Under a heuristic Data Vault classification mined from the foreign-key structure, the table is characterized as hub-leaning, which suggests it functions in a reference-data capacity: a stable, uniquely keyed set of business concepts that other transactional tables point to, rather than a transactional or descriptive satellite entity.

Key Information Stored

The table's business identity is anchored by the column FACULTY_TASK_TYPE, which also serves as the documented primary key through the constraint IGS_PS_FAC_TASK_TYP_PK. A separate unique index, IGS_PS_FAC_TASK_TYP_U1, is defined on the same column, confirming it as the single business-key candidate. In practical terms, the primary key is therefore a natural business key rather than a surrogate sequence, since the same column carries both the PK constraint and the unique index.

The most consequential descriptive columns documented in the metadata are:

  • FACULTY_TASK_TYPE — the unique code identifying each faculty task category; the primary key and the join column used by dependent tables.
  • DESCRIPTION — the human-readable name or explanation of the task type, used in list-of-values displays and reports.
  • DEFAULT_WL — the default workload value applied when a faculty assignment task of this type is created.
  • DEPT_BUDGET_CD — the department budget code associated with the task type, supporting financial or costing attribution of faculty effort.
  • CLOSED_IND — an active/inactive indicator controlling whether the task type remains available for new assignments.

The remaining columns are standard Oracle EBS audit and concurrency attributes: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. These record who inserted or amended the row and when, and they underpin the audit trail required for reference data maintenance.

Common Use Cases and Queries

Typical usage centers on validation lookups, workload defaulting, and reference reporting. Administrators query active task types to populate selection lists, while integration and reporting routines resolve the task type code into its description and default workload.

A common validation query restricts results to open task types:

  • SELECT faculty_task_type, description, default_wl, dept_budget_cd FROM igs_ps_fac_task_typ WHERE closed_ind = 'N' ORDER BY faculty_task_type;

For workload analysis, the default workload can be aggregated by department budget code to estimate planned effort by organizational unit. For migration or reconciliation exercises, a query filtered on the audit columns identifies reference rows created or modified after a given date. Because the module is obsolete, a further practical use case is impact assessment prior to upgrade or decommissioning: identifying which faculty assignment tasks still depend on each task type.

Related Objects

The metadata documents a single foreign-key dependency, in which another table references this lookup:

  • IGS_PS_FAC_ASG_TASK — references IGS_PS_FAC_TASK_TYP via the column FACULTY_TASK_TYPE. This is the principal transactional consumer of the reference data, recording individual faculty assignment tasks and inheriting the default workload defined here.

In a broader Student System context, related reference and transaction objects include the faculty assignment header tables, department and budget-code validation sets that align with DEPT_BUDGET_CD, and the standard audit columns' associated EBS security and concurrent-program infrastructure. The join between IGS_PS_FAC_ASG_TASK.FACULTY_TASK_TYPE and IGS_PS_FAC_TASK_TYP.FACULTY_TASK_TYPE remains the primary relationship to model when building queries, reports, or migration scripts against this object.