DokuWiki

Reports are available in APEX via the APEX Reports feature, which is accessible on the Feature Selector in the left content panel.

To see the reports that you are authorized to access, click the Reports selector as shown below:

APEX Reports are served up via CeRTNA Microsoft SQL Server Report Services (SSRS). The reports in APEX will look and behave exactly like they did in the CeRTNA web client application.

When you select a report a parameter section and a standard toolbar will displayed as shown below:

The report tool bar has many features. You can move between pages using the arrows or by typing in a page number to advance to the desired page. You can select an export format from the drop down menu, refresh the report or print the report by clicking one of the buttons.

Several formats are available for exporting reports as seen below:

The Activity Detail Report is intended to provide totals of activity by various selection criteria. The Activity Detail Report provides a baseline management tool to monitor activity for the ERDS, Counties, and Submitters. This report includes the Transaction ID, County, Originator Name, Customer Reference, County Fees, Instrument Numbers or Rejection Codes and a Status.

Parameter selection is based on your user role:

Agent Role Parameters:

County Role Parameters:

After the report options have been selected, click the View Report button to generate the Activity Detail Report as shown below:

Clicking on one of the Transaction ID's will cause the Transaction Audit Report to be displayed in a pop-up window as shown below:

The Activity Summary Report is intended to provide totals of activity by various selection criteria. The Activity Summary Report provides a baseline Management tool to monitor activity for the ERDS, Counties and Submitters. This report will list the Submitter and give the total Count, Recording Fee and Tax totals.

This report is produced by selecting a Start Date and End Date. Click View Report to view the Activity Summary Report.

Depending on your role, you will see one of the following formats:

Agent Role:

County Role:

As the name implies, the Recordation Report is intended to provided detailed recording information based on a variety of user specified criteria.

This report shows information about the County, Submitter, Transaction ID, Primary & Secondary Reference Numbers, Recording Fees, Taxes, Date/Time of Recording, Document Type and Recorded Instrument Number.

This report provides summary information at both county and submitter levels and all totals are rolled into a grand total for the report.

The report can be restricted to a specific date range, selected counties or submitters and depending your role, grouping options may be available.

Output for the Recordation Report is based on your user role.

Agent Role Samples:

Agent Recordation Report grouped by County:

Example of summary lines for an Agent Recordation Report grouped by County:

Agent Recordation Report grouped by Submitter:

Example of summary lines for an Agent Recordation Report grouped by Submitter:

County Role Samples:

County role users do not see a Grouping field. The County view of the Recordation Report is automatically grouped by Submitter. Sample layouts are shown below:

Example of summary lines for a County Recordation Report:

The Rejection Detail Report is intended to provide rejection details to Submitters and County. This report includes Transaction ID, County, Submitter, Primary Reference, Last Modified, Doc Type, Rejection Code, Rejection Code Description and Rejection Message.

Parameter selection is based on your user role:

Agent Role Parameters:

County Role Parameters:

After the report options have been selected, click the View Report button to generate the Reject Detail Report as shown below:

The Status Detail Report shows a summary of all payloads by Status. This will give the Submitter or County user a snapshot of the activity for a time period and the total number of payloads in any given status.

Like the other reports, parameter selection is based on your user role:

Agent Role Parameters:

County Role Parameters:

After the report options have been selected, click the View Report button to generate the Status Detail Report as shown below:

The Transaction History for individual transactions can be viewed by clicking a specific Transaction ID that appears in the detail of the Status Detail Report. When you click a Transaction ID the Transaction history is shown in a pop-up report window as shown below:

The Status Summary Report shows summary counts for each of the major transaction statuses. (Draft, Submitted, RetrievedByCounty, ReturnedByCounty, RetrievedBySubmitter, and Archived. The Status Summary Reports can be grouped based on your role. For Agent Roles, the report can be grouped by County or Submitter. For County Roles the report can be grouped by Agent or Submitter. If you are a System Administrator Role you can group the report by County, Agent, or Submitter.

Following are samples for Agent and County roles:

Agent Role - Grouped by County:

County Role - Grouped by Agent:

County Role - Grouped by Submitter:

Agent Role - Grouped by Submitter:

If you click a summary value that is greater than zero, the Status Detail Report is displayed in a pop-up report windows for the selected items as shown below:

The Transaction Audit Report reflects the history of a transaction. All activity is logged by date, time and user. The report provides a history of each of the status changes associated with the specific transaction. This report includes the Type, Reference, Status, Agent, Submitter, County, Created By and Modified By for each status change of the transaction.

To generate the Transaction Audit Report enter the Transaction_Id and click View Report. The report will be generated and displayed as shown below:

The Transaction History Report provides a flexible way to review the history of multiple transactions within a single report. All activity is logged by date, time and user. The report provides a history of each of the status changes associated with each transaction that meets the filtering criteria. This report includes the Type, Reference, Status, Agent, Submitter, County, Created By and Modified By for each status change of the transaction.

Report sorting and filtering options vary based on user role.

Agent role users can sort by County/Submitter or Submitter/County and they can filter based on Start Date, End Date, County, and Submitter as shown below:

Agent Role Samples:

Agent Role sorting by County/Submitter:

Agent role sorting by Submitter/County:

County Role Samples:

County Role sorting by Agent/Submitter:

County role sorting by Submitter/Agent: