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

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