130 likes | 262 Views
Systems Engineering Thoughts from an INCOSE Member in Healthcare. Rick Biehl 03/19/2009. Source Behaviors. Operational Systems. Source Data. ETL System. Data Warehouse. Reference & Metadata Management System. System of Internal Controls. Extraction System. Data Marts.
E N D
Systems Engineering Thoughts from an INCOSE Member in Healthcare Rick Biehl03/19/2009
Source Behaviors Operational Systems Source Data ETL System Data Warehouse Reference & Metadata Management System System of Internal Controls Extraction System Data Marts Query & Report System Queries & Reports Target Behaviors
Timeline Measurement Error OrderAction FulfillAction FulfillAction FulfillAction ChargeAction ChargeAction OrderEntry FulfillEntry FulfillEntry FulfillEntry ChargeAction MeasurementError MeasurementError MeasurementError MeasurementError DownstreamSystem
Warehousing UOM Pattern (Syntax) FACT D_UOM SCALE CLASS UNIT MEASURE VALUE
Warehouse EAV Pattern (Semantics) Subject Level 1 Level 2(HL7 Message) Event Level 3(HL7 Segment) Entity Level 4(HL7 Field) Attribute
Organization Calendar Person Time of Day Encounter Operation Caregiver Data Feed Payor Data Quality Diagnosis U.O.M Procedure Data State Material Keyword Facility Metadata Accounting Fact
Service-Unit Manufacturer Supplier ORGANIZATION Country City Address GEOPOLITICS ProviderUser Source CAREGIVER YearMonth Day CALENDAR CohortPersonSpecimen PATIENT HourMinuteSecond CLOCK Inpatient Ambulatory Emergency ENCOUNTER ANNOTATION Keyword Concept Body LocationSite Tooth ANATOMY Placer Order Filler Order OPERATION Problem ReactionRisk Factor DIAGNOSIS Unit Measure Value UOM Lab Test ExaminationObservation PROCEDURE Active SupersededInactive DATA STATE MedicationImmunization Contraceptive MATERIAL SourceApplication DATA FEED InstallationMTFClinic FACILITY Event Entity Attribute METADATA ACCOUNTING MEPRS Secondary Dimensions Primary Dimensions FACT
Provider Staff Contractor CAREGIVER LOCATION City Address CohortPersonSpecimen PATIENT Almanac Dimensions YearMonth Day CALENDAR Encounter Study Assignment INTERACTION Unit Measure UOM DecisionAnalysisDimensions Problem ReactionRisk Factor DIAGNOSIS Test ExaminationMaintenance PROCEDURE AnalystSupportDimension Keyword Observation Note ANNOTATION MedicationImmunization Device MATERIAL Active SupersededInactive DATA STATE VHA FacilityNCA LocationVBA Office Warehouse Internal Control Dimensions FACILITY SourceApplication DATA FEED G/L AccountSubsidiary Account Memo Account ControlDimensions ACCOUNTING Event Entity Attribute METADATA ORGANIZATION Dept. of VA VHA FACT
Gene Sequence Mutation Genome Ecology Nature Setting Chromatin StructureTranscription Factor Target Regulome Environment Ecology, Population, Organism, Organ, Tissue, Cell, Protein, Gene, B.P. Transcriptome mRNA System -omes Type Proteome Proteins Specimen Sample Subject Instance Epigenome Methylation to Clinical Data Warehouse Fact Metabalome Signal Transduction Experiment Instrument Measurement Publication Investigation Interaction Expression Function Outcome Confidence Finding DiseaseAppearance Trait Phenotype Speculation Knowledge Assertion Epistemology Physiology Reaction Process Life Cycles Growth Stages Development Element Molecule Macromolecule Pharmacology Chemistry Resistance Perturbation Pathology Quantity Quality Space Time Treatment Protocol Therapy Measure Anatomy Makeup Structure
Multiple Timeline Analysis Action Action Action Action Physician Timeline (Activity of the Operator) Action Action Action Action Action Action Action Action Action Action Action Action Patient Timeline (Activity of the Process) Action Action Action Action Action Equipment Timeline (Activity of the Machine)
Warehousing as System-of-Systems Financial Data Warehouse ClinicalData Clinical Data Warehouse LogisticsData Logistics Data Warehouse Operations Data Operations Data Warehouse ResearchData Research Data Warehouse