View harbinger.public.view_external_cube_exam_facts
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
Order Placed Date timestamptz 35,6  √  null
Scheduled Date timestamptz 35,6  √  null
Rescheduled Date timestamptz 35,6  √  null
Appointment Date timestamptz 35,6  √  null
Patient Arrival Time timestamptz 35,6  √  null
Begin Registration Date timestamptz 35,6  √  null
Check In Date timestamptz 35,6  √  null
Exam Start Time timestamptz 35,6  √  null
Begin Exam Event Time timestamptz 35,6  √  null
Exam Complete Time timestamptz 35,6  √  null
End Exam Event Time timestamptz 35,6  √  null
Cancelled Time timestamptz 35,6  √  null
Final Read Time timestamptz 35,6  √  null
Prelim Read Time timestamptz 35,6  √  null
First Read Time timestamptz 35,6  √  null
First Image in PACS Time timestamptz 35,6  √  null
Scan Start Time timestamptz 35,6  √  null
Scan End Time timestamptz 35,6  √  null
exam_date timestamptz 35,6  √  null
Exam ID int8 19  √  null
Accession Number text 2147483647  √  null
site_id int8 19  √  null
site text 2147483647  √  null
site_name text 2147483647  √  null
resource_id int8 19  √  null
resource text 2147483647  √  null
resource_name text 2147483647  √  null
modality_id int8 19  √  null
HL7 Modality text 2147483647  √  null
radiologist_id int8 19  √  null
resident_id int8 19  √  null
technologist_id int8 19  √  null
ordering_provider_id int8 19  √  null
procedure_id int8 19  √  null
procedure_code text 2147483647  √  null
procedure_description text 2147483647  √  null
reportable bool 1  √  null
procedure_specialty_id int8 19  √  null
patient_id int8 19  √  null
patient_mrn_id int8 19  √  null
site_class_id int8 19  √  null
site_location_id int8 19  √  null
patient_class text 2147483647  √  null
rad_exam_department_id int8 19  √  null
rad_exam_department text 2147483647  √  null
rad_exam_department_description text 2147483647  √  null
delay_reason_id int8 19  √  null
delay_reason text 2147483647  √  null
exam_priority_id int8 19  √  null
priority text 2147483647  √  null
scheduler_id int8 19  √  null
exam_status text 2147483647  √  null
prelim_read_flag bool 1  √  null
final_read_flag bool 1  √  null
order_placed_flag bool 1  √  null
order_scheduled_flag bool 1  √  null
patient_arrival_flag bool 1  √  null
exam_complete_flag bool 1  √  null
cancelled_before_arrival_flag bool 1  √  null
cancelled_after_arrival_flag bool 1  √  null
cancelled_before_scheduled_flag bool 1  √  null
cancelled_after_scheduled_flag bool 1  √  null
first_image_in_pacs_flag bool 1  √  null
Prelim Read Flag bool 1  √  null
Final Read Flag bool 1  √  null
Order Placed Flag bool 1  √  null
Order Scheduled Flag bool 1  √  null
Patient Arrival Flag bool 1  √  null
Exam Complete Flag bool 1  √  null
Cancelled Before Arrival Flag bool 1  √  null
Cancelled After Arrival Flag bool 1  √  null
Cancelled Before Scheduled Flag bool 1  √  null
Cancelled After Scheduled Flag bool 1  √  null
First Image in PACS Flag bool 1  √  null
volume int4 10  √  null
pro_rvu float8 17,17  √  null
tech_rvu float8 17,17  √  null
patient_age int4 10  √  null
access_wait int8 19  √  null
reg_wait int8 19  √  null
reg_duration int8 19  √  null
exam_wait int8 19  √  null
Exam Begin to Exam Complete TAT int8 19  √  null
Patient Arrived to Exam Begin TAT int8 19  √  null
order_complete int8 19  √  null
Exam Complete to Prelim Read TAT int8 19  √  null
Exam Complete to Final Read TAT int8 19  √  null
first_report_turn_around int8 19  √  null
order_first_image int8 19  √  null
order_last_image int8 19  √  null
First Image in PACS to Prelim Read TAT int8 19  √  null
last_image_prelim int8 19  √  null
first_image_final int8 19  √  null
First Image in PACS to Final Read TAT int8 19  √  null
end_exam_first_image int8 19  √  null
Scan End to PACS TAT int8 19  √  null
send_duration int8 19  √  null
transport int8 19  √  null
order_first_report int8 19  √  null
order_first_prelim int8 19  √  null
order_first_final int8 19  √  null
schedule_first_report int8 19  √  null
schedule_first_prelim int8 19  √  null
schedule_first_final int8 19  √  null
send_delay int8 19  √  null
Scan Start to Scan End TAT int8 19  √  null
order_begin_acquisition int8 19  √  null
order_end_acquisition int8 19  √  null
Patient Arrived to Scan Start TAT int8 19  √  null
acquisition_delay int8 19  √  null
acquisition_ready int8 19  √  null
acquisition_first_report int8 19  √  null
acquisition_first_prelim int8 19  √  null
Scan End to Final Read TAT int8 19  √  null
appointment_duration int8 19  √  null
rad_pacs_bodypart_id int8 19  √  null
bodypart text 2147483647  √  null
rad_pacs_modality_id int8 19  √  null
modality text 2147483647  √  null
rad_pacs_aet_id int8 19  √  null
ae_title text 2147483647  √  null
rad_pacs_speciality_id int8 19  √  null
speciality text 2147483647  √  null
updated_at timestamptz 35,6  √  null
Order to Schedule TAT int8 19  √  null
Schedule to Patient Arrived TAT int8 19  √  null
Exam Begin to Scan Start TAT int8 19  √  null
Prelim Read to Final Read TAT int8 19  √  null
Order to Patient Arrived TAT int8 19  √  null
Patient Arrived to Exam Complete TAT int8 19  √  null
department text 2147483647  √  null
department_name text 2147483647  √  null
provider_group text 2147483647  √  null
group_name text 2147483647  √  null
manufacturer text 2147483647  √  null
charges int8 19  √  null
payments int8 19  √  null
adjustments int8 19  √  null
accounts_receivable int8 19  √  null
acquisition_interseries_delay int8 19  √  null
acquisition_series_duration int8 19  √  null
image_count int8 19  √  null
series_count int8 19  √  null
first_image timestamptz 35,6  √  null
last_image timestamptz 35,6  √  null
dicom_begin timestamptz 35,6  √  null
dicom_end timestamptz 35,6  √  null
service_id int8 19  √  null
service text 2147483647  √  null
service_description text 2147483647  √  null

Analyzed at Tue Aug 16 14:31 UTC 2022