Dual Enrollment Application: Data Elements
Doc Version 1
See OpenCCC Account Data Elements which are not included on this page.
Data Element Names
- 1 Term Description
- 2 Term Code
- 3 Term End Date
- 4 Term Start Date
- 5 High School Expected Graduation Date
- 6 Educational Goal
- 7 High School Attendance (School Type)
- 8 Enrollment Status
- 9 High School Education Level
- 10 Last School Attended: Country
- 11 Last School Attended: State
- 12 Last School Attended: Name
- 13 Last School Attended: City
- 14 School Not Listed
- 15 Last School Attended: CDS Code
- 16 Last School Attended: Full CDS Code
- 17 Last School Attended: CEEB Code
- 18 Highest Grade Completed
- 19 Grade Point Average
- 20 Highest English Course Completed
- 21 Highest English Course Completed Grade
- 22 Highest Math Course Taken
- 23 Highest Math Course Taken Grade
- 24 Highest Math Course Passed
- 25 Highest Math Course Passed Grade
- 26 Dependent of Parent/Guardian
- 27 Parent/Guardian First Name
- 28 Parent/Guardian Last Name
- 29 Parent/Guardian Relationship
- 30 Gender
- 31 Transgender
- 32 Sexual Orientation
- 33 Hispanic/Latino
- 34 Race Group
- 35 Race & Ethnicity Full
- 36 Race/Ethnicity
- 37 No Mailing Address Homeless
- 38 Mailing Address: Country
- 39 Mailing Address: Street 1 & 2
- 40 Mailing Address: City
- 41 Mailing Address: State/Province
- 42 Mailing Address: Non-USA Province
- 43 Mailing Address: Postal Code
- 44 Mailing Address: Same as Permanent
- 45 Mailing Address outside U.S.
- 46 Mailing Address Validation Override
- 47 Consent Indicator
- 48 E-Signature Confirmation
- 49 Financial Aid Acknowledgement
- 50 Application ID
- 51 Application Confirmation Number
- 52 Application Language Flag
- 53 Application Type
- 54 CCGI Token
- 55 IP Address at Account Creation
- 56 IP Address at Application Creation
- 57 IP Address at Application Submission
- 58 SIS Receipt
- 59 Timestamp: Application Creation
- 60 Timestamp: Application Submission
- 61 Timestamp: Application Update
Table of Data Fields
- 1 term_description
- 2 termCode
- 3 termEnd
- 4 termStart
- 5 hsCompDate
- 6 eduGoal
- 7 hsAttendance
- 8 enrollStatus
- 9 hsEduLevel
- 10 hsCountry
- 11 hsState
- 12 hsName
- 13 hsCity
- 14 hsCds
- 15 hsCdsFull
- 16 hsCeeb
- 17 hsGradeCompleted
- 18 gradePointAverage
- 19 highestEnglishCourse
- 20 highestEnglishGrade
- 21 highestMathCourseTaken
- 22 highestMathTakenGrade
- 23 highestMathCoursePassed
- 24 highestMathPassedGrade
- 25 dependentStatus
- 26 pgFirstname
- 27 pgLastname
- 28 pgRel
- 29 gender
- 30 transgender
- 31 orientation
- 32 hispanic
- 33 raceGroup
- 34 raceEthnicFull
- 35 Table: Breakdown of Race & Ethnicity Full Names and Values
- 36 raceEthnic
- 37 noMailingAddressHomeless
- 38 country
- 39 streetaddress1, streetaddress2
- 40 city
- 41 state
- 42 nonusaprovince
- 43 postalcode
- 44 addressSame
- 45 nonUsAddress
- 46 mailingAddressValidationOverride
- 47 consentIndicator
- 48 eSignature
- 49 ackFinAid
- 50 confirmation
- 51 appLang
Dual Enrollment Workflow
The data elements below are listed in the order they appear in the Dual Enrollment Application workflow.
Term Description
Data Element: | term_description |
Apply API (Glue): | termDescription |
Description: | The description of the college’s term that is displayed to the student in the Choose a term drop down menu. |
Type/Format, Length: | varchar, 100 |
Values: | Text string |
Allows Null: | No |
Storage/Usage: | Never auto-populates. |
Conditions: | Always Each open term will display as a response option in the Choose a term drop down menu; else the term does not display to the end user. Term will display if the Note: Only terms that have an Term Open Date <term_open_date> that is on or after the current date will display in the Choose a term drop down menu. |
Field Error Check: |
|
Validation Check: | Required user response. |
Onscreen Label/Prompt Text: | “When would you like to start classes?” Choose a term [menu] |
Additional Text: | None |
Notes: | College configures term information in the CCCApply Administrator. One or more Terms must be |
Revision Log | March 2025 |
Term Code
Data Element: | term_code |
Apply API (Glue): | termCode |
Description: | The unique identifier code for a term configured by the college in the CCCApply Administrator. |
Type/Format, Length: | varchar, 15 |
Values: | Text string |
Storage/Usage: | Typically used by the college as the primary identifier for the term applied for. |
Allows Null: | No |
Default: | None |
Notes: | Colleges configure their terms in the CCCApply Administrator. Important: Term code should not be edited or deleted once it is made available to students. |
Revision Log | March 2025 |
Term End Date
Data Element: | term_end |
Apply API (Glue): | termEnd |
Description: | The last day of the Term, determined by the college and configured in the CCCApply Administrator. |
Type/Format, Length: | date, 10 |
Values: | Date input by (or provided by) the college. |
Allows Null: | No |
Default: | None |
Storage/Usage: | Stored in the Terms table in CAP. |
Notes: | Colleges configure their terms in the CCCApply Administrator |
Revision Log | March 2025 |
Term Start Date
Data Element: | term_start |
Apply API (Glue): | termStart |
Description: | The first day of the Term as determined and configured by the college in the CCCApply Administrator. |
Type/Format, Length: | date, 10 |
Values: | Date input by (or provided by) the college |
Allows Null: | No |
Default: | None |
Storage/Usage: | Required field. |
Notes: | Colleges configure their terms in the CCCApply Administrator. |
Revision Log | March 2025 |
High School Expected Graduation Date
Data Element: | hs_comp_date |
Apply API (Glue): | hsCompDate |
Description: | Applicant’s response to “Expected High School Completion Date” question in the Dual Enrollment workflow. |
Type/Format, Length: | date, 10 (data format is yyyy-mm-dd) |
Response Options/Values: | Month [menu] Year [menu] [checkbox] I don't know, because I'm not in high school or an adult school program right now |
Allows Null: | Yes |
Default: | The ‘day’ portion of date value will default to first day of the month/year entered (yyyy-mm-01) |
Storage/Usage: | The format of the data stored is yyyy-mm-dd. |
Conditions: | Displays if applicant selects “I have not graduated from high school” from High School page. |
Error Validation Checks: | Required response if “I don't know, because I'm not in high school or an adult school program right now” is empty. |
Onscreen Label/Prompt Text: | When do you expect to graduate? Month [menu] Year [menu] |
Notes: |
|
Revision Log | March 2025 |
Educational Goal
Data Element: | edu_goal |
Apply API (Glue): | eduGoal |
Description: | Applicant’s response to Educational Goal. |
Type/Format, Length: | Text, 1 |
Response Options/Values: | J = Educational development |
Allows Null: | No |
Default: | Default value is auto-stored in the backend (J = Educational development) |
Storage/Usage: | Stored value is the 1-character code indicating the default Ed Goal. |
Error Validation Check: | None |
Onscreen Label/Prompt Text: | N/A |
Conditions: | Question does not display in the application. |
Notes | In the Dual Enrollment student workflow only, a default value (J - Educational development) is auto-stored and passed to college with the submitted application data. Correlates to MIS SS01 |
Revision Log: | March 2025 |
High School Attendance (School Type)
Data Element: | hs_attendance |
Apply API (Glue): | hsAttendance |
Description: | Indicates the applicant’s response to “School Type” question in the Dual Enrollment workflow. |
Type/Format, Length: | smallint, 1 |
Response Options/Values: | 1 = I go to high school 2 = I am homeschooled with a registered homeschool program 3 = I am being independently homeschooled 4 = I have not gone to high school, adult school, or been homeschooled 5 = I go to an adult school |
Allows Null: | No |
Default: | None |
Storage/Usage: |
|
Conditions: | Always |
Error Validation Checks: | Required selection. If applicant’s age is 21 yro or younger at term start date, then the following response options/values display only: 1 = I go to high school If applicant’s age is 22 yrs or older at term start date, then the following response options/values display only: 4 = I have not gone to high school, adult school, or been homeschooled Regardless of age, if the applicant selects “I have not gone to high school, adult school, or been homeschooled” then the Standard Application Re-direct screen displays and the applicant must select “Proceed” to continue to the Standard Application for Admission, or “Cancel” to return to the School Type question to select another option. |
Onscreen Label/Prompt Text: | “What type of school are you currently attending?” [menu] |
Notes: | The Standard Application Re-Direct screen in the Dual Enrollment workflow includes the following onscreen text: “Looks like you need to fill out the standard application based on your answers. Click 'Proceed' to go there now!” |
Revision Log: | March 2025 |
Enrollment Status
Data Element: | enroll_status |
Apply API (Glue): | enrollStatus |
Description: | Indicates the applicant’s college enrollment status in the Dual Enrollment workflow. |
Type/Format, Length: | Text, 1 |
Response Options/Values: | Y = Enrolling as Special K12 Admit Z = Enrolling as Special Adult Admit |
Allows Null: | No |
Default: | If applicant is 22 yro or older, a value of “Z” is automatically stored. |
Storage/Usage: | Auto-store value based on School Type response or applicant’s age. |
Conditions: | Does not display to the applicant in the Dual Enrollment application workflow. |
Input Rules: | Auto-stored value. IF user’s response to School Type <hs_attendance> at term start date is one of the following: 1 = I go to high school Then, store value “Y” = Enrolling as Special K12 Admit for <enroll_status> Else, If user’s response to School Type <hs_attendance> is 5 = I go to an adult school Then store value “Z” = Enrolling as Special Adult Admit” <enroll_status> |
Onscreen Label/Prompt Text: | N/A |
Notes: | Correlates to MIS SB15. Per California law, students age 22 years or older are prohibited from enrolling in or attending high school or lower grade in California (SB11). |
Revision Log | March 2025 |
High School Education Level
Data Element: | hs_edu_level |
Apply API (Glue): | hsEduLevel |
Description: | Indicates the applicant’s High School Education level in the Dual Enrollment workflow. |
Type/Format, Length: | Text, 1 |
Response Options/Values: | 1 = Will be enrolled as a Special K12 Admit. Z = Will be enrolled as a Special Adult Admit. |
Allows Null: | No |
Default: | If applicant is 22 yro or older, a default value of “Z” is automatically stored for <hs_edu_level>. |
Storage/Usage: | Auto-stored value based on School Type response or applicant’s age. |
Conditions: | Does not display to the applicant in the Dual Enrollment workflow. |
Input Rules: | Auto-stored value. IF user’s response to School Type <hs_attendance> at term start date is one of the following: 1 = I go to high school Then, auto-store value “1” = (Special K12 Admit) ” for <hs_edu_level>. Else, if user’s response to School Type is: 5 = I go to an adult school” Then store value “Z” = (Special Adult Admit) for <hs_edu_level>.” |
Onscreen Label/Prompt Text: | N/A |
Notes: | Correlates to MIS SB11 and SB15 Per California law, students age 22 years or older are prohibited from enrolling in or attending high school or lower grade in California (SB11). |
Revision Log | March 2025 |
Last School Attended: Country
Data Element: | hs_country |
Apply API (Glue): | hsCountry |
Description: | Indicates the applicant’s response to the “Current or Most Recent High-School Attended: Country” field. |
Type/Format, Length: | Text, 2 |
Response Options/Values: | Menu of countries per ISO. |
Allows Null: | No |
Default: | Default menu display = United States |
Storage/Usage: |
|
Conditions: | Always displays in the Dual Enrollment workflow |
Error Validation: | Required field |
Onscreen Label/Prompt Text: | Country [menu] |
Notes: |
|
Revision Log | March 2025 |
Last School Attended: State
Data Element: | hs_state |
Apply API (Glue): | hsState |
Description: | Indicates the applicant’s response to “Current or Most Recent High-School Attended: State” in the Dual Enrollment workflow. |
Type/Format, Length: | Text, 2 |
Values/Response Options: | Menu of US states and Non-US provinces, territories, etc. |
Allows Null: | Yes if Country is not US. |
Default: | None |
Storage/Usage: | Stores the 2-digit U.S. state code. |
Conditions: | Always displays. |
Error Validation | Required response. |
Onscreen Label/Prompt Text: | State [menu] |
Notes: | Default menu selection is California if US is selected. |
Revision Log | March 2025 |
Last School Attended: Name
Data Element: | hs_name |
Apply API (Glue): | hsName |
Description: | Indicates applicant’s selection for “Current or Most Recent High-School Attended: School Name” in the Dual Enrollment workflow. |
Type/Format, Length: | Text, 30 |
Response Options/Values: | Name of the US school selected from School Finder or the manual entry of school entered by applicant. |
Allows Null: | No |
Default: | None |
Storage/Usage: | Value always stores. |
Conditions: | Only displays in the Dual Enrollment workflow if the applicant selects the “I don’t see my school” link below the School Finder OR if <hs_country> is NOT the United States. |
Input Values: | School Name <hs_name> is populated with the name of the US school selected from School Finder, OR from manual entry if the user clicks “I don’t see my school” link below the School Finder, OR from manual entry if the Country is NOT United States. |
Error Validation | Required response, else error message: “This is required.” |
Onscreen Label/Prompt Text: | School Name |
Notes: | School Name <hs_name> is populated with the name of the US school selected from School Finder, OR from manual entry if the user clicks “I don’t see my school” link below the School Finder, OR from manual entry if the Country is NOT United States. |
Revision Log | March 2025 |
Last School Attended: City
Data Element: | hs_city |
Apply API (Glue): | hsCity |
Description: | Applicant’s response to “Current or Most Recent High-School Attended: City” in the Dual Enrollment workflow. |
Type/Format, Length: | varchar, 20 |
Response Options/Values: | City of the school selected from School Finder or the manual entry of the “City” <hs_city> entered by applicant. |
Allows Null: | No |
Default: | None |
Storage/Usage: | Value always stores. |
Conditions: | Only displays in the Dual Enrollment workflow if Country is not United States OR if the user clicks the “I don’t see my school” link; else does not display. |
Error Validation: | Required response, else error message: “This is required.” |
Onscreen Label/Prompt Text: | City |
Notes: |
|
Revision Log | March 2025 |
School Not Listed
Data Element: | hs_not_listed |
Apply API (Glue): | hsNotListed |
Description: | Indicates the applicant clicked on the “I don’t see my school” link under the School Finder. |
Type/Format, Length: | string |
Values/Response Options: | True = The “I don’t see my school” link was clicked False = The “I don’t see my school” link was not clicked. |
Allows Null: | Yes |
Default: | None |
Storage/Usage: | When this is true, it means the School Name and City have been entered manually. |
Conditions: | Always displays in the Dual Enrollment workflow when the School Finder is displayed (and Country is United States). |
Error Validation: | None |
Onscreen Label/Prompt Text: | “I don’t see my school” [link below School Finder] |
Notes: |
|
Revision Log | March 2025 |
Last School Attended: CDS Code
Data Element: | hs_cds |