WEBVTT
1
00:00:16.771 --> 00:00:18.777
Good morning everyone.
2
00:00:18.777 --> 00:00:19.853
I'm just gonna give another minute or so.
3
00:00:19.853 --> 00:00:22.393
I think we have 50 people signed up
4
00:00:22.393 --> 00:00:25.950
so we have a few more that should be here
5
00:00:25.950 --> 00:00:27.333
in another minute or so.
6
00:00:34.310 --> 00:00:35.280
I have started the recording
7
00:00:35.280 --> 00:00:38.370
just so you're aware that we are gonna record today.
8
00:00:38.370 --> 00:00:40.830
There are a couple of things I've added to the presentation
9
00:00:40.830 --> 00:00:42.960
that are in last year's presentation,
10
00:00:42.960 --> 00:00:45.150
so hopefully this one goes smoothly
11
00:00:45.150 --> 00:00:47.793
and we'll upload this one when it's all set.
12
00:00:49.530 --> 00:00:52.020
I am gonna get going,
13
00:00:52.020 --> 00:00:53.970
so I just wanted to introduce myself
14
00:00:53.970 --> 00:00:55.593
and just let you know that I'm Dawn Caffrey,
15
00:00:55.593 --> 00:00:59.370
I am in financial and cost accounting services
16
00:00:59.370 --> 00:01:01.530
and I'm joined today by Josh
17
00:01:01.530 --> 00:01:03.663
from Sponsored Project Administration.
18
00:01:04.890 --> 00:01:08.070
I am gonna be looking at a screen over on the other side,
19
00:01:08.070 --> 00:01:09.600
so I am gonna turn my camera off,
20
00:01:09.600 --> 00:01:11.340
but I just wanted to to say hi,
21
00:01:11.340 --> 00:01:15.600
and I know like kind of runs more smoothly
22
00:01:15.600 --> 00:01:17.070
with everyone having their camera
23
00:01:17.070 --> 00:01:18.420
and their microphones off,
24
00:01:18.420 --> 00:01:21.480
but if you have any questions throughout the presentation,
25
00:01:21.480 --> 00:01:23.430
the chat is being monitored
26
00:01:23.430 --> 00:01:28.430
and if it makes sense to just jump off mute
27
00:01:30.900 --> 00:01:32.820
and just ask a question, you're welcome to do so as well,
28
00:01:32.820 --> 00:01:36.453
just when we get going, get back into mute.
29
00:01:37.680 --> 00:01:39.720
So I'm guessing everybody's gonna be having some coffee
30
00:01:39.720 --> 00:01:42.663
and some breakfast as we learn about effort reporting.
31
00:01:45.360 --> 00:01:48.690
So this is part two of our effort management series.
32
00:01:48.690 --> 00:01:53.690
Today we're gonna be focusing on the post award piece.
33
00:01:55.500 --> 00:01:59.070
So last month we had part one,
34
00:01:59.070 --> 00:02:01.380
personnel effort on sponsored projects.
35
00:02:01.380 --> 00:02:03.360
That was really focusing on proposals
36
00:02:03.360 --> 00:02:08.360
and how to include the effort commitment
37
00:02:08.400 --> 00:02:11.400
in a way that gives some flexibility
38
00:02:11.400 --> 00:02:13.830
and then today, like I said is part two,
39
00:02:13.830 --> 00:02:16.170
it's effort verification on sponsored projects
40
00:02:16.170 --> 00:02:18.960
and kind of focusing on the tools of the PI portal
41
00:02:18.960 --> 00:02:22.653
to help facilitate your quarterly reviews of effort.
42
00:02:25.710 --> 00:02:28.260
Today we'll go through quarterly verifications at UVM
43
00:02:28.260 --> 00:02:31.830
and who should be included in that and why.
44
00:02:31.830 --> 00:02:35.910
We will go through the tools in PeopleSoft,
45
00:02:35.910 --> 00:02:37.980
there's really kind of two main areas.
46
00:02:37.980 --> 00:02:41.611
There's the sponsored effort commitment tool
47
00:02:41.611 --> 00:02:44.490
and that's really looking at the person level
48
00:02:44.490 --> 00:02:46.650
and then we have the tools in the PI portal
49
00:02:46.650 --> 00:02:48.510
that really looks at the project level,
50
00:02:48.510 --> 00:02:51.180
so you can see everybody on the project.
51
00:02:51.180 --> 00:02:52.410
I have in here demo,
52
00:02:52.410 --> 00:02:55.200
but it kind of will go through demo
53
00:02:55.200 --> 00:02:57.510
for each section of those.
54
00:02:57.510 --> 00:02:59.040
We'll go through some planning
55
00:02:59.040 --> 00:03:01.530
and considerations for what to look for
56
00:03:01.530 --> 00:03:03.600
and ask during your quarterly verifications,
57
00:03:03.600 --> 00:03:06.810
and I can stay after for any kind
58
00:03:06.810 --> 00:03:08.700
of open lab time if people have questions
59
00:03:08.700 --> 00:03:11.703
or wanna work in the system and I can stick around.
60
00:03:15.300 --> 00:03:19.380
So I would recommend everybody kinda bookmark
61
00:03:19.380 --> 00:03:21.720
the division of finance page,
62
00:03:21.720 --> 00:03:23.220
'cause there's a lot of resources
63
00:03:23.220 --> 00:03:25.320
that you can get right from there.
64
00:03:25.320 --> 00:03:27.300
We have a link to the effort reporting page.
65
00:03:27.300 --> 00:03:29.970
We did the cost transfer training not too long ago,
66
00:03:29.970 --> 00:03:31.800
you can link to that.
67
00:03:31.800 --> 00:03:34.920
You have our F&A rates, or benefit rates
68
00:03:34.920 --> 00:03:39.920
and information about year end coming up
69
00:03:41.031 --> 00:03:42.000
and then closing move equipment,
70
00:03:42.000 --> 00:03:44.730
so there's a ton of information there,
71
00:03:44.730 --> 00:03:47.850
but if you are on the division of finance page,
72
00:03:47.850 --> 00:03:50.460
you can click on the effort management
73
00:03:50.460 --> 00:03:52.830
and reporting link
74
00:03:52.830 --> 00:03:55.440
and that will bring you to the effort management
75
00:03:55.440 --> 00:03:57.370
or reporting webpage schacker
76
00:03:59.490 --> 00:04:00.660
to go over some tools here.
77
00:04:00.660 --> 00:04:02.280
So under key resources,
78
00:04:02.280 --> 00:04:04.590
this right here is last year's presentation
79
00:04:04.590 --> 00:04:09.300
and once I get this presentation captioned,
80
00:04:09.300 --> 00:04:13.233
we'll have it up for you to view.
81
00:04:14.160 --> 00:04:16.950
Last year's PowerPoint is up there right now.
82
00:04:16.950 --> 00:04:19.530
I've added a couple of edits to it
83
00:04:19.530 --> 00:04:21.450
and at the end I've added some information
84
00:04:21.450 --> 00:04:26.450
about how to use ERS, the Effort Reporting System
85
00:04:27.180 --> 00:04:30.630
to log in throughout the year to see the impacts
86
00:04:30.630 --> 00:04:35.103
of dual appointments or directors, additional pays,
87
00:04:35.970 --> 00:04:38.523
that information is also in the user guide.
88
00:04:39.690 --> 00:04:41.520
We have a lot of good information
89
00:04:41.520 --> 00:04:43.480
in the frequently asked questions
90
00:04:44.550 --> 00:04:45.540
and again the user guide.
91
00:04:45.540 --> 00:04:47.220
So you have the user guide for the effort verification
92
00:04:47.220 --> 00:04:48.360
that we're going through today.
93
00:04:48.360 --> 00:04:52.680
There's a link to SPA's PI portal
94
00:04:52.680 --> 00:04:54.240
'cause I don't go through everything in the PI portal,
95
00:04:54.240 --> 00:04:55.990
but I go through quite a bit of it.
96
00:05:03.600 --> 00:05:05.040
If you're on my UVM,
97
00:05:05.040 --> 00:05:06.330
you have links to PeopleSoft
98
00:05:06.330 --> 00:05:08.100
which is what we'll be focusing on today,
99
00:05:08.100 --> 00:05:08.933
and you do have the link
100
00:05:08.933 --> 00:05:11.283
to the Effort Reporting System as well.
101
00:05:15.150 --> 00:05:17.130
So conducting effort verifications,
102
00:05:17.130 --> 00:05:18.480
who do we include in that?
103
00:05:18.480 --> 00:05:20.400
So basically all individuals
104
00:05:20.400 --> 00:05:23.010
who have payroll charged directly
105
00:05:23.010 --> 00:05:25.410
or is cost shared as sponsored agreements
106
00:05:25.410 --> 00:05:28.230
are included in the review of key personnel
107
00:05:28.230 --> 00:05:30.150
with commitments on sponsored projects,
108
00:05:30.150 --> 00:05:33.270
and the PI should be looking at anyone
109
00:05:33.270 --> 00:05:35.013
who isn't key personnel as well.
110
00:05:36.360 --> 00:05:39.180
So we have the semi-monthly employees
111
00:05:39.180 --> 00:05:43.680
who will also certify in ERS,
112
00:05:43.680 --> 00:05:45.873
which we've been doing for years now,
113
00:05:47.340 --> 00:05:50.610
and the semi-monthly are the faculty
114
00:05:50.610 --> 00:05:53.580
and key personnel and sponsored awards.
115
00:05:53.580 --> 00:05:57.270
I did have this note here that starting in FY24, any
116
00:05:57.270 --> 00:06:00.360
of the individuals who were moved from the biweekly,
117
00:06:00.360 --> 00:06:03.150
the traditional biweekly to Kronos,
118
00:06:03.150 --> 00:06:08.070
those individuals will start certifying in ERS this year.
119
00:06:08.070 --> 00:06:11.040
And there's more to come on that when I do the training
120
00:06:11.040 --> 00:06:12.690
for effort certification,
121
00:06:12.690 --> 00:06:16.053
not everyone will be transitioning in FY24,
122
00:06:18.630 --> 00:06:19.860
but those who do
123
00:06:19.860 --> 00:06:24.123
will have effort certification forms in ERS.
124
00:06:25.140 --> 00:06:28.770
We have the traditional biweekly hourly employee,
125
00:06:28.770 --> 00:06:31.570
and I added this traditional year for this year because,
126
00:06:33.210 --> 00:06:35.790
up until now you've had biweekly,
127
00:06:35.790 --> 00:06:39.030
which included our temporary hourly employees
128
00:06:39.030 --> 00:06:40.710
and our hourly undergraduate
129
00:06:40.710 --> 00:06:44.130
and graduate students as well as a few people on Kronos,
130
00:06:44.130 --> 00:06:48.320
so like our physical plant department was on Kronos,
131
00:06:48.320 --> 00:06:53.320
so now we're gonna have any employees who are non...
132
00:06:55.890 --> 00:07:00.300
I always get this wrong, so the non salaried?
133
00:07:00.300 --> 00:07:02.040
Non-exempt, there we go,
134
00:07:02.040 --> 00:07:05.970
non-exempt employees will be moving to Kronos.
135
00:07:05.970 --> 00:07:10.320
And so the temporary hourly employees
136
00:07:10.320 --> 00:07:12.540
and the hourly undergraduate and graduate students,
137
00:07:12.540 --> 00:07:15.570
they actually charge
138
00:07:15.570 --> 00:07:18.690
and certify their hours at the time they submit them
139
00:07:18.690 --> 00:07:20.310
and they will continue to do so.
140
00:07:20.310 --> 00:07:22.330
So they are not actually in
141
00:07:24.150 --> 00:07:25.800
the Effort Reporting System
142
00:07:25.800 --> 00:07:27.690
for certification at the end of the year,
143
00:07:27.690 --> 00:07:30.630
but you do need to review their hours
144
00:07:30.630 --> 00:07:33.240
as you're doing your quarterly review
145
00:07:33.240 --> 00:07:36.420
to make sure that they are being charged
146
00:07:36.420 --> 00:07:37.710
to the correct awards
147
00:07:37.710 --> 00:07:41.820
and being updated,
148
00:07:41.820 --> 00:07:45.390
especially if an award closes for one year
149
00:07:45.390 --> 00:07:46.740
and you get a new project for the next year,
150
00:07:46.740 --> 00:07:48.360
that those get updated
151
00:07:48.360 --> 00:07:50.220
so they're charging the correct budgets
152
00:07:50.220 --> 00:07:53.060
and there are no encumbrances for those,
153
00:07:53.060 --> 00:07:54.600
so no budget estimates for those,
154
00:07:54.600 --> 00:07:56.883
but they do need to be verified by the PI.
155
00:07:59.220 --> 00:08:01.650
So here we have the Kronos hourly employees
156
00:08:01.650 --> 00:08:03.540
that start transitioning next month.
157
00:08:03.540 --> 00:08:06.030
They will use the plan confirmation approach
158
00:08:06.030 --> 00:08:08.700
that the semi-monthly employees do,
159
00:08:08.700 --> 00:08:10.500
which we'll go over in a little bit.
160
00:08:11.730 --> 00:08:13.110
They will be charging actuals
161
00:08:13.110 --> 00:08:14.370
but they will be encumbered,
162
00:08:14.370 --> 00:08:17.020
so they are going to have kind of like
163
00:08:18.330 --> 00:08:20.520
what we've been referring to is salary distributions.
164
00:08:20.520 --> 00:08:21.600
It's not really salary now,
165
00:08:21.600 --> 00:08:23.130
but it's basically
166
00:08:23.130 --> 00:08:25.560
how they're anticipating their effort
167
00:08:25.560 --> 00:08:27.780
to be distributed in the same way
168
00:08:27.780 --> 00:08:29.733
we use salary distributions.
169
00:08:31.320 --> 00:08:34.060
Again, they need to be verified by the PI or co-PI
170
00:08:35.371 --> 00:08:38.163
and again, they will certify once a year in Kronos.
171
00:08:39.150 --> 00:08:43.110
For more guidance on the Kronos employee transition,
172
00:08:43.110 --> 00:08:47.190
you will need to look at payrolls page for that
173
00:08:47.190 --> 00:08:52.190
and I can send out the link too later on.
174
00:08:56.430 --> 00:08:57.420
And then just a note here,
175
00:08:57.420 --> 00:09:00.090
so pre and postdoc trainees
176
00:09:00.090 --> 00:09:03.850
and fellows, they don't certify
177
00:09:04.740 --> 00:09:05.670
because the federal government
178
00:09:05.670 --> 00:09:07.260
doesn't consider their stipend
179
00:09:07.260 --> 00:09:09.600
to be a true reflection of effort,
180
00:09:09.600 --> 00:09:11.910
but they do still need to be verified
181
00:09:11.910 --> 00:09:14.880
that the stipends are being appropriately allocated
182
00:09:14.880 --> 00:09:17.610
to projects and at the right amount,
183
00:09:17.610 --> 00:09:20.640
usually those training awards have a specific guidance
184
00:09:20.640 --> 00:09:25.640
of what is permitted in terms of the stipend amount.
185
00:09:31.170 --> 00:09:32.070
So continuing on,
186
00:09:32.070 --> 00:09:35.700
so commitments are in the PI portal
187
00:09:35.700 --> 00:09:38.610
and the source data is entered by SPA during award setup.
188
00:09:38.610 --> 00:09:40.680
So the people who have commitments
189
00:09:40.680 --> 00:09:43.003
are gonna be the principal investigator,
190
00:09:43.003 --> 00:09:46.350
a co-PI, anybody who's considered name personnel,
191
00:09:46.350 --> 00:09:47.880
so they're named on the notice
192
00:09:47.880 --> 00:09:51.060
of award document, notice award agreement
193
00:09:51.060 --> 00:09:52.830
and then we also have faculty.
194
00:09:52.830 --> 00:09:55.740
So any faculty who aren't any of the above,
195
00:09:55.740 --> 00:09:57.627
they're not a PI co-PI or named personnel,
196
00:09:57.627 --> 00:10:00.370
but we still wanna have a way for
197
00:10:01.950 --> 00:10:04.440
anybody helping faculty to be able to see
198
00:10:04.440 --> 00:10:08.310
their full commitments on awards.
199
00:10:08.310 --> 00:10:11.430
They have more flexibility in terms of
200
00:10:11.430 --> 00:10:12.480
changing those commitments,
201
00:10:12.480 --> 00:10:14.580
but it's good to have a tool
202
00:10:14.580 --> 00:10:17.070
to see what they've committed effort on
203
00:10:17.070 --> 00:10:19.370
and so that they don't over commit themselves.
204
00:10:20.773 --> 00:10:21.606
Just a note here,
205
00:10:21.606 --> 00:10:22.500
so if commitments are entered incorrectly
206
00:10:22.500 --> 00:10:23.700
at the time of award setup,
207
00:10:23.700 --> 00:10:25.830
you should contact SPA@uvm.edu
208
00:10:25.830 --> 00:10:27.900
and ask that the source data be corrected.
209
00:10:27.900 --> 00:10:29.580
You will see that correction
210
00:10:29.580 --> 00:10:31.260
in the PI portal the following day
211
00:10:31.260 --> 00:10:33.510
'cause it's a nightly process to update that.
212
00:10:37.050 --> 00:10:40.830
So individuals who do not get commitments in the PI portal
213
00:10:40.830 --> 00:10:45.830
are lab techs students, other non-key staff.
214
00:10:46.260 --> 00:10:47.610
So really they're not a faculty,
215
00:10:47.610 --> 00:10:50.520
typically they're not gonna have a commitment
216
00:10:50.520 --> 00:10:54.180
and even the pre-postdoc training fellows,
217
00:10:54.180 --> 00:10:56.460
they're not gonna have commitments,
218
00:10:56.460 --> 00:10:58.140
and the PI, again, is still responsible
219
00:10:58.140 --> 00:11:00.450
for verifying these individuals effort
220
00:11:00.450 --> 00:11:03.480
on their awards on a quarterly basis.
221
00:11:03.480 --> 00:11:05.933
We'll go over the tools to do that in a little bit.
222
00:11:09.427 --> 00:11:12.570
So as I mentioned before, the Kronos individuals
223
00:11:12.570 --> 00:11:15.930
that are moving to the new approach
224
00:11:15.930 --> 00:11:17.610
uses the plan confirmation approach,
225
00:11:17.610 --> 00:11:22.610
which is what the semi-monthly individuals do.
226
00:11:23.400 --> 00:11:25.170
So basically there's a salary distribution
227
00:11:25.170 --> 00:11:28.170
that is set up ahead of time that indicates
228
00:11:28.170 --> 00:11:31.023
where they intend to distribute their effort.
229
00:11:32.220 --> 00:11:36.000
For semi-monthly it's getting allocated
230
00:11:36.000 --> 00:11:39.510
as the payroll happens and in a set amount
231
00:11:39.510 --> 00:11:41.040
because they're salaried.
232
00:11:41.040 --> 00:11:43.470
Kronos individuals now will have
233
00:11:43.470 --> 00:11:45.270
the salary distribution set up,
234
00:11:45.270 --> 00:11:49.350
so it'll distribute their hours as they work them
235
00:11:49.350 --> 00:11:53.430
and enter them into Kronos against that salary distribution.
236
00:11:53.430 --> 00:11:56.373
So they're not going in like the regular traditional,
237
00:11:58.620 --> 00:12:01.590
biweekly, temp or grad students
238
00:12:01.590 --> 00:12:05.250
or students where they're entering a combo code,
239
00:12:05.250 --> 00:12:08.280
so it'll default to salary distribution,
240
00:12:08.280 --> 00:12:10.140
beyond that, any further questions
241
00:12:10.140 --> 00:12:12.150
that'll need to go again to payroll,
242
00:12:12.150 --> 00:12:15.720
but it's basically like you're planning on how
243
00:12:15.720 --> 00:12:18.510
that effort is gonna be distributed ahead of time
244
00:12:18.510 --> 00:12:21.810
and what they're planning on working on.
245
00:12:21.810 --> 00:12:24.150
So it's important to have these quarterly verifications
246
00:12:24.150 --> 00:12:26.370
to look back at the last quarter
247
00:12:26.370 --> 00:12:28.920
and ask, you know, this is how we planned
248
00:12:28.920 --> 00:12:31.080
on having your effort distributed,
249
00:12:31.080 --> 00:12:32.910
was that really a good reflection
250
00:12:32.910 --> 00:12:34.950
of your effort as it was worked
251
00:12:34.950 --> 00:12:38.110
and making any corrections
252
00:12:39.180 --> 00:12:42.120
to actual effort that is needed.
253
00:12:42.120 --> 00:12:46.290
So if they planned on doing 50% on award A and award B
254
00:12:46.290 --> 00:12:48.033
and it actually ended up being 25%
255
00:12:48.033 --> 00:12:50.340
and 75%, you're gonna look back
256
00:12:50.340 --> 00:12:51.540
and get that information,
257
00:12:51.540 --> 00:12:54.243
having that conversation, making that change.
258
00:12:55.410 --> 00:12:57.270
And then the confirmation piece
259
00:12:57.270 --> 00:12:59.550
is we do an annual certification,
260
00:12:59.550 --> 00:13:01.500
so it's July through June
261
00:13:01.500 --> 00:13:03.543
of the proceeding fiscal year,
262
00:13:05.670 --> 00:13:08.010
so that's the period that's being certified
263
00:13:08.010 --> 00:13:09.090
for the effort,
264
00:13:09.090 --> 00:13:12.873
but it's conducted during like late August into September,
265
00:13:14.220 --> 00:13:16.050
any of the stragglers who are still working on it,
266
00:13:16.050 --> 00:13:18.483
really, the deadline is October 15th,
267
00:13:19.380 --> 00:13:20.670
but generally trying to get it done
268
00:13:20.670 --> 00:13:23.403
by the September payroll,
269
00:13:24.900 --> 00:13:27.060
and it is a web-based certification system.
270
00:13:27.060 --> 00:13:28.470
And so there's a training specifically
271
00:13:28.470 --> 00:13:30.750
on that at the end of August.
272
00:13:30.750 --> 00:13:32.760
So anybody who's gonna be involved with that,
273
00:13:32.760 --> 00:13:35.313
look for that announcement later in the year.
274
00:13:39.150 --> 00:13:40.680
And the reason for doing all this
275
00:13:40.680 --> 00:13:44.220
is really to abide by federal regulations.
276
00:13:44.220 --> 00:13:48.330
So the uniform guidance that is currently in place
277
00:13:48.330 --> 00:13:51.480
was put out in December, 2014
278
00:13:51.480 --> 00:13:54.030
and focused on internal controls,
279
00:13:54.030 --> 00:13:55.880
and it used what's called the COSO
280
00:13:55.880 --> 00:14:00.003
or the Green Book was cited quite a bit in that.
281
00:14:00.870 --> 00:14:03.180
At the time UVM did an assessment
282
00:14:03.180 --> 00:14:05.823
of our approach to effort,
283
00:14:06.930 --> 00:14:08.010
and we realized that, you know,
284
00:14:08.010 --> 00:14:12.000
at the time UVM's internal controls really aligned
285
00:14:12.000 --> 00:14:15.423
with the changes in uniform guidance at that time.
286
00:14:16.890 --> 00:14:19.410
We now use a PeopleSoft commitment tool
287
00:14:19.410 --> 00:14:21.300
to conduct the quarterly verifications,
288
00:14:21.300 --> 00:14:23.430
which is why you're all here today.
289
00:14:23.430 --> 00:14:25.773
We do the, you know, certification.
290
00:14:26.670 --> 00:14:29.490
There were some updates to the IBS definition based on that,
291
00:14:29.490 --> 00:14:33.870
which we'll go over after this, which is still applicable
292
00:14:33.870 --> 00:14:38.850
based on some upcoming changes that we've seen
293
00:14:38.850 --> 00:14:41.640
for effort or excuse me, for uniform guidance.
294
00:14:41.640 --> 00:14:44.190
So we are anticipating some updates
295
00:14:44.190 --> 00:14:46.770
to uniform guidance this year.
296
00:14:46.770 --> 00:14:48.450
It could be any day now,
297
00:14:48.450 --> 00:14:52.557
but we didn't see any real changes for effort,
298
00:14:52.557 --> 00:14:55.230
and so we'll continue to do what we've been doing
299
00:14:55.230 --> 00:14:57.024
'cause we've been passing audits
300
00:14:57.024 --> 00:14:59.343
and it's been very successful.
301
00:15:02.580 --> 00:15:05.430
So again, when uniform guidance first came out,
302
00:15:05.430 --> 00:15:08.580
these were kind of some of the updates that we had.
303
00:15:08.580 --> 00:15:12.330
So effort verification is done on a quarterly basis
304
00:15:12.330 --> 00:15:13.800
and it's really for all employees, right?
305
00:15:13.800 --> 00:15:16.560
So it's not just the principal investigator
306
00:15:16.560 --> 00:15:17.460
and the key personnel.
307
00:15:17.460 --> 00:15:18.630
You have to look at everybody.
308
00:15:18.630 --> 00:15:21.690
but the principal investigator is now allowed
309
00:15:21.690 --> 00:15:26.553
to verify the other employees on the award.
310
00:15:28.890 --> 00:15:30.030
When you get to certification,
311
00:15:30.030 --> 00:15:32.460
all faculty have to certify for themselves,
312
00:15:32.460 --> 00:15:36.783
but PIs can certify for any of their students,
313
00:15:40.466 --> 00:15:41.880
and staff on the awards
314
00:15:41.880 --> 00:15:44.040
if that's what the department chooses to do,
315
00:15:44.040 --> 00:15:45.603
and that's permissible.
316
00:15:47.370 --> 00:15:48.750
As far as charging salaries
317
00:15:48.750 --> 00:15:51.093
and wages to sponsored projects,
318
00:15:52.320 --> 00:15:54.330
the importance here is that
319
00:15:54.330 --> 00:15:56.550
all necessary payroll adjustments must be made
320
00:15:56.550 --> 00:15:59.280
such the final amount charged to sponsored agreements
321
00:15:59.280 --> 00:16:02.340
is accurate, allowable and properly allocated.
322
00:16:02.340 --> 00:16:03.690
And it really goes down to
323
00:16:03.690 --> 00:16:06.180
what our university definition is kind
324
00:16:06.180 --> 00:16:08.070
of having a tolerance in there.
325
00:16:08.070 --> 00:16:10.920
And so right out of the effort management
326
00:16:10.920 --> 00:16:13.023
and reporting policy,
327
00:16:13.980 --> 00:16:15.810
I'm gonna just have to read it, sorry.
328
00:16:15.810 --> 00:16:17.580
The university's level of precision
329
00:16:17.580 --> 00:16:20.310
of an employee's effort on each sponsored agreement
330
00:16:20.310 --> 00:16:24.790
or activity shall be within 5% of an employee's total effort
331
00:16:25.680 --> 00:16:28.830
of the activities included in the IBS.
332
00:16:28.830 --> 00:16:30.690
And so I just really wanna kind of get into this,
333
00:16:30.690 --> 00:16:35.100
and so an example here is for a quarter
334
00:16:35.100 --> 00:16:38.640
that you're looking at, you charge 10% for an individual
335
00:16:38.640 --> 00:16:41.460
to a specific sponsored agreement.
336
00:16:41.460 --> 00:16:43.477
But when you're talking with that individual, they say,
337
00:16:43.477 --> 00:16:47.430
"Oh well you know, the first month I worked 8%,
338
00:16:47.430 --> 00:16:49.860
I worked 10% the second month
339
00:16:49.860 --> 00:16:52.440
and then the third month I worked 12%."
340
00:16:52.440 --> 00:16:54.480
You're still averaging 10%.
341
00:16:54.480 --> 00:16:57.270
And so in that case the correct amount
342
00:16:57.270 --> 00:17:00.120
is allocated to that agreement,
343
00:17:00.120 --> 00:17:03.120
so the final amount for that quarter was correct,
344
00:17:03.120 --> 00:17:07.683
and it's within the 5% tolerance.
345
00:17:08.820 --> 00:17:13.820
Now let's say the employee was charged 10% for that quarter
346
00:17:13.860 --> 00:17:16.057
and the communication was like,
347
00:17:16.057 --> 00:17:20.910
"Oh no, I did like 4% one month, 10% the second
348
00:17:20.910 --> 00:17:23.700
and then 16 the final month."
349
00:17:23.700 --> 00:17:25.920
You're still charging the correct final amount
350
00:17:25.920 --> 00:17:28.530
in that amount 'cause it still averages the 10%,
351
00:17:28.530 --> 00:17:31.260
but now you exceed that 5% tolerance.
352
00:17:31.260 --> 00:17:34.650
And so in that case, according to our effort policy,
353
00:17:34.650 --> 00:17:37.500
we would expect that a distribution be updated
354
00:17:37.500 --> 00:17:41.910
to correct the variation within that month.
355
00:17:41.910 --> 00:17:44.460
So as long as you're within that 5%
356
00:17:44.460 --> 00:17:47.400
and it's the final amount is accurate, no updates need
357
00:17:47.400 --> 00:17:49.080
to be submitted,
358
00:17:49.080 --> 00:17:50.653
once you exceed the 5%,
359
00:17:50.653 --> 00:17:54.213
yes we expect corrections to be made to reflect that.
360
00:17:59.280 --> 00:18:00.210
So again, this is one account
361
00:18:00.210 --> 00:18:03.450
I just need to read. (laughing)
362
00:18:03.450 --> 00:18:05.580
So this is directly out of uniform guidance.
363
00:18:05.580 --> 00:18:07.950
So it was recognized that teaching, research, service
364
00:18:07.950 --> 00:18:11.250
and administration are often inextricably intermingled
365
00:18:11.250 --> 00:18:12.960
in the academic setting,
366
00:18:12.960 --> 00:18:13.980
when recording salaries
367
00:18:13.980 --> 00:18:16.530
and wages charged to federal awards for institutions
368
00:18:16.530 --> 00:18:19.770
of higher education, a precise assessment of factors
369
00:18:19.770 --> 00:18:23.520
that contribute to cost is therefore not always feasible
370
00:18:23.520 --> 00:18:24.870
nor is it expected.
371
00:18:24.870 --> 00:18:27.210
Basically the federal government is recognizing
372
00:18:27.210 --> 00:18:30.990
that it's really hard to be precise
373
00:18:30.990 --> 00:18:33.360
and we're not expected to go in
374
00:18:33.360 --> 00:18:36.540
and have people track hour by hour what their effort is.
375
00:18:36.540 --> 00:18:41.540
And so it's really kind of defaults to
376
00:18:41.640 --> 00:18:43.680
what the institutional policy is.
377
00:18:43.680 --> 00:18:48.030
And so they state that significant changes
378
00:18:48.030 --> 00:18:51.360
in the corresponding work activity as defined
379
00:18:51.360 --> 00:18:53.340
by the non-federal entities written policy.
380
00:18:53.340 --> 00:18:57.330
So basically as defined by UVM, are identified
381
00:18:57.330 --> 00:18:59.160
and entered into records in a timely manner.
382
00:18:59.160 --> 00:19:02.160
So this is going back to what I just talked about here.
383
00:19:02.160 --> 00:19:07.160
We define it as a 5% tolerance within the employee's IBS.
384
00:19:09.450 --> 00:19:12.360
And so anything beyond that 5%
385
00:19:12.360 --> 00:19:16.380
is considered a significant change according to our policy.
386
00:19:16.380 --> 00:19:21.120
And so we would enter into the records that correction,
387
00:19:21.120 --> 00:19:22.600
so do a salary distribution
388
00:19:23.820 --> 00:19:26.910
and then the uniform guidance also continues on,
389
00:19:26.910 --> 00:19:29.370
it says short term as one
390
00:19:29.370 --> 00:19:32.460
or two months fluctuations between workload.
391
00:19:32.460 --> 00:19:35.220
Categories need not be considered as long
392
00:19:35.220 --> 00:19:37.014
as the distribution of salaries
393
00:19:37.014 --> 00:19:39.960
and wages is reasonable over the long term.
394
00:19:39.960 --> 00:19:43.320
So kind of what they consider long term
395
00:19:43.320 --> 00:19:45.333
is three months or more, so.
396
00:19:48.267 --> 00:19:52.147
It's kind of the dense part of the presentation. (laughing)
397
00:19:56.130 --> 00:20:00.060
I just wanna briefly touch upon the 1% minimum
398
00:20:00.060 --> 00:20:04.440
for principal investigators.
399
00:20:04.440 --> 00:20:09.003
We did update this language a couple years ago,
400
00:20:10.200 --> 00:20:15.200
so basically we're expecting that PIs have a 1% average
401
00:20:15.270 --> 00:20:18.120
for the minimum on a per budget period,
402
00:20:18.120 --> 00:20:19.703
so no less than 1%.
403
00:20:21.420 --> 00:20:24.240
What was changed was to put this average in here,
404
00:20:24.240 --> 00:20:28.297
because it isn't sufficient for somebody to say,
405
00:20:28.297 --> 00:20:30.390
"Oh I have 1% during the summer month."
406
00:20:30.390 --> 00:20:32.550
So if somebody's a nine month faculty
407
00:20:32.550 --> 00:20:36.450
and they work 1% during the summer months on their award,
408
00:20:36.450 --> 00:20:39.060
that's not 1% for the budget period,
409
00:20:39.060 --> 00:20:40.710
they would have to increase their amount.
410
00:20:40.710 --> 00:20:43.470
If they're only working during the summer,
411
00:20:43.470 --> 00:20:44.610
they would need to increase it
412
00:20:44.610 --> 00:20:47.730
because if the budget period is a full year,
413
00:20:47.730 --> 00:20:52.200
which typically they are, but not always. (laughing)
414
00:20:52.200 --> 00:20:53.940
If the award is specifically
415
00:20:53.940 --> 00:20:56.550
for just the three summer months for start
416
00:20:56.550 --> 00:20:57.750
and end date of the award,
417
00:20:57.750 --> 00:20:59.760
then 1% would be fine in that case,
418
00:20:59.760 --> 00:21:02.250
but if the budget period is longer than that,
419
00:21:02.250 --> 00:21:03.083
you need to look at
420
00:21:03.083 --> 00:21:04.800
what's the average over the budget period.
421
00:21:04.800 --> 00:21:08.310
And so sometimes if they're only working
422
00:21:08.310 --> 00:21:10.620
for a certain field season, they would need
423
00:21:10.620 --> 00:21:15.003
to be working more than 1% during that field season.
424
00:21:16.800 --> 00:21:19.620
And just also to clarify,
425
00:21:19.620 --> 00:21:23.220
the 1% doesn't need to be cost shared.
426
00:21:23.220 --> 00:21:25.290
I still see quite a bit of that
427
00:21:25.290 --> 00:21:27.727
as a comment in salary distributions like
428
00:21:27.727 --> 00:21:30.150
"Oh we need to put our 1% cost share on here."
429
00:21:30.150 --> 00:21:33.420
And just to clarify, the expectation from UVM is to try
430
00:21:33.420 --> 00:21:35.730
and get that to be paid by the sponsor,
431
00:21:35.730 --> 00:21:37.350
so they're paying their fair share
432
00:21:37.350 --> 00:21:40.890
of the effort required to complete the award.
433
00:21:40.890 --> 00:21:43.320
Obviously budgets don't always accommodate that
434
00:21:43.320 --> 00:21:44.558
and so sometimes it can,
435
00:21:44.558 --> 00:21:46.860
I mean it obviously can be cost shared if that's approved
436
00:21:46.860 --> 00:21:48.753
by the dean's departments,
437
00:21:50.310 --> 00:21:52.503
but it isn't required to be cost share.
438
00:21:56.130 --> 00:21:58.230
Just to touch upon some prior approvals.
439
00:21:58.230 --> 00:22:02.970
So any change in key personnel on the award would need
440
00:22:02.970 --> 00:22:05.880
to be communicated to the sponsor,
441
00:22:05.880 --> 00:22:08.583
and so that's anybody named on the award document.
442
00:22:09.720 --> 00:22:13.360
Does engagements from the project for more than three months
443
00:22:14.880 --> 00:22:19.770
or a 25% or greater reduction in time devoted to the project
444
00:22:19.770 --> 00:22:23.070
by key personnel would need to get prior approval.
445
00:22:23.070 --> 00:22:26.340
And so really the PI should be involved
446
00:22:26.340 --> 00:22:30.720
with anyone having a reduction of effort
447
00:22:30.720 --> 00:22:32.730
that's key personnel on their awards
448
00:22:32.730 --> 00:22:35.340
so that they can evaluate whether or not the scope
449
00:22:35.340 --> 00:22:37.170
or the objective of the project
450
00:22:37.170 --> 00:22:39.930
is able to be met with that change.
451
00:22:39.930 --> 00:22:42.450
So I mean this isn't strictly effort
452
00:22:42.450 --> 00:22:45.540
in terms of needing to get sponsored prior approval,
453
00:22:45.540 --> 00:22:48.840
but other individuals reductions
454
00:22:48.840 --> 00:22:50.670
or disengagements could impact to that,
455
00:22:50.670 --> 00:22:52.530
so we just mentioned it here as something
456
00:22:52.530 --> 00:22:55.680
to consider while doing your quarterly reviews
457
00:22:55.680 --> 00:22:57.213
with your PIs.
458
00:22:59.100 --> 00:23:02.370
And just a note that NH now allows effort reductions
459
00:23:02.370 --> 00:23:05.010
during no cost extension periods without prior approval.
460
00:23:05.010 --> 00:23:06.620
However, it does need to be indicated at the time
461
00:23:06.620 --> 00:23:11.103
of the no-cost extension request when working with SPA.
462
00:23:15.390 --> 00:23:17.100
The effort compliance landscape,
463
00:23:17.100 --> 00:23:18.310
so there's been
464
00:23:20.370 --> 00:23:22.980
and continues to be pretty hefty fines
465
00:23:22.980 --> 00:23:27.843
for institutions who don't have sufficient support,
466
00:23:30.700 --> 00:23:32.490
so they don't have sufficient documentation
467
00:23:32.490 --> 00:23:35.070
to support the level of effort claimed on grants
468
00:23:35.070 --> 00:23:36.903
and charged to awards.
469
00:23:37.740 --> 00:23:39.570
So this is a list that we do not want
470
00:23:39.570 --> 00:23:40.890
to find ourselves on some days.
471
00:23:40.890 --> 00:23:44.610
So that's why we continue on with what we've been doing
472
00:23:44.610 --> 00:23:45.750
and we've been very successful
473
00:23:45.750 --> 00:23:48.153
with our current policies and procedures.
474
00:23:49.770 --> 00:23:51.900
In terms of audits, there's internal audits
475
00:23:51.900 --> 00:23:54.780
and investigations here at UVM.
476
00:23:54.780 --> 00:23:57.240
There are uniform guidance audits.
477
00:23:57.240 --> 00:24:00.840
We currently have KPMG as our external auditors.
478
00:24:00.840 --> 00:24:05.580
There are office of an inspector general audits,
479
00:24:05.580 --> 00:24:07.200
agency specific audits.
480
00:24:07.200 --> 00:24:10.260
And it feels like UVM's always under an audit (laughing)
481
00:24:10.260 --> 00:24:11.280
for one reason or another,
482
00:24:11.280 --> 00:24:13.260
which a lot of times is behind the scenes
483
00:24:13.260 --> 00:24:15.030
and you guys aren't aware of what we're doing
484
00:24:15.030 --> 00:24:17.610
because we do have the documentation,
485
00:24:17.610 --> 00:24:20.160
like, I'm constantly asked for
486
00:24:20.160 --> 00:24:23.550
effort certification forms for different awards
487
00:24:23.550 --> 00:24:26.103
because of, again, agency specific audits.
488
00:24:30.090 --> 00:24:32.040
In terms of effort planning and management.
489
00:24:32.040 --> 00:24:35.100
So reviewing effort can really inform a lot
490
00:24:35.100 --> 00:24:36.960
of things throughout the fiscal years.
491
00:24:36.960 --> 00:24:38.910
Obviously we have the committed effort
492
00:24:38.910 --> 00:24:41.160
and effort confirmation.
493
00:24:41.160 --> 00:24:42.240
We have a quarterly monitoring,
494
00:24:42.240 --> 00:24:44.070
which we're talking about today, updates
495
00:24:44.070 --> 00:24:46.473
to salary distributions throughout the year.
496
00:24:47.550 --> 00:24:51.570
Fiscal budgeting, which we're entering in,
497
00:24:51.570 --> 00:24:52.403
it's either started now
498
00:24:52.403 --> 00:24:53.236
or we're going into it
499
00:24:53.236 --> 00:24:56.190
in the next few days to two weeks
500
00:24:56.190 --> 00:24:58.320
and your faculty workload plans.
501
00:24:58.320 --> 00:25:01.110
So people are trying to take on more effort, you know,
502
00:25:01.110 --> 00:25:03.270
look at what's already planned for them
503
00:25:03.270 --> 00:25:06.990
in the PeopleSoft tools
504
00:25:06.990 --> 00:25:09.120
so you can see if they're gonna be over committed.
505
00:25:09.120 --> 00:25:13.110
Are they able to incorporate what they're proposing,
506
00:25:13.110 --> 00:25:15.243
particularly for director roles, you know,
507
00:25:16.200 --> 00:25:17.910
that's gotta be part of their 1.0 FTE
508
00:25:20.250 --> 00:25:24.150
and so where can they reduce effort elsewhere
509
00:25:24.150 --> 00:25:26.250
to accommodate those type of roles.
510
00:25:26.250 --> 00:25:28.800
And so the dean's offices
511
00:25:28.800 --> 00:25:31.470
can use these tools
512
00:25:31.470 --> 00:25:33.780
and come to the administrators for support
513
00:25:33.780 --> 00:25:35.643
before approving certain things.
514
00:25:38.430 --> 00:25:41.070
So in terms of getting to the tools
515
00:25:41.070 --> 00:25:44.430
to help to ask all those questions
516
00:25:44.430 --> 00:25:45.390
and considerations,
517
00:25:45.390 --> 00:25:48.480
so you would go to the employee homepage,
518
00:25:48.480 --> 00:25:52.590
so most of you probably already default to that
519
00:25:52.590 --> 00:25:56.100
and you'd click on the UVM PI portal
520
00:25:56.100 --> 00:25:58.143
and oops, sorry about that.
521
00:25:59.520 --> 00:26:03.060
And from there you have really two areas
522
00:26:03.060 --> 00:26:04.170
that we'll focus on today,
523
00:26:04.170 --> 00:26:06.300
I'm gonna start with the second menu option down,
524
00:26:06.300 --> 00:26:08.880
it's the sponsored effort commitments.
525
00:26:08.880 --> 00:26:12.450
And from there you can type in a department
526
00:26:12.450 --> 00:26:15.360
or you can type in a person's name
527
00:26:15.360 --> 00:26:17.643
or employee ID department description,
528
00:26:18.810 --> 00:26:22.110
however you wanna start looking for your individuals
529
00:26:22.110 --> 00:26:24.210
who you need to to look into.
530
00:26:24.210 --> 00:26:29.210
And anybody who has commitment set up for them
531
00:26:29.640 --> 00:26:31.980
will be displayed below in the list below,
532
00:26:31.980 --> 00:26:33.060
and you can just click on them
533
00:26:33.060 --> 00:26:36.063
and it'll bring you into an individual's form.
534
00:26:38.640 --> 00:26:42.990
So it brings you right into the commitment
535
00:26:42.990 --> 00:26:46.820
by person tab of the sponsored effort commitments,
536
00:26:46.820 --> 00:26:48.120
and so there's a lot of information here
537
00:26:48.120 --> 00:26:50.802
so I'm gonna start to try and break it all down.
538
00:26:50.802 --> 00:26:52.530
So here in the header it's gonna default
539
00:26:52.530 --> 00:26:54.330
to the current fiscal year.
540
00:26:54.330 --> 00:26:55.650
I wasn't as successful
541
00:26:55.650 --> 00:26:57.090
as finding like some really good examples
542
00:26:57.090 --> 00:26:58.020
as I was last year,
543
00:26:58.020 --> 00:27:00.510
so I did just keep most of my examples from last year.
544
00:27:00.510 --> 00:27:05.510
So for now, if you go into it, it would default to 2024,
545
00:27:06.600 --> 00:27:09.450
but if somebody does have a salary distribution pending
546
00:27:09.450 --> 00:27:12.810
for them, as long as it was done the day before,
547
00:27:12.810 --> 00:27:14.670
the system is gonna give you a note here,
548
00:27:14.670 --> 00:27:15.630
letting you know that there are
549
00:27:15.630 --> 00:27:18.813
outstanding distribution changes for this person.
550
00:27:20.400 --> 00:27:21.930
Notes that, you know, effort reduction
551
00:27:21.930 --> 00:27:24.543
more than 25% require prior approval.
552
00:27:26.070 --> 00:27:27.360
We'll go over this later.
553
00:27:27.360 --> 00:27:29.730
This is a button here that you can add comments.
554
00:27:29.730 --> 00:27:30.990
So this is really great
555
00:27:30.990 --> 00:27:35.820
'cause there's constantly changes
556
00:27:35.820 --> 00:27:38.340
in personnel within departments
557
00:27:38.340 --> 00:27:40.710
or kind of structures of how departments work
558
00:27:40.710 --> 00:27:43.800
and manage and support their faculty.
559
00:27:43.800 --> 00:27:48.720
So if more than one person is going to be responsible
560
00:27:48.720 --> 00:27:51.810
for supporting faculty, we recommend putting your comments
561
00:27:51.810 --> 00:27:54.630
after doing your quarterly reviews into PeopleSoft
562
00:27:54.630 --> 00:27:59.310
so that they're available for whether you leave
563
00:27:59.310 --> 00:28:00.940
and go onto a different position
564
00:28:02.280 --> 00:28:06.180
or your department changes the structure
565
00:28:06.180 --> 00:28:08.880
and now you have like a team approach to supporting faculty
566
00:28:08.880 --> 00:28:11.730
and you may not be the same person always supporting
567
00:28:11.730 --> 00:28:15.090
that particular faculty person,
568
00:28:15.090 --> 00:28:17.250
so we'll go over that in a little bit.
569
00:28:17.250 --> 00:28:20.490
But again, so it will first default to all the commitments
570
00:28:20.490 --> 00:28:23.160
for the current fiscal year when you enter it.
571
00:28:23.160 --> 00:28:25.650
You can type in a different fiscal year
572
00:28:25.650 --> 00:28:27.120
and click limit by fiscal year.
573
00:28:27.120 --> 00:28:29.130
If you wanted to look at the last year,
574
00:28:29.130 --> 00:28:30.600
you can click show all year,
575
00:28:30.600 --> 00:28:32.973
it can be a bit much though, I will warn you.
576
00:28:35.490 --> 00:28:37.200
But then if you start looking at the information,
577
00:28:37.200 --> 00:28:38.550
it's showing you, you get the award
578
00:28:38.550 --> 00:28:40.920
and project, a lot of the PIs
579
00:28:40.920 --> 00:28:43.650
or faculty know their project by the description
580
00:28:43.650 --> 00:28:47.430
and not so much the PeopleSoft information
581
00:28:47.430 --> 00:28:48.630
or the click information,
582
00:28:48.630 --> 00:28:50.640
so that's here as well.
583
00:28:50.640 --> 00:28:53.680
I believe there's the award description at the very end
584
00:28:55.500 --> 00:28:58.500
and then there's a button here, we'll go over it later,
585
00:28:58.500 --> 00:28:59.850
just go to that project
586
00:28:59.850 --> 00:29:02.790
so you could see all the information on that.
587
00:29:02.790 --> 00:29:04.140
The employee class,
588
00:29:04.140 --> 00:29:07.650
so here you have your 12 month faculty,
589
00:29:07.650 --> 00:29:12.650
sometimes you have nine month faculty,
590
00:29:12.990 --> 00:29:14.220
occasionally there I think there'll be
591
00:29:14.220 --> 00:29:15.180
a couple of 10 months,
592
00:29:15.180 --> 00:29:17.940
but basically 12 or nine month faculty.
593
00:29:17.940 --> 00:29:20.160
Your role, which will dictate whether
594
00:29:20.160 --> 00:29:21.960
it's considered key or not,
595
00:29:21.960 --> 00:29:25.950
so principal investigator, co-PI and name personnel.
596
00:29:25.950 --> 00:29:28.890
These are your three that will default
597
00:29:28.890 --> 00:29:31.230
to saying yes they are key personnel.
598
00:29:31.230 --> 00:29:33.423
Your faculty role is, no.
599
00:29:34.650 --> 00:29:36.390
The awarded home department is helpful
600
00:29:36.390 --> 00:29:39.420
because if you're the faculty person
601
00:29:39.420 --> 00:29:42.550
you're doing a quarterly review on
602
00:29:44.190 --> 00:29:47.580
has commitments and awards outside of your department,
603
00:29:47.580 --> 00:29:49.530
it's helpful to know which department that is
604
00:29:49.530 --> 00:29:52.050
and to reach out to that department
605
00:29:52.050 --> 00:29:55.050
to find out is this award getting extended
606
00:29:55.050 --> 00:29:58.210
or when you're meeting with them
607
00:29:59.310 --> 00:30:00.420
or with your faculty
608
00:30:00.420 --> 00:30:02.550
and they say, "I'm not working on this anymore."
609
00:30:02.550 --> 00:30:04.290
And their key personnel, you wanna reach out
610
00:30:04.290 --> 00:30:07.830
to that administrator and the PI to let them know
611
00:30:07.830 --> 00:30:09.990
that they've dropped off that award
612
00:30:09.990 --> 00:30:12.273
or reduced their effort for instance.
613
00:30:13.470 --> 00:30:15.180
So this kind of keeps scrolling.
614
00:30:15.180 --> 00:30:17.220
So I'm just gonna go to the the next slide
615
00:30:17.220 --> 00:30:18.900
which continues on.
616
00:30:18.900 --> 00:30:21.690
So you would have this start
617
00:30:21.690 --> 00:30:22.523
and end date of...
618
00:30:22.523 --> 00:30:23.670
This is the commitment,
619
00:30:23.670 --> 00:30:25.890
this isn't the award start and end date.
620
00:30:25.890 --> 00:30:28.860
So this is telling you when they should be working
621
00:30:28.860 --> 00:30:30.480
on the award and how much.
622
00:30:30.480 --> 00:30:32.850
So 12 month individual would be calendar
623
00:30:32.850 --> 00:30:34.560
and calendar cost share.
624
00:30:34.560 --> 00:30:37.650
A nine month faculty will have academic
625
00:30:37.650 --> 00:30:41.520
and direct Anna's cost share,
626
00:30:41.520 --> 00:30:42.900
and this gives you the information on who
627
00:30:42.900 --> 00:30:45.180
the PI of that particular award is.
628
00:30:45.180 --> 00:30:47.340
And historically for the Effort Reporting System,
629
00:30:47.340 --> 00:30:50.310
when we used that as the commitment tool, they had
630
00:30:50.310 --> 00:30:53.070
to have each budget period broken out for some features
631
00:30:53.070 --> 00:30:55.320
that worked in that system.
632
00:30:55.320 --> 00:30:56.640
We've moved away from that,
633
00:30:56.640 --> 00:30:59.700
so you'll start to see instead of each award
634
00:30:59.700 --> 00:31:02.640
being set up for individual budget periods,
635
00:31:02.640 --> 00:31:05.760
if the commitment doesn't change over time,
636
00:31:05.760 --> 00:31:08.040
you might see one...
637
00:31:08.040 --> 00:31:10.950
Sorry, I think we're getting an oil delivery,
638
00:31:10.950 --> 00:31:13.150
so if you hear the dog barking, I apologize.
639
00:31:15.090 --> 00:31:16.140
So what was I saying?
640
00:31:16.140 --> 00:31:18.930
Yeah, so going forward you might just see
641
00:31:18.930 --> 00:31:21.930
for one award it might span like five years
642
00:31:21.930 --> 00:31:23.253
if it's a five year award.
643
00:31:26.670 --> 00:31:30.780
So this cost share is both regular cost share
644
00:31:30.780 --> 00:31:32.430
that's committed to the sponsor
645
00:31:32.430 --> 00:31:35.463
or it's over the salary cap cost share.
646
00:31:36.720 --> 00:31:39.570
Comments here, these are percentages
647
00:31:39.570 --> 00:31:41.520
and they're not listed in person months,
648
00:31:41.520 --> 00:31:44.940
so there is that difference
649
00:31:44.940 --> 00:31:48.240
that we talked about in part one
650
00:31:48.240 --> 00:31:53.240
of the effort trainings where it's best to commit effort
651
00:31:55.920 --> 00:31:57.690
to the sponsor based on person months
652
00:31:57.690 --> 00:31:59.880
because it allows for a lot of flexibility,
653
00:31:59.880 --> 00:32:03.120
but once it's awarded, we all work in percentages
654
00:32:03.120 --> 00:32:06.480
because salary distributions are not set up
655
00:32:06.480 --> 00:32:10.320
by person months.
656
00:32:10.320 --> 00:32:15.170
You know, like so the system right now gives percentages
657
00:32:16.260 --> 00:32:19.590
and I know SPA's working on a new version
658
00:32:19.590 --> 00:32:22.740
of Qlik that might be giving it in person months,
659
00:32:22.740 --> 00:32:24.690
so there's more to come on, you know,
660
00:32:24.690 --> 00:32:27.360
what tools are gonna look like moving forward,
661
00:32:27.360 --> 00:32:30.363
but right now this is how everything looks here.
662
00:32:31.260 --> 00:32:33.660
And again, the commitment data is available the day
663
00:32:33.660 --> 00:32:36.710
after the award is set up and completed in PeopleSoft.
664
00:32:38.160 --> 00:32:41.130
This is just a summary of what I hopefully just went over.
665
00:32:41.130 --> 00:32:42.930
So name and id, I didn't mention that,
666
00:32:42.930 --> 00:32:45.030
but that's on, on the header option
667
00:32:45.030 --> 00:32:48.090
to change this fiscal year, alert is there
668
00:32:48.090 --> 00:32:50.460
if there's a pending salary distribution
669
00:32:50.460 --> 00:32:54.240
and a button to access the commitment page
670
00:32:54.240 --> 00:32:55.350
to document your review.
671
00:32:55.350 --> 00:32:58.020
So that's the comments page,
672
00:32:58.020 --> 00:33:00.870
so we'll go over that again in a little bit.
673
00:33:00.870 --> 00:33:04.233
The commitment data as I mentioned, it has the PeopleSoft
674
00:33:04.233 --> 00:33:06.810
and Qlik number, project number, project description,
675
00:33:06.810 --> 00:33:11.810
a go to button tells you the class project role,
676
00:33:11.940 --> 00:33:13.770
we've gone over all of this.
677
00:33:13.770 --> 00:33:15.670
Okay, so I didn't miss anything there.
678
00:33:19.170 --> 00:33:24.170
The next tab over in this is distributions by person.
679
00:33:24.390 --> 00:33:25.680
Again, it'll let you know
680
00:33:25.680 --> 00:33:27.690
if there's an outstanding distribution
681
00:33:27.690 --> 00:33:29.580
request for that individual.
682
00:33:29.580 --> 00:33:31.530
It will default to the current fiscal year.
683
00:33:31.530 --> 00:33:34.050
Again, my examples last year's,
684
00:33:34.050 --> 00:33:36.690
this does not include additional pays,
685
00:33:36.690 --> 00:33:39.120
so this is strictly salary distribution.
686
00:33:39.120 --> 00:33:41.310
So if somebody has a summer commitment
687
00:33:41.310 --> 00:33:43.020
for those nine month faculty,
688
00:33:43.020 --> 00:33:44.580
you're not gonna see that in here.
689
00:33:44.580 --> 00:33:49.020
So you're gonna need to know
690
00:33:49.020 --> 00:33:53.880
what you've submitted and go into PeopleSoft HR
691
00:33:53.880 --> 00:33:55.020
and look up that individual
692
00:33:55.020 --> 00:33:57.540
and make sure everything that is supposed
693
00:33:57.540 --> 00:34:01.050
to be submitted for that individual is in progress,
694
00:34:01.050 --> 00:34:03.873
obviously when we get close to the summer months.
695
00:34:08.220 --> 00:34:10.590
Yeah, you actually will have to click on this,
696
00:34:10.590 --> 00:34:13.260
get payroll distributions in order to see that data.
697
00:34:13.260 --> 00:34:14.700
It won't actually default in
698
00:34:14.700 --> 00:34:17.820
so you just gotta click the button for some reason
699
00:34:17.820 --> 00:34:22.170
and then all the columns are able to be sorted,
700
00:34:22.170 --> 00:34:24.903
so you can click on any of these to sort them.
701
00:34:26.190 --> 00:34:28.320
You can click on the chart field button
702
00:34:28.320 --> 00:34:29.340
to see all the chart fields.
703
00:34:29.340 --> 00:34:31.470
I tend to click on this button here,
704
00:34:31.470 --> 00:34:33.120
which will give you all the information
705
00:34:33.120 --> 00:34:33.990
you see on my screen now,
706
00:34:33.990 --> 00:34:36.390
but also all of the chart fields,
707
00:34:36.390 --> 00:34:37.920
but even without the chart fields,
708
00:34:37.920 --> 00:34:39.963
this will give you information based on
709
00:34:39.963 --> 00:34:41.640
what the function code is.
710
00:34:41.640 --> 00:34:46.640
So you know, you wanna see the cost share,
711
00:34:48.810 --> 00:34:50.103
you can sort by that,
712
00:34:52.230 --> 00:34:53.063
but to me,
713
00:34:53.063 --> 00:34:54.900
like you don't have the project number right here.
714
00:34:54.900 --> 00:34:57.630
So without clicking on here, okay,
715
00:34:57.630 --> 00:34:59.220
yeah this is cost share, (laughing)
716
00:34:59.220 --> 00:35:02.790
but what award, oh actually no, sorry, it's over here.
717
00:35:04.260 --> 00:35:05.430
I do have these red lines here.
718
00:35:05.430 --> 00:35:08.040
So anybody who's familiar with salary distributions
719
00:35:08.040 --> 00:35:11.490
can kind of get familiar with this here pretty quickly,
720
00:35:11.490 --> 00:35:14.700
but basically this is effective start
721
00:35:14.700 --> 00:35:16.830
and end date of the distribution.
722
00:35:16.830 --> 00:35:21.360
So these are gonna add up to a 100%
723
00:35:21.360 --> 00:35:26.360
for this UVM salary for this individual from 7/1 to 9/30.
724
00:35:27.660 --> 00:35:31.200
And then it switches, that one ends
725
00:35:31.200 --> 00:35:33.720
and this new allocation starts as of 10/1,
726
00:35:33.720 --> 00:35:35.520
and that goes through February,
727
00:35:35.520 --> 00:35:38.790
excuse me, December 31st (laughing)
728
00:35:38.790 --> 00:35:42.160
and then again it switches again starting January 1st
729
00:35:43.080 --> 00:35:44.830
through the end of the fiscal year.
730
00:35:46.980 --> 00:35:48.510
Again, you can do a range
731
00:35:48.510 --> 00:35:51.000
of fiscal years here if you wanted
732
00:35:51.000 --> 00:35:54.000
or just put in the fiscal year you want,
733
00:35:54.000 --> 00:35:56.150
but it's gonna default to the current year.
734
00:35:57.990 --> 00:36:01.590
Another thing to look for here is
735
00:36:01.590 --> 00:36:04.230
if there's anything in department suspense.
736
00:36:04.230 --> 00:36:08.160
So again, you'd click on to see all the chart fields.
737
00:36:08.160 --> 00:36:10.620
It's just a way, you're already talking with them.
738
00:36:10.620 --> 00:36:12.030
Is there something in suspense
739
00:36:12.030 --> 00:36:13.530
that should be a trigger to you?
740
00:36:13.530 --> 00:36:14.490
Is something set up?
741
00:36:14.490 --> 00:36:17.010
Are we still waiting for approval
742
00:36:17.010 --> 00:36:18.243
for a sponsor?
743
00:36:19.230 --> 00:36:20.820
Has the sponsor said that it's been denied?
744
00:36:20.820 --> 00:36:22.257
Like what do we need to do with this effort
745
00:36:22.257 --> 00:36:24.630
and suspense from previous quarters
746
00:36:24.630 --> 00:36:26.643
and maybe the upcoming quarter?
747
00:36:29.730 --> 00:36:30.810
So same thing,
748
00:36:30.810 --> 00:36:34.953
we have the name employee D option change fiscal year,
749
00:36:35.850 --> 00:36:37.200
additional pays are not there.
750
00:36:37.200 --> 00:36:39.333
Alert if there's pending distribution.
751
00:36:42.630 --> 00:36:43.620
Actually lemme go back.
752
00:36:43.620 --> 00:36:48.620
So it does have a project description over here.
753
00:36:48.960 --> 00:36:51.240
Oh it does include the employee record number.
754
00:36:51.240 --> 00:36:56.240
So sometimes people may switch an employee record
755
00:36:56.670 --> 00:36:58.290
or if they have a dual appointment,
756
00:36:58.290 --> 00:37:00.270
you'll see both employee records there.
757
00:37:00.270 --> 00:37:02.193
You'd probably wanna sort by that.
758
00:37:05.190 --> 00:37:07.530
It does have your home department
759
00:37:07.530 --> 00:37:11.643
and your percentages, so.
760
00:37:13.110 --> 00:37:15.693
I've gone through all of that detail,
761
00:37:19.290 --> 00:37:22.560
going back to the commitment by person page,
762
00:37:22.560 --> 00:37:26.490
so we're gonna go over this add comments field.
763
00:37:26.490 --> 00:37:31.320
So this will open up into a new tab
764
00:37:31.320 --> 00:37:33.840
and this is where again, you're gonna wanna display
765
00:37:33.840 --> 00:37:38.520
your comments about the review you just had
766
00:37:38.520 --> 00:37:43.520
with that individual, especially any action items.
767
00:37:43.710 --> 00:37:45.192
So for instance, like I just said,
768
00:37:45.192 --> 00:37:47.670
this person's in department suspense award,
769
00:37:47.670 --> 00:37:49.650
A, B, C, D has been awarded and set up,
770
00:37:49.650 --> 00:37:53.130
now I need to distribute X percentage to that award.
771
00:37:53.130 --> 00:37:55.020
That might be your action item
772
00:37:55.020 --> 00:37:59.740
and a comment you wanna put on after your review
773
00:38:01.440 --> 00:38:03.480
and be sure to click the save button.
774
00:38:03.480 --> 00:38:07.293
So this is what the comment field looks like.
775
00:38:08.520 --> 00:38:11.040
You can add additional comments here,
776
00:38:11.040 --> 00:38:12.030
you can delete them,
777
00:38:12.030 --> 00:38:14.490
anyone can delete them, so be careful
778
00:38:14.490 --> 00:38:18.390
and if auditors request information,
779
00:38:18.390 --> 00:38:20.670
which has started to happen, asking
780
00:38:20.670 --> 00:38:24.240
for documentation of the quarterly reviews.
781
00:38:24.240 --> 00:38:26.790
So if it's here we can provide it to them,
782
00:38:26.790 --> 00:38:28.890
but whatever's here, we're not gonna edit.
783
00:38:28.890 --> 00:38:31.353
So be careful (laughing) of what you say,
784
00:38:32.250 --> 00:38:34.890
but also be detailed enough
785
00:38:34.890 --> 00:38:38.190
so that you know when you come back to this the next time
786
00:38:38.190 --> 00:38:41.640
or somebody else gets assigned to that faculty member
787
00:38:41.640 --> 00:38:43.830
that they have the details needed to know
788
00:38:43.830 --> 00:38:47.740
what action items were pending after your review
789
00:38:50.520 --> 00:38:53.400
and what was reviewed during that time period.
790
00:38:53.400 --> 00:38:54.720
So I mean, right now
791
00:38:54.720 --> 00:38:58.470
I've only gone over reviewing effort commitments
792
00:38:58.470 --> 00:39:01.350
and actual effort for the individual
793
00:39:01.350 --> 00:39:03.090
for this faculty member,
794
00:39:03.090 --> 00:39:05.280
but really wanna come back to this faculty member
795
00:39:05.280 --> 00:39:07.230
after you've gone through each of their projects
796
00:39:07.230 --> 00:39:08.670
and reviewed the personnel on them
797
00:39:08.670 --> 00:39:11.340
to know if there's any other action items
798
00:39:11.340 --> 00:39:12.360
and to just really document
799
00:39:12.360 --> 00:39:14.610
that you have looked at each of the projects.
800
00:39:15.630 --> 00:39:18.690
I'll go over looking at pending proposals
801
00:39:18.690 --> 00:39:20.550
and Qlik towards the end,
802
00:39:20.550 --> 00:39:23.730
but this is a recommendation of note to put in here,
803
00:39:23.730 --> 00:39:27.630
so you can kind of have an ongoing list of pending proposals
804
00:39:27.630 --> 00:39:28.920
and have a conversation about 'em,
805
00:39:28.920 --> 00:39:30.090
and that's something you might wanna do
806
00:39:30.090 --> 00:39:32.010
before you meet with the faculty member.
807
00:39:32.010 --> 00:39:35.190
Just look at all the pending proposals
808
00:39:35.190 --> 00:39:36.690
and their commitments on those.
809
00:39:36.690 --> 00:39:37.950
Know what's coming up,
810
00:39:37.950 --> 00:39:39.420
being able to have a conversation
811
00:39:39.420 --> 00:39:41.160
of was it awarded?
812
00:39:41.160 --> 00:39:42.090
Is it pending set up?
813
00:39:42.090 --> 00:39:44.013
Do we need to get an advanced account?
814
00:39:45.169 --> 00:39:46.680
And, so on.
815
00:39:46.680 --> 00:39:49.380
And this is a good example of really when you're done
816
00:39:49.380 --> 00:39:54.180
with the full review of individuals on an award,
817
00:39:54.180 --> 00:39:55.380
what a note would look like.
818
00:39:55.380 --> 00:39:59.130
So quarterly review was done,
819
00:39:59.130 --> 00:40:02.670
reviewed all of his commitments and actual effort
820
00:40:02.670 --> 00:40:05.010
and there are no effort corrections needed for last quarter
821
00:40:05.010 --> 00:40:07.080
or the upcoming quarter for him.
822
00:40:07.080 --> 00:40:10.020
Need to initiate a no-cost extension for
823
00:40:10.020 --> 00:40:12.093
project 1, 2, 3, 4, 5, 6,
824
00:40:13.230 --> 00:40:16.140
reviewed personnel effort on his projects,
825
00:40:16.140 --> 00:40:18.000
and graduate student Jamie Smith
826
00:40:18.000 --> 00:40:19.950
or John Smith is not distributed
827
00:40:19.950 --> 00:40:24.720
to project (laughing) 9 8 7 6 5 4.
828
00:40:24.720 --> 00:40:28.470
Notified their administrator via the notify button
829
00:40:28.470 --> 00:40:29.823
in that project.
830
00:40:30.840 --> 00:40:33.390
And so most of these pages will have a notify button.
831
00:40:33.390 --> 00:40:35.520
I really like the one
832
00:40:35.520 --> 00:40:38.580
right out of the actual project itself
833
00:40:38.580 --> 00:40:40.770
'cause it gives you a link to that project
834
00:40:40.770 --> 00:40:42.390
for that business manager if they want,
835
00:40:42.390 --> 00:40:44.670
and so I'll show you that in a little bit.
836
00:40:44.670 --> 00:40:48.370
But again, you don't get that your user data ID
837
00:40:49.410 --> 00:40:51.840
and timestamp until you click save.
838
00:40:51.840 --> 00:40:53.917
When I was first testing this with Susan SKoga, I was like,
839
00:40:53.917 --> 00:40:56.820
"My notes aren't saving, like it's not working."
840
00:40:56.820 --> 00:40:58.170
And she's like, "Are you clicking save?"
841
00:40:58.170 --> 00:41:00.570
I'm like, "Well I guess not." (laughing)
842
00:41:00.570 --> 00:41:01.403
Because like I said,
843
00:41:01.403 --> 00:41:03.450
it opens up into a new tab
844
00:41:03.450 --> 00:41:05.280
and so it's so tempting to just x out
845
00:41:05.280 --> 00:41:08.340
of the tab without having saved your notes.
846
00:41:08.340 --> 00:41:10.920
So that will always be my word of caution
847
00:41:10.920 --> 00:41:12.333
to you to be sure to save.
848
00:41:17.340 --> 00:41:22.320
All right, I am going to switch over
849
00:41:22.320 --> 00:41:27.320
to showing you a demo
850
00:41:27.630 --> 00:41:30.480
of that part so far.
851
00:41:30.480 --> 00:41:32.620
So again, for me, I default essential user
852
00:41:33.570 --> 00:41:36.330
if you don't already default to UVM employee,
853
00:41:36.330 --> 00:41:37.770
you wanna switch to that.
854
00:41:37.770 --> 00:41:40.560
You should have a UVM PI portal tab.
855
00:41:40.560 --> 00:41:41.890
You can just click on that
856
00:41:43.320 --> 00:41:46.560
and it's the second menu option below here.
857
00:41:46.560 --> 00:41:49.470
Again, you can look up by department
858
00:41:49.470 --> 00:41:53.460
and you'll get all of the individuals
859
00:41:53.460 --> 00:41:55.773
that have had commitments set up in the past.
860
00:41:56.700 --> 00:41:58.590
You'll see these are all the ones
861
00:41:58.590 --> 00:42:01.530
that have had comments entered on 'em,
862
00:42:01.530 --> 00:42:02.675
so you could go in
863
00:42:02.675 --> 00:42:06.873
and see the commitments in the history here,
864
00:42:08.580 --> 00:42:11.700
so this is a good example of using this.
865
00:42:11.700 --> 00:42:14.340
And so anyone that goes to help this individual,
866
00:42:14.340 --> 00:42:17.670
this PI later on has that history
867
00:42:17.670 --> 00:42:20.760
and can pick up if needed.
868
00:42:20.760 --> 00:42:23.310
But going back to the search,
869
00:42:23.310 --> 00:42:25.260
there are some historic information here.
870
00:42:25.260 --> 00:42:28.050
So you have some old individuals where...
871
00:42:28.050 --> 00:42:33.030
Well not old individuals, but old commitments
872
00:42:33.030 --> 00:42:37.037
from years ago when staff used to require
873
00:42:39.210 --> 00:42:41.130
a direct cost justification for staff
874
00:42:41.130 --> 00:42:43.530
to be distributed on an award.
875
00:42:43.530 --> 00:42:46.530
And so the system sees these from long ago,
876
00:42:46.530 --> 00:42:50.040
but there's nothing here,
877
00:42:50.040 --> 00:42:51.390
that's why you don't see any comments
878
00:42:51.390 --> 00:42:53.340
from Mindy in this case
879
00:42:53.340 --> 00:42:55.980
because it's old historic information.
880
00:42:55.980 --> 00:42:56.970
It's gonna list them,
881
00:42:56.970 --> 00:42:59.170
but you don't need to do anything with them.
882
00:43:00.210 --> 00:43:02.700
Once you start to go through all the individuals
883
00:43:02.700 --> 00:43:03.540
in your department,
884
00:43:03.540 --> 00:43:05.580
if you haven't already, you'll get to know,
885
00:43:05.580 --> 00:43:08.763
okay, these ones I don't need to do. (laughing)
886
00:43:12.173 --> 00:43:15.153
and you can also go by name.
887
00:43:18.090 --> 00:43:22.650
And so again, click on any of that is all hyperlink.
888
00:43:22.650 --> 00:43:24.990
And so here, like I said,
889
00:43:24.990 --> 00:43:27.180
it defaults to the current fiscal year.
890
00:43:27.180 --> 00:43:28.377
You have all your information.
891
00:43:28.377 --> 00:43:29.863
I'm just gonna collapse this
892
00:43:29.863 --> 00:43:31.513
so you can see a little bit more.
893
00:43:32.640 --> 00:43:34.040
But again, I mean keep scrolling, which is why I had
894
00:43:34.040 --> 00:43:35.880
to put it on two slides,
895
00:43:35.880 --> 00:43:36.990
But yeah, this is the award title
896
00:43:36.990 --> 00:43:37.823
I think is the only thing
897
00:43:37.823 --> 00:43:39.690
I didn't end up having in there,
898
00:43:39.690 --> 00:43:42.240
'cause again, that might be the piece of information
899
00:43:42.240 --> 00:43:45.840
that the PI is familiar with as opposed to
900
00:43:45.840 --> 00:43:49.020
the project number or the award ID or project.
901
00:43:49.020 --> 00:43:51.470
You know, like they all have their different ways
902
00:43:52.500 --> 00:43:54.873
of recognizing which awards they're working on.
903
00:43:56.160 --> 00:43:58.290
And so again, if you wanted to see
904
00:43:58.290 --> 00:43:59.910
what were the commitments last year,
905
00:43:59.910 --> 00:44:02.013
you can limit by fiscal year.
906
00:44:05.100 --> 00:44:06.207
So it seems like this year
907
00:44:06.207 --> 00:44:09.600
there's less commitments for this one,
908
00:44:09.600 --> 00:44:11.490
a little more easily able to be managed.
909
00:44:11.490 --> 00:44:12.690
Oh, and I forgot to put mention this.
910
00:44:12.690 --> 00:44:15.390
So project status, you can see which awards are closed,
911
00:44:15.390 --> 00:44:17.403
which had an advanced account.
912
00:44:18.480 --> 00:44:21.630
You can see the end date again of the commitment,
913
00:44:21.630 --> 00:44:23.763
not necessarily the project.
914
00:44:26.640 --> 00:44:30.570
And then you'd switch over to the distribution by person
915
00:44:30.570 --> 00:44:32.820
and again, see how it defaults to this fiscal year.
916
00:44:32.820 --> 00:44:36.480
You do have to press the button. (laughing)
917
00:44:36.480 --> 00:44:37.410
Oh, this one now has
918
00:44:37.410 --> 00:44:39.600
outstanding distribution change requests for this person.
919
00:44:39.600 --> 00:44:41.813
I don't think it did last week when I was looking at it.
920
00:44:43.347 --> 00:44:45.690
And so this is her entire distribution request.
921
00:44:45.690 --> 00:44:47.540
So there's a lot of information here,
922
00:44:49.019 --> 00:44:52.380
but you can see like this is where
923
00:44:52.380 --> 00:44:53.670
it switches over from.
924
00:44:53.670 --> 00:44:58.670
So July and August were the same distribution
925
00:44:58.860 --> 00:45:02.610
and then it switched, there's a change in September.
926
00:45:02.610 --> 00:45:04.950
So whether this busy, it might just be easier
927
00:45:04.950 --> 00:45:08.010
to run the distribution and have the form in front of you,
928
00:45:08.010 --> 00:45:09.300
but this is a tool here,
929
00:45:09.300 --> 00:45:11.310
if you wanted to just be able to go back and forth
930
00:45:11.310 --> 00:45:15.780
and say, "All right, well she's telling me she didn't
931
00:45:15.780 --> 00:45:19.413
work as much on this award.
932
00:45:21.660 --> 00:45:23.520
Well what did we already enter
933
00:45:23.520 --> 00:45:24.780
and did we already discuss that?"
934
00:45:24.780 --> 00:45:26.130
And you can just come over
935
00:45:26.130 --> 00:45:27.630
and look over here to see that.
936
00:45:27.630 --> 00:45:32.070
So different ways to use that.
937
00:45:32.070 --> 00:45:35.430
Again, this is the comment button,
938
00:45:35.430 --> 00:45:37.353
again it opens into a new page,
939
00:45:39.390 --> 00:45:41.790
defaults to having a comment here.
940
00:45:41.790 --> 00:45:45.570
I like to just always have more space,
941
00:45:45.570 --> 00:45:50.570
just my idiosyncrasies, but you won't get that user ID
942
00:45:51.990 --> 00:45:53.610
and last updated date
943
00:45:53.610 --> 00:45:58.570
until you save, I'm gonna save it,
944
00:46:01.034 --> 00:46:03.510
and now you see this here, it's still editable.
945
00:46:03.510 --> 00:46:06.813
I don't even know if we need this edit box,
946
00:46:08.280 --> 00:46:11.733
but again, anybody could come in and also delete it.
947
00:46:13.345 --> 00:46:14.760
I'm gonna save that delete
948
00:46:14.760 --> 00:46:17.210
because this is the (laughing) production system.
949
00:46:20.340 --> 00:46:25.110
Is there any questions on really using the commitment
950
00:46:25.110 --> 00:46:29.220
by person for the sponsored effort commitments tools here?
951
00:46:29.220 --> 00:46:31.220
Again, we're just looking at the person.
952
00:46:35.400 --> 00:46:38.490
All right, I think all the questions were answered
953
00:46:38.490 --> 00:46:39.323
as we went
954
00:46:40.350 --> 00:46:45.123
and then going to bring the presentation back up.
955
00:46:51.106 --> 00:46:54.060
It always used to default to this screen and now it's not.
956
00:46:54.060 --> 00:46:56.660
I don't know why today is different, but here we go.
957
00:46:57.600 --> 00:47:00.300
So the next piece is looking at
958
00:47:00.300 --> 00:47:02.340
the individuals on the project.
959
00:47:02.340 --> 00:47:04.950
So the PI and co-PI are responsible
960
00:47:04.950 --> 00:47:07.200
for making sure all the other individuals
961
00:47:07.200 --> 00:47:11.440
on the project are being charged appropriately
962
00:47:12.540 --> 00:47:14.397
and that's required to be done quarterly as well.
963
00:47:14.397 --> 00:47:18.450
And so the PI portal search by project tool's
964
00:47:18.450 --> 00:47:20.160
gonna give you some options for that.
965
00:47:20.160 --> 00:47:22.800
So there's two ways to access the project.
966
00:47:22.800 --> 00:47:24.060
You can just come here
967
00:47:24.060 --> 00:47:29.060
and you can enter the project number one by one
968
00:47:29.130 --> 00:47:33.540
or when you're in the sponsored effort commitment page for
969
00:47:33.540 --> 00:47:37.470
that person, you can just click on the project
970
00:47:37.470 --> 00:47:39.270
and it'll bring you right into that.
971
00:47:42.960 --> 00:47:45.180
When you're in the the PI portal,
972
00:47:45.180 --> 00:47:46.710
there's the personnel commitments.
973
00:47:46.710 --> 00:47:51.660
And so this will give you the PI
974
00:47:51.660 --> 00:47:54.930
as well as any faculty or other key personnel set up.
975
00:47:54.930 --> 00:47:57.240
So this is where you're gonna see that
976
00:47:57.240 --> 00:47:59.880
and be able to have conversations around it.
977
00:47:59.880 --> 00:48:02.040
So down below you have the start
978
00:48:02.040 --> 00:48:03.660
and end date of the commitment,
979
00:48:03.660 --> 00:48:07.380
up here you have the start and end date of the project.
980
00:48:07.380 --> 00:48:11.133
You also have the sponsor id, the PeopleSoft
981
00:48:11.133 --> 00:48:14.043
and click ID and the project number.
982
00:48:24.630 --> 00:48:25.910
Lemme just make sure I went through all this.
983
00:48:25.910 --> 00:48:29.640
It was key faculty and keeper personnel, project role,
984
00:48:29.640 --> 00:48:32.220
so it's gonna give you the role
985
00:48:32.220 --> 00:48:36.870
and so it'll leave the employee class blank
986
00:48:36.870 --> 00:48:39.480
if that person's no longer has active
987
00:48:39.480 --> 00:48:41.260
in that employee record
988
00:48:42.180 --> 00:48:44.580
or no longer has an active employee record,
989
00:48:44.580 --> 00:48:46.560
and so that's a good thing to look for.
990
00:48:46.560 --> 00:48:49.980
And so if in this case you would say, well, you know, okay,
991
00:48:49.980 --> 00:48:52.890
well this is a really old commitment
992
00:48:52.890 --> 00:48:57.270
that person's gone and Christina was hired in his place
993
00:48:57.270 --> 00:49:00.930
or maybe you weren't expecting to see this be blank
994
00:49:00.930 --> 00:49:04.560
and it was a key personnel and so you need to address that.
995
00:49:04.560 --> 00:49:06.510
So just kinda looking for that blank there
996
00:49:06.510 --> 00:49:08.640
and are there any questions that come up
997
00:49:08.640 --> 00:49:11.190
based on the fact that this person's no longer at UVM
998
00:49:11.190 --> 00:49:12.440
but there's a commitment.
999
00:49:13.380 --> 00:49:17.580
SPA is only going to make adjustments to the commitment
1000
00:49:17.580 --> 00:49:19.050
if that's a key personnel
1001
00:49:19.050 --> 00:49:20.580
and you get prior approval for,
1002
00:49:20.580 --> 00:49:22.770
otherwise that's something you would just put
1003
00:49:22.770 --> 00:49:25.650
in your notes section that we went through earlier
1004
00:49:25.650 --> 00:49:29.880
of why that person is either reduced
1005
00:49:29.880 --> 00:49:31.470
or they're not UVM anymore
1006
00:49:31.470 --> 00:49:34.053
and so and so has taken over that role.
1007
00:49:36.510 --> 00:49:39.000
And then just kind of as you scroll on,
1008
00:49:39.000 --> 00:49:42.420
you'll see what we saw earlier, but for all individuals.
1009
00:49:42.420 --> 00:49:46.050
So you'll see the academic, the calendar
1010
00:49:46.050 --> 00:49:47.370
and the summer periods,
1011
00:49:47.370 --> 00:49:48.720
and the breakdown for that.
1012
00:49:55.825 --> 00:49:58.110
This I just gonna put it all on one page to see,
1013
00:49:58.110 --> 00:50:03.110
oh, and this is a really useful place to use your notes
1014
00:50:05.490 --> 00:50:10.380
because it will provide information in the email already.
1015
00:50:10.380 --> 00:50:13.980
So this is an example if you used it from that page,
1016
00:50:13.980 --> 00:50:16.680
it would actually bring you right into that commitments tab
1017
00:50:16.680 --> 00:50:21.680
and you could say "Please set up a distribution change
1018
00:50:21.840 --> 00:50:23.820
to have Christina's effort allocated
1019
00:50:23.820 --> 00:50:28.050
to project number before the 90 days past
1020
00:50:28.050 --> 00:50:30.660
the payroll has been reached."
1021
00:50:30.660 --> 00:50:33.660
So like it'll bring 'em right into that page
1022
00:50:33.660 --> 00:50:37.170
and you will also need to enter
1023
00:50:37.170 --> 00:50:41.623
the subject line for that as well.
1024
00:50:41.623 --> 00:50:44.760
But it's a just a easy way for them
1025
00:50:44.760 --> 00:50:47.010
to be able to see the information themselves,
1026
00:50:47.010 --> 00:50:48.960
and you don't have to type it all out again
1027
00:50:48.960 --> 00:50:52.143
'cause it's right in the email, it started for you.
1028
00:50:55.770 --> 00:50:58.200
All right, so effort verifications in PeopleSoft.
1029
00:50:58.200 --> 00:51:02.460
The objectives are to perform an after the fact review.
1030
00:51:02.460 --> 00:51:03.660
Yep.
1031
00:51:03.660 --> 00:51:05.610
We have a question in the chat.
1032
00:51:05.610 --> 00:51:08.460
Sarah Powell asks if you can talk about
1033
00:51:08.460 --> 00:51:11.250
how this data is pulled into ERS
1034
00:51:11.250 --> 00:51:14.163
and the commitments seem to match the employment class.
1035
00:51:18.900 --> 00:51:19.733
Lemme go back.
1036
00:51:23.940 --> 00:51:28.940
So the reason for this breakdown was historically
1037
00:51:31.380 --> 00:51:36.003
for the way data came over to ERS and still does.
1038
00:51:36.840 --> 00:51:39.690
So if somebody is a nine month faculty,
1039
00:51:39.690 --> 00:51:44.690
the programs to get the data out of PeopleSoft
1040
00:51:45.913 --> 00:51:48.330
for commitment data in ERS is to say,
1041
00:51:48.330 --> 00:51:50.790
Well this is a nine month faculty,
1042
00:51:50.790 --> 00:51:54.380
it's gonna look for commitments entered in academic,
1043
00:51:54.380 --> 00:51:55.680
in academic cost share,
1044
00:51:55.680 --> 00:51:58.110
and it's gonna look for commitments in summer
1045
00:51:58.110 --> 00:52:00.330
and summer cost share to be able
1046
00:52:00.330 --> 00:52:04.020
to put it into the correct places in ERS.
1047
00:52:04.020 --> 00:52:06.090
So if you have a nine month faculty
1048
00:52:06.090 --> 00:52:09.240
but you're seeing commitments set up under calendar,
1049
00:52:09.240 --> 00:52:11.610
then you're not gonna get the benefit
1050
00:52:11.610 --> 00:52:14.130
of that commitment data in ERS.
1051
00:52:14.130 --> 00:52:15.720
It'll come over as blank data
1052
00:52:15.720 --> 00:52:19.200
because it's a nine month faculty, it's looking here
1053
00:52:19.200 --> 00:52:21.930
but it was set up incorrectly and put in calendar.
1054
00:52:21.930 --> 00:52:25.096
And so when it looks for academic, it's gonna be blank,
1055
00:52:25.096 --> 00:52:27.240
when it looks for summer, it's gonna be blank.
1056
00:52:27.240 --> 00:52:30.150
And so you're gonna get blank data into ERS
1057
00:52:30.150 --> 00:52:33.780
for when you go to do effort certification.
1058
00:52:33.780 --> 00:52:37.800
And so it's a good tool for the certification
1059
00:52:37.800 --> 00:52:41.700
as well because it alerts you to the fact that...
1060
00:52:41.700 --> 00:52:44.250
Especially if somebody has zero (laughing)
1061
00:52:44.250 --> 00:52:47.640
amounts distributed to an award that they're a PI on
1062
00:52:47.640 --> 00:52:50.130
and have a commitment on, you want that alert to tell you,
1063
00:52:50.130 --> 00:52:51.750
oh wait, we need to have a conversation about this
1064
00:52:51.750 --> 00:52:53.790
before we certify your effort.
1065
00:52:53.790 --> 00:52:58.790
And so you really wanna be making sure here it's 12 month
1066
00:52:58.920 --> 00:53:01.470
that it's under calendar and calendar cost share.
1067
00:53:01.470 --> 00:53:02.877
If they're nine month, they're under academic
1068
00:53:02.877 --> 00:53:05.580
and academic cost somewhere,
1069
00:53:05.580 --> 00:53:08.103
because it does have an impact down the road.
1070
00:53:12.540 --> 00:53:14.070
And if you see it in the wrong place,
1071
00:53:14.070 --> 00:53:17.823
email SPA at SPA.uvm.edu.
1072
00:53:20.700 --> 00:53:25.700
All right, so the question was,
1073
00:53:30.060 --> 00:53:31.980
if someone was proposed as 12 months,
1074
00:53:31.980 --> 00:53:34.800
but their appointment changed to nine months,
1075
00:53:34.800 --> 00:53:38.343
does this mean we need to change the math and change this?
1076
00:53:40.680 --> 00:53:44.940
That is a good question and historically we have not.
1077
00:53:44.940 --> 00:53:47.820
So SPA isn't in the business
1078
00:53:47.820 --> 00:53:52.820
of managing data entry all the time for that.
1079
00:53:53.610 --> 00:53:57.180
So historically that's been very rare
1080
00:53:57.180 --> 00:54:00.420
where people go from 9 to 12 and 12 to 9,
1081
00:54:00.420 --> 00:54:01.833
but it does happen.
1082
00:54:03.180 --> 00:54:08.040
And so in those cases, the commitment and information,
1083
00:54:08.040 --> 00:54:13.040
because usually those people have a lot of commitments.
1084
00:54:13.050 --> 00:54:15.810
It's not just a new commitment going forward,
1085
00:54:15.810 --> 00:54:19.493
and so no, there hasn't been action
1086
00:54:20.820 --> 00:54:22.830
to go back to all the other awards
1087
00:54:22.830 --> 00:54:23.940
that have already been set up
1088
00:54:23.940 --> 00:54:25.890
and recalculate all that information
1089
00:54:25.890 --> 00:54:26.943
and set them up.
1090
00:54:29.340 --> 00:54:34.260
I mean that's been the kind of the decision.
1091
00:54:34.260 --> 00:54:36.120
If something's been proposed
1092
00:54:36.120 --> 00:54:41.040
and somebody changes before the award is awarded
1093
00:54:41.040 --> 00:54:45.090
and set up, I would say it would be up to the department
1094
00:54:45.090 --> 00:54:48.840
to reach out to SPA during award setup
1095
00:54:48.840 --> 00:54:50.220
and have that conversation
1096
00:54:50.220 --> 00:54:52.113
of how to adjust that if they want.
1097
00:54:53.070 --> 00:54:54.330
Keeping in mind though
1098
00:54:54.330 --> 00:54:59.050
that I know SPA is working on testing a new version
1099
00:55:00.282 --> 00:55:05.282
of Qlik that will be going to person months.
1100
00:55:06.600 --> 00:55:11.010
And so there are updates coming in the future,
1101
00:55:11.010 --> 00:55:14.580
hopefully of how that is handled
1102
00:55:14.580 --> 00:55:15.900
and then what the implications
1103
00:55:15.900 --> 00:55:17.490
that will have on the project team page
1104
00:55:17.490 --> 00:55:19.560
and then implications on how we handle ERS.
1105
00:55:19.560 --> 00:55:21.390
So like for right now, no,
1106
00:55:21.390 --> 00:55:25.980
there isn't a recalculation between 9 and 12 or 12 to 9.
1107
00:55:25.980 --> 00:55:29.670
And so the commitments information in ERS
1108
00:55:29.670 --> 00:55:32.883
tends to end up being blank,
1109
00:55:34.800 --> 00:55:38.073
which is unfortunate, but again that's tends to be rare.
1110
00:55:41.160 --> 00:55:44.133
Okay, those are good questions.
1111
00:55:45.630 --> 00:55:48.000
Okay, so objectives for effort verification
1112
00:55:48.000 --> 00:55:50.640
is to perform an after the fact review of interim charges,
1113
00:55:50.640 --> 00:55:53.070
so what has happened in the last three months
1114
00:55:53.070 --> 00:55:56.370
and perform a perspective review of what's anticipated
1115
00:55:56.370 --> 00:55:57.780
for the coming three months.
1116
00:55:57.780 --> 00:56:00.420
So you're really looking at a six month span,
1117
00:56:00.420 --> 00:56:02.970
and if you can go beyond that, great,
1118
00:56:02.970 --> 00:56:04.500
especially the beginning of a fiscal year.
1119
00:56:04.500 --> 00:56:08.610
I mean we're getting to the end of FY24 already.
1120
00:56:08.610 --> 00:56:12.300
I don't really know how, but you're not gonna be able
1121
00:56:12.300 --> 00:56:15.780
to do salary distributions right now for FY25,
1122
00:56:15.780 --> 00:56:19.020
although you're gonna start doing budget building.
1123
00:56:19.020 --> 00:56:21.393
And so you're gonna have an idea of, all right,
1124
00:56:22.980 --> 00:56:25.203
this faculty member has a number of awards,
1125
00:56:26.040 --> 00:56:27.780
or proposals out there,
1126
00:56:27.780 --> 00:56:32.130
what should we put into department suspense
1127
00:56:32.130 --> 00:56:34.260
in anticipation of those getting awarded
1128
00:56:34.260 --> 00:56:35.130
during budget building?
1129
00:56:35.130 --> 00:56:37.410
You know like, so that's kind of right now
1130
00:56:37.410 --> 00:56:38.880
how you can go beyond the three months,
1131
00:56:38.880 --> 00:56:43.880
but go as far as you can, reasonably can.
1132
00:56:43.950 --> 00:56:45.030
Again document the scope
1133
00:56:45.030 --> 00:56:46.920
of your review and resulting action items
1134
00:56:46.920 --> 00:56:48.753
and complete those action items.
1135
00:56:51.360 --> 00:56:56.220
You're gonna be preparing for your meetings with the PIs,
1136
00:56:56.220 --> 00:56:58.503
looking at what's proposed out there.
1137
00:56:59.490 --> 00:57:00.323
When you meet with them,
1138
00:57:00.323 --> 00:57:02.310
you'll review their individual effort,
1139
00:57:02.310 --> 00:57:05.940
you'll review project personnel if they're PIs,
1140
00:57:05.940 --> 00:57:08.160
you'll document and work on your action items,
1141
00:57:08.160 --> 00:57:09.690
and it's just this quarterly verification
1142
00:57:09.690 --> 00:57:12.843
that goes around and round and round. (laughing)
1143
00:57:21.630 --> 00:57:24.900
we already went over the personnel commitments.
1144
00:57:24.900 --> 00:57:27.330
So that's anyone who's set up with a commitment
1145
00:57:27.330 --> 00:57:30.330
and you can look at their distribution information,
1146
00:57:30.330 --> 00:57:33.810
but like I said before, the PI is responsible
1147
00:57:33.810 --> 00:57:36.300
for verifying non-key personnel on their award
1148
00:57:36.300 --> 00:57:38.190
who aren't gonna have commitments.
1149
00:57:38.190 --> 00:57:42.030
And so I've kind of outlined some tools for that.
1150
00:57:42.030 --> 00:57:43.260
So when you're in the PI portal
1151
00:57:43.260 --> 00:57:45.840
and if you're on the payroll information tab,
1152
00:57:45.840 --> 00:57:48.240
you need to click this payroll expenses to date.
1153
00:57:48.240 --> 00:57:51.363
And I noticed this morning actually as I was preparing,
1154
00:57:53.280 --> 00:57:56.283
that this takes a longer time now than it used to,
1155
00:57:57.240 --> 00:57:59.160
or at least an example I have today,
1156
00:57:59.160 --> 00:58:02.190
but also I noticed that it has over here
1157
00:58:02.190 --> 00:58:03.660
that I didn't notice until this morning
1158
00:58:03.660 --> 00:58:07.920
that you can click either sponsor paid or cost share.
1159
00:58:07.920 --> 00:58:10.050
I don't know if that's having any impact
1160
00:58:10.050 --> 00:58:11.850
on performance on it.
1161
00:58:11.850 --> 00:58:15.210
I don't know if anybody has been using this religiously
1162
00:58:15.210 --> 00:58:16.043
and seeing that,
1163
00:58:16.043 --> 00:58:19.170
somebody has definitely slowed down for that button,
1164
00:58:19.170 --> 00:58:21.633
I wonder if it's because of that breakdown,
1165
00:58:23.220 --> 00:58:26.580
but maybe we can put a footprint and kinda report that.
1166
00:58:26.580 --> 00:58:28.290
So I have one set up and already ready to go
1167
00:58:28.290 --> 00:58:29.460
that I can show you when I get there,
1168
00:58:29.460 --> 00:58:31.833
but yeah, you do need to to press the button.
1169
00:58:32.670 --> 00:58:33.840
What I like about this is
1170
00:58:33.840 --> 00:58:35.970
it has the account description right here,
1171
00:58:35.970 --> 00:58:37.860
but this is for the project as a whole.
1172
00:58:37.860 --> 00:58:41.670
It's not specifically for the budget period you're in,
1173
00:58:41.670 --> 00:58:44.730
so if it's at a five year award, it's gonna be cumulative.
1174
00:58:44.730 --> 00:58:45.750
It will give you anybody
1175
00:58:45.750 --> 00:58:50.070
who has salary distribution allocated to it.
1176
00:58:50.070 --> 00:58:52.140
But what I like about it is like you can...
1177
00:58:52.140 --> 00:58:53.550
I blocked out the names for this
1178
00:58:53.550 --> 00:58:55.200
'cause there are payroll dollars,
1179
00:58:56.520 --> 00:58:57.930
and this is out on the web,
1180
00:58:57.930 --> 00:59:00.660
so that's redacted for that purpose.
1181
00:59:00.660 --> 00:59:04.680
But like if you see grad student here
1182
00:59:04.680 --> 00:59:07.140
and they're not encumbered but they're supposed to be,
1183
00:59:07.140 --> 00:59:10.957
or that's your signal like
1184
00:59:10.957 --> 00:59:12.360
"All right, well maybe they're not here."
1185
00:59:12.360 --> 00:59:14.970
Or you see an old grad student
1186
00:59:14.970 --> 00:59:15.803
and your PI is like,
1187
00:59:15.803 --> 00:59:18.090
"Well no, now I have John Smith working on it,
1188
00:59:18.090 --> 00:59:20.100
why isn't John Smith allocated?"
1189
00:59:20.100 --> 00:59:22.720
So it's a great way to just have some conversations
1190
00:59:24.870 --> 00:59:26.373
to see if anyone's missing.
1191
00:59:28.980 --> 00:59:30.747
And then below that
1192
00:59:30.747 --> 00:59:34.080
you have the GET payroll distributions button.
1193
00:59:34.080 --> 00:59:36.300
Again, this is an older example,
1194
00:59:36.300 --> 00:59:38.280
but it's a good one that I was struggling
1195
00:59:38.280 --> 00:59:41.820
to find a current example that was as good,
1196
00:59:41.820 --> 00:59:44.970
but it will default to your current fiscal year.
1197
00:59:44.970 --> 00:59:48.213
You can limit it by employee ID number.
1198
00:59:51.990 --> 00:59:54.960
You can put in a range of fiscal years if you wanted.
1199
00:59:54.960 --> 00:59:58.620
Again, is anybody missing when you look at past
1200
00:59:58.620 --> 01:00:00.210
and future quarters under review?
1201
01:00:00.210 --> 01:00:02.640
'Cause if anybody is allocated,
1202
01:00:02.640 --> 01:00:03.810
even though they're not paid yet,
1203
01:00:03.810 --> 01:00:08.490
but if they're allocated for the next quarter,
1204
01:00:08.490 --> 01:00:10.650
they're gonna show up here,
1205
01:00:10.650 --> 01:00:12.720
or if they were allocated in the past
1206
01:00:12.720 --> 01:00:15.780
but no longer allocated, for instance,
1207
01:00:15.780 --> 01:00:17.520
maybe it was on advanced account
1208
01:00:17.520 --> 01:00:20.970
and it's been taken off advanced account
1209
01:00:20.970 --> 01:00:25.380
and you only see the dates up to the advanced account date.
1210
01:00:25.380 --> 01:00:27.240
You wanna, for some of the people
1211
01:00:27.240 --> 01:00:29.250
or maybe all the people, that's kind of your signal,
1212
01:00:29.250 --> 01:00:31.470
all right, we need to get this updated
1213
01:00:31.470 --> 01:00:33.513
to continue on their distribution.
1214
01:00:40.140 --> 01:00:41.910
You can get multiple entries
1215
01:00:41.910 --> 01:00:44.550
if they have more than one employee record.
1216
01:00:44.550 --> 01:00:46.950
And this is why I kept this example, even though it's older,
1217
01:00:46.950 --> 01:00:48.137
a couple years old now, but it's
1218
01:00:48.137 --> 01:00:50.580
'cause it's this employee,
1219
01:00:50.580 --> 01:00:52.890
employee not act currently active in this position,
1220
01:00:52.890 --> 01:00:55.170
and you can see, well there was a different role
1221
01:00:55.170 --> 01:00:58.113
for this person and they're now employee record five.
1222
01:01:02.790 --> 01:01:05.550
If you see this and maybe not the new record
1223
01:01:05.550 --> 01:01:06.690
but you know they're working on it,
1224
01:01:06.690 --> 01:01:10.020
again, a signal you have an action item
1225
01:01:10.020 --> 01:01:11.320
to distribute that person
1226
01:01:14.400 --> 01:01:16.320
with the PI 'cause PI's gonna be the one
1227
01:01:16.320 --> 01:01:18.360
to know if these percentages are reasonable
1228
01:01:18.360 --> 01:01:20.710
in relation to the work that's being performed.
1229
01:01:22.050 --> 01:01:24.000
And is effort distributed correctly
1230
01:01:24.000 --> 01:01:25.773
between direct and cost share?
1231
01:01:28.260 --> 01:01:31.710
So yeah, the PI is gonna review, confirm and
1232
01:01:31.710 --> 01:01:33.870
or request changes to the employees distributed
1233
01:01:33.870 --> 01:01:35.970
to his or her grants,
1234
01:01:35.970 --> 01:01:38.100
missing employees should be distributed.
1235
01:01:38.100 --> 01:01:41.050
Who should be distributed would be part of the PI's review.
1236
01:01:45.600 --> 01:01:48.120
So again, earlier we talked about the personnel commitment.
1237
01:01:48.120 --> 01:01:50.733
So this is where you would review,
1238
01:01:51.960 --> 01:01:54.777
compare the actual and the planned effort
1239
01:01:54.777 --> 01:01:56.760
and the data for the personnel commitment tab
1240
01:01:56.760 --> 01:01:59.190
as well as any documented effort changes
1241
01:01:59.190 --> 01:02:02.310
from prior effort verification.
1242
01:02:02.310 --> 01:02:05.610
So it's like these three tabs are all very useful
1243
01:02:05.610 --> 01:02:08.193
for your quarterly verification all in one place.
1244
01:02:10.830 --> 01:02:15.573
I am going to do a quick demo on that.
1245
01:02:19.934 --> 01:02:23.220
Like I said, you can go here and you can search by project
1246
01:02:23.220 --> 01:02:28.050
or you're reviewing with your PI, their individual effort
1247
01:02:28.050 --> 01:02:29.760
and then you can just go project by project
1248
01:02:29.760 --> 01:02:33.000
for any that they're the principal investigator on.
1249
01:02:33.000 --> 01:02:35.073
So we're gonna look at this one here.
1250
01:02:38.790 --> 01:02:41.040
So again, you can go to the payroll information tab.
1251
01:02:41.040 --> 01:02:43.410
I already did this (laughing)
1252
01:02:43.410 --> 01:02:45.390
for this project, 'cause it takes a while.
1253
01:02:45.390 --> 01:02:48.240
Again, I'm wondering if it has something to do with this,
1254
01:02:49.110 --> 01:02:50.940
but again you can see all
1255
01:02:50.940 --> 01:02:53.040
of the individuals and their titles on it.
1256
01:02:53.040 --> 01:02:58.040
This one actually just ended at the end of last month,
1257
01:02:58.200 --> 01:03:00.420
so we wouldn't have any encumbrances.
1258
01:03:00.420 --> 01:03:04.320
So if you do, it's distributed past the end date.
1259
01:03:04.320 --> 01:03:08.910
Also a question, you know, has the work completed on this?
1260
01:03:08.910 --> 01:03:11.850
Do we need a no cost extension would be a good question
1261
01:03:11.850 --> 01:03:13.683
to ask for this project.
1262
01:03:14.760 --> 01:03:18.780
I also did already get payroll distributions
1263
01:03:18.780 --> 01:03:20.400
just to have it loaded already.
1264
01:03:20.400 --> 01:03:24.390
And so like I said earlier, I like to...
1265
01:03:24.390 --> 01:03:25.620
oh, I timed out.
1266
01:03:25.620 --> 01:03:28.680
I was afraid of that. (laughing)
1267
01:03:28.680 --> 01:03:29.700
Well I'm not gonna do this one again
1268
01:03:29.700 --> 01:03:30.630
'cause you know that one takes a while,
1269
01:03:30.630 --> 01:03:33.810
but you can do this button here
1270
01:03:33.810 --> 01:03:36.870
and see the full distribution
1271
01:03:36.870 --> 01:03:40.230
for the individual on this award.
1272
01:03:40.230 --> 01:03:43.020
So I just said full distribution,
1273
01:03:43.020 --> 01:03:47.790
what I should say is the distribution
1274
01:03:47.790 --> 01:03:51.420
for this individual to this project.
1275
01:03:51.420 --> 01:03:52.770
So you'd have to go to
1276
01:03:52.770 --> 01:03:54.840
the other tool we talked about earlier
1277
01:03:54.840 --> 01:03:56.640
to see this person's full distribution,
1278
01:03:56.640 --> 01:03:58.080
but this is just showing you
1279
01:03:58.080 --> 01:03:59.610
what they're distributed on this project,
1280
01:03:59.610 --> 01:04:01.050
which it's a condensed version,
1281
01:04:01.050 --> 01:04:02.500
which is kind of nice to get.
1282
01:04:04.530 --> 01:04:09.530
And I did do a payroll detailed transaction as well.
1283
01:04:12.030 --> 01:04:15.090
Actually, I don't know if I went over this in a slide.
1284
01:04:15.090 --> 01:04:17.070
This isn't all that useful.
1285
01:04:17.070 --> 01:04:20.010
The only thing I find this useful in terms
1286
01:04:20.010 --> 01:04:22.860
of effort verification, it's useful for very many things,
1287
01:04:22.860 --> 01:04:26.340
but would be to maybe if you're meeting with them
1288
01:04:26.340 --> 01:04:27.813
during effort certification,
1289
01:04:28.710 --> 01:04:32.520
'cause that's now like end of August into September.
1290
01:04:32.520 --> 01:04:36.060
You wanna make sure if you have nine month faculty,
1291
01:04:36.060 --> 01:04:38.940
that their summer salaries have been distributed
1292
01:04:38.940 --> 01:04:40.770
to the award as you expected.
1293
01:04:40.770 --> 01:04:43.680
And so you could just put in a date range here
1294
01:04:43.680 --> 01:04:47.070
of June 1st to August 30th.
1295
01:04:47.070 --> 01:04:50.280
I can't talk today with dates, June to August
1296
01:04:50.280 --> 01:04:54.960
and run that to see who is distributed to it
1297
01:04:54.960 --> 01:04:57.120
for the summer months and make sure
1298
01:04:57.120 --> 01:04:59.250
that they were allocated properly.
1299
01:04:59.250 --> 01:05:01.770
I think it's actually journal date though,
1300
01:05:01.770 --> 01:05:05.820
so that is a caveat, it's not like it's effort dates.
1301
01:05:05.820 --> 01:05:08.940
So if somebody got their summer pay paid in September
1302
01:05:08.940 --> 01:05:11.070
'cause it was entered late, you're not gonna see it here
1303
01:05:11.070 --> 01:05:12.210
if you limit that by that,
1304
01:05:12.210 --> 01:05:14.700
but it's a good way to kind of drill down
1305
01:05:14.700 --> 01:05:17.310
and see to make sure effort
1306
01:05:17.310 --> 01:05:20.433
for summer salary was distributed if needed.
1307
01:05:22.410 --> 01:05:25.043
All right, was there any questions
1308
01:05:28.800 --> 01:05:31.170
on kind of the tips on how to use...
1309
01:05:31.170 --> 01:05:33.300
Oh yeah, I can't, I'm in an older one.
1310
01:05:33.300 --> 01:05:38.300
So this would be the project personnel for this project,
1311
01:05:43.024 --> 01:05:45.210
the detailed transactions and the payroll.
1312
01:05:45.210 --> 01:05:48.420
So that's kinda all I had to say on that.
1313
01:05:48.420 --> 01:05:49.620
So I don't see any questions on that,
1314
01:05:49.620 --> 01:05:52.117
so I'm gonna go back to presentation.
1315
01:06:01.386 --> 01:06:02.310
So yeah, so you wanna prepare,
1316
01:06:02.310 --> 01:06:04.230
you review the individual effort,
1317
01:06:04.230 --> 01:06:07.280
project personnel for others distributed to the project
1318
01:06:07.280 --> 01:06:08.190
in your action items.
1319
01:06:08.190 --> 01:06:11.350
So this kind of flushes out
1320
01:06:12.630 --> 01:06:13.860
like different things to consider
1321
01:06:13.860 --> 01:06:14.940
during each of those steps.
1322
01:06:14.940 --> 01:06:16.410
So when you're preparing,
1323
01:06:16.410 --> 01:06:20.070
you wanna schedule your meetings in advance.
1324
01:06:20.070 --> 01:06:23.010
You want to review the PI portal details
1325
01:06:23.010 --> 01:06:26.790
just to see if there's anything that you've identified
1326
01:06:26.790 --> 01:06:29.370
or emailed discussion points to the PI ahead of time,
1327
01:06:29.370 --> 01:06:30.633
if you find that helpful.
1328
01:06:32.370 --> 01:06:37.350
Review action items from the previous verification session,
1329
01:06:37.350 --> 01:06:41.670
maybe even pull up any award documents that might be useful,
1330
01:06:41.670 --> 01:06:43.980
any that might be going into no-cost extension
1331
01:06:43.980 --> 01:06:47.923
or like your proposals, are these awarded?
1332
01:06:53.670 --> 01:06:58.670
So when you're meeting with the individual
1333
01:06:59.250 --> 01:07:01.380
and they're going over their individual effort,
1334
01:07:01.380 --> 01:07:03.900
you'll do that first piece that we looked at,
1335
01:07:03.900 --> 01:07:05.490
the sponsored effort commitments
1336
01:07:05.490 --> 01:07:08.010
and look at the commitment by person report.
1337
01:07:08.010 --> 01:07:12.063
You'll review that for accuracy, compliance of commitments,
1338
01:07:12.900 --> 01:07:16.860
review actuals and future effort,
1339
01:07:16.860 --> 01:07:19.173
discuss if anything needs a no cost extension.
1340
01:07:20.970 --> 01:07:24.840
You'll review their distributions by person tab
1341
01:07:24.840 --> 01:07:26.760
and kind of compare that to the commitments
1342
01:07:26.760 --> 01:07:28.340
or just run your salary distribution
1343
01:07:28.340 --> 01:07:30.060
if you find that easier for the people
1344
01:07:30.060 --> 01:07:34.920
who have a lot of effective dates and a lot of awards.
1345
01:07:34.920 --> 01:07:38.070
I find the distribution form just to be easier to look at,
1346
01:07:38.070 --> 01:07:42.033
but it is all there in the distribution by person tab.
1347
01:07:43.050 --> 01:07:45.240
Have a discussion like now is a good time
1348
01:07:45.240 --> 01:07:47.610
to start discussing what additional pays are needed
1349
01:07:47.610 --> 01:07:49.830
for summer effort for the non-contract period
1350
01:07:49.830 --> 01:07:51.610
for your nine month faculty
1351
01:07:52.470 --> 01:07:54.390
and again, review pending proposals.
1352
01:07:54.390 --> 01:07:58.050
I'll go over that in detail of how to find those,
1353
01:07:58.050 --> 01:08:00.503
if you aren't familiar with that towards the end though.
1354
01:08:01.620 --> 01:08:04.080
So prepare, go over individual effort,
1355
01:08:04.080 --> 01:08:05.760
then go over the project personnel.
1356
01:08:05.760 --> 01:08:07.210
So as I said before,
1357
01:08:07.210 --> 01:08:09.087
you'd go over the payroll information tab
1358
01:08:09.087 --> 01:08:11.730
and you had those two resources there.
1359
01:08:11.730 --> 01:08:15.510
Go over the transaction detail tab.
1360
01:08:15.510 --> 01:08:18.930
You can use that to look for summer salary for instance,
1361
01:08:18.930 --> 01:08:20.760
have a discussion about additional pays
1362
01:08:20.760 --> 01:08:22.140
for others on the award,
1363
01:08:22.140 --> 01:08:23.820
because you don't wanna be surprised later on
1364
01:08:23.820 --> 01:08:28.560
as you get towards the end of November
1365
01:08:28.560 --> 01:08:29.707
and somebody's coming to you saying,
1366
01:08:29.707 --> 01:08:32.610
"Oh we never did their additional pay for."
1367
01:08:32.610 --> 01:08:35.280
And you've been relying on your budget information
1368
01:08:35.280 --> 01:08:38.190
and now you still owe them for that effort
1369
01:08:38.190 --> 01:08:39.210
but you don't have the money.
1370
01:08:39.210 --> 01:08:41.880
So it's a good thing to be making sure
1371
01:08:41.880 --> 01:08:43.800
that everybody's getting paid,
1372
01:08:43.800 --> 01:08:48.240
whether it's your Kronos individuals, your other biweekly,
1373
01:08:48.240 --> 01:08:50.913
your semi-monthly or additional pays.
1374
01:08:52.500 --> 01:08:57.270
Again, identify your action items for retroactive
1375
01:08:57.270 --> 01:09:00.760
or perspective payroll distribution changes
1376
01:09:02.220 --> 01:09:04.530
and then your action items you wanna document.
1377
01:09:04.530 --> 01:09:07.590
So one action item is to document your review.
1378
01:09:07.590 --> 01:09:11.070
Again, that comments button is really important.
1379
01:09:11.070 --> 01:09:14.070
Timely submission of payroll related changes,
1380
01:09:14.070 --> 01:09:19.070
email SPA, if there's any commitment set up corrections
1381
01:09:20.250 --> 01:09:22.257
or initiate prior approval requests,
1382
01:09:22.257 --> 01:09:25.980
and I think that's really more prior approval requests.
1383
01:09:25.980 --> 01:09:28.260
Now we probably just submitting a MOD,
1384
01:09:28.260 --> 01:09:29.610
but if you had questions on whether
1385
01:09:29.610 --> 01:09:31.950
or not you needed prior approval,
1386
01:09:31.950 --> 01:09:34.650
that's when you would email SPA.
1387
01:09:34.650 --> 01:09:37.110
Yeah, if you know for sure yes, we need prior approval,
1388
01:09:37.110 --> 01:09:41.650
start your MOD and Qlik and then verify
1389
01:09:42.720 --> 01:09:45.363
resulting changes on action items.
1390
01:09:49.110 --> 01:09:52.110
All right, so preparing for success
1391
01:09:52.110 --> 01:09:53.730
for these verifications.
1392
01:09:53.730 --> 01:09:56.580
So you really wanna set them up either in teams
1393
01:09:56.580 --> 01:09:59.580
or zoom, depending whether you're college of medicine or not
1394
01:10:00.600 --> 01:10:04.680
or in person and it could vary within your department.
1395
01:10:04.680 --> 01:10:07.560
You could have PIs that are very hands-on
1396
01:10:07.560 --> 01:10:09.150
and they're good with teams
1397
01:10:09.150 --> 01:10:09.983
and they're gonna get in there
1398
01:10:09.983 --> 01:10:11.610
and they wanna do it themselves too
1399
01:10:11.610 --> 01:10:13.740
and you can teach 'em that, great
1400
01:10:13.740 --> 01:10:16.110
and then you have other faculty
1401
01:10:16.110 --> 01:10:18.240
who really need the handholding
1402
01:10:18.240 --> 01:10:20.250
and need you to sit with them and go through them.
1403
01:10:20.250 --> 01:10:23.190
So it's really person by person based on your experience
1404
01:10:23.190 --> 01:10:24.393
with the faculty,
1405
01:10:25.680 --> 01:10:27.090
and just kind of thinking about when to do,
1406
01:10:27.090 --> 01:10:28.320
I mean August, September
1407
01:10:28.320 --> 01:10:31.680
you're working on identification midyear,
1408
01:10:31.680 --> 01:10:33.980
you know the next quarter, November, December,
1409
01:10:35.010 --> 01:10:37.020
right around now when you're starting to do budget building
1410
01:10:37.020 --> 01:10:38.703
and planning for the next year.
1411
01:10:39.870 --> 01:10:42.270
And then towards the end of the year you wanna do your final
1412
01:10:42.270 --> 01:10:45.150
cleanup and clear your suspense,
1413
01:10:45.150 --> 01:10:46.470
finalize the fiscal year
1414
01:10:46.470 --> 01:10:50.880
so it's ready for effort certification
1415
01:10:50.880 --> 01:10:52.800
and to make sure all the additional pays
1416
01:10:52.800 --> 01:10:56.200
are getting out there, maybe even reviewing each one
1417
01:10:58.050 --> 01:11:00.240
when you're reviewing the project for award closeout.
1418
01:11:00.240 --> 01:11:01.740
Quickly check in,
1419
01:11:01.740 --> 01:11:05.160
see if there's any other changes on newly set up awards
1420
01:11:05.160 --> 01:11:10.160
or just any effort changes that they may be aware of
1421
01:11:10.500 --> 01:11:11.333
be asking them,
1422
01:11:11.333 --> 01:11:12.690
and I'd schedule them in advance
1423
01:11:12.690 --> 01:11:15.140
so they're aware, you know, this is gonna happen.
1424
01:11:16.410 --> 01:11:18.930
We don't dictate that this is the schedule you do.
1425
01:11:18.930 --> 01:11:22.500
So some departments have a lot of faculty
1426
01:11:22.500 --> 01:11:25.203
on sponsored projects, others don't.
1427
01:11:26.555 --> 01:11:28.050
So the ones that don't have a lot
1428
01:11:28.050 --> 01:11:29.820
of faculty may follow the schedule
1429
01:11:29.820 --> 01:11:32.130
and do all of them on the schedule.
1430
01:11:32.130 --> 01:11:35.070
Others may have, like I said, a lot of faculty
1431
01:11:35.070 --> 01:11:37.920
and sponsored awards and do a third each month,
1432
01:11:37.920 --> 01:11:40.710
but that particular faculty member
1433
01:11:40.710 --> 01:11:43.620
is getting seen every three months.
1434
01:11:43.620 --> 01:11:48.620
So it isn't dictated in the effort policy when those happen,
1435
01:11:51.030 --> 01:11:52.743
these are just recommendations.
1436
01:11:54.060 --> 01:11:57.750
Again, preparing, assess results from the last verification,
1437
01:11:57.750 --> 01:12:00.240
identifying some potential discussion points in advance
1438
01:12:00.240 --> 01:12:02.700
and having supporting documentation
1439
01:12:02.700 --> 01:12:04.230
and really enroll your dean's offices.
1440
01:12:04.230 --> 01:12:06.720
So you're getting any pushback from running a faculty,
1441
01:12:06.720 --> 01:12:09.690
the dean's offices are well aware of these requirements
1442
01:12:09.690 --> 01:12:11.520
for quarterly effort verifications
1443
01:12:11.520 --> 01:12:13.170
and the importance of them
1444
01:12:13.170 --> 01:12:15.120
and they will support you on them
1445
01:12:15.120 --> 01:12:17.370
and our department as well.
1446
01:12:17.370 --> 01:12:18.960
So you can reach out to myself
1447
01:12:18.960 --> 01:12:22.353
or Lindsay for support if you're getting pushback.
1448
01:12:25.890 --> 01:12:27.990
Just kind of highlighting again,
1449
01:12:27.990 --> 01:12:30.840
so reviewing the individual, it must be done quarterly
1450
01:12:30.840 --> 01:12:33.963
for all faculty of commitments on sponsored projects.
1451
01:12:35.310 --> 01:12:36.990
Review all dates
1452
01:12:36.990 --> 01:12:39.930
and percentages in the commitment by person report
1453
01:12:39.930 --> 01:12:41.793
for accuracy and completeness.
1454
01:12:42.630 --> 01:12:45.030
Review the distribution by person details
1455
01:12:45.030 --> 01:12:49.530
to ensure allocated effort matches actual effort applied.
1456
01:12:49.530 --> 01:12:52.560
So if you're allocating 10%
1457
01:12:52.560 --> 01:12:55.140
and they said, "Oh no I've been actually
1458
01:12:55.140 --> 01:12:57.510
only been doing five for the last quarter."
1459
01:12:57.510 --> 01:12:59.610
You wanna update that and evaluate whether
1460
01:12:59.610 --> 01:13:03.453
or not reduction request is required.
1461
01:13:06.390 --> 01:13:09.153
We talked about comparing commitment to actual.
1462
01:13:11.940 --> 01:13:15.180
Yeah, and so if there is an effort reduction
1463
01:13:15.180 --> 01:13:18.190
in individual's role as key personnel
1464
01:13:21.300 --> 01:13:23.580
and they're not the PI, you need to reach out
1465
01:13:23.580 --> 01:13:25.680
to the PI to let them know,
1466
01:13:25.680 --> 01:13:27.120
make sure they're aware
1467
01:13:27.120 --> 01:13:30.750
because again, that could impact the scope of work,
1468
01:13:30.750 --> 01:13:33.630
and the PI would need to make sure they're asking
1469
01:13:33.630 --> 01:13:38.630
for that approval proactively.
1470
01:13:43.770 --> 01:13:46.200
Again, on key personnel, we talked about the tools
1471
01:13:46.200 --> 01:13:51.200
and the PI portal
1472
01:13:51.270 --> 01:13:53.613
to support that which are listed here.
1473
01:13:54.690 --> 01:13:58.470
Payroll expenses to date will provide the job description,
1474
01:13:58.470 --> 01:14:00.270
which is what I like about that one.
1475
01:14:01.200 --> 01:14:03.000
Compare distribution percentages
1476
01:14:03.000 --> 01:14:05.790
to personnel commitments percentage for any faculty
1477
01:14:05.790 --> 01:14:09.960
and non key personnel, discuss future effort
1478
01:14:09.960 --> 01:14:11.910
for each personnel the project
1479
01:14:11.910 --> 01:14:14.400
and review pending electronic additional pay forms.
1480
01:14:14.400 --> 01:14:17.150
So I think we've (laughing) talked that through enough.
1481
01:14:18.876 --> 01:14:20.220
So effort reduction considerations.
1482
01:14:20.220 --> 01:14:23.370
The PI must be involved in assessing the impact
1483
01:14:23.370 --> 01:14:25.890
of effort commitment reductions on key personnel
1484
01:14:25.890 --> 01:14:27.633
who is listed in the notice of award.
1485
01:14:27.633 --> 01:14:31.410
Will the scope of work have to be reduced or changed?
1486
01:14:31.410 --> 01:14:34.950
Will effort reduction be during a no cost extension period?
1487
01:14:34.950 --> 01:14:37.320
So these are questions to evaluate.
1488
01:14:37.320 --> 01:14:39.090
Does the sponsor have to approve?
1489
01:14:39.090 --> 01:14:40.590
We kind of jumped ahead here.
1490
01:14:40.590 --> 01:14:43.440
So if yes submit your MOD,
1491
01:14:43.440 --> 01:14:47.160
if you're unsure, email your research administrator.
1492
01:14:47.160 --> 01:14:48.300
If no, just document
1493
01:14:48.300 --> 01:14:50.160
the planned effort for future reference.
1494
01:14:50.160 --> 01:14:53.880
And again, if the answer's no, the sponsor doesn't need
1495
01:14:53.880 --> 01:14:56.280
to approve that 'cause they're not key personnel
1496
01:14:57.270 --> 01:15:01.050
or it's not a federal award that asked for commitments.
1497
01:15:01.050 --> 01:15:06.050
And then SPA isn't going to be updating
1498
01:15:06.660 --> 01:15:09.900
that commitment in the project team page
1499
01:15:09.900 --> 01:15:12.423
which flows to these tools.
1500
01:15:13.380 --> 01:15:17.760
However, if it does require sponsor approval,
1501
01:15:17.760 --> 01:15:19.140
it does go through that process.
1502
01:15:19.140 --> 01:15:23.250
The sponsor approves, once SPA gets that approval,
1503
01:15:23.250 --> 01:15:25.050
they would be updating that commitment
1504
01:15:25.050 --> 01:15:29.580
and you would see that the following day
1505
01:15:29.580 --> 01:15:31.623
after SPA has updated that commitment.
1506
01:15:36.480 --> 01:15:38.550
Josh, I think you wanted take over for this one.
1507
01:15:38.550 --> 01:15:41.233
You live in the world of person months. (laughing)
1508
01:15:41.233 --> 01:15:42.930
Yeah, well first
1509
01:15:42.930 --> 01:15:45.660
I just wanted to also mention that
1510
01:15:45.660 --> 01:15:50.660
it really is kind of rare that a sponsor actually needs
1511
01:15:50.730 --> 01:15:55.020
to approve a planned effort reduction.
1512
01:15:55.020 --> 01:15:57.000
Like once you go through all these tests
1513
01:15:57.000 --> 01:16:00.750
and check things almost every time
1514
01:16:00.750 --> 01:16:03.510
the sponsor does not need to approve it.
1515
01:16:03.510 --> 01:16:06.390
Like I probably send these into a sponsor
1516
01:16:06.390 --> 01:16:08.013
maybe once or twice a year.
1517
01:16:09.450 --> 01:16:11.220
I mean, certain circumstances
1518
01:16:11.220 --> 01:16:13.440
can cause that to be different,
1519
01:16:13.440 --> 01:16:15.963
but for the most part it's really not that common.
1520
01:16:17.370 --> 01:16:19.410
So when we are looking at whether
1521
01:16:19.410 --> 01:16:21.570
or not sponsor approval is needed,
1522
01:16:21.570 --> 01:16:26.190
we want to compare what we've committed to the sponsor
1523
01:16:26.190 --> 01:16:27.810
with what we're projecting,
1524
01:16:27.810 --> 01:16:29.943
and we're doing this in person months,
1525
01:16:31.530 --> 01:16:33.990
because again, we're not talking about like changing
1526
01:16:33.990 --> 01:16:35.190
the marginal effort.
1527
01:16:35.190 --> 01:16:39.750
If someone's going from 20% to 10%,
1528
01:16:39.750 --> 01:16:42.450
you may say, "Oh well we're cutting the REF in half."
1529
01:16:42.450 --> 01:16:47.450
But if they've already actually done a bunch of effort,
1530
01:16:51.420 --> 01:16:54.630
then that may not really be an issue.
1531
01:16:54.630 --> 01:16:59.630
So to do this, we're going to add the person of months
1532
01:17:00.120 --> 01:17:01.860
we've already applied
1533
01:17:01.860 --> 01:17:03.810
to the period we're looking at
1534
01:17:03.810 --> 01:17:07.290
and then we're gonna project the future person months
1535
01:17:07.290 --> 01:17:09.360
for the remainder of this period
1536
01:17:09.360 --> 01:17:13.140
and then we compare that to what we've committed
1537
01:17:13.140 --> 01:17:14.550
again for the same period.
1538
01:17:14.550 --> 01:17:17.400
And the reason why I'm saying period instead of year
1539
01:17:17.400 --> 01:17:20.403
is that if you recall from the part one training,
1540
01:17:21.270 --> 01:17:25.980
for a lot of sponsors, the sort of awarded period
1541
01:17:25.980 --> 01:17:28.890
that we're looking at can be multiple years.
1542
01:17:28.890 --> 01:17:30.330
So if it's an NSF award
1543
01:17:30.330 --> 01:17:33.693
and they're awarding three years at one time,
1544
01:17:34.680 --> 01:17:36.270
then what we're looking at
1545
01:17:36.270 --> 01:17:38.793
is that entire three year award period,
1546
01:17:39.630 --> 01:17:41.340
whereas with something like NIH
1547
01:17:41.340 --> 01:17:43.830
that awards things on a yearly basis,
1548
01:17:43.830 --> 01:17:46.893
then we would be looking at that one specific year.
1549
01:17:48.780 --> 01:17:52.860
So for calculating person months for a 12 month faculty,
1550
01:17:52.860 --> 01:17:57.720
you basically would multiply the number of months
1551
01:17:57.720 --> 01:18:01.980
that have already been worked by the percent effort
1552
01:18:01.980 --> 01:18:06.980
that that investigator has already been put on that award.
1553
01:18:07.410 --> 01:18:11.820
So, let's say in the example
1554
01:18:11.820 --> 01:18:16.193
we're in month seven of an award period
1555
01:18:19.385 --> 01:18:24.060
and, you know, the PI has put 25% effort in.
1556
01:18:25.080 --> 01:18:28.500
So you would multiply 7 x 25%
1557
01:18:28.500 --> 01:18:31.980
and then that would get you 1.75 person months
1558
01:18:31.980 --> 01:18:34.230
you've already worked on this award.
1559
01:18:34.230 --> 01:18:35.257
So then if you're saying,
1560
01:18:35.257 --> 01:18:38.300
"Well okay, well we wanna reduce the effort moving forward
1561
01:18:38.300 --> 01:18:41.580
in this award period starting in month eight,
1562
01:18:41.580 --> 01:18:45.690
we wanna reduce that from 25% to 15%,
1563
01:18:45.690 --> 01:18:47.970
well then you would basically see okay,
1564
01:18:47.970 --> 01:18:52.260
there's five months extra in this award period,
1565
01:18:52.260 --> 01:18:56.550
and so you would multiply 5 x 0.15
1566
01:18:56.550 --> 01:18:59.130
and you would get 0.75 person months.
1567
01:18:59.130 --> 01:19:02.700
So in this case, the projected effort is 2.5 person months
1568
01:19:02.700 --> 01:19:04.233
over the course of that year.
1569
01:19:05.250 --> 01:19:10.250
And so if you've committed three person months
1570
01:19:13.364 --> 01:19:17.347
and we are projecting doing 2.5 person months
1571
01:19:18.510 --> 01:19:22.680
to basically look at whether we needed prior approval,
1572
01:19:22.680 --> 01:19:26.190
you would say "okay, you know, for a federal sponsor,
1573
01:19:26.190 --> 01:19:27.740
you need prior approval
1574
01:19:27.740 --> 01:19:32.740
if we are reducing effort by 25% or more."
1575
01:19:32.880 --> 01:19:37.880
And so 75% of three person months is 2.25 person month.
1576
01:19:38.940 --> 01:19:42.270
So in this case we are at 2.5 person months,
1577
01:19:42.270 --> 01:19:47.040
which means that, you know, we will have committed,
1578
01:19:47.040 --> 01:19:50.487
you know, enough effort that we are projecting
1579
01:19:53.520 --> 01:19:55.200
to put enough effort on this award
1580
01:19:55.200 --> 01:19:57.603
that we will not need prior approval.
1581
01:19:59.340 --> 01:20:02.040
And also another thing to mention when I say prior approval,
1582
01:20:02.040 --> 01:20:05.040
this is supposed to be prior approval, you know,
1583
01:20:05.040 --> 01:20:08.700
we should be looking at a future change
1584
01:20:08.700 --> 01:20:10.473
and making these projections,
1585
01:20:11.850 --> 01:20:15.150
but obviously sometimes that doesn't happen.
1586
01:20:15.150 --> 01:20:19.000
And in those cases, you know, we would be looking at
1587
01:20:20.190 --> 01:20:22.620
more or less getting forgiveness from the sponsor
1588
01:20:22.620 --> 01:20:23.850
instead of permission,
1589
01:20:23.850 --> 01:20:27.270
and in these cases it's much, much better to ask
1590
01:20:27.270 --> 01:20:28.860
for permission than forgiveness.
1591
01:20:28.860 --> 01:20:32.160
And so we do wanna do these projections
1592
01:20:32.160 --> 01:20:35.490
and actually project out versus realize
1593
01:20:35.490 --> 01:20:37.800
that we have not committed enough effort
1594
01:20:37.800 --> 01:20:41.643
and need to get the sponsor to approve it retroactively.
1595
01:20:43.110 --> 01:20:47.970
So when you have a faculty with an academic appointment,
1596
01:20:47.970 --> 01:20:50.160
this gets a lot more complicated
1597
01:20:50.160 --> 01:20:51.570
or at least a little bit more complicated
1598
01:20:51.570 --> 01:20:55.540
because in these cases we are gonna be now looking at
1599
01:20:57.660 --> 01:20:59.790
where we are in the year in terms of
1600
01:20:59.790 --> 01:21:02.313
the academic versus summer, right?
1601
01:21:06.300 --> 01:21:07.380
There's another dimension here,
1602
01:21:07.380 --> 01:21:10.210
so like for example, let's say
1603
01:21:12.603 --> 01:21:15.300
it's a January 1st start date
1604
01:21:15.300 --> 01:21:20.300
and, you know, we're in July,
1605
01:21:21.090 --> 01:21:24.060
then you'd be just looking at that amount
1606
01:21:24.060 --> 01:21:27.270
of that academic period that has been worked
1607
01:21:27.270 --> 01:21:29.790
and then you'd be doing the summer period separately
1608
01:21:29.790 --> 01:21:31.230
as a separate calculation.
1609
01:21:31.230 --> 01:21:35.490
And so really you sort of need to do separate calculations
1610
01:21:35.490 --> 01:21:36.570
for summer and academic
1611
01:21:36.570 --> 01:21:39.750
if you are combining summer and academic.
1612
01:21:39.750 --> 01:21:42.900
Other times if we're only doing the summer period,
1613
01:21:42.900 --> 01:21:44.640
then we're just gonna be focusing on
1614
01:21:44.640 --> 01:21:47.910
that summer period in terms of the amount of work
1615
01:21:47.910 --> 01:21:49.860
that's already been put.
1616
01:21:49.860 --> 01:21:54.480
And so, you know, how start and end dates work,
1617
01:21:54.480 --> 01:21:55.650
sometimes you're sort
1618
01:21:55.650 --> 01:22:00.630
of combining two calendar year summer periods.
1619
01:22:00.630 --> 01:22:03.750
So like if an award starts 8/1
1620
01:22:03.750 --> 01:22:06.660
you would be looking at, you know,
1621
01:22:06.660 --> 01:22:11.660
one like portion of a summer academic period
1622
01:22:13.020 --> 01:22:15.510
and then another portion of a summer academic period
1623
01:22:15.510 --> 01:22:18.837
depending on how we've laid out the effort commitments.
1624
01:22:18.837 --> 01:22:20.640
And so just to say
1625
01:22:20.640 --> 01:22:22.500
that this can get a little bit complicated
1626
01:22:22.500 --> 01:22:23.943
when you are doing academic,
1627
01:22:24.780 --> 01:22:26.100
but the most important thing is just
1628
01:22:26.100 --> 01:22:27.870
to be mindful of the start and end dates
1629
01:22:27.870 --> 01:22:31.020
and what amount of an academic versus a summer period
1630
01:22:31.020 --> 01:22:32.013
you are hitting,
1631
01:22:33.000 --> 01:22:35.103
but the general idea is the same.
1632
01:22:36.900 --> 01:22:38.700
Dawn, you can go forward if you want.
1633
01:22:38.700 --> 01:22:42.930
All right, I just wanna check
1634
01:22:42.930 --> 01:22:45.000
to see if there's questions.
1635
01:22:45.000 --> 01:22:50.000
All right, so as I promised I said I'd show you how
1636
01:22:51.180 --> 01:22:54.480
to go over the proposal commitments.
1637
01:22:54.480 --> 01:22:56.970
And again, this all worked last week
1638
01:22:56.970 --> 01:22:59.697
when I checked it out in UVM Qlik
1639
01:22:59.697 --> 01:23:02.550
and again, I know SPA is working on an upgrade
1640
01:23:02.550 --> 01:23:04.230
so things may change,
1641
01:23:04.230 --> 01:23:06.783
but as of right now, this is what is still current.
1642
01:23:08.010 --> 01:23:10.140
So there are actually four different reports
1643
01:23:10.140 --> 01:23:11.220
you can use for this.
1644
01:23:11.220 --> 01:23:14.730
So when you're in UVM Qlik, you navigate to grants,
1645
01:23:14.730 --> 01:23:16.710
reports, customer reports,
1646
01:23:16.710 --> 01:23:20.280
and in the search field enter investigators on proposals
1647
01:23:20.280 --> 01:23:22.860
and it should bring up these four reports.
1648
01:23:22.860 --> 01:23:26.010
I tend to suggest these bottom two,
1649
01:23:26.010 --> 01:23:28.083
so you would wanna do the two.
1650
01:23:34.440 --> 01:23:35.910
I dunno, yeah it cluttered it up
1651
01:23:35.910 --> 01:23:37.500
a little bit with like the in development,
1652
01:23:37.500 --> 01:23:41.040
like if it isn't submitted, do you need to know about it?
1653
01:23:41.040 --> 01:23:43.080
That's really a decision for you guys
1654
01:23:43.080 --> 01:23:44.850
to kind of play around with these,
1655
01:23:44.850 --> 01:23:49.260
but again, these are the two that I tend to recommend,
1656
01:23:49.260 --> 01:23:50.523
but do what suits you.
1657
01:23:51.420 --> 01:23:54.060
So again, so grants reports, customer reports, input
1658
01:23:54.060 --> 01:23:55.620
and investigators on proposals,
1659
01:23:55.620 --> 01:23:59.730
and you'll see these four just to give a visual of that.
1660
01:23:59.730 --> 01:24:00.960
So once you do that
1661
01:24:00.960 --> 01:24:04.110
and you get there, you get to this example,
1662
01:24:04.110 --> 01:24:06.450
I picked investigator reports for PI only
1663
01:24:06.450 --> 01:24:08.400
and put in a PI's last name.
1664
01:24:08.400 --> 01:24:10.650
And so you do have to select this dropdown box.
1665
01:24:10.650 --> 01:24:13.660
I think it might end up defaulting to
1666
01:24:15.510 --> 01:24:16.650
FP number maybe,
1667
01:24:16.650 --> 01:24:19.680
so you wanna make sure you select PI last name
1668
01:24:19.680 --> 01:24:21.383
if that's how you wanna look it up.
1669
01:24:22.440 --> 01:24:23.670
You'll get a list
1670
01:24:23.670 --> 01:24:28.480
and so you have pending sponsor approval
1671
01:24:29.520 --> 01:24:32.483
denied or under review, I don't know.
1672
01:24:32.483 --> 01:24:35.670
So like look at the ones that aren't awarded
1673
01:24:35.670 --> 01:24:38.490
because those ones you'll find set up already
1674
01:24:38.490 --> 01:24:39.930
in the tools we've already talked about,
1675
01:24:39.930 --> 01:24:41.040
but you wanna focus on the ones
1676
01:24:41.040 --> 01:24:43.080
that are pending sponsor approval.
1677
01:24:43.080 --> 01:24:45.000
You click on the FP number
1678
01:24:45.000 --> 01:24:46.230
and you'd scroll down to the bottom
1679
01:24:46.230 --> 01:24:50.520
and you'd click on the name under working budgets.
1680
01:24:50.520 --> 01:24:54.990
From there on the left hand menu you click view budgets
1681
01:24:54.990 --> 01:24:56.230
again, left hand menu
1682
01:24:57.480 --> 01:24:59.640
and you click personnel costs
1683
01:24:59.640 --> 01:25:04.500
and you would see the personnel costs and the breakdown.
1684
01:25:04.500 --> 01:25:07.140
And so right now again it's percentages
1685
01:25:07.140 --> 01:25:10.440
but that might become mixed
1686
01:25:10.440 --> 01:25:14.400
or depending on, you know, what the sponsor requires,
1687
01:25:14.400 --> 01:25:16.800
but that's all still being worked out depending on
1688
01:25:16.800 --> 01:25:17.730
how the testing goes
1689
01:25:17.730 --> 01:25:20.610
and what the upgrade entails in Qlik.
1690
01:25:20.610 --> 01:25:25.143
So for now it's still in percentages that I can show you.
1691
01:25:25.980 --> 01:25:28.710
And so again, I would recommend you go through
1692
01:25:28.710 --> 01:25:30.540
all the pending proposals
1693
01:25:30.540 --> 01:25:32.370
and look at the commitments for that person
1694
01:25:32.370 --> 01:25:34.230
and enter a note.
1695
01:25:34.230 --> 01:25:36.720
I even put in a suggestion
1696
01:25:36.720 --> 01:25:40.980
to put in the role for that as well
1697
01:25:40.980 --> 01:25:42.630
just so you have everything here
1698
01:25:42.630 --> 01:25:45.220
and can just have that conversation of
1699
01:25:46.320 --> 01:25:48.360
have you heard anything from the sponsor on this?
1700
01:25:48.360 --> 01:25:51.540
And they may say, "Oh yeah, this one wasn't awarded."
1701
01:25:51.540 --> 01:25:54.660
So you would reach out to SPA,
1702
01:25:54.660 --> 01:25:56.790
to let them know this was unfunded
1703
01:25:56.790 --> 01:25:59.460
and to close that out in Qlik
1704
01:25:59.460 --> 01:26:03.750
or they might say, "Yeah these bottom two,
1705
01:26:03.750 --> 01:26:04.840
they were awarded
1706
01:26:05.850 --> 01:26:07.800
but we haven't gotten the award document yet.
1707
01:26:07.800 --> 01:26:11.250
Do we need to work on an advanced account?"
1708
01:26:11.250 --> 01:26:14.760
So those are some questions you can work on
1709
01:26:14.760 --> 01:26:17.820
after you have your listing of pending proposals
1710
01:26:17.820 --> 01:26:18.870
and then you can just copy
1711
01:26:18.870 --> 01:26:21.270
and paste this into a new comment
1712
01:26:21.270 --> 01:26:24.303
with any updates you have for your next quarter.
1713
01:26:27.870 --> 01:26:30.810
On Qlik does the effort need to be looked up
1714
01:26:30.810 --> 01:26:34.440
by each funding proposal individually?
1715
01:26:34.440 --> 01:26:36.210
Is there a way to look up all effort
1716
01:26:36.210 --> 01:26:37.650
pending for an individual?
1717
01:26:37.650 --> 01:26:42.570
No, so Qlik doesn't have that report unfortunately.
1718
01:26:42.570 --> 01:26:46.170
That's why like you do this once
1719
01:26:46.170 --> 01:26:48.480
and then you can run those reports real quick
1720
01:26:48.480 --> 01:26:51.570
and just see is there any new funding proposal
1721
01:26:51.570 --> 01:26:53.730
because this information isn't gonna change
1722
01:26:53.730 --> 01:26:55.830
in the funding proposal once it's out there
1723
01:26:55.830 --> 01:26:57.960
and pending sponsor review.
1724
01:26:57.960 --> 01:26:59.670
So if you run the report again
1725
01:26:59.670 --> 01:27:02.970
and you see the same for pending proposals
1726
01:27:02.970 --> 01:27:04.110
as you did last quarter,
1727
01:27:04.110 --> 01:27:05.370
there's nothing further you need to do,
1728
01:27:05.370 --> 01:27:06.780
you have all the information here.
1729
01:27:06.780 --> 01:27:09.420
If you see one more, you'd wanna look at that one,
1730
01:27:09.420 --> 01:27:11.367
see what the commitment is on that,
1731
01:27:11.367 --> 01:27:13.770
and like I said, you can either edit this comment,
1732
01:27:13.770 --> 01:27:15.570
add that, or copy this
1733
01:27:15.570 --> 01:27:19.080
and put it into a new one with the new commitment
1734
01:27:19.080 --> 01:27:22.710
in there for the new funding proposal.
1735
01:27:22.710 --> 01:27:24.900
So that's just my recommendation on how to use that
1736
01:27:24.900 --> 01:27:29.640
to keep this kind of an ongoing tool.
1737
01:27:29.640 --> 01:27:31.590
But yeah, initially you need to look it up
1738
01:27:31.590 --> 01:27:36.213
to get all the proposals pending in the commitments.
1739
01:27:39.960 --> 01:27:42.570
So discussion points related
1740
01:27:42.570 --> 01:27:45.750
to pending proposals, this is a good one.
1741
01:27:45.750 --> 01:27:48.090
Will my pending proposals affect my ability
1742
01:27:48.090 --> 01:27:50.370
to meet my commitments on my current,
1743
01:27:50.370 --> 01:27:51.780
active sponsored agreements?
1744
01:27:51.780 --> 01:27:53.850
And if the answer is yes, you wanna pay attention
1745
01:27:53.850 --> 01:27:58.850
to that award and what's their plan
1746
01:27:58.950 --> 01:28:03.950
if they end up getting awarded that,
1747
01:28:04.020 --> 01:28:06.990
they're gonna have to reduce effort on other agreements
1748
01:28:06.990 --> 01:28:11.340
and will that require a significant enough reduction
1749
01:28:11.340 --> 01:28:14.070
in other awards to require sponsor approval
1750
01:28:14.070 --> 01:28:16.953
or is it just a couple awards will be reduced?
1751
01:28:17.910 --> 01:28:18.743
Another thing,
1752
01:28:18.743 --> 01:28:20.400
should I communicate effort commitment changes
1753
01:28:20.400 --> 01:28:23.160
to the sponsor to proactively address reductions
1754
01:28:23.160 --> 01:28:26.790
of an effort or disengagements longer than three months?
1755
01:28:26.790 --> 01:28:28.890
Should I request an advanced account,
1756
01:28:28.890 --> 01:28:32.159
have any sponsor communicated that pending proposals
1757
01:28:32.159 --> 01:28:33.330
will not be funded?
1758
01:28:33.330 --> 01:28:35.070
So we kind of talked about those already.
1759
01:28:35.070 --> 01:28:39.570
So anything that needs to be updated in UVM Qlik
1760
01:28:39.570 --> 01:28:41.490
for pending proposals, you can reach out
1761
01:28:41.490 --> 01:28:43.833
to your research administrator at SPA.
1762
01:28:47.430 --> 01:28:49.230
And this is a new piece that hasn't...
1763
01:28:49.230 --> 01:28:50.400
It's been in the user guide
1764
01:28:50.400 --> 01:28:53.160
but I haven't included it in the presentation in the past,
1765
01:28:53.160 --> 01:28:54.480
but just with a lot
1766
01:28:54.480 --> 01:28:57.090
of ongoing conversations about dual appointments
1767
01:28:57.090 --> 01:28:59.490
and directors, I thought it would be useful
1768
01:28:59.490 --> 01:29:01.740
to present to you guys,
1769
01:29:01.740 --> 01:29:04.560
but not everyone here is going
1770
01:29:04.560 --> 01:29:05.760
to have access to this.
1771
01:29:05.760 --> 01:29:08.280
So really those individuals who are involved
1772
01:29:08.280 --> 01:29:10.560
with effort certification during
1773
01:29:10.560 --> 01:29:15.560
the August, September time period have access
1774
01:29:16.110 --> 01:29:20.700
to this in the Effort Reporting System or ERS.
1775
01:29:20.700 --> 01:29:24.810
And so you, if you don't have access to it, you might need
1776
01:29:24.810 --> 01:29:27.870
to reach out to the person in your department who does
1777
01:29:27.870 --> 01:29:31.293
for anyone with a dual appointment or director appointment.
1778
01:29:36.990 --> 01:29:41.340
So ERS contains the fiscal year, semi-monthly payroll
1779
01:29:41.340 --> 01:29:42.870
regardless of payment type,
1780
01:29:42.870 --> 01:29:47.100
so whether it's from their job record or additional pays.
1781
01:29:47.100 --> 01:29:48.690
So as the payrolls happen,
1782
01:29:48.690 --> 01:29:51.633
I'm updating ERS every payroll.
1783
01:29:52.980 --> 01:29:55.950
Again, eventually you'll also have the Kronos individuals
1784
01:29:55.950 --> 01:29:57.543
in there too, but not yet.
1785
01:29:59.811 --> 01:30:01.860
So you would go under reports
1786
01:30:01.860 --> 01:30:05.430
and then you'd click on effort on demand preview
1787
01:30:05.430 --> 01:30:08.950
and that allows you to see the monthly breakdown paid
1788
01:30:10.230 --> 01:30:11.880
to individuals
1789
01:30:11.880 --> 01:30:15.393
and again, only individuals assigned to your department.
1790
01:30:17.040 --> 01:30:18.810
And it's a useful tool
1791
01:30:18.810 --> 01:30:21.780
to see like Common Paymasters included in there
1792
01:30:21.780 --> 01:30:24.630
for any of the UVM medical center folks
1793
01:30:24.630 --> 01:30:26.100
and chairs of directors.
1794
01:30:26.100 --> 01:30:29.040
So once you click on that,
1795
01:30:29.040 --> 01:30:32.063
you would click on that report, you'd get a list
1796
01:30:32.063 --> 01:30:34.413
of all the departments you have access to.
1797
01:30:35.280 --> 01:30:40.200
In this case I'm just picking surgery, trauma surgery
1798
01:30:40.200 --> 01:30:44.520
and then there is a proceed button at the bottom
1799
01:30:44.520 --> 01:30:46.470
in ERS but it didn't really fit on my slide.
1800
01:30:46.470 --> 01:30:47.580
I didn't want it to get too small,
1801
01:30:47.580 --> 01:30:50.480
but yeah, click your department, click the proceed button,
1802
01:30:51.540 --> 01:30:53.490
you would click on the hyperlink for the individual
1803
01:30:53.490 --> 01:30:57.150
and there's purposes I've blocked out (laughing)
1804
01:30:57.150 --> 01:31:00.210
the identifying information for the person,
1805
01:31:00.210 --> 01:31:01.980
but you would click on the hyperlink here.
1806
01:31:01.980 --> 01:31:03.780
I think their name might even be a hyperlink,
1807
01:31:03.780 --> 01:31:08.070
but then it will bring you into what you're used to seeing
1808
01:31:08.070 --> 01:31:11.280
for effort certification for the initial view.
1809
01:31:11.280 --> 01:31:13.800
And so this isn't all that useful
1810
01:31:13.800 --> 01:31:15.330
and so you'd wanna click on
1811
01:31:15.330 --> 01:31:19.410
the total salary information hyperlink at the bottom
1812
01:31:19.410 --> 01:31:21.720
and that will bring you into the monthly breakdown.
1813
01:31:21.720 --> 01:31:24.930
And so here you have somebody who has Common Paymaster
1814
01:31:24.930 --> 01:31:26.550
for UVM Medical Center
1815
01:31:26.550 --> 01:31:29.310
and that's not gonna be on their salary distribution.
1816
01:31:29.310 --> 01:31:30.630
So their salary distribution
1817
01:31:30.630 --> 01:31:35.630
is gonna be broken up by these three here,
1818
01:31:37.020 --> 01:31:38.550
but you wanna see the impact
1819
01:31:38.550 --> 01:31:42.540
of the Common Paymaster here
1820
01:31:42.540 --> 01:31:46.350
or if they're a chair
1821
01:31:46.350 --> 01:31:50.730
and they have two different salary distribution breakdowns,
1822
01:31:50.730 --> 01:31:53.190
you wanna see the impact of both of those.
1823
01:31:53.190 --> 01:31:55.860
Again, if they have an additional pay
1824
01:31:55.860 --> 01:31:58.050
that would be added in down here as well.
1825
01:31:58.050 --> 01:32:01.350
So this is just a tool, another tool
1826
01:32:01.350 --> 01:32:02.370
to see those people
1827
01:32:02.370 --> 01:32:04.710
that are a little more complicated knowing
1828
01:32:04.710 --> 01:32:06.630
that they have dual appointments
1829
01:32:06.630 --> 01:32:10.140
or something non-traditional that
1830
01:32:10.140 --> 01:32:13.680
you can't just compare straight commitment percentage
1831
01:32:13.680 --> 01:32:16.080
to satellite distribution percentage,
1832
01:32:16.080 --> 01:32:17.250
and you wanna see the impact.
1833
01:32:17.250 --> 01:32:19.380
So again, this is updated throughout the year.
1834
01:32:19.380 --> 01:32:21.450
You can see this is current
1835
01:32:21.450 --> 01:32:26.450
and this is effort payroll through February 29th, 2024.
1836
01:32:27.720 --> 01:32:31.740
And I mean it's typical October you see all your college
1837
01:32:31.740 --> 01:32:35.640
of medicine clinical faculty I think it is that have
1838
01:32:35.640 --> 01:32:39.990
their distribution percentage breakdown change
1839
01:32:39.990 --> 01:32:43.713
because that's the fiscal year start for UVM Medical Center.
1840
01:32:44.550 --> 01:32:48.270
You'd also tend to get changes during January
1841
01:32:48.270 --> 01:32:52.530
because that's when the salary cap tends to become effective
1842
01:32:52.530 --> 01:32:54.150
and a date change with that.
1843
01:32:54.150 --> 01:32:59.150
So just different things to consider by using ERS,
1844
01:33:03.540 --> 01:33:05.760
and you would also have access to that
1845
01:33:05.760 --> 01:33:07.350
for any of your grad students.
1846
01:33:07.350 --> 01:33:11.323
So just going back to this report,
1847
01:33:14.010 --> 01:33:17.460
it's gonna list anyone in your department
1848
01:33:17.460 --> 01:33:20.070
who would have an effort certification form
1849
01:33:20.070 --> 01:33:24.960
based on commitments and or effort.
1850
01:33:24.960 --> 01:33:27.450
So somebody could have commitments but no effort yet
1851
01:33:27.450 --> 01:33:29.400
and they're gonna have an effort form
1852
01:33:29.400 --> 01:33:30.750
or anybody charged directly
1853
01:33:30.750 --> 01:33:33.420
or is cost share to sponsored agreements
1854
01:33:33.420 --> 01:33:34.890
will have an effort form
1855
01:33:34.890 --> 01:33:38.370
and once they're generated for the fiscal year,
1856
01:33:38.370 --> 01:33:41.450
but you'll see them all listed here
1857
01:33:41.450 --> 01:33:43.653
so it's another tool you can use.
1858
01:33:45.870 --> 01:33:50.870
It's not as widely used,
1859
01:33:51.240 --> 01:33:53.640
'cause again it's not available to everybody
1860
01:33:53.640 --> 01:33:56.730
like the PI portal is, which is why we switched
1861
01:33:56.730 --> 01:33:58.020
to using the PI portal
1862
01:33:58.020 --> 01:33:59.670
because it was getting the traffic
1863
01:33:59.670 --> 01:34:03.450
and it has a lot more flexibility for more people
1864
01:34:03.450 --> 01:34:04.743
to have access to it.
1865
01:34:05.640 --> 01:34:08.460
So again, prepare, review your individual effort,
1866
01:34:08.460 --> 01:34:12.960
review project personnel, have your action items
1867
01:34:12.960 --> 01:34:15.810
and that's your kind of quarterly verification
1868
01:34:15.810 --> 01:34:17.110
that goes round and round.
1869
01:34:20.910 --> 01:34:23.880
This preview data does include commitment data, correct?
1870
01:34:23.880 --> 01:34:26.700
Yeah, actually that is correct too.
1871
01:34:26.700 --> 01:34:30.840
So if there are commitments it'll show up here
1872
01:34:30.840 --> 01:34:32.580
and there are drilled down information
1873
01:34:32.580 --> 01:34:37.580
so you can see how that's broken down by direct
1874
01:34:37.590 --> 01:34:39.063
and cost share I believe,
1875
01:34:40.080 --> 01:34:43.680
yeah and I think there'd be a icon here
1876
01:34:43.680 --> 01:34:46.080
that would show you if there's cost share,
1877
01:34:46.080 --> 01:34:49.410
but anybody who hasn't taken
1878
01:34:49.410 --> 01:34:50.640
the effort certification training,
1879
01:34:50.640 --> 01:34:53.700
this is gonna look pretty foreign to you (laughing)
1880
01:34:53.700 --> 01:34:56.100
because there is a parent account
1881
01:34:56.100 --> 01:34:58.920
and then this is the child account.
1882
01:34:58.920 --> 01:35:00.780
So the parent has the commitment,
1883
01:35:00.780 --> 01:35:04.350
the child has the like the actual effort
1884
01:35:04.350 --> 01:35:07.320
and so these two lines here are tied.
1885
01:35:07.320 --> 01:35:10.470
So right now I see this has a 1% commitment
1886
01:35:10.470 --> 01:35:12.750
but there's nothing being allocated to it.
1887
01:35:12.750 --> 01:35:15.270
That's a conversation to have should there be,
1888
01:35:15.270 --> 01:35:20.270
is this right here, this suspense in money,
1889
01:35:21.420 --> 01:35:22.920
should some of that be allocated
1890
01:35:22.920 --> 01:35:24.300
to this project perhaps?
1891
01:35:24.300 --> 01:35:27.570
So those are discussions you could have
1892
01:35:27.570 --> 01:35:28.800
if you're familiar with this,
1893
01:35:28.800 --> 01:35:31.997
but it's just another tool that can be used
1894
01:35:35.700 --> 01:35:39.423
for anybody with commitments and effort throughout the year.
1895
01:35:42.870 --> 01:35:46.510
Yes, Sue put that year
1896
01:35:47.550 --> 01:35:49.330
our fiscal year period
1897
01:35:50.730 --> 01:35:51.903
or yeah are they?
1898
01:35:58.276 --> 01:36:01.609
So right now this is taking into account
1899
01:36:03.060 --> 01:36:07.440
the portion of commitment that falls in
1900
01:36:07.440 --> 01:36:09.930
the current reporting period.
1901
01:36:09.930 --> 01:36:13.053
So yes Sue, that's a really good question.
1902
01:36:14.880 --> 01:36:16.650
You're gonna have more visibility
1903
01:36:16.650 --> 01:36:18.420
and understanding of what the commitment is,
1904
01:36:18.420 --> 01:36:21.960
I think if you use the PI portal tool,
1905
01:36:21.960 --> 01:36:25.170
because this will annualize.
1906
01:36:25.170 --> 01:36:28.290
So say somebody had a 10% commitment
1907
01:36:28.290 --> 01:36:31.590
but only six months of that award
1908
01:36:31.590 --> 01:36:34.710
fell within this current fiscal year,
1909
01:36:34.710 --> 01:36:37.440
it's going annualize it to 5%
1910
01:36:37.440 --> 01:36:41.760
because when you look at it for the reporting period
1911
01:36:41.760 --> 01:36:45.137
of this fiscal year, total it's supposed to come out
1912
01:36:45.137 --> 01:36:49.560
to 5% because it's 10% for six months.
1913
01:36:49.560 --> 01:36:52.113
So that is another consideration to use.
1914
01:36:53.190 --> 01:36:56.610
The main point of this training really
1915
01:36:56.610 --> 01:36:58.830
is to use it for drilling down
1916
01:36:58.830 --> 01:37:02.083
to see the impacts of dual appointments
1917
01:37:04.260 --> 01:37:07.953
and additional pays in the monthly breakdown,
1918
01:37:09.720 --> 01:37:14.720
but the video is up, it is a long one
1919
01:37:15.660 --> 01:37:17.700
but we'll get into the details
1920
01:37:17.700 --> 01:37:19.800
of all of that in that training.
1921
01:37:19.800 --> 01:37:21.090
So if you aren't familiar with that,
1922
01:37:21.090 --> 01:37:21.923
reach out to me
1923
01:37:21.923 --> 01:37:22.770
and I can can walk you through
1924
01:37:22.770 --> 01:37:24.750
if you think it'd be helpful,
1925
01:37:24.750 --> 01:37:26.670
but we're not gonna focus too much on that right now,
1926
01:37:26.670 --> 01:37:28.920
but it is a very good point so thank you Sue.
1927
01:37:31.830 --> 01:37:34.113
So are there any other questions?
1928
01:37:39.660 --> 01:37:41.280
For reporting effort
1929
01:37:41.280 --> 01:37:45.723
and FTEs on progress reports for nine month faculty,
1930
01:37:46.560 --> 01:37:49.773
would you convert their distribution on the project
1931
01:37:49.773 --> 01:37:51.813
to a 12 month appointment?
1932
01:37:54.630 --> 01:37:56.040
Josh, do you have any insight on that?
1933
01:37:56.040 --> 01:38:00.210
I've never worked with progress reports
1934
01:38:00.210 --> 01:38:03.720
and I don't know,
1935
01:38:03.720 --> 01:38:06.060
I'm guessing that might be sponsored specific?
1936
01:38:06.060 --> 01:38:06.893
Yeah,-
1937
01:38:06.893 --> 01:38:09.930
USDA often often goes FTEs
1938
01:38:09.930 --> 01:38:11.230
on their progress reports.
1939
01:38:13.050 --> 01:38:15.393
So for USDA specific,
1940
01:38:16.920 --> 01:38:19.650
like you're talking about the one that's in,
1941
01:38:19.650 --> 01:38:21.750
oh my gosh, I forget what it's called, report, right?
1942
01:38:21.750 --> 01:38:23.200
Report, yeah.
1943
01:38:25.410 --> 01:38:26.243
So first of all
1944
01:38:26.243 --> 01:38:28.470
I don't think that that is considered
1945
01:38:28.470 --> 01:38:30.900
to be like an official reporting of effort
1946
01:38:30.900 --> 01:38:33.843
because if it was we would wanna review it.
1947
01:38:37.470 --> 01:38:38.820
Well what I would do is
1948
01:38:38.820 --> 01:38:42.060
I would convert everything to person months
1949
01:38:42.060 --> 01:38:44.160
because a person month doesn't matter
1950
01:38:44.160 --> 01:38:47.223
if someone's a 9 month faculty or a 12 month faculty.
1951
01:38:48.690 --> 01:38:52.920
That's what I would do for all of these.
1952
01:38:52.920 --> 01:38:54.510
So convert it to person months
1953
01:38:54.510 --> 01:38:55.800
and then back to FTEs.
1954
01:38:57.750 --> 01:38:58.950
Does report not allow you
1955
01:38:58.950 --> 01:39:00.557
to report in person months?
1956
01:39:02.222 --> 01:39:04.140
No you have to enter FTE
1957
01:39:04.140 --> 01:39:06.450
for each of the groups,
1958
01:39:06.450 --> 01:39:08.160
and I get this question a lot in Cals
1959
01:39:08.160 --> 01:39:10.683
'cause we have a lot of USDA awards.
1960
01:39:15.060 --> 01:39:17.660
Well yes, there's various ways of doing it.
1961
01:39:18.750 --> 01:39:22.770
One way of doing it would be to convert to person months
1962
01:39:22.770 --> 01:39:24.240
and then use that to figure out
1963
01:39:24.240 --> 01:39:28.023
what percent of a 12 month period someone worked.
1964
01:39:31.200 --> 01:39:32.970
There are other ways of doing it
1965
01:39:32.970 --> 01:39:34.500
if you don't wanna make that conversion,
1966
01:39:34.500 --> 01:39:36.000
but that's a pretty easy conversion,
1967
01:39:36.000 --> 01:39:38.183
so I would just probably suggest doing that.
1968
01:39:39.900 --> 01:39:40.850
Thank you.
1969
01:39:43.233 --> 01:39:48.000
All right Alex had for joint UVM Medical Center faculty,
1970
01:39:48.000 --> 01:39:50.610
is there another type of account
1971
01:39:50.610 --> 01:39:53.610
also called a commitment account
1972
01:39:53.610 --> 01:39:55.863
for the UVM portion of their pay?
1973
01:39:56.730 --> 01:39:57.563
I'm not sure I understand.
1974
01:39:57.563 --> 01:39:59.610
Like I know that there's the Common Paymaster
1975
01:39:59.610 --> 01:40:03.090
for the UVM medical center,
1976
01:40:03.090 --> 01:40:04.980
then there's like UVM pay
1977
01:40:04.980 --> 01:40:06.780
and then there's the Common Paymaster
1978
01:40:06.780 --> 01:40:10.350
is kind of the way I've always referred to it as,
1979
01:40:10.350 --> 01:40:13.653
but am I understanding your question correctly?
1980
01:40:19.380 --> 01:40:20.700
And you can take yourself off mute
1981
01:40:20.700 --> 01:40:22.100
if it's easier to just...
1982
01:40:25.890 --> 01:40:30.093
Yeah, so you're saying that there is another one?
1983
01:40:32.760 --> 01:40:36.213
I mean in my mind there's two job data,
1984
01:40:37.149 --> 01:40:39.510
two job data records in PeopleSoft.
1985
01:40:39.510 --> 01:40:42.870
And I've always just referred to the UVM side,
1986
01:40:42.870 --> 01:40:45.660
but in either way like bullet distribution,
1987
01:40:45.660 --> 01:40:47.700
well the Common Paymaster doesn't even have
1988
01:40:47.700 --> 01:40:50.190
a distribution, the hospital side,
1989
01:40:50.190 --> 01:40:51.990
it's just the amount that goes to them
1990
01:40:51.990 --> 01:40:56.990
and then you allocate the UVM portion 100%
1991
01:40:57.000 --> 01:40:59.013
on the just salary distribution, so.
1992
01:41:00.390 --> 01:41:02.520
But if other questions come up,
1993
01:41:02.520 --> 01:41:06.303
definitely feel free to reach out to us.
1994
01:41:07.380 --> 01:41:10.623
You can either contact cost accounting or just me directly.
1995
01:41:11.520 --> 01:41:12.660
If you have any feedback you wanted
1996
01:41:12.660 --> 01:41:14.010
to give on this presentation
1997
01:41:14.010 --> 01:41:18.450
or the tools, we're happy to hear those.
1998
01:41:18.450 --> 01:41:20.340
We do have again, the effort website.
1999
01:41:20.340 --> 01:41:23.880
We have overviews, there's policies, effort verification
2000
01:41:23.880 --> 01:41:25.410
user guide that walks you through this.
2001
01:41:25.410 --> 01:41:28.710
This presentation will go up as well.
2002
01:41:28.710 --> 01:41:30.570
And again, once I get this captioned,
2003
01:41:30.570 --> 01:41:33.240
we'll get this on there as well.
2004
01:41:33.240 --> 01:41:36.060
It'll just replace the one that's on there
2005
01:41:36.060 --> 01:41:39.750
and then there's some great FAQs there as well.
2006
01:41:39.750 --> 01:41:43.683
So be in touch if you need us.
2007
01:41:45.330 --> 01:41:47.340
And then if you wanted to stay after
2008
01:41:47.340 --> 01:41:51.720
and do anything here for like walking through any of these,
2009
01:41:51.720 --> 01:41:55.213
the great thing about the team's presentation
2010
01:41:57.540 --> 01:41:59.760
is you kind of can walk through it as you as we go,
2011
01:41:59.760 --> 01:42:02.060
so I'm guessing a lot of you did that as well,
2012
01:42:02.940 --> 01:42:04.590
but feel free to reach out
2013
01:42:04.590 --> 01:42:06.930
or stay after if you would like.
2014
01:42:06.930 --> 01:42:09.933
I am going to stop the recording though,
2015
01:42:17.860 --> 01:42:19.630
and thank you all for coming.