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 |