Search Results igs_pe_suburb_postcd




Overview
Explore in AI Chat

Overview

The IGS_PE_SUBURB_POSTCD table is a reference data entity within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary function is to store a standardized mapping between Australian suburbs and their corresponding postal codes (postcodes), as defined by Australia Post. This table was designed to serve as a validation and lookup source for Australian address data, ensuring consistency in student demographic and statistical records. It is critical to note that the IGS module is marked as obsolete in the provided ETRM documentation for both EBS 12.1.1 and 12.2.2. Furthermore, the metadata explicitly states the table was "Not implemented in this database," indicating it may exist as a shell or planned object without populated data in many deployments, limiting its practical operational role.

Key Information Stored

Based on the documented structure, the table's design centers on the relationship between suburbs and postcodes. The primary key is defined solely on the POSTCODE column, suggesting the table's intent was to list valid postcodes, potentially with associated suburb details. The exact column list beyond POSTCODE is not detailed in the provided metadata, as the description notes "The data supplied is, as yet, undefined." Typically, such a table would include columns like SUBURB_NAME, STATE, and possibly a unique identifier. The annual update cycle mentioned implies the table was intended to be maintained via a data load process to reflect Australia Post's official changes.

Common Use Cases and Queries

The primary use case is the validation and enrichment of Australian address information entered into the Student System. For instance, when recording a student's home location, an application could reference this table to validate that a provided postcode is valid and corresponds to the entered suburb. A typical query would involve a join to the related statistics table to ensure referential integrity or to report on student distributions by geographic area. A sample lookup query would be:

  • SELECT * FROM igs_pe_suburb_postcd WHERE postcode = '3000';

However, given the "obsolete" and "not implemented" status, active development or reporting against this table in a live EBS environment is highly unlikely. Its utility is largely historical or conceptual.

Related Objects

The table maintains a direct foreign key relationship with the IGS_PE_STATISTICS table, which is part of the same obsolete Student System module. The relationship is documented as follows:

  • The IGS_PE_STATISTICS.HOME_LOCATION_POSTCODE column references the IGS_PE_SUBURB_POSTCD.POSTCODE column. This relationship appears twice in the provided metadata, likely indicating two separate foreign key constraints from the IGS_PE_STATISTICS table to this lookup table, potentially for different address-related columns. This design enforced that the postcode recorded in a student's statistical record existed in the official Australia Post mapping.

No other related tables, views, or APIs are documented in the provided metadata. The table's isolation and obsolete status suggest minimal integration with core, active EBS modules like HRMS or Financials.