V.2018.12
912.2807.18
...
Download Client Overview
When a student submits a CCCApply (Standard or International) or CC Promise Grant application, their application responses are stored in the CCC Technology Center's submitted application database in two tables: submitted_application and submitted_question_response (for supplemental question responses). The submitted_application table contains the applicants' responses on their application and a number of fields from their user account at the time they submit.
...
After configuring your properties and job and format definitions XML files you can run download jobs in your test environment and SIS to confirm the data is mapping and storing correctly in your SIS prior to downloading data from the production server. Download jobs can be set for both the application data and supplemental question responses.
Working with XML
Although working with computer languages can be daunting, you don't need to be an expert to work with the Download client XML files, and you don't need any sophisticated tools. A simple text editor and a rudimentary understanding of XML hierarchy will be helpful.
...
| Warning |
|---|
Important: Do not use XML Notepad to edit your XML files. It adds a BOM (Byte Order Mark) to the file and will cause the download job to abnormally terminate and an error message may display indicating that the XML file contains a BOM. If you run your download and get the BOM error, you can take one of the following actions to remove it:
To remove the BOM, click on options from the Tools menu and de-select "Save UTF byte order mark". Save your file.
To remove the BOM, select "Encode in UTF-8 without BOM" from the Encoding menu. Save your file. |
...
Unzipping, Installing, and Configuring the Download Client
The following steps outline a "quick-start" process for a first-time unzip and configuration of the Download client.
...
When your college first transitions to the CCCApply applications, you will be working with a CCC Tech Center Project Manager. The Project Manager will provide you a checklist for your implementation. One of the implementation steps includes contacting CCC Tech Center Technical Support to get your Download client.
Download Client System Requirements
- A Virtual Machine dedicated for the Download Client installation
- Java 7 or higher of either the Java Runtime Environment (JRE) or Java Development Kit (JDK)
- The latest Download Client version, available here (as a transfer-client.jar file): https://cccnext.jira.com/wiki/ display/PD/User+Guides
...
- 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.
...
Confirm that no errors are printed.
Preparing to Download Applications: Configuring Your Job and Format Files
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 |
|---|
Note: Your format file must always be stored in the formats directory of the Download Client files in order for it to be processed. |
Running a Download Job
After installing the Download client and configuring your job and format XML files, use the following steps to run a job to download your college's student applications (in order to import them into your college's SIS).
...
| Info |
|---|
| Tip: You can set up a chron job to automate your application data downloads to occur on a regular basis. |
...
Job File Configuration Details
The job file contains information about what student applications to download and what directories to use for the output file. A job file is created for each download job. When a job is set up in the college's scheduler, the job file name is passed as a parameter to the job.
The Job File
The job file controls the high-level aspects of the download, such as the server from which to retrieve the data. It also allows you to specify multiple downloads that may retrieve different datasets or present the data in different formats.
The Format Definitions File
The format definitions file allows you to select the specific fields you want to retrieve from the student applications and control the format of the data that the Download client delivers to you.
Sample Job file
| Attribute Name | Description | Function |
|---|---|---|
| url | Specify the server URL for the system from which you want to download (see list below). | This allows you to create different jobs to download different jobs to download from different environments. Choose the URL for the environment you want to download, from the table below. |
| misCode | Specify the MIS code(s) for the college. | The college can only download applications for which they are authorized. |
...
| Panel | ||
|---|---|---|
| ||
<job url="https://admin.openccc.net:8443/ccctransfer" misCode="311,312,313" <file directory="c:/temp" formatId="ccMainV1" prefix="contracosta" suffix=".txt" /> |
Filter Elements
Any given job has the basic constraint that only applications for the specified MIS codes can be retrieved. An optional filter is allowed to further restrict which student application data gets downloaded for a given job. With no filter specified, only data for "new" student applications for that MIS code are retrieved. An application is considered new if it has not previously been downloaded by the Download client.
<job> element
The job is the root element for all download definitions.
Attributes
Environments for the URL Attribute
| App Type/Environment | URL |
|---|---|
| Standard App PILOT | https://pilot.admin.openccc.net:8443/ccctransfer |
| Standard PRODUCTION | https://admin.openccc.net:8443/ccctransfer |
| BOG PILOT | https://pilot.admin.openccc.net:8443/ccctransferbog |
| BOG PRODUCTION | https://admin.openccc.net:8443/ccctransferbog |
| International PILOT | https://pilot.admin.openccc.net:8443/ccctransferintl |
| International PRODUCTION | https://admin.openccc.net:8443/ccctransferintl |
<file> element
The file element specifies the directory to create the download file, how the file name is formatted and which format definition to use.
...
| Attribute Name | Description | Conditions | ||
|---|---|---|---|---|
| directory | The directory the download file will be created in. | The directory must exist. | ||
| prefix | The prefix of the download file. | |||
| suffix | The suffix of the download file. | i.e. .txt or .csv | ||
| formatId | The format id to use. | The format id must exist in a formatdefinitions.xml file, specified by the id attribute.
| ||
| os | Defines the type of carriage return or line feed character. | os="windows" (Uses CR/LF) os="unix" (Uses LF) If os is omitted, it uses "windows" as the default. |
Full File Name
Besides the prefix and suffix, the date and time are also included in the file name. Based on this example: <file directory="/ somedir / downloads" prefix="main" suffix=".txt" formatId="fixedMain1" /If the transfer job ran on feb 6 2014, the file name would be / somedir / downloads / main-140206-081228.txt where "140206" represents the date and "081228" represents the run time of the job.
...
Format Definitions File Configuration Details
The format definitions file is an XML file used to define student application data download format:
...
| Panel | ||
|---|---|---|
| ||
<?xml version="1.0" encoding="UTF-8"?> <fieldList> </fieldList> |
formatDefinition Element
Fields in the download file appear in the order they are defined in the format definitions XML file.
Attributes
| 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. |
Child Elements
<fieldList>
The fieldList contains a list of field definitions.
<field>
The field element defines how an individual field is formatted. The element value is the name of the field in the submitted_application table (see the Download Data section, below).
...
| Attribute Name | Description | Restrictions |
|---|---|---|
| len | The fixed width of the field. | Only applicable in the fixed format. |
| name | The name of the field (from the application's Data Dictionary) to output |
<whitespace>
The whitespace element is only used in fixed format definitions when you want to insert fixed width spaces in between two fields. <whitespace len="3" />
...
len The fixed width of the whitespace.
<constant>
The constant element is used to insert a constant string value into the file. If you specify the len attribute, it will right pad the text with spaces if the len is greater than the length of the text. If you do not specify len, if will not add any padding. <constant len="30">College one starts here</constant>
...
If specified, it will right pad the text with spaces if the len is greater than the length of the text. If omitted, if will not add any padding.
<newline>
The newline causes a carriage return (line feed). The newline element is aware of the operating system. For Windows it will add CR & LF. For Unix it will just add LF. <newline />
<byAppId>
The byAppId element allows you to specify a single application for download when you provide a specific app_id value. <byAppId app_id = '16197'/>
<dateFormatter>
A date formatter allows customization of how date/time values can be formatted using a pattern string. Example pattern strings are: MM/dd/yyyy, yyyy-MM-dd, etc. <field name="tstmp_submit" len="20">
...
An application submitted to a California Community College at 3:30 pm/15:30:00 on April 15, 2016 will appear as 22:30:00 in the downloaded data--a seven hour time difference--if no timezone attribute is applied to the dateFormatter for timestamp fields. The time is seven hours different than the actual application submit time due to Daylight Savings time.
<booleanFormatter>
The booleanFormatter allows you to configure what text displays/downloads for boolean-date type fields with true, false, and null values. <booleanFormatter trueValue="1" falseValue="0" nullValue="?"/>
...
Note: If the nullValue attribute is not defined, then any fields with null values will default to display the falseValue attribute in your download data. If neither the nullValue nor the falseValue attributes are defined, then a null value downloads as a string of "false."
<ssnFormatter>
The ssnFormatter applies formatting to social security numbers to include or remove dashes. <field name="ssn" len="9">
...
If removeDashes="false", len should be 11. This will format an SSN field with dashes.
<simpleMapper>
The simpleMapper formatter provides a way to make simple translations of data.
...
| Attribute Name | Description |
|---|---|
| len | Specifies the length of the output (<to>) field (fixed format only). |
| name | Name of the input field. |
| unmatched | Value to use if actual data does not match any of the from values If unmatched element is not specified, the actual data value will be used |
<stringFormatter>
The stringFormatter allows you to configure text field values to display/download as all upper-case or lower-case letters and what text displays/downloads for text fields with null values. <stringFormatter caseConversion="lowercase" nullValue="[null]"/>
...
Note: If the nullValue attribute is not defined, then any text-type fields with null values will default to display/download an empty string: " ".
<phoneFormatter>
The phoneFormatter is used to format phone numbers. <field len="15" name="mainphone"> <phoneFormatter pattern="(999) 999-9999"/> </field>
...
5303322233 (999) 999-9999 (530) 332-2233
<numberFormatter>
The numberFormatter can be used for applying a variety of formats to numbers.
...
Note: To view more format value examples, see: http://docs.oracle.com/javase/7/docs/api/java/util/ Formatter.html#syntax
...
Data Fields: CCCApply Standard Application
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
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
alien_reg_issue_date date Yes Yes Yes
alien_reg_no_expire boolean Yes Yes Yes
alien_reg_number character Varying 20 Yes Yes Yes
app_id bigint NO 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 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
career_planning boolean Yes Yes Yes
ccc_id character Varying 8 NOT NULL Yes Yes Yes OpenCCC Account
child_care boolean Yes Yes Yes
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 14 Yes Yes Yes 3.31.17
col2_cds_full Character 14 Yes Yes Yes 3.31.17
col3_cds_full Character 14 Yes Yes Yes 3.31.17
col4_cds_full Character 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
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
email character
varying
254 Yes Yes Yes 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 Old No No No Removed
hs_cds_full Character
varying
14 Yes Yes Yes 3.31.17
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 1 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 Charvar 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 9.30.16
integrity_fg_40 boolean Yes Yes Yes 3.31.17
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
ip_address character
varying
15 Yes Yes No
last_page character
varying
25 Yes No No
lastname character
varying
50 Yes Yes Yes OpenCCC
Account
mainphone_auth_text boolean Yes Yes Yes OpenCCC
Account
mainphone_ext character
varying
4 Yes Yes Yes OpenCCC
Account
mainphone character
varying
14 Yes Yes Yes OpenCCC
Account
major_code character
varying
30 Yes Yes Yes
major_description character
varying
64 Yes Yes Yes
major_id bigint Yes No No
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_status character 1 NOT NULL
Yes Yes Yes
no_documents boolean Yes Yes Yes
no_mailing_address_homeless Boolean Yes Yes Yes 3.31.17
no_perm_address_homeless Boolean Yes Yes Yes 3.31.17
non_us_address boolean Yes Yes Yes
nonusaprovince character
varying
30 Yes Yes Yes
online_classes boolean Yes Yes Yes
orientation bytea No No No
otherfirstname character
varying
50 Yes Yes Yes OpenCCC Account
otherlastname character
varying
50 Yes Yes Yes OpenCCC
Account
Data Field Type Length Null Download RC Rules Notes
perm_state character 2 Yes Yes Yes from OpenCCC
Account
perm_streetaddress1 character
varying
50 Yes Yes Yes from
perm_streetaddress2 character
varying
50 Yes Yes Yes from OpenCCC
Account
perm_zip4 character 4 Yes No Yes
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
othermiddlename character
varying
50 Yes Yes Yes OpenCCC
Account
othername Character
varying
50 Yes Yes Yes OpenCCC
Account
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 OpenCCC
Account
perm_postalcode character
varying
20 Yes Yes Yes OpenCCC
Account
postalcode character varying 20 Yes Yes Yes
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 Yes No Yes
race_ethnic text Yes Yes Yes
race_group text Yes Yes Yes
rdd date 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
scholarship_info boolean Yes Yes Yes
secondphone_auth_text boolean Yes Yes Yes OpenCCC
Account
secondphone_ext character varying 4 Yes Yes Yes OpenCCC
Account
secondphone character varying 14 Yes Yes Yes OpenCCC
Account
signature text Yes No No
ssn_display character varying 11 Yes Yes Yes
ssn_exception boolean Yes No Yes OpenCCC
Account
ssn_no Boolean Yes Yes Yes 9.30.16
ssn_type character 1 Yes No Yes OpenCCC
Account
ssn text Yes Yes No OpenCCC
Account
state character 2 Yes Yes Yes
status character 1 Yes Yes Yes
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 OpenCCC
Account
sup_page_code character varying 30 No Yes Yes
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
term_end Date Yes Yes Yes 3.31.17
term_start Date Yes Yes Yes 3.31.17
testing_assessment boolean Yes Yes Yes
transfer_info boolean Yes Yes Yes
transgender bytea No No No
transgender_submission bytea No No No
transgender_encrypted text No No No
tstmp_create timestamp with
time zone
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 character varying 20 Yes Yes Yes
zip4 character 4 Yes No Yes
completed_eleventh_grade Boolean 1 Yes* Yes* Yes* Opt-in
ONLY
grade_point_average Alpha-numeric 5 Yes* Yes* Yes* Opt-in
ONLY
highest_english_course Integer 2 Yes* Yes* Yes* Opt-in
ONLY
highest_english_grade Var char 2 Yes* Yes* Yes* Opt-in
ONLY
highest_math_course_taken Integer 2 Yes* Yes* Yes* Opt-in
ONLY
highest_math_taken_grade Var char 2 Yes* Yes* Yes* Opt-in
ONLY
highest_math_course_passed Integer 2 Yes* Yes* Yes* Opt-in
ONLY
highest_math_passed_grade Var char 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
Data Fields: CCCApply International Application
The table below includes all the columns/fields you can download to your college SIS for the CCCApply International application. Refer to the CCCApply International Data Dictionary for detailed field definitions.
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 No Added
3/27/15
campaign2 varchar 255 Yes Yes No Added
3/27/15
campaign3 varchar 255 Yes Yes No 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
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
| Data Fields: CCCApply International Application | 55
col4_cds_full Character
14 Yes Yes Yes 3.31.17 varying
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
| Data Fields: CCCApply International Application | 56
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 YYeses 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
| Data Fields: CCCApply International Application | 57
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 No No No 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
| Data Fields: CCCApply International Application | 58
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
| Data Fields: CCCApply International Application | 59
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
| Data Fields: CCCApply International Application | 60
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
| Data Fields: CCCApply International Application | 61
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
email 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
| Data Fields: CCCApply International Application | 62
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
| Data Fields: CCCApply International Application | 63
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
Hs_cds_full character
varying
14 Yes Yes Yes 3.31.17
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
| Data Fields: CCCApply International Application | 64
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
| Data Fields: CCCApply International Application | 65
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
major_desc Varchar 50 Yes Yes Yes
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
no_mailing_address_homeless Boolean Yes Yes Yes 3.31.17
no_non_usa_perm_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 Not
currently
non_us_permanent_home_address_same
_as_permanent
boolean Yes
| Data Fields: CCCApply International Application | 66
non_us_permanent_home_address_
boolean Yes Yes Yes
verified
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_
address
boolean Yes Yes Yes Always "TRUE"
non_us_permanent_home_non_us_postal
_code
varchar 30 Yes Yes Yes
non_us_permanent_home_non_us_
province
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
| Data Fields: CCCApply International Application | 67
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
| Data Fields: CCCApply International Application | 68
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
| Data Fields: CCCApply International Application | 69
presently_studying_in_us boolean Yes Yes Yes
primary_language varchar 10 Yes Yes Yes
pt1_authorizing_school varchar 32 Yes Yes Yes
pt1_end_date date Yes Yes Yes
pt1_practical_training_id bigint No Yes Yes
pt1_start_date date Yes Yes Yes
pt1_type varchar 3 Yes Yes Yes
pt2_authorizing_school varchar 32 Yes Yes Yes
pt2_end_date date Yes Yes Yes
pt2_practical_training_id bigint No Yes Yes
pt2_start_date date Yes Yes Yes
pt2_type varchar 3 Yes Yes Yes
pt3_authorizing_school varchar 32 Yes Yes Yes
pt3_end_date date Yes Yes Yes
pt3_practical_training_id bigint No Yes Yes
pt3_start_date date Yes Yes Yes
pt3_type varchar 3 Yes Yes Yes
pt4_authorizing_school varchar 32 Yes Yes Yes
pt4_end_date date Yes Yes Yes
pt4_practical_training_id bigint No Yes Yes
pt4_start_date date Yes Yes Yes
pt4_type varchar 3 Yes Yes Yes
race_ethnicity Text string Yes Yes Yes 9.30.16
| Data Fields: CCCApply International Application | 70
race_group Text string Yes Yes Yes 9.30.16
salt text Yes Yes 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 No No
ssn_exception boolean
Default = false
Yes
ssn_last4 char 4 Yes
ssn_no Boolean Yes Yes Yes 9.30.16
ssn_type char 1 Yes Yes
state varchar 2 Yes Yes Yes Not
currently used
status char Yes Yes Yes Applicatio
n 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_start_date Date Yes Yes Yes 9.30.16
term_end_date Date Yes Yes Yes 9.30.16
tstmp_create timestamp
with time zone
Yes Yes Yes
tstmp_download timestamp
with time zone
Yes 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 usedData 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 | 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? | Notes | ||||||||||
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
Each submitted CCCApply International application includes data fields that are automatically populated from each student's OpenCCC Account. The table below displays the OpenCCC Account
database columns and their corresponding columns that they populate in the CCCApply International table.
Data Item | Account Data Element | Application Data Element |
CCCID | cccid | ccc_id |
Date of Birth | birthdate | birthdate |
Email Address | ||
Legal Name: First | firstname | firstname |
Legal Name: Last | lastname | lastname |
Legal Name: Middle | middlename | middlename |
Legal Name:Suffix | suffix | suffix |
Main Telephone | mainphone | main_phone_number |
Main Telephone Extension | mainphone_ext | main_phone_ext |
Permanent Address: City | city | perm_addr_city |
Permanent Address: Country | county | perm_country |
Permanent Address: Non-U.S. State/ Province | nonusaprovince | perm_addr_nonusaprovince |
Permanent Address: Postal Code | postalcode | perm_addr_zip_code perm_addr_non_us_postal_code |
Permanent Address: State | state | perm_addr_state |
Permanent Address: Street 1 | streetaddress1 | perm_addr_streetaddress_1 |
Permanent Address: Street 2 | streetaddress2 | perm_addr_streetaddress_2 |
Preferred Name: First | preferred_firstname | preferred_firstname |
Preferred Name: Last | preferred_lastname | preferred_lastname |
Preferred Name: Middle | preferred_middlename | preferred_middlename |
Previous Name: First | otherfirstname | otherfirstname |
Previous Name: Last | otherlastname | otherlastname |
Previous Name: Middle | othermiddlename | othermiddlename |
Second Telephone | secondphone | second_phone_number |
Second Telephone Extension | secondphone_ext | secondphone_ext |
Social Security Number: Other Exception | ssn_exception | ssn_exception |
Social Security Number: None | ssn_no | ssn_no |
Social Security Number/TIN | ssn | ssn |
Social Security Number/TIN Type | ssn_type | ssn_type |
Text Permission: Main Telephone | mainphone_auth_txt | main_phone_auth_text |
Text Permission: Second Telephone | secondphone_auth_txt | second_phone_auth_txt |
Crypto key id: Internal System Field | cryptokeyid | cryptokeyid |
Data Fields: Promise Grant Application
The table below includes all the columns/fields you can download to your college SIS for the Promise Grant application. Refer to the CC Promise Grant Data Dictionary for detailed field definitions.
...