S_IA_SCH_X (ver 17.2.0)
This table is an extension of the Schools table, and holds Iowa-specific state reporting fields.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| SchoolsDCID | 17.2.0 | Number (10,0) | System generated primary key. |
| Building_Contact_Title | 17.2.0 | Varchar2(50) | The title of the for the school contact; previously used in the Iowa e-Transcript. Migrated from [Schools]IA_BuildingContactTitle. Obsolete as of August 2022. |
| Building_Name_Type | 17.2.0 | Varchar2(2) | The building name type; previously used in the Iowa e-Transcript. Migrated from [Schools]IA_BuildingNameType. Obsolete as of August 2022. |
Building_Phone_Type | 17.2.0 | Varchar2(1) | The building phone type; previously used in the Iowa e-Transcript. Migrated from [Schools]IA_BuildingNumberType. Obsolete as of August 2022. |
| Contact_First_Name | 17.2.0 | Varchar2(50) | The first name of the school contact; previously used in the Iowa e-Transcript. Migrated from [Schools]IA_ContactFirstName. |
| Contact_Last_Name | 17.2.0 | Varchar2(50) | The last name of the school contact; previously used in the Iowa e-Transcript. Migrated from [Schools]IA_ContactLastName. |
| DistrictNumberOverride | 22.11.1 | Varchar2(4) | The override for non-public schools within a Diocese comprised of schools with multiple district numbers. |
| MAX_GPA | 17.2.0 | Double | The maximum GPA value; previously used in the Iowa e-Transcript.Migrated from [Schools]IA_MaximumGPA. |
| MIN_GPA | 17.2.0 | Double | The minimum GPA value; previously used in the Iowa e-Transcript.Migrated from [Schools]IA_MinimumGPA. Obsolete as of August 2022. |
| NwgtGPAMethod | 22.8.2 | Varchar2(50) | The GPA method used to calculate the Non-weighted GPA (eTranscript Collection). |
| WgtGPAMethod | 22.8.2 | Varchar2(50) | The GPA method used to calculate the Weighted GPA (eTranscript Collection). |