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 ...

    • Medications Setup - Count Scheduler

      Purpose The purpose of the article is to help navigate and create new count schedulers. Video Instructions 1. Begin by navigating to the Medications module and selecting on Setup. 2. Now select on the Count Scheduler section. 3. At the top of the ...