Student Courses File Layout

10.01

Record Type Code

Y

Not found in eSchoolPlus. For the Fall Submission, the value will be SCSE and for the End of Year Submission it will be SCSC.

10.02

Transaction Type Code

N

Not found in eSchoolPlus. This field tells CALPADS if the data being sent is an update, deletion or new record.

10.03

Local Record ID

N

Not being sent in files created in eSchoolPlus

10.04

Reporting LEA

Y

reg_entry_with

building

First 7 characters of State Equivalency Code for the building on the Entry/Withdrawal record being reported for the student. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel.

10.05

School of Course Delivery

Y

reg_v_programs



or
reg_entry_with

prog_value where state_code_equiv = 'ca(code)_schl' (see 3.13 for list of codes)
or building

Last 7 characters of State Equivalency Code for the building on the Entry/Withdrawal record being reported for the student. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel.

10.06

Academic Year ID

Y

From the School Year prompt on CALPADS extract/download page.

10.07

SSID

Y

reg_personal

state_report_id

Registration > Entry & Reports > Student Demographic > Personal—SSID field.

10.08

Local Student ID

Y

reg_entry_with

student_id

Student ID field

10.09

Student Legal First Name

Y

reg

first_name

Registration > Entry & Reports > Student Demographic > Registration—First Name field. Since the State file may only include Alphabetic letters, numbers, periods, hyphens and apostrophes any other characters in this field will be stripped out for the State File.

10.10

Student Legal Last Name

Y

reg

last_name

Registration > Entry & Reports > Student Demographic > Registration—Last Name field. Since the State file may only include Alphabetic letters, numbers, periods, hyphens and apostrophes any other characters in this field will be stripped out for the State File.

10.11

Student Birth Date

Y

reg

birthdate

Registration > Entry & Reports > Student Demographic > Registration—Birth Date field. Student Age must be between 0 and 22. If Grade Level is AD, student age must be between 15 and 80.

10.12

Student Gender Code

Y

reg

gender

Registration > Entry & Reports > Student Demographic > Registration—Gender field

10.13

Local Course ID

Y

schd_ms

course

Scheduling > Courses > Course Sections > Master Schedule—Course field.

10.14

Course Section ID

Y

schd_ms

section_key

Not seen from the eSchoolPlus software. This field is a unique identifier for the course behind the scenes throughout the software.

10.15

Academic Term Code

Y

ca_v_ms_user
(schd_ms_user)

course_term/crs_seq_term
page number= 200 field_number=8/9

Scheduling > Courses > Course Sections > CA Course—Course Term and Course Sequence Term fields.

10.16

Student Credits Attempted

If End of Year Submission then Y

mr_stu_hdr

Count(att_credit)

Mark Reporting > Entry & Reports > Student > Report Card Summary—Attempted Credit field.

10.17

Student Credits Earned

If End of Year Submission then Y

mr_stu_hdr

Count(earn_credit)

Mark Reporting > Entry & Reports > Student > Report Card Summary—Earned Credit field.

10.18

Student Course Final Grade

If End of Year Submission then Y

mr_stu_marks

mark_value

Mark Reporting > Entry & Reports > Student > Report Card Summary—Mark field.

To determine final Mark Type, use the Mark Type(s) field on the Create CALPADS Extract/State Files page.

10.19

UC/CSU Admission Requirement Code

N

ca_v_ms_user
(schd_ms_user)

uccsu_app_crs
page number= 200 field_number=14

Scheduling > Courses > Course Sections > Master Schedule—UC/CSU Approved Course field.

10.20

Marking Period Code

If End of Year Submission then Y

reg_mp_weeks

state_code_equiv

Administration > Registration Setup > Calendars > Marking Periods – State Code Equivalent field.