Periodic Inspection

The Periodic Inspection task creates inspections based on periodic inspection schedules associated with licenses or applications.

This task is available for the License, Trade License, and Use Permits modules.

Setup

This table describes the Infor Public Sector setup forms that are used to configure this task:

Setup form Comments
Application Workflow Used to define periodic inspections for use application types.
License Workflow Used to define periodic inspections for license and trade license types.

This table lists the database tables that store setup information for this task:

Table Comments
CDR_BUSINESSLICENSE.LICPERIODICINSPSCHED Stores periodic inspection schedules for business licenses.
CDR_TRADELICENSE.TRADEPERIODICINSPSCHED Stores periodic inspection schedules for trade licenses.
CDR_USE.USEPERIODICINSPSCHED Stores periodic inspection schedules for use applications.

Invocation

The Periodic Inspection task can be scheduled or invoked manually from the Batch Manager form, and it can be invoked through the console.

This table describes each parameter for this task:

Parameter Description
Application Type Type of use application for which inspections will be generated.
License Type Type of license or trade license for which inspections will be generated.
Inspection Type Type of inspection that will be generated.
Generate __ Days in Advance Number of days before the scheduled date that you want to generate inspections.
Commit Every __ Records Number of applications or licenses processed in each batch.
Note: You can enter any number here, but there are limitations at the database level. Oracle databases have a limit of 1,000 records, and SQL Server databases have a limit of 2,000 records. Entering a larger number will cause errors.

Data output

This table lists the database tables in which this task adds or updates records:

Table Comments
CDR_BUSINESSLICENSE.LICINSP Stores license inspection records.
CDR_BUSINESSLICENSE.LICPERDINSPGEN Stores information on periodic inspection generation runs for business licenses.
CDR_BUSINESSLICENSE.LICPERDINSPGENDTL Stores information on each inspection that was generated in a periodic inspection generation run for business licenses.
CDR_TRADELICENSE.TRADEINSP Stores trade license inspection records.
CDR_TRADELICENSE.TRADEPERDINSPGEN Stores information on periodic inspection generation runs for trade licenses.
CDR_TRADELICENSE.TRADEPERDINSPGENDTL Stores information on each inspection that was generated in a periodic inspection generation run for trade licenses.
CDR_USE.USEINSP Stores use inspection records.
CDR_USE.USEPERDINSPGEN Stores information on periodic inspection generation runs for use applications.
CDR_USE.USEPERDINSPGENDTL Stores information on each inspection that was generated in a periodic inspection generation run for use applications.

This table lists the Infor Public Sector forms that you can use to review the results of this task:

Form Comments
Lookup Inspections Standard lookup used to search for license, trade license, or use inspections.
Inspection InfoViewer Used to view and update a license, trade license, or use inspection.
License InfoViewer Inspections are displayed on the Inspections tab.
Trade License InfoViewer Inspections are displayed on the Inspections tab.
Use Application InfoViewer Inspections are displayed on the Inspections tab.