Version 2019.1
Updated: 02.19.18
...
Info |
---|
Upgrade to the Latest Download Client VerslonA new version of the Download Client Jar file, also called the transfer-client Jar file, is made available with each new CCCApply release that includes database changes. You can find it alongside the most recent the Jar file adjacent to the current version of the Download Client User Guide on the User Guides page. Go to https://cccnext.jira.com/wiki/display/PD/User+Guides - and look for the "transfer-client.jar" version matching the latest release version. |
...
Download Client Installation Steps
Note |
---|
The steps that follow assume the ‘java’ and ‘jar’ commands are available from your PATH environment. The installers for both the JRE and JDK should install the Java runtime so that the various command-line tools, including ‘java’ and ‘jar’ are available in the system PATH. |
Download Client Installation Steps
...
If you already have installed the Download Client you can skip to: Preparing to Download Applications: Configuring Your Job and Format Files.
...
Key | Description | Required? | Default Value |
---|---|---|---|
javax.net.ssl.keyStore | Specifies the Java Keystore that contains the certificate to validate your college to the CCC Transfer Server | Yes | FTT_HOME/conf/client.jks |
javax.net.ssl.keyStorePassword | Specifies the password for the keystore that javax.net.ssl.keyStore indicates. | Yes | password |
3. Change your college keystore password using the steps in this section. When you first receive the Download Client from the CCCTech Center, a certificate is created for your college that controls which MIS code(s) you can access for downloads. The default password for this initial certificate is “password.” The CCCTech Center recommends that you change this password using the following steps.
...
Navigate to the transfer-client\conf\ directory and create a backup of your current client.jks file.
At a command prompt, navigate to the transfer-client\conf directory and locate your college key alias by entering the following command at a command prompt (press the Enter key after you type the command): keytool -list -keystore client.jks The output from running this command will be a list of keys contained in the keystore.
Locate your college key alias by looking at the key name at the beginning of the entry of type "PrivateKeyEntry". The college key alias will usually be in the format of "xxx.edu" where xxx is your college’s initials.
Update your college keystore password by entering the following command at the command prompt from the transfer-client\conf directory (press the Enter key after you type the command): keytool -storepasswd -keystore client.jks
When prompted to enter your current keystore password, enter your current password (the password = password for all first-time Download Clients). You’ll be prompted to enter your new keystore password, and then prompted to re-enter the new keystone password (press the Enter key after each entry).
Update your college key password to match the keystore password you just set in step 3e above by entering the following command at the command prompt from the transfer-client\conf directory (press the Enter key after you type the command): keytool -keypasswd -alias <key_alias> -keystore client.jks
When prompted to enter your current keystore password, enter they keystore password you set in step 3e, above.
Enter the same password as in step 3e when prompted to enter and re-enter your new key password.
Open the conf/ccctransfer.properties file and edit the ccctransfer.keystore.password value to have your new password instead of the old one (password). That is, edit the word password after the = sign in this entry: ccctransfer.keystore.password=password
Save and close the conf/ccctransfer.properties file. You have now updated your college keystore password for all applications (CCCApply Standard and International, and CC Promise Grant).
Test the new keystore by entering the following command at the command prompt for each application.
To test the new keystore for your Pilot server, enter the following command at the command prompt:
For the CCCApply application:
java -jar transfer-client.jar -test https://pilot.admin.openccc.net:8443/ccctransfer/debug
For the CC Promise Grant application:
java -jar transfer-client.jar -test https://pilot.admin.openccc.net:8443/ccctransferbog/debug
For the International application (coming soon):
java -jar transfer-client.jar -test https://pilot.admin.openccc.net:8443/ccctransferintl/debug
Confirm that no errors are printed.
To test the new keystone for your Production server, enter the following command at the command prompt:
For the CCCApply application:
java -jar transfer-client.jar -test https://admin.openccc.net/ccctransfer/debug
For the CC Promise Grant application:
java -jar transfer-client.jar -test https://admin.openccc.net:8443/ccctransferbog/debug
For the International application (coming soon):
java -jar transfer-client.jar -test https://admin.openccc.net:8443/ccctransferintl/debug
...
After installing the Download Client, you will need to configure the job and format XML files to configure which application data you want to download.
Note |
---|
Noncredit ApplicationThe Noncredit application is an optionally-implemented, separate workflow within the CCCApply Standard application that allows students taking only noncredit coursework to apply to your college without having to answer residency-related questions. The only changes you need to make to your Download Client Job File is to include the two new Noncredit application-specific fields: integrity_fg_81 and non_credit. See the "Noncredit Application" and "Appendix E: Table of Downloadable Fields" sections of the CCCApply Standard & Noncredit Application Data Dictionary 2019.2 and the Data Fields: CCCApply Standard and Noncredit application for details. |
...
Attribute Name | Value |
---|---|
outputFormat | Set the value to fixed or delimited. |
Delimiter | For delimited files, specify the delimiter. The default is comma (",") if unspecified. Examples of delimited file: outputFormat="delimited" delimiter="|" (pipe is the delimiter). Note: You can use multiple characters as a delimiter, if desired. outputFormat="delimited" delimiter="	" (tab is the delimiter; the 	 delimiter value results in tab delimited output) |
applicationType | Specifies which type of applications you are downloading (Standard, CC Promise Grant, or International). If not specified, it will default to Standard applications. For BOG, applicationType="bogfw". For International, applicationType="intl". |
stripDiacritics | The stripDiacritics attribute will convert certain diacritic (non-English or foreign) characters to standard ascii characters. If omitted, the data will be sent as originally entered in the application. To convert diacritic characters, add stripDiacritics="true". Important note: If you use this attribute, be sure to test thoroughly before using it in production so you know you are getting the results you expect. |
charset | Sets the charset that the output from the download client will utilize. |
Child Elements
<fieldList>
...
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 | IF an application is submitted using the Noncredit application URL then the value for <confirmation> is preceded with "NC-" | |
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_fg_81 | boolean | Yes | Yes | Yes | Set to “true” when “non_credit” = true and all other flags are ignored | ||
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 | |||
non_credit | boolean | No | Yes | Yes | Yes | Optional; Value set to "True" if applicant applies using the new Noncredit Application URL; otherwise it is "False" | |
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 |
...