9.2 Mass Select Transactions - Group Post

Purpose: Use this document as a resource for how to select transactions in mass using ctcLink.

Audience: Student Financials Staff.

Mass Select Transactions - Group Post

Mass Select Transaction

Navigation: NavBar > Navigator > Student Financials > Charges and Payments > Group Processing > Mass Select Transactions

  1. The Mass Select Transactions run control search page displays.
  2. Create or choose a Run Control.
  3. Select the Search or Add button.
Mass Select Transactions page Find an Existing Value tab
  1. The Mass Select Transactions page displays.
  2. Select the most appropriate Group Type and Origin ID for the type of transaction that you are posting.
  3. Use a Selection Tool drop-down list to identify the ID’s to be charged. The Selection Tool options are:
    1. External File
    2. Population Selection
    3. Equation Engine
Mass Select Transactions Parameters, Pop Selection and Line Details highlighted
  1. Select a file mapping that works with the file you are uploading. The file may need to be changed, or a request submitted to have file mapping created for the type of file you will be uploading. Example: When you select External File and upload a file, you will have the requirement of selecting a file mapping.
Population Selection File Mapping Create File Mapping link visable

File Mapping

Although you may not have access to create/edit a file mapping, it is important to understand how the mapping works so your file can correspond.

Population Selection File Mapping Edit File Mapping link visable

Looking at the file mapping in this example, you can see that EMPLID is a required value to know who to assign the transactions to. In this example ITEM_AMT and ITEM_TYPE are also being provided.

Population Selection File Map

Notice in the sample .csv file below, how each row represents the Field Number displayed from the image of the Population Selection File Map page above.

Mass Assign Charge ctct test Excell exampl

Comma separated value uploads are the most common upload types. However, notice in the file mapping Field Delimiter drop-down menu, there are options for accepting files in various formats such as heading/without heading, tabs, semi-colon and pipe.

Population Selection File Map Field Delimiter drop down menu

When using PSQuery or Equation Engine, a file mapping is not required, but similar file mapping type variables are needed. So naturally EMPLID is a required field in your returned results.

  1. Line Details Section:  
    1. Complete only the remaining fields in the Line Details section that will apply to all of the items within the spreadsheet. The fields within the Line Details section will overwrite the information contained in the spreadsheet being uploaded if populated.
      1. Be sure to not populate fields within the Line Details section that will be uploaded from the spreadsheet.
      2. For PSQuery this would be modifying the Unique Field Name to match the field in question. Example: ITEM_AMT for field Item Amount
  1. Once the Mass Select Transactions page is complete, select the Run button.
MAss Select Transactions Line Details section highlighted
  1. The Process Scheduler Request page displays.
  2. Select the OK button.
Process Scheduler Request page - OK button highlighted
  1. This will result in a new entry on the Create Group Data Entry Page.
Create Group Data Entries

Navigation:  NavBar > Navigator > Student Financials > Charges and Payments > Group Processing > Create Group Data Entries

  1. The Create Group Data Entries page displays.
  2. Enter Search Criteria.
  3. Select the Search button.
  4. The Search Results display.
  5. Select the applicable result.
Group Data Entry - Posting Status higlighted
  1. The Group Entry tab displays.
  2. This file can be drilled into and then Saved, so the Edit Status changes to "Edited" and the Posting Action is "Available" for posting.
Group Entry tab - Effective Status section highlighed
  1. After this process is done, it will change the Posting Status on the surface Group Data Entry search page from "Not Posted" to "NOT Comp.".
Group Data Entry Posting Status
Group Post Transaction

Navigation:  NavBar >Navigator > Student Financials > Charges and Payments >  Group Processing > Post Transactions

  1. The Post Transactions run control search page displays.
  2. Create or choose a Run Control.
  3. Select the Search or Add button.
post transactions search page
  1. The Post Transactions page displays.
  2. Enter the Starting Group ID, or Group ID Range if more than one, from the group that you edited and saved.
  3. Select the Run button.
Post Transactions page - Starting and Ending Group ID highlighted
  1. The Process Scheduler Request page displays.
  2. Under the Process List section, select the Group Posting Process check box.
  3. Select the OK button.
Process Scheduler Requesat page - Group Posting Process check box highlighted
  1. Process complete.

0 Comments

Add your comment

E-Mail me when someone replies to this comment

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