...
Data Element (column) | Data Type | Length | Allows Null | Downloadable | In Report Center? | In Rules? | Notes |
---|---|---|---|---|---|---|---|
address_verified | boolean | Yes | Yes | Yes | |||
agent_phone_ext | varchar | 4 | Yes | Yes | Yes | Not currently used | |
agent_phone_number | varchar | 25 | Yes | Yes | Yes | ||
alt_non_us_phone_auth_txt | boolean | Yes | Yes | Not currently used | |||
alt_non_us_phone_ext | varchar | 4 | Yes | Yes | Not currently used | ||
alt_non_us_phone_number | varchar | 25 | Yes | Yes | Yes | ||
app_id | bigint | No | Yes | Yes | |||
app_lang | char | 2 | Yes | Yes | Yes | ||
authorize_agent_info_release | boolean | Yes | Yes | Yes | |||
birthdate | date | Yes | 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 | Yes | ||
city | varchar | 50 | Yes | Yes | Yes | Agent's City | |
coenroll_confirm | char | 1 | Yes | Yes | Yes | Not currently used | |
col1_cds | varchar | 30 | Yes | Yes | Yes | ||
col1_ceeb | varchar | 30 | Yes | Yes | Yes | ||
col1_city | varchar | 50 | Yes | Yes | Yes | ||
col1_college_attended_id | bigint | No | Yes | Yes | |||
col1_country | char | 2 | Yes | Yes | Yes | ||
col1_degree_date | date | Yes | Yes | Yes | |||
col1_degree_obtained | char | 1 | Yes | Yes | Yes | ||
col1_end_date | date | Yes | Yes | Yes | |||
col1_expelled_status | boolean | Yes | Yes | Yes | |||
col1_major | varchar | 50 | Yes | Yes | Yes | ||
col1_name | varchar | 30 | Yes | Yes | Yes | ||
col1_non_us_province | varchar | 50 | Yes | Yes | Yes | ||
col1_not_listed | boolean | Yes | Yes | Yes | |||
col1_primary_instruction_language | varchar | 5010 | Yes | Yes | Yes | ||
col1_start_date | date | Yes | Yes | Yes | |||
col1_state | varchar | 2 | Yes | Yes | Yes | ||
col2_cds | varchar | 30 | Yes | Yes | Yes | ||
col2_ceeb | varchar | 30 | Yes | Yes | Yes | ||
col2_city | varchar | 50 | Yes | Yes | Yes | ||
col2_college_attended_id | bigint | No | Yes | Yes | |||
col2_country | char | 2 | Yes | Yes | Yes | ||
col2_degree_date | date | Yes | Yes | Yes | |||
col2_degree_obtained | char | 1 | Yes | Yes | Yes | ||
col2_end_date | date | Yes | Yes | Yes | |||
col2_expelled_status | boolean | Yes | Yes | Yes | |||
col2_major | varchar | 50 | Yes | Yes | Yes | ||
col2_name | varchar | 30 | Yes | Yes | Yes | ||
col2_non_us_province | varchar | 50 | Yes | Yes | Yes | ||
col2_not_listed | boolean | Yes | Yes | Yes | |||
col2_primary_instruction_language | varchar | 10 | Yes | Yes | Yes | ||
col2_start_date | date | Yes | Yes | Yes | |||
col2_state | varchar | 2 | Yes | Yes | Yes | ||
col3_cds | varchar | 30 | Yes | Yes | Yes | ||
col3_ceeb | varchar | 30 | Yes | Yes | Yes | ||
col3_city | varchar | 50 | Yes | Yes | Yes | ||
col3_college_attended_id | bigint | No | Yes | Yes | |||
col3_country | char | 2 | Yes | Yes | Yes | ||
col3_degree_date | date | Yes | Yes | Yes | |||
col3_degree_obtained | char | 1 | Yes | Yes | Yes | ||
col3_end_date | date | Yes | Yes | Yes | |||
col3_expelled_status | boolean | Yes | Yes | Yes | |||
col3_major | varchar | 50 | Yes | Yes | Yes | ||
col3_name | varchar | 30 | Yes | Yes | Yes | ||
col3_non_us_province | varchar | 50 | Yes | Yes | Yes | ||
col3_not_listed | boolean | Yes | Yes | Yes | |||
col3_primary_instruction_language | varchar | 10 | Yes | Yes | Yes |
col3_start_date | date | Yes | Yes | Yes | |||||||||||||||||
col3_state | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
col4_cds | varchar | 30 | Yes | Yes | Yes | ||||||||||||||||
col4_ceeb | varchar | 30 | Yes | Yes | Yes | ||||||||||||||||
col4_city | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
col4_college_attended_id | bigint | No | Yes | Yes | |||||||||||||||||
col4_country | char | 2 | Yes | Yes | Yes | ||||||||||||||||
col4_degree_date | date | Yes | Yes | Yes | |||||||||||||||||
col4_degree_obtained | char | 1 | Yes | Yes | Yes | ||||||||||||||||
col4_end_date | date | Yes | Yes | Yes | |||||||||||||||||
col4_expelled_status | boolean | Yes | Yes | Yes | |||||||||||||||||
col4_major | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
col4_name | varchar | 30 | Yes | Yes | Yes | ||||||||||||||||
col4_non_us_province | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
col4_not_listed | boolean | Yes | Yes | Yes | |||||||||||||||||
col4_primary_instruction_language | varchar | 10 | Yes | Yes | Yes | ||||||||||||||||
col4_start_date | date | Yes | Yes | Yes | |||||||||||||||||
col4_state | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
college_comp_date | date | Yes | Yes | ||||||||||||||||||
college_count | smallint | Yes | Yes | Yes | |||||||||||||||||
college_edu_level | char | 12 | Yes | Yes | |||||||||||||||||
college_expelled_summary | boolean | Yes | Yes | Yes | |||||||||||||||||
college_id | char | 3 | Yes | Yes | Yes | ||||||||||||||||
college_name | char | 50 | Yes | Yes | Yes | ||||||||||||||||
company | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
confirmation | varchar | 30 | Yes | Yes | Yes | ||||||||||||||||
consent | boolean | Yes | Yes | Yes | |||||||||||||||||
contact | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
country | varchar | 2 | Yes | Yes | Yes | Agent's Country | |||||||||||||||
country_of_birth | char | 2 | Yes | Yes | Yes | ||||||||||||||||
country_of_citizenship | char | 2 | Yes | Yes | Yes | ||||||||||||||||
cryptokeyid | integer | Yes | System property | ||||||||||||||||||
current_mailing_address_outside_us | boolean | Yes | Yes | Yes | Not currently used | ||||||||||||||||
current_mailing_address_verified | boolean | Yes | Yes | Yes | |||||||||||||||||
current_mailing_city | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
current_mailing_country | char | 2 | Yes | Yes | Yes | ||||||||||||||||
current_mailing_non_us_address | boolean | Yes | Yes | Yes | |||||||||||||||||
current_mailing_non_us_postal_code | varchar | 30 | Yes | Yes | Yes | ||||||||||||||||
current_mailing_non_us_province | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
current_mailing_same_as_permanent | boolean | Yes | Yes | ||||||||||||||||||
current_mailing_state | char | 2 | Yes | Yes | Yes | ||||||||||||||||
current_mailing_street_1 | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
current_mailing_street_2 | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
current_mailing_zip_code | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
dep1_country_of_birth | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
dep1_date_of_birth | date | Yes | Yes | Yes | |||||||||||||||||
dep1_dependent_id | bigint | No | Yes | Yes | |||||||||||||||||
dep1_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep1_gender | varchar | 1 | Yes | Yes | Yes | ||||||||||||||||
dep1_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep1_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
dep1_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
dep10_country_of_birth | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
dep10_date_of_birth | date | Yes | Yes | Yes | |||||||||||||||||
dep10_dependent_id | bigint | No | Yes | Yes | |||||||||||||||||
dep10_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep10_gender | varchar | 1 | Yes | Yes | Yes | ||||||||||||||||
dep10_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep10_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
dep10_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
dep2_country_of_birth | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
dep2_date_of_birth | date | Yes | Yes | Yes | |||||||||||||||||
dep2_dependent_id | bigint | No | Yes | Yes | |||||||||||||||||
dep2_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep2_gender | varchar | 1 | Yes | Yes | Yes | ||||||||||||||||
dep2_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep2_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
dep2_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
dep3_country_of_birth | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
dep3_date_of_birth | date | Yes | Yes | Yes | |||||||||||||||||
dep3_dependent_id | bigint | No | Yes | Yes | |||||||||||||||||
dep3_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep3_gender | varchar | 1 | Yes | Yes | Yes | ||||||||||||||||
dep3_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep3_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
dep3_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
dep4_country_of_birth | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
dep4_date_of_birth | date | Yes | Yes | Yes | |||||||||||||||||
dep4_dependent_id | bigint | No | Yes | Yes | |||||||||||||||||
dep4_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep4_gender | varchar | 1 | Yes | Yes | Yes | ||||||||||||||||
dep4_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep4_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
dep4_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
dep5_country_of_birth | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
dep5_date_of_birth | date | Yes | Yes | Yes | |||||||||||||||||
dep5_dependent_id | bigint | No | Yes | Yes | |||||||||||||||||
dep5_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep5_gender | varchar | 1 | Yes | Yes | Yes | ||||||||||||||||
dep5_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep5_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
dep5_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
dep6_country_of_birth | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
dep6_date_of_birth | date | Yes | Yes | Yes | |||||||||||||||||
dep6_dependent_id | bigint | No | Yes | Yes | |||||||||||||||||
dep6_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep6_gender | varchar | 1 | Yes | Yes | Yes | ||||||||||||||||
dep6_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep6_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
dep6_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
dep7_country_of_birth | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
dep7_date_of_birth | date | Yes | Yes | Yes | |||||||||||||||||
dep7_dependent_id | bigint | No | Yes | Yes | |||||||||||||||||
dep7_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep7_gender | varchar | 1 | Yes | Yes | Yes | ||||||||||||||||
dep7_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep7_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
dep7_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
dep8_country_of_birth | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
dep8_date_of_birth | date | Yes | Yes | Yes | |||||||||||||||||
dep8_dependent_id | bigint | No | Yes | Yes | |||||||||||||||||
dep8_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep8_gender | varchar | 1 | Yes | Yes | Yes | ||||||||||||||||
dep8_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep8_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
dep8_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
dep9_country_of_birth | varchar | 2 | Yes | Yes | Yes | ||||||||||||||||
dep9_date_of_birth | date | Yes | Yes | Yes | |||||||||||||||||
dep9_dependent_id | bigint | No | Yes | Yes | |||||||||||||||||
dep9_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep9_gender | varchar | 1 | Yes | Yes | Yes | ||||||||||||||||
dep9_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
dep9_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
dep9_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
educational_goal | char | 1 | Yes | Yes | Yes | ||||||||||||||||
varchar | 254 | Yes | Yes | Yes | From Account | ||||||||||||||||
emergency_contact_address_verified | boolean | Yes | Yes | Yes | |||||||||||||||||
emergency_contact_city | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_country | char | 2 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_email | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||||||
emergency_contact_non_us_address | boolean | Yes | Yes | Yes | |||||||||||||||||
emergency_contact_non_us_postal_code | varchar | 30 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_non_us_province | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_phone_auth_txt | boolean | Yes | Yes | ||||||||||||||||||
emergency_contact_phone_ext | varchar | 4 | Yes | Yes | Not currently used | ||||||||||||||||
emergency_contact_phone_number | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_relationship | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_state | char | 2 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_street_1 | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_street_2 | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
emergency_contact_zip_code | varchar | 20 | Yes | Yes | Yes | ||||||||||||||||
eng_months_studied | smallint | Yes | Yes | Yes | Not currently used | ||||||||||||||||
eng_proficiency_date | date | Yes | Yes | Yes | |||||||||||||||||
eng_proficiency_other | varchar | 50 | Yes | Yes | Yes | ||||||||||||||||
eng_proficiency_prerequisite | boolean | Yes | |||||||||||||||||||
eng_proficiency_req | text | Yes | Yes | Yes | |||||||||||||||||
eng_proficiency_score | char | 6 | Yes | Yes | Yes | ||||||||||||||||
eng_proficiency_show_score | boolean | Yes | Yes | Yes | |||||||||||||||||
eng_proficiency_type | char | 2 | Yes | Yes | Yes | ||||||||||||||||
enroll_status | char | 1 | Yes | Yes | Yes | ||||||||||||||||
enroll_term_code | varchar | 15 | Yes | Yes | Yes | ||||||||||||||||
enroll_term_description | varchar | 100 | Yes | Yes | Yes | ||||||||||||||||
esignature | boolean | Yes | Yes | Yes | |||||||||||||||||
expiration_date | date | Yes | Yes | Yes | |||||||||||||||||
fax_number_number | varchar | 25 | Yes | Yes | Yes | ||||||||||||||||
firstname | varchar | 50 | Yes | Yes | Yes | From Account | |||||||||||||||
gender | char | 1 | Yes | Yes | Yes | ||||||||||||||||
higher_lang | varchar | 10 | Yes | Yes | Yes | Not currently used | |||||||||||||||
highest_comp_date | date | Yes | Yes | Yes | |||||||||||||||||
highest_edu_level | varchar | 5 | Yes | Yes | Yes | ||||||||||||||||
hispanic | boolean | Yes | Yes | Yes | |||||||||||||||||
hs_address_verified | boolean | Yes | Yes | Yes | Not currently used | ||||||||||||||||
hs_cds | char | 30 | Yes | Yes | Yes | ||||||||||||||||
hs_ceeb | char | 30 | Yes | Yes | Yes | ||||||||||||||||
hs_city | varchar | 50 | Yes | Yes | Yes |
hs_comp_date | date | Yes | Yes | Yes | |||||||||||||
hs_country | char | 2 | Yes | Yes | Yes | ||||||||||||
hs_diploma_cert | char | 12 | Yes | Yes | Not currently used | ||||||||||||
hs_diploma_cert_date | date | Yes | Yes | Not currently used | |||||||||||||
hs_edu_level | char | 1 | Yes | Yes | Yes | ||||||||||||
hs_end_date | date | Yes | Yes | Yes | |||||||||||||
hs_lang | varchar | 10 | Yes | Yes | Yes | ||||||||||||
hs_name | varchar | 40 | Yes | Yes | Yes | ||||||||||||
hs_non_us_address | boolean | Yes | Yes | Yes | Not currently used | ||||||||||||
hs_non_us_postal_code | varchar | 30 | Yes | Yes | Yes | Not currently used | |||||||||||
hs_non_us_province | varchar | 50 | Yes | Yes | Yes | Not currently used | |||||||||||
hs_not_listed | boolean | Yes | Yes | Yes | |||||||||||||
hs_start_date | date | Yes | Yes | Yes | |||||||||||||
hs_state | char | 2 | Yes | Yes | Yes | ||||||||||||
hs_street_1 | varchar | 50 | Yes | Yes | Yes | ||||||||||||
hs_street_2 | varchar | 50 | Yes | Yes | Yes | ||||||||||||
hs_type | char | 1 | Yes | Yes | Yes | ||||||||||||
hs_zip_code | varchar | 20 | Yes | Yes | Yes | Not currently used | |||||||||||
i20_expiration_date | date | Yes | Yes | Yes | |||||||||||||
i20_issuing_school_name | varchar | 20 | Yes | Yes | Yes | ||||||||||||
i94_admission_number | varchar | 32 | Yes | Yes | Yes | ||||||||||||
i94_expiration_date | date | Yes | 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 | Yes | |||||||||||||
last_page | varchar | 30 | Yes | Yes | Yes | System property | |||||||||||
lastname | varchar | 50 | Yes | Yes | Yes | From Account | |||||||||||
main_phone_auth_txt | boolean | Yes | Yes | Yes | From Account | ||||||||||||
main_phone_ext | varchar | 4 | Yes | Yes | Yes | From Account | |||||||||||
main_phone_number | varchar | 25 | Yes | 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 | Yes | |||||||||||||
no_visa | boolean | Yes | Yes | Yes | |||||||||||||
non_us_address | boolean | Yes | Yes | Yes | Not currently | ||||||||||||
non_us_permanent_home_address_same _as_permanent | boolean | Yes | |||||||||||||||
non_us_permanent_home_address_verifi ed | boolean | Yes | Yes | Yes | |||||||||||||
non_us_permanent_home_city | varchar | 50 | Yes | Yes | Yes | ||||||||||||
non_us_permanent_home_country | char | 2 | Yes | Yes | Yes | ||||||||||||
non_us_permanent_home_non_us_addre ss | boolean | Yes | Yes | Yes | Always "TRUE" | ||||||||||||
non_us_permanent_home_non_us_posta l_code | varchar | 30 | Yes | Yes | Yes | ||||||||||||
non_us_permanent_home_non_us_provi nce | varchar | 50 | Yes | Yes | Yes | ||||||||||||
non_us_permanent_home_street_1 | varchar | 50 | Yes | Yes | Yes | ||||||||||||
non_us_permanent_home_street_2 | varchar | 50 | Yes | Yes | Yes | ||||||||||||
non_us_phone_auth_txt | boolean | Yes | Yes | Not currently used | |||||||||||||
non_us_phone_ext | varchar | 4 | Yes | Yes | Not currently used | ||||||||||||
non_us_phone_number | varchar | 25 | Yes | Yes | Yes | ||||||||||||
non_us_postal_code | varchar | 30 | Yes | Yes | Yes | Agent's Postal Code | |||||||||||
non_us_province | varchar | 50 | Yes | Yes | Yes | Agent's State/Province | |||||||||||
number_of_dependents | smallint | Yes | Yes | Yes | |||||||||||||
number_of_practical_training | smallint | Yes | Yes | Yes | |||||||||||||
otherfirstname | varchar | 50 | Yes | Yes | Yes | From Account | |||||||||||
otherlastname | varchar | 50 | Yes | Yes | Yes | From Account | |||||||||||
othermiddlename | varchar | 50 | Yes | Yes | Yes | From Account | |||||||||||
parent_guardian_address_verified | boolean | Yes | Yes | Yes | |||||||||||||
parent_guardian_city | varchar | 50 | Yes | Yes | Yes | ||||||||||||
parent_guardian_country | char | 2 | Yes | Yes | Yes | ||||||||||||
parent_guardian_email | varchar | 50 | Yes | Yes | Yes | ||||||||||||
parent_guardian_first_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||
parent_guardian_last_name | varchar | 25 | Yes | Yes | Yes | ||||||||||||
parent_guardian_no_first_name | boolean | Yes | Yes | Yes | |||||||||||||
parent_guardian_non_us_address | boolean | Yes | Yes | Yes | |||||||||||||
parent_guardian_non_us_postal_code | varchar | 30 | Yes | Yes | Yes | ||||||||||||
parent_guardian_non_us_province | varchar | 50 | Yes | Yes | Yes | ||||||||||||
parent_guardian_phone_auth_txt | boolean | Yes | Yes | ||||||||||||||
parent_guardian_phone_ext | varchar | 4 | Yes | Yes | Not currently used | ||||||||||||
parent_guardian_phone_number | varchar | 25 | Yes | Yes | Yes | ||||||||||||
parent_guardian_relationship | char | 1 | Yes | Yes | Yes | ||||||||||||
parent_guardian_state | char | 2 | Yes | Yes | Yes | ||||||||||||
parent_guardian_street_1 | varchar | 50 | Yes | Yes | Yes | ||||||||||||
parent_guardian_street_2 | varchar | 50 | Yes | Yes | Yes | ||||||||||||
parent_guardian_zip_code | varchar | 20 | Yes | Yes | Yes | ||||||||||||
passport_country_of_issuance | char | 2 | Yes | Yes | Yes | ||||||||||||
passport_expiration_date | date | Yes | Yes | Yes | |||||||||||||
passport_not_yet | boolean | Yes | Yes | Yes | |||||||||||||
passport_number | varchar | 20 | Yes | Yes | Yes | ||||||||||||
perm_addr_address_verified | boolean | Yes | Yes | Yes | From Account | ||||||||||||
perm_addr_city | varchar | 50 | Yes | Yes | Yes | From Account | |||||||||||
perm_addr_country | char | 2 | Yes | Yes | Yes | From Account | |||||||||||
perm_addr_non_us_address | boolean | Yes | Yes | Yes | From Account | ||||||||||||
perm_addr_non_us_postal_code | varchar | 30 | Yes | Yes | Yes | From Account | |||||||||||
perm_addr_non_us_province | varchar | 50 | Yes | Yes | Yes | From Account | |||||||||||
perm_addr_state | char | 2 | Yes | Yes | Yes | From Account | |||||||||||
perm_addr_street_1 | varchar | 50 | Yes | Yes | Yes | From Account | |||||||||||
perm_addr_street_2 | varchar | 50 | Yes | Yes | Yes | From Account | |||||||||||
perm_addr_zip_code | varchar | 20 | Yes | Yes | Yes | From Account | |||||||||||
phone_auth_txt | boolean | Yes | Yes | Not currently used | |||||||||||||
phone_ext | varchar | 4 | Yes | Yes | Yes | Not currently used | |||||||||||
phone_number | varchar | 25 | Yes | Not currently used; Currently holds same value as alt_non_us_ phone_number | |||||||||||||
preferred_firstname | varchar | 50 | |||||||||||||||
preferred_lastname | varchar | 50 | |||||||||||||||
preferred_middlename | varchar | 50 | |||||||||||||||
preferred_name | boolean | ||||||||||||||||
presently_studying_in_us | boolean | Yes | Yes | Yes | |||||||||||||
primary_language | varchar | 10 | Yes | Yes | Yes | ||||||||||||
pt1_authorizing_school | varchar | 32 | Yes | Yes | Yes | ||||||||||||
pt1_end_date | date | Yes | Yes | Yes | |||||||||||||
pt1_practical_training_id | bigint | No | Yes | Yes | |||||||||||||
pt1_start_date | date | Yes | Yes | Yes | |||||||||||||
pt1_type | varchar | 3 | Yes | Yes | Yes | ||||||||||||
pt2_authorizing_school | varchar | 32 | Yes | Yes | Yes | ||||||||||||
pt2_end_date | date | Yes | Yes | Yes | |||||||||||||
pt2_practical_training_id | bigint | No | Yes | Yes | |||||||||||||
pt2_start_date | date | Yes | Yes | Yes | |||||||||||||
pt2_type | varchar | 3 | Yes | Yes | Yes | ||||||||||||
pt3_authorizing_school | varchar | 32 | Yes | Yes | Yes | ||||||||||||
pt3_end_date | date | Yes | Yes | Yes | |||||||||||||
pt3_practical_training_id | bigint | No | Yes | Yes | |||||||||||||
pt3_start_date | date | Yes | Yes | Yes | |||||||||||||
pt3_type | varchar | 3 | Yes | Yes | Yes | ||||||||||||
pt4_authorizing_school | varchar | 32 | Yes | Yes | Yes | ||||||||||||
pt4_end_date | date | Yes | Yes | Yes | |||||||||||||
pt4_practical_training_id | bigint | No | Yes | Yes | |||||||||||||
pt4_start_date | date | Yes | Yes | Yes | |||||||||||||
pt4_type | varchar | 3 | Yes | Yes | Yes | ||||||||||||
race_ethnicity | Text string | Yes | Yes | Yes | Fixed 9.30.16 | ||||||||||||
race_ethnic_full | Text string | 805 | Yes | Yes | Yes | v.6.3.0 2018 | |||||||||||
race_group | Text string | Yes | Yes | Yes | Fixed 9.30.16 | ||||||||||||
salt | text | NO | NO | NO | System property | ||||||||||||
second_phone_auth_txt | boolean | Yes | Yes | Yes | From Account | ||||||||||||
second_phone_ext | varchar | 4 | Yes | Yes | Yes | From Account | |||||||||||
second_phone_number | varchar | 25 | Yes | Yes | Yes | From Account | |||||||||||
sevis_id_number | varchar | 11 | Yes | Yes | Yes | ||||||||||||
signature | text | No | Yes | Not currently used | |||||||||||||
ssn | text | Yes | Yes | Yes | |||||||||||||
ssn_exception |
boolean
boolean Default = false | Yes | ||||||||||||||||
ssn_last4 | char | 4 | Yes | ||||||||||||||
ssn_type | char | 1 | Yes | Yes | |||||||||||||
state | varchar | 2 | Yes | Yes | Yes | Not currently used | |||||||||||
status | char | Yes | Yes | Yes | Application download status | ||||||||||||
street_1 | varchar | 50 | Yes | Yes | Yes | Agent street address 1 | |||||||||||
street_2 | varchar | 50 | Yes | Yes | Yes | Agent street address 2 | |||||||||||
suffix | varchar | 3 | Yes | Yes | Yes | From Account | |||||||||||
sup_page_code | varchar | 30 | Yes | Yes | Yes | ||||||||||||
term_end_date | Date | Yes | Yes | Yes | Added 9/30/16 | ||||||||||||
term_start_date | Date | Yes | Yes | Yes | Added 9/30/16 | ||||||||||||
tstmp_create | timestamp with time zone Default=now | () | Yes | ||||||||||||||
tstmp_download | timestamp with time zone | Yes | Yes | ||||||||||||||
tstmp_submit | timestamp with time zone | Yes | Yes | Yes | |||||||||||||
tstmp_update | timestamp with time zone | Yes | Yes | Yes | |||||||||||||
visa_type | varchar | 4 | Yes | Yes | Yes | ||||||||||||
zip_code | varchar | 20 | Yes | Yes | Yes | Not currently used |
Account Data in the
...
International Application
Each submitted CCCApply International application includes data fields that are automatically populated from each student's OpenCCC Account. The table below displays the OpenCCC Account
database columns and their corresponding columns that they populate in the CCCApply International table.
Data Item | Account Data Element | Application Data Element |
---|---|---|
CCCID | cccid | ccc_id |
Date of Birth | birthdate | birthdate |
Email Address | ||
Legal Name: First | firstname | firstname |
Legal Name: Last | lastname | lastname |
Legal Name: Middle | middlename | middlename |
Legal Name:Suffix | suffix | suffix |
Main Telephone | mainphone | main_phone_number |
Main Telephone Extension | mainphone_ext | main_phone_ext |
Permanent Address: City | city | perm_addr_city |
Permanent Address: Country | county | perm_country |
Permanent Address: Non-U.S. State/ Province | nonusaprovince | perm_addr_nonusaprovince |
Permanent Address: Postal Code | postalcode | perm_addr_zip_code perm_addr_non_us_postal_code |
Permanent Address: State | state | perm_addr_state |
Permanent Address: Street 1 | streetaddress1 | perm_addr_streetaddress_1 |
Permanent Address: Street 2 | streetaddress2 | perm_addr_streetaddress_2 |
Preferred Name: First | preferred_firstname | preferred_firstname |
Preferred Name: Last | preferred_lastname | preferred_lastname |
Preferred Name: Middle | preferred_middlename | preferred_middlename |
Previous Name: First | otherfirstname | otherfirstname |
Previous Name: Last | otherlastname | otherlastname |
Previous Name: Middle | othermiddlename | othermiddlename |
Second Telephone | secondphone | second_phone_number |
Second Telephone Extension | secondphone_ext | secondphone_ext |
Social Security Number: Other Exception | ssn_exception | ssn_exception |
Social Security Number: None | ssn_no | ssn_no |
Social Security Number/TIN | ssn | ssn |
Social Security Number/TIN Type | ssn_type | ssn_type |
Text Permission: Main Telephone | mainphone_auth_txt | main_phone_auth_text |
Text Permission: Second Telephone | secondphone_auth_txt | second_phone_auth_txt |
Crypto key id: Internal System Field | cryptokeyid | cryptokeyid |
Data Fields: Promise Grant Application
The table below includes all the columns/fields you can download to your college SIS for the Promise Grant application. Refer to the CC Promise Grant Data Dictionary for detailed field definitions.
...
Account Data in the CC Promise Grant Application
Data Item | Account Data Element | Application Data Element |
---|---|---|
CCCID | cccid | ccc_id |
Date of Birth | birthdate | birthdate |
Email Address | ||
Legal Name: First | firstname | firstname |
Legal Name: Last | lastname | lastname |
Legal Name: Middle | middlename | middlename |
Main Telephone | mainphone | mainphone |
Main Telephone Extension | mainphone_ext | mainphone_ext |
Permanent Address: No Address | no_perm_address_homeless | no_perm_address_homeless |
Permanent Address: City | city | city |
Permanent Address: Country | county | country |
Permanent Address: Non-U.S. State/Province | nonusaprovince | province |
Permanent Address: Postal Code | postalcode | postalcode |
Permanent Address: State | state | state |
Permanent Address: Street 1 | streetaddress1 | streetaddress1 |
Permanent Address: Street 2 | streetaddress2 | streetaddress2 |
Preferred Name: First | preferred_firstname | preferred_firstname |
Preferred Name: Last | preferred_lastname | preferred_lastname |
Preferred Name: Middle | preferred_middlename | preferred_middlename |
Previous Name: First | previous_firstname | previous_firstname |
Previous Name: Middle | previous_middlename | previous_middlename |
Previous Name: Last | previous_lastname | previous_lastname |
Social Security Number: Other Exception | ssn_exception | ssn_exception |
Social Security Hash | ssn_hash | ssn_hash |
Social Security Number: None | ssn_no | ssn_no |
Social Security Number/TIN | ssn | ssn |
Social Security Number/TIN Type | ssn_type | ssn_type |
Text Permission: Main Telephone | mainphone_auth_txt | mainphone_auth_text |
Crypto key id: Internal System Field | cryptokeyid | cryptokeyid |
...
...
...
CC Promise Grant Application Downloadable Fields
Data Element (column) | Data Type | Length |
---|
Allows
Allows Null |
---|
Downloadable | In |
---|
Report
the Report Center? | In the |
---|
Rules Area? | Notes? | ||||||
---|---|---|---|---|---|---|---|
ack_fin_aid | boolean | Yes | Yes | Yes | |||
app_id | bigint | No | Yes | Yes | No | ||
app_lang | string | 2 | Yes | Yes | Yes | ||
birthdate | date | Yes | Yes | Yes | |||
born_before_23_year | string | 1 | Yes | Yes | Yes | ||
campaign1 | string | 255 | Yes | Yes | No | ||
campaign2 | string | 255 | Yes | Yes | No | ||
campaign3 | string | 255 | Yes | Yes | No | ||
ccc_id | string | 8 | No | Yes | Yes | Yes | |
cert_national_guard | string | 1 | Yes | Yes | Yes | ||
cert_veteran_affairs | string | 1 | Yes | Yes | Yes | ||
city | string | 50 | Yes | Yes | Yes | ||
college_id | string | 3 | Yes | Yes | Yes | ||
college_name | string | 50 | Yes | Yes | Yes | ||
confirmation_applicant | boolean | Yes | Yes | Yes | |||
confirmation_number | String | 25 | Yes | Yes | Yes | ||
confirmation_parent_guardian | boolean | Yes | Yes | Yes | |||
country | string | 2 | Yes | Yes | Yes | ||
dep_gross_income | integer | Yes | Yes | Yes | |||
dep_number_household | integer | Yes | Yes | Yes | |||
dep_other_income | integer | Yes | Yes | Yes | |||
dep_total_income | integer | Yes | Yes | Yes | |||
dependency_status | string | 1 | Yes | Yes | Yes | ||
dependent_on_parent_taxes | string | 1 | Yes | Yes | Yes | ||
dependents | string | 1 | Yes | Yes | Yes | ||
determined_ab540_eligible | string | 1 | Yes | Yes | Yes | ||
determined_homeless | String | 1 | Yes | Yes | Yes | Added Mar 2017 | |
determined_non_res_exempt | string | 1 | Yes | Yes | Yes | ||
determined_residentca | string | 1 | Yes | Yes | Yes | ||
elig_bogfw | String | 1 | Yes | Yes | Yes | ||
elig_medal_honor | string | 1 | Yes | Yes | Yes | ||
elig_method_a | boolean | Yes | Yes | Yes | |||
elig_method_b | boolean | Yes | Yes | Yes | |||
elig_method_d | Boolean | Yes | Yes | Yes | 3.31.17 | ||
elig_police_fire | string | 1 | Yes | Yes | Yes | ||
elig_sept_11 | string | 1 | Yes | Yes | Yes | ||
String | 50 | Yes | Yes | Yes | |||
emancipated_minor | string | 1 | Yes | Yes | Yes | ||
firstname | string | 50 | Yes | Yes | Yes | ||
general_assistance | string | 1 | Yes | Yes | Yes | ||
homeless_youth_hud | string | 1 | Yes | Yes | Yes | ||
homeless_youth_other | string | 1 | Yes | Yes | Yes | ||
homeless_youth_school | string | 1 | Yes | Yes | Yes | ||
ind_gross_income | Integer | Yes | Yes | Yes | |||
ind_number_household | integer | Yes | Yes | Yes | |||
ind_other_income | integer | Yes | Yes | Yes | |||
ind_total_income | integer | Yes | Yes | Yes | |||
ip_address | string | 15 | Yes | No | No | ||
last_page | string | 25 | Yes | Yes | Yes | ||
lastname | string | 50 | Yes | Yes | Yes | ||
legal_guardianship | string | 1 | Yes | Yes | Yes | ||
living_with_parents | string | 1 | Yes | Yes | Yes | ||
mainphone | string | 14 | Yes | Yes | Yes | ||
mainphone_auth_text | boolean | Yes | Yes | Yes | |||
mainphone_ext | string | 4 | Yes | Yes | Yes | ||
marital_status | string | 1 | Yes | Yes | Yes | ||
married_or_rdp | string | 1 | Yes | Yes | Yes | ||
middlename | string | 50 | Yes | Yes | Yes | ||
no_mailing_address_homeless | Boolean | Yes | Yes | Yes | 3.31.17 | ||
no_perm_address_homeless | Boolean | Yes | Yes | Yes | 3.31.17 | ||
non_us_address | Boolean | Yes | Yes | Yes | |||
parent_guardian_name | string | 60 | Yes | Yes | Yes | ||
parents_assistance | string | 1 | Yes | Yes | Yes | ||
parents_deceased | string | 1 | Yes | Yes | Yes | ||
postalcode | string | 20 | Yes | Yes | Yes | ||
preferred_firstname | string | 50 | Yes | Yes | Yes | ||
preferred_lastname | string | 50 | Yes | Yes | Yes | ||
preferred_middlename | string | 50 | Yes | Yes | Yes | ||
preferred_name | boolean | Yes | Yes | Yes | |||
otherfirstname | String | 50 | No | ||||
othermiddlename | String | 50 | No | ||||
otherlastname | String | 50 | No | ||||
othername | String | 50 | No | ||||
province | string | 30 | Yes | Yes | Yes | ||
reg_dom_partner | string | 1 | Yes | Yes | Yes | ||
ssi_ssp | string | 1 | Yes | Yes | Yes | ||
ssn | string | Yes | No | No | |||
ssn_exception | boolean | Yes | Yes | Yes | |||
ssn_hash | string | Yes | No | No | |||
ssn_last4 | string | 4 | Yes | Yes | |||
ssn_no | Boolean | Yes | Yes | Yes | |||
ssn_type | string | 1 | Yes | Yes | Yes | ||
state | string | 2 | Yes | Yes | Yes | ||
status | String | 1 | Yes | Yes | Yes | ||
streetaddress1 | string | 50 | Yes | Yes | Yes | ||
streetaddress2 | string | 50 | Yes | Yes | Yes | ||
student_college_id | string | 20 | Yes | Yes | Yes | ||
tanf_calworks | string | 1 | Yes | Yes | Yes | ||
term_code | string | 5 | Yes | Yes | Yes | ||
tstmp_create | date | tmstmp w/ time zone | Yes | Yes | |||
tstmp_download | date | tmstmp w/ time zone | Yes | Yes | |||
tstmp_submit | date | tmstmp w/ time zone | Yes | Yes | |||
tstmp_update | date | tmstmp w/ time zone | Yes | Yes | |||
us_veteran | string | 1 | Yes | Yes | Yes | ||
year_code | bigint | NO | Yes | Not downloadable | |||
year_description | string | 100 | Yes | Yes | Yes |
Data Fields: Supplemental Questions Responses
...