/
International Application Data Fields
International Application Data Fields
- Former user (Deleted)
- Patricia Donohue
Owned by Former user (Deleted)
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 | boolean | 1 | Yes | Yes | Yes | NEW From Account 3/31/17 | |
| no_visa | boolean | Yes | 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 | Yes | ||||
| non_us_permanent_home_city | varchar | 50 | Yes | Yes | |||
| non_us_permanent_home_country | char | 2 | Yes | Yes | |||
| non_us_permanent_home_non_us_ address | boolean | Yes | Yes | Always "TRUE" | |||
| non_us_permanent_home_non_us_postal _code | varchar | 30 | Yes | Yes | |||
| non_us_permanent_home_non_us_ province | varchar | 50 | Yes | Yes | |||
| non_us_permanent_home_street_1 | varchar | 50 | Yes | Yes | |||
| non_us_permanent_home_street_2 | varchar | 50 | Yes | 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 | 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 | Yes | ||||
| number_of_practical_training | smallint | Yes | 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 | Yes | ||||
| parent_guardian_city | varchar | 50 | Yes | Yes | |||
| parent_guardian_country | char | 2 | Yes | Yes | |||
| parent_guardian_email | varchar | 50 | Yes | Yes | |||
| parent_guardian_first_name | varchar | 25 | Yes | Yes | |||
| parent_guardian_last_name | varchar | 25 | Yes | Yes | |||
| parent_guardian_no_first_name | boolean | Yes | Yes | ||||
| parent_guardian_non_us_address | boolean | Yes | Yes | ||||
| parent_guardian_non_us_postal_code | varchar | 30 | Yes | Yes | |||
| parent_guardian_non_us_province | varchar | 50 | Yes | 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 | Yes | |||
| parent_guardian_relationship | char | 1 | Yes | Yes | |||
| parent_guardian_state | char | 2 | Yes | Yes | |||
| parent_guardian_street_1 | varchar | 50 | Yes | Yes | |||
| parent_guardian_street_2 | varchar | 50 | Yes | Yes | |||
| parent_guardian_zip_code | varchar | 20 | Yes | Yes | |||
| passport_country_of_issuance | char | 2 | Yes | Yes | |||
| passport_expiration_date | date | Yes | Yes | ||||
| passport_not_yet | boolean | Yes | Yes | ||||
| passport_number | varchar | 20 | Yes | 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 | Yes | ||||
| primary_language | varchar | 10 | Yes | Yes | |||
| pt1_authorizing_school | varchar | 32 | Yes | Yes | |||
| pt1_end_date | date | Yes | Yes | ||||
| pt1_practical_training_id | bigint | Yes | Yes | ||||
| pt1_start_date | date | Yes | Yes | ||||
| pt1_type | varchar | 3 | Yes | Yes | |||
| pt2_authorizing_school | varchar | 32 | Yes | Yes | |||
| pt2_end_date | date | Yes | Yes | ||||
| pt2_practical_training_id | bigint | Yes | Yes | ||||
| pt2_start_date | date | Yes | Yes | ||||
| pt2_type | varchar | 3 | Yes | Yes | |||
| pt3_authorizing_school | varchar | 32 | Yes | Yes | |||
| pt3_end_date | date | Yes | Yes | ||||
| pt3_practical_training_id | bigint | Yes | Yes | ||||
| pt3_start_date | date | Yes | Yes | ||||
| pt3_type | varchar | 3 | Yes | Yes | |||
| pt4_authorizing_school | varchar | 32 | Yes | Yes | |||
| pt4_end_date | date | Yes | Yes | ||||
| pt4_practical_training_id | bigint | Yes | Yes | ||||
| pt4_start_date | date | Yes | Yes | ||||
| pt4_type | varchar | 3 | Yes | Yes | |||
| race_ethnicity | text string, 2147483647 | Yes | Yes | Revised 9.30.16 (Release 5.5) | |||
| race_group | text string, 2147483647 | Yes | Yes | Revised 9.30.16 (Release 5.5) | |||
| salt | Restricted field | No | No | No | 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 | Yes | |||
| signature | text | Yes | Not currently used | ||||
| ssn | text | Yes | Yes | encrypted | |||
| ssn_exception | boolean Default = false | ||||||
| ssn_last4 | char | 4 | |||||
| ssn_type | char | 1 | 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 | Yes | 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 | Yes | ||||
| tstmp_update | timestamp with time zone | Yes | Yes | ||||
| visa_type | varchar | 4 | Yes | Yes | |||
| zip_code | varchar | 20 | Yes | Yes | Not currently used |
, multiple selections available,
Related content
CCCApply Standard/CollegePromise/International App Enterprise Data Dictionary V2
CCCApply Standard/CollegePromise/International App Enterprise Data Dictionary V2
More like this
Accessing In-Progress Application Data in the CCC Data Warehouse
Accessing In-Progress Application Data in the CCC Data Warehouse
More like this
CCCApply Standard Application SuperGlue Data Mappings - MSQL
CCCApply Standard Application SuperGlue Data Mappings - MSQL
More like this
International Application Deployment Steps
International Application Deployment Steps
More like this
CCCApply In-Progress Applications Report
CCCApply In-Progress Applications Report
More like this
CCCApply International SuperGlue Data Mappings - PeopleSoft
CCCApply International SuperGlue Data Mappings - PeopleSoft
More like this