Request No. | 2018-37B |
---|---|
Date of Request | October 14, 2018 |
Requester | CCCApply Redesign Workgroup - CCCCO |
Application(s) | Standard Application |
Section / Page | Full Workflow |
Approval Date | TBD |
Changes to Download File | TBD |
Changes to Residency Logic | TBD |
Low-Hanging Fruit Changes
This is the second round of short-term, low-hanging fruit changes approved as part of the CCCApply Redesign Project, guided by the CCC Chancellor's Office in collaboration with the CCCApply Redesign Workgroup. See "Low-Hanging Fruit #1" change request for the first round of changes deployed to the current version of CCCApply in FY18-19.
Business Need
Student-centered design in action.
The Chancellor’s Office, the CCC Technology Center, and the Foundation for California Community Colleges, in collaboration with the community colleges and in partnership with ideas42, are redesigning the CCCApply experience with a student-centered approach in mind.
Chancellor's Office Project Name: CCCApply Redesign Project
Stakeholders:
CCCApply Redesign Workgroup & Sub-Committees
CCCApply User Workgroup (formerly known as the Steering Committee)
Risks & Constraints
Scope and schedule deadlines - must have complete business requirements, reviewed, approved, estimated and prioritized by the final deadline in order to meet the quarterly release schedule for FY18-19.
Change Requirements
CCCApply Redesign Project short-term changes approved for the current version of CCCApply.
Must meet the requirements deadline schedule for designated release.
Changes to the Needs & Interests Page
# | Description | Proposed Solution / Requirements | Need Requirements |
---|---|---|---|
1 | Remove the question, "Are you comfortable reading and writing English?" from the Needs & Interests page in the Standard application for all users |
| Should this question also be removed from the International Application? |
2 | Remove the "Financial Assistance" section and both questions in that section from the Needs & Interests page in the Standard application for all users. Remove the "Are you interested in receiving information about money for college? from the N&I page in the standard App. |
| Should these questions also be removed from the International Application? |
3 | Remove the "Are you receiving TANF/CalWorks, SSI, or General?" questions from the Needs & Interests page in the Standard application for all users |
| Should these questions also be removed from the International Application? |
4 | Reconfigure the Athletic Interest section to be an "opt-in" form element that can be removed from the Needs & Interests page in Standard Application, or can remain/display for colleges that opt-in to use it for Title IX purposes. |
| In-Scope FY18-19: Medium size effort to remove from App as a configurable data form element for users; Out-of-Scope FY18-19: Large-sized effort - includes all of the work listed above AND the work to add an opt-in/out with a toggle in the Administrator. Requires CAP UI/UX engineer. |
Move this OOS section up under the "California Stay Begin" questions (switch places with the Special Residency section) and based on a Yes response (checkbox is checked) to any of these four checkbox questions, display the first three "Special Residency" questions, otherwise do not display. | |||
Revised Needs & Interests page with removed questions | |||
Changes to the Residency Page
# | Description | Proposed Solution / Requirements | Need Requirements |
---|---|---|---|
1 | Revise the layout of the Residency Page for improved efficiency |
The layout should be:
| |
2 | Revise the layout and format of the "Out of State Activities" questions. Change the format of the four separate Yes/No radio button Out-of-State Activities checkbox questions to One question with four checkbox response options. | Combine the four separate Yes/No radio button questions into one question with four checkbox response options. This way the user doesn't HAVE to answer these questions unless they pertain to them.:
Background & Reasoning
| |
3 | Revise the Special Residency section - Implement skip logic to only display the Special Residency questions IF the applicant responds YES to one or more Out-of-State Activities. |
NOTE: No change to the Homeless Youth or Foster Youth questions. These would ALWAYS display on screen as currently implemented. | |
4 | Whether applicant is a full-time employee, or spouse/dependent of a full-time employee, of a state college | Hide this question unless user answers Yes to the Out-of-State activity question Are you or your spouse a full-time employee of any of the following colleges/universities? 1. California Community College 2. California State University or College 3. University of California 4. Maritime Academy [radio button] Yes [radio button] No | |
5 | Whether applicant is a full-time employee, or spouse/dependent of a full-time employee, of a state college | Hide this question unless user answers Yes to the Out-of-State activity question | |
6 | Hide this question unless user answers Yes to the Out-of-State activity question | ||
Special Residency Screenshots | |||
Changes to the Education Page
# | Description | Proposed Solution / Requirements | Need Requirements |
---|---|---|---|
1 | Revise the College Enrollment Status logic to hide College Education & Colleges Attended questions Add skip logic to the Education Page to hide Colleges Attended questions IF the student is a First Time Student in College | Update the logic in the Enrollment Status field to HIDE the College Education & Colleges/Universities Attended sections IF user selects:
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
| |
Questions to be Removed
Requirements Deadlines
*Due to the current budget and team capacity, even approved changes that do meet the deadlines below are not guaranteed inclusion in the release(s).
FINAL DEADLINES | ||
---|---|---|
Change Management Activities | Q3 Release - March 2019 | Q4 Release - June 15, 2019 |
Submit Change Request | December 31, 2018 | February 28, 2019 |
T-Shirt Size Estimate | January 8, 2019 | March 7, 2019 |
Budget Review | January 8, 2019 | March 9, 2019 |
Written Sign-Off on Vetted Approved Changes | January 9, 2019 | March 15, 2019 |
Resources & Capacity Estimates | ||
Story / Epic Business Requirements | January 11, 2019 | March 25, 2019 |
Technical Estimate | January 11, 2019 | March 27, 2019 |
Release Management Activities | ||
Code Freeze | January 31, 2019 | May 16, 2019 |
Pilot Release (30 Days) | February 15, 2019 | May 31, 2019 |
Pilot Release (2 Weeks) | March 1, 2019 | June 14, 2019 |
Production Release | March 15, 2019 | June 28, 2019 |
Out-of-Scope Items
# | Description | Section | Proposed Solution / Requirements |
---|---|---|---|
5 | Revision to the Social Security Number Question | OpenCCC Account Creation & Apply Edit Account page | Simplify the Social Security Number question / section in OpenCCC Account by zipping up the extended legal information text behind a "pop-up Help" hyperlink, removing the "I plan to apply for financial aid" checkbox, hiding but maintaining existing data fields |
Spanish Language Translation to CCCApply | |||
Collapse the Account Information/Mailing sections and put behind an "Edit" button or link | Account Information / Mailing | Zip up the “Review OpenCCC Account Info” section IF user comes directly from Account creation. Current Mailing defaults to “same as Permanent Address | |
Move "Consent to Release information" page OR add an additional Consent page to the Account Freat | |||
Data Dictionary Elements
Residency Page Data Elements
The tables in this section show the fields that are populated from the Residency tab of the CCCApply standard application.
State College Employee
Data Element: | ca_college_employee |
Description: | Whether applicant is a full-time employee, or spouse/dependent of a full-time employee, of a state college |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Question Text: | Are you or your spouse a full-time employee of any of the following colleges/universities? 1. California Community College 2. California State University or College 3. University of California 4. Maritime Academy [radio button] Yes [radio button] No |
Conditions: | Always If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Is your parent or guardian a full-time employee ...” |
Additional Text: | None |
Response Options: | As shown in Question Text. |
Hover Help: | "Click Yes if <you or your spouse/your parent or guardian> is a full-time employee of one of the listed institutions. Otherwise, click No." [Spanish: "Haga clic en Yes si <usted/o cónyuge/ padre o guarda> están como empleado de tiempo completo con credenciales de una escuela pública de California y se están inscribiendo en este colegio p los propósitos de cumplimiento de requisitos relacionados con la credencial. De lo contrario, haga clic en No."] |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | Required selection; else error message, “You must indicate whether or not <You or your spouse/your parent or guardian> is a full-time employee of one of the listed colleges / universities.” |
Notes: | None |
Data Element: | residency: ca_college_employee |
Public School Employee
Data Element: | ca_school_employee |
Description: | Whether applicant is a full-time credentialed employee of a California public school enrolling in college to fulfill credential-related requirements. |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Xap Field: | publicSchoolCredEmployee |
Revision Log: | ~~ |
Question Text: | Are you a full-time credentialed employee of a California public school enrolling in college for purposes of fulfilling credential-related requirements? [radio button] Yes [radio button] No |
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 indicate whether or not you are a fulltime credentialed employee of a California public school enrolling in college for purposes of fulfilling credential-related requirements.” |
Notes: | None |
Data Element: | residency: ca_school_employee |
Seasonal Agricultural Worker
Data Element: | ca_seasonal_ag |
Description: | Whether applicant has been employed as a seasonal agricultural worker for at least a total of two months of each of the past two years. |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Xap Field: | agriculturalEmployee |
Revision Log: | ~~ |
Question Text: | Have you been employed as a seasonal agricultural worker for at least a total of two months in each of the past two years? [radio button] Yes [radio button] No |
Conditions: | Always If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Has your parent or guardian been employed ...” |
Additional Text: | None |
Response Options: | As shown in Question Text. |
Hover Help: | [Spanish: "Haga clic en Yes si <usted/su padre o guarda > han sido empleado como un trabajador de agricultura temporal durante dos meses o más en cada uno de los últimos dos años. De lo contrario, haga clic en No."] |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | Required selection; else error message, “You must indicate whether or not <you have/your parent or guardian has> been employed as a seasonal agricultural worker for at least a total of two months in each of the past two years.” |
Notes: | None |
Data Element: | residency: ca_seasonal_ag |
Homeless Youth
Data Element: | homeless_youth |
Description: | Whether applicant has been determined to be a homeless youth at any time within the last 24 months. |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No |
Allows Null: | Yes |
Default: | If <no_perm_address_homeless> = 1 (True/Yes) then set <homeless_youth> to Yes. |
Notes: | residency table |
Question Text: | At any time in the last 24 months were you determined to be homeless by any of the following?
[radio button] Yes [radio button] No |
Conditions: | Only appears on the Residency page if applicant is under 25 years old at time of application. If <no_perm_address_homeless> checkbox – in the OpenCCC Account = Yes, the set default to Yes on this question. |
Additional Text: | None |
Response Options: | As shown in Question Text. |
Field Error Check: | None |
Page Error Check: | If displayed, required selection; else error message, “Required user response if question is displayed; else error message, "You must select Yes or No to specify whether you have been determined homeless anytime within the last 24 months. If you have been determined homeless, select “Yes” and contact the Admissions Office to present verification.” |
Notes: | Added in March 2017 per AB 801 – Homeless Youth |
Data Element: | residency: homeless_youth |
Foster Youth in California
Data Element: | ca_foster_youth | ||||||||||||
Description: | Whether applicant is a current or former Foster Youth in California and under 20 years of age at RDD. | ||||||||||||
Format, Length: | boolean, 1 | ||||||||||||
Values: | The calculation for how to set this field based on the foster_youth_status field.
| ||||||||||||
Allows Null: | Yes | ||||||||||||
Default: | None | ||||||||||||
Usage: | To align with the updated requirements for AB12, this field was removed from the residency logic (Area B) and replaced with new logic (see Residency Area B Logic). The field will still populate based on the logic detailed under Values. | ||||||||||||
Notes: | This question became obsolete and was removed from the application based on new requirements for AB 194 and MIS SG03. The database field is still being populated but is no longer used in the residency algorithm. | ||||||||||||
Xap Field: | under20FosterYouthCA | ||||||||||||
Revision Log: | March 31, 2016 | ||||||||||||
Response Options: | |||||||||||||
Pop-Up Help: | None | ||||||||||||
Field Error Check: | None | ||||||||||||
Notes: | This database field is still being populated. residency table | ||||||||||||
Data Element: | residency: ca_foster_youth |
Foster Youth Status
Data Element: | foster_youth_status | |
Description: | Indicates the Foster Youth status of the applicant based on their screen input. | |
Format, Length: | char 1 | |
Values: | Set the value for this field as follows: 0 = The response to “Have you ever been in Court Ordered Foster Care?” is No. Set the field based on the option selected when Foster Care question is Yes and the additional question text displays with radio buttons: 1 = I am currently in foster care (including extended foster care after age 18). 2 = I aged out/emancipated from foster care or exited voluntarily on or after my 18th birthday. 3 = No longer used 4 = No longer used 5 = I exited the foster care system before my 18th birthday. 6 = I am not sure at what age I exited foster care. | |
Allows Null: | No | |
Default: | None | |
Usage: | ||
Notes: | residency table | |
Xap Field: | fosterYouthStatus | |
Revision Log: | March 31, 2016 | |
Question Text: | Have you ever been in court-ordered foster care? (See additional text below) | |
Conditions: | Always | |
Additional Text: | When did you exit foster care? I am currently in foster care (including extended foster care after age 18). I aged out/emancipated from foster care or exited voluntarily on or after my 18th birthday. I exited the foster care system before my 18th birthday. I am not sure at what age I exited foster care. | |
Response Options: | Required fields: For the Yes/No question, if not selected, error message is: “Please indicate if you have ever been in court-ordered foster care.” When the Yes/No question = Yes, one of the options must be selected. If no option is selected, error message is: “Please select one of the foster care options.” | |
Hover Help: | [Spanish: "Por favor indique, si o no ha estado alguna vez colocado en Cuidado Adoptivo ordenado por el tribunal."] | |
Pop-Up Help: | The "Have you ever been in Court Ordered Foster Care?" question link opens the following pop-up help: You have been in foster care if you were removed from your biological family through an order by a court, which can include placement with foster parents, in a group home, or with relatives/extended family members. If you were living with relatives you must have been placed through the foster care system by an order of the court. Foster Care includes, but is not limited to, placement in out-of-home care under the supervision of the Juvenile Probation Department. As long as you were placed within the foster care system by order of a court, you were in foster care. Having a legal guardian does not necessarily mean that you have been in foster care. If you need assistance with determining whether you were in foster care, you can contact the California Foster Care Ombudsman's office at (877) 846-1602 or fosteryouthhelp@dss.ca.gov. The "When did you exit foster care?" link renders a help pop-up which reads:
You 'aged out/emancipated' from foster care if you exited foster care on or after your 18th birthday. If you need assistance with determining when you exited foster care, you can contact the California Foster Care Ombudsman's office at (877) 846-1602 or fosteryouthhelp@dss.ca.gov.
You 'exited the foster care system before your 18th birthday' if you were returned to the custody of your biological parents, entered a legal guardianship (with relatives or nonrelatives) or were legally adopted before your 18th birthday. If you need assistance with determining when you exited foster care, you can contact the California Foster Care Ombudsman's office at (877) 846-1602 or fosteryouthhelp@dss.ca.gov.
If you need assistance with determining when you exited foster care, you can contact the California Foster Care Ombudsman's office at (877) 846-1602 or fosteryouthhelp@dss.ca.gov. | |
Field Error Check: | None | |
Page Error Check: | None | |
Notes: | Question revised in 2016 to better align data values with MIS and AB12. See Appendix A: Submission Calculations Service Residency: Area B logic, Step 4. AB669 approved in 2009. Question revised in 2013. | |
Data Element: | residency: foster_youth_status | |
Foster Youth Priority
Data Element: | foster_youth_priority | ||||||||||||
Description: | Calculated result for AB194 eligibility. Eligibility is defined as being a current foster youth or former foster youth who was in foster care as of the applicant’s 18th birthday and under age 25. | ||||||||||||
Format, Length: | boolean, 1 | ||||||||||||
Values: | AFTER the foster_youth_status field has been set, set the value of foster_youth_priority as follows:
| ||||||||||||
Allows Null: | No | ||||||||||||
Default: | None | ||||||||||||
Usage: | Calculated result for AB194 eligibility. | ||||||||||||
Notes: | The Foster Youth Priority field is the only trigger for Integrity Flag 71. The Integrity Flag 71 is triggered if the value after calculation is "1" (meaning the applicant is eligible for Foster Youth Priority registration). See Table E. Residency Integrity Flags, here: Appendix A: Submission Calculation Logic & Residency Algorithm on page 197. residency table | ||||||||||||
Xap Field: | fosterYouthPriority | ||||||||||||
Revision Log: | 1/29/16 |
Foster Youth MIS
Data Element: | foster_youth_mis | |||||||||
Description: | Derived field based on foster_youth_status. | |||||||||
Format, Length: | boolean, 1 | |||||||||
Values: | AFTER the foster_youth_status field has been set, set the value of foster_youth_mis as follows:
Note: Even though = 3 and = 4 are no longer used, they remain in the logic for assurance that in case the values should appear, they will be considered eligible. | |||||||||
Allows Null: | Yes | |||||||||
Default: | None | |||||||||
Usage: | ||||||||||
Notes: | In CCCApply, this field is case sensitive (lower) = foster_youth_mis residency table | |||||||||
Xap Field: | fosterYouthMIS | |||||||||
Revision Log: | 1/29/16 |
Declared Residency Outside California for Taxes
Data Element: | ca_outside_tax |
Description: | Response to whether applicant (or parent/guardian) has declared residency in another state for state income tax purposes in the 2 years prior to RDD |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Question Text: | Since <RDD minus 2 years>, have you declared residency in another state for state income tax purposes? [radio button] Yes [radio button] No |
Conditions: | Always; If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Since <RDD minus 2 years>, has your parent or guardian declared residency ...” |
Additional Text: | None |
Response Options: | As shown in Question Text. |
Hover Help: | [Spanish: "Haga clic en Yes si <RDD minus 2 years>, <si usted/su padre o guarda> presentó una declaración de impuestos como residente de un estado que no sea California. De lo contrario, haga clic en No."] |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | Required selection; else error message, “You must indicate whether or not <you have/your parent or guardian has> declared residency in another state for state income tax purposes.” |
Notes: | None |
Data Element: | residency: ca_outside_tax |
Declared Residency Outside California for Taxes Year
Data Element: | ca_outside_tax_year |
Description: | Most recent year indicated for declaring residency in another state for state income tax purposes |
Format, Length: | Date, 10 (yyyy-mm-dd download format) |
Values: | UI entry: Integer, between <RDDyear> and <RDDYear – 2> |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Question Text: | If Yes, what was the most recent year? [textbox] |
Conditions: | Appears only if Residency Outside California for Taxes is ‘Yes’. |
Additional Text: | None |
Response Options: | Four-digit year. |
Hover Help: | "Enter the year in which <you/your parent or guardian> most recently filed an income tax return as a resident of a state other than California." [Spanish: "Entre el año en que <usted/su padre o guarda> más recientemente presentó una declaración de impuestos como residente de un estado que no sea California."] |
Pop-Up Help: | None |
Field Error Check: | Must be year portion of <RDD>, <RDD minus 1 year>, or <RDD minus 2 years>; else error message, “For ‘<have you/has your parent or guardian> declared residency in another state for state income tax purposes’, the year must be between <RDDyear minus 2 years> and <RDDyear>.” |
Page Error Check: | Required response; else error message, “You must specify the year that <you/your parent or guardian> declared residency in another state for state income tax purposes.” |
Notes: | None |
Data Element: | residency: ca_outside_tax_year |
Registered to Vote Outside California
Data Element: | ca_outside_voted |
Description: | Response to whether applicant (or parent/guardian) has registered to vote in another state in the 2 years prior to RDD |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Question Text: | Since <RDD minus 2 years>, have you registered to vote in another state? [radio button] Yes [radio button] No |
Conditions: | Always If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Since <RDD minus 2 years>, has your parent or guardian registered to vote in another state?” |
Additional Text: | None |
Response Options: | As shown in Question Text. |
Hover Help: | [Spanish: "Haga clic en Yes si, desde <RDD minus 2 years>, <si usted/su padre o guarda han> registrado p votar en un estado que no sea California. De lo contrario, haga clic en No.”] |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | Required selection; else error message, “You must indicate whether or not <you have/your parent or guardian has> registered to vote in another state.” |
Notes: | None |
Data Element: | residency: ca_outside_voted |
Registered to Vote Outside California: Year
Data Element: | ca_outside_voted_year |
Description: | Most recent year indicated for registering to vote in another state |
Format, Length: | Date, 10 (yyyy-mm-dd download format) |
Values: | UI entry: Integer, between <RDDyear> and <RDDYear – 2> |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Question Text: | If Yes, what was the most recent year? [textbox] |
Conditions: | Appears only if Registered To Vote Outside California is ‘Yes’. |
Additional Text: | None |
Response Options: | Four-digit year. |
Hover Help: | "Enter the year in which <you/your parent or guardian> most recently registered to vote in a state other than California." [Spanish: "Entre el año en que <usted/su padre o guarda> más recientemente registro p votar en un estado que no sea California."] |
Pop-Up Help: | None |
Field Error Check: | Must be year portion of <RDD>, <RDD minus 1 year>, or <RDD minus 2 years>; else error message, “For ‘<have you/has your parent or guardian> registered to vote in another state’, the year must be between <RDDyear minus 2 years> and <RDDyear>.” |
Page Error Check: | Required response; else error message, “You must specify the year that <you/your parent or guardian> registered to vote in another state.” |
Notes: | None |
Data Element: | residency: ca_outside_voted_year |
Residence for College Outside California
Data Element: | ca_outside_college |
Description: | Response to whether applicant (or parent/guardian) has declared residency outside California to attend a college or university in the 2 years prior to RDD |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Question Text: | Since <RDD minus 2 years>, have you declared residency at an out-of-state college or university? [radio button] Yes [radio button] No |
Conditions: | Always If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Since <RDD minus 2 years>, has your parent or guardian declared residency ...” |
Additional Text: | None |
Response Options: | As shown in Question Text. |
Hover Help: | [Spanish: "Haga clic en Yes si, desde <RDD minus 2 years>, <si usted/su padre o guarda han> declarado residencia en un colegio o Universidad en un estado que no sea California. De lo contrario, haga clic en No."] |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | Required selection; else error message, “You must indicate whether or not <you have/your parent or guardian has> declared residency at an out-of- state college or university.” |
Notes: | None |
Data Element: | residency: ca_outside_college |
Residence for College Outside California: Year
Data Element: | ca_outside_college_year |
Description: | Most recent year indicated for declaring residency outside California to attend a college or university |
Format, Length: | Date, 10 (yyyy-mm-dd download format) |
Values: | UI entry: Integer, between <RDDyear> and <RDDYear – 2> |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Question Text: | If Yes, what was the most recent year? [textbox] |
Conditions: | Appears only if Residence for College Outside California is ‘Yes’. |
Additional Text: | None |
Response Options: | Four-digit year. |
Hover Help: | “Enter the year in which <you/your parent or guardian> most recently declared residency at a college or university in a state other than California.” [Spanish: "Entre el año en que <usted/su padre o guarda> más recientemente declaró residencia en un colegio o Universidad en un estado que no sea California."] |
Pop-Up Help: | None |
Field Error Check: | Must be year portion of <RDD>, <RDD minus 1 year>, or <RDD minus 2 years>; else error message, “For ‘<have you/has your parent or guardian> declared residency at an out-of-state college or university’, the year must be between <RDDyear minus 2 years> and <RDDyear>.” |
Page Error Check: | Required response; else error message, “You must specify the year that <you/your parent or guardian> declared residency at an out-of-state college or university.” |
Notes: | None |
Data Element: | residency: ca_outside_college_year |
Lawsuit Outside California
Data Element: | ca_outside_lawsuit |
Description: | Response to whether applicant (or parent/guardian) has instituted a legal petition outside California in the 2 years prior to RDD |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Xap Field: | lawsuitNonCAState |
Revision Log: | ~~ |
Question Text: | Since <RDD minus 2 years>, have you petitioned for a lawsuit or a divorce as a resident in another state? [radio button] Yes [radio button] No |
Conditions: | Always If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Since <RDD minus 2 years>, has your parent or guardian petitioned ...” |
Additional Text: | None |
Response Options: | As shown in Question Text. |
Hover Help: | [Spanish: "Haga clic en Yes si, desde <RDD minus 2 years>, <si usted/su padre o guarda> presentó una demanda o un divorcio como residente en un estado que no sea California. De lo contrario, haga clic en No."] |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | Required selection; else error message, “You must indicate whether or not <you have/your parent or guardian has> petitioned for a lawsuit or a divorce as a resident in another state.” |
Notes: | None |
Data Element: | residency: ca_outside_lawsuit |
Lawsuit Outside California: Year
Data Element: | ca_outside_lawsuit_year |
Description: | Most recent year indicated for petitioning for a lawsuit or a divorce as a resident in another state |
Format, Length: | Date, 10 (yyyy-mm-dd download format) |
Values: | UI entry: Integer, between <RDDyear> and <RDDYear – 2> |
Allows Null: | Yes |
Default: | None |
Usage: | |
Notes: | residency table |
Xap Field: | yearLawsuitOutsideCalifornia |
Revision Log: | ~~ |
Question Text: | If Yes, what was the most recent year? [textbox] |
Conditions: | Appears only if Lawsuit Outside California is ‘Yes’. |
Additional Text: | None |
Response Options: | Four-digit year. |
Hover Help: | "Enter the year in which <you/your parent or guardian> most recently petitioned for a lawsuit or a divorce as a resident in a state other than California." [Spanish: "Entre el año en que <usted/su padre o guarda> más recientemente presentó una demanda o un divorcio como residente en un estado que no sea California."] |
Pop-Up Help: | None |
Field Error Check: | Must be year portion of <RDD>, <RDD minus 1 year>, or <RDD minus 2 years>; else error message, “For ‘<have you/has your parent or guardian> petitioned for a lawsuit or a divorce as a resident in another state’, the year must be between <RDDyear minus 2 years> and <RDDyear>.” |
Page Error Check: | Required response; else error message, “You must specify the year that <you/your parent or guardian> petitioned for a lawsuit or a divorce as a resident in another state.” |
Notes: | None |
Data Element: | residency: ca_outside_lawsuit_year |
Residency Status
Data Element: | res_status |
Description: | Applicant’s preliminary residency status as calculated by the Residency Algorithm in the Appendix A: Submission Calculations Service. |
Format, Length: | bpchar, 1 |
Values: | 1 = Resident 2 = Possible Resident. Documentation Required. 3 = Non-resident |
Allows Null: | No |
Default: | None |
Usage: | Used by colleges as a preliminary indication of residency. Colleges have the responsibility to obtain appropriate documentation and make a final residency determination for every applicant. |
Notes: | Populated by Submission Calculation Service (Residency Algorithm); for details, see Appendix A: Submission Calculation Service specification. residency table Appendix A: Submission Calculation Logic & Residency Algorithm on page 197 |
Residency Status Change
Data Element: | res_status_change |
Description: | Whether applicant’s Residency Status is different than the Residency Status calculated in previous application(s) |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No |
Allows Null: | No |
Default: | None |
Usage: | Alerts colleges to potential residency fraud. |
Notes: | Populated by Submission Calculation Service (Residency Algorithm); for details, see Appendix A: Submission Calculation Service specification. This data element may evolve as college needs regarding residency change information are explored further. residency table Appendix A: Submission Calculation Logic & Residency Algorithm on page 197 |
Previous Residency Date
Data Element: | res_prev_date |
Description: | Date of most recent application when applicant’s Residency Status was different than the Residency Status calculated for this application |
Format, Length: | date, 10 (yyyy-mm-dd download format) |
Values: | Valid date |
Allows Null: | Yes |
Default: | None |
Usage: | Alerts colleges to potential residency fraud. |
Notes: | Populated by Submission Calculation Service (Residency Algorithm); for details, see Appendix A: Submission Calculation Service specification. This data element may evolve as college needs regarding residency change information are explored further. residency table Appendix A: Submission Calculation Logic & Residency Algorithm on page 197 |
Residency Integrity Flags
Data Element: | integrity_flags |
Description: | Residency Integrity Flags generated by the Residency Algorithm in the Submission Calculation Service |
Format, Length: | character varying(255) |
Values: | 2-character codes, comma-delimited. Codes are sorted in ascending order. For valid codes and their meanings, see the table of Residency Integrity Flags in Table E: Residency Integrity Flags in Appendix A: Submission Calculation Service specification. |
Allows Null: | No |
Default: | None |
Usage: | Alerts college A&R personnel to reasons for the preliminary residency and ineligibility calculations and/or to responses that might require documentation or warrant special attention when making a final residency determination or admission decision. |
Notes: | Populated by Submission Calculation Service (Residency Algorithm); for details, see Appendix A: Submission Calculation Logic & Residency Algorithm. residency table Appendix A: Submission Calculation Logic & Residency Algorithm on page 197 |
Ineligible for Admission Flag
Data Element: | adm_ineligible |
Description: | Applicant’s eligibility for admission as calculated by the Submission Calculation Service |
Format, Length: | smallint, 1 |
Values: | 0 = Applicant is eligible for admission 1 = Applicant is ineligible for admission 2 = Applicant is HS grad under 18 as of RDD; eligible for admission with documentation |
Allows Null: | No |
Default: | None |
Usage: | Alerts colleges to applicants who are not, or may not be, eligible for admission. |
Notes: | Populated by Submission Calculation Service; for details, see Appendix A: Submission Calculation Service specification. residency table Appendix A: Submission Calculation Logic & Residency Algorithm on page 197 |
Eligible for AB540 Waiver
Data Element: | elig_ab540 |
Description: | Whether applicant is eligible for AB540 tuition waver, as determined by the Submission Calculation Service |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No |
Allows Null: | No |
Default: | None |
Usage: | Alerts college Financial Aid personnel to applicants who are eligible for AB540 tuition waiver. Determines whether AB540 information and links are included on the Links and Opportunities page. |
Notes: | Populated by Submission Calculation Service; for details, see CCCApply Appendix A: Submission Calculations Service specification. residency table Appendix A: Submission Calculation Logic & Residency Algorithm on page 197 |
Xap Field: | eligibleForWaiver |
Revision Log: | ~~ |
Financial Aid Referral Flag
Data Element: | fin_aid_ref | |
Description: | Whether applicant has indicated interest in or need for financial aid, as determined by the Submission Calculation Service. | |
Format, Length: | boolean, 1 | |
Values: | 1 = True/Yes 0 = False/No | |
Allows Null: | No | |
Default: | None | |
Usage: | Alerts college Financial Aid personnel to applicants who are interested in financial aid. Determines whether FAFSA link (and later, BOGFW link) is included on the Links and Opportunities page. | |
Notes: | residency table Appendix A: Submission Calculation Logic & Residency Algorithm on page 197 | |
Xap Field: | financialAidReferral | |
Revision Log: | ~~ | |
Needs & Interests
The tables in this section show the data element information for the fields that are populated on the Needs & Interests tab of the CCCApply standard application.
Once an applicant submits their application, their responses to the needs and interests questions are mapped and stored in the submitted_application table (i.e. a response to “Comfortable with English” is stored in the comfortable_english column) and are available for download.
Summary Table of Needs & Interests Values
The values below represent a summary of the values stored in the system ni_id table as displayed below. Once an applicant's application is submitted, responses to these questions are stored and available for download from the single submitted_application table. For details on the values you can download, see the tables in that follow the table below.
ni_id | Question |
1 | Comfortable with English = No |
2 | Financial Aid Info = Yes |
3 | Receiving TANF, SSI, General Assistance = Yes |
4 | Foster Youth = Yes (Question removed from application – October 2014) |
5 | Athletic Interest = Yes, including intercollegiate |
6 | Athletic Interest = Yes, but not intercollegiate |
7 | Academic Counseling/Advising = Yes (checked) |
8 | Basic Skills (reading, writing, math) = Yes (checked) |
9 | CalWorks = Yes (checked) |
10 | Career Planning = Yes (checked) |
11 | Child Care = Yes (checked) |
12 | Counseling - Personal = Yes (checked) |
13 | DSPS - Disabled Student Programs and Services = Yes (checked) |
18 | Employment Assistance = Yes (checked) |
14 | EOPS - Extended Opportunity Programs and Services = Yes (checked) |
15 | ESL - English as a Second Language = Yes (checked) |
16 | Health Services = Yes (checked) |
17 | Housing Information = Yes (checked) |
19 | Online Classes = Yes (checked) |
20 | Re-entry Program (after 5 years out) = Yes (checked) |
21 | Scholarship Information = Yes (checked) |
22 | Student Government = Yes (checked) |
23 | Testing, Assessment, Orientation = Yes (checked) |
24 | Transfer Information = Yes (checked) |
25 | Tutoring Services = Yes (checked) |
26 | Veterans Services = Yes (checked) |
Comfortable With English
Data Element: | comfortable_english |
Description: | Question to assess applicant's comfort level in reading/writing English. |
Format: | boolean |
Length: | Downloads as "t" or "f" when format length is set to 1, or "true" or "false" if format length is set to 5 |
Question Text: | Are you comfortable reading and writing English? Yes [radio button, clearable] No [radio button, clearable] |
Conditions: | Always |
Additional Text: | None |
Response Options: | Yes radio button, No radio button, or no selection |
Allows Null: | Yes |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | None |
Notes: | In 2003, the current form of this question was implemented to better identify applicants who might need language assistance. Response is optional. |
XAP Field: | |
Revision Log: |
Financial Aid Information
Data Element: | financial_assistance |
Description: | Question that allows applicant to express interest in receiving information about money for college |
Format: | boolean |
Length: | Downloads as "t" or "f" when format length is set to 1, or "true" or "false" if format length is set to 5 |
Question Text: | Are you interested in receiving information about money for college? Yes [radio button, clearable] No [radio button, clearable] |
Conditions: | Always |
Additional Text: | None |
Response Options: | Yes radio button, No radio button, or no selection |
Allows Null: | Yes |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | None |
Notes: | None |
XAP Field: | |
Revision Log: |
Receiving TANF, SSI, General Assistance
Data Element: | tanf_ssi_ga |
Description: | To assess if the applicant is currently receiving TANF/CalWORKs, SSI, or General Assistance |
Format: | boolean |
Length: | Downloads as "t" or "f" when format length is set to 1, or "true" or "false" if format length is set to 5 |
Question Text: | Are you receiving TANF/CalWORKs, SSI, or General Assistance? Yes [radio button, clearable] No [radio button, clearable] |
Conditions: | Always |
Additional Text: | None |
Response Options: | Yes readio button, No radio button, or no selection |
Allows Null: | Yes |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | None |
Notes: | None |
XAP Field: | |
Revision Log: |
Athletic Interest: Intercollegiate
Data Element: | athletic_intercollegiate |
Description: | On the Needs & Interests tab (Athletic Interest field group) applicant can indicate interest in intercollegiate team sports participation |
Format: | boolean |
Length: | Downloads as "t" or "f" when format length is set to 1, or "true" or "false" if format length is set to 5 |
Question Text: | Are you interested in participating in a sport while attending college? [radio button] Yes, I am interested in one or more sports, including the possibility of playing on an intercollegiate team. |
Conditions: | Always |
Additional Text: | (Your response does not obligate you in any way. To be eligible to participate on an intercollegiate team, you must be enrolled in at least 12 units.) |
Response Options: | Yes radio button or no selection |
Allows Null: | Yes |
Pop-Up Help: | Levels of College Sports California Community Colleges generally offer the opportunity to participate in sports at various levels, though not all colleges offer sports at all levels. At the highest level, intercollegiate teams (also called ‘varsity teams’) represent the college in competition against other colleges, typically in conferences under the authority of the California Community Colleges Athletic Association (CCCAA). For more about this level of college sports, see the website for the CCCAA (www.cccaasports.org{hyperlink opens in another tab/window}) and the college’s website. {Replace ‘the college’s website’ with ‘the <CollegeName> website (<URL/hyperlink>)’ if feasible}. Intramural and club sports allow students to participate at a less rigorous level than the intercollegiate teams and/or to play a sport for which the college does not field an intercollegiate team. In intramural sports, several teams from the college play each other in college-sponsored competitions. In club sports, the clubs are sanctioned by the college but make or find their own opportunities for competition. |
Field Error Check: | None |
Page Error Check: | Required selection of one radio button in the Athletic Interest field group; else error message, “You must specify whether or not you are interested in participating in a sport while attending college.” |
Notes: | This question is intended to be used as a key for determining which applicants will receive a Title IX survey from the college. |
XAP Field: | |
Revision Log: |
Athletic Interest: Intramural
Data Element: | athletic_intramural |
Description: | On the Needs & Interests tab (Athletic Interest field group) applicant can indicate interest in intramural sports participation. |
Format: | boolean |
Length: | Downloads as "t" or "f" when format length is set to 1, or "true" or "false" if format length is set to 5 |
Question Text: | Are you interested in participating in a sport while attending college? [radio button] Yes, I am interested in intramural or club sports, but not in playing on an intercollegiate team. |
Conditions: | Always |
Additional Text: | (Your response does not obligate you in any way. To be eligible to participate on an intercollegiate team, you must be enrolled in at least 12 units.) |
Response Options: | Yes radio button or no selection |
Allows Null: | Yes |
Pop-Up Help: | Levels of College Sports California Community Colleges generally offer the opportunity to participate in sports at various levels, though not all colleges offer sports at all levels. At the highest level, intercollegiate teams (also called ‘varsity teams’) represent the college in competition against other colleges, typically in conferences under the authority of the California Community Colleges Athletic Association (CCCAA). For more about this level of college sports, see the website for the CCCAA (www.cccaasports.org{hyperlink opens in another tab/window}) and the college’s website. {replace ‘the college’s website’ with ‘the <CollegeName> website (<URL/hyperlink>)’ if feasible} Intramural and club sports allow students to participate at a less rigorous level than the intercollegiate teams and/or to play a sport for which the college does not field an intercollegiate team. In intramural sports, several teams from the college play each other in |
college-sponsored competitions. In club sports, the clubs are sanctioned by the college but make or find their own opportunities for competition. | |
Field Error Check: | None |
Page Error Check: | Required selection of one radio button in the Athletic Interest field group; else error message, “You must specify whether or not you are interested in participating in a sport while attending college.” |
Notes: | This question is intended to be used as a key for determining which applicants will receive a Title IX survey from the college. |
XAP Field: | |
Revision Log: |
Athletic Interest: No
Data Element: | athletic_not_interested |
Description: | On the Needs & Interests (Athletic Interest field group) applicant can indicate they are not interested in sports participation. |
Format: | boolean |
Length: | Downloads as "t" or "f" when format length is set to 1, or "true" or "false" if format length is set to 5 |
Question Text: | Are you interested in participating in a sport while attending college? [radio button] No, I am not interested in participating in a sport (beyond taking P.E. classes). |
Conditions: | Always |
Additional Text: | (Your response does not obligate you in any way. To be eligible to participate on an intercollegiate team, you must be enrolled in at least 12 units.) |
Response Options: | No radio button or no selection |
Allows Null: | Yes |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | Required selection of one radio button in the Athletic Interest field group; else error message, “You must specify whether or not you are interested in participating in a sport while attending college.” |
Notes: | This question is intended to be used as a key for determining which applicants will receive a Title IX survey from the college. |
XAP Field: | |
Revision Log: |