activity_type

activity_type

Purpose

  1. Tracks types of activities and their configurations. 

Relationships


  • f_all_schedule: One-to-Many (1:N)

    • One activity_type can be associated with many schedules

    • Referenced in f_all_schedule through activity_type field

  • v_event_payroll_summary: One-to-Many (1:N)

    • One activity_type can have many payroll entries

    • Referenced through activity_type_id

  • v_payroll_summary: One-to-Many (1:N)

    • One activity_type can have many payroll summaries

    • Referenced through activity_type_id




Table

Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization identifier

name

varchar(50)

Activity type name

shortcode

varchar(8)

Short code identifier

color

varchar(7)

Color code

is_default

boolean

Default flag

notes

text

Additional notes

created_by

integer

Creator user ID

created_at

timestamp

Creation timestamp

is_archived

boolean

Archive status

archived_at

timestamp

Archive timestamp

archived_by

integer

Archiving user ID





    • Related Articles

    • Personnel Setup - Activity Types

      Purpose Statement Activity types serve as organizational categories for tracking personnel activities across incident documentation and training events. They enable departments to accurately categorize work for payroll processing, compliance ...

    • Inspection Type - Part 2: Creating and Editing an Inspection Checklist

      Purpose Statement This article demonstrates how to create and edit comprehensive inspection checklists within the Fire/EMS software platform. Inspection checklists enable departments to standardize their inspection processes, ensure regulatory ...

    • Inventory: Creating an Inventory Packaging Type

      Purpose The purpose of this article is to inform users how to create a new inventory packaging type in the First Due system. Inventory packaging allows users to document the packaging specifications of inventory. Video Directions 1. Click on Assets. ...

    • Risk Assessment - OVAP Scoring

      Purpose Statement The purpose of this feature is to calculate the Risk Assessment Score (OVAP Score) for occupancies to identify and evaluate important factors and characteristics that determine their relative risk to a community. This scoring system ...

    • Inspection Type - Part 3: Forms

      Purpose Statement This article demonstrates how to configure the Forms section when setting up an Inspection Type. The Forms section determines which forms are used for different inspection outcomes (Pass, Fail, Corrected) and controls whether ...