Get documents about "October Setup
Shared by: HC111212161324
-
Stats
- views:
- 5
- posted:
- 12/12/2011
- language:
- English
- pages:
- 32
Document Sample
BEGINNING PROCESS
What is EMIS? (Education Management Information System) software use by all districts
to report data to the ODE for State & Federal ADM funds
1) Gain access – TRECA Account Authorization form
2) Extract and load data files – request by creating UniCenter ticket
3) Check for errors & correct (correction will require another extraction and load)
4) Submit data to the ODE by e-mailing: submit_emis@treca.org
5) Review ODE reports from submission
Student Databases – Why are there so many?
Each database has a specific purpose:
Oct ‘K’ - State reporting for Count Week for ADM next year
Oct to Mar - Run AGG’s and RDET to submit
Dec ‘M’ - Federal reporting for Handicap & Special Ed & ECE coding
Dec to Jan - Run AGG’s to submit
Mar ‘D’ – CTAE - State reporting of Student Workforce Completers
Mar to May – Run REDT to submit
Jun ‘N’ Year End or EOY – State reporting for Accountability & LRC
Apr to Jly - Run AGG’s & RDET to submit
TRECA will create the new database and load first extraction.
2) Extracting and load data files –
To request eSIS file extraction, make request through UniCenter tickets. Be sure to
include what database to extract as well as what files (all files or specify what files).
The EMIS Guide - Appendix I lists the required data fields for each database. The
documentation from the TRECA In-Service will provide you with a checklist of what needs
to be done to help prioritize the work.
3) Run Error Reports
EMSAGG – Student and class list data
EMSRDET – Staff, Course & Building Info data
EMSVLD – This is an extract tool used to verify data accuracy. Run to verify
whatever data field you choose – report looks similar to the AGG/RDET.
EMS_MSG_2 lists error definitions
Never hesitate to call TRECA Student Service for help with errors or questions: (740) 389-
4798. Kathy Heinlen x223 or Crystal Shoemaker x265
4) Submit Data
To submit the most current data, run the EMSAGG & EMSRDET and correct before
having us submit your data to the ODE. To submit, e-mail request to
submit_emis@treca.org. Make sure to include what database and data files are be to
submitted.
5) Report Comparison - ODE Reports & your reports & EMIS reports & the SF3
Oct 06K reporting ends March 3, 2006
EMIS 101 TRECA Training February 2006 Page 1 of 32
EMIS STUDENT & STAFF DATA REPORTING
I. What’s Due for October Reporting – Required to run EMSAGG & EMSRDET
Student Demographics/Attendance/SSID Staff Demographics/Employment
Student ELA data
Student Courses Contracted Staff Employment
Student Program Course Master
Proficiency Only Assessment Career-Technical Education Correlated Class
KRA-L Assessment District & Building General Fall Information
Preschool Assessment Highly Qualified Definition
II. What’s Due for December Reporting – Required to run EMSAGG
For Handicap Students: For Preschool Students:
Student Demographics/Attendance/SSID Student Demographics/Attendance/SSID
Student Programs Early Childhood Record
III. What’s Due for March Reporting – Required to run EMSRDET
Student Employment Record
IV. What’s Due for June Reporting – Required to run EMSAGG & EMSRDET
Student Demographics/Attendance/SSID Staff Demographics/Employment
Student Courses Contracted Staff Employment
Student Program Course Master
State Test Assessments CTAE Completer data
Preschool Assessment District & Building General Information
Gifted Records Career Passport
Discipline Records Corporal Punishment
Early Childhood Records Graduation Credits
______ _______ Majority of Attendance IRN\
______ _______ High Quality Professional Development
______ _______ District & Building General Yearend Information
V. Helpful EMIS Screens
Within the EMIS_MGR option (#10 on Main Menu), you will find:
EMSBST-- Rebuilding Student search
EMSBSF – Rebuilding Staff search
EMSCON-- “Fiscal Year” and Reporting Period is listed. Check for each new database.
Within the EMIS_ELV option (#3on Main Menu), you will find:
EMSAGG -- Batch job creates .SEQ and reports for student data reporting
EMSRDET – Batch job creates .SEQ and report for staff data reporting
EMSVLD – Extra tool used to verify data accuracy
Within the EMIS_ODE option (#7 on Main Menu) you will find these reports that simulate ODE reports:
EMS_EDTADM Student Aggregation Summary by Building
EMS_ESP Education Service Personnel
EMS_SEUNIT Special Ed Approved Units Report
EMS_STAFF Staff Demographics/Employment Report
EMIS 101 TRECA Training February 2006 Page 2 of 32
To get started, you will need access to:
TRECA – www.treca.org
Click on tab for Services / Student Services for:
EMIS pages
TRECA Repots
CSADM portal account – via e-mail to CSADM@NWOCA.ORG
CSADM forum user – via web page at
http://forums.oecn.k12.oh.us/forums/oecn/dispatch.cgi/csadm click on the register button
and follow the screen directions.
eSIS – TRECA Authorized Account Application. Must have a School Wires account or
contact Student Services.
E-TERM – TRECA Authorized Account Application. Must have a School Wires account or
contact Student Services.
IBM’s SSID web page – via UniCenter include the user name, users e-mail, telephone
number for user, and the IP Address for the computer being used. This information will be
sent to IBM with an direct e-mail to the user once created. IBM’s SSID web page –
https://www.ohiossid.com/ssid_login.asp
ODE home page - http://www.ode.state.oh.us/
ODE EMIS home page - http://www.ode.state.oh.us/emis/
ODE Documentation (current report explanations available) -
http://www.ode.state.oh.us/EMIS/documentation/
ODE Newsflash (current year) - http://www.ode.state.oh.us/EMIS/news/
ODE Archives (lists past Documentation & Newsflashes) -
http://www.ode.state.oh.us/EMIS/Archives/
School Wires – via web page at www.TRECA.org - see upper right corner of web page.
UniCenter new user setup – contact John Shank (at john@treca.org) with user name.
UniCenter – http://helpdesk.usd.oecn.k12.oh.us/CAISD/PDMWEB.EXE
EMIS 101 TRECA Training February 2006 Page 3 of 32
Getting into EMIS data:
#1 Sign into E-Term:
User name:
Password:
#2 Select a batabase by typing:
EMIS_SEL
#3 Select EMIS Reformatted File Maintenance Programs by typing:
EMIS_MNT
NOTE: You should now see the following menu
EMIS_MNT EMIS Data Reporting System
Jan 24 06 EMIS Reformatted File Maintenance Programs
___________________________________________________________________
1. EMSFCN Financial Data Maintenance
2. EMSSCN Staff Data Maintenance
3. EMSTCN Student Data Maintenance
4. EMSGCN General Information Maintenance
MENU>
Another way to get to EMIS data:
#1 Sign into E-Term
#2 At the Main Menu select 11. EMIS EMIS Data Reporting System
#3 At the EMIS Main Menu select 1. EMIS_SEL EMIS Select EMIS Database
#4 Select proper database and press enter
#5 At the EMIS Main Menu select 2. EMIS_MNT EMIS Reform File Maint Prog
EMIS 101 TRECA Training February 2006 Page 4 of 32
Getting around in E-Term:
E-Term is menu driven and command driven
When at
MENU>
Type “EMIS” or e.g. “11”
E-Term is menu or command driven
F10 will exit and take you back on menu
From here, Logout or Lo will log out off of E-Term
When at
Menu: EMSTCN Option> .
E-Term is command driven by menu at the bottom of the screen
Menu options differ from File options
Basic Menu Options:
(Re) Accept F7 Help F8 Exit F10 Next
Basic File Options
F6 Top (goes to top of list)
F7 Help (gives list of field data entry options)
F8 Exit (exits file)
F10 Next (finds next record in search)
F11 Find (finds first record in search)
F12 Add (allows new record to be added)
F13 Delete (do not use this delete option)
F14 Modify (modifies current screen data)
F17 Lockmode
F18 Set defaults
S8 Next Screen (to view next screen press Shift & F8) or PageDown
S9 Go Screen 3 (to view last screen press Shift & F9) or End
Also see, EMIS Terms for Beginners – page 8 for help with eSIS Screen Shots
EMIS 101 TRECA Training February 2006 Page 5 of 32
NOTE:
EMIS 101 TRECA Training February 2006 Page 6 of 32
EMSSCN Staff Maintenance
When Reported:
Oct Jun
Oct Jun
Jun
Oct Jun
Oct Jun
Oct
Oct Jun
Oct Jun
At Option: Press F10 to go back one menu option
EMSHQP – enter data into EMIS by hand
3. EMSHQP – Maintain Teacher HQPD Data
HQPD QUICK ENTRY/UPDATE SCREEN
Find: Filter by IRN:
Interrupt Name
School Pos Loc Pos
SSN Teacher Name IRN Code Contr Status HQPD
999999999 LITTEN 999905 205 01 N Y
999999998 DENT 999905 205 01 N Y
999999997 BAKER 999905 206 02 C N
EMSHQP - Maintain Teacher HQPD Data
F6 Top F11 Find
F7 Help F14 Modify
F8 Exit F17 Lockmode
F10 Next
EMSHQT – enter data into EMIS by hand
5. EMSHQT – Maintain Teacher HQT Data
HQT QUICK ENTRY/UPDATE SCREEN
Find: Filter by IRN:
SSN/NAME: 999999999 - KING
Course Previous
Local Classroom Code Course Code Course Description Type IRN Year HQT HQT
9999-MATH03-02 110003 Mathematics K-3 R00 999923 5 5
9999-READ03-02 050102 Reading K-3 R00 999923 5 5
9999-SCI03-02 132120 Science (4-6) R00 999923 5 5
EMSHQT -- Maintain Highly Qualified Teacher data
EMIS 101 TRECA Training February 2006 Page 7 of 32
F6 Top F11 Find
F7 Help F14 Modify
F8 Exit F17 Lockmode
F10 Next
EMSFCL
5. EMSFCL – Maintain Class Master File
Press F8 to exit Class Master screen
eSIS
School / Course Information / Course Maintenance
EMIS 101 TRECA Training February 2006 Page 8 of 32
and
School / Course Information / Course Section Maintenance
Click Specific Course Section Maintenance
EMIS 101 TRECA Training February 2006 Page 9 of 32
NOTE:
EMIS 101 TRECA Training February 2006 Page 10 of 32
EMSTCN Student Maintenance
When Reported:
Oct Dec Mar Jun
Oct Jun
Oct Jun
Oct Dec Jun
Jun
Jun
Mar
Mar
Dec Jun
Fal Win Spg Fin
Jun
Oct Jun
Jun
Jun
Oct Jun
Oct
Jun
Oct Jun
Oct
Oct Jun
Oct Jun
EMIS 101 TRECA Training February 2006 Page 11 of 32
EMSUDM
1 EMSUDM – Maintain Student Demographics/Attendance
EMIS 101 TRECA Training February 2006 Page 12 of 32
eSIS Basic screen
Basic Screen
Loop option
eSIS EMIS Detail screens
EMIS 101 TRECA Training February 2006 Page 13 of 32
eSIS EMIS Detail screens con’t
EMIS Detail 2 includes the ECE record data
EMIS 101 TRECA Training February 2006 Page 14 of 32
eSIS Sped Lite screens
EMIS 101 TRECA Training February 2006 Page 15 of 32
EMIS 101 TRECA Training February 2006 Page 16 of 32
eSIS Other screens with EMIS reportable fields
EMIS 101 TRECA Training February 2006 Page 17 of 32
EMSPGM
1 EMSPGM – Maintain Student Program Record
Find:
JACKSON,AND
Search key Trans Provider
EMIS ID Code/Desc School IRN/Name Empl.ID/Name IRN IRN
Jackson
X99999999 206070 999949 999999999
Resource/Pull-Out Room for Gifted Students led by GIS
Test School Elemen TEACHERS, NAME
EMSPGM - Student Program File Maintenance Program
F6 Top F11 Find F17 Lockmode
F7 Help F12 Add F18 Set defaults
F8 Exit F13 Delete
F10 Next F14 Modify
eSIS Program screen – see EMIS Guide Ch 2 section 2.5.11 for reporting requirements
EMIS 101 TRECA Training February 2006 Page 18 of 32
EMSGIF – only reported in Jun ‘N’ database
1 EMSGIF – Maintain Student Gifted Records
Find:
Student ID Search key
Student ID X99999999 Name Cris,
School IRN/Name 999995 Test School Gifted
Screening Assessment Identified Served
Superior Cognitive Ability N N N 000000 N
Specific Academic Ability - Math Y Y Y 200412 Y
(SAA) Science N N N 000000 N
(SAA) Reading/Writing N N N 000000 N
(SAA) Social Studies N N N 000000 N
Creative Thinking Ability N N N 000000 N
Visual/Performing Arts N N N 000000 N
EMSGIF -- Student Gifted Maintenance Program
F6 Top F11 Find F17 Lockmode
F7 Help F12 Add F18 Set defaults
F8 Exit F13 Delete
F10 Next F14 Modify
Gifted & Talented screen – reported for Jun ‘N’
EMIS 101 TRECA Training February 2006 Page 19 of 32
EMSMGA – only reported in Jun ‘N’ database
1 EMSMGA – Maintain Student Achievement Testing Records
Find:
STUDENT NAME ID GRADE HANDICAP
Ron X999999999 08 **
TEST GRADE MARCH SCORES REQ
STUDENT TEST SUBJ DATE WHEN ENROLL ---------- TEST TEST WAIV PCT PART
ID LEVEL TYPE TAKEN TESTED IRN SCALED RAW ACC. TYPE REAS PRO RATE
X99999999 08 M 03/2005 08 999990 *** 240 NO STR * * *
Middle School
X99999999 08 R 03/2005 08 999990 *** 310 NO STR * * *
Middle School
/
/
/
Record not found. Displaying next record.
EMSMGA -- Student Achievement Testing Record Maintenance Program
F6 Top F11 Find F17 Lockmode
F7 Help F12 Add F18 Set defaults
F8 Exit F13 Delete
F10 Next F14 Modify
eSIS Standardized Testing screens – Achievement
EMIS 101 TRECA Training February 2006 Page 20 of 32
EMSMGX – only reported in Jun ‘N’ database
1 EMSMGX – Maintain Student OGT Testing Records
Find:
STUDENT NAME ID GRADE HANDICAP
McBye X99999990 10 **
TEST GRADE MARCH No SCORES REQ
STUDENT TEST SUBJ WHEN DATE ENROLL OF ---------- TEST TEST WAI GRA PCT PART
ID LEV. TYPE TAKEN TAKEN IRN ATT SCALED RAW ACC. TYPE REA REQ PRO RATE
X99999990 10 C 10 03/2005 999993 01 *** 310 NO STR * Y * *
High School
X99999990 10 M 10 03/2005 999993 01 472 410 NO STR * Y * *
High School
X99999990 10 R 10 03/2005 999993 01 451 410 NO STR * Y * *
High School
X99999990 10 S 10 03/2005 999993 01 *** 335 NO STR * Y * *
High School
X99999990 10 W 10 03/2005 999993 01 *** 390 NO STR * Y * *
High School
Record not found. Displaying next record.
EMSMGX -- Student OGT Testing Record Maintenance Program
F6 Top F11 Find F17 Lockmode
F7 Help F12 Add F18 Set defaults
F8 Exit F13 Delete
F10 Next F14 Modify
eSIS Standardized Testing screens - OGT
EMIS 101 TRECA Training February 2006 Page 21 of 32
EMS– only reported in Jun ‘N’ database
1 EMSMGX – Maintain Student OGT Testing Records
Find:
Student ID Search key
Student ID 999999998 Name Amb,
SSID
Sex M Proficiency Score Scaled Score
Racial/Ethnic Code W Reading 2 229
Writing 2 055
Diploma Date 06/02/2005 Math 2 254
Completed Date 10/2003 Citizenship 2 222
Science 2 212
Building IRN 999994 High School
District IRN 999999 Local SD
EMSSPO -- Student Proficiency Only Maintenance Program
F6 Top F11 Find F17 Lockmode
F7 Help F12 Add F18 Set defaults
F8 Exit F13 Delete
F10 Next F14 Modify
eSIS Ohio Proficiency Only screens
Common View / Ohio / Proficiency Only
EMIS 101 TRECA Training February 2006 Page 22 of 32
NOTE:
EMIS 101 TRECA Training February 2006 Page 23 of 32
EMSGCN General Information – hand enter into EMIS
4. EMSGCN General Information Maintenance
3. EMSGEN - District Fall Information DQ – OCT REPORTING ONLY
AND
1. EMSMDR - District Yearend Information DR – JUN REPORTING ONLY
EMIS DISTRICT GENERAL FALL INFORMATION
District IRN 999999
Participation Eligibility 0.00
Kindergarten Entrance Birthdate (A, B, *): B
Number of eligible nonpublic students with disabilities
who are not being served
Number of Students Home Schooled
EMSGEN -- District General Fall Information
F7 Help
F8 Exit
F14 Modify
F17 Lockmode
EMIS 101 TRECA Training February 2006 Page 24 of 32
EMSGCN General Information – hand enter into EMIS
4. EMSGCN General Information Maintenance
4. EMSMDF - Building Fall Information DF – OCT REPORTING ONLY
AND
2. EMSMBP - Building Yearend Information DB – JUN REPORTING ONLY
Find: BUILDING FALL INFORMATION
Building IRN 999995 Comm School
--------------------
** ESC's are not required to report a fall building (DF) record.
Note: The following 5 questions are required by City, Ex.Village, Local, JVS,
and Community Schools. Not required by DYS and State Schools.
Be sure to check screens 2-4 to see if your entity needs to complete other
portions.
--
Is this building open during the following days of count week? (Y/N):
Monday : Y
Tuesday : Y
Wednesday: Y
Thursday : Y
Friday : Y
Find: BUILDING FALL INFORMATION
You are currently working with: 999995 - Comm School
------------------------------
Note: All fields on this screen should be completed by ALL entities
--
First day of school scheduled for students in grades 1-12: 08/28/2005
First day of school scheduled for Kindergarten students: 08/28/2005
Last day of school scheduled for students (K-12): 06/04/2006
Hours per day scheduled:
Grades 1-8 : 5.00 Alternate Day Full Day Kindergarten:
Grades 9-12: 5.00 Every Day Full Day Kindergarten :
Half Day Kindergarten : 2.50
Find: BUILDING FALL INFORMATION
You are currently working with: 999995 - Comm School
------------------------------
Note: The fields on this screen should ONLY be completed by Community
-- Schools whose contract for the school year requires hours.
Parent Teacher conference hours scheduled:
Professional Meeting (Teachers) hours scheduled: 140
Annual hours in session scheduled...
Grades 1-8 : 920 Half Day Kindergarten : 460
Grades 9-11: 920 Alternate Full Day Kindergarten:
Grade 12 : 920 Every Day Full Day Kindergarten:
EMIS 101 TRECA Training February 2006 Page 25 of 32
Find: BUILDING FALL INFORMATION
You are currently working with: 999995 - Comm School
------------------------------
Note: The fields on this screen should be completed by all City, Ex. Village
-- Local, JVS, DYS and also Community Schools whose contract requires days.
Parent Teacher Conference FTE Scheduled:
Professional Meeting (Teachers) FTE Scheduled:
Annual Days in Session Scheduled...
Grades 1-8 : Half Day Kindergarten :
Grades 9-11: Alternate Full Day Kindergarten:
Grade 12 : Every Day Full Day Kindergarten:
EMIS_ELV Run Error Reports before submitting data
EMIS Main Menu
3. EMIS_ELV EMIS Data Extraction, Loading, and Validation Programs
EMIS_ELV EMIS Data Reporting System
Feb 24 05 EMIS Data Extraction, Loading, and Validation Programs
1. EMS4502 Create 4502 report from EMIS financial detail file
2. EMSAGG Submit EMSAGG Procedure to Batch
3. EMSAGG4 Generate Aggregation Reports
4. EMSAGG5 Aggregation Validation Error Report
5. EMSAGG6 Aggregation Exclusion Report
6. EMSAGG7 Aggregation Detail Report
7. EMSR2D Extract EMIS records into ODE Detail File format
8. EMSRDET Validate and Dump Reformatted Records
9. EMSRX Submit EMSRX Reformatted File Load Job to Batch
10. FFIMPORT Import Five Year Financial Forecast from CSV Delimited File
11. EMSUBSUM Report of records submitted to ODE
12. EMSVLD EMIS Data Validation Reports
13. RUN_EMSR2D Submit RUN_EMSR2D Procedure to Batch
14. RUN_EMSVLD Submit RUN_EMSVLD Procedure to Batch
15. RUN_RDET Submit EMSRDET Procedure to Batch
16. JVSEXTR Extract Proficiency data for for JVS Loading
17. JVSLOAD Load extracted JVS Proficiency data
Press <cr> for first screen...
Menu
#1 You must select a database before running any of the error reports
#2 You must re-run the error report and re-submit every time you make changes
#3 You must re-run and re-submit at SSDT & ODE request due to software updates
Oct ‘K’ - State reporting for Count Week for ADM next year
October to March - Run EMSAGG and EMSRDET before submitting
EMIS 101 TRECA Training February 2006 Page 26 of 32
Dec ‘M’ - Federal reporting for Handicap & Special Ed & ECE coding
December to January - Run EMSAGG before submitting
Mar ‘D’ – CTAE - State reporting of Student Workforce Completers
March to May – Run EMSRDET before submitting
Jun ‘N’ Year End or EOY – State reporting for Accountability & LRC
April to July - Run EMSAGG & EMSRDET before submitting
EMIS SCREENS
EMIS_ELV
EMIS Data Extraction, Loading, and Validation Programs
EMSAGG
Run to verify data. Can be run whenever you would like to check your database for accuracy. This also prepares
your staff file for submission.
Fiscal Year 06
Reporting Period K
Report Option S (Summary) or D (Detail) or B (for both)
Aggregations to Perform ________________________________________________________
EMIS database code 06K_
Name of batch queue job should run on SYS$BATCH___________________________
Time batch job should start running
Username batch job will run under TRECA_KATHY____
Additional qualifiers for batch job /LOG/KEEP/NOTIFY .
EMSAGG -- Submit EMSAGG.COM Procedure to Batch
(Re) Submit batch job F7 Help
F8 Exit -- do not submit batch job
EMSAGG.SEQ - Sequential file that gets sent to the State.
EMSAGG4S.TXT - Summary ADM Control - FTE by Gr/Race/Sex
EMSAGG4D.TXT - Detail ONLY gets generated if you select report option “D”
EMSAGG5.TXT - EMIS Validation Errors
EMSAGG6.TXT - Excluded Students
EMSAGG7.TXT - EMIS aggregation detail report (Included Students)
EMSRDET
Final step necessary when submitting your data to Columbus. This prepares your staff file for submission.
Example of running EMSRDET:
EMSRDET 1.4-001, 95.08.08
EMSRDET -- Validate and dump reformatted record program
This program allows you to dump reformatted records to detail files. It differs from EMSR2D in that records
are validated before dumped, & only valid reformatted records are dumped to the detail files.
Fiscal year to use on detail records: <06> __
Reporting period to select: < > _ K
EMIS 101 TRECA Training February 2006 Page 27 of 32
Enter alternate sort codes to extract:
< >
__________________________________________________
Continue, Re-enter, or Exit (C,R,E,?) <C> _
EMSRDS06K.SEQ - Sequential file that gets sent to the State for staff
EMSRD06K.TXT - Error
EMSAGG4D.TXT - Detail ADM Control - FTE by Gr/Race/Sex
AND
EMSAGG7.TXT – EMIS Aggregation Detail Report (Included Students)
NOTE: Also helpful for SF3 Flow All report – Status field
1 = Student being instructed at your district
1X – where X = Student Status
2 = Student receiving instruction elsewhere
2X – where X = Att/Home IRN Indicator
3 = Student is open enrolled into a district, is partially educated there and is sent to a third district for
further education
3X – where X = Att/Home IRN Indicator
4 = Student attends a JVS not in the jointure of the sending district
4X – where X = Att/Home IRN Indicator
Attending/Home IRN Status Values
10 Instructing/Resident 1F Not enrolled Public student receives
11 Instructing/Tuition 1H ESC providing instruction and servic
12 Instructing/Voc Contract 1I Not Enrolled. Receiving PS Spec Ed,
13Instructing/Unauthorized 1L Non resident open enrollment counted
14 Instructing/Out-of-State Tuition 1M Community School
15 Instructing/Out-of-State Non-Tuition 1P All Court Ordered Institutional Plac
16 Instructing/Nonpublic 1S Non resident attending district base
17 Instructing/With Grandparent 1T All Institutional Placements not cou
18 Instructing/Senior 1U State supported school (e.g.OSB, OSD
19 Instructing/Open Enrollment 1W Non Resident attending under Title 1
1A Instructing/Parent Employee 20 Non-instructing/Resident
1B Instructing/Non-County Co-op 21 Non-instructing/Tuition
1C Foster Care Placement 22 Non-instructing/Voc Contract
1D Instructing/Direct Pay Tuition 23 Non-instructing/JVS
EMIS 101 TRECA Training February 2006 Page 28 of 32
24 Non-instructing/County Board 2P All Court Ordered Institutional Plac
25 Non-instructing/Post Secondary 2S Student attending based on Superinte
26 Non-instructing/MRDD 2T All Institutional Placements not cou
27 Non-instructing/Other Co-op 2V Vouchers - Cleveland Only
28 Non-instructing/DYS-Rehab 2W District Student attending under Tit
29 Non-instructing/Proprietary 39 Open Enrollment - Non Residents ate
2C Non-instructing/Court Placement 35 Open Enrolled / PSEO
2E Non-instructing/Open Enrollment 3X Non resid, open enrolled attn other entity
2M Student who attends Community School 49 JVS open enrolled student
EMIS SCREENS
EMIS_ELV
Tools used to help verify your EMIS data accuracy
EMSVLD
Run to verify data. Can be run whenever you would like to check your database for accuracy.
Enter Reporting Period (?): <A> _
K
Ignore undefined (blank) fields (Y,N) (?): <N> _
Enter sort code of records to validate (blank to end) (?): < > *
(by inserting an asterisk all records will be included, ex. CI, CN, etc.)
Enter sort code of records to validate (blank to end) (?): < > __
Restrict to School IRN (blank to include all) (?): < > ______
Restrict to class code (blank to include all) (?): < > ____________________
These are the sort types you selected:
Reporting Period is K: OCT15 Ignore Undefined (blank) Fields: N
School IRN Chosen: ALL
Classroom Code Chosen: ALL
CI: Staff Demographics CK: Staff Employment
CN: Staff Class - Master CV: Voc Ed Correlated Class
CW: Multiple-Teacher Classes DB: District Building Profile
DQ: District General Info for Fall DR: District General Yearend
GC: Building Testing GI: Student Demographics
GK: Student Attendance GL: Student Summer School
GP: Student Proficiency Only GN: Student Subject
GQ: Student Program GT: Student Testing
QB: Spending Plan QC: Financial Information
You can choose to continue, exit, or reenter these sort codes. If you choose to reenter, all your previous entered
values will be discarded.
Continue, Add more, Re-enter or Exit (C,A,R,E) (?) <C> _
EMIS 101 TRECA Training February 2006 Page 29 of 32
EMSVLD.TXT - Error Report
EMIS SCREENS
EMIS_ODE
EMIS Reports Similar To Those Received From ODE
EMIS_ODE
This is where you’ll find reports that can be run to check your October Data in EMIS! SSDT has provided a
series of reports, which simulate the reports received from ODE once data has been submitted. These reports do
some error checking but not all the checking contained in the reports ODE creates. By checking these reports
you may catch some additional errors that were not encountered by the validations and aggregations.
EMIS_ODE EMIS Data Reporting System
Jan 16 06 EMIS Reports Similar to those received from ODE
The reports on this menu simulate reports from ODE using
data located at the DDAS. The reports can be used to verify
the EMIS information prior to submission to ODE.
1. EFM_LOCAL Expenditure FLow Model reports
2. EMS_CHILDC December Disability Child Counts (DCC_RLEVEL) *
3. EMS_EDTADM Student Aggregation Summary by Building (EDIT-ADM) *
4. EMS_ESP Education Service Personnel (ESP-STAFF)
5. EMS_PSUNIT Preschool Unit Inclusion Report
6. EMS_SEUNIT Special Ed Approved Units Report (SPEC_ED) *
7. EMS_STAFF Staff Demographics/Employment Report (DEMO_JOB)
Note: Reports with '*' after the description require that
the aggregation routines (EMSAGG) have already been executed
EMIS 101 TRECA Training February 2006 Page 30 of 32
EMIS_RPT EMIS Data Reporting System
Jan 16 06 EMIS Reports
1. EMSRIDS State Assigned Staff Ids to SSN Cross Reference Report
2. EAUDRPT EMIS Reformatted File Auditing Report
3. FORECAST Five Year Forecast Data Report
4. EMSSTM EMIS Statement from financial listmakers
EMIS Information Reports
5. EMS_CODES EMIS Field Value Report (UDMS-4RW)
6. EMS_FIELDS EMIS Fields with Code Values (UDMS)
7. EMS_RANGES EMIS Fields with Range Validations (UDMS)
8. EMS_MSG_1 EMIS Standard Error Messages (UDMS)
* 9. EMS_MSG_2 EMIS Standard Error Messages with corrective Actions (UDMS)
EMIS Student Information Reports
10. EMS_ECE Student Early Childhood Report (UDMS)
11. SEC_504 Students marked as having a Section 504 Plan (UDMS)
12. CTA_RPT Career Technical Adult Education Information Report (UDMS)
13. DISADV_SUM EMIS Disadvantagement Student Summary (UDMS)
* 14. HANDICAP EMIS Summary Report of Handicap Students (UDMS)
* 15. OE_COMING EMIS Open Enrollment - Students Coming Report (UDMS)
* 16. OE_GOING EMIS Open Enrollment - Students Going Report (UDMS)
17. PROGRAM_80 EMIS Student Program Report by Building - 80 Column (UDMS)
18. PROG_BLDG EMIS Student Program report by Building - 132 Column (UDMS)
19. RFO_RPT EMIS Student Reading First Ohio (RFO) report (UDMS)
* 20. STU_AH EMIS Students Attending/Residing in other Districts (UDMS)
21. STU_ATTEND EMIS Student Attendance Summary Report (UDMS)
22. STU_DISC EMIS Detail of Student Discipline by Bldg, Grade, Name(UDMS)
23. ACHV_TEST EMIS Student Achievement Testing Report (UDMS)
24. OGT_TEST EMIS Student OGT Testing Report (UDMS)
25. PROF_TEST EMIS Student Proficiency Testing Report (UDMS)
26. EMSREP4 Student Demograph./Attend. Funding & Legal Requirements Rept
* 27. EMSSID Statewide Student Identifier Report
28. EMSREP6 Student by Classroom within Building Report
29. EMSREP7 Student within Program Code within Building Report
30. VERIFY_PRO 4th/6th/12th Grade Proficiency Verification (VERIFY_PROF)
Staff and Class Master Reports
31. COURSE EMIS Course Master Listing (UDMS)
* 32. EMSPRS Staff HQPD Principal's Recording Sheet
EMIS 101 TRECA Training February 2006 Page 31 of 32
33. EMSREP2 Staff Class Master Funding & Legal Requirements Report
34. EMSREP3 Vocational Ed. Program Funding & Legal Requirements Report
Staff and Student Counts
35. EMSRT1 Staff FTE Count Report by Sex
36. EMSRT2 Student Count Report by Grade Level/Race within Building
37. EMSRT3 Student Count Report by Disadvantagement Type and Handicap
38. EMSRT5 Student Count Report by Classroom within Building
39. EMSRT6 Student Count by Program Code within Building Report
HQT Programs and Reports
40. HQTEXT HQT Extraction/Conversion (updates HQT field from prev. yr)
* 41. HQTPRS EMIS HQT Principal's Recording Sheet
* 42. HQTRPT EMIS Current HQT report listing
* 43. HQT_STAT EMIS HQT Teacher's Status Sheet
Press <cr> for first screen...
EMIS 101 TRECA Training February 2006 Page 32 of 32
