RIDE Information Services
 
e-RIDE Home  
State Reporting  
School & District Profiles  
Statistical Reports  
Data Dictionary  
Schools Directory  
RIDE Staff  
Report Cards  
Information Works!  
Trainings/Workshops  
RIDE Web Site  
eRIDE Login  
 
 
  State Data Dictionary
   
  Because of the complex school environment and the need for essential information for making instructional placement and student services decisions, the inclusion of data elements in this dictionary reflects only the federal and state data collection requirements.  For a more comprehensive handbook of data elements, please go to http://nces.ed.gov/programs/handbook/. The latest edition of the NCES student data handbook can also be downloaded . Each district or school planning to collect and maintain information about individual students MUST determine how the data are to be maintained, and who will have access to the data, taking into consideration federal, state, and local laws and regulations.
   
 

Search by Category: or Keyword: 

 
 
Item Name Database Category Entity Field Name Field Type Length
School ID  School Information  School  sch_code  varchar  5 
School Name  School Information  School  sch_name  varchar  50 
School Name 30  School Information  School  sch_name30  varchar  30 
School Name 15  School Information  School  sch_name15  varchar  15 
School Address Line 1  School Information  School  sch_add1  varchar  50 
School Address Line 2  School Information  School  sch_add2  varchar  50 
School City  School Information  School  sch_city  varchar  20 
School State  School Information  School  sch_state  varchar  2 
School Zip  School Information  School  sch_zip  varchar  10 
School Chief Name  School Information  School  sch_chief_name  varchar  30 
School Chief Title  School Information  School  sch_chief_title  varchar  15 
School Phone  School Information  School  sch_phone  varchar  10 
School Fax  School Information  School  sch_fax  varchar  10 
School Email  School Information  School  sch_email  varchar  60 
School Web  School Information  School  sch_web  varchar  60 
School Level Code  School Information  School  sch_level_code  varchar  2 
School Grade Low  School Information  School  sch_low_grade  varchar  2 
School Grade High  School Information  School  sch_high_grade  varchar  2 
School Type Code  School Information  School  sch_type_code  varchar  2 
School District Code  School Information  School  distcode  varchar  2 
School - SPED  School Information  School  sch_sped  varchar  1 
School - LEP  School Information  School  sch_lep  varchar  1 
School - Charter  School Information  School  sch_charter  varchar  1 
School - Magnet  School Information  School  sch_magnet  varchar  1 
School - Title 1  School Information  School  sch_title1  varchar  1 
School - Title 1 Whole School  School Information  School  sch_title1p  varchar  1 
School - Administrative Site  School Information  School  sch_adminsite  varchar  1 
School - State Operated  School Information  School  sch_state_operated  varchar  1 
School - Lunch Site  School Information  School  sch_lunchsite  varchar  1 
School - Assessment Site  School Information  School  sch_test  varchar  1 
School Open Status  School Information  School  sch_status  varchar  1 
Assessment School Code  School Information  School  assessment_code  varchar  5 
Assessment School Name  School Information  School  assessment_name  varchar  50 
School Title 1 Status  School Information  School  sch_title1_ccd  varchar  20 
State Assigned Student Identifier  Student Demographics  Student  SASID  int  10 
Locally Assigned Student Identifier  Student Demographics  Student  LASID  varchar  16 
Student Last Name  Student Demographics  Student  lastName  varchar  30 
Student First Name  Student Demographics  Student  firstName  varchar  30 
Student Middle Initial  Student Demographics  Student  mi  varchar  1 
Student Gender  Student Demographics  Student  sex  varchar  1 
Student Hispanic or Latino Ethnicity  Student Demographics  Student  hispanic  varchar  1 
Student Race  Student Demographics  Student  race  varchar  1 
Date of Birth  Student Demographics  Student  DOB  date   
State Assigned Student Identifier  Enrollment  Student  SASID  int  10 
Locally Assigned Student Identifier  Enrollment  Student  LASID  varchar  16 
State Assigned District Code  Enrollment  District  distCode  varchar  2 
State Assigned School Code  Enrollment  School  schCode  varchar  5 
Grade or Setting  Enrollment  Student  grade  varchar  2 
Residency  Enrollment  District  resDistrict  varchar  2 
Immigrant Status  Enrollment  Student  immigrant  varchar  2 
Homelessness Status  Enrollment  Student  homeless  varchar  2 
Title I Status  Enrollment  Student  titleI  varchar  1 
IEP Status  Enrollment  Student  IEP  varchar  1 
LEP Status  Enrollment  Student  LEP  varchar  1 
Voc Ed Status  Enrollment  Student  vocED  varchar  1 
Lunch Status  Enrollment  Student  lunch  varchar  1 
Date of Enrollment  Enrollment  Enrollment  enroll_date  date   
Cohort Year*  Enrollment  Student  cohort_year  varchar  7 
Enrollment Status*  Enrollment  Enrollment  enroll_status  varchar  2 
Enrollment Type  Enrollment  Enrollment  enroll_type  varchar  2 
Aggregate Days of Membership  Enrollment  Enrollment  ADM  decimal   
Aggregate Days of Attendance  Enrollment  Enrollment  ADA  decimal   
Number of Tardies  Enrollment  Enrollment  tardies  int   
Number of Absenses  Enrollment  Enrollment  num_absences  int   
Absense Type  Enrollment  Enrollment  absense_type  varchar  2 
Exit/Withdrawal Date  Enrollment  Enrollment  exit_date  date   
Exit/Withdrawal Status  Enrollment  Enrollment  exit_status  varchar  2 
Exit/Withdrawal Type  Enrollment  Enrollment  exit_type  varchar  2 
State Assigned Student Identifier  VocEd  Student  SASID  int  10 
Locally Assigned Student Identifier  VocEd  Student  LASID  varchar  16 
Disabled  VocEd  Student  disabled  varchar  1 
Economic  VocEd  Student  economic  varchar  1 
Single Parent  VocEd  Student  single_parent  varchar  1 
Displaced Homemaker  VocEd  Student  displaced_homemaker  varchar  1 
LEP/ESL  VocEd  Student  lep  varchar  1 
Location  VocEd  Student  location_code  varchar  5 
Program  VocEd  Student  program  varchar  1 
Participation Level  VocEd  Student  Participation_Level  varchar  1 
Grade Level  VocEd  Student  grade_level  varchar  2 
Program Entry Date  VocEd  Student  program_entry_date  date   
Program Exit Date  VocEd  Student  program_exit_date  date   
Program Status  VocEd  Student  program_status  varchar  1 
State Assigned Student Identifier  Discipline  Student  SASID  int  10 
Locally Assigned Student Identifier  Discipline  Student  LASID  varchar  16 
State Assigned School Code  Discipline  School  schCode  varchar  5 
Infraction  Discipline  Infraction  infraction  varchar  2 
Date of Infraction  Discipline  Infraction  infraction_date  date   
Discipline  Discipline  Infraction  discipline  varchar  1 
Duration  Discipline  Infraction  duration  int   
Weapon  Discipline  Infraction  weapon  varchar  1 
Reason  Discipline  Infraction  reason  text   
Physical Injury  Discipline  Infraction  physcialInjury  varchar  1 
State Assigned Student Identifier  SPED  Student  SASID  int  10 
Last Name  SPED  Student  lastName  varchar  30 
First Name  SPED  Student  firstName  varchar  30 
Middle Initial  SPED  Student  MI  varchar  1 
Date of Birth  SPED  Student  DOB  date   
Gender  SPED  Student  SEX  varchar  1 
Race  SPED  Student  race  varchar  1 
State Assigned Student Identifier  SPED  Census  SASID  int  10 
Locally Assigned Student Identifier  SPED  Census  LASID  int  20 
Census Month and Year  SPED  Census  CensusMonthYear  varchar  3 
Community District  SPED  Census  CommDistrict  varchar  2 
Service District  SPED  Census  ServiceDistrict  varchar  2 
State Assigned School Code  SPED  Census  SchCode  varchar  5 
Grade or Setting  SPED  Census  Grade  varchar  2 
Status  SPED  Census  Status  varchar  1 
English Ability  SPED  Census  EnglishAbility  varchar  1 
Beneficiary  SPED  Census  Beneficiary  varchar  1 
Summer Exit Code  SPED  Census  SummerExitCode  varchar  1 
Private School Enrollee  SPED  Census  PrivateSchoolEnrollee  varchar  1 
Transportation  SPED  Census  Transportation  varchar  1 
Primary Disability Code  SPED  Census  PrimaryDisabilityCode  varchar  1 
Assessment Accommodations  SPED  Census  Assessment  varchar  1 
IEP Due Date  SPED  Census  IEPDueDate  date   
IEP Team Meeting Date  SPED  Census  IEPTMDate  date   
Case Manager Code *  SPED  Census  CaseManagerCode  varchar  10 
State Assigned Student Identifier  SPED  Service  SASID  int  10 
Program Code  SPED  Service  ProgramCode  varchar  1 
Cost Center  SPED  Service  CostCenterCode  varchar  5 
Services Plan District code  SPED  Service  SPDistrictCode  varchar  2 
Service Provider  SPED  Service  ServiceProviderCode  varchar  1 
Starting Date  SPED  Service  StartingDate  date   
Ending Date  SPED  Service  EndingDate  date   
Service Location  SPED  Service  ServiceLocation  varchar  5 
Hours Per Day  SPED  Service  HoursPerDay  decimal   
Days Per Week  SPED  Service  DaysPerWeek  int   
Weeks Per Month  SPED  Service  WeeksPerMonth  int   
Service Exit Code  SPED  Service  ServiceExitCode  varchar  1 
Regular Natural Setting  SPED  Service  RegNatSetting  varchar  1 
Teacher Code *  SPED  Service  TeacherCode  varchar  12 
Account Number *  SPED  Service  AccountNum  varchar  9 
Tuition Cost *  SPED  Service  TuitionCost  varchar  10 
Subject Area *  SPED  Service  SubjectArea  varchar  5 
State Assigned Student Identifier  SPED  Evaluation  SASID  int  10 
Evaluation Area *  SPED  Evaluation  EvaluationArea  varchar  1 
Evaluation Date *  SPED  Evaluation  EvaluationDate  date   
Evaluation Disposition *  SPED  Evaluation  EvaluationDisposition  varchar  1 
Evaluation TM Date *  SPED  Evaluation  EvaluationTMDate  date   
State Assigned Student Identifier  SPED  Medicaid  SASID  int  10 
Medical Eligibility *  SPED  Medicaid  MedicalEligible  varchar  1 
Medical Number *  SPED  Medicaid  MedicalNumber  varchar  10 
Social Security Number *  SPED  Medicaid  SocialSecurityNumber  varchar  15 
Case Worker *  SPED  Medicaid  CaseWorker  varchar  25 
Parental Consent For Billing With SSN *  SPED  Medicaid  ParentConsentBillSSN  varchar  1 
State Assigned Student Identifier  SPED  IEPAttendance  SASID  int  10 
IEP Team Meeting Date  SPED  IEPAttendance  IEPTMDate  date   
Parents  SPED  IEPAttendance  Parents  varchar  1 
Regular Ed Teacher  SPED  IEPAttendance  RegTeacher  varchar  1 
Special Ed Teacher  SPED  IEPAttendance  SpedTeacher  varchar  1 
District Rep  SPED  IEPAttendance  DistrictRep  varchar  1 
Student  SPED  IEPAttendance  Student  varchar  1 
Transition Service  SPED  IEPAttendance  TransitionService  varchar  1 
Related Service Provider  SPED  IEPAttendance  RelatedSProvider  varchar  1 
Other  SPED  IEPAttendance  Other  varchar  1 
State Assigned Student Identifier  SPED  Student  SASID  int  10 
Parent Last Name *  SPED  Student  ParentLastName  varchar  30 
Parent First Name *  SPED  Student  ParentFirstName  varchar  30 
Address (Line 1)  SPED  Student  Address1  varchar  50 
Address (Line 2)  SPED  Student  Address2  varchar  50 
City *  SPED  Student  City  varchar  20 
State *  SPED  Student  State  varchar  2 
Zip *  SPED  Student  Zip  varchar  10 
Home Phone *  SPED  Student  HomePhone  varchar  15 
Work Phone *  SPED  Student  WorkPhone  varchar  15 
Mother's Phone *  SPED  Student  MothersPhone  varchar  15 
Father's Phone *  SPED  Student  FathersPhone  varchar  15 
Emergency Phone *  SPED  Student  EmergencyPhone  varchar  15 
Student Cell Phone *  SPED  Student  StudentCellPhone  varchar  15 
Student Email *  SPED  Student  StudentEmail  varchar  60 
State Assigned Student Identifier  SPED  Transition  SASID  int  10 
Employment Goals  SPED  Transition  Employment  varchar  1 
Employment Desc  SPED  Transition  EmploymentDesc  text   
Employment Goals Basis Determination  SPED  Transition  EmploymentBasis  varchar  1 
Employment Desc Basis Determination  SPED  Transition  EmploymentBasisDesc  text   
Post Secondary Education Goals  SPED  Transition  PostSecondary  varchar  1 
Post Secondary Education Desc  SPED  Transition  PostSecondaryDesc  text   
Post Secondary Education Basis Determination  SPED  Transition  PostSecondaryBasis  varchar  1 
Post Secondary Education Desc Basis Determination  SPED  Transition  PostSecondaryBasisDesc  text   
Independent Living Goals  SPED  Transition  IndependentLiving  varchar  1 
Independent Living Desc  SPED  Transition  IndependentLivingDesc  text   
Independent Living Goals Basis Determination  SPED  Transition  IndependentLivingBasis  varchar  1 
Independent Living Desc Basis Determination  SPED  Transition  IndependentLivingBasisDesc  text   
Community Participation Goals  SPED  Transition  CommParticipation  varchar  1 
Community Participation Desc  SPED  Transition  CommParticipationDesc  text   
Community Participation Goals Basis Determination  SPED  Transition  CommParticipationBasis  varchar  1 
Community Participation Desc Basis Determination  SPED  Transition  CommParticipationBasisDesc  text   
Course of Study Completed  SPED  Transition  CourseofStudy  varchar  1 
State Assigned Student Identifier  SPED  EarlyChildhood  SASID  int  10 
Regular Early Childhood Setting  SPED  EarlyChildhood  RegECSetting  varchar  1 
Regular Early Childhood Hours Per Week  SPED  EarlyChildhood  RegECHours  int  2 
Regular Early Childhood Setting Head Start  SPED  EarlyChildhood  RegECSettingType_HS  varchar  1 
Regular Early Childhood Setting Kindergarten  SPED  EarlyChildhood  RegECSettingType_KG  varchar  1 
Regular Early Childhood Setting Private Preschool  SPED  EarlyChildhood  RegECSettingType_PrivS  varchar  1 
Regular Early Childhood Setting Early Care  SPED  EarlyChildhood  RegECSettingType_EarlyCare  varchar  1 
Regular Early Childhood Setting Integrated PreSch  SPED  EarlyChildhood  RegECSettingType_InPresch  varchar  1 
Early Childhood Special Education Program  SPED  EarlyChildhood  ECSpEdProgram  varchar  1 
Early Childhood Special Education Program Type  SPED  EarlyChildhood  ECSpEdProgramType  varchar  10 
Special Education Services  SPED  EarlyChildhood  SpEdServ  varchar  1 
Special Education Services Location  SPED  EarlyChildhood  SpEdServLoc  varchar  10 
State Assigned Student Identifier  LEP  Student  SASID  int  10 
Locally Assigned Student Identifier  LEP  Student  LASID  varchar  16 
State Assigned School Code  LEP  School  schCode  varchar  5 
Community District  LEP  District  CommDistrict  varchar  2 
Grade or Setting  LEP  Student  grade  varchar  2 
Language  LEP  Student  languageN  varchar  50 
Start Year  LEP  Student  startYear  date   
Entering Proficiency Level  LEP  Student  enteringLevel  varchar  1 
Current Proficiency Level  LEP  Student  currentLevel  varchar  1 
Birth Place  LEP  Student  birthPlace  varchar  20 
Date of Entry into US  LEP  Student  entryDate  date   
Immigrant Status  LEP  Student  immigrant  varchar  1 
MacScore  LEP  Student  macScore  varchar  5 
Mac II Level  LEP  Student  macForm  varchar  2 
LEP Program Model  LEP  Student  model  varchar  5 
Start Date  LEP  Service  startDate  date   
End Date  LEP  Service  endDate  date   
Hours Per Day  LEP  Service  hoursPDay  decimal   
Days Per Week  LEP  Service  daysPWeek  int   
Weeks Per Month  LEP  Service  weeksPMonth  int   
Reason for Termination  LEP  Service  termReason  varchar  1 
Teacher  LEP  Service  teacherCode  int   
ActiveStatus  LEP  Service  asOfStatus  varchar  1 
State Assigned Student ID  CHOICE  Student  SASID  int  10 
Locally Assigned Student Identifier  CHOICE  Student  LASID  varchar  16 
State Assigned School Code  CHOICE  Student  choiceSchCode  varchar  5 
Grade or Setting  CHOICE  Student  choiceGrade  varchar  2 
Requested Transfer  CHOICE  Student  choiceTRRequested  varchar  1 
Not Accommated  CHOICE  Student  choiceNAccommodated  varchar  1 
School Transferred To  CHOICE  Student  choiceTRSchcode  varchar  5 
Transportion Provided  CHOICE  Student  choiceTPProvided  varchar  1 
Transportation Cost  CHOICE  Student  choiceTPCost  int   
State Assigned Student ID  SES  Student  SASID  int  10 
Locally Assigned Student Identifier  SES  Student  LASID  varchar  16 
State Assigned School Code  SES  Student  sesSchCode  varchar  5 
Grade or Setting  SES  Student  sesGrade  varchar  2 
Received SES  SES  Student  sesReceived  varchar  1 
SES Provider  SES  Student  sesProvider  varchar  5 
SES School Year  SES  Student  sesSchYear  varchar  1 
SES Summer  SES  Student  sesSummer  varchar  1 
SES Saturday  SES  Student  sesSaturday  varchar  1 
SES Cost  SES  Student  sesCost  int   
SES Outcome  SES  Student  sesOutcome  varchar  1 
SASID  SPED Parent Survey  Student  SASID  int  10 
DISTCODE  SPED Parent Survey  Student  DISTCODE  varchar  2 
SCHCODE  SPED Parent Survey  Student  SCHCODE  varchar  5 
GRADE  SPED Parent Survey  Student  GRADE  varchar  2 
LASTNAME  SPED Parent Survey  Student  LASTNAME  varchar  30 
FIRSTNAME  SPED Parent Survey  Student  FIRSTNAME  varchar  30 
MI  SPED Parent Survey  Student  MI  varchar  1 
SEX  SPED Parent Survey  Student  SEX  varchar  1 
DOB  SPED Parent Survey  Student  DOB  date   
RACE  SPED Parent Survey  Student  RACE  varchar  1 
ADDRESS1  SPED Parent Survey  Student  ADDRESS1  varchar  100 
ADDRESS2  SPED Parent Survey  Student  ADDRESS2  varchar  100 
CITY  SPED Parent Survey  Student  CITY  varchar  20 
STATE  SPED Parent Survey  Student  STATE  varchar  2 
ZIP  SPED Parent Survey  Student  ZIP  varchar  5 
HOMELANGUAGE  SPED Parent Survey  Student  HOMELANGUAGE  varchar  1 
Early Intervention Services  SPED  EarlyChildhood  EIServices  varchar  20 
IEP TM Date for Orig IEP  SPED  EarlyChildhood  OrigIEPDate  date   
Effective Date of Orig IEP  SPED  EarlyChildhood  OrigIEPEffDate  date   
Effective Date of IEP After 3rd Birthday  SPED  EarlyChildhood  EffectiveDateGreater3  varchar  20 
Effective Date of IEP After 3rd Birthday (Other)  SPED  EarlyChildhood  ReasonOther  varchar  50 
Special Education Service Type  SPED  Service  Service Type  varchar  7 
Special Education IEP Type  SPED  Census  IEP Type  varchar  3 
State Assigned Student ID  Student Daily Attendance  Attendance  SASID  int  10 
Locally Assigned Student ID  Student Daily Attendance  Attendance  LASID  varchar  16 
State Assigned District Code  Student Daily Attendance  Attendance  distCode  varchar  2 
State Assigned School Code  Student Daily Attendance  Attendance  schCode  varchar  5 
Date of Attendance/Absence  Student Daily Attendance  Attendance  Attend_Date  date   
Type of Attendance/Absence  Student Daily Attendance  Attendance  Attend_Type  varchar  2 
   
 

Items are subject to changes in State and Federal reporting mandates and requirements.  Items with a '*' are not currently mandated by State or Federal law, but necessary for accurate State and local student information management and reporting .
Last updated on 11/8/06.  Contact: Dr. Ken Gu, 222-8957; kenneth.gu@ride.ri.gov