2018-30: Display the "Colleges Attended" Section Conditionally Based on Enrollment Status

Data Element:

hs_edu_level

Description:

Applicant’s response to High School Education Level question

Format, Length:

bpchar, 1

Values:

3 = Received high school diploma from U.S. school
4 = Passed a high school equivalency test and received a certificate of high school equivalency
5 = Received a Certificate of California High School Proficiency
6 = Received a diploma/certificate of graduation from a Foreign secondary school
1 = Will be enrolled in high school (or lower grade) and college at the same time
2 = Currently enrolled in adult school
0 = Not a graduate of, and no longer enrolled in high school

Allows Null:

No

Default:

None

Usage:

Notes:

SB11, SB15

Xap Field:

highSchoolEdLevel

Revision Log:

~~

Question Text:

High School Education Level as of <RDD, or ‘July 1, RDDyear’ if RDDmonth is May or June> [menu]

Conditions:

Always

Additional Text: If a student is applying for a term that starts in May or June, then the College Enrollment Status and the High School Education labels have "as of 7/1/<RDD year>" listed.

Response Options:

3 = Received high school diploma from U.S. school
4 = Passed a high school equivalency test and received a certificate of high school equivalency
5 = Received a Certificate of California High School Proficiency
6 = Received a diploma/certificate of graduation from a Foreign secondary school
1 = Will be enrolled in high school (or lower grade) and college at the same time
2 = Currently enrolled in adult school
0 = Not a graduate of, and no longer enrolled in high school

Pop-Up Help:

Field Error Check:

None

Page Error Check:

Required selection; else error message, “You must select your High School Education Level.”

If (RDD minus <birthdate>) => 22 years, then do not display the option “1 = Will be enrolled in high school (or lower grade) and college at the same time”.

If High School Education Level is ‘Will be enrolled in high school (or lower grade) and college at the same time’, then College Enrollment Status must be ‘Enrolling in high school (or lower grade) and college at the same time’; else error message, “Your responses to the Enrollment Status and High School Education Level questions are contradictory. Please fix one or the other.”

If High School Education Level is “Enrolled in high school (or lower grades) and college at the same time”, then Higher Education Level cannot be “Received an associate degree” or “Received a bachelor’s degree or higher”; else error message, “Your responses to the High School Education Level and College Education Level questions are contradictory. Please fix one or the other.”

Notes:

Relates to SB11.

Note: If student is 22 years or older at <RDD> they are prohibited from enrolling in high school or lower grade in California. Steering Committee approved request to remove the response option, “Will be enrolled in high school (or lower grade) and college at the same time” from the drop down menu to minimize errors in classification.

education table

Data Element:

education: hs_edu_level

Data Element:

hs_comp_date

Description:

Applicant’s response to High School Completion Date question

Format, Length:

date, 10 (download format is yyyy-mm-dd)

Values:

Valid date

Allows Null:

Yes

Default:

None

Usage:

Notes:

education table

Xap Field:

highSchoolCompletionDate

Revision Log:

~~

Question Text:

High School Completion Date Month        Day        Year

[menu]        [menu]        [textbox] yyyy

Conditions:

Appears only if High School Education Level is one of the following: 3 = Received high school diploma from U.S. school

4 = Passed the GED, or received a High School Certificate of Equivalency 5 = Received a Certificate of California High School Proficiency

6 = Received a diploma/certificate of graduation from a Foreign secondary school

Additional Text:

“If unsure of the exact day, please estimate.”

Response Options:

Valid date

Pop-Up Help:

None

Field Error Check:

Date must be before "July 1, RDDYear” if RDDmonth is May or June; else error message "Your High School Completion Date cannot be after 06/30/<year of RDD>. Please correct the completion date and/or your High School Education Level.”

Year must be after 1900; else error message, “You must enter a 4-digit year after 1900.”

Day must be valid for month; else error message, “The day you selected is not valid for the month you selected.”

If mm/dd is February 29, year must be a leap year; else error message, “The day you selected is not valid for the year you entered.”

Page Error Check:

Required selection; else error message, “You must specify your High School Completion Date. If unsure of the exact day, please estimate.”

Date must be after Date of Birth; else error message, “Your High School Completion Date cannot be before your date of birth; please correct.”

Date must be on or before RDD; else error message, “Your High School Completion Date cannot be after <RDD >. Please correct the date and/or your High School Education Level.”

If term applied for starts in either May or June in the same year as the applicant’s

hs_comp_date, then the hs_comp_date must be before RDD or before July 1, ‘RDDYear'; else error message: "Your High School Completion Date cannot be after <RDD >. Please correct the completion date and/or your High School Education Level.”

Notes:

The HS Completion date can be after the <current date>, but should be before the Residency Determination Date <RDD>, which is the day before the Term start date <term:start_date>.

Each term has a unique <RDD>. The <RDD> is based on the term:start_date which is configured by the college in the Terms tab in the Administrator. The <RDD> appears in the question prompt text for all fields that are used in the Residency algorithm. High School students

Applying to a term that begins after they graduate (or equivalent) should be advised to read and understand the <RDD> carefully and answer questions according to that date and not the current date, which is a common oversight.

Data Element:

education: hs_comp_date

Data Element:

higher_edu_level

Description:

Applicant’s response to Higher Education Level question

Format, Length:

bpchar, 1

Values:

X = No degree

7 = Received an associate degree

8 = Received a bachelor’s degree or higher

Null = No response

Allows Null:

Yes

Default:

None

Usage:

Notes:

Xap Field:

higherEdLevel

Question Text:

College Education Level as of <RDD> [menu]

Conditions:

Displayed unless Enrollment Status is ‘Enrolling in high school (or lower grade) and college at the same time’.

Additional Text:

None

Response Options:

X = No degree

7 = Received an associate degree

8 = Received a bachelor’s degree or higher

<null> No response

Pop-Up Help:

None

Field Error Check:

None

Page Error Check:

Optional response.

May not specify a lower education level than any Degree Type indicated in the ‘Colleges Attended’ section; else error message, “The Higher Education Level you selected is not consistent with the Degree(s) you specified for Colleges Attended; please fix one or the other.”

Notes:

Higher Ed Level can specify a higher degree than the highest “Degree” type at a College Attended because the degree might be from a college not listed.

education table

Data Element:

education:  higher_edu_level

Data Element:

higher_comp_date

Description:

Applicant’s response to Higher Ed Degree Date question

Format, Length:

date, 10 (yyyy-mm-dd format in download)

Values:

Valid date

Allows Null:

Yes

Default:

None

Usage:

Notes:

education table

Xap Field:

higherEdCompletionDate

Revision Log:

~~

Question Text:

College Degree Date

Month        Day        Year

[menu]  [menu]  [textbox] yyyy

Conditions:

Appears only if Higher Education Level is one of the following: Received an associate degree

Received a bachelor’s degree or higher

Additional Text:

“If unsure of the exact day, please estimate.”

Response Options:

Valid date

Pop-Up Help:

None

Field Error Check:

Year must be after 1900; else error message, “You must enter a 4-digit year after 1900.”

Day must be valid for month; else error message, “The day you selected is not valid for the month you selected.”

If mm/dd is February 29, year must be a leap year; else error message, “The day you selected is not valid for the year you entered.”

Page Error Check:

Required selection; else error message, “You must specify your College Degree Date. If unsure of the exact day, please estimate.”

Date must be after Date of Birth; else error message, “Your College Degree Date cannot be before your date of birth; please correct.”

Date must be before RDD; else error message, “Your College Degree Date cannot be after <RDD >. Please correct the date and/or your Higher Education Level.”

Cannot be before High School Completion Date; else error message, “Your High School Completion Date cannot be after your College Degree Date.

Please fix the incorrect date.”

Notes:

None

Data Element:

education:  higher_comp_date

Data Element:

highest_edu_level

Description:

Applicant highest education level, system-generated from Higher Education or High School Education responses.

Format, Length:

bpchar, 5

Values:

If higher_edu_level = 7 or = 8, then first character = higher_edu_level; else first character = hs_edu_level.

If higher_edu_level = 7 or = 8, then final four characters = yyyy from higher_comp_date; else final four characters = yyyy from hs_comp_date (0000 if null)

Allows Null:

No

Default:

None

Usage:

Correlates to MIS SB11

Notes:

education table
System-generated field (derived) between the High School Education Level and Higher Education Level (College) – whichever is highest.

Xap Field:

highestEdLevel

highestEducationLevelYear

Revision Log:

~~

Data Element:

cahs_graduated

Description:

Applicant’s response to Graduated from California High School question

Format, Length:

boolean, 1

Values:

1 = True/Yes

0 = False/No

Allows Null:

No

Default:

None

Usage:

A factor in AB540 Waiver eligibility

Notes:

education table

Xap Field:

graduatedCAHS

Revision Log:

~~

Question Text:

Did you receive your diploma, GED, or certificate in California?

Yes [radio button]        No [radio button]

Conditions:

Appears only if High School Education Level is one of the following: Received high school diploma from U.S. school

Passed the GED, or received a High School Certificate of Equivalency

Additional Text:

None

Response Options:

As shown in Question Text.

Pop-Up Help:

None

Field Error Check:

None

Page Error Check:

Required user response; else error message, “You must select Yes or No to specify whether or not you have received a diploma or certificate of completion from a California high school, or a California High School Certificate of Equivalency (GED).”

Notes:

Defaults to ‘No’ when question is not asked.

Automatically set this to ‘Yes’ when High School Ed level = 5.

Data Element:

education: cahs_graduated

Data Element:

cahs_3year

Description:

Applicant’s response to Attended California High School for Three Years question

Format, Length:

boolean, 1

Values:

1 = True/Yes

0 = False/No

Allows Null:

No

Default:

None

Usage:

A factor in AB540 Waiver eligibility

Notes:

education table

Xap Field:

attendedCAHS3Years

Revision Log:

~~

Question Text:

Have you attended high school in California for three or more years?

Yes [radio button]        No [radio button]

Conditions:

Always

Additional Text:

None

Response Options:

As shown in Question Text.

Pop-Up Help:

None

Field Error Check:

None

Page Error Check:

Required user response; else error message, “You must select Yes or No to specify whether or not you attended high school in California for three or more years.”

Notes:

Used in AB540 Waiver algorithm.

Home schooled students are not eligible for the AB540 exemption if instruction was provided by a tutor or other person (including the student’s parents) who did not have a valid California teaching credential, or was not affiliated with a state approved home-schooling program.

From CCCCO Legal Advisory 07-01: “Home schooling is instruction by a tutor or other person (including the student’s parent) who does not have a valid California teaching credential.

Local high schools are charged with determining whether to accept home schooling as valid attendance. Therefore, community college districts that are asked to consider home schooling as high school attendance for purposes of granting the exemption should confer with the public high school the student would have attended if not home schooled. If that high school accepts or would accept home schooling as valid high school attendance, the community college should also accept it for purposes of assessing whether the student can demonstrate three years of high school attendance.”

Data Element:

education: cahs_3year

Data Element:

hs_attendance

Description:

Applicant’s response to High School Attendance question

Format, Length:

smallint, 1

Values:

1  = Attended high school.

2  = Was homeschooled in a registered homeschool organization?

3  = Was independently homeschooled.

4  = Did not attend high school and was not homeschooled.

Allows Null:

No

Default:

None

Usage:

Notes:

education table

Xap Field:

notAttendHS

Revision Log:

~~

Question Text:

[radio button] I attended high school.

[radio button] I was homeschooled in a registered homeschool organization.

[radio button]  I was independently homeschooled.

[radio button] I did not attend high school and was not homeschooled.

Conditions:

Always

Additional Text:

None

Response Options:

As shown in Question Text.

Pop-Up Help:

None

Field Error Check:

None

Page Error Check:

Required selection; else error message, “You must select one of the options under Last High School Attended.”

Must not be ‘I did not attend high school’ or ‘I was homeschooled in a registered homeschool organization’ or ‘I was independently homeschooled’ if High School Education Level is ‘Received high school diploma from U.S. school’ or ‘Received a diploma/certificate of graduation from a Foreign secondary school’; else error message, “Your responses to the High School Education Level and High School Attendance questions are contradictory. Please fix one or the other.”

Must be ‘I attended high school’ or ‘I was homeschooled in a registered homeschool

organization’ if Attended California High School for Three Years is ‘Yes’; else error message, “One of your answers states that you attended a California high school for three years, but another states that you did not attend high school. Please fix these conflicting answers.”

Notes:

Note: The data elements home_schooled and hs_not_attended are no longer used. They were replaced with hs_attendance.

Data Element:

education:  hs_attendance

Data Element:

hs_not_listed

Description:

Indicates if the applicant clicked that their high school was not listed when searching for the high school.  When this is true, it means the high school was entered manually.

Format, Length:

boolean

Values:

True = The high school not listed link was clicked

False = The high school not listed link was not clicked.

Allows Null:

No

Default:

None

Usage:

Notes:

education table

Xap Field:

N/A

Revision Log:

~~

Question Text:

[Link in the school list] My school is not in the list.

Conditions:

Appears if Country is United States.

Additional Text:

Response Options:

Pop-Up Help:

None

Field Error Check:

None

Page Error Check:

None

Notes:

Clicking this link will cause the high school name and city fields to open for manual entry.

Data Element:

education:  hs_not_listed

Data Element:

hs_state

Description:

Applicant’s response to question for Last High School Attended: State

Format, Length:

bpchar, 2

Values:

USPS state code

Allows Null:

Yes, only if Country is not US

Default:

None

Usage:

Notes:

Defaults to US on application

education table

Xap Field:

High sch 1 enrolled - state

Revision Log:

~~

Question Text:

State [menu]

Conditions:

Appears if Country is United States.

Additional Text:

None

Response Options:

Menu of U.S. states, territories, etc., with California at top. Defaults to “Select a State”.

Pop-Up Help:

None

Field Error Check:

None

Page Error Check:

Required. Error message is “Please select a state”.

Notes:

None

Data Element:

education: hs_state

Data Element:

hs_city

Description:

Applicant’s response to question for Last High School Attended: City

Format, Length:

varchar, 20

Values:

Text string up to 20 characters

Allows Null:

Yes

Default:

None

Usage:

Notes:

Can come from High School Finder or from applicant entry

education table

Xap Field:

High sch 1 enrolled - city

Revision Log:

~~

Question Text:

User is prompted to enter their high school and/or city in the school search box.

"Enter the name or city of your high school or homeschool organization. Then make a selection from the list."

The hs_city ("City" field) is populated from the school lookup table when the user selects a school from the list. If the user clicks “My school is not in the list,”, then the user free-form enters the city in the "City" field.

Conditions:

Appears if Country is United States, and hs_attendance is 1 = I attended high school or 2 = I was homeschooled in a registered homeschool organization.

Additional Text:

Response Options:

None: populated by High School Finder.

Hover Help:

None

Pop-Up Help:

None

Field Error Check:

None

Page Error Check:

None

Notes:

Data Element:

education: hs_city