...
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 | 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 | 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 Annual Update | ||
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 | |
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 | 2 | Yes* | Yes* | Yes* | Opt-In ONLY | |
highest_math_course_taken | Integer | Yes* | Yes* | Yes* | Opt-In ONLY | ||
highest_math_taken_grade | Character | 2 | Yes* | Yes* | Yes* | Opt-In ONLY | |
highest_math_course_passed | Integer | Yes* | Yes* | Yes* | Opt-In ONLY | ||
highest_math_passed_grade | Character | 2 | Yes* | Yes* | Yes* | Opt-In ONLY |
...
academic_counseling boolean Yes Yes Yes
...