Permits & Licensing Casework template
A service catalogue where each permit type carries its statutory determination period and fee, applications that compute their own legal deadline from the date of receipt — so an overdue case is a filter, not a discovery — and the site inspections feeding the decision. Applicants carry the NACE activity code the permit is issued against.
Tables
Service catalogue
Service code, Service, Directorate, Statutory period (days), Fee, Appealable, Cases, Cases received, Fees due, Notes
Cases
Case reference, Applicant, Applicant activity (NACE), Service, Service record, Statutory period (days), Fee, State, Received via, Case officer, Received, Decided, Fee paid, Site and 6 more
Inspections
Inspection, Case, Case record, Applicant, Carried out, Inspector, Result, Follow-up in (days), Follow-up due, Notes
Views
- Casework board (kanban)
- All cases (grid)
- Statutory deadlines (calendar)
- Case sites (map)
- Cases by service (chart)
- Open casework (grid)
- Inspection log (grid)
- Inspection calendar (calendar)
- Service catalogue (grid)
Forms
- Submit an application
Automations
- Acknowledge a new application
- Email the applicant on a decision
- Daily statutory-deadline sweep
- “Cases” reached “Withdrawn”
- Daily sweep — still open in “Cases”
- “Fee paid” was ticked in “Cases”
- Large value in “Follow-up in (days)”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.