Search Results primary_seq_num

Overview

The IGS_DA_REQ_WIFTRCKS table belongs to the IGS (Student System) product family within Oracle E-Business Suite and stores Degree Audit Request information concerning What-If Track options selected by a student. Records in this table are permitted only for Single Request Types, not Batch request types, reflecting its role as a narrowly scoped staging structure for ad hoc degree audit simulations. Because the entity is not implemented in the current database instance and IGS is flagged as an obsolete product, the table should be treated as a legacy artifact retained for historical reference or upgrade continuity across EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the heuristic classification assigned to this object is standalone. This suggests that, in a data warehouse design, IGS_DA_REQ_WIFTRCKS is best treated as an independent structure without an explicit foreign-key participation, rather than as a hub, link, or satellite tied to another core entity. This classification is a modeling suggestion based on mined key relationships and should guide how the table is incorporated into reporting or migration efforts.

Key Information Stored

The documented physical schema contains 16 columns owned by the IGS schema. The surrogate primary key is defined by IGS_DA_REQ_WIFTRCKS_PK on PRIMARY_SEQ_NUM, which uniquely identifies each What-If track record. The unique index IGS_DA_REQ_WIFTRCKS_U1 also enforces PRIMARY_SEQ_NUM, while the business-key candidate IGS_DA_REQ_WIFTRCKS_U2 spans BATCH_ID, PROGRAM_CODE, MAJOR_SEQ_NUM, and TRACK_SEQ_NUM, forming the natural composite that identifies a What-If track selection.

The most significant columns include:

• PRIMARY_SEQ_NUM — surrogate primary key and unique identifier for the record.
• BATCH_ID — batch context identifier; part of the unique business key.
• PROGRAM_CODE — academic program associated with the What-If track.
• MAJOR_SEQ_NUM — sequence number of the major within the program.
• TRACK_SEQ_NUM — sequence number of the What-If track; the sought column in the user query.
• TRACK_UNIT_SET — unit set qualifying the track selection.
• TRACK_OPTION_VERSION — version of the track option applied.
• TRACK_OPTION_CATALOG — catalog year or catalog reference for the track option.
• TRACK_CAL_TYPE — calendar type linked to the track.
• TRACK_CI_SEQ_NUM — associated sequence for track curriculum item context.
• ORG_UNIT_TRACK — organizational unit owning the track.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical use cases revolve around auditing or migrating What-If track selections recorded against degree audit requests. A common pattern filters on TRACK_SEQ_NUM alongside PROGRAM_CODE and MAJOR_SEQ_NUM to identify which tracks students simulated.

Sample query:

• SELECT PRIMARY_SEQ_NUM, BATCH_ID, PROGRAM_CODE, MAJOR_SEQ_NUM, TRACK_SEQ_NUM, TRACK_UNIT_SET, TRACK_OPTION_VERSION FROM IGS_DA_REQ_WIFTRCKS WHERE TRACK_SEQ_NUM = :track_seq ORDER BY MAJOR_SEQ_NUM;
• SELECT PROGRAM_CODE, COUNT(*) FROM IGS_DA_REQ_WIFTRCKS GROUP BY PROGRAM_CODE;

Reporting scenarios include verifying uniqueness of track combinations against IGS_DA_REQ_WIFTRCKS_U2, tracing a single request back to its track option catalog, and reconciling audit columns for change history.

Related Objects

Because the classification is standalone, documented foreign-key relationships are absent; related objects are therefore inferred from shared business keys and the Degree Audit request domain:

• IGS_DA_REQ_WHATIF — header-level What-If request data sharing BATCH_ID and PROGRAM_CODE.
• IGS_DA_REQ_MAJORS — major-level request detail keyed by MAJOR_SEQ_NUM and PROGRAM_CODE.
• IGS_DA_REQ_HEADERS — parent request structure referenced via BATCH_ID.
• IGS_DA_MAJOR_TRACKS — master track definition matched by TRACK_SEQ_NUM.
• IGS_DA_TRACK_OPTIONS — track option catalog matched by TRACK_OPTION_CATALOG and TRACK_OPTION_VERSION.
• IGS_DA_CAL_TYPES — calendar type reference for TRACK_CAL_TYPE.
• IGS_DA_ORG_UNITS — organizational unit reference for ORG_UNIT_TRACK.

These relationships should be validated against the target instance, as the object is not implemented and IGS remains an obsolete product line.