CCCApply Standard & Noncredit Application: Data Elements

California Community College logo

CCCApply Standard & Noncredit Application: Data Elements

Version 6.21.0

 

Data Fields

Skip to main content

College & District Information Fields

The data fields in this section are stored in the College and District tables in the Common Application Platform (CAP). Many of the fields are configurable and managed by the colleges in the CCCApply Administrator.

Campaign Fields

Data Element:

campaign1, campaign2, campaign3

Description:

An optional college-defined campaign name or code that can be used to identify the source of the student’s application (when embedded in the college’s application URL).

 

Type/Format, Length:

varchar, 255

Values:

Text string; supported characters: a-z, A-Z, 0-9, -, _, ., ~ and %

Storage/Usage:

Stored in the submitted applications table. Deliverable and available for reporting.

Up to three campaigns may be stored in the database at one time.

Allows Null:

No

Default:

None

Display Conditions:

Does not display to the user.

Notes:

See the CCCApply Administrator User Guide for implementation information.

Provides a name that colleges can download and report on as a measure of a campaign's success.

In order to implement the campaign feature, when you create your URL for students to link to the CCCApply application you must add the extra parameter of &user1=x (where x = the name of your campaign) on to the end of the URL link. You can do this for up to three parameters, using &user1=x&user2=y and &user3=z (where x, y and z = the names of other unique campaigns). For example, the format for implementing a URL for three campaigns would look like this:
http://www.google.com

https://www.opencccapply.net/cccapply-welcome? cccMisCode=231&user1=x&user2=y&user3=z

An example of the practical implementation of this format is:

https://www.opencccapply.net/cccapply-welcome?cccMisCode=231&user1=collegeIntroPage&user2=advertOnGoogle&user3=advertOnGoodMorningAmerica

DELIVERED FIELD.

Revision Log:

 

Back to top of section: College & District Information Data | Back to top of page

College ID

Data Element:

college_id

Description:

The CCCCO MIS identification code for the California Community College.

Type/Format, Length:

bpchar, 3

Values:

3-digit code

Storage/Usage:

Pulled from table of COMIS college ID codes. System field:  Required and non-configurable.

Allows Null:

No

Default:

None

Display Conditions:

Displays on Application Confirmation page.

Notes:

DELIVERED FIELD. College table.

Revision Log:

 

Back to top of section: College & District Information Data | Back to top of page

College Name

Data Element:

college_name

Description:

Name of college student is applying to.

Type/Format, Length:

varchar, 50

Values:

Text string

Storage/Usage:

Required. College may customize in the CCCApply Administrator.

Allows Null:

No

Default:

None

Display Conditions:

Displays on Application Confirmation page.

Notes:

DELIVERED FIELD

Revision Log:

 

Back to top of section: College & District Information Data | Back to top of page

College Address: Street

Data Element:

college: streetaddress1, streetaddress2

Description:

Street address for the college, in two lines.

Type/Format, Length:

Each: varchar, 50

Values:

Text strings

Storage/Usage:

Required. College-customizable in the CCCApply Administrator.

Allows Null:

streetaddress1 – No

streetaddress2 - Yes

Default:

None

Display Conditions:

Displays on Application Confirmation page.

Notes:

NOT A DELIVERED FIELD

Revision Log

 

Back to top of section: College & District Information Data | Back to top of page

College Address: City

Data Element:

college: city

Description:

City portion of college’s address

Type/Format, Length:

varchar, 50

Values:

Text string

Storage/Usage:

Required. College-customizable in the CCCApply Administrator.

State is always ‘CA’ when address is displayed.

Allows Null:

No

Default:

None

Display Conditions:

Displays on Application Confirmation page.

Notes:

State is always ‘CA’ when address is displayed.

NOT A DELIVERED FIELD

Revision Log

 

Back to top of section: College & District Information Data | Back to top of page

College Address: Zip Code

Data Element:

college: postalcode

Description:

ZIP Code portion of college’s address

Type/Format, Length:

varchar, 10

Values:

Text string, 5 or 10 characters

Storage/Usage:

Required.

College-customizable in the CCCApply Administrator.

Stored in the College table.

Allows Null:

No

Default:

None

Display Conditions:

Displays on Application Confirmation page.

Notes:

NOT A DELIVERED FIELD.

Revision Log

 

Back to top of section: College & District Information Data | Back to top of page

College Website URL

Data Element:

college: url

Description:

URL for college’s website

Type/Format, Length:

varchar, 50

Values:

Text string

Storage/Usage:

Required.

College-customizable in the CCCApply Administrator.

Stored in the College table.

Allows Null:

No

Default:

None

Display Conditions:

Displays on Application Confirmation page.

Notes/Constraints

NOT A DELIVERED FIELD.

Revision Log

 

Back to top of section: College & District Information Data | Back to top of page

College Admissions Office Phone Number

Data Element:

college: phone_adm

Description:

Phone number for college’s Admission Office

Type/Format, Length:

varchar, 14

Values:

Text string

Storage/Usage:

Optional, but recommended.

College-customizable in the CCCApply Administrator.

Stored in the College table.

Allows Null:

No

Default:

None

Display Conditions:

Displays on Application Confirmation page.

Notes:

NOT A DELIVERED FIELD.

Revision Log

 

Back to top of section: College & District Information Data | Back to top of page

College Admissions Office Email Address

Data Element:

college: email_adm

Description:

Email address for college’s Admission office

Type/Format, Length:

varchar, 50

Values:

Text string

Storage/Usage:

Optional, but recommended.

College-customizable in the CCCApply Administrator.

Stored in the College table.

Allows Null:

No

Default:

None

Display Conditions:

Displays on Application Confirmation page.

Notes:

NOT A DELIVERED FIELD

Revision Log

 

Back to top of section: College & District Information Data | Back to top of page

College Redirect URL

Data Element:

college: redirect_url

Description:

The URL address that the college wants to redirect the student to upon application submission (Sign Out & Finish button).

Type/Format, Length:

Varchar

Values:

Valid web site URL.

Storage/Usage:

Sends student's web browser focus to a college-specific URL upon application submission to encourage a more seamless experience.

Allows Null:

Yes

Default:

Null

Notes:

Note: This field is not fully supported can only be implemented upon special request/permission by contacting the CCCApply Product Manager.

NOT A DELIVERED FIELD.

Revision Log

 

Back to top of section: College & District Information Data | Back to top of page

District ID

Data Element:

district_id

Description:

Identifies the CCC District based on the system’s table of COMIS district ID codes.

Type/Format, Length:

bpchar, 3

Values:

3-digit code

Storage/Usage:

System field. Required and non-configurable.

Allows Null:

No

Default:

None

Display Conditions:

Displays on the Application confirmation page.

Notes:

NOT A DELIVERED FIELD.

Revision Log

 

Back to top of section: College & District Information Data | Back to top of page

District Name

Data Element:

district_name

Description:

Name of the CCC district.

Type/Format, Length:

varchar, 50

Values:

Text string

Storage/Usage:

Required and customizable. District table.

Allows Null:

No

Default:

None

Display Conditions:

Displays on the Application confirmation page.

Notes:

Used to identify the college district by the CCC Help Desk for student support and account recovery.

Delivered field.

Revision Log

 

Back to top of section: College & District Information Data | Back to top of page

District Address: Street

Data Element:

district: streetaddress1, streetaddress2

Description:

Street address for the District office, in two lines.

Type/Format, Length: