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 To explain how to setup activity types in the Personnel Module. Activity types are used within: Incident Documentation In the Payroll Summary Activities and Training In the Payroll Summary Video Directions 1. Click on Personnel > Setup. 2. ...

    • Inspection Type - Part 3: Forms

      Purpose The purpose of this Knowledge Base Article is to demonstrate setting up the Forms Section for an Inspection Type. Related Articles Inspection Type - Part 1: Creating and Editing Inspection Type Inspection Type - Part 2: Creating and Editing ...

    • Create and Edit Permit Type

      Purpose The purpose of this Knowledge Base Article is to learn how to create and edit permit types. Related Article Adding Custom Data Fields to Permit Type Inspection Type - Part 4: Email Video Instructions NOTE: Permit Types can be cloned from one ...

    • Inspection Type - Part 1: Creating and Editing Inspection Type (Review First)

      Purpose The purpose of this Knowledge Base Article is to demonstrate how to create and edit an Inspection Type. Related Articles Inspection Type - Part 2: Creating and Editing an Inspection Checklist Inspection Type - Part 3: Forms Inspection Type - ...

    • Apparatus: Creating a Fluid Type

      Purpose The purpose of this article is to inform users how to create a fluid type in the First Due system. Fluid types allow users to track how much, what types, and costs of fluids that are added to an apparatus. Video Directions 1. Click on Assets. ...