Setting Up the Look-up Tables

The surveillance feature in Cority works with several modules and look-up tables to complete employee surveillance. Follow these steps to set up all necessary look-up tables for the surveillance to work properly.

  1. Set up the components required by each module that you want to link to. For example, if you are defining an activity called CBC (Complete Blood Count) that is linked to the Clinical Testing module, you must have defined the test battery to be used and the tests that are part of that battery.

    Module

    Look-up Tables Required and Order

    Clinical Tests
    (see Clinical Testing)

    1. ClinicalTestCategory

    2. ClinicalTestUnit

    3. ClinicalTestBattery

    Questionnaires
    (see Questionnaires)

    1. QuestionCategory

    2. SingleQuestion

    3. Questionnaire

    Training Courses
    (see Training)

    1. TrainingCourseType

    2. TrainingCourseOwner

    3. TrainingReference

    4. TrainingCourse

    Immunization
    (see Immunization)

    ImmunizationCode

    Respirator

    Recording Equipment

  2. Set up the ScheduleActivity look-up table which links an activity to a module and specific components. For example:

    SCH_ActivityCodesForm.png

     

    SCH_ActivityCodesForm2.png
  3. The exposure group name can be created as a schedule activity and used in the ExposureGroup look-up table as a recall activity for those clients wanting to recall by an exposure group instead of specific activities. This will allow exam activities to be identified as a template related to the clinic visit reason. It is recommended that you put asterisks around each activity that has the same name as the exposure group to easily identify programs vs. activities.

    SCH_ActivityCodesForm3.png

    A medical surveillance activity can be identified as a “group activity” that will encompass multiple related activity codes for an SEG, e.g. different questionnaires per location. To view the sub-activities that have been added to a group activity when in the clinic visit record, open the group activity (on the Exam Activity tab) - they are listed in a separate Sub-activity section. When any one of the sub activities is completed, the group activity’s Last Test Date is updated with the Test Date of the most recent sub-activity and if Last Test Date matches the clinic visit treatment date, then the group activity is marked as complete. To use this functionality:

    For more information about these fields, see ScheduleActivity.

  4. Define the ClinicVisitReason table, which links a grouping of schedule activities into a single clinic visit reason. When a clinic visit reason is selected as part of a clinic visit record, the linked activities will automatically display on the Exam Activities tab. For example, a Clinic Visit Reason of “Physical Examination” could have the linked activities shown below:

    CV_Reasons.png
  5. Set up the SEGs and their recall activities in the ExposureGroup table. SEGs are groups of employees who require the same medical surveillance. Setting up an SEG allows you to schedule standard recalls for all members of the SEG (e.g. for hearing or vision tests, biosurveillance, or training).