CCCApply In-Progress Applications Report

The following guide is a sub-set of the CCCApply Report Center User Guide.

Purpose

The purpose for this “how-to” guide is to provide authorized CCC college staff using the CCCApply Application for Admission* with information and instructions for accessing the new CCCApply In-Progress Applications reports that have been added to the CCCApply Report Center (since June 2020).

About In-Progress Application Data

As an authorized CCC college Admission staff or other authorized college staff conducting outreach and providing support for new applicants, I need the ability to view, run reports, and export approved data for every CCCApply application that is started for my college in order to contact, provide support and/or conduct outreach to prospective students who have expressed interest in applying to my college .

Un-submitted applications are those that were started by an individual but never completed or submitted.

  • Only available for Standard / Noncredit Applications

  • Data is not real-time; data refresh occurs daily at 12:00 am

  • Have an account configured for access 

  • In-Progress application data is only available for the last 30 days from the current data of data are available

 

Getting to the Report

The image below shows the available “In-Progress Application” report templates available in the CCC Report Center.

 

Combine Required In-Progress Application Data Fields (Dataset)

  • Combine the following data fields and import full set into the Apply_In-Progress_Applications data domain or topic* on the Public root in the CCCApply Report Center.

Description

Data Field

California Community College ID

ccc_id

College ID

college_id

College Name

college_name

Term Code

term_code

Legal Name: First

firstname

Legal Name: Middle

middlename

Legal Name: Last

lastname

Legal Name: Suffix

suffix

Preferred First Name

preferred_firstname

Date of Birth

birthdate

Mailing Address: Street

streetaddress1 streetaddress2

Mailing Address: City

city

Mailing Address: State

state

Mailing Address: Non-USA Province

nonusprovince

Mailing Address: Postal Code

postalcode

Mailing Address: Country

country

Mailing Address: Same as Permanent

same_as_permanent

Mailing Address outside U.S.

non_us_address

No Mailing Address - Homeless

no_mailing_address_homeless

No Permanent Address Homeless

no_perm_address_homeless

Permanent Address: Street1 and Street2

perm_streetaddress1
perm_streetaddress2

Permanent Address: City

perm_city

Permanent Address: State

perm_state

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

perm_nonusprovince

Permanent Address: ZIP Code or Postal Code

perm_postalcode

Permanent Address: Country

perm_country

Main Phone Number

mainphone

Main Phone: Extension

mainphone_ext

Main Phone: Text Permission

mainphone_auth_text

Second Phone Number

secondphone

Second Phone: Extension

secondphone_ext

Second Phone: Text Permission

secondphone_auth_text

Main Phone: International

mainphoneintl

Second Phone: International

secondphoneintl

Email Address

email

Application ID

app_Id

Timestamp Create

tstmp_create

NOTE: To identify Noncredit Applications, filter the App_id field to contain the characters “NC” which will appear for each application started from the Noncredit URL.

 

Data Domain

  • Apply_In-Progress_Applications" domain ONLY for rows where the App_Ids “timestamp_create” + 24 hours > AND <timestamp_create> Plus 4 WEEKS>


Data Refresh Frequency

  • Refresh (over-write) the combined data set in the "Apply In-Progress Applications" domain EVERY 24 HOURS (or once every daily) at 12:00 AM.

  • The refresh over-write should (ONLY show rows where the App_ID is created/started between <current date/time minus 24 hours> AND <current date/time minus 4 WEEKS>

 

CCCApply Report Center

Running the In-Progress Application “Views”

 

Schedule a Recurring Report

  1. Save the selected Ad Hoc View as a Report

  2. Click View Repository, then access the folder where you saved the Report

  3. Right Click on the Report, then choose “Schedule…”

  4. Choose Create Schedule

  5. Define the Schedule

  6. Save the Schedule with a name and description

  7. Edit the saved Schedule

  8. Define the Output

  9. Define the Notifications

  10. Save the Schedule