ctcLink Reference Center9.2 Student FinancialsSF - CollectionsSF Pre-Collections ProcessesMass Assign/Release SF Service Indicators Based on Amount Past Due (B01)

Mass Assign/Release SF Service Indicators Based on Amount Past Due (B01)

Purpose: Use this document as a reference for how to mass assign Student Financials service indicators based on past due amount.

Audience: Student Financials Staff.

You must have at least one of these local college managed security roles:

  • ZD CC Service Indicators
  • ZZ CC Service Indicators

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

This process utilizes the Mass Assign/Mass Release Service Indicator pages and some flexible queries designed to assign any indicator the user has access to assign, based on the prompted criteria. This is to give the individual colleges a tool for controlling their application of policy in regards to what threshold assigns and releases a service indicator.  

It is recommended that you have separate run controls for your Mass Assign/Mass Release processes, so you can schedule them and they retain your entered values and do not conflict with each other.

Mass Assign

Navigation: Campus Community > Service Indicators > Person > Mass Assign

  1. The Mass Assign Run Control search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_ADM_FYR_5 (Admissions Letter, Summer, FYR Admit Type).
  3. The Mass Assign page displays.
  4. Within the Population Selection section:
    1. Select PS Query from the Selection Tool drop-down.
    2. Enter or search for the Query Name CTC_SF_MA_SRV_IND_AMT.
    3. Select the Edit Prompts link and the Query Prompts dialogue box displays.
      1. Search, enter, or select the following fields:
        1. Business Unit.
        2. Serv Ind Being Assigned: B01.
        3. Serv Ind Reason Being Assigned: NOPAY.
        4. Amount Past Due More Than: Dollar amount the account needs to be past due by the number of days to be selected.
        5. Days Past Due (at least): The number of days past due to set a threshold for selection. Both the Amount Past Due and Days Past due work in conjunction. Both things must be true for selection.
        6. Excl SI with impact NOCAN: Select the checkbox to exclude accounts with Service Indicators that have a service impact of NOCAN.
        7. Excl SI with impact NOAGE: Select the checkbox to exclude accounts with Service Indicators that have a service impact of NOAGE.
        8. Serv Ind End Term Not Less than: If using the exclusion checkboxes and the selected service indicators have an end term, they will not be excluded if the Term prompted for is less than the end term on the service indicator that the student may have with the impact. In other words, if a student has a service indicator with selected impact and it has an end term that has passed (example: 2235), and then the “current term” is entered (example 2237), that service indicator will not exclude them from being selected, because the end term has expired. Blank end terms will continue being considered for exclusion.
        9. *New Section*: Please refer to the Additional Resources section of this QRG for more information.
          1. Item Term (9999 for all terms)
          2. SetID
          3. Item Type Group: Restricts the types of charges evaluated.
      2. Select the OK button and the Mass Assign page displays.
  5. Select the Preview Selection Results hyperlink to ensure you are picking up students with your prompts.
  6. Within the Service Indicator Data section, search, enter, or select the:
    1. Institution.
    2. Service Indicator Code: B01.
    3. Reason: NOPAY.
    4. Use System Date: Selecting the checkbox makes the start date of the Service indicator whatever the system date is at the time of assignment, rather than the Start Date entered in the Effective Period box.
  7. Within the Effective Period section, search or enter the:
    1. Start Term: Optional Field - Limits the service indicators system impact in relation to the service impacts on the service indicator, to be effective on the Starting Term.
    2. End Term: Optional Field - Limits the service indicators system impact in relation to the service impacts on the service indicator, to be effective on the Ending Term.
    3. Start Date: Enter a date that you would want the Service indicator to start.
    4. End Date: Enter a date that you would want the Service indicator to end.
  8. Within the Assignment Details section, search or enter the:
    1. Department: Enter desired Department.
    2. Reference: Optional.
    3. Amount: This amount is not dynamic. It is suggested to leave at zero as not to cause confusion.
    4. Currency Code: USD.
  9. Optional: Within the Comments section, enter your comment.
  10. Select the Run button and the Process Scheduler Request page displays.
  11. Select the SCC_SI_ASSN checkbox.
  12. Optional: Select the Format type to view the report.
  13. Select the OK button. Please refer to the Process Schedule Request steps for further instructions.
  14. Process complete.
Mass assign page with the PS query populated in selection tool, Query name populated, service indicator code, and reason populated based on steps.

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

View Tutorial Via Panopto

View the external link to Mass Assign B01 Indicator. This link will open in a new tab/window.

Mass Release

Navigation: Campus Community > Service Indicators > Person > Mass Release

  1. The Mass Release Run Control search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_ADM_FYR_5 (Admissions Letter, Summer, FYR Admit Type).
  3. The Mass Release page displays.
  4. Within the Population Selection section:
    1. Select PS Query from the Selection Tool drop-down.
    2. Enter or search for the Query Name CTC_SF_MR_SRV_IND_AMT.
    3. Select the Edit Prompts link and the Query Prompts dialogue box displays.
      1. Search, enter, or select the following fields:
        1. Business Unit.
        2. Serv Ind Being Released: B01.
        3. Service Ind Reason Being Released: NOPAY.
        4. Amount Past Due Not More Than: Dollar amount (past due) the account needs to be at or under by the number of days to be selected.
        5. Days Past Due (at least): The number of days past due to set a threshold for selection. Both the Amount Past Due Not More Than and Days Past due work in conjunction. Both things must be true for selection.
        6. *New Section*: Please refer to the Additional Resources section of this QRG for more information.
          1. Item Term (9999 for all terms)
          2. SetID
          3. Item Type Group: Restricts the types of charges evaluated.
      2. Select the OK button. The Mass Release page displays.
  5. Select the Preview Selection Results hyperlink to ensure you are picking up students with your prompts.
  6. Within the Service Indicator Data section, search, enter, or select the:
    1. Institution.
    2. Service Indicator Code: B01.
    3. Reason: NOPAY.
  7. Within the Effective Period section, search or enter the:
    1. Start Term: Optional Field - Limits the service indicators system impact in relation to the service impacts on the service indicator, to be effective on the Starting Term.
    2. End Term: Optional Field - Limits the service indicators system impact in relation to the service impacts on the service indicator, to be effective on the Ending Term.
    3. Start Date: Enter a date that you would want the Service indicator to start.
    4. End Date: Enter a date that you would want the Service indicator to end.
  8. Select the Run button and the Process Scheduler Request page displays.
  9. Select the SCC_SI_RELS checkbox.
  10. Optional: Select the Format type to view the report.
  11. Select the OK button. Please refer to the Process Schedule Request steps for further instructions.
  12. Process complete.
Mass assign page with the PS query populated in selection tool, Query name populated, service indicator code, and reason populated based on steps.

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

View Tutorial Via Panopto

View the external link to Mass Release B01 Indicator. This link will open in a new tab/window.

Scenarios

Scenario One - Setting the Amount Past Due and Days to the Same Value for Both the Assign and Release

Mass Assign Query Mass Release Query
Amount Past Due: $50.00
Amount Past Due: $50.00
Days Past Due: 30
Days Past Due: 30

When the balance is $88 and 54 days past due, the Service Indicator would be assigned. It would be released if they paid $38 after 10 days later, and now they owe $50 and are 64 days past due. If they paid 37.99 the service indicator would not be released.

Scenario Two - Setting the Amount Past Due and Days Higher for Assign and Lower for Release

Mass Assign Query
Mass Release Query
Amount Past Due: $50.00
Amount Past Due: $3.00
Days Past Due: 30
Days Past Due: 1

When the balance is $88 and 54 days past due, the Service Indicator would be assigned. To get the Service Indicator released, the student would need to pay their account down to $3. If this happened after 5 days it would be $3 at 59 days past due. If they paid $85 that would be met, but if that person picked up a small charge (pencil rental .50 cents) and it was due two days ago, then the person would not be released because the .50 cents that is 2 days past due and the $3 that is 59 days past due would be calculated together, making $3.50 that is greater than 0 days past due.

This would be a strategy for stricter release and bringing accounts more current before lifting the holds.

When scheduling the Mass Assign/Mass Release, you can have the processes run daily at slightly different times. The populations should be different, so it would probably be fine to run at the same time. However it would be best to have them run sequentially.  

Additional Resources

The following video will link to an external video location that covers ComGen Limit.

Comgen Limit Talk

CTC_SF_MA_SRV_IND_AMT query with the additional section of Item Term, SETID, and Item Type Group section which limits the charges evaluated to those for the prompted term or 9999 for all. Also restricts to the type of charges evaluated. Example item type groups All vs Tuition vs ENRLCAN

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.