Omni-Patient™ HealthViews User's Guide > Configuring Omni-Patient™ HealthViews > Executing the Scripts

Executing the Scripts

Topics:

Configuring the Settings in the Property File
Using the build_all.sh Shell Script
List of Available Scripts
Custom Views

A shell script is provided to execute all of the Omni-Patient HealthViews scripts in the correct order. The shell script uses one of the following property files for configuration purposes, depending on whether PostgreSQL or Greenplum is the target database:

/db_config/postgres.properties
/db_config/greenplum.properties

Configuring the Settings in the Property File

This section describes the contents and settings of the property file (postgres.properties and greenplum.properties).

database.type=
Defines the database type. Currently, GPDB (Greenplum) or POSTGRESQL (PostgreSQL) are supported.
database.host=
Defines the address of the database, which can be logical or an IP address.
database.name=
Defines the name of the database for Omni-Patient HealthViews.
database.username=
Defines the user name to log on to the database.
database.userpass=
Password for the user of the database. This is optional and not recommended. Instead, use the .pgpass file in PostgreSQL to store passwords.
database.src_schema=
Name of the schema for Omni-Patient (typically public for PostgreSQL and hub for Greenplum).
database.targ_schema=healthviews
Defines the name of the schema for Omni-Patient HealthViews, which is usually set to healthviews.

Using the build_all.sh Shell Script

The shell script to run all Omni-Patient HealthViews scripts is build_all.sh. This shell script must be edited to point to the appropriate property file that is being used (postgres.properties and greenplum.properties).

Execute this shell script by typing:

./build_all.sh

In addition, the build_all.sh shell script can be added to a cron job to run on a regularly scheduled interval (typically once per day).

List of Available Scripts

The following table lists and describes all of the available scripts for Omni-Patient HealthViews.

Script	Description
000_v_hv_progress_meter.sql	Creates the hv_progress_meter view.
001_aa_hv_availability.sql	Creates public.hv_availability and populates it with the time of the start of the HealthViews build process.
001_date_dimension.sql	Defines all dates in the system.
002_time_dimension.sql	Defines all times in the system.
003_t_codeset_lookup.sql	Lookup table for codesets.
003_t_dim_codemap_lookup.sql	Defines all codemaps for the system.
003_v_dim_codemap_lookup.sql	View for all codemaps in the system.
005_t_patient_master.sql	All mastered patients in the system.
006_t_provider_master.sql	All mastered providers in the system.
007_t_facility_master.sql	All mastered facilities in the system.
008_t_organization_master.sql	All organizations in the system.
020_t_encounter.sql	All encounters in the system.
021_t_clinical_event2.sql	All clinical events in the system.
021_t_movement_event.sql	All movement events in the system.
021_t_observation_event.sql	All observation events in the system.
022_t_clinical_event_provider.sql	All clinical event provider events in the system.
022_t_drop_temp_tables.sql	Drop temporary tables used by the event tables.
022_t_specimen.sql	All specimens in the system.
022_v_specimen.sql	View for all specimens in the system.
023_t_appointment.sql	All appointments in the system.
024_t_appointment_notification.sql	All appointment notifications in the system.
025_t_patient_wait_list.sql	All patient wait list records for the system.
026_t_patient_wait_list_preference.sql	All patient wait list preferences records for the system.
027_t_provider_availability_appt.sql	All provider availability appointment records for the system.
028_t_provider_availability_slot.sql	All provider availability slot records for the system.
029_t_provider_template.sql	All provider template records for the system.
030_t_account.sql	All accounts for the system.
030_t_provider_template_schedule.sql	All provider template schedule records for the system.
030_v_account.sql	View for all accounts in the system.
031_t_account_guarantor.sql	All account guarantor records for the system.
031_t_referral_source.sql	All referral source records for the system.
031_v_account_guarantor.sql	View for all account guarantor records.
031_v_referral_source.sql	View for all referral source records.
032_t_account_health_plan_coverage.sql	All account health plan records in the system.
032_v_account_health_plan_coverage.sql	View for all account health plan records.
033_t_account_transaction.sql	All account transactions in the system.
033_v_account_transaction.sql	View for all account transactions.
034_t_bill.sql	All bill records in the system.
034_v_bill.sql	View for all bill records.
035_t_bill_line_item.sql	All bill line item records in the system.
035_v_bill_line_item.sql	View for all bill line item records.
036_t_charge.sql	All charge records in the system.
036_v_charge.sql	View for all charge records.
037_t_claim.sql	All claim records in the system.
037_v_claim.sql	View for all claim records.
038_t_patient_health_plan.sql	All patient health plan records in the system.
038_v_patient_health_plan.sql	View for all health plan records.
040_t_transfusion_order_event.sql	All transfusion order event records in the system.
040_v_transfusion_order_event.sql	View for all transfusion order event records.
050_v_clinical_event.sql	All clinical event records in the system.
051_v_clinical_event_provider.sql	View for all clinical event records.
052_v_encounter.sql	All encounter records in the system.
059_all_dimensional_views.sql	Views for provider master records, facility location master records, organization master records, patient master records, codeset lookup records, time, dates, and date/times.
060_v_appointment.sql	View for all appointment records.
061_v_patient_wait_list.sql	View for all patient wait list records.
062_v_patient_wait_list_preference.sql	View for all patient wait list records.
063_v_provider_availability_slot.sql	View for all provider availability slot records.
064_v_provider_template.sql	View for all provider template records.
066_v_appointment_notification.sql	View for all appointment notification records.
067_v_provider_template_schedule.sql	View for all provider template schedule records.
068_v_provider_availability_appt.sql	View for all provider availability appointment records.
070_t_concept_tables.sql	All concept table records in the system.
071_v_concept_views.sql	View for all concept table records.
080_t_health_plan.sql	All health plan records in the system.
080_v_health_plan.sql	View for all health plan records.
090_t_consent.sql	All consent records in the system.
090_v_consent.sql	View for all consent records.
095_v_hpa_location.sql	View for hpa location records.
095_v_hpa_organization.sql	View for hpa organization records.
100_t_symptom.sql	All symptom records in the system.
100_v_symptom.sql	View for all symptom records.
110_t_allergy.sql	All allergy records in the system.
110_v_allergy.sql	View for all allergy records.
120_t_medication_dosage.sql	All medication dosage records in the system.
120_v_medication_dosage.sql	View for all medication dosage records.
130_t_chronic_condition.sql	All chronic condition records in the system.
130_v_chronic_condition.sql	View for all chronic condition records.
140_t_complication.sql	All complication records in the system.
140_v_complication.sql	View for all complication records.
150_t_substance_usage.sql	All substance usage records in the system.
150_v_substance_usage.sql	View for all substance usage records.
160_t_indication.sql	All indication records in the system.
160_v_indication.sql	View for all indication records.
170_t_procedure_complication.sql	All procedure complication records in the system.
170_v_procedure_complication.sql	View for all procedure complication records.
180_t_dim_date_infoapp.sql	Date records for infoapps.
180_v_dim_date_infoapp.sql	View for date records for infoapps.
190_t_encounter_health_plan_coverage.sql	All encounter health plan coverage records in the system.
190_v_encounter_health_plan_coverage.sql	View for all encounter health plan coverage records.
200_t_order_detail_reason.sql	All order detail records in the system.
200_v_order_detail_reason.sql	View for all order detail records.
210_t_pharmacy_suppl_code.sql	All pharmacy supply code records in the system.
210_v_pharmacy_suppl_code.sql	View for all pharmacy supply code records.
220_t_pharmacy_component_suppl_code.sql	All pharmacy component supply code records in the system.
220_v_pharmacy_component_suppl_code.sql	View for all pharmacy component supply code records.
230_t_pharmacy_administration_route.sql	All pharmacy administration route records in the system.
230_v_pharmacy_administration_route.sql	View for all pharmacy administration route records.
240_t_facility.sql	All facility records in the system.
240_v_facility.sql	View for all facility records.
250_t_dim_provider_contact_method.sql	All provider contact method records in the system.
250_v_dim_provider_contact_method.sql	View for all provider contact method records.
260_t_guarantor.sql	All guarantor records in the system.
260_v_guarantor.sql	View for all guarantor records.
270_t_guarantor_account.sql	All guarantor account records in the system.
270_v_guarantor_account.sql	View for all guarantor account records.
280_t_extended_attribute.sql	All extended attribute records in the system.
285_v_encounter_extended_attributes.sql	View for all extended attribute records.
290_t_payer_master.sql	All payer master records in the system.
290_v_payer_master.sql	View for all payer master records.
295_t_payer_name_master.sql	All payer name master records in the system.
295_v_payer_name_master.sql	View for all payer name master records.
296_t_worker_master.sql	All worker master records in the system.
296_v_worker_master.sql	View for all worker master records.
297_t_worker_job_master.sql	All worker job master records in the system.
297_v_worker_job_master.sql	View for all job master records.
298_t_organization.sql	All organization records in the system.
298_v_dim_organization_unit.sql	View for all organization unit records.
300_t_dim_slhn_patient.sql	All patients in the St. Luke's system.
300_t_dim_slhn_provider.sql	View for all patients in the St. Luke's system.
300_v_dim_slhn_patient.sql	All providers in the St. Luke's system.
300_v_dim_slhn_provider.sql	View for all providers in the St. Luke's system.
300_v_slhn_facility.sql	View for all facilities in the St. Luke's system.
300_v_slhn_facility_location.sql	View for all facility locations in the St.Luke's system.
300_v_slhn_observation.sql	View for all observation events in the St. Luke's system.
300_v_slhn_organization.sql	View for all organizations in the St. Luke's system.
300_v_slhn_organization_unit.sql	View for all organizations in the St. Luke's system.
300_v_slhn_patient.sql	View for all patients in the St. Luke's system.
300_v_slhn_provider.sql	View for all providers in the St. Luke's system.
301_t_dim_patient_contact_method.sql	All patient contact method records in the system.
301_v_dim_patient_contact_method.sql	View for all patient contact method records.
302_t_patient_preferred_providers.sql	All patient preferred provider records in the system.
302_v_patient_preferred_providers.sql	View for all patient preferred provider records.
303_t_bed_count.sql	All bed count records in the system.
303_v_bed_count.sql	View for all bed count records.
304_t_closed_bed.sql	All closed bed records in the system.
304_v_closed_bed.sql	View for all closed bed records in the system.
305_t_costing.sql	All costing records in the system.
305_v_costing.sql	View for all costing records.
306_t_member.sql	All member records in the system.
306_v_member.sql	View for all member records.
308_t_survey.sql	All survey records in the system.
308_v_survey.sql	View for all survey records.
309_t_survey_question.sql	All survey question records in the system.
309_v_survey_question.sql	View for all survey question records.
310_t_survey_answer.sql	All survey answer records in the system.
310_v_survey_answer.sql	View for all survey answer records.
311_t_episode.sql	All episode records in the system.
311_v_episode.sql	View for all episode records.
312_t_mammogram_event.sql	All mammogram event records in the system.
312_v_mammogram_event.sql	View for all mammogram event records.
313_t_order_event.sql	All order event records in the system.
313_v_order_event.sql	View for all order event records.
314_t_patient_fall_event.sql	All patient fall event records in the system.
314_v_patient_fall_event.sql	View for all patient fall event records.
315_t_patient_count.sql	All patient count records in the system.
315_v_patient_count.sql	View for all patient count records.
316_t_surgery_case.sql	All surgery case records in the system.
316_v_surgery_case.sql	View for all surgery case records in the system.
318_t_service_order_event.sql	All service order event records in the system.
318_v_service_order_event.sql	View for all service record events.
319_t_event_note.sql	All event note records in the system.
319_v_event_note.sql	View for all event note records.
320_t_gl_transaction.sql	All general ledger transaction records in the system.
320_v_gl_transaction.sql	View for all general ledger transaction records.
321_t_appointment_note.sql	All appointment note records in the system.
321_v_appointment_note.sql	View for all appointment note records.
322_t_extended_attribute_master.sql	All extended attribute master records in the system.
322_v_extended_attribute_master.sql	View for all extended attribute master records.
323_t_provider_assignment.sql	All provider assignment records in the system.
323_v_provider_assignment.sql	View for all provider assignment records.
324_t_surgery_case_cart.sql	All surgery case cart records in the system.
324_v_surgery_case_cart.sql	View for all surgery case cart records.
325_t_surgery_movement.sql	All surgery movement records in the system.
325_v_surgery_movement.sql	View for all surgery movement records.
326_t_surgery_procedure.sql	All surgery procedure records in the system.
326_v_surgery_procedure.sql	View for all surgery procedure records.
327_t_additive_code.sql	All additive code records in the system.
327_v_additive_code.sql	View for all additive code records.
328_t_underlying_cause.sql	All underlying cause records in the system.
328_v_underlying_cause.sql	View for all underlying cause records.
329_t_daily_census.sql	All daily census records in the system.
329_v_daily_census.sql	View for all daily census records.
330_t_daily_emergency.sql	All daily emergency records in the system.
330_v_daily_emergency.sql	View for all daily emergency records.
331_t_payer_claim.sql	All payer claim records in the system.
331_v_payer_claim.sql	View for all payer claim records.
332_t_benefit_plan.sql	All benefit plan records in the system.
332_v_benefit_plan.sql	View for all benefit plan records.
333_t_care_plan.sql	All care plan records in the system.
333_v_care_plan.sql	View for all care plan records.
334_t_payer_client.sql	All payer client records in the system.
334_v_payer_client.sql	View for all payer client records.
335_t_patient_satisfaction_survey.sql	All patient satisfaction survey records in the system.
335_v_patient_satisfaction_survey.sql	View for all patient satisfaction survey records.
336_t_item_cost_component.sql	All item cost component records in the system.
336_v_item_cost_component.sql	View for all item cost component records.
337_t_cart_item.sql	All cart item records in the system.
337_v_cart_item.sql	View for all cart item records.
338_t_clinical_body_site.sql	All clinical body site records in the system.
338_v_clinical_body_site.sql	View for all clinical body site records.
339_t_patient_fall_risk_assessment_event.sql	All patient fall risk assessment event records in the system.
339_v_patient_fall_risk_assessment_event.sql	View for all patient fall risk assessment event records.
340_t_ed_visit.sql	All ed visit records in the system.
340_v_ed_visit.sql	View for all ed visit records.
341_t_hospital_billing_account.sql	All hospital billing account records in the system.
341_v_hospital_billing_account.sql	View for all hospital billing account records.
342_t_costing_other_procedure_code.sql	All costing other procedure code records in the system.
342_v_costing_other_procedure_code.sql	View for all costing other procedure code records.
343_t_reference_range.sql	All reference range records in the system.
343_v_reference_range.sql	View for all reference range records.
344_t_pharmacy_component.sql	All pharmacy component records in the system.
344_v_pharmacy_component.sql	View for all pharmacy component records.
345_t_related_encounter.sql	All related encounter records in the system.
345_v_related_encounter.sql	View for all related encounter records.
700_v_hosp_readmissions_general_inpatients.sql	View for all hospital readmission general in-patients.
700_v_hosp_readmissions_psychiatric_inpatients.sql	View for all hospital readmission psychiatric in-patients.
903_v_hv_release.sql	HealthViews release information.
904_t_hvtabstats.sql	Record counts and deltas for all tables in HealthViews as well as record counts for all partitions of tables with multiple partitions
999_a_grant_select.sql	Provides grant select privileges to all HealthView tables and views to specified users.
999_a_postgres_indexes.sql	Creates all of the required indexes on the HealthViews tables.
999_t_hv_availability.sql	Records stop time for the HealthViews build time and creates the healthviews.t_hv_availability table.
999_v_hv_availability.sql	View for seeing the most recent start and end times for the HealthViews build process as well as the duration.

Custom Views

In addition to the standard views provided by Omni-Patient HealthViews, custom views can also be created and integrated into the Omni-Patient HealthViews build process. For more information about these customizations, contact your Information Builders Account Manager.