Perl MIS Report Structure

Each standard Perl MIS report is made up of a parameter file and five files of Perl code.

The parameter file for each report is located in the /usr/opt/blcmp/talis/mis/param directory and bears the name of the report (for example orr_order_letter). One of the functions of the parameter file is to indicate the location of the five component files. Creating local versions of theses scripts is described in the topic Tailoring Reports.

The Perl code files are located in a directory, which also bears the name of the report, under /usr/opt/blcmp/talis/mis.
 


 

Every new report will have its own directory and will have a parameter file within the directory /usr/opt/blcmp/talis/mis/param. For example, Overdues will have a directory called:

/usr/opt/blcmp/talis/mis/loa_odue_letter

In the param directory there will be a file called loa_odue letter:

/usr/opt/blcmp/talis/mis/param/loa_odue_letter

The individual reference directories for each new MIS script contain five source code files. The following table describes the function of each file, with an example from the loa_odue_letter script.

File

Description

Example from loa_odue_letter

main.pl

Contains the main body of the program which controls the overall processing of the report, including the default preselect.

The default preselect selects all LOAN rows that are overdue and matches the parameters given on the command line (for example, limits set by -b and -e).

preselect.pl

This file is provided as a stub. The user inserts their variant preselect in this file.

This could be tailored to limit the overdue preselect to a given Borrower Type.

select.pl

Further refinements to the preselect to just produce the rows needed in the output.

An Overdue Letter is re-sent if the Item has been renewed and has gone overdue again.

retrieve.pl

Retrieval of all the data elements required in the final output.

All the Work and Item details associated with the overdue loan.

format.pl

Template file for the output.