Program Status Extract (Rhode Island)

Last Modified on 04/10/2024 12:55 pm CDT

Tool Search: Enrollment Census

The Program Status Extract collects basic information about programs in which students are enrolled, including start and end dates and statuses.

Screenshot of the Program Status Report for Rhode Island in Report, RI State Reporting, Enrollment Census Report. Program Status Report

Read - Access and generate the Enrollment Census Reports.
Write - N/A
Add - N/A
Delete - N/A


For more information about Tool Rights and how they function, see the Tool Rights article.

Report Logic

Only Programs listed in the Program Code List that are marked as State Reported are included. Only programs that are currently active and those that were active during the school year are included in the report. This is done in the Flags Setup tool.

The student's Program Start Date must be on/during the Effective Date entered on the Extract editor, and the entered Effective Date must be on or after the Enrollment Start Date.

Students who have multiple enrollments (a primary enrollment plus a special education enrollment) report multiple times with duplicate program information.

Students do not report when:

  • They have an Enrollment Status of W (Summer Withdrawal).
  • Their enrollment record is marked as State Exclude.

Programs do not report when: 

  • The program start date is in a previous school year and it has an End Date.
  • The program is NOT marked as State Reported.

SQL Query

EXECUTE dbo.get_RI_EnrollmentCensusB @calendarList = '77'
DECLARE @d smalldatetime = getdate() EXECUTE dbo.get_RI_EnrollmentCensusB @calendarList = '106,107,108',@effectiveDate =@d

Program Code List

Verify the following Programs and Program Codes are available in the Flags Setup tool. The must be marked as Active and as State Reported in order to report. The selected Flag Image and Flag Color is up to the school and/or district to manage. 

Screenshot of the Flag Setup editor in Student Information Program Administration Flags Setup with the Name, Code, Active and State Reported fields highlighted.Flag Setup Example

Click here to expand...

CodeName
101ACF Certification
103Adobe Certified Associate
104ASE Student Certification
105ASK Concepts of Entrepreneurship and Management
106ASK Concepts of Finance
107ASK Fundamental Business Concepts
108ASK Fundamental Marketing Concepts
109Autodesk Certified User
112Cisco Certified Entry Networking Technician 
115CompTIA 
117ETA Certificates
120I-CAR
122ISCET Electronics Systems Associate (ESA) Levels 1-4 (CCENT)
125NIMS Credential
126NOCTI Accounting Advanced &  Basic Assessment
127NOCTI Accounting-Basic Assessment
129NOCTI Audio-Visual Communications Assessment
130NOCTI Broadcasting and Journalism Assessment 
135NOCTI Criminal Justice Assessment
144NOCTI Performing Arts Assessment
145NOCTI Pre-Engineering/Engineering Technology Assessment
149NOCTI Television Production Assessment
151NRFF National Professional Certification in Retail Management
152NRFF National Professional Certification in Sales
154Paraprofessional Exam
155PrintEd
156ProStart National Certificate of Achievement
157Rhode Island Early Learning and Development (RIELDS) Foundations Certificate 
159RI Cosmetology Licenses
160ServSafe Alcohol Certificate
161ServSafe Food Handler Certificate
162ServSafe Food Protection Manager Certification 
164NOCTI Computer Programming
166NOCTI Small Animal Science and Technology
167NOCTI Horticulture-Landscaping
168Adobe Premier Certification
169American Composite Manufacturers Association (ACMA) Certification - Certified Composites Technician (CCT)
170Associate Android Developer Exam
171Canine and Feline CPR and First Aid Certification
172Certified Front Desk Representative (CFDR)
173Certified Guest Service Professional (CGSP)
174Certified Guestroom Attendant (CGA)
175Certified Hospitality & Tourism Management Professional Certification (CHTMP)
176Cisco-Certified Network Associate (CCNA)
177Comportable video Editing Certification
178Dance Education Assistant Certification from RI Dance Alliance, Inc. (portfolio review)
179Diploma in graphics operations (Xerox), design or printing technology
180Final Cut Pro-certification
181Foundational-level MSSC Certified Logistics Associate (CLA) Certificate
182I-Car Level II
183Manufacturing Skills Institute (MSI) Manufacturing Technician 1 (MT1) certification.
184Manufacturing Standards Skills Council (MSSC) Certified Production Technician (CPT) program
185Microsoft Technology Associate
186Mid-level technical MSSC Certified Logistics Technician (CLT)
187NAFTrack Certification
188National Guard Certificate
189National Honor Society for Dance Academics (NDEO)
190National Incident Management System Training (NIMS)
191NCCER Carpentry Level 1 Certificate
192NCCER Carpentry Level 2 Certificate
193NCCER Carpentry Level 3 Certificate
194NCCER Electrical Level 1 Certificate
195NCCER Electrical Level 2 Certificate
196NCCER Electrical Level 3 Certificate
197NCCER HVAC Level 1 Certificate
198NCCER HVAC Level 2 Certificate
199NCCER HVAC Level 3 Certificate
200NCCER Plumbing Level 1 Certificate
201NCCER Plumbing Level 2 Certificate
202NCCER Plumbing Level 3 Certificate
203NCCER Sheet Metal Level 1 Certificate
204NCCER Sheet Metal Level 2 Certificate
205NCCER Sheet Metal Level 3 Certificate
206NCCER Welding Level 1 Certificate
207NCCER Welding Level 2 Certificate
208NCCER Welding Level 3 Certificate
209NOCTI - A/V Technology & Communications (Job Ready)
210NOCTI - Agriculture, Food & Natural Resources (Pathway)
211NOCTI - Audio/Video Communications (Job Ready)
212NOCTI - BioTechnology (Job Ready)
213NOCTI - Computer Networking Fundamentals (Job Ready)
214NOCTI - Graphic Production Technology (Job Ready)
215NOCTI - Legal Services (Pathway)
216NOCTI - Visual Arts (Pathway)
217NOCTI - Web Design (Job Ready)
218Node.js Certified Developer
219Oracle Database 12c Administrator Certified Associate
220Oracle Java Foundations Certified Junior Associate
221Precision Exam - Computer Programming
222Precision Exam - Health Science: Biotechnology
223Precision Exam - Visual Arts
224Precision Exam - Web Development
225Precision Exams - IT Support & Network
226Project Lead the Way - Biomedical Science: Biomedical Innovation
227Project Lead the Way - Biomedical Science: Human Body Systems
228Project Lead the Way - Biomedical Science: Medical Interventions
229Project Lead the Way - Biomedical Science: Principles of Biomedical Science
230Project Lead the Way - Computer Science: Computer Science A
231Project Lead the Way - Computer Science: Computer Science Essentials
232Project Lead the Way - Computer Science: Computer Science Principles
233Project Lead the Way - Computer Science: Cybersecurity
234Project Lead the Way - Engineering: Aerospace Engineering
235Project Lead the Way - Engineering: Civil Engineering and Architecture
236Project Lead the Way - Engineering: Computer Integrated Manufacturing
237Project Lead the Way - Engineering: Computer Science Principles
238Project Lead the Way - Engineering: Digital Electronics
239Project Lead the Way - Engineering: Engineering Design and Development
240Project Lead the Way - Engineering: Introduction to Engineering Design
241Project Lead the Way - Engineering: Principles of Engineering
242Project Lead the Way - Environmental Sustainability
243QuickBooks certification
244Rhode Island Financial Scholars Program (EVERFI)
245Rhode Island Marine Trades Association (RIMTA) Certificate of Completion
246RI CNA license
247RI CPCT provisional license
248RI Dental Hygiene license
249RI EMT license
250Roger Williams University Public Service/Gov Completion
251ServSafe Allergen Training Certification
252Skillconnect Certificate
253SkillsUSA Marine Service Technology Proficiency Assessment
254Sony Vegas/Sound Forge Certification
255Teacher Assistant Certification
256Unity Certified Developer
257ACT National Career Readiness Certificate
258American Heart Association's Basic Life Support (BLS) for Health Care Providers (HCP)
259FFA LifeKnowledge
260First Aid / CPR & AED Training; 
261NOCTI Workplace Skills Career Readiness
262OSHA 10
263OSHA 10 Construction
264OSHA 10 Safe Workplace: Pesticide Safe Worker
265Red Cross Babysitting & Child Care Certificate
266Rhode Island Early Learning and Development Standards Certificate
267SkillsUSA Career Essentials Suite
268WorkKeys Assessment:  Applied Math
269WorkKeys Assessment:  Applied Technology
270WorkKeys Assessment:  Business Writing
271WorkKeys Assessment:  Fit
272WorkKeys Assessment:  Graphic Literacy
273WorkKeys Assessment:  Talent
274WorkKeys Assessment:  Workplace Documents
275WorkKeys Assessment:  Workplace Observation
276NOCTI Business Financial Management Assessment
277NOCTI Financial and Investment Planning Assessment
278NOCTI General Management Assessment
279NIMS: Measurement, Materials & Safety
280NIMS: Manual Milling Skills 1
281NIMS: Turning Operations; Turning Between Centers
282NIMS: Turning Operations; Turning Chucking Skills
283NIMS: CNC Turning; Programming, Setup, & Operations
284NIMS: CNC Milling; Programming, Setup & Operations
285Project Lead the Way - Engineering: Essentials
286Autodesk Inventor
287OSHA 30
288New England Laborers Apprenticeship Training
289HBI PACT Core Examination Certificate
290HBI PACT Specialty: Basic Carpentry Certificate
291American Welding Society (AWS) Level 1
292HBI PACT Specialty: Basic Electrical (NOCTI)
293New England Carpenters Training Fund (NECTF) Level 1
294New England Carpenters Training Fund (NECTF) Level 2
295New England Carpenters Training Fund (NECTF) Level 3
296Precision Exam - Criminal Justice
1031Homeless - Sheltered
1032Homeless - Doubled up
1033Homeless - Unsheltered
1034Homeless - Hotels/Motels
1035Unaccompanied Homeless Youth
1040Migrant
1045Child in foster care
1050Title I School-wide Program
1051Title I Reading/Language Arts
1052Title I Mathematics
1053Title I Science
1054Title I Social Studies
1055Title I Vocational/Career
1056Title I Other Instructional Services
1057Title I Health/Dental/Eye Care
1058Title I Supporting Guidance/Advocacy
1059Title I Other Support Services
1410Intervention - behavior/social emotional
1411Intervention - math
1412Intervention - reading
1413Intervention - oral language
1414Intervention - writing
1415Intervention - other academic
1510reading below grade level (requires a PLP) for Grades K-5
1520reading less than 1 yr. below grade level for Grades 6-12
1521reading 1 yr. or more below grade level (requires a PLP) for Grades 6-12
180121st Century CLC Participant
1901Dual Language - Portuguese
1902Dual Language - Spanish
1909Dual Language - Other
3010CTE Fulltime
3011CTE Parttime
3012Voc Ed Concentrator
3110College Crusade
3111Upward Bound
3112Head Start Participant
4001Bruneian
4002Burmese
4003Cambodian
4004Filipino
4005Hmong
4006Indonesian
4007Laotian
4008Malaysian
4009Thai
4010Timoran
4011Singaporean
4012Vietnamese
4018Southeast Asian - ethnicity unknown
4019Asian - not Southeast Asian
4050Medical Form Submitted
4110Distance Instruction
4111Hybrid Model Instruction
4112In-School Instruction

Generate the Program Status Extract

  1. Select Program Status from the Extract Type dropdown list. 
  2. Enter an Effective Date in mmddyyyy format or select a date from the calendar icon.
  3. Select the Format in which the report should generate. Options are CSV and HTML.
  4. When the student's legal name and gender information should report from the Protected Identity Information area, mark the Report Legal Identities checkbox.
  5. Click Generate Extract to generate the report.

Screenshot of the CSV Format of the Program Status Report.Program Status Extract - CSV Format

Screenshot of the HTML format of the Program Status Report. Program Status Extract - HTML Format  

Program Status Extract Layout

Element Name

Description

Location

DIST CODE

Lists the reporting district code.


Numeric, 2 digits

Enrollments > State Reporting Fields > Resident District Code


Enrollment.serving District

SCH CODE

Identifies the school code.


Numeric, 5 digits

School Information > School Detail > State School Number


School.number

SASID

Reports the state-assigned student identification number.


Numeric, 10 digits

Demographics > Person Identifiers > Student State ID


Person.stateID

LASID

The locally-assigned student identification number.


Numeric, 16 digits

Demographics > Person Identifiers > Local Student Number


Person.student Number

LASTNAME

Reports the student's last name.


When the Report Student Legal Identities checkbox is marked, the student's Legal Last Name reports when a Legal Last Name is entered for that student.


Alphanumeric, 50 characters

Demographics > Last Name


Identity.lastName

Identities > Protected Identity Information > Legal Last Name


Identity.legalLastName

PROGRAM_CODE

Reports the code associated with the program in which the student is enrolled.


See the Program Code List for options.


The Program must be marked as Active and State Reported in order to be included in the report.


Numeric, 4 digits

Flags > Flag


Program.code

PROGRAM_SDATE

Reports the date on which the student began participating in the program.


Date field, 10 characters (MM/DD/YYYY)

Flags > Start Date


Program.startDate

PROGRAM_EDATE

The date on which the student stopped participating in the program.


When the Program End Date is blank AND the Enrollment End Date is populated, the Enrollment End Date reports. 


Otherwise, this field reports blank.


Date field, 10 characters (MM/DD/YYYY)

Flags > End Date


Program.endDate

Enrollment > General Enrollment Information > End Date


Enrollment.endDate

PROGRAM_EXIT_CODE

The code describing the student's exit from the program.

Options are:

  1. Completed Program
  2. Voluntary Withdrawal
  3. Involuntary Withdrawal
  4. Still Active

Numeric, 1 digit

Flags > Exit Status


ProgramParticipation. exitStatus

Previous Versions

Program Status Extract (Rhode Island) [.2211 - .2243]

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com