/
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 TypeLengthAllows NullDown-loadableIn Report Center?Rules Avail-able?Notes
address_verifiedboolean


YesYes
agent_phone_extvarchar4

YesYesNot currently used
agent_phone_numbervarchar25

YesYes
alt_non_us_phone_auth_txtboolean



YesNot currently used
alt_non_us_phone_extvarchar4


YesNot currently used
alt_non_us_phone_numbervarchar25

YesYes
app_idbigint
No
Yes

app_langchar2
YesYesYes
authorize_agent_info_releaseboolean

YesYesYes
birthdatedate


YesYesFrom Account
campaign1varchar255
YesYes
Added 3/27/15
campaign2varchar255
YesYes
Added 3/27/15
campaign3varchar255
YesYes
Added 3/27/15
ccc_idvarchar8NoYesYesYes
citizenship_statusvarchar1

YesYes
cityvarchar50

YesYesAgent's City
coenroll_confirmchar1

YesYesNot currently used
col1_cdsvarchar30

YesYes
col1_cds_fullvarchar14YesYesYesYesNEW 3/31/17
col1_ceebvarchar30

YesYes
col1_cityvarchar50

YesYes
col1_college_attended_idbigint


YesYes
col1_countrychar2

YesYes
col1_degree_datedate


YesYes
col1_degree_obtainedchar1

YesYes
col1_end_datedate


YesYes
col1_expelled_statusboolean


YesYes
col1_majorvarchar50

YesYes
col1_namevarchar30

YesYes
col1_non_us_provincevarchar50

YesYes
col1_not_listedboolean


YesYes
col1_primary_instruction_languagevarchar5010

YesYes
col1_start_datedate


YesYes
col1_statevarchar2

YesYes
col2_cdsvarchar30

YesYes
col2_cds_fullvarchar14YesYesYesYesNEW 3/31/17
col2_ceebvarchar30

YesYes
col2_cityvarchar50

YesYes
col2_college_attended_idbigint


YesYes
col2_countrychar2

YesYes
col2_degree_datedate


YesYes
col2_degree_obtainedchar1

YesYes
col2_end_datedate


YesYes
col2_expelled_statusboolean


YesYes
col2_majorvarchar50

YesYes
col2_namevarchar30

YesYes
col2_non_us_provincevarchar50

YesYes
col2_not_listedboolean


YesYes
col2_primary_instruction_languagevarchar10

YesYes
col2_start_datedate


YesYes
col2_statevarchar2

YesYes
col3_cdsvarchar30

YesYes
col3_cds_fullvarchar14YesYesYesYesNEW 3/31/17
col3_ceebvarchar30

YesYes
col3_cityvarchar50

YesYes
col3_college_attended_idbigint


YesYes
col3_countrychar2

YesYes
col3_degree_datedate


YesYes
col3_degree_obtainedchar1

YesYes
col3_end_datedate


YesYes
col3_expelled_statusboolean


YesYes
col3_majorvarchar50

YesYes
col3_namevarchar30

YesYes
col3_non_us_provincevarchar50

YesYes
col3_not_listedboolean


YesYes
col3_primary_instruction_languagevarchar10

YesYes
col3_start_datedate


YesYes
col3_statevarchar2

YesYes
col4_cdsvarchar30

YesYes
col4_cds_fullvarchar14YesYesYesYesNEW 3/31/17
col4_ceebvarchar30

YesYes
col4_cityvarchar50

YesYes
col4_college_attended_idbigint


YesYes
col4_countrychar2

YesYes
col4_degree_datedate


YesYes
col4_degree_obtainedchar1

YesYes
col4_end_datedate


YesYes
col4_expelled_statusboolean


YesYes
col4_majorvarchar50

YesYes
col4_namevarchar30

YesYes
col4_non_us_provincevarchar50

YesYes
col4_not_listedboolean


YesYes
col4_primary_instruction_languagevarchar10

YesYes
col4_start_datedate


YesYes
col4_statevarchar2

YesYes
college_comp_datedate


Yes

college_countsmallint


YesYes
college_edu_levelchar12

Yes

college_expelled_summaryboolean


YesYes
college_idchar3
YesYesYes
companyvarchar50

YesYes
confirmationvarchar30
YesYesYes
consentboolean

YesYesYes
contactvarchar50

YesYes
countryvarchar2

YesYesAgent's Country
country_of_birthchar2

YesYes
country_of_citizenshipchar2

YesYes
cryptokeyidinteger

NoNoNoRestricted
current_mailing_address_outside_usboolean


YesYesNot currently used
current_mailing_address_verifiedboolean


YesYes
current_mailing_cityvarchar50

YesYes
current_mailing_countrychar2

YesYes
current_mailing_non_us_addressboolean


YesYes
current_mailing_non_us_postal_codevarchar30

YesYes
current_mailing_non_us_provincevarchar50

YesYes
current_mailing_same_as_permanentboolean


Yes

current_mailing_statechar2

YesYes
current_mailing_street_1varchar50

YesYes
current_mailing_street_2varchar50

YesYes
current_mailing_zip_codevarchar20

YesYes
dep1_country_of_birthvarchar2

YesYes
dep1_date_of_birthdate


YesYes
dep1_dependent_idbigint


YesYes
dep1_first_namevarchar25

YesYes
dep1_gendervarchar1

YesYes
dep1_last_namevarchar25

YesYes
dep1_no_first_nameboolean


YesYes
dep1_relationshipvarchar20

YesYes
dep10_country_of_birthvarchar2

YesYes
dep10_date_of_birthdate


YesYes
dep10_dependent_idbigint


YesYes
dep10_first_namevarchar25

YesYes
dep10_gendervarchar1

YesYes
dep10_last_namevarchar25

YesYes
dep10_no_first_nameboolean


YesYes
dep10_relationshipvarchar20

YesYes
dep2_country_of_birthvarchar2

YesYes
dep2_date_of_birthdate


YesYes
dep2_dependent_idbigint


YesYes
dep2_first_namevarchar25

YesYes
dep2_gendervarchar1

YesYes
dep2_last_namevarchar25

YesYes
dep2_no_first_nameboolean


YesYes
dep2_relationshipvarchar20

YesYes
dep3_country_of_birthvarchar2

YesYes
dep3_date_of_birthdate


YesYes
dep3_dependent_idbigint


YesYes
dep3_first_namevarchar25

YesYes
dep3_gendervarchar1

YesYes
dep3_last_namevarchar25

YesYes
dep3_no_first_nameboolean


YesYes
dep3_relationshipvarchar20

YesYes
dep4_country_of_birthvarchar2

YesYes
dep4_date_of_birthdate


YesYes
dep4_dependent_idbigint


YesYes
dep4_first_namevarchar25

YesYes
dep4_gendervarchar1

YesYes
dep4_last_namevarchar25

YesYes
dep4_no_first_nameboolean


YesYes
dep4_relationshipvarchar20

YesYes
dep5_country_of_birthvarchar2

YesYes
dep5_date_of_birthdate


YesYes
dep5_dependent_idbigint


YesYes
dep5_first_namevarchar25

YesYes
dep5_gendervarchar1

YesYes
dep5_last_namevarchar25

YesYes
dep5_no_first_nameboolean


YesYes
dep5_relationshipvarchar20

YesYes
dep6_country_of_birthvarchar2

YesYes
dep6_date_of_birthdate


YesYes
dep6_dependent_idbigint


YesYes
dep6_first_namevarchar25

YesYes
dep6_gendervarchar1

YesYes
dep6_last_namevarchar25

YesYes
dep6_no_first_nameboolean


YesYes
dep6_relationshipvarchar20

YesYes
dep7_country_of_birthvarchar2

YesYes
dep7_date_of_birthdate


YesYes
dep7_dependent_idbigint


YesYes
dep7_first_namevarchar25

YesYes
dep7_gendervarchar1

YesYes
dep7_last_namevarchar25

YesYes
dep7_no_first_nameboolean


YesYes
dep7_relationshipvarchar20

YesYes
dep8_country_of_birthvarchar2

YesYes
dep8_date_of_birthdate


YesYes
dep8_dependent_idbigint


YesYes
dep8_first_namevarchar25

YesYes
dep8_gendervarchar1

YesYes
dep8_last_namevarchar25

YesYes
dep8_no_first_nameboolean


YesYes
dep8_relationshipvarchar20

YesYes
dep9_country_of_birthvarchar2

YesYes
dep9_date_of_birthdate


YesYes
dep9_dependent_idbigint


YesYes
dep9_first_namevarchar25

YesYes
dep9_gendervarchar1

YesYes
dep9_last_namevarchar25

YesYes
dep9_no_first_nameboolean


YesYes
dep9_relationshipvarchar20

YesYes
educational_goalchar1
YesYesYes
emailvarchar254

YesYesFrom Account
emergency_contact_address_verifiedboolean


YesYes
emergency_contact_cityvarchar50

YesYes
emergency_contact_countrychar2

YesYes
emergency_contact_emailvarchar50

YesYes
emergency_contact_first_namevarchar25

YesYes
emergency_contact_last_namevarchar25

YesYes
emergency_contact_no_first_nameboolean


YesYes
emergency_contact_non_us_addressboolean


YesYes
emergency_contact_non_us_postal_codevarchar30

YesYes
emergency_contact_non_us_provincevarchar50

YesYes
emergency_contact_phone_auth_txtboolean



Yes
emergency_contact_phone_extvarchar4


YesNot currently used
emergency_contact_phone_numbervarchar25

YesYes
emergency_contact_relationshipvarchar20

YesYes
emergency_contact_statechar2

YesYes
emergency_contact_street_1varchar50

YesYes
emergency_contact_street_2varchar50

YesYes
emergency_contact_zip_codevarchar20

YesYes
eng_months_studiedsmallint


YesYesNot currently used
eng_proficiency_datedate


YesYes
eng_proficiency_othervarchar50

YesYes
eng_proficiency_reqtext


YesYesNot currently used
eng_proficiency_scorechar6

YesYes
eng_proficiency_show_scoreboolean


YesYes
eng_proficiency_typechar2

YesYes
enroll_statuschar1

YesYes
enroll_term_codevarchar15
YesYesYes
enroll_term_descriptionvarchar50
YesYesYes
esignatureboolean

YesYesYes
expiration_datedate


YesYes
fax_number_numbervarchar25

YesYes
firstnamevarchar50
YesYesYesFrom Account
genderchar1

YesYes
higher_langvarchar10

YesYesNot currently used
highest_comp_datedate


YesYes
highest_edu_levelvarchar5

YesYes
hispanicboolean


YesYes
hs_address_verifiedboolean


YesYesNot currently used
hs_cdschar30

YesYes
hs_cds_fullvarchar14YesYesYesYesFull 14 digit CDE High School code
hs_ceebchar30

YesYes
hs_cityvarchar50

YesYes
hs_comp_datedate


YesYes
hs_countrychar2

YesYes
hs_diploma_certchar12


YesNot currently used
hs_diploma_cert_datedate



YesNot currently used
hs_edu_levelchar1

YesYes
hs_end_datedate


YesYes
hs_langvarchar10

YesYes
hs_namevarchar40

YesYes
hs_non_us_addressboolean


YesYesNot currently used
hs_non_us_postal_codevarchar30

YesYesNot currently used
hs_non_us_provincevarchar50

YesYesNot currently used
hs_not_listedboolean


YesYes
hs_start_datedate


YesYes
hs_statechar2

YesYes
hs_street_1varchar50

YesYes
hs_street_2varchar50

YesYes
hs_typechar1

YesYes
hs_zip_codevarchar20

YesYesNot currently used
i20_expiration_datedate


YesYes
i20_issuing_school_namevarchar20

YesYes
i94_admission_numbervarchar32

YesYes
i94_expiration_datedate


YesYes
intended_4_year_majorvarchar255
YesYesYes
ip_addressvarchar15
YesYes
Added 3/27/15
issue_datedate


YesYes
last_pagevarchar30

YesYesSystem property
lastnamevarchar50
YesYesYesFrom Account
main_phone_auth_txtboolean


YesYesFrom Account
main_phone_extvarchar4

YesYesFrom Account
main_phone_numbervarchar25

YesYesFrom Account
major_codevarchar30
YesYesYes
major_descriptionvarchar64
YesYesYes
middlenamevarchar50
YesYesYesFrom Account
no_i94_expiration_dateboolean


YesYes
no_mailing_address_homelessboolean1
YesYesYesNEW From Account 3/31/17
no_perm_address_homeless