f_schedule

f_schedule

Purpose

  1. Personnel scheduling fact table.

Relationships


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

    • Many schedules link to one personnel record

    • Referenced through personnel_id

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

    • Many schedules link to one user

    • Referenced through user_id


Table


Column

Type

Description

id

integer

Primary key

client_code

varchar

Organization identifier

user_id

integer

User reference

public_name

varchar

Public name

first_name

varchar

First name

middle_name

varchar

Middle name

last_name

varchar

Last name

phone

varchar

Contact phone

personnel_id

integer

Personnel reference

personnel_start_date

date

Start date

personnel_secondary_start_date

date

Secondary start

personnel_start_date_ranking

smallint

Start ranking

personnel_agency_id

varchar

Agency ID

personnel_badge_number

varchar

Badge number

personnel_payroll_id

varchar

Payroll ID

work_date

date

Work date

start_at_local

timestamp

Start time

end_at_local

timestamp

End time

duration_hours

numeric

Duration

created_by

integer

Creator reference

created_at

timestamp

Creation time

work_type_multiplier_factor

numeric

Pay multiplier

notes

varchar

Notes






    • Related Articles

    • f_all_schedule

      Purpose Comprehensive scheduling fact table tracking personnel assignments and work schedules. Relationships activity_type: Many-to-One (N:1) Many schedules link to one activity type Referenced through activity_type field v_fire_dept_user: ...

    • f_fire_inspection

      Purpose Documents fire inspections and their results. Relationships v_occupancy: Many-to-One (N:1) Many inspections can link to one occupancy Referenced through place_id v_fire_inspection_violation: One-to-Many (1:N) One inspection can have many ...

    • Import Fee Schedule

      Purpose Statement The Import Fee Schedule feature allows administrators to efficiently bulk upload multiple fee schedule items into the system using a standardized Excel template. This feature streamlines the process of setting up billing structures ...

    • Navigating the Invoicing Fee Schedule

      Purpose Statement The Fee Schedule List provides administrators with a centralized interface to manage all billing line items within the Fire/EMS platform. This feature enables efficient navigation, searching, and bulk management of fee structures ...

    • Inspection Record - Schedule Reinspection

      Purpose Statement The Schedule Reinspection feature enables fire prevention officers and inspection personnel to efficiently schedule follow-up inspections when violations or failed checklist items are identified during initial inspections. This ...