Search Results igs_ge_measurement

Overview

The IGS_GE_MEASUREMENT table is a foundational reference table within the Oracle E-Business Suite (EBS) Student System (IGS), specifically designated as part of the General (GE) sub-module. Its primary role is to serve as a master list of standardized measurement codes, providing a centralized, normalized data source for various measurement-related attributes across the application. This design enforces data integrity and consistency. It is critical to note that the IGS product line, including this table, is officially marked as obsolete within the EBS 12.1.1 and 12.2.2 releases. This status indicates that while the object may exist in certain installations for backward compatibility, it is no longer under active development or enhancement by Oracle, and its use in new implementations is strongly discouraged.

Key Information Stored

The table's structure is centered on a code-based key. The primary and most significant column is MEASUREMENT_CD, which stores the unique alphanumeric code identifying a specific measurement type or value. Based on its role as a reference table for foreign keys, it likely contains at minimum a description column (e.g., MEASUREMENT_DESC or DESCRIPTION) to provide a human-readable meaning for the code, though this is not explicitly detailed in the provided metadata. The table's purpose is to define discrete measurement values, such as standardized sizes for academic regalia (e.g., 'S', 'M', 'L', 'XL', or specific numeric dimensions), which are then referenced by other transactional tables.

Common Use Cases and Queries

The principal use case for this table is to support the graduation and awards ceremony process by standardizing the sizing for academic regalia. It is referenced to validate and describe the academic gown and hat sizes for graduating students. A typical query would involve joining this table to the graduation ceremony details to translate stored codes into meaningful descriptions for reports or ceremony planning documents.

Sample SQL Pattern:
SELECT crmn.student_id,
gown_meas.measurement_desc AS gown_size,
hat_meas.measurement_desc AS hat_size
FROM igs_gr_awd_crmn crmn,
igs_ge_measurement gown_meas,
igs_ge_measurement hat_meas
WHERE crmn.academic_gown_size = gown_meas.measurement_cd
AND crmn.academic_hat_size = hat_meas.measurement_cd
AND crmn.ceremony_id = :p_ceremony_id;

Related Objects

The table maintains defined foreign key relationships with one other object in the Student System, as documented in the ETRM. The IGS_GR_AWD_CRMN table, which manages graduation award ceremony details, references IGS_GE_MEASUREMENT twice to validate its size attributes.

• IGS_GR_AWD_CRMN.ACADEMIC_GOWN_SIZE: This column is a foreign key referencing IGS_GE_MEASUREMENT.MEASUREMENT_CD, storing the code for the student's academic gown size.
• IGS_GR_AWD_CRMN.ACADEMIC_HAT_SIZE: This column is a foreign key referencing IGS_GE_MEASUREMENT.MEASUREMENT_CD, storing the code for the student's academic hat (mortarboard) size.

These relationships are enforced by the database constraint IGS_GE_MEASUREMENT_PK on the primary key column MEASUREMENT_CD.