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