Display Field Name | Description | First Iteration | Second Iteration | Third Iteration |
---|---|---|---|---|
MRN | Patient medical record number | ✓ | ✓ | ✓ |
Status | Scheduling status: scheduled, cancelled, no show, arrived, completed, etc. | ✓ | ✓ | ✓ |
Date | Date of colonoscopy | ✓ | ✓ | ✓ |
First Name | Patient’s first name | ✓ | ✓ | ✓ |
Preferred Name | Patient's preferred name | |||
Last Name | Patient’s last name | ✓ | ✓ | ✓ |
DOB | Date of birth | ✓ | ✓ | ✓ |
Age | Age | ✓ | ✓ | ✓ |
Sex | Sex | ✓ | ✓ | ✓ |
Race | Race | ✓ | ✓ | ✓ |
Hispanic Ethnicity | Yes/No answers | ✓ | ✓ | ✓ |
Preferred Language | Preferred language | ✓ | ||
Phone | Primary phone number | ✓ | ✓ | ✓ |
Home | Home phone number | ✓ | ✓ | |
Cell | Cell phone number | ✓ | ||
Patient Email Address | Email address | ✓ | ||
Patient Address (Line 1) | Patient address (line 1) | ✓* | ✓ | ✓ |
Patient Address (Line 2) | Patient address (line 2) | ✓* | ✓ | ✓ |
City | City | ✓* | ✓ | ✓ |
State | State | ✓* | ✓ | ✓ |
ZIP Code | ZIP code | ✓* | ✓ | |
Department | Department at which the procedure will be performed | ✓ | ✓ | |
Type | Type of colonoscopy procedure | ✓ | ✓ | ✓ |
Ordering Provider | Ordering provider | ✓ | ✓ | ✓ |
Attending Provider | Attending provider | ✓ | ✓ | ✓ |
Associated Diagnosis | Associated Dx in the order for colonoscopy | ✓ | ✓ | |
Indication | Physician’s indication for the Dx in the order | ✓ | ✓ | |
Rectal Bleeding† | Patient had rectal bleeding in the past 60 days | ✓ | ||
ASN† | Appointment serial number—A unique identifier for all appointments associated with a physician order. Used in combination with CSN to track appointment changes. | ✓ | ||
CSN‡ | Contact serial number—A unique identifier for a new appointment. Used in combination with ASN to track appointment changes. | ✓ |
↵* Address was a single field in the first iteration. Subsequent iterations imported discrete fields.
↵† The ICD-10 codes associated with rectal bleeding (K62.5, K92.1, and R19.5) were found in the encounter diagnoses from encounters that occurred in the past 60 days and grouped together to create a single variable, Rectal Bleeding. These were distinct from the ICD-10 codes criterion, which was designed to search the problem list.
↵‡ In Epic, a unique Contact Serial Number (CSN) is generated for each new appointment that is made for an Order. The first CSN to be generated is designated as the Appointment Serial Number (ASN), which serves as the reference number connecting all subsequent appointment changes that occur for that Order.