Search Results prgm_seq_in_id




Overview
Explore in AI Chat

Overview

The IGS_DA_IN_PRG table is a core data structure within the Oracle E-Business Suite (EBS) Student System (OSS), specifically under the IGS (iGrads) schema. Its primary function is to serve as a staging area for incoming data from a third-party degree audit software. The table stores detailed information about academic programs associated with student degree audit requests, facilitating the evaluation of a student's progress toward graduation requirements. As indicated by the metadata comment "Obsolete," this table's active use in current implementations of EBS 12.1.1 or 12.2.2 may be limited, suggesting it has been superseded by other objects or processes in later application versions. Its historical role was to integrate external audit results into the Oracle EBS ecosystem.

Key Information Stored

The table captures the relationship between a student, a degree audit batch request, and the specific academic program being audited. Key columns include BATCH_ID and PERSON_ID, which uniquely tie records to a specific audit request for a student. The PRGM_SEQ_IN_ID provides a unique sequence for linking program data to corresponding results. The PROG_CODE and PROG_VERSION columns define the specific academic program and its version under evaluation. Critical audit outcome metrics are stored in PROG_EARNED_CR_PTS (completed credits) and PROG_EARNED_GPA. The PROG_COMP_IND, PROG_COMP_DATE, and DEGREE_DATE columns track completion status and timelines. The PROG_COMP_SRC is a static identifier for the third-party audit software source.

Common Use Cases and Queries

This table supports processes for loading, validating, and reporting on external degree audit results. Common operational scenarios include reconciling imported audit data and generating reports on student program completion statuses sourced from the third-party system. A typical query pattern would involve joining on BATCH_ID and PERSON_ID to analyze audit outcomes. For example, to find completed program audits for a specific student, one might use:

  • SELECT prog_code, prog_version, prog_comp_date, prog_earned_cr_pts FROM igs.igs_da_in_prg WHERE person_id = :stu_id AND prog_comp_ind IS NOT NULL ORDER BY prog_comp_date DESC;

Another common use case is batch-level analysis to verify data integrity post-import, such as checking for programs linked to a specific audit request batch.

Related Objects

The table's structure and unique indexes indicate its integration within a broader data flow. The two unique indexes, IGS_DA_IN_PRG_U1 (on PRGM_SEQ_IN_ID) and IGS_DA_IN_PRG_U2 (on BATCH_ID, PERSON_ID, PROG_CODE, PROG_VERSION), enforce data integrity and support performance for lookups. This table is logically related to other "DA" (Degree Audit) interface tables within the IGS schema that handle incoming student, course, and result data. It would also have dependencies on core OSS base tables storing definitive PERSON and PROGRAM definitions, to which the imported data in IGS_DA_IN_PRG is ultimately compared and applied. Given its staging nature, it is likely referenced by concurrent programs or APIs responsible for processing the imported audit data into the application's transactional tables.

  • TABLE: IGS.IGS_DA_IN_PRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_PRG,  object_name:IGS_DA_IN_PRG,  status:VALID, 

  • Table: IGS_DA_IN_USET 12.2.2

    product: IGS - Student System (Obsolete) ,  description: Storage for incoming Unit Set information for the programs coming back from the 3rd party for the Students in the Degree Audit Request. ,  implementation_dba_data: Not implemented in this database , 

  • Table: IGS_DA_IN_PRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_PRG,  object_name:IGS_DA_IN_PRG,  status:VALID,  product: IGS - Student System ,  description: Storage for the incoming information from the 3rd party about programs related to the Students in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_IN_PRG , 

  • Table: IGS_DA_IN_PRG 12.2.2

    product: IGS - Student System (Obsolete) ,  description: Storage for the incoming information from the 3rd party about programs related to the Students in the Degree Audit Request. ,  implementation_dba_data: Not implemented in this database , 

  • Table: IGS_DA_IN_USET 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_USET,  object_name:IGS_DA_IN_USET,  status:VALID,  product: IGS - Student System ,  description: Storage for incoming Unit Set information for the programs coming back from the 3rd party for the Students in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_IN_USET , 

  • TABLE: IGS.IGS_DA_IN_USET 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_USET,  object_name:IGS_DA_IN_USET,  status:VALID, 

  • eTRM - IGS Tables and Views 12.1.1

    description: Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'. , 

  • eTRM - IGS Tables and Views 12.1.1

    description: Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'. ,