Standard DED
| Table of Contents | ||
|---|---|---|
|
Problem Statement or Business Need
Per Vice Chancellor Omid Pourzanjani, questions MUST be removed from the CCCApply application in order to make it shorter. The CCCApply Redesign Workgroup has been meeting bi-weekly since June 1, 2018 to determine how to
NOTE: Patty to send Omid all information available on the SSN revision per IRS mandate from 2015. Ask Tim if we have any information on specifically which department at the IRS did the language come from?
Questions to be removed from the CCCApply Standard Application:
College Enrollment:
Change order of the response options in the drop-down menu, putting "enrolling in high school (or lower grade) and college at the same time" first (1) in the order of four. This was discussed at the CACCRAO 2018 A&R Directors Training session (9-18-18) with Sonja Horn (Yuba), Brian Dean (Citrus/Cypress? (add values to the High School Education Level and rename the question (only) Highest Education Level.
College Attended - add skip logic to only display if user has logical College Enrollment Status. If displayed then remove the a"Attendance From" and "Attendance To" fields from display.
From Citizenship Status - add DACA value to the field response options
Parent Education Levels (check with Omid)
Athletic Interest Questions (3)
Special Residency questions: Seasonal Ag worker, CA public
Considering removing the Needs & Interests table. Mike Caruso explained why these are invaluable to the MyPath application.
All of the residency questions were put only
Proposed Solution
HS Education Level
- Change the label for this question to: Highest Education Level
- Combine the high school education levels and the college education levels into one field (No back-end changes are needed for this - it would all be front-end changes)
- There are three fields currently that are populated from two current onscreen questions (HS Education Level & College Education Level):
- <hs_edu_level>
- <higher_edu_level>
- <highest_edu_level>
If they choose this then: (See 2018-26: Add Value to Last High School Attended Section in Apply
Colleges Attended
Colleges Name
Number of College Attended
Problem - we have different values for similar questions:
Col1-4 Degree Type vs.
Higher Education Level
X = No degree
A = Associate degree
B = Bachelor degree or higher
C = Certificate
Null = No response
Higher Education Level
X = No degree
7 = Received an associate degree
8 = Received a bachelor’s degree or higher
Null = No response
This appears as "College Education Level"
Seasonal Worker
This question can be moved out of the application
- IF the applicant is determined to be a non-resident, the college can follow up with these special residency exceptions via Rule and Email
Public School Employee
This question can be moved out of the application
- IF the applicant is determined to be a non-resident, the college can follow up with these special residency exceptions via Rule and Email
State University Employee
This question can be moved out of the application
- IF the applicant is determined to be a non-resident, the college can follow up with these special residency exceptions via Rule and Email
- Update flag and logic to remove from Area B logic
- Add to "Special Residency" section
- Add to "Special Residency" section
- Combine all four Y/N radio button questions into One question
- Move the new question to the top of the page
Athletic Interest: Intracollege
OpenCCC Account Creation
This page contains out-dated information that was pertinent in the first couple of years after launching OpenCCC and moving away from the Xap application, which issued email addresses as part of the account creation process. The options to be reviewed are:
- Remove this page from the workflow can move the information to an About page link accessible from the header.
- The landing page for OpenCCC.net would be an enhanced version of the SignIn page.
Since we will be redesigning the UI in a future release, it makes sense to simplify these types of changes in this version, right?
In the future, let's re-think the use of radio buttons unless they are absolutely needed.
Amanda - can you please update this ticket and the Previous Name format change ticket to just "default response to No/False" and make sure the user can easily click on Yes to change their answer.
Since we will be redesigning the UI in a future release, it makes sense to simplify these types of changes in this version, right?
In the future, let's re-think the use of radio buttons unless they are absolutely needed.
Amanda - can you please update this ticket and the Previous Name format change ticket to just "default response to No/False" and make sure the user can easily click on Yes to change their answer.
Requirements Summary
Change Specifications
Top
Changes to Data Download File
Changes to Logic
Top
Supporting Documentation
Below is additional documentation (i.e., CCCCO legal opinions, residency and/or education code citations, legislation citations, supplemental information, etc.) to be referenced in support of this change request.
For Internal Use Only
Related JIRAs
Education
The tables in this section show the fields that are populated from the Education tab of the CCCApply standard application.
Enrollment Status
Data Element:
enroll_status
Description:
Applicant’s response to College Enrollment Status question
Format, Length:
bpchar, 1
Values:
1 = First-time student in college (after leaving high school)
2 = Transfer student from another college
3 = Returning student to this college after absent for a main term
Y = Enrolling in high school (or lower grade) and college at the same time
Allows Null:
No
Default:
None
Usage:
Correlates to MIS SB15
Notes:
education table
Xap Field:
enrollmentStatusOneChar
Revision Log:
~~
Question Text:
As of <RDD>, I will have the following college enrollment status: [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:
1 = First-time student in college (after leaving high school) 2 = First time at this college; have attended another college
3 = Returning student to this college after absent for a main term
Y = Enrolling in high school (or lower grade) and college at the same time
Pop-Up Help:
None
Field Error Check:
None
Page Error Check:
Required selection; else error message, “You must select your College Enrollment Status.”
If (RDD minus <birthdate>) => 22 years, then do not display the response option “Y = Enrolling in high school (or lower grade) and college at the same time”.
Cannot be “First-time student in college” if college degree is indicated in “Higher education level” field; else error message, “You cannot have a College Enrollment Status of ‘First-time student in college’ if you have received an associate or bachelor’s degree.”
If College Enrollment Status is “Enrolling in high school (or lower grades) and college at the same time”, then High School Education Level must be “Enrolled in college and high school (or lower grades) at the same time”; else error message, “Answers to College Enrollment Status and High School Education Level do not agree: please fix one or the other.”
If College Enrollment Status is “Enrolling in high school (or lower grades) and college at the same time” or “First-time student in college (after leaving high school)”, and data is present in Colleges Attended section, applicant is prompted to confirm or correct the responses: “Your College
Enrollment Status and number of colleges attended indicate that you have previously attended college while in high school (or lower grades). If this is true, please check the confirmation box below. If it is not true, please correct your responses as necessary.”
“I confirm that I previously attended college while in high school or lower grades.”
Notes:
Correlates to MIS SB15.
Note: Per SB11, 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, “Enrolling in high school (or lower grade) and college at the same time” from the drop down menu to minimize errors in classification.
Data Element:
education: enroll_status
High School Education Level
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:
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
High School Completion Date
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
Higher Education Level (College)
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
Higher Education Completion Date
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
Highest Education Level
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:
~~
Graduated From California High School
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
Attended California High School for Three Years
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
High School Attendance
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
High School Not Listed
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
Last High School Attended: Country
Data Element:
hs_country
Description:
Applicant’s response to question for Last High School Attended: Country
Format, Length:
bpchar, 2
Values:
ISO country code
Allows Null:
No
Default:
None
Usage:
Disables High School Finder if not US
Notes:
Defaults to US on application
education table
Xap Field:
High sch 1 enrolled - country
Revision Log:
~~
Question Text:
Country [menu]
Conditions:
Appears if radio button for “I attended high school or a homeschool organization” is selected.
Additional Text:
None
Response Options:
Menu of countries per ISO, United States at top. Defaults to United States.
Pop-Up Help:
None
Field Error Check:
None
Page Error Check:
If High School Education Level is “3 - Received high school diploma from U.S. school”, then Country must be U.S.; else error message, “The country of your Last High School Attended does not match your response to High School education level. Please fix one or the other.”
[Spanish: “El país de la última escuela secundaria a la que asististe no coincide con la respuesta que diste en relación con tu nivel de estudios secundarios. Favor de corregir una o la otra respuesta.”]
If High School Education Level is “6 - Received a diploma/certificate of graduation from a Foreign secondary school”, then Country must not be U.S.; else error message, “The Country of your Last High School Attended does not match your response to High School education level. Please fix one or the other.”
[Spanish: “El país de la última escuela secundaria a la que asististe no coincide con la respuesta que diste en relación con tu nivel de estudios secundarios. Favor de corregir una o la otra respuesta.”]
Notes:
This is a rare menu field that has a default selection.
Data Element:
education: hs_country
Last High School Attended: State
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
Last High School Attended: City
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
Last High School Attended: CDS Code
Data Element:
hs_cds
Description:
High school’s CDS code from High School Finder, or generic code if not from Finder
Format, Length:
bpchar, 6
Values:
Null if ‘education: hs_name’ is null
If State is California: CDS code from High School Finder, else if there is no CDS code in Finder or if the school is entered manually, then 600050
If Country is not US: 8XXXXX
If Country is US but State is not California (whether the school is entered manually or found in the school table):
AL = 600010
AK = 600020
AZ = 600030
NH = 600290
NJ = 600300
NM = 600310
AR = 600040
CO = 600060
CT = 600070
DE = 600080
DC = 600510
FL = 600090
GA = 600100
HI = 600110
ID = 600120
IL = 600130
IN = 600140
IA = 600150
KS = 600160
KY = 600170
LA = 600180
ME = 600190
MD = 600200
MA = 600210
MI = 600220
MN = 600230
MS = 600240
MO = 600250
MT = 600260
NE = 600270
NY = 600320
NC = 600330
ND = 600340
NV = 600280
OH = 600350
OK = 600360
OR = 600370
PA = 600380
RI = 600390
SC = 600400
SD = 600410
TN = 600420
TX = 600430
UT = 600440
VT = 600450
VA = 600460
WA = 600470
WV = 600480
WI = 600490
WY = 600500
AS = 600610 CZ = 600770
VI = 600890
PR = 600810
GU = 600650
Allows Null:
Yes
Default:
None
Notes:
education table
Xap Field:
highSchoolCDSCode1
Last High School Attended: Full CDS Code
Data Element:
hs_cds_full
Description:
Full high school CDS code from CDE
Format, Length:
Character varying 14
Values:
Null if ‘education: hs_name’ is null
If State is California: CDS code from High School Finder, else if there is no CDS code in Finder or if the school is entered manually, then 600050
If Country is not US: 8XXXXX
If Country is US but State is not California (whether the school is entered manually or found in the school table):
AL = 600010
AK = 600020
AZ = 600030
NH = 600290
NJ = 600300
NM = 600310
AR = 600040
CO = 600060
CT = 600070
DE = 600080
DC = 600510
FL = 600090
GA = 600100
HI = 600110
ID = 600120
IL = 600130
IN = 600140
IA = 600150
KS = 600160
KY = 600170
LA = 600180
ME = 600190
MD = 600200
MA = 600210
MI = 600220
MN = 600230
MS = 600240
MO = 600250
MT = 600260
NE = 600270
NY = 600320
NC = 600330
ND = 600340
NV = 600280
OH = 600350
OK = 600360
OR = 600370
PA = 600380
RI = 600390
SC = 600400
SD = 600410
TN = 600420
TX = 600430
UT = 600440
VT = 600450
VA = 600460
WA = 600470
WV = 600480
WI = 600490
WY = 600500
AS = 600610 CZ = 600770
VI = 600890
PR = 600810
GU = 600650
Allows Null:
Yes
Default:
None
Notes:
Added March 2017; Pulling from the same data source, but this will display and download the full 14-digit High School CDS code.
Last High School Attended: CEEB Code
Data Element:
hs_ceeb
Description:
High school’s CEEB code from High School Finder, if available
Format, Length:
bpchar, 7
Values:
CEEB code or null
Allows Null:
Yes
Default:
None
Usage:
Notes:
education table
Xap Field:
High sch 1 enrolled - ceeb
Revision Log:
~~
Number of Colleges Attended
Data Element:
college_count
Description:
Applicant’s response to Number of Colleges Attended question
Format, Length:
smallint
Values:
0 = None
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5 or more
Allows Null:
No
Default:
None
Usage:
Notes:
education table
Xap Field:
moreThanFourColleges
Revision Log:
~~
Question Text:
Specify the number of colleges you have attended including those you are currently attending.
[radio button] None [radio button] 1 [radio button] 2 [radio button] 3 [radio button] 4 [radio button] 5 or more
Conditions:
Always
Additional Text:
If ‘5 or more’ is selected: Instructions TBD
Response Options:
As shown in Question Text.
Pop-Up Help:
None
Field Error Check:
None
Page Error Check:
Required response; else error message, “You must select the number of colleges/universities you have attended.”
Must not be ‘None’ if Enrollment Status is ‘Transfer student from another college’ or
‘Returning student to this college after absent for a main term’; else error message, “Your Enrollment Status and number of colleges attended do not agree. Please correct one or the other.”
Must not be ‘None’ if Higher Education Level is ‘Received an associate degree’ or ‘Received a bachelor’s degree or higher’; else error message, “Your Higher Education Level cannot indicate a college degree if the number of colleges/universities you have attended is None.
Please correct one or the other.”
Must be ‘None’ if Enrollment Status is ‘First-time student in college (after leaving high school)’ or ‘Enrolling in high school (or lower grade) and college at the same time’; else error message, “Your Enrollment Status and number of colleges attended indicate that you have previously attended college while in high school (or lower grades). If this is true, please check the confirmation box below. If it is not true, please correct your responses as necessary.
[checkbox] I confirm that I previously attended college while in high school or lower grades.” This edit will never get activated because the same edit related to college data present will get triggered first. It is the same confirmation/error message.
Notes:
This question replaces the “more than 4 colleges” checkbox in Xap CCCApply. It allows CCCApply to display the exact number of Colleges Attended question blocks needed and to require that all are filled in.
Information about colleges attended is sorted as follows:
The number of College/University question sets that will appear depends on the response to Number of Colleges Attended.
If the Number of Colleges Attended is ‘5ormore’, we probably want to insert instructional text after the Number of Colleges Attended question. This text would tell the user which colleges to list: most recent; most significant; anything as long as the highest degree is included. To minimize redundancy, this document provides tables for the College/University 1 question set only. For College/University 2, College/University 3, and College/University 4,everything is the same as for College/University1 except:
• Wherever it occurs in the tables, “College/University 1” will be replaced by “College/ University 2”, “College/University 3”, or “College/University 4” as appropriate.
- The question set for College/University 2 will appear when Number of Colleges Attended is ‘2’, ‘3’, ‘4’, or ‘5 or more’.
- The question set for College/University 3 will appear when Number of Colleges Attended is ‘3’, ‘4’, or ‘5 or more’.
- The question set for College/University 4 will appear when Number of Colleges Attended is ‘4’ or ‘5 or more’.
Sorting Colleges Attended:
When there are two or more colleges, they can be listed in any order by the applicant. However, in the database they will be sorted and saved in order of attendance, with College/University 1 the most recently attended. The primary sorting date will be Attendance Ended; the secondary sorting date will be Attendance Began. If two or more colleges have the same Attendance Ended date and the same Attendance Began date, it doesn’t matter which comes before the other in the sorting.
Note: In the Xap system, once the Education page has been completed, the schools are resorted on the Education page to match the database sorting. It does not matter whether CCCApply does this. However, if CCCApply does resort the Colleges Attended list, to prevent confusing situations for the user, the sorting should not occur until the page is completed (i.e., sorting should not occur when the page is saved but not completed).
Data Element:
| Page Properties | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Table of Contents | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
Problem Statement or Business Need
The recently passed Assembly Bill 3101 (AB3101) would exempt a student seeking to enroll exclusively in career development and college preparation courses, and other courses for which no credit is given, from community college residency classification requirements.
AB3101 calls to revise the [CCCApply] process so that only data that is required by the federal gov, state law, or that is otherwise necessary...be collected during the process.
And...to the extent that data can be collected from the student at a later time, to delay the collection of that data until after the student has applied to a community college.
[AB3101] would exempt a student seeking to enroll exclusively in career development and college preparation courses, and other courses for which no credit is given...from community college residency classification requirements.
The application therefore needs to be updated to streamline the application process to exempt non-credit students from the residency determination, and only collect data that is required by the federal gov, state law, or that is otherwise necessary at the time of application.
CCCApply Proposed Solution
Below is a running list of changes to be made, and/or questions to be removed or revised, in the Standard Application by the CCCApply Redesign Workgroup - in order to meet the requirements of AB 3101.
As changes are approved, they are prioritized in the FY18/19 quarterly release scheduled. See the following breakdown documents for each release:
2018-37A: CCCApply Redesign Low-Hanging Fruit #1
2018-37B: CCCApply Redesign Low-Hanging Fruit #2
2019-03: CCCApply Redesign Release #4
Questions to be Removed
| Description | Page/Section | Question / Data Field(s) | Remove or Revise | Change Requirements | Legal Implications | Proposed Solution & Release Timeline |
|---|---|---|---|---|---|---|
College Education Level | Education | College education level as of <RDD> <higher_edu_level> | REMOVE & REVISE | Remove the question for users based on their Enrollment Status. Add skip logic to the Enrollment Status <enroll_status> question which will hide this question (and all other conditionally displayed college questions) for all First Time in College users. Remove (hide) question if user's enrollment status is: | COMPLETED See change specifications in | |
Colleges/Universities Attended | Education | Number of Colleges/Universities Attended <college_count> | REMOVE & REVISE | Remove the question for users based on their Enrollment Status. Add skip logic to the Enrollment Status <enroll_status> question which will hide this question (and all other conditionally displayed college questions) for all First Time in College users. Remove (hide) question if user's enrollment status is: | SB12 | COMPLETED See change specifications in |
| Comfortable with English | Needs & Interests | "Are you comfortable reading and writing English" <comfortable_english> | REMOVE* | Remove this question from the application for all users by default. Implement ability for colleges to "opt-in" to continue displaying the full Needs & Interests page. | SG20 Student-Literacy-Status | COMPLETED This question is part of the Needs & Interests page which is scheduled to be removed from the application in the June 2019 release (Q4 - v.6.5.0). NOTE: Colleges will have the opportunity to "opt-in" to continue displaying the Needs & Interests page by written request. |
| Financial Assistance section | Needs & Interests | "Are you interested in receiving information about money for college?" <financial_assistance> | REMOVE* | Remove this question from the application for all users by default. Implement the ability for colleges to "opt-in" to continue displaying the full Needs & Interests page. | SG14 | COMPLETED This question is part of the Needs & Interests page which is scheduled to be removed from the application in the June 2019 release (Q4 - v.6.5.0). NOTE: Colleges will have the opportunity to "opt-in" to continue displaying the Needs & Interests page by written request. |
| Financial Assistance section | Needs & Interests | "Are you receiving TANF/CalWorks, SSI, or General Assistance?" <tanf_ssi_ga> | REMOVE* | Remove this question from the application for all users by default. Implement the ability for colleges to "opt-in" to continue displaying the full Needs & Interests page. | SB164 | COMPLETED This question is part of the Needs & Interests page which is scheduled to be removed from the application in the June 2019 release (Q4 - v.6.5.0). NOTE: Colleges will have the opportunity to "opt-in" to continue displaying the Needs & Interests page by written request. |
| Athletic Interest | Needs & Interests | "Are you interested in participating in a sport while attending college?" <athletic_intercollegiate> <athletic_intramural> <athletic_not_interested> | REMOVE* | Remove this question from the application for all users by default. Implement the ability for colleges to "opt-in" to continue displaying the full Needs & Interests page. | Title IX 80% of our colleges are using this question to facilitate their Title IX survey | COMPLETED This question is part of the Needs & Interests page which is scheduled to be removed from the application in the June 2019 release (Q4 - v.6.5.0). NOTE: Colleges will have the opportunity to "opt-in" to continue displaying the Needs & Interests page by written request. |
| Programs & Services | Needs & Interests | Summary of values stored in the system ni_id table <ni_id_table> | REMOVE* | Remove this question from the application for all users by default. Implement the ability for colleges to "opt-in" to continue displaying the full Needs & Interests page. | Needed for colleges using MyPath | COMPLETED This question is part of the Needs & Interests page which is scheduled to be removed from the application in the June 2019 release (Q4 - v.6.5.0). NOTE: Colleges will have the opportunity to "opt-in" to continue displaying the Needs & Interests page by written request. |
Out-of-State Activities Residency Questions | Residency | <ca_outside_tax> <ca_outside_tax_year> <ca_outside_voted> <ca_outside_voted_year> <ca_outside_college> <ca_outside_college_year> <ca_outside_lawsuit> <ca_outside_lawsuit_year> | REVISE | Revise the format of the four "Out-Of-State" questions from four separate Yes/No radio button questions with conditional "Year" field to one question and change the radio buttons to checkboxes and set the default to "No". In effect, this removes three questions from the application.
| This set of questions is required to determine residency. | COMPLETED See change specifications in In 2018, the percentages of Yes responses across all Out-of-State activities: <ca_outside_tax> = 1.5% |
| Special Residency Section | Residency | Layout change | REVISE | Move the Special Residency section down below the "Out of State Activities" section and implement skip logic to hide the first three questions in Special Residency unless...
| Benefit: | COMPLETED See change specifications in 2018 Data |
| Special Residency: Seasonal Worker | Residency | Have you been employed as a seasonal agricultural worker for at least a total of two months in each of the past two years? <ca_seasonal_ag> | REMOVE & REVISE | Remove this question from the application unless user answers Yes to the Out-of-State activity question | Shortens app for 97.4% of users | COMPLETED See change specifications in |
| Special Residency: Public School Employee | Residency | Are you a full-time credentialed employee of a California public school enrolling in college for purposes of fulfilling credential-related requirements? <ca_school_employee> | REMOVE & REVISE | Remove this question from the application user answers Yes to the Out-of-State activity question | Shortens app for 97.2% of users | COMPLETED See change specifications in |
| Special Residency: State University Employee | Residency | Are you or your spouse a full-time employee of any of the following colleges/universities? <ca_college_employee> | REMOVE & REVISE | Remove this question from the application user answers Yes to the Out-of-State activity question | Shortens app for 97.4% of users | COMPLETED See change specifications in |
Enrollment Status (Hide College Education & Colleges Attended if first time in College) | Education page | <enroll_status> | REMOVE & REVISE | Add skip logic to the Enrollment Status question to remove the College Education & Colleges/Universities Attended sections IF user selects:
| Shortens application for 40% of users | COMPLETED In 2018*, enrollment status breakdown is as follows: 40% = First time student 48.5% = returning to college 11.5% = Dual enrollment (high school or lower grade) *Based on 2,451,319 applications submitted by 12/15/18 |
| Colleges/Universities Attended | Attendance Dates | <attendance_from> <attendance_to> | REMOVE | Remove the attendance dates in the Colleges/Universities Attended section when user is reporting prior college attendance | TBD | TBD |
| SSN Encouragement Pop-up | Edit Account & Account Mailing | <ssn_encouragement> | REMOVE | Remove the SSN Encouragement pop-up box which natters (reminds) students who have not provided their SSN to complete the SSN question. | COMPLETED | |
| Introduction Page | Introduction Page | REMOVE | Remove the Introduction page from the application for all users. This eliminates three clicks for every student in the application workflow. | N/A | COMPLETED | |
| Review Application Page | Review Application Page | REMOVE | Remove the Review Application page from being a required page and set of clicks in the application workflow for all users. Move to the Submission page as an optional, collapsed function hidden behind a button. | COMPLETED | ||
| Consent to Release Information Page | Consent to Release Information | REMOVE | Remove the Consent to Release Information page from being a separate page (and set of clicks) in the application workflow for all users. Move to the Submission page. | COMPLETED | ||
| Personal Information page | Demographic Information page | RENAME & MOVE | Rename the Personal Information page to the Demographic Information page and move to the end of the application workflow. This will decrease the number of students abandoning the application because they will be more invested in completing the process. | COMPLETED | ||
| Needs & Interests Page | Remove all five questions/sections on the Needs & Interests page (the entire page) for all students by default. The questions to be removed (hidden) by default are:
| COMPLETED This section was reconfigured to be "optionally" turned off or on in the CCCApply Release 4 June 28, 2019 (v.6.5.0) | ||||
| 5 | WAIT ON THIS ONE - revisit with committee
| NEEDS REVIEW from ADVISORY COMMITTEE | |
| EDIT ACCOUNT | 2 | Move the SSN question* from OpenCCC Account to the CCCApply Application(s) using the new proposed layout format. | PENDING APPROVAL from LEADERSHIP |
| Account / Mailing Information | 3 | Simplify the Account Information/Mailing page by hiding OpenCCC Account Information for first time applicants that just created their OpenCCC Accounts
| COMPLETED |
| Education | 8 | Research "Last HS Attended" section - Workgroup/Omid believes that section should also be conditional and per MIS requirements that I've seen, if the student is over age 25 (22?) then they are not "required" to provide details of their last high school, such as CDS code, name, address, city, state Zip (maybe State). Research this with the Advisory Committee - SB12 - STUDENT-HIGH-SCHOOL-LAST (see attached) | RESEARCH MIS RESEARCH ED CODE/ TITLE 5 |
| 9 | Dual Enrollment - Add to skip logic to hide college education sections (this is already a JIRA) | ||
| 10 | HS Completion Date - simplify this field by first asking for the YYYY the applicant graduated; if the year is within ? 10 years of RDD, then ask for MM; if within 2 years, also ask for DD to best of ability, if not skip. This will need to be considered from many perspectives: MIS requirements, Dual enrollment, residency, etc. | RESEARCH MIS, ADVISORY CONSULTATION | |
| See combined list of change requests pending: 2019-16: Open Issues Around the Education Pages - Apply & International | |||
| See 744587524 | |||
| Needs & Interests | 12 | Research whether we need to keep the TANF question on the Needs & Interests page (second question in the Financial Assistance section). Confirm we do or do not need it for Non-Credit students too. This was reviewed and approved by the Workgroup but could be unreliable and needs Steering approval. | RESEARCH TANF mandate of 2017. See attached. |
| 13 | Revise the Programs & Services Labels on the Needs & Interests page: Discuss better way to present the Programs & Services list to the applicant beyond just labels for each area. We need to incorporate better/more superior Help support for vague language throughout the application .This section is one such area. | WORK with ADVISORY GROUP ON PROPOSAL | |
| Demographic Info | 14 | Explore removing the Parent/Guardian Education Levels question- what are the requirements? Can this be removed from MIS perspective? Does it need to be asked? If YES, does it need to be Required? If yes, can we simplify the options we are asking? Per Workgroup, there are fewer MIS required response options than we are asking now. Why? | RESEARCH MIS |
| Enrollment | 6 | Revise the Education Goals to ensure they have to be collected at the time of application | RESEARCH MIS REVIEW WITH ADVISORY COMM |
| ACCOUNT | 1 | Collaborate with the OpenCCC Redesign project team to itemize all fields that are proposed to be removed from OpenCCC Account creation because they will need to be added to CCCApply (BOG and/or International) because all fields are currently passed through Account to the application (merged) for download. Also any fields that are added to OpenCCC Account that may need to be downloaded by Apply should be considered. Questions for the OpenCCC Redesign team:
| RESEARCH AND TESTING What is the new redesign vision? Review OpenCCC Redesign Charter Review sprint demos and regular comm to Steering and colleges |
Add Questions Removed from OpenCCC System Into CCCApply NOTE: The OpenCCC Redesign project is happening and currently requirements are being gathered to completely redesign this front-load/front-facing account system to be more utilitarian towards authentication/authorizatIon than PII / Directory information data collection If the new OpenCCC design requires the removal of many of the existing personal information fields (Previous Name fields, Preferred Name fields, SSN, DOB, Main Phone, Second Phone, Perm Address, Homeless checkboxes, etc.) then we need to redesign the Account & Mailing Info page to accommodate all of these fields because they will need to move added to the application proper. This is a significant change to our existing configuration and would require - I believe - approval by the Advisory Committee (Steering), the Workgroup, and CCCApply. Further, any new fields added to Account that need to be added to Apply - such as additional consent to release OpenCCC data (maybe) or other new fields, may need to be added to the Applications downloads. | RESEARCH ALL FIELDS TARGETED TO BE REMOVED RESEARCH AND REVIEW BY STAKEHOLDERS |