Data Model

This topic outlines the data model used to handle the Operational Reporting view and the metadata from the JET user interface point of view.

Entities

The following entities are responsible for handling Operational Reporting.

• Reporting Views

• View Columns

• View Floor Plans

• User View Search Preference

Reporting Views

This is a seeded table and stores the details of all the technical views generated for each Operation Reporting need.

Attributes: The following are the attributes for this table.

CMT: No

Field	Description
Code	The code associated with the view.
Alias	A 7-character abbreviation used when adding dynamic fields in a join to prevent name conflicts.
Base Entity	Stores the main entity related to this view from the table OHI Tables. This attribute is used to pull its dynamic fields for inclusion in the view.
Access	Reference to access restrictions.
Created By	Displays the name of the user who created the entry.
Creation Date	Records the timestamp when the entry was created.
Identifying Column	Captures the column name that contains PII.
UI Reporting?	Indicates whether the view is used for display on the reporting user interface.

View Columns

This is a seeded table and stores the column metadata per Reporting View. The entries in this table are read-only and automatically retrieve single-value dynamic fields from the base entity associated with the respective view.

Attributes: The following are the attributes for this table.

Field	Description
View Name	Stores the View ID of the Operational Report from the table Reporting View.
Column Name	Stores the column names from the referred view or usage name with a prefix DYN_ in case of dynamic fields.
Type	Stores the data type of the field.
Properties	Stores the payload in case of datatype Array or Amount (always a list).
Created By	Displays the name of the user who created the entry.
Creation Date	Records the timestamp when the entry was created.
PII?	Indicates whether the column contains Personally Identifiable Information. This attribute is used for audit trail purposes.
Searchable?	Indicates if this column is searchable or not. This means whether it is allowed to configure a search on this column.
Dynamic?	Indicates if the field is a dynamic field or not.

Type (Domain)

Value	Description
Amount	Amount
Date	Date
Number	Number
Array	Array
String	String
Text	Text

View Floor Plans

This table stores the user configured floor plans of the technical view.

Attributes: The following are the attributes for this table.

CMT: Yes

Field	Description
Code	Code for the Operational Report floor plan.
Description	Description of the Operational Report floor plan.
Function Access	Foreign key to function access.
View	Stores the View ID from the table Reporting View.
Payload	Stores the floor plan payload as defined.
System?	Indicates if this is a system generated floor plan or user defined floor plan.
Enabled?	Indicates if this floor plan is still active or inactive.

User View Search Preferences

This table stores the user search preference on quick search and advance search.

Attributes: The following are the attributes for this table.

CMT: No

Field	Description
Description	Description of the user search preference.
User	Reference to the user.
Floorplan	Reference to the floor plan.
Preference Payload	Stores the JSON payload to capture the user preferences.