HOLOGRAM_SELECTIONS

Description: |
This table stores details about each selection made in a hologram record. Which specific details are stored depends on the type of each row.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HOLOGRAM_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HOLOGRAM_ID | NUMERIC | No |
The unique identifier (.1 item) for the hologram record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc. Note this does not represent an actual date; it simply serves as a unique line identifier in a specific hologram.
3 | DISPLAY_NAME | VARCHAR | No |
Display name of the selection stored in this contact.
4 | LEVEL_OF_SERVICE_PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
5 | SMARTTEXT_TYPE_C_NAME | VARCHAR | No |
The filing type category ID of the SmartText SSI.
May contain organization-specific values: Yes
Category Entries:
Progress Notes/Telephone Documentation
Patient Instructions
Inpatient Notes
ED Discharge Instructions
ED Patient Instructions
Discharge Attachments/Clinical References
6 | SMARTTEXT_NOTE_TYPE_IP_C_NAME | VARCHAR | No |
The note type category ID potentially filed to if the SmartText type is Inpatient Notes.
May contain organization-specific values: Yes
Category Entries:
Progress Notes
Consults
Procedures
H&P
Discharge Summary
ED Notes
Initial Assessments
ED Triage Notes
Case Communication
OR Nursing
OR Surgeon
OR PreOp
OR PostOp
OR Anesthesia
Ambulatory Progress Notes
Ambulatory H&P Notes
Ambulatory Procedure Notes
Discharge Instructions
ED Provider Notes
Decision
Note to Patient via Portal
Anesthesia Preprocedure Evaluation
Anesthesia Postprocedure Evaluation
H&P (View-Only)
Interval H&P Note
Anesthesia Procedure Notes
Addendum Note
Care Plan
Hospital Course
Subjective & Objective
L&D Delivery Note
Telephone Encounter
Patient Instructions
Assessment & Plan Note
Communication Body
ED AVS Snapshot
Letter
Lactation Note
Committee Review
IP AVS Snapshot
MR AVS Snapshot
Pharmacy Enrollment Note
Pre-Procedure Assessment
Discharge Instr - Supplementary Instructions
Discharge Instr - AVS First Page
Discharge Instr - Meds
Discharge Instr - Pharmacy
Discharge Instr - Activity
Discharge Instr - Diet
Discharge Instr - Appointments
Discharge Instr - Lab
Discharge Instr - Other Orders
Discharge Instr - Other Info
CAA (Care Area Assessment)
Nursing Note
ACP (Advance Care Planning)
ERAS
Organ Offer
Result Encounter Note
Radiation Planning Notes
Radiation Completion Notes
Radiation Therapy Simulation Directive
Radiation Treatment Planning Directive
Radiation Treatment Management
Radiation Treatment Summary
Home Infusion
Form
BH Treatment Plan
Group Note
Video Visit Routing Comment
E-Visit Routing Comment
Claim Note
Multi-Disciplinary Team Discussion
Dialysis Plan of Care Note
Home Health Plan of Care Certification Statement
Home Health Plan of Care
Dialysis Monthly Comprehensive Note
Dialysis Rounding Note
SMD Notes
Unmapped External Note
Filtered External Note
Code Documentation
Sedation Documentation
JDT PCOD
Dental Procedure Details
Performed Procedure
Appeal Review
Appeal MD Review
Appeal Intake
Appeal Creation
Appeal External Review
Grievance Review
Grievance Resolution
Grievance Intake
Grievance Creation
Home Health
LTC Provider Review
Chart Abstraction
MR Safety Technologist Evaluation
MR Safety Medical Physics Exam Customization
MR Safety Implant Electronics Preparation
MR Safety Implant Positioning and Immobilization
Inpatient Self-Administration Sheet
Outpatient Self-Administration Sheet
Inpatient Medication Chart
Outpatient Medication Chart
Hospice
Hospice Plan of Care
Hospice Non-Covered
Hard Deleted Note
7 | SMARTTEXT_ADDED_NOW_YN | VARCHAR | No |
Indicates whether "Add Now" was used to select the SmartText SSI. "Y" indicates it was; "N" or NULL indicate it was not.
May contain organization-specific values: No
Category Entries:
No
Yes
8 | SMARTTEXT_MAKE_SENSITIVE_YN | VARCHAR | No |
Indicates whether the note this selection will potentially contribute to is marked sensitive. "Y" indicates the note created or added to is marked sensitive. "N" or NULL indicate the sensitivity of the note created or filed to is unaffected by this.
The category values for this column were already listed for column: SMARTTEXT_ADDED_NOW_YN
9 | DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
10 | DX_DESCRIPTION | VARCHAR | No |
Display name of a diagnosis pended in a HOL record. Dynamic reflection of I SSI 5010.
11 | DX_QUAL_2_C_NAME | VARCHAR | No |
Qualifier for a diagnosis pended in an HOL record. Dynamic reflection of I SSI 5020.
May contain organization-specific values: Yes
12 | DX_COMMENT | VARCHAR | No |
Comment for a diagnosis pended in an HOL record. Dynamic reflection of I SSI 5030.
13 | DX_PRIMARY_YN | VARCHAR | No |
Whether a diagnosis pended in an HOL record is intended to be marked as the encounter's primary diagnosis. Dynamic reflection of I SSI 5060.
May contain organization-specific values: No
Category Entries:
Yes
No
14 | DX_CHRONIC_YN | VARCHAR | No |
Whether a diagnosis pended in an HOL is a chronic condition.
The category values for this column were already listed for column: SMARTTEXT_ADDED_NOW_YN
15 | IMMUN_ID | NUMERIC | No |
The unique ID of the immunization record associated with this hologram selection.
16 | IMMUN_ID_NAME | VARCHAR | No |
The name of the immunization.
17 | IMMNZTN_DOSE | VARCHAR | No |
The dose string, including quantity and unit, for the immunization in this hologram selection.
18 | IMMNZTN_DOSE_AMOUNT | NUMERIC | No |
The dose quantity for the immunization in this hologram selection. Corresponds to the unit in the IMMNZTN_DISP_QTYUNIT_C column.
19 | IMMNZTN_DISP_QTYUNIT_C_NAME | VARCHAR | No |
The dose unit category ID for the hologram selection.
May contain organization-specific values: Yes
Category Entries:
mL
L
mg
g
Units
mmol
mEq
mcg
%
Int'l Units
Million Units
kcal
ng
mg PE
milli-units
pg
KBq
MBq
GBq
mcL
mL/min
L/min
mg/min
g/min
Units/min
mmol/min
mEq/min
mcg/min
kJ/min
Int'l Units/min
Million Units/min
kcal/min
ng/min
mg PE/min
milli-units/min
pg/min
KBq/min
MBq/min
GBq/min
mcL/min
mL/hr
L/hr
mg/hr
g/hr
Units/hr
mmol/hr
mEq/hr
mcg/hr
kJ/hr
Int'l Units/hr
Million Units/hr
kcal/hr
ng/hr
mg PE/hr
milli-units/hr
pg/hr
KBq/hr
MBq/hr
GBq/hr
mcL/hr
mL/day
L/day
mg/day
g/day
Units/day
mmol/day
mEq/day
mcg/day
kJ/day
Int'l Units/day
Million Units/day
kcal/day
ng/day
mg PE/day
milli-units/day
pg/day
Inch/day
KBq/day
MBq/day
GBq/day
mcL/day
IR/day
BAU/day
PFU/day
Million PFU/day
Million Int'l Units/day
Kilo Int'l Units/day
EIN/day
Million EIN/day
mL/kg
L/kg
mg/kg
g/kg
Units/kg
mmol/kg
mEq/kg
mcg/kg
kJ/kg
Int'l Units/kg
Million Units/kg
kcal/kg
ng/kg
mg PE/kg
milli-units/kg
pg/kg
mg/kg (Actual)
Each/kg
Puff/kg
Package/kg
Drop/kg
Inch/kg
KBq/kg
MBq/kg
GBq/kg
mcL/kg
IR/kg
BAU/kg
Million Int'l Units/kg
mcmol/kg
1e12 Vector Genomes/kg
Vector Genomes/kg
Dose/kg
mcg DFE/kg
Kilo Int'l Units/kg
1e11 Vector Genomes/kg
1e13 Vector Genomes/kg
1e14 Vector Genomes/kg
1e15 Vector Genomes/kg
EIN/kg
IR/min
BAU/min
Million Int'l Units/min
Kilo Int'l Units/min
IR/hr
BAU/hr
Million Int'l Units/hr
Kilo Int'l Units/hr
mL/mL
L/mL
mg/mL
g/mL
Units/mL
mmol/mL
mEq/mL
mcg/mL
kJ/mL
Int'l Units/mL
Million Units/mL
kcal/mL
ng/mL
mg PE/mL
milli-units/mL
pg/mL
KBq/mL
MBq/mL
GBq/mL
mcL/mL
IR/mL
BAU/mL
PFU/mL
Million PFU/mL
Million Int'l Units/mL
mcmol/mL
1e12 Vector Genomes/mL
Vector Genomes/mL
Kilo Int'l Units/mL
1e11 Vector Genomes/mL
1e13 Vector Genomes/mL
1e14 Vector Genomes/mL
1e15 Vector Genomes/mL
millicurie/mL
mL/L
L/L
mg/L
g/L
Units/L
mmol/L
mEq/L
mcg/L
kJ/L
Int'l Units/L
Million Units/L
kcal/L
ng/L
mg PE/L
milli-units/L
pg/L
KBq/L
MBq/L
GBq/L
mcL/L
IR/L
BAU/L
Million Int'l Units/L
Kilo Int'l Units/L
mL/m2
L/m2
mg/m2
g/m2
Units/m2
mmol/m2
mEq/m2
mcg/m2
kJ/m2
Int'l Units/m2
Million Units/m2
kcal/m2
ng/m2
mg PE/m2
milli-units/m2
pg/m2
mg/m2 (Actual)
Each/m2
Puff/m2
Package/m2
Drop/m2
KBq/m2
MBq/m2
GBq/m2
mcL/m2
IR/m2
BAU/m2
Million Int'l Units/m2
mcmol/m2
1e12 Vector Genomes/m2
Vector Genomes/m2
Kilo Int'l Units/m2
1e11 Vector Genomes/m2
1e13 Vector Genomes/m2
1e14 Vector Genomes/m2
1e15 Vector Genomes/m2
mL/1.7m2
L/1.7m2
mg/1.7m2
g/1.7m2
Units/1.7m2
mmol/1.7m2
mEq/1.7m2
mcg/1.7m2
kJ/1.7m2
Int'l Units/1.7m2
Million Units/1.7m2
kcal/1.7m2
ng/1.7m2
mg PE/1.7m2
milli-units/1.7m2
pg/1.7m2
Each/1.7m2
KBq/1.7m2
MBq/1.7m2
GBq/1.7m2
mcL/1.7m2
IR/1.7m2
BAU/1.7m2
Million Int'l Units/1.7m2
Kilo Int'l Units/1.7m2
mL/kg (IDL)
L/kg (IDL)
mg/kg (IDL)
g/kg (IDL)
Units/kg (IDL)
mmol/kg (IDL)
mEq/kg (IDL)
mcg/kg (IDL)
Int'l Units/kg (IDL)
Million Units/kg (IDL)
Kcal/kg (IDL)
ng/kg (IDL)
mg PE/kg (IDL)
milli-units/kg (IDL)
pg/kg (IDL)
mg/m2 (IDL)
mL/kg (ADJ)
L/kg (ADJ)
mg/kg (ADJ)
g/kg (ADJ)
Units/kg (ADJ)
mmol/kg (ADJ)
mEq/kg (ADJ)
mcg/kg (ADJ)
Int'l Units/kg (ADJ)
Million Units/kg (ADJ)
Kcal/kg (ADJ)
ng/kg (ADJ)
mg PE/kg (ADJ)
milli-units/kg (ADJ)
pg/kg (ADJ)
mg/m2 (ADJ)
mL/100 mL
L/100 mL
mg/100 mL
g/100 mL
Units/100 mL
mmol/100 mL
mEq/100 mL
mcg/100 mL
kJ/100 mL
Int'l Units/100 mL
Million Units/100 mL
kcal/100 mL
ng/100 mL
mg PE/100 mL
milli-units/100 mL
pg/100 mL
KBq/100 mL
MBq/100 mL
GBq/100 mL
mcL/100 mL
IR/100 mL
BAU/100 mL
Million Int'l Units/100 mL
Kilo Int'l Units/100 mL
mL/oz
L/oz
mg/oz
g/oz
Units/oz
mmol/oz
mEq/oz
mcg/oz
kJ/oz
Int'l Units/oz
Million Units/oz
kcal/oz
ng/oz
mg PE/oz
milli-units/oz
pg/oz
KBq/oz
MBq/oz
GBq/oz
mcL/oz
IR/oz
BAU/oz
Million Int'l Units/oz
Kilo Int'l Units/oz
mL/kg/min
L/kg/min
mg/kg/min
g/kg/min
Units/kg/min
mmol/kg/min
mEq/kg/min
mcg/kg/min
kJ/kg/min
Int'l Units/kg/min
Million Units/kg/min
kcal/kg/min
ng/kg/min
mg PE/kg/min
milli-units/kg/min
pg/kg/min
KBq/kg/min
MBq/kg/min
GBq/kg/min
mcL/kg/min
mL/kg/min (IDL)
L/kg/min (IDL)
mg/kg/min (IDL)
g/kg/min (IDL)
Units/kg/min (IDL)
mmol/kg/min (IDL)
mEq/kg/min (IDL)
mcg/kg/min (IDL)
Int'l Units/kg/min (IDL)
Million Units/kg/min (IDL)
Kcal/kg/min (IDL)
ng/kg/min (IDL)
mg PE/kg/min (IDL)
milli-units/kg/min (IDL)
pg/kg/min (IDL)
mL/kg/min (ADJ)
L/kg/min (ADJ)
mg/kg/min (ADJ)
g/kg/min (ADJ)
Units/kg/min (ADJ)
mmol/kg/min (ADJ)
mEq/kg/min (ADJ)
mcg/kg/min (ADJ)
Int'l Units/kg/min (ADJ)
Million Units/kg/min (ADJ)
Kcal/kg/min (ADJ)
ng/kg/min (ADJ)
mg PE/kg/min (ADJ)
milli-units/kg/min (ADJ)
pg/kg/min (ADJ)
IR/kg/min
BAU/kg/min
Million Int'l Units/kg/min
Kilo Int'l Units/kg/min
mL/m2/min
L/m2/min
mg/m2/min
g/m2/min
Units/m2/min
mmol/m2/min
mEq/m2/min
mcg/m2/min
kJ/m2/min
Int'l Units/m2/min
Million Units/m2/min
kcal/m2/min
ng/m2/min
mg PE/m2/min
milli-units/m2/min
pg/m2/min
KBq/m2/min
MBq/m2/min
GBq/m2/min
mcL/m2/min
mL/1.7m2/min
L/1.7m2/min
mg/1.7m2/min
g/1.7m2/min
Units/1.7m2/min
mmol/1.7m2/min
mEq/1.7m2/min
mcg/1.7m2/min
kJ/1.7m2/min
Int'l Units/1.7m2/min
Million Units/1.7m2/min
kcal/1.7m2/min
ng/1.7m2/min
mg PE/1.7m2/min
milli-units/1.7m2/min
pg/1.7m2/min
KBq/1.7m2/min
MBq/1.7m2/min
GBq/1.7m2/min
mSv
mGy
mcL/1.7m2/min
mcSv
Sv
mcGy
cGy
Gy
mRAD
RAD
mg of pseudoephedrine
mg of ephedrine
IR/m2/min
BAU/m2/min
Million Int'l Units/m2/min
Kilo Int'l Units/m2/min
IR/1.7m2/min
BAU/1.7m2/min
Million Int'l Units/1.7m2/min
Kilo Int'l Units/1.7m2/min
mL/kg/hr
L/kg/hr
mg/kg/hr
g/kg/hr
Units/kg/hr
mmol/kg/hr
mEq/kg/hr
mcg/kg/hr
kJ/kg/hr
Int'l Units/kg/hr
Million Units/kg/hr
kcal/kg/hr
ng/kg/hr
mg PE/kg/hr
milli-units/kg/hr
pg/kg/hr
KBq/kg/hr
MBq/kg/hr
GBq/kg/hr
mcL/kg/hr
mL/kg/hr (IDL)
L/kg/hr (IDL)
mg/kg/hr (IDL)
g/kg/hr (IDL)
Units/kg/hr (IDL)
mmol/kg/hr (IDL)
mEq/kg/hr (IDL)
mcg/kg/hr (IDL)
Int'l Units/kg/hr (IDL)
Million Units/kg/hr (IDL)
Kcal/kg/hr (IDL)
ng/kg/hr (IDL)
mg PE/kg/hr (IDL)
milli-units/kg/hr (IDL)
pg/kg/hr (IDL)
mL/kg/hr (ADJ)
L/kg/hr (ADJ)
mg/kg/hr (ADJ)
g/kg/hr (ADJ)
Units/kg/hr (ADJ)
mmol/kg/hr (ADJ)
mEq/kg/hr (ADJ)
mcg/kg/hr (ADJ)
Int'l Units/kg/hr (ADJ)
Million Units/kg/hr (ADJ)
Kcal/kg/hr (ADJ)
ng/kg/hr (ADJ)
mg PE/kg/hr (ADJ)
milli-units/kg/hr (ADJ)
pg/kg/hr (ADJ)
IR/kg/hr
BAU/kg/hr
Million Int'l Units/kg/hr
Kilo Int'l Units/kg/hr
mL/m2/hr
L/m2/hr
mg/m2/hr
g/m2/hr
Units/m2/hr
mmol/m2/hr
mEq/m2/hr
mcg/m2/hr
kJ/m2/hr
Int'l Units/m2/hr
Million Units/m2/hr
kcal/m2/hr
ng/m2/hr
mg PE/m2/hr
milli-units/m2/hr
pg/m2/hr
KBq/m2/hr
MBq/m2/hr
GBq/m2/hr
mcL/m2/hr
mL/1.7m2/hr
L/1.7m2/hr
mg/1.7m2/hr
g/1.7m2/hr
Units/1.7m2/hr
mmol/1.7m2/hr
mEq/1.7m2/hr
mcg/1.7m2/hr
kJ/1.7m2/hr
Int'l Units/1.7m2/hr
Million Units/1.7m2/hr
kcal/1.7m2/hr
ng/1.7m2/hr
mg PE/1.7m2/hr
milli-units/1.7m2/hr
pg/1.7m2/hr
KBq/1.7m2/hr
MBq/1.7m2/hr
GBq/1.7m2/hr
mcL/1.7m2/hr
IR/1.7m2/hr
BAU/1.7m2/hr
Million Int'l Units/1.7m2/hr
Kilo Int'l Units/1.7m2/hr
IR/m2/hr
BAU/m2/hr
Million Int'l Units/m2/hr
Kilo Int'l Units/m2/hr
mL/kg/day
L/kg/day
mg/kg/day
g/kg/day
Units/kg/day
mmol/kg/day
mEq/kg/day
mcg/kg/day
kJ/kg/day
Int'l Units/kg/day
Million Units/kg/day
kcal/kg/day
ng/kg/day
mg PE/kg/day
milli-units/kg/day
pg/kg/day
Inch/kg/day
KBq/kg/day
MBq/kg/day
GBq/kg/day
mL/kg/day (IDL)
L/kg/day (IDL)
mg/kg/day (IDL)
g/kg/day (IDL)
Units/kg/day (IDL)
mmol/kg/day (IDL)
mEq/kg/day (IDL)
mcg/kg/day (IDL)
Int'l Units/kg/day (IDL)
Million Units/kg/day (IDL)
Kcal/kg/day (IDL)
ng/kg/day (IDL)
mg PE/kg/day (IDL)
milli-units/kg/day (IDL)
pg/kg/day (IDL)
mL/kg/day (ADJ)
L/kg/day (ADJ)
mg/kg/day (ADJ)
g/kg/day (ADJ)
Units/kg/day (ADJ)
mmol/kg/day (ADJ)
mEq/kg/day (ADJ)
mcg/kg/day (ADJ)
Int'l Units/kg/day (ADJ)
Million Units/kg/day (ADJ)
Kcal/kg/day (ADJ)
ng/kg/day (ADJ)
mg PE/kg/day (ADJ)
milli-units/kg/day (ADJ)
pg/kg/day (ADJ)
mcL/kg/day
IR/kg/day
BAU/kg/day
Million Int'l Units/kg/day
mL/m2/day
L/m2/day
mg/m2/day
g/m2/day
Units/m2/day
mmol/m2/day
mEq/m2/day
mcg/m2/day
kJ/m2/day
Int'l Units/m2/day
Million Units/m2/day
kcal/m2/day
ng/m2/day
mg PE/m2/day
milli-units/m2/day
pg/m2/day
KBq/m2/day
MBq/m2/day
GBq/m2/day
mcL/m2/day
mL/1.7m2/day
L/1.7m2/day
mg/1.7m2/day
g/1.7m2/day
Units/1.7m2/day
mmol/1.7m2/day
mEq/1.7m2/day
mcg/1.7m2/day
kJ/1.7m2/day
Int'l Units/1.7m2/day
Million Units/1.7m2/day
kcal/1.7m2/day
ng/1.7m2/day
mg PE/1.7m2/day
milli-units/1.7m2/day
pg/1.7m2/day
KBq/1.7m2/day
MBq/1.7m2/day
GBq/1.7m2/day
mcL/1.7m2/day
mL/oz/day
L/oz/day
mg/oz/day
g/oz/day
Units/oz/day
mmol/oz/day
mEq/oz/day
mcg/oz/day
kJ/oz/day
Int'l Units/oz/day
Million Units/oz/day
kcal/oz/day
ng/oz/day
mg PE/oz/day
milli-units/oz/day
pg/oz/day
KBq/oz/day
MBq/oz/day
GBq/oz/day
mcL/oz/day
IR/m2/day
BAU/m2/day
Million Int'l Units/m2/day
Kilo Int'l Units/m2/day
IR/1.7m2/day
BAU/1.7m2/day
Million Int'l Units/1.7m2/day
Kilo Int'l Units/1.7m2/day
IR/oz/day
BAU/oz/day
Million Int'l Units/oz/day
Kilo Int'l Units/oz/day
kJ/30 mL
kcal/30 mL
Gy-cm2
mcGy-cm2
mGy-cm2
cGy-cm2
dGy-cm2
mcGy-m2
mGy-m2
cGy-m2
dGy-m2
Gy-m2
mRAD-cm2
RAD-cm2
mL/cm2
mg/cm2
mOsmol
each
tablet
capsule
drop
tsp
puff
suppository
spray
Squirt
inch
patch
Act
ampule
Bar
Bottle
Can
Device
enema
Gallon
Inhaler
kit
lb
lozenge
oz
packet
Stick
strip
Tbsp
Tube
vial
Wafer
Container
Syringe
Package
applicator
cm
Applicatorful
Troche
millicurie
Intra Uterine Device
Part
m
Film
Million Cells
Dose
mm
IR
BAU
kg
cm2
Imperial Gallon
kJ
PFU
Piece
Million PFU
Doses/Fill
Cartridge
Thousand Units
Lipoprotein Lipase Releasing Unit
Scoop
Million Int'l Units
mm2
Pump
fluid ounce
Product
Bag
mcmol
1e12 Vector Genomes
Vector Genomes
millicurie/kg
millicurie/m2
millicurie/1.7m2
microcurie
microcurie/kg
microcurie/m2
microcurie/1.7m2
Canister
mcg DFE
Billion Cells
Application
Box
Capful
Inhalation
Lancet
Needle
Pad
Pen
Piece of gum
Ring
Swab
Sachet
Implant
Insert
Pools
Kilo Int'l Units
Kilo Int'l Units/kg/day
1e11 Vector Genomes
1e13 Vector Genomes
1e14 Vector Genomes
1e15 Vector Genomes
Cells
EIN
Million EIN
EIN/kg/day
mGy-cm
cGy-cm
dGy-cm
Gy-cm
mGy-m
cGy-m
dGy-m
Gy-m
Hounsfield Units
None / Other
20 | IMMNZTN_ROUTE_C_NAME | VARCHAR | No |
The immunization route category ID for the hologram selection.
May contain organization-specific values: Yes
21 | IMMNZTN_SITE_C_NAME | VARCHAR | No |
The immunization site category ID for the hologram selection.
May contain organization-specific values: Yes
22 | IMMNZTN_MANUFACTURER_MFG_C_NAME | VARCHAR | No |
The immunization manufacturer category ID for the hologram selection.
May contain organization-specific values: Yes
23 | IMMNZTN_LOT_NUMBER | VARCHAR | No |
The lot number for the immunization in this hologram selection.
24 | IMMNZTN_PRODUCT | VARCHAR | No |
The product for the immunization in this hologram selection.
25 | IMMNZTN_NDC_ID | VARCHAR | No |
The unique ID of the national drug code associated with the immunization in this hologram selection.
26 | IMMNZTN_NDC_ID_NDC_CODE | VARCHAR | No |
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
27 | IMMNZTN_IMM_PRODUCT_C_NAME | VARCHAR | No |
The immunization product category ID for the hologram selection.
May contain organization-specific values: Yes
No Entries Defined
28 | IMMNZTN_DATE | DATETIME | No |
The date this immunization was administered.
29 | IMMNZTN_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
The date and time that this immunization was administered.
30 | IMMNZTN_INVENTORY_CLASS_C_NAME | VARCHAR | No |
The inventory class category ID for the hologram selection.
May contain organization-specific values: No
Category Entries:
Facility Administered
Prescription
Vaccines for Children
31 | IMMNZTN_LOT_NUM_ID_LOT_NUM | VARCHAR | No |
The lot number on the vial for a given medication or immunization.
32 | IMMNZTN_NEXT_DUE_DATE | DATETIME | No |
Date of the next time this immunization is due.
33 | IMMNZTN_EXPIRATION_DATE | DATETIME | No |
Expiration date for this immunization.
34 | IMMNZTN_IMM_DEFER_DUR_C_NAME | VARCHAR | No |
The immunization deferral duration category ID for the hologram selection.
May contain organization-specific values: Yes
No Entries Defined
35 | IMMNZTN_GIVEN_BY_USER_ID | VARCHAR | No |
The unique ID associated with the user record for this row. This column is frequently used to link to the CLARITY_EMP table.
36 | IMMNZTN_GIVEN_BY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
37 | IMMNZTN_EXTERNAL_ADMIN_C_NAME | VARCHAR | No |
The immunization external administration category ID for the hologram selection.
May contain organization-specific values: Yes
Category Entries:
Patient reported
Confirmed
MyChart Entered
Auto Reconciled From Outside Source
38 | IMMNZTN_VIS_DATE | VARCHAR | No |
The issue date of the Vaccine Information Statement provided to the patient for the immunization in this hologram selection. This value is a freetext string, not a discrete date.
39 | IMMNZTN_DEFER_REASON_C_NAME | VARCHAR | No |
The immunization deferral reason category ID for the hologram selection.
May contain organization-specific values: Yes
Category Entries:
Patient Refused
Contraindication
40 | IMMNZTN_ADMIN_COMMENT | VARCHAR | No |
The immunization administration comment entered by the user who administered the vaccine.
41 | IMMNZTN_ADMIN_LOCATION | VARCHAR | No |
This item stores the physical location where the immunization was administered. Note this column does not network to a location table.
42 | IMMNZTN_STATUS_C_NAME | VARCHAR | No |
The immunization status category ID for the hologram selection.
May contain organization-specific values: No
Category Entries:
Given
Deleted
Incomplete
Deferred
Refused
Partially Administered
Invalid
43 | LOS_COMPONENT_PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
44 | COMPONENT_LOS_NEW_OR_EST_C_NAME | VARCHAR | No |
The new or established patient category ID for the level of service component.
May contain organization-specific values: No
Category Entries:
New
Established
45 | LOS_COMPONENT_COUNSEL_TIME | INTEGER | No |
Level of service component counseling time.
46 | COMPONENT_LOS_HX_LEVEL_C_NAME | VARCHAR | No |
The history level category ID for the level of service component.
May contain organization-specific values: No
Category Entries:
Problem Focused
Expanded Problem Focused
Detailed
Comprehensive
47 | COMPONENT_LOS_EXAM_LEVEL_C_NAME | VARCHAR | No |
The exam level category ID for the level of service component.
May contain organization-specific values: No
Category Entries:
Problem Focused
Expanded Problem Focused
Detailed
Comprehensive
48 | COMPONENT_LOS_MDM_LEVEL_C_NAME | VARCHAR | No |
The MDM level category ID for the level of service component.
May contain organization-specific values: No
Category Entries:
Straightforward
Low Complexity
Moderate Complexity
High Complexity
49 | LOS_COMPONENT_PROC_CALC_YN | VARCHAR | No |
Indicates whether the level of service component procedure ID was calculated ('Y') or not calculated ('N' or NULL).
The category values for this column were already listed for column: SMARTTEXT_ADDED_NOW_YN
50 | FUP_NUMBER_OF_UNITS | INTEGER | No |
Follow-up number of units.
51 | FUP_TYPE_OF_UNIT_C_NAME | VARCHAR | No |
Category from I EPT 18314.
May contain organization-specific values: No
Category Entries:
Days
Weeks
Months
Years
As needed (PRN)
Date
52 | FUP_APPROX_YN | VARCHAR | No |
Follow-up approximately checkbox value. Category from ECT 100.
The category values for this column were already listed for column: DX_PRIMARY_YN
53 | FUP_PRN_YN | VARCHAR | No |
Follow-up PRN checkbox value. Category from ECT 100.
The category values for this column were already listed for column: DX_PRIMARY_YN
54 | FUP_RETURN_FOR_TEXT | VARCHAR | No |
Free-text note indicating what the follow-up is for.
55 | FUP_CODIFIED_C_NAME | VARCHAR | No |
Category from I EPT 18210, but stored in I EPT 18330. Used to store the method of follow-up.
May contain organization-specific values: Yes
56 | FUP_INSTRUCTIONS_CODIFIED_C_NAME | VARCHAR | No |
Category from I EPT 18211, but stored in I EPT 18331. Used to store special instructions for the follow-up.
May contain organization-specific values: Yes
57 | FUP_COPY_TO_PCP_YN | VARCHAR | No |
Category value from ECT 100 to indicate if the patient's primary care provider should automatically be included as a recipient when documenting the follow-up.
The category values for this column were already listed for column: DX_PRIMARY_YN
58 | FUP_SEND_REMINDER_YN | VARCHAR | No |
Category from ECT 100. Used to determine if a reminder should be sent for the follow-up.
The category values for this column were already listed for column: DX_PRIMARY_YN
59 | FUP_REMINDER_DAYS | INTEGER | No |
The number of days to wait until the follow-up reminder message is sent.
60 | FUP_PRN_TEXT | VARCHAR | No |
Text explaining when the patient should follow up PRN.
61 | FUP_REMINDER_MESSAGE | VARCHAR | No |
Message that will be sent as a follow-up reminder.
62 | FUP_ROUTING_PRIORITY_C_NAME | VARCHAR | No |
Follow-up chart routing priority.
May contain organization-specific values: Yes
Category Entries:
High
Routine
Low
63 | FUP_ROUTING_COMMENT | VARCHAR | No |
Follow-up chart routing comments.
64 | FUP_USER_ACCEPTED_YN | VARCHAR | No |
Category from ECT 101 to track whether the user has accepted the follow-up details.
The category values for this column were already listed for column: SMARTTEXT_ADDED_NOW_YN
65 | NT_DISPOSITION_PHONE_DISP_C_NAME | VARCHAR | No |
Disposition from category EPT 17400.
May contain organization-specific values: Yes
66 | NT_DISPOSITION_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
67 | NT_DISPOSITION_COMMENT | VARCHAR | No |
Disposition comment.
68 | NT_DISPOSITION_DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
69 | NT_DISP_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
The disposition instant stored in UTC format.
70 | REASON_FOR_VISIT_RFV_ID_REASON_VISIT_NAME | VARCHAR | No |
The name of the Reason for Visit record.
71 | REASON_FOR_VISIT_COMMENT | VARCHAR | No |
Contains free text comments about a reason for visit that is being temporarily stored in a hologram record. Dynamic reflection of I SSI 10010.
72 | REASON_FOR_VISIT_ONSET_DATE | DATETIME | No |
Contains onset date for a reason for visit that is being temporarily stored in a hologram record.