Versions Compared

Old Version 25

changes.mady.by.user Patricia Donohue

Saved on

compared with

New Version 26

changes.mady.by.user Rick Snodgrass

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Version 2019.1
Updated: 02.19.18

...

Info

Upgrade to the Latest Download Client Verslon

A new version of the Download Client Jar file, also called the transfer-client Jar file, is made available with each new CCCApply release that includes database changes. You can find the Jar file adjacent to the current version of the Download Client User Guide on the User Guides page.  Go to https://cccnext.jira.com/wiki/display/PD/User+Guides - and look for the "transfer-client.jar" version matching the latest release version.

...

Note

Noncredit Application

The Noncredit application is an optionally-implemented, separate workflow within the CCCApply Standard application that allows students taking only noncredit coursework to apply to your college without having to answer residency-related questions. The only changes you need to make to your Download Client Job File is to include the two new Noncredit application-specific fields: integrity_fg_81 and non_credit. See the "Noncredit Application" and "Appendix E: Table of Downloadable Fields" sections of the CCCApply Standard & Noncredit Application Data Dictionary and the Data Fields: CCCApply Standard and Noncredit application for details. 

...

Attribute Name

Value

outputFormat

Set the value to fixed or delimited.


Delimiter

For delimited files, specify the delimiter. The default is comma (",") if unspecified. Examples of delimited file:

outputFormat="delimited" delimiter="|" (pipe is the delimiter).

Note: You can use multiple characters as a delimiter, if desired.

outputFormat="delimited" delimiter="	" (tab is the delimiter; the 	 delimiter value results in tab delimited output)

applicationType

Specifies which type of applications you are downloading (Standard, CC Promise Grant, or International). If not specified, it will default to Standard applications. For BOG, applicationType="bogfw". For International, applicationType="intl".

stripDiacritics

 The stripDiacritics attribute will convert certain diacritic (non-English or foreign) characters to standard ascii characters. If omitted, the data will be sent as originally entered in the application. To convert diacritic characters, add stripDiacritics="true". Important note: If you use this attribute, be sure to test thoroughly before using it in production so you know you are getting the results you expect.

charset

Sets the charset that the output from the download client will utilize.

charset="ASCII" will place question marks (?) where non-standard/non-English characters are in the output. Multiple question marks can stand for a single non-standard/non-English character, meaning that if you have specified a specific length for a field's output, the end could get cut off if there are too many question marks in the user's value for that field.

charset="UTF-8" will print most non-standard/non-English characters in user output without unnecessarily adding to the length of the output.

If this attribute is not specified, it will default to ASCII.


Child Elements

<fieldList>

...

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. For a slightly more detailed list of downloadable CCCApply Standard and Noncredit application fields, see "Appendix E: Table of Downloadable Fields" in the CCCApply Standard & Noncredit Data Dictionary 2019.2.

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
v.6.2.0

citizenship_status

character

1

NOT  NULL

Yes

Yes

Yes


city

character varying

50


Yes

Yes

Yes


coenroll_confirm

boolean



Yes

Yes

Yes


col1_cds_full

Character varying

14


Yes

Yes

Yes

3.31.17

col2_cds_full

Character varying

14


Yes

Yes

Yes

3.31.17

col3_cds_full

Character varying

14


Yes

Yes

Yes

3.31.17

col4_cds_full

Character varying

14


Yes

Yes

Yes

3.31.17

col1_cds

character

6


Yes

Yes

Yes


col1_ceeb

character

7


Yes

Yes

Yes


col1_city

character varying

20


Yes

Yes

Yes


col1_country

character

2


Yes

Yes

Yes


col1_degree_date

date



Yes

Yes

Yes


col1_degree_obtained

character

1


Yes

Yes

Yes


col1_end_date

date



Yes

Yes

Yes


col1_expelled_status

boolean



Yes

No

No


col1_name

character varying

30


Yes

Yes

Yes


col1_not_listed

boolean



Yes

Yes

Yes


col1_start_date

date



Yes

Yes

Yes


col1_state

character varying

30


Yes

Yes

Yes


col2_cds

character

6


Yes

Yes

Yes


col2_ceeb

character

7


Yes

Yes

Yes


col2_city

character varying

20


Yes

Yes

Yes


col2_country

character

2


Yes

Yes

Yes


col2_degree_date

date



Yes

Yes

Yes


col2_degree_obtained

character

1


Yes

Yes

Yes


col2_end_date

date



Yes

Yes

Yes


col2_expelled_status

boolean



Yes

No

No


col2_name

character varying

30


Yes

Yes

Yes


col2_not_listed

boolean



Yes

Yes

Yes


col2_start_date

date



Yes

Yes

Yes


col2_state

character varying

30


Yes

Yes

Yes


col3_cds

character

6


Yes

Yes

Yes


col3_ceeb

character

7


Yes

Yes

Yes


col3_city

character varying

20


Yes

Yes

Yes


col3_country

character

2


Yes

Yes

Yes


col3_degree_date

date



Yes

Yes

Yes


col3_degree_obtained

character

1


Yes

Yes

Yes


col3_end_date

date



Yes

Yes

Yes


col3_expelled_status

boolean



Yes

No

No


col3_name

character varying

30


Yes

Yes

Yes


col3_not_listed

boolean



Yes

Yes

Yes


col3_start_date

date



Yes

Yes

Yes


col3_state

character varying

30


Yes

Yes

Yes


col4_cds

character

6


Yes

Yes

Yes


col4_ceeb

character

7


Yes

Yes

Yes


col4_city

character varying

20


Yes

Yes

Yes


col4_country

character

2


Yes

Yes

Yes


col4_degree_date

date



Yes

Yes

Yes


col4_degree_obtained

character

1


Yes

Yes

Yes


col4_end_date

date



Yes

Yes

Yes


col4_expelled_status

boolean



Yes

No

No


col4_name

character varying

30


Yes

Yes

Yes


col4_not_listed

boolean



Yes

Yes

Yes


col4_start_date

date



Yes

Yes

Yes


col4_state

character varying

30


Yes

Yes

Yes


college_count

smallint



Yes

Yes

Yes


college_expelled_summary

boolean



Yes

No

No


college_id

character

3


Yes

Yes

Yes


college_name

character varying

50


Yes

Yes

Yes


comfortable_english

boolean



Yes

Yes

Yes


comments

text



Yes

Yes

Yes


confirmation

character varying

30


Yes

Yes

Yes

IF an application is submitted using the Noncredit application URL then the value for <confirmation> is preceded with "NC-"

consent_indicator

boolean



Yes

Yes

Yes


counseling_personal

boolean



Yes

Yes

Yes


country

character

2


Yes

Yes

Yes


cryptokeyid

integer



No

No

No

System use only

dependent_status

character

1


Yes

No

Yes


discharge_type

character varying

1


Yes

No

No


district_name

character varying

50


Yes

Yes

Yes


dsps

boolean



Yes

Yes

Yes


edu_goal

character

1


Yes

Yes

Yes


elig_ab540

boolean



Yes

Yes

Yes


email

character varying

254


Yes

Yes

Yes

from OpenCCC Account

employment_assistance

boolean



Yes

Yes

Yes


enroll_status

character

1


Yes

Yes

Yes


eops                                                  

boolean



Yes

Yes

Yes


esignature

boolean



Yes

Yes

Yes


esl

boolean



Yes

Yes

Yes


experience

integer



Yes

Yes

Yes


fin_aid_ref

boolean



Yes

Yes

Yes


financial_assistance

boolean



Yes

Yes

Yes


firstname

character varying

50


Yes

Yes

Yes

from OpenCCC Account

foster_youth_mis

boolean



Yes

Yes

Yes


foster_youth_preference

boolean



Yes

Yes

No


foster_youth_priority

boolean



Yes

Yes

Yes


foster_youth_status

character

1


Yes

Yes

Yes


foster_youths

boolean



No longer used

No longer used

No longer used

No longer used in db

fraud_score

double precision



No

No

No

Added to Apply Only 6.2.0

fraud_status

integer



No

No

No

Added to Apply Only 6.2.0

gender

character

1


Yes

Yes

Yes


health_services

boolean



Yes

Yes

Yes


higher_comp_date

date



Yes

Yes

Yes


higher_edu_level

character

1


Yes

Yes

Yes


highest_edu_level

character

5


Yes

Yes

Yes


hispanic

boolean



Yes

Yes

Yes


home_schooled

boolean



Yes

Yes

Yes


homeless_youth

Boolean



Yes

Yes

Yes

3.31.17

housing_info

boolean



Yes

Yes

Yes


hs_attendance

smallint



Yes

Yes

Yes


hs_cds

character

6


Yes

Yes

Yes


hs_cds_full

Character varying

14


Yes

Yes

Yes

3.31.17

hs_ceeb

character

7


Yes

Yes

Yes


hs_city

character varying

20


Yes

Yes

Yes


hs_comp_date

date



Yes

Yes

Yes


hs_country

character

2


Yes

Yes

Yes


hs_edu_level

character

1


Yes

Yes

Yes


hs_name

character varying

30


Yes

Yes

Yes


hs_not_attended

boolean



Yes

Yes

Yes


hs_not_listed

boolean



Yes

Yes

Yes


hs_state

character

2


Yes

Yes

Yes


integrity_fg_01

boolean



Yes

Yes

Yes


integrity_fg_02

boolean



Yes

Yes

Yes


integrity_fg_03

boolean



Yes

Yes

Yes


integrity_fg_04

boolean



Yes

Yes

Yes


integrity_fg_11

boolean



Yes

Yes

Yes


integrity_fg_30

Boolean



Yes

Yes

Yes


Integrity_fg_40

boolean



Yes

Yes

Yes

2017-12 (AB801)

Integrity_fg_41

boolean







integrity_fg_47

boolean



Yes

Yes

Yes


integrity_fg_48

boolean



Yes

Yes

Yes


integrity_fg_49

boolean



Yes

Yes

Yes


integrity_fg_50

boolean



Yes

Yes

Yes


integrity_fg_51

boolean



Yes

Yes

Yes


integrity_fg_52

boolean



Yes

Yes

Yes


integrity_fg_53

boolean



Yes

Yes

Yes


integrity_fg_54

boolean



Yes

Yes

Yes


integrity_fg_55

boolean



Yes

Yes

Yes


integrity_fg_56

boolean



Yes

Yes

Yes


integrity_fg_57

boolean



Yes

Yes

Yes


integrity_fg_58

boolean



Yes

Yes

Yes


integrity_fg_59

boolean



Yes

Yes

Yes


integrity_fg_60

boolean



Yes

Yes

Yes


integrity_fg_61

boolean



Yes

Yes

Yes


integrity_fg_62

boolean



Yes

Yes

Yes


integrity_fg_63

boolean



Yes

Yes

Yes


integrity_fg_64

boolean



Yes

No

No


integrity_fg_65

boolean



Yes

Yes

Yes


integrity_fg_70

boolean



Yes

Yes

Yes


integrity_fg_71

boolean



Yes

No

Yes


integrity_fg_80

boolean



Yes

Yes

Yes


integrity_fg_81

boolean



Yes

Yes

Yes

Set to “true” when “non_credit” = true and all other flags are ignored

integrity_flags

character varying

255


Yes

No

No


intended_major

character varying

30


Yes

No

Yes


lastname

character varying

50


Yes

Yes

Yes

from OpenCCC Account

ip_address

character varying

15


Yes

Yes

No


last_page

character varying

25


Yes

No

No


mainphone_auth_text

boolean



Yes

Yes

Yes

from OpenCCC Account

mainphone_ext

character varying

4


Yes

Yes

Yes

from OpenCCC Account

mainphone

character varying

14


Yes

Yes

Yes

from OpenCCC Account

mainphoneintl

character varying

25


Yes

No

No


major_category

character varying

100


Yes

No

No

Admin 2.0  v.6.2.0

major_code

character varying

30


Yes

Yes

Yes


major_description

character varying

100


Yes

Yes

Yes

Extended to 100 9.29.16

major_id

bigint



No

No

No

System-generated

middlename

character varying

50


Yes

Yes

Yes

from OpenCCC Account

military_ca_stationed

boolean



Yes

Yes

Yes


military_discharge_date

date



Yes

Yes

Yes


military_home_country

character

2


Yes

Yes

Yes


military_home_state

character

2


Yes

Yes

Yes


military_legal_residence

character

2


Yes

Yes

Yes


military_stationed_ca_ed

boolean



Yes

Yes

Yes


military_stationed_ca_ed_end

date






Removed from DB 6.2.0

military_stationed_ca_ed_start

date






Removed from DB 6.2.0

military_status

character

1

No

Yes

Yes

Yes


no_documents

boolean



Yes

Yes

Yes

Used for VISA

no_mailing_address_homeless

Boolean



Yes

Yes

Yes

3.31.17

no_perm_address_homeless

Boolean



Yes

Yes

Yes

3.31.17

non_us_address

boolean



Yes

Yes

Yes


non_credit

boolean


No

Yes

Yes

Yes

Optional; Value set to "True" if applicant applies using the new Noncredit Application URL; otherwise it is "False"


character varying

30


Yes

Yes

Yes


online_classes

boolean



Yes

Yes

Yes


orientation

bytea



No

No

No

Researchers can access through Data Warehouse

otherfirstname

character varying

50


Yes

Yes

Yes

from OpenCCC Account

otherlastname

character varying

50


Yes

Yes

Yes

from OpenCCC Account

othermiddlename

character varying

50


Yes

Yes

Yes

from OpenCCC Account

perm_address_validation

character

1


Yes

No

No


perm_city

character varying

50


Yes

Yes

Yes

from OpenCCC Account

perm_country

character

2


Yes

Yes

Yes

from OpenCCC Account

perm_nonusaprovince

character varying

30


Yes

Yes

Yes

from OpenCCC Account

perm_postalcode

character varying

20


Yes

Yes

Yes

from OpenCCC Account

perm_state

character

2


Yes

Yes

Yes

from OpenCCC Account

perm_streetaddress1

character varying

50


Yes

Yes

Yes

from OpenCCC Account

perm_streetaddress2

character varying

50


Yes

Yes

Yes

from OpenCCC Account

perm_zip4

character

4


Yes

No

Yes

from OpenCCC Account

pg_edu_mis

character

2


Yes

Yes

Yes


pg_firstname

character varying

20


Yes

Yes

Yes


pg_lastname

character varying

25


Yes

Yes

Yes


pg_rel

character

1


Yes

Yes

Yes


pg1_edu

character

1


Yes

Yes

Yes


pg2_edu

character

1


Yes

Yes

Yes


postalcode

character varying

20


Yes

Yes

Yes

from OpenCCC Account

preferred_firstname

character varying

50


Yes

No

Yes

from OpenCCC Account

preferred_lastname

character varying

50


Yes

No

Yes

from OpenCCC Account

preferred_middlename

character varying

50


Yes

No

Yes

from OpenCCC Account

preferred_name

boolean

  1


Yes

No

Yes

from OpenCCC Account

race_ethnic

text



Yes

Yes

Yes


race_ethnic_full

text

805


 Yes

No

No

v.6.3.0 2018

race_group

text



Yes

Yes

Yes


rdd

date



Yes

No

Yes


recommend

integer



Yes

Yes

Yes


reentry_program

boolean



Yes

Yes

Yes


res_area_a

smallint



Yes

Yes

Yes


res_area_b

smallint



Yes

Yes

Yes


res_area_c

smallint



Yes

Yes

Yes


res_area_d

smallint



Yes

Yes

Yes


res_prev_date

date



Yes

Yes

Yes


res_status

character

1


Yes

Yes

Yes


res_status_change

boolean



Yes

Yes

Yes


salt

text



No

No

No

System use only

scholarship_info

boolean



Yes

Yes

Yes


secondphone_auth_text

boolean



Yes

Yes

Yes

from OpenCCC Account

secondphone_ext

character varying

4


Yes

Yes

Yes

from OpenCCC Account

secondphone

character varying

14


Yes

Yes

Yes

from OpenCCC Account

secondphoneintl

character varying

25


Yes

No

No


orientation

bytea



No

No

No

Researchers can access through Data Warehouse

signature

text



Yes

No

No


ssn_display

character varying

11


Yes

Yes

Yes


ssn_exception

boolean



Yes

No

Yes

3/31/16
from OpenCCC Account

ssn_no

character



Yes

Yes

Yes

Added 9.30.16

ssn_type

character

1


Yes

No

Yes

from OpenCCC Account

ssn

text



Yes

Yes

No

from OpenCCC Account

state

character

2


Yes

Yes

Yes


status

character

1


Yes

Yes

Yes

Download status

streetaddress1

character varying

50


Yes

Yes

Yes


streetaddress2

character varying

50


Yes

Yes

Yes


student_government

boolean



Yes

Yes

Yes


suffix

character varying

3


Yes

Yes

Yes

from OpenCCC Account

sup_page_code

character varying

30


No

Yes- as content

Yes _id


supp_check_01

boolean



Yes

Yes

Yes


supp_check_02

boolean



Yes

Yes

Yes


supp_check_03

boolean



Yes

Yes

Yes


supp_check_04

boolean



Yes

Yes

Yes


supp_check_05

boolean



Yes

Yes

Yes


supp_check_06

boolean



Yes

Yes

Yes


supp_check_07

boolean



Yes

Yes

Yes


supp_check_08

boolean



Yes

Yes

Yes


supp_check_09

boolean



Yes

Yes

Yes


supp_check_10

boolean



Yes

Yes

Yes


supp_check_11

boolean



Yes

Yes

Yes


supp_check_12

boolean



Yes

Yes

Yes


supp_check_13

boolean



Yes

Yes

Yes


supp_check_14

boolean



Yes

Yes

Yes


supp_check_15

boolean



Yes

Yes

Yes


supp_check_16

boolean



Yes

Yes

Yes


supp_check_17

boolean



Yes

Yes

Yes


supp_check_18

boolean



Yes

Yes

Yes


supp_check_19

boolean



Yes

Yes

Yes


supp_check_20

boolean



Yes

Yes

Yes


supp_check_21

boolean



Yes

Yes

Yes


supp_check_22

boolean



Yes

Yes

Yes


supp_check_23

boolean



Yes

Yes

Yes


supp_check_24

boolean



Yes

Yes

Yes


supp_check_25

boolean



Yes

Yes

Yes


supp_check_26

boolean



Yes

Yes

Yes


supp_check_27

boolean



Yes

Yes

Yes


supp_check_28

boolean



Yes

Yes

Yes


supp_check_01

boolean



Yes

Yes

Yes


supp_check_29

boolean



Yes

Yes

Yes


supp_check_30

boolean



Yes

Yes

Yes


supp_check_31

boolean



Yes

Yes

Yes


supp_check_32

boolean



Yes

Yes

Yes


supp_check_33

boolean



Yes

Yes

Yes


supp_check_34

boolean



Yes

Yes

Yes


supp_check_35

boolean



Yes

Yes

Yes


supp_check_36

boolean



Yes

Yes

Yes


supp_check_37

boolean



Yes

Yes

Yes


supp_check_38

boolean



Yes

Yes

Yes


supp_check_39

boolean



Yes

Yes

Yes


supp_check_40

boolean



Yes

Yes

Yes


supp_check_41

boolean



Yes

Yes

Yes


supp_check_42

boolean



Yes

Yes

Yes


supp_check_43

boolean



Yes

Yes

Yes


supp_check_44

boolean



Yes

Yes

Yes


supp_check_45

boolean



Yes

Yes

Yes


supp_check_46

boolean



Yes

Yes

Yes


supp_check_47

boolean



Yes

Yes

Yes


supp_check_48

boolean



Yes

Yes

Yes


supp_check_49

boolean



Yes

Yes

Yes


supp_check_50

boolean



Yes

Yes

Yes


supp_country_01

string

2


Yes

Yes

Yes


supp_country_02

string

2


Yes

Yes

Yes


supp_country_03

string

2


Yes

Yes

Yes


supp_country_04

string

2


Yes

Yes

Yes


supp_country_05

string

2


Yes

Yes

Yes


supp_date_01

date



Yes

Yes

Yes


supp_date_02

date



Yes

Yes

Yes


supp_date_03

date



Yes

Yes

Yes


supp_date_04

date



Yes

Yes

Yes


supp_date_05

date



Yes

Yes

Yes


supp_menu_01

string

60


Yes

Yes

Yes


supp_menu_02

string

60


Yes

Yes

Yes


supp_menu_03

string

60


Yes

Yes

Yes


supp_menu_04

string

60


Yes

Yes

Yes


supp_menu_05

string

60


Yes

Yes

Yes


supp_menu_06

string

60


Yes

Yes

Yes


supp_menu_07

string

60


Yes

Yes

Yes


supp_menu_08

string

60


Yes

Yes

Yes


supp_menu_09

string

60


Yes

Yes

Yes


supp_menu_10

string

60


Yes

Yes

Yes


supp_menu_11

string

60


Yes

Yes

Yes


supp_menu_12

string

60


Yes

Yes

Yes


supp_menu_13

string

60


Yes

Yes

Yes


supp_menu_14

string

60


Yes

Yes

Yes


supp_menu_15

string

60


Yes

Yes

Yes


supp_menu_16

string

60


Yes

Yes

Yes


supp_menu_17

string

60


Yes

Yes

Yes


supp_menu_18

string

60


Yes

Yes

Yes


supp_menu_19

string

60


Yes

Yes

Yes


supp_menu_20

string

60


Yes

Yes

Yes


supp_menu_21

string

60


Yes

Yes

Yes


supp_menu_22

string

60


Yes

Yes

Yes


supp_menu_23

string

60


Yes

Yes

Yes


supp_menu_24

string

60


Yes

Yes

Yes


supp_menu_25

string

60


Yes

Yes

Yes


supp_menu_26

string

60


Yes

Yes

Yes


supp_menu_27

string

60


Yes

Yes

Yes


supp_menu_28

string

60


Yes

Yes

Yes


supp_menu_29

string

60


Yes

Yes

Yes


supp_menu_30

string

60


Yes

Yes

Yes


supp_phonenumber_01

string

25


Yes

No

No


supp_phonenumber_02

string

25


Yes

No

No


supp_phonenumber_03

string

25


Yes

No

No


supp_phonenumber_04

string

25


Yes

No

No


supp_phonenumber_05

string

25


Yes

No

No


supp_secret_01

string



Yes

No

No


supp_secret_02

string



Yes

No

No


supp_secret_03

string



Yes

No

No


supp_secret_04

string



Yes

No

No


supp_secret_05

string



Yes

No

No


supp_state_01

string

2


Yes

Yes

Yes


supp_state_02

string

2


Yes

Yes

Yes


supp_state_03

string

2


Yes

Yes

Yes


supp_state_04

string

2


Yes

Yes

Yes


supp_state_05

string

2


Yes

Yes

Yes


supp_text_01

string

250


Yes

Yes

Yes


supp_text_02

string

250


Yes

Yes

Yes


supp_text_03

string

250


Yes

Yes

Yes


supp_text_04

string

250


Yes

Yes

Yes


supp_text_05

string

250


Yes

Yes

Yes


supp_text_06

string

250


Yes

Yes

Yes


supp_text_07

string

250


Yes

Yes

Yes


supp_text_08

string

250


Yes

Yes

Yes


supp_text_09

string

250


Yes

Yes

Yes


supp_text_10

string

250


Yes

Yes

Yes


supp_text_11

string

250


Yes

Yes

Yes


supp_text_12

string

250


Yes

Yes

Yes


supp_text_13

string

250


Yes

Yes

Yes


supp_text_14

string

250


Yes

Yes

Yes


supp_text_15

string

250


Yes

Yes

Yes


supp_text_16

string

250


Yes

Yes

Yes


supp_text_17

string

250


Yes

Yes

Yes


supp_text_18

string

250


Yes

Yes

Yes


supp_text_19

string

250


Yes

Yes

Yes


supp_text_20

string

250


Yes

Yes

Yes


supp_yesno_1

boolean



Yes

Yes

Yes


supp_yesno_2

boolean



Yes

Yes

Yes


supp_yesno_3

boolean



Yes

Yes

Yes


supp_yesno_4

boolean



Yes

Yes

Yes


supp_yesno_5

boolean



Yes

Yes

Yes


supp_yesno_6

boolean



Yes

Yes

Yes


supp_yesno_7

boolean



Yes

Yes

Yes


supp_yesno_8

boolean



Yes

Yes

Yes


supp_yesno_9

boolean



Yes

Yes

Yes


supp_yesno_10

boolean



Yes

Yes

Yes


supp_yesno_11

boolean



Yes

Yes

Yes


supp_yesno_12

boolean



Yes

Yes

Yes


supp_yesno_13

boolean



Yes

Yes

Yes


supp_yesno_14

boolean



Yes

Yes

Yes


supp_yesno_15

boolean



Yes

Yes

Yes


supp_yesno_16

boolean



Yes

Yes

Yes


supp_yesno_17

boolean



Yes

Yes

Yes


supp_yesno_18

boolean



Yes

Yes

Yes


supp_yesno_19

boolean



Yes

Yes

Yes


supp_yesno_20

boolean



Yes

Yes

Yes


supp_yesno_21

boolean



Yes

Yes

Yes


supp_yesno_22

boolean



Yes

Yes

Yes


supp_yesno_23

boolean



Yes

Yes

Yes


supp_yesno_24

boolean



Yes

Yes

Yes


supp_yesno_25

boolean



Yes

Yes

Yes


supp_yesno_26

boolean



Yes

Yes

Yes


supp_yesno_27

boolean



Yes

Yes

Yes


supp_yesno_28

boolean



Yes

Yes

Yes


supp_yesno_29

boolean



Yes

Yes

Yes


supp_yesno_30

boolean



Yes

Yes

Yes


tanf_ssi_ga

boolean



Yes

Yes

Yes


term_code

character varying

15


Yes

Yes

Yes


term_description

character varying

100


Yes

Yes

Yes


term_id

bigint



Yes

No

No


term_end

Bigint



Yes

Yes

Yes

Added to DLC 3/31/17

term_start

bigint



Yes

Yes

Yes

Added to DLC 3/31/17

testing_assessment

boolean



Yes

Yes

Yes


transfer_info

boolean



Yes

Yes

Yes


transgender

bytea



No

No

No

Researchers can access through Data Warehouse

transgender_submission

bytes



No

No

No


transgender_encrypted

text



No

No

No


tstmp_create

timestamp with time zone


DEFAULT

Yes

Yes

No


tstmp_download

timestamp with time zone



Yes

Yes

No


tstmp_submit

timestamp with time zone



Yes

Yes

Yes


tstmp_update

timestamp with time zone



Yes

No

No


tutoring_services

boolean



Yes

Yes

Yes


under19_ind

boolean



Yes

No

Yes


veterans_services

boolean



Yes

Yes

Yes


visa_type

Alphanumeric

2


Yes

Yes

Yes


zip4

character

4


Yes

No

Yes


completed_eleventh_grade

boolean



Yes*

No*

No*

Opt-In ONLY

grade_point_average

Alpha-Numeric value

5


Yes*

Yes*

Yes*

Opt-In ONLY

highest_english_course

Integer



Yes*

Yes*

Yes*

Opt-In ONLY

highest_english_grade

Character varying

2


Yes*

Yes*

Yes*

Opt-In ONLY

highest_math_course_taken

Integer



Yes*

Yes*

Yes*

Opt-In ONLY

highest_math_taken_grade

Character varying

2


Yes*

Yes*

Yes*

Opt-In ONLY

highest_math_course_passed

Integer



Yes*

Yes*

Yes*

Opt-In ONLY

highest_math_passed_grade

Character varying

2


Yes*

Yes*

Yes*

Opt-In ONLY

...