Student CTE Program Associations (Core v3.X)

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

Tool Search: Ed-Fi

This association represents the career and technical education (CTE) program that a student participates in. The association is an extension of the StudentProgramAssociation particular for CTE programs.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an the student has a Career Tech Program record that overlaps the configured year and the student has an enrollment in the configured year.

  • Do not send records if the Calendar Exclude check box is checked in the calendar the student is enrolled.
  • Do not send records if the School Exclude check box is checked in the calendar the student is enrolled.
  • Do not send a record if the No Show check box is checked.
Put

When the Programs> Career Tech Programs record is updated by the following fields, all student's records will be updated.

  • State Code (CIP)
Put

When the student's Academic Planning> Career Tech Program Detail record has changed for a student.

  • Student Status
  • End Date
  • Non-Traditional Participation
Delete/Post

When the start date of a Career Tech Program record is changed.

DeleteWhen the Career Tech Program record is deleted.
DeleteIf the Career Tech start/end dates are changed and the record no longer overlaps the configured year.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
ResyncIf a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
ResyncIf a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.


Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

ActionTrigger
Post/Delete

Natural Key changes:

  • LEA Reference - District Numbers cannot change after data has been sent.  If a district number changes, we would expect an Ed-Fi error and this change would not be supported.
  • If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers.
  • Start Date - if the start date of the record changes, the record will delete then repost with new date.
DeleteCascading Deletes:  N/A - no dependent resources.


Scope Year Logic

This table describes scope year logic of this object.

Logic

The record will send to and year that the student's Career Tech record overlaps with.

Data will only send for the years that have valid configuration.


Resource Preferences

Data Element Label

Mapping Needed

Career Tech Pathway/Program NamecareerPathwayDescriptor
Student StatuscteProgramCompletionIndicator
Select the Program Type Descriptor associated with this ProgramProgram Type Descriptor

Student's Career Tech Program Certifications Status is = Passing

Student's Career Tech Program Certifications Status is = Attempted

Student does not have a Career Tech Program Certifications record 

Technical Skills Assessment Descriptors

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
programsPutThe primary table for sending data for this resource.
programparticipationPutThe primary table for sending data for this resource.

Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field
 id The unique identifier of the resource.


M

beginDateThe month, day, and year on which the Student first received services.
  1. Reports the start date of the Career Tech Program the student is assigned.
MStudent Information> Academic Planning> Programs> Program Type:  Career Tech Program> Start Dateprogramparticipation.startdate
educationOrganizationReferenceA reference to the related Education Organization Resource.
  1. Reports the Natural Key of the Local Education Agencies resource.
M

programReferenceA reference related to the Program resource.
  1. Reports the Natural Key of the Programs resource.
M

studentReference

A reference to the related Student resource.

  1. Reports the Natural Key of the Students resource.
M

cteProgramsThe career cluster representing the career path of the Vocational/Career Tech concentrator.
  1. See array section below for requirements.
O





endDateThe month, day, and year on which the Student exited the Program or stopped receiving services.
  1. Reports the end date of the Career Tech Program the student is assigned.
OStudent Information> Academic Planning> Programs> Program Type:  Career Tech Program> End Dateprogramparticipation.enddate
nonTraditionalGenderStatus

Indicator that student is from a gender group that comprises less than 25% of the individuals employed in an occupation or field of work.

  1. Reports 'True' if the Non-Traditional Participation checkbox is checked.
  2. Else, report 'False'.
OStudent Information> Academic Planning> Programs> Program Type:  Career Tech Program> Non-Traditional Participationprogramparticipation.nonTraditional
privateCTEProgramIndicator that student participated in career and technical education at private agencies or institutions that are reported by the state for purposes of the Elementary and Secondary Education Act (ESEA). Students in private institutions which do not receive Perkins funding are reported only in the state file.
  1. Always report 'False'.
O

reasonExitedDescriptorThe reason the child left the Program within a school or district.
  1. This field is optional, does not report.
O

servedOutsideOfRegularSession

Indicates whether the Student received services during the summer session or between sessions.

  1. This field is optional, does not report.
O

services Indicates the Service(s) being provided to the Student by the Program.
  1. This field is optional, does not report.
O

technicalSkillsAssessmentDescriptor

Results of technical skills assessment aligned with industry recognized standards.

  1. Report the  descriptor based on the mapped results on the student's Career Tech Program - Certifications record.
    • Student's Career Tech Program Certifications Status is = Passing
    • Student's Career Tech Program Certifications Status is = Attempted
    • Student does not have a Career Tech Program Certifications record.
  2. If the student has more than 1 Certification record, use the record with the date that overlaps the configured year.
    • If the student has more than 1 eligible record, report the record with the most recent start date.
    • If the date on the certification record is NULL, use the record with the highest participationCertificationID.
O

Arrays

Click here to expand...

ctePrograms

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

careerPathwayDescriptor

A sequence of courses within an area of interest that is a student’s educational road map to a chosen career.
  1. Report the Ed-Fi code from the mapped Career Tech Program Pathway/Program Name.
  2. If the pathway is not mapped, do not report.
MProgram Admin> Programs> Career Tech Programs> Pathway/Program Nameprogram.name
cipCode

Number and description of the CIP Code associated with the student’s CTEProgram.

  1. Reports the State Code (CIP) from the Career Tech Program being reported.

O

Program Admin> Programs> Career Tech Programs> State Code (CIP)program.code
cteProgramCompletionIndicator

A boolean indicator of whether the Student has completed the CTEProgram.

  1. Reports 'True' if the student has a Student Status that is mapped in Resource Preferences.
  2. Report 'False' if the student has a Student Status that is not mapped in Resource Preferences or the Student Status is blank.
OStudent Information> Academic Planning> Program Type= Career Tech Program> Student Statusprogramparticipation.studentStatus
primaryCTEProgramIndicator

A boolean indicator of whether this CTEProgram, is the student’s primary CTEProgram.

  1. Report 'True' if the student has only 1 eligible Career Tech Program record in the configured year.
  2. If the student has more than 1 eligible Career Tech program in the a configured year, report 'True' for the record with the most recent start date. For all other records, report 'False'.
O

 


Type/Descriptors

Click here to expand...

Career Pathway Descriptors

Code ValueDescriptionNamespaceShort Description
Agriculture, Food and Natural ResourcesAgriculture, Food and Natural Resourcesuri://ed-fi.org/CareerPathwayDescriptorAgriculture, Food and Natural Resources
Architecture and ConstructionArchitecture and Constructionuri://ed-fi.org/CareerPathwayDescriptorArchitecture and Construction
Arts, A/V Technology and CommunicationsArts, A/V Technology and Communicationsuri://ed-fi.org/CareerPathwayDescriptorArts, A/V Technology and Communications
Business, Management and AdministrationBusiness, Management and Administrationuri://ed-fi.org/CareerPathwayDescriptorBusiness, Management and Administration
Education and TrainingEducation and Traininguri://ed-fi.org/CareerPathwayDescriptorEducation and Training
FinanceFinanceuri://ed-fi.org/CareerPathwayDescriptorFinance
Government and Public AdministrationGovernment and Public Administrationuri://ed-fi.org/CareerPathwayDescriptorGovernment and Public Administration
Health ScienceHealth Scienceuri://ed-fi.org/CareerPathwayDescriptorHealth Science
Hospitality and TourismHospitality and Tourismuri://ed-fi.org/CareerPathwayDescriptorHospitality and Tourism
Human ServicesHuman Servicesuri://ed-fi.org/CareerPathwayDescriptorHuman Services
Information TechnologyInformation Technologyuri://ed-fi.org/CareerPathwayDescriptorInformation Technology
Law, Public Safety, Corrections and SecurityLaw, Public Safety, Corrections and Securityuri://ed-fi.org/CareerPathwayDescriptorLaw, Public Safety, Corrections and Security
ManufacturingManufacturinguri://ed-fi.org/CareerPathwayDescriptorManufacturing
Marketing, Sales and ServiceMarketing, Sales and Serviceuri://ed-fi.org/CareerPathwayDescriptorMarketing, Sales and Service
OtherOtheruri://ed-fi.org/CareerPathwayDescriptorOther
Science, Technology, Engineering and MathematicsScience, Technology, Engineering and Mathematicsuri://ed-fi.org/CareerPathwayDescriptorScience, Technology, Engineering and Mathematics
Transportation, Distribution and LogisticsTransportation, Distribution and Logisticsuri://ed-fi.org/CareerPathwayDescriptorTransportation, Distribution and Logistics

Technical Skills Assessment Descriptors

Code ValueDescriptionNamespaceShort Description
PassedPasseduri://ed-fi.org/TechnicalSkillsAssessmentDescriptorPassed
Did Not TakeDid Not Takeuri://ed-fi.org/TechnicalSkillsAssessmentDescriptorDid Not Take
Not PassedNot Passeduri://ed-fi.org/TechnicalSkillsAssessmentDescriptorNot Passed

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