Skip to main content
Skip table of contents

ADAM - MCAP Launch Pad Student Import File

This will create the ADAM MCAP student import file needed to upload students to LaunchPad.

Selection Criteria

How the Student records are selected for the report when Testing File Type Active Students is selected:

  • 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 Compliance > General Information (Maryland State Information) page.

  • The student must not be excluded from Testing on the Compliance > Testing, Status, Exemptions and Accommodations page.

  • The student has a ADAM MCAP testing status of active on the Compliance > Testing, Status, Exemptions and Accommodations page.

  • A testing status that is blank will be reported as active.

How the Student records are selected for the report when Testing File Type toBeDeleted is selected:

  • The student has an exit date that is on or between the report start and end dates or the student's ADAM MCAP Testing Status is toBeDeleted on the Compliance > Testing, Status, Exemptions and Accommodations page.

  • The student is in grades 03 through 12.

  • The student's school is not excluded from State Reporting.

  • The student must not be excluded from State Reporting on the Compliance > General Information (Maryland State Information) page.

  • The student must not be excluded from Testing on the Compliance > Testing, Status, Exemptions and Accommodations page.

Updating Student Test Status:

Once the data in the ADAM - MCAP Student Import file is correct, run the report a final time with the Update ADAM Student Test Status set to Yes. This will update the student's ADAM MCAP Test Status on the Testing, Status, Exemptions and Accommodations page.

  • When the report is run for Active Students and the student's ADAM MCAP test status is active or blank it will be updated to active.

  • When the report is run for Inactive Students the student's ADAM MCAP test status will be updated to toBeDeleted.

Report Input

Field

Description

Select Schools to Report

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 Students (active) or Inactive Students (tobedeleted)

Update Student’s Test Status

Choose No or Yes

Report Output

Column Letter

Data Element

Description

[Table]FieldName

Field Type

Field Length

A

sourcedID

The student identification number assigned by the Maryland State Department of Education. Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[Students]State_StudentNumber

Numeric

10

B

status

Identifies rows to be added or updated for testing.

Valid values:

Active

TobeDeleted

Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > Testing Status, Exemptions and Accommodations.

active
or
toBeDeleted

N/A

N/A

C

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.

The student identification number assigned by the Maryland State Department of Education. Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[Students]State_StudentNumber

Numeric

10

D

givenName

The first name of the student. Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[Students]First_Name OR
[StudentCoreFields]PSCore_Legal_First_Name

Alpha numeric

15

E

familyName

The last name of the student. Extracted from the Edit Demographics page. Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[Students]Last_Name OR
[StudentCoreFields]PSCore_Legal_Last_Name

Alpha numeric

25

F

middleName

The middle name of the student. Extracted from the Edit Demographics page. Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[Students]Middle_Name OR
[StudentCoreFields]PSCore_Legal_Middle_Name

Alpha numeric

15

G

grades

Reported Values: 03 through 12

The grade level of the student. Extracted from Student Search > School Enrollment> History > Enrollment History.

[Students]Grade_Level

Alpha numeric

2

H

primaryOrgID

The two-digit local education agency code (LEA). Extracted from the District Information page. Extracted from Start Page > District Management > 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 Management > District Setup > School Info.

[Pref]DistrictNumber +

[Schools]SchoolNumber

Numeric

6

I

orgSourcedids

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 Management > District Setup > School Info.

[Pref]DistrictNumber +

[Schools]SchoolNumber

Numeric

6

J

birthdate

The birth date of the student. Extracted from the Edit Demographics page. Extracted from Start Page > Student Selection> Student Profile > Demographics. Date Format = MM/DD/YYYY.

[Students]DOB

Date

8

K

sex

Reported Values:

  • F = Female

  • M = Male

  • O = Other

The gender of the student. Extracted from the Edit Demographics page. Extracted from Start Page > Student Selection> Student Profile > Demographics. 

[Students]Gender OR [StudentCoreFields]PSCore_Legal_Gender

Alpha numeric

1

L

americanIndianOrAlaskaNative

Reported Values:

Y If RaceCd = 1 OR MD_Eth_Amer_Ind = 1, else N.

Extracted from the Edit Demographics page. Extracted from Start Page > Student Selection> Student Profile > Demographics.  OR Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[StudentRace]RaceCd OR

[S_MD_STU_X]Race_Amer_Ind_TF

Alpha numeric

1

M

asian

Reported Values:

Y If RaceCd = 2 OR MD_Eth_Asian = 1, else N.

Extracted from the Edit Demographics page. Start Page > Student Selection> Student Profile > Demographics.  OR Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[StudentRace]RaceCd OR

[S_MD_STU_X]Race_Asian_TF

Alpha numeric

1

N

blackOrAfricanAmerican

Reported Values:

Y If RaceCd = 3 OR MD_Eth_Black = 1, else N.

Extracted from the Edit Demographics page. Start Page > Student Selection> Student Profile > Demographics.  OR Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[StudentRace]RaceCd OR

[S_MD_STU_X]Race_Black_TF

Alpha numeric

1

O

nativeHawaiianOrOtherPacificIslander

Reported Values:

Y If RaceCd = 4 OR MD_Eth_Hawaiian = 1, else N.

Extracted from the Edit Demographics page. Start Page > Student Selection> Student Profile > Demographics.  OR Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[StudentRace]RaceCd OR

[S_MD_STU_X]Race_Hawaiian_TF

Alpha numeric

1

P

white

Reported Values:

Y If RaceCd = 5 OR MD_Eth_White = 1, else N.

Extracted from the Edit Demographics page. Start Page > Student Selection> Student Profile > Demographics.  OR Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[StudentRace]RaceCd OR

[S_MD_STU_X]Race_White_TF

Alpha numeric

1

Q

demographicRaceTwoOrMoreRaces

Blank

N/A

N/A

N/A

R

hispanicOrLatinoEthnicity

Reported Values:

Y If fedethnicity = 1 OR MD_Hispan_Lat = 1, else N.

Extracted from the Edit Demographics page. Start Page > Student Selection> Student Profile > Demographics.  OR Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

[Students]FedEthnicity OR

[S_MD_STU_X]Hispan_Lat_TF

Alpha numeric

1

S

metadata.iep

Indicates if the student qualifies as a student with disabilities. 

Extracted from the Edit Demographics page. Start Page > Student Selection> Student Profile > Demographics.  OR Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

  • Y - Student receiving special education services. If [S_MD_STU_X]Special_Education = 1

  • N - Student not receiving special education services.

  • E - Student exited special education services. If [S_MD_STU_X]Special_Education = 2

  • 2 - Code 504 student. If [S_MD_STU_X]Special_Education = 4

  • 3 - Student exited special education service, but enrolled in 504. If [S_MD_STU_X]Special_Education = 3

[S_MD_STU_X]Special_Education

[S_MD_REN_X]Special_Education

Alpha numeric

1

T

metadata.lep

Indicates if the student qualifies as an LEP student - Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

Reported Values:

  • N No, not receiving LEP Services

  • Y If [S_MD_STU_X]ELL = 1

  • E If [S_MD_STU_X]ELLL = 2, if exited since 06/01/2015, else N

[S_MD_STU_X]ELL

Alpha numeric

1

U

metadata.section504

Indicates if the student qualifies as a student with disabilities. Extracted from the Edit Demographics page. Start Page > Student Selection> Student Profile > Demographics.  OR Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

  • Y - Student receiving special education services. If [S_MD_STU_X]Special_Education = 1

  • N - Student not receiving special education services.

  • E - Student exited special education services. If [S_MD_STU_X]Special_Education = 2

  • 2 - Code 504 student. If [S_MD_STU_X]Special_Education = 4

  • 3 - Student exited special education service, but enrolled in 504. If [S_MD_STU_X]Special_Education = 3

[S_MD_STU_X]Special_Education

[S_MD_REN_X]Special_Education

Alpha numeric

1

V

metadata.economicDisadvantage

Indicates if the student qualifies for Free or Reduced Lunch. Extracted from Start Page > Student Selection > Transactions > Lunch Transactions

  • Y= Yes, eligible tor receive free or reduced price meals

  • N = No, not eligible to receive free or reduced price meals

  • Blank

[Students]LunchStatus

[Reenrollments]LunchStatus

Alpha numeric

1

W

lepbegindate

The date the student began receiving LEP services. Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

Date Format = MM/DD/YYYY

[S_MD_STU_X]ELL_Begin_Date

Date

8

X

lepexitdate

The date the student ended LEP servic. Extracted from es. Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

Date Format = MM/DD/YYYY.

[S_MD_STU_X]ELL_End_Date

Date

8

Y

localid

The student identification number assigned by the school. Extracted from the Edit Demographics page. Start Page > Student Selection> Student Profile > Demographics. 

[Students]Student_Number

Numeric

10

Z

englishlanguageentrydate

The date special education services ended. Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

Date Format = MM/DD/YYYY.

[S_MD_STU_X]First_Date_In_US_School

Date

8

AA

lepreadingexempt

Indicates if the student qualifies as an LEP Exempt student. Extracted from Start Page > Student Selection > Compliance > State Information > Testing Status, Exemptions and Accommodations.

Reported Values:

  • N = No

  • Y = Yes

[S_MD_STU_X]parcc_lepReadingExempt

Alpha numeric

1

AB

homeleaforlea24

Reported as null.

N/A

N/A

N/A

AC

specialeducationenddate

The date special education services ended Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

If [S_MD_STU_X]Special_Education = 2, then [S_MD_STU_X]SpecEd_End_Date, if exited since 06/01/2015

Date Format = MM/DD/YYYY.

[S_MD_STU_X]SpecEd_End_Date

Date

8

AD

primarydisabilitytype

The major or overriding disability condition that best describes a person's impairment. Extracted from the Maryland State Information page, Start Page > Student Selection > Compliance > State Information > General Information.

Reported Values:

If [S_MD_STU_X]Special_Education = 1 AND

[S_MD_STU_X]Primary_Disability = ‘14’, then ‘AUT’

OR if [S_MD_STU_X]Primary_Disability = ’03’ OR ‘12’, then ‘DB’

OR if [S_MD_STU_X]Primary_Disability = ‘15’, then ‘DD’

OR if [S_MD_STU_X]Primary_Disability = ‘06’, then ‘EMN’

OR if [S_MD_STU_X]Primary_Disability = ‘02’ then ‘HI’

OR if [S_MD_STU_X]Primary_Disability = ‘01’, then ‘ID’

OR if [S_MD_STU_X]Primary_Disability = ‘10’, then ‘MD’

OR if [S_MD_STU_X]Primary_Disability = ‘07’, then ‘OI’

OR if [S_MD_STU_X]Primary_Disability = ‘08’, then ‘OHI’

OR if [S_MD_STU_X]Primary_Disability = ‘09’, then ‘SLD’

OR if [S_MD_STU_X]Primary_Disability = ‘04’, then ‘SLI’

OR if [S_MD_LOG_X]DisabilityCode = ‘13’, then ‘TBI’

OR if [S_MD_LOG_X]DisabilityCode = ‘05’, then ‘VI’,

ELSE Blank.

[S_MD_STU_X]Special_Education AND

[S_MD_STU_X]Primary_Disability

Alpha numeric

3

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close