SAIS Student Database Transaction System Messages
Arizona Department of Education
Student Accountability
Information System
Student Database
Transaction Requirements
· System Messages
Version 4.6
Last updated February 4, 2005
Arizona Department of Education
School Finance Division
1535 W. Jefferson Street
Phoenix, Arizona 85007-3209
For updates to this document, see the MIS project contact in section Contacts.
TransactionSystemMessages.doc
The Arizona Department of Education, a state educational agency, is an equal opportunity employer and affirms that it does not discriminate on the basis of race, religion, color, national origin, age, sex or handicapping condition.
SAIS Student Database Transaction System Messages
Table of Contents
Revisions 1
About This Document 9
Author 9
Contacts 9
Document References 9
Document Distribution and Postings 9
Document Filename 9
System Messages 10
Table 1 System Messages Related to the Student Enrollment Transaction (001) 13
Table 2 System Messages Related to the Student Readmission Transaction (002) 18
Table 3 System Messages Related to the Student Withdrawal Transaction (003) 21
Table 4 System Messages Related to the Student Absence Transaction (004) 23
Table 5 System Messages Related to the Student Personal Information Transaction (005) 25
Table 6 System Messages Related to the Student Membership Change Transaction (006) 27
Table 7 System Messages Related to the Student District of Residence (DOR) Transaction (007) 28
Table 8 System Messages Related to the Student FTE Transaction (008) 30
Table 9 System Messages Related to the Student Grade Transfer Transaction (009) 33
Table 10 System Messages Related to the Student Payer Factors Transaction (010) 36
Table 11 System Messages Related to the Student Need Transaction (011) 38
Table 12 System Messages Related to the Student Assessment Transaction (012) 40
Table 13 System Messages Related to the Language Program Participation Transaction (013) 42
Table 14 System Messages Related to the SPED Service Participation Transaction (014) 44
Table 15 System Messages Related to the Support Program Participation Transaction (015) 47
Table 16 System Messages Related to the Student Year End Status Transaction (016) 48
Table 17 System Messages Related to the Student Attendance Transaction (017) 50
Table 18 System Messages Related to the Student Summer Withdrawal Transaction (018) 52
Table 19 System Messages Related to the Student SPED Service DOR Transfer Transaction (019) 54
Table 20 Common System Messages 56
Table 21 Integrity Checking Messages 58
Table 22 Matching File Messages 68
Table 23 System Messages Related to the Community College Classes Transaction (020) 69
Table 24 System Messages Related to the Initial IEP Transaction (021) 70
Table 25 System Messages Related to the Test label Transaction (022) 71
Appendix: Cross-Reference of All System Messages 72
Issues 79
TransactionSystemMessages.doc Page ii last updated 02/04/2005
SAIS Student Database Transaction System Messages
Revisions
Below is an inventory of the revisions made to this document since publication of version 1.0. (The revisions made while this document was in Draft form are included in this list.) Each time a revision is made the following sections, if included in this document, will also be updated: Table of Contents, List of Figures, List of Tables, Issues.
MM/DD/CCYY Version 4.6 NOT YET PUBLISHED
Ver. / New Information / Old Information / Source4.6 / Table 1
Added message(s):
· -411015 (Informational) / Previously did not exist / Ticket # 18958
C. Cree, MIS – Business Analysis
4.6 / Table 1
Added messages for the Mid-Year Track Change enrollment / Previously did not exist / C. Cree, MIS – Business Analysis
4.6 / Table 13
Added new messages related to the Assessment verification. / Previously published message numbers were duplicates. / C. Cree, MIS – Business Analysis
11/02/2004 Version 4.5 PUBLISHED
Ver. / New Information / Old Information / Source4.5 / Table 15 – Support Program Participation
Added message(s):
· -24016 (Error) / Previously did not exist / SAIS Business Rules
C. Cree, MIS – Business Analysis
09/23/2004 Version 4.4 PUBLISHED
Ver. / New Information / Old Information / Source4.4 / Table 14 – SPED Service Participation
Added message(s):
· -223002 (warning)
· -23037 (error) / Previously did not exist / Tickets # 18244, 23378
Peggy Staples, ESS;
C. Cree, MIS – Business Analysis
4.4 / Table 21 – Integrity Checking Messages
Added messages to validate:
· -44354 – Error on SPED Need Code combinations
· -222000 – Warning on Concurrent ELL service / Previously did not exist / Peggy Staples, ESS;
Kathie Mooney, EAS;
C. Cree MIS – Business Analysis
09/16/2004 Version 4.3 PUBLISHED
Ver. / New Information / Old Information / Source4.3 / Table 21 – Integrity Messages
Added the following message number(s):
· -44104 / Previously did not exist / Ticket # 16194
Buell Brown, MIS QA;
Mardy Cruz, MIS QA;
C. Cree, MIS – Business Analysis
4.3 / Table 15 – Support Programs
Added new message number(s):
· -24015 / Previously did not exist. / Nancy Konitzer, AAD;
Jeff Stowe, AAD;
C. Cree, MIS – Business Analysis
08/02/2004 Version 4.2 Published
Ver. / New Information / Old Information / Source /4.2 / Table 21 – Integrity Messages
Added the following message numbers:
· -44315
· -44349
· -44332 / Previously marked with @@ / Michael Lyczywek, Software Development; Ticket #21421
Carol Cree, MIS – Business Analysis
4.2 / Table 19 – Student SPED Service DOR Transfer
Added the following message numbers:
· -44315
· -44349
· -44332 / Previously did not exist. / Michael Lyczywek, Software Development; Ticket #21421
Carol Cree, MIS – Business Analysis
4.2 / Table 21 – Integrity Messages
Added the following failure message:
-@@ Students attending ASDB must be receiving HI or VI Need services at ASDB to be eligible for any other Need at ASDB. / Previously did not exist / Jim Whelan. MIS – Business Analysis
Peggy Staples, ESS Data Specialist
07/02/2004 Version 4.1 Published
Ver. / New Information / Old Information / Source4.1 / Table 3 – Student Withdrawal Transaction
Added the following warning messages:
· -215000
· -215002
· -215003
· -215004 / Messages previously contained @@ / Carol Cree, MIS – Business Analysis
4.1 / Table 13 – Language Program Participation
Added the following messages:
· 43405
· 43408
· 44347
· 44348 / Messages not documented consistent in previous versions. / Carol Cree, MIS – Business Analysis
Ticket # 19149.
4.1 / Appendix: Cross Reference of All System Messages
Removed message -11008 relating to Foreign Exchange Indicator / Message previously in use, but retired as of FY05. / Carol Cree, MIS – Business Analysis
6/10/2004 Version 4.0 Published
Ver. / New Information / Old Information / Source /4.0 / Table 12:
Added messages for revised Assessment edits / Irene Moreno, EAS, Kathie Moonie, EAS; Rolanda Bell, R&E; Helen Hugo – MIS – SAIS Student Details Manager; Carol Cree, MIS – Business Analysis
4.0 / Table 13:
Added message re: Grade membership required for ELL student / Helen Hugo – MIS – SAIS Student Details Manager; Mardy Cruz, MIS – QA; Carol Cree, MIS – Business Analysis
4.0 / Table 14:
Added Pre-School transfers message. / Janice McGoldrick
4.0 / Table 21:
Added Language participation Integrity failure messages. / Irene Moreno, EAS, Kathie Moonie, EAS; Rolanda Bell, R&E; Helen Hugo – MIS – SAIS Student Details Manager; Carol Cree, MIS – Business Analysis
4.0 / Table 21 Integrity: Message # 44338 text changed to “A child must be at least within 90 days of their third birthday AND not yet reached kindergarten age (5 years of age before September 1) to start membership in grade PS. / Message text originally specified “5 years of age by September 1”. This scenario was failing SPED integrity, but passing ADM integrity. Change is effective FY03 forward. / Peggy Staples, SPED Program Specialist per ticket # 17372. Modified by C. Cree, BA 4/7/04
4.0 / Table 21 Integrity: Modified MD and MDSSI descriptions and error messages -44344 and -44346 to include the phrase “…with a valid program service participation…” / Previous error messages needed clarification / Tickets 20945 & 19856
Peggy Staples, ESS Sped Program Specialist
Jim Whelan, Business Analyst, MIS
4.0 / Table 21 Integrity: Added Sped failure -44503. / -44503 previously did not exist / Ticket 19947
Jim Whelan, Business Analyst, MIS
4.0 / Table 21 Integrity: Modified error messages -44337 and -44503 to include a reference to ARS 15-821C and clarify by Jan 1st / ARS was not included in previous error messages
Previous messages indicated before Jan 1st / Ticket 19947
Helen Hugo, Student Details Project Manager, MIS
Jim Whelan, Business Analyst, MIS
4.0 / Table 21 Integrity: Added error message -44345 Change membership/SPED grade to KG or submit a Group B SPED service for each day of UE membership for a 5 year old. ;SchoolCTDS= / -44345 previously did not exist / Ticket 19491
Jim Whelan, Business Analyst, MIS
4.0
3/8/2004 Version 3.1 DRAFT published
ver / new information / old information / source /3.1 / Table 21 Integrity: Message number not yet assigned.) Message text changed to " Student is not 3 years old on Initial IEP Date; Initial IEP will not count toward FAPE." Displays student birthdate and submitted Initial IEP Date. / Originally read " Student less than 3; Initial IEP will not count toward FAPE."
Originally didn't show the IEP Date or birthdate. / Janice McGoldrick, 3/8/2004
3.1 / Table 24 Initial IEP: Message 236001. Message text changed to " Student is not 3 years old on Initial IEP Date; Initial IEP will not count toward FAPE." Displays student birthdate and submitted Initial IEP Date. / Originally read " Student less than 3; Initial IEP will not count toward FAPE."
Originally didn't show the IEP Date or birthdate. / Janice McGoldrick, 3/8/2004
2/6/2004 Version 3 DRAFT published
ver / new information / old information / source /3 / FY2005 Changes
This revisions table will be expanded to include all changes before final publication / Janice McGoldrick, 2/6/2004, ticket 19022
3 / Table 1 Enrollment
· changed message 411005 to say that student must be within 90 days of 3rd bday to be eligible to generate funding / · message previously said student had to be within 3 months / Janice McGoldrick, 2/6/2004, ticket 19022
3 / Table 21 Integrity,
· message 444002 changed to "Ten days or more of attendance missing. Submit attendance for this time if appropriate. If these days are unexcused absences, withdraw this student for excessive unexcused absence."
· message 44344: Added EDP to list of Need codes possibly required for MD.
· message 44351, 44352, 44353 added
· removed message 44320, 44308 (said respectively: unorganized territories not eligible for SPED services and DOR cannot be unorganized) / · previous message did not allow that the missing attendance days might not imply unexcused absences
· previous validation did not include EDP
· messages did not exist, should have been added to doc in v2.2
· unorganized is valid DOR in SPED / · Vikki Gibbons, TUSD, ticket 16200 (JMcG 8-12-03
· Peggy Staples, ESS; Janice McGoldrick MIS PMO; ticket 17339 10/27/2003
· added per ticket 15371 7/24/2003
· Juan Reza, MIS Developer; Mardy Cruz, MIS QA, ticket 14040 5/29/2003
8/7/2003 Version 2.2 published
ver / new information / old information / source /2.2 / Table 1 (11011, 11012)
Table 5 (14008, 14009)
· changed term "mother" to "responsible party" / · term was changed back in 2000 / Janice McGoldrick, 6/30/03, ticket 15379
2.2 / Table 10,
· changed message 9018 to "LEA Identifier not active" / · previous message was "LEA identifier does not exist." / SAIS Tech Writer, Charity Torrez, and Developer, 1-15-03; (JMcG 6/23/03)
2.2 / Table 17,
· 12021 added new message to validate attendance across a single week span / · message did not previously exist / Buell Brown, MIS QA, Janice McGoldrick, MIS Software Devt Mgr, Ticket 15171
2.2 / Table 21,
· changed message 9017 to "LEA Identifier does not exist"
· message 43201 First enrollment of the school year in a single track must be an “E” code
· new message 43208 for withdrawal date cannot be last day of school (ticket 15474)
· message 43405 changed to Previous Grade {} exited {} effective on {} New Grade {} effective on {}
· removed message 44321 (duplicated by message 43133
· message 44335 says Student under 33 months cannot receive SPED services
· Added message 244305 and 244307. / · previous message was "District is not valid for SAIS"
· previous message did not check the same track
· message did not previously exist
· 43405 previously stated the same information but was worded poorly
· redundant message
· previously said "Student under 3 years cannot receive SPED services"
· message did not previously exist / · all but the noted bullets: SAIS Tech Writer, Charity Torrez, and Developer, 1-15-03; (JMcG 6/23/03)
· 43405: Buell Brown, MIS QA, ticket 13090
· 44335: Peggy Staples, ESS; Rose Whelihan, SF, 6-18-2003, ticket 14267
· 244305 and 244307: Venkat Maddipatla 11/5/2002; Janice McGoldrick, MIS PMO ticket 9748
2.2 / Appendix (cross reference of messages)
· removed message 44321 (duplicated by message 43133)
· removed message 209001 / · redundant message
· does not appear in any transaction / SAIS Tech Writer, Charity Torrez, and Developer, 1-15-03; (JMcG 6/23/03)
5/1/2003 Version 2.1 published
ver / new information / old information / source /2.1 / In Table 4,
· updated message for 18009 to "No matching FTE period for the reported absence date"
· added message -18014 (10/30/02) / · previous message was "Missing FTE/Share for this Membership."
· new message did not exist / SAIS Tech Writer, Charity Torrez, and Developer, Michael Lyczywek (ticket 10422)
2.1 / In Table 5, added message –14036. / None / Ginny Nordstrom per ticket number 10243.
2.1 / Table 9, new message 17026 / did not previously exist / Ginny Nordstrom, developer, ticket 12608; doc change by Janice McGoldrick, MIS Software Dev't Mgr 3/11/2003
2.1 / Table 10, changed message -29000 to Missing required element: Special Enrollment Code And/Or Tuition Payer Code. Either an OldSpecialEnrollmentCode or an OldTuitionPayerCode is a required field for a Change operation. / Missing required element: Special Enrollment Code Or Tuition Payer Code / SAIS Tech Writer, Charity Torrez, and Tester, Darrin Hines
2.1 / Table 14, added messages 233002, 233003 / messages did not exist / Venkat Maddipatla, Charity Torrez
2.1 / Table 15: Table relates to the Support Program Participation Transaction.
· Since this transaction is being activated for FY 2003-04, removed comment that this is not yet active in SAIS.
· Synchronized messages to match the newly implemented transaction.
· Added new message 24014, program cannot be offered for this Need. / · previously used the old term "Supplementary Program Participation Transaction"
· the table included a note that it was not yet being used by SAIS
· message 24014 did not exist / Janice McGoldrick, MIS Software Development Mgr
2.1 / Table 17, added new message –12020 – "There is no grade membership associated with the school membership" / None / Randy Morter, developer, ticket 14162.
2.1 / In Table 18 modified messages –32005, -332001, -332002, and -332003 to reflect actual message and detail displayed, / Contained detail elements that are not displayed and was missing elements that are displayed. / Ginny Nordstrom in connection with ticket number 12013.
2.1 / Table 21,
· 43104 changed message to say that DOR is missing for all or part of the membership
· changed message to charters are not eligible for CEC (neither DOA nor DOR)
· 43125: removed "or charters" from CEC message
· 43127 expanded message to include that DOA might not be approved for grade
· added new messages 43134 to 43138, 43407, 44103, 44201
· 43203 changed "reported" to "submitted"
· 43204 changed to say not received a year end status or a final withdrawal from this school
· 44311 service codes F, V, and J may not have CEC.
· 44322 modified message to "This school is not approved to provide Special Education services for this grade."
· 44332 changed message to "invalid grade for PS-only need code"
· 44338 changed message to "student in PS must be younger than 5"
· 44342 changed to "service code F is not valid for open enrollment"
· 44344 new message for MD validation
· 44346 new message for MDSSI validation
· 244201 new message for missing attendance
· 443701 message deleted / · previously said just that DOR was missing for given dates
· previously said charters were allowed for CEC's
· same as above
· previously, only said that school was not approved for grade
· messages did not exist
· 43203 change at left
· 43204 said just no yr end status or withdrawal
· 44311 previously dis-allowed F, V, J, and S
· 44322 previous message too vague: "This school is not approved to teach this grade."
· previously said "... for service code"
· 44338 previously said "younger than 6" (ticket 13603)
· 44342 previously dis-allowed service code S
· 44344 did not exist
· 44346 did not exist
· 24201 did not exist
· 443701 was redundant / · 44322 Ginny Nordstrom, developer, ticket 11536 3/11/2003
· other messages, various developers, with doc changes by Charity Torrez and Janice McGoldrick
10/25/2002 Version 2.0 published