Page Comparison

The table below includes all the fields in the submitted application database for the CCCApply International applicaiton. Most all of the fields are downloadable to your college SIS with the exception of some noted fields that are used internally by the underlying software. Any fields that are not downloadable are marked as such.

Data Element (column)	Data Type	Length	Allows Null	Down-loadable	In Report Center?	Rules Avail-able?	Notes
address_verified	boolean

Yes


agent_phone_ext	varchar	4

			Yes	Yes	Not currently used
agent_phone_number	varchar	25

Yes


alt_non_us_phone_auth_txt	boolean

					Yes	Not currently used
alt_non_us_phone_ext	varchar	4

				Yes	Not currently used
alt_non_us_phone_number	varchar	25

Yes


app_id	bigint

No

Yes


app_lang	char	2

Yes


authorize_agent_info_release	boolean

Yes


birthdate	date

				Yes	Yes	From Account
campaign1	varchar	255

Yes

		Added 3/27/15
campaign2	varchar	255

Yes

	Added 3/27/15
campaign3	varchar	255

Yes

	Added 3/27/15
ccc_id	varchar	8	No	Yes	Yes	Yes


citizenship_status	varchar	1

Yes


city	varchar	50

			Yes	Yes	Agent's City
coenroll_confirm	char	1

		Yes	Yes	Not currently used
col1_cds	varchar	30

Yes


col1_ceeb	varchar	30

Yes


col1_city	varchar	50

Yes


col1_college_attended_id	bigint

Yes


col1_country	char	2

Yes


col1_degree_date	date

Yes


col1_degree_obtained	char	1

Yes


col1_end_date	date

Yes


col1_expelled_status	boolean

Yes


col1_major	varchar	50

Yes


col1_name	varchar	30

Yes


col1_non_us_province	varchar	50

Yes


col1_not_listed	boolean

Yes


col1_primary_instruction_language	varchar	5010

Yes


col1_start_date	date

Yes


col1_state	varchar	2

Yes


col2_cds	varchar	30

Yes


col2_ceeb	varchar	30

Yes


col2_city	varchar	50

Yes


col2_college_attended_id	bigint

Yes


col2_country	char	2

Yes


col2_degree_date	date

Yes


col2_degree_obtained	char	1

Yes


col2_end_date	date

Yes


col2_expelled_status	boolean

Yes


col2_major	varchar	50

Yes


col2_name	varchar	30

Yes


col2_non_us_province	varchar	50

Yes


col2_not_listed	boolean

Yes


col2_primary_instruction_language	varchar	10

Yes


col2_start_date	date

Yes


col2_state	varchar	2

Yes


col3_cds	varchar	30

Yes


col3_ceeb	varchar	30

Yes


col3_city	varchar	50

Yes


col3_college_attended_id	bigint

Yes


col3_country	char	2

Yes


col3_degree_date	date

Yes


col3_degree_obtained	char	1

Yes


col3_end_date	date

Yes


col3_expelled_status	boolean

Yes


col3_major	varchar	50

Yes


col3_name	varchar	30

Yes


col3_non_us_province	varchar	50

Yes


col3_not_listed	boolean

Yes


col3_primary_instruction_language	varchar	10

Yes


col3_start_date	date

Yes


col3_state	varchar	2

Yes


col4_cds	varchar	30

Yes


col4_ceeb	varchar	30

Yes


col4_city	varchar	50

Yes


col4_college_attended_id	bigint

Yes


col4_country	char	2

Yes


col4_degree_date	date

Yes


col4_degree_obtained	char	1

Yes


col4_end_date	date

Yes


col4_expelled_status	boolean

Yes


col4_major	varchar	50

Yes


col4_name	varchar	30

Yes


col4_non_us_province	varchar	50

Yes


col4_not_listed	boolean

Yes


col4_primary_instruction_language	varchar	10

Yes


col4_start_date	date

Yes


col4_state	varchar	2

Yes


college_comp_date	date

Yes


college_count	smallint

Yes


college_edu_level	char	12

Yes


college_expelled_summary	boolean

Yes


college_id	char	3

Yes


company	varchar	50

Yes


confirmation	varchar	30

Yes


consent	boolean

Yes


contact	varchar	50

Yes


country	varchar	2

			Yes	Yes	Agent's Country
country_of_birth	char	2

Yes


country_of_citizenship	char	2

Yes


cryptokeyid	integer

					System property
current_mailing_address_outside_us	boolean

				Yes	Yes	Not currently used
current_mailing_address_verified	boolean

Yes


current_mailing_city	varchar	50

Yes


current_mailing_country	char	2

Yes


current_mailing_non_us_address	boolean

Yes


current_mailing_non_us_postal_code	varchar	30

Yes


current_mailing_non_us_province	varchar	50

Yes


current_mailing_same_as_permanent	boolean

Yes


current_mailing_state	char	2

Yes


current_mailing_street_1	varchar	50

Yes


current_mailing_street_2	varchar	50

Yes


current_mailing_zip_code	varchar	20

Yes


dep1_country_of_birth	varchar	2

Yes


dep1_date_of_birth	date

Yes


dep1_dependent_id	bigint

Yes


dep1_first_name	varchar	25

Yes


dep1_gender	varchar	1

Yes


dep1_last_name	varchar	25

Yes


dep1_no_first_name	boolean

Yes


dep1_relationship	varchar	20

Yes


dep10_country_of_birth	varchar	2

Yes


dep10_date_of_birth	date

Yes


dep10_dependent_id	bigint

Yes


dep10_first_name	varchar	25

Yes


dep10_gender	varchar	1

Yes


dep10_last_name	varchar	25

Yes


dep10_no_first_name	boolean

Yes


dep10_relationship	varchar	20

Yes


dep2_country_of_birth	varchar	2

Yes


dep2_date_of_birth	date

Yes


dep2_dependent_id	bigint

Yes


dep2_first_name	varchar	25

Yes


dep2_gender	varchar	1

Yes


dep2_last_name	varchar	25

Yes


dep2_no_first_name	boolean

Yes


dep2_relationship	varchar	20

Yes


dep3_country_of_birth	varchar	2

Yes


dep3_date_of_birth	date

Yes


dep3_dependent_id	bigint

Yes


dep3_first_name	varchar	25

Yes


dep3_gender	varchar	1

Yes


dep3_last_name	varchar	25

Yes


dep3_no_first_name	boolean

Yes


dep3_relationship	varchar	20

Yes


dep4_country_of_birth	varchar	2

Yes


dep4_date_of_birth	date

Yes


dep4_dependent_id	bigint

Yes


dep4_first_name	varchar	25

Yes


dep4_gender	varchar	1

Yes


dep4_last_name	varchar	25

Yes


dep4_no_first_name	boolean

Yes


dep4_relationship	varchar	20

Yes


dep5_country_of_birth	varchar	2

Yes


dep5_date_of_birth	date

Yes


dep5_dependent_id	bigint

Yes


dep5_first_name	varchar	25

Yes


dep5_gender	varchar	1

Yes


dep5_last_name	varchar	25

Yes


dep5_no_first_name	boolean

Yes


dep5_relationship	varchar	20

Yes


dep6_country_of_birth	varchar	2

Yes


dep6_date_of_birth	date

Yes


dep6_dependent_id	bigint

Yes


dep6_first_name	varchar	25

Yes


dep6_gender	varchar	1

Yes


dep6_last_name	varchar	25

Yes


dep6_no_first_name	boolean

Yes


dep6_relationship	varchar	20

Yes


dep7_country_of_birth	varchar	2

Yes


dep7_date_of_birth	date

Yes


dep7_dependent_id	bigint

Yes


dep7_first_name	varchar	25

Yes


dep7_gender	varchar	1

Yes


dep7_last_name	varchar	25

Yes


dep7_no_first_name	boolean

Yes


dep7_relationship	varchar	20

Yes


dep8_country_of_birth	varchar	2

Yes


dep8_date_of_birth	date

Yes


dep8_dependent_id	bigint

Yes


dep8_first_name	varchar	25

Yes


dep8_gender	varchar	1

Yes


dep8_last_name	varchar	25

Yes


dep8_no_first_name	boolean

Yes


dep8_relationship	varchar	20

Yes


dep9_country_of_birth	varchar	2

Yes


dep9_date_of_birth	date

Yes


dep9_dependent_id	bigint

Yes

YesYes

Yes
dep9_first_name	varchar	25

Yes


dep9_gender	varchar	1

Yes


dep9_last_name	varchar	25

Yes


dep9_no_first_name	boolean

Yes


dep9_relationship	varchar	20

Yes


educational_goal	char	1

Yes


email	varchar	254

		Yes	Yes	From Account
emergency_contact_address_verified	boolean

Yes


emergency_contact_city	varchar	50

Yes


emergency_contact_country	char	2

Yes


emergency_contact_email	varchar	50

Yes


emergency_contact_first_name	varchar	25

Yes


emergency_contact_last_name	varchar	25

Yes


emergency_contact_no_first_name	boolean

Yes


emergency_contact_non_us_address	boolean

Yes


emergency_contact_non_us_postal_code	varchar	30

Yes


emergency_contact_non_us_province	varchar	50

Yes


emergency_contact_phone_auth_txt	boolean

Yes


emergency_contact_phone_ext	varchar	4

				Yes	Not currently used
emergency_contact_phone_number	varchar	25

Yes


emergency_contact_relationship	varchar	20

Yes


emergency_contact_state	char	2

Yes


emergency_contact_street_1	varchar	50

Yes


emergency_contact_street_2	varchar	50

Yes


emergency_contact_zip_code	varchar	20

Yes


eng_months_studied	smallint

				Yes	Yes	Not currently used
eng_proficiency_date	date

Yes


eng_proficiency_other	varchar	50

Yes


eng_proficiency_req	text

				Yes	Yes	Not currently used
eng_proficiency_score	char	6

Yes


eng_proficiency_show_score	boolean

Yes


eng_proficiency_type	char	2

Yes


enroll_status	char	1

Yes


enroll_term_code	varchar	15

Yes


enroll_term_description	varchar	50

Yes


esignature	boolean

Yes


expiration_date	date

Yes


fax_number_number	varchar	25

Yes


firstname	varchar	50

	Yes	Yes	Yes	From Account
gender	char	1

Yes


higher_lang	varchar	10

		Yes	Yes	Not currently used
highest_comp_date	date

Yes


highest_edu_level	varchar	5

Yes


hispanic	boolean

Yes


hs_address_verified	boolean

				Yes	Yes	Not currently used
hs_cds	char	30

Yes


hs_ceeb	char	30

Yes


hs_city	varchar	50

Yes


hs_comp_date	date

Yes


hs_country	char	2

Yes


hs_diploma_cert	char	12

Yes

			Yes	Not currently used
hs_diploma_cert_date	date

				Yes	Not currently used
hs_edu_level	char	1

Yes


hs_end_date	date

Yes


hs_lang	varchar	10

Yes


hs_name	varchar	40

Yes


hs_non_us_address	boolean

				Yes	Yes	Not currently used
hs_non_us_postal_code	varchar	30

			Yes	Yes	Not currently used
hs_non_us_province	varchar	50

		Yes	Yes	Not currently used
hs_not_listed	boolean

Yes


hs_start_date	date

Yes


hs_state	char	2

Yes


hs_street_1	varchar	50

Yes


hs_street_2	varchar	50

Yes


hs_type	char	1

Yes


hs_zip_code	varchar	20

		Yes	Yes	Not currently used
i20_expiration_date	date

Yes


i20_issuing_school_name	varchar	20

Yes


i94_admission_number	varchar	32

Yes


i94_expiration_date	date

Yes


intended_4_year_major	varchar	255

Yes


ip_address	varchar	15

Yes

	Added 3/27/15
issue_date	date

Yes


last_page	varchar	30

			Yes	Yes	System property
lastname	varchar	50

	Yes	Yes	Yes	From Account
main_phone_auth_txt	boolean

			Yes	Yes	From Account
main_phone_ext	varchar	4

		Yes	Yes	From Account
main_phone_number	varchar	25

Yes

From Account
major_code	varchar	30

Yes


major_description	varchar	64

Yes


middlename	varchar	50

	Yes	Yes	Yes	From Account
no_i94_expiration_date	boolean

Yes


no_visa	boolean

Yes


non_us_address	boolean

				Yes	Yes	Not currently
non_us_permanent_home_address_same _as_permanent	boolean


non_us_permanent_home_address_ verified	boolean

Yes


non_us_permanent_home_city	varchar	50

Yes


non_us_permanent_home_country	char	2

Yes


non_us_permanent_home_non_us_ address	boolean

			Yes	Yes	Always "TRUE"
non_us_permanent_home_non_us_postal _code	varchar	30

Yes


non_us_permanent_home_non_us_ province	varchar	50

Yes


non_us_permanent_home_street_1	varchar	50

Yes


non_us_permanent_home_street_2	varchar	50

Yes


non_us_phone_auth_txt	boolean

					Yes	Not currently used
non_us_phone_ext	varchar	4

				Yes	Not currently used
non_us_phone_number	varchar	25

Yes


non_us_postal_code	varchar	30

			Yes	Yes	Agent's Postal Code
non_us_province	varchar	50

			Yes	Yes	Agent's State/Province
number_of_dependents	smallint

Yes


number_of_practical_training	smallint

Yes


otherfirstname	varchar	50

			Yes	Yes	From Account
otherlastname	varchar	50

			Yes	Yes	From Account
othermiddlename	varchar	50

		Yes	Yes	From Account
parent_guardian_address_verified	boolean

Yes


parent_guardian_city	varchar	50

Yes


parent_guardian_country	char	2

Yes


parent_guardian_email	varchar	50

Yes


parent_guardian_first_name	varchar	25

Yes


parent_guardian_last_name	varchar	25

Yes


parent_guardian_no_first_name	boolean

Yes


parent_guardian_non_us_address	boolean

Yes


parent_guardian_non_us_postal_code	varchar	30

Yes


parent_guardian_non_us_province	varchar	50

Yes


parent_guardian_phone_auth_txt	boolean

Yes


parent_guardian_phone_ext	varchar	4

				Yes	Not currently used
parent_guardian_phone_number	varchar	25

Yes


parent_guardian_relationship	char	1

Yes


parent_guardian_state	char	2

Yes


parent_guardian_street_1	varchar	50

Yes


parent_guardian_street_2	varchar	50

Yes


parent_guardian_zip_code	varchar	20

Yes


passport_country_of_issuance	char	2

Yes


passport_expiration_date	date

Yes


passport_not_yet	boolean

Yes


passport_number	varchar	20

Yes


perm_addr_address_verified	boolean

				Yes	Yes	From Account
perm_addr_city	varchar	50

			Yes	Yes	From Account
perm_addr_country	char	2

		Yes	Yes	From Account
perm_addr_non_us_address	boolean

			Yes	Yes	From Account
perm_addr_non_us_postal_code	varchar	30

		Yes	Yes	From Account
perm_addr_non_us_province	varchar	50

		Yes	Yes	From Account
perm_addr_state	char	2

			Yes	Yes	From Account
perm_addr_street_1	varchar	50

			Yes	Yes	From Account
perm_addr_street_2	varchar	50

			Yes	Yes	From Account
perm_addr_zip_code	varchar	20

		Yes	Yes	From Account
phone_auth_txt	boolean

					Yes	Not currently used
phone_ext	varchar	4

			Yes	Yes	Not currently used
phone_number	varchar	25

Not currently used

Currently holds same value as alt_non_us_

phone_number

presently_studying_in_us

boolean

Yes


primary_language	varchar	10

Yes


pt1_authorizing_school	varchar	32

Yes


pt1_end_date	date

Yes


pt1_practical_training_id	bigint

Yes


pt1_start_date	date

Yes


pt1_type	varchar	3

Yes


pt2_authorizing_school	varchar	32

Yes


pt2_end_date	date

Yes


pt2_practical_training_id	bigint

Yes


pt2_start_date	date

Yes


pt2_type	varchar	3

Yes


pt3_authorizing_school	varchar	32

Yes


pt3_end_date	date

Yes


pt3_practical_training_id	bigint

Yes


pt3_start_date	date

Yes


pt3_type	varchar	3

Yes


pt4_authorizing_school	varchar	32

Yes


pt4_end_date	date

Yes


pt4_practical_training_id	bigint

Yes


pt4_start_date	date

Yes


pt4_type	varchar	3

Yes


race_ethnicity	text

string, 2147483647

Yes

Revised 9.30.16 (Release 5.5)
race_group	text

string, 2147483647

Yes

salttext

Revised 9.30.16 (Release 5.5)
salt	text	Yes	System property
second_phone_auth_txt	boolean

			Yes	Yes	From Account
second_phone_ext	varchar	4

		Yes	Yes	From Account
second_phone_number	varchar	25

			Yes	Yes	From Account
sevis_id_number	varchar	11

Yes


signature	text

Yes

		Not currently used
ssn	text

Yes


ssn_exception	boolean Default = false


ssn_last4	char	4


ssn_type	char	1

state

Yes

state

varchar

2

		Yes	Yes	Not currently used
status	char

			Yes	Yes	Yes	Application download status
street_1	varchar	50

			Yes	Yes	Agent street address 1
street_2	varchar	50

		Yes	Yes	Agent street address 2
suffix	varchar	3

		Yes	Yes	From Account
sup_page_code	varchar	30

Yes


term_start_date	date	Added 9.30.16 (Release 5.5)
term_end_date	date	Added 9.30.16 (Release 5.5)
tstmp_create	timestamp with time zone Default=now()


tstmp_download	timestamp with time zone

Yes


tstmp_submit	timestamp with time zone

Yes


tstmp_update	timestamp with time zone

Yes


visa_type	varchar	4

Yes


zip_code	varchar	20

Yes

Not currently used

Versions Compared

Old Version 4

New Version 5

Key