...
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 | integerSystem property | 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 | text | Yes | 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 |