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. |