Career Cruising Integration Data Files

This topic describes the data files for the Career Cruising integration.

For information about the Career Cruising Utility, refer to Career Cruising Utility Page.

Download Files

The following files can be created for the Career Cruising integration. These files include building, student, course, and student mark reporting data.

School.txt

This file contains information for all the schools in the district, to be loaded into the School table in Career Cruising.

Career Cruising Field	eSchoolPlus table.field	Comments
SchoolCode	reg_building.building	Integer building number converted to character.
Name	reg_building.building_name	Building name will be truncated to 250 characters.
SchoolType	reg_building.building_type	Translated based on Career Cruising Building Types to one of the following: 1 for secondary or high school, 2 for elementary or middle, 3 for other.

CourseMaster.txt

This file contains information for all active courses in the Course Catalog.

Career Cruising Field	eSchoolPlus table.field	Comments
SchoolCode	Schd_course.building	Integer building number converted to character.
CourseCode	Schd_course.course
CourseName	Schd_course.description	Course description will be truncated to 250 characters.
CreditValue	Schd_course.credit
GradeLowerInt	Schd_course.min_grade	This is the Course Catalog's Include for Minimum Grade field which is related to the PerformancePLUS Integration. It is an optional field in eSchoolPlus. A blank will be returned if no value is entered in the Include for Minimum Grade field.
GradeUpperInt	Schd_course.max_grade	This is the Course Catalog's Include for Maximum Grade field which is related to the PerformancePLUS Integration. It is an optional field in eSchoolPlus. A blank will be returned if no value is entered in the Include for Maximum Grade field.

Student.txt

Use the Career Cruising Utility's Filter options to select the students to include in the data file.

Career Cruising Field	eSchoolPlus table.field	Comments
StudentID	reg.student_id
FirstName	reg.first_name
LastName	reg.last_name
Gender	reg.gender	M or F.
DateofBirth	reg.birthdate	MM/DD/YYYY converted to YYYY-MM-DD format.
CurrentGrade	reg.grade	Student's grade level. Grade level is converted from alpha to integer.
CurrentSchoolCode	reg.building	Building number.
PreRegSchoolCode	reg_next_year.next_building	Next building number.
Email	reg_contact.email	From the Physical contact record for the student.
UserName	reg_contact.login_id	From the Physical contact record for the student.
Password	reg_contact.web_password	From the Physical contact record for the student. The password will be hashed; it cannot be decrypted.
CurrentTeacher	reg.homeroom_primary	Name of the teacher for the student's primary homeroom.
DegreeType	reg.diploma_type	Diploma type code.
GroupVariable	N/A	Not applicable.
StudentGuid	N/A	Not applicable.

StudentCourses.txt

Use the Career Cruising Utility's Filter options to select the students to include in the data file.

Career Cruising Field	eSchoolPlus table.field	Comments
StudentID	mr_stu_hdr.student_id
CourseCode	mr_stu_hdr.section_key	The schd_ms.course field value for the section_key.
CourseName	mr_stu_hdr.section_key	The schd_ms.description field value for the section_key, truncated to 100 characters.
DateCourseComplete	reg_mp_dates.end_date	The End Date from the marking period dates (reg_mp_dates) record for the last marking period in which the course meets (schd_ms_mp). Date will be in a YYYY-MM-DD format.
GradeMark	N/A	Due to school districts having unique situations for which mark for a course should be used as the "final" mark, this field will be blank, and marks will be in fields appended to the file as indicated below.
CreditValue	mr_stu_hdr.earn_credit or mr_stu_hdr.att_credit	If course is completed, this will be the earned credit, otherwise it is the attempted credit.
HSCourse	schd_ms_bldg_type.bldg_type	New setup table regtb_cc_bldg_type will need to indicate a 1 for high school or otherwise 0 for the user-defined building types. Will be 1 if one of the building types for the course is indicated as such.
CoursePart	mr_crssequ_det.equiv_sequence	0 if year-long course, 1 or 2 if semesterized course (mr_crsequ_det). If no mr_crsequ_det record, then 0.
MarkType1	mr_stu_marks.mark_value	Most recent mark of the mark type specified in the regtb_cc_mark_type table where mark_no =1.
MarkType2	mr_stu_marks.mark_value	Most recent mark of the mark type specified in the regtb_cc_mark_type table where mark_no = 2.
MarkType3	mr_stu_marks.mark_value	Most recent mark of the mark type specified in the regtb_cc_mark_type table where mark_no =3.
MarkType4	mr_stu_marks.mark_value	Most recent mark of the mark type specified in the regtb_cc_mark_type table where mark_no =4.
MarkType5	mr_stu_marks.mark_value	Most recent mark of the mark type specified in the regtb_cc_mark_type table where mark_no = 5.

Upload File

The Career Cruising Integration includes the ability to upload student course requests from Career Cruising to the eSchoolPlus database. The CourseRequests.txt file must be pipe-delimited and include a header line with column headers. The following table describes how each field in the file is processed.

Career Cruising Field	eSchoolPlus table.field	Comments
HighSchoolCode	schd_stu_req.building	Course request building.
StudentID	schd_stu_req.student_id	Student ID.
FirstName	N/A	Not uploaded.
LastName	N/A	Not uploaded.
CourseCode	schd_stu_req.course	Requested course.
Status	N/A	Not uploaded.
SelectionType	schd_stu_req.request_type	Values will be converted as follows: Standard -> R – regular request Alternate ->S – student alternate request
AltCourseCode	schd_stu_req.alt_to_request	Course code for alternate course request for the specific course request.
Priority	N/A	Not uploaded.
Semester	schd_stu_req_mp.marking_period	If a comma-delimited list of marking periods is included in the field, separate marking period records are inserted.
CourseSection	schd_stu_req.course_section	Course section requested, if specified.