CU Boulder Human Resources
Knowledgebase
Transactions (Payroll)
Transactions document the specific requests/transactions of the case. They are automatically created with Spreadsheet Uploads, or they can be manually added to a case.
Transactions from a Spreadsheet Upload
When an HRL/etc creates a case from the HRSC Support Portal and uploads a Transactions Spreadsheet, those Transactions will automatically populate in Salesforce.
Here’s an example of a Transaction Spreadsheet an HRL would have filled out:
And here’s how it shows up in the Case in Salesforce:
In the created Case in Salesforce, two areas will be auto-populate:
Case Contacts: Salesforce will try matching the employees from the Spreadsheet to employees in the system (based on EID). If there is a match, Salesforce will formally connect the employee’s Contact record to the Case. If there is no match, Salesforce will create a new Contact and new Case Contact.
Transactions: Salesforce will make individual Transactions for every row in the Spreadsheet. It will populate all the applicable fields from the Spreadsheet in the Transaction record.
Manually Creating a Transaction
You can manually add/create a Transaction in a Case as well. To do this, follow these steps:
Click the “New” Case Contacts Button
We will identify the “Impacted Employee” before adding the new Transaction
Search for Case Contact
If you want to only attach to the Contact, click the “Search All Contacts” tab. If you want to pull in employment information to the Case Contact, click the “Search Employment Records” tab.
Search by name, EID, email, etc.
Click the “Next” button
Identify the Case Contact Type
Since you’re adding a Transaction, you’ll most likely want to choose “Impacted Employee”
Click on the “New Transaction” Button
Determine Transaction Type/Sub-Type/Sub-Sub-Type
Choose the appropriate Transaction categorization
Click the “Next” button
Add Transaction Details
Conditional fields will display based on the Case Type. Populate as necessary.
Click the “Save” button
Done. View Transaction on Case Page
Click the Case Number link
View your new manually-added Transaction
Editing Transactions
There are two ways to edit Transactions--by individual Transaction record, or by a spreadsheet view.
Editing Individual Transaction
You can edit an individual Transaction by clicking on the Transaction record.
Editing Transactions in Spreadsheet View
You can view all the Transactions of a case in a spreadsheet-style view by expanding the “Transactions” header:
Once opened in this spreadsheet-style view, there are several things you can do to help manage the Transactions:
View All: This link exists at the bottom of the spreadsheet list and opens the list of Transactions in its own page.
Edit: Allows you to edit the “cells” of the spreadsheet.
Sort Columns: Allows you sort the column alphabetically or numerically.
Expand/Collapse Columns: Allows you to expand or contract the column width to your preference.
Freeze: Allows you to freeze columns.
Update: Allows you to mass-update multiple Transactions at the same time.
You must select the appropriate Transactions first (far left side of page).
Click the “Update” button
Identify what data-point you want to mass update
Identify the value you want to populate for each data-point for each Transaction selected
Explorer Button: This is the three-horizontal-line button
Allows you to do advance searching/filtering/sorting/grouping
Allows you to reorder the columns