What's New
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. |
Back To Data Element Dictionary Menu