PBEM CPT Data Catalog: Difference between revisions

From Portland NET Wiki
Jump to navigation Jump to search
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.