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 | Not currently used |
agent_phone_number | varchar | 25 |
| |
|
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 |
| | | |
|
authorize_agent_info_release | boolean |
| | | |
|
|
| Yes | Yes | From Account |
campaign1 | varchar | 255 |
| |
| Added 3/27/15 |
campaign2 | varchar | 255 |
|
| Added 3/27/15 |
campaign3 | varchar | 255 |
|
| Added 3/27/15 |
ccc_id | varchar | 8 | No | Yes | Yes | Yes |
|
|
citizenship_status | varchar | 1 |
| | | |
|
| Yes | Yes | Agent's City |
coenroll_confirm | char | 1 |
|
|
| Yes | Yes | Not currently used |
col1_cds | varchar | 30 |
| | | |
|
col1_college_attended_id | bigint |
| | | | | |
|
col1_degree_obtained | char | 1 |
| | | |
|
col1_expelled_status | boolean |
| | | | | | |
|
col1_non_us_province | varchar | 50 |
| | | | |
|
col1_primary_instruction_language | varchar | 5010 |
| | | | | | | | | | |
|
col2_college_attended_id | bigint |
| | | | | | | |
|
col2_degree_obtained | char | 1 |
| | | | |
|
col2_expelled_status | boolean |
| | | | | |
|
col2_non_us_province | varchar | 50 |
| | | |
|
col2_primary_instruction_language | varchar | 10 |
| | | | | | | | | | |
|
col3_college_attended_id | bigint |
| | | | | |
|
col3_degree_obtained | char | 1 |
| | | |
|
col3_expelled_status | boolean |
| | | | | |
|
col3_non_us_province | varchar | 50 |
| | | |
|
col3_primary_instruction_language | varchar | 10 |
| Yes | | | | | | | | |
|
col4_college_attended_id | bigint |
| | | | | |
|
col4_degree_obtained | char | 1 |
| | | |
|
col4_expelled_status | boolean |
| | | | | | |
|
col4_non_us_province | varchar | 50 |
| | | |
|
col4_primary_instruction_language | varchar | 10 |
| | | | | | | | | | | | |
|
|
college_expelled_summary | boolean |
| | | | | | | | | | |
|
| Yes | Yes | Agent's Country |
country_of_birth | char | 2 |
| |
|
country_of_citizenship | char | 2 |
| | | | | |
|
|
|
|
| System property |
current_mailing_address_outside_us | boolean |
| | |
|
|
| Yes | Yes | Not currently used |
current_mailing_address_verified | boolean |
| | |
|
current_mailing_city | varchar | 50 |
| |
|
current_mailing_country | char | 2 |
| |
|
current_mailing_non_us_address | boolean |
| | | |
|
current_mailing_non_us_postal_code | varchar | 30 |
| |
|
current_mailing_non_us_province | varchar | 50 |
| |
|
current_mailing_same_as_permanent | boolean |
| | | |
|
|
current_mailing_state | char | 2 |
| |
|
current_mailing_street_1 | varchar | 50 |
| |
|
current_mailing_street_2 | varchar | 50 |
| |
|
current_mailing_zip_code | varchar | 20 |
| |
|
dep1_country_of_birth | varchar | 2 |
| | | | | | | | | | | | |
|
dep1_no_first_name | boolean |
| | |
|
dep1_relationship | varchar | 20 |
| |
|
dep10_country_of_birth | varchar | 2 |
| | | | | | |
|
dep10_first_name | varchar | 25 |
| | | |
|
dep10_no_first_name | boolean |
| | |
|
dep10_relationship | varchar | 20 |
| | |
|
dep2_country_of_birth | varchar | 2 |
| | | | | | | | | | |
|
dep2_no_first_name | boolean |
| | |
|
dep2_relationship | varchar | 20 |
| |
|
dep3_country_of_birth | varchar | 2 |
| | | | | | | Yes | | | |
|
dep3_no_first_name | boolean |
| | |
|
dep3_relationship | varchar | 20 |
| |
|
dep4_country_of_birth | varchar | 2 |
| | | | | | | | | | |
|
dep4_no_first_name | boolean |
| | |
|
dep4_relationship | varchar | 20 |
| | |
|
dep5_country_of_birth | varchar | 2 |
| | | | | | | | | | |
|
dep5_no_first_name | boolean |
| | |
|
dep5_relationship | varchar | 20 |
| |
|
dep6_country_of_birth | varchar | 2 |
| | | | | | | | | | | | |
|
dep6_no_first_name | boolean |
| | |
|
dep6_relationship | varchar | 20 |
| |
|
dep7_country_of_birth | varchar | 2 |
| | | | | | | | | | |
|
dep7_no_first_name | boolean |
| | |
|
dep7_relationship | varchar | 20 |
| |
|
dep8_country_of_birth | varchar | 2 |
| | | | | | | | | |
|
dep8_no_first_name | boolean |
| | |
|
dep8_relationship | varchar | 20 |
| |
|
dep9_country_of_birth | varchar | 2 |
| | | | | | Yes | Yes | | Yes |
|
dep9_first_name | varchar | 25 |
| | | | |
|
dep9_no_first_name | boolean |
| | |
|
dep9_relationship | varchar | 20 |
| | |
|
| Yes | Yes | From Account |
emergency_contact_address_verified | boolean |
| | |
|
emergency_contact_city | varchar | 50 |
| |
|
emergency_contact_country | char | 2 |
| |
|
emergency_contact_email | varchar | 50 |
| |
|
emergency_contact_first_name | varchar | 25 |
| |
|
emergency_contact_last_name | varchar | 25 |
| | |
|
emergency_contact_no_first_name | boolean |
| | |
|
emergency_contact_non_us_address | boolean |
| | |
|
emergency_contact_non_us_postal_code | varchar | 30 |
| |
|
emergency_contact_non_us_province | varchar | 50 |
| |
|
emergency_contact_phone_auth_txt | boolean |
| | | |
|
emergency_contact_phone_ext | varchar | 4 |
| | |
|
|
| Yes | Not currently used |
emergency_contact_phone_number | varchar | 25 |
| |
|
emergency_contact_relationship | varchar | 20 |
| |
|
emergency_contact_state | char | 2 |
| |
|
emergency_contact_street_1 | varchar | 50 |
| |
|
emergency_contact_street_2 | varchar | 50 |
| |
|
emergency_contact_zip_code | varchar | 20 |
| | |
|
eng_months_studied | smallint |
| | |
|
|
| Yes | Yes | Not currently used |
eng_proficiency_date | date |
| | |
|
eng_proficiency_other | varchar | 50 |
| | | |
|
|
| Yes | Yes | Not currently used |
eng_proficiency_score | char | 6 |
| |
|
eng_proficiency_show_score | boolean |
| | |
|
eng_proficiency_type | char | 2 |
| | |
|
enroll_term_code | varchar | 15 |
|
|
enroll_term_description | varchar | 50 |
| | | | |
|
fax_number_number | varchar | 25 |
| | |
| Yes | Yes | Yes | From Account |
gender | char | 1 |
| | |
|
| Yes | Yes | Not currently used |
highest_comp_date | date |
| | |
|
highest_edu_level | varchar | 5 |
| | | |
|
hs_address_verified | boolean |
| | |
|
|
| Yes | Yes | Not currently used |
hs_cds | char | 30 |
| | | | | | | | | | | | Yes |
|
|
| Yes | Not currently used |
hs_diploma_cert_date | date |
| | |
|
|
|
| Yes | Not currently used |
hs_edu_level | char | 1 |
| | | | | | | | | |
|
|
| 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 | Not currently used |
i20_expiration_date | date |
| | |
|
i20_issuing_school_name | varchar | 20 |
| |
|
i94_admission_number | varchar | 32 |
| | | | |
|
intended_4_year_major | varchar | 255 |
| |
| Added 3/27/15 |
issue_date | date |
| | | |
|
| 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 |
|
|
major_description | varchar | 64 |
|
| Yes | Yes | Yes | From Account |
no_i94_expiration_date | boolean |
| | | | | | |
|
|
| Yes | Yes | Not currently |
non_us_permanent_home_address_same _as_permanent | boolean |
| | | | |
|
|
|
|
|
|
non_us_permanent_home_address_ verified | boolean |
| | |
|
non_us_permanent_home_city | varchar | 50 |
| |
|
non_us_permanent_home_country | char | 2 |
| |
|
non_us_permanent_home_non_us_ address | boolean |
| |
|
|
| Yes | Yes | Always "TRUE" |
non_us_permanent_home_non_us_postal _code | varchar | 30 |
| |
|
non_us_permanent_home_non_us_ province | varchar | 50 |
| | |
|
non_us_permanent_home_street_1 | varchar | 50 |
| |
|
non_us_permanent_home_street_2 | varchar | 50 |
| |
|
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 |
| |
|
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 |
| | |
|
number_of_practical_training | smallint |
| | | |
|
| Yes | Yes | From Account |
otherlastname | varchar | 50 |
| |
|
| Yes | Yes | From Account |
othermiddlename | varchar | 50 |
|
|
| Yes | Yes | From Account |
parent_guardian_address_verified | boolean |
| | |
|
parent_guardian_city | varchar | 50 |
| |
|
parent_guardian_country | char | 2 |
| |
|
parent_guardian_email | varchar | 50 |
| |
|
parent_guardian_first_name | varchar | 25 |
| |
|
parent_guardian_last_name | varchar | 25 |
| |
|
parent_guardian_no_first_name | boolean |
| | |
|
parent_guardian_non_us_address | boolean |
| | |
|
parent_guardian_non_us_postal_code | varchar | 30 |
| |
|
parent_guardian_non_us_province | varchar | 50 |
| |
|
parent_guardian_phone_auth_txt | boolean |
| | | |
|
parent_guardian_phone_ext | varchar | 4 |
| | |
|
|
| Yes | Not currently used |
parent_guardian_phone_number | varchar | 25 |
| | |
|
parent_guardian_relationship | char | 1 |
| |
|
parent_guardian_state | char | 2 |
| |
|
parent_guardian_street_1 | varchar | 50 |
| |
|
parent_guardian_street_2 | varchar | 50 |
| |
|
parent_guardian_zip_code | varchar | 20 |
| |
|
passport_country_of_issuance | char | 2 |
| |
|
passport_expiration_date | date |
| | | | | | |
|
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 |
| | |
|
primary_language | varchar | 10 |
| |
|
pt1_authorizing_school | varchar | 32 |
| | | | |
|
pt1_practical_training_id | bigint |
| | | | | | | | |
|
pt2_authorizing_school | varchar | 32 |
| | | |
|
pt2_practical_training_id | bigint |
| | | | | | |
|
pt3_authorizing_school | varchar | 32 |
| | | |
|
pt3_practical_training_id | bigint |
| | | | | | | |
|
pt4_authorizing_school | varchar | 32 |
| | | |
|
pt4_practical_training_id | bigint |
| | | | | | | | | | | | salt | text | | | | | 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 |
| | | | |
| Not currently used |
ssn | text |
| | |
|
ssn_exception | boolean Default = false |
| | | | | | | | | state | | Yes | | | | |
|
| 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 |
| | | |
|
|
tstmp_submit | timestamp with time zone |
| | |
|
tstmp_update | timestamp with time zone |
| | | |