Skip to: Content | Footer

California Postsecondary Education Data Home Page

Data Table Descriptions

Enrollment Supporting Tables
su_t_Enrollment_Status
Column Data Type Storage Length NULL Allowed Description
Enroll_Status_Code Character (Unicode) 1 2 Yes The enrollment status of a student.
Enroll_Status_Description Character (Unicode) 40 80 Yes Code identifying the enrollment status of a student.
su_t_Program_Codes
Column Data Type Storage Length NULL Allowed Description
Program_Code Character (ASCII) 1 1 No Code identifying the type of program in which a student has enrolled. (e.g. Regular, Non-Credit, etc.)
Valid_for_UC Bit 1 1 Yes Flag to indicate whether the data value is valid for the University of California System.
Valid_for_CSU Bit 1 1 Yes Flag to indicate whether the data value is valid for the California State University System.
Valid_for_CCC Bit 1 1 Yes Flag to indicate whether the data value is valid for the Community College System.
Valid_for_OthPub Bit 1 1 Yes Flag to indicate whether the data value is valid for the other public colleges and universities.
Valid_for_Indep Bit 1 1 Yes Flag to indicate whether the data value is valid for the members of the Association of Independent California Colleges and Universities.
Valid_for_OutOfState Bit 1 1 Yes Flag to indicate whether the data value is valid for out-of-state institutions.
Program_Code_Description Character (ASCII) 20 20 Yes The type of program in which a student has enrolled. (e.g. Regular, Non-Credit, etc.)
Program_Code_Comment Memo (ASCII)   16 Yes A comment field used by Commission staff to document changes to program types over the years.
su_t_Student_Level
Column Data Type Storage Length NULL Allowed Description
Level_Code Character (Unicode) 2 4 No Code identifying the student level.
Level_Title Character (Unicode) 40 80 Yes The student level.
Short_Level_Title Character (Unicode) 20 40 Yes Shortened student level title for use in mobile applications and areas that have limited space.
Ungr_Gr_Selection Character (Unicode) 1 2 Yes Flag to indicate whether the level is graduate, undergraduate or other.
Valid_for_UC Bit 1 1 No Flag to indicate whether the data value is valid for the University of California System.
Valid_for_CSU Bit 1 1 No Flag to indicate whether the data value is valid for the California State University System.
Valid_for_CCC Bit 1 1 No Flag to indicate whether the data value is valid for the Community College System.
Valid_for_OthPub Bit 1 1 No Flag to indicate whether the data value is valid for the other public colleges and universities.
Valid_for_Indep Bit 1 1 No Flag to indicate whether the data value is valid for the members of the Association of Independent California Colleges and Universities.
Valid_for_OutOfState Bit 1 1 No Flag to indicate whether the data value is valid for out-of-state institutions.
U_L_Division Character (Unicode) 1 2 Yes Flag to indicate whether the student level is upper or lower division.
Rpt_Sort Character (Unicode) 2 4 Yes Sort order for the student level.
Level_Comment Memo (Unicode)   16 Yes A comment field used by Commission staff to document changes to student levels over the years.
su_t_Time_Status
Column Data Type Storage Length NULL Allowed Description
Time_Code Character (ASCII) 1 1 No Code identifying the time status of a student. (e.g. full-time, part-time, etc.)
Time_Title Character (ASCII) 9 9 No The time status of a student. (e.g. full-time, part-time, etc.)

Show All Supporting Tables

Back To Data Element Dictionary Menu

 

Looking for other Commission data?

Visit Where to Find Data for quick links sorted by the type of data.

Want to reproduce a pre-configured data report?

Visit Reproduce Pre-Configured Report for available instructions.

How to Cite this Information

See Citing Information on the Terms of Use page for some suggestions.

See something weird?

Known problems and notes about the data are documented on the Caveats page. Please let us know if you notice something that is not included. Send an e-mail to Data_Quality@cpec.ca.gov or fill out the Comments form.