Search Results igs_ps_govt_dscp




Overview
Explore in AI Chat

Overview

The table IGS_PS_GOVT_DSCP is a reference data entity within the Oracle E-Business Suite (EBS) Student System (IGS), specifically for versions 12.1.1 and 12.2.2. It serves as a master repository for the Department of Education, Employment and Training (DEET) set of discipline group codes. These standardized codes are used for governmental reporting and classification of academic disciplines. It is critical to note that the ETRM metadata explicitly marks this table as "Not implemented in this database" and its parent module, IGS - Student System, as "Obsolete." This indicates the table is part of a legacy or deprecated data model and may not be populated or actively used in standard implementations, though its structure may persist for historical data compatibility.

Key Information Stored

The table's primary purpose is to store the valid list of government-defined discipline codes. Its structure is centered on a single primary key column, which holds the core reference data. Based on the provided metadata, the definitive column is:

  • GOVT_DISCIPLINE_GROUP_CD: This is the primary key column (IGS_PS_GOVT_DSCP_PK) and stores the unique code representing a specific discipline group as defined by the DEET framework. The table likely contains additional descriptive columns (such as a description or effective dates) common to reference tables, though these are not detailed in the provided excerpt.

Common Use Cases and Queries

Given its status as a reference table for potentially obsolete functionality, its primary use case is to validate and constrain discipline codes entered in related transactional tables. In historical reporting or data migration scenarios, queries would typically join this table to fetch the official description for a code stored elsewhere. A fundamental query pattern would be to retrieve the full list of valid codes for setup or validation purposes:

SELECT govt_discipline_group_cd FROM igs_ps_govt_dscp WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);

For reporting, a common join would link discipline data from a course or unit table to this reference table to decode the government discipline group for official submissions:

SELECT dscp.course_cd, gdscp.govt_discipline_group_cd FROM igs_ps_dscp_all dscp, igs_ps_govt_dscp gdscp WHERE dscp.govt_discipline_group_cd = gdscp.govt_discipline_group_cd;

Related Objects

The integrity of the IGS_PS_GOVT_DSCP table is enforced through its primary key, which is referenced by foreign keys in at least two other tables, as documented in the ETRM metadata. These relationships define how this reference data is utilized within the (obsolete) Student System data model:

  • IGS_PS_DSCP_ALL: This table, which stores discipline details, references IGS_PS_GOVT_DSCP via the column IGS_PS_DSCP_ALL.GOVT_DISCIPLINE_GROUP_CD. This links a specific discipline record to its official government classification.
  • IGS_FI_GV_DSP_HEC_CN: This financial aid or fees-related table (context suggests Government Discipline HECS Contributions) also references IGS_PS_GOVT_DSCP via the column IGS_FI_GV_DSP_HEC_CN.GOVT_DISCIPLINE_GROUP_CD. This indicates the government discipline code was used to determine fee calculations or funding categories.
  • Table: IGS_PS_GOVT_DSCP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_GOVT_DSCP,  object_name:IGS_PS_GOVT_DSCP,  status:VALID,  product: IGS - Student System ,  description: This entity describes the DEET set of discipline group codes. ,  implementation_dba_data: IGS.IGS_PS_GOVT_DSCP , 

  • Table: IGS_FI_GV_DSP_HEC_CN 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_GV_DSP_HEC_CN,  object_name:IGS_FI_GV_DSP_HEC_CN,  status:VALID,  product: IGS - Student System ,  description: This table describes the mappings of government discipline groups to contribution bands. ,  implementation_dba_data: IGS.IGS_FI_GV_DSP_HEC_CN , 

  • View: IGSFV_ACADEMIC_DISCIPLINES 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_ACADEMIC_DISCIPLINES,  object_name:IGSFV_ACADEMIC_DISCIPLINES,  status:VALID,  product: IGS - Student System ,  description: This is the full view which describes the university set of discipline group codes. ,  implementation_dba_data: APPS.IGSFV_ACADEMIC_DISCIPLINES , 

  • Table: IGS_PS_DSCP_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_DSCP_ALL,  object_name:IGS_PS_DSCP_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the university set of discipline group codes. This is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values. ,  implementation_dba_data: IGS.IGS_PS_DSCP_ALL ,