Tool Search: MT Extracts
The Student Demographic Extract contains information related to student data.
Student Demographic Extract EditorThe extract can be generated in the following formats:
- State Format (TSV)
- HTML
- CSV
- XML
Use the State Format when all data has been reviewed for accuracy and information is ready to be uploaded. Use one of the other formats for data review and testing.
Student Demographic Extract - State Format (TSV)Generate the Student Demographic Extract
- Select the Student Demographics option from the Extract Type dropdown list.
- Select the desired Format from the dropdown list.
- Choose the desired calendars from the Calendar list.
- Click the Generate Report button. The extract will display in a new window in the selected format.
Student Demographic Extract Layout
The following lists the data elements and formats for the Student Demographic Extract.
Header Layout
|
Data Element |
Description |
Type, Format and Length |
|---|---|---|
|
Record Type |
The abbreviation for the type of file upload entered. This will always report as HD. |
Alphanumeric, 2 characters |
|
Date |
The most recent date a change was made on the file, or the date the file was generated. |
Date field, 10 characters
|
|
Time |
The most recent time a change was made on the file, or the date the file was generated. |
Time field, 8 characters
|
|
Version |
The most current version of the file interface specification and references to the application system. This field will always report as MT9.1. |
Alphanumeric, 5 characters |
Report Layout
|
Data Element |
Description |
Type, Format and Length |
Campus Database |
Campus Interface |
|---|---|---|---|---|
|
Record Type |
The abbreviation for the type of file upload entered. This will always report as SD. |
Alphanumeric, 2 characters |
Not dynamically stored |
Not dynamically stored |
|
District Number |
This is a unique system number that identifies the district uploading the information, assigned by the Montana Office of Public Instruction. |
Numeric, 4 digits |
district.number |
District Information > District Number |
|
Student State ID |
Unique student ID number assigned by OPI. |
Numeric, 9 digits |
person.stateID |
Demographics > Person Identifiers > State ID |
|
Student Local ID |
Unique student ID number assigned by the school of enrollment. |
Numeric, 15 digits |
person.studentNumber |
Demographics > Person Identifiers > Student ID |
|
Last Name |
Student's legal last name |
Alphanumeric, 40 characters |
identity.lastName |
Demographics > Person Information > Last Name |
|
First Name |
Student's legal first name |
Alphanumeric, 35 characters |
identity.firstName |
Demographics > Person Information > First Name |
|
Middle Name |
Student's middle name |
Alphanumeric, 20 characters |
identity.middleName |
Demographics > Person Information > Middle Name |
|
Suffix |
Indication of student having a generational name (Jr., III, etc.) |
Alphanumeric, 3 characters |
identity.suffix |
Demographics > Person Information > Suffix |
|
Gender |
Indication of student being either Male or Female. |
Alphanumeric, 1 character |
identity.gender |
Demographics > Person Information > Gender |
|
Birth Date |
Student's date of birth |
Date field, 10 characters
|
identity.birthdate |
Demographics > Person Information > Birth Date |
| Photo Opt In | Indicates if a missing child's photo should be synced to the Montana State Edition. |
Numeric, 1 digit 0, 1, 2 or null |
Contact.photoOptIn | Demographics > Missing Child Photo Opt In |
|
Race/Ethnicity |
The general racial or ethnic category which most clearly reflects the individual’s recognition in his or her community, or with which the individual most identifies. |
Numeric, 2 digit |
identity.raceEthnicity |
Demographics > Person Information >Race/Ethnicity |
|
Hispanic/Latino |
A person of Mexican, Puerto Rican, Cuban, South or Central American, or other Spanish culture or origin, regardless of race. A validation exists for this field. See the Upload Validation section for more information. |
Numeric, 1 digit |
identity.hispanicEthnicity |
Demographics > Person Information >Race/Ethnicity > Is person of Hispanic/Latino descent |
|
American Indian Alaska Native |
A person having origins in any of the original peoples of North and South America, including Central America, and who maintains tribal affiliation or community attachment. A validation exists for this field. See the Upload Validation section for more information. |
Alphanumeric, 1 character
|
raceEthnicity.code |
Demographics > Person Information >Race/Ethnicity > American Indian Alaska Native |
|
Asian |
A person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, Vietnam and Laos. A validation exists for this field. See the Upload Validation section for more information. |
Alphanumeric, 1 character
|
raceEthnicity.code |
Demographics > Person Information >Race/Ethnicity > Asian |
|
Black African American |
A person having origins in any of the black racial groups of Africa. A validation exists for this field. See the Upload Validation section for more information. |
Alphanumeric, 1 character
|
raceEthnicity.code |
Demographics > Person Information >Race/Ethnicity > Black African American |
|
Native Hawaiian Pacific Islander |
A person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. A validation exists for this field. See the Upload Validation section for more information. |
Alphanumeric, 1 character
|
raceEthnicity.code |
Demographics > Person Information >Race/Ethnicity > Native Hawaiian Pacific Islander |
|
White |
A person having origins in any of the original peoples of Europe, the Middle East, or North Africa. A validation exists for this field. See the Upload Validation section for more information. |
Alphanumeric, 1 character
|
raceEthnicity.code |
Demographics > Person Information >Race/Ethnicity > White |
|
Race Ethnicity Determination |
Method used to determine race and ethnicity. Options are:
|
Numeric, 2 digits |
identity.raceEthnicityDetermination |
Demographics > Person Information >Race/Ethnicity >Race/Ethnicity Determination |
|
Nickname |
Name by which the student is also known, in addition to his legal name. |
Alphanumeric, 50 characters |
identity.alias |
Demographics > Person Information > Nickname |
|
Calendar End Year |
Indicates the school calendar year for which data is being imported. A validation exists for this field. See the Upload Validation section for more information. |
Numeric, 2 digits |
calendar.endYear |
Calendar Info > End Date |
