Data Validation Examples

#cpr.ppid

#cpr.participant.firstName

#cpr.participant.middleName

#cpr.participant.lastName

#cpr.registrationDate

#cpr.externalSubjectId

#cpr.site

#cpr.participant.birthDate

#cpr.participant.uid

#cpr.participant.empi

#cpr.participant.gender

#cpr.participant.vitalStatus

#cpr.participant.deathDate

#cpr.participant.races

#cpr.participant.ethnicities

#cpr.participant.pmis

#cpr.participant.pmis

#visit.name

#visit.status

#visit.missedBy

#visit.missedReason

#visit.visitDate

#visit.site

#visit.clinicalDiagnoses

#visit.surgicalPathologyNumber

#visit.clinicalStatus

#visit.comments

#specimen.label

#specimen.barcode

#specimen.lineage

#specimen.status

#specimen.type

#specimen.anatomicSite

#specimen.laterality

#specimen.pathology

#specimen.initialQty

#specimen.availableQty

#specimen.concentration

#specimen.parentLabel

#specimen.biohazards

#specimen.storageLocation

#specimen.createdOn

#specimen.freezeThawCycles

#specimen.incrParentFreezeThaw

#specimen.comments

#specimen.collectionEvent.time

#specimen.collectionEvent.user

#specimen.receivedEvent.time

#specimen.receivedEvent.user

#specimen.collectionEvent.container

#specimen.collectionEvent.procedure

#specimen.receivedEvent.receivedQuality

#specimen.events.SpecimenFrozenEvent.time

#specimen.events.SpecimenFrozenEvent.frozenMethod

#specimen.events.SpecimenFrozenEvent.comments

{
           "records" : [ "cpr" ],
           "rules" : [
             {
               "expr" : "#cpr.participant.firstName != null && #cpr.participant.lastName != null",
               "description" : "First name or last name should not be null"
             }
           ]
         },

{
      "records" : [ "cpr" ],
      "rules" : [ {
        "expr" : "#cpr.participant.firstName.matches(\"^[A-Z]+$\")",
        "description" : "Only capital letters allowed for Initials"
      } ]
    }

{
     "records" : [ "cpr" ],
      "rules" : [ {
        "when" : "#cpr.participant.extensionDetail?.getAttrsMap()?.get('min_max_age') != null && !#cpr.participant.extensionDetail?.getAttrsMap()?.get('min_max_age').isEmpty()",
        "expr" : "T(java.lang.Integer).parseInt(#cpr.participant.extensionDetail?.getAttrsMap()?.get('min_max_age')) >= 18 && T(java.lang.Integer).parseInt(#cpr.participant.extensionDetail?.getAttrsMap()?.get('min_max_age')) <= 55",
        "description" : "Partiicpant's age should be between 18 and 55"
      } ]
}

{
         "records" : [ "cpr" ],
         "rules" : [
           {
             "when" : "#cpr.participant.vitalStatus == 'Dead'",
             "expr" : "#cpr.participant.extensionDetail?.getAttrsMap()?.get('ST2') != null ",
             "description" : "Specify Death Cause"
           }
         ]
       }

{
           "records" : [ "cpr" ],
           "rules" : [
             {
               "expr" : "#cpr.participant.gender != null && !#containsAny(#cpr.participant.gender, {'Female', 'Unknown', 'Undifferentiated'})",
               "description" : "Only Male patient should be register"
             }
           ]
         }

{
         "records" : [ "cpr" ],
           "rules" : [
             {
               "when" : "#containsAny(#cpr.participant.races, {'White', 'Asian'})",
               "expr" : "#cpr.participant.ethnicities.size() == 1 && #cpr.participant.ethnicities.contains('American')",
               "description" : "For White/Asian races, ethnicity should be American"
             }
           ]
         }

{
           "records" : [ "cpr" ],
           "rules" : [
             {
               "when" : "#cpr.site == 'MCRI Repository'",
               "expr" : "#containsAny(#cpr.participant.races, {'White', 'Asian'})",
               "description" : "Race should be White/Asin for 'MCRI Repository' site patient"
             }
           ]
         },
         {
           "records" : [ "cpr" ],
           "rules" : [
             {
               "when" : "#containsAny(#cpr.participant.vitalStatus, {'Alive'})",
               "expr" : "#containsAny(#cpr.participant.ethnicities, {'American', 'African'})",
               "description" : "For alive patient, the enthicity should be American/African"
             }
           ]
         }

{
      "records" : [ "cpr" ],
      "rules" : [
        {
        "when" : "#cpr.registrationDate != null && #cpr.participant.extensionDetail?.getAttrsMap()?.get('ST6')!= null",
        "expr" : "#cpr.participant.extensionDetail?.getAttrsMap()?.get('ST6') matches '^\\w+(\\.\\w+)*@\\w+(\\.\\w+)*(\\.[A-Za-z]{2,})$'",
        "description" : "Please enter a valid email address"
      } ]
    }

{
        "records": ["cpr"],
        "forms": {
          "cpr": [ "smokingHistoryForm" ]
        },
        "rules": [
          {
            "when": "#cprForms != null && #cprForms['smokingHistoryForm'] != null",
            "expr": "#cprForms['smokingHistoryForm']['haveYouEverSmoked'] != 'Yes'",
            "description": "SH:Smokers not allowed!"
          }
         ]
       }

{
          "records": ["cpr"],
          "forms": {
            "cpr": [ "smokingHistoryForm" ]
          },
          "rules": [
            {
              "when": "#cprForms != null && #cprForms['smokingHistoryForm'] != null",
              "expr": "#cpr.participant.gender != 'Male' || #cprForms['smokingHistoryForm']['haveYouEverSmoked'] != 'Yes'",
              "description": "SH:Male Smokers Not allowed!"
            }
           ]
         }

{
      "records" : [ "cpr" ],
      "rules" : [ {
        "expr" : "#cmp(#cpr.participant.extensionDetail?.getAttrValue('date_participant_signed'), #currentTime()) <= 0",
        "description" : "Participant date signed should be lesser than or equal to current date"
      } ]
    }

{
           "records" : [ "cpr" ],
           "rules" : [ {
             "expr" : "#yearsBetween(#cpr.participant.birthDate, #cpr.registrationDate) >= 18",
             "description" : "Participant should be older than 18 years"
           } ]
         }

{
  "records" : [ "cpr" ],
  "rules" : [
    {
      "when" : "#cpr.participant.vitalStatus == 'Dead'",
      "expr" : "#cpr.participant.extensionDetail?.getAttrsMap()?.get('DD3') != null ",
      "description" : "Specify the value for Diagnosed With"
    }
  ]
}

{
         "records" : [ "cpr" ],
         "rules" : [
           {
             "when" : "#cpr.participant.vitalStatus == 'Alive'",
             "expr" : "#cpr.participant.extensionDetail?.getAttrsMap()?.get('MLB4') != null ",
             "description" : "Specify the cities where patient is lived"
           }
         ]
       }

{
         "records" : [ "cpr" ],
         "rules" : [
           {
             "when" : "#cpr.participant.extensionDetail?.getAttrsMap()?.get('FC5') == 'Krishna W' ",
             "expr" : "#cpr.participant.extensionDetail?.getAttrsMap()?.get('ST2') != null ",
             "description" : "Specify the death cause if the surgeon is Krishna W"
           }
         ]
       },

{
      "records" : [ "visit"],
      "rules" : [
        {
          "when" : "#visit.status == 'Complete'",
          "expr" : "#containsAny(#visit.clinicalDiagnoses, {'Cholera', 'Liver cell carcinoma'})",
          "description" : "Clinical diagnosis should be Cholera/Cholepe"
        }
      ]
    },

{
      "records" : [ "visit"],
      "rules" : [
        {
          "when" : "#containsAny(#visit.clinicalDiagnoses, {'Cholera', 'Liver cell carcinoma'})",
          "expr" : "#visit.extensionDetail?.getAttrsMap()?.get('DD2') == 'Negative' ",
          "description" : "Clinical Subtype should be Negative"
        }
      ]
    },

{
  "records" : [ "cpr", "visit" ],
  "rules" : [
    {
      "expr" : "#cpr.registrationDate != null && #visit.visitDate != null && !#cpr.registrationDate.after(#visit.visitDate)",
      "description" : "Visit date should be same or later than the registration date!"
      }
      ]
    }

{
      "records" : [ "visit" ],
      "rules" : [ {
        "when" : "#visit.status == 'Complete'",
        "expr" : "#visit.clinicalDiagnoses.size() == 2 && #visit.clinicalDiagnoses.contains('Breast implant status') && #visit.clinicalDiagnoses.contains('Other disorders of breast')",
        "description" : "Clinical diagnosis should be Breast implant status and Other disorders of breast"
      } ]
    },

{
      "records": ["visit"],
"rules" : [
        {
          "when" : "#specimen.status == 'Collected' && #visit.eventLabel == 'Baseline' && #containsAny(#visit.clinicalDiagnoses, {'10 weeks gestation of pregnancy', '11 weeks gestation of pregnancy', '12 weeks gestation of pregnancy', '13 weeks gestation of pregnancy', '14 weeks gestation of pregnancy'})",
          "expr" : "#containsAny(#specimen.anatomicSite, {'Extrahepatic bile duct', 'Intrahepatic bile duct', 'Liver'})",
          "description" : "CORE AS: Check the combo of CD AND AS"
        },
]
}

{
      "records" : [ "visit" ],
      "forms" : {
        "visit" : [ "newPathologyForm" ]
      },
      "rules" : [ {
        "when" : "#visitForms != null && #visitForms['newPathologyForm'] != null && {'Extrahepatic bile duct', 'Intrahepatic bile duct', 'Liver'}.contains(#visitForms['newPathologyForm']['tumourSiteAnatomicSite'])",
        "expr" : "{'10 weeks gestation of pregnancy', '11 weeks gestation of pregnancy', '12 weeks gestation of pregnancy', '13 weeks gestation of pregnancy', '14 weeks gestation of pregnancy'}.contains(#visitForms['newPathologyForm']['tumourMorphologyDiagnosis'])",
        "description" : "CF VISIT: Check the combination of diagnoses and anatomic sites"
      } ]
    }

{
      "records" : [ "visit" ],
      "forms" : {
        "visit" : [ "newPathologyForm" ]
      },
      "rules" : [ {
        "when" : "#visitForms != null && #visitForms['newPathologyForm'] != null && {'Extrahepatic bile duct', 'Intrahepatic bile duct', 'Liver'}.contains(#visitForms['newPathologyForm']['tumourSiteAnatomicSite'])",
        "expr" : "#containsAny(#visit.clinicalDiagnoses, {'10 weeks gestation of pregnancy', '11 weeks gestation of pregnancy', '12 weeks gestation of pregnancy', '13 weeks gestation of pregnancy', '14 weeks gestation of pregnancy'})",
        "description" : "Check the combination of Form Anatomic Site and Core Clinical Diagnoses"
      } ]
    }

{
        "when" : "#visit.visitDate != null && #visit.status == 'Complete' && #visit.clinicalStatus != null && #visitForms != null && #visitForms['demoPathologyForm'] != null && #visitForms['demoPathologyForm']['diagnosis3'] != null && #visitForms['demoPathologyForm']['diagnosis3'] matches '^\\d+/[0-2].*'",
        "expr" : "#visit.clinicalStatus == 'Non-malignant'",
        "description" : "Check the clinical status value based on the diagnosis"
      },

{
      "records" : [ "specimen", "cpr", "visit" ],
      "rules" : [
        {
          "when" : "#cpr.participant.gender == 'Male' && #specimen.status == 'Collected' && #visit.eventLabel == 'Baseline'",
          "expr" : "!{'Female genital tract, NOS', 'Overlapping lesion of female genital organs', 'Other specified parts of female genital organs', 'Breast, NOS'}.contains(#specimen.anatomicSite)",
          "description" : "CORE GEN AS: Check the Gender ASite COMBO"
        }
     ]
    }

{
          "when" : "#specimen.status == 'Collected'",
          "expr" : "!#cpr.registrationDate.after(#specimen.collectionEvent.time)",
          "description" : "The specimen #specimen.label (#specimen.type) collection date should be same or later than the registration date!"
}

{
          "when" : "#specimen.status == 'Collected' && #specimen.specimenClass == 'Tissue'",
          "expr" : "#specimen.anatomicSite == 'Brain, NOS' || #specimen.anatomicSite == 'Abdomen, NOS'",
          "description" : "Anatomic site should be Brain NOS or Abdomen NOS for tissue samples"
        }

{
      "records" : [ "visit", "specimen" ],
      "rules" : [ {
        "when" : "#visit.visitDate != null &&  #visit.status == 'Complete' && #specimen.collectionEvent.time != null && #specimen.status == 'Collected'",
        "expr" : "#formatDate(#visit.visitDate,'yyyyMMdd') == #formatDate(#specimen.collectionEvent.time,'yyyyMMdd')",
        "description" : "Correct the visit date to the  specimen collection date"
      } ]
    }

{
"records": ["shipment"],
                "rules": [
                  {
                    "when": "#shipment.status != 'Pending'",
                    "expr": "#cmp(#shipment.shippedDate, #currentTime()) <= 0",
                    "description": "1. Shipment date should be lesser than current date/time"
                  }
                ]
 },

{
"records": ["shipment"],
                "rules": [
                  {
                    "when": "#shipment.status == 'Received'",
                    "expr": "#cmp(#shipment.receivedDate, #currentTime()) <= 0",
                    "description": "2. Shipment received date should be lesser than current date/time"
                  }
                ]
},

  {"records": ["shipment", "shipmentSpecimen"],
                "rules": [
                  {
                    "when": "#shipment.status != 'Pending' && #shipment.shippedDate != null",
                    "expr": "#cmp(#shipment.shippedDate, #specimen.collectionEvent.time) >= 0",
                    "description": "3. Shipment date should be greater than the specimen (#specimen.label) collection date"
                  }
                ]
                },

  {
  "records": ["shipment", "shipmentSpecimen"],
                "rules": [
                       {
                    "when": "#shipment.status != 'Pending' && #shipment.receivedDate != null",
                    "expr": "#cmp(#shipment.receivedDate, #specimen.collectionEvent.time) >= 0",
                    "description": "4. Shipment receive date should be greater than the specimen (#specimen.label) collection date"
                  }
                ]
   },

   {
                "records": ["shipment", "shipmentSpecimen"],
                "rules": [
                  {
                    "when": "#shipment.status != 'Pending' && #shipment.shippedDate != null",
                    "expr": "(#shipment.shippedDate.getTime() - (#specimen.collectionEvent.time.getTime() - 24 * 60 * 60 * 1000)) >= 0",
                    "description": "Shipment date should be greater than the specimen collection date"
                  }
                ]
  }
            

{
  "records" : [ "specimen" ],
  "forms" : {
    "specimen" : [ "SpecimenShipmentShippedEvent" ]
  },
  "rules" : [ {
    "when" : "#specimenForms != null && #specimenForms['SpecimenShipmentShippedEvent'] != null",
    "expr": "#collFns.forEvery(#specimenForms['SpecimenShipmentShippedEvent$Array'], 'se', \"#se['time'].after(#specimen.collectionEvent.time)\")",
    "description" : "Shipment date should be later than the collection date."
  } ]
}

{
   "records": ["shipment", "shipmentSpecimen"],
     "rules": [
                {
                   "when": "#shipment.status != 'Pending' && #shipment.shippedDate != null",
                    "expr": "(#shipment.shippedDate.getTime() - #specimen.collectionEvent.time.getTime()) >= -86400000",
                    "description": "Shipment shipped date cannot occur more than 24 hours before the Specimen collection date."
                }
              ]
}

{
               "records": ["shipment", "shipmentSpecimen"],
               "rules": [
                 {
                   "when": "#shipment.status != 'Pending' && #shipment.shippedDate != null",
                   "expr": "#shipment.shippedDate.getYear() > #specimen.collectionEvent.time.getYear() || (#shipment.shippedDate.getYear() == #specimen.collectionEvent.time.getYear() && #shipment.shippedDate.getMonth() > #specimen.collectionEvent.time.getMonth()) || (#shipment.shippedDate.getYear() == #specimen.collectionEvent.time.getYear() && #shipment.shippedDate.getMonth() == #specimen.collectionEvent.time.getMonth() && #shipment.shippedDate.getDate() >= #specimen.collectionEvent.time.getDate())",
                   "description": "Shipment date should be greater than the specimen collection date"
                 }
               ]
 }

{
                "records": ["order"],
                "rules": [
                  {
                    "when": "#order.status != 'PENDING'",
                    "expr": "#cmp(#order.executionDate, #currentTime()) <= 0",
                    "description": "Order date should be lesser than current date/time"
                  }
                ]
              },

{
                "records": ["order", "orderItem"],
                "rules": [
                  {
                    "when": "#order.status == 'EXECUTED' && #order.executionDate != null",
                    "expr": "#cmp(#order.executionDate, #specimen.collectionEvent.time) >= 0",
                    "description": "Order date should be greater than the specimen (#specimen.label) collection date"
                  }
                ]
              }