CR Requirements
Utilities
eLearning:
Overview
Class roster refers to the data submitted by the district for use in DMAC Solutions that contains information about the campuses, teachers, students, and classes within the district.
This information is used throughout DMAC Solutions to:
Identify the teachers, students and classes at the campus/district
Create and maintain teacher accounts
Restrict user access to confidential data
Link students to their teachers/classes for reporting
Identify students participating in special programs and services
Technical Requirements
A class roster data file must be an ASCII text file with a tab character as the field delimiter and a carriage return and/or line feed character marking the end of each row.
A district may submit either a single data file containing all class roster data for the district or multiple data files containing all the class roster data for each campus.
Each record in the data file must:
Contain the minimum required fields with valid values
Contain the same number of tab(ASCII 09) delimited fields
End with a carriage return (ASCII 13) and/or line feed (ASCII 10) control character
Column headers are not required in a data file. If column headers are provided, they must be located in the first row of the file.
Text qualifiers are not supported and all quotation marks (ASCII 34) are removed from the file before processing.
PLEASE NOTE: If you have no other option than to send a comma delimited file, you must contact our Help Desk for approval before sending a file.
IMPORTANT: The DMAC Class Roster data file must contain two required fields to identify teachers:
The Teacher ID is a unique value maintained at the district level used to identify teachers locally.
The Teacher Unique ID is a value maintained by the Texas Education Agency (TEA). This ID is unique to each teacher in the state.
It is critically important that once you submit your Class Roster data file, you must continue using the same values for both of these fields for each subsequent submission. The Teacher ID or Teacher Unique ID cannot change once it is submitted to DMAC because this will impact the validity of data tied to teacher’s records.
Please note:
Any school who submits daily imports must send them within the hours of 3:00 p.m. and 12:00 a.m. in order for the files to be imported the following day. Files submitted after 12:00 a.m. will be imported the next business day.
Please call our Help Desk at 1.866.988.6777 with any questions about the Class Roster file.
Specifications | Notes |
Data Files | Class roster files are processed one data file at a time. If a file contains data for multiple campuses, then each campus in the file is processed individually. DO NOT split roster data for a single campus among separate data files. |
Required Fields | IMPORTANT: The omission of any required field from a data file will prevent processing of the entire data file. An invalid value for a required field will prevent processing of that record only. |
Optional Fields | IMPORTANT: The omission or invalid value of any optional field will not prevent adata file from being processed.If an optional field is not provided or contains invalid values, that field will berecorded and reported as unavailable. |
Special Characters | IMPORTANT: Only letters, numbers, spaces, hyphens, and apostrophes will be accepted for field values. All other characters will be removed before validation and processing. |
Field Length | All required field values not meeting the required length will be marked as invalid.All optional field values exceeding the maximum length will be truncated before validation and processing. All leading or trailing spaces are removed from all field values before validation and processing. |
Class Roster Layout
The following table lists, in order, all the class roster fields used in DMAC. Non-required fields not available for export should include a blank or empty string to retain their position in the file.
Name | Length | Required | Element ID |
Campus ID | 9 | Yes | |
Teacher Unique ID | 10 | Yes | |
Teacher ID | 4-14 | Yes | |
Teacher First Name | 1-20 | Yes | |
Teacher Last Name | 1-25 | Yes | |
Teacher Email | 128 | No | |
Service ID | 8 | No | |
Course Content | 30 | No | |
Course Number | 10 | No | |
Course Description | 50 | No | |
Course Period | 2 | No | |
Course Section | 2 | No | |
Course Semester | 2 | No | |
Student Unique ID | 10 | Yes | |
Student ID | 9 | Yes | |
Student First Name | 1-20 | Yes | |
Student Middle Name | 1-20 | Yes | |
Student Last Name | 1-25 | Yes | |
Student Grade | 2 | Yes | |
Student Gender | 1 | No | |
Student Date of Birth | 10 | Yes | |
Hispanic/Latino | 1 | Yes | |
American Indian/ Alaskan Native | 1 | No | |
Asian | 1 | No | |
Black/African American | 1 | No | |
Native Hawaiian/ Other Pacific Islander | 1 | No | |
White | 1 | No | |
At Risk | 1 | No | |
Bilingual | 1 | No | |
CTE | 1 | No | |
Dyslexia | 1 | No | |
ECD | 1 | No | |
ESL | 1 | No | |
GT | 1 | No | |
EB | 1 | No | |
Migrant | 1 | No | |
Special Education | 1 | No | |
Title I | 1 | No | |
504 | 1 | No | |
Military Connected | 1 | No | |
Foster Care | 1 | No | |
Homeless | 1 | No | |
Local ID | 9 | No | |
Date Enrolled | 10 | No |
Sample Data File
The following example displays a screenshot of a standard tab delimited class roster data file. Fixed-width data files are not supported.
Example 1: Tab delimited data file
Field Definitions
Example:
