2Subject Areas
Overview
This chapter provides information on the subject areas with data you maintain in Oracle Public Sector Cloud. These subject areas, with their corresponding data, are available for you to use when creating and editing analyses and reports. The information for each subject area includes:
-
Description of the subject area.
-
Business questions that can be answered by data in the subject area, with a link to more detailed information about each business question.
-
Job roles and duty roles that can be used to secure access to the subject area, with a link to more detailed information about each job role and duty role.
-
Primary navigation to the work area that is represented by the subject area.
-
Time reporting considerations in using the subject area, such as whether the subject area reports historical data or only the current data. Historical reporting refers to reporting on historical transactional data in a subject area. With a few exceptions, all dimensional data are current as of the primary transaction dates or system date.
-
The lowest grain of transactional data in a subject area. The lowest transactional data grain determines how data are joined in a report.
-
Special considerations, tips, and things to look out for in using the subject area to create analyses and reports.
OTBI Performance Real Time
Description
Analyze OTBI analysis and dashboard usage and performance, including logical and physical database SQL, execution time, and errors. View the last six months of OTBI usage and performance trends, commonly used subject areas, and report errors. This subject area provides data to monitor and disagnose OTBI reporting performance. Historical data older than six months is purged each week.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Not available
Time Reporting
This subject area supports six-month usage history data.
Time dimension is linked to "Time"."Report Start Date".
Transactional Grain
This subject area returns data at the grain of a query execution and database physical SQL.
Special Considerations
This subject area contains six months of query execution data. Each OTBI query execution can generate multiple database SQL statements. Usage data volume grows over time, so use proper filters to narrow reporting data load. Because this subject area has no data security, you're advised to secure user access to it.
OTBI Usage Real Time
Description
Analyze six months of subject area and analysis usage trends and patterns with a simpler and lighter-weight selection of OTBI usage metrics, including for example user, report and subject area usage patterns. Historical data older than six months is purged each week.
Business Questions
This subject area can answer the following business questions:
-
What is the execution history of dashboard X in the past month?
-
How many custom OTBI analyses have been run in the past month?
-
How many ad-hoc OTBI analyses have been run in the past month?
-
How many predefined OTBI analyses have been run in the past month?
-
How many OTBI SOAP web services have been run in the past month?
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Not available
Time Reporting
This subject area supports six-month usage history data.
Time dimension is linked to "Time"."Report Start Date".
Transactional Grain
This subject area returns data at the grain of a query execution.
Special Considerations
This subject area contains six months of usage history. It doesn't contain database SQL execution details so it has less data volume.
Public Sector Cloud - Code Enforcement Case Real Time
Description
Real time information on reporting various violations, as well as citations by issue type and issues by subtype, in a given period.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > Code Enforcement
Time Reporting
This subject area supports case transactions history.
Time dimension is linked to Case Submission Date.
Transactional Grain
This subject area returns data at the grain of Cases (PSC_CE_CASE).
Special Considerations
None.
Public Sector Cloud - Permit Inspection Activity Real Time
Description
Real time information on volume by inspection type, parcel, assignment, duration, associated permit type, and date dimensions of inspections types processed by an agency.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > Inspections > Inspections
Time Reporting
This subject area supports inspection transactions history.
Time dimension is linked to Inspection Result Date.
Transactional Grain
This subject area returns data at the grain of Inspections (PSC_INS_INSPECTION).
Special Considerations
None.
Public Sector Cloud - Permits Real Time
Description
Real time information on volume, revenue and square footage facts by permit type, parcel, permit status, assignment, and date dimensions of permits processed by an agency.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > Permits > Permits
Time Reporting
This subject area supports permits transactions history.
Time dimension is linked to Permit Application Date, Permit Issue Date.
Transactional Grain
This subject area returns data at the grain of Permit Records (PSC_LNP_RECORD).
Special Considerations
None.
Public Sector Cloud - Plan Review Real Time
Description
Real time information about the plan review and facts by plan review decisions, cycle time, and agency.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > My Tasks > My Plan Reviews
Time Reporting
This subject area supports plan review transactions history.
Time dimension is linked to Plan Review Decision Date.
Transactional Grain
This subject area returns data at the grain of Plan Review Cycles (PSC_LNP_PR, PSC_LNP_PR_USER).
Special Considerations
None.
Public Sector Cloud - Planning Application Real Time
Description
Real time information on volume, revenue facts by parcel, application status, assignment, and date dimensions of permits processed by an agency.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > Planning and Zoning > Planning Applications
Time Reporting
This subject area supports planning application transactions history.
Time dimension is linked to Planning Applications File Date.
Transactional Grain
This subject area returns data at the grain of Planning Application Records (PSC_LNP_RECORD).
Special Considerations
None.
Public Sector Cloud - Projects Real Time
Description
Real time information on project level volume, fees, payment facts by transaction type, transaction status by an agency.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > Projects > Project List
Time Reporting
This subject area supports project transactions history.
Time dimension is linked to Project Start Date.
Transactional Grain
This subject area returns data at the grain of Project Records (PSC_COM_PROJECT, PSC_COM_PROJECT_RECORD).
Special Considerations
None.
Public Sector Cloud - Property History Real Time
Description
Real time history information on total area and land value facts by property type and districts by an agency.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > Property Information > Parcel
Time Reporting
This subject area supports past property valuation history.
Time dimension is linked to Property Valuation Date.
Transactional Grain
This subject area returns data at the grain of Parcel (PSC_COM_PARCEL_B , PSC_COM_PARCEL_VALUE_F).
Special Considerations
None.
Public Sector Cloud - Property Real Time
Description
Real time information on total area and land value facts by property type and districts by an agency.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > Property Information > Parcel
Time Reporting
This subject area supports property valuation transactions history.
Time dimension is linked to Property Valuation Date.
Transactional Grain
This subject area returns data at the grain of Parcel (PSC_COM_PARCEL_B , PSC_COM_PARCEL_VALUE_F).
Special Considerations
None.
Public Sector Cloud - Receipts Real Time
Description
Real time information on the fees and payment facts by parcel by an agency.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > Billing and Payment > Payment History
Time Reporting
This subject area supports receipt transactions history.
Time dimension is linked to Transaction File Date.
Transactional Grain
This subject area returns data at the grain of fees (PSC_LNP_FEE_RECORD).
Special Considerations
None.
Public Sector Cloud - Workflow Activities Real Time
Description
Real time history information of workflow activity time duration facts by workflow transaction status.
Business Questions
This subject area can answer the following business questions:
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > Permits > Permits > Workflow Tab
Time Reporting
This subject area supports workflow transactions history.
Time dimension is linked to Workflow Creation Date.
Transactional Grain
This subject area returns data at the grain of workflow activities (PSC_TS_WF_ACTIVITIES).
Special Considerations
None.