(GN) Student Course Record

Report Parameters

Schools for which to run?*

If run at the district level, choose one of the following:

• Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report

• All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Current Selection Students*

Indicate which students to include in the report by selecting one of the following options:

• The Selected [number] Students Only – Run the report for students in the current selection.

• All Students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Report Start Date*

Enter the start date for scanning school enrollments.

Format: [M]M/[D]D/[YY]YY

Report End Date*

Enter the end date for scanning school enrollments.

Format: [M]M/[D]D/[YY]YY

Reporting Period*

Select the reporting period for which you are creating the extract.

Fiscal Year*

Enter the fiscal year for the report.

Scheduling

Run Now

Select this option to execute the report in the order it is received in the report queue.

Schedule (available Version 7.1.1.)

Enter the start date and start time for the report.

• Select Run Once and Submit to run the report at the specified date and time.

• Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

N/A

Filler

Filler

N/A

Numeric

8

1–8

GN010

Sort Type

The sort type equals GN for the Student Course extract.

N/A

Alpha-numeric

2

9–10

N/A

Filler

Filler

N/A

Alpha-numeric

1

11

GN020

Fiscal Year

The fiscal year is set by report input.

N/A

Alpha-numeric

4

12–15

GN030

Data Set

The fiscal year is set by report input.

N/A

Alpha-numeric

1

16

GN040

District IRN

This field contains the district number. This field value is extracted from the District Information preferences.

[Prefs]Name= districtname

[Prefs]Value

Alpha-numeric

6

17–22

GN050

EMIS Student ID Number

This field contains the EMIS student ID number assigned by the district to this student. This field value is extracted from the Student Number field on the Student Profile > Demographics page, and prepended with the EMIS Prefix ID, if entered, else zeroes are added to create a 9-digit number.

[Students]Student_Number

Alpha-numeric

9

23–31

GN080

Local Classroom Code

This field is calculated by concatenating the School ID, Course Number, and Section Number.

[Schools]School_Number

[Sections]Course_Number

[Sections]Section_Number

Alpha-numeric

20

32–51

N/A

Filler

Filler

N/A

Alpha-numeric

1

52

GN150

High School Credit Earned

This field is calculated. Y displays in this field if the student has grades for this class; otherwise, N displays.
Two circumstances can change the value extracted:

• If the Subject Area for Credit field on the Course Edit page is set to Not Applicable, the High School Credit Earned value extracted for all students for that class is an asterisk regardless of whether or not the student has a grade for that class

• If the High School Credit Earned field on the Current Enrollment page is set to P, the student received credit as reported in the Partial/Override Credit field, P is exported as the value for the High School Credit Earned field and the credit value displays in the Partial/Override Credit field.

• This circumstance does not apply if the High School Credit Earned field on the Current Enrollment page is set to Determined by Course Settings for a student for a given course.

N/A

Alpha-numeric

1

53

N/A

Filler

Filler

N/A

Alpha-numeric

2

54–55

GN152

Partial / Override Credit

If the High School Credit Earned field equals P, this field contains the number of credits the student earned for this course. This field value is extracted from the Partial/Override Credit field on the Student Selection > Courses and Programs > Course Registrations > Edit Enrollment Record.

[CC]PartialOverrideCredit

Numeric

3 with 2 decimal places

56–58

GN160

Course Enrollment Start Date

The first day of a student’s enrollment in a course. Defaults to 00000000 if the student enrolled from the Course Start Date. Format: CCYYMMDD.

[CC]DateEnrolled

Numeric

8

59–66

GN170

Course Enrollment End Date

The last day of a student’s enrollment in a course. Defaults to 00000000 if the student enrolled through the Course End Date. Format: CCYYMMDD.

[CC]DateLeft

Numeric

8

67–74

N/A

Filler

Filler

N/A

Alpha-numeric

86

75–160