Versions Compared

Old Version 15

changes.mady.by.user Patricia Donohue

Saved on

compared with

New Version 16

changes.mady.by.user Patricia Donohue

Saved on

Key

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

...

Here are some sample patterns:

Database Field ValuePatternDownload Field Result
530-332-223399999999995303322233
530-332-223399999993322233
530-332-2233(999) 999-9999(530) 332-2233
5303322233(999) 999-9999(530) 332-2233


<numberFormatter>

The numberFormatter can be used for applying a variety of formats to numbers.

...

Attribute NameDescription
nameName of the input field
lenSpecifies the length of the output field
formatSee the following table for sample formats


Database Field ValueFormatDownload Field Result
25000"$%,d.00"$25,000.00
25000"%,d.00"25,000.00

Note: To view more format value examples, see: http://docs.oracle.com/javase/7/docs/api/java/util/ Formatter.html#syntax

...

CC Promise Grant Application Downloadable Fields

Data Element (column)

Data Type

Length

Allows Null

Downloadable

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





Data Fields: Supplemental Questions Responses

...