Promise Grant Data Fields for Auto-Population

	A	B	C	D	E	F	H	I	K	L
1	This column lists all CCCApply Application data fields in alphabetical order	This column identifies potential matches from Apply to Promise Grant	This column lists all Promise Grant Application data fields in alphabetical order	This column lists all the fields already populating from OpenCCC Account	Amanda's Notes Per Analysis on DB Fields	This column shows data that is already coming in from CCCApply	This column lists proposed data fields that could auto-pop from previous BOG submitted app
2	APPLY Data Elements	PROPOSED AUTO-POP FROM APPLY & ACCOUNT	CCPG Data Elements	Breakdown Fields Populating from Account		Fields Pre-Pop from Apply	POSSIBLE AUTO-POP FROM PREVIOUS CCPG	NOTES	Auto-Population & System-Generated Data
3	academic_counseling	ack_fin_aid	ack_fin_aid	ack_fin_aid	This shows up on the certification page.		Yes
4	ack_fin_aid		app_id		This is a system generated field that is auto generated and custom foreach application so cant be auto filled.		system		The following fields of the CC Promise Grant Application (BOGFW) auto-populate from the applicant’s OpenCCC account:
5	address_same	app_lang	app_lang		This is the language button. it's saved in DB. Not eligible for autopopulate.	app_lang	Yes
6	address_validation	birthdate	birthdate	birthdate	Already populated from Account. Not eligible for autopopulate.		Yes		· CCCID
7	adm_ineligible	<current_date> minus 23 years > birthdate	born_before_23_year		Calculated on backend - it's what determined on the dependency status page - used in conjunction with dependecy page questions so the other DB fields cover this. Not applicable for auto-population. Used whether to show those last 2 questions.	<current_date> minus 23 years > birthdate	Yes	If this is Yes, we can also identify dependency status (dependent vs. independent)
8	alien_reg_expire_date		campaign1		Passed in from the college when they have a link to the application to their website, so auto population not applicable.				· Last Name, First Name, Middle Initial
9	alien_reg_issue_date		campaign2		Passed in from the college when they have a link to the application to their website, so auto population not applicable.
10	alien_reg_no_expire		campaign3		Passed in from the college when they have a link to the application to their website, so auto population not applicable.				· SSN
11	alien_reg_number	ccc_id	ccc_id	ccc_id	Passed in from student account. not applicable for auto -pop		Yes
12	app_id	Logic: <military_status> minus	cert_national_guard			<military_status = 7 or = 9>	Yes		· SSN Last 4 digits
13	app_lang		cert_veteran_affairs				Yes
14	athletic_intercollegiate	city	city	city			Yes		· SSN Type
15	athletic_intramural	college_id	college_id	college_id	Set by which college they are applying to so not eligible for auto-pop.		system
16	athletic_not_interested	college_name	college_name	college_name	Set by which college they are applying to so not eligible for auto-pop.		system		· Email Address
17	basic_skills		confirmation_applicant
18	birthdate		confirmation_number		This is a system generated field that is auto generated and custom foreach application so cant be auto filled.				· Date of Birth
19	ca_college_employee		confirmation_parent_guardian
20	ca_date_current	country	country	country			Yes		· Mainphone, extension and authorization for text
21	ca_foster_youth		dep_gross_income
22	ca_not_arrived		dep_number_household						· Street address 1 and 2
23	ca_outside_college		dep_other_income
24	ca_outside_college_year		dep_total_income						· City
25	ca_outside_lawsuit	dependent_status	dependency_status		Calculated based off questions they answer on dependency status page, not eligible for auto populate.	dependent_status	Yes (probably not - depends on age)	See DED (Dependency Status); slightly different than Apply's dependency status logic.
26	ca_outside_lawsuit_year		dependent_on_parent_taxes						· State
27	ca_outside_tax		dependents
28	ca_outside_tax_year	elig_ab540	determined_ab540_eligible			elig_ab540	Yes (TBD - need to look into these more - they will change over time)		· Postalcode
29	ca_outside_voted	homeless_youth	determined_homeless			homeless_youth	Yes (TBD - need to look into these more - they will change over time)
30	ca_outside_voted_year	res_status = 2 (and/or visa_type = T or U)	determined_non_res_exempt			res_status = 2 (and/or visa_type = T or U)	Yes (TBD - need to look into these more - they will change over time)
31	ca_res_2_years	res_status = 1	determined_residentca			res_status = 1	Yes (TBD - need to look into these more - they will change over time)		The following fields are system-generated and added to the application:
32	ca_school_employee	TBD	elig_bogfw		Calculated field based on all their answers so not eligible for auto -pop.
33	ca_seasonal_ag		elig_medal_honor				Yes		· The app_id is automatically generated when the row is first inserted into the table.
34	cahs_3year	TBD	elig_method_a		Calculated field based on all their answers so not eligible for auto -pop.
35	cahs_graduated	TBD	elig_method_b		Calculated field based on all their answers so not eligible for auto -pop.				· The college_id is set from the College table based on the college the BOGFW is being submitted to.
36	calworks	TBD	elig_method_d		Calculated field based on all their answers so not eligible for auto -pop.
37	campaign1		elig_police_fire				Yes		· The Current Mailing address fields can be populated from the student’s OpenCCC Account’s permanent address fields in the same way as CCCApply (i.e. – by clicking the checkbox that indicates the addresses are the same).
38	campaign2		elig_sept_11				Yes
39	campaign3	email	email	email	Passed in from student account. not applicable for auto -pop		Yes		Address verification for mailing addresses will be the same as in the CCCApply Standard application.
40	career_planning	under19_ind	emancipated_minor			under19_ind	Yes (TBD - need to look into these more - they will change over time)	Compare the "under19_ind" logic to the Dependency Status logic to see which determines emancipated minor status.
41	ccc_id	firstname	firstname	firstname	Passed in from student account. not applicable for auto -pop		Yes
42	child_care	tanf_ssi_ga	general_assistance			tanf_ssi_ga	Yes (TBD - need to look into these more - they will change over time)		subject_name	For dependents, subject_name is "Parent(s)/RDP ". For independents, subject name is "Student and Spouse’s/RDP "
43	citizenship_status	homeless_youth	homeless_youth_hud	Check the homeless youth status values for matches		homeless_youth	Yes (TBD - need to look into these more - they will change over time)
44	city	homeless_youth	homeless_youth_other			homeless_youth	Yes (TBD - need to look into these more - they will change over time)
45	coenroll_confirm	homeless_youth	homeless_youth_school			homeless_youth	Yes (TBD - need to look into these more - they will change over time)
46	col1_cds_full		ind_gross_income
47	col2_cds_full		ind_number_household
48	col3_cds_full		ind_other_income
49	col4_cds_full		ind_total_income
50	col1_cds	ip_address	ip_address	ip_address	Captured from header when they first start application. not applicable for auto -pop		system
51	col1_ceeb		last_page		Saved everytime in the aplication as they complete, not eligible for auto-populate.
52	col1_city	lastname	lastname	lastname	Passed in from student account. not applicable for auto -pop		Yes
53	col1_country	dependency_status	legal_guardianship			dependency_status	Yes (TBD - need to look into these more - they will change over time)
54	col1_degree_date	dependency_status	living_with_parents			dependency_status	Yes (TBD - need to look into these more - they will change over time)	This (and a few other fields) are conditional based on Dependency Status. See notes:
55	col1_degree_obtained	mainphone	mainphone	mainphone	Passed in from student account. not applicable for auto -pop		Yes
56	col1_end_date	mainphone_auth_text	mainphone_auth_text	mainphone_auth_text	Passed in from student account. not applicable for auto -pop		Yes
57	col1_expelled_status	mainphone_ext	mainphone_ext	mainphone_ext	Passed in from student account. not applicable for auto -pop		Yes
58	col1_name		marital_status				Yes (TBD - need to look into these more - they will change over time)
59	col1_not_listed		married_or_rdp				Yes (TBD - need to look into these more - they will change over time)
60	col1_start_date	middlename	middlename	middlename	Passed in from student account. not applicable for auto -pop		Yes
61	col1_state	no_mailing_address_homeless	no_mailing_address_homeless	no_mailing_address_homeless			Yes (TBD - need to look into these more - they will change over time)
62	col2_cds	no_perm_address_homeless	no_perm_address_homeless	no_perm_address_homeless	Passed in from student account. not applicable for auto -pop		Yes (TBD - need to look into these more - they will change over time)
63	col2_ceeb	non_us_address	non_us_address	non_us_address			Yes
64	col2_city	pg_firstname + pg_lastname	parent_guardian_name			pg_firstname + pg_lastname	Yes
65	col2_country		parents_assistance				Yes (TBD - need to look into these more - they will change over time)
66	col2_degree_date		parents_deceased				Yes
67	col2_degree_obtained	postalcode	postalcode	postalcode			Yes
68	col2_end_date	preferred_firstname	preferred_firstname	preferred_firstname	Passed in from student account. not applicable for auto -pop		Yes
69	col2_expelled_status	preferred_lastname	preferred_lastname	preferred_lastname	Passed in from student account. not applicable for auto -pop		Yes
70	col2_name	preferred_middlename	preferred_middlename	preferred_middlename	Passed in from student account. not applicable for auto -pop		Yes
71	col2_not_listed	preferred_name	preferred_name	preferred_name	Passed in from student account. not applicable for auto -pop		Yes
72	col2_start_date	otherfirstname	otherfirstname	otherfirstname	Passed in from student account. not applicable for auto -pop		Yes
73	col2_state	othermiddlename	othermiddlename	othermiddlename	Passed in from student account. not applicable for auto -pop		Yes
74	col3_cds	otherlastname	otherlastname	otherlastname	Passed in from student account. not applicable for auto -pop		Yes
75	col3_ceeb	Othername	othername	Othername	Passed in from student account. not applicable for auto -pop		Yes
76	col3_city	perm_nonusaprovince	province	perm_nonusaprovince or nonusaprovince			Yes
77	col3_country		reg_dom_partner				Yes (TBD - need to look into these more - they will change over time)
78	col3_degree_date	tanf_ssi_ga	ssi_ssp			tanf_ssi_ga	Yes (TBD - need to look into these more - they will change over time)
79	col3_degree_obtained	ssn	ssn	ssn	Passed in from student account. not applicable for auto -pop		Yes
80	col3_end_date	ssn_exception	ssn_exception	ssn_exception	Passed in from student account. not applicable for auto -pop		Yes
81	col3_expelled_status		ssn_hash		Passed in from student account. not applicable for auto -pop	ssn_hash
82	col3_name	ssn_display	ssn_last4	ssn_display	Passed in from student account. not applicable for auto -pop		Yes
83	col3_not_listed	ssn_no	ssn_no	ssn_no	Passed in from student account. not applicable for auto -pop		Yes
84	col3_start_date	ssn_type	ssn_type	ssn_type	Passed in from student account. not applicable for auto -pop		Yes
85	col3_state	perm_state	state	perm_state			Yes
86	col4_cds		status (Download status)		System generated based on status of app, not eligible for auto- pop.		system
87	col4_ceeb	perm_streetaddress1	streetaddress1	perm_streetaddress1			Yes
88	col4_city	perm_streetaddress2	streetaddress2	perm_streetaddress2			Yes
89	col4_country		student_college_id
90	col4_degree_date	calworks	tanf_calworks			calworks	Yes (TBD - need to look into these more - they will change over time)
91	col4_degree_obtained	term_code	term_code			term_code
92	col4_end_date		tstmp_create		System generated based on status of app, not eligible for auto- pop.		system
93	col4_expelled_status		tstmp_download		System generated based on status of app, not eligible for auto- pop.		system
94	col4_name		tstmp_submit		System generated based on status of app, not eligible for auto- pop.		system
95	col4_not_listed		tstmp_update		System generated based on status of app, not eligible for auto- pop.		system
96	col4_start_date	<logic> = <military_status = 3, 4, 5>	us_veteran			<logic> = <military_status = 3, 4, 5>	Yes
97	col4_state		year_code		Year the app is being filled out for, not eligible for auto-population.		System	This is set based on the bogfw_year table based on whichever BOGyear is selected
98	college_count		year_description		Year description the app is being filled out for, not eligible for auto-population.		System	description of the year from the bogfw_year table in conjunction with the academic_year field in the college table
99	college_expelled_summary
100	college_id