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 |
Table of Contents | ||||
---|---|---|---|---|
|
Info |
---|
RECORDING - CCCApply Redesign Low-Hanging Fruit Changes #2: Listen to CCCApply Product Manager, Patty Donohue, walk through the second series of "low-hanging fruit" changes,"CCCApply Redesign Low-Hanging Fruit #2" on December 18, 2018. This set of changes is part of the CCCApply Redesign Project. |
Change Request Approval Form: Change Request Approval Form: CCCApply Low-Hanging Fruit #2
Change Approval Slides PPT: CCCApply Redesign Low-Hanging Fruit #2
Business Need
As part of the CCCApply Redesign Project Dashboard, under the direction of the CCCCO, continue to streamline the CCCApply application with more "low-hanging fruit" changes including implementing skip logic and removing questions, including:
- Revise & Remove Questions from the Residency Page
- Remove/Hide three Special Residency questions by default
- Reorder questions on the Residency Page
- Reformat the Out-of-State Activities question
- Revise & Remove Questions from the Education Page
- Remove/Hide college questions on the Education page by default
Add Logic in the College Enrollment Status field to hide/show college questions based on enrollment status
- Revise & Remove Questions from the Needs & Interests Page
- Remove questions on the Needs & Interests page for all users
- Reconfigure the Athletic Interest question to be “opt-in” for colleges
Info |
---|
CCCApply Redesign ProjectStudent-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 Dashboard Stakeholders: CCCApply Redesign Workgroup & Sub-Committees, CCCApply User Workgroup (formerly known as the Steering Committee) |
Risks
Scope. Schedule and Budget Deadlines
In order to include one or more of the proposed low-hanging fruit changes in one of the scheduled releases for CCCApply FY18-19, all business requirements must be reviewed, approved in writing by the Requirements Deadlines schedule. Approved requirements will then be estimated (sized) and prioritized against the FY18-19 work plan and budget for development and release.
Change Request Approval Process
Info |
---|
RECORDING - CCCApply Redesign Low-Hanging Fruit Changes #2: Listen to CCCApply Product Manager, Patty Donohue, walk through the second series of "low-hanging fruit" changes,"CCCApply Redesign Low-Hanging Fruit #2" on December 18, 2018. This set of changes is part of the CCCApply Redesign Project. Warning: There is a bit of annoying audio fluctuations in the recording. |
Proposed Change Requirements
The tables below outline individual change requests submitted for approval to the CCCApply Redesign Workgroup.
Approved changes must meet the requirements deadline schedule for designated release.
Revise & Remove Questions from the Residency Page
# | Change Request Description | Proposed Solution / Requirements | Need Requirements |
---|---|---|---|
1 | Remove/Hide the first three questions from the Special Residency section for all users by defaultWhy hide these questions?
| REQUIREMENTS:
If the user has reported one or more Out-of-State Activities within 2 years of the RDD, these hidden questions will be displayed and a response is required. If NO out-of-state activities are reported in the previous section, then do not show the hidden questions and store a "Null" value in the database for each of them. | 2018 Data *Based on 2,451,319 applications submitted by 12/15/18 |
Additional Change Specifications:
Background Info The benefit of these special residency questions to the user and the college, is to provide a user who is possibly not a California resident a special residency offer "possible non-resident" users with who are at risk of being offer special consideration are optional (not required) and pertain to the user if they are first identified as a non-resident due to their response in the out-of-state activities section. The Homeless Youth and the Foster Youth questions ALWAYS display and each requires a response by all users. NOTE: There is no change proposed for the Homeless Youth or the Foster Youth questions other than they are included in the reordering of the questions on the page |
Benefit: Alternative Solution: IF this request is declined, consider making these three questions Optional by changing the Yes/No radio button format to optional checkboxes. Null is allowed already | ||
2 | Reorder the questions on the Residency Page for all users |
The new order would be:
| |
Current Residency Page - Top Section Current Residency Page - Bottom | |||
This is how it looks with the two sections switched | |||
3 | Revise the "Out of State Activities" SectionSkip logic to display first three Special Residency questions if out-of-state activity is Yes within 2 years |
Out-of-State Year Fields All four existing OOS data fields and conditional OOS Year fields should not change with this change request. The validation logic to display the year fields will persist, as well as all existing text, timing, IF user selects one or more OOS activities (= True/Yes), then display the corresponding "Year" text input field.
Background Information (Residency Logic)
| Development estimating notes: If we change the format of each OOS question from radio buttons to checkboxes - keep all existing conditions and validation - this change has been estimated to be MEDIUM For Reference Only: In 2018, the percentages of Yes responses across all Out-of-State activities: <ca_outside_tax> = 1.5% Average = 1% of applicants are reporting an out-of-state activity. Wow. Downloads Each checkbox response option should be optional and the default set to No. Store Null values for each unchecked checkbox. The out-of-state activity questions each have a corresponding conditional question/field that appears when selected to collect additional information about the date (year) that the activity occurred. This will not change in the new combined question format. |
Mockup of the Current (Legacy) Out-of-State Activities Section Currently, there four Yes/No questions that must be answered by all users. | |||
Mockup of the NEW Proposed Out-of-State Activities Question & Layout The new format includes one question with four, optional checkbox response options. The allows the user to skip the question unless it pertains to them, eliminating the "required response" requirement for each radio button. This is the new proposed layout, which only requires a response IF the user has one or more out-of-state activities to report. Mockup of the NEW, Proposed Out-of-State Activities - Year Fields If the user selects one or more out-of-state activities (= Yes/True), Then display the corresponding "Year" textbox and require a response. All current data field conditions, logic, and onscreen text will persist in the new proposed question/format. Mockup of the NEW, Proposed Out-of-State Activities - Parent/Guardian Language Example of the new, proposed Out-of-State Activity question with text presented for a minor. |
Revise & Remove Questions from the Education Page
# | Change Request Description | Proposed Solution / Requirements | Additional Information | ||
---|---|---|---|---|---|
1 | Remove/Hide College Questions on the Education Page for All Users by default Why? The Education page is the most complex of all the Standard Application page - skip logic could be implemented to lessen complexity where possible. First-time students in college (after leaving high school) are not required to answer, or see, the College Education Level and/or the Colleges/Universities Attended Section by default on the Education page. | Hide the following questions on the Education Page for all users by default:
Therefore, only the following questions/sections are displayed to all users by default:
| |||
2 | Add skip logic to the College Enrollment Status field to show/hide college questions based on enrollment status |
"1 = First-time student in college (after leaving high school)" THEN, DO NOT DISPLAY:
ELSE, display college questions and enforce all existing conditions, field logic, error validation. 3. IF the college enrollment status is one of the following: 2 = Transfer student from another college (Keep existing logic) 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 THEN, DISPLAY the College Education Level & Colleges Attended (Col1-4) and enforce all current conditions, field logic, and error validation. | In 2018*, College 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 | ||
| |||||
3 | Revise skip logic validation the College Enrollment Status field to hide/show college questions for dual enrollment students Do not display college questions to dual enrollment students based on response to College Enrollment Status. |
Note - if approved this would expand the logic proposed in change request above (#2 in the Education Page changes above) to:
Display Confirmation Pop-Up Box: “Is this the first time you have attended college while in high school (or lower grades)?" [radio button] "Yes, I confirm that I have attended college while still in high school (or lower grade) before.” [radio button] "No, I have never attended college while in high school (or lower grade) before." If Yes, DO NOT DISPLAY the college education or colleges attended section. If No, then DISPLAY the questions. | ANOTHER POSSIBLE CHANGE not included in the current change request |
Proposed Changes to the Enrollment Status
CURRENT DATA ELEMENT TABLE | PROPOSED CHANGES TO DATA ELEMENT | |
---|---|---|
Data Element: | enroll_status | enroll_status |
Description: | Applicant’s response to College Enrollment Status question | Applicant’s response to College Enrollment Status question |
Format, Length: | bpchar, 1 | 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 | 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 | No |
Default: | None | None |
Usage: | Correlates to MIS SB15 | Correlates to MIS SB15 |
Notes: | education table | education table |
Xap Field: | enrollmentStatusOneChar | enrollmentStatusOneChar |
Revision Log: | ~~ | March 2019 |
Question Text: | As of <RDD>, I will have the following college enrollment status: [menu] | As of <RDD>, I will have the following college enrollment status: [menu] |
Conditions: | Always | 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 | 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 | None |
Field Error Check: | None | None |
Page Error Check: | Required selection; else error message, “You must select your College Enrollment Status.” | 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. | 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 "2 = First time at this college; have attended another college" or "3 = Returning student to this college after absent for a main term" THEN display College Education Status and Colleges/Universities Attended" sections and require responses, ELSE do not display college questions. 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 “Y = Enrolling in high school (or lower grades) and college at the same time”, applicant is prompted to confirm if this is their first time in college or not: “Have you previously attended college while also enrolled in high school (or lower grades) before?" 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.” If College Enrollment Status is “Y = 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. | 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 | education: enroll_status |
Higher Education Level (College)
aka "College Education Level"
CURRENT DATA ELEMENT TABLE | PROPOSED CHANGES TO DATA ELEMENT | |
---|---|---|
Data Element: | higher_edu_level | higher_edu_level |
Description: | Applicant’s response to Higher Education Level question | Applicant’s response to Higher Education Level question |
Format, Length: | bpchar, 1 | bpchar, 1 |
Values: | X = No degree 7 = Received an associate degree 8 = Received a bachelor’s degree or higher Null = No response | X = No degree 7 = Received an associate degree 8 = Received a bachelor’s degree or higher Null = No response |
Allows Null: | Yes | Yes |
Default: | None | None |
Notes: | ||
Xap Field: | higherEdLevel | higherEdLevel |
Revision Log: | March 2019 | |
Question Text: | College Education Level as of <RDD> [menu] | 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’. | Displayed unless Enrollment Status is ‘1 = First-time student in college (after leaving high school)" OR "Y - Enrolling in high school (or lower grade) and college at the same time’. |
Additional Text: | None | None |
Response Options: | X = No degree 7 = Received an associate degree 8 = Received a bachelor’s degree or higher <null> No response | X = No degree 7 = Received an associate degree 8 = Received a bachelor’s degree or higher <null> No response |
Pop-Up Help: | None | None |
Field Error Check: | None | 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.” | 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 | 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 | education: higher_edu_level |
Number of Colleges Attended
Data Element: | college_count | college_count |
Description: | Applicant’s response to Number of Colleges Attended question | Applicant’s response to Number of Colleges Attended question |
Format, Length: | smallint | smallint |
Values: | 0 = None 1 = 1 2 = 2 3 = 3 4 = 4 5 = 5 or more | 0 = None 1 = 1 2 = 2 3 = 3 4 = 4 5 = 5 or more |
Allows Null: | No | No |
Default: | None | None |
Notes: | education table | education table |
Xap Field: | moreThanFourColleges | moreThanFourColleges |
Revision Log: | ~~ | March 2019 |
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 | 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 | Displayed UNLESS Enrollment Status is ‘1 = First-time student in college (after leaving high school)" OR "Y - Enrolling in high school (or lower grade) and college at the same time’. |
Additional Text: | If ‘5 or more’ is selected: Instructions TBD | If ‘5 or more’ is selected: Instructions TBD |
Response Options: | As shown in Question Text. | As shown in Question Text. |
Pop-Up Help: | None | None |
Field Error Check: | None | 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. | 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. | 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). |
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 | college_count |
Remove Questions from the Needs & Interests Page
# | Description | Proposed Solution / Requirements | Need Requirements |
---|---|---|---|
1 | Remove questions from the Needs & Interests page for all users by default | ||
A | Remove the "Are you comfortable reading and writing English?" question from the Needs & Interests page for all users |
| Should this question also be removed from the International Application? |
B | Remove the "Financial Assistance" section and the "Are you interested in receiving information about money for college? question from the Needs & Interests page for all users |
| Should these questions also be removed from the International Application? |
C | Remove the"Are you receiving TANF/CalWorks, SSI, or General?" question from the Needs & Interests page for all users |
| Should these questions also be removed from the International Application? |
2 | Reconfigure the Athletic Interest question to be an "opt-in" question for some college usersin 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. |
Proposed Needs & Interests Questions Being Removed |
Note |
---|
Low-Hanging Fruit Changes This is the second round of short-term, low-hanging fruit changes approved as part of the CCCApply Redesign Project Dashboard, 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 production version of CCCApply in FY18-19. |
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 1528, 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-16, 2019 | June 28, 2019 |
Out-of-Scope Items
Revise the Skip Logic Validation in the College Enrollment Status Field for Dual Enrollment Students
SEE DETAILS in the changes to the Education page section above.
This requirement would add an additional value (and "Y = Enrolling in high school (or lower grade) and college at the same time" to the new validation logic change being made to the College Enrollment Status field to hide/show "college" sections based on applicant's "Enrollment Status"
Current Data Dictionary Elements
Note |
---|
Expand the links to see excerpts from the 2018 CCCApply Data Dictionary. These are provided for reference purposes to show the current (pre-change) data specifications. |
Residency Page Data Elements
The tables in this section show the fields that are populated from the Residency tab of the CCCApply standard application.
title | Click here to expand CA Residency Fields... |
---|
California Resident for Two Years
Data Element:
ca_res_2_years
ca_res_2_years
Description:
Applicant’s response regarding residence in California since two years before RDD.
Applicant’s response regarding residence in California since two years before RDD.
Format, Length:
boolean, 1
boolean, 1
Values:
1 = True/Yes
0 = False/No
1 = True/Yes
0 = False/No
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
NOTE: The Residency page does not appear on the Application if the Citizenship Status response makes residency unnecessary.
NOTE: The Residency page does NOT appear in the Non-Credit version of the Standard Application (nor does the Citizenship & Military page).
residency table
NOTE: The Residency page does not appear on the Application if the Citizenship Status response makes residency unnecessary.
NOTE: The Residency page does NOT appear in the Non-Credit version of the Standard Application (nor does the Citizenship & Military page).
residency table
Question Text:
Have you lived in California continuously since <RDD minus 2 years>? [radio button] Yes [radio button] No
Have you lived in California continuously since <RDD minus 2 years>? [radio button] Yes [radio button] No
Conditions:
Always appears if Residency page is shown to the applicant (see Notes)
If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Has your parent or guardian lived in California …”
Always appears if Residency page is shown to the applicant (see Notes)
If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Has your parent or guardian lived in California …”
Additional Text:
None
None
Response Options:
As shown in Question Text.
As shown in Question Text.
Pop-Up Help:
Residence in California
When determining the length of time lived continuously in California, disregard absences from California for education, business, or vacation that did not affect your intent to maintain residency in California and did not involve activities as a resident of another state.
Residence in California
When determining the length of time lived continuously in California, disregard absences from California for education, business, or vacation that did not affect your intent to maintain residency in California and did not involve activities as a resident of another state.
Field Error Check:
None
None
Page Error Check:
Required response; else error message, “You must specify whether or not <you have/your parent or guardian has> lived in California since <RDD minus 2 years>.”
Required response; else error message, “You must specify whether or not <you have/your parent or guardian has> lived in California since <RDD minus 2 years>.”
Notes:
None
None
Data Element:
residency: ca_res_2_years
residency: ca_res_2_years
State College Employee
Data Element:
ca_college_employee
ca_college_employee
Description:
Whether applicant is a full-time employee, or spouse/dependent of a full-time employee, of a state college
Whether applicant is a full-time employee, or spouse/dependent of a full-time employee, of a state college
Format, Length:
boolean, 1
boolean, 1
Values:
1 = True/Yes
0 = False/No
1 = True/Yes
0 = False/No
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
residency table
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
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 ...”
Displays if "Out-of-State Activities" is not empty
If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Is your parent or guardian a full-time employee ...”
Additional Text:
None
None
Response Options:
As shown in Question Text.
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."]
"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
None
Field Error Check:
None
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.”
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
None
Data Element:
residency: ca_college_employee
residency: ca_college_employee
Public School Employee
Data Element:
ca_school_employee
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.
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
boolean, 1
Values:
1 = True/Yes
0 = False/No
1 = True/Yes
0 = False/No
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
residency table
residency table
Xap Field:
publicSchoolCredEmployee
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
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
Displays if "Out-of-State Activities" is not empty
Additional Text:
None
None
Response Options:
As shown in Question Text.
As shown in Question Text.
Pop-Up Help:
None
None
Field Error Check:
None
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.”
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
None
Data Element:
residency: ca_school_employee
residency: ca_school_employee
Seasonal Agricultural Worker
Data Element:
ca_seasonal_ag
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.
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
boolean, 1
Values:
1 = True/Yes
0 = False/No
1 = True/Yes
0 = False/No
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
residency table
residency table
Xap Field:
agriculturalEmployee
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
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 ...”
Displays only if "Out-of-State Activities" is not empty
If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Has your parent or guardian been employed ...”
Additional Text:
None
None
Response Options:
As shown in Question Text.
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."]
[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
None
Field Error Check:
None
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.”
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
None
Data Element:
residency: ca_seasonal_ag
residency: ca_seasonal_ag
Homeless Youth
Data Element:
homeless_youth
homeless_youth
Description:
Whether applicant has been determined to be a homeless youth at any time within the last 24 months.
Whether applicant has been determined to be a homeless youth at any time within the last 24 months.
Format, Length:
boolean, 1
boolean, 1
Values:
1 = True/Yes
0 = False/No
1 = True/Yes
0 = False/No
Allows Null:
Yes
Yes
Default:
If <no_perm_address_homeless> = 1 (True/Yes) then set <homeless_youth> to Yes.
If <no_perm_address_homeless> = 1 (True/Yes) then set <homeless_youth> to Yes.
Notes:
residency table
residency table
Question Text:
At any time in the last 24 months were you determined to be homeless by any of the following?
- High school or school district homeless liaison
- Emergency shelter or transitional housing program
- Director of a runaway or homeless youth basic center or transitional living program
[radio button] Yes [radio button] No
At any time in the last 24 months were you determined to be homeless by any of the following?
- High school or school district homeless liaison
- Emergency shelter or transitional housing program
- Director of a runaway or homeless youth basic center or transitional living program
[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.
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
None
Response Options:
As shown in Question Text.
As shown in Question Text.
Field Error Check:
None
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.”
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
Added in March 2017 per AB 801 – Homeless Youth
Data Element:
residency: homeless_youth
residency: homeless_youth
Foster Youth in California
Data Element:
ca_foster_youth
ca_foster_youth
Description:
Whether applicant is a current or former Foster Youth in California and under 20 years of age at RDD.
Whether applicant is a current or former Foster Youth in California and under 20 years of age at RDD.
Format, Length:
boolean, 1
boolean, 1
Values:
The calculation for how to set this field based on the foster_youth_status field.
Value
Meaning
Logic
1
AB669 Eligibility = Yes
(foster_youth_status=1 OR =2 OR =6) AND (RDD* minus Birthdate < 20 years)
0
AB669 Eligibility = No
Logic: (foster_youth_status=0 OR =3 OR =4 OR =5) OR (RDD* minus Birthdate is >= 20 years)
* RDD = Residency Determination Date: 1 day before term: date_start
The calculation for how to set this field based on the foster_youth_status field.
Value
Meaning
Logic
1
AB669 Eligibility = Yes
(foster_youth_status=1 OR =2 OR =6) AND (RDD* minus Birthdate < 20 years)
0
AB669 Eligibility = No
Logic: (foster_youth_status=0 OR =3 OR =4 OR =5) OR (RDD* minus Birthdate is >= 20 years)
* RDD = Residency Determination Date: 1 day before term: date_start
Allows Null:
Yes
Yes
Default:
None
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.
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.
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
under20FosterYouthCA
Revision Log:
March 31, 2016
March 31, 2016
Response Options:
Pop-Up Help:
Response Options:
None
Field Error Check:
None
None
Notes:
None
This database field is still being populated.
residency table
Data Element:
This database field is still being populated.
residency table
residency: ca_foster_youth
Foster Youth Status
Data Element:
foster_youth_status
foster_youth_status
Description:
Indicates the Foster Youth status of the applicant based on their screen input.
Indicates the Foster Youth status of the applicant based on their screen input.
Format, Length:
char 1
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.
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
No
Default:
None
None
Usage:
Notes:
residency table
residency table
Xap Field:
fosterYouthStatus
fosterYouthStatus
Revision Log:
March 31, 2016
March 31, 2016
Question Text:
Have you ever been in court-ordered foster care?
(See additional text below)
Have you ever been in court-ordered foster care?
(See additional text below)
Conditions:
Always
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.
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.
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.”
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.”
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:
- Aged Out/Emancipated
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.
- Exited the foster care system before my 18th birthday
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.
- Not Sure
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.
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:
- Aged Out/Emancipated
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.
- Exited the foster care system before my 18th birthday
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.
- Not Sure
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.
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.
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.
Foster Youth Priority
Data Element:
foster_youth_priority
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.
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
boolean, 1
Values:
AFTER the foster_youth_status field has been set, set the value of foster_youth_priority as follows:
Value | Meaning | Logic |
1 | AB194 Eligibility = Yes | (foster_youth_status=1 OR =2 OR =3 OR =4 OR =6) AND (RDD* minus Birthdate < 25 years) THEN set Flag 71 |
0 | AB194 Eligibility = No | (foster_youth_status =0 OR =5) OR (RDD* minus Birthdate is >= 25 years) |
* RDD = Residency Determination Date: 1 day before term: date_start |
AFTER the foster_youth_status field has been set, set the value of foster_youth_priority as follows:
Value | Meaning | Logic |
1 | AB194 Eligibility = Yes | (foster_youth_status=1 OR =2 OR =3 OR =4 OR =6) AND (RDD* minus Birthdate < 25 years) THEN set Flag 71 |
0 | AB194 Eligibility = No | (foster_youth_status =0 OR =5) OR (RDD* minus Birthdate is >= 25 years) |
* RDD = Residency Determination Date: 1 day before term: date_start |
Allows Null:
No
No
Default:
None
None
Usage:
Calculated result for AB194 eligibility.
This field triggers Integrity Flag 71 (the applicant is eligible for Foster Youth Priority registration) if the value after calculation = 1.
See Appendix A: Table E– Integrity Flags for specific language.
Calculated result for AB194 eligibility.
This field triggers Integrity Flag 71 (the applicant is eligible for Foster Youth Priority registration) if the value after calculation = 1.
See Appendix A: Table E– Integrity Flags for specific language.
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
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
fosterYouthPriority
Revision Log:
1/29/16
1/29/16
Foster Youth MIS
Data Element:
foster_youth_mis
foster_youth_mis
Description:
Derived field based on foster_youth_status.
Derived field based on foster_youth_status.
Format, Length:
boolean, 1
boolean, 1
Values:
AFTER the foster_youth_status field has been set, set the value of foster_youth_mis as follows:
Value | Meaning | Logic |
1 | MIS SG03 = 1 | foster_youth_status=1 OR =2 OR =3 OR =4 OR =5 |
0 | MIS SG03 = 0 | foster_youth_status=0 |
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.
AFTER the foster_youth_status field has been set, set the value of foster_youth_mis as follows:
Value | Meaning | Logic |
1 | MIS SG03 = 1 | foster_youth_status=1 OR =2 OR =3 OR =4 OR =5 |
0 | MIS SG03 = 0 | foster_youth_status=0 |
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
Yes
Default:
None
None
Usage:
Notes:
In CCCApply, this field is case sensitive (lower) = foster_youth_mis
residency table
In CCCApply, this field is case sensitive (lower) = foster_youth_mis
residency table
Xap Field:
fosterYouthMIS
fosterYouthMIS
Revision Log:
1/29/16
1/29/16
Declared Residency Outside California for Taxes
Data Element:
ca_outside_tax
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
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
boolean, 1
Values:
1 = True/Yes
0 = False/No
1 = True/Yes
0 = False/No
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
residency table
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
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 ...”
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
None
Response Options:
As shown in Question Text.
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."]
[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
None
Field Error Check:
None
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.”
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
None
Data Element:
residency: ca_outside_tax
residency: ca_outside_tax
Declared Residency Outside California for Taxes Year
Data Element:
ca_outside_tax_year
ca_outside_tax_year
Description:
Most recent year indicated for declaring residency in another state for state income tax purposes
Most recent year indicated for declaring residency in another state for state income tax purposes
Format, Length:
Date, 10 (yyyy-mm-dd download format)
Date, 10 (yyyy-mm-dd download format)
Values:
UI entry: Integer, between <RDDyear> and <RDDYear – 2>
UI entry: Integer, between <RDDyear> and <RDDYear – 2>
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
residency table
residency table
Question Text:
If Yes, what was the most recent year? [textbox]
If Yes, what was the most recent year? [textbox]
Conditions:
Appears only if Residency Outside California for Taxes is ‘Yes’.
Appears only if Residency Outside California for Taxes is ‘Yes’.
Additional Text:
None
None
Response Options:
Four-digit year.
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."]
"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
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>.”
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.”
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
None
Data Element:
residency: ca_outside_tax_year
residency: ca_outside_tax_year
Registered to Vote Outside California
Data Element:
ca_outside_voted
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
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
boolean, 1
Values:
1 = True/Yes
0 = False/No
1 = True/Yes
0 = False/No
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
residency table
residency table
Question Text:
Since <RDD minus 2 years>, have you registered to vote in another state?
[radio button] Yes [radio button] No
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?”
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
None
Response Options:
As shown in Question Text.
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.”]
[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
None
Field Error Check:
None
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.”
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
None
Data Element:
residency: ca_outside_voted
residency: ca_outside_voted
Registered to Vote Outside California: Year
Data Element:
ca_outside_voted_year
ca_outside_voted_year
Description:
Most recent year indicated for registering to vote in another state
Most recent year indicated for registering to vote in another state
Format, Length:
Date, 10 (yyyy-mm-dd download format)
Date, 10 (yyyy-mm-dd download format)
Values:
UI entry: Integer, between <RDDyear> and <RDDYear – 2>
UI entry: Integer, between <RDDyear> and <RDDYear – 2>
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
residency table
residency table
Question Text:
If Yes, what was the most recent year? [textbox]
If Yes, what was the most recent year? [textbox]
Conditions:
Appears only if Registered To Vote Outside California is ‘Yes’.
Appears only if Registered To Vote Outside California is ‘Yes’.
Additional Text:
None
None
Response Options:
Four-digit year.
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."]
"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
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>.”
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.”
Required response; else error message, “You must specify the year that
<you/your parent or guardian> registered to vote in another state.”
Notes:
None
None
Data Element:
residency: ca_outside_voted_year
residency: ca_outside_voted_year
Residence for College Outside California
Data Element:
ca_outside_college
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
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
boolean, 1
Values:
1 = True/Yes
0 = False/No
1 = True/Yes
0 = False/No
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
residency table
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
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 ...”
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
None
Response Options:
As shown in Question Text.
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."]
[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
None
Field Error Check:
None
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.”
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
None
Data Element:
residency: ca_outside_college
residency: ca_outside_college
Residence for College Outside California: Year
Data Element:
ca_outside_college_year
ca_outside_college_year
Description:
Most recent year indicated for declaring residency outside California to attend a college or university
Most recent year indicated for declaring residency outside California to attend a college or university
Format, Length:
Date, 10 (yyyy-mm-dd download format)
Date, 10 (yyyy-mm-dd download format)
Values:
UI entry: Integer, between <RDDyear> and <RDDYear – 2>
UI entry: Integer, between <RDDyear> and <RDDYear – 2>
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
residency table
residency table
Question Text:
If Yes, what was the most recent year? [textbox]
If Yes, what was the most recent year? [textbox]
Conditions:
Appears only if Residence for College Outside California is ‘Yes’.
Appears only if Residence for College Outside California is ‘Yes’.
Additional Text:
None
None
Response Options:
Four-digit year.
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."]
“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
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>.”
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.”
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
None
Data Element:
residency: ca_outside_college_year
residency: ca_outside_college_year
Lawsuit Outside California
Data Element:
ca_outside_lawsuit
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
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
boolean, 1
Values:
1 = True/Yes
0 = False/No
1 = True/Yes
0 = False/No
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Notes:
residency table
residency table
Xap Field:
lawsuitNonCAState
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
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 ...”
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
None
Response Options:
As shown in Question Text.
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."]
[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
None
Field Error Check:
None
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.”
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
None
Data Element:
residency: ca_outside_lawsuit
residency: ca_outside_lawsuit
Lawsuit Outside California: Year
Data Element:
ca_outside_lawsuit_year
ca_outside_lawsuit_year
Description:
Most recent year indicated for petitioning for a lawsuit or a divorce as a resident in another state
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)
Date, 10 (yyyy-mm-dd download format)
Values:
UI entry: Integer, between <RDDyear> and <RDDYear – 2>
Changes to Data Dictionary Elements
Note |
---|
Expand the links to see excerpts from the 2018 CCCApply Data Dictionary. These are provided for reference purposes to show the current (pre-change) data specifications. |
Residency Page Data Elements
The tables in this section show the fields that are populated from the Residency tab of the CCCApply standard application.
Expand | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||
California Resident for Two Years
|
Usage:
Notes:
residency table
residency table
Xap Field:
yearLawsuitOutsideCalifornia
yearLawsuitOutsideCalifornia
Revision Log:
~~
~~
Question Text:
If Yes, what was the most recent year? [textbox]
If Yes, what was the most recent year? [textbox]
Conditions:
Appears only if Lawsuit Outside California is ‘Yes’.
|
Four-digit year.
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."]
"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."]
|
None
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>.”
|
|
|
|
|
|
|
|
|
|
|
|
State College Employee
CURRENT DATA ELEMENT | PROPOSED CHANGES TO DATA ELEMENT | |
---|---|---|
Data Element: |
ca_college_ |
employee |
ca_college_ |
employee |
Description: |
Applicant’s preliminary residency status as calculated by the Residency Algorithm in the Appendix A: Submission Calculations Service.
Whether applicant is a full-time employee, or spouse/dependent of a full-time employee, of a state college | Whether applicant is a full-time employee, or spouse/dependent of a full-time employee, of a state college |
Format, Length: |
boolean, 1 |
boolean, 1 |
Values:
1 = Resident
2 = Possible Resident. Documentation Required.
3 = Non-resident
1 = Resident
2 = Possible Resident. Documentation Required.
3 = Non-residentValues: | 1 = True/Yes 0 = False/No | 1 = True/Yes 0 = False/No |
Allows Null: |
Yes |
Yes | ||
Default: | None | 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.
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
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
res_status_change
Description:
Whether applicant’s Residency Status is different than the Residency Status calculated in previous application(s)
Whether applicant’s Residency Status is different than the Residency Status calculated in previous application(s)
Format, Length:
boolean, 1
boolean, 1
Values:
1 = True/Yes
0 = False/No
1 = True/Yes
0 = False/No
Allows Null:
No
No
Default:
None
None
Usage:
Alerts colleges to potential residency fraud.
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
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
res_prev_date
Description:
Date of most recent application when applicant’s Residency Status was different than the Residency Status calculated for this application
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)
date, 10 (yyyy-mm-dd download format)
Values:
Valid date
Valid date
Allows Null:
Yes
Yes
Default:
None
None
Usage:
Alerts colleges to potential residency fraud.
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
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 Algorithmon page 197
Xap Field:
financialAidReferral
Revision Log:
: | ||
Notes: | residency table | 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 | 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 ...” | Displays if "Out-of-State Activities" is not empty If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Is your parent or guardian a full-time employee ...” |
Additional Text: | None | None |
Response Options: | As shown in Question Text. | 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."] | "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 | None |
Field Error Check: | None | 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.” | 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 | None |
Data Element: | residency: ca_college_employee | residency: ca_college_employee |
Public School Employee
CURRENT DATA ELEMENT | PROPOSED CHANGES TO DATA ELEMENT | |
---|---|---|
Data Element: | ca_school_employee | 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. | 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 | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No | 1 = True/Yes 0 = False/No |
Allows Null: | Yes | Yes |
Default: | None | None |
Usage: | ||
Notes: | residency table | residency table |
Xap Field: | publicSchoolCredEmployee | 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 | 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 | Displays if "Out-of-State Activities" is not empty |
Additional Text: | None | None |
Response Options: | As shown in Question Text. | As shown in Question Text. |
Pop-Up Help: | None | None |
Field Error Check: | None | 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.” | 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 | None |
Data Element: | residency: ca_school_employee | residency: ca_school_employee |
Seasonal Agricultural Worker
CURRENT DATA ELEMENT | PROPOSED CHANGES TO DATA ELEMENT | |
---|---|---|
Data Element: | ca_seasonal_ag | 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. | 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 | boolean, 1 |
Values: | 1 = True/Yes 0 = False/No | 1 = True/Yes 0 = False/No |
Allows Null: | Yes | Yes |
Default: | None | None |
Usage: | ||
Notes: | residency table | residency table |
Xap Field: | agriculturalEmployee | 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 | 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 ...” | Displays only if "Out-of-State Activities" is not empty If Subject to Parent/Guardian is ‘Yes’, question text will begin: “Has your parent or guardian been employed ...” |
Additional Text: | None | None |
Response Options: | As shown in Question Text. | 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."] | [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 | None |
Field Error Check: | None | 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.” | 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 | None |
Data Element: | residency: ca_seasonal_ag | residency: ca_seasonal_ag |
Education Data Dictionary Elements
Enrollment Status
Data Element: | enroll_status | enroll_status |
Description: | Applicant’s response to College Enrollment Status question | Applicant’s response to College Enrollment Status question |
Format, Length: | bpchar, 1 | 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 | 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 | No |
Default: | None | None |
Usage: | Correlates to MIS SB15 | Correlates to MIS SB15 |
Notes: | education table | education table |
Xap Field: | enrollmentStatusOneChar | enrollmentStatusOneChar |
Revision Log: | ~~ | ~~ |
Question Text: | As of <RDD>, I will have the following college enrollment status: [menu] | As of <RDD>, I will have the following college enrollment status: [menu] |
Conditions: | Always | 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. | 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 | 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 | None |
Field Error Check: | None | None |
Page Error Check: | Required selection; else error message, “You must select your College Enrollment Status.” | 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.” Proposed change to validation checks: If College 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" then DO NOT DISPLAY the following questions/sections: College Education Level = (higher_edu_level)Colleges Attended section: = starting with College Count (college_count) and all other questions in the Colleges Attended section. 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” then the applicant will be prompted to confirm whether they have previously attended college or not: “Is this your first time attending college while in high school (or lower grades)? If Yes, please check the confirmation box below. Otherwise, click "f you have not attended college before, please correct your responses as necessary.” “I confirm that I previously attended college while in high school or lower grades.” 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.” | 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.” Proposed change to validation checks: If College 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" then DO DO NOT DISPLAY the following questions/sections: College Education Level = (higher_edu_level) If College Enrollment Status is “Enrolling in high school (or lower grades) and college at the same time” then the applicant will be prompted to confirm whether they have previously attended college or not: “Is this your first time attending college while in high school (or lower grades)? If Yes, please check the confirmation box below. Otherwise, click "f you have not attended college before, please correct your responses as necessary.” “I confirm that I previously attended college while in high school or lower grades.” 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. | 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 | education: enroll_status |
Needs & Interests Data Dictionary Elements
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 | comfortable_english | ||
Description: | Question to assess applicant's comfort level in reading/writing English. | Question to assess applicant's comfort level in reading/writing English. | ||
Format: | boolean | 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 | 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] | Are you comfortable reading and writing English? Yes [radio button, clearable] No [radio button, clearable] | ||
Conditions: | Always | AlwaysDisplays only by request by college | ||
Additional Text: | None | None | ||
Response Options: | Yes radio button, No radio button, or no selection | Yes radio button, No radio button, or no selection | ||
Allows Null: | Yes | Yes | ||
Pop-Up Help: | None | None | ||
Field Error Check: | None | None | ||
Page Error Check: | None | None | ||
Notes: | In 2003, the current form of this question was implemented to better identify applicants who might need language assistance. Response is optional. | 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 | financial_assistance | |
Description: | Question that allows applicant to express interest in receiving information about money for college | Question that allows applicant to express interest in receiving information about money for college | |
Format: | boolean | 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 | 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] | Are you interested in receiving information about money for college? Yes [radio button, clearable] No [radio button, clearable] | |
Conditions: | Always | AlwaysDisplays only by request by college | |
Additional Text: | None | None | |
Response Options: | Yes radio button, No radio button, or no selection | Yes radio button, No radio button, or no selection | |
Allows Null: | Yes | Yes | |
Pop-Up Help: | None | None | |
Field Error Check: | None | None | |
Page Error Check: | None | None | |
Notes: | None | NoneXAP Field: | Revision Log: |
Receiving TANF, SSI, General Assistance
Data Element: | tanf_ssi_ga | tanf_ssi_ga | ||
Description: | To assess if the applicant is currently receiving TANF/CalWORKs, SSI, or General Assistance | To assess if the applicant is currently receiving TANF/CalWORKs, SSI, or General Assistance | ||
Format: | boolean | 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 | 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] | Are you receiving TANF/CalWORKs, SSI, or General Assistance? Yes [radio button, clearable] No [radio button, clearable] | ||
Conditions: | Always | AlwaysDisplays only by request by college | ||
Additional Text: | None | None | ||
Response Options: | Yes readio button, No radio button, or no selection | Yes readio radio button, No radio button, or no selection | ||
Allows Null: | Yes | Yes | ||
Pop-Up Help: | None | None | ||
Field Error Check: | None | None | ||
Page Error Check: | None | None | ||
Notes: | None | None | XAP Field: | Revision Log: |
Athletic Interest: Intercollegiate
Data Element: | athletic_intercollegiate | athletic_intercollegiate |
Description: | On the Needs & Interests tab (Athletic Interest field group) applicant can indicate interest in intercollegiate team sports participation | On the Needs & Interests tab (Athletic Interest field group) applicant can indicate interest in intercollegiate team sports participation |
Format: | boolean | 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 | 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. | 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 | AlwaysDisplays only by request by college |
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.) | (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 | Yes radio button or no selection |
Allows Null: | Yes | 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. | 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 | 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.” | Required If displayed on screen, 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. | 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 | athletic_intramural | |
Description: | On the Needs & Interests tab (Athletic Interest field group) applicant can indicate interest in intramural sports participation. | On the Needs & Interests tab (Athletic Interest field group) applicant can indicate interest in intramural sports participation. | |
Format: | boolean | 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 | 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. | 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 | AlwaysDisplayed by request by college | |
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.) | (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 | Yes radio button or no selection | |
Allows Null: | Yes | 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 | 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. | 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 | 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.” | Required selection If displayed on screen, 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. | 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 | athletic_not_interested | ||
Description: | On the Needs & Interests (Athletic Interest field group) applicant can indicate they are not interested in sports participation. | On the Needs & Interests (Athletic Interest field group) applicant can indicate they are not interested in sports participation. | ||
Format: | boolean | 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 | 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). | 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 | AlwaysDisplayed by request by college | ||
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.) | (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 | No radio button or no selection | ||
Allows Null: | Yes | Yes | ||
Pop-Up Help: | None | None | ||
Field Error Check: | None | 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.” | Required selection If displayed on screen, 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. | 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: |