Component Description OEAAAssessment

Last Updated: 4/7/2015
OEAAAssessment
Component Description
The OEAA Assessment Component has been made available in the Early Roster Collection to allow district users to pre-identify students for Michigan
assessment examinations. Assessment pre-identification is also available via the BAA Secure Site.
Document Contents
Schema
Contains the component characteristic names, descriptions, and specifications (Excel Sheet 2)
List of Values
Contains the list of allowed values for all characteristics of a "List of Values" datatype (Excel Sheet 3)
Staging Area Business
Rule Validations
Contains the list of business rule validations, grouped by characteristic, that apply to this component (Excel Sheet 4)
Version History
Contains a history of updates made to the business rule validations in this school year (Excel Sheet 5)
User Guide
Contains references and support for using this document (Excel Sheet 6)
Collection Matrix
Collection Name
Component Status
CEPI Internal Request for UIC
Not Allowed
Early Childhood EOP
Not Allowed
Early Childhood Fall
Not Allowed
Early Childhood Spring
Not Allowed
Early Roster
Optional
EOY 2016 General Collection
Not Allowed
Fall 2015 General Collection
Not Allowed
IHE Request for UIC
Not Allowed
Request for UIC
Not Allowed
Spring 2016 General Collection
Not Allowed
Student Record Maintenance
Not Allowed
Teacher Student Data Link
Not Allowed
Date Generated: 4/7/2015 8:56:20 AM
Page 1 of 11
Last Updated: 4/7/2015
OEAAAssessment
Schema
Characteristic Name
Characteristic Description
Data Type
Other Test Type
An assessment test the student will be taking.
List of Values
(choose from list)
Other Group Code
(Optional field) School assigned code used for reporting math assessment scores – if a Class
Group Code is assigned by the posted deadline, student answer document labels and /or
preprinted answer documents will be sent organized by Building, Subject and Class Group
Code. The final reports will also group students by the Class Group Codes.
Text (numbers and
letters)
4
Other Research Code 1
(Optional field) School’s can determine how to use this field for use in researching or tracking Numeric Text (can
student assessment information and what 2 digits they will use. Valid values are 01-10.
have leading zeros)
These codes are only reported back in the Student’s Downloadable Data File.
Other Research Code 2
(Optional field) School’s can determine how to use this field for use in researching or tracking Numeric Text (can
student assessment information and what 2 digits they will use. Valid values are 01-10.
have leading zeros)
These codes are only reported back in the Student’s Downloadable Data File.
Date Generated: 4/7/2015 8:56:20 AM
Min
Max Min Value Max Value Decimal Is Multi Required?
Length Length
Positions Valued?
False
False
4
False
False
2
2
False
False
2
2
False
False
Page 2 of 11
Last Updated: 4/7/2015
OEAAAssessment
List of Values
Other Test Type
Code
Description
08
Kindergarten Entry Assessment (KEA)
09
Interim
Date Generated: 4/7/2015 8:56:20 AM
Page 3 of 11
Last Updated: 4/7/2015
OEAAAssessment
Staging Area Business Rule Validations
Characteristic Name
Rule Number Data Validation
OtherGroupCode
254.552.1
If [OtherTestType] does not contain a value
[OtherGroupCode] cannot contain a value
1
When an OtherGroupCode characteristic is provided, the corresponding
Test Type must be provided.
OtherResearchCode1
254.553.1
If [OtherTestType] does not contain a value
[OtherResearchCode1] cannot contain a value
1
When an OtherResearchCode1 characteristic is provided, the
corresponding Test Type must be provided.
OtherResearchCode2
254.554.1
If [OtherTestType] does not contain a value
[OtherResearchCode2] cannot contain a value
1
When an OtherResearchCode2 characteristic is provided, the
corresponding Test Type must be provided.
OtherTestType
254.551.1
If [OtherTestType] = "08"
{SchoolDemographics}.[GradeOrSetting] must = "00"
1
When Other Test Type is submitted with a value of 08, the grade must be
'00' (kindergarten).
254.551.2
If [OtherTestType] = "09"
{SchoolDemographics}.[GradeOrSetting] must be "00", "01", "02", "03",
"04", "05", "06", "07", "08", "09", "10", "11", or "12"
1
When Other Test Type is submitted with a value of 09, the grade cannot
be '14', '20' or '30'.
Date Generated: 4/7/2015 8:56:20 AM
Severity Error/Warning Message
Page 4 of 11
Last Updated: 4/7/2015
OEAAAssessment
Version History
Date
Description
Rule Affected TFS Number
Updated By
2/14/2014
New characteristic
schalkt
5/6/2014
New characteristic
schalkt
5/8/2014
New characteristic
5/8/2014
New characteristic
3/23/2015
Removed the characteristics related to the Math,
Reading, Writing, Social Studies, Science, and ELA tests.
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.455.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.456.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.459.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.448.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.459.2
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.436.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.437.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.438.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.439.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.440.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.441.1
48141
schalkt
Date Generated: 4/7/2015 8:56:20 AM
schalkt
Page 5 of 11
Last Updated: 4/7/2015
OEAAAssessment
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.442.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.443.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.440.2
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.451.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.452.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.457.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.457.2
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.444.2
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.445.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.446.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.447.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.453.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.454.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.458.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.458.2
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.444.1
48141
schalkt
Date Generated: 4/7/2015 8:56:20 AM
Page 6 of 11
Last Updated: 4/7/2015
OEAAAssessment
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.449.1
48141
schalkt
4/7/2015
Referenced characteristic(s) have been removed from
the component.
254.450.1
48141
schalkt
4/7/2015
Referenced characteristics have been removed from the
component.
254.1
schalkt
4/7/2015
Referenced characteristics have been removed from the
component.
254.2
schalkt
4/7/2015
Referenced characteristics have been removed from the
component.
254.3
schalkt
Date Generated: 4/7/2015 8:56:20 AM
Page 7 of 11
Last Updated: 4/7/2015
OEAAAssessment
User Guide
Collection Matrix
Component Status
Defines which collections the component may be submitted. The possible values are:
Name
Description
Required
This component must be submitted in this collection. If omitted in an upload, the file will be rejected upon upload.
Optional
This component is optional in this collection, but may be condtionally required due to validation rules.
Not Allowed
This component cannot be submitted in this collection. If included in an upload file, the file will be rejected upon upload.
Schema
Characteristic Name
The name of the characteristic. This matches the name in the schema.
Characteristic Description
A description of the characteristic and why the data is needed.
Data Type
The system data type. The possible values are:
Name
Classification
Addresses (numbers, letters, #)
string
Date (only)
date
Date (year and month only) (YYYYMM)
string
Decimal Number
decimal
List of Values (choose from list)
string
Names (letters, apostrophe, commas, hyphens, periods)
string
Numeric Text (0-6) (can have leading zeros)
string
Numeric Text (can have leading zeros)
string
Text (free form)
string
Text (numbers and letters)
string
Date Generated: 4/7/2015 8:56:20 AM
Page 8 of 11
Last Updated: 4/7/2015
OEAAAssessment
Whole Number (integer)
int
Yes / No (or True False, or Boolean)
boolean
Min Length
For characteristics of a "text" data type classification, this specifies the minimum character length
Max Length
For characteristics of a "text" data type classification, this specifies the maximum character length
Min Value
For characteristics of a "number" data type classification, this specifies the minimum character length
Max Value
For characteristics of a "number" data type classification, this specifies the maximum character length
Decimal Positions
For characteristics of a "number" data type, this specifies the number of digits allowed to the right of a decmial point.
Is Multi Valued?
TRUE indicates that this characteristic may be submitted multiple times in the same component; FALSE indicates that only one instance is allowed.
Required?
Y indicates this characteristic is required to be submitted as part of the schema; N indicates that is either optional at the schema level (but may be
conditionally required due to validation rules)
Validation Rules
Definitions & Guidance
•
•
•
•
•
Text surrounded by {} indicates that this is a component
Text surrounded by [] indicates that this is a characteristic
A Severity of "1" indicates that the validation is an error; a "2" indicates that it is a warning
CollectionName refers to the value of the "CollectionName" attribute in the collection schema
AsOfDate refers to one of two values:
ƕ For single-certified collections, it is the State-defined certification as of date for the collection
ƕ For ongoing certified collections, it is the value of the [AsOfDate] characteristic in the {StudentRecordMaintenance} component
Version History
Date Generated: 4/7/2015 8:56:20 AM
Page 9 of 11
OEAAAssessment
Last Updated: 4/7/2015
Notes
•
•
TFS Number is used internally by CEPI for tracking purposes
Each update to a validation or a wording change to the error/warning message will be noted here
Date Generated: 4/7/2015 8:56:20 AM
Page 10 of 11
Last Updated: 4/7/2015
OEAAAssessment
Appendix A
Certain entity-related validations in MSDS are dependent on which collection is being submitted. The table below defines the dates or date ranges that
are used in these validations. Validations that are dependent on this table are noted in the specific data validation; they will contain a reference to this
appendix.
Collection
Type
Start Date
End Date
General collections
date
Certification As of Date
Early Childhood collections
date range
Collection Open Date
Student Record Maintenance
date
As of Date (SRM component)
Teacher Student Data Link *
date range
7/1/{AcademicYear start}
8/31/{School Year End}
date range
7/1/{School Year Start}
8/31/{School Year End}
Early Roster
date range
7/1/{School Year Start}
6/30/{School Year End}
all other collections
date
Today's Date
Collection Close Date
* The TSDL collection will use the school year value submitted in the Academic Year
characteristic, if it was submitted. If no value is found, the current school year values are
used.
Date Generated: 4/7/2015 8:56:20 AM
Page 11 of 11