sql.eureka_package_oracle.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aiw-i2b2-etl Show documentation

AIW i2b2 ETL is a Protempa query results handler for loading data and abstractions into i2b2.

There is a newer version: 4.7

---
-- #%L
-- AIW i2b2 ETL
-- %%
-- Copyright (C) 2012 - 2015 Emory University
-- %%
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
-- 
--      http://www.apache.org/licenses/LICENSE-2.0
-- 
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
-- #L%
---
CREATE OR REPLACE PACKAGE EUREKA
AS
-- Load new providers into PROVIDER_DIMENSION, and update existing providers.
PROCEDURE EK_INS_PROVIDER_FROMTEMP(
        tempProviderTableName IN VARCHAR, 
        upload_id IN NUMBER);

-- Load new patients into PATIENT_DIMENSION, and update existing patients.
PROCEDURE EK_INS_PATIENT_FROMTEMP(
        tempTableName IN VARCHAR,
        upload_id IN NUMBER) ;

-- Load new concepts into CONCEPT_DIMENSION, and update existing concepts.
PROCEDURE EK_INS_CONCEPT_FROMTEMP(
        tempConceptTableName IN VARCHAR, 
        upload_id IN NUMBER) ;

-- Load new modifiers into MODIFIER_DIMENSION, and update existing modifiers.
PROCEDURE EK_INS_MODIFIER_FROMTEMP(
        tempModifierTableName IN VARCHAR, 
        upload_id IN NUMBER) ;

PROCEDURE EK_INS_ENC_VISIT_FROMTEMP(
    tempTableName IN VARCHAR,
    upload_id     IN NUMBER) ;
    
PROCEDURE EK_UPDATE_OBSERVATION_FACT(
    upload_temptable_name IN VARCHAR,
    upload_temptable_name_c IN VARCHAR,
    upload_id             IN NUMBER,
    appendFlag            IN NUMBER) ;

PROCEDURE EK_INSERT_EID_MAP_FROMTEMP(
    tempEidTableName IN VARCHAR,  
    upload_id IN NUMBER) ;

PROCEDURE EK_INSERT_PID_MAP_FROMTEMP(
    tempPidTableName IN VARCHAR, 
    upload_id IN NUMBER) ;

PROCEDURE EK_DISABLE_INDEXES;

PROCEDURE EK_ENABLE_INDEXES;
    
END EUREKA ;
/