MCAP - Student Classes File

Selection Criteria

This report creates the MCAP Student Classes File as a .csv file.

How Active Students are selected for the report:

The student is actively enrolled in a school not excluded from State Reporting and did not exit between the report start and end dates.
The student is in grades 03 through 12.
The student must not be excluded from State Reporting on the State/Province - MD page.
The student must not be excluded from Testing on the Testing, Status, Exemptions and Accommodations page.
The student has a MCAP testing status of U on the Testing, Status, Exemptions and Accommodations page.
Note: To ensure that active students have a MCAP Test Status of U on the Testing, Status, Exemptions and Accommodations page, the MCAP - Student Accommodation Report can be run for Active Students with the Update Student's Test Status option set to Yes.

How the Student Class records are selected for the report when Testing File Type Active Classes (Insert/Update) is selected :

Student is actively enrolled in a Course/Section (enrollment exit date is not between the the report start and in date).
The Student's class enrollment record has a MCAP testing status of I, U, or blank.
The Course or Section has a MD Test Subject of ELA, Math, Science, or Social Studies.
Course is not excluded from State Reporting.
Section is not excluded from State Reporting.
The Student is not Omitted from the test subject on the Testing, Status, Exemptions and Accommodations page.
The Student has and an Include/Omit Status of I or U for the testing subject on the Testing, Status, Exemptions and Accommodations page, when not enrolled in a Course with the corresponding testing subject.

How Active Student's Class records are selected for report when Testing File Type Inactive Classes (Delete) is selected:

The student has Course/Section with an enrollment exit date that is between the report start and end dates or the Student's class enrollment record has a MCAP testing status of D.
The Course or Section has a MD Test Subject of ELA, Math, Science, or Social Studies.
Course is not excluded from State Reporting.
Section is not excluded from State Reporting.
The Student has and Include/Omit Status of D for the testing subject on the Testing, Status, Exemptions and Accommodations page, when not enrolled in a Course with the corresponding testing subject.

Updating Student Class MCAP Test Status:

Once the data in the Student Class file is correct, run the report a final time with the Update Student Class Test Status set to Yes. This will update the student's Class MCAP Test Status on the class enrollment record or the test subject Include/Omit status on the Testing, Status, Exemptions and Accommodations page.

When the report is run for Active Classes and the student is enrolled in a class with a MCAP Class test status of I or Blank the MCAP Class test status will be updated to U (Update).
When the report is run for Active Classes and the student has a test subject with an Include/Omit status of I or Blank on the Testing, Status, Exemptions and Accommodations page, the Include/Omit status will update to U.
When the report is run for Inactive Classes and the student is enrolled in a class with a MCAP test status of D or the student has exited the class the MCAP Class test status will be updated to 'Blank'.
When report is run for Inactive Classes and the student has a test subject with an Include/Omit status of D on the Testing, Status, Exemptions and Accommodations page, the Include/Omit status will update to O.

Required Set-up:

Course/Sections have a MD Test Subject if applicable.
Student's Testing, Status, Exemptions and Accommodations page is marked for any tests to exclude or include in testing outside of Course/Section enrollment.

How to Make Multiple Selections or Deselect:

Windows: Hold 'Ctrl' key for multiple selections.
Mac: Hold 'Command' key for multiple selections.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

This report uses the State Reporting Platform to generate results.

Field	Description
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Select Students	Indicate which students to include in the report by selecting one of the following options: The Selected [number] Students Only All Students Note: If running the report for a single student, or group of students, select the students prior to running the report.
Report Start Date	Choose the Start Date for enrollments you want to include
Report End Date	Choose the End Date for enrollments you want to include
Use Alternate School Numbers	Choose Yes if you would like to use Alternate School Numbers when processing the report.
Testing File Type	Choose Active Classes (Insert/Update) or Inactive Classes (Delete)
Update Student's Test Status	Choose No or Yes
Customer Code	Enter the Customer Code specified by MSDE in the MCAP Guide to Importing Classes.
Scheduling – Run Now	Leave Run Now selected to run the report now.
Submit	Click Submit to run the report now
Scheduling – Please Select When to run	Click Schedule to schedule this report to run nightly. Select Weekdays only.
Please Select Schedule Settings	Enter the Start Date and Start time. Click Repeat and Daily.
Please select daily repeat cycle options.	Click Weekdays.
Please select end date range option	Click No End date or enter the day after the last day of school in the Ends On field.
Submit	Click Submit to schedule the report

Back to Top

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Column Letter	Data Element	Description	[Table]FieldName	Field Type	Field Length
A	Update Indicator	Identifies rows to be added or updated for testing accommodations. Valid Values: I = Insert U = Update D = Delete	[S_MD_CC_X]Test_Status Or [S_MD_STU_X]preid_ELA10_IncExc [S_MD_STU_X]parcc_ALGI_IncExc [S_MD_STU_X]parcc_ALGII_IncExc [S_MD_STU_X]parcc_ALGII_IncExc	Alpha	1
B	Customer Code	always MARYLAND		Alpha
C	Organization Code	The two-digit local education agency code (LEA). Extracted from the District Information page. Extracted from Start Page > District Setup > District Information. Plus The four-digit code that identifies the school building. Extracted from the Edit School page. Extracted from Start Page > District Setup > Schools/School Info > Edit School.	[Pref]DistrictNumber + [Schools]SchoolNumber	Numeric	6
D	Class ID	Unique ID for the class.	[cc]sectionid	Alpha	50
E	Class Name	Name of class.	[Courses]Course_Name + [Sections]section_number	Alpha	255
F	Class Grade	Grade of class.	[S_MD_CRS_X]state_grade_level or [Students]Grade_level	Alpha	2
G	Class Subject	Subject of class.	[S_MD_CRS_X]Test_Subject	Alpha	255
H	Role	always Student		Alpha
I	ID	The student identification number assigned by the Maryland State Department of Education. Extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information.	[Students]State_StudentNumber	Numeric	10
J	Course ID	Unique ID for the Course - This is left blank.	[Courses]Course_Number	Alpha	255