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_homelessboolean1
YesYesYesNEW From Account 3/31/17
no_visaboolean


YesYes
non_us_addressboolean


YesYesNot currently
non_us_permanent_home_address_same

_as_permanent

boolean





non_us_permanent_home_address_

verified

boolean


YesYes
non_us_permanent_home_cityvarchar50

YesYes
non_us_permanent_home_countrychar2

YesYes
non_us_permanent_home_non_us_

address

boolean


YesYesAlways "TRUE"
non_us_permanent_home_non_us_postal

_code

varchar30

YesYes
non_us_permanent_home_non_us_

province

varchar50

YesYes
non_us_permanent_home_street_1varchar50

YesYes
non_us_permanent_home_street_2varchar50

YesYes
non_us_phone_auth_txtboolean



YesNot currently used
non_us_phone_extvarchar4


YesNot currently used
non_us_phone_numbervarchar25

YesYes
non_us_postal_codevarchar30

YesYesAgent's Postal Code
non_us_provincevarchar50

YesYesAgent's State/Province
number_of_dependentssmallint


YesYes
number_of_practical_trainingsmallint


YesYes
otherfirstnamevarchar50

YesYesFrom Account
otherlastnamevarchar50

YesYesFrom Account
othermiddlenamevarchar50

YesYesFrom Account
parent_guardian_address_verifiedboolean


YesYes
parent_guardian_cityvarchar50

YesYes
parent_guardian_countrychar2

YesYes
parent_guardian_emailvarchar50

YesYes
parent_guardian_first_namevarchar25

YesYes
parent_guardian_last_namevarchar25

YesYes
parent_guardian_no_first_nameboolean


YesYes
parent_guardian_non_us_addressboolean


YesYes
parent_guardian_non_us_postal_codevarchar30

YesYes
parent_guardian_non_us_provincevarchar50

YesYes
parent_guardian_phone_auth_txtboolean



Yes
parent_guardian_phone_extvarchar4


YesNot currently used
parent_guardian_phone_numbervarchar25

YesYes
parent_guardian_relationshipchar1

YesYes
parent_guardian_statechar2

YesYes
parent_guardian_street_1varchar50

YesYes
parent_guardian_street_2varchar50

YesYes
parent_guardian_zip_codevarchar20

YesYes
passport_country_of_issuancechar2

YesYes
passport_expiration_datedate


YesYes
passport_not_yetboolean


YesYes
passport_numbervarchar20

YesYes
perm_addr_address_verifiedboolean


YesYesFrom Account
perm_addr_cityvarchar50

YesYesFrom Account
perm_addr_countrychar2

YesYesFrom Account
perm_addr_non_us_addressboolean


YesYesFrom Account
perm_addr_non_us_postal_codevarchar30

YesYesFrom Account
perm_addr_non_us_provincevarchar50

YesYesFrom Account
perm_addr_statechar2

YesYesFrom Account
perm_addr_street_1varchar50

YesYesFrom Account
perm_addr_street_2varchar50

YesYesFrom Account
perm_addr_zip_codevarchar20

YesYesFrom Account
phone_auth_txtboolean



YesNot currently used
phone_extvarchar4

YesYesNot currently used
phone_numbervarchar25



Not currently used

Currently holds same value as alt_non_us_

phone_number

presently_studying_in_usboolean


YesYes
primary_languagevarchar10

YesYes
pt1_authorizing_schoolvarchar32

YesYes
pt1_end_datedate


YesYes
pt1_practical_training_idbigint


YesYes
pt1_start_datedate


YesYes
pt1_typevarchar3

YesYes
pt2_authorizing_schoolvarchar32

YesYes
pt2_end_datedate


YesYes
pt2_practical_training_idbigint


YesYes
pt2_start_datedate


YesYes
pt2_typevarchar3

YesYes
pt3_authorizing_schoolvarchar32

YesYes
pt3_end_datedate


YesYes
pt3_practical_training_idbigint


YesYes
pt3_start_datedate


YesYes
pt3_typevarchar3

YesYes
pt4_authorizing_schoolvarchar32

YesYes
pt4_end_datedate


YesYes
pt4_practical_training_idbigint


YesYes
pt4_start_datedate


YesYes
pt4_typevarchar3

YesYes
race_ethnicitytext string, 2147483647


YesYesRevised 9.30.16 (Release 5.5)
race_grouptext string, 2147483647


YesYesRevised 9.30.16 (Release 5.5)
saltRestricted field

NoNoNoSystem property
second_phone_auth_txtboolean


YesYesFrom Account
second_phone_extvarchar4

YesYesFrom Account
second_phone_numbervarchar25

YesYesFrom Account
sevis_id_numbervarchar11

YesYes
signaturetext


Yes
Not currently used
ssntext


YesYesencrypted
ssn_exceptionboolean

Default = false







ssn_last4char4




ssn_typechar1

Yes

statevarchar2

YesYesNot currently used
statuschar

YesYesYesApplication download status
street_1varchar50

YesYesAgent street address 1
street_2varchar50

YesYesAgent street address 2
suffixvarchar3

YesYesFrom Account
sup_page_codevarchar30
YesYesYes
term_start_datedate




Added 9.30.16 (Release 5.5)
term_end_datedate




Added 9.30.16 (Release 5.5)
tstmp_createtimestamp with time zone

Default=now()







tstmp_downloadtimestamp with time zone


Yes

tstmp_submittimestamp with time zone


YesYes
tstmp_updatetimestamp with time zone


YesYes
visa_typevarchar4

YesYes
zip_codevarchar20

YesYesNot currently used