Prepare Periodic Inspection Schedule

The Prepare Periodic Inspection Schedule task adds periodic inspection schedules to eligible license, trade license, or use applications.

A periodic inspection schedule defines the type of inspection to generate and the intervals at which it will be generated. The actual inspections are generated by a Periodic Inspection task.

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.LICPERIODICINSPSU Stores periodic inspection schedule setups for business license types.
CDR_TRADELICENSE.TRADEPERIODICINSPSU Stores periodic inspection schedule setups for trade license types.
CDR_USE.USEPERIODICINSPSU Stores periodic inspection schedule setups for use application types.

Invocation

The Prepare Periodic Inspection Schedule 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 periodic inspection schedules will be generated.
License Type Type of license or trade license for which periodic inspection schedules will be generated.
Inspection Type Type of inspection for which periodic inspection schedules will be generated.
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.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.

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

Form Comments
License InfoViewer Periodic inspection schedules are displayed on the Inspections tab.
Trade License InfoViewer Periodic inspection schedules are displayed on the Inspections tab.
Use Application InfoViewer Periodic inspection schedules are displayed on the Inspections tab.