Results for “measurement_type”

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

Overview

IGS_GE_MEASUREMENT is a reference (lookup) table within the Oracle E-Business Suite IGS — Student System product family. Its documented purpose is to describe measurements, meaning it stores the valid codes and descriptive attributes used to qualify numeric sizing or measurement values referenced elsewhere in the student and graduation data model. In the ETRM 12.1.1 schema the object is owned by the IGS schema and exposes nine documented columns. Note that the product is flagged as Obsolete and the table is marked "Not implemented in this database" in the supplied metadata, indicating that in many 12.1.1 / 12.2.2 instances the object exists only as a legacy artifact rather than an active, populated structure.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is hub-leaning. This is a modeling suggestion only: the table is referenced by dependent tables through a single business key column, which is the classic behaviour of a hub — a stable list of unique business entities (measurement codes) around which descriptive and transactional satellites are organised.

Key Information Stored

The table records the master list of measurement definitions. The most significant documented columns are:

• MEASUREMENT_CD — the business key and the single column of primary key IGS_GE_MEASUREMENT_PK. It uniquely identifies each measurement.
• MEASUREMENT_TYPE — categorises the measurement (for example, the class of sizing or measurement being described).
• DESCRIPTION — the human-readable description of the measurement, used in lists of values and reports.
• CLOSED_IND — a status flag indicating whether the measurement code is active or closed for new use.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO-column audit set capturing creation and last-modification metadata.

Regarding key structure: the surrogate primary key IGS_GE_MEASUREMENT_PK is defined on MEASUREMENT_CD. A unique index, IGS_GE_MEASUREMENT_U1, is also documented on MEASUREMENT_CD, confirming it as the business-key candidate. There is no independently documented surrogate ID column separate from the business key in the metadata provided.

Common Use Cases and Queries

The primary practical role of this table is to supply valid measurement values to dependent graduation and award records. Reporting typically joins it to consumer tables to resolve codes into descriptions.

• Listing active measurements for a pick list:

SELECT measurement_cd, description, measurement_type
FROM   igs_ge_measurement
WHERE  closed_ind = 'N'
ORDER  BY measurement_type, measurement_cd;

• Resolving gown and hat sizes on award ceremony records:

SELECT a.award_ceremony_id,
       g.description AS gown_size,
       h.description AS hat_size
FROM   igs_gr_awd_crmn a
       LEFT JOIN igs_ge_measurement g
              ON g.measurement_cd = a.academic_gown_size
       LEFT JOIN igs_ge_measurement h
              ON h.measurement_cd = a.academic_hat_size;

Typical scenarios include validating inbound sizing data against the lookup, generating ceremony or graduation reporting where garment sizing is resolved to text, and auditing which measurement codes remain open versus closed. Because the product is obsolete, most investigations focus on migration or archival reporting rather than live transaction processing.

Related Objects

The documented foreign-key relationships show this table functioning as a parent lookup. The most significant related object is:

• IGS_GR_AWD_CRMN — the award ceremony table, which references IGS_GE_MEASUREMENT twice: once through IGS_GR_AWD_CRMN.ACADEMIC_GOWN_SIZE and once through IGS_GR_AWD_CRMN.ACADEMIC_HAT_SIZE, each joined to IGS_GE_MEASUREMENT.MEASUREMENT_CD.

Beyond these two foreign-key dependencies, no additional consumer tables or APIs are documented in the supplied metadata. Any further references should be confirmed by querying the data dictionary (for example, DBA_CONSTRAINTS and DBA_CONS_COLUMNS) on the target environment, since the obsolete status of the IGS product means supporting objects may vary across 12.1.1 and 12.2.2 installations.