Program Status Extract (Rhode Island)

Last Modified on 10/22/2022 10:36 am CDT

Classic View: RI State Reporting > Enrollment Census > Program Status 

Search Terms: Enrollment Census

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

Enrollment Census Program Status Extract  

Report Logic

Only Programs listed in the Program Code List report.

The student's Program Start Date must be on or before 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 an Enrollment Status of W (Summer Withdrawal) or those whose enrollment is marked as State Exclude are not included in the extract results.

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

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

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 (CCENT)
115CompTIA
117ETA Certificates
120I-CAR
122ISCET Electronics Systems Associate (ESA) Levels 1-4
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
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
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
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
1031Homeless - Sheltered
1032Homeless - Doubled-Up
1033Homeless - Unsheltered
1034Homeless - Hotels/Motels
1035Unaccompanied Homeless Youth
1045Child In Foster Care
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
1901Dual Language - Portuguese
1902Dual Language - Spanish
1909Dual Language - Other
3110College Crusade
3111Upward Bound
3112Head Start Participant
4001Bruneian
4002Burmese
4003Cambodian
4004Filipino
4005Hmong
4006Indonesian
4007Laotian
4008Malaysian
4009Thai
4010Timoran
4011Singaporean
4012Vietamese
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 by clicking the calendar icon and selecting a date. 
  3. Select the Format in which the report should generate. Options are CSV and HTML.
  4. If 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.

Program Status Extract - CSV Format  

Program Status Extract - HTML Format  

Program Status Extract Layout

Element Name

Description

Location

DIST CODE

The reporting district code.


Numeric, 2 digits

Student Information > General > Enrollments Tab > State Reporting Fields > Resident District Code


Enrollment.serving District

SCH CODE

Identifies the school code.


Numeric, 5 digits

System Administration > Resources > School > School Detail > State School Number


School.number

SASID

The state-assigned student identification number.


Numeric, 10 digits

Census > People > Demographics > Person Identifiers > Student State ID


Person.stateID

LASID

The locally-assigned student identification number.


Numeric, 16 digits

Census > People > Demographics > Person Identifiers > Local Student Number


Person.student Number

LASTNAME

The student's last name.


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


Alphanumeric, 50 characters

Census > People > Demographics > Last Name


Identity.lastName

Census > People > Identities > Protected Identity Information > Legal Last Name


Identity.legalLastName

PROGRAM_CODE

The code attached to the program in which the student is enrolled. 


See the Program Code List for options.


Numeric, 4 digits

Student Information > General > Flags > Flag


Program.code

PROGRAM_SDATE

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


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

Student Information > General > Flags > Start Date


Program.startDate

PROGRAM_EDATE

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


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

Student Information > General > Flags > End Date


Program.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

Student Information > General > Flags > Exit Status


ProgramParticipation. exitStatus


Related Articles

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

Thank you!

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