Prepare Periodic Inspection Schedule
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. |