f_schedule

Purpose

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

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