Hi Steven,
Thanks for the reply.
Below is my VDB.xml Which version attribute are you referring to?
<?xml version="1.0" encoding="ASCII"?>
<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:diagram="http://www.metamatrix.com/metamodels/Diagram" xmlns:mmcore="http://www.metamatrix.com/metamodels/Core" xmlns:relational="http://www.metamatrix.com/metamodels/Relational" xmlns:transformation="http://www.metamatrix.com/metamodels/Transformation">
<mmcore:ModelAnnotation xmi:uuid="mmuuid:d8c5fbb2-1655-4f6a-80ac-6c3979150859" primaryMetamodelUri="http://www.metamatrix.com/metamodels/Relational" modelType="VIRTUAL" ProducerName="Teiid Designer" ProducerVersion="8.3.3.Final-v20140613-1202-B88">
<modelImports xmi:uuid="mmuuid:0237ee9a-43c5-482e-929c-4bf458256807" name="XMLSchema" modelLocation="http://www.w3.org/2001/XMLSchema" modelType="TYPE" primaryMetamodelUri="http://www.eclipse.org/xsd/2002/XSD"/>
<modelImports xmi:uuid="mmuuid:48ca6317-8221-4d79-b9a3-890d21ee5aec" name="iCare_ProgNotes_ViewModel" modelLocation="../iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_ViewModel.xmi" uuid="mmuuid:db6fc2e2-dec4-4b11-90a7-7ddf0e3e464b" modelType="VIRTUAL" primaryMetamodelUri="http://www.metamatrix.com/metamodels/Relational"/>
<modelImports xmi:uuid="mmuuid:f4452be4-002f-4407-8d3b-f3c69ab0cc14" name="P5_Model_ltcperson" modelLocation="../P5_IMPORTS/P5_TABLES/P5_ltcperson/P5_Model_ltcperson.xmi" uuid="mmuuid:264bc667-85c7-44a8-ae7f-3752a61808d8" modelType="PHYSICAL" primaryMetamodelUri="http://www.metamatrix.com/metamodels/Relational"/>
<modelImports xmi:uuid="mmuuid:d3974b17-aee7-4273-a7c9-fa3b73e8b413" name="P5_Model_proc_prognotes" modelLocation="../P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi" uuid="mmuuid:35c361ac-97a5-4b36-ad51-daf87ba3b258" modelType="PHYSICAL" primaryMetamodelUri="http://www.metamatrix.com/metamodels/Relational"/>
<modelImports xmi:uuid="mmuuid:252d9d6b-ce28-423b-ba62-4ded71cc93d0" name="P5_Model_ltcpersonnotes" modelLocation="../P5_IMPORTS/P5_TABLES/P5_ltcpersonnotes/P5_Model_ltcpersonnotes.xmi" uuid="mmuuid:9ca19ed1-8573-4523-a093-90067ba0b4ef" modelType="PHYSICAL" primaryMetamodelUri="http://www.metamatrix.com/metamodels/Relational"/>
</mmcore:ModelAnnotation>
<diagram:DiagramContainer xmi:uuid="mmuuid:c13a9e18-2707-4a8d-a42d-f5b4080568e4">
<diagram xmi:uuid="mmuuid:d7f89771-e230-4305-a8d1-58e7c4eb1b56" type="packageDiagramType" target="mmuuid/d8c5fbb2-1655-4f6a-80ac-6c3979150859">
<diagramEntity xmi:uuid="mmuuid:0aca0a89-8b4a-4794-b274-fd6f07684a5d" modelObject="mmuuid/d3a847c2-36d6-4d8f-82ed-2a49ec5b50a0" xPosition="20" yPosition="20"/>
</diagram>
</diagram:DiagramContainer>
<mmcore:AnnotationContainer xmi:uuid="mmuuid:4d550e40-a1a2-45a5-b148-4b089976faef">
<annotations xmi:uuid="mmuuid:2bad23d9-106c-44f4-8cfa-961e16392834" annotatedObject="mmuuid/d8c5fbb2-1655-4f6a-80ac-6c3979150859">
<tags xmi:uuid="mmuuid:ef14e5f8-a3c0-4868-ac86-29dbc92ed2f9" key="modelExtensionDefinition:relational" value="relational"/>
<tags xmi:uuid="mmuuid:4f2024cf-349f-4230-afd0-9ab697ae1838" key="modelExtensionDefinition:REST" value="REST"/>
</annotations>
<annotations xmi:uuid="mmuuid:17238e8d-1d17-4897-a34b-ab083c931872" annotatedObject="mmuuid/ef14e5f8-a3c0-4868-ac86-29dbc92ed2f9">
<tags xmi:uuid="mmuuid:e8ec70bf-7f4e-4880-8997-b15c6e2fc5ab" key="metamodel" value="http://www.metamatrix.com/metamodels/Relational"/>
<tags xmi:uuid="mmuuid:c7f85e63-96ef-416f-ac17-4e0b2314b0f5" key="namespacePrefix" value="relational"/>
<tags xmi:uuid="mmuuid:9ef95121-1128-4726-9299-942c4c2c26e0" key="namespaceUri" value="http://www.teiid.org/ext/relational/2012"/>
<tags xmi:uuid="mmuuid:51ffe67c-516a-4c76-b6d2-611881b18728" key="version" value="3"/>
<tags xmi:uuid="mmuuid:9a9eca80-0ef6-4ab2-a10d-cf76abb8f006" key="description" value="Relational metamodel extension properties"/>
<tags xmi:uuid="mmuuid:7a40c627-a940-445e-a38c-61297909b1f1" key="modelTypes" value=""/>
<tags xmi:uuid="mmuuid:d2f5756d-3cb4-44b2-8f5c-1b26ec3b9b36" key="extendedMetaclass:org.teiid.designer.metamodels.relational.impl.ForeignKeyImpl" value="org.teiid.designer.metamodels.relational.impl.ForeignKeyImpl"/>
<tags xmi:uuid="mmuuid:d3273b3b-f591-4578-a474-d03c5ad20ec6" key="extendedMetaclass:org.teiid.designer.metamodels.relational.impl.ProcedureImpl" value="org.teiid.designer.metamodels.relational.impl.ProcedureImpl"/>
<tags xmi:uuid="mmuuid:bcb0b9a6-b001-4b1b-921d-7fb22426afaa" key="extendedMetaclass:org.teiid.designer.metamodels.relational.impl.BaseTableImpl" value="org.teiid.designer.metamodels.relational.impl.BaseTableImpl"/>
</annotations>
<annotations xmi:uuid="mmuuid:9d492b15-0a63-4f9e-bc47-135f530dfd2c" annotatedObject="mmuuid/7a40c627-a940-445e-a38c-61297909b1f1">
<tags xmi:uuid="mmuuid:eae892b7-ab1a-42df-9ffb-fbdbe51b66f0" key="VIRTUAL" value=""/>
<tags xmi:uuid="mmuuid:1a84f61b-080d-4151-afa9-d2d0fa56f1a8" key="PHYSICAL" value=""/>
</annotations>
<annotations xmi:uuid="mmuuid:33d0762a-01fa-446b-b88e-26f755a25ab5" annotatedObject="mmuuid/d2f5756d-3cb4-44b2-8f5c-1b26ec3b9b36">
<tags xmi:uuid="mmuuid:2474579c-88fc-4f36-9cad-e308f0fbfc4c" key="propertyDefinition:allow-join" value="allow-join"/>
</annotations>
<annotations xmi:uuid="mmuuid:63143930-4be3-443e-9fe9-e05e63ff09ca" annotatedObject="mmuuid/2474579c-88fc-4f36-9cad-e308f0fbfc4c">
<tags xmi:uuid="mmuuid:14941f52-d6b4-46af-a046-e62c9edc42f2" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:3cfd0aa7-1bba-4f70-a95e-7545a4d97301" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:70493fd6-3c13-46d0-8e93-b5ee603ae807" key="defaultValue" value="true"/>
<tags xmi:uuid="mmuuid:5f2b0a5c-f3a5-4206-976c-3c5c5ec8d502" key="id" value="allow-join"/>
<tags xmi:uuid="mmuuid:47d9f973-de75-460e-b711-1bf1356e691a" key="index" value="true"/>
<tags xmi:uuid="mmuuid:4fa8088a-f5e0-4891-800e-5f5ea94d2e6b" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:b2f9a710-5d71-44f3-9b2b-d04576bf4976" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:1a9f71ba-4af0-459e-aa83-2b280bfcbc4b" key="required" value="false"/>
<tags xmi:uuid="mmuuid:1f19c38c-d27e-4399-a417-51da91ef0774" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:9149363e-9fc8-44cd-b4eb-3c45eb61d0f7" annotatedObject="mmuuid/3cfd0aa7-1bba-4f70-a95e-7545a4d97301">
<tags xmi:uuid="mmuuid:f1797b8e-afeb-495e-8c59-3633955cece9" key="en" value="Allow Join"/>
</annotations>
<annotations xmi:uuid="mmuuid:d359c04e-750c-4069-9e85-ba99d1e80650" annotatedObject="mmuuid/d3273b3b-f591-4578-a474-d03c5ad20ec6">
<tags xmi:uuid="mmuuid:1f5d5393-4d13-4352-b5cc-5189938d6d8c" key="propertyDefinition:deterministic" value="deterministic"/>
<tags xmi:uuid="mmuuid:3307a437-e948-4b38-9efe-ce97ae2726f1" key="propertyDefinition:native-query" value="native-query"/>
<tags xmi:uuid="mmuuid:6e10f31c-adb0-473f-a588-f3cc37d28389" key="propertyDefinition:non-prepared" value="non-prepared"/>
<tags xmi:uuid="mmuuid:1a293869-7d00-425c-a5ef-012240bd1f9f" key="propertyDefinition:aggregate" value="aggregate"/>
<tags xmi:uuid="mmuuid:d35439d0-d790-4ebd-a021-1d0446b2e962" key="propertyDefinition:analytic" value="analytic"/>
<tags xmi:uuid="mmuuid:84f07c7c-316d-4c75-8cde-47c424d69335" key="propertyDefinition:allows-orderby" value="allows-orderby"/>
<tags xmi:uuid="mmuuid:f72bc9fd-bf5c-46f4-96c4-97f3383d0d34" key="propertyDefinition:uses-distinct-rows" value="uses-distinct-rows"/>
<tags xmi:uuid="mmuuid:73dc1c39-f1d8-4ff4-b132-1fbe5a5d8636" key="propertyDefinition:allows-distinct" value="allows-distinct"/>
<tags xmi:uuid="mmuuid:eb20dd8a-ab25-46c3-a6c9-dc640e16a684" key="propertyDefinition:decomposable" value="decomposable"/>
<tags xmi:uuid="mmuuid:c6eb9148-8cc1-48a5-9110-cf7fb642e715" key="propertyDefinition:varargs" value="varargs"/>
<tags xmi:uuid="mmuuid:4605c0c3-58f7-4852-b2f9-4fcaf337c422" key="propertyDefinition:null-on-null" value="null-on-null"/>
<tags xmi:uuid="mmuuid:e348cee2-3198-4d1d-9b87-9b9dcc1133e2" key="propertyDefinition:function-category" value="function-category"/>
<tags xmi:uuid="mmuuid:21e4e8fa-42e3-4076-8f24-f4217957c3b6" key="propertyDefinition:java-class" value="java-class"/>
<tags xmi:uuid="mmuuid:10b41a7a-eacc-4365-b5a4-72cc335d59b9" key="propertyDefinition:java-method" value="java-method"/>
<tags xmi:uuid="mmuuid:f1d002b7-ecca-4271-8d5c-d2fcd17d132d" key="propertyDefinition:udfJarPath" value="udfJarPath"/>
</annotations>
<annotations xmi:uuid="mmuuid:1ef0e33a-2408-4a97-9655-b08e0b90a0d2" annotatedObject="mmuuid/1f5d5393-4d13-4352-b5cc-5189938d6d8c">
<tags xmi:uuid="mmuuid:b639454f-5154-462e-a005-a17eeb5f09dd" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:4ae29d5d-c9fd-4495-8595-a217e2b7daa5" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:a031ea87-0f1e-45f7-ac9a-291ccb764fd4" key="defaultValue" value="false"/>
<tags xmi:uuid="mmuuid:e6053aed-99bb-4546-997d-a133c0fe0e38" key="description" value=""/>
<tags xmi:uuid="mmuuid:a4dc6ffe-eeda-4de5-8ad0-268c919d6fee" key="id" value="deterministic"/>
<tags xmi:uuid="mmuuid:9dec61fc-e0bc-4e84-abd4-e3e1085faf69" key="index" value="true"/>
<tags xmi:uuid="mmuuid:79d97b8a-5201-4d0b-88b1-6a7927fea401" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:ce31257a-c08b-4615-87f1-8e2676d29414" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:fb025d32-693e-4e1a-b5a9-a1c111d94caa" key="required" value="false"/>
<tags xmi:uuid="mmuuid:86081427-cb28-4acd-b9a9-be609ccb8a47" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:dd08f074-7dc8-4eec-9182-aca3c1d4f4ee" annotatedObject="mmuuid/4ae29d5d-c9fd-4495-8595-a217e2b7daa5">
<tags xmi:uuid="mmuuid:117e31c9-0a64-401d-9d15-566082801123" key="en" value="Deterministic"/>
</annotations>
<annotations xmi:uuid="mmuuid:b9efce6b-62be-404d-8319-5f30145fec83" annotatedObject="mmuuid/e6053aed-99bb-4546-997d-a133c0fe0e38">
<tags xmi:uuid="mmuuid:87ef9490-72bd-4851-9182-e125c626def4" key="en" value="Specifies that the source function will always return the same result for a specific input value"/>
</annotations>
<annotations xmi:uuid="mmuuid:d8c11a83-5727-4ded-9610-95d75d019c6e" annotatedObject="mmuuid/3307a437-e948-4b38-9efe-ce97ae2726f1">
<tags xmi:uuid="mmuuid:2ecb0ba4-e8f1-4e08-8ceb-cc671b214038" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:34d76b9b-58f9-4cfd-b4b0-0996f3a90e05" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:02c51407-39fa-4191-b560-719ca2daff7a" key="id" value="native-query"/>
<tags xmi:uuid="mmuuid:24c7b0f1-5042-440e-a675-0fc421372bc8" key="index" value="true"/>
<tags xmi:uuid="mmuuid:b3c71e95-4260-461e-a7e3-d96ba6b41617" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:e964dbba-d219-485a-b758-e141dfea5d77" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:38507c87-33b4-4735-af0c-f09ae9e91b04" key="required" value="false"/>
<tags xmi:uuid="mmuuid:e3a4580d-5523-4d91-97c8-444c930589a9" key="runtimeType" value="string"/>
</annotations>
<annotations xmi:uuid="mmuuid:5e34e929-ff35-4bdd-a55d-fd5cb59b22d3" annotatedObject="mmuuid/34d76b9b-58f9-4cfd-b4b0-0996f3a90e05">
<tags xmi:uuid="mmuuid:67e3984e-91e9-4dd3-bb4f-4ad9cea70847" key="en" value="Native Query"/>
</annotations>
<annotations xmi:uuid="mmuuid:2cfea74e-c515-4afe-8087-19206b61dfc8" annotatedObject="mmuuid/6e10f31c-adb0-473f-a588-f3cc37d28389">
<tags xmi:uuid="mmuuid:28c1a05b-e7ec-4a0d-afc4-d9590e1d8ae1" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:c89ca2c2-f678-40de-9a3a-5739e22afe05" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:8f0e1026-36ba-494d-a7d1-68aa14afa0eb" key="defaultValue" value="false"/>
<tags xmi:uuid="mmuuid:e5a29588-e088-4906-9147-30db5c533b8b" key="id" value="non-prepared"/>
<tags xmi:uuid="mmuuid:2725f491-f756-4973-b9c5-e2585aabbaef" key="index" value="true"/>
<tags xmi:uuid="mmuuid:8af93117-164f-4394-ae31-2a153330ca30" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:282bdc3a-8e5f-4cbe-8bd8-b1c8793ce0dc" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:3c5ab6c2-cc3b-4b96-a145-edd410c5bef8" key="required" value="false"/>
<tags xmi:uuid="mmuuid:6ad4d15c-c0e1-4b53-82a1-e3ccc984a86d" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:04cab9ad-f3f1-48ac-a9df-e94d9c25cc0e" annotatedObject="mmuuid/c89ca2c2-f678-40de-9a3a-5739e22afe05">
<tags xmi:uuid="mmuuid:d563f522-108c-4690-95e7-eb7875e3179e" key="en" value="Non-Prepared"/>
</annotations>
<annotations xmi:uuid="mmuuid:068076bb-d97f-401e-9bbd-65fd5b56be5d" annotatedObject="mmuuid/1a293869-7d00-425c-a5ef-012240bd1f9f">
<tags xmi:uuid="mmuuid:6dd6fcd7-3748-4bbd-84d5-3ab704ce807d" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:3c0d913d-4684-4754-a6c9-95b767d00df3" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:6b962128-3cc8-4f06-9e02-d0086bfb46ca" key="defaultValue" value="false"/>
<tags xmi:uuid="mmuuid:a306e928-94a6-47fa-9142-cc2251c5f7bb" key="id" value="aggregate"/>
<tags xmi:uuid="mmuuid:56d2d1a9-dbd8-4fbd-9ed8-3692685a037b" key="index" value="true"/>
<tags xmi:uuid="mmuuid:907e5360-b538-4eab-bac1-5bdfdb164e0b" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:24a48ccf-5fb4-4d25-92a4-fd5265e809e5" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:94d29e0f-c042-4f50-89cf-bf25f07a6050" key="required" value="true"/>
<tags xmi:uuid="mmuuid:ab063862-56bb-4c76-bf08-39ffe7866c7a" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:a944ae38-4af6-4147-bf7b-aae12446d672" annotatedObject="mmuuid/3c0d913d-4684-4754-a6c9-95b767d00df3">
<tags xmi:uuid="mmuuid:07600980-b375-43dc-8716-ba993c7105f5" key="en" value="Aggregate"/>
</annotations>
<annotations xmi:uuid="mmuuid:1a4b4b08-1dcf-425a-a933-7b8c17d950a6" annotatedObject="mmuuid/d35439d0-d790-4ebd-a021-1d0446b2e962">
<tags xmi:uuid="mmuuid:719eadda-9eeb-4e2a-91a1-13fa4a019b06" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:899c89cb-1266-4882-bc94-7a26f58711ca" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:3b9cce2a-0b4b-498e-8a51-40abdf8a7dbc" key="defaultValue" value="false"/>
<tags xmi:uuid="mmuuid:be0366a8-4ed8-4802-8c0e-2164f5a5f95e" key="id" value="analytic"/>
<tags xmi:uuid="mmuuid:c405f3c8-f3d0-47b2-a224-0f961bda8b7b" key="index" value="true"/>
<tags xmi:uuid="mmuuid:73e9738c-09a8-4e9a-9b14-4a2b4f7a32b3" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:82cc726e-35fb-4db9-86e0-15cb85f2e043" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:d8042eff-376a-4182-b404-8c550c4f85ff" key="required" value="false"/>
<tags xmi:uuid="mmuuid:9976b0df-a0a4-4c65-b0e3-8731cfae2565" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:0059d25a-121a-4106-8838-ebe81e6b602f" annotatedObject="mmuuid/899c89cb-1266-4882-bc94-7a26f58711ca">
<tags xmi:uuid="mmuuid:b43285e3-f08c-4988-bf06-79db26c0d9e4" key="en" value="Analytic"/>
</annotations>
<annotations xmi:uuid="mmuuid:e00fd73c-2165-4ad6-8845-3e19beb65cb2" annotatedObject="mmuuid/84f07c7c-316d-4c75-8cde-47c424d69335">
<tags xmi:uuid="mmuuid:27844456-8a1f-4b98-b262-107732f11b55" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:f49b7ec7-174b-42f3-919a-3e4f1a99efc8" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:3e96741f-0b00-4bc8-9b6d-aaf0870c348f" key="defaultValue" value="false"/>
<tags xmi:uuid="mmuuid:6bb94019-7c5a-4e65-99b7-f8d6490dfe80" key="id" value="allows-orderby"/>
<tags xmi:uuid="mmuuid:20b7fbc3-27d2-4ac0-ae3c-52bf42bfb4bb" key="index" value="true"/>
<tags xmi:uuid="mmuuid:274d34cf-d6c6-4349-904c-38f57e827596" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:99e18e52-0cf4-4ce9-8fe7-32ec013715cb" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:3aea1146-6dc1-4451-916e-556c2523f0e8" key="required" value="false"/>
<tags xmi:uuid="mmuuid:38fcb146-ba5a-421a-98b7-b232b31d0df8" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:0a1e544a-5cb0-46ef-bc9e-2fe46d651bc7" annotatedObject="mmuuid/f49b7ec7-174b-42f3-919a-3e4f1a99efc8">
<tags xmi:uuid="mmuuid:570c3585-136e-423f-bdd8-b8e1bfe33647" key="en" value="Allows Order-by"/>
</annotations>
<annotations xmi:uuid="mmuuid:844fb866-4070-4f42-87cf-b9be3668943e" annotatedObject="mmuuid/f72bc9fd-bf5c-46f4-96c4-97f3383d0d34">
<tags xmi:uuid="mmuuid:f5094a02-6523-4266-86e5-0e16820e4bcf" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:05c43bbc-730b-4bbe-9501-9393ed8d43c7" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:733d495c-cb01-437d-95f2-4614a141bd18" key="defaultValue" value="false"/>
<tags xmi:uuid="mmuuid:ba1834c2-49b6-409b-9fff-0ec350b647b1" key="id" value="uses-distinct-rows"/>
<tags xmi:uuid="mmuuid:d2fe56ee-8dea-44b3-a57a-fbf175ed9d2b" key="index" value="true"/>
<tags xmi:uuid="mmuuid:2f66d786-239a-445d-ac7a-7a49218c2960" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:e0d0d28d-04f0-4169-a432-e0a24a1fad17" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:5fdd2c87-c810-4123-9da7-2dc4249b171c" key="required" value="false"/>
<tags xmi:uuid="mmuuid:10f6956f-1cb9-41fe-98c6-635f63a45c56" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:60ad3732-5c31-4730-88a4-1c1bb0b22466" annotatedObject="mmuuid/05c43bbc-730b-4bbe-9501-9393ed8d43c7">
<tags xmi:uuid="mmuuid:b04da4a7-18e9-4937-9c3c-70a3a266f2c0" key="en" value="Uses Distinct Rows"/>
</annotations>
<annotations xmi:uuid="mmuuid:4d754f9f-2431-49b9-90c7-3ac9b6ed3fb7" annotatedObject="mmuuid/73dc1c39-f1d8-4ff4-b132-1fbe5a5d8636">
<tags xmi:uuid="mmuuid:3d32abf7-c4d1-4faf-954c-41731a1e5fec" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:a21d2f11-d3ca-4fd0-b6ec-2b3ab459cfe8" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:57d1603e-e131-4e93-ade9-2a48805c569f" key="defaultValue" value="false"/>
<tags xmi:uuid="mmuuid:c4ff8227-dfe1-4a1b-8fd9-f398bbfe3e3e" key="id" value="allows-distinct"/>
<tags xmi:uuid="mmuuid:45a7e8a9-6241-4554-94bf-afe9f461eae2" key="index" value="true"/>
<tags xmi:uuid="mmuuid:e65e5710-8618-4c54-9bf0-7b9f518fda5c" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:32eb6cc2-cef7-40e0-8357-644d00c3630d" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:b010d3e1-d468-4129-92e4-b7e4ee6e6752" key="required" value="false"/>
<tags xmi:uuid="mmuuid:1cda46c5-9836-4c3f-a42c-fa6a8d178e33" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:d7f07f4b-13ba-4b19-a4e3-43f82e27c625" annotatedObject="mmuuid/a21d2f11-d3ca-4fd0-b6ec-2b3ab459cfe8">
<tags xmi:uuid="mmuuid:112eb767-cc8b-46a7-9d0e-c9446b238e6d" key="en" value="Allows Distinct"/>
</annotations>
<annotations xmi:uuid="mmuuid:6312c31f-eb2c-4f1d-be09-63dc57f29f7c" annotatedObject="mmuuid/eb20dd8a-ab25-46c3-a6c9-dc640e16a684">
<tags xmi:uuid="mmuuid:f327b369-e121-42a6-b822-39e9b58bc981" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:7629c9c2-f8c4-42a9-b895-b3800781a978" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:5b6c9ff0-b803-4765-af53-ee946ee84e60" key="defaultValue" value="false"/>
<tags xmi:uuid="mmuuid:82f2dea6-b2a3-4427-b180-39a62311f1b4" key="id" value="decomposable"/>
<tags xmi:uuid="mmuuid:f92b372e-a7f1-4cf6-8c82-a6f406424409" key="index" value="true"/>
<tags xmi:uuid="mmuuid:f6b4f63c-2df2-499e-8559-3156818bc5fc" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:0fd0af9f-2c3c-49e8-a6c6-6825a599229c" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:d3847221-a027-4c45-bd39-55bc7cff005a" key="required" value="false"/>
<tags xmi:uuid="mmuuid:520afd08-b969-45d7-906a-c08c0655c153" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:c6e8719f-806f-4868-b29e-c453be0cce39" annotatedObject="mmuuid/7629c9c2-f8c4-42a9-b895-b3800781a978">
<tags xmi:uuid="mmuuid:fe96bd2e-756e-41a1-84ab-6dcb44a5fb30" key="en" value="Decomposable"/>
</annotations>
<annotations xmi:uuid="mmuuid:eb5b2a1c-1f3a-4b4f-8d92-6f1e0027b1cf" annotatedObject="mmuuid/c6eb9148-8cc1-48a5-9110-cf7fb642e715">
<tags xmi:uuid="mmuuid:e8b1b8cf-664f-4241-bc58-7b2f392274b9" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:57ba7488-bb53-4539-8ea3-0da5684a4f1e" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:92242145-6555-486f-9488-3f13283b1201" key="defaultValue" value="false"/>
<tags xmi:uuid="mmuuid:fb9060f0-5198-4182-a4b2-74b53b9e8f06" key="description" value=""/>
<tags xmi:uuid="mmuuid:4df163ed-e7d5-48bf-ac4d-5b6a1af7c613" key="id" value="varargs"/>
<tags xmi:uuid="mmuuid:891f5279-c994-494c-a1ce-e9862623dc95" key="index" value="true"/>
<tags xmi:uuid="mmuuid:95744c50-89e4-4661-a8e6-d85940332149" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:d8bdd02e-a8e7-4c76-86f7-7c62cf0f9f21" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:a16acf81-e62a-460a-8b82-c3d537837841" key="required" value="false"/>
<tags xmi:uuid="mmuuid:470d9360-d45b-43d5-b67b-9a55e73d3e87" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:43264bea-4fb5-4a2b-bd6f-ab1da4127686" annotatedObject="mmuuid/57ba7488-bb53-4539-8ea3-0da5684a4f1e">
<tags xmi:uuid="mmuuid:13b4a58f-080d-4d55-bcec-b9d3efb082dc" key="en_US" value="Variable Arguments"/>
</annotations>
<annotations xmi:uuid="mmuuid:881901a1-6925-4ffa-bfa1-8fee924b59b8" annotatedObject="mmuuid/fb9060f0-5198-4182-a4b2-74b53b9e8f06">
<tags xmi:uuid="mmuuid:9d23e5b8-1af5-434e-a457-ff2d6cf7d802" key="en_US" value="Indicates that the last arg may be repeated a variable number of times."/>
</annotations>
<annotations xmi:uuid="mmuuid:7061cc88-b523-4920-bde8-86ec208b2d73" annotatedObject="mmuuid/4605c0c3-58f7-4852-b2f9-4fcaf337c422">
<tags xmi:uuid="mmuuid:3dd32fc5-6bef-4d74-b033-40d9f0407b5e" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:cde3295e-8643-4d3c-8e0d-9423b6b44c1a" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:2adae86a-3bff-49d9-9dc8-67467dbd9b81" key="defaultValue" value="false"/>
<tags xmi:uuid="mmuuid:70b1861c-4353-4cf6-8b2e-087b6b24a2b6" key="description" value=""/>
<tags xmi:uuid="mmuuid:5f45be9f-9eff-400f-941f-32eb10512261" key="id" value="null-on-null"/>
<tags xmi:uuid="mmuuid:f94c2e93-9cb7-4d11-8dce-f704333e5593" key="index" value="true"/>
<tags xmi:uuid="mmuuid:7ed491ee-0a88-446d-92ef-805f745da9a9" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:fea9eb87-6228-48ea-a20f-82dc67ca61f0" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:795165ea-f1c4-4135-b3c1-5da0710fb611" key="required" value="false"/>
<tags xmi:uuid="mmuuid:468066bb-371a-4b26-ab34-396df9dc1aab" key="runtimeType" value="boolean"/>
</annotations>
<annotations xmi:uuid="mmuuid:c2c9e607-89f3-43ee-b802-8264b202de80" annotatedObject="mmuuid/cde3295e-8643-4d3c-8e0d-9423b6b44c1a">
<tags xmi:uuid="mmuuid:94adb86f-fdba-46d7-b3ce-527462439374" key="en_US" value="Returns null on null"/>
</annotations>
<annotations xmi:uuid="mmuuid:5df2d987-2ee3-403e-a1bd-8dee07801641" annotatedObject="mmuuid/70b1861c-4353-4cf6-8b2e-087b6b24a2b6">
<tags xmi:uuid="mmuuid:b76cf1bf-58e1-4c3c-a888-ea8a90f5f63d" key="en_US" value="indicates that the function will return null."/>
</annotations>
<annotations xmi:uuid="mmuuid:2a9a8721-2f38-4078-b8df-13490d6f5536" annotatedObject="mmuuid/e348cee2-3198-4d1d-9b87-9b9dcc1133e2">
<tags xmi:uuid="mmuuid:6668a01b-01f6-42c4-9f0c-1210be332151" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:0e2831a0-9cf6-476e-b9a4-2dbaf57ab3c7" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:6ef70fc4-955c-40c7-96ae-97a6bff5925f" key="description" value=""/>
<tags xmi:uuid="mmuuid:e237c25a-5dd2-4fc1-9848-2c8441baa7ce" key="id" value="function-category"/>
<tags xmi:uuid="mmuuid:ab8a04d5-375f-43b8-a68e-fe95fad71279" key="index" value="true"/>
<tags xmi:uuid="mmuuid:abdae0c4-21cc-499d-94c3-aeec434b03f9" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:77f4af93-4986-43b3-8817-e43b3c271be0" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:63ac5e77-7c9b-4a2b-915e-32ee2f952f2f" key="required" value="false"/>
<tags xmi:uuid="mmuuid:e0fe7135-d485-4337-b607-46fade564d9c" key="runtimeType" value="string"/>
</annotations>
<annotations xmi:uuid="mmuuid:70b532ed-f92f-4381-b2ed-0cff241bddd9" annotatedObject="mmuuid/0e2831a0-9cf6-476e-b9a4-2dbaf57ab3c7">
<tags xmi:uuid="mmuuid:e85434fa-cf44-4be5-a256-251e81faff54" key="en_US" value="Function Category"/>
</annotations>
<annotations xmi:uuid="mmuuid:d7e29b31-b56e-4ac1-b28b-8cf0dd6b262d" annotatedObject="mmuuid/6ef70fc4-955c-40c7-96ae-97a6bff5925f">
<tags xmi:uuid="mmuuid:3677cb53-1d7c-4de1-8fff-fe523172a9b6" key="en_US" value="The category for function procedures"/>
</annotations>
<annotations xmi:uuid="mmuuid:5f703f6e-bb3e-492d-bfb7-4f8d80cd7e1a" annotatedObject="mmuuid/21e4e8fa-42e3-4076-8f24-f4217957c3b6">
<tags xmi:uuid="mmuuid:855deee6-ecdf-42a8-9abf-da62e0348d32" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:3619346a-c0bb-4cb7-af87-224658218efd" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:2e6d6e80-fb02-4fcf-ae78-f4d1d991d91f" key="description" value=""/>
<tags xmi:uuid="mmuuid:1de651c3-e827-4074-9515-b2166cc31967" key="id" value="java-class"/>
<tags xmi:uuid="mmuuid:52477f91-07c6-46b0-b68f-98e432bd5055" key="index" value="true"/>
<tags xmi:uuid="mmuuid:cdedb5cd-5a8a-405a-ba87-bf9719bc58f6" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:6da00efe-8bd7-4342-9645-c48b1ceeb97b" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:83fa7247-00cb-4b8c-b840-a1a93df41161" key="required" value="false"/>
<tags xmi:uuid="mmuuid:37e29e1a-5bb9-4267-ad7b-be0b4675b4ec" key="runtimeType" value="string"/>
</annotations>
<annotations xmi:uuid="mmuuid:eb19f8f4-1b3b-4724-94f9-4c07689d3cca" annotatedObject="mmuuid/3619346a-c0bb-4cb7-af87-224658218efd">
<tags xmi:uuid="mmuuid:e1f0e7f7-4188-45d6-b01d-e3a8bef5126a" key="en_US" value="Java Class"/>
</annotations>
<annotations xmi:uuid="mmuuid:c8068572-4e42-4ba9-aa78-38652c53f941" annotatedObject="mmuuid/2e6d6e80-fb02-4fcf-ae78-f4d1d991d91f">
<tags xmi:uuid="mmuuid:bf2dec40-86de-4bb2-9687-c0b4298cd749" key="en_US" value="The java class containing the user defined function"/>
</annotations>
<annotations xmi:uuid="mmuuid:fabe64bd-07ab-47af-ab41-efa0a288fddf" annotatedObject="mmuuid/10b41a7a-eacc-4365-b5a4-72cc335d59b9">
<tags xmi:uuid="mmuuid:c81a01ef-2e1a-4f42-9b66-6592438782bf" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:adb46905-3a30-439d-8bd9-1fa1770a5191" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:c405e984-dc30-4d6e-9c2d-d2847f75d017" key="description" value=""/>
<tags xmi:uuid="mmuuid:d750ef87-b724-4a43-bdd8-c2e27640f65a" key="id" value="java-method"/>
<tags xmi:uuid="mmuuid:ac2d1c77-2010-4870-9e81-e0930f927be7" key="index" value="true"/>
<tags xmi:uuid="mmuuid:8c21070f-7b52-4dbe-a4bf-60a245c4cf28" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:f1489c42-c64c-46d8-9028-ffe851420c71" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:71e2d3ef-8a6d-40a9-af43-c59bf73dd1e2" key="required" value="false"/>
<tags xmi:uuid="mmuuid:287ab983-0e37-4fb4-90ec-43250b01c357" key="runtimeType" value="string"/>
</annotations>
<annotations xmi:uuid="mmuuid:6c70ea56-8169-4e85-9ebf-d3af7e292cf0" annotatedObject="mmuuid/adb46905-3a30-439d-8bd9-1fa1770a5191">
<tags xmi:uuid="mmuuid:05b1503a-eb97-4ee1-a3f4-2cc568715351" key="en_US" value="Java Method"/>
</annotations>
<annotations xmi:uuid="mmuuid:92c2484b-f9a6-4f3e-87cf-9d90704d1059" annotatedObject="mmuuid/c405e984-dc30-4d6e-9c2d-d2847f75d017">
<tags xmi:uuid="mmuuid:074aa5d2-97d6-44b1-a39c-f96ab0c2166b" key="en_US" value="The java method defining the user defined function"/>
</annotations>
<annotations xmi:uuid="mmuuid:83a3f22e-7388-4b44-a80e-c30a6d9c6eec" annotatedObject="mmuuid/f1d002b7-ecca-4271-8d5c-d2fcd17d132d">
<tags xmi:uuid="mmuuid:d8b8a0bf-572f-46ea-b7fc-49ad99709dc0" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:7c5d66fc-2d9d-4d17-a084-4f895d171a2c" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:21e1cccf-3dc9-473a-affa-58e39b3ab56f" key="description" value=""/>
<tags xmi:uuid="mmuuid:affd1082-64c7-4925-bc7d-3c70cb7c51a7" key="id" value="udfJarPath"/>
<tags xmi:uuid="mmuuid:aecdac08-44b2-4fcb-97c5-df099c65b69d" key="index" value="false"/>
<tags xmi:uuid="mmuuid:f748eee8-3d34-4a8a-8cba-6340a70cb51f" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:8a9aee81-426c-4c32-bd24-aedb988bbc0f" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:d81f8b25-f685-4d77-9092-c1560af7c99c" key="required" value="false"/>
<tags xmi:uuid="mmuuid:cead48da-7436-49c4-b426-484a1a3d2744" key="runtimeType" value="string"/>
</annotations>
<annotations xmi:uuid="mmuuid:61703543-d53b-405c-9657-ea14c62d6033" annotatedObject="mmuuid/7c5d66fc-2d9d-4d17-a084-4f895d171a2c">
<tags xmi:uuid="mmuuid:de629946-1b9f-40f3-ab37-dd7ff8c925c5" key="en" value="UDF Jar Path"/>
</annotations>
<annotations xmi:uuid="mmuuid:63888f4e-245c-4ed9-bfe3-9ecac555cb83" annotatedObject="mmuuid/21e1cccf-3dc9-473a-affa-58e39b3ab56f">
<tags xmi:uuid="mmuuid:8e7aac01-4c83-4523-8de9-ad8d25577b71" key="en_US" value="The project-relative path where the UDF jar is located"/>
</annotations>
<annotations xmi:uuid="mmuuid:f892910e-1357-44ea-984a-3484b95e8421" annotatedObject="mmuuid/bcb0b9a6-b001-4b1b-921d-7fb22426afaa">
<tags xmi:uuid="mmuuid:49e431ba-65b5-4636-88b6-a8ad4ecfbc6a" key="propertyDefinition:native-query" value="native-query"/>
</annotations>
<annotations xmi:uuid="mmuuid:6d0e17c4-955f-4249-a6f8-f086b45ae261" annotatedObject="mmuuid/49e431ba-65b5-4636-88b6-a8ad4ecfbc6a">
<tags xmi:uuid="mmuuid:4b994465-285c-419d-bb03-83276e20b5e8" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:1be3a3c5-85e8-404b-b319-b23965442ea0" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:8b2b1ec2-0553-488a-9f9d-710e39b124ed" key="id" value="native-query"/>
<tags xmi:uuid="mmuuid:51844811-82ab-4237-9470-4c12acdd729b" key="index" value="true"/>
<tags xmi:uuid="mmuuid:f77897f1-4661-4748-9d7f-cc65d8f2db33" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:9e3fa054-d002-4b25-8ef4-340eb9cc3de0" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:95be8ac8-9f0a-4209-bb23-c50e6853ab3e" key="required" value="false"/>
<tags xmi:uuid="mmuuid:3958a5d9-41c5-483c-a66d-e770796232aa" key="runtimeType" value="string"/>
</annotations>
<annotations xmi:uuid="mmuuid:a690bb8b-ba85-4046-9da4-cd8efd4441e3" annotatedObject="mmuuid/1be3a3c5-85e8-404b-b319-b23965442ea0">
<tags xmi:uuid="mmuuid:77244d44-4f3c-497c-937f-5e9e0225d523" key="en" value="Native Query"/>
</annotations>
<annotations xmi:uuid="mmuuid:7967d0b1-7b1f-4f76-9e07-4334f119d780" annotatedObject="mmuuid/4f2024cf-349f-4230-afd0-9ab697ae1838">
<tags xmi:uuid="mmuuid:24e65ec7-6cea-454f-9c14-225ad85734df" key="metamodel" value="http://www.metamatrix.com/metamodels/Relational"/>
<tags xmi:uuid="mmuuid:95cb9203-8c9e-4add-860a-6efd91b7e4fc" key="namespacePrefix" value="REST"/>
<tags xmi:uuid="mmuuid:d06a82a9-f94e-4485-9f2b-f389173bf40f" key="namespaceUri" value="http://teiid.org/rest"/>
<tags xmi:uuid="mmuuid:47766fff-55ba-4996-b901-9e88bba34ea8" key="version" value="1"/>
<tags xmi:uuid="mmuuid:23eeb307-188d-4607-8a8d-3ceaa0bd9708" key="description" value="REST extended virtual procedure properties"/>
<tags xmi:uuid="mmuuid:7959e5a2-430f-44f9-be02-de11a407a6a0" key="modelTypes" value=""/>
<tags xmi:uuid="mmuuid:1a9201dd-1bb6-4540-9412-14ae74152853" key="extendedMetaclass:org.teiid.designer.metamodels.relational.impl.ProcedureImpl" value="org.teiid.designer.metamodels.relational.impl.ProcedureImpl"/>
</annotations>
<annotations xmi:uuid="mmuuid:7ecf7df8-44f8-4760-9bbf-bba077656277" annotatedObject="mmuuid/7959e5a2-430f-44f9-be02-de11a407a6a0">
<tags xmi:uuid="mmuuid:84510432-2131-4582-96d4-cb4b395f54c2" key="VIRTUAL" value=""/>
</annotations>
<annotations xmi:uuid="mmuuid:071de3a2-f36e-414c-b222-a39a8f7b82c3" annotatedObject="mmuuid/1a9201dd-1bb6-4540-9412-14ae74152853">
<tags xmi:uuid="mmuuid:6165de55-3b1a-4c67-b0f5-177ccb79bb3b" key="propertyDefinition:charset" value="charset"/>
<tags xmi:uuid="mmuuid:f04cf263-11f2-4bad-821d-12ab376ee8c9" key="propertyDefinition:headers" value="headers"/>
<tags xmi:uuid="mmuuid:2d3e8587-22b3-4eff-9024-54ad0e20af85" key="propertyDefinition:METHOD" value="METHOD"/>
<tags xmi:uuid="mmuuid:4e94c7b7-888c-4c6d-817a-dfc4144d410a" key="propertyDefinition:URI" value="URI"/>
</annotations>
<annotations xmi:uuid="mmuuid:bc9b0c33-596e-47d0-bbfa-c0b392be5cd3" annotatedObject="mmuuid/6165de55-3b1a-4c67-b0f5-177ccb79bb3b">
<tags xmi:uuid="mmuuid:12591df9-b374-49db-a6df-bf734a28b8ef" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:33a73d2c-3cc6-4058-a739-b1580b294a6d" key="allowedValues" value=""/>
<tags xmi:uuid="mmuuid:5f010cbf-d57c-472d-9e5f-e82a8ad01f5d" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:66b42ccc-f17a-4ef0-93e7-a70ed5101ae2" key="description" value=""/>
<tags xmi:uuid="mmuuid:fe8f9418-3440-4022-890a-e44c5e38d10e" key="id" value="charset"/>
<tags xmi:uuid="mmuuid:aeacf490-399f-4a8f-8940-6cccf00a6588" key="index" value="false"/>
<tags xmi:uuid="mmuuid:2ac788de-c50e-4ce4-a242-8b044badd33e" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:cb86a017-f659-4127-9dd5-ce7a53e55061" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:9380d2cd-a2ed-458e-8883-3d3a7492a46a" key="required" value="false"/>
<tags xmi:uuid="mmuuid:b2db0222-529b-4897-90cd-59e650a2db99" key="runtimeType" value="string"/>
</annotations>
<annotations xmi:uuid="mmuuid:88aeacff-6b90-4244-bf9f-00305a40bb54" annotatedObject="mmuuid/33a73d2c-3cc6-4058-a739-b1580b294a6d">
<tags xmi:uuid="mmuuid:dd495116-ad34-41f2-8426-2153be3e7519" key="UTF-8" value=""/>
<tags xmi:uuid="mmuuid:7e5cc02d-2472-42ce-b806-b3c20b235c66" key="US-ASCII" value=""/>
</annotations>
<annotations xmi:uuid="mmuuid:708b6879-6c09-48da-ab94-02e04b348f2c" annotatedObject="mmuuid/5f010cbf-d57c-472d-9e5f-e82a8ad01f5d">
<tags xmi:uuid="mmuuid:0a429cc4-3551-4f3f-8402-bf98cf3a3d41" key="en_US" value="CHARSET"/>
</annotations>
<annotations xmi:uuid="mmuuid:069ecdb0-3870-4489-bfb4-b009920dff93" annotatedObject="mmuuid/66b42ccc-f17a-4ef0-93e7-a70ed5101ae2">
<tags xmi:uuid="mmuuid:82b8a7d1-ff3a-4d94-8efc-b9aff6fd1b61" key="en_US" value="Optional property for procedures that return a Blob with content type that is text-based. This character set to used to convert the data. "/>
</annotations>
<annotations xmi:uuid="mmuuid:e9711b98-7add-4781-98a6-d189d7986de8" annotatedObject="mmuuid/f04cf263-11f2-4bad-821d-12ab376ee8c9">
<tags xmi:uuid="mmuuid:3127cc68-1865-4dd4-b75e-74e235b02520" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:2f9c42b5-78a5-429f-82f9-c70a8b422afb" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:27a034fc-e62b-4f37-a8c5-ab6e0a9af35f" key="description" value=""/>
<tags xmi:uuid="mmuuid:9ea62a56-74f6-46b4-b462-f97cef774b75" key="id" value="headers"/>
<tags xmi:uuid="mmuuid:30c4e030-91dc-48e8-9200-5af4a8318dfe" key="index" value="false"/>
<tags xmi:uuid="mmuuid:b971b837-d052-4567-869b-aa457ae8a28d" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:2f9235e0-707f-4b88-a954-ea58ae4f6571" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:bbae62a5-e44c-4197-9a68-31f1b23e1e93" key="required" value="false"/>
<tags xmi:uuid="mmuuid:87bcdddf-ff2a-4047-9876-249e59f1517f" key="runtimeType" value="string"/>
</annotations>
<annotations xmi:uuid="mmuuid:d9a469e9-58ab-4085-aa79-2577b31a4e72" annotatedObject="mmuuid/2f9c42b5-78a5-429f-82f9-c70a8b422afb">
<tags xmi:uuid="mmuuid:949c160a-0bab-4715-9dcb-f1c80f53af92" key="en_US" value="HEADERS"/>
</annotations>
<annotations xmi:uuid="mmuuid:dca35678-24d4-47ff-8d98-bcd7468c37eb" annotatedObject="mmuuid/27a034fc-e62b-4f37-a8c5-ab6e0a9af35f">
<tags xmi:uuid="mmuuid:5dbe4152-1afe-4dd8-969d-858b67768634" key="en_US" value="Semi-colon delimited list of HTTP Header parameters to pass into the REST service operation. Ex. header1;header2;etc. These value will be passed into the procedure first."/>
</annotations>
<annotations xmi:uuid="mmuuid:8dd701f5-6389-41ff-b100-8c3e4aad2574" annotatedObject="mmuuid/2d3e8587-22b3-4eff-9024-54ad0e20af85">
<tags xmi:uuid="mmuuid:4ea8ef0d-112c-484b-b103-14f285c99a1f" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:3419c1cd-eedb-47d1-a29d-8749451d3b41" key="allowedValues" value=""/>
<tags xmi:uuid="mmuuid:2ef20d81-2b62-4833-8601-57150c6e2d65" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:41875af3-e456-4900-81d5-5177e2d44a1f" key="defaultValue" value=" "/>
<tags xmi:uuid="mmuuid:2e54a763-40f5-404e-9b79-a1d0b2d85b95" key="description" value=""/>
<tags xmi:uuid="mmuuid:97d52e02-dcdb-45bd-84c3-ea44213c592f" key="id" value="METHOD"/>
<tags xmi:uuid="mmuuid:88802c28-3b54-40c6-a339-526c786c67a2" key="index" value="true"/>
<tags xmi:uuid="mmuuid:9fff653b-c8ab-4519-bf00-d685bfc07c4d" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:288e3e08-40f7-42d5-adfa-d8a2161420b8" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:b0b52a83-927e-4c52-988a-8072bc13576c" key="required" value="false"/>
<tags xmi:uuid="mmuuid:cef3ffab-ca83-46b4-b028-84e06d6a8235" key="runtimeType" value="string"/>
</annotations>
<annotations xmi:uuid="mmuuid:74c532c9-92e7-4193-affc-ca24ec426f92" annotatedObject="mmuuid/3419c1cd-eedb-47d1-a29d-8749451d3b41">
<tags xmi:uuid="mmuuid:afd7410b-a8f9-4e52-a0e8-7f2ef410db36" key="POST" value=""/>
<tags xmi:uuid="mmuuid:f3368dd6-ffbd-4bad-8aae-03a49396fba6" key=" " value=""/>
<tags xmi:uuid="mmuuid:1f04990e-96f1-4480-9f71-aa2053a32e0b" key="GET" value=""/>
<tags xmi:uuid="mmuuid:b208ee48-a870-4030-99b7-405b4d9e297a" key="DELETE" value=""/>
<tags xmi:uuid="mmuuid:04e21866-27d1-4dce-97c8-1752397765e0" key="PUT" value=""/>
</annotations>
<annotations xmi:uuid="mmuuid:644fed81-7224-4254-b1af-c493a5a9ef30" annotatedObject="mmuuid/2ef20d81-2b62-4833-8601-57150c6e2d65">
<tags xmi:uuid="mmuuid:6b921702-262d-488f-a77b-038c6faa9c3f" key="en_US" value="Rest Method"/>
</annotations>
<annotations xmi:uuid="mmuuid:d777e494-3b10-4a83-a666-7dd97efb187c" annotatedObject="mmuuid/2e54a763-40f5-404e-9b79-a1d0b2d85b95">
<tags xmi:uuid="mmuuid:587d9b18-5c05-4bf0-a11d-dad78ddc3a25" key="en_US" value="The REST method to map this procedure to. Supported methods are
				GET/PUT/POST/DELETE."/>
</annotations>
<annotations xmi:uuid="mmuuid:b7f3a9e7-cd2e-44d4-ba47-adbc2550548a" annotatedObject="mmuuid/4e94c7b7-888c-4c6d-817a-dfc4144d410a">
<tags xmi:uuid="mmuuid:4d64796a-7fc0-46a1-b6f8-e77d31012a26" key="advanced" value="false"/>
<tags xmi:uuid="mmuuid:b8ef1ddd-2795-4211-82bf-a9e1f36ca4e6" key="displayName" value=""/>
<tags xmi:uuid="mmuuid:c7a1d185-1322-41d8-b0c8-2efea8e66a2f" key="description" value=""/>
<tags xmi:uuid="mmuuid:890955fc-e3d5-431b-a17a-b609e13b4a88" key="id" value="URI"/>
<tags xmi:uuid="mmuuid:3a1bc563-cf68-4e04-84ea-1c053f90c544" key="index" value="true"/>
<tags xmi:uuid="mmuuid:85c55ae1-bceb-449e-ac82-242ffbba9157" key="modifiable" value="true"/>
<tags xmi:uuid="mmuuid:0b677681-e366-401c-b044-08d7eeb33f28" key="masked" value="false"/>
<tags xmi:uuid="mmuuid:5690ac0e-9dbd-4a61-b2ae-cbef400370bc" key="required" value="false"/>
<tags xmi:uuid="mmuuid:5f1f54ea-adf2-4657-a8d3-36eb06d461cd" key="runtimeType" value="string"/>
</annotations>
<annotations xmi:uuid="mmuuid:4d6a52b6-0f82-41c3-8894-fa51c90a76b8" annotatedObject="mmuuid/b8ef1ddd-2795-4211-82bf-a9e1f36ca4e6">
<tags xmi:uuid="mmuuid:8ba4ca1e-0b54-4733-8cef-52f5da6a1ac7" key="en_US" value="URI"/>
</annotations>
<annotations xmi:uuid="mmuuid:9f3198d2-a96a-4a2b-a6f2-ab4c1463a3eb" annotatedObject="mmuuid/c7a1d185-1322-41d8-b0c8-2efea8e66a2f">
<tags xmi:uuid="mmuuid:4f6fb91b-ac14-4dda-82af-1a423d473382" key="en_US" value="The relative URI to map this procedure to."/>
</annotations>
</mmcore:AnnotationContainer>
<relational:Procedure xmi:uuid="mmuuid:d3a847c2-36d6-4d8f-82ed-2a49ec5b50a0" name="iCare_P5_ProgNt_Proc">
<parameters xmi:uuid="mmuuid:f411bf30-06e1-450f-aa85-0b74289ea490" name="ProcProgNoteID" direction="OUT" length="4000" nullable="NULLABLE" radix="0">
<type href="http://www.w3.org/2001/XMLSchema#int"/>
</parameters>
<parameters xmi:uuid="mmuuid:a319ea77-59c9-4138-b93e-52ea62021af9" name="UserID_by" direction="OUT" length="4000" nullable="NULLABLE" radix="0">
<type href="http://www.w3.org/2001/XMLSchema#string"/>
</parameters>
<parameters xmi:uuid="mmuuid:cf5f7760-5912-4a9a-98ec-a2261a3a7aab" name="notetext" direction="OUT" length="90000" nullable="NULLABLE" radix="0">
<type href="http://www.w3.org/2001/XMLSchema#string"/>
</parameters>
<parameters xmi:uuid="mmuuid:7eeae5ce-31c3-4c72-ac88-dfb7abf63a96" name="datecreated" direction="OUT" length="4000" nullable="NULLABLE" radix="0">
<type href="http://www.w3.org/2001/XMLSchema#string"/>
</parameters>
<parameters xmi:uuid="mmuuid:496c4612-72df-415f-84a6-076960fe5e0b" name="admittedto" direction="OUT" length="4000" nullable="NULLABLE" radix="0">
<type href="http://www.w3.org/2001/XMLSchema#string"/>
</parameters>
<parameters xmi:uuid="mmuuid:7e46adb9-6ba8-4ac1-98a7-b1ec59720213" name="issystem" direction="OUT" nullable="NULLABLE">
<type href="http://www.w3.org/2001/XMLSchema#boolean"/>
</parameters>
<parameters xmi:uuid="mmuuid:9bd4cd57-2d0b-4a16-9bbe-e47b280c71be" name="NoteID" direction="OUT" nullable="NULLABLE">
<type href="http://www.w3.org/2001/XMLSchema#int"/>
</parameters>
<parameters xmi:uuid="mmuuid:296928ca-1919-4ec3-9779-a5ac84bf121b" name="CategoryID" direction="OUT" nullable="NULLABLE">
<type href="http://www.w3.org/2001/XMLSchema#int"/>
</parameters>
<parameters xmi:uuid="mmuuid:e56dd34f-2b3e-41df-a304-be6afeac3124" name="ReasonDel" direction="OUT" nullable="NULLABLE">
<type href="http://www.w3.org/2001/XMLSchema#string"/>
</parameters>
</relational:Procedure>
<transformation:TransformationContainer xmi:uuid="mmuuid:dad243f6-0f9e-40ff-a7c1-cf16c5cf6d20">
<transformationMappings xsi:type="transformation:SqlTransformationMappingRoot" xmi:uuid="mmuuid:f3350416-9d81-49a8-8c2a-c32180dce039" outputs="mmuuid/d3a847c2-36d6-4d8f-82ed-2a49ec5b50a0" target="mmuuid/d3a847c2-36d6-4d8f-82ed-2a49ec5b50a0">
<helper xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:09e3a56e-9b4b-4358-9638-729b8ce0e48f">
<nested xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:aa665159-3a41-40e2-8182-c2facd18668f" selectSql="CREATE VIRTUAL PROCEDURE
BEGIN
	LOOP ON (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl) AS @ProgNoteID
	BEGIN
		IF(@ProgNoteID.ProgNoteID > 0)
		BEGIN
			DECLARE string VARIABLES.@Namefirst = (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.NameFirst FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl WHERE iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID = @ProgNoteID.ProgNoteID);
			DECLARE string VARIABLES.@NameLast = (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.NameLast FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl WHERE iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID = @ProgNoteID.ProgNoteID);
			DECLARE string VARIABLES.@MedicareNumber = (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.MedicareNumber FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl WHERE iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID = @ProgNoteID.ProgNoteID);
			DECLARE string VARIABLES.@ReasonDeleted = (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ReasonDeleted FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl WHERE iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID = @ProgNoteID.ProgNoteID);
			DECLARE integer VARIABLES.@ltcPersonID = (SELECT P5_Model_ltcperson.ltcperson.ltcPersonID FROM P5_Model_ltcperson.ltcperson WHERE (P5_Model_ltcperson.ltcperson.FirstName = VARIABLES.@Namefirst) AND ((P5_Model_ltcperson.ltcperson.LastName = VARIABLES.@NameLast) AND (P5_Model_ltcperson.ltcperson.medicarenumber = VARIABLES.@MedicareNumber)));
			iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.ProcProgNoteID = VARIABLES.@ltcPersonID;
			iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.ReasonDel = VARIABLES.@ReasonDeleted;
			iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.notetext = (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.Note FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl WHERE iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID = @ProgNoteID.ProgNoteID);
			DECLARE string VARIABLES.@Notetext = iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.notetext;
			DECLARE integer VARIABLES.@userid = 1;
			DECLARE integer VARIABLES.@categoryid = 50;
			DECLARE integer VARIABLES.@notestatusid = 1;
			IF((VARIABLES.@ltcPersonID IS NOT NULL) AND (VARIABLES.@ReasonDeleted IS NULL) AND (VARIABLES.@Notetext IS NOT NULL))
			BEGIN
				EXEC P5_Model_proc_prognotes.proc_progressnotes_create(VARIABLES.@ltcPersonID, VARIABLES.@userid, VARIABLES.@categoryid, VARIABLES.@notestatusid, VARIABLES.@Notetext);
			END
			ELSE
			BEGIN
				IF((VARIABLES.@ltcPersonID IS NOT NULL) AND (VARIABLES.@ReasonDeleted IS NOT NULL) AND (VARIABLES.@Notetext IS NOT NULL))
				BEGIN
					EXEC P5_Model_proc_prognotes.proc_progressnotes_create(VARIABLES.@ltcPersonID, VARIABLES.@userid, VARIABLES.@categoryid, VARIABLES.@notestatusid, VARIABLES.@Notetext);
					iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.NoteID = (SELECT MAX(P5_Model_ltcpersonnotes.ltcpersonnotes.NoteID) FROM ltcpersonnotes);
					DECLARE integer VARIABLES.@NoteID = iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.NoteID;
					EXEC P5_Model_proc_prognotes.proc_progressnotes_markaserror(VARIABLES.@NoteID, VARIABLES.@userid, VARIABLES.@ReasonDeleted);
				END
				ELSE
				BEGIN
					RAISE SQLWARNING SQLEXCEPTION 'Patient names returned NULL or INVALID ProgNoteID';
					RAISE SQLWARNING SQLEXCEPTION VARIABLES.@Namefirst;
					RAISE SQLWARNING SQLEXCEPTION VARIABLES.@NameLast;
				END
			END
		END
	END
END"/>
<aliases xmi:uuid="mmuuid:37eaf2a6-0c69-41ac-8b5e-d734058fe5f6" alias="proc_progressnotes_markaserror">
<aliasedObject href="../P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi#mmuuid/02bb2f8a-0957-46c4-9277-33a2c531acdd"/>
</aliases>
<aliases xmi:uuid="mmuuid:ab8a3e84-15c0-4f6a-ab6e-481f0388af98" alias="ltcperson">
<aliasedObject href="../P5_IMPORTS/P5_TABLES/P5_ltcperson/P5_Model_ltcperson.xmi#mmuuid/407ffa5e-87a0-424c-a8ba-021fb22b8e87"/>
</aliases>
<aliases xmi:uuid="mmuuid:43b50b6c-acd2-4a28-98e8-e3218268138d" alias="iCare_ProgNotes_Tbl">
<aliasedObject href="../iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_ViewModel.xmi#mmuuid/2bebcebc-bff9-4b6e-b49b-9bb8f66582e7"/>
</aliases>
<aliases xmi:uuid="mmuuid:af8e8fd5-b3d3-43e5-adf0-3babcc172fdb" alias="proc_progressnotes_create">
<aliasedObject href="../P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi#mmuuid/6b7dc0d5-b90f-49e0-b883-ecfa89467af7"/>
</aliases>
<aliases xmi:uuid="mmuuid:dd1a7f94-a06a-47d7-bbf9-9b08eb4edddb" alias="ltcpersonnotes">
<aliasedObject href="../P5_IMPORTS/P5_TABLES/P5_ltcpersonnotes/P5_Model_ltcpersonnotes.xmi#mmuuid/166548af-07e4-4773-8bd6-2b75220e66d4"/>
</aliases>
</helper>
<inputs href="../P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi#mmuuid/02bb2f8a-0957-46c4-9277-33a2c531acdd"/>
<inputs href="../P5_IMPORTS/P5_TABLES/P5_ltcperson/P5_Model_ltcperson.xmi#mmuuid/407ffa5e-87a0-424c-a8ba-021fb22b8e87"/>
<inputs href="../iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_ViewModel.xmi#mmuuid/2bebcebc-bff9-4b6e-b49b-9bb8f66582e7"/>
<inputs href="../P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi#mmuuid/6b7dc0d5-b90f-49e0-b883-ecfa89467af7"/>
<inputs href="../P5_IMPORTS/P5_TABLES/P5_ltcpersonnotes/P5_Model_ltcpersonnotes.xmi#mmuuid/166548af-07e4-4773-8bd6-2b75220e66d4"/>
</transformationMappings>
</transformation:TransformationContainer>
</xmi:XMI>