3Business Questions
Overview
For each business question in this chapter, links are provided for more detailed information about the subject areas, job roles, and duty roles associated with the business question.
What is the most common inspection outcome for incidents and cases?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the average number of inspections that were scheduled and completed during a given period?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many inspections were carried out by the code officers?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the primary reasons for major code case violations?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many code cases were reported in a given period, by issue type?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the monthly trend of reported incidents?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many citations are there compared to the same period last year?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the primary reasons for major inspection violations?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the workload distribution across all inspectors in a given period?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the total inspection activity for an inspection type?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the total demand for inspections in a given period?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the total permit activity for a permit type in a given period?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the total valuation and assessed fee of permit activity?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the busiest time for permit applications?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
When does the agency issue the most permits?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the distribution of permits across different permit statuses?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Who is the primary contact for a permit?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How long are plan review cycles on average?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many plan review cycles are needed for a permit application on average?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the distribution of plan review cycles across plan reviewers in a given period?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many plan reviews had override decisions?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the different conditions applied to planning applications?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the different hearing decisions for a given application type?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the different activities tracked for a planning application?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the total application activity for a planning entitlement type?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the total valuation and assessed fee for a planning application?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the distribution of planning applications across different planning application statuses?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the property land value changes in a given period?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the net asset value changes in a given period?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the property classifications by zone?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the property valuations by district?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the total activity for fees?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the total payment by fee type?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How much in fees was received in a quarter?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Which projects were started in a specified timeframe?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What transactions are associated with a project?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the inspections carried out for a project?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How much time elapsed between statuses in the workflow process?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How much time elapsed between permit issuance and final inspection?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the average number of workflow tasks by permit type?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many withdrawals were there in a given period?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many times did the agency staff alter the workflow during a given period?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many users run OTBI analyses?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Who are the top N OTBI users?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the weekly OTBI analysis usage trend?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the top N most frequently-run OTBI analyses?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many predefined OTBI analyses have been run in the past month?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many custom OTBI analyses have been run in the past month?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many ad-hoc OTBI analyses have been run in the past month?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the execution history of dashboard X in the past month?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Which analyses have low usage in the past month?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many OTBI SOAP web services have been run in the past month?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the long-running analyses in the past month?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the OTBI execution time histogram in the past month?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Which analyses have the longest response time?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Which analyses have high data row count?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Which analyses reached OTBI max row limit?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the common execution errors in the past month?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
How many analyses and dashboards failed in the past month?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the most commonly used OTBI subject areas?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are the least-used OTBI subject areas?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Which subject areas have slow performance?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Which subject areas have large data volume?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Which analyses have low usage because of poor performance?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What is the database SQL execution time and row count?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Why am I not able to view certain subject areas with my login credentials?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Which data security policy would provide access to the data I need to see?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Can I view and edit a particular page? If yes, which functional security policy do I need to provide to a user who needs similar access?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
I have not added a specific role to a user, but the user seem to have this job role. Can I trace how has this been inherited by the user?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
What are all the data security privileges that a specific user added?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question:
Which roles were added with a specific functional security policy, and who added them?
Subject Areas
The following subject areas contain the folders and attributes needed to answer this business question:
Job Roles
The following job roles secure access to the data related to this business question:
Duty Roles
The following duty roles secure access to the data related to this business question: