 alter table DYEXTN_USERDEF_DE_VALUE_REL add constraint FK3EE58DCF5521B106 foreign key (USER_DEF_DE_ID) references DYEXTN_USERDEFINED_DE;
 alter table DYEXT_ENTIY_COMPOSITE_KEY_REL add constraint FKD2168AAA4AC41F7E foreign key (ENTITY_ID) references DYEXTN_ENTITY;
 alter table DYEXT_ENTIY_COMPOSITE_KEY_REL add constraint FKD2168AAA4DC2CD16 foreign key (ATTRIBUTE_ID) references DYEXTN_PRIMITIVE_ATTRIBUTE;
+insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3433,'SECURE_CONDITION','Greater than or Equal to!=!AGE',309);
+insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3434,'SECURE_CONDITION','SECURE_CONDITION',283);
+insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3435,'LIMITED_PRIVILEGE','LIMITED_PRIVILEGE',342);
+insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3436,'LIMITED_PRIVILEGE','LIMITED_PRIVILEGE',345);
+insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3437,'LIMITED_PRIVILEGE','LIMITED_PRIVILEGE',314);

insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3430,'resultview','resultview',21);
insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3431,'resultview','resultview',22);
insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3432,'resultview','resultview',31);
insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3433,'SECURE_CONDITION','Greater than or Equal to!=!AGE',309);
insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3434,'SECURE_CONDITION','SECURE_CONDITION',283);
insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3435,'LIMITED_PRIVILEGE','LIMITED_PRIVILEGE',342);
insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3436,'LIMITED_PRIVILEGE','LIMITED_PRIVILEGE',345);
insert into  dyextn_tagged_value  ( IDENTIFIER , T_KEY , T_VALUE , ABSTRACT_METADATA_ID ) values (3437,'LIMITED_PRIVILEGE','LIMITED_PRIVILEGE',314);
/*Data for the table  dyextn_textarea  */

/*Data for the table  dyextn_textfield  */


/*Data for the table  dyextn_role  */

insert into  dyextn_role  ( IDENTIFIER , ASSOCIATION_TYPE , MAX_CARDINALITY , MIN_CARDINALITY , NAME ) values (1,'ASSOCIATION',100,0,NULL),(2,'CONTAINTMENT',1,1,'providerType'),(3,'ASSOCIATION',100,0,'provider'),(4,'CONTAINTMENT',1,0,'personName'),(5,'ASSOCIATION',1,1,'provider'),(6,'CONTAINTMENT',1,0,'providerType'),(7,'ASSOCIATION',1,1,'medicationOrderDetails'),(8,'CONTAINTMENT',1,0,'frequencyWithModifier'),(9,'ASSOCIATION',1,1,'medicationOrderDetails'),(10,'CONTAINTMENT',1,0,'orderingProvider'),(11,'ASSOCIATION',1,1,'medicationComponent'),(12,'CONTAINTMENT',1,0,'units'),(13,'ASSOCIATION',1,1,'medicationComponent'),(14,'CONTAINTMENT',1,0,'quantityUnits'),(15,'ASSOCIATION',1,1,'medicationComponent'),(16,'CONTAINTMENT',1,0,'form'),(17,'ASSOCIATION',1,1,'medicationComponent'),(18,'CONTAINTMENT',1,1,'component'),(19,'ASSOCIATION',1,1,'medicationComponent'),(20,'CONTAINTMENT',1,0,'type'),(21,'ASSOCIATION',1,1,'medicationComponent'),(22,'CONTAINTMENT',1,0,'route'),(23,'ASSOCIATION',1,1,'medicationOrderDetails'),(24,'CONTAINTMENT',100,0,'medicationComponentCollection'),(25,'ASSOCIATION',1,1,'medicationOrderDetails'),(26,'CONTAINTMENT',1,0,'orderStatus'),(27,'ASSOCIATION',1,1,'medicationOrderDetails'),(28,'CONTAINTMENT',1,0,'infusionUnits'),(29,'ASSOCIATION',1,1,'medicationOrderDetails');
insert into  dyextn_role  ( IDENTIFIER , ASSOCIATION_TYPE , MAX_CARDINALITY , MIN_CARDINALITY , NAME ) values (30,'CONTAINTMENT',1,0,'verifiedBy'),(31,'ASSOCIATION',1,1,'medicationOrderDetails'),(32,'CONTAINTMENT',1,0,'quantityUnits'),(33,'ASSOCIATION',1,1,'medicationOrderDetails'),(34,'CONTAINTMENT',1,0,'units'),(35,'ASSOCIATION',1,1,'medicationOrderDetails'),(36,'CONTAINTMENT',1,0,'substitutionStatus'),(37,'ASSOCIATION',1,1,'medicationOrderDetails'),(38,'CONTAINTMENT',1,0,'frequency'),(39,'ASSOCIATION',1,1,'medicationOrderDetails'),(40,'CONTAINTMENT',1,0,'frequencyModifier'),(41,'ASSOCIATION',1,1,'medicationOrderDetails'),(42,'CONTAINTMENT',1,0,'responsiblePharmacy'),(43,'ASSOCIATION',1,1,'medicationOrder'),(44,'CONTAINTMENT',100,1,'medicationOrderDetailsCollection'),(45,'ASSOCIATION',1,1,'medicationOrder'),(46,'CONTAINTMENT',1,1,'application'),(47,'ASSOCIATION',1,1,'medicationOrder'),(48,'CONTAINTMENT',1,1,'facility'),(49,'ASSOCIATION',1,1,'medicationOrder'),(50,'CONTAINTMENT',1,1,'medicationCollection'),(51,'ASSOCIATION',1,1,'personUpi'),(52,'ASSOCIATION',100,0,'medicationOrderCollection'),(53,'ASSOCIATION',1,1,'encounterDetails'),(54,'CONTAINTMENT',1,0,'patientLocation'),(55,'ASSOCIATION',1,1,'encounterDetails'),(56,'CONTAINTMENT',100,0,'providerCollection'),(57,'ASSOCIATION',1,1,'encounterDetails'),(58,'CONTAINTMENT',1,0,'vipIndicator');
insert into  dyextn_role  ( IDENTIFIER , ASSOCIATION_TYPE , MAX_CARDINALITY , MIN_CARDINALITY , NAME ) values (59,'ASSOCIATION',1,1,'encounterDetails'),(60,'CONTAINTMENT',1,0,'diagnosticRelatedGroup'),(61,'ASSOCIATION',1,1,'encounterDetails'),(62,'CONTAINTMENT',1,0,'facilityDischargeDisposition'),(63,'ASSOCIATION',1,1,'encounterDetails'),(64,'CONTAINTMENT',1,0,'financialClass'),(65,'ASSOCIATION',1,1,'insurance'),(66,'CONTAINTMENT',1,0,'insuredRelationshipToPatient'),(67,'ASSOCIATION',100,0,NULL),(68,'CONTAINTMENT',1,1,'insuredRelationShipToPatient'),(69,'ASSOCIATION',1,1,'insurance'),(70,'CONTAINTMENT',1,0,'nameOfInsured'),(71,'ASSOCIATION',1,1,'insurance'),(72,'CONTAINTMENT',1,1,'planType'),(73,'ASSOCIATION',1,1,'encounterDetails'),(74,'CONTAINTMENT',100,0,'insuranceCollection'),(75,'ASSOCIATION',1,1,'clinicalTrial'),(76,'CONTAINTMENT',1,0,'principalInvestigator'),(77,'ASSOCIATION',1,1,'encounterDetails'),(78,'CONTAINTMENT',100,0,'clinicalTrailCollection'),(79,'ASSOCIATION',1,1,'encounterDetails'),(80,'CONTAINTMENT',1,0,'dischargeService'),(81,'ASSOCIATION',1,1,'encounterDetails'),(82,'CONTAINTMENT',1,0,'admittingService'),(83,'ASSOCIATION',1,1,'procedure'),(84,'CONTAINTMENT',1,1,'provider'),(85,'ASSOCIATION',1,1,'procedure'),(86,'CONTAINTMENT',1,1,'code'),(87,'ASSOCIATION',1,1,'procedure'),(88,'CONTAINTMENT',1,1,'type'),(89,'ASSOCIATION',1,1,NULL),(90,'CONTAINTMENT',1,1,'type');
insert into  dyextn_role  ( IDENTIFIER , ASSOCIATION_TYPE , MAX_CARDINALITY , MIN_CARDINALITY , NAME ) values (91,'ASSOCIATION',1,1,NULL),(92,'CONTAINTMENT',1,1,'code'),(93,'ASSOCIATION',1,1,'encounterDetails'),(94,'CONTAINTMENT',100,0,'procedureCollection'),(95,'ASSOCIATION',100,0,NULL),(96,'CONTAINTMENT',1,1,'financialClass'),(97,'ASSOCIATION',100,0,NULL),(98,'CONTAINTMENT',1,1,'facilityDischargeDisposition'),(99,'ASSOCIATION',100,0,NULL),(100,'CONTAINTMENT',100,0,'infectionControlCodes'),(101,'ASSOCIATION',100,0,NULL),(102,'CONTAINTMENT',1,1,'optOutIndicator'),(103,'ASSOCIATION',100,0,NULL),(104,'CONTAINTMENT',1,1,'hipaaNotified'),(105,'ASSOCIATION',100,0,NULL),(106,'CONTAINTMENT',1,1,'vipIndicator'),(107,'ASSOCIATION',100,0,NULL),(108,'CONTAINTMENT',1,1,'dischargeService'),(109,'ASSOCIATION',100,0,NULL),(110,'CONTAINTMENT',1,0,'diagnosticRelatedGroup'),(111,'ASSOCIATION',100,0,NULL),(112,'CONTAINTMENT',1,1,'dischargeDisposition'),(113,'ASSOCIATION',100,0,NULL),(114,'CONTAINTMENT',1,1,'patientType'),(115,'ASSOCIATION',100,0,NULL),(116,'CONTAINTMENT',1,1,'admittingService'),(117,'ASSOCIATION',1,1,NULL),(118,'CONTAINTMENT',1,1,'patientClass'),(119,'ASSOCIATION',1,1,'encounterDetails'),(120,'CONTAINTMENT',1,0,'patientClass'),(121,'ASSOCIATION',1,1,'encounterDetails'),(122,'CONTAINTMENT',1,0,'patientType'),(123,'ASSOCIATION',1,1,'diagnosis'),(124,'CONTAINTMENT',1,0,'type'),(125,'ASSOCIATION',1,1,'diagnosis');
insert into  dyextn_role  ( IDENTIFIER , ASSOCIATION_TYPE , MAX_CARDINALITY , MIN_CARDINALITY , NAME ) values (126,'CONTAINTMENT',1,0,'code'),(127,'ASSOCIATION',100,0,NULL),(128,'CONTAINTMENT',1,1,'type'),(129,'ASSOCIATION',100,0,NULL),(130,'CONTAINTMENT',1,1,'code'),(131,'ASSOCIATION',1,1,'encounterDetails'),(132,'CONTAINTMENT',100,0,'diagnosisCollection'),(133,'ASSOCIATION',1,1,'encounterDetails'),(134,'CONTAINTMENT',1,0,'optOutIndicator'),(135,'ASSOCIATION',1,1,'encounterDetails'),(136,'CONTAINTMENT',1,0,'dischargeDisposition'),(137,'ASSOCIATION',1,1,'encounterDetails'),(138,'CONTAINTMENT',100,0,'infectionControlCodeCollection'),(139,'ASSOCIATION',1,1,'encounterDetails'),(140,'CONTAINTMENT',1,0,'hippaNotified'),(141,'ASSOCIATION',1,1,'encounter'),(142,'CONTAINTMENT',100,1,'encounterDetailsCollection'),(143,'ASSOCIATION',1,1,'medicalRecordNumber'),(144,'CONTAINTMENT',1,1,'facility'),(145,'ASSOCIATION',1,1,'encounter'),(146,'CONTAINTMENT',1,1,'medicalRecordNumber'),(147,'ASSOCIATION',1,1,'encounter'),(148,'CONTAINTMENT',1,1,'facility'),(149,'ASSOCIATION',1,1,'personUpi'),(150,'ASSOCIATION',100,0,'encounterCollection'),(151,'CONTAINTMENT',100,0,'demographicsCollection'),(152,'CONTAINTMENT',100,0,'ethnicOriginCollection'),(153,'CONTAINTMENT',100,0,'demographicsCollection'),(154,'CONTAINTMENT',1,0,'gender'),(155,'ASSOCIATION',100,0,'demographics');
insert into  dyextn_role  ( IDENTIFIER , ASSOCIATION_TYPE , MAX_CARDINALITY , MIN_CARDINALITY , NAME ) values (156,'CONTAINTMENT',1,0,'advancedDirectiveExists'),(157,'CONTAINTMENT',100,0,'demographicsCollection'),(158,'CONTAINTMENT',1,0,'religion'),(159,'CONTAINTMENT',100,0,'demographicsCollection'),(160,'CONTAINTMENT',100,0,'raceCollection'),(161,'CONTAINTMENT',1,1,'demographics'),(162,'CONTAINTMENT',1,1,'personName'),(163,'ASSOCIATION',100,0,'associatedPerson'),(164,'CONTAINTMENT',1,1,'relationToPerson'),(165,'ASSOCIATION',1,1,'associatedPerson'),(166,'ASSOCIATION',1,1,'associatedPersonUpi'),(167,'ASSOCIATION',1,1,'demographics'),(168,'CONTAINTMENT',100,0,'associatedPersonCollection'),(169,'ASSOCIATION',1,1,'demographics'),(170,'CONTAINTMENT',1,0,'nextOfKin'),(171,'ASSOCIATION',1,1,'demographics'),(172,'CONTAINTMENT',100,0,'phoneCollection'),(173,'CONTAINTMENT',1,1,'address'),(174,'CONTAINTMENT',1,0,'state'),(175,'CONTAINTMENT',1,1,'address'),(176,'CONTAINTMENT',1,0,'type'),(177,'CONTAINTMENT',1,1,'address'),(178,'CONTAINTMENT',1,0,'country'),(179,'CONTAINTMENT',1,1,'demographics'),(180,'CONTAINTMENT',100,0,'addressCollection'),(181,'CONTAINTMENT',100,0,'demographicsCollection'),(182,'CONTAINTMENT',1,0,'maritalStatus'),(183,'CONTAINTMENT',1,1,'personUpi'),(184,'CONTAINTMENT',100,1,'demographicsCollection'),(185,'ASSOCIATION',1,1,'laboratoryProcedure');
insert into  dyextn_role  ( IDENTIFIER , ASSOCIATION_TYPE , MAX_CARDINALITY , MIN_CARDINALITY , NAME ) values (186,'CONTAINTMENT',1,1,'procedure'),(187,'ASSOCIATION',1,1,'laboratoryProcedure'),(188,'CONTAINTMENT',1,1,'facility'),(189,'ASSOCIATION',1,1,'laboratoryProcedure'),(190,'CONTAINTMENT',1,1,'application'),(191,'ASSOCIATION',1,1,'laboratoryProcedureDetails'),(192,'CONTAINTMENT',1,1,'procedureStatus'),(193,'ASSOCIATION',1,1,'laboratoryProcedureDetails'),(194,'CONTAINTMENT',1,0,'medicalRecordNumber'),(195,'ASSOCIATION',100,0,NULL),(196,'ASSOCIATION',100,0,'procedureId'),(197,'ASSOCIATION',100,0,NULL),(198,'ASSOCIATION',100,0,'procedureStatus'),(199,'ASSOCIATION',1,1,'laboratoryResults'),(200,'CONTAINTMENT',1,0,'resultStatus'),(201,'ASSOCIATION',1,1,'result'),(202,'CONTAINTMENT',1,0,'normalRange'),(203,'CONTAINTMENT',1,1,'result'),(204,'CONTAINTMENT',1,1,'units'),(205,'ASSOCIATION',1,1,'resultValue'),(206,'CONTAINTMENT',1,1,'normalizedResult'),(207,'ASSOCIATION',1,1,'resultValue'),(208,'CONTAINTMENT',1,1,'sourceResult'),(209,'ASSOCIATION',1,1,'laboratoryResults'),(210,'CONTAINTMENT',1,0,'resultValue'),(211,'ASSOCIATION',1,1,'laboratoryResults'),(212,'CONTAINTMENT',100,0,'abnormalFlagCollection'),(213,'ASSOCIATION',1,1,'laboratoryResults'),(214,'CONTAINTMENT',1,1,'test'),(215,'ASSOCIATION',1,1,'LaboratoryProcedureDetails');
insert into  dyextn_role  ( IDENTIFIER , ASSOCIATION_TYPE , MAX_CARDINALITY , MIN_CARDINALITY , NAME ) values (216,'CONTAINTMENT',100,0,'laboratoryResultCollection'),(217,'ASSOCIATION',1,1,'laboratoryProcedureDetails'),(218,'CONTAINTMENT',1,0,'specimenType'),(219,'ASSOCIATION',1,1,'laboratoryProcedureDetails'),(220,'CONTAINTMENT',1,1,'performingFacility'),(221,'ASSOCIATION',1,1,'laboratoryProcedure'),(222,'CONTAINTMENT',100,1,'laboratoryProcedureDetailsCollection'),(223,'ASSOCIATION',1,1,'personUpi'),(224,'ASSOCIATION',100,0,'laboratoryProcedureCollection'),(225,'ASSOCIATION',100,0,'providerCollection'),(226,'ASSOCIATION',1,0,'personUpi');

/*Data for the table  dyextn_rule  */

