Search Results dept_budget_cd

Overview

IGS.IGS_PS_FAC_TASK_TYP is a configuration table in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the IGS schema, which supports the Oracle Student System and related academic workload management functionality. The table stores Faculty Task Types together with the default workload associated with each type. It functions as a reference or setup entity that institutions define to categorize the academic tasks performed by faculty members, such as instruction, research, administrative duties, or committee service, and to attach a standard workload value to each category.

Physically, the table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and is accessed through a unique index, IGS_PS_FAC_TASK_TYP_U1, residing in APPS_TS_TX_IDX. From a data modeling perspective, the heuristic Data Vault classification for this object is hub-leaning, suggesting that it behaves principally as a business-key hub. The FACULTY_TASK_TYPE column serves as the natural business key, uniquely identifying each task type, and acts as the anchor to which transactional or assignment-level data can be linked. This classification should be treated as a modeling suggestion rather than a formal Data Vault design decision.

Key Information Stored

The table contains ten documented columns. The most significant are:

• FACULTY_TASK_TYPE (VARCHAR2, 30) — The primary key and the business-key candidate enforced by the unique index IGS_PS_FAC_TASK_TYP_U1. It holds the institution-defined code for the faculty task category.
• DEFAULT_WL (NUMBER) — The default workload value for the given Faculty Task Type. This is the column most closely associated with the "default_wl" search term and represents the standard workload assigned when a faculty assignment uses this task type.
• DESCRIPTION (VARCHAR2, 80) — A descriptive label for the Faculty Task Type, used in lists of values and reports.
• DEPT_BUDGET_CD (VARCHAR2, 30) — The Department Budget Code associated with the task type, enabling linkage to departmental budgeting and cost allocation processes.
• CLOSED_IND (VARCHAR2) — A closure indicator. Once a Faculty Task Type is closed, it no longer appears in the LOV of forms and is not considered for processing, providing a soft-delete mechanism that preserves historical integrity.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording insert and update users and timestamps.

The primary key, IGS_PS_FAC_TASK_TYP_PK, enforces uniqueness of FACULTY_TASK_TYPE, while IGS_PS_FAC_TASK_TYP_U1 is the corresponding unique index. No separate surrogate key column is exposed in the documented metadata.

Common Use Cases and Queries

Typical use cases include validating faculty assignment workloads, building workload distribution reports, and populating task type lookup lists in application forms. A common pattern is to retrieve only active task types for use in a list of values:

SELECT FACULTY_TASK_TYPE, DESCRIPTION, DEFAULT_WL FROM IGS.IGS_PS_FAC_TASK_TYP WHERE NVL(CLOSED_IND,'N') = 'N';

Reporting use cases frequently join configuration data to assignment-level transactions to compare actual workload against the default, and to aggregate workload by department budget code:

SELECT t.DEPT_BUDGET_CD, t.FACULTY_TASK_TYPE, t.DEFAULT_WL, COUNT(a.FACULTY_TASK_TYPE) FROM IGS.IGS_PS_FAC_TASK_TYP t, IGS.IGS_PS_FAC_ASG_TASK a WHERE t.FACULTY_TASK_TYPE = a.FACULTY_TASK_TYPE GROUP BY t.DEPT_BUDGET_CD, t.FACULTY_TASK_TYPE, t.DEFAULT_WL;

Administrators also query the table when auditing configuration changes via the WHO columns, or when identifying closed task types for archival purposes.

Related Objects

The documented dependency data shows that IGS_PS_FAC_TASK_TYP does not reference any other database object through foreign keys, but it is referenced by IGS_PS_FAC_ASG_TASK through the FACULTY_TASK_TYPE column. This child table stores individual faculty assignment task records and inherits or defaults its workload from DEFAULT_WL in the parent type. The primary source of related information is therefore:

• IGS.IGS_PS_FAC_ASG_TASK — Child table; its FACULTY_TASK_TYPE column is a foreign key pointing to IGS_PS_FAC_TASK_TYP.FACULTY_TASK_TYPE, enabling task-type-to-assignment reporting.
• IGS.IGS_PS_FAC_TASK_TYP_PK — The primary key constraint enforcing FACULTY_TASK_TYPE uniqueness.
• IGS.IGS_PS_FAC_TASK_TYP_U1 — The unique index supporting the business key and LOV lookups.

The dependency documentation also lists the APPS synonym IGS_PS_FAC_TASK_TYP, which makes the object accessible under the APPS schema for application and query purposes. No additional third-party dependencies are documented in the ETRM metadata.