PBEM CPT Data Catalog: Difference between revisions
| Line 11: | Line 11: | ||
'''Source:''' The records for this measurement go back to the first class in 1994, via hard copy attendance sheets (and later, MS Excel-based tracking sheets and scans of dated sign in sheets). The information is currently tracked and stored on [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER] and viewable as a filter. | '''Source:''' The records for this measurement go back to the first class in 1994, via hard copy attendance sheets (and later, MS Excel-based tracking sheets and scans of dated sign in sheets). The information is currently tracked and stored on [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER] and viewable as a filter. | ||
'''Update Procedure:''' Every time a Basic NET class is completed, it should be inputted to [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER]. That should prompt datasheets and dashboards to update automatically. | '''Update Procedure:''' Every time a Basic NET class is completed, it should be inputted to [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER]. That should prompt datasheets and dashboards to update automatically. The SmartSheet formula governing data retrieval on the datasheets is: | ||
<pre> | |||
=COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | |||
</pre> | |||
'''Dashboard Locations:''' TBA | '''Dashboard Locations:''' TBA | ||
Revision as of 22:54, 2 December 2025
WHAT do PBEM Volunteers Do?
Number of Basic NET Classes
Type: Output, Measurement
Available date range: Q2 1994 - present
Description: This is a count of each Basic NET class completed.
Source: The records for this measurement go back to the first class in 1994, via hard copy attendance sheets (and later, MS Excel-based tracking sheets and scans of dated sign in sheets). The information is currently tracked and stored on PBEM CPT Activities/B.) Training TRACKER and viewable as a filter.
Update Procedure: Every time a Basic NET class is completed, it should be inputted to PBEM CPT Activities/B.) Training TRACKER. That should prompt datasheets and dashboards to update automatically. The SmartSheet formula governing data retrieval on the datasheets is:
=COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
Dashboard Locations: TBA
Hours Categories
These are hours reports that come from MIP. The reports are taken quarterly and reflect when a volunteer reports, not necessarily when the activity took place (which is why, for example, you might see BNT hours logged in a quarter where there was no Basic NET class).
Basic NET Training
- Refresher training
- Mandatory Reporter for Child and Elder Abuse
- Independent Study
- Unit 9
- Unit 8
Advanced NET Training/Exercises
- Zoom trainings/lectures
- Conferences
- Basic BEECN training (basic training for a VSF is advanced training)
- Serving as a survivor actor
Deployment Hours/Program Service
Basic criteria: hours logged by NETs that are paraprofessional activities.
- NET Meetings
- Event planning meetings (e.g. CDE or NETcamp planning meetings)
- Moulage
- TSA K-9 Decoy
- Clearing storm drains
- Instruction
- BEECN or radio maintenance
- Friends of Portland NET activities
- Wiki work
- Team Leader responsibilities
- Anniversary parties
Community Engagement
Hours logged only for public facing events, including trainings for community groups.