Licensure
Column Title
Column Title
Column Title
Haven’t found what you’re looking for?
Target Table: ASSESSMENT_FACT
Data Submission Schedule: 40 Day, 80 Day, 120 Day and End of Year (EOY)
Grain: One record per district / test description / assessment school year date / item description / test date / student ID
Load Dependencies
Template Description – The Assessment Fact Template is the only template in the Assessment Domain and it used to capture information on the following assessments:
School Year 2019-2020 Changes:
Delete Options:
File Name Format: DDD_ASSESSMENT_FACT_YYYYMMDDHHMM.fff
File Name Format Example: 001_ASSESSMENT_FACT_201907071201.csv
| Field Number | Field Name | Data Type, Required, Code | Valid Values |
|---|---|---|---|
| 1 | DISTRICT CODE | Character, Required, Key | |
| 2 | TEST DESCRIPTION | Character, Required, Key |
Valid Values
|
| 3 | ASSESSMENT SCHOOL YEAR DATE | Date, Required, Key |
|
| 4 | ITEM DESCRIPTION CODE | Character, Required, Key |
|
| 5 | TEST DATE | Date, Required, Key | YYYY-MM-DD |
| 6 | STUDENT ID | Character, Required, Key | Enter Student ID |
| 7 | LOCATION CODE | Character, Required, Updateable | |
| 17 | STANDARD ACHIEVED CODE | Character, Conditionally Required, Updateable |
Valid Values
|
| 19 | SCORE (RAW SCORE) | Number (4 decimals), Conditionally Required, Updateable | Enter the raw score. |
| 45 | SCORING MODEL CODE | Character, Conditionally Required, Updateable | Valid Values BRIG = Brigance CC = Creative Curriculum WORK = Work Sampling, PETITION = Petition to NMPED DLDSC = Dual Discrepancy Model Assessment NMPKOA = NM Pre-K Observational Assessment |
Submit new assessments for students at each reporting period. EoC, CCR, ENGLISH LANGUAGE PROFICIENCY SCREENER (NMELPAPT), Home/Heritage Language and the NM Language Usage Survey (LUS) assessments must be submitted at each reporting period. Title I Part D Assessment Data may be submitted at any reporting period, but will be reviewed and verified during the EOY collection and as needed during the summer collection.