STATEWIDE INFORMATION SYSTEM 1999/2000

[Pages:159]Sy0010

STATEWIDE INFORMATION SYSTEM (SIS) HANDBOOK

2019-2020

Johnny Key, Commissioner

Dr. Ivy Pfeffer, Deputy Commissioner

Technical Assistance Arkansas Department of Education Divison of Elementary and Secondary Education Office of Information Technology

Arijit Sarkar 501-371-5005 Arijit.Sarkar@

Arkansas Department of Education Divison of Elementary and Secondary Education

Office of Information Technology Reshmi Jose 501-371-5091

Reshmi.Jose@

STATEWIDE INFORMATION SYSTEM 2019-2020

TABLE OF CONTENTS

I. Project Overview .....................................................................................................1

II. SIS Overview ...........................................................................................................2

III. Data Submission Cycles ..........................................................................................3

IV. Submission Cycles, Tables, Data, and Reports Cycle 1: Annual Reports due for Cycle 1 ...............................................................6 Cycle 2: Annual Reports due for Cycle 2 ...............................................................7 Cycle 3: Annual Reports due for Cycle 3 ...............................................................9 Cycle 4: Annual Reports due for Cycle 4 .............................................................10 Cycle 5: Annual Reports due for Cycle 5 .............................................................11 Cycle 6: Annual Reports due for Cycle 6 .............................................................12 Cycle 7: Annual Reports due for Cycle 7 .............................................................14 Cycle 8: Annual Reports due for Cycle 8 .............................................................16 Cycle 9: Annual Reports due for Cycle 9 .............................................................17

V. Database Schema Definitions ................................................................................18 1. Act 61 ................................................................................................................19 2. Act 61ii ..............................................................................................................20 3. ALE (Annual Report) ........................................................................................21 4. ALE Days ..........................................................................................................22 5. Bus.....................................................................................................................23 6. Bus ? Supplemental Transportation ..................................................................25 7. Bus ? Transportation Personnel ........................................................................26 8. Calendar.............................................................................................................27 9. Class ..................................................................................................................28 10. Contact Persons................................................................................................32 11. Discipline .........................................................................................................35 12. District..............................................................................................................37 13. Finance ? Act 28 ..............................................................................................41 14. Finance ? Bank Reconciliation ........................................................................45 15. Finance ? Building Loss ..................................................................................46 16. Finance ? Contracted Non-Employee ..............................................................47 17. Finance ? Employee.........................................................................................48 18. Finance ? Employee Additional Duties ...........................................................50 19. Finance ? Employee Base Salary.....................................................................51 20. Finance ? Employee Benefits (payments/services in addition to salary) ......53 21. Finance ? Employee Bonus .............................................................................54 22. Finance ? Employee Fringe Benefits ...............................................................55 23. Finance ? Employee Leave ..............................................................................56 24. Finance ? Employee Salary/Benefits ...............................................................57 25. Finance ? Expenditure .....................................................................................60 26. Finance ? General Ledger ................................................................................62 27. Finance ? Salaries & FTE ...............................................................................62 28. Finance ? Programs on Behalf of Other Agencies...........................................64

STATEWIDE INFORMATION SYSTEM 2019-2020

TABLE OF CONTENTS (CONTINUED)

29. Finance ? Property Value.................................................................................65 30. Finance ? Revenue ...........................................................................................66 31. Finance ? Salary Range ...................................................................................67 32. Finance ? Salary Schedule ...............................................................................70 33. Finance ? Vendor .............................................................................................71 34. Finance ? Supplemental Educational Services (SES) Provider .......................72 35. Finance ? Underpayments................................................................................73 36. Equity ? Compliance Reports ..........................................................................74 37. Facility Building ..............................................................................................76 38. Graduate ...........................................................................................................78 39. Job Assignment ................................................................................................79 40. Medical Dyslexia .............................................................................................80 41. Medical Hearing...............................................................................................81 42. Medical Immunization .....................................................................................82 43. Medical Scoliosis .............................................................................................84 44. Medical Vision.................................................................................................85 45. Private Schools (Federal Programs).................................................................87 46. Private Schools ? Title I (Federal Programs)...................................................89 47. Professional Development ...............................................................................90 48. Register ............................................................................................................91 49. Safety Drill.......................................................................................................92 50. School .............................................................................................................93 51. School Board Training .....................................................................................99 52. Special Education ? Early Childhood ............................................................100 53. Special Education ? Early Intervening Services 1(School Age Only) ..........104 54. Special Education ? Early Intervening Services 2(School Age Only) ..........106 55. Special Education ? Employee ......................................................................107 56. Special Education ? Referral Tracking ..........................................................110 57. Special Education ? School Age....................................................................113 58. Student ...........................................................................................................117 59. Student Attendance ........................................................................................125 60. Student Grades ...............................................................................................126 61. Student ID Change .........................................................................................127

STATEWIDE INFORMATION SYSTEM 2019-2020

TABLE OF CONTENTS (CONTINUED)

VI. Appendix A. County ...........................................................................................................130 B. District LEAs ................................................................................................130 C. School LEAs .................................................................................................130 D. Arkansas Educational Cooperatives .............................................................130 E. Postsecondary Schools and Vocational Centers ............................................131 F. Arkansas Licensed Job Codes .......................................................................132 G. Arkansas Classified Job Codes .....................................................................132 H. Language Codes.............................................................................................133 I. Course Codes and Definitions .......................................................................135 J. Salaries & FTE Position Cross Reference .....................................................137 K. Arkansas Approved Digital Learning Providers............................................140 L. Private School Codes .....................................................................................142 M. Reports Listed Numerically with Corresponding Cycle ................................147 N. Data Changes For This Year's SIS Handbook ..............................................151

STATEWIDE INFORMATION SYSTEM 2017-2018

PROJECT OVERVIEW

The Statewide Information System (SIS) is a web-based system developed by the Arkansas Department of Education's Research and Technology Division to enable school districts to submit and certify data to the State. The system is used by school districts using eSchoolPlus and eFinancePlus software. The system has the capability to pull data from eSchoolPlus and eFinancePlus on a nightly as well as on-demand basis as required by school districts. The SIS Cycle Submission process was developed to replace an existing system through which districts reviewed summarized financial and student information before submitting and certifying the data to the State.

The objectives of SIS are to:

A. Ensure that every school district has access to comparable administrative computing systems and services with which to meet all local and state requirements.

B. Promote increased compatibility of the administrative records and data maintained by each district office and school site.

C. Reduce the paperwork and reporting burden of school sites and district offices.

D. Increase the accuracy and timeliness of data submitted by school districts to the ADE for state and federal reporting, program analysis, and evaluation.

The result is the availability at the state level of a comprehensive and integrated database of information about students, programs, district personnel, and finances to be utilized for planning and policy-making.

SIS Implementation Requirements for Districts and Education Service Cooperatives

Every school district must have implemented an automated district information system meeting the following requirements:

A. The district information system must contain a centralized system of records and data for all schools, programs, staff, finances and facilities.

B. For local record keeping, the district information system must provide the business functions of accounts payable, general ledger, purchasing, inventory, fixed assets, personnel, and payroll. Student functions must include daily and class attendance, course scheduling, report cards and permanent records, special education, health, discipline, as well as other demographic and program information defined as necessary by the ADE.

C. The district information system must comply with all data definitions and procedures specified by the ADE for financial accounting, personnel records, and student records. This shall include implementation of Handbook IIR2 standards for financial accounting, state student numbering procedures, common course number and title conventions, automated attendance record keeping procedures, permanent record content, and requirements for calculation of high school grade point averages.

1

STATEWIDE INFORMATION SYSTEM 2017-2018

PROJECT OVERVIEW

SIS Requirements for the Arkansas Department of Education

The ADE will make available to every district all required data elements, records, and procedures for local record keeping and state reporting in a document called the SIS Handbook.

This SIS Handbook will be updated once annually to reflect all changes in requirements resulting from state or federal laws and regulations. The ADE shall make every effort to distribute the annual update as far in advance of each new fiscal year as possible. The online version is available at . Click on the SIS Handbooks menu icon. The SIS Handbook is scheduled for release March 1st of every year.

If changes to the SIS Handbook become necessary after its initial release and printing, updates will be made in an addendum online located on the ADE Data Center website. There will be no corrections to the hard copy issue and the printed books will not be revised.

SIS OVERVIEW

The Arkansas Department of Education (ADE) has developed a state reporting process design that will allow Arkansas school districts to report their data electronically over the statewide network to the ADE.

ADE approves the database structure. Data is collected as it directly relates to one of the records outlined. When the data to be collected is not available in either eFinancePLUS or eSchoolPLUS, The LEA Profile System is provided by the programming staff to collect required data (i.e. bus and facility data).

The data submissions will be transmitted in accordance with the reporting cycles outlined in the Data Submission Cycles chart (page 3-5). All unit records are cyclic and must be submitted in their entirety by their due date(s). There will be a calculated elements database created from the unit records submitted by each district. The programs that create these data elements will be used for all calculations at the ADE, ensuring that all formulas and/or logic that derive items such as Average Daily Attendance (ADA) are the same for all parties.

ADE provides procedural instructions, release notes and documentation for each cycle. This information is published far enough in advance of each cycle to give the user time to meet the cycle submission due date. It can be accessed by going on the Internet to the ADE Data Center web site at . Click on the SIS Icon, then select "Statewide Information System." Only district personnel selected to perform state reporting coordinator duties will execute record submissions by utilizing the Statewide Information System on their network-connected workstation. All reports produced for a cycle should be reviewed by appropriate district, school, food service, and counselor personnel for accuracy prior to submission to the ADE. Once the data submission is complete, each district is required by the ADE to sign and return the "Certification of Data Accuracy" form (one for each cycle) to the ADE. This form is part of the release notes provided by ADE for each cycle.

2

STATEWIDE INFORMATION SYSTEM 2019-2020

DATA SUBMISSION CYCLES

DATABASE RECORD

Act 61 (AC)

Act 61ii (AI)

ALE (AS)

ALE Days (AL)

Bus (BU) Bus - Supplemental Transportation (TP) Bus - Transportation Personnel (TS) Calendar (CA)

Class (CL)

Contact Person (CO)

Discipline (DS)

District (DI)

Finance ? Act 28 (AT)

Finance ? Bank Recon (BC) Finance ? Building Losses (BL) Finance ? Contracted NonEmployee Nurse (NE) Finance ? Employee (EM) Finance ? Employee Additional Duty (FA) Finance ?Employee Base Salary (BS) Finance ? Employee Benefit (CF) Finance ? Employee Bonus (EB) Finance ? Employee Fringe Benefits (FN) Finance ? Employee Leave (EL) Finance ? Employee Salary (ES)

Finance ? Expenditures (FE)

Finance ? General Ledger (FG)

PAGE

19 20 21 22 23 25 26 27 28 32 35 37 41 45 46 47 48 50 51 53 54 55 56 57 58

60

C 1

C 2

C 3

C 4

C 5

C 6

C 7

C 8

C 9

SEP 30 OCT 15 NOV 15 DEC 15 FEB 15 APR 15 JUN 15 JUL 31 AUG 31

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X X

X

X

X

X

X

X

X

X X

3

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download