Page Properties | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Table of Contents | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
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
CCCApply Proposed Solution
Page/Section | Description | Data Field(s) | Remove or Change | Change Requirements | Legal Implications | JIRA |
---|---|---|---|---|---|---|
Enrollment | Ed Goal Responses Revision | <ed_goal> | CHANGE | Work with the Non-Credit sub-committee to revise the responses to make more sense to the student. The values would map the same, but the onscreen response options would be clarified. | ||
Account Info | Zip up the Account Info section | CHANGE | Zip up all the questions in the Account Information section which can be opened via the same "Edit my account" link | |||
Current Mailing | ||||||
Help Page | ||||||
Edit Account | Revise the SSN Question Revise the Preferred Name | |||||
Citizenship | Update section label & select question labels | |||||
Education | Enrollment Status | <enroll_status> | CHANGE | Update the logic in the Enrollment Status field to HIDE the College Education & Colleges/Universities Attended sections IF user selects:
CONTINUE BELOW | ||
Here's the logic that should be implemented across the responses: 1 = First-time student in college (after leaving high school)
2 = Transfer student from another college (Keep existing logic) 3 = Returning student to this college after absent for a main term (Keep existing logic) Y = Enrolling in high school (or lower grade) and college at the same time
| ||||||
Education | HS Education Level | <hs_edu_level> | CHANGE |
Revise the conditions and logic to only display the response options that align to the college enrollment responses, such as:
Move the logic from College Education to this question - IF user selects: Associates Degree, THEN display the Colleges Attended (college_count) and all the corresponding logic (i.e., display Col1-4 fields depending on number selected in college count. | None because there will be no change to the data output to the colleges - we are just combining two fields into one (removing College Education Level dropdown from the application) | |
<hs_edu_level> No change to the existing data field valuse | Add the values from Higher Education Level field to the High School Education Level dropdown menu / response options, X = No degree 7 = Received an associate degree 8 = Received a bachelor’s degree or higher | |||||
<hs_edu_level> | Revise the conditions and logic to only display the response options that align to the college enrollment responses, such as:
| |||||
<higher_edu_level> | CHANGE | 3 = Received high school diploma from U.S. school | ||||
CHANGE LOGIC | Only display these values in the new Highest Education Level menu following options IF college enrollment response is: 3 = Returning student to this college after absent for a main term from the College Enrollment question menu | |||||
Education | Last HS Attended | <hs_attendance> | CHANGE | To remove barriers for dual enrollment students, ADD a response option/value to the Last HS Attended field/question for "I attended a grade lower than high school" for middle school students.
See 2018-26: Add Value to Last High School Attended Section in Apply | ||
Colleges Attended | College Education | <higher_edu_level> | REMOVE | Remove this question from the application. These response options would be added to the HS Ed Level question (see above) | ||
Education | Colleges Attended | CHANGE | Update conditions: Display the Colleges Attended and Colleges & University fields (Col1-4) if the user's 'College Enrollment Status" indicates they have previously attended college | |||
Colleges Attended | Colleges Name | CHANGE | Update the conditions for display Only display this section IF student selects: 2 = Transfer student from another college 3 = Returning student to this college after absent for a main term from the College Enrollment question menu | |||
Education | Number of College Attended | college_count | CHANGE | Update the conditions for display Only display this section IF student selects: 2 = Transfer student from another college 3 = Returning student to this college after absent for a main term from the College Enrollment question menu | ||
Col1-4 Degree Type | 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" | ||||
Residency | Special Residency: Seasonal Worker | REMOVE | This question can be moved out of the application
| |||
Residency | Special Residency: Public School Employee | REMOVE | This question can be moved out of the application
| |||
Residency | Special Residency: State University Employee | REMOVE | This question can be moved out of the application
| |||
Residency | Homeless Youth Questions | CHANGE |
| |||
Residency | Foster Youth Questions | CHANGE |
| |||
Residency | Out-of-State Indicators Residency Questions | CHANGE |
| |||
Needs & Interests | Athletic Interest: Inter-collegiate Athletic Interest: Intracollege | REMOVE | Remove the requirement to display the two Athletic Interest questions from the application AND make them "Optional" - just like the MMI questions. Colleges can decide if they want to "turn on" the athletic questions or not (Many colleges are using the Title IX survey and use those questions as the trigger logic to send the application). | |||
Needs & Interests | Language | CHANGE | Remove the "Are you comfortable reading and writing English" from the application | |||
Needs & Interests | Financial Aid Section | CHANGE | Remove the "Are you comfortable with speaking and reading English" from the application | |||
Citizenship/Military |
OpenCCC Account Creation
Page/Section | Description | Remove or Change | Change Requirements | Legal Implications | JIRA |
---|---|---|---|---|---|
Account Creation Page 1 | Revision to SSN Question | REVISE | Streamline the Social Security Number question in the Account creation to new proposed format. This format would:
Keep the following elements in the question:
| ||
Account Recovery | Account Recovery by Text Message | ENHANCE | Add ability to recover OpenCCC account by text message Add as an option to be selected with Answer Security Question or Send me an Email to recover my account. Implement Text Messaging into Account Recovery If student selects = send me a text message to recover my account > send a 5-6 digit code that would be implemented onscreen | ||
OpenCCC.net | Welcome page | REMOVE | Remove this page from the workflow - The information can be moved to the Help page. Make the homepage/landing page for "www.openccc.net" to the Sign-In page. | N/A | |
OpenCCC.net | Create Your Account page | REMOVE | Remove this page from the workflow - The information can be moved to the Help page 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:
| ||
OpenCCC Sign-In | OpenCCC Sign-In page | CHANGE | |||
Account Creation Page 1 | Previous Name | CHANGE | To save dev time on this story, in our current uPortal application - instead of changing the format to checkbox - just default the answer to No/False. 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. | ||
Account Creation Page 2 | Revise the Email Address Logic | REVISE | |||
Account Creation Page 2 | Revision to Main phone & Second phone responses | REVISE | Enhance the Mainphone / Second phone fields to add additional options to identify:
| ||
Account Creation Page 2 | Mainphone Extension Second phone Extension | REMOVE REMOVE | Remove these fields from onscreen in the Account Creation & Edit Account Deprecate these fields | ||
Account Creation Page 1 | Preferred Name | CHANGE | To save dev time on this story, in our current uPortal application - instead of changing the format to checkbox - just default the answer to No/False. 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
# | Title | User Story | Importance | Notes |
---|---|---|---|---|
1 | ||||
2 |
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.
Description | File or Link |
---|---|
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 Change label of this question to "Highest Education Level" |
Format, Length: | bpchar, 1 |
Values: | 3 = Received high school diploma from U.S. 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: |
X = Attended some college but did not obtain a degree 7 = Received an associate degree 8 = Received a bachelor’s degree or higher |
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 |
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. [radio button] I attended a lower grade than high school. | |
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. |
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: | college_count |