Skip to content

Third Week Course Enrollment Input File Specifications (Fall, Winter, Spring)

Back to Main Course Enrollment Page

Third Week Course Enrollment Input File Specifications (Fall, Winter, Spring) Overview

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

Schedule

Campuses should submit this file each term by the end of the sixth week of classes.

File Physical Characteristics

File Name: CED3WK.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 3WK 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'
M016 Units Attempted-Current Term-3rd 3 NUM E 99v9
Back to Main Course Enrollment Page