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

    • Import Fee Schedule

      Purpose The purpose of this Knowledge Base Article is to demonstrate how to import a fee schedule. Video Instructions 1. Click on Invoicing. 2. Click on Fee Schedule. 3. Click on Import Fee Schedule. 4. Click on Download sample spreadsheet. 5. Sample ...

    • Navigating the Invoicing Fee Schedule

      Purpose To demonstrate the navigation and features of the Fee Schedule List. Video Instructions 1. Click on Invoicing. 2. Click on Fee Schedule. 3. Select or enter appropriate Search Criteria. 4. Click on search to search/filter by the criteria ...

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

    • Inspections: Scheduling Inspections

      Purpose To review the places and methods to schedule an Inspection in your First Due account. There are five places in the system to schedule inspections from. Video Instructions Method #1: Schedule Inspection from Occupancy Record. 1. Click on ...

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