Populating Tables for Student Records

At a minimum for Student Records, set up these tables in the sequence they are listed.

For the course catalog and schedule of classes, there is PeopleCode behind the COURSE_ID field to increment a new course ID by 1. To mimic what this PeopleCode does, the conversion program needs to do the +1 logic. You can manually set the next available course ID in the installation table for Campus Solutions. You should update the last course ID assigned in the Installation table, so that you do not have collisions between the course IDs assigned by the conversion and course IDs manually created later.

In addition to the conversion program you write to create the catalog, you should set the Status field on the Catalog Data page to Active so that the course is active as soon as you run the conversion program to create the record.

Course Catalog Tables

Populate these tables for the course catalog:

  • CRSE_CATALOG

  • CRSE_COMPONENT

  • CRSE_OFFER

Schedule of Classes Tables

Populate these tables for the schedule of classes:

  • CLASS_TBL

  • CLASS_ASSOC

  • CLASS_COMPONENT

Student Careers and Plans

Populate these tables for student careers and plans:

  • STDNT_CAREER

  • STDNT_CAR_SEQ

  • ACAD_PROG

  • ACAD_PLAN

Student Degrees

Populate these tables for student degrees:

  • DEGREE_TBL: populate this table manually.

  • ACAD_DEGREE.

  • ACAD_DEGR_HON.

  • ACAD_DEGR_PLAN.

  • ACAD_DEGR_SPLN.

Grades

Populate these tables manually for grades:

  • GRADING_SCHEME_TBL

  • GRADE_BASIS_TBL

  • GRADE_TBL

Student Term Data

Populate these tables for student term data:

  • STDNT_CAR_TERM

  • ENRL_REQ_HEADER

  • ENRL_REQ_DETAIL

Related Topics