Versions Compared

Key

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

...

Table of Contents
minLevel1
maxLevel6
outlinefalse
stylenone
typelist
printabletrue

About verifications and CRM functionality

The federal government may require institutions are required to verify certain information about specific students applying for federal financial aid. These verifications may include items such as requests like confirming US Citizenship citizenship or providing gathering additional information about the a student's income. Typically, students must submit documentation that an institution must review prior to disbursing aid. The documents are required to be retained by the institution. 

Institutions may leverage the financial aid module in conjunction with CRM workflows/activities and the student document portal to alert and email students of their the need to collect and submit the documents for verification processing.

When using the Campus Café Packaging systemCafe packaging process, once an ISIR selected for Government Verification government verification is received, the packaging record is placed in a "Hold" hold status, where preventing the student cannot be from being processed until they are marked as being "verified " under on the Packaging Detail page. 

For Verification verification instructions and best practices, please refer to the Federal Student Aid Handbook.

Prerequisites

Campus Café CRM Templates for Verification and ISIR Comment Code Activity

...

  • Set up a connection to your email provider if sending email notifications.

  • Set up document portal if collecting information using Campus Cafe.

Required permissions

Module

Number

Description

Global

928, 957, 1238

Create or change a notification by building a workflow and activity tracking template

System Admin

1182

Create, change or delete a trigger that automatically launches the notification

Delivered email notifications based on ISIR comment codes

Campus Cafe has developed workflows, activity tracking templates and database triggers related to commonly required financial aid verification documents based on ISIR comment codes. These activities automatically email students or notify financial aid counselors of needed action; these can be installed a no cost to the institution (cost might required actions.

You may request these be installed, typically at no cost. However, a cost may be incurred if additional training is needed).

Activity Tracking Member

If the institution wishes to leverage the student document portal to track documents and for students to upload them, Campus Cafe recommends using training is required. For example, your institution needs training on how to modify a workflow to adjust the wording of its email.

Create notification

You can use a combination of workflows, activities and database triggers to automatically notify a student when they need to provide information to comply with the verification request. You can also configure Campus Cafe to allow students to upload this documentation to Campus Cafe where financial aid cousnelors can review it.

Activity tracking member

Activities in Campus Cafe are grouped by member, which you can think of as a broad category. You can provide access to activities by their member. For financial aid verifications, we recommend you use the F - Financial Aid member . Ensure the Webdefault (student) permission group has access to this member (directions) and do not use the member to also track internal notes that should not be visible to students.

...

Establish Workflow

  • Create a workflow (see workflow documentation)

  • To send an email to the student, set the workflow type as "Email Sent On Add" and complete the email subject line and body. (The mail-merge fields can be used in these as well.)

    image-20240115-173928.pngImage Removed
  • When using the Editor Format "Simple" you can copy and paste HTML code from a free online HTML editor or you can use a Saved Email Template from the builder within Campus Cafe.

    image-20240115-174057.pngImage Removedimage-20240115-174116.pngImage Removed
  • To allow the student to upload the required document in the document portal, under attachment, check "Tracked Person Can Add Attachment." (The student must have access to the activity tracking member associated with the workflow.)

  • To allow administrators to upload the required document in the document portal, under attachment, check "Admin Can Add Attachment." (The administrator must have access to the activity tracking member associated with the workflow.)

    image-20240115-174140.pngImage Removed
  • Under Category for the document to show up under the student's Financial Aid Document portal, it must be assigned to "M - Missing Information".

    image-20240115-174154.pngImage Removed
  • Under Options, check the "Required FA Doc" if this document is necessary for completing verification.

    image-20240115-174212.pngImage Removed
  • Set any other settings (see workflow documentation) that are applicable to the workflow and click save.

Establish Activity

Create an activity and associate it with the workflow created in the previous step (see activity directions).

Constraints can be used apply the activity only to students with certain verification codes or comment codes. Below is an example setup for a Dependent V1 worksheet Activity.

...

and limit the access to applicants, students and the financial aid team. Don’t use this member for activities that track internal notes otherwise students will be able to see them.

Provide students access to the F - Financial Aid member

  1. Go to Admin > Tracking Perms.

  2. Click New Tracking Group.

  3. In Group Id enter the permission group for students. By default, this is Webdefault.

  4. In Member select F - Financial Aid.

  5. Click Create.

  6. Repeat this process for other permission groups that need access, which may include your applicant and financial aid team groups.

Workflow and activity

The workflow and activity contains the content of your notification, lets students upload a document and administrators view it.

Activities automatically triggered and added by the financial aid triggers use the Tracking Year semester for the ISIR (e.g. ISIR 2021 will use '202100', ISIR 2022 will use '202200') and not the current active semester set in Financial Aid Control.

  1. Go to All Users > Activity Tracking Templates.

  2. In Member select F - Financial Aid.

  3. In Template Name enter a short description. For example, Dependent Verification for a notification that a student needs to verify their status as dependent for tax purposes.

  4. Click Add. A new page appears.

  5. Select Auto-create Workflow.

  6. In Description enter text about the notification. For example Dependent Verification.

  7. In the leftmost Constraint 1 box select FA_PACKAGING:VERIFICATION_TRACKING_FLAG".

  8. In the middle Constraint 1 middle box select " %LIKE% - Contains".

  9. In the rightmost Constraint 1 far right box enter the verification code, case sensitive. For example, for a student selected for a dependent verification, enter "V1"

  10. In the Constraint 2 select FA_PACKAGING.ISIR_DEPENDECY_STATUS

  11. In the Constraint 2 middle box select "= - EQUALS"

  12. In the Constraint 2 far right box enter "D" for dependent ("I" for Independent)

    image-20240115-174429.pngImage Removed

To prevent the student from receiving the verification notification more than once per semester

  1. In the V1.

  2. Optionally enter additional constraints to further narrow the communication.

  3. Click Save.

  4. At the bottom of the screen under Added Workflows click the paper and pencil icon. A new screen appears.

    image-20240814-001741.pngImage Added

  5. In Type select an option that aligns with your business processes. If you’re triggering an email, we recommend you select Email.

  6. In Category select Missing Information if you want the request to show in the student's Financial Aid Document portal. Otherwise select a category that aligns with your business processes.

  7. If you want students to be able to upload a document, select Tracked Person Can Add Attachment. We also recommend you select Tracked Person Can View Attachment.

  8. To allow administrative staff to view the document, select Admin Can View Attachment.

  9. In Mode select Email Sent on Add if you want the student to receive an email about the requirement.

  10. If sending an email, select Email Tracked Person and whether to email their preferred, non-preferred or both email addresses.

  11. If sending an email, complete the Email Default Subject Text and Email Default Body Text. Alternatively you can select a you can select a Saved Email Template from the builder within Campus Cafe.

  12. Under Options select Required FA Doc.

  13. Click Save.

Limit notification to once per semester

You can tell Campus Cafe to send a notification only once per semester, regardless of how many ISIRs you receive for the student or how many times you package them.

  1. Go to All Users > Activity Tracking Templates.

  2. In Member select F - Financial Aid and click Submit.

  3. Next to the notification to limit, click Edit.

  4. In Prohibit Work Flow Repeat select Prohibit Repeat For Semesterfor Semester.

    image-20240814-005126.pngImage Added

  5. Click Save.

    image-20240115-174503.pngImage Removed
  6. Activities automatically triggered and added by the financial aid triggers will use the Tracking Year semester for the ISIR (e.g. ISIR 2021 will use '202100', ISIR 2022 will use '202200') and not the current active semester set in the Financial Aid Control Page.

Example Activity with more than one comment code:

...

Database Triggers

Database trigger

Once you create an activity and workflow you can manually assign them to students. Alternatively, you can have Campus Cafe automatically assign them based on a database trigger.

For the full explanation of database triggers please see the Creating Database Triggers page.

For the V1 Dependent Worksheet Activity that is shown above to trigger and be applied to a student automatically when an ISIR comes in, the database trigger is set up in the following way:

...

Trigger Group: Set any group name that is desired

...

Description: Set any description that is desired

...

Table Name: FA_PACKAGING suggested

...

Field Name: PACKAGE_STATUS suggested (REVISION could possibly be used as well)

...

From Operator:  = EQUALS

...

From Value:  * which means that any value

...

To Operator:  = EQUALS

...

To Value:  * which means that any value (ISIR Packaging status) that is created by the ISIR will trigger the template.

...

  1. Go to Admin > Database Triggers.

  2. Click New Record.

  3. In Trigger Group name the trigger.

  4. In Description enter information about the trigger.

  5. In Table Name select the table that contains the information that will change and trigger the notification. For example, FA_PACKAGING.

  6. In Field Name select the specific data that when changes launches the notification. For example, PACKAGE_STATUS or REVISION.

  7. In From Operator select Equals.

  8. In From Value enter * which means that value can initially be anything.

  9. In To Operator select Equals.

  10. In To Value enter the new value that will trigger the notification. If you enter * Campus Cafe evaluates this trigger any time there is a change to this data, regardless of what it is. The constraints you set on the activity tracking template will limit the students who receive the notification.

  11. In Trigger On Event select Both. Setting to both will work as a "catch-all" to make sure that the verification activity gets added.

  12. In Template

...

  1. select the activity.

  2. Click Create.