Skip to: Content | Footer

California Postsecondary Education Data Home Page

Data Table Descriptions

Institution Supporting Tables
su_t_Calendar_System
Column Data Type Storage Length NULL Allowed Description
Calendar_Code Character (ASCII) 1 1 No Code identifying the calendar system of a school.
Calendar_Description Character (ASCII) 30 30 No The calendar system of a school.
su_t_Carnegie1994Codes
Column Data Type Storage Length NULL Allowed Description
Carnegie1994Code Character (Unicode) 2 4 Yes Code created in 1994 by the Carnegie Foundation to classify degree-granting, accredited higher education institutions.
Carnegie1994Name Character (Unicode) 100 200 Yes The title of the classification created in 1994 by the Carnegie Foundation for degree-granting, accredited higher education institutions.
Carnegie1994Description Memo (Unicode)   16 Yes The full description of the classification created in 1994 by the Carnegie Foundation for degree-granting, accredited higher education institutions.
su_t_Carnegie2000Codes
Column Data Type Storage Length NULL Allowed Description
Carnegie2000Code Character (ASCII) 2 2 Yes Code created by the Carnegie Foundation in 2000 to classify degree-granting, accredited higher education institutions.
Carnegie2000Name Character (ASCII) 100 100 Yes The title of the classification created in 2000 by the Carnegie Foundation for degree-granting, accredited higher education institutions.
Carnegie2000Description Character (ASCII) 500 500 Yes The full description of the classification created in 2000 by the Carnegie Foundation for degree-granting, accredited higher education institutions.
Carnegie2000Category Character (ASCII) 100 100 Yes The grouping of like classifications created in 2000 by the Carnegie Foundation for degree-granting, accredited higher education institutions.
Sort_Order Integer 10 4 Yes Sort order for the data.
su_t_CDS_File
Column Data Type Storage Length NULL Allowed Description
CDS_Code Character (ASCII) 14 14 No Code identifying schools that includes the county code, district code, and school code.
School_Name Character (Unicode) 100 200 Yes The name of the school.
Physical_Address_Line1 Character (ASCII) 60 60 Yes Part of the physical address.
Physical_Address_Line2 Character (ASCII) 50 50 Yes Part of the physical address.
Physical_City Character (ASCII) 50 50 Yes Part of the physical address.
Physical_Zip_Code Character (ASCII) 5 5 Yes Part of the physical address.
Physical_Zip_Extension Character (ASCII) 4 4 Yes Part of the physical address.
Mailing_Address_Line Character (ASCII) 60 60 Yes Part of the mailing address.
Mailing_City Character (ASCII) 50 50 Yes Part of the mailing address.
Mailing_Zip_Code Character (ASCII) 5 5 Yes Part of the mailing address.
Mailing_Zip_Extension Character (ASCII) 4 4 Yes Part of the mailing address.
District_Ownership Character (ASCII) 2 2 Yes Code identifying the ownership of a district
School_Ownership Character (ASCII) 2 2 Yes Code identifying the ownership of a school.
Status_Code Character (ASCII) 1 1 Yes Code identifying the open/closed status of a school.
Area_Type_Code Character (ASCII) 1 1 Yes Code identifying the area type; that is, whether the school is located in an urban, suburban, or rural setting.
County_Code Character (ASCII) 2 2 Yes Code identifying the California county.
District_Code Character (ASCII) 5 5 Yes The 5-digit district code portion of the CDS (County-District-School) Code.
XRef_Number Character (ASCII) 6 6 Yes Code identifying a school assigned by the Commission as a cross-reference to the school code; maps to High_School_Code and Source_Institution for queries.
CC_District_Code Character (ASCII) 5 5 Yes Code used to identify the California Community College District.
Assembly_Dist Character (ASCII) 2 2 Yes The California State Assembly district number.
Congress_Dist Character (ASCII) 2 2 Yes The U.S. House of Representatives district number.
Senate_Dist Character (ASCII) 2 2 Yes The California State Senate district number.
Latitude Numeric 7 5 Yes The latitude of the centroid of a location or area.
Longitude Numeric 7 5 Yes The longitude of the centroid of a location or area.
Charter Character (ASCII) 1 1 Yes Flag to indicate whether the school is a charter.
Last_CPEC_Updated_Date Date/Time 16 4 Yes The date of the last update of the record by Commission staff.
su_t_District_Ownership
Column Data Type Storage Length NULL Allowed Description
District_Ownership_Code Character (ASCII) 2 2 No Code identifying the ownership of a district
District_Ownership_Title Character (ASCII) 75 75 Yes The ownership of a district
CDE_Name Character (ASCII) 25 25 Yes The name used by the California Department of Education for district/school ownership.
su_t_Institution_XWalk
Column Data Type Storage Length NULL Allowed Description
Record_ID Integer 10 4 No Key field for the cross-walk table to provide a unique value. Not for use as a school code.
CDS_Code Character (ASCII) 14 14 Yes Code identifying schools that includes the county code, district code, and school code.
School_Code Character (ASCII) 6 6 Yes The 6-digit school code portion of the CDS (County-District-School) Code.
Institution_Code Character (ASCII) 6 6 Yes Code identifying a postsecondary institution assigned by the Commission.
System_Code Character (ASCII) 2 2 Yes Code identifying the system of an institution.
Federal_Unit_ID Character (ASCII) 6 6 Yes Code used in the Postsecondary Education Participants System (PEPS) by the Office of Postsecondary Education (OPE) of the U.S. Department of Education to identify a school.
IPEDS_Sector Character (ASCII) 1 1 Yes Code identifying the Integrated Postsecondary Education Data System (IPEDS) sector of a school.
FICE_Code Character (ASCII) 6 6 Yes Code created by the Federal Interagency Committee on Education (FICE) to identify a school.
ATP_Code Character (ASCII) 6 6 Yes Code used by the American Testing Program (ATP) and the College Entrance Examination Board (CEEB) to identify a school.
COSAR_Code Character (ASCII) 6 6 Yes Code used by the California State University Chancellor's Office to identify a school. (COSAR Code = Chancellor's Office Systemwide Administrative Reporting Code)
UC_Campus_Code Character (ASCII) 2 2 Yes Code used by the University of California to identify a school.
CCC_College_ID Character (ASCII) 3 3 Yes Code used by the California Community Colleges to identify a school.
OPEID Character (ASCII) 8 8 Yes Code used by the Office of Postsecondary Education (OPE) at the U.S. Department of Education to identify a school.
DunnBrad_ID Character (ASCII) 9 9 Yes Code assigned by the Dunn & Bradstreet Information Corporation.
Carnegie_ID Character (ASCII) 2 2 Yes Code created by the Carnegie Foundation to classify degree-granting, accredited higher education institutions.
WASC_Code Character (ASCII) 10 10 Yes Code used by the Western Association of Schools and Colleges (WASC) to identify a school.
RateProf_ID Character (ASCII) 5 5 Yes Code used by Rate my Professors to identify a school.
Last_Update Date/Time 16 4 Yes The date of the last update of the record.
su_t_IPEDS_Sector
Column Data Type Storage Length NULL Allowed Description
IPEDS_Sector_In Character (Unicode) 2 4 Yes Code identifying the Integrated Postsecondary Education Data System (IPEDS) sector of a school as reported in IPEDS data.
IPEDS_Sector Character (Unicode) 1 2 Yes Code identifying the Integrated Postsecondary Education Data System (IPEDS) sector of a school.
IPEDS_Sector_Desc Character (Unicode) 50 100 Yes The Integrated Postsecondary Education Data System (IPEDS) sector of a school.
su_t_Profit_Status
Column Data Type Storage Length NULL Allowed Description
Profit_Code Character (ASCII) 1 1 No Code identifying the profit/not-for-profit status of a school.
Profit_Description Character (ASCII) 15 15 No The profit/not-for-profit status of a school.
su_t_Religions
Column Data Type Storage Length NULL Allowed Description
Religion_Code Character (ASCII) 2 2 No Code identifying the religious affiliation of a school.
Religion Character (ASCII) 50 50 Yes The religious affiliation of a school.
su_t_School_Ownership
Column Data Type Storage Length NULL Allowed Description
Ownership_Code Character (ASCII) 2 2 No Code identifying the ownership of a school.
Ownership_Title Character (ASCII) 75 75 No The ownership of a school.
CDE_Name Character (ASCII) 15 15 Yes The name used by the California Department of Education for district/school ownership.
School_Type Character (ASCII) 1 1 Yes Code identifying the type of school.
Comprehensive_HS Bit 1 1 No Flag to indicate whether a school is a comprehensive high school.
CDS_Sort Character (ASCII) 1 1 Yes Sort order for use in the School Code Cross-Walk system on the website.
su_t_School_Status
Column Data Type Storage Length NULL Allowed Description
Status_Code Character (ASCII) 1 1 Yes Code identifying the open/closed status of a school.
Status_Short_Desc Character (ASCII) 15 15 Yes The open/closed status of a school.
Status_Long_Desc Character (ASCII) 50 50 Yes The detailed description of the open/closed status of a school.
su_t_School_Type
Column Data Type Storage Length NULL Allowed Description
School_Type Character (ASCII) 1 1 No Code identifying the type of school.
School_Type_Desc Character (ASCII) 50 50 No The type of school.
su_t_Systems
Column Data Type Storage Length NULL Allowed Description
System_code Character (Unicode) 2 4 No Code identifying the system of an institution.
System_Title Character (Unicode) 60 120 Yes The system of an institution.
Sort_Order Integer 10 4 Yes Sort order for the data.
CPEC_url Character (Unicode) 400 800 Yes The URL to the page on the Commission's website with information about the systems.

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.