...
The table below includes all the columns/fields you can download to your college SIS for the CCCApply Standard application. Refer to the CCCApply Data Dictionary for detailed field definitions.
Data Element (column) | Data Type | Length | Null | Download-able? | RC | Rules? | Notes |
---|---|---|---|---|---|---|---|
academic_counseling | boolean | Yes | Yes | Yes | |||
ack_fin_aid | boolean | Yes | Yes | Yes | |||
address_same | boolean | Yes | Yes | Yes | |||
address_validation | character | 1 | Yes | No | No | ||
adm_ineligible | smallint | Yes | Yes | Yes | |||
alien_reg_expire_date | date | Yes | Yes | Yes | Also used for VISA expire date | ||
alien_reg_issue_date | date | Yes | Yes | Yes | Also used for VISA issue date | ||
alien_reg_no_expire | boolean | Yes | Yes | Yes | Also used for VISA no expire date | ||
alien_reg_number | character varying | 20 | Yes | Yes | Yes | ||
app_id | bigint | NOT NULL | Yes | Yes | No | ||
app_lang | character | 2 | Yes | Yes | Yes | ||
athletic_intercollegiate | boolean | Yes | Yes | Yes | |||
athletic_intramural | boolean | Yes | Yes | Yes | |||
athletic_not_interested | boolean | Yes | Yes | Yes | |||
basic_skills | boolean | Yes | Yes | Yes | |||
birthdate | date | Yes | Yes | Yes | from OpenCCC Account | ||
ca_college_employee | boolean | Yes | Yes | Yes | |||
ca_date_current | date | Yes | Yes | Yes | |||
ca_foster_youth | boolean | Yes | Yes | Yes | |||
ca_not_arrived | boolean | Yes | Yes | Yes | |||
ca_outside_college | boolean | Yes | Yes | Yes | |||
ca_outside_college_year | date | Yes | Yes | Yes | |||
ca_outside_lawsuit | boolean | Yes | Yes | Yes | |||
ca_outside_lawsuit_year | date | Yes | Yes | Yes | |||
ca_outside_tax | boolean | Yes | Yes | Yes | |||
ca_outside_tax_year | date | Yes | Yes | Yes | |||
ca_outside_voted | boolean | Yes | Yes | Yes | |||
ca_outside_voted_year | date | Yes | Yes | Yes | |||
ca_res_2_years | boolean | Yes | Yes | Yes | |||
ca_school_employee | boolean | Yes | Yes | Yes | |||
ca_seasonal_ag | boolean | Yes | Yes | Yes | |||
cahs_3year | boolean | Yes | Yes | Yes | |||
cahs_graduated | boolean | Yes | Yes | Yes | |||
calworks | boolean | Yes | Yes | Yes | |||
campaign1 | character varying | 255 | Yes | Yes | No | ||
campaign2 | character varying | 255 | Yes | Yes | No | ||
campaign3 | character varying | 255 | Yes | Yes | No | ||
cap_major_id | bigint | No | No | No | System-generated | ||
cap_term_id | bigint | No | No | No | System-generated | ||
career_planning | boolean | Yes | Yes | Yes | |||
ccc_id | character varying | 8 | NOT NULL | Yes | Yes | Yes | from OpenCCC Account |
child_care | boolean | Yes | Yes | Yes | |||
cip_code | character | 6 | Yes | No | No | Admin 2.0 | |
citizenship_status | character | 1 |
NOT NULL | Yes | Yes | Yes | ||||
city | character varying | 50 | Yes | Yes | Yes | ||
coenroll_confirm | boolean | Yes | Yes | Yes | |||
col1_cds_full | Character varying | 14 | Yes | Yes | Yes | 3.31.17 | |
col2_cds_full | Character varying | 14 | Yes | Yes | Yes | 3.31.17 | |
col3_cds_full | Character varying | 14 | Yes | Yes | Yes | 3.31.17 | |
col4_cds_full | Character varying | 14 | Yes | Yes | Yes | 3.31.17 | |
col1_cds | character | 6 | Yes | Yes | Yes | ||
col1_ceeb | character | 7 | Yes | Yes | Yes | ||
col1_city | character varying | 20 | Yes | Yes | Yes | ||
col1_country | character | 2 | Yes | Yes | Yes | ||
col1_degree_date | date | Yes | Yes | Yes | |||
col1_degree_obtained | character | 1 | Yes | Yes | Yes | ||
col1_end_date | date | Yes | Yes | Yes | |||
col1_expelled_status | boolean | Yes | No | No | |||
col1_name | character varying | 30 | Yes | Yes | Yes | ||
col1_not_listed | boolean | Yes | Yes | Yes | |||
col1_start_date | date | Yes | Yes | Yes | |||
col1_state | character varying | 30 | Yes | Yes | Yes | ||
col2_cds | character | 6 | Yes | Yes | Yes | ||
col2_ceeb | character | 7 | Yes | Yes | Yes | ||
col2_city | character varying | 20 | Yes | Yes | Yes | ||
col2_country | character | 2 | Yes | Yes | Yes | ||
col2_degree_date | date | Yes | Yes | Yes | |||
col2_degree_obtained | character | 1 | Yes | Yes | Yes | ||
col2_end_date | date | Yes | Yes | Yes | |||
col2_expelled_status | boolean | Yes | No | No | |||
col2_name | character varying | 30 | Yes | Yes | Yes | ||
col2_not_listed | boolean | Yes | Yes | Yes | |||
col2_start_date | date | Yes | Yes | Yes | |||
col2_state | character varying | 30 | Yes | Yes | Yes | ||
col3_cds | character | 6 | Yes | Yes | Yes | ||
col3_ceeb | character | 7 | Yes | Yes | Yes | ||
col3_city | character varying | 20 | Yes | Yes | Yes | ||
col3_country | character | 2 | Yes | Yes | Yes | ||
col3_degree_date | date | Yes | Yes | Yes | |||
col3_degree_obtained | character | 1 | Yes | Yes | Yes | ||
col3_end_date | date | Yes | Yes | Yes | |||
col3_expelled_status | boolean | Yes | No | No | |||
col3_name | character varying | 30 | Yes | Yes | Yes | ||
col3_not_listed | boolean | Yes | Yes | Yes | |||
col3_start_date | date | Yes | Yes | Yes | |||
col3_state | character varying | 30 | Yes | Yes | Yes | ||
col4_cds | character | 6 | Yes | Yes | Yes | ||
col4_ceeb | character | 7 | Yes | Yes | Yes | ||
col4_city | character varying | 20 | Yes | Yes | Yes | ||
col4_country | character | 2 | Yes | Yes | Yes | ||
col4_degree_date | date | Yes | Yes | Yes | |||
col4_degree_obtained | character | 1 | Yes | Yes | Yes | ||
col4_end_date | date | Yes | Yes | Yes | |||
col4_expelled_status | boolean | Yes | No | No | |||
col4_name | character varying | 30 | Yes | Yes | Yes | ||
col4_not_listed | boolean | Yes | Yes | Yes | |||
col4_start_date | date | Yes | Yes | Yes | |||
col4_state | character varying | 30 | Yes | Yes | Yes | ||
college_count | smallint | Yes | Yes | Yes | |||
college_expelled_summary | boolean | Yes | No | No | |||
college_id | character | 3 | Yes | Yes | Yes | ||
college_name | character varying | 50 | Yes | Yes | Yes | ||
comfortable_english | boolean | Yes | Yes | Yes | |||
comments | text | Yes | Yes | Yes | |||
confirmation | character varying | 30 | Yes | Yes | Yes | ||
consent_indicator | boolean | Yes | Yes | Yes | |||
counseling_personal | boolean | Yes | Yes | Yes | |||
country | character | 2 | Yes | Yes | Yes | ||
cryptokeyid | integer | No | No | No | System use only | ||
dependent_status | character | 1 | Yes | No | Yes | ||
discharge_type | character varying | 1 | Yes | No | No | ||
district_name | character varying | 50 | Yes | Yes | Yes | ||
dsps | boolean | Yes | Yes | Yes | |||
edu_goal | character | 1 | Yes | Yes | Yes | ||
elig_ab540 | boolean | Yes | Yes | Yes | |||
character varying | 254 | Yes | Yes | Yes | from OpenCCC Account | ||
employment_assistance | boolean | Yes | Yes | Yes | |||
enroll_status | character | 1 | Yes | Yes | Yes | ||
eops | boolean | Yes | Yes | Yes | |||
esignature | boolean | Yes | Yes | Yes | |||
esl | boolean | Yes | Yes | Yes | |||
experience | integer | Yes | Yes | Yes | |||
fin_aid_ref | boolean | Yes | Yes | Yes | |||
financial_assistance | boolean | Yes | Yes | Yes | |||
firstname | character varying | 50 | Yes | Yes | Yes | from OpenCCC Account | |
foster_youth_mis | boolean | Yes | Yes | Yes | |||
foster_youth_preference | boolean | Yes | Yes | No | |||
foster_youth_priority | boolean | Yes | Yes | Yes | |||
foster_youth_status | character | 1 | Yes | Yes | Yes | ||
foster_youths | boolean | No longer used | No |
longer used | No longer used | No longer used in db | |||||
fraud_score | double precision | No | No | No | Added to Apply Only 6.2.0 | ||
fraud_status | integer | No | No | No | Added to Apply Only 6.2.0 | ||
gender | character | 1 | Yes | Yes | Yes | ||
health_services | boolean | Yes | Yes | Yes | |||
higher_comp_date | date | Yes | Yes | Yes | |||
higher_edu_level | character | 1 | Yes | Yes | Yes | ||
highest_edu_level | character | 5 | Yes | Yes | Yes | ||
hispanic | boolean | Yes | Yes | Yes | |||
home_schooled | boolean | Yes | Yes | Yes | |||
homeless_youth | Boolean | Yes | Yes | Yes | 3.31.17 | ||
housing_info | boolean | Yes | Yes | Yes | |||
hs_attendance | smallint | Yes | Yes | Yes | |||
hs_cds | character | 6 | Yes | Yes | Yes | ||
hs_cds_full | Character varying | 14 | Yes | Yes | Yes | 3.31.17 | |
hs_ceeb | character | 7 | Yes | Yes | Yes | ||
hs_city | character varying | 20 | Yes | Yes | Yes | ||
hs_comp_date | date | Yes | Yes | Yes | |||
hs_country | character | 2 | Yes | Yes | Yes | ||
hs_edu_level | character | 1 | Yes | Yes | Yes | ||
hs_name | character varying | 30 | Yes | Yes | Yes | ||
hs_not_attended | boolean | Yes | Yes | Yes | |||
hs_not_listed | boolean | Yes | Yes | Yes | |||
hs_state | character | 2 | Yes | Yes | Yes | ||
integrity_fg_01 | boolean | Yes | Yes | Yes | |||
integrity_fg_02 | boolean | Yes | Yes | Yes | |||
integrity_fg_03 | boolean | Yes | Yes | Yes | |||
integrity_fg_04 | boolean | Yes | Yes | Yes | |||
integrity_fg_11 | boolean | Yes | Yes | Yes | |||
integrity_fg_30 | Boolean | Yes | Yes | Yes | |||
Integrity_fg_40 | boolean | Yes | Yes | Yes |
2017-12 (AB801) | |||||||
Integrity_fg_41 | boolean | ||||||
integrity_fg_47 | boolean | Yes | Yes | Yes | |||
integrity_fg_48 | boolean | Yes | Yes | Yes | |||
integrity_fg_49 | boolean | Yes | Yes | Yes | |||
integrity_fg_50 | boolean | Yes | Yes | Yes | |||
integrity_fg_51 | boolean | Yes | Yes | Yes | |||
integrity_fg_52 | boolean | Yes | Yes | Yes | |||
integrity_fg_53 | boolean | Yes | Yes | Yes | |||
integrity_fg_54 | boolean | Yes | Yes | Yes | |||
integrity_fg_55 | boolean | Yes | Yes | Yes | |||
integrity_fg_56 | boolean | Yes | Yes | Yes | |||
integrity_fg_57 | boolean | Yes | Yes | Yes | |||
integrity_fg_58 | boolean | Yes | Yes | Yes | |||
integrity_fg_59 | boolean | Yes | Yes | Yes | |||
integrity_fg_60 | boolean | Yes | Yes | Yes | |||
integrity_fg_61 | boolean | Yes | Yes | Yes | |||
integrity_fg_62 | boolean | Yes | Yes | Yes | |||
integrity_fg_63 | boolean | Yes | Yes | Yes | |||
integrity_fg_64 | boolean | Yes | No | No | |||
integrity_fg_65 | boolean | Yes | Yes | Yes | |||
integrity_fg_70 | boolean | Yes | Yes | Yes | |||
integrity_fg_71 | boolean | Yes | No | Yes | |||
integrity_fg_80 | boolean | Yes | Yes | Yes | |||
integrity_flags | character varying | 255 | Yes | No | No | ||
intended_major | character varying | 30 | Yes | No | Yes | ||
lastname | character varying | 50 | Yes | Yes | Yes | from OpenCCC Account | |
ip_address | character varying | 15 | Yes | Yes | No | ||
last_page | character varying | 25 | Yes | No | No | ||
mainphone_auth_text | boolean | Yes | Yes | Yes | from OpenCCC Account | ||
mainphone_ext | character varying | 4 | Yes | Yes | Yes | from OpenCCC Account | |
mainphone | character varying | 14 | Yes | Yes | Yes | from OpenCCC Account | |
mainphoneintl | character varying | 25 | Yes | No | No | ||
major_category | character varying | 100 | Yes | No | No | Admin 2. |
0 v.6.2.0 | |||||||
major_code | character varying | 30 | Yes | Yes | Yes | ||
major_description | character varying | 100 | Yes | Yes | Yes | Extended to 100 9.29.16 | |
major_id | bigint | No | No | No | System-generated | ||
middlename | character varying | 50 | Yes | Yes | Yes | from OpenCCC Account | |
military_ca_stationed | boolean | Yes | Yes | Yes | |||
military_discharge_date | date | Yes | Yes | Yes | |||
military_home_country | character | 2 | Yes | Yes | Yes | ||
military_home_state | character | 2 | Yes | Yes | Yes | ||
military_legal_residence | character | 2 | Yes | Yes | Yes | ||
military_stationed_ca_ed | boolean | Yes | Yes | Yes | |||
military_stationed_ca_ed_end | date | Removed from DB 6.2.0 | |||||
military_stationed_ca_ed_start | date | Removed from DB 6.2.0 | |||||
military_status | character | 1 | No | Yes | Yes | Yes | |
no_documents | boolean | Yes | Yes | Yes | Used for VISA | ||
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 | |||
nonusaprovince | character varying | 30 | Yes | Yes | Yes | ||
online_classes | boolean | Yes | Yes | Yes | |||
orientation | bytea | No | No | No | Researchers can access through Data Warehouse | ||
otherfirstname | character varying | 50 | Yes | Yes | Yes | from OpenCCC Account | |
otherlastname | character varying | 50 | Yes | Yes | Yes | from OpenCCC Account | |
othermiddlename | character varying | 50 | Yes | Yes | Yes | from OpenCCC Account | |
perm_address_validation | character | 1 | Yes | No | No | ||
perm_city | character varying | 50 | Yes | Yes | Yes | from OpenCCC Account | |
perm_country | character | 2 | Yes | Yes | Yes | from OpenCCC Account | |
perm_nonusaprovince | character varying | 30 | Yes | Yes | Yes | from OpenCCC Account | |
perm_postalcode | character varying | 20 | Yes | Yes | Yes | from OpenCCC Account | |
perm_state | character | 2 | Yes | Yes | Yes | from OpenCCC Account | |
perm_streetaddress1 | character varying | 50 | Yes | Yes | Yes | from OpenCCC Account | |
perm_streetaddress2 | character varying | 50 | Yes | Yes | Yes | from OpenCCC Account | |
perm_zip4 | character | 4 | Yes | No | Yes | from OpenCCC Account | |
pg_edu_mis | character | 2 | Yes | Yes | Yes | ||
pg_firstname | character varying | 20 | Yes | Yes | Yes | ||
pg_lastname | character varying | 25 | Yes | Yes | Yes | ||
pg_rel | character | 1 | Yes | Yes | Yes | ||
pg1_edu | character | 1 | Yes | Yes | Yes | ||
pg2_edu | character | 1 | Yes | Yes | Yes | ||
postalcode | character varying | 20 | Yes | Yes | Yes | from OpenCCC Account | |
preferred_firstname | character varying | 50 | Yes | No | Yes | from OpenCCC Account | |
preferred_lastname | character varying | 50 | Yes | No | Yes | from OpenCCC Account | |
preferred_middlename | character varying | 50 | Yes | No | Yes | from OpenCCC Account | |
preferred_name | boolean | 1 | Yes | No | Yes | from OpenCCC Account | |
race_ethnic | text | Yes | Yes | Yes | |||
race_ethnic_full | text | 805 | Yes | No | No | v.6.3.0 2018 | |
race_group | text | Yes | Yes | Yes | |||
rdd | date | Yes | No | Yes | |||
recommend | integer | Yes | Yes | Yes | |||
reentry_program | boolean | Yes | Yes | Yes | |||
res_area_a | smallint | Yes | Yes | Yes | |||
res_area_b | smallint | Yes | Yes | Yes | |||
res_area_c | smallint | Yes | Yes | Yes | |||
res_area_d | smallint | Yes | Yes | Yes | |||
res_prev_date | date | Yes | Yes | Yes | |||
res_status | character | 1 | Yes | Yes | Yes | ||
res_status_change | boolean | Yes | Yes | Yes | |||
salt | text | No | No | No | System use only | ||
scholarship_info | boolean | Yes | Yes | Yes | |||
secondphone_auth_text | boolean | Yes | Yes | Yes | from OpenCCC Account | ||
secondphone_ext | character varying | 4 | Yes | Yes | Yes | from OpenCCC Account | |
secondphone | character varying | 14 | Yes | Yes | Yes | from OpenCCC Account | |
secondphoneintl | character varying | 25 | Yes | No | No | ||
orientation | bytea | No | No | No | Researchers can access through Data Warehouse | ||
signature | text | Yes | No | No | |||
ssn_display | character varying | 11 | Yes | Yes | Yes | ||
ssn_exception | boolean | Yes | No | Yes | 3/31/16 | ||
ssn_no | character | Yes | Yes | Yes | Added 9.30.16 | ||
ssn_type | character | 1 | Yes | No | Yes | from OpenCCC Account | |
ssn | text | Yes | Yes | No | from OpenCCC Account | ||
state | character | 2 | Yes | Yes | Yes | ||
status | character | 1 | Yes | Yes | Yes | Download status | |
streetaddress1 | character varying | 50 | Yes | Yes | Yes | ||
streetaddress2 | character varying | 50 | Yes | Yes | Yes | ||
student_government | boolean | Yes | Yes | Yes | |||
suffix | character varying | 3 | Yes | Yes | Yes | from OpenCCC Account | |
sup_page_code | character varying | 30 | No | Yes- as content | Yes _id | ||
supp_check_01 | boolean | Yes | Yes | Yes | |||
supp_check_02 | boolean | Yes | Yes | Yes | |||
supp_check_03 | boolean | Yes | Yes | Yes | |||
supp_check_04 | boolean | Yes | Yes | Yes | |||
supp_check_05 | boolean | Yes | Yes | Yes | |||
supp_check_06 | boolean | Yes | Yes | Yes | |||
supp_check_07 | boolean | Yes | Yes | Yes | |||
supp_check_08 | boolean | Yes | Yes | Yes | |||
supp_check_09 | boolean | Yes | Yes | Yes | |||
supp_check_10 | boolean | Yes | Yes | Yes | |||
supp_check_11 | boolean | Yes | Yes | Yes | |||
supp_check_12 | boolean | Yes | Yes | Yes | |||
supp_check_13 | boolean | Yes | Yes | Yes | |||
supp_check_14 | boolean | Yes | Yes | Yes | |||
supp_check_15 | boolean | Yes | Yes | Yes | |||
supp_check_16 | boolean | Yes | Yes | Yes | |||
supp_check_17 | boolean | Yes | Yes | Yes | |||
supp_check_18 | boolean | Yes | Yes | Yes | |||
supp_check_19 | boolean | Yes | Yes | Yes | |||
supp_check_20 | boolean | Yes | Yes | Yes | |||
supp_check_21 | boolean | Yes | Yes | Yes | |||
supp_check_22 | boolean | Yes | Yes | Yes | |||
supp_check_23 | boolean | Yes | Yes | Yes | |||
supp_check_24 | boolean | Yes | Yes | Yes | |||
supp_check_25 | boolean | Yes | Yes | Yes | |||
supp_check_26 | boolean | Yes | Yes | Yes | |||
supp_check_27 | boolean | Yes | Yes | Yes | |||
supp_check_28 | boolean | Yes | Yes | Yes | |||
supp_check_01 | boolean | Yes | Yes | Yes | |||
supp_check_29 | boolean | Yes | Yes | Yes | |||
supp_check_30 | boolean | Yes | Yes | Yes | |||
supp_check_31 | boolean | Yes | Yes | Yes | |||
supp_check_32 | boolean | Yes | Yes | Yes | |||
supp_check_33 | boolean | Yes | Yes | Yes | |||
supp_check_34 | boolean | Yes | Yes | Yes | |||
supp_check_35 | boolean | Yes | Yes | Yes | |||
supp_check_36 | boolean | Yes | Yes | Yes | |||
supp_check_37 | boolean | Yes | Yes | Yes | |||
supp_check_38 | boolean | Yes | Yes | Yes | |||
supp_check_39 | boolean | Yes | Yes | Yes | |||
supp_check_40 | boolean | Yes | Yes | Yes | |||
supp_check_41 | boolean | Yes | Yes | Yes | |||
supp_check_42 | boolean | Yes | Yes | Yes | |||
supp_check_43 | boolean | Yes | Yes | Yes | |||
supp_check_44 | boolean | Yes | Yes | Yes | |||
supp_check_45 | boolean | Yes | Yes | Yes | |||
supp_check_46 | boolean | Yes | Yes | Yes | |||
supp_check_47 | boolean | Yes | Yes | Yes | |||
supp_check_48 | boolean | Yes | Yes | Yes | |||
supp_check_49 | boolean | Yes | Yes | Yes | |||
supp_check_50 | boolean | Yes | Yes | Yes | |||
supp_country_01 | string | 2 | Yes | Yes | Yes | ||
supp_country_02 | string | 2 | Yes | Yes | Yes | ||
supp_country_03 | string | 2 | Yes | Yes | Yes | ||
supp_country_04 | string | 2 | Yes | Yes | Yes | ||
supp_country_05 | string | 2 | Yes | Yes | Yes | ||
supp_date_01 | date | Yes | Yes | Yes | |||
supp_date_02 | date | Yes | Yes | Yes | |||
supp_date_03 | date | Yes | Yes | Yes | |||
supp_date_04 | date | Yes | Yes | Yes | |||
supp_date_05 | date | Yes | Yes | Yes | |||
supp_menu_01 | string | 60 | Yes | Yes | Yes | ||
supp_menu_02 | string | 60 | Yes | Yes | Yes | ||
supp_menu_03 | string | 60 | Yes | Yes | Yes | ||
supp_menu_04 | string | 60 | Yes | Yes | Yes | ||
supp_menu_05 | string | 60 | Yes | Yes | Yes | ||
supp_menu_06 | string | 60 | Yes | Yes | Yes | ||
supp_menu_07 | string | 60 | Yes | Yes | Yes | ||
supp_menu_08 | string | 60 | Yes | Yes | Yes | ||
supp_menu_09 | string | 60 | Yes | Yes | Yes | ||
supp_menu_10 | string | 60 | Yes | Yes | Yes | ||
supp_menu_11 | string | 60 | Yes | Yes | Yes | ||
supp_menu_12 | string | 60 | Yes | Yes | Yes | ||
supp_menu_13 | string | 60 | Yes | Yes | Yes | ||
supp_menu_14 | string | 60 | Yes | Yes | Yes | ||
supp_menu_15 | string | 60 | Yes | Yes | Yes | ||
supp_menu_16 | string | 60 | Yes | Yes | Yes | ||
supp_menu_17 | string | 60 | Yes | Yes | Yes | ||
supp_menu_18 | string | 60 | Yes | Yes | Yes | ||
supp_menu_19 | string | 60 | Yes | Yes | Yes | ||
supp_menu_20 | string | 60 | Yes | Yes | Yes | ||
supp_menu_21 | string | 60 | Yes | Yes | Yes | ||
supp_menu_22 | string | 60 | Yes | Yes | Yes | ||
supp_menu_23 | string | 60 | Yes | Yes | Yes | ||
supp_menu_24 | string | 60 | Yes | Yes | Yes | ||
supp_menu_25 | string | 60 | Yes | Yes | Yes | ||
supp_menu_26 | string | 60 | Yes | Yes | Yes | ||
supp_menu_27 | string | 60 | Yes | Yes | Yes | ||
supp_menu_28 | string | 60 | Yes | Yes | Yes | ||
supp_menu_29 | string | 60 | Yes | Yes | Yes | ||
supp_menu_30 | string | 60 | Yes | Yes | Yes | ||
supp_phonenumber_01 | string | 25 | Yes | No | No | ||
supp_phonenumber_02 | string | 25 | Yes | No | No | ||
supp_phonenumber_03 | string | 25 | Yes | No | No | ||
supp_phonenumber_04 | string | 25 | Yes | No | No | ||
supp_phonenumber_05 | string | 25 | Yes | No | No | ||
supp_secret_01 | string | Yes | No | No | |||
supp_secret_02 | string | Yes | No | No | |||
supp_secret_03 | string | Yes | No | No | |||
supp_secret_04 | string | Yes | No | No | |||
supp_secret_05 | string | Yes | No | No | |||
supp_state_01 | string | 2 | Yes | Yes | Yes | ||
supp_state_02 | string | 2 | Yes | Yes | Yes | ||
supp_state_03 | string | 2 | Yes | Yes | Yes | ||
supp_state_04 | string | 2 | Yes | Yes | Yes | ||
supp_state_05 | string | 2 | Yes | Yes | Yes | ||
supp_text_01 | string | 250 | Yes | Yes | Yes | ||
supp_text_02 | string | 250 | Yes | Yes | Yes | ||
supp_text_03 | string | 250 | Yes | Yes | Yes | ||
supp_text_04 | string | 250 | Yes | Yes | Yes | ||
supp_text_05 | string | 250 | Yes | Yes | Yes | ||
supp_text_06 | string | 250 | Yes | Yes | Yes | ||
supp_text_07 | string | 250 | Yes | Yes | Yes | ||
supp_text_08 | string | 250 | Yes | Yes | Yes | ||
supp_text_09 | string | 250 | Yes | Yes | Yes | ||
supp_text_10 | string | 250 | Yes | Yes | Yes | ||
supp_text_11 | string | 250 | Yes | Yes | Yes | ||
supp_text_12 | string | 250 | Yes | Yes | Yes | ||
supp_text_13 | string | 250 | Yes | Yes | Yes | ||
supp_text_14 | string | 250 | Yes | Yes | Yes | ||
supp_text_15 | string | 250 | Yes | Yes | Yes | ||
supp_text_16 | string | 250 | Yes | Yes | Yes | ||
supp_text_17 | string | 250 | Yes | Yes | Yes | ||
supp_text_18 | string | 250 | Yes | Yes | Yes | ||
supp_text_19 | string | 250 | Yes | Yes | Yes | ||
supp_text_20 | string | 250 | Yes | Yes | Yes | ||
supp_yesno_1 | boolean | Yes | Yes | Yes | |||
supp_yesno_2 | boolean | Yes | Yes | Yes | |||
supp_yesno_3 | boolean | Yes | Yes | Yes | |||
supp_yesno_4 | boolean | Yes | Yes | Yes | |||
supp_yesno_5 | boolean | Yes | Yes | Yes | |||
supp_yesno_6 | boolean | Yes | Yes | Yes | |||
supp_yesno_7 | boolean | Yes | Yes | Yes | |||
supp_yesno_8 | boolean | Yes | Yes | Yes | |||
supp_yesno_9 | boolean | Yes | Yes | Yes | |||
supp_yesno_10 | boolean | Yes | Yes | Yes | |||
supp_yesno_11 | boolean | Yes | Yes | Yes | |||
supp_yesno_12 | boolean | Yes | Yes | Yes | |||
supp_yesno_13 | boolean | Yes | Yes | Yes | |||
supp_yesno_14 | boolean | Yes | Yes | Yes | |||
supp_yesno_15 | boolean | Yes | Yes | Yes | |||
supp_yesno_16 | boolean | Yes | Yes | Yes | |||
supp_yesno_17 | boolean | Yes | Yes | Yes | |||
supp_yesno_18 | boolean | Yes | Yes | Yes | |||
supp_yesno_19 | boolean | Yes | Yes | Yes | |||
supp_yesno_20 | boolean | Yes | Yes | Yes | |||
supp_yesno_21 | boolean | Yes | Yes | Yes | |||
supp_yesno_22 | boolean | Yes | Yes | Yes | |||
supp_yesno_23 | boolean | Yes | Yes | Yes | |||
supp_yesno_24 | boolean | Yes | Yes | Yes | |||
supp_yesno_25 | boolean | Yes | Yes | Yes | |||
supp_yesno_26 | boolean | Yes | Yes | Yes | |||
supp_yesno_27 | boolean | Yes | Yes | Yes | |||
supp_yesno_28 | boolean | Yes | Yes | Yes | |||
supp_yesno_29 | boolean | Yes | Yes | Yes | |||
supp_yesno_30 | boolean | Yes | Yes | Yes | |||
tanf_ssi_ga | boolean | Yes | Yes | Yes | |||
term_code | character varying | 15 | Yes | Yes | Yes | ||
term_description | character varying | 100 | Yes | Yes | Yes | ||
term_id | bigint | Yes | No | No | |||
term_end | Bigint | Yes | Yes | Yes | Added to DLC 3/31/17 | ||
term_start | bigint | Yes | Yes | Yes | Added to DLC 3/31/17 | ||
testing_assessment | boolean | Yes | Yes | Yes | |||
transfer_info | boolean | Yes | Yes | Yes | |||
transgender | bytea | No | No | No | Researchers can access through Data Warehouse | ||
transgender_submission | bytes | No | No | No | |||
transgender_encrypted | text | No | No | No | |||
tstmp_create | timestamp with time zone | DEFAULT | Yes | Yes | No | ||
tstmp_download | timestamp with time zone | Yes | Yes | No | |||
tstmp_submit | timestamp with time zone | Yes | Yes | Yes | |||
tstmp_update | timestamp with time zone | Yes | No | No | |||
tutoring_services | boolean | Yes | Yes | Yes | |||
under19_ind | boolean | Yes | No | Yes | |||
veterans_services | boolean | Yes | Yes | Yes | |||
visa_type | Alphanumeric | 2 | Yes | Yes | Yes | ||
zip4 | character | 4 | Yes | No | Yes | ||
completed_eleventh_grade | boolean | Yes* | No* | No* | Opt-In ONLY | ||
grade_point_average | Alpha-Numeric value | 5 | Yes* | Yes* | Yes* | Opt-In ONLY | |
highest_english_course | Integer | Yes* | Yes* | Yes* | Opt-In ONLY | ||
highest_english_grade | Character |
varying | 2 | Yes* | Yes* | Yes* | Opt-In ONLY | ||
highest_math_course_taken | Integer | Yes* | Yes* | Yes* | Opt-In ONLY | ||
highest_math_taken_grade | Character |
varying | 2 | Yes* | Yes* | Yes* | Opt-In ONLY | ||
highest_math_course_passed | Integer | Yes* | Yes* | Yes* | Opt-In ONLY | ||
highest_math_passed_grade | Character |
varying | 2 | Yes* | Yes* | Yes* | Opt-In ONLY |
Data Map: CCCApply Standard Application to XAP Field Names
Database Field Name & Type XAP field name
ccc_id character varying(8) N/A - new
status character(1) N/A - new
college_id character(3) N/A - new
edu_goal character(1) educationalGoals
highest_edu_level character(5) highestEdLevel highestEducationLevelYear
consent_indicator boolean consent
app_lang character(2) spanishApplication
esignature boolean Application Certification Info
ack_fin_aid boolean CCCApply Finaid Confirmation
fin_aid_ref boolean financialAidReferral
confirmation character varying(30) Application Confirmation Number
streetaddress1 character varying(50) Mailing address – street
streetaddress2 character varying(50) Mailing address – street 2
city character varying(50) Mailing address - city
postalcode character varying(20) Mailing address - zip code mailingAddrIntlCode
state character(2) Mailing address - state
nonusaprovince character varying(30) mailAddrNonUSState
country character(2) Mailing address – country
non_us_address boolean N/A – indicator of non us address
email character varying(50) Email address
perm_streetaddress1 character varying(50) Permanent address – street
perm_streetaddress2 character varying(50) Permanent address – street 2
perm_city character varying(50) Permanent address - city
perm_postalcode character varying(20) Permanent address - zip code permAddrIntlCode
perm_state character(2) Permanent address - state
perm_nonusaprovince character varying(30) permAddrNonUSState
perm_country character(2) Permanent address – country
address_same boolean permAddrSameAsMailing (In new system perm
address & mailing are reversed so this means mailing is same as perm.).
mainphone character varying(14) Primary phone number
mainphone_ext character varying(4) Primary phone - extension
mainphone_auth_text Boolean N/A – new – authorized for text messages
secondphone character varying(14) Secondary phone number
secondphone_ext character varying(4) Secondary phone - extension
secondphone_auth_text boolean N/A – new – authorized for text messages
enroll_status character(1) enrollmentStatusOneChar
hs_edu_level character(1) highSchoolEdLevel
hs_comp_date date highSchoolCompletionDate
higher_edu_level character(1) higherEdLevel
higher_comp_date date higherEdCompletionDate
cahs_graduated boolean graduatedCAHS
cahs_3year boolean attendedCAHS3Years
hs_name character varying(30) High sch 1 enrolled - name
hs_city character varying(20) High sch 1 enrolled - city
hs_state character(2) High sch 1 enrolled - state
hs_country character(2) High sch 1 enrolled - country
hs_cds character(6) highSchoolCDSCode1
hs_ceeb character(7) High sch 1 enrolled - ceeb
hs_not_listed boolean N/A – new – Indicates user selected their high
school was not listed.
home_schooled Boolean N/A – new – applicant indicated they were home
schooled.
college_count smallint N/A – new – applicant's response to number of
colleges attended.
hs_attendance smallint notAttendHS
gender character(1) gender
dependent_status character(1) over19OrMarried (Different definition)
pg_firstname character varying(20) Guardian/Parent name - first
pg_lastname character varying(25) Guardian/Parent name - last
pg_rel character(1) guardianOrParentRelation
pg1_edu character(1) edLevelParentGuardian1
pg2_edu character(1) edLevelParentGuardian2
pg_edu_mis character(2) N/A – new – combines previous two fields
race_ethnic text raceEthnicity
hispanic boolean hispanicLatino
race_group text raceGroup
ssn (for downloads see ssnFormatter) Social Security Number
birthdate date Birthdate
firstname character varying(50) Student name - first
middlename character varying(50) Student name - middle
lastname character varying(50) Student name - last
suffix character varying(3) nameSuffix
otherfirstname character varying(50) Other name - first name
othermiddlename character varying(50) N/A - new
otherlastname character varying(50) Other name - last name
citizenship_status character(1) citizenshipStatus
alien_reg_number character varying(20) visaNumber
visa_type character varying(20) visaType
no_documents boolean noDocuments
alien_reg_issue_date date visaIssueDate
alien_reg_expire_date date visaExpirationDate
alien_reg_no_expire boolean noVisaExpirationDate
military_status character(1) militaryStatus
military_discharge_date date militaryDischargeDate
discharge_type N/A - new
military_home_state character(2) militaryHomeRecord
military_home_country character(2) militaryHomeCountry
military_ca_stationed boolean militaryInCA
military_legal_residence character(2) militaryLegalResidence
ca_res_2_years boolean residentCAAtLeast2Years
ca_date_current date Date stay in CA began
ca_not_arrived boolean notCAResident
ca_college_employee boolean fullTimeEmployee
ca_school_employee boolean publicSchoolCredEmployee
ca_seasonal_ag boolean agriculturalEmployee
ca_foster_youth boolean under20FosterYouthCA
ca_outside_tax boolean nonCAResForTax
ca_outside_tax_year date yearNonCAResForTax
ca_outside_voted boolean registeredVoterInNonCAState
ca_outside_voted_year date yearRegisteredVoterInNonCAState
ca_outside_college boolean residentAtNonCACollege
ca_outside_college_year date yearResidentAtNonCACollege
ca_outside_lawsuit boolean lawsuitNonCAState
ca_outside_lawsuit_year date yearLawsuitOutsideCalifornia
res_status character(1) residencyStatus
res_status_change boolean residencyStatusChange
res_prev_date date previousResidencyDate
adm_ineligible smallint ineligibilityFlag
elig_ab540 boolean eligibleForWaiver
res_area_a smallint N/A – new – Residency – Citizenship Area
res_area_b smallint N/A – new – Residency – Stay and Intent Area
res_area_c smallint N/A – new – Residency - Military Exemption Area
res_area_d smallint N/A – new – Residency - Other exemptions
experience integer CCC SLO Survey 1 Satisfaction
recommend integer CCC SLO Survey 2 Recommend
comments text CCC SLO Survey 3 Comments
comfortable_english boolean primaryLanguage
financial_assistance boolean financialAidInfo
tanf_ssi_ga boolean generalAssistance
foster_youths boolean fosterYouth
athletic_intercollegiate boolean N/A – new – Title IX field
athletic_intramural boolean N/A – new – Title IX field
athletic_not_interested boolean N/A – new – Title IX field
academic_counseling boolean academicCounseling
basic_skills boolean basicSkills
calworks boolean calWorks
career_planning boolean careerPlanning
child_care boolean childCare
counseling_personal boolean personalCounseling
dsps boolean disabledStudentPrograms
eops boolean EOPS
esl boolean ESL
health_services boolean healthServices
housing_info boolean housing
employment_assistance boolean jobPlacement
online_classes boolean onlineClasses
reentry_program boolean reentryProgram
scholarship_info boolean scholarships
student_government boolean studentGovernment
testing_assessment boolean testing
transfer_info boolean transferInfo
tutoring_services boolean tutoringServices
veterans_services boolean veteransServices
integrity_fg_01 boolean integrityFlags (all in one field in XAP)
integrity_fg_02 boolean integrityFlags (all in one field in XAP)
integrity_fg_03 boolean integrityFlags (all in one field in XAP)
integrity_fg_04 boolean integrityFlags (all in one field in XAP)
integrity_fg_11 boolean integrityFlags (all in one field in XAP)
Integrity_fg_40 boolean New 3/31/17
integrity_fg_47 boolean integrityFlags (all in one field in XAP)
integrity_fg_48 boolean integrityFlags (all in one field in XAP)
integrity_fg_49 boolean integrityFlags (all in one field in XAP)
integrity_fg_50 boolean integrityFlags (all in one field in XAP)
integrity_fg_51 boolean integrityFlags (all in one field in XAP)
integrity_fg_52 boolean integrityFlags (all in one field in XAP)
integrity_fg_53 boolean integrityFlags (all in one field in XAP)
integrity_fg_54 boolean integrityFlags (all in one field in XAP)
integrity_fg_55 boolean integrityFlags (all in one field in XAP)
integrity_fg_56 boolean integrityFlags (all in one field in XAP)
integrity_fg_57 boolean integrityFlags (all in one field in XAP)
integrity_fg_58 boolean integrityFlags (all in one field in XAP)
integrity_fg_59 boolean integrityFlags (all in one field in XAP)
integrity_fg_60 boolean integrityFlags (all in one field in XAP)
integrity_fg_61 boolean integrityFlags (all in one field in XAP)
integrity_fg_62 boolean integrityFlags (all in one field in XAP)
integrity_fg_63 boolean integrityFlags (all in one field in XAP)
integrity_fg_70 boolean integrityFlags (all in one field in XAP)
integrity_fg_80 boolean integrityFlags (all in one field in XAP)
integrity_flags char varying(255) This has all the flags like in XAP
For Colleges only listing first occurrence of each field
col1_ceeb character(7) College enrolled 1 - ceeb
col1_cds character(6) collegeCDSCode1
col1_not_listed boolean Colleges Attended
col1_name character varying(30) College enrolled 1 – name
col1_city character varying(20) College 1 address - city
col1_state character varying(30) College 1 address – state
col1_country character(2) College 1 address - country
col1_start_date date College enrolled 1 - date from
col1_end_date date College enrolled 1 - date to
col1_degree_date date collegeDegreeDate1
col1_degree_obtained character(1) collegeDegreeType1
col1_expelled_status N/A - new
college_expelled_summary N/A - new
college_name character varying(50) N/A – Name of college applied to
term_description character varying(100) enrol_term_year_description
major_code character varying(30) Major Code
major_description character varying(100) Major Name
tstmp_submit timestamp with time zone Application Date Submitted
ssn_display character varying(11) N/A - new
foster_youth_status character(1) fosterYouthStatus
foster_youth_preference Boolean N/A - new
foster_youth_mis Boolean fosterYouthMIS
foster_youth_priority Boolean fosterYouthPriority
International Application Data Field Summary
The table below includes all the fields in the submitted application database for the CCCApply International application. 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
...
Downloadabl e
...
...
International Application Data Field Summary
The table below includes all the fields in the submitted application database for the CCCApply International application. 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 | 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 |
Data Element (column)
Data Type
Length
Allows
Null
Downloadabl
e
In Report Center?
Rules
Available?
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 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 OpenCCC Apply International Application
...
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
...