Back to Home

New Inspection Type Guide

Table of Contents

• Overview
• List

Overview

• What you need to know when adding a new inspection type
• Below list is data that is necessary when creating a new inspection type
• Scripts are necessary when importing data to Cigna databases.

List

• Setup Teams
  • Teams are local only, so no script needed for Cigna side
  • Business Owner Team: Add BO, BM
  • Quality Team: Add QR, QM
  • SME - Quality Team: Add QR
• Setup Sample
  • Create script
  • Create sample rule for each inspection type
    • OnShore Example
      • GSPRestricted = 1 and InspectionTypeNo = 4
    • GSP Example
      • GSPRestricted = 0 and InspectionTypeNo = 4
• Setup CodeList
  • Create script
    • DynamicField - Include all Fields associated with the intake form
      • Example script: insert into smart.p11_Codelist (LookUpNo, LookUpTitle, LookUpCategory, Option1, Option2, Option7) values (0, 'Business Owner', 'DynamicField','IntakeForm', 'rfv_BOTeam', 17 )
    • DynamicOption - include all options necessary for each field
      • Example script: insert into smart.p11_CodeList (LookUpNo, LookUpTitle, LookUpCategory, Option1, Option3, Option7) values (0, 'Business Type', 'DynamicOption', 1, null, 17)
      • New CodeList values
        • Example script: insert into smart.p11_Codelist (LookUpNo, LookUpTitle, LookUpCategory) values (8, 'HSA','Account Group')
      • Radiobuttons used in Checklist setup, must be created and with Option3 = True to display properly. See rbt_FundingType in QR_Review.aspx page
      • NOTE - DynamicOption radiobutton values cannot be null. Always include radiobutton value of 0 if not being used. Or else it will error out when you try to Edit intake form after creating it.
• Tables - Add new column name to the following tables
  • smart.p11_IntakeForm
  • smart.p11_IntakeForm_Delete
• Views - join new column names from above tables
  • smart.p11_qry_IntakeForm
  • smart.p11_qry_IntakeForm_Short
• Stored Procedures
  • smart.p11_List_Checklist - Add the InspectionTypeNo to the appropriate Option
  • smart.p11_Load_IntakeForm - Add new table fields to your Insert and Update options in the stored procedure
• Web Pages
  • uc_IntakeFormNew.ascx
    • Add new Template fields, if necessary
  • uc_IntakeFormNew.ascx.cs (Code Behind)
    • Add new columns for ddv_IntakeForm_ItemCommand, e.CommandName == "Save"
    • If adding new TemplateField, make sure ddv_IntakeForm's Fields count is updated ddv_IntakeForm.Fields[22].HeaderText
  • uc_IntakeFormEdit.ascx [See Intake Form Row Position] for reference
    • Add new Template fields, if necessary
  • uc_IntakeFormEdit.ascx.cs (Code Behind)
    • Add new columns for ddv_IntakeForm_ItemCommand, e.CommandName == "Save"
    • If adding new TemplateField, make sure ddv_IntakeForm's Fields count is updated ddv_IntakeForm.Fields[20].HeaderText