What's New
Data Table Descriptions
| Supporting Tables | |||||
| su_t_Age_Groups | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | Age_Category | Character (ASCII) | 1 | 1 | No | Code identifying the age category of a student. | Age_Category_Title | Character (ASCII) | 15 | 15 | No | The age category of a student. It is a range of years spanning as few as 2 years or an open-ended range such as 65 and over. | Minimum_Age | Integer | 5 | 2 | Yes | The minimum age of an age group. | Maximum_Age | Integer | 5 | 2 | Yes | The maximum age of an age group. |
| su_t_Area_Types | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | Area_Type_Code | Character (Unicode) | 1 | 2 | No | Code identifying the area type; that is, whether the school is located in an urban, suburban, or rural setting. | Area_Type_Desc | Character (Unicode) | 8 | 16 | No | The area type of a school; that is, whether the school is located in an urban, suburban, or rural setting. |
| 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_CIPFile | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | Discipline_Code | Character (ASCII) | 6 | 6 | Yes | Code identifying the detailed Classification of Instructional Program (CIP). The same as the CIP Code without the period. | Discipline_Title | Character (ASCII) | 120 | 120 | Yes | The detailed Classification of Instructional Program (CIP). | Digit2_Discipline | Character (ASCII) | 2 | 2 | Yes | The 2-digit Classification of Instructional Program (CIP) code used to identify the general description of a discipline. | Digit4_Discipline | Character (ASCII) | 4 | 4 | Yes | The 4-digit Classification of Instructional Program (CIP) code used to identify the focused general description of a discipline. | New_Flag | Bit | 1 | 1 | No | Flag to indicate whether the Classification of Instructional Program (CIP) Code is a new value in the last update. | Deleted_Flag | Bit | 1 | 1 | No | Flag to indicate that the Classification of Instructional Program (CIP) is no longer being used. | STEM | Character (ASCII) | 2 | 2 | Yes | Code identifying the science, technology, engineering, or math (STEM) category of a program. | CTE_Flag | Bit | 1 | 1 | Yes | Flag to indicate whether the program classifies as career technical education (CTE). |
| su_t_Crime_Categories | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | CrimeCat_Code | Character (ASCII) | 2 | 2 | Yes | Code identifying the category of a crime. | CrimeCat_Desc | Character (ASCII) | 25 | 25 | Yes | The category of a crime. | Sort_Order | Character (ASCII) | 1 | 1 | Yes | Sort order for the data. |
| su_t_CrimeStats_Locations | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | Location_Code | Character (ASCII) | 3 | 3 | Yes | Code identifying the location where a crime was committed. | Location_Type | Character (ASCII) | 50 | 50 | Yes | The location where a crime was committed. | Sort_Order | Character (ASCII) | 1 | 1 | Yes | Sort order for the data. |
| su_t_Degree_Types | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | Degree_Type | Character (ASCII) | 2 | 2 | Yes | Code identifying the type of degree. | Degree_Title | Character (ASCII) | 50 | 50 | Yes | The title of a degree type. | First_Professional_Flag | Bit | 1 | 1 | Yes | Flag to indicate whether the degree type is considered first professional. | 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. | Sorted_Degree | Character (ASCII) | 1 | 1 | Yes | Sort order for degree types. | IPEDS_Degree_Type | Character (ASCII) | 2 | 2 | Yes | Code used by the Integrated Postsecondary Education Data System (IPEDS) to identify a degree type. | Profiles_Sort | Character (ASCII) | 1 | 1 | Yes | Sort order for degree types for use in the educational and demographic profiles. | Profiles_Title | Character (ASCII) | 50 | 50 | Yes | The title of a degree type without special characters for use in the educational and demographic profiles.. | Degree_Comment | Memo (ASCII) | 16 | Yes | A comment field used by Commission staff to document changes to degree types over the years. |
| su_t_Disability_Codes | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | Disability_Code | Character (ASCII) | 1 | 1 | Yes | Code identifying the type disability a student has. | Disability_Group | Character (ASCII) | 1 | 1 | Yes | Code identifying the grouping of a disability. (e.g. Physical Disability) | Disability_Sequence | Character (ASCII) | 2 | 2 | Yes | Sort order to keep disability groups together. | Disability_Title | Character (ASCII) | 50 | 50 | Yes | The type disability a student has. | CSU_Disability_Code | Character (ASCII) | 1 | 1 | Yes | Code used by the California State University system to identify a disability. | CSU_Disability_Title | Character (ASCII) | 50 | 50 | Yes | The title of the disability used by the California State University system. |
| su_t_Disability_Groups | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | Disability_Group | Character (ASCII) | 1 | 1 | No | Code identifying the grouping of a disability. (e.g. Physical Disability) | Disability_Group_Description | Character (ASCII) | 50 | 50 | Yes | The grouping of a disability. (e.g. Physical Disability) |
| 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_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_Ethnicity | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | Ethnicode | Character (ASCII) | 2 | 2 | No | Code identifying the ethnicity of a student. | EthnicTitle | Character (ASCII) | 30 | 30 | No | The ethnicity of a student. | Combined_Ethnic | Character (ASCII) | 1 | 1 | Yes | Code identifying the collapsed ethnicity of a student. | UC_Ethnicode | Character (ASCII) | 1 | 1 | Yes | Code used by the University of California system to identify an ethnicity. | CSU_Ethnicode | Character (ASCII) | 1 | 1 | Yes | Code used by the California State University system to identify an ethnicity. | CCC_Ethnicode | Character (ASCII) | 2 | 2 | Yes | Code used by the California Community College system to identify an ethnicity. | IPEDS_Ethnicode | Character (ASCII) | 1 | 1 | Yes | Code used by the Integrated Postsecondary Education Data System (IPEDS) to identify an ethnicity. | Eligibility_Ethnicode | Character (ASCII) | 1 | 1 | Yes | Code used in the eligibility study to identify an ethnicity. | CSIS51_Ethnicode | Character (ASCII) | 3 | 3 | Yes | Code used by California School Information Services (CSIS) to identify an ethnicity. | Combined_Ethnictitle | Character (ASCII) | 12 | 12 | Yes | The abbreviated version of the collapsed ethnicity title (e.g. Combines Japanese, Chinese, etc. to Asian/Pac Is) | Combined_Title | Character (ASCII) | 25 | 25 | Yes | The collapsed ethnicity title (e.g. Combines Japanese, Chinese, etc. to Asian/Pacific Islander) | CBEDS_Ethnicode | Character (ASCII) | 1 | 1 | Yes | Code used by the California Basic Educational Data System (CBEDS) to identify ethnicity. | CDE_Alpha | Character (ASCII) | 1 | 1 | Yes | Code used by the California Department of Education to identify an ethnicity. | SAT_ACT_Ethnicode | Character (ASCII) | 2 | 2 | Yes | Code used by the College Board and ACT to identify an ethnicity. | SAT_ACT_Ethnictitle | Character (ASCII) | 18 | 18 | Yes | The title of the ethnicity used by the College Board and ACT. |
| su_t_Gender | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | GenderCode | Character (ASCII) | 1 | 1 | No | Code identifying the gender of the student. | GenderTitle | Character (ASCII) | 7 | 7 | No | The gender of the student. | CCC_Gender | Character (ASCII) | 1 | 1 | Yes | Code used by the California Community College system to identify a gender. | UC_Gender | Character (ASCII) | 1 | 1 | Yes | Code used by the University of California system to identify a gender. | CSU_Gender | Character (ASCII) | 1 | 1 | Yes | Code used by the California State University system to identify a gender. | CSIS51_Gender | Character (ASCII) | 1 | 1 | Yes | Code used by California School Information Services (CSIS) to identify a gender. |
| 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_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_Regions | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | Region_code | Character (ASCII) | 1 | 1 | Yes | Code identifying the Commission-defined region. | Region_name | Character (Unicode) | 24 | 48 | Yes | The Commission-defined region. | County_Code | Character (ASCII) | 2 | 2 | No | Code identifying the California county. | County_Name | Character (ASCII) | 50 | 50 | Yes | The California county. | FIPS_Code | Character (ASCII) | 3 | 3 | Yes | Code created by Federal Information Processing Standards (FIPS) to identify a county. | Milepost | Character (ASCII) | 3 | 3 | Yes | Code used by the California Department of Transportation to identify a county. | 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. | Old_Region_Code | Character (ASCII) | 2 | 2 | Yes | Code identifying the Commission-defined region used prior to 2003. | Old_Region_Title | Character (ASCII) | 25 | 25 | Yes | The Commission-defined region used prior to 2003. | CDE_Region_Code | Character (ASCII) | 2 | 2 | Yes | Code used in California Department of Education data to identify a region. | CDE_Region_Name | Character (ASCII) | 20 | 20 | Yes | The name of the region used by the California Department of Education. | Center_Lat | Character (ASCII) | 10 | 10 | Yes | Latitude Centroid of the map area. | Center_Lng | Character (ASCII) | 10 | 10 | Yes | Longitude Centroid of the map area. | SW_Lat | Character (ASCII) | 10 | 10 | Yes | South West Latitude of the map area. Used to determine the zoom leve of the map. | SW_Lng | Character (ASCII) | 10 | 10 | Yes | South West Longitude of the map area. Used to determine the zoom leve of the map. | NE_Lat | Character (ASCII) | 10 | 10 | Yes | North East Latitude of the map area. Used to determine the zoom leve of the map. | NE_Lng | Character (ASCII) | 10 | 10 | Yes | North East Longitude of the map area. Used to determine the zoom leve of the map. | County_Color | Character (ASCII) | 8 | 8 | Yes | Defines the color attribute of the county when displayed on a google map. | num_Levels | Character (ASCII) | 2 | 2 | Yes | The number of GROUPS of zoom levels used by the encoded polyline (and polygon) level to specify the precision level. | Zoom_Factor | Character (ASCII) | 1 | 1 | Yes | Approximate magnification between different level groups. | Levels | Character (ASCII) | 100 | 100 | Yes | The precision of the encoded polyline (and polygon). | Points | Character (ASCII) | 1000 | 1000 | Yes | Encoded points defining a specified area of a map. |
| 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_State_Table | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | CPEC_State_Code | Character (ASCII) | 2 | 2 | No | Code identifying the state or territory. | IPEDS_State_Code | Integer | 10 | 4 | Yes | Code used by the Integrated Postsecondary Education Data System (IPEDS) to identify a state or territory. | Residence_Code | Bit | 1 | 1 | Yes | Flag to indicate whether the state or territory is valid as a state of residence; can be NULL. | PostOffice_Abbreviation | Character (ASCII) | 2 | 2 | Yes | The post office abbreviation of a state or territory. This field is also used as a map to get the state name in an address. | FIPS_State_Code | Character (ASCII) | 2 | 2 | Yes | Code created by Federal Information Processing Standards (FIPS) to identify a state. | CCC_State_Code | Character (ASCII) | 10 | 10 | Yes | Code used by the California Community College system to identify a state or territory. | CSU_State_Code | Character (ASCII) | 4 | 4 | Yes | Code used by the California State University system to identify a state or territory. | UC_State_Code | Character (ASCII) | 3 | 3 | Yes | Code used by the University of California system to identify a state or territory. | OOS_Code | Character (ASCII) | 6 | 6 | Yes | Code used by the California State University system and the University of California system identifying the out-of-state residence of a student. | CPEC_OOS_Code | Character (ASCII) | 6 | 6 | Yes | Code identifying the out-of-state residence of a student. This is a modified version of OOS_Code so that it is not accidentally mapped to a school code during data conversion. | State_Name | Character (ASCII) | 50 | 50 | Yes | The name of a state or territory. | OBE_Region | Character (ASCII) | 1 | 1 | Yes | Code identifying the geographic region defined by the U.S. Office of Business Economics. | OBEReg_Description | Character (ASCII) | 25 | 25 | Yes | The geographic region defined by the U.S. Office of Business Economics. | State_Color | Character (ASCII) | 8 | 8 | Yes | Defines the color attribute of the state when displayed on a google map. | State_Comments | Character (ASCII) | 255 | 255 | Yes | A comment field used by Commission staff to document changes to state table over the years. |
| su_t_STEM_Types | |||||
| Column | Data Type | Storage | Length | NULL Allowed | Description | STEM | Character (ASCII) | 2 | 2 | No | Code identifying the science, technology, engineering, or math (STEM) category of a program. | STEM_Description | Character (ASCII) | 50 | 50 | Yes | The science, technology, engineering, or math (STEM) category of a program. |
| 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_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. |
| 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.) |
Back To Data Element Dictionary Menu