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 |