Search Results igs_ps_dscp_pk

Overview

The table IGS_PS_DSCP_ALL is a core data entity within the Oracle E-Business Suite Student System (IGS). It serves as the master repository for an institution's defined set of discipline group codes. These codes are used to classify academic units, courses, and student enrollments into broad disciplinary areas for administrative and reporting purposes. A critical function of this table, as noted in its description, is to manage the mapping between the university's internal discipline classifications and the standardized codes required by the DEET (Department of Education, Employment and Training, an Australian government body). While the table stores the institution's full set of codes, a subset of these values is mapped to official DEET equivalents for statutory reporting.

Key Information Stored

The primary data stored in IGS_PS_DSCP_ALL revolves around the discipline group code and its attributes. The central column is DISCIPLINE_GROUP_CD, which is the table's primary key (IGS_PS_DSCP_PK). This column holds the unique identifier for each discipline group. Another significant column is GOVT_DISCIPLINE_GROUP_CD, which is referenced by a foreign key from the IGS_PS_GOVT_DSCP table. This relationship is central to the DEET mapping functionality, linking the internal code to its corresponding government-reported equivalent. While the full column list is not detailed in the provided metadata, typical attributes for such a code table would include a description, effective dates, and an inactive indicator.

Common Use Cases and Queries

The primary use case is the classification and reporting of academic activities. It is essential for generating government compliance reports that require data to be aggregated by DEET discipline groups. Administratively, it supports curriculum management, enrollment analysis, and resource planning by discipline. Common queries involve joining this table to related transactional data. For example, to list all active discipline codes with their government mappings, a query might be:

• SELECT dscp.DISCIPLINE_GROUP_CD, dscp.DESCRIPTION, govt.GOVT_DISCIPLINE_GROUP_CD FROM IGS_PS_DSCP_ALL dscp, IGS_PS_GOVT_DSCP govt WHERE dscp.DISCIPLINE_GROUP_CD = govt.DISCIPLINE_GROUP_CD AND dscp.CLOSED_IND = 'N';

Another frequent pattern is querying the discipline history of a specific unit or course offering by joining through IGS_PS_UNT_DSCP_HIST_ALL or IGS_PS_UNIT_DSCP.

Related Objects

IGS_PS_DSCP_ALL is a referenced master table for several key transactional entities in the Student System, as defined by its foreign key relationships. The table IGS_PS_GOVT_DSCP holds the official government discipline details, linking via the GOVT_DISCIPLINE_GROUP_CD. The table IGS_AD_TER_ED_UNI_AT references it, likely for storing tertiary education attribution data. Most importantly, it is referenced by the history table IGS_PS_UNT_DSCP_HIST_ALL and the assignment table IGS_PS_UNIT_DSCP, which track the discipline group associations for academic units over time and for specific instances, respectively. These relationships underscore its role as the source of truth for discipline classification across the module.