Arizona Ed-Fi Data v3.1 - Courses | Infinite Campus Test

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
	Arizona has pre-loaded courses so courses are not posted or deleted.

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.

Action	Trigger
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Delete	If a resource is toggled to 'OFF" after data has sent and an action is performed that would trigger a delete, that data will remain in the ODS until a resync is done.
Resync	If 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.
Resync	If 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.
Resync	If 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.

Action	Trigger
Delete/Post	If any of the following changes in the Schools resource: If the Ed-Fi School Number changes. School ID: If the State School Number changes and the Ed-Fi School Number is NULL
Delete/Post	If the State Code or Number changes.
Delete/Post	Cascading Updates/Delete: If the natural key changes all dependent data will be deleted/reposted: Course Transcripts

Action

Trigger

Delete/Post

If any of the following changes in the Schools resource:

If the Ed-Fi School Number changes.
School ID: If the State School Number changes and the Ed-Fi School Number is NULL

Delete/Post

If the State Code or Number changes.

Delete/Post

Cascading Updates/Delete: If the natural key changes all dependent data will be deleted/reposted:

Course Transcripts

Scope Year Logic

This table describes scope year logic of this object.

Logic
Courses will report to the configured year to which they are aligned.
Data will only send for years that have valid configuration.

Error Log

Error	Possible Causes/How to fix
409: Failed to delete courses resource. [message:The resource (or a subordinate entity of the resource) cannot be deleted because it is a dependency of the 'courseOffering' entity.]	There are still dependent resources in the Ed-Fi ODS so the course record cannot be deleted. Use the delete tool to remove any dependent data before the course can be removed.

Error

Possible Causes/How to fix

409: Failed to delete courses resource.

[message:The resource (or a subordinate entity of the resource) cannot be deleted because it is a dependency of the 'courseOffering' entity.]

There are still dependent resources in the Ed-Fi ODS so the course record cannot be deleted. Use the delete tool to remove any dependent data before the course can be removed.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
State Code and Number	Course Identification System Descriptors
Course SCED Subject Area	Academic Subject Descriptors
Course Difficulty Level	Course Level Characteristic Types

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectType	Object Key Data Source
Course	courseID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
course	Post/Put/Delete	The primary table used for sending data for this resource.

Object Data Elements

This table describes data elements sent within the Courses resource.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
courseCode	A unique alphanumeric code assigned to a course.	Report the Course ID for the course	M	Scheduling> Course> Course ID	course.ID
identificationCodes	An unordered collection of courseIdentificationCodes. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis	See Array logic below	M
educationOrganizationReference	A reference to the related Education Organization resource	Reports the School number associated with the course	M
academicSubjectDescriptor	The intended major subject area of the course.	Reports the Ed-Fi Code from the SCED SCED Subject Area. If NULL or Ed-Fi Value is blank, do not report.	O	Scheduling> Course> SCED Subject Area	course.sced SubjectArea
careerPathwayDescriptor	The career cluster or pathway representing the career path of the Vocational/CTE concentrator.	This field is optional, do not report.	O
competencyLevels	An unordered collection of courseCompetencyLevels. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	This field is optional, do not report.	O
courseDefinedByDescriptor	Specifies whether the course was defined by the SEA, LEA, school or national organization.	This field is optional, do not report.	O
courseDescription	A description of the content standards and goals covered in the course. Reference may be made to state or national content standards.	This field is optional, do not report.	O
courseGPAApplicabilityDescriptor	An indicator of whether or not this course being described is included in the computation of the student’s Grade Point Average, and if so, if it weighted differently from regular courses.	This field is optional, do not report.	O
courseTitle	The descriptive name given to a course of study offered in a school or other institution or organization. In departmentalized classes at the elementary, secondary, and postsecondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts).	Reports the Course Name.	M	Scheduling> Course> Name	course.name
dateCourseAdopted	The date the district adopted the course.	This field is optional, do not report.	O
highSchoolCourseRequirement	An indication that this course credit is required for a high school diploma.	This field is optional, do not report.	O
learningObjectives	An unordered collection of courseLearningObjectives. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	This field is optional, do not report.	O
learningStandards	An unordered collection of courseLearningStandards. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	This field is optional, do not report.	O
levelCharacteristics	An unordered collection of courseLevelCharacteristics. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	See Array logic below.	O
maxCompletionsForCredit	Designates how many times the course may be taken with credit received by the student.	This field is optional, do not report.	O
maximumAvailableCreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	This field is optional, do not report.	O
maximumAvailableCredits	The maximum amount of credit available to a student who successfully completes the course.	This field is optional, do not report.	O
maximumAvailableCreditTypeDescriptor	The type of credits or units of value awarded for the completion of a course.	This field is optional, do not report.	O
minimumAvailableCreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	This field is optional, do not report.	O
minimumAvailableCredits	The minimum amount of credit available to a student who successfully completes the course.	This field is optional, do not report.	O
minimumAvailableCreditTypeDescriptor	The type of credits or units of value awarded for the completion of a course.	This field is optional, do not report.	O
numberOfParts	The number of parts identified for a course.	Report the value selected in the SCED Sequence "Part m" field.. If NULL, report '1'.	M	Scheduling> Course> SCED Sequence (part m)	course.sced SequenceMax
offeredGradeLevels	An unordered collection of courseGradeLevels. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	This field is optional, do not report.	O
timeRequiredForCompletion	The actual or estimated number of clock minutes required for class completion. This number is especially important for career and technical education classes and may represent (in minutes) the clock hour requirement of the class.	This field is optional, do not report.	O
etag	A unique system-generated value that identifies the version of the resource.	This field is optional, do not report.	O

Arrays

Course Identification Code

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
courseIdentificationSystemDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	Reports the mapped Ed-Fi Code for the identification code being reporte.	M
assigningOrganizationIdentificationCode	The organization code or name assigning the staff Identification Code.	This field is optional, do not report.	O
identificationCode	A unique number or alphanumeric code assigned to a space, room, site, building, individual, organization, program, or institution by a school, school system, a state, or other agency or entity.	Reports the State Code if populated on Course and is mapped to an Ed-FI Code. Reports the Number if mapped to an Ed-Fi Code.	M	Scheduling> Course> State Code and/or Scheduling> Course> Number	course.statecode or course.number

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

courseIdentificationSystemDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Reports the mapped Ed-Fi Code for the identification code being reporte.

assigningOrganizationIdentificationCode

The organization code or name assigning the staff Identification Code.

This field is optional, do not report.

identificationCode

A unique number or alphanumeric code assigned to a space, room, site, building, individual, organization, program, or institution by a school, school system, a state, or other agency or entity.

Reports the State Code if populated on Course and is mapped to an Ed-FI Code.
Reports the Number if mapped to an Ed-Fi Code.

Scheduling> Course> State Code

and/or

Scheduling> Course> Number

course.statecode

course.number

Course Level Characteristics

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
courseLevelCharacteristicDescriptor	Specification of the specific program or designation associated with the course. For example: Ap, IB, Dual Credit, CTE, etc	Reports the Ed-Fi Code from the Course Level Selected. If Ed-FI Code is NULL or field is blank, do not report.	M	Scheduling> Courses> Course Level	course.honorsCode

Type/Descriptor

Course Identification System Descriptor

Code Value	Description	Namespace	Short Description
NCES Pilot SNCCS course code	NCES Pilot SNCCS course code	uri://ed-fi.org/CourseIdentificationSystemDescriptor	NCES Pilot SNCCS course code
School course code	School course code	uri://ed-fi.org/CourseIdentificationSystemDescriptor	School course code
SCED course code	SCED course code	uri://ed-fi.org/CourseIdentificationSystemDescriptor	SCED course code
Intermediate agency course code	Intermediate agency course code	uri://ed-fi.org/CourseIdentificationSystemDescriptor	Intermediate agency course code
University course code	University course code	uri://ed-fi.org/CourseIdentificationSystemDescriptor	University course code
LEA course code	LEA course code	uri://ed-fi.org/CourseIdentificationSystemDescriptor	LEA course code
State course code	State course code	uri://ed-fi.org/CourseIdentificationSystemDescriptor	State course code
Other	Other	uri://ed-fi.org/CourseIdentificationSystemDescriptor	Other
CSSC course code	CSSC course code	uri://ed-fi.org/CourseIdentificationSystemDescriptor	CSSC course code

Academic Subject Descriptors

Code Value	Description	Namespace	Short Description
Career and Technical Education	Career and Technical Education	uri://ed-fi.org/AcademicSubjectDescriptor	Career and Technical Education
Composite	Composite	uri://ed-fi.org/AcademicSubjectDescriptor	Composite
Critical Reading	Critical Reading	uri://ed-fi.org/AcademicSubjectDescriptor	Critical Reading
Cross Subject	Cross Subject	uri://ed-fi.org/AcademicSubjectDescriptor	Cross Subject
English	English	uri://ed-fi.org/AcademicSubjectDescriptor	English
English Language Arts	English Language Arts	uri://ed-fi.org/AcademicSubjectDescriptor	English Language Arts
Fine and Performing Arts	Fine and Performing Arts	uri://ed-fi.org/AcademicSubjectDescriptor	Fine and Performing Arts
Foreign Language and Literature	Foreign Language and Literature	uri://ed-fi.org/AcademicSubjectDescriptor	Foreign Language and Literature
Life and Physical Sciences	Life and Physical Sciences	uri://ed-fi.org/AcademicSubjectDescriptor	Life and Physical Sciences
Mathematics	Mathematics	uri://ed-fi.org/AcademicSubjectDescriptor	Mathematics
Military Science	Military Science	uri://ed-fi.org/AcademicSubjectDescriptor	Military Science
Other	Other	uri://ed-fi.org/AcademicSubjectDescriptor	Other
Physical, Health, and Safety Education	Physical, Health, and Safety Education	uri://ed-fi.org/AcademicSubjectDescriptor	Physical, Health, and Safety Education
Reading	Reading	uri://ed-fi.org/AcademicSubjectDescriptor	Reading
Religious Education and Theology	Religious Education and Theology	uri://ed-fi.org/AcademicSubjectDescriptor	Religious Education and Theology
Science	Science	uri://ed-fi.org/AcademicSubjectDescriptor	Science
Social Sciences and History	Social Sciences and History	uri://ed-fi.org/AcademicSubjectDescriptor	Social Sciences and History
Social Studies	Social Studies	uri://ed-fi.org/AcademicSubjectDescriptor	Social Studies
Writing	Writing	uri://ed-fi.org/AcademicSubjectDescriptor	Writing

Course Level Characteristics

Code Value	Description	Namespace	Shor tDescription
Gifted and Talented	Gifted and Talented	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Gifted and Talented
Untracked	Untracked	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Untracked
Pre-AP	Pre-AP	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Pre-AP
Graduation Credit	Graduation Credit	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Graduation Credit
Dual Credit	Dual Credit	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Dual Credit
General	General	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	General
Remedial	Remedial	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Remedial
International Baccalaureate	International Baccalaureate	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	International Baccalaureate
Honors	Honors	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Honors
English Language Learner	English Language Learner	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	English Language Learner
Accepted as high school equivalent	Accepted as high school equivalent	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Accepted as high school equivalent
Advanced	Advanced	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Advanced
Advanced Placement	Advanced Placement	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Advanced Placement
Basic	Basic	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Basic
Career and Technical Education	Career and Technical Education	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Career and Technical Education
College-level	College-level	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	College-level
Core Subject	Core Subject	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Core Subject
Correspondence	Correspondence	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Correspondence
Distance Learning	Distance Learning	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Distance Learning
Pre-IB	Pre-IB	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Pre-IB
Other	Other	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Other
Magnet	Magnet	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Magnet
Students with disabilities	Students with disabilities	uri://ed-fi.org/CourseLevelCharacteristicDescriptor	Students with disabilities

Arizona Ed-Fi Data v3.1 - Courses

Object Triggering Logic

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Error Log

Resource Preferences

Identity Mapping Object Key

Event Queue Detail

Object Data Elements

Arrays

Course Identification Code

Course Level Characteristics

Type/Descriptor

Course Identification System Descriptor

Academic Subject Descriptors

Course Level Characteristics

Related Articles