Results for “run_prms_id”
9 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_HE_EXT_RUN_PRMS is a table in the IGS schema (IGS - Student System) that stores the extract run parameter details captured for each execution of a Higher Education data extraction process. The table records the selection parameters that govern how data is pulled from the database during an extract run, including inclusion and exclusion directives that control the population of the extracted data set. It is a child table within the extract run hierarchy: each row is associated with a parent extract run defined in IGS_HE_EXT_RUN_DTLS.
Under the heuristic Data Vault classification mined from the foreign key structure, this table is described as satellite-leaning. In modeling terms, this suggests the table behaves as a descriptive satellite attached to the extract run hub/link represented by IGS_HE_EXT_RUN_DTLS, capturing the run-specific parameter attributes and their change history rather than defining a new business entity or a many-to-many relationship.
Key Information Stored
The documented physical schema for this table contains ten columns. The most significant include:
- RUN_PRMS_ID — the surrogate primary key, enforced by the unique index IGS_HE_EXT_RUN_PRMS_PK and repeated as the business-key candidate via the unique index IGS_HE_EXT_RUN_PRMS_U1. It uniquely identifies each parameter row.
- EXTRACT_RUN_ID — the foreign key column that links the parameter record back to its parent extract run in IGS_HE_EXT_RUN_DTLS. This is the principal join column between the two tables.
- PARAM_TYPE — identifies the category or type of the parameter being applied to the run, enabling the extraction logic to interpret the associated inclusion/exclusion flags.
- EXCLUDE — a flag indicating that the associated value or entity should be excluded from the extract.
- ONLY — a flag indicating that the extract should be restricted to the associated value or entity, i.e., only that selection should be included.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns recording the user and timestamp of the initial insert and each subsequent update; these support auditing and concurrency tracking for the parameter records.
The surrogate PRIMARY KEY (RUN_PRMS_ID) is distinct from the business-key unique index; in the documented metadata, IGS_HE_EXT_RUN_PRMS_U1 covers the same RUN_PRMS_ID column, so no separate natural business key is disclosed.
Common Use Cases and Queries
Typical use cases involve auditing or reproducing the exact parameters used in a prior extract run, troubleshooting extracts that excluded or restricted expected records, and reporting on the selection criteria applied by each run. A representative join retrieves run details with their parameters:
- SELECT d.extract_run_id, p.run_prms_id, p.param_type, p.exclude, p.only FROM igs.igs_he_ext_run_dtls d JOIN igs.igs_he_ext_run_prms p ON p.extract_run_id = d.extract_run_id WHERE d.extract_run_id = :run_id;
- Identify restrictive runs: SELECT * FROM igs.igs_he_ext_run_prms WHERE only = 'Y' OR exclude = 'Y';
- Audit trail: SELECT run_prms_id, created_by, creation_date, last_updated_by, last_update_date FROM igs.igs_he_ext_run_prms WHERE extract_run_id = :run_id ORDER BY creation_date;
Related Objects
- IGS_HE_EXT_RUN_DTLS — the immediate parent; joined on EXTRACT_RUN_ID and referenced by the foreign key from IGS_HE_EXT_RUN_PRMS.
- IGS_HE_EXT_RUN_PRMS_PK — primary key constraint enforcing uniqueness of RUN_PRMS_ID.
- IGS_HE_EXT_RUN_PRMS_U1 — unique index on RUN_PRMS_ID, serving as the documented business-key candidate.
- Other IGS extract and Higher Education process tables that reference extract runs (via EXTRACT_RUN_ID) form the surrounding extraction framework and may be joined for end-to-end reporting.
-
Holds the Extract Run Parameters details for each run while extracting data from the database
-
Table: IGS_HE_EXT_RUN_PRMS 12.2.2
Holds the Extract Run Parameters details for each run while extracting data from the database
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
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
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'.