(October 19, 2001)

The MPCTC (Maryland Police and Correctional Training Commissions) use Skills Manager to manage an aggregate database containing certification, employment, training and firearms records for all police and correctional personnel in Maryland. Skills Manager enables the MPCTC to easily measure officer compliance with established state training and certification standards. More than 120 public safety agencies in Maryland have also adopted Skills Manager to manage their personnel training and development records.

All police and correctional agencies are required by law to report their officers' training and firearms records to the MPCTC on an annual basis. Academies must also report training records at the conclusion of each entry level training course so that new graduates can be promptly certified. These records can be reported on either approved paper scan forms or by computer file. Computer files must be submitted in a format acceptable by the MPCTC. Skills Manager provides features that make reporting by computer file both quick and easy.

Two reports are provided for exporting annual training and firearms records to ASCII text files; Export Annual Training and Export Annual Firearms. The resulting text files can be sent to the MPCTC where the records are imported into the state database.

Two reports are also provided for exporting entry level training and firearms records to ASCII text files; Export Training By Course and Export Firearms By Course. The resulting text files can be sent to the MPCTC where the records are imported into the state database.

NOTE: For this multi-agency aggregation of data to work successfully all agencies must adhere to standard data coding schemes established by the MPCTC. Agencies must also use the same version of Skills Manager used by the MPCTC. This is because different versions of Skills Manager (4.x, 5.x, 6.x, 7.x) store data in different formats and data exchange can occur successfully only between instances of Skills Manager at the same version level.

The data you export from Skills Manager is placed in a folder somewhere on your local computer or on your network. Before you export your records, you will need to determine the name and location of this folder. You must tell Skills Manager where this folder is by entering the appropriate file path into the Setup form. The following instructions will assist you. (A Skills Manager account with system administrator privileges is required to perform this operation.)

• Choose Utilities from the main menu.
• Choose Setup from the pop-up menu.
• In the field named Import & Export Folder enter a valid file path to the folder where you want Skills Manager to save your exported data. (Skills Manager will create the folder automatically when the export is performed, if necessary).

To direct the output to your floppy disk drive, you might use the following value. 

A:

To direct the output to a folder on your local hard drive, you might use the following value.

C:\Export

Export Annual Training

 

NOTE: Exported files (named XTrnHst.txt and XTrnMem.txt) are stored in the location specified by the Import & Export Folder value specified on your Setup form.

Export Annual Firearms

This report is designed to report on a single agency. When the report is launched, the operator is prompted to enter an Agency # and a Year for extracting the appropriate training firearms from the database. (If you manage the records for multiple agencies this report must be processed once for each agency.)

1. Employees must have an employment record associating them (either currently or formerly) with the specified agency.

Firearms Qualification

2. Only firearms for the year specified by the operator are exported.

 

NOTE: Exported files (named XWpnHst.txt) are stored in the location specified by the Import & Export Folder on your Setup form.

Export Training by Course