f_all_schedule

f_all_schedule

Purpose


  1. 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: Many-to-One (N:1)

    • Many schedules link to one user

    • Referenced through user_id

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

    • Many schedules link to one personnel record

    • Referenced through personnel_id



Table


Column

Type

Description

id

integer

Primary key

client_code

varchar

Organization identifier

user_id

integer

Associated user ID

public_name

varchar

User's public name

first_name

varchar

User's first name

middle_name

varchar

User's middle name

last_name

varchar

User's last name

phone

varchar

Contact phone

personnel_id

integer

Personnel ID

personnel_start_date

date

Start date

personnel_secondary_start_date

date

Secondary start date

personnel_start_date_ranking

smallint

Start date ranking

personnel_agency_id

varchar

Agency ID

personnel_badge_number

varchar

Badge number

personnel_payroll_id

varchar

Payroll ID

personnel_fema_id

varchar

FEMA ID

personnel_firefighter_id

varchar

Firefighter ID

personnel_career_volunteer

varchar

Career/volunteer status

personnel_cad_id

varchar

CAD ID

personnel_days_scheduled_code

varchar

Days scheduled code

personnel_hours_scheduled_code

varchar

Hours scheduled code

personnel_status_code

varchar

Status code

personnel_is_active

boolean

Active status

email

varchar

Email address

personnel_rank

varchar

Rank

personnel_shift

varchar

Shift assignment

personnel_apparatus

varchar

Apparatus assignment

personnel_station_num

varchar

Station number

personnel_division

varchar

Division

work_date

date

Work date

start_at_local

timestamp

Local start time

end_at_local

timestamp

Local end time

duration_hours

numeric

Duration in hours

created_by

integer

Creator user ID

created_at

timestamp

Creation timestamp

is_trade

boolean

Trade flag

is_off_roster

boolean

Off roster flag

is_holdover

boolean

Holdover flag

is_kelly_day

boolean

Kelly day flag

is_approved

boolean

Approval status

status_code

varchar

Status code

off_roster_pay_amount

numeric

Off roster pay amount




    • Related Articles

    • f_schedule

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

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