Search Results num_rollover_period

Overview

IGS_PS_FAC_ASG_TASK_V is an Oracle E-Business Suite database view owned by the APPS schema within the IGS (Student System) product family. As documented in the ETRM metadata for release 12.2.2, the view stores the assigned tasks for faculty members, presenting a denormalised, read-friendly projection of faculty task assignment data together with the descriptive text of each task type. Its principal role is to support reporting and integration requirements in which the technical task type code held on the assignment record must be resolved to a human-readable description for display, extraction, or downstream processing.

The view is defined with the status VALID and is exposed alongside other IGS Student System objects. Because it is a view rather than a base table, it does not itself hold data; it derives its content at query time from the underlying assignment and task-type tables. This makes it suitable for ad hoc enquiry screens, concurrent program extracts, and interface queries where a single joined row per faculty task assignment is required.

Underlying Base Objects

The view text documented in the ETRM metadata identifies two referenced base tables:

• IGS_PS_FAC_ASG_TASK FAT — the faculty assignment task table, which supplies the assignment-level attributes including the workload identifier, task type, budget code, confirmed indicator, default workload flag, rollover attributes, and the standard WHO audit columns. The FAT.ROWID is exposed as ROW_ID.
• IGS_PS_FAC_TASK_TYP FTT — the faculty task type reference table, which supplies the descriptive text for the task type.

The two tables are joined on the faculty task type code, expressed in the view definition as FTT.FACULTY_TASK_TYPE = FAT.FACULTY_TASK_TYPE. This is an inner join, so only assignment rows whose task type exists in the task type reference table are returned. Although the ETRM metadata records "none documented" against the referenced base objects entry, the embedded view text unambiguously establishes the FAT and FTT tables as the sources.

Key Columns

The view exposes the following columns, several of which are significant to both functional and technical consumers:

• ROW_ID — the ROWID of the underlying assignment task row, useful for row identification and for constructing update paths.
• FAC_WL_ID — the faculty workload identifier, linking the task assignment to a faculty workload record.
• FACULTY_TASK_TYPE — the code identifying the type of task assigned to the faculty member.
• TASK_DESCRIPTION — the descriptive text of the task type, sourced from IGS_PS_FAC_TASK_TYP. This is the column returned by the user's search term task_description.
• DEPT_BUDGET_CD — the department budget code associated with the assignment.
• CONFIRMED_IND — indicates whether the assignment has been confirmed.
• DEFAULT_WL — flag denoting the default workload.
• NUM_ROLLOVER_PERIOD and ROLLOVER_FLAG — describe rollover behaviour for the assignment.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle WHO audit columns.

Common Use Cases and Queries

Typical uses include faculty workload reporting, task confirmation monitoring, and extraction of task descriptions for integration into external scheduling or HR systems. A representative query listing assignment tasks with descriptions is:

• SELECT fac_wl_id, faculty_task_type, task_description, dept_budget_cd, confirmed_ind, default_wl, rollover_flag FROM apps.igs_ps_fac_asg_task_v WHERE confirmed_ind = 'Y';
• SELECT task_description, COUNT(*) FROM apps.igs_ps_fac_asg_task_v GROUP BY task_description;
• SELECT * FROM apps.igs_ps_fac_asg_task_v WHERE fac_wl_id = :p_fac_wl_id;

All queries should be executed against the APPS schema with appropriate IGS responsibility security applied.