Maryland Direct Certification System Enrollment File (MDCS)

On this page:

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

The report selects records based on the following criteria:

All students enrolled as of the count date will be selected.
If using a current student selection, the student must be in the current student selection
Students cannot be identified to be excluded from state reporting from Start Page> Select a Student> State/Province - MD > Maryland State Information page.

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	Click the button to run for the Selected Students or All Students
Count Date	Select the enrollment date for the classes you wish to include
Use Alternate School Numbers	Select Yes if you would like to use Alternate School Numbers when processing the report.
Include Column Headings	Select Yes to include column headings in the file.
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 the Schedule button to schedule this report to run nightly. Check the weekdays only box
Please Select Schedule Settings	Enter the Start Date and Start time. Click the Repeat and Daily buttons.
Please select daily repeat cycle options.	Click the Weekdays only box.
Please select end date range option	Click the No End date or you may complete the Ends On field with the day after you last day of school.
Submit	Click Submit to schedule the report

Back to Top

Report Output

Each of the fields displayed in the output of the report are 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	County Number	This field contains the two-digit County code for student's county of residence. County 99 should be used for out-of state students.	[S_MD_STU_X]County_Code or [Prefs]DistrictNumber	Alpha	2
B	Sponsor Number	This field contains the two-digit local education agency code (LEA). This field is extracted from the District Information page, Start Page > District Setup > District Information.	[Prefs]MD_DistrictLEA	Numeric	15
C	Site Number	This field contains the four-digit code that identifies the school building. This field is extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.	[Schools]School_Number	Numeric	15
D	Social Security Number	This field contains the student's nine-digit social Security number. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]ssn	Numeric	12
E	Birthdate	This field contains the birth date of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics. Date Format = YYYYMMDD.	[Students]DOB	Date	10
F	Last Name	This field contains the last name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Last_Name OR [StudentCoreFields]PSCore_Legal_Last_Name	Alpha numeric	36
G	First Name	This field contains the first name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]First_Name OR [StudentCoreFields]PSCore_Legal_First_Name	Alpha numeric	35
H	Middle Name	This field contains the middle name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Middle_Name OR [StudentCoreFields]PSCore_Legal_Middle_Name	Alpha numeric	35
I	Gender	Reported Values: F = Female M = Male X = Non-binary O = Other This field contains the gender of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Gender	Alpha numeric	1
J	Race	Start Page > Student Selection > Demographics OR Start Page > Student Selection > Maryland State Information. A = Asian B = Black C = White H = Hispanic N = Native American P = Pacific Islands/Alaskan U = Unknown O = Other (multi ethnicity non-hispanic)	[Students]FedEthnicity OR [S_MD_STU_X]Hispan_Lat_TF [StudentRace]RaceCd OR [S_MD_STU_X]Race_Amer_Ind_TF [S_MD_STU_X]Race_Asian_TF S_MD_STU_X]Race_Black_TF [S_MD_STU_X]Race_Hawaiian_TF
K	State Student Identifier (SASID)	This field contains the student identification number assigned by the Maryland State Department of Education. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information.	[Students]State_StudentNumber	Numeric	10
L	Case Number	Students SNAP or TCA Case Number for Direct Verification.	[S_MD_STU_X]Case_Number	Alpha numeric	9
M	Local Student Identifier	This field contains the student identification number assigned by the school. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Student_Number	Numeric	15
N	Address1	This field contains the address of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Mailing_Street or [Students]Street	Alpha numeric	30
O	Address2	This field contains the address of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Mailing_Street or [Students]Street	Alpha numeric	30
P	City	This field contains the city of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Mailing_City or [Students]City	Alpha numeric	30
Q	State	This field contains the state of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Mailing_State or [Students]State	Alpha	2
R	Zip Code	This field contains the zip code of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Mailing_Zip or [Students]zip	Numeric	5
S	Enrollment Start Date	This field contains the student enrollment / reenrollment start date. This field is extracted from the Start Page > Student Selection> Transfer Info.	[Students]EntryDate or [Reenrollments]EntryDate	Date	10