Dual Enrollment Application: Data Elements

Dual Enrollment Application: Data Elements

Doc Version 1

See OpenCCC Account Data Elements which are not included on this page.

Data Element Names

 

 

Table of Data Fields

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

 

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
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

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
5 = I go to an adult school

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

Back to top

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.
Auto-stored value is passed to the college with the submitted application data.

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
2 = I am homeschooled with a registered homeschool program
3 = I am being independently homeschooled

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

Back to top

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.
Auto-stored value is passed to the college with the submitted application data.

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
2 = I am homeschooled with a registered homeschool program
3 = I am being independently homeschooled

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

Back to top

 

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

Back to top

 

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

Back to top

 

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.
Store value populated from the name of the school selected from School Finder OR from a manual entry in the <hs_name> field.

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
Textbox [ Please enter the name of the school ]

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

Back to top

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.
Store value populated from the City of the school selected from School Finder OR from a manual entry in the <hs_city> field.

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
[ Please enter the name of city ]

Notes:

 

Revision Log

March 2025

Back to top

 

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

Back to top

 

Last School Attended: CDS Code

Data Element:

hs_cds