Skip to content

End of Term Course Enrollment Input File Specifications (Fall, Winter, Spring)

Back to Main Course Enrollment Page

End of Term Course Enrollment Input File Specifications (Fall, Winter, Spring) Overview

The end of term course file contains data on all students who took courses at the term specified.

Schedule

Campuses should submit this file for the Fall Quarter (Fall Semester) by the end of the eighth week after the end of the term and, for the Winter and Spring Quarters (Spring Semester), by the end of the sixth week.

File Physical Characteristics

File Name: CEDEOT.Qqyy (in uppercase) where:

  • q = 2 (Fall)
  • q = 3 (Winter)
  • q = 4 (Spring)
  • yy = the effective year

Record Format: Pipe delimited text file

Transmission: The input file is transmitted via UC PCSSC Production Go Anywhere VSFTP process. Please contact your campus Managed File Transfer (MFT) single point of contact for campus file transfer matters.

For more information on Production Control Shared Services (PCSSC) and the new vsftp transmittal process, visit: https://pcssc.berkeley.edu/

Fall, Winter, Spring EOT Course Enrollment Input File Layout 

Ref. No Element Name Length Format Error Level Valid Values
HEADER RECORD (OPTIONAL)
0010 Record Type Code 1 CHAR S 'A'
0020 Header Campus Code 2 CHAR S '01' | '02' | '03' | '04' | '05' | '06' | '07' | '08' | '09' | '10'
0030 Header Date 8 CHAR S File Creation Date - Format YYYYMMDD, YYYY = Calendar Year
DATA RECORD
0010 Record Type Code 1 CHAR S 'M'
A010 Campus Registered Code 2 CHAR S '01' | '02' | '03' | '04' | '05' | '06' | '07' | '08' | '09' | '10'
A020 Identification Number - Student 10 CHAR S Non-Blank | Not the Same as Social Security Number | No Special Characters
M001 Calendar Year Registered 4 CHAR S YYYY - Must be the year currently being processed.
C010 Term Registered Code 1 CHAR S '2' | '3' | '4' ('2' = Fall, '3' = Winter, '4' = Spring)

M002

Last Name-Student 35 CHAR E First character is not blank (unless student has one name), and may contain only capital characters A-Z, blank, hyphen, period, and/or apostrophe. Students with only one name defaults to Last Name field.

M003

First Name-Student, Middle Initial-Student 30 CHAR E First character is not blank, and may contain only capital characters A-Z, blank, hyphen, period, and/or apostrophe. Students with only one name defaults to Last Name field.
M004 Department Code 10 CHAR E Non-blank
M005 Department Name 30 CHAR E Non-blank
M006 Subject Code 6 CHAR E

Non-blank

M007 Subject Name 30 CHAR E Non-blank
M008 Course Identification Code 20 CHAR E Non-blank, flush left
M009 Course Number 20 CHAR E Non-blank, flush left
M010 Course Title 35 CHAR E Non-blank
M011 Section Identification Code 6 CHAR E Non-blank
M012 Course Level Code 2 CHAR E 'LD', 'UD', 'GR'
M013 Unit Type 1 CHAR E 'Q' = Quarter, 'S' = Semester
M015 Course Enrollment Status 1 CHAR E 'E', 'L', 'C', 'A'
M017 Units Attempted-Current Term EOT 3 NUM E 99v9
M018 Units Passed-Current Term-Graded-EOT 3 NUM E 99v9
M019 Units Passed-Current Term-P/NP-EOT 3 NUM E 99v9
M020 Grade Points-Current Term-EOT 4 NUM E 999v9
Back to Main Course Enrollment Page