| SchoolDescription |
| Base Entity | SCHOOL |
| Attribute Name | SchoolDescription |
| Logical Rolename | |
| ColumnName | SchoolDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | Free-form text description of the school in the area for the specified type. |
| Note |
| SchoolDescription Logical Attribute Properties |
| Logical Attribute Name | SchoolDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| SchoolDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SchoolDescription Bound Attachments |
| Name | Current Value |
| SchoolDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SchoolDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber |
| Base Entity | SCHOOL |
| Attribute Name | SequenceNumber |
| Logical Rolename | |
| ColumnName | SequenceNumber |
| RoleName | |
| Domain | XSD:Integer |
| Definition | An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. |
| Note |
| SequenceNumber Logical Attribute Properties |
| Logical Attribute Name | SequenceNumber |
| Datatype | INTEGER |
| Nullable | YES |
| SequenceNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SequenceNumber Bound Attachments |
| Name | Current Value |
| SequenceNumber User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SequenceNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDistrictName |
| Base Entity | SCHOOL |
| Attribute Name | SchoolDistrictName |
| Logical Rolename | |
| ColumnName | SchoolDistrictName |
| RoleName | |
| Domain | MISMOString |
| Definition | The name of the school district in which the property is located. |
| Note |
| SchoolDistrictName Logical Attribute Properties |
| Logical Attribute Name | SchoolDistrictName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| SchoolDistrictName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SchoolDistrictName Bound Attachments |
| Name | Current Value |
| SchoolDistrictName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SchoolDistrictName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDistrictName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDistrictName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDistrictName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDistrictURL |
| Base Entity | SCHOOL |
| Attribute Name | SchoolDistrictURL |
| Logical Rolename | |
| ColumnName | SchoolDistrictURL |
| RoleName | |
| Domain | MISMOURL |
| Definition | The Uniform Resource Locator (web address) for the school district. |
| Note |
| SchoolDistrictURL Logical Attribute Properties |
| Logical Attribute Name | SchoolDistrictURL |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| SchoolDistrictURL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SchoolDistrictURL Bound Attachments |
| Name | Current Value |
| SchoolDistrictURL User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SchoolDistrictURL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDistrictURL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDistrictURL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolDistrictURL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolMaximumGradeType |
| Base Entity | SCHOOL |
| Attribute Name | SchoolMaximumGradeType |
| Logical Rolename | |
| ColumnName | SchoolMaximumGradeType |
| RoleName | |
| Domain | SchoolGradeEnum |
| Definition | The highest grade offered by the school. |
| Note |
| SchoolMaximumGradeType Logical Attribute Properties |
| Logical Attribute Name | SchoolMaximumGradeType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| SchoolMaximumGradeType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SchoolMaximumGradeType Reference Value (Bound to Domain) |
| Name | ValidationRule441 |
| Description | |
| Type | By List |
| Value | Value Description |
| Eigth | Eigth |
| Eleventh | Eleventh |
| Fifth | Fifth |
| First | First |
| Fourth | Fourth |
| Kindergarten | Kindergarten |
| Ninth | Ninth |
| PreKindegarten | PreKindegarten |
| Second | Second |
| Seventh | Seventh |
| Sixth | Sixth |
| Tenth | Tenth |
| Third | Third |
| Twelfth | Twelfth |
| SchoolMaximumGradeType Bound Attachments |
| Name | Current Value |
| SchoolMaximumGradeType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SchoolMaximumGradeType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolMaximumGradeType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolMaximumGradeType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolMaximumGradeType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolMinimumGradeType |
| Base Entity | SCHOOL |
| Attribute Name | SchoolMinimumGradeType |
| Logical Rolename | |
| ColumnName | SchoolMinimumGradeType |
| RoleName | |
| Domain | SchoolGradeEnum |
| Definition | The lowest grade offered by the school. |
| Note |
| SchoolMinimumGradeType Logical Attribute Properties |
| Logical Attribute Name | SchoolMinimumGradeType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| SchoolMinimumGradeType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SchoolMinimumGradeType Reference Value (Bound to Domain) |
| Name | ValidationRule441 |
| Description | |
| Type | By List |
| Value | Value Description |
| Eigth | Eigth |
| Eleventh | Eleventh |
| Fifth | Fifth |
| First | First |
| Fourth | Fourth |
| Kindergarten | Kindergarten |
| Ninth | Ninth |
| PreKindegarten | PreKindegarten |
| Second | Second |
| Seventh | Seventh |
| Sixth | Sixth |
| Tenth | Tenth |
| Third | Third |
| Twelfth | Twelfth |
| SchoolMinimumGradeType Bound Attachments |
| Name | Current Value |
| SchoolMinimumGradeType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SchoolMinimumGradeType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolMinimumGradeType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolMinimumGradeType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolMinimumGradeType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolName |
| Base Entity | SCHOOL |
| Attribute Name | SchoolName |
| Logical Rolename | |
| ColumnName | SchoolName |
| RoleName | |
| Domain | MISMOString |
| Definition | The full name of the specified school. |
| Note |
| SchoolName Logical Attribute Properties |
| Logical Attribute Name | SchoolName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| SchoolName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SchoolName Bound Attachments |
| Name | Current Value |
| SchoolName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SchoolName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolType |
| Base Entity | SCHOOL |
| Attribute Name | SchoolType |
| Logical Rolename | |
| ColumnName | SchoolType |
| RoleName | |
| Domain | SchoolEnum |
| Definition | The public school type as categorized by the common names for grades supported by the indicated school. Each state determines what grade range constitutes elementary education. According to its length, elementary education may be followed (or not) by a number of years of middle school education (generally three years). Secondary education takes place in grades 7-12, depending upon the laws and policies of states and local school districts. There is no national structure, curriculum or governing law; all laws and policies are set and enforced by the 50 state governments and the over 14,000 local school districts. All states and school districts have set the secondary school graduation level as the completion of 12th grade, and the common name for the secondary graduation qualification is the High School Diploma. This diploma name covers a variety of awards for different curricula and standards. |
| Note |
| SchoolType Logical Attribute Properties |
| Logical Attribute Name | SchoolType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| SchoolType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SchoolType Reference Value (Bound to Domain) |
| Name | ValidationRule440 |
| Description | |
| Type | By List |
| Value | Value Description |
| ElementarySchool | Grades PK or K-6 on average, but state and local practice may vary. Age level from: 6 to: 14 |
| HighSchool | Grades 9-12 or 10-12 Age level from: 15 to: 18 |
| JuinorHighSchool | Grades 7-8, 7-9 or 8-9 Age level from: 13 to: 15 |
| MiddleSchool | Grades 6-8 or 7-9 Age level from: 10 to: 14 |
| Other | Other |
| SchoolType Bound Attachments |
| Name | Current Value |
| SchoolType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SchoolType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolTypeGradeCount |
| Base Entity | SCHOOL |
| Attribute Name | SchoolTypeGradeCount |
| Logical Rolename | |
| ColumnName | SchoolTypeGradeCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of grades offered by the indicated shool type. |
| Note |
| SchoolTypeGradeCount Logical Attribute Properties |
| Logical Attribute Name | SchoolTypeGradeCount |
| Datatype | INTEGER |
| Nullable | NO |
| SchoolTypeGradeCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SchoolTypeGradeCount Bound Attachments |
| Name | Current Value |
| SchoolTypeGradeCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SchoolTypeGradeCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolTypeGradeCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolTypeGradeCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolTypeGradeCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolTypeOtherDescription |
| Base Entity | SCHOOL |
| Attribute Name | SchoolTypeOtherDescription |
| Logical Rolename | |
| ColumnName | SchoolTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | Free form description of the school if School Type Other is selected. |
| Note |
| SchoolTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | SchoolTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| SchoolTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SchoolTypeOtherDescription Bound Attachments |
| Name | Current Value |
| SchoolTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SchoolTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolURL |
| Base Entity | SCHOOL |
| Attribute Name | SchoolURL |
| Logical Rolename | |
| ColumnName | SchoolURL |
| RoleName | |
| Domain | MISMOURL |
| Definition | The Uniform Resource Locator (web address) for the school. |
| Note |
| SchoolURL Logical Attribute Properties |
| Logical Attribute Name | SchoolURL |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| SchoolURL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SchoolURL Bound Attachments |
| Name | Current Value |
| SchoolURL User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SchoolURL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolURL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolURL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SchoolURL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |