Results for “igs_da_in_src_unts”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_DA_IN_SRC_UNTS is a transactional table within the Oracle E-Business Suite Student System (IGS) product family. It stores the source unit records supplied by third-party systems for individual students as part of a Degree Audit request. In the degree audit workflow, an external institution or evaluation engine submits the student's prior coursework or earned units, and those records are persisted here for matching, evaluation, and articulation against the institution's own curriculum requirements.

The table resides in the IGS schema and is documented as VALID in the ETRM 12.1.1 repository, containing 19 physical columns. Its heuristic Data Vault classification is satellite-leaning. From a modeling perspective, this suggests IGS_DA_IN_SRC_UNTS behaves primarily as a descriptive satellite: it carries attribute-rich context about source units that are anchored to a parent business key—most likely a degree audit request combined with a person reference—rather than acting as an independent hub of its own business concept. The BATCH_ID and PERSON_ID foreign keys to IGS_DA_REQ_STDNTS reinforce this interpretation, tying each row to an existing request-student relationship.

Key Information Stored

The surrogate primary key is SRC_UNIT_ID, enforced through IGS_DA_IN_SRC_UNTS_PK and mirrored by the unique index IGS_DA_IN_SRC_UNTS_U1. The most business-relevant columns include:

• BATCH_ID and PERSON_ID — the composite foreign key to IGS_DA_REQ_STDNTS, identifying the student and the audit request batch the unit belongs to.
• SRC_UNIT_GROUP and SRC_UNIT_DPMASK — grouping and department-masking attributes used to organize source units for evaluation.
• SRC_TRANS_UNIT_INST_ID and SRC_TRANS_UNIT_ALT_INST_ID — identifiers for the transferring institution (primary and alternate alias).
• SRC_UNIT_CODE and SRC_UNIT_CODE_VERSION — the external course or unit code and its version, essential for equivalency mapping.
• SRC_UNIT_TITLE — the descriptive title of the incoming unit as provided by the third party.
• SRC_UNIT_TEACH_PERIOD — the teaching period during which the unit was taken.
• SRC_UNIT_EARNED_CREDIT and SRC_UNIT_COUNT — quantitative measures of credit earned and unit count.
• SRC_UNIT_GRADE — the grade awarded in the source unit.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard WHO-column traceability.

Note that SRC_UNIT_ID is a surrogate identifier; no natural unique business key is documented beyond that surrogate index.

Common Use Cases and Queries

Typical reporting centers on reviewing which source units a third party submitted for a given student or batch. A common query joins back to the parent request table:

• Retrieve all source units for a batch: SELECT SRC_UNIT_ID, SRC_UNIT_CODE, SRC_UNIT_TITLE, SRC_UNIT_GRADE FROM IGS_DA_IN_SRC_UNTS WHERE BATCH_ID = :batch_id AND PERSON_ID = :person_id;
• Summarize earned credit per transferring institution: group by SRC_TRANS_UNIT_INST_ID and sum SRC_UNIT_EARNED_CREDIT.
• Reconcile incoming codes against internal curriculum using SRC_UNIT_CODE and SRC_UNIT_CODE_VERSION.

Interface and inbound-integration developers use the table to validate that a submitted degree audit payload was persisted correctly before evaluation proceeds.

Related Objects

• IGS_DA_REQ_STDNTS — parent table referenced via BATCH_ID and PERSON_ID; the primary relationship in the model.
• IGS_DA_IN_SRC_UNTS_PK — the primary key constraint on SRC_UNIT_ID.
• IGS_DA_IN_SRC_UNTS_U1 — unique index supporting the surrogate key.
• Other IGS degree audit objects (evaluation, request, and student tables) typically reference this data indirectly through the request-student relationship.

Because the documented metadata is limited to a single foreign key, the broader integration surface should be confirmed against the specific 12.1.1 or 12.2.2 instance before relying on additional relationships.