Versions Compared

Old Version 10

changes.mady.by.user Patricia Donohue

Saved on

compared with

New Version 11

changes.mady.by.user Patricia Donohue

Saved on

Key

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

...

Data Element (column)

Data Type

Length

Allows Null

 Downloadable

In Report Center?

In Rules?

Notes

address_verified

boolean



Yes

Yes

Yes


agent_phone_ext

varchar

4


Yes

Yes

Yes

Not currently used

agent_phone_number

varchar

25


Yes

Yes

Yes


alt_non_us_phone_auth_txt

boolean



Yes


Yes

Not currently used

alt_non_us_phone_ext

varchar

4


Yes


Yes

Not currently used

alt_non_us_phone_number

varchar

25


Yes

Yes

Yes


app_id

bigint


No

Yes

Yes



app_lang

char

2


Yes

Yes

Yes


authorize_agent_info_release

boolean



Yes

Yes

Yes


birthdate

date



Yes

Yes

Yes

From Account

campaign1

varchar

255


Yes

Yes


Added 3/27/15

campaign2

varchar

255


Yes

Yes


Added 3/27/15


campaign3

varchar

255


Yes

Yes


Added 3/27/15

ccc_id

varchar

8

No

Yes

Yes

Yes


citizenship_status

varchar

1


Yes

Yes

Yes


city

varchar

50


Yes

Yes

Yes

Agent's City

coenroll_confirm

char

1


Yes

Yes

Yes

Not currently used

col1_cds

varchar

30


Yes

Yes

Yes


col1_ceeb

varchar

30


Yes

Yes

Yes


col1_city

varchar

50


Yes

Yes

Yes


col1_college_attended_id

bigint



No

Yes

Yes


col1_country

char

2


Yes

Yes

Yes


col1_degree_date

date



Yes

Yes

Yes


col1_degree_obtained

char

1


Yes

Yes

Yes


col1_end_date

date



Yes

Yes

Yes


col1_expelled_status

boolean



Yes

Yes

Yes


col1_major

varchar

50


Yes

Yes

Yes


col1_name

varchar

30


Yes

Yes

Yes


col1_non_us_province

varchar

50


Yes

Yes

Yes


col1_not_listed

boolean



Yes

Yes

Yes


col1_primary_instruction_language

varchar

5010


Yes

Yes

Yes


col1_start_date

date



Yes

Yes

Yes


col1_state

varchar

2


Yes

Yes

Yes


col2_cds

varchar

30


Yes

Yes

Yes


col2_ceeb

varchar

30


Yes

Yes

Yes


col2_city

varchar

50


Yes

Yes

Yes


col2_college_attended_id

bigint



No

Yes

Yes


col2_country

char

2


Yes

Yes

Yes


col2_degree_date

date



Yes

Yes

Yes


col2_degree_obtained

char

1


Yes

Yes

Yes


col2_end_date

date



Yes

Yes

Yes


col2_expelled_status

boolean



Yes

Yes

Yes


col2_major

varchar

50


Yes

Yes

Yes


col2_name

varchar

30


Yes

Yes

Yes


col2_non_us_province

varchar

50


Yes

Yes

Yes


col2_not_listed

boolean



Yes

Yes

Yes


col2_primary_instruction_language

varchar

10


Yes

Yes

Yes


col2_start_date

date



Yes

Yes

Yes


col2_state

varchar

2


Yes

Yes

Yes


col3_cds

varchar

30


Yes

Yes

Yes


col3_ceeb

varchar

30


Yes

Yes

Yes


col3_city

varchar

50


Yes

Yes

Yes


col3_college_attended_id

bigint



No

Yes

Yes


col3_country

char

2


Yes

Yes

Yes


col3_degree_date

date



Yes

Yes

Yes


col3_degree_obtained

char

1


Yes

Yes

Yes


col3_end_date

date



Yes

Yes

Yes


col3_expelled_status

boolean



Yes

Yes

Yes


col3_major

varchar

50


Yes

Yes

Yes


col3_name

varchar

30


Yes

Yes

Yes


col3_non_us_province

varchar

50


Yes

Yes

Yes


col3_not_listed

boolean



Yes

Yes

Yes


col3_primary_instruction_language

varchar

10


Yes

Yes

Yes



col3_start_date

date



Yes

Yes

Yes


col3_state

varchar

2


Yes

Yes

Yes


col4_cds

varchar

30


Yes

Yes

Yes


col4_ceeb

varchar

30


Yes

Yes

Yes


col4_city

varchar

50


Yes

Yes

Yes


col4_college_attended_id

bigint



No

Yes

Yes


col4_country

char

2


Yes

Yes

Yes


col4_degree_date

date



Yes

Yes

Yes


col4_degree_obtained

char

1


Yes

Yes

Yes


col4_end_date

date



Yes

Yes

Yes


col4_expelled_status

boolean



Yes

Yes

Yes


col4_major

varchar

50


Yes

Yes

Yes


col4_name

varchar

30


Yes

Yes

Yes


col4_non_us_province

varchar

50


Yes

Yes

Yes


col4_not_listed

boolean



Yes

Yes

Yes


col4_primary_instruction_language

varchar

10


Yes

Yes

Yes


col4_start_date

date



Yes

Yes

Yes


col4_state

varchar

2


Yes

Yes

Yes


college_comp_date

date



Yes

Yes



college_count

smallint



Yes

Yes

Yes


college_edu_level

char

12


Yes

Yes



college_expelled_summary

boolean



Yes

Yes

Yes


college_id

char

3


Yes

Yes

Yes


college_name

char

50


Yes

Yes

Yes


company

varchar

50


Yes

Yes

Yes


confirmation

varchar

30


Yes

Yes

Yes


consent

boolean



Yes

Yes

Yes


contact

varchar

50


Yes

Yes

Yes


country

varchar

2


Yes

Yes

Yes

Agent's Country

country_of_birth

char

2


Yes

Yes

Yes


country_of_citizenship

char

2


Yes

Yes

Yes


cryptokeyid

integer



Yes



System property

current_mailing_address_outside_us

boolean



Yes

Yes

Yes

Not currently used

current_mailing_address_verified

boolean



Yes

Yes

Yes


current_mailing_city

varchar

50


Yes

Yes

Yes


current_mailing_country

char

2


Yes

Yes

Yes


current_mailing_non_us_address

boolean



Yes

Yes

Yes


current_mailing_non_us_postal_code

varchar

30


Yes

Yes

Yes


current_mailing_non_us_province

varchar

50


Yes

Yes

Yes


current_mailing_same_as_permanent

boolean



Yes

Yes



current_mailing_state

char

2


Yes

Yes

Yes


current_mailing_street_1

varchar

50


Yes

Yes

Yes


current_mailing_street_2

varchar

50


Yes

Yes

Yes


current_mailing_zip_code

varchar

20


Yes

Yes

Yes


dep1_country_of_birth

varchar

2


Yes

Yes

Yes


dep1_date_of_birth

date



Yes

Yes

Yes


dep1_dependent_id

bigint



No

Yes

Yes


dep1_first_name

varchar

25


Yes

Yes

Yes


dep1_gender

varchar

1


Yes

Yes

Yes


dep1_last_name

varchar

25


Yes

Yes

Yes


dep1_no_first_name

boolean



Yes

Yes

Yes


dep1_relationship

varchar

20


Yes

Yes

Yes


dep10_country_of_birth

varchar

2


Yes

Yes

Yes


dep10_date_of_birth

date



Yes

Yes

Yes


dep10_dependent_id

bigint



No

Yes

Yes


dep10_first_name

varchar

25


Yes

Yes

Yes


dep10_gender

varchar

1


Yes

Yes

Yes


dep10_last_name

varchar

25


Yes

Yes

Yes


dep10_no_first_name

boolean



Yes

Yes

Yes


dep10_relationship

varchar

20


Yes

Yes

Yes


dep2_country_of_birth

varchar

2


Yes

Yes

Yes


dep2_date_of_birth

date



Yes

Yes

Yes


dep2_dependent_id

bigint



No

Yes

Yes


dep2_first_name

varchar

25


Yes

Yes

Yes


dep2_gender

varchar

1


Yes

Yes

Yes


dep2_last_name

varchar

25


Yes

Yes

Yes


dep2_no_first_name

boolean



Yes

Yes

Yes


dep2_relationship

varchar

20


Yes

Yes

Yes


dep3_country_of_birth

varchar

2


Yes

Yes

Yes


dep3_date_of_birth

date



Yes

Yes

Yes


dep3_dependent_id

bigint



No

Yes

Yes


dep3_first_name

varchar

25


Yes

Yes

Yes


dep3_gender

varchar

1


Yes

Yes

Yes


dep3_last_name

varchar

25


Yes

Yes

Yes


dep3_no_first_name

boolean



Yes

Yes

Yes


dep3_relationship

varchar

20


Yes

Yes

Yes


dep4_country_of_birth

varchar

2


Yes

Yes

Yes


dep4_date_of_birth

date



Yes

Yes

Yes


dep4_dependent_id

bigint



No

Yes

Yes


dep4_first_name

varchar

25


Yes

Yes

Yes


dep4_gender

varchar

1


Yes

Yes

Yes


dep4_last_name

varchar

25


Yes

Yes

Yes


dep4_no_first_name

boolean



Yes

Yes

Yes


dep4_relationship

varchar

20


Yes

Yes

Yes


dep5_country_of_birth

varchar

2


Yes

Yes

Yes


dep5_date_of_birth

date



Yes

Yes

Yes


dep5_dependent_id

bigint



No

Yes

Yes


dep5_first_name

varchar

25


Yes

Yes

Yes


dep5_gender

varchar

1


Yes

Yes

Yes


dep5_last_name

varchar

25


Yes

Yes

Yes


dep5_no_first_name

boolean



Yes

Yes

Yes


dep5_relationship

varchar

20


Yes

Yes

Yes


dep6_country_of_birth

varchar

2


Yes

Yes

Yes


dep6_date_of_birth

date



Yes

Yes

Yes


dep6_dependent_id

bigint



No

Yes

Yes


dep6_first_name

varchar

25


Yes

Yes

Yes


dep6_gender

varchar

1


Yes

Yes

Yes


dep6_last_name

varchar

25


Yes

Yes

Yes


dep6_no_first_name

boolean



Yes

Yes

Yes


dep6_relationship

varchar

20


Yes

Yes

Yes


dep7_country_of_birth

varchar

2


Yes

Yes

Yes


dep7_date_of_birth

date



Yes

Yes

Yes


dep7_dependent_id

bigint



No

Yes

Yes


dep7_first_name

varchar

25


Yes

Yes

Yes


dep7_gender

varchar

1


Yes

Yes

Yes


dep7_last_name

varchar

25


Yes

Yes

Yes


dep7_no_first_name

boolean



Yes

Yes

Yes


dep7_relationship

varchar

20


Yes

Yes

Yes


dep8_country_of_birth

varchar

2


Yes

Yes

Yes


dep8_date_of_birth

date



Yes

Yes

Yes


dep8_dependent_id

bigint



No

Yes

Yes


dep8_first_name

varchar

25


Yes

Yes

Yes


dep8_gender

varchar

1


Yes

Yes

Yes


dep8_last_name

varchar

25


Yes

Yes

Yes


dep8_no_first_name

boolean



Yes

Yes

Yes


dep8_relationship

varchar

20


Yes

Yes

Yes


dep9_country_of_birth

varchar

2


Yes

Yes

Yes


dep9_date_of_birth

date



Yes

Yes

Yes


dep9_dependent_id

bigint



No

Yes

Yes


dep9_first_name

varchar

25


Yes

Yes

Yes


dep9_gender

varchar

1


Yes

Yes

Yes


dep9_last_name

varchar

25


Yes

Yes

Yes


dep9_no_first_name

boolean



Yes

Yes

Yes


dep9_relationship

varchar

20


Yes

Yes

Yes


educational_goal

char

1


Yes

Yes

Yes


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


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



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

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

...

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

email

email

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.

...

Account Data in the CC Promise Grant Application

Data Item

Account Data Element

Application Data Element

CCCID

cccid

ccc_id

Date of Birth

birthdate

birthdate

Email Address                 

email

email

Legal Name: First

firstname

firstname

Legal Name: Last

lastname

lastname

Legal Name: Middle

middlename

middlename

Main Telephone

mainphone

mainphone

Main Telephone Extension

mainphone_ext

mainphone_ext

Permanent Address: No Address

no_perm_address_homeless

no_perm_address_homeless

Permanent Address: City

city

city

Permanent Address: Country

county

country

Permanent Address: Non-U.S. State/Province

nonusaprovince

province

Permanent Address: Postal Code

postalcode

postalcode

Permanent Address: State

state

state

Permanent Address: Street 1

streetaddress1

streetaddress1

Permanent Address: Street 2

streetaddress2

streetaddress2

Preferred Name: First

preferred_firstname

preferred_firstname

Preferred Name: Last

preferred_lastname

preferred_lastname

Preferred Name: Middle

preferred_middlename

preferred_middlename

Previous Name: First

previous_firstname

previous_firstname

Previous Name: Middle

previous_middlename

previous_middlename

Previous Name: Last

previous_lastname

previous_lastname

Social Security Number: Other

Exception

ssn_exception

ssn_exception

Social Security Hash
(Internal Use Only)

ssn_hash

ssn_hash

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

mainphone_auth_text

Crypto key id: Internal System Field

cryptokeyid

cryptokeyid

 

 

 

...

 

 

 

 

 

 

 

 

...



...

CC Promise Grant Application Downloadable Fields

Data Element (column)

Data Type

Length

Allows

Allows Null

Down-loadable

Downloadable

In

the

Report

the Report Center?

In the

Rules

Rules  Area?

Notes?

ack_fin_aid

boolean



Yes

Yes

Yes


app_id

bigint


No

Yes

Yes

No


app_lang

string

2


Yes

Yes

Yes


birthdate

date



Yes

Yes

Yes


born_before_23_year

string

1


Yes

Yes

Yes


campaign1

string

255


Yes

Yes

No


campaign2

string

255


Yes

Yes

No


campaign3

string

255


Yes

Yes

No


ccc_id

string

8

No

Yes

Yes

Yes


cert_national_guard

string

1


Yes

Yes

Yes


cert_veteran_affairs

string

1


Yes

Yes

Yes


city

string

50


Yes

Yes

Yes


college_id

string

3


Yes

Yes

Yes


college_name

string

50


Yes

Yes

Yes


confirmation_applicant

boolean



Yes

Yes

Yes


confirmation_number

String

25


Yes

Yes

Yes


confirmation_parent_guardian

boolean



Yes

Yes

Yes


country

string

2


Yes

Yes

Yes


dep_gross_income

integer



Yes

Yes

Yes


dep_number_household

integer



Yes

Yes

Yes


dep_other_income

integer



Yes

Yes

Yes


dep_total_income

integer



Yes

Yes

Yes


dependency_status

string

1


Yes

Yes

Yes


dependent_on_parent_taxes

string

1


Yes

Yes

Yes


dependents

string

1


Yes

Yes

Yes


determined_ab540_eligible

string

1


Yes

Yes

Yes


determined_homeless

String

1


Yes

Yes

Yes

Added Mar 2017

determined_non_res_exempt

string

1


Yes

Yes

Yes


determined_residentca

string

1


Yes

Yes

Yes


elig_bogfw

String

1


Yes

Yes

Yes


elig_medal_honor

string

1


Yes

Yes

Yes


elig_method_a

boolean



Yes

Yes

Yes


elig_method_b

boolean



Yes

Yes

Yes


elig_method_d

Boolean



Yes

Yes

Yes

3.31.17

elig_police_fire

string

1


Yes

Yes

Yes


elig_sept_11

string

1


Yes

Yes

Yes


email

String

50


Yes

Yes

Yes


emancipated_minor

string

1


Yes

Yes

Yes


firstname

string

50


Yes

Yes

Yes


general_assistance

string

1


Yes

Yes

Yes


homeless_youth_hud

string

1


Yes

Yes

Yes


homeless_youth_other

string

1


Yes

Yes

Yes


homeless_youth_school

string

1


Yes

Yes

Yes


ind_gross_income

Integer



Yes

Yes

Yes


ind_number_household

integer



Yes

Yes

Yes


ind_other_income

integer



Yes

Yes

Yes


ind_total_income

integer



Yes

Yes

Yes


ip_address

string

15


Yes

No

No


last_page

string

25


Yes

Yes

Yes


lastname

string

50


Yes

Yes

Yes


legal_guardianship

string

1


Yes

Yes

Yes


living_with_parents

string

1


Yes

Yes

Yes


mainphone

string

14


Yes

Yes

Yes


mainphone_auth_text

boolean



Yes

Yes

Yes


mainphone_ext

string

4


Yes

Yes

Yes


marital_status

string

1


Yes

Yes

Yes


married_or_rdp

string

1


Yes

Yes

Yes


middlename

string

50


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


parent_guardian_name

string

60


Yes

Yes

Yes


parents_assistance

string

1


Yes

Yes

Yes


parents_deceased

string

1


Yes

Yes

Yes


postalcode

string

20


Yes

Yes

Yes


preferred_firstname

string

50


Yes

Yes

Yes


preferred_lastname

string

50


Yes

Yes

Yes


preferred_middlename

string

50


Yes

Yes

Yes


preferred_name

boolean



Yes

Yes

Yes


otherfirstname

String

50




No


othermiddlename

String

50




No


otherlastname

String

50




No


othername

String

50




No


province

string

30


Yes

Yes

Yes


reg_dom_partner

string

1


Yes

Yes

Yes


ssi_ssp

string

1


Yes

Yes

Yes


ssn

string



Yes

No

No


ssn_exception

boolean



Yes

Yes

Yes


ssn_hash

string



Yes

No

No


ssn_last4

string

4


Yes


Yes


ssn_no

Boolean



Yes

Yes

Yes


ssn_type

string

1


Yes

Yes

Yes


state

string

2


Yes

Yes

Yes


status

String

1


Yes

Yes

Yes


streetaddress1

string

50


Yes

Yes

Yes


streetaddress2

string

50


Yes

Yes

Yes


student_college_id

string

20


Yes

Yes

Yes


tanf_calworks

string

1


Yes

Yes

Yes


term_code

string

5


Yes

Yes

Yes


tstmp_create

date

tmstmp w/ time zone


Yes


Yes


tstmp_download

date

tmstmp w/ time zone


Yes


Yes


tstmp_submit

date

tmstmp w/ time zone


Yes


Yes


tstmp_update

date

tmstmp w/ time zone


Yes


Yes


us_veteran

string

1


Yes

Yes

Yes


year_code

bigint



NO


Yes

Not downloadable

year_description

string

100


Yes

Yes

Yes





Data Fields: Supplemental Questions Responses

...