Some schools have students who go to a serving school. The
serving school sends the Teacher Course Assignment, but the home school sends
the Student Course Assignment. Because some serving schools are using section
numbers longer than 2 characters, we have added a field to allow for entry of a
longer section number on a course in the course master that will match the
section number from a serving school.
The field is called SR_Section
and is set at 50 characters. It has been added to the following tables in
the database:
Coursemaster
Coursemaster_NY
Coursemaster_SR
Transcript_Detail
Clients who have courses in the course master
requiring a longer section number will fill in the SR_Section field in the
Coursemaster and Coursemaster_NY tables. Clients who just manually enter
Transcript Detail records for serving school classes will fill in the SR_Section
field in the Transcript Detail table with the longer section numbers.
GPA Calculation
When posting to transcript,
Transcript_detail.SR_Section will be populated from Coursemaster.SR_Section, if
a section number has been entered in this field on the Coursemaster record. If
no section has been entered, the field is populated with
(Coursemaster.Course_number & Coursemaster.section).
State
Reporting
Student Course Assignment: The report field “Section” will be
matched to Transcript_Detail.SR_Section. This match will be forced to avoid user
error.
Teacher Course Assignment (Ent and Exit): The report field
“Section_Number” will be matched to CourseMaster_SR.SR_Section. This match will
be forced to avoid user error. This field is populated when the report is run.
The criteria are the same as above in GPA calculation.