APEX Tracker — Agency Personnel & Expiration Tracking

Total Officers

Sworn law enforcement

Total Dispatchers

Communications personnel

Total Civilians

Non-sworn employees

Fully Certified

All certs current

Expired Certs

Requires action

Expiring Soon

Within 90 days

In FTO Program

Probationary officers

📅 Yearly Mandated Training

🥧 Cert Status Overview

🥧 Certs by Type

📊 Monthly Expirations

📅 Upcoming Expirations (12 Months)

👮 Roster

🏢 Org Chart

🎖 Training Officers

🔄 Transfers & Assignments

Officer Roster

Badge #	Officer Name	Rank	Division	Unit / Assignment	Watch	Platoon	Cert Status	FTO	Actions

Department Org Chart

Training Officers

⚙ Specialty Categories

FILTER BY INSTRUCTOR SPECIALTY — CLICK TO TOGGLE, SELECT MORE THAN ONE TO COMBINE

Transfers & Assignment Changes

Date	Officer	From Division	From Unit	To Division	To Unit	Watch	Platoon	Reason

⛉ Equipment

🗂 Equipment Types

📖 Usage History

📅 Daily Activity

📦 Archived

📄 Document Tracker

Equipment

Type	Make / Model	Serial #	Asset #	Status	Location	Responsible Officer	Signed Out	Condition	Actions

Equipment Types

Equipment Usage History

Officer	Equipment	Serial #	Signed Out	Returned	Time Out	Out / In Condition	Status	Actions

Daily Equipment Activity

📦 Archived Equipment Records

📋 Cert Registry

🔍 Cert Search

📂 Upload Cert Files

🏛 Issue In-House Cert

🖼 Certificate Template

✅ Compliance Board

🎖 PTC Recertification

Certification Registry

Defined Certification Types

Click a certification type to edit or deactivate it.

Issue External Certification

Select Officer

Certification Type

Issue Date

Expiration Date

♾ NO EXPIRATION

Issuing Agency / Instructor

Certificate # / ID

📄

Click to attach scanned certificate

All Issued Certifications

Officer	Certification	Cert #	Uploaded	Issued	Expires	Days Left	Agency / Instructor	Source	Certificate	Status

Certification Search

QUICK:

Officer	Rank	Unit / Division	Certification	Expires	Days Left	Status
ENTER A SEARCH TERM OR SELECT A FILTER ABOVE

Upload Certification Files

PDF · PNG · JPG · Multi-file supported

🔍 AUTO NAME DETECTION

Select Officer

Add Files

Tag & Save

1 — Select Officer

Search Officer

📂

Drop PDF / image files here

or click to browse — you can select multiple files at once

▼ Uploaded Certification Files (0)

Officer	File Name	Cert Type	Issued	Expires	Uploaded	File	Actions

Issue In-House Certification

Certificate Details

Certificate Template

Recipient Officer *

Certification / Training Title *

Certification Type (for tracking)

Certificate Date

Expiration Date (for tracker) ♾ No Expiration — this certification never expires

Certificate # / ID

Instructor / Signatory 1

Signatory 2 (Chief / CO)

Live Certificate Preview

Auto-updates as you type

Certificate Template Library

Show archived

2026

COMPLIANCE BOARD

🟢 Current🟠 Expiring ≤90 days🔴 Expired⬜ Not on file

📚 Archived Compliance Boards

👮 Trainees

🎖 FTO Instructors

📝 Daily Obs. Reports (DOR)

✅ Final Review

👮 Current Trainees (0)

Trainee	Current FTO	Previous FTOs	Phase	Started	Last Evaluation	Progress	Status	Actions

All FTO Records

Badge #	Officer	FTO Assigned	Start Date	Phase	Avg Score	Progress	DORs Filed	Status	Actions

FTO Instructor Roster

Daily Observation Reports

📎 Upload Scanned DOR

Trainee

Evaluation Date

Phase

📄

Click to attach scanned DOR (PDF/Image)

Date	Trainee	FTO	Phase	Shift	Avg Rating	NRT Flags	Type	File	Status	Actions

Administrator Final Review

Date	Trainee	DORs Filed	Program Days	Overall Score	Recommendation	Coordinator	Report	Actions

Analytics & Reports

🥧 FTO Phase Distribution

📊 FTO Avg Score by Category

🥧 Rank Breakdown

📊 Cert Compliance Rate

Certification Compliance Report

Certification	Total Issued	Current	Expired	Expiring ≤90d	Compliance %

▦ Weekly Shift Schedule

🎓 Training Schedule

📅 Training Calendar

🔗

VCS POSS Integration Note

VCS POSS does not expose a public API for direct live sync. This scheduler mirrors POSS logic (shift rules, manpower floors, role-based scheduling). Use Export → VCS CSV to import your schedule directly into POSS, or contact VCS at support@vcssoftware.com to inquire about enterprise API access for custom integrations.

Weekly Schedule

⚙ Department Manpower Settings

Min Patrol Officers / Day

Min Supervisors / Day

Patrol Days Off / Week (per officer)

Default Shift Length (hrs)

Day Shift Start

Night Shift Start

Registration Rules

● Patrol Officers — Scheduled on days OFF from patrol (training uses rest days).
● Admin / Support Services — Scheduled on days THEY WORK (during office hours).
● Detectives — Scheduled on working days (no disruption to patrol floor).
● System enforces minimum manpower floors — will not schedule if patrol drops below minimum.

🔫 Weapon Register

🎯 Ammunition & Target Inventory

🏅 Qualification Scores

📊 Analytics & Reports

Weapons & Equipment Register

Officer	Duty Status	Type	Make / Model	Serial #	Caliber	Qualified	Qual Expiry	Notes	Actions

Weapon Qualification Scores

QUALIFICATION YEAR

Enter Qualification Result

Select Officer *

Qualification Type *

Less-Lethal Device *

Qualification Date *

Cycle / Session *

Day Score

Night Score

Result

🔫 On-Duty Firearm Used

🌙 Off-Duty Firearm Used (optional)

Notes / Comments

Officer	Type	Weapon / Device	Date	Cycle	Day	Night	Result	Instructor	Notes	Actions

2026

INVENTORY YEAR

Date	Type	Item	Category	Qty In	Qty Out	Balance	Training Event	Notes	Logged By

📚 Archived Inventory Years

Ammunition & Target Analytics

Compare year:

vs.

Usage by Ammunition Type

Usage by Training Event

Real Ammo vs. Simunition vs. Targets

Year-over-Year Comparison

Command Staff Summary — Year-to-Date

⏱ Hours Log

📱 QR Sign-In

🔔 Pending Sign-Ins

📋 Sign-In Sheets

Training Hours Log

Officer	Date	Course / Training	Category	Hours	POST Hrs	FEMA Hrs	Instructor	Location	Source	Actions

QR Code Training Sign-In

📋

Google Forms Integration — Live QR Sign-In

Officers scan the QR code with any phone camera → Google Form opens instantly → they fill it out → responses appear in your Google Sheet in real time.

One-time setup (5 minutes): 1. Create a Google Form at forms.google.com with the fields shown below
2. Click the ⋮ menu → Get pre-filled link → fill one sample entry → Copy Link
3. Paste that link into Google Form Base URL below and map the field IDs
4. Done — every session auto-populates course/date/hours into the form

⚙ Google Form Configuration

Google Form Base URL *

Paste the viewform URL (not the edit URL)

Field Entry IDs

Create these questions in your Google Form, then find each field's entry ID from the pre-fill link (format: entry.XXXXXXXXX)

Officer Name field ID

Badge # field ID

Course Name field ID

Category field ID

Date field ID

Hours field ID

Instructor field ID

Location field ID

⚡

Auto-Sync — Google Apps Script Bridge

Responses auto-appear in Pending Sign-Ins. No CSV. No manual steps.

Apps Script Web App URL

Paste the URL from Step 4 of the setup guide below

Poll Interval

📖 Apps Script Setup Guide (one-time, ~10 min) ▼

One-time setup. After this, responses auto-sync forever.

Step 1 — In your Google Form → click the Responses tab → click the Google Sheets icon → Create a new spreadsheet

Step 2 — In the Google Sheet → click Extensions → Apps Script

Step 3 — Delete all existing code and paste in the script below, then click Save (💾)

Step 4 — Click Deploy → New Deployment → Type: Web App → Execute as: Me → Who has access: Anyone → Deploy → Copy the URL

Step 5 — Paste the URL in the Apps Script Web App URL field above and click ▶ Start Auto-Sync

Paste this into Apps Script (Code.gs)

Manual Fallback (if Auto-Sync not configured)

📅 Configure Training Session

Training Title / Course *

📂 Repository Structure

📁/certificationsScanned cert files by badge # subdirectoryToday
📁/fto-recordsFTO evaluation forms and progress logsToday
📁/reportsAuto-generated compliance reportsToday
📄officers.jsonMaster officer rosterToday
📄certifications.jsonAll issued certificationsToday
⚙️.github/workflows/expiry-alerts.ymlAuto weekly cert expiry scanToday

💾 Export / Sync Data

⚙️ App Configuration

App version: 1.0.0 · Build: APEX-TRACKER-2026

💾 Auto-Save Status

Loading auto-save info...

📦 Backup Files

📥 Restore from Backup

Select a WNYP_CMS_Backup_*.json file to restore officer records, certifications, FTO data, weapons, and training hours.

🗂 Personnel Archive

Name	Rank at Separation	Badge	Separation Date	Previous Assignment	Years of Service	Status	Actions

🔧 AI Maintenance Tool

ADMIN ONLY — POWERED BY CLAUDE FABLE 5

🔍 System Diagnostic Scanner

Run an automated scan of the application state to detect data issues, missing records, and configuration problems.

          Ready. Click Run Full Scan to begin.
        

⚡ Quick Fix Tools

🤖 AI Command Interface CLAUDE FABLE 5

Type a plain-language command and the AI will analyze the application, diagnose the issue, and provide a fix or explanation. All commands are logged.

── AI MAINTENANCE CONSOLE ──

Claude Fable 5 maintenance engineer online. I have live visibility into your application state and can help you:
• Diagnose and fix bugs in the application
• Explain how any feature works
• Identify data inconsistencies
• Suggest improvements
• Answer questions about the system in plain language

Type a command or question below to get started.

Quick:

Enter to send · Shift+Enter for new line · All commands logged in audit trail

⛨ PATROL HUB

Field reference — ordinances · NJ Title 2C · NJ Title 39

⌂ Patrol Hub

🏛 Municipal Ordinances

⚖ Title 2C

🚗 Title 39

📋 Complaint Manual

Patrol Hub is provided as a department reference resource. Officers remain responsible for following current law, Attorney General directives, department policy, and official legal sources.