Table of Contents |
---|
Data Validation Fields
We can set up data validation on these 3 types of fields and their combinations:
Core fields
Custom fields
Custom form fields
Combination of the core fields, custom fields, custom form fields
...
title | Field Dictionary used to create the expression in edit check |
---|
Core Fields Dictionary for Participants, Visits, and Specimens.
...
Level
...
Field Name
...
Field Expression
...
Participant
...
PPID
...
Code Block | ||
---|---|---|
| ||
#cpr.ppid |
...
Participant
...
First Name
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.firstName |
...
Participant
...
Middle Name
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.middleName |
...
Participant
...
Last Name
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.lastName |
...
Participant
...
Registration Date
...
Code Block | ||
---|---|---|
| ||
#cpr.registrationDate |
...
Participant
...
External Subject ID
...
Code Block | ||
---|---|---|
| ||
#cpr.externalSubjectId |
...
Participant
...
Registration Site
...
Code Block | ||
---|---|---|
| ||
#cpr.site |
...
Participant
...
Birth Date
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.birthDate |
...
Participant
...
Social Security Number
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.uid |
...
Participant
...
eMPI
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.empi |
...
Participant
...
Gender
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.gender |
...
Participant
...
Vital Status
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.vitalStatus |
...
Participant
...
Death Date
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.deathDate |
...
Participant
...
Races
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.races |
...
Participant
...
Ethnicity
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.ethnicities |
...
Participant
...
MRN
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.pmis |
...
Visit
...
Name
...
Code Block | ||
---|---|---|
| ||
#cpr.participant.pmis |
...
Visit
...
Name
...
Code Block | ||
---|---|---|
| ||
#visit.name |
...
Visit
...
Status
...
Code Block | ||
---|---|---|
| ||
#visit.status |
...
Visit
...
Missed By
...
Code Block | ||
---|---|---|
| ||
#visit.missedBy |
...
Visit
...
Missed Reason
...
Code Block | ||
---|---|---|
| ||
#visit.missedReason |
...
Visit
...
Visit Date
...
Code Block | ||
---|---|---|
| ||
#visit.visitDate |
...
Visit
...
Visit Site
...
Code Block | ||
---|---|---|
| ||
#visit.site |
...
Visit
...
Clinical Diagnosis
...
Code Block | ||
---|---|---|
| ||
#visit.clinicalDiagnoses |
...
Visit
...
Clinical Status
...
Code Block | ||
---|---|---|
| ||
#visit.surgicalPathologyNumber |
...
Visit
...
SPR
...
Code Block | ||
---|---|---|
| ||
#visit.clinicalStatus |
...
Visit
...
Visit Comments
...
Code Block | ||
---|---|---|
| ||
#visit.comments |
...
Specimen
...
Label
...
Code Block | ||
---|---|---|
| ||
#specimen.label |
...
Specimen
...
Barcode
...
Code Block | ||
---|---|---|
| ||
#specimen.barcode |
...
Specimen
...
Lineage
...
Code Block | ||
---|---|---|
| ||
#specimen.lineage |
...
Specimen
...
Collection Status
...
Code Block | ||
---|---|---|
| ||
#specimen.status |
...
Specimen
...
Type
...
Code Block | ||
---|---|---|
| ||
#specimen.type |
...
Specimen
...
Anatomic Site
...
Code Block | ||
---|---|---|
| ||
#specimen.anatomicSite |
...
Specimen
...
Laterality
...
Code Block | ||
---|---|---|
| ||
#specimen.laterality |
...
Specimen
...
Pathology Status
...
Code Block | ||
---|---|---|
| ||
#specimen.pathology |
...
Specimen
...
Initial Qty
...
Code Block | ||
---|---|---|
| ||
#specimen.initialQty |
...
Specimen
...
Available Qty
...
Code Block | ||
---|---|---|
| ||
#specimen.availableQty |
...
Specimen
...
Concentration
...
Code Block | ||
---|---|---|
| ||
#specimen.concentration |
...
Specimen
...
Parent Specimen Label
...
Code Block | ||
---|---|---|
| ||
#specimen.parentLabel |
...
Specimen
...
Biohazard
...
Code Block | ||
---|---|---|
| ||
#specimen.biohazards |
...
Specimen
...
Location
...
Code Block | ||
---|---|---|
| ||
#specimen.storageLocation |
...
Specimen
...
Created On
...
Code Block | ||
---|---|---|
| ||
#specimen.createdOn |
...
Specimen
...
Freezer Thaw Cycle
...
Code Block | ||
---|---|---|
| ||
#specimen.freezeThawCycles |
...
Specimen
...
Increment Freeze Thaw Cycle
...
Code Block | ||
---|---|---|
| ||
#specimen.incrParentFreezeThaw |
...
Specimen
...
Comments
...
Code Block | ||
---|---|---|
| ||
#specimen.comments |
...
Specimen
...
Collection Date
...
Code Block | ||
---|---|---|
| ||
#specimen.collectionEvent.time |
...
Specimen
...
Collector
...
Code Block | ||
---|---|---|
| ||
#specimen.collectionEvent.user |
...
Specimen
...
Received Date
...
Code Block | ||
---|---|---|
| ||
#specimen.receivedEvent.time |
...
Specimen
...
Receiver
...
Code Block | ||
---|---|---|
| ||
#specimen.receivedEvent.user |
...
Specimen
...
Collection Container
...
Code Block | ||
---|---|---|
| ||
#specimen.collectionEvent.container |
...
Specimen
...
Collection Procedure
...
Code Block | ||
---|---|---|
| ||
#specimen.collectionEvent.procedure |
...
Specimen
...
Received Quality
...
Code Block | ||
---|---|---|
| ||
#specimen.receivedEvent.receivedQuality |
...
Specimen
...
Frozen Time
...
Code Block | ||
---|---|---|
| ||
#specimen.events.SpecimenFrozenEvent.time |
...
Specimen
...
Frozen Method
...
Code Block | ||
---|---|---|
| ||
#specimen.events.SpecimenFrozenEvent.frozenMethod |
...
Specimen
...
Frozen Comments
...
Code Block | ||
---|---|---|
| ||
#specimen.events.SpecimenFrozenEvent.comments |
Examples
Participant
We can add edit checks on participant fields using the record type as ‘cpr’
Expand | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Visit
We can add edit checks on visit fields using the record type as ‘visit’
Expand | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||
|
Specimen
We can add edit checks on specimen fields using the record type as ‘specimen’
Expand | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||
|
Shipment
We can add edit checks on shipment fields using the record type as ‘shipment’
Expand | |||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||
|
Order
We can add edit checks on order fields using the record type as ‘order’
...