Assessments

AssessmentIdentifier

String

CTE - CTE_[S_SC_Stu_CATE_C]CERT_ADMIN

Dial 3 and 4 - Concat(District code, school code, 'DIAL 4')

Acad Assistance - 'Academic Assistance'

[Assessment]AssessmentIdentifier

[s_sc_stu_testmissed_c]test_category

State-assigned number for district + [Gen]schoolid +[S_SC_STU_TESTMISSED_C]Test;

R

namespace

Namespace for the Assessment.

CTE, Dial 3 and 4, Academic Assistance - ed.sc.gov/SCDEAssessments

Student Not Tested - ed.sc.gov/SCDEAssessmentsStudentNotTest

R

AcademicSubjects

  /AcademicSubjectDescriptor

The description of the content or subject area (e.g., arts, mathematics, reading, stenography, or a foreign language) of an assessment.

String

CTE - 'Career and Technical Education'

Dial 3 and 4 - 'DIAL 4'

Academic Assistance - 'Academic Assistance'

Student Not Tested -

If [S_SC_STU_TESTMISSED_C]Test is ELA/Math or SCI/SocStud then AcademicSubjectDescriptor is Composite;
If substring([S_SC_STU_TESTMISSED_C]Test,1,2) is (En) then AcademicSubjectDescriptor is English/Language Arts;
If substring([S_SC_STU_TESTMISSED_C]Test,1,3) is (Alg) then AcademicSubjectDescriptor is Mathematics;
If substring([S_SC_STU_TESTMISSED_C]Test,1,2) is (Bi) then AcademicSubjectDescriptor is Science;
If substring([S_SC_STU_TESTMISSED_C]Test,1,2) is (Hi) then AcademicSubjectDescriptor is Social Studies;
If [S_SC_STU_TESTMISSED_C]Test is 'College Readiness' or 'Career Readiness' then AcademicSubjectDescriptor is Career Activities, non-CTE;
If [S_SC_STU_TESTMISSED_C]Test is 'ALT English 1' then AcademicSubjectDescriptor is E

English/Language Arts;
If [S_SC_STU_TESTMISSED_C]Test is 'ALT Algebra 1' then AcademicSubjectDescriptor is Mathematics;
If [S_SC_STU_TESTMISSED_C]Test is 'ALT Biology 1' then AcademicSubjectDescriptor is Science;
If [S_SC_STU_TESTMISSED_C]Test is 'ALT US History 1' then AcademicSubjectDescriptor is Social Studies;
If [S_SC_STU_TESTMISSED_C]Test is 'Listening' then AcademicSubjectDescriptor is English/Language Arts;
If [S_SC_STU_TESTMISSED_C]Test is 'Reading' then AcademicSubjectDescriptor is English/Language Arts;
If [S_SC_STU_TESTMISSED_C]Test is 'Writing' then AcademicSubjectDescriptor is English/Language Arts;
If [S_SC_STU_TESTMISSED_C]Test is 'Speaking' then AcademicSubjectDescriptor is English/Language Arts;
If [S_SC_Stu_CATE_C]CERT_ADMIN is NOT NUll then AcademicSubjectDescriptor is 'Career and Technical Education'

R

AssessmentCategoryDescriptor

Indicates the category for the test that was missed.

String

Not used for CTE, Dial 3 and 4, and Academic Assistance

Student Not Tested - 

If the [S_SC_STU_TESTMISSED_C]request_exclusion is 1 then use the descriptors with "...Exclusion Requested" +[S_SC_STU_TESTMISSED_C]Test_Category, or use the descriptors without "...Exclusion Requested";

Example:

If [S_SC_STU_TESTMISSED_C]request_exlcusion is 1 and [S_SC_STU_TESTMISSED_C]test_category is ELEM_MIDDLE then AssessmentCategoryDescriptor is EM_ER, or AssessmentCategoryDescriptor is ELEM_MIDDLE;

If [S_SC_Stu_CATE_C]CERT_ADMIN is NOT NUll then AcademicCategoryDescriptor= CTE

O

AcademicSubjects

   /AssessmentPeriodDescriptor

Indicates the term the End of Course exam was missed.

[S_SC_STU_TESTMISSED_C]Term_Test_Missed

[AssessmentAcademicSubject]AcademicSubjectDescriptorId, DIAL 4

AssessmentTitle

The title or name of the assessment.

String

CTE - [S_SC_Stu_CATE_C]CERT_ADMIN

Dial 3 and 4 - 'DIAL 4'

Academic Assistance - 'Academic Assistance'

Student Not Tested - [S_SC_STU_TESTMISSED_C]Test;

R

Identification Codes

The student's seven-digit Identification Code is a combination of three-digit District ID and four-digit School ID.

Numeric

CTE - If [S_SC_Stu_CATE_C]CERTIFICATION_OWNER is null then Identification Codes  is the student's enrollment location education organization ID. If [S_SC_Stu_CATE_C]CERTIFICATION_OWNER is not null then identification codes is the entered value.

Not used for Dial 3 and 4, Academic Assistance, and Student Not Tested

EducationOrganizationReference

  /educationOrganizationId

Indicates the school number that identified the missed test and requested the exclusion.

State-assigned number for district and students.schoolid; If [S_SC_Stu_CATE_C]CERTIFICATION_OWNER is NOT NULL then replace EducationOrganizationId with the value in that field.

assessedGradeLevelDescriptor

The typical grade level for which an assessment is designed. If the test assessment spans a range of grades, then this attribute holds the highest grade assessed. If only one grade level is assessed, then only this attribute is used. For example: Adult ,Prekindergarten, First grade, Second grade.

Descriptor

R

platformTypeDescriptor

If [S_SC_STU_X]ELP_Paper=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]GT_Paper=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]CR_Paper=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]G38PaperEla=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]G38PaperMath=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]G38PaperScience=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]G38PaperSocStu=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]EOCEPPaperEla=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]EOCEPPaperMath=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]EOCEPPaperScience=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]EOCEPPaperSocStu=1 then platformTypeDescriptor='Paper-based';

assessmentReference

A reference to the related assessment resource.

R

/AssessmentIdentifier

The state-assigned number for the district.

String

'CTE'_[S_SC_Stu_CATE_C]CERT_ADMIN

[Assessment]AssessmentIdentifier

R

      /Namespace

ed.sc.gov/SCDEAssessments

R

     /SchoolYear

The current school year. For example, 2023.

Numeric

R

studentReference

A reference to the related student resource.

   /studentUniqueId

The student associated with the assessment.

String

StudentAssessment.studentusi

[students]state_studentnumber

R

StudentAssessmentIdentifier

String

Concat [4-digit District ID + 3-digit schoolcode + certification row number + '-' + certification number + Students.DCID]

[StudentAssessment]AssessmentIdentifier

R

AdministrationDate

String

[StudentAssessment]AdministrationDate

For [S_SC_Stu_CATE_C]CERT_ADMINYEAR and values that begin with "SP..." use 3/1/'cat('20',substring(cert_adminyear,3,2)'

For [S_SC_Stu_CATE_C]CERT_ADMINYEAR and values that begin with "FA..." use 11/1/'cat('20',substring(cert_adminyear,3,2)'

R

eventCircumstanceDescriptorId

String

[studentAssessment]eventCircumstanceDescriptorId

If S_SC_STU_TESTMISSED_C.Request_Exclusion=1, “Requested Exclusion” is published. If S_SC_STU_TESTMISSED_C.Request_Exclusion=0, “No Exclusion Requested” is published.

uri://ed.sc.gov/eventCircumstanceDescriptor

R

PerformanceLevels

/assessmentReportingMethodDescriptor

String

[StudentAssessmentPerformanceLevel]AssessmentReportingMethodDescriptorId

'Pass-Fail'

R

/performanceLevelDescriptor

String

[StudentAssessmentPerformanceLevel]PerformanceLevelDescriptorId

If [S_SC_Stu_CATE_C]CERT_PASSED ='Y' then performanceLevelDescriptor='Pass'
If [S_SC_Stu_CATE_C]CERT_PASSED ='N' then performanceLevelDescriptor='Fail'

R

/performanceLevelMet

Numeric

1 for all records 

R

assessmentReference

A reference to the related assessment resource.

R

/AssessmentIdentifier

The state-assigned number for the district.

String

[Assessment]AssessmentIdentifier,Assessment Name, subject, assessment window, and the student not tested flag

Assessment identifier is DIAL 4

R

      /Namespace

[Assessment]Namespace

ed.sc.gov/SCDEAssessments

     /SchoolYear

The current school year. For example, 2023.

Numeric

studentReference

A reference to the related student resource.

   /studentUniqueId

The student associated with the assessment.

String

StudentAssessment.studentusi

[students]state_studentnumber

R

StudentAssessmentIdentifier

[StudentAssessment]AssessmentIdentifier

CONCAT (District code, school code, 'DIAL 4')

AdministrationDate

The date on which an assessment is administered or first day of administration if over multiple days.

Date

[S_SC_STU_X]dial_test_date

[StudentAssessment]AdministrationDate

O

PerformanceLevels

/assessmentReportingMethodDescriptor

[StudentAssessmentPerformanceLevel]AssessmentReportingMethodDescriptorId

'Number Score'

R

ScoreResult

AssessmentReportingMethodDescriptor

If [S_SC_STU_X]DIAL_MOTR_SubScaleNum IS NOT NULL then AssessmentReportingMethodDescriptor='Scale score'
If [S_SC_STU_X]DIAL_MOTR_SubScalePer IS NOT NULL then AssessmentReportingMethodDescriptor='Other'
If [S_SC_STU_X]DIAL_CONC_SubScaleNum IS NOT NULL then AssessmentReportingMethodDescriptor='Scale score'
If [S_SC_STU_X]DIAL_CONC_SubScalePer IS NOT NULL then AssessmentReportingMethodDescriptor='Other'
If [S_SC_STU_X]DIAL_LANG_SubScaleNum IS NOT NULL then AssessmentReportingMethodDescriptor='Scale score'
If [S_SC_STU_X]DIAL_LANG_SubScalePer IS NOT NULL then AssessmentReportingMethodDescriptor='Other'
If [S_SC_STU_X]DIAL_SELF_SubScaleNum IS NOT NULL then AssessmentReportingMethodDescriptor='Scale score'
If [S_SC_STU_X]DIAL_SELF_SubScalePer IS NOT NULL then AssessmentReportingMethodDescriptor='Other'
If [S_SC_STU_X]DIAL_SEmot_SubScaleNum IS NOT NULL then AssessmentReportingMethodDescriptor='Scale score'
If [S_SC_STU_X]DIAL_SEmot_SubScalePer IS NOT NULL then AssessmentReportingMethodDescriptor='Other'

Result

[S_SC_STU_X]DIAL_MOTR_SubScaleNum
[S_SC_STU_X]DIAL_MOTR_SubScalePer
[S_SC_STU_X]DIAL_CONC_SubScaleNum
[S_SC_STU_X]DIAL_CONC_SubScalePer
[S_SC_STU_X]DIAL_LANG_SubScaleNum
[S_SC_STU_X]DIAL_LANG_SubScalePer
[S_SC_STU_X]DIAL_SELF_SubScaleNum
[S_SC_STU_X]DIAL_SELF_SubScalePer
[S_SC_STU_X]DIAL_SEmot_SubScaleNum
[S_SC_STU_X]DIAL_SEmot_SubScalePer

ResultDatatypeTypeDescriptor

The data type of the published result. For example, numbers, percentages, etc.

If [S_SC_STU_X]DIAL_MOTR_SubScaleNum IS NOT NULL then ResultDatatypeTypeDescriptor='Integer'
If [S_SC_STU_X]DIAL_MOTR_SubScalePer IS NOT NULL then ResultDatatypeTypeDescriptor='Percentage'
If [S_SC_STU_X]DIAL_CONC_SubScaleNum IS NOT NULL then ResultDatatypeTypeDescriptorr='Integer'
If [S_SC_STU_X]DIAL_CONC_SubScalePer IS NOT NULL then ResultDatatypeTypeDescriptor='Percentage'
If [S_SC_STU_X]DIAL_LANG_SubScaleNum IS NOT NULL then ResultDatatypeTypeDescriptor='Integer'
If [S_SC_STU_X]DIAL_LANG_SubScalePer IS NOT NULL then ResultDatatypeTypeDescriptor='Percentage'
If [S_SC_STU_X]DIAL_SELF_SubScaleNum IS NOT NULL then ResultDatatypeTypeDescriptor='Integer'
If [S_SC_STU_X]DIAL_SELF_SubScalePer IS NOT NULL then ResultDatatypeTypeDescriptor='Percentage'
If [S_SC_STU_X]DIAL_SEmot_SubScaleNum IS NOT NULL then ResultDatatypeTypeDescriptor='Integer'
If [S_SC_STU_X]DIAL_SEmot_SubScalePer IS NOT NULL then ResultDatatypeTypeDescriptor='Percentage'

assessmentReference

A reference to the related assessment resource.

R

/AssessmentIdentifier

The state-assigned number for the district.

String

[Assessment]AssessmentIdentifier,Assessment Name, subject, assessment window, and the student not tested flag

'Academic Assistance'

R

      /Namespace

ed.sc.gov/SCDEAssessments

     /SchoolYear

The current school year. For example, 2023.

Numeric

studentReference

A reference to the related student resource.

   /studentUniqueId

The student associated with the assessment.

String

StudentAssessment.studentusi

[Students]state_studentnumber

R

StudentAssessmentIdentifier

Concat (District code, school code, 'Academic Assistance')

R

AdministrationDate

The date on which an assessment is administered or first day of administration if over multiple days.

[S_SC_STU_STTESTPERF_C]TEST_DATE

[StudentAssessment]AdministrationDate

eventDescription

CONCAT(YearID,_,S_SC_STU_STTESTPERF_C,Year_ID)

ScoredResults

AssessmentReportingMethodDescriptor

HSASSESS_ELA

HSASSESS_MTH

SCPASS_ELA

SCPASS_MTH

Result

PERFORMANCE_LEVEL_HSASSESS_ELA

PERFORMANCE_LEVEL_HSASSESS_MTH

SCPASS_PERFORMANCELEVEL_ELA

SCPASS_PERFORMANCELEVEL_MATH

ResultDatatypeTypeDescriptor

The data type of the published result. For example, numbers, percentages, etc.

Integer

assessmentReference

A reference to the related assessment resource.

R

/AssessmentIdentifier

The state-assigned number for the district.

String

[s_sc_stu_testmissed_c]test_category, Assessment Name, subject, assessment window, and the student not tested flag

R

      /Namespace

[Assessment]Namespace

ed.sc.gov/SCDEAssessmentsStudentNotTest

     /SchoolYear

The current school year. For example, 2023.

Numeric

studentReference

A reference to the related student resource.

   /studentUniqueId

The student taking the assessment.

String

[StudentAssessment]studentusi

[students]state_studentnumber

R

StudentAssessmentIdentifier

Concat (District code, school code, [s_sc_stu_testmissed_c]test_category)

AdministrationDate

The date on which an assessment is administered or first day of administration if over multiple days.

Date

[StudentAssessment]AdministrationDate

If [s_sc_stu_testmissed_c]term_test_missed is not null then [s_sc_stu_testmissed_c]term_test_missed (assume 11/1/yr for F and 3/1/yr for S) 
(yr is the current school year) or, use 11/1/current school year

O

eventDescription

Concat (YearID,_,[S_SC_STU_TESTMISSED_C]YearID)

ReasonNotTestedDescriptor

Indicates the reason the student missed the assessment.

[StudentAssessment]ReasonNotTestedDescriptorId
[S_SC_STU_TESTMISSED_C]Reason_Not_Tested

If [S_SC_STU_TESTMISSED_C]Request_Exclusion=1 then ReasonNotTestedDecriptor is'Requested Exclusion' else 'No Exclusion Requested'

assessmentAdministrationReference

Assessment administration reference.

R

  /administrationIdentifier

KRA administration identifier.

String

'KRA'

R

  /assessmentIdentifier

KRA assessment identifier.

String

'KRA'

R

  /assigningEducationOrganizationId

Assigning education organization ID.

Numeric

1

R

  /namespace

KRA assessment roster namespace.

String

uri://kra_assessment.com/AssessmentRoster

R

studentEducationOrganizationAssociationReference

Student education organization association reference.

R

  /educationOrganizationId

School education organization ID.

String

[EDFI_SC_73_LIB]formatLEASchoolID

R

  /studentUniqueId

Student unique ID.

String

[Students]State_StudentNumber

R

reportingEducationOrganizationReference

Reporting education organization reference.

O

  /educationOrganizationId

Reporting district education organization ID.

String

[EDFI_SC_73_LIB]formatLEADistrictID

O

studentSchoolAssociationReference

Student school association reference.

R

  /entryDate

Student entry date.

Date

[Students]EntryDate

R

  /schoolId

School ID.

String

[EDFI_SC_73_LIB]formatLEASchoolID

R

  /studentUniqueId

Student unique ID.

String

[Students]State_StudentNumber

R

testingEducationOrganizationReference

School where the KRA course is enrolled.

[CST_STG_STUASSREG_ARR_TMP]CCSCHOOLID

O

  /educationOrganizationId

Testing school from course enrollment.

String

[EDFI_SC_73_LIB]formatLEASchoolID from CST_STG_STUASSREG_ARR_TMP.CCSCHOOLID (course codes 0896, 0897, 1761; priority 1761, then 0896, then 0897)

O

assessmentGradeLevelDescriptor

Grade level descriptor for KRA.

String

[Students]Grade_Level (Kindergarten = 0)

O

studentEducation Organization Association Refrence

educationorganizationid

State-assigned number for the district.

studentUniqueid

The student associated with the record.

[Students]Student_Number

assesment customization

DistrictID

Student’s district ID.

Prefs.Value = districtnumber

district_student_id

Student's local ID.

String

[Students]Student_Number

state_student_id

Student's state ID.

String

[Students]State_StudentNumber

SCHOOLID

The school ID. The school code including the preceding zeroes concatenated with the district ID. For example, if schoolcode is 001 and district ID is 1001, the schoolID will be 1001001.

Prefs.Value

Schools.School_Number

studentfirstname

The student’s last name.

[StudentCoreFields]Legal_Last_Name

studentlastname

The student’s first name.

[StudentCoreFields]Legal_First_Name

studentmiddlename

The student’s middle name.

StudentCoreFields.Legal_Middle_Name

dob

Student's date of birth.

Date

[Students]DOB formatted as MM/DD/YYYY

FedRaceEth

Federal race/ethnicity code.

String

[Students]FedEthnicity / [StudentRace]RaceCD; H=Hispanic, M=Multi, A=Asian, B=Black, P=Pacific Islander, W=White, I=Native American

Gender

Student's gender.

String

[StudentCoreFields]PSCore_Legal_Gender

IEP

IEP indicator.

String

[S_SC_STU_X]InstrSetting; Y if starts with 'S', else N

ELL_LEP

ELL/LEP indicator.

String

[S_SC_STU_X]Engl_Prof; Y if Engl_Prof does not start with '8' or '9'; else N

Course

KRA course and section identifier.

String

Concat([Sections]SEC_SCHID, '-', [CC]Section_Number) from KRA course enrollment (0896, 0897, 1761)

teacher_id

KRA teacher number.

String

[Teachers]TeacherNumber

TeachEmail

KRA teacher email.

String

[Users]Email_Addr

teacher_first_name

KRA teacher first name.

String

[Teachers]First_Name

teacher_last_name

KRA teacher last name.

String

[Teachers]Last_Name

EnrolledDistrictID

Enrolled district ID number.

String

Prefs.Value = districtnumber

EnrolledDistrictName

Enrolled district name.

String

Prefs.Value = districtname

EnrolledSchoolID

Enrolled school ID (district + 3-digit school code).

String

Prefs.Value (districtnumber) + SUBSTR(Schools.School_Number, 1, 3)

EnrolledSchoolName

Enrolled school name.

String

[Schools]Name

LName

Student legal last name.

String

[StudentCoreFields]PSCore_Legal_Last_Name

FName

Student legal first name.

String

[StudentCoreFields]PSCore_Legal_First_Name

MName

Student legal middle name.

String

[StudentCoreFields]PSCore_Legal_Middle_Name

StudentID

Student local ID.

String

[Students]Student_Number

StateID

Student state ID.

String

[Students]State_StudentNumber

DOB

Student date of birth.

Date

[Students]DOB formatted as MM/DD/YYYY

Gender

Student gender.

String

[StudentCoreFields]PSCore_Legal_Gender

EnrolledGrade

Student enrolled grade level.

String

[Students]Grade_Level

truegrade

Student true grade level.

String

[S_SC_STU_X]TrueGrade

Latino

Hispanic/Latino indicator.

String

[Students]FedEthnicity; Y if = 1, N if = 0

RaceI

American Indian indicator.

String

[StudentRace]RaceCD; Y if race code I

RaceA

Asian indicator.

String

[StudentRace]RaceCD; Y if race code A

RaceB

Black/African American indicator.

String

[StudentRace]RaceCD; Y if race code B

RaceP

Pacific Islander indicator.

String

[StudentRace]RaceCD; Y if race code P

RaceW

White indicator.

String

[StudentRace]RaceCD; Y if race code W

English

English proficiency code.

String

[S_SC_STU_X]Engl_Prof

Migrant

Migrant status indicator.

Valid values:

• Blank

• Yes

String

[S_SC_STU_X]Migrant; Y if Migrant = 1, otherwise blank

GR9

Ninth-grade entry year code.

String

[S_SC_STU_X]NinthGradeCode

AltAssessTA_FirstName

Alt assessment test administrator first name.

String

[S_SC_STU_X]AltAssessTA_FirstName

AltAssessTA_LastName

Alt assessment test administrator last name.

String

[S_SC_STU_X]AltAssessTA_LastName

Algebra

Algebra SC-Alt course enrollment indicator.

String

[CC]Course_Number; Y if enrolled in course code 4854

Biology

Biology SC-Alt course enrollment indicator.

String

[CC]Course_Number; Y if enrolled in course code 4855

English1

English SC-Alt course enrollment indicator.

String

[CC]Course_Number; Y if enrolled in course code 4853

USHC

U.S. History and Constitution SC-Alt enrollment indicator.

String

[CC]Course_Number; Y if enrolled in course code 4856

studentEducationOrganizationAssociationReference

educationorganizationid

State-assigned number for the district.

studentUniqueid

The student associated with the record.

[Students]Student_Number

assessment customization

District

The name of the district.

Prefs.Value = districtname

STATE

State code.

'SC'

districtid

District ID number.

Prefs.Value = districtnumber

School

The name of the school.

[Schools]Name

SchoolID

The school ID. District number concatenated with school code.

Prefs.Value + Schools.School_Number

LName

The student's legal last name.

[StudentCoreFields]PSCore_Legal_Last_Name

FName

The student's legal first name.

[StudentCoreFields]PSCore_Legal_First_Name

MName

The student's legal middle name.

[StudentCoreFields]PSCore_Legal_Middle_Name

dob

Student's date of birth.

[Students]DOB formatted MM/DD/YYYY

Gender

Student's gender.

[StudentCoreFields]PSCore_Legal_Gender

StateID

Student's state ID.

[Students]State_StudentNumber

StudentID

Student's local ID.

[Students]Student_Number

grade

Student's grade level.

[S_SC_STU_X]TrueGrade if not null; otherwise [Students]Grade_Level

Latino

Hispanic/Latino indicator.

[Students]FedEthnicity; Y if FedEthnicity = 1

RaceI

American Indian or Alaska Native.

[StudentRace]RaceCD; Y if race code 'I'

RaceA

Asian.

[StudentRace]RaceCD; Y if race code 'A'

RaceB

Black or African American.

[StudentRace]RaceCD; Y if race code 'B'

RaceP

Native Hawaiian or Pacific Islander.

[StudentRace]RaceCD; Y if race code 'P'

RaceW

White.

[StudentRace]RaceCD; Y if race code 'W'

FirstLang

Student's first language spoken at home.

[S_SC_STU_X]First_Lang_Spoken

USEntryDate

Date the student entered US schools.

[S_SC_STU_X]USSchEntryDate formatted MM/DD/YYYY

Migrant

Migrant status indicator.

[S_SC_STU_X]Migrant; Y if Migrant = 1

IEPFLAG

IEP indicator.

[S_SC_STU_X]InstrSetting; Y if InstrSetting starts with 'S'

Plan504

504 plan indicator.

[S_SC_STU_X]InstrSetting; Y if InstrSetting contains 'PR', 'PS', or '504'

altaccess

Alternate ACCESS indicator.

[S_SC_STU_X]AltAssessCde

studentEducationOrganizationAssociationReference

educationorganizationid

State-assigned number for the district.

studentUniqueid

The student associated with the record.

[Students]Student_Number

assessment customization

District

The name of the district.

Prefs.Value = districtname

STATE

State code.

'SC'

districtid

District ID number.

Prefs.Value = districtnumber

School

The name of the school.

[Schools]Name

SchoolID

The school ID. District number concatenated with school code.

Prefs.Value + Schools.School_Number

LName

The student's legal last name.

[StudentCoreFields]PSCore_Legal_Last_Name

FName

The student's legal first name.

[StudentCoreFields]PSCore_Legal_First_Name

MName

The student's legal middle name.

[StudentCoreFields]PSCore_Legal_Middle_Name

dob

Student's date of birth.

[Students]DOB formatted MM/DD/YYYY

Gender

Student's gender.

[StudentCoreFields]PSCore_Legal_Gender

StateID

Student's state ID.

[Students]State_StudentNumber

StudentID

Student's local ID.

[Students]Student_Number

grade

Student's grade level.

[S_SC_STU_X]TrueGrade if not null; otherwise [Students]Grade_Level

Latino

Hispanic/Latino indicator.

[Students]FedEthnicity; Y if FedEthnicity = 1

RaceI

American Indian or Alaska Native.

[StudentRace]RaceCD; Y if race code 'I'

RaceA

Asian.

[StudentRace]RaceCD; Y if race code 'A'

RaceB

Black or African American.

[StudentRace]RaceCD; Y if race code 'B'

RaceP

Native Hawaiian or Pacific Islander.

[StudentRace]RaceCD; Y if race code 'P'

RaceW

White.

[StudentRace]RaceCD; Y if race code 'W'

FirstLang

Student's first language spoken at home.

[S_SC_STU_X]First_Lang_Spoken

USEntryDate

Date the student entered US schools.

[S_SC_STU_X]USSchEntryDate formatted MM/DD/YYYY

Migrant

Migrant status indicator.

[S_SC_STU_X]Migrant; Y if Migrant = 1

IEPFLAG

IEP indicator.

[S_SC_STU_X]InstrSetting; Y if InstrSetting starts with 'S'

Plan504

504 plan indicator.

[S_SC_STU_X]InstrSetting; Y if InstrSetting contains 'PR', 'PS', or '504'

altaccess

Alternate ACCESS indicator.

[S_SC_STU_X]AltAssessCde

DistrictID

Student's district ID

Numeric

Prefs.Value = districtnumber

District

The name of the district

String

Prefs.Value = districtname

TSchoolID

The testing school identifier

String

Computed LEA school ID

Tschool

The testing school name

String

Schools.Name

Precode 1

Student pre-code 1 value

String

[S_SC_STU_X]Precode1

StudentID

Local student number

String

Students.Student_Number

FName

Student first name

String

[StudentCoreFields]Legal_First_Name

LName

Student last name

String

[StudentCoreFields]Legal_Last_Name

MName

Student middle initial

String

First character of [StudentCoreFields]Legal_Middle_Name

Latino

Hispanic/Latino indicator

String

[Students]FedEthnicity If FedEthnicity = 1 then Y

RaceI

American Indian/Alaska Native indicator

String

[StudentRace]RaceCD If RaceI = 1 then Y

RaceA

Asian indicator

String

[StudentRace]RaceCD If RaceA = 1 then Y

RaceB

Black or African American indicator

String

[StudentRace]RaceCD If RaceB = 1 then Y

RaceP

Native Hawaiian/Pacific Islander indicator

String

[StudentRace]RaceCD If RaceP = 1 then Y

RaceW

White indicator

String

[StudentRace]RaceCD If RaceW = 1 then Y

Gender

Student gender

String

[StudentCoreFields]PSCore_Legal_Gender

GradeLevel

Student grade level

String

[S_SC_STU_X]Grade_Level; if [S_SC_STU_X]TrueGrade is not null, TrueGrade takes precedence

GR9

Ninth-grade entry year code

Numeric

[S_SC_STU_X]NinthGradeCode Published with 9GR prepended

English

English language proficiency level

String

[S_SC_STU_X]Engl_Prof Published for specific proficiency codes only (e.g., 6.0, M1–M4, numeric 1–5, 8FRMEL, 8NVREL); otherwise NULL

Migrant

Migrant status indicator

String

[S_SC_STU_X]Migrant If Migrant = 1 then Y

GAndT

Gifted and talented classification

String

[S_SC_STU_X]GT_Qualified GTA or A → C; GTR or R → R; GTB or B → B

DOB

Student date of birth

Date

[Students]DOB

StateID

State student identifier

String

Students.State_StudentNumber

InstrSetting

Instructional setting / program code

String

[S_SC_STU_X]InstrSetting Published when value is one of: SE, SP, SR, 504, PR, PS, RS

Plan504

Section 504 plan indicator

String

[S_SC_STU_X]InstrSetting If InstrSetting is 504, PR, or PS then Y

EOCEPPaperMath

Paper-based Math indicator

String

[S_SC_STU_X]EOCEPPaperMath

EOCEPPaperELA

Paper-based ELA indicator

String

[S_SC_STU_X]EOCEPPaperELA

EOCEPPaperScience

Paper-based Science indicator

String

[S_SC_STU_X]EOCEPPaperScience

EOCEPPaperSocStu

Paper-based Social Studies indicator

String

[S_SC_STU_X]EOCEPPaperSocStu

TrueGrade

Override grade level

String

[S_SC_STU_X]TrueGrade

SectionID

EOCEP course section identifier

String

[CC]Section_Number from enrolled EOCEP course. If student is enrolled in multiple EOCEP sections, published as SectionNumber-CourseCode-TermID

TeacherID

Teacher identifier

String

[CC]Teachernumber for the enrolled EOCEP course

TeachLName

Teacher last name

String

Teacher's last name for the enrolled EOCEP course

TeachFName

Teacher first name

String

Teacher's first name for the enrolled EOCEP course

CertNum

Teacher certification number

String

[Teachers]SIF_StatePrID for the enrolled EOCEP course; 000000 if null

homeroomname

Homeroom teacher name for GOLD section.

String

CST_STG_CENROLL_ASS_TMP (CASE WHEN homeroom='1' THEN teacher first + last END)

DistrictName

District name.

String

Prefs.Value (districtname)

SchoolName

School name.

String

Schools.Name

SCHOOLID

District + 3-digit school code.

String

districtnumber + LPAD(P_SCHOOLID, 3, '0')

teachlname

Teacher last name.

String

CST_STG_CENROLL_ASS_TMP.LAST_NAME

teachfname

Teacher first name.

String

CST_STG_CENROLL_ASS_TMP.FIRST_NAME

username

Teacher email/username.

String

CST_STG_CENROLL_ASS_TMP.EMAIL_ADDR

classid

Teacher number.

String

CST_STG_CENROLL_ASS_TMP.TEACHERNUMBER

firstName

Student legal first name.

String

StudentCoreFields.PSCore_Legal_First_Name

middleinitial

Student middle initial.

String

SUBSTR(StudentCoreFields.PSCore_Legal_Middle_Name, 1, 1)

lastName

Student legal last name.

String

StudentCoreFields.PSCore_Legal_Last_Name

stateid

State student ID.

String

Students.State_StudentNumber

studentid

Local student number.

String

Students.Student_Number

genderID

Student gender.

String

StudentCoreFields.PSCore_Legal_Gender

birthdate

Student DOB.

Date

Students.DOB formatted as MM/DD/YYYY

raceID

Race code for GOLD.

String

Race flags mapped to M/A/B/P/W/I

ethID

Ethnicity code.

String

fedethnicity_txt

languageid

First language code.

String

first_lang_txt

SCHOOLYEAR

Current school year.

String

P_YEARID + 1991

DistrictName

District name.

String

Prefs.Value (districtname)

SchoolName

School name.

String

[Schools]Name

homeroom

Homeroom teacher name when section is flagged as homeroom.

String

CST_STG_CENROLL_ASS_TMP (CASE WHEN homeroom='1' THEN teacher first + last name END)

STUDENTFIRSTNAME

Student legal first name.

String

[StudentCoreFields]PSCore_Legal_First_Name

STUDENTLASTNAME

Student legal last name.

String

StudentCoreFields.PSCore_Legal_Last_Name

STUDENTDOB

Student DOB.

Date

Students.DOB formatted as MM/DD/YYYY

STUDENTID

State student ID.

String

[Students]State_StudentNumber

STUDENTGENDER

Student gender text.

String

PSCore_Legal_Gender mapped F=Girl, M=Boy

STUDENTELLSTATUS

ELL status flag.

String

Engl_Prof mapped to Yes/No (Yes when first char not 8 or 9)

STUDENTIEPSTATUS

IEP status flag.

String

InstrSetting mapped to Yes/No (Yes when first char = S)

AGEGROUP

Age group for pre-K.

String

grade_txt mapped to PK4 when grade = -1

STUDENTETHNICITY

Student ethnicity text.

String

FedEthnicity + Race flags mapped to descriptive value

STUDENTHOMELANGUAGE

Student home language.

String

homelang_txt

DISTRICTID

District number.

String

Prefs.Value (districtnumber)

DISTRICTID_DISTRICTNAME

District name-number combined.

String

districtname + '-' + districtnumber

SCHOOLID

Formatted school ID.

String

v_Schoolidtxt

SCHOOLID_SCHOOLNAME

School name and formatted school ID.

String

schoolname + '-' + formatLEASchoolID(P_PROFILEID, P_SCHOOLID)

CLASSTEACHER

Class teacher full name.

String

CST_STG_CENROLL_ASS_TMP FIRST_NAME + ' ' + LAST_NAME

STUDENTID2

Local student number.

String

Students.Student_Number

tschoolname

Testing school name.

String

CST_STG_CENROLL_ASS_TMP.SEC_SCHNAME

tschoolid

Testing school numeric ID.

String

CST_STG_CENROLL_ASS_TMP.SEC_SCHID

classuniqueid

Unique class identifier.

String

SEC_SCHID + '-' + section_number + '-' + section_dcid

teacherID

Teacher identifier.

String

districtnumber + '-' + users_dcid

teacheremail

Teacher email.

String

CST_STG_CENROLL_ASS_TMP.EMAIL_ADDR