/
International Application Data Fields
International Application Data Fields
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 | Yes | ||||
agent_phone_ext | varchar | 4 | Yes | Yes | Not currently used | ||
agent_phone_number | varchar | 25 | Yes | 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 | Yes | |||
app_id | bigint | No | Yes | ||||
app_lang | char | 2 | Yes | Yes | Yes | ||
authorize_agent_info_release | boolean | Yes | Yes | Yes | |||
birthdate | date | Yes | Yes | From Account | |||
campaign1 | varchar | 255 | Yes | Yes | Added 3/27/15 | ||
campaign2 | varchar | 255 | Yes | Yes | Added 3/27/15 | ||
campaign3 | varchar | 255 | Yes | Yes | Added 3/27/15 | ||
ccc_id | varchar | 8 | No | Yes | Yes | Yes | |
citizenship_status | varchar | 1 | Yes | Yes | |||
city | varchar | 50 | Yes | Yes | Agent's City | ||
coenroll_confirm | char | 1 | Yes | Yes | Not currently used | ||
col1_cds | varchar | 30 | Yes | Yes | |||
col1_cds_full | varchar | 14 | Yes | Yes | Yes | Yes | NEW 3/31/17 |
col1_ceeb | varchar | 30 | Yes | Yes | |||
col1_city | varchar | 50 | Yes | Yes | |||
col1_college_attended_id | bigint | Yes | Yes | ||||
col1_country | char | 2 | Yes | Yes | |||
col1_degree_date | date | Yes | Yes | ||||
col1_degree_obtained | char | 1 | Yes | Yes | |||
col1_end_date | date | Yes | Yes | ||||
col1_expelled_status | boolean | Yes | Yes | ||||
col1_major | varchar | 50 | Yes | Yes | |||
col1_name | varchar | 30 | Yes | Yes | |||
col1_non_us_province | varchar | 50 | Yes | Yes | |||
col1_not_listed | boolean | Yes | Yes | ||||
col1_primary_instruction_language | varchar | 5010 | Yes | Yes | |||
col1_start_date | date | Yes | Yes | ||||
col1_state | varchar | 2 | Yes | Yes | |||
col2_cds | varchar | 30 | Yes | Yes | |||
col2_cds_full | varchar | 14 | Yes | Yes | Yes | Yes | NEW 3/31/17 |
col2_ceeb | varchar | 30 | Yes | Yes | |||
col2_city | varchar | 50 | Yes | Yes | |||
col2_college_attended_id | bigint | Yes | Yes | ||||
col2_country | char | 2 | Yes | Yes | |||
col2_degree_date | date | Yes | Yes | ||||
col2_degree_obtained | char | 1 | Yes | Yes | |||
col2_end_date | date | Yes | Yes | ||||
col2_expelled_status | boolean | Yes | Yes | ||||
col2_major | varchar | 50 | Yes | Yes | |||
col2_name | varchar | 30 | Yes | Yes | |||
col2_non_us_province | varchar | 50 | Yes | Yes | |||
col2_not_listed | boolean | Yes | Yes | ||||
col2_primary_instruction_language | varchar | 10 | Yes | Yes | |||
col2_start_date | date | Yes | Yes | ||||
col2_state | varchar | 2 | Yes | Yes | |||
col3_cds | varchar | 30 | Yes | Yes | |||
col3_cds_full | varchar | 14 | Yes | Yes | Yes | Yes | NEW 3/31/17 |
col3_ceeb | varchar | 30 | Yes | Yes | |||
col3_city | varchar | 50 | Yes | Yes | |||
col3_college_attended_id | bigint | Yes | Yes | ||||
col3_country | char | 2 | Yes | Yes | |||
col3_degree_date | date | Yes | Yes | ||||
col3_degree_obtained | char | 1 | Yes | Yes | |||
col3_end_date | date | Yes | Yes | ||||
col3_expelled_status | boolean | Yes | Yes | ||||
col3_major | varchar | 50 | Yes | Yes | |||
col3_name | varchar | 30 | Yes | Yes | |||
col3_non_us_province | varchar | 50 | Yes | Yes | |||
col3_not_listed | boolean | Yes | Yes | ||||
col3_primary_instruction_language | varchar | 10 | Yes | Yes | |||
col3_start_date | date | Yes | Yes | ||||
col3_state | varchar | 2 | Yes | Yes | |||
col4_cds | varchar | 30 | Yes | Yes | |||
col4_cds_full | varchar | 14 | Yes | Yes | Yes | Yes | NEW 3/31/17 |
col4_ceeb | varchar | 30 | Yes | Yes | |||
col4_city | varchar | 50 | Yes | Yes | |||
col4_college_attended_id | bigint | Yes | Yes | ||||
col4_country | char | 2 | Yes | Yes | |||
col4_degree_date | date | Yes | Yes | ||||
col4_degree_obtained | char | 1 | Yes | Yes | |||
col4_end_date | date | Yes | Yes | ||||
col4_expelled_status | boolean | Yes | Yes | ||||
col4_major | varchar | 50 | Yes | Yes | |||
col4_name | varchar | 30 | Yes | Yes | |||
col4_non_us_province | varchar | 50 | Yes | Yes | |||
col4_not_listed | boolean | Yes | Yes | ||||
col4_primary_instruction_language | varchar | 10 | Yes | Yes | |||
col4_start_date | date | Yes | Yes | ||||
col4_state | varchar | 2 | Yes | Yes | |||
college_comp_date | date | Yes | |||||
college_count | smallint | Yes | Yes | ||||
college_edu_level | char | 12 | Yes | ||||
college_expelled_summary | boolean | Yes | Yes | ||||
college_id | char | 3 | Yes | Yes | Yes | ||
company | varchar | 50 | Yes | Yes | |||
confirmation | varchar | 30 | Yes | Yes | Yes | ||
consent | boolean | Yes | Yes | Yes | |||
contact | varchar | 50 | Yes | Yes | |||
country | varchar | 2 | Yes | Yes | Agent's Country | ||
country_of_birth | char | 2 | Yes | Yes | |||
country_of_citizenship | char | 2 | Yes | Yes | |||
cryptokeyid | integer | No | No | No | Restricted | ||
current_mailing_address_outside_us | boolean | Yes | Yes | Not currently used | |||
current_mailing_address_verified | boolean | Yes | Yes | ||||
current_mailing_city | varchar | 50 | Yes | Yes | |||
current_mailing_country | char | 2 | Yes | Yes | |||
current_mailing_non_us_address | boolean | Yes | Yes | ||||
current_mailing_non_us_postal_code | varchar | 30 | Yes | Yes | |||
current_mailing_non_us_province | varchar | 50 | Yes | Yes | |||
current_mailing_same_as_permanent | boolean | Yes | |||||
current_mailing_state | char | 2 | Yes | Yes | |||
current_mailing_street_1 | varchar | 50 | Yes | Yes | |||
current_mailing_street_2 | varchar | 50 | Yes | Yes | |||
current_mailing_zip_code | varchar | 20 | Yes | Yes | |||
dep1_country_of_birth | varchar | 2 | Yes | Yes | |||
dep1_date_of_birth | date | Yes | Yes | ||||
dep1_dependent_id | bigint | Yes | Yes | ||||
dep1_first_name | varchar | 25 | Yes | Yes | |||
dep1_gender | varchar | 1 | Yes | Yes | |||
dep1_last_name | varchar | 25 | Yes | Yes | |||
dep1_no_first_name | boolean | Yes | Yes | ||||
dep1_relationship | varchar | 20 | Yes | Yes | |||
dep10_country_of_birth | varchar | 2 | Yes | Yes | |||
dep10_date_of_birth | date | Yes | Yes | ||||
dep10_dependent_id | bigint | Yes | Yes | ||||
dep10_first_name | varchar | 25 | Yes | Yes | |||
dep10_gender | varchar | 1 | Yes | Yes | |||
dep10_last_name | varchar | 25 | Yes | Yes | |||
dep10_no_first_name | boolean | Yes | Yes | ||||
dep10_relationship | varchar | 20 | Yes | Yes | |||
dep2_country_of_birth | varchar | 2 | Yes | Yes | |||
dep2_date_of_birth | date | Yes | Yes | ||||
dep2_dependent_id | bigint | Yes | Yes | ||||
dep2_first_name | varchar | 25 | Yes | Yes | |||
dep2_gender | varchar | 1 | Yes | Yes | |||
dep2_last_name | varchar | 25 | Yes | Yes | |||
dep2_no_first_name | boolean | Yes | Yes | ||||
dep2_relationship | varchar | 20 | Yes | Yes | |||
dep3_country_of_birth | varchar | 2 | Yes | Yes | |||
dep3_date_of_birth | date | Yes | Yes | ||||
dep3_dependent_id | bigint | Yes | Yes | ||||
dep3_first_name | varchar | 25 | Yes | Yes | |||
dep3_gender | varchar | 1 | Yes | Yes | |||
dep3_last_name | varchar | 25 | Yes | Yes | |||
dep3_no_first_name | boolean | Yes | Yes | ||||
dep3_relationship | varchar | 20 | Yes | Yes | |||
dep4_country_of_birth | varchar | 2 | Yes | Yes | |||
dep4_date_of_birth | date | Yes | Yes | ||||
dep4_dependent_id | bigint | Yes | Yes | ||||
dep4_first_name | varchar | 25 | Yes | Yes | |||
dep4_gender | varchar | 1 | Yes | Yes | |||
dep4_last_name | varchar | 25 | Yes | Yes | |||
dep4_no_first_name | boolean | Yes | Yes | ||||
dep4_relationship | varchar | 20 | Yes | Yes | |||
dep5_country_of_birth | varchar | 2 | Yes | Yes | |||
dep5_date_of_birth | date | Yes | Yes | ||||
dep5_dependent_id | bigint | Yes | Yes | ||||
dep5_first_name | varchar | 25 | Yes | Yes | |||
dep5_gender | varchar | 1 | Yes | Yes | |||
dep5_last_name | varchar | 25 | Yes | Yes | |||
dep5_no_first_name | boolean | Yes | Yes | ||||
dep5_relationship | varchar | 20 | Yes | Yes | |||
dep6_country_of_birth | varchar | 2 | Yes | Yes | |||
dep6_date_of_birth | date | Yes | Yes | ||||
dep6_dependent_id | bigint | Yes | Yes | ||||
dep6_first_name | varchar | 25 | Yes | Yes | |||
dep6_gender | varchar | 1 | Yes | Yes | |||
dep6_last_name | varchar | 25 | Yes | Yes | |||
dep6_no_first_name | boolean | Yes | Yes | ||||
dep6_relationship | varchar | 20 | Yes | Yes | |||
dep7_country_of_birth | varchar | 2 | Yes | Yes | |||
dep7_date_of_birth | date | Yes | Yes | ||||
dep7_dependent_id | bigint | Yes | Yes | ||||
dep7_first_name | varchar | 25 | Yes | Yes | |||
dep7_gender | varchar | 1 | Yes | Yes | |||
dep7_last_name | varchar | 25 | Yes | Yes | |||
dep7_no_first_name | boolean | Yes | Yes | ||||
dep7_relationship | varchar | 20 | Yes | Yes | |||
dep8_country_of_birth | varchar | 2 | Yes | Yes | |||
dep8_date_of_birth | date | Yes | Yes | ||||
dep8_dependent_id | bigint | Yes | Yes | ||||
dep8_first_name | varchar | 25 | Yes | Yes | |||
dep8_gender | varchar | 1 | Yes | Yes | |||
dep8_last_name | varchar | 25 | Yes | Yes | |||
dep8_no_first_name | boolean | Yes | Yes | ||||
dep8_relationship | varchar | 20 | Yes | Yes | |||
dep9_country_of_birth | varchar | 2 | Yes | Yes | |||
dep9_date_of_birth | date | Yes | Yes | ||||
dep9_dependent_id | bigint | Yes | Yes | ||||
dep9_first_name | varchar | 25 | Yes | Yes | |||
dep9_gender | varchar | 1 | Yes | Yes | |||
dep9_last_name | varchar | 25 | Yes | Yes | |||
dep9_no_first_name | boolean | Yes | Yes | ||||
dep9_relationship | varchar | 20 | Yes | Yes | |||
educational_goal | char | 1 | Yes | Yes | Yes | ||
varchar | 254 | Yes | Yes | From Account | |||
emergency_contact_address_verified | boolean | Yes | Yes | ||||
emergency_contact_city | varchar | 50 | Yes | Yes | |||
emergency_contact_country | char | 2 | Yes | Yes | |||
emergency_contact_email | varchar | 50 | Yes | Yes | |||
emergency_contact_first_name | varchar | 25 | Yes | Yes | |||
emergency_contact_last_name | varchar | 25 | Yes | Yes | |||
emergency_contact_no_first_name | boolean | Yes | Yes | ||||
emergency_contact_non_us_address | boolean | Yes | Yes | ||||
emergency_contact_non_us_postal_code | varchar | 30 | Yes | Yes | |||
emergency_contact_non_us_province | varchar | 50 | Yes | 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 | Yes | |||
emergency_contact_relationship | varchar | 20 | Yes | Yes | |||
emergency_contact_state | char | 2 | Yes | Yes | |||
emergency_contact_street_1 | varchar | 50 | Yes | Yes | |||
emergency_contact_street_2 | varchar | 50 | Yes | Yes | |||
emergency_contact_zip_code | varchar | 20 | Yes | Yes | |||
eng_months_studied | smallint | Yes | Yes | Not currently used | |||
eng_proficiency_date | date | Yes | Yes | ||||
eng_proficiency_other | varchar | 50 | Yes | Yes | |||
eng_proficiency_req | text | Yes | Yes | Not currently used | |||
eng_proficiency_score | char | 6 | Yes | Yes | |||
eng_proficiency_show_score | boolean | Yes | Yes | ||||
eng_proficiency_type | char | 2 | Yes | Yes | |||
enroll_status | char | 1 | Yes | Yes | |||
enroll_term_code | varchar | 15 | Yes | Yes | Yes | ||
enroll_term_description | varchar | 50 | Yes | Yes | Yes | ||
esignature | boolean | Yes | Yes | Yes | |||
expiration_date | date | Yes | Yes | ||||
fax_number_number | varchar | 25 | Yes | Yes | |||
firstname | varchar | 50 | Yes | Yes | Yes | From Account | |
gender | char | 1 | Yes | Yes | |||
higher_lang | varchar | 10 | Yes | Yes | Not currently used | ||
highest_comp_date | date | Yes | Yes | ||||
highest_edu_level | varchar | 5 | Yes | Yes | |||
hispanic | boolean | Yes | Yes | ||||
hs_address_verified | boolean | Yes | Yes | Not currently used | |||
hs_cds | char | 30 | Yes | Yes | |||
hs_cds_full | varchar | 14 | Yes | Yes | Yes | Yes | Full 14 digit CDE High School code |
hs_ceeb | char | 30 | Yes | Yes | |||
hs_city | varchar | 50 | Yes | Yes | |||
hs_comp_date | date | Yes | Yes | ||||
hs_country | char | 2 | Yes | Yes | |||
hs_diploma_cert | char | 12 | Yes | Not currently used | |||
hs_diploma_cert_date | date | Yes | Not currently used | ||||
hs_edu_level | char | 1 | Yes | Yes | |||
hs_end_date | date | Yes | Yes | ||||
hs_lang | varchar | 10 | Yes | Yes | |||
hs_name | varchar | 40 | Yes | 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 | Yes | ||||
hs_start_date | date | Yes | Yes | ||||
hs_state | char | 2 | Yes | Yes | |||
hs_street_1 | varchar | 50 | Yes | Yes | |||
hs_street_2 | varchar | 50 | Yes | Yes | |||
hs_type | char | 1 | Yes | Yes | |||
hs_zip_code | varchar | 20 | Yes | Yes | Not currently used | ||
i20_expiration_date | date | Yes | Yes | ||||
i20_issuing_school_name | varchar | 20 | Yes | Yes | |||
i94_admission_number | varchar | 32 | Yes | Yes | |||
i94_expiration_date | date | Yes | Yes | ||||
intended_4_year_major | varchar | 255 | Yes | Yes | Yes | ||
ip_address | varchar | 15 | Yes | Yes | Added 3/27/15 | ||
issue_date | date | Yes | 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 | Yes | From Account | ||
major_code | varchar | 30 | Yes | Yes | Yes | ||
major_description | varchar | 64 | Yes | Yes | Yes | ||
middlename | varchar | 50 | Yes | Yes | Yes | From Account | |
no_i94_expiration_date | boolean | Yes | Yes | ||||
no_mailing_address_homeless | boolean | 1 | Yes | Yes | Yes | NEW From Account 3/31/17 | |
no_perm_address_homeless |