S_LA_SCH_X (ver 17.4.0)
This table is an extension of the [Schools] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SchoolsDCID | 17.4.0 | Number (10,0) | Primary key that relates the extended table back to the [Schools] table. |
| InsideCityLimits_TF | 17.4.0 | Number (1,0) | Migrated from: [Schools]LA_CityLimits |
| CongressionalDistrictCode | 17.4.0 | Varchar2 (2) | Migrated from: [Schools]LA_CongDist |
| InstitutionControlCode | 17.4.0 | Varchar2 (2) | Migrated from: [Schools]LA_InstCtrl |
| InstitutionFundingCode | 17.4.0 | Varchar2 (2) | Migrated from: [Schools]LA_InstFund |
| InstitutionTypeCode | 17.4.0 | Varchar2 (2) | Migrated from: [Schools]LA_InstType |
| OrganizationalPatternCode | 17.4.0 | Varchar2 (2) | Migrated from: [Schools]LA_OrgPattCd |
| ReligiousAffiliationCode | 17.4.0 | Varchar2 (2) | Migrated from: [Schools]LA_RelAff |
| BusinessPartnershipCountCode | 17.4.0 | Varchar2 (2) | Migrated from: [Schools]LA_SchBus |
| CalendarCode | 17.4.0 | Varchar2 (3) | Migrated from: [Schools]LA_SchCalCode |
| CloseDate | 17.4.0 | Date | Migrated from: [Schools]LA_SchoolCloseDt |
| MailingAddress | 17.4.0 | Varchar2 (35) | Migrated from: [Schools]LA_SchoolMAddress |
| MailingCity | 17.4.0 | Varchar2 (25) | Migrated from: [Schools]LA_SchoolMCity |
| MailingZipFive | 17.4.0 | Varchar2 (5) | Migrated from: [Schools]LA_SchoolMZip |
| MailingZipPlusFour | 17.4.0 | Varchar2 (4) | Migrated from: [Schools]LA_SchoolMZipExt |
| PhoneExtension | 17.4.0 | Varchar2 (4) | Migrated from: [Schools]LA_SchoolPhoneX |
| SiteCode | 17.4.0 | Varchar2 (6) | Migrated from: [Schools]LA_SiteCode |
| TuitionChargedInd_TF | 17.4.0 | Number (1,0) | Migrated from: [Schools]LA_Tuition |