update i2b2demodata.concept_dimension
set concept_path = '\00Pharmacy\' || '000000000' || upper(substring(name_char,1,1)) || '\' 
|| insertstr(0,substring(concept_cd,10), substring('0000000000',length(substring(concept_cd,10))+1)) || '\' 
where sourcesystem_cd = 'Pharmacy';

insert into i2b2demodata.PATIENT_DIMENSION (PATIENT_NUM, VITAL_STATUS_CD, BIRTH_DATE, DEATH_DATE, SEX_CD, AGE_IN_YEARS_NUM, LANGUAGE_CD, 
RACE_CD, MARITAL_STATUS_CD, RELIGION_CD, ZIP_CD, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, UPLOAD_ID, STATECITYZIP_PATH) 
values (10001, null, null, null, null, null, null, null, null, null, null, '2010-01-01', '2010-01-01', '2010-01-01', 'Pharmacy', 1, 'NA'); 

insert into i2b2demodata.OBSERVATION_FACT (ENCOUNTER_NUM, PATIENT_NUM, CONCEPT_CD, PROVIDER_ID, START_DATE, MODIFIER_CD, VALTYPE_CD, TVAL_CHAR, NVAL_NUM, VALUEFLAG_CD, QUANTITY_NUM, UNITS_CD, END_DATE, 
LOCATION_CD, CONFIDENCE_NUM, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, UPLOAD_ID, CONCEPT_PATH)
select 10000001,10001,concept_cd,'@','2010-01-01','@','T',name_char,null,null,null,null,'2010-01-01','@',null,'2010-01-01','2010-01-01','2010-01-01','Pharmacy',1,concept_path  from i2b2demodata.concept_dimension
where sourcesystem_cd = 'Pharmacy';

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
select 2, concept_path, name_char, 'N', 'LA', concept_cd, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', concept_path, name_char, '2010-01-01','2010-01-01','2010-01-01','Pharmacy',concept_path
from i2b2demodata.concept_dimension where sourcesystem_cd = 'Pharmacy';

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(0, '\00Pharmacy\', 'Pharmacy', 'N', 'CA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\', 'Pharmacy', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.TABLE_ACCESS (C_TABLE_CD, C_TABLE_NAME, C_PROTECTED_ACCESS, C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, 
C_VISUALATTRIBUTES, C_FACTTABLECOLUMN, C_DIMTABLENAME, C_COLUMNNAME, C_COLUMNDATATYPE, 
C_OPERATOR, C_DIMCODE, C_TOOLTIP, C_ENTRY_DATE)  
values ('Pharmacy','i2b2','N', 0, '\00Pharmacy\', 'Pharmacy', 'N', 'CA', 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\', 'Pharmacy', 
'2010-01-01');



insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000A\', 'A', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000A\', 'A', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000B\', 'B', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000B\', 'B', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000C\', 'C', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000C\', 'C', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000D\', 'D', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000D\', 'D', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000E\', 'E', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000E\', 'E', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000F\', 'F', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000F\', 'F', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000G\', 'G', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000G\', 'G', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000H\', 'H', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000H\', 'H', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000I\', 'I', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000I\', 'I', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000J\', 'J', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000J\', 'J', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000K\', 'K', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000K\', 'K', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000L\', 'L', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000L\', 'L', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000M\', 'M', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000M\', 'M', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000N\', 'N', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000N\', 'N', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000O\', 'O', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000O\', 'O', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000P\', 'P', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000P\', 'P', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000Q\', 'Q', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000Q\', 'Q', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000R\', 'R', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000R\', 'R', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000S\', 'S', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000S\', 'S', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000T\', 'T', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000T\', 'T', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000U\', 'U', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000U\', 'U', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000V\', 'V', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000V\', 'V', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000W\', 'W', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000W\', 'W', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000X\', 'X', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000X\', 'X', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000Y\', 'Y', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000Y\', 'Y', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

insert into i2b2metadata.I2B2 (C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_BASECODE, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, 
C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_TOOLTIP, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, CONCEPT_PATH) 
values(1, '\00Pharmacy\000000000Z\', 'Z', 'N', 'FA', null, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\00Pharmacy\000000000Z\', 'Z', 
'2010-01-01','2010-01-01','2010-01-01','Pharmacy',null);

commit;


