harbinger.public contains 1296 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
cms_hcpcs_code_revisions	active	bool	1			true
employees	active	bool	1	√		true
icd_code_revisions	active	bool	1			true
locales	active	bool	1	√		null
procedures	active	bool	1			true
sites	application_visible	bool	1			true
view_external_cube_exam_facts	Cancelled After Arrival Flag	bool	1	√		null
view_external_cube_exam_facts	Cancelled After Scheduled Flag	bool	1	√		null
view_external_cube_exam_facts	Cancelled Before Arrival Flag	bool	1	√		null
view_external_cube_exam_facts	Cancelled Before Scheduled Flag	bool	1	√		null
view_external_cube_exam_facts	cancelled_after_arrival_flag	bool	1	√		null
view_external_cube_exam_facts	cancelled_after_scheduled_flag	bool	1	√		null
view_external_cube_exam_facts	cancelled_before_arrival_flag	bool	1	√		null
view_external_cube_exam_facts	cancelled_before_scheduled_flag	bool	1	√		null
cms_facility_types	cms_facility	bool	1
sites	cms_facility	bool	1	√		null
scheduling_tasks	deleted	bool	1			false
site_classes	ed	bool	1
patient_mrns	empi	bool	1			false
view_external_cube_exam_facts	Exam Complete Flag	bool	1	√		null
view_external_cube_exam_facts	exam_complete_flag	bool	1	√		null
view_external_cube_exam_facts	Final Read Flag	bool	1	√		null
view_external_cube_exam_facts	final_read_flag	bool	1	√		null
view_external_cube_exam_facts	First Image in PACS Flag	bool	1	√		null
view_external_cube_exam_facts	first_image_in_pacs_flag	bool	1	√		null
scheduling_tasks	holiday	bool	1			false
application_information	in_progress	bool	1	√		false
view_external_cube_exam_facts	Order Placed Flag	bool	1	√		null
view_external_cube_exam_facts	Order Scheduled Flag	bool	1	√		null
view_external_cube_exam_facts	order_placed_flag	bool	1	√		null
view_external_cube_exam_facts	order_scheduled_flag	bool	1	√		null
metasites	organizational	bool	1			false
view_external_cube_exam_facts	Patient Arrival Flag	bool	1	√		null
view_external_cube_exam_facts	patient_arrival_flag	bool	1	√		null
card_case_facts	patient_priority_specified_date	bool	1	√		null
rad_exam_facts	patient_priority_specified_date	bool	1	√		null
view_external_cube_exam_facts	Prelim Read Flag	bool	1	√		null
view_external_cube_exam_facts	prelim_read_flag	bool	1	√		null
employee_specialty_mappings	primary_specialty	bool	1	√		false
card_case_facts	reportable	bool	1	√		null
procedures	reportable	bool	1	√		true
rad_exam_facts	reportable	bool	1	√		null
view_external_cube_exam_facts	reportable	bool	1	√		null
claim_transaction_facts	self_pay	bool	1	√		null
claim_transactions	self_pay	bool	1	√		null
job_metrics_logs	success	bool	1
cms_hcpcs_codes	supply	bool	1			false
cms_hcpcs_codes	surgical	bool	1			false
site_classes	trauma	bool	1
application_information	visibility	bool	1	√		true
card_case_facts	appointment_day	int2	5	√		null
card_case_facts	appointment_dow	int2	5	√		null
card_case_facts	appointment_hour	int2	5	√		null
card_case_facts	appointment_minute	int2	5	√		null
card_case_facts	appointment_month	int2	5	√		null
card_case_facts	appointment_woy	int2	5	√		null
card_case_facts	appointment_year	int2	5	√		null
card_case_facts	begin_case_day	int2	5	√		null
card_case_facts	begin_case_dow	int2	5	√		null
card_case_facts	begin_case_hour	int2	5	√		null
card_case_facts	begin_case_minute	int2	5	√		null
card_case_facts	begin_case_month	int2	5	√		null
card_case_facts	begin_case_woy	int2	5	√		null
card_case_facts	begin_case_year	int2	5	√		null
rad_exam_facts	dicom_end_day	int2	5	√		null
rad_exam_facts	dicom_end_dow	int2	5	√		null
rad_exam_facts	dicom_end_hour	int2	5	√		null
rad_exam_facts	dicom_end_minute	int2	5	√		null
rad_exam_facts	dicom_end_month	int2	5	√		null
rad_exam_facts	dicom_end_woy	int2	5	√		null
rad_exam_facts	dicom_end_year	int2	5	√		null
card_case_facts	end_case_day	int2	5
card_case_facts	end_case_dow	int2	5
card_case_facts	end_case_hour	int2	5
card_case_facts	end_case_minute	int2	5
card_case_facts	end_case_month	int2	5
card_case_facts	end_case_woy	int2	5
card_case_facts	end_case_year	int2	5
rad_exam_facts	end_exam_day	int2	5
rad_exam_facts	end_exam_dow	int2	5
rad_exam_facts	end_exam_hour	int2	5
rad_exam_facts	end_exam_minute	int2	5
rad_exam_facts	end_exam_month	int2	5
rad_exam_facts	end_exam_woy	int2	5
rad_exam_facts	end_exam_year	int2	5
card_case_facts	final_report_day	int2	5	√		null
rad_exam_facts	final_report_day	int2	5	√		null
card_case_facts	final_report_dow	int2	5	√		null
rad_exam_facts	final_report_dow	int2	5	√		null
card_case_facts	final_report_hour	int2	5	√		null
rad_exam_facts	final_report_hour	int2	5	√		null
card_case_facts	final_report_minute	int2	5	√		null
rad_exam_facts	final_report_minute	int2	5	√		null
card_case_facts	final_report_month	int2	5	√		null
rad_exam_facts	final_report_month	int2	5	√		null
card_case_facts	final_report_woy	int2	5	√		null
rad_exam_facts	final_report_woy	int2	5	√		null
card_case_facts	final_report_year	int2	5	√		null
rad_exam_facts	final_report_year	int2	5	√		null
card_case_facts	first_report_day	int2	5	√		null
rad_exam_facts	first_report_day	int2	5	√		null
card_case_facts	first_report_dow	int2	5	√		null
rad_exam_facts	first_report_dow	int2	5	√		null
card_case_facts	first_report_hour	int2	5	√		null
rad_exam_facts	first_report_hour	int2	5	√		null
card_case_facts	first_report_minute	int2	5	√		null
rad_exam_facts	first_report_minute	int2	5	√		null
card_case_facts	first_report_month	int2	5	√		null
rad_exam_facts	first_report_month	int2	5	√		null
card_case_facts	first_report_woy	int2	5	√		null
rad_exam_facts	first_report_woy	int2	5	√		null
card_case_facts	first_report_year	int2	5	√		null
rad_exam_facts	first_report_year	int2	5	√		null
card_case_facts	prelim_report_day	int2	5	√		null
rad_exam_facts	prelim_report_day	int2	5	√		null
card_case_facts	prelim_report_dow	int2	5	√		null
rad_exam_facts	prelim_report_dow	int2	5	√		null
card_case_facts	prelim_report_hour	int2	5	√		null
rad_exam_facts	prelim_report_hour	int2	5	√		null
card_case_facts	prelim_report_minute	int2	5	√		null
rad_exam_facts	prelim_report_minute	int2	5	√		null
card_case_facts	prelim_report_month	int2	5	√		null
rad_exam_facts	prelim_report_month	int2	5	√		null
card_case_facts	prelim_report_woy	int2	5	√		null
rad_exam_facts	prelim_report_woy	int2	5	√		null
card_case_facts	prelim_report_year	int2	5	√		null
rad_exam_facts	prelim_report_year	int2	5	√		null
claim_transaction_facts	service_performed_day	int2	5
claim_transaction_facts	service_performed_dow	int2	5
claim_transaction_facts	service_performed_hour	int2	5
claim_transaction_facts	service_performed_minute	int2	5
claim_transaction_facts	service_performed_month	int2	5
claim_transaction_facts	service_performed_woy	int2	5
claim_transaction_facts	service_performed_year	int2	5
claim_transaction_facts	transaction_post_day	int2	5
claim_transaction_facts	transaction_post_dow	int2	5
claim_transaction_facts	transaction_post_hour	int2	5
claim_transaction_facts	transaction_post_minute	int2	5
claim_transaction_facts	transaction_post_month	int2	5
claim_transaction_facts	transaction_post_woy	int2	5
claim_transaction_facts	transaction_post_year	int2	5
card_case_facts	wheels_in_day	int2	5	√		null
card_case_facts	wheels_in_dow	int2	5	√		null
card_case_facts	wheels_in_hour	int2	5	√		null
card_case_facts	wheels_in_minute	int2	5	√		null
card_case_facts	wheels_in_month	int2	5	√		null
card_case_facts	wheels_in_woy	int2	5	√		null
card_case_facts	wheels_in_year	int2	5	√		null
card_case_facts	wheels_out_day	int2	5	√		null
card_case_facts	wheels_out_dow	int2	5	√		null
card_case_facts	wheels_out_hour	int2	5	√		null
card_case_facts	wheels_out_minute	int2	5	√		null
card_case_facts	wheels_out_month	int2	5	√		null
card_case_facts	wheels_out_woy	int2	5	√		null
card_case_facts	wheels_out_year	int2	5	√		null
dicom_series	image_count	int4	10	√		null
dicom_studies	image_count	int4	10	√		null
rad_pacs_metadata	image_count	int4	10	√		null
card_case_details	patient_age	int4	10	√		null
card_case_facts	patient_age	int4	10	√		null
rad_exam_details	patient_age	int4	10	√		null
rad_exam_facts	patient_age	int4	10	√		null
view_external_cube_exam_facts	patient_age	int4	10	√		null
residents	pgy2	int4	10	√		null
residents	pgy3	int4	10	√		null
residents	pgy4	int4	10	√		null
residents	pgy5	int4	10	√		null
application_credentials	poolsize	int4	10			10
procedures	scheduled_duration	int4	10	√		null
dicom_studies	series_count	int4	10	√		null
claim_transaction_facts	unit_count	int4	10	√		null
claim_transactions	unit_count	int4	10	√		null
card_case_facts	volume	int4	10	√		null
procedures	volume	int4	10			1
rad_exam_facts	volume	int4	10	√		null
view_external_cube_exam_facts	volume	int4	10	√		null
patients	birthdate	date	13	√		null
cms_hcpcs_codes	conversion_factor	float8	17,17			0
cms_hcpcs_codes	facility_pe_rvu	float8	17,17			0
employees	fte	float8	17,17	√		1.0
cms_gpci	mp_gpci	float8	17,17			0
cms_hcpcs_codes	mp_rvu	float8	17,17			0
cms_hcpcs_codes	nonfacility_pe_rvu	float8	17,17			0
cms_gpci	pe_gpci	float8	17,17			0
card_case_facts	pro_rvu	float8	17,17	√		null
procedures	pro_rvu	float8	17,17			0
rad_exam_facts	pro_rvu	float8	17,17	√		null
view_external_cube_exam_facts	pro_rvu	float8	17,17	√		null
card_case_facts	tech_rvu	float8	17,17	√		null
procedures	tech_rvu	float8	17,17			0
rad_exam_facts	tech_rvu	float8	17,17	√		null
view_external_cube_exam_facts	tech_rvu	float8	17,17	√		null
cms_gpci	work_gpci	float8	17,17			0
cms_hcpcs_codes	work_rvu	float8	17,17			0
card_case_facts	access_wait	int8	19	√		null
card_case_metrics	access_wait	int8	19	√		null
rad_exam_facts	access_wait	int8	19	√		null
rad_exam_metrics	access_wait	int8	19	√		null
view_external_cube_exam_facts	access_wait	int8	19	√		null
dicom_studies	accession_external_system_id	int8	19	√		null
rad_exam_facts	accounts_receivable	int8	19	√		null
view_external_cube_exam_facts	accounts_receivable	int8	19	√		null
rad_exam_facts	acquisition_delay	int8	19	√		null
rad_exam_metrics	acquisition_delay	int8	19	√		null
view_external_cube_exam_facts	acquisition_delay	int8	19	√		null
rad_exam_facts	acquisition_duration	int8	19	√		null
rad_exam_metrics	acquisition_duration	int8	19	√		null
rad_exam_facts	acquisition_first_final	int8	19	√		null
rad_exam_metrics	acquisition_first_final	int8	19	√		null
rad_exam_facts	acquisition_first_prelim	int8	19	√		null
rad_exam_metrics	acquisition_first_prelim	int8	19	√		null
view_external_cube_exam_facts	acquisition_first_prelim	int8	19	√		null
rad_exam_facts	acquisition_first_report	int8	19	√		null
rad_exam_metrics	acquisition_first_report	int8	19	√		null
view_external_cube_exam_facts	acquisition_first_report	int8	19	√		null
rad_exam_facts	acquisition_interseries_delay	int8	19	√		null
rad_exam_metrics	acquisition_interseries_delay	int8	19	√		null
view_external_cube_exam_facts	acquisition_interseries_delay	int8	19	√		null
rad_exam_facts	acquisition_ready	int8	19	√		null
rad_exam_metrics	acquisition_ready	int8	19	√		null
view_external_cube_exam_facts	acquisition_ready	int8	19	√		null
rad_exam_facts	acquisition_series_duration	int8	19	√		null
rad_exam_metrics	acquisition_series_duration	int8	19	√		null
view_external_cube_exam_facts	acquisition_series_duration	int8	19	√		null
rad_exam_facts	acquisition_wait	int8	19	√		null
rad_exam_metrics	acquisition_wait	int8	19	√		null
rad_exam_facts	adjustments	int8	19	√		null
view_external_cube_exam_facts	adjustments	int8	19	√		null
card_case_facts	anesthesia_wait	int8	19	√		null
card_case_metrics	anesthesia_wait	int8	19	√		null
card_case_facts	anesthesiologist_id	int8	19	√		null
card_case_personnel	anesthesiologist_id	int8	19	√		null
application_information	application_category_id	int8	19	√		null
application_credentials	application_information_id	int8	19
card_case_times	appointment_duration	int8	19	√		null
orders	appointment_duration	int8	19	√		null
rad_exam_facts	appointment_duration	int8	19	√		null
rad_exam_times	appointment_duration	int8	19	√		null
view_external_cube_exam_facts	appointment_duration	int8	19	√		null
card_case_facts	appointment_epoch	int8	19	√		null
card_case_facts	assisting_ids	_int8	19	√		null
card_case_personnel	assisting_physician1_id	int8	19	√		null
card_case_personnel	assisting_physician2_id	int8	19	√		null
card_case_personnel	assisting_physician3_id	int8	19	√		null
rad_exam_personnel	assisting_tech1_id	int8	19	√		null
rad_exam_personnel	assisting_tech2_id	int8	19	√		null
rad_exam_personnel	assisting_tech3_id	int8	19	√		null
card_case_facts	attending_id	int8	19	√		null
card_case_personnel	attending_id	int8	19	√		null
rad_exam_personnel	attending_id	int8	19	√		null
card_case_personnel	authorizing_id	int8	19	√		null
rad_exam_personnel	authorizing_id	int8	19	√		null
claim_transactions	balance	int8	19
card_case_facts	begin_case_epoch	int8	19	√		null
card_case_personnel	begin_case_id	int8	19	√		null
rad_exam_facts	begin_exam_epoch	int8	19	√		null
rad_exam_personnel	begin_exam_id	int8	19	√		null
claim_transaction_facts	billing_employee_id	int8	19	√		null
claim_transactions	billing_employee_id	int8	19
card_reports	card1_id	int8	19	√		null
card_reports	card2_id	int8	19	√		null
card_reports	card3_id	int8	19	√		null
card_reports	card4_id	int8	19	√		null
card_case_authorizations	card_case_id	int8	19
card_case_claim_transactions	card_case_id	int8	19
card_case_claims	card_case_id	int8	19
card_case_details	card_case_id	int8	19
card_case_facts	card_case_id	int8	19
card_case_metadata	card_case_id	int8	19
card_case_metrics	card_case_id	int8	19
card_case_personnel	card_case_id	int8	19
card_case_procedure_mappings	card_case_id	int8	19
card_case_times	card_case_id	int8	19
card_reports	card_case_id	int8	19	√		null
dicom_studies	card_case_id	int8	19	√		null
card_case_metadata	card_case_metadata_type_id	int8	19
card_case_facts	cardiologist_id	int8	19	√		null
card_case_facts	cardiologist_specialty_id	int8	19	√		null
claim_transactions	carrier_id	int8	19	√		null
card_case_facts	case_duration	int8	19	√		null
card_case_metrics	case_duration	int8	19	√		null
card_case_facts	case_priority_id	int8	19	√		null
card_cases	case_priority_id	int8	19	√		null
card_case_facts	case_wait	int8	19	√		null
card_case_metrics	case_wait	int8	19	√		null
rad_exam_facts	charges	int8	19	√		null
view_external_cube_exam_facts	charges	int8	19	√		null
card_case_personnel	checkin_id	int8	19	√		null
rad_exam_personnel	checkin_id	int8	19	√		null
claim_transaction_facts	claim_denial_reason_id	int8	19	√		null
claim_transactions	claim_denial_reason_id	int8	19	√		null
card_case_claims	claim_id	int8	19
claim_transaction_facts	claim_id	int8	19	√		null
claim_transactions	claim_id	int8	19
rad_exam_claims	claim_id	int8	19
radonc_case_claims	claim_id	int8	19
claim_transactions	claim_sequence	int8	19
claim_transaction_facts	claim_status_id	int8	19	√		null
claim_transactions	claim_status_id	int8	19
card_case_claim_transactions	claim_transaction_id	int8	19
claim_transaction_cms_modifiers	claim_transaction_id	int8	19
claim_transaction_diagnoses	claim_transaction_id	int8	19
claim_transaction_facts	claim_transaction_id	int8	19
rad_exam_claim_transactions	claim_transaction_id	int8	19
claim_transaction_facts	claim_transaction_type_id	int8	19	√		null
claim_transactions	claim_transaction_type_id	int8	19
employee_clinical_role_mappings	clinical_role_id	int8	19
site_classes	cms_facility_type_id	int8	19	√		null
sites	cms_gpci_id	int8	19	√		null
claim_transaction_facts	cms_hcpcs_code_id	int8	19	√		null
claim_transactions	cms_hcpcs_code_id	int8	19
procedure_hcpcs_mappings	cms_hcpcs_code_id	int8	19
cms_gpci	cms_hcpcs_code_revision_id	int8	19
cms_hcpcs_codes	cms_hcpcs_code_revision_id	int8	19
claim_transaction_cms_modifiers	cms_modifier_id	int8	19
cms_hcpcs_codes	cms_modifier_id	int8	19	√		null
claims	current_balance	int8	19			0
claims	current_carrier_id	int8	19	√		null
claims	current_claim_status_id	int8	19	√		null
claims	current_claim_transaction_id	int8	19	√		null
people	current_employee_id	int8	19	√		null
card_cases	current_report_id	int8	19	√		null
rad_exams	current_report_id	int8	19	√		null
card_cases	current_status_id	int8	19
orders	current_status_id	int8	19	√		null
rad_exams	current_status_id	int8	19
radonc_cases	current_status_id	int8	19
card_case_details	delay_reason_id	int8	19	√		null
card_case_facts	delay_reason_id	int8	19	√		null
rad_exam_details	delay_reason_id	int8	19	√		null
rad_exam_facts	delay_reason_id	int8	19	√		null
view_external_cube_exam_facts	delay_reason_id	int8	19	√		null
employee_demos	demographic_type_id	int8	19
insurance_carrier_demographics	demographic_type_id	int8	19
patient_demos	demographic_type_id	int8	19
patient_demos_history	demographic_type_id	int8	19
employee_clinical_role_mappings	department_id	int8	19	√		null
orders	department_id	int8	19
services	department_id	int8	19
specialties	department_id	int8	19
rad_exam_facts	dicom_begin_epoch	int8	19	√		null
rad_exam_facts	dicom_end_epoch	int8	19	√		null
dicom_series	dicom_protocol_id	int8	19	√		null
dicom_series	dicom_study_id	int8	19	√		null
application_information	display_order	int8	19	√		null
employee_clinical_role_mappings	employee_id	int8	19
employee_demos	employee_id	int8	19
employee_specialty_mappings	employee_id	int8	19
identifiers	employee_id	int8	19	√		null
residents	employee_id	int8	19
card_case_facts	encounter_duration	int8	19	√		null
card_case_metrics	encounter_duration	int8	19	√		null
rad_exam_facts	encounter_duration	int8	19	√		null
rad_exam_metrics	encounter_duration	int8	19	√		null
card_case_facts	end_case_epoch	int8	19
card_case_personnel	end_case_id	int8	19	√		null
rad_exam_facts	end_exam_epoch	int8	19
rad_exam_facts	end_exam_first_image	int8	19	√		null
rad_exam_metrics	end_exam_first_image	int8	19	√		null
view_external_cube_exam_facts	end_exam_first_image	int8	19	√		null
rad_exam_personnel	end_exam_id	int8	19	√		null
rad_exam_facts	end_exam_last_image	int8	19	√		null
rad_exam_metrics	end_exam_last_image	int8	19	√		null
dicom_series	equipment_model_id	int8	19	√		null
rad_exam_facts	equipment_model_id	int8	19	√		null
rad_pacs_metadata	equipment_model_id	int8	19	√		null
dicom_series	equipment_serial_number_id	int8	19	√		null
rad_exam_facts	equipment_serial_number_id	int8	19	√		null
rad_pacs_metadata	equipment_serial_number_id	int8	19	√		null
patient_events	event_reason_id	int8	19	√		null
patient_events_history	event_reason_id	int8	19	√		null
view_external_cube_exam_facts	Exam Begin to Exam Complete TAT	int8	19	√		null
view_external_cube_exam_facts	Exam Begin to Scan Start TAT	int8	19	√		null
view_external_cube_exam_facts	Exam Complete to Final Read TAT	int8	19	√		null
view_external_cube_exam_facts	Exam Complete to Prelim Read TAT	int8	19	√		null
view_external_cube_exam_facts	Exam ID	int8	19	√		null
rad_exam_facts	exam_duration	int8	19	√		null
rad_exam_metrics	exam_duration	int8	19	√		null
rad_exam_metadata	exam_metadata_type_id	int8	19
orders	exam_priority_id	int8	19	√		null
rad_exam_facts	exam_priority_id	int8	19	√		null
rad_exams	exam_priority_id	int8	19	√		null
radonc_cases	exam_priority_id	int8	19	√		null
view_external_cube_exam_facts	exam_priority_id	int8	19	√		null
rad_exam_facts	exam_wait	int8	19	√		null
rad_exam_metrics	exam_wait	int8	19	√		null
view_external_cube_exam_facts	exam_wait	int8	19	√		null
card_case_metadata	external_system_id	int8	19
card_cases	external_system_id	int8	19
claims	external_system_id	int8	19
dicom_protocols	external_system_id	int8	19
dicom_series	external_system_id	int8	19	√		null
dicom_studies	external_system_id	int8	19
external_system_role_mappings	external_system_id	int8	19
external_system_statuses	external_system_id	int8	19
identifiers	external_system_id	int8	19
insurance_carriers	external_system_id	int8	19
order_metadata	external_system_id	int8	19
orders	external_system_id	int8	19
patient_mrns	external_system_id	int8	19
procedures	external_system_id	int8	19
provider_groups	external_system_id	int8	19
rad_exam_external_system_statuses	external_system_id	int8	19
rad_exam_metadata	external_system_id	int8	19
rad_exams	external_system_id	int8	19
rad_pacs_metadata	external_system_id	int8	19
radonc_cases	external_system_id	int8	19
reasons	external_system_id	int8	19
resources	external_system_id	int8	19
scheduling_task_groupings	external_system_id	int8	19
scheduling_tasks	external_system_id	int8	19
site_classes	external_system_id	int8	19
site_locations	external_system_id	int8	19
visits	external_system_id	int8	19
external_system_role_mappings	external_system_role_id	int8	19
patient_events	external_system_status_id	int8	19
patient_events_history	external_system_status_id	int8	19
rad_exam_external_system_statuses	external_system_status_id	int8	19
card_case_facts	final_report_epoch	int8	19	√		null
rad_exam_facts	final_report_epoch	int8	19	√		null
view_external_cube_exam_facts	First Image in PACS to Final Read TAT	int8	19	√		null
view_external_cube_exam_facts	First Image in PACS to Prelim Read TAT	int8	19	√		null
claims	first_claim_transaction_id	int8	19	√		null
card_cases	first_final_report_id	int8	19	√		null
rad_exams	first_final_report_id	int8	19	√		null
rad_exam_facts	first_image_final	int8	19	√		null
rad_exam_metrics	first_image_final	int8	19	√		null
view_external_cube_exam_facts	first_image_final	int8	19	√		null
rad_exam_facts	first_image_prelim	int8	19	√		null
rad_exam_metrics	first_image_prelim	int8	19	√		null
card_cases	first_prelim_report_id	int8	19	√		null
rad_exams	first_prelim_report_id	int8	19	√		null
card_case_facts	first_report_epoch	int8	19	√		null
rad_exam_facts	first_report_epoch	int8	19	√		null
card_cases	first_report_id	int8	19	√		null
rad_exams	first_report_id	int8	19	√		null
rad_exam_facts	first_report_turn_around	int8	19	√		null
rad_exam_metrics	first_report_turn_around	int8	19	√		null
view_external_cube_exam_facts	first_report_turn_around	int8	19	√		null
claim_transaction_diagnoses	icd_code_id	int8	19
visit_diagnoses	icd_code_id	int8	19
icd_codes	icd_code_revision_id	int8	19
card_case_facts	icu_recovery_duration	int8	19	√		null
card_case_metrics	icu_recovery_duration	int8	19	√		null
application_categories	id	bigserial	19		√	nextval('application_categories_id_seq'::regclass)
application_credentials	id	bigserial	19		√	nextval('application_credentials_id_seq'::regclass)
application_information	id	bigserial	19		√	nextval('application_information_id_seq'::regclass)
backend_statuses	id	bigserial	19		√	nextval('backend_statuses_id_seq'::regclass)
card_case_authorizations	id	bigserial	19		√	nextval('card_case_authorizations_id_seq'::regclass)
card_case_claim_transactions	id	bigserial	19		√	nextval('card_case_claim_transactions_id_seq'::regclass)
card_case_claims	id	bigserial	19		√	nextval('card_case_claims_id_seq'::regclass)
card_case_details	id	bigserial	19		√	nextval('card_case_details_id_seq'::regclass)
card_case_facts	id	bigserial	19		√	nextval('card_case_facts_id_seq'::regclass)
card_case_metadata	id	bigserial	19		√	nextval('card_case_metadata_id_seq'::regclass)
card_case_metrics	id	bigserial	19		√	nextval('card_case_metrics_id_seq'::regclass)
card_case_personnel	id	bigserial	19		√	nextval('card_case_personnel_id_seq'::regclass)
card_case_procedure_mappings	id	bigserial	19		√	nextval('card_case_procedure_mappings_id_seq'::regclass)
card_case_times	id	bigserial	19		√	nextval('card_case_times_id_seq'::regclass)
card_cases	id	bigserial	19		√	nextval('card_cases_id_seq'::regclass)
card_reports	id	bigserial	19		√	nextval('card_reports_id_seq'::regclass)
claim_transaction_cms_modifiers	id	bigserial	19		√	nextval('claim_transaction_cms_modifiers_id_seq'::regclass)
claim_transaction_diagnoses	id	bigserial	19		√	nextval('claim_transaction_diagnoses_id_seq'::regclass)
claim_transaction_facts	id	bigserial	19		√	nextval('claim_transaction_facts_id_seq'::regclass)
claim_transaction_types	id	bigserial	19		√	nextval('claim_transaction_types_id_seq'::regclass)
claim_transactions	id	bigserial	19		√	nextval('claim_transactions_id_seq'::regclass)
claims	id	bigserial	19		√	nextval('claims_id_seq'::regclass)
clinical_roles	id	bigserial	19		√	nextval('clinical_roles_id_seq'::regclass)
cms_facility_types	id	bigserial	19		√	nextval('cms_facility_types_id_seq'::regclass)
cms_gpci	id	bigserial	19		√	nextval('cms_gpci_id_seq'::regclass)
cms_hcpcs_code_revisions	id	bigserial	19		√	nextval('cms_hcpcs_code_revisions_id_seq'::regclass)
cms_hcpcs_codes	id	bigserial	19		√	nextval('cms_hcpcs_codes_id_seq'::regclass)
cms_modifiers	id	bigserial	19		√	nextval('cms_modifiers_id_seq'::regclass)
configuration_variables	id	bigserial	19		√	nextval('configuration_variables_id_seq'::regclass)
demographic_types	id	bigserial	19		√	nextval('demographic_types_id_seq'::regclass)
departments	id	bigserial	19		√	nextval('departments_id_seq'::regclass)
dicom_protocols	id	bigserial	19		√	nextval('dicom_protocols_id_seq'::regclass)
dicom_series	id	bigserial	19		√	nextval('dicom_studies_id_seq'::regclass)
dicom_studies	id	bigserial	19		√	nextval('dicom_studies_id_seq'::regclass)
employee_clinical_role_mappings	id	bigserial	19		√	nextval('employee_clinical_role_mappings_id_seq'::regclass)
employee_demos	id	bigserial	19		√	nextval('employee_demos_id_seq'::regclass)
employee_specialty_mappings	id	bigserial	19		√	nextval('employee_specialty_mappings_id_seq'::regclass)
employees	id	bigserial	19		√	nextval('employees_id_seq'::regclass)
equipment_models	id	bigserial	19		√	nextval('equipment_models_id_seq'::regclass)
equipment_serial_numbers	id	bigserial	19		√	nextval('equipment_serial_numbers_id_seq'::regclass)
exam_metadata_types	id	bigserial	19		√	nextval('exam_metadata_types_id_seq'::regclass)
exam_priorities	id	bigserial	19		√	nextval('exam_priorities_id_seq'::regclass)
external_system_role_mappings	id	bigserial	19		√	nextval('external_system_role_mappings_id_seq'::regclass)
external_system_roles	id	bigserial	19		√	nextval('external_system_roles_id_seq'::regclass)
external_system_statuses	id	bigserial	19		√	nextval('external_system_statuses_id_seq'::regclass)
external_systems	id	bigserial	19		√	nextval('external_systems_id_seq'::regclass)
icd_code_revisions	id	bigserial	19		√	nextval('icd_code_revisions_id_seq'::regclass)
icd_codes	id	bigserial	19		√	nextval('icd_codes_id_seq'::regclass)
identifier_types	id	bigserial	19		√	nextval('identifier_types_id_seq'::regclass)
identifiers	id	bigserial	19		√	nextval('identifiers_id_seq'::regclass)
insurance_carrier_demographics	id	bigserial	19		√	nextval('insurance_carrier_demographics_id_seq'::regclass)
insurance_carrier_plan_groupings	id	bigserial	19		√	nextval('insurance_carrier_plan_groupings_id_seq'::regclass)
insurance_carrier_plans	id	bigserial	19		√	nextval('insurance_carrier_plans_id_seq'::regclass)
insurance_carriers	id	bigserial	19		√	nextval('insurance_carriers_id_seq'::regclass)
insurance_policies	id	bigserial	19		√	nextval('insurance_policies_id_seq'::regclass)
job_metrics_logs	id	bigserial	19		√	nextval('job_metrics_logs_id_seq'::regclass)
locales	id	bigserial	19		√	nextval('locales_id_seq'::regclass)
manufacturers	id	bigserial	19		√	nextval('manufacturers_id_seq'::regclass)
metasite_associations	id	bigserial	19		√	nextval('metasite_associations_id_seq'::regclass)
metasites	id	bigserial	19		√	nextval('metasites_id_seq'::regclass)
modalities	id	bigserial	19		√	nextval('modalities_id_seq'::regclass)
order_metadata	id	bigserial	19		√	nextval('order_metadata_id_seq'::regclass)
order_procedure_mappings	id	bigserial	19		√	nextval('order_procedure_mappings_id_seq'::regclass)
ordering_departments	id	bigserial	19		√	nextval('ordering_departments_id_seq'::regclass)
orders	id	bigserial	19		√	nextval('orders_id_seq'::regclass)
patient_demos	id	bigserial	19		√	nextval('patient_demos_id_seq'::regclass)
patient_demos_history	id	bigserial	19		√	nextval('patient_demos_history_id_seq'::regclass)
patient_events	id	bigserial	19		√	nextval('patient_events_id_seq'::regclass)
patient_events_history	id	bigserial	19		√	nextval('patient_events_history_id_seq'::regclass)
patient_mrns	id	bigserial	19		√	nextval('patient_mrns_id_seq'::regclass)
patient_types	id	bigserial	19		√	nextval('patient_types_id_seq'::regclass)
patients	id	bigserial	19		√	nextval('patients_id_seq'::regclass)
people	id	bigserial	19		√	nextval('people_id_seq'::regclass)
procedure_hcpcs_mappings	id	bigserial	19		√	nextval('procedure_hcpcs_mappings_id_seq'::regclass)
procedure_modifiers	id	bigserial	19		√	nextval('procedure_modifiers_id_seq'::regclass)
procedures	id	bigserial	19		√	nextval('procedures_id_seq'::regclass)
provider_groups	id	bigserial	19		√	nextval('provider_groups_id_seq'::regclass)
rad_exam_authorizations	id	bigserial	19		√	nextval('rad_exam_authorizations_id_seq'::regclass)
rad_exam_claim_transactions	id	bigserial	19		√	nextval('rad_exam_claim_transactions_id_seq'::regclass)
rad_exam_claims	id	bigserial	19		√	nextval('rad_exam_claims_id_seq'::regclass)
rad_exam_departments	id	bigserial	19		√	nextval('rad_exam_departments_id_seq'::regclass)
rad_exam_details	id	bigserial	19		√	nextval('rad_exam_details_id_seq'::regclass)
rad_exam_external_system_statuses	id	bigserial	19		√	nextval('rad_exam_external_system_statuses_id_seq'::regclass)
rad_exam_facts	id	bigserial	19		√	nextval('rad_exam_facts_id_seq'::regclass)
rad_exam_metadata	id	bigserial	19		√	nextval('rad_exam_metadata_id_seq'::regclass)
rad_exam_metrics	id	bigserial	19		√	nextval('rad_exam_metrics_id_seq'::regclass)
rad_exam_personnel	id	bigserial	19		√	nextval('rad_exam_personnel_id_seq'::regclass)
rad_exam_times	id	bigserial	19		√	nextval('rad_exam_times_id_seq'::regclass)
rad_exams	id	bigserial	19		√	nextval('rad_exams_id_seq'::regclass)
rad_pacs_aets	id	bigserial	19		√	nextval('rad_pacs_aets_id_seq'::regclass)
rad_pacs_bodyparts	id	bigserial	19		√	nextval('rad_pacs_bodyparts_id_seq'::regclass)
rad_pacs_metadata	id	bigserial	19		√	nextval('rad_pacs_metadata_id_seq'::regclass)
rad_pacs_modalities	id	bigserial	19		√	nextval('rad_pacs_modalities_id_seq'::regclass)
rad_pacs_specialities	id	bigserial	19		√	nextval('rad_pacs_specialities_id_seq'::regclass)
rad_pacs_station_names	id	bigserial	19		√	nextval('rad_pacs_station_names_id_seq'::regclass)
rad_reports	id	bigserial	19		√	nextval('rad_reports_id_seq'::regclass)
radonc_case_authorizations	id	bigserial	19		√	nextval('radonc_case_authorizations_id_seq'::regclass)
radonc_case_claims	id	bigserial	19		√	nextval('radonc_case_claims_id_seq'::regclass)
radonc_cases	id	bigserial	19		√	nextval('radonc_cases_id_seq'::regclass)
reasons	id	bigserial	19		√	nextval('reasons_id_seq'::regclass)
relationship_types	id	bigserial	19		√	nextval('relationship_types_id_seq'::regclass)
residents	id	bigserial	19		√	nextval('residents_id_seq'::regclass)
resources	id	bigserial	19		√	nextval('resources_id_seq'::regclass)
scheduling_task_groupings	id	bigserial	19		√	nextval('scheduling_task_groupings_id_seq'::regclass)
scheduling_tasks	id	bigserial	19		√	nextval('scheduling_tasks_id_seq'::regclass)
services	id	bigserial	19		√	nextval('services_id_seq'::regclass)
site_classes	id	bigserial	19		√	nextval('site_classes_id_seq'::regclass)
site_locations	id	bigserial	19		√	nextval('site_locations_id_seq'::regclass)
site_sublocations	id	bigserial	19		√	nextval('site_sublocations_id_seq'::regclass)
sites	id	bigserial	19		√	nextval('sites_id_seq'::regclass)
software_versions	id	bigserial	19		√	nextval('software_versions_id_seq'::regclass)
specialties	id	bigserial	19		√	nextval('specialties_id_seq'::regclass)
universal_event_types	id	bigserial	19		√	nextval('universal_event_types_id_seq'::regclass)
visit_diagnoses	id	bigserial	19		√	nextval('visit_diagnoses_id_seq'::regclass)
visit_insurance_policies	id	bigserial	19		√	nextval('visit_insurance_policies_id_seq'::regclass)
visits	id	bigserial	19		√	nextval('visits_id_seq'::regclass)
identifiers	identifier_type_id	int8	19
rad_exam_facts	image_count	int8	19	√		null
rad_exam_metrics	image_count	int8	19	√		null
view_external_cube_exam_facts	image_count	int8	19	√		null
card_case_facts	in_lab_patient_prep_duration	int8	19	√		null
card_case_metrics	in_lab_patient_prep_duration	int8	19	√		null
card_case_facts	in_lab_post_procedure_duration	int8	19	√		null
card_case_metrics	in_lab_post_procedure_duration	int8	19	√		null
claim_transaction_facts	insurance_carrier_id	int8	19	√		null
insurance_carrier_demographics	insurance_carrier_id	int8	19
insurance_carrier_plans	insurance_carrier_id	int8	19
claim_transaction_facts	insurance_carrier_plan_grouping_id	int8	19	√		null
insurance_carrier_plans	insurance_carrier_plan_grouping_id	int8	19	√		null
claim_transaction_facts	insurance_carrier_plan_id	int8	19	√		null
insurance_policies	insurance_carrier_plan_id	int8	19	√		null
card_case_authorizations	insurance_policy_id	int8	19
claim_transaction_facts	insurance_policy_id	int8	19	√		null
claim_transactions	insurance_policy_id	int8	19	√		null
rad_exam_authorizations	insurance_policy_id	int8	19
radonc_case_authorizations	insurance_policy_id	int8	19
visit_insurance_policies	insurance_policy_id	int8	19
card_cases	last_final_report_id	int8	19	√		null
rad_exams	last_final_report_id	int8	19	√		null
rad_exam_facts	last_image_final	int8	19	√		null
rad_exam_metrics	last_image_final	int8	19	√		null
rad_exam_facts	last_image_prelim	int8	19	√		null
rad_exam_metrics	last_image_prelim	int8	19	√		null
view_external_cube_exam_facts	last_image_prelim	int8	19	√		null
card_cases	last_prelim_report_id	int8	19	√		null
rad_exams	last_prelim_report_id	int8	19	√		null
application_information	manufacturer_id	int8	19
dicom_series	manufacturer_id	int8	19	√		null
equipment_models	manufacturer_id	int8	19
rad_exam_facts	manufacturer_id	int8	19	√		null
rad_pacs_metadata	manufacturer_id	int8	19	√		null
orders	master_order_id	int8	19	√		null
external_systems	metasite_id	int8	19
metasite_associations	metasite_id	int8	19
card_case_facts	modality_id	int8	19	√		null
cms_hcpcs_codes	modality_id	int8	19	√		null
rad_exam_facts	modality_id	int8	19	√		null
resources	modality_id	int8	19	√		null
view_external_cube_exam_facts	modality_id	int8	19	√		null
card_case_personnel	nurse1_id	int8	19	√		null
card_case_personnel	nurse2_id	int8	19	√		null
card_case_personnel	nurse3_id	int8	19	√		null
patient_events	operator_employee_id	int8	19	√		null
patient_events_history	operator_employee_id	int8	19	√		null
view_external_cube_exam_facts	Order to Patient Arrived TAT	int8	19	√		null
view_external_cube_exam_facts	Order to Schedule TAT	int8	19	√		null
rad_exam_facts	order_begin_acquisition	int8	19	√		null
rad_exam_metrics	order_begin_acquisition	int8	19	√		null
view_external_cube_exam_facts	order_begin_acquisition	int8	19	√		null
card_case_facts	order_complete	int8	19	√		null
card_case_metrics	order_complete	int8	19	√		null
rad_exam_facts	order_complete	int8	19	√		null
rad_exam_metrics	order_complete	int8	19	√		null
view_external_cube_exam_facts	order_complete	int8	19	√		null
rad_exam_facts	order_end_acquisition	int8	19	√		null
rad_exam_metrics	order_end_acquisition	int8	19	√		null
view_external_cube_exam_facts	order_end_acquisition	int8	19	√		null
rad_exam_facts	order_first_final	int8	19	√		null
rad_exam_metrics	order_first_final	int8	19	√		null
view_external_cube_exam_facts	order_first_final	int8	19	√		null
rad_exam_facts	order_first_image	int8	19	√		null
rad_exam_metrics	order_first_image	int8	19	√		null
view_external_cube_exam_facts	order_first_image	int8	19	√		null
rad_exam_facts	order_first_prelim	int8	19	√		null
rad_exam_metrics	order_first_prelim	int8	19	√		null
view_external_cube_exam_facts	order_first_prelim	int8	19	√		null
rad_exam_facts	order_first_report	int8	19	√		null
rad_exam_metrics	order_first_report	int8	19	√		null
view_external_cube_exam_facts	order_first_report	int8	19	√		null
card_cases	order_id	int8	19	√		null
order_metadata	order_id	int8	19
order_procedure_mappings	order_id	int8	19
rad_exams	order_id	int8	19	√		null
radonc_cases	order_id	int8	19	√		null
rad_exam_facts	order_last_image	int8	19	√		null
rad_exam_metrics	order_last_image	int8	19	√		null
view_external_cube_exam_facts	order_last_image	int8	19	√		null
order_metadata	order_metadata_type_id	int8	19
orders	ordering_department_id	int8	19	√		null
rad_exam_facts	ordering_department_id	int8	19	√		null
claim_transaction_facts	ordering_employee_id	int8	19	√		null
claim_transactions	ordering_employee_id	int8	19	√		null
card_case_facts	ordering_id	int8	19	√		null
card_case_personnel	ordering_id	int8	19	√		null
rad_exam_personnel	ordering_id	int8	19	√		null
orders	ordering_provider_group_id	int8	19	√		null
rad_exam_facts	ordering_provider_group_id	int8	19	√		null
card_case_facts	ordering_provider_id	int8	19	√		null
orders	ordering_provider_id	int8	19	√		null
rad_exam_facts	ordering_provider_id	int8	19	√		null
view_external_cube_exam_facts	ordering_provider_id	int8	19	√		null
claims	original_charge	int8	19			0
view_external_cube_exam_facts	Patient Arrived to Exam Begin TAT	int8	19	√		null
view_external_cube_exam_facts	Patient Arrived to Exam Complete TAT	int8	19	√		null
view_external_cube_exam_facts	Patient Arrived to Scan Start TAT	int8	19	√		null
card_case_facts	patient_id	int8	19
patient_mrns	patient_id	int8	19
rad_exam_facts	patient_id	int8	19
view_external_cube_exam_facts	patient_id	int8	19	√		null
card_case_facts	patient_in_room_duration	int8	19	√		null
card_case_metrics	patient_in_room_duration	int8	19	√		null
card_case_facts	patient_mrn_id	int8	19
card_cases	patient_mrn_id	int8	19
claims	patient_mrn_id	int8	19
orders	patient_mrn_id	int8	19
patient_demos	patient_mrn_id	int8	19
patient_demos_history	patient_mrn_id	int8	19
patient_events	patient_mrn_id	int8	19
patient_events_history	patient_mrn_id	int8	19
rad_exam_facts	patient_mrn_id	int8	19
rad_exams	patient_mrn_id	int8	19
radonc_cases	patient_mrn_id	int8	19
view_external_cube_exam_facts	patient_mrn_id	int8	19	√		null
visits	patient_mrn_id	int8	19
site_classes	patient_type_id	int8	19
rad_exam_facts	payments	int8	19	√		null
view_external_cube_exam_facts	payments	int8	19	√		null
claim_transaction_facts	performing_employee_id	int8	19	√		null
claim_transactions	performing_employee_id	int8	19	√		null
card_case_facts	performing_id	int8	19	√		null
card_case_personnel	performing_id	int8	19	√		null
rad_exam_personnel	performing_id	int8	19	√		null
card_case_facts	performing_specialty_id	int8	19	√		null
employees	person_id	int8	19
cms_facility_types	pos_code	int8	19
patient_events	postevent_site_sublocation_id	int8	19	√		null
patient_events_history	postevent_site_sublocation_id	int8	19	√		null
claim_transaction_facts	posting_employee_id	int8	19	√		null
claim_transactions	posting_employee_id	int8	19	√		null
procedures	practice_fee	int8	19			0
card_case_facts	pre_procedure_duration	int8	19	√		null
card_case_metrics	pre_procedure_duration	int8	19	√		null
view_external_cube_exam_facts	Prelim Read to Final Read TAT	int8	19	√		null
card_case_facts	prelim_report_epoch	int8	19	√		null
rad_exam_facts	prelim_report_epoch	int8	19	√		null
rad_exam_facts	prelim_turn_around	int8	19	√		null
rad_exam_metrics	prelim_turn_around	int8	19	√		null
card_case_facts	prep_duration	int8	19	√		null
card_case_metrics	prep_duration	int8	19	√		null
card_case_details	previous_procedure_id	int8	19	√		null
rad_exam_details	previous_procedure_id	int8	19	√		null
procedures	pro_fee	int8	19			0
card_case_details	procedure_change_reason_id	int8	19	√		null
rad_exam_details	procedure_change_reason_id	int8	19	√		null
card_case_procedure_mappings	procedure_id	int8	19
dicom_studies	procedure_id	int8	19	√		null
order_procedure_mappings	procedure_id	int8	19
procedure_hcpcs_mappings	procedure_id	int8	19
rad_exam_facts	procedure_id	int8	19	√		null
rad_exams	procedure_id	int8	19	√		null
radonc_cases	procedure_id	int8	19	√		null
view_external_cube_exam_facts	procedure_id	int8	19	√		null
card_case_facts	procedure_ids	_int8	19	√		null
card_case_details	procedure_modifier_id	int8	19	√		null
rad_exam_details	procedure_modifier_id	int8	19	√		null
rad_exam_facts	procedure_specialty_id	int8	19	√		null
view_external_cube_exam_facts	procedure_specialty_id	int8	19	√		null
card_case_facts	procedure_specialty_ids	_int8	19	√		null
card_case_facts	procedure_wait	int8	19	√		null
card_case_metrics	procedure_wait	int8	19	√		null
rad_reports	rad1_id	int8	19	√		null
rad_reports	rad2_id	int8	19	√		null
rad_reports	rad3_id	int8	19	√		null
rad_reports	rad4_id	int8	19	√		null
rad_exam_facts	rad_exam_department_id	int8	19	√		null
rad_exams	rad_exam_department_id	int8	19	√		null
scheduling_task_groupings	rad_exam_department_id	int8	19	√		null
view_external_cube_exam_facts	rad_exam_department_id	int8	19	√		null
dicom_studies	rad_exam_id	int8	19	√		null
rad_exam_authorizations	rad_exam_id	int8	19
rad_exam_claim_transactions	rad_exam_id	int8	19
rad_exam_claims	rad_exam_id	int8	19
rad_exam_details	rad_exam_id	int8	19
rad_exam_external_system_statuses	rad_exam_id	int8	19
rad_exam_facts	rad_exam_id	int8	19
rad_exam_metadata	rad_exam_id	int8	19
rad_exam_metrics	rad_exam_id	int8	19
rad_exam_personnel	rad_exam_id	int8	19
rad_exam_times	rad_exam_id	int8	19
rad_pacs_metadata	rad_exam_id	int8	19
rad_reports	rad_exam_id	int8	19	√		null
dicom_series	rad_pacs_aet_id	int8	19	√		null
rad_exam_facts	rad_pacs_aet_id	int8	19	√		null
rad_pacs_metadata	rad_pacs_aet_id	int8	19	√		null
resources	rad_pacs_aet_id	int8	19	√		null
view_external_cube_exam_facts	rad_pacs_aet_id	int8	19	√		null
dicom_series	rad_pacs_bodypart_id	int8	19	√		null
rad_exam_facts	rad_pacs_bodypart_id	int8	19	√		null
rad_pacs_metadata	rad_pacs_bodypart_id	int8	19	√		null
view_external_cube_exam_facts	rad_pacs_bodypart_id	int8	19	√		null
dicom_protocols	rad_pacs_modality_id	int8	19
dicom_series	rad_pacs_modality_id	int8	19	√		null
rad_exam_facts	rad_pacs_modality_id	int8	19	√		null
rad_pacs_metadata	rad_pacs_modality_id	int8	19	√		null
view_external_cube_exam_facts	rad_pacs_modality_id	int8	19	√		null
rad_pacs_metadata	rad_pacs_speciality_id	int8	19	√		null
view_external_cube_exam_facts	rad_pacs_speciality_id	int8	19	√		null
rad_pacs_metadata	rad_pacs_station_name_id	int8	19	√		null
rad_exam_facts	radiologist_id	int8	19	√		null
view_external_cube_exam_facts	radiologist_id	int8	19	√		null
rad_exam_facts	radiologist_specialty_id	int8	19	√		null
radonc_case_authorizations	radonc_case_id	int8	19
radonc_case_claims	radonc_case_id	int8	19
card_case_facts	recovery_duration	int8	19	√		null
card_case_metrics	recovery_duration	int8	19	√		null
card_case_facts	reg_duration	int8	19	√		null
card_case_metrics	reg_duration	int8	19	√		null
rad_exam_facts	reg_duration	int8	19	√		null
rad_exam_metrics	reg_duration	int8	19	√		null
view_external_cube_exam_facts	reg_duration	int8	19	√		null
card_case_facts	reg_wait	int8	19	√		null
card_case_metrics	reg_wait	int8	19	√		null
rad_exam_facts	reg_wait	int8	19	√		null
rad_exam_metrics	reg_wait	int8	19	√		null
view_external_cube_exam_facts	reg_wait	int8	19	√		null
insurance_policies	relationship_type_id	int8	19
card_reports	report_status_id	int8	19	√		null
rad_reports	report_status_id	int8	19	√		null
card_case_facts	resident_id	int8	19	√		null
rad_exam_facts	resident_id	int8	19	√		null
view_external_cube_exam_facts	resident_id	int8	19	√		null
card_case_facts	resource_id	int8	19	√		null
card_cases	resource_id	int8	19	√		null
orders	resource_id	int8	19	√		null
rad_exam_facts	resource_id	int8	19	√		null
rad_exams	resource_id	int8	19	√		null
view_external_cube_exam_facts	resource_id	int8	19	√		null
view_external_cube_exam_facts	Scan End to Final Read TAT	int8	19	√		null
view_external_cube_exam_facts	Scan End to PACS TAT	int8	19	√		null
view_external_cube_exam_facts	Scan Start to Scan End TAT	int8	19	√		null
view_external_cube_exam_facts	Schedule to Patient Arrived TAT	int8	19	√		null
rad_exam_facts	schedule_first_final	int8	19	√		null
rad_exam_metrics	schedule_first_final	int8	19	√		null
view_external_cube_exam_facts	schedule_first_final	int8	19	√		null
rad_exam_facts	schedule_first_prelim	int8	19	√		null
rad_exam_metrics	schedule_first_prelim	int8	19	√		null
view_external_cube_exam_facts	schedule_first_prelim	int8	19	√		null
rad_exam_facts	schedule_first_report	int8	19	√		null
rad_exam_metrics	schedule_first_report	int8	19	√		null
view_external_cube_exam_facts	schedule_first_report	int8	19	√		null
card_case_facts	scheduler_id	int8	19	√		null
card_case_personnel	scheduler_id	int8	19	√		null
rad_exam_facts	scheduler_id	int8	19	√		null
rad_exam_personnel	scheduler_id	int8	19	√		null
view_external_cube_exam_facts	scheduler_id	int8	19	√		null
rad_exam_facts	scheduling_rad_exam_department_id	int8	19	√		null
rad_exam_facts	scheduling_service_id	int8	19	√		null
rad_exam_facts	scheduling_site_id	int8	19	√		null
rad_exam_facts	scheduling_specialty_id	int8	19	√		null
scheduling_tasks	scheduling_task_grouping_id	int8	19
rad_exam_facts	send_delay	int8	19	√		null
rad_exam_metrics	send_delay	int8	19	√		null
view_external_cube_exam_facts	send_delay	int8	19	√		null
rad_exam_facts	send_duration	int8	19	√		null
rad_exam_metrics	send_duration	int8	19	√		null
view_external_cube_exam_facts	send_duration	int8	19	√		null
rad_exam_facts	series_count	int8	19	√		null
rad_exam_metrics	series_count	int8	19	√		null
view_external_cube_exam_facts	series_count	int8	19	√		null
card_case_facts	service_id	int8	19	√		null
card_cases	service_id	int8	19	√		null
rad_exam_facts	service_id	int8	19	√		null
rad_exams	service_id	int8	19	√		null
scheduling_task_groupings	service_id	int8	19	√		null
view_external_cube_exam_facts	service_id	int8	19	√		null
claim_transaction_facts	service_performed_epoch	int8	19
card_case_personnel	signin_id	int8	19	√		null
rad_exam_personnel	signin_id	int8	19	√		null
card_case_facts	site_class_id	int8	19	√		null
card_cases	site_class_id	int8	19	√		null
claim_transaction_facts	site_class_id	int8	19	√		null
claims	site_class_id	int8	19	√		null
orders	site_class_id	int8	19	√		null
patient_events	site_class_id	int8	19	√		null
patient_events_history	site_class_id	int8	19	√		null
rad_exam_facts	site_class_id	int8	19	√		null
rad_exams	site_class_id	int8	19	√		null
radonc_cases	site_class_id	int8	19	√		null
view_external_cube_exam_facts	site_class_id	int8	19	√		null
card_case_facts	site_id	int8	19	√		null
card_cases	site_id	int8	19
claim_transaction_facts	site_id	int8	19	√		null
claims	site_id	int8	19
metasite_associations	site_id	int8	19
orders	site_id	int8	19
rad_exam_departments	site_id	int8	19
rad_exam_facts	site_id	int8	19	√		null
rad_exams	site_id	int8	19
radonc_cases	site_id	int8	19
resources	site_id	int8	19
scheduling_task_groupings	site_id	int8	19	√		null
services	site_id	int8	19
site_classes	site_id	int8	19
site_locations	site_id	int8	19	√		null
view_external_cube_exam_facts	site_id	int8	19	√		null
visits	site_id	int8	19	√		null
rad_exam_facts	site_location_id	int8	19	√		null
site_sublocations	site_location_id	int8	19
view_external_cube_exam_facts	site_location_id	int8	19	√		null
card_cases	site_sublocation_id	int8	19	√		null
rad_exams	site_sublocation_id	int8	19	√		null
radonc_cases	site_sublocation_id	int8	19	√		null
dicom_series	software_version_id	int8	19	√		null
rad_pacs_metadata	software_version_id	int8	19	√		null
employee_specialty_mappings	specialty_id	int8	19
procedures	specialty_id	int8	19	√		null
scheduling_task_groupings	specialty_id	int8	19	√		null
scheduling_tasks	task_entity_id	int8	19	√		null
procedures	tech_fee	int8	19			0
card_case_facts	technologist_id	int8	19	√		null
card_case_personnel	technologist_id	int8	19	√		null
rad_exam_facts	technologist_id	int8	19	√		null
rad_exam_personnel	technologist_id	int8	19	√		null
view_external_cube_exam_facts	technologist_id	int8	19	√		null
card_case_facts	total_care_time	int8	19	√		null
card_case_metrics	total_care_time	int8	19	√		null
card_case_facts	total_wait	int8	19	√		null
card_case_metrics	total_wait	int8	19	√		null
rad_exam_facts	total_wait	int8	19	√		null
rad_exam_metrics	total_wait	int8	19	√		null
claim_transaction_facts	transaction_amount	int8	19	√		null
claim_transactions	transaction_amount	int8	19
claim_transaction_facts	transaction_post_epoch	int8	19
card_reports	transcriptionist_id	int8	19	√		null
rad_reports	transcriptionist_id	int8	19	√		null
rad_exam_facts	transport	int8	19	√		null
rad_exam_metrics	transport	int8	19	√		null
view_external_cube_exam_facts	transport	int8	19	√		null
card_case_facts	turn_around	int8	19	√		null
card_case_metrics	turn_around	int8	19	√		null
rad_exam_facts	turn_around	int8	19	√		null
rad_exam_metrics	turn_around	int8	19	√		null
claim_transaction_facts	universal_event_type_id	int8	19	√		null
external_system_statuses	universal_event_type_id	int8	19	√		null
card_cases	visit_id	int8	19	√		null
claims	visit_id	int8	19	√		null
orders	visit_id	int8	19	√		null
patient_demos	visit_id	int8	19	√		null
patient_demos_history	visit_id	int8	19	√		null
patient_events	visit_id	int8	19	√		null
patient_events_history	visit_id	int8	19	√		null
rad_exams	visit_id	int8	19	√		null
radonc_cases	visit_id	int8	19	√		null
visit_diagnoses	visit_id	int8	19
visit_insurance_policies	visit_id	int8	19
card_case_facts	wait_to_pre_procedure	int8	19	√		null
card_case_metrics	wait_to_pre_procedure	int8	19	√		null
card_case_facts	wheels_in_epoch	int8	19	√		null
card_case_facts	wheels_out_epoch	int8	19	√		null
card_case_times	anesthesia_complete	timestamptz	35,6	√		null
card_case_times	anesthesiologist_arrival	timestamptz	35,6	√		null
card_case_times	appointment	timestamptz	35,6	√		null
orders	appointment	timestamptz	35,6	√		null
rad_exam_times	appointment	timestamptz	35,6	√		null
view_external_cube_exam_facts	Appointment Date	timestamptz	35,6	√		null
view_external_cube_exam_facts	Begin Exam Event Time	timestamptz	35,6	√		null
view_external_cube_exam_facts	Begin Registration Date	timestamptz	35,6	√		null
card_case_times	begin_case	timestamptz	35,6	√		null
card_case_times	begin_case_event	timestamptz	35,6	√		null
rad_exam_times	begin_exam	timestamptz	35,6	√		null
rad_exam_times	begin_exam_event	timestamptz	35,6	√		null
card_case_times	begin_reg	timestamptz	35,6	√		null
rad_exam_times	begin_reg	timestamptz	35,6	√		null
card_case_times	cancelled	timestamptz	35,6	√		null
rad_exam_times	cancelled	timestamptz	35,6	√		null
view_external_cube_exam_facts	Cancelled Time	timestamptz	35,6	√		null
claims	charge_post	timestamptz	35,6	√		null
view_external_cube_exam_facts	Check In Date	timestamptz	35,6	√		null
card_case_times	check_in	timestamptz	35,6	√		null
rad_exam_times	check_in	timestamptz	35,6	√		null
claims	claim_create	timestamptz	35,6	√		null
rad_pacs_metadata	dicom_begin	timestamptz	35,6	√		null
view_external_cube_exam_facts	dicom_begin	timestamptz	35,6	√		null
rad_pacs_metadata	dicom_end	timestamptz	35,6	√		null
view_external_cube_exam_facts	dicom_end	timestamptz	35,6	√		null
view_external_cube_exam_facts	End Exam Event Time	timestamptz	35,6	√		null
card_case_times	end_case	timestamptz	35,6	√		null
card_case_times	end_case_event	timestamptz	35,6	√		null
rad_exam_times	end_exam	timestamptz	35,6	√		null
rad_exam_times	end_exam_event	timestamptz	35,6	√		null
patient_events	event_time	timestamptz	35,6
patient_events_history	event_time	timestamptz	35,6
view_external_cube_exam_facts	Exam Complete Time	timestamptz	35,6	√		null
view_external_cube_exam_facts	Exam Start Time	timestamptz	35,6	√		null
view_external_cube_exam_facts	exam_date	timestamptz	35,6	√		null
view_external_cube_exam_facts	Final Read Time	timestamptz	35,6	√		null
view_external_cube_exam_facts	First Image in PACS Time	timestamptz	35,6	√		null
view_external_cube_exam_facts	First Read Time	timestamptz	35,6	√		null
rad_pacs_metadata	first_image	timestamptz	35,6	√		null
view_external_cube_exam_facts	first_image	timestamptz	35,6	√		null
application_information	installed_at	timestamptz	35,6			now()
rad_pacs_metadata	last_image	timestamptz	35,6	√		null
view_external_cube_exam_facts	last_image	timestamptz	35,6	√		null
view_external_cube_exam_facts	Order Placed Date	timestamptz	35,6	√		null
card_case_times	order_arrival	timestamptz	35,6	√		null
orders	order_arrival	timestamptz	35,6	√		null
rad_exam_times	order_arrival	timestamptz	35,6	√		null
rad_exam_times	pacs_read_time	timestamptz	35,6	√		null
view_external_cube_exam_facts	Patient Arrival Time	timestamptz	35,6	√		null
card_case_times	physician_arrival	timestamptz	35,6	√		null
card_case_times	physician_notified	timestamptz	35,6	√		null
card_case_times	post_procedure_arrival	timestamptz	35,6	√		null
card_case_times	post_procedure_departure	timestamptz	35,6	√		null
card_case_times	post_procedure_icu_arrival	timestamptz	35,6	√		null
card_case_times	post_procedure_icu_departure	timestamptz	35,6	√		null
card_case_times	pre_procedure_arrival	timestamptz	35,6	√		null
card_case_times	pre_procedure_departure	timestamptz	35,6	√		null
view_external_cube_exam_facts	Prelim Read Time	timestamptz	35,6	√		null
card_case_times	ready_for_anesthesia	timestamptz	35,6	√		null
card_case_times	ready_for_procedure	timestamptz	35,6	√		null
card_reports	report_event	timestamptz	35,6	√		null
rad_reports	report_event	timestamptz	35,6	√		null
card_case_times	reschedule_event	timestamptz	35,6	√		null
rad_exam_times	reschedule_event	timestamptz	35,6	√		null
view_external_cube_exam_facts	Rescheduled Date	timestamptz	35,6	√		null
backend_statuses	run_start	timestamptz	35,6			now()
job_metrics_logs	run_start	timestamptz	35,6			now()
view_external_cube_exam_facts	Scan End Time	timestamptz	35,6	√		null
view_external_cube_exam_facts	Scan Start Time	timestamptz	35,6	√		null
card_case_times	schedule_event	timestamptz	35,6	√		null
rad_exam_times	schedule_event	timestamptz	35,6	√		null
view_external_cube_exam_facts	Scheduled Date	timestamptz	35,6	√		null
dicom_series	series_begin	timestamptz	35,6	√		null
dicom_series	series_end	timestamptz	35,6	√		null
claim_transactions	service_performed	timestamptz	35,6
card_case_times	sign_in	timestamptz	35,6	√		null
rad_exam_times	sign_in	timestamptz	35,6	√		null
dicom_studies	study_begin	timestamptz	35,6	√		null
dicom_studies	study_end	timestamptz	35,6	√		null
scheduling_tasks	task_start	timestamptz	35,6			now()
scheduling_tasks	task_stop	timestamptz	35,6			now()
claim_transactions	transaction_post	timestamptz	35,6
application_categories	updated_at	timestamptz	35,6			now()
application_credentials	updated_at	timestamptz	35,6			now()
application_information	updated_at	timestamptz	35,6			now()
backend_statuses	updated_at	timestamptz	35,6			now()
card_case_authorizations	updated_at	timestamptz	35,6			now()
card_case_claim_transactions	updated_at	timestamptz	35,6			now()
card_case_claims	updated_at	timestamptz	35,6			now()
card_case_details	updated_at	timestamptz	35,6			now()
card_case_facts	updated_at	timestamptz	35,6			now()
card_case_metadata	updated_at	timestamptz	35,6			now()
card_case_metrics	updated_at	timestamptz	35,6			now()
card_case_personnel	updated_at	timestamptz	35,6			now()
card_case_procedure_mappings	updated_at	timestamptz	35,6			now()
card_case_times	updated_at	timestamptz	35,6			now()
card_cases	updated_at	timestamptz	35,6			now()
card_reports	updated_at	timestamptz	35,6			now()
claim_transaction_cms_modifiers	updated_at	timestamptz	35,6			now()
claim_transaction_diagnoses	updated_at	timestamptz	35,6			now()
claim_transaction_facts	updated_at	timestamptz	35,6			now()
claim_transaction_types	updated_at	timestamptz	35,6			now()
claim_transactions	updated_at	timestamptz	35,6			now()
claims	updated_at	timestamptz	35,6			now()
clinical_roles	updated_at	timestamptz	35,6			now()
cms_facility_types	updated_at	timestamptz	35,6			now()
cms_gpci	updated_at	timestamptz	35,6			now()
cms_hcpcs_code_revisions	updated_at	timestamptz	35,6			now()
cms_hcpcs_codes	updated_at	timestamptz	35,6			now()
cms_modifiers	updated_at	timestamptz	35,6			now()
configuration_variables	updated_at	timestamptz	35,6			now()
demographic_types	updated_at	timestamptz	35,6			now()
departments	updated_at	timestamptz	35,6			now()
dicom_protocols	updated_at	timestamptz	35,6			now()
dicom_series	updated_at	timestamptz	35,6			now()
dicom_studies	updated_at	timestamptz	35,6			now()
employee_clinical_role_mappings	updated_at	timestamptz	35,6			now()
employee_demos	updated_at	timestamptz	35,6			now()
employee_specialty_mappings	updated_at	timestamptz	35,6			now()
employees	updated_at	timestamptz	35,6			now()
equipment_models	updated_at	timestamptz	35,6			now()
equipment_serial_numbers	updated_at	timestamptz	35,6			now()
exam_metadata_types	updated_at	timestamptz	35,6			now()
exam_priorities	updated_at	timestamptz	35,6			now()
external_system_role_mappings	updated_at	timestamptz	35,6			now()
external_system_roles	updated_at	timestamptz	35,6			now()
external_system_statuses	updated_at	timestamptz	35,6			now()
external_systems	updated_at	timestamptz	35,6			now()
icd_code_revisions	updated_at	timestamptz	35,6			now()
icd_codes	updated_at	timestamptz	35,6			now()
identifier_types	updated_at	timestamptz	35,6			now()
identifiers	updated_at	timestamptz	35,6			now()
insurance_carrier_demographics	updated_at	timestamptz	35,6			now()
insurance_carrier_plan_groupings	updated_at	timestamptz	35,6			now()
insurance_carrier_plans	updated_at	timestamptz	35,6			now()
insurance_carriers	updated_at	timestamptz	35,6			now()
insurance_policies	updated_at	timestamptz	35,6			now()
job_metrics_logs	updated_at	timestamptz	35,6			now()
locales	updated_at	timestamptz	35,6			now()
manufacturers	updated_at	timestamptz	35,6			now()
metasite_associations	updated_at	timestamptz	35,6			now()
metasites	updated_at	timestamptz	35,6			now()
modalities	updated_at	timestamptz	35,6			now()
order_metadata	updated_at	timestamptz	35,6			now()
order_procedure_mappings	updated_at	timestamptz	35,6			now()
ordering_departments	updated_at	timestamptz	35,6			now()
orders	updated_at	timestamptz	35,6			now()
patient_demos	updated_at	timestamptz	35,6			now()
patient_demos_history	updated_at	timestamptz	35,6			now()
patient_events	updated_at	timestamptz	35,6			now()
patient_events_history	updated_at	timestamptz	35,6			now()
patient_mrns	updated_at	timestamptz	35,6			now()
patient_types	updated_at	timestamptz	35,6			now()
patients	updated_at	timestamptz	35,6			now()
people	updated_at	timestamptz	35,6			now()
procedure_hcpcs_mappings	updated_at	timestamptz	35,6			now()
procedure_modifiers	updated_at	timestamptz	35,6			now()
procedures	updated_at	timestamptz	35,6			now()
provider_groups	updated_at	timestamptz	35,6			now()
rad_exam_authorizations	updated_at	timestamptz	35,6			now()
rad_exam_claim_transactions	updated_at	timestamptz	35,6			now()
rad_exam_claims	updated_at	timestamptz	35,6			now()
rad_exam_departments	updated_at	timestamptz	35,6			now()
rad_exam_details	updated_at	timestamptz	35,6			now()
rad_exam_external_system_statuses	updated_at	timestamptz	35,6			now()
rad_exam_facts	updated_at	timestamptz	35,6			now()
rad_exam_metadata	updated_at	timestamptz	35,6			now()
rad_exam_metrics	updated_at	timestamptz	35,6			now()
rad_exam_personnel	updated_at	timestamptz	35,6			now()
rad_exam_times	updated_at	timestamptz	35,6			now()
rad_exams	updated_at	timestamptz	35,6			now()
rad_pacs_aets	updated_at	timestamptz	35,6			now()
rad_pacs_bodyparts	updated_at	timestamptz	35,6			now()
rad_pacs_metadata	updated_at	timestamptz	35,6			now()
rad_pacs_modalities	updated_at	timestamptz	35,6			now()
rad_pacs_specialities	updated_at	timestamptz	35,6			now()
rad_pacs_station_names	updated_at	timestamptz	35,6			now()
rad_reports	updated_at	timestamptz	35,6			now()
radonc_case_authorizations	updated_at	timestamptz	35,6			now()
radonc_case_claims	updated_at	timestamptz	35,6			now()
radonc_cases	updated_at	timestamptz	35,6			now()
reasons	updated_at	timestamptz	35,6			now()
relationship_types	updated_at	timestamptz	35,6			now()
residents	updated_at	timestamptz	35,6			now()
resources	updated_at	timestamptz	35,6			now()
scheduling_task_groupings	updated_at	timestamptz	35,6			now()
scheduling_tasks	updated_at	timestamptz	35,6			now()
services	updated_at	timestamptz	35,6			now()
site_classes	updated_at	timestamptz	35,6			now()
site_locations	updated_at	timestamptz	35,6			now()
site_sublocations	updated_at	timestamptz	35,6			now()
sites	updated_at	timestamptz	35,6			now()
software_versions	updated_at	timestamptz	35,6			now()
specialties	updated_at	timestamptz	35,6			now()
universal_event_types	updated_at	timestamptz	35,6			now()
view_external_cube_exam_facts	updated_at	timestamptz	35,6	√		null
visit_diagnoses	updated_at	timestamptz	35,6			now()
visit_insurance_policies	updated_at	timestamptz	35,6			now()
visits	updated_at	timestamptz	35,6			now()
card_case_times	wheels_in	timestamptz	35,6	√		null
card_case_times	wheels_out	timestamptz	35,6	√		null
claims	zero_balance	timestamptz	35,6	√		null
job_metrics_logs	run_duration	interval	49,6
card_cases	accession	text	2147483647
dicom_studies	accession	text	2147483647	√		null
rad_exams	accession	text	2147483647
view_external_cube_exam_facts	Accession Number	text	2147483647	√		null
rad_pacs_aets	ae_title	text	2147483647
view_external_cube_exam_facts	ae_title	text	2147483647	√		null
application_information	application_name	text	2147483647
application_information	application_path	text	2147483647
card_case_authorizations	auth_number	text	2147483647
claim_transactions	auth_number	text	2147483647	√		null
rad_exam_authorizations	auth_number	text	2147483647
radonc_case_authorizations	auth_number	text	2147483647
site_sublocations	bed	text	2147483647	√		null
card_reports	body_fts	tsvector	2147483647	√		null
rad_reports	body_fts	tsvector	2147483647	√		null
rad_pacs_bodyparts	bodypart	text	2147483647
view_external_cube_exam_facts	bodypart	text	2147483647	√		null
cms_gpci	carrier	text	2147483647
insurance_carriers	carrier	text	2147483647
radonc_cases	case_number	text	2147483647
application_categories	category_name	text	2147483647
claims	claim_number	text	2147483647
clinical_roles	clinical_role	text	2147483647
icd_codes	code	text	2147483647
procedures	code	text	2147483647
backend_statuses	command	text	2147483647
claim_transactions	comments	text	2147483647	√		null
configuration_variables	configuration_key	text	2147483647
configuration_variables	configuration_value	text	2147483647
view_external_cube_exam_facts	delay_reason	text	2147483647	√		null
employee_demos	demographic	text	2147483647
insurance_carrier_demographics	demographic	text	2147483647
patient_demos	demographic	text	2147483647
patient_demos_history	demographic	text	2147483647
demographic_types	demographic_type	text	2147483647
departments	department	text	2147483647
ordering_departments	department	text	2147483647
rad_exam_departments	department	text	2147483647
view_external_cube_exam_facts	department	text	2147483647	√		null
ordering_departments	department_name	text	2147483647	√		null
view_external_cube_exam_facts	department_name	text	2147483647	√		null
application_categories	description	text	2147483647	√		null
application_information	description	text	2147483647	√		null
clinical_roles	description	text	2147483647	√		null
cms_hcpcs_codes	description	text	2147483647	√		null
external_system_roles	description	text	2147483647	√		null
icd_codes	description	text	2147483647	√		null
procedures	description	text	2147483647	√		null
rad_exam_departments	description	text	2147483647	√		null
services	description	text	2147483647	√		null
universal_event_types	description	text	2147483647	√		null
card_case_details	diagnosis	text	2147483647	√		null
rad_exam_details	diagnosis	text	2147483647	√		null
dicom_series	dicom_instances	jsonb	2147483647			'{}'::jsonb
application_information	display_name	text	2147483647
locales	display_name	text	2147483647
insurance_policies	employer_name	text	2147483647	√		null
universal_event_types	event_type	text	2147483647
view_external_cube_exam_facts	exam_status	text	2147483647	√		null
external_systems	external_system	text	2147483647
cms_facility_types	facility_type	text	2147483647
job_metrics_logs	frequency	text	2147483647	√		null
patients	gender	text	2147483647	√		null
provider_groups	group_name	text	2147483647	√		null
view_external_cube_exam_facts	group_name	text	2147483647	√		null
insurance_policies	group_number	text	2147483647	√		null
insurance_carrier_plan_groupings	grouping_name	text	2147483647
cms_hcpcs_codes	hcpcs	text	2147483647
view_external_cube_exam_facts	HL7 Modality	text	2147483647	√		null
application_credentials	hmac_secret_key	text	2147483647
backend_statuses	hostname	text	2147483647
job_metrics_logs	hostname	text	2147483647
icd_code_revisions	icd_code_revision	text	2147483647
icd_code_revisions	icd_code_version	text	2147483647
application_categories	icon	text	2147483647	√		null
application_information	icon	text	2147483647	√		null
identifiers	identifier	text	2147483647	√		null
external_systems	identifier_padding_rules	text	2147483647	√		null
identifier_types	identifier_type	text	2147483647	√		null
card_reports	impression_fts	tsvector	2147483647	√		null
rad_reports	impression_fts	tsvector	2147483647	√		null
application_information	in_progress_icon	text	2147483647	√		null
external_systems	integration_definition	text	2147483647	√		null
job_metrics_logs	job_description	text	2147483647
job_metrics_logs	job_name	text	2147483647
dicom_series	laterality	text	2147483647	√		null
cms_gpci	locality	text	2147483647
cms_gpci	locality_name	text	2147483647
site_locations	location	text	2147483647
manufacturers	manufacturer	text	2147483647
view_external_cube_exam_facts	manufacturer	text	2147483647	√		null
card_case_metadata	metadata	text	2147483647
order_metadata	metadata	text	2147483647
rad_exam_metadata	metadata	text	2147483647
exam_metadata_types	metadata_type	text	2147483647
metasites	metasite	text	2147483647
modalities	modality	text	2147483647
rad_pacs_modalities	modality	text	2147483647
view_external_cube_exam_facts	modality	text	2147483647	√		null
equipment_models	model	text	2147483647
cms_modifiers	modifier	text	2147483647
patient_mrns	mrn	text	2147483647
employees	name	text	2147483647	√		null
patients	name	text	2147483647	√		null
people	name	text	2147483647	√		null
resources	name	text	2147483647	√		null
site_classes	name	text	2147483647	√		null
site_locations	name	text	2147483647	√		null
sites	name	text	2147483647	√		null
card_case_details	order_comments	text	2147483647	√		null
rad_exam_details	order_comments	text	2147483647	√		null
orders	order_number	text	2147483647	√		null
application_credentials	password	text	2147483647
view_external_cube_exam_facts	patient_class	text	2147483647	√		null
card_case_facts	patient_priority	text	2147483647	√		null
rad_exam_facts	patient_priority	text	2147483647	√		null
card_case_facts	patient_type	text	2147483647	√		null
patient_types	patient_type	text	2147483647
rad_exam_facts	patient_type	text	2147483647	√		null
insurance_carrier_plans	plan_name	text	2147483647
insurance_carrier_plans	plan_number	text	2147483647	√		null
insurance_policies	policy_holder_name	text	2147483647
insurance_policies	policy_number	text	2147483647	√		null
exam_priorities	priority	text	2147483647
view_external_cube_exam_facts	priority	text	2147483647	√		null
locales	privacy_agreement	text	2147483647	√		null
card_case_details	procedure_change_comments	text	2147483647	√		null
rad_exam_details	procedure_change_comments	text	2147483647	√		null
view_external_cube_exam_facts	procedure_code	text	2147483647	√		null
view_external_cube_exam_facts	procedure_description	text	2147483647	√		null
procedure_modifiers	procedure_modifier	text	2147483647
dicom_protocols	protocol	text	2147483647	√		null
provider_groups	provider_group	text	2147483647
view_external_cube_exam_facts	provider_group	text	2147483647	√		null
view_external_cube_exam_facts	rad_exam_department	text	2147483647	√		null
view_external_cube_exam_facts	rad_exam_department_description	text	2147483647	√		null
reasons	reason	text	2147483647
relationship_types	relationship	text	2147483647
card_reports	report_body	text	2147483647	√		null
rad_reports	report_body	text	2147483647	√		null
card_reports	report_impression	text	2147483647	√		null
rad_reports	report_impression	text	2147483647	√		null
resources	resource	text	2147483647
view_external_cube_exam_facts	resource	text	2147483647	√		null
view_external_cube_exam_facts	resource_name	text	2147483647	√		null
cms_hcpcs_code_revisions	revision	text	2147483647
locales	rfc_code	text	2147483647
site_sublocations	room	text	2147483647	√		null
backend_statuses	run_output	jsonb	2147483647
job_metrics_logs	run_output	jsonb	2147483647
job_metrics_logs	script_path	text	2147483647
equipment_serial_numbers	serial_number	text	2147483647
dicom_series	series_iuid	text	2147483647
services	service	text	2147483647	√		null
view_external_cube_exam_facts	service	text	2147483647	√		null
view_external_cube_exam_facts	service_description	text	2147483647	√		null
sites	site	text	2147483647
view_external_cube_exam_facts	site	text	2147483647	√		null
site_classes	site_class	text	2147483647
view_external_cube_exam_facts	site_name	text	2147483647	√		null
software_versions	software_version	text	2147483647
rad_pacs_specialities	speciality	text	2147483647
view_external_cube_exam_facts	speciality	text	2147483647	√		null
specialties	specialty	text	2147483647
rad_pacs_station_names	station_name	text	2147483647
external_system_statuses	status	text	2147483647
backend_statuses	status_type	text	2147483647
rad_pacs_metadata	study_comments	text	2147483647	√		null
dicom_studies	study_iuid	text	2147483647
external_system_roles	system_role	text	2147483647
scheduling_task_groupings	task_abbreviation	text	2147483647	√		null
scheduling_tasks	task_entity_table_name	text	2147483647	√		null
scheduling_task_groupings	task_grouping_identifier	text	2147483647
scheduling_tasks	task_identifier	text	2147483647
scheduling_task_groupings	task_name	text	2147483647	√		null
claim_transaction_types	transaction_type	text	2147483647
application_credentials	username	text	2147483647
application_information	version	text	2147483647
visits	visit_number	text	2147483647	√		null