Custom Reports: "Rules of Operation"

(Revised December 7, 2009)

The Maryland Police and Correctional Training Commissions (MPCTC) certify all active police and correctional officers annually to ensure every officer meets or exceeds current state requirements for basic training, field training, in-service training, and firearms qualifications. This certification occurs each year after agencies have submitted their training and firearms records to the MPCTC as required by state law.

The custom reports described in this document are accessed by selecting Custom on the main menu in Skills Manager.  This menu item is disabled after installing the Skills Manager software, but it is easily activated using the instructions provided below.

1. Launch Skills Manager and login.

2. Choose Utilities on the menu.

3. Choose Setup on the pop-up menu.

4. Click on the Options tab.

5. Enter the value MD in the Customization Code field.

6. Click OK to save your changes.

7. Choose Custom on the main menu and you should see a list of reports.

Lists active police or correctional officers who have completed an Entry Level Training course but not a mandatory Field Training Course.

This report is designed to report on either police officers or correctional officers. When the report is launched, the operator is prompted to choose which type of agency the report will process.

Active, certified officers who meet the following criteria and have not completed a field training course.

When the operator chooses the agency type "Police" the following database conditions are evaluated . . .

Employment Table . . .

1. An officer must be "Active" and associated with a Police Agency.

 

Certification Table . . .

2. An officer must have a "Police Officer" (P) certificate with a status of "Probationary" (P).

Training Table . . .

3. The officer must have "Passed" or "Completed" a police entry level training course after January 20, 2003.

4. The officer has not completed the Police Field Training Course (PFT0001).

Employment Table . . .

1. An officer must be "Active" and associated with a Correctional Agency.

Certification Table . . .

2. An officer must have a "Correctional Officer" (C) certificate with a status of "Probationary" (P).

Training Table . . .

3. The officer must have "passed" or "completed" a correctional entry level training course after January 1, 2004.

4. The officer has not completed the correctional field training course (CFT0001).

 

Lists active officers who are not in compliance with Maryland in-service training requirements. 

This report is designed to report on a single agency. When the report is launched, the operator is prompted to enter an Agency ID and to choose the period of time (this year or last year) for which the report will apply. "This year" represents the current calendar year and "Last year" the previous calendar year. The year represented in the Windows operating system date is assumed to be the current year.

Active, certified officers who meet the following criteria and have not accumulated 18 hours or more of state-qualified in-service training.

When the report is processed the following database conditions are evaluated . . .

Agencies Table . . .

1. Only agencies with the attribute "Mandated" (MND) qualify for the report.

Employment Table . . .

2. Officers must be employed by the agency specified by the operator.

3. Officers must be "Active" at this agency.

4. Officers must be level "Base Level Mandated Officer" (1) or "First Line Supervisor" (2) to qualify for the report.

Certification Table . . .

5. When an officer's current agency is of type "Corrections" (COR) . . . the officer must have a "Corrections Officer" (C) certificate with a status of "Certified" (C).

6. When an officer's current agency is of type "Police" (POL) . . . the officer must have a "Police Officer" (P) certificate with a status of "Certified" (C).

Training Table . . .

7. Only training that falls within the date range entered by the operator qualifies for the report.

8. Only training with a status of "Passed" or "Completed" qualifies for the report.

9. Only MPCTC approved training courses qualify for the report. These courses are identified by "Police" (P) or "Corrections" (C) in the Program field of the Course record. (Individual agencies may add courses to the course catalog under other programs, however training events recorded for such courses are ignored and do not qualify for this report).

10. Qualified training hours are totaled for each officer. Officers who have less than 18 hours of qualified training are printed on the report.

 

Lists active officers who have not completed a specific course. 

This report is designed to report on a single agency. The operator is prompted to enter an Agency ID and to choose the period of time (this year or last year) for which the report will apply. "This year" represents the current calendar year and "Last year" the previous calendar year. The year represented in the Windows operating system date is assumed to be the current year. The operator also supplies the Course ID on which the report will operate.

Active, certified officers who meet the following criteria and have not completed the course specified by the operator.

When the report is processed the following database conditions are evaluated . . .

Agencies Table . . .

1. Only agencies with the attribute "Mandated" (MND) qualify for the report.

Employment Table . . .

2. Officers must be employed by the agency specified by the operator.

3. Officers must be "Active" at this agency.

4. Officers must be level (1) Base Level Mandated Officer or (2) First Line Supervisor.

Certification Table . . .

5. When an officer's current agency is of type "Corrections" (COR) . . . the officer must have a "Corrections Officer" (C) certificate with a status of "Certified" (C).

6. When an officer's current agency is of type "Police" (POL) . . . the officer must have a "Police Officer" (P) certificate with a status of "Certified" (C).

Training Table . . .

7. Only training that falls within the date range entered by the operator qualifies for the report.

8. Only training with a status of "Passed" or "Completed" qualifies for this report.

9. Officer did not successfully complete course specified by the operator.

Note: The operator can enter Courses other than those associated with (P) Police and (C) Corrections programs, as identified by the Program field of the Course record.

Lists active officers who are not in compliance with Maryland firearms qualification requirements. 

This report is designed to report on a single agency. The operator is prompted to enter an Agency ID and to choose the period of time (this year or last year) for which the report will apply. "This year" represents the current calendar year and "Last year" the previous calendar year. The year in the Windows operating system date is assumed to be the current year.

Officers who meet the following criteria and have not qualified once with a "Duty Weapon in Normal Light" (D) and once with a "Duty Weapon in Low Light" (L).

Lists active officers with certifications that will expire in the current year. 

This report is designed to report on a single agency. The operator is prompted to enter an Agency ID and to choose the period of time (this year or last year) for which the report will apply. "This year" represents the current calendar year and "Last year" the previous calendar year. The year represented in the Windows operating system date is assumed to be the current year.

Active, certified officers who meet the following criteria and have a certificate that expires in the current year.

When the report is processed the following database conditions are evaluated . . .

Agencies Table . . .

1. Only agencies with the attribute " Mandated" (MND) qualify for the report.

Employment Table . . .

2. Officers must be employed by the agency specified by the operator.

3. Officers must be "Active" at this agency.

4. Officers at level (7) Chiefs, Deputy Chiefs, and Agency Heads are excluded from the report.

Certification Table . . .

5. Officers must have a "Police Officer" (P) certificate.

6. This certificate must have a status of "Certified" (C).

7. This certificate must have an Expiration Date in the current year.

 

Lists active officers who have probationary certificates due to expire within the next 90 days. 

This report is designed to report on a single agency. When the report is launched, the operator is prompted to enter an Agency ID.

Active officers who meet the following criteria and have a probationary certificate within 90 days of expiration.

When the report is processed the following database conditions are evaluated . . .

Employment Table . . .

1. Officers must be employed by the agency specified by the operator.

2. Officers must be "Active" at this agency.

Certification Table . . .

3. When an officer's current agency is of type "Corrections" (COR) . . . the officer must have a "Corrections Officer" (C) certificate witha status of "Probationary" (P).

4. When an officer's current agency is of type "Police" (POL) . . . the officer must have a "Police Officer" (P) certificate witha status of "Probationary" (P).

5. This certificate must have a Probation End Date within 90 days of expiration, relative to the date this report is run.

Training Table . . .

6. Only training with a status of "Passed" or "Completed" qualifies for the report.

7. When the agency specified is of type "Corrections" (COR) . . . and the officer has not attended an MPCTC approved "Entry Level Corrections" course. These courses are identified by "Corrections" (C) in the Program field and "Entry Level" (E) in the Subject field of the Course record. (Individual agencies may add courses to the course catalog under other programs, however training events recorded for such courses are ignored and do not qualify for this report).

8. When the agency specified is of type "Police" (POL) . . . and the officer has not attended an MPCTC approved "Entry Level Police" course. These courses are identified by "Police" (P) in the Program field and "Entry Level" (E) in the Subject field of the Course record. (Individual agencies may add courses to the course catalog under other programs, however training events recorded for such courses are ignored and do not qualify for this report).

 

Lists active officers promoted to "First Line Supervisor" within the past 365 days who have not completed a supervisor level training course. 

This report is designed to report on a single agency. The operator is prompted to enter an Agency ID.

Active, certified officers who meet the following criteria, were promoted to supervisor within past 365 days, and have not completed a Supervisor course.

When the report is processed the following database conditions are evaluated . . .

Employment Table . . .

1. Officers must be employed by the agency specified by the operator.

2. Officers must be "Active" at this agency.

3. Officers must have been promoted to level (2) First Line Supervisor within the past 365 days.

Certification Table . . .

4. When an officer's current agency is of type "Corrections" (COR) . . . the officer must have a "Corrections Officer" (C) certificate with a status of "Certified" (C).

5. When an officer's current agency is of type "Police" (POL) . . . the officer must have a "Police Officer" (P) certificate with a status of "Certified" (C).

Training Table . . .

6. Only training with a status of "Passed" or "Completed" qualifies for the report.

7. Only MPCTC approved training courses qualify for the report. These courses are identified by "Police" (P) or "Corrections" (C) in the Program field of the Course record. (Individual agencies may add courses to the course catalog under other programs, however training events recorded for such courses are ignored and do not qualify for this report).

8. Officer has not attended a state approved "Supervisor" course. These courses are identified by "Supervisor" (S) in the Subject field of the Course record.

 

Purpose

Lists officers promoted to "First Line Administrator" within the past 365 days who have not completed an administrator level training course. 

This report is designed to report on a single agency. The operator is prompted to enter an Agency ID.

Active, certified officers who meet the following criteria, were promoted to administrator within past 365 days, and have not completed an Administrator course.

When the report is processed the following database conditions are evaluated . . .

Employment Table . . .

1. Officers must be employed by the agency specified by the operator.

2. Officers must be "Active" at this agency.

3. Officers who were promoted to level (4) First Line Administrator with the past 365 days.

Certification Table . . .

4. When an officer's current agency is of type "Corrections" (COR) . . . the officer must have a "Corrections Officer" (C) certificate with a status of "Certified" (C).

5. When an officer's current agency is of type "Police" (POL) . . . the officer must have a "Police Officer" (P) certificate with a status of "Certified" (C).

Training Table . . .

6. Only training with a status of "Passed" or "Completed" qualifies for the report.

7. Only MPCTC approved training courses qualify for the report. These courses are identified by "Police" (P) or "Corrections" (C) in the Program field of the Course record. (Individual agencies may add courses to the course catalog under other programs, however training events recorded for such courses are ignored and do not qualify for this report).

8. Officer has not attended a state approved "Administrator" course. These courses are identified by "Administrator" (A) in the Subject field of the Course record.

 

Lists active officers alphabetically with rank and certification status.

This report is designed to report on a single agency. The operator is prompted to enter an Agency ID.  The report prints name, rank and certification status for all employees that are selected.

Active, certified officers who meet the following criteria.

When the report is processed the following database conditions are evaluated . . .

Employment Table . . .

1. Officers must be employed by the agency specified by the operator.

2. Officers must be "Active" at this agency.

3. Employees with an action of (IH) "Hired as Instructor" are excluded from the report.

Certification Table . . .

4. When an officer's current agency is of type "Corrections" (COR) . . . the officer must have a "Corrections Officer" (C) certificate.

5. When an officer's current agency is of type "Police" (POL) . . . the officer must have a "Police Officer" (P) certificate.

 

Exports training records to a text file for reporting annual training to the Maryland Police & Corrections Training Commissions.

This report is designed to report on one or all agencies at a time. The operator is prompted to enter a single Agency ID or choose all agencies, and to choose the period of time (this year or last year) for which the report will apply.

When the report is processed the following database conditions are evaluated . . .

Employment Table . . .

1. Officers must be currently or formerly employed by the agency(s) specified by the operator.

Training Table . . .

2. Only training that falls within the date range specified by the operator qualifies for output.

3. Only training with a status of "Passed" or "Completed" qualifies for output.

 

Exports firearms records to a text file for reporting annual firearms to the Maryland Police & Corrections Training Commissions.

This report is designed to report on one or all agencies at a time. The operator is prompted to enter a single Agency ID or choose all agencies, and to choose the period of time (this year or last year) for which the report will apply.

When the report is processed the following database conditions are evaluated . . .

Employment . . .

1. Officers must be currently or formerly employed by the agency(s) specified by the operator.

Firearms . . .

2. Only firearms that fall within the date range specified by the operator qualify for output.

3. Only firearms with a status of "Passed" or "Completed" qualify for output.

 

Exports training records from a single course for a specific training date, for reporting to the Maryland Police & Corrections Training Commissions.

This report is designed to report on one or more agencies. The operator is prompted to enter a single Agency ID or choose all agencies, to enter a date, and to specify a specific course.

When the report is processed the following database conditions are evaluated . . .

Employment Table . . .

1. Officers must be currently or formerly employed by the agency(s) specified by the operator.

Training Table . . .

2. Only training that falls within the date range specified by the operator qualifies for output.

3. Only training associated with the course specified by the operator qualifies for output.

4. Only training with a status of "Passed" or "Completed" qualifies for output.

 

NOTE: Exported files (named XTrnHst.txt and XTrnMem.txt) are stored at the location specified by the Import & Export Folder field in the Setup dialog box.  To view or change this setting, choose Utilities on the main menu and then Setup on the pop-up menu.

Exports firearms records from a single course for a specific training date, for reporting to the Maryland Police & Corrections Training Commissions.

This report is designed to report on one or more agencies. The operator is prompted to enter a single Agency ID or choose all agencies, to enter a date, and to specify up to 3 specific courses.

When the report is processed the following database conditions are evaluated . . .

Employment . . .

1. Officers must be currently or formerly employed by the agency(s) specified by the operator.

Firearms . . .

2. Only firearms that fall within the date range specified by the operator qualify for output.

3. Only firearms associated with the course(s) specified by the operator qualify for output.

4. Only firearms with a status of "Passed" or "Completed" qualify for output.

 

NOTE: The exported file (named XWpnHst.txt) is stored at the location specified by the Import & Export Folder field in the Setup dialog box.  To view or change this setting, choose Utilities on the main menu and then Setup on the pop-up menu.

Exports training, firearms, and course records for a specific officer for the purpose of exchanging records with another agency, perhaps the officer's new employer.

This report is designed to report on a single officer. The operator is prompted to enter an officer's Certification Number and alternatively a date range.

When the report is processed the following database conditions are evaluated . . .

Training Table . . .

1. Only training that falls within the date range specified by the operator is exported.

Firearms Table . . .

2. Only firearms that fall within the date range specified by the operator is exported.

Course Table . . .

3. All courses referenced in the exported training and firearms records are exported.

 

NOTE: Exported files (named XTrnHst.txt, XTrnMem.txt, WpnHst.txtr, and Course.txt) are stored at the location specified by the Import & Export Folder field in the Setup dialog box.  To view or change this setting, choose Utilities on the main menu and then Setup on the pop-up menu.

Back to top