Add FH lookup codes for FireRescue1 Academy training data
To accurately track training classes taken through FireRescue1 Academy in the FH Training module, you need to add a lookup code in FH, identifying FireRescue1 Academy as a method of instruction. You may also want to add lookup codes to capture instructor information included in the FireRescue1 Academy data file, for your FH training records.
- (FH Enterprise) Verify that the user name and password for remote connection configuration is for a SQL administrator account.
- Log into FH as an administrator.
-
Choose Tools → Lookup Tables.
The Lookup Tables dialog box appears.
-
Expand Staff Activity and Training Codes → Training Class, Program and Instructor Codes.
-
Add a lookup code for each of the following.
The method of instruction
-
Select Method of Instruction, and then click Setup.
The Lookup - Method of Instruction dialog box appears.
-
Click New.
The Code for Method of Instruction dialog box appears.
-
In Code, type
KA
for identifying FireRescue1 Academy as the method of instruction for a training class.Note: The
KA
lookup code is required for this field, for the data file to import correctly. -
In Description, type text that identifies the lookup code.
The description can be any text you want to use.
Example:
FireRescue1 Academy training course
- Click Save.
- In the Lookup - Method of Instruction dialog box, click Close.
The location of instruction
-
Select Location of Training/Activity, and then click Setup.
The Lookup - Location of Training/Activity dialog box appears.
-
Click New.
The Code for Location of Training/Activity dialog box appears.
-
In Code, type the lookup code you want to use for identifying FireRescue1 Academy as the location for the training class.
Example:
FireRescue1
-
In Description, type text that identifies the lookup code you are defining.
Example:
FireRescue1 Academy
- Click Save.
- In the Lookup - Location of Training/Activity dialog box, click Close.
The agency providing training.
-
Select Agency Providing Training, and then click Setup.
The Lookup - Agency Providing Training dialog box appears.
-
Click New.
The Code for Agency Providing Training dialog box appears.
-
In Code, type the lookup code you want to use for identifying FireRescue1 Academy as the agency that provided the training class.
Example:
FireRescue1
-
In Description, type text that identifies the lookup code you are defining.
Example:
FireRescue1 Academy
- Click Save.
- In the Lookup - Agency Providing Training dialog box, click Close.
(If you did not delete the instructor code fields earlier) The instructor information
In Delete unneeded data fields , you had the option to delete the fields containing the instructor code information during the import process for the FireRescue1 Academy data file.
If you did not delete these fields, you need to create a lookup code in FH to map the FireRescue1 Academy instructor data to.
-
Select Instructor Codes, and then click Setup.
The Lookup - Instructor Codes dialog box appears.
-
Click New.
The Code for Instructor Codes dialog box appears.
-
In Code, type
KA
for identifying a FireRescue1 Academy instructor for the training class.Note: This lookup code is required for this field, for the data file to import correctly.
-
In Description, type text that identifies the lookup code you are defining.
The description can be any text you want to use.
Example:
FireRescue1--Mark Peterson
- Click Save.
- In the Lookup - Instructor Codes dialog box, click Close.
-
- In the Lookup Tables dialog box, click Close.
- Continue with Set up an automated task to import the FireRescue1 Academy data.