Smartsheet Process Log
CreatedSubmitterUnit that owns processEnterprise or Unit-Level ProcessProcess NameEdit LinkSmartsheet Process StatusNeeds Retrofitting for Licensing Model ChangeNeeds Retrofitting for Workday ImplementationDescription/Background
 Collaboration powered by Smartsheet   |   Report Abuse
105/12/23 11:51 PMShawn HillAccountingEnterprise
GASB 42 - Impairments
ActiveTBDTBDCheck for GASB 42 compliance on capital assets with net book values of greater than: $100k for equipment and $250k for all other capital assets.
205/12/23 11:51 PMShawn HillAccountingEnterprise
GASB 51 - Intangible Assets
DraftTBDTBDSurvey to determine the existence of certain intangible assets at state organizations.
305/12/23 11:51 PMShawn HillAccountingEnterprise
GASB 87 - Leases (UGA as lessee)
ActiveTBDTBDThe GASB 87 questionnaire is required to be completed by each UGA department that intends to lease a non-university owned asset. The questionnaire is designed to gather information about new lease activities in order to determine if UGA should record a lease liability.
405/12/23 11:51 PMShawn HillAccountingEnterprise
GASB 87 - Leases (UGA as lessor)
ActiveTBDTBDThe GASB 87 questionnaire is required to be completed by each UGA department that intends to lease a non-university owned asset. The questionnaire is designed to gather information about new lease activities in order to determine if UGA should record a lease liability.
505/12/23 11:51 PMShawn HillAccountingEnterprise
GASB 96 - SBITAs
ActiveTBDTBDQuestionnaire designed to gather information about new SBITA activities in order to determine if UGA should record a Subscription liability. The Business Services and Accounting team will review each questionnaire for its completeness and determine if the SBITA meets the standards of GASB 96.
605/12/23 11:51 PMShawn HillAccountingEnterprise
GASB 96 - Library Questionnaire
DraftTBDTBDQuestionnaire designed to gather information about new SBITA activities in order to determine if UGA should record a Subscription liability. The Business Services and Accounting team will review each questionnaire for its completeness and determine if the SBITA meets the standards of GASB 96.
705/12/23 11:51 PMShawn HillAccountingEnterprise
Student Technology Fee (STF) Allocation
In TestingTBDTBDTracks STF carry forward requests. Units will have the option to carry-forward up to 5% of their STF allocation by submitting a written plan to the Committee for Applied Instructional Technology (CAIT) for approval. If a unit wishes to carry-forward funds in an amount that exceeds 5% of their allocation, the unit must submit its plan, along with the appropriate justification, through the CAIT to the Provost and Vice President for Finance & Administration for approval.
805/12/23 11:51 PMShawn HillAccountingEnterprise
Tax Exempt Bonds
DraftTBDTBDQuestionnaire to track tax exempt bonds. Under federal tax law applicable to tax-exempt bonds, only a small portion of facilities or equipment financed or refinanced with the proceeds of the bonds may be used, leased, managed or operated by a non-qualified user. This questionnaire is intended to help with the collection and review of information in order to determine compliance with the private business use limits. The private business use limits apply for the entire term of the bonds (including any refunding bonds) and violation of private business use limits could result in the loss of the tax-exempt status of the bonds.
905/12/23 11:51 PMShawn HillAccountingEnterprise
Unrelated Business Income (UBIT)
ActiveTBDTBDQuestionnaire to track UBIT. Each year the University must perform an analysis to determine the amount of unrelated business income (UBI) to be reported to the Internal Revenue Service (IRS) and Georgia Department of Revenue. The University is not exempt from income tax imposed on activities which are substantially unrelated to the purpose and mission of the University, even though these activities may generate income to support the University’s purpose and mission related activities.
1005/12/23 11:51 PMShawn HillAccountingEnterprise
Request for deferred income
DraftTBDTBDUnits submit requests for deferred income for accounting review/approval.
1105/12/23 11:51 PMShawn HillAccountingEnterprise
DSS Questionnaire
In TestingTBDTBDDepts request to conduct departmental sales and services through Service Center activities. Workflow to collect requisite approvals.
1201/17/24 11:26 AMShawn HillAccountingEnterprise
Accrued Payroll
ActiveTBDTBDDynamic view for units to review accrued payroll, distribution %, amount, and chartstring.
1301/17/24 1:58 PMShawn HillAccountingEnterprise
Space survey for IDC rates
DraftTBDTBDIntake and tracking process for IDC rate space survey
1401/17/24 1:45 PMShawn HillAccountingOffice of ResearchEnterprise
UGARF Check Requests
ActiveTBDTBDIntake form and workflow approvals on UGARF check requests. Generates a PDF that can be loaded into the Financial Edge system.
1505/12/23 11:51 PMShawn HillAccounts ReceivableEnterprise
Aging A/R detail
In TestingTBDTBDA/R team copies query result into master list and Smartsheet automates the process of aggregating the data and distributing aging A/R reports to units.
1605/12/23 11:51 PMShawn HillAP/TravelEnterprise
Food Purchase Justification
ActiveTBDTBDThis form walks the submitter through the process and documentation requirements for various expense types, and emails the submitter a recap that can be attached as documentation when the expense report is submitted in the Financial Management System as a payment request or expense report.
1705/12/23 11:51 PMShawn HillAP/TravelEnterprise
Non-Employee Payment form
In TestingTBDTBDForm to request non-employee payment and route to AP for approval.
1801/17/24 11:33 AMShawn HillAP/TravelEnterprise
ACH Modifications
DraftTBDTBDForm and workflow for Accounts Payable to verify ACH modifications.
1901/17/24 11:35 AMShawn HillAP/TravelEnterprise
Electronic Withdrawal of Funds - DHHS Payees
ActiveTBDTBDUnits request electronic payment withdrawal and routes to CBO and then AP for reviews and approval.
2001/17/24 11:36 AMShawn HillAP/TravelEnterprise
Human Subjects non monetary compensation > $100
ActiveTBDTBDTracks non-monetary compensation > $100 for human subjects. Captures DOB of human subjects.
2101/17/24 11:39 AMShawn HillAP/TravelEnterprise
AP - Tabbed Checks
ActiveTBDTBDIntake form and AP tracking list for tabbed checks.
2201/17/24 11:40 AMShawn HillAP/TravelEnterprise
Taxable Travel Expense
ActiveTBDTBDAP enters taxable travel reimbursements (including allowable amounts) based on query result. Routes to expense manager for approval. Routes to Payroll for approval/payment.
2305/31/24 11:25 PMShawn HillAP/TravelEnterprise
Travel training completion
ActiveTBDTBDTracks comprehensive travel course completion for expense managers across all units. Learning and Development have noted that training data are considered sensitive, though this type of training may be less sensitive than others.
2401/17/24 11:33 AMShawn HillAP/TravelBursar & Treasury ServicesEnterprise
Cancel or Escheat Checks
ActiveTBDTBDStudent Accounts adds entries and AP reviews, updates check status, enters voucher number, and marks complete. Replaces manual tracking. Contains student 81x number.
2501/17/24 12:06 PMShawn HillAP/TravelBursar & Treasury ServicesEnterprise
Wire Authorizations
ActiveTBDTBDTracking list and approval process for wire authorization collaboration between AP and BTS.
2605/12/23 11:51 PMShawn HillAsset ManagementEnterprise
Surplus Equipment Transfer
In TestingTBDTBDForm to request that items be transferred to the surplus warehouse.
2701/17/24 12:09 PMShawn HillAthletic AssociationUnit Level
Football Game Credentials
ActiveTBDTBDAllows non-UGA and UGA organizations to request football gameday credentials and allows Athletics to keep a single master tracking list that they can view from their phones in the stadium.
2801/17/24 12:10 PMShawn HillAthletic AssociationUnit Level
Athletics per diem card requests
ActiveTBDTBDAllows members of Athletics to request per diem cards. Contains 81x number.
2905/12/23 11:51 PMShawn HillBudget OfficeEnterprise
Carryforward reporting
ActiveTBDTBDUnits input quarterly carryforward balance updates, aggregates data for BOR reporting.
3001/17/24 12:47 PMShawn HillBudget OfficeEnterprise
Strategic reserves reporting
ActiveTBDTBDAnnual process for units to report on and justify strategic reserves. Automatically balances entries against outstanding carryforward balances.
3105/12/23 11:51 PMShawn HillBudget OfficeBursar & Treasury ServicesGraduate SchoolSponsored Projects AdministrationEnterprise
Graduate Tuition Return Incentive Program
ActiveTBDTBDMulti-unit workflow to track Graduate Tuition Return incentive program. Collects 81x number.
3201/17/24 2:40 PMShawn HillBudget OfficeBursar & Treasury ServicesRegistrarEnterprise
eRates
ActiveTBDTBDRequest form and approval workflow for UGA eRates. Collects approvals from 10+ units and sends notifications to ensure appropriate BOR coordination and Banner coding. Monthly reminders to show eRate requests in progress.
3305/12/23 11:51 PMShawn HillBursar & Treasury ServicesEnterprise
Petty Cash Application
ActiveTBDTBDUnits request petty cash accounts and BTS team reviews/approves.
3401/17/24 12:48 PMShawn HillBursar & Treasury ServicesEnterprise
Charge to Account Form
DraftTBDTBDAllows Student Accounts to process charges to accounts. Contains 81x numbers and student data.
3503/05/24 4:23 PMJoshua.Haynes@uga.eduBursar & Treasury Services
Scholarship Submission
DraftTBDTBDNote this is a Terry College of Business Process, I selected the Bursar's office as they are the final step in the Scholarship process.

Currently as we're preparing to manage our scholarship submission process we have the issue of being able to collect the needed information for entry. As we bring a scholarship coordinator online we are attempting to streamline the process by having the review and approvals integrated into the submission process. The process will only be available to those that utilize the current information, 99% of the data is non troublesome. The only item we are not able to get around is the 811/810 number. As is the form would be used by internal staff to submit the recipient information for scholarship entry and then be verified by those in the approval path. Currently we are using OneDrive, however that has brought a set of challenges and not everyone is consistent in filling in information. This form would require the information be completed to submit it. At present I have added a safeguard of getting the whole 811/810 number by literally blanking the field after the email notification is sent.

At present we've been testing the form to collect the last 6 of the number, however if we could use the 811/810 number we would be able to move toward our ultimate goal of a portal/page for students to submit their information and be matched using the built in automation to generate the eligible scholarships. This would increase our ability to support our students with our donors dollars. At present we have approximately 200 or more scholarships, so we're trying to identify a better way to manage this while having the maximum reach.
3601/17/24 12:51 PMShawn HillFaculty AffairsEnterprise
Faculty Performance Reviews
ActiveTBDTBDCentral location to track faculty performance review scores and effort percentages. Used for upload into OneUSG Connect along with unit reviews. Designed to make the intake process easier for Dept. Heads and other faculty supervisors.
3701/17/24 12:52 PMShawn HillFaculty AffairsEnterprise
Faculty Offer Letters
DraftTBDTBDAllows faculty to electronically sign and track offer letters.
3801/15/26 2:45 PMCameron TroedssonFaculty AffairsHuman ResourcesUniversity Human ResourcesUnit Level
UHR - Direct Appointment Tracker
ActiveRetrofit CompleteTBDRetrofitting current 'Start Date Changes' sheet into a new dynamic view for UHR teams to utilize once new SmartSheet licensing model changes go live.

Dynamic view completed, UHR specific dynamic view access column added to data sheet.
3901/17/24 2:09 PMShawn HillFinance - Programs & Change Mgmt.Enterprise
Targeted Email Alerts
ActiveTBDTBDAllows financial and HR practitioners to automatically sign up for targeted emails, including automated notifications on known issues and enhancements.
4001/17/24 2:44 PMShawn HillFinance - Programs & Change Mgmt.Enterprise
FACTS program
ActiveTBDTBDAutomates the scheduling and reminder process for the FACTS program.
4101/17/24 2:46 PMShawn HillFinance - Programs & Change Mgmt.Enterprise
Knowledge Base Ticketing System
ActiveTBDTBDCreated a homegrown ticketing system for knowledge base maintenance with automated notifications and dashboard.
4201/17/24 2:48 PMShawn HillFinance - Programs & Change Mgmt.Human ResourcesEnterprise
Master CBO list
ActiveTBDTBDUsed for workflow routing on other Smartsheet processes
4301/17/24 2:48 PMShawn HillFinance - Programs & Change Mgmt.Human ResourcesEnterprise
Master HR Liaisons list
ActiveTBDTBDUsed for workflow routing on other Smartsheet processes
4401/17/24 2:49 PMShawn HillFinance - Programs & Change Mgmt.Human ResourcesEnterprise
Master Faculty Affairs Liaisons list
ActiveTBDTBDUsed for workflow routing on other Smartsheet processes
4501/17/24 2:51 PMShawn HillFinance - Programs & Change Mgmt.Human ResourcesEnterprise
Master Dean/VP list
ActiveTBDTBDUsed for workflow routing on other Smartsheet processes
4601/17/24 3:08 PMShawn HillFinance - Programs & Change Mgmt.Human ResourcesEnterprise
Smartsheet enterprise license management
ActiveTBDTBDRequest form, approval workflow, and notifications for Smartsheet license management on our enterprise account
4701/17/24 12:55 PMShawn HillGraduate SchoolEnterprise
Award Letter Wizard
DraftTBDTBDAuto generates award letters for graduate students.
4801/17/24 12:57 PMShawn HillGraduate SchoolEnterprise
Deadlines and Key Dates
ActiveTBDTBDAuto generates notifications (Teams and email) to Grad Coordinator Assistants on upcoming key dates and deadlines.
4901/17/24 12:59 PMShawn HillGraduate SchoolEnterprise
Grad Assistant Annual Rates
ActiveTBDTBDCreates automated process for tracking dept, grad school, and provost approvals of grad assistant annual rates.
5001/17/24 1:01 PMShawn HillGraduate SchoolEnterprise
GradStatus Access Request Form
ActiveTBDTBDRequest form and workflow approvals to request access to the GradStatus system. Contains 81x number.
5101/17/24 1:02 PMShawn HillGraduate SchoolUnit Level
Graduate School Budget Dashboard
ActiveTBDTBDCreates budget dashboard for Grad Dean. including remaining balances, revenue targets, payroll information, historical spend rates, etc.
5201/17/24 1:03 PMShawn HillGraduate SchoolEnterprise
Grad Award/Fellowship Tracker
ActiveTBDTBDTracks distribution of award/fellowship funds and automates process of collecting chartstrings from unit financial contacts.
5305/31/24 11:23 PMShawn HillGraduate SchoolHuman ResourcesEnterprise
Graduate Assistant Increases
ActiveTBDTBDAnnual process to capture graduate assistant increases (comp rate, FTE, and job code changes) to feed an automated update process in UGAJobs and OneUSG Connect
5401/17/24 1:51 PMShawn HillHuman ResourcesEnterprise
Grad Assistant Bulk Updates
ActiveTBDTBDAllows units to request and track bulk updates to GA Comp Rate, Standard Hours, and/or Job Code
5501/17/24 1:53 PMShawn HillHuman ResourcesEnterprise
SWB/RWB Requests
ActiveTBDTBDAllows units to request and track short work break and returns from work break
5601/17/24 2:01 PMShawn HillHuman ResourcesEnterprise
Women's Staff Leadership Institute Applications
ActiveTBDTBDIntake and notification process for Women's Staff Leadership Institute
5701/17/24 2:02 PMShawn HillHuman ResourcesEnterprise
New-hire onboarding surveys
ActiveTBDTBDCollects feedback from UGA new hires in month 2 of employment with the goal of continuously improving the onboarding process.
5806/07/24 3:30 PMshawnh@uga.eduHuman ResourcesInsurance & Claims ManagementEnterprise
Volunteer Agreements
In TestingRetrofit CompleteTBDReplaces a PDF-based process for securing signatures for volunteer approvals, routing these to insurances and claims management, and notifying UHR of these new volunteers.
5901/09/26 11:55 AMCameron TroedssonHuman ResourcesUniversity Human ResourcesUnit Level
UHR - New Employee & I-9 Tracking
ActiveRetrofit CompleteTBDRetrofitting current 'New Employee & I-9 Tracking' sheet into a new dynamic view for UHR Inquiry & Transaction teams to utilize once new SmartSheet licensing model changes go live.

Dynamic view completed, UHR specific dynamic view access column added to data sheet.
6001/12/26 1:20 PMCameron TroedssonHuman ResourcesUniversity Human ResourcesUnit Level
UHR - Retirement Intent Tracking
ActiveRetrofit CompleteTBDRetrofitting current 'Retirement Intent Tracking' sheet into a new dynamic view for UHR Benefits teams to utilize once new SmartSheet licensing model changes go live.

Dynamic view completed, UHR specific dynamic view access column added to data sheet.
6101/12/26 1:20 PMCameron TroedssonHuman ResourcesUniversity Human ResourcesUnit Level
UHR- Front Desk Sign In
ActiveRetrofit CompleteTBDRetrofitting current 'Front Desk Sign In' sheet into a new dynamic view for UHR Inquiry & Transaction teams to utilize once new SmartSheet licensing model changes go live.

Dynamic view completed, UHR specific dynamic view access column added to data sheet.
6201/12/26 1:20 PMCameron TroedssonHuman ResourcesUniversity Human ResourcesUnit Level
UHR - Departmental Parking Pass Tracker
DraftRetrofit NeededTBDRetrofitting current 'New Employee & I-9 Tracking' sheet into a new dynamic view for UHR Admin teams to utilize once new SmartSheet licensing model changes go live.

After discussion, determined that we will be moving data entry to a form and will make the sheet itself view only for requestors. Form completed, further discussion on implementation needed
6301/13/26 9:40 AMCameron TroedssonHuman ResourcesUniversity Human ResourcesUnit Level
UHR - Out of State Employment Request Form
ActiveRetrofit CompleteTBDRetrofitting current 'Out-of-State Employment' sheet into a new dynamic view for UHR Inquiry & Transaction teams to utilize once new SmartSheet licensing model changes go live.

Dynamic view completed, UHR specific dynamic view access column added to data sheet.
6401/13/26 10:03 AMCameron TroedssonHuman ResourcesUniversity Human ResourcesUnit Level
UHR - Onboarding and Orientation
ActiveRetrofit CompleteTBDRetrofitting current 'Onboarding and Orientation' sheet into a new dynamic view for UHR Inquiry & Transaction teams to utilize once new SmartSheet licensing model changes go live.

Dynamic view completed, UHR specific dynamic view access column added to data sheet.
6501/13/26 10:09 AMCameron TroedssonHuman ResourcesUniversity Human ResourcesUnit Level
UHR - Start Date Changes
ActiveRetrofit CompleteTBDRetrofitting current 'Start Date Changes' sheet into a new dynamic view for UHR Inquiry & Transaction teams to utilize once new SmartSheet licensing model changes go live.

Dynamic view completed, UHR specific dynamic view access column added to data sheet.
6601/15/26 11:40 AMCameron TroedssonHuman ResourcesUniversity Human ResourcesUnit Level
UHR - Background Investigation Tracking
ActiveRetrofit CompleteTBDRetrofitting current 'Background Tracking sheet into a new dynamic view for UHR Inquiry & Transaction teams to utilize once new SmartSheet licensing model changes go live.

Dynamic view completed, UHR specific dynamic view access column added to data sheet.
6702/18/26 4:16 PMCameron TroedssonHuman ResourcesUniversity Human ResourcesUnit Level
UHR - Independent Contractor
ActiveRetrofit CompleteTBDRetrofitting current 'Independent Contractor' sheet into a new dynamic view for UHR teams to utilize once new SmartSheet licensing model changes go live.

Dynamic view completed, UHR specific dynamic view access column added to data sheet.
6802/18/26 4:16 PMCameron TroedssonHuman ResourcesUniversity Human ResourcesUnit Level
UHR - Retire Rehire
DraftRetrofit NeededTBDRetrofitting current 'Retire Rehire' sheet into a new dynamic view for UHR teams to utilize once new SmartSheet licensing model changes go live.
6901/17/24 1:08 PMShawn HillInsurance & Claims ManagementEnterprise
Comprehensive Accident Reporting and Evaluation System (CARES)
DraftTBDTBDSystem to report accidents, incidents, and near misses for tracking and analysis. Goal is to allow UGA to build process and not have to purchase a 7-figure system for this.
7001/17/24 1:08 PMShawn HillInsurance & Claims ManagementEnterprise
Insurance Premium Chartstrings
DraftTBDTBDAutomates the process for collecting chartstrings for insurance on physical assets.
7101/17/24 1:11 PMShawn HillInsurance & Claims ManagementEnterprise
Motor Vehicle Use - Driver Acknowledgment Form
ActiveTBDTBDElectronic intake form to capture driver data. Eliminates thousands of manual entries each year. Includes data on driving records.
7201/17/24 1:28 PMShawn HillInsurance & Claims ManagementEnterprise
Vehicle Renewals
In TestingTBDTBDAutomates process for validation, including insurance chartstrings, for roughly 2,000 UGA vehicles
7303/31/25 8:52 AMshembree@uga.eduInsurance & Claims ManagementEnterprise
Insurance Claims Reporting
ActiveRetrofit CompleteTBDThis process replaced an older Adobe Coldfusion form, please allows us to track insurance claims within our office including worker's compensation.
7402/10/26 10:11 AMSavannah HembreeInsurance & Claims ManagementEnterprise
Consent for Motor Vehicle Records Investigation
ActiveRetrofit CompleteTBDElectronic intake form to capture consent for motor vehicle record investigations (driver's history). Eliminates hundreds of manual entries each year from paper forms. Includes data on drivers. Some date is redacted once driver is deemed eligible/not eligible. The rest is redacted at one year when the MVR is expired.

Retrofitted to provide UHR BI team and UGA Dispatch dynamic view access to update results.
7502/10/26 10:23 AMSavannah HembreeInsurance & Claims ManagementEnterprise
Insurance Premium Chartstrings
ActiveRetrofit NeededTBDAutomates the process for collecting chartstrings for insurance on transient assets.
7602/10/26 10:23 AMSavannah HembreeInsurance & Claims ManagementRisk & ResiliencyEnterprise
List of piers, docks, boardwalks, and bridges
ActiveRetrofit CompleteTBDList of all docks, boardwalks, piers, and bridges over waterways that are under a UGA department's control. Allows Risk & Resiliency to verify yearly inspections.
7701/17/24 1:58 PMShawn HillMail & Receiving ServicesEnterprise
Holiday mail pickup requests
ActiveTBDTBDIntake, notification, and tracking process for holiday mail pickups
7801/17/24 1:05 PMShawn HillMorehead Honors CollegeUnit Level
Alumni Reader Onboarding
ActiveTBDTBDAutomates several steps in the process for applying, reviewing, selecting, and onboarding alumni readers for the Honors College. Contains 81x numbers.
7901/17/24 2:07 PMShawn HillOffice of Accreditation & Institutional EffectivenessEnterprise
Centers & Institutes List
ActiveTBDTBDCreates a tracking list of active and inactive centers and institutes. Allows UGA to publicly post this on a webpage through an embedded dashboard. Allows Grants Portal to read a current list of active centers and institutes via the API, which is used for reporting and proposal submission.
8002/10/26 10:23 AMSavannah HembreeOffice of Emergency PreparednessUnit Level
Certificates for training classes
ActiveRetrofit CompleteTBDForm to capture names/emails of OEP training classes in order to autogenerate certificates
8102/10/26 10:29 AMSavannah HembreeOffice of Emergency PreparednessUnit Level
AED Chartstrings
ActiveRetrofit NeededTBDList of chartstrings for the annual Lifeready AED fee for departments that maintain an AED at UGA.
8202/10/26 10:29 AMSavannah HembreeOffice of Emergency PreparednessUnit Level
UGA Alert Survey
ActiveRetrofit Not NeededTBDSurvey for the twice yearly UGA Alert tests.
8301/17/24 1:30 PMShawn HillOffice of Institutional ResearchEnterprise
Master Institutional Hierarchy (MIH)
In TestingTBDTBDMapping, requests, approvals for MIH
8401/17/24 1:32 PMShawn HillOffice of ResearchEnterprise
New Faculty Hires
ActiveTBDTBDAutomatically alerts various research units of upcoming faculty hires (at offer letter stage) so that proactive steps can be taken to ensure that they are ready to conduct research upon arrival.
8501/17/24 1:36 PMShawn HillOffice of ResearchEnterprise
Core Facilities Equipment Requests
ActiveTBDTBDCreates a tracking sheet with workflow for core facilities equipment requests.
8601/17/24 1:36 PMShawn HillOffice of ResearchEnterprise
Research Facilities Space Request
ActiveTBDTBDCreates a tracking sheet with workflow for research space requests. .
8701/17/24 1:37 PMShawn HillOffice of ResearchEnterprise
FASTER research advisory team progress
ActiveTBDTBDTracks ideas and progress on these ideas to improve research processes
8801/17/24 1:39 PMShawn HillOffice of ResearchEnterprise
IDC return unit guidelines
ActiveTBDTBDTracks units IDC distribution split percentages to investigator, dept, college.
8901/17/24 1:42 PMShawn HillOffice of ResearchEnterprise
Minor's Research Access Form
ActiveTBDTBDIntake form and approval workflow for minors who will be participating in research. College minor's address, school, phone #, email, and parent/guardian information. Collect approvals from the minor, the parent/guardian, and the PI along with data on any potential risks/hazards to which minor may be exposed.
9001/17/24 1:47 PMShawn HillOffice of ResearchEnterprise
VPR request for budget transfer
ActiveTBDTBDTracking sheet for VPR budget transfer requests
9106/07/24 3:50 PMShawn HillOffice of ResearchEnterprise
Radiation Safety - Monthly Radiological Forms
ActiveTBDTBDMonthly process prompts PIs using radiation to document their use details
9205/12/23 11:51 PMShawn HillPayrollEnterprise
Overpayment Form
In TestingTBDTBDForm and decision tree to request overpayments. Creates SNOW ticket. Creates tracking list for Payroll.
9305/12/23 11:51 PMShawn HillPayrollEnterprise
Paychecks Outstanding
ActiveTBDTBDAutomates process of following up with individuals who have outstanding, undeposited paychecks.
9407/09/24 1:55 PMshawnh@uga.eduPayrollEnterprise
Direct Deposit Exemption Requests
ActiveTBDTBDStreamlines the process for requesting direct deposit exemptions and eliminates a PDF-based process.
9505/12/23 11:51 PMShawn HillProcurementEnterprise
Contract Negotiation Tracker
ActiveTBDTBDThis process replaces email and individual Excel workbooks/sheets. This tracks the contract review process within Procurement and among the different Procurement teams.
9605/12/23 11:51 PMcversola@uga.eduProcurementEnterprise
Informal Bid Tracker
ActiveTBDTBDAllow Procurement to track internal informal bid processing.
9705/12/23 11:51 PMcversola@uga.eduProcurementEnterprise
PCard Monthly Reconciliation Process
ActiveTBDTBDTracks requests to cardholders and submissions of PCard monthly reconciliation packages.
9805/12/23 11:51 PMcversola@uga.eduProcurementEnterprise
PCard Yearly Spend Analysis
ActiveTBDTBDTracks requests to Approvers that card spend is accurate and cards are still needed.
9901/17/24 2:32 PMcversola@uga.eduProcurementEnterprise
Aging PO Report
ActiveTBDTBDThis process replaces individually-emailed reports for each unit 1-2 times per year to request review and updates for older POs that may need action in order to close out.
10001/17/24 2:44 PMcversola@uga.eduProcurement
Procurement System Onboarding
ActiveTBDTBDThis process enables any staff involved in preparations for a new employee, such as obtaining system access, preparing office technology, etc., that often have to be completed in sequence. This replaces the flurry of last-minute and rushed preparations before they arrive.
10101/17/24 2:51 PMcversola@uga.eduProcurement
Recreation Reuse Tracking
ActiveTBDTBDThis tracks the request, review, and approval of recreation and reuse POs with various Procurement and Accounting teams. This replaces manual processing via emails and Excel tracking sheet.
10201/23/24 10:39 PMShawn HillSponsored Projects AdministrationEnterprise
Advance Payments to Subrecipients
ActiveTBDTBDAutomates a manual process and physical form to request advance payments to subrecipients and collect approvals from PI, Dean/Dept Head, and SPA Post Award Director.
10305/31/24 11:27 PMShawn HillSr VP for Academic Affairs & ProvostEnterprise
Opportunity Hire Tracker
ActiveTBDTBDTracks submissions and approvals (Dept Head, Dean, Provost's Office) for the opportunity hire program
10405/31/24 11:29 PMShawn HillSr VP for Academic Affairs & ProvostEnterprise
Presidential Strategic Hiring Initiative
ActiveTBDTBDTracks unit requests and approvals (Dean, Provost Office) for the Presidential Strategic Hiring Initiative.
10506/10/24 11:03 AMjgil2@uga.eduVP for Public Service & Outreach
GC HR Proces - Incoporates Position Requests, Internal Metric Reporting, and RSA Generation
In TestingTBDTBDWe are working to streamline our process to manage HR issues. Currently we have a sheet that took our legacy data from a decommissioned system. We are adding a Position Request flow as well as an RSA flow.

Our internal Reporting tracks performance measures, QPM, on how many students, what level of student, what they are studying, and where they are from.

Data stored is being updated, but is focused on positions. Does not store 810 or social. Will potentially store BCAT, MYID, Address, Birthday Position Posting, Funding source, FTE and Salary data
10605/12/23 11:51 PMShawn HillCAESUnit Level
Federal Vehicle & Farm Equipment Tracker
In TestingTBDTBDAllows CAES to track federal vehicles and farm equipment with maintenance logs, mileage tracker, location, etc. Creates prompts to enter updated information at intervals throughout the year.
10707/02/24 8:48 AMdanieljc@uga.eduCarl Vinson Institute of Government
Portfolio Management & Data Reports/Visualizations
ActiveTBDTBDLaunched this process effective 7.1.2023 to standardize our project intake process, capture key, aggregate data points, and integrate the necessary business workflow automations to increase organizational efficiencies. Also, we are using Power BI to send automated weekly paginated reports and dynamic stat report to leadership. We created a CVIOG data app in Power BI for all team members to access all current/historical projects by city, county, and client and plans to add more into this app. We have mocked up several dynamic dashboards in Power BI using data sourced from this sheet and synthetic data.
10811/20/24 2:06 PMdanieljc@uga.eduCarl Vinson Institute of Government
Professional Development & TAP
ActiveTBDTBDCollect all staff and faculty professional development experiences and TAP information via Smartsheet form and layer with Power BI to create data visualizations:

(Conference (Presenting) - local, state, or national
Conference (Attending)
Continuing Education (for required licensure)
Training Program
Tuition Assistance Program (TAP)
Webinar
Workshop
Other
10906/21/24 1:12 PMshawnh@uga.eduOffice of Student Financial AidEnterprise
Foreign gift/contract reporting
ActiveTBDTBDStreamlines collection of gifts from or contracts with financial entities. Auto calculates total amounts to determine whether thresholds are met for DOE or NSF reporting requirements.
11005/12/23 11:51 PMShawn HillOGE, BTS, Procurement, etc.Enterprise
Study Away Tracker
ActiveTBDTBDAllows OGE to coordinate with departments and Finance Division on budgetary aspects of study away programs.
11105/12/23 11:51 PMShawn HillSPA, UGAFEnterprise
Foundation Relations - Gift vs. Sponsored
DraftTBDTBDCreates a decision tree for gifts versus sponsored projects.