2Subject Areas
Overview
This chapter provides information on the subject areas with data you maintain in Oracle Public Sector Community Development. 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.
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.