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

Data Element (column)

Data Type

Length

Allows

Null

Down-loadable

In the

Report

Center?

In the 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