Student Demographics Extract (Montana)

PATH: MT State Reporting > MT Extracts > Student Demographics

The Student Demographic Extract contains information related to student data.

Image 1: Student Demographic Extract Editor

The 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. 

Image 2: Student Demographic Extract - State Format (TSV)

Generating the Student Demographic Extract

  1. Select the Student Demographics option from the Extract Type dropdown list.
  2. Select the desired Format from the dropdown list.
  3. Choose the desired calendars from the Calendar list. 
  4. 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

Campus Database

Campus Interface

Record Type

The abbreviation for the type of file upload entered.  This will always report as HD.

Alphanumeric, 2 characters

Not dynamically stored

Not dynamically stored

Date

The most recent date a change was made on the file, or the date the file was generated.

Date field, 10 characters
MM/DD/YYYY

Not dynamically stored

Not dynamically stored

Time

The most recent time a change was made on the file, or the date the file was generated.

Time field, 8 characters
HH:<<:SS

Not dynamically stored

Not dynamically stored

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 

Not dynamically stored

Not dynamically stored

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

System Administration > Resources > District Information > District Number

Student State ID

Unique student ID number assigned by OPI.

Numeric, 9 digits

person.stateID

Census > People > Demographics > Person Identifiers > State ID

Student Local ID

Unique student ID number assigned by the school of enrollment.

Numeric, 15 digits

person.studentNumber

Census > People > Demographics > Person Identifiers > Student ID

Last Name

Student's legal last name

Alphanumeric, 40 characters

identity.lastName

Census > People > Demographics > Person Information > Last Name

First Name

Student's legal first name

Alphanumeric, 35 characters

identity.firstName

Census > People > Demographics > Person Information > First Name

Middle Name

Student's middle name

Alphanumeric, 20 characters

identity.middleName

Census > People > Demographics > Person Information > Middle Name

Suffix

Indication of student having a generational name (Jr., III, etc.)

Alphanumeric, 3 characters

identity.suffix

Census > People > Demographics > Person Information > Suffix

Gender

Indication of student being either Male or Female.

Alphanumeric, 1 character

identity.gender

Census > People > Demographics > Person Information > Gender

Birth Date

Student's date of birth

Date field, 10 characters
MM/DD/YYYY

identity.birthdate

Census > People > 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 Census > People > 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

Census > People > 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

Census > People > 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
Y or N

raceEthnicity.code

Census > People > 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
Y or N

raceEthnicity.code

Census > People > 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
Y or N

raceEthnicity.code

Census > People > 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
Y or N

raceEthnicity.code

Census > People > 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
Y or N

raceEthnicity.code

Census > People > Demographics > Person Information >Race/Ethnicity > White

Race Ethnicity Determination

Method used to determine race and ethnicity.  Options are:

  • 01: Parent Identified
  • 02: Self Identified
  • 03: Observer Identified
  • 04: Unknown

     

    A validation exists for this field. See the Upload Validation section for more information.

Numeric, 2 digits

identity.raceEthnicityDetermination

Census > People > 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

Census > People > 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

System Administration > Calendar > Calendar Info > End Date