Summary Table
Categories |
Total Count |
PII |
1 |
URL |
13 |
DNS |
1 |
EKL |
0 |
IP |
0 |
PORT |
0 |
VsID |
0 |
CF |
0 |
AI |
0 |
VPD |
0 |
PL |
0 |
Other |
0 |
File Content
?<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
DTS:refId="Package"
DTS:CreationDate="8/21/2017 3:12:14 PM"
DTS:CreationName="Microsoft.Package"
DTS:CreatorComputerName="
DNS
"
DTS:CreatorName="
PII
"
DTS:DTSID="{E5857108-E4BD-4395-BBA3-3260E3819595}"
DTS:ExecutableType="Microsoft.Package"
DTS:LastModifiedProductVersion="14.0.3002.113"
DTS:LocaleID="1033"
DTS:ObjectName="extConConsultLookUpTest"
DTS:PackageType="5"
DTS:ProtectionLevel="0"
DTS:VersionBuild="120"
DTS:VersionGUID="{B92117D4-6A8F-4877-8EED-A99AF53EA216}">
<DTS:Property
DTS:Name="PackageFormatVersion">8</DTS:Property>
<DTS:ConnectionManagers>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[Cache Connection Manager]"
DTS:CreationName="CACHE"
DTS:Description="zraw._con.consultlookuptest"
DTS:DTSID="{6CF13EFF-39CB-4DD1-B058-616E8536AF70}"
DTS:ObjectName="Cache Connection Manager">
<DTS:ObjectData>
<DTS:ConnectionManager>
<DTS:CacheColumns>
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="BatchLogID"
DTS:DTSID="{C25D4DA5-22E8-448E-85EC-1C8DFFA9EECC}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ClinicalProcedureIEN"
DTS:DTSID="{03A4A6F9-B443-4200-BCFD-AEF3481CFE1C}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ClinicalProcedureSID"
DTS:DTSID="{E20037FF-1D43-4F5A-9ACB-1EF775A48DA2}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ConsultIEN"
DTS:DTSID="{A6FB2E26-1DB8-4D3F-BF9B-06C710C86EA7}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ConsultPlaceProtocolIEN"
DTS:DTSID="{060FC755-0755-4D63-AD69-FF0512F3A52F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ConsultPlaceProtocolSID"
DTS:DTSID="{83BA47D3-B86F-4B9E-887E-2219BA54915F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:IndexPosition="1"
DTS:ObjectName="ConsultSID"
DTS:DTSID="{12C6B2DE-891B-4B3C-A210-D89295D462F2}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="CPRSOrderIEN"
DTS:DTSID="{76181AFF-8AB4-443D-B41A-70AF11BD3A65}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="CPRSOrderSID"
DTS:DTSID="{9CA5179A-7F2A-4438-8822-FF82FA2EC97F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="CPRSStatus"
DTS:DTSID="{F524CF59-7440-4CFF-99BE-C00FD658E22B}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="100"
DTS:CodePage="1252"
DTS:ObjectName="DisplayTextOfItemOrdered"
DTS:DTSID="{F12086CE-2FD0-45B4-A0FF-BC1AF3E1A7D8}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="133"
DTS:ObjectName="EarliestDate"
DTS:DTSID="{1733AF7F-2BE5-45DF-8BEE-506F6C09CD91}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="EarliestDateTransformSID"
DTS:DTSID="{A2E80146-E5AF-4B11-8ED3-D30F90C5C011}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="EarliestVistaErrorDate"
DTS:DTSID="{B5BC8915-B021-4E38-AA93-D3890572D48C}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ETLBatchID"
DTS:DTSID="{E244A357-C983-498B-9E36-17D5DA13E6D4}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="extractBatchID"
DTS:DTSID="{551C3C16-90FB-43F4-94C9-5B036672633B}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="304"
DTS:ObjectName="FileEntryDateTime"
DTS:DTSID="{91FDCBA1-F170-4FC0-AD74-C787BD38CB66}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="FileEntryDateTimeTransformSID"
DTS:DTSID="{6514551E-53F6-4A68-97A8-1B935455BE7D}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="FileEntryVistaErrorDate"
DTS:DTSID="{509B1030-477F-470A-BDA7-A39FA53DE7B6}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="FromLocationIEN"
DTS:DTSID="{E61CD91B-20DB-4DDC-8CA4-D828D9D5AFE7}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="FromLocationSID"
DTS:DTSID="{B994B56A-7BD1-4AE7-88EB-F4647A7AFE85}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="100"
DTS:CodePage="1252"
DTS:ObjectName="GMRCProcedure"
DTS:DTSID="{6B50D008-6833-40E9-816F-4C0B3334EFD0}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="GMRCProcedureIEN"
DTS:DTSID="{DF77F734-3DEA-437B-ADBA-E50B7F539BE6}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="GMRCProcedureSID"
DTS:DTSID="{E3C47761-53D7-45B9-AF3E-13C1EE7EE508}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="InpatOutpat"
DTS:DTSID="{66CF1592-F2EF-4FB9-B2E5-23E5810476D5}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="1"
DTS:CodePage="1252"
DTS:ObjectName="OpCode"
DTS:DTSID="{9D0717A0-F88F-4677-ABD5-6C30D4EC5E72}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="OrderingInstitutionIEN"
DTS:DTSID="{4CCD776D-CAF5-42EA-88FE-5E1C03D479A3}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="OrderingInstitutionSID"
DTS:DTSID="{C61F0B57-2333-4CA3-86E0-9677995C7249}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="2"
DTS:ObjectName="OrderingSta3n"
DTS:DTSID="{AC174FEA-F05A-4EB2-9711-8AE81113F934}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="OrderStatusIEN"
DTS:DTSID="{7ED75A4B-7B1E-4961-AE51-3FBFD7A98F5A}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="OrderStatusSID"
DTS:DTSID="{6BF83D0D-8B42-4329-9C9E-D18F3FCEAF92}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="PatientIEN"
DTS:DTSID="{87811C61-A224-487A-B903-92C5E18CFBEC}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="PatientLocationIEN"
DTS:DTSID="{7F5EDF79-5ABE-4720-A9F7-94F05D98B1BE}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="PatientLocationSID"
DTS:DTSID="{2C891166-90D4-4DDB-B079-40515D39447B}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="PatientSID"
DTS:DTSID="{104DDB5C-13C4-48C9-A5A6-E18A704E6214}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="PlaceOfConsultation"
DTS:DTSID="{C874882C-D52A-440D-9972-9191A9D5A60F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ProtocolIEN"
DTS:DTSID="{852ADF43-B2BC-4622-8D87-7C38B11EF6C1}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ProtocolSID"
DTS:DTSID="{42DC6CCD-6803-4A2C-BEB7-84753079FACF}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="255"
DTS:CodePage="1252"
DTS:ObjectName="ProvisionalDiagnosis"
DTS:DTSID="{6BD1995E-B4C4-40CC-9A4A-E7AD6B9CC438}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ProvisionalDiagnosisCode"
DTS:DTSID="{E0EAF0D4-A401-4BBC-88D0-2CF35FE5F7E7}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="100"
DTS:CodePage="1252"
DTS:ObjectName="RecentActivityType"
DTS:DTSID="{2D6FF809-5C0F-42FC-816C-2148D5F75D4E}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RecentActivityTypeIEN"
DTS:DTSID="{0127E690-E0BD-4C62-B691-16B5773BEDA3}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="RecentActivityTypeSID"
DTS:DTSID="{E4254D92-B707-41AA-81BA-34F3CA1506A8}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RemoteConsultIEN"
DTS:DTSID="{A3D1386E-879E-4ABE-83BC-6F380E9F01A4}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RemoteConsultInstitutionIEN"
DTS:DTSID="{A31256AE-6286-403A-8AAA-BA188F76B799}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="RemoteConsultInstitutionSID"
DTS:DTSID="{10606D5C-0294-45AF-B04A-37E3556F6246}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="RemoteConsultSID"
DTS:DTSID="{584D8487-BD67-4957-9374-EAC75FF03852}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RemoteConsultSta3n"
DTS:DTSID="{76D959DB-2E1D-4167-8906-D164C0243E2E}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RemoteRole"
DTS:DTSID="{D4D9FD0F-8E49-4048-B819-4F9588B76E47}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="100"
DTS:CodePage="1252"
DTS:ObjectName="RemoteService"
DTS:DTSID="{75D60673-06CD-4F21-81AA-98E09292021F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="RequestDateSID"
DTS:DTSID="{3A554A95-5EC9-46B5-9C74-0F67E0E111AE}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="304"
DTS:ObjectName="RequestDateTime"
DTS:DTSID="{11422DF7-0F72-4735-AD28-B56D5537792F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="RequestDateTimeTransformSID"
DTS:DTSID="{60850588-9F78-4717-8541-5F653BC57120}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RequestType"
DTS:DTSID="{F18C6019-451E-43BD-BF2C-C88E3F4BE836}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RequestVistaErrorDate"
DTS:DTSID="{61039A5E-B351-41DA-AB87-079EC6BEE290}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ResultIEN"
DTS:DTSID="{2B0F6985-CF88-4BCF-94E1-230BB6E59918}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ResultPointedToFileNumber"
DTS:DTSID="{EE50F779-5B39-49DA-81E7-E4AA946207A6}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="ResultSID"
DTS:DTSID="{35A7CD98-7310-42DA-8FC7-A15EE739DDEB}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="SendingStaffIEN"
DTS:DTSID="{7F9DB8B9-958C-481B-AF6E-3D1DE961D024}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="SendingStaffSID"
DTS:DTSID="{090B0318-FCF9-48CC-88D3-A0AEFE69DCCA}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="1"
DTS:CodePage="1252"
DTS:ObjectName="SignificantFindings"
DTS:DTSID="{75C6F6C1-F125-491C-B23C-A8B79B583EC7}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="2"
DTS:ObjectName="Sta3n"
DTS:DTSID="{86EAF7AE-ADE8-4091-B930-EB1C439EA5CF}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="TIUDocumentIEN"
DTS:DTSID="{C6D5EB85-84AB-441E-82D3-3E86EB24BB24}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="TIUDocumentSID"
DTS:DTSID="{1DBA62C8-3BC5-46DD-B077-2EF4D9AEAF63}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ToRequestServiceIEN"
DTS:DTSID="{459C5268-33E7-4E40-8A82-D78831346524}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="100"
DTS:CodePage="1252"
DTS:ObjectName="ToRequestServiceName"
DTS:DTSID="{2D0C08BB-0673-420A-9BAE-5E549AD1A2CA}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ToRequestServiceSID"
DTS:DTSID="{EF858644-69D2-496B-99F2-5EDB92D76CA0}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ToStaffIEN"
DTS:DTSID="{5C2BFA0D-CB59-459A-86D0-6C2E7D895F90}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ToStaffSID"
DTS:DTSID="{FBD68084-0433-4AE3-8DE7-54A73E15457C}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="Urgency"
DTS:DTSID="{B90EE2A0-331C-4DBD-8DD3-9127D0804F88}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="UrgencyProtocolIEN"
DTS:DTSID="{65695F9A-F9EA-4BCE-BD05-112B86620829}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="UrgencyProtocolSID"
DTS:DTSID="{0A64079B-C181-4111-BF7A-A059651F6FE9}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="135"
DTS:ObjectName="VistaCreateDate"
DTS:DTSID="{F829154A-6556-427F-AD9F-08A8BCD0FD8D}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="135"
DTS:ObjectName="VistaEditDate"
DTS:DTSID="{093E815F-6112-4E97-9C5F-DE7406C68D73}"
DTS:CreationName="" />
</DTS:CacheColumns>
</DTS:ConnectionManager>
</DTS:ObjectData>
</DTS:ConnectionManager>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[Cache Connection Manager 1]"
DTS:CreationName="CACHE"
DTS:DTSID="{04B31E60-25A1-43E5-B645-0E9282DD66DB}"
DTS:ObjectName="Cache Connection Manager 1">
<DTS:ObjectData>
<DTS:ConnectionManager>
<DTS:CacheColumns>
<DTS:CacheColumn
DTS:DataType="20"
DTS:IndexPosition="1"
DTS:ObjectName="ConsultSID"
DTS:DTSID="{495F199F-FAA1-4A39-BE3B-1B9B2943A263}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ConsultIEN"
DTS:DTSID="{86B06526-250D-49D7-9F6B-0E1CE9486900}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="2"
DTS:ObjectName="Sta3n"
DTS:DTSID="{F1006161-C0B7-4B2F-91E9-11F82EC5920E}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="PatientSID"
DTS:DTSID="{729A0508-5D41-417C-97EC-04EA90A7392E}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="PatientLocationSID"
DTS:DTSID="{3C38230D-947E-4A64-9B4C-28984A7FC10F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ProtocolSID"
DTS:DTSID="{18871758-D8EB-4332-9DD4-3B1A8BB55CB4}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="GMRCProcedureSID"
DTS:DTSID="{09BE5DE3-45C9-4346-938E-167B61B0B80B}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="100"
DTS:CodePage="1252"
DTS:ObjectName="GMRCProcedure"
DTS:DTSID="{6072C41D-2010-4280-B9CA-3AFD2E5F0596}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ClinicalProcedureSID"
DTS:DTSID="{6C3599B1-C3BA-4BF5-BBEC-B13CBBF47B68}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ToRequestServiceSID"
DTS:DTSID="{C3698380-87F0-4198-823E-11771C25BC97}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="100"
DTS:CodePage="1252"
DTS:ObjectName="ToRequestServiceName"
DTS:DTSID="{0D94A940-845A-4E2D-A2CC-A94678E5D3C3}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="304"
DTS:ObjectName="RequestDateTime"
DTS:DTSID="{64E96B6D-4641-4B43-BFE0-1B2FF56EDF81}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RequestVistaErrorDate"
DTS:DTSID="{37F7F6CA-2CA2-45C7-BB61-D4DFF292FEFF}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="RequestDateTimeTransformSID"
DTS:DTSID="{99DFD6B7-4FA5-4A4C-91C5-C6F2326B9EB3}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="RequestDateSID"
DTS:DTSID="{27D5BD54-C033-4D36-B25F-F675CC57F77F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="304"
DTS:ObjectName="FileEntryDateTime"
DTS:DTSID="{77986CE4-BB75-4426-A7A2-619E1C10D522}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="FileEntryVistaErrorDate"
DTS:DTSID="{7586A027-3E22-41B2-86BD-BB59F3ACE11B}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="FileEntryDateTimeTransformSID"
DTS:DTSID="{4910C30A-3033-4C95-956B-3FF3FCF50134}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="FromLocationSID"
DTS:DTSID="{4E93228E-E43A-4A75-B962-098CC1A380AD}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RequestType"
DTS:DTSID="{B238230C-9FAC-44BC-9341-DC399CF1F231}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ToStaffSID"
DTS:DTSID="{B9240DB2-8580-46FA-B9C1-25FA7519E4A3}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="OrderStatusSID"
DTS:DTSID="{53DE4D1D-4E86-4DE0-B5D1-0474CA4B3D44}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="CPRSOrderSID"
DTS:DTSID="{7B0DC90A-2A62-4062-B181-BAFC53457E36}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="CPRSStatus"
DTS:DTSID="{8A5EAB18-E09E-452B-BFF1-760EFD7BF1B3}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="RecentActivityTypeSID"
DTS:DTSID="{12AB01E1-D61C-450E-8FD5-13D69C18B498}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="100"
DTS:CodePage="1252"
DTS:ObjectName="RecentActivityType"
DTS:DTSID="{19C2C34D-D906-4803-BD6C-B2803FF2A78F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="SendingStaffSID"
DTS:DTSID="{6014F577-0404-4628-BFEC-70F9DCF2353F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="1"
DTS:CodePage="1252"
DTS:ObjectName="SignificantFindings"
DTS:DTSID="{A5D57739-C63C-4D0B-9413-43B884846F1C}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="UrgencyProtocolSID"
DTS:DTSID="{0A3A1499-36E6-47BF-909D-340E6301469F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="Urgency"
DTS:DTSID="{352D2E62-20D5-497A-BF9B-EFFBEB90F849}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ConsultPlaceProtocolSID"
DTS:DTSID="{589F393B-DADA-4D63-9B4F-1200ED6DF169}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="PlaceOfConsultation"
DTS:DTSID="{71620ECC-A36A-484C-B945-81662BA7714D}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="100"
DTS:CodePage="1252"
DTS:ObjectName="DisplayTextOfItemOrdered"
DTS:DTSID="{0F926761-E42A-4A5B-9192-BC515EA0EF6D}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="OrderingInstitutionSID"
DTS:DTSID="{8D4CA502-BE7A-4A9C-90DB-6ACF06B2DD2F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="2"
DTS:ObjectName="OrderingSta3n"
DTS:DTSID="{5A7D7A92-5468-42DF-9789-BAEC4EAD485F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="InpatOutpat"
DTS:DTSID="{374C2660-6D33-4A1E-99F2-D416799506FE}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="255"
DTS:CodePage="1252"
DTS:ObjectName="ProvisionalDiagnosis"
DTS:DTSID="{B39BDDD9-BEF3-4256-B4E7-11D71A640B72}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ProvisionalDiagnosisCode"
DTS:DTSID="{FCDA5024-962B-41F6-B7FE-24B5E6F9501B}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RemoteRole"
DTS:DTSID="{CF2E2C88-6C06-471E-8ECF-83619B3A6975}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="100"
DTS:CodePage="1252"
DTS:ObjectName="RemoteService"
DTS:DTSID="{A63DD4C8-3E7B-46F3-A896-95354F7AA891}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="RemoteConsultInstitutionSID"
DTS:DTSID="{9B89244B-ECB0-45B6-A1AF-CA342D17B861}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RemoteConsultSta3n"
DTS:DTSID="{A11D8E9B-D0C7-4591-8F51-E17297DC65FD}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="RemoteConsultSID"
DTS:DTSID="{E5573ABD-560C-4179-AD39-0A9FD8DD2A46}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="TIUDocumentSID"
DTS:DTSID="{49DF6CED-5EB8-4A40-9FB6-FBF89CE04892}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="133"
DTS:ObjectName="EarliestDate"
DTS:DTSID="{D8A36E82-A510-4299-AF35-24C1078B9D77}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="EarliestVistaErrorDate"
DTS:DTSID="{95315D64-AEDD-4BBC-941E-068A08237477}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="EarliestDateTransformSID"
DTS:DTSID="{C316D35F-F03B-4C7A-AA7A-283C237150D6}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ClinicalProcedureIEN"
DTS:DTSID="{C87FBA71-B4CE-4D5E-8ABF-CAE8BCB5309A}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ConsultPlaceProtocolIEN"
DTS:DTSID="{049E5439-6D9D-4C0E-BA18-999321B28A37}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="CPRSOrderIEN"
DTS:DTSID="{F1C6079A-AC40-42C9-A526-91A6632CDBD2}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="FromLocationIEN"
DTS:DTSID="{4D95E6C9-951C-4442-91AD-1028523A8201}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="GMRCProcedureIEN"
DTS:DTSID="{A9D153D0-06C6-4B6A-B4E2-3F4F01AF8C82}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="OrderingInstitutionIEN"
DTS:DTSID="{49802A0A-7A62-4EF4-9673-BA7B5171F50D}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="OrderStatusIEN"
DTS:DTSID="{2F9FB03E-9617-49A6-B00A-D585E3644FF9}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="PatientIEN"
DTS:DTSID="{5CE6844D-458E-4CF2-966B-82A36B2A0D02}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="PatientLocationIEN"
DTS:DTSID="{1DE4E17E-0B17-4E2C-ABC1-BEEB7C20A2DF}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ProtocolIEN"
DTS:DTSID="{94C4E76E-B925-4717-A09B-82ABFA8F504F}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RecentActivityTypeIEN"
DTS:DTSID="{F812B52C-9CCA-4014-A3D9-0515FE140762}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RemoteConsultIEN"
DTS:DTSID="{0892F4FB-A011-42F0-8340-D35B3D7B84EB}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="RemoteConsultInstitutionIEN"
DTS:DTSID="{17093193-7406-476A-B733-7A4391802C08}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="SendingStaffIEN"
DTS:DTSID="{16A20D4B-56CA-42FD-B4A7-E1E20B3A9EF5}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="TIUDocumentIEN"
DTS:DTSID="{4E08D97D-BC43-4FD3-844B-2D8A0EC9D857}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ToRequestServiceIEN"
DTS:DTSID="{00EA4A83-78F5-4C0B-BDA2-581FB92295A1}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ToStaffIEN"
DTS:DTSID="{C56CCA2F-4E41-4F5D-BE78-7E1A7455AF1B}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="UrgencyProtocolIEN"
DTS:DTSID="{841E2A1A-D0F0-430D-8467-A9E5A0D0DEB9}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ResultIEN"
DTS:DTSID="{79DF8FB8-C144-4028-9CF5-2F7BDCAA92A4}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="ResultSID"
DTS:DTSID="{4AB5B223-F3AA-4A2E-8FEF-86F24CF3D391}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ResultPointedToFileNumber"
DTS:DTSID="{CEB62386-ECA0-49F3-8948-EA44EA75B7FA}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:ObjectName="ETLBatchID"
DTS:DTSID="{DFECF6C6-9B4D-4542-BB4D-A30B021E7AA7}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="1"
DTS:CodePage="1252"
DTS:ObjectName="OpCode"
DTS:DTSID="{9885DAF4-0382-4C00-8A08-C9115F864BE8}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="135"
DTS:ObjectName="VistaCreateDate"
DTS:DTSID="{93A4F5BF-31DD-442A-9C58-C7AD12FAC422}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="135"
DTS:ObjectName="VistaEditDate"
DTS:DTSID="{0EDFB720-7952-454C-8645-198B12C664DE}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="extractBatchID"
DTS:DTSID="{A30DCBC1-6C1E-44AC-8D85-EE52E6B8A929}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="20"
DTS:ObjectName="BatchLogID"
DTS:DTSID="{C5032163-3EBD-4C01-BBFE-E93C86874BB7}"
DTS:CreationName="" />
</DTS:CacheColumns>
</DTS:ConnectionManager>
</DTS:ObjectData>
</DTS:ConnectionManager>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[Cache Connection Manager 2]"
DTS:CreationName="CACHE"
DTS:Description="cache.Locations"
DTS:DTSID="{B80BDBAE-D4EE-4B97-B0E2-1D738177011C}"
DTS:ObjectName="Cache Connection Manager 2">
<DTS:ObjectData>
<DTS:ConnectionManager>
<DTS:CacheColumns>
<DTS:CacheColumn
DTS:DataType="3"
DTS:IndexPosition="1"
DTS:ObjectName="patientlocationsid"
DTS:DTSID="{5A7A5CAA-EAA5-405E-A922-2698ACC1C62B}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="3"
DTS:IndexPosition="2"
DTS:ObjectName="fromlocationsid"
DTS:DTSID="{0A33BEF9-E8F1-4BCF-984A-2FE771E5D815}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="ploc"
DTS:DTSID="{0B2A3554-0DBB-4708-B632-2CE8D988FA50}"
DTS:CreationName="" />
<DTS:CacheColumn
DTS:DataType="129"
DTS:Length="50"
DTS:CodePage="1252"
DTS:ObjectName="floc"
DTS:DTSID="{245FA1BB-E28C-43CF-94AA-46DFF2F3F9C2}"
DTS:CreationName="" />
</DTS:CacheColumns>
</DTS:ConnectionManager>
</DTS:ObjectData>
</DTS:ConnectionManager>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[EPRS_Shadow_OLEDB]"
DTS:CreationName="OLEDB"
DTS:DTSID="{EFCA6BDA-23D7-4920-8669-EFBF02AF44AC}"
DTS:ObjectName="EPRS_Shadow_OLEDB">
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:ConnectionString="Data Source=
URL
;Initial Catalog=EPRS_Shadow;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" />
</DTS:ObjectData>
</DTS:ConnectionManager>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[
URL
.CBOPC_EPRS]"
DTS:CreationName="OLEDB"
DTS:DTSID="{C665217A-8CCA-447D-98D3-A0048536CC91}"
DTS:ObjectName="
URL
.CBOPC_EPRS">
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:ConnectionString="Data Source=
URL
;Initial Catalog=CBOPC_EPRS;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" />
</DTS:ObjectData>
</DTS:ConnectionManager>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[
URL
.SPV]"
DTS:CreationName="OLEDB"
DTS:DTSID="{1B52085F-0A52-4735-8C24-994ABEFECF72}"
DTS:ObjectName="
URL
.SPV">
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:ConnectionString="Data Source=
URL
;Initial Catalog=SPV;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" />
</DTS:ObjectData>
</DTS:ConnectionManager>
</DTS:ConnectionManagers>
<DTS:Variables>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{35FCB8B8-DC58-451C-80DD-FDD444EFD8EE}"
DTS:IncludeInDebugDump="6789"
DTS:Namespace="User"
DTS:ObjectName="batchLogId">
<DTS:VariableValue
DTS:DataType="20">0</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{4D13F925-C12D-4C74-90CC-D316B82C9704}"
DTS:IncludeInDebugDump="6789"
DTS:Namespace="User"
DTS:ObjectName="batchRecordCount">
<DTS:VariableValue
DTS:DataType="20">0</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{5CA6FF2F-0B84-47CD-A1AE-C13CDA87876A}"
DTS:IncludeInDebugDump="2345"
DTS:Namespace="User"
DTS:ObjectName="filePathName">
<DTS:VariableValue
DTS:DataType="8"
xml:space="preserve"></DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{A6A870E4-19FA-47C2-ACAB-13B786E33A8E}"
DTS:IncludeInDebugDump="2345"
DTS:Namespace="User"
DTS:ObjectName="loadStatusComplete">
<DTS:VariableValue
DTS:DataType="8">EXTCOMPLETE</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{211B3A4B-68F7-48EB-9A46-476FD3C9CA6C}"
DTS:IncludeInDebugDump="2345"
DTS:Namespace="User"
DTS:ObjectName="loadStatusError">
<DTS:VariableValue
DTS:DataType="8">EXTERROR</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{62010831-EC19-4D02-8FE9-B65EB1E1F49C}"
DTS:IncludeInDebugDump="6789"
DTS:Namespace="User"
DTS:ObjectName="maxSourceBatchNumber">
<DTS:VariableValue
DTS:DataType="20">0</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{0855C7A2-017B-4657-9164-AB85BABC8577}"
DTS:IncludeInDebugDump="6789"
DTS:Namespace="User"
DTS:ObjectName="priorSourceBatchNumber">
<DTS:VariableValue
DTS:DataType="20">0</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{40E8FF35-0653-4151-9838-4740A5DBAA46}"
DTS:IncludeInDebugDump="2345"
DTS:Namespace="User"
DTS:ObjectName="rawTableName">
<DTS:VariableValue
DTS:DataType="8">zraw._conConsultUMMetric</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{F095F76B-402B-44C9-8DBE-F4C3E7B5FC83}"
DTS:IncludeInDebugDump="6789"
DTS:Namespace="User"
DTS:ObjectName="resultOK">
<DTS:VariableValue
DTS:DataType="3">0</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{BB003C12-C713-41F6-9CA1-E98435083BE4}"
DTS:IncludeInDebugDump="2345"
DTS:Namespace="User"
DTS:ObjectName="sourceTableName">
<DTS:VariableValue
DTS:DataType="8">con.Consult</DTS:VariableValue>
</DTS:Variable>
</DTS:Variables>
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Do Delete Raw for BatchLogID in case of existing recs for that batch"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{3869CBDB-A860-408C-BDC7-60B4C6E081CA}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Do Delete Raw for BatchLogID in case of existing recs for that batch"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{2322488E-4270-4638-A0DA-53D21A13C0C8}"
SQLTask:SqlStatementSource="EXEC zraw.uspDoDeleteRaw @batchLogId, @rawTableName, @resultOK OUTPUT;"
SQLTask:ResultType="ResultSetType_SingleRow" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ResultBinding
SQLTask:ResultName="0"
SQLTask:DtsVariableName="User::resultOK" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@rawTableName"
SQLTask:DtsVariableName="User::rawTableName"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@resultOK"
SQLTask:DtsVariableName="User::resultOK"
SQLTask:ParameterDirection="Output"
SQLTask:DataType="11"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Get Max Source Batch ID and Batch Count (remember to change the hard-coded table name)"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{4A715B55-C62E-442F-B024-F864F1BFFCFF}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Get Max Source Batch ID and Batch Count (remember to change the hard-coded table name)"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{2322488E-4270-4638-A0DA-53D21A13C0C8}"
SQLTask:SqlStatementSource="SELECT IsNull(COUNT(1), 0) AS BatchRecordCount, 
IsNull(MAX(ExtractBatchID), 0) AS MaxSourceBatchNumber 
FROM zraw._conConsultUMMetric

WHERE BatchLogID = @batchLogId

--May need to swap out the second field based on these rules:

--1. if there is an ExtractBatchID, then subtitute the 0 above with 
	--IsNull(MAX(ExtractBatchID), 0) AS MaxSourceBatchNumber
--2. if there is no ExtractBatchID from source, then substitute the field in #1 with
	--0 AS MaxSourceBatchNumber"
SQLTask:ResultType="ResultSetType_SingleRow" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ResultBinding
SQLTask:ResultName="1"
SQLTask:DtsVariableName="User::maxSourceBatchNumber" />
<SQLTask:ResultBinding
SQLTask:ResultName="0"
SQLTask:DtsVariableName="User::batchRecordCount" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Lookup Transformation Cache"
DTS:CreationName="STOCK:SEQUENCE"
DTS:Description="Sequence Container"
DTS:DTSID="{425410b2-fda8-4632-9fff-6167082cea3c}"
DTS:ExecutableType="STOCK:SEQUENCE"
DTS:LocaleID="-1"
DTS:ObjectName="Lookup Transformation Cache">
<DTS:Variables />
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination"
DTS:CreationName="Microsoft.Pipeline"
DTS:Description="Data Flow Task"
DTS:DTSID="{a76b223d-7c03-41ef-95d6-7e489473705e}"
DTS:ExecutableType="Microsoft.Pipeline"
DTS:LocaleID="-1"
DTS:ObjectName="* Get Data From Source And Send To Raw Table Destination"
DTS:TaskContact="Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1">
<DTS:Variables />
<DTS:ObjectData>
<pipeline
version="1">
<components>
<component
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column"
componentClassID="Microsoft.DerivedColumn"
contactInfo="Derived Column;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0"
description="Creates new column values by applying expressions to transformation input columns. Create new columns or overwrite existing ones. For example, concatenate the values from the 'first name' and 'last name' column to make a 'full name' column."
name="Add BatchlogID as derived column"
usesDispositions="true">
<inputs>
<input
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Inputs[Derived Column Input]"
description="Input to the Derived Column Transformation"
name="Derived Column Input">
<externalMetadataColumns />
</input>
</inputs>
<outputs>
<output
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Outputs[Derived Column Output]"
description="Default Output of the Derived Column Transformation"
exclusionGroup="1"
name="Derived Column Output"
synchronousInputId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Inputs[Derived Column Input]">
<outputColumns>
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Outputs[Derived Column Output].Columns[BatchLogID]"
dataType="i8"
errorOrTruncationOperation="Computation"
errorRowDisposition="FailComponent"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Outputs[Derived Column Output].Columns[BatchLogID]"
name="BatchLogID"
truncationRowDisposition="FailComponent">
<properties>
<property
containsID="true"
dataType="System.String"
description="Derived Column Expression"
name="Expression">@[User::batchLogId]</property>
<property
containsID="true"
dataType="System.String"
description="Derived Column Friendly Expression"
expressionType="Notify"
name="FriendlyExpression">@[User::batchLogId]</property>
</properties>
</outputColumn>
</outputColumns>
<externalMetadataColumns />
</output>
<output
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Outputs[Derived Column Error Output]"
description="Error Output of the Derived Column Transformation"
exclusionGroup="1"
isErrorOut="true"
name="Derived Column Error Output"
synchronousInputId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Inputs[Derived Column Input]">
<outputColumns>
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Outputs[Derived Column Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Outputs[Derived Column Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
<component
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup"
componentClassID="Microsoft.Lookup"
contactInfo="Lookup;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;6"
description="Joins additional columns to the data flow by looking up values in a table. For example, join to the 'employee id' column the employees table to get 'hire date' and 'employee name'. We recommend this transformation when the lookup table can fit into memory."
name="Lookup"
usesDispositions="true"
version="6">
<properties>
<property
dataType="System.String"
description="Specifies the SQL statement that generates the lookup table."
expressionType="Notify"
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property>
<property
dataType="System.String"
description="Specifies a SQL statement that uses parameters to generate the lookup table."
expressionType="Notify"
name="SqlCommandParam"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91">select * from () [refTable]
where [refTable].[patientlocationsid] = ? and [refTable].[fromlocationsid] = ?</property>
<property
dataType="System.Int32"
description="Specifies the type of connection used to access the reference dataset."
name="ConnectionType"
typeConverter="LookupConnectionType">1</property>
<property
dataType="System.Int32"
description="Specifies the cache type of the lookup table."
name="CacheType"
typeConverter="CacheType">0</property>
<property
dataType="System.Int32"
description="Specifies how the Lookup transformation handles rows without matching entries in the reference data set."
name="NoMatchBehavior"
typeConverter="LookupNoMatchBehavior">0</property>
<property
dataType="System.Int32"
description="Specifies the percentage of the cache that is allocated for rows with no matching entries in the reference dataset."
name="NoMatchCachePercentage">0</property>
<property
dataType="System.Int32"
description="Maximum Memory Usage for Reference Cache on a 32 bit platform."
name="MaxMemoryUsage">25</property>
<property
dataType="System.Int64"
description="Maximum Memory Usage for Reference Cache on a 64 bit platform."
name="MaxMemoryUsage64">25</property>
<property
dataType="System.String"
description="Indicates whether to reference metadata in an XML format."
name="ReferenceMetadataXml"><referenceMetadata><referenceColumns><referenceColumn name="patientlocationsid" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="fromlocationsid" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="ploc" dataType="DT_STR" length="50" precision="0" scale="0" codePage="1252"/><referenceColumn name="floc" dataType="DT_STR" length="50" precision="0" scale="0" codePage="1252"/></referenceColumns></referenceMetadata></property>
<property
containsID="true"
dataType="System.String"
description="Specifies the list of lineage identifiers that map to the parameters that the SQL statement in the SQLCommand property uses. Entries in the list are separated by semicolons."
name="ParameterMap">#{Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationSID]};#{Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationSID]};</property>
<property
dataType="System.Int32"
description="Specifies the column code page to use when code page information is unavailable from the data source."
name="DefaultCodePage">1252</property>
<property
dataType="System.Boolean"
description="Determines whether duplicate keys in the reference data should be treated as errors when full cache mode is used."
name="TreatDuplicateKeysAsError">false</property>
</properties>
<connections>
<connection
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Connections[CacheConnection]"
connectionManagerID="Package.ConnectionManagers[Cache Connection Manager 2]"
connectionManagerRefId="Package.ConnectionManagers[Cache Connection Manager 2]"
description="Connection manager used to access lookup data."
name="CacheConnection" />
</connections>
<inputs>
<input
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Inputs[Lookup Input]"
name="Lookup Input">
<inputColumns>
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Inputs[Lookup Input].Columns[PatientLocationSID]"
cachedDataType="i4"
cachedName="PatientLocationSID"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationSID]">
<properties>
<property
dataType="System.String"
description="Specifies the column in the reference table that a column joins."
name="JoinToReferenceColumn">patientlocationsid</property>
<property
dataType="System.Null"
description="Specifies the column in the reference table from which a column is copied."
name="CopyFromReferenceColumn" />
</properties>
</inputColumn>
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Inputs[Lookup Input].Columns[FromLocationSID]"
cachedDataType="i4"
cachedName="FromLocationSID"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationSID]">
<properties>
<property
dataType="System.String"
description="Specifies the column in the reference table that a column joins."
name="JoinToReferenceColumn">fromlocationsid</property>
<property
dataType="System.Null"
description="Specifies the column in the reference table from which a column is copied."
name="CopyFromReferenceColumn" />
</properties>
</inputColumn>
</inputColumns>
<externalMetadataColumns />
</input>
</inputs>
<outputs>
<output
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Match Output]"
errorOrTruncationOperation="Lookup"
errorRowDisposition="IgnoreFailure"
exclusionGroup="1"
name="Lookup Match Output"
synchronousInputId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Inputs[Lookup Input]">
<outputColumns>
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Match Output].Columns[ploc]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Copy Column"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Match Output].Columns[ploc]"
name="ploc"
truncationRowDisposition="IgnoreFailure">
<properties>
<property
dataType="System.String"
description="Specifies the column in the reference table from which a column is copied."
name="CopyFromReferenceColumn">ploc</property>
</properties>
</outputColumn>
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Match Output].Columns[floc]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Copy Column"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Match Output].Columns[floc]"
name="floc"
truncationRowDisposition="IgnoreFailure">
<properties>
<property
dataType="System.String"
description="Specifies the column in the reference table from which a column is copied."
name="CopyFromReferenceColumn">floc</property>
</properties>
</outputColumn>
</outputColumns>
<externalMetadataColumns />
</output>
<output
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup No Match Output]"
description="The Lookup output that handles rows with no matching entries in the reference dataset. Use this output when the NoMatchBehavior property is set to "Send rows with no matching entries to the no match output.""
exclusionGroup="1"
name="Lookup No Match Output"
synchronousInputId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Inputs[Lookup Input]">
<externalMetadataColumns />
</output>
<output
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Error Output]"
exclusionGroup="1"
isErrorOut="true"
name="Lookup Error Output"
synchronousInputId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Inputs[Lookup Input]">
<outputColumns>
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
<component
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination"
componentClassID="Microsoft.OLEDBDestination"
contactInfo="OLE DB Destination;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4"
description="OLE DB Destination"
name="OLE DB Destination"
usesDispositions="true"
version="4">
<properties>
<property
dataType="System.Int32"
description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out."
name="CommandTimeout">0</property>
<property
dataType="System.String"
description="Specifies the name of the database object used to open a rowset."
name="OpenRowset">[zraw].[_conConsultLookuptest]</property>
<property
dataType="System.String"
description="Specifies the variable that contains the name of the database object used to open a rowset."
name="OpenRowsetVariable"></property>
<property
dataType="System.String"
description="The SQL command to be executed."
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property>
<property
dataType="System.Int32"
description="Specifies the column code page to use when code page information is unavailable from the data source."
name="DefaultCodePage">1252</property>
<property
dataType="System.Boolean"
description="Forces the use of the DefaultCodePage property value when describing character data."
name="AlwaysUseDefaultCodePage">false</property>
<property
dataType="System.Int32"
description="Specifies the mode used to access the database."
name="AccessMode"
typeConverter="AccessMode">3</property>
<property
dataType="System.Boolean"
description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on."
name="FastLoadKeepIdentity">false</property>
<property
dataType="System.Boolean"
description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destination. Applies only if fast load is turned on."
name="FastLoadKeepNulls">true</property>
<property
dataType="System.String"
description="Specifies options to be used with fast load. Applies only if fast load is turned on."
name="FastLoadOptions">CHECK_CONSTRAINTS</property>
<property
dataType="System.Int32"
description="Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on."
name="FastLoadMaxInsertCommitSize">2147483647</property>
</properties>
<connections>
<connection
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Connections[OleDbConnection]"
connectionManagerID="Package.ConnectionManagers[
URL
.CBOPC_EPRS]"
connectionManagerRefId="Package.ConnectionManagers[
URL
.CBOPC_EPRS]"
description="The OLE DB runtime connection used to access the database."
name="OleDbConnection" />
</connections>
<inputs>
<input
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input]"
errorOrTruncationOperation="Insert"
errorRowDisposition="FailComponent"
hasSideEffects="true"
name="OLE DB Destination Input">
<inputColumns>
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ETLBatchID]"
cachedDataType="i8"
cachedName="ETLBatchID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ETLBatchID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ETLBatchID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ConsultSID]"
cachedDataType="i8"
cachedName="ConsultSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ConsultIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ConsultIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[Sta3n]"
cachedDataType="i2"
cachedName="Sta3n"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Sta3n]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[Sta3n]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[PatientSID]"
cachedDataType="i4"
cachedName="PatientSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[PatientLocationSID]"
cachedDataType="i4"
cachedName="PatientLocationSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientLocationSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ProtocolSID]"
cachedDataType="i4"
cachedName="ProtocolSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProtocolSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[GMRCProcedureSID]"
cachedDataType="i4"
cachedName="GMRCProcedureSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedureSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[GMRCProcedure]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="100"
cachedName="GMRCProcedure"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedure]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedure]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ClinicalProcedureSID]"
cachedDataType="i4"
cachedName="ClinicalProcedureSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ClinicalProcedureSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ToRequestServiceSID]"
cachedDataType="i4"
cachedName="ToRequestServiceSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ToRequestServiceName]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="100"
cachedName="ToRequestServiceName"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceName]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceName]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RequestDateTime]"
cachedDataType="dbTimeStamp2"
cachedName="RequestDateTime"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateTime]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTime]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RequestVistaErrorDate]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RequestVistaErrorDate"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestVistaErrorDate]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestVistaErrorDate]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RequestDateTimeTransformSID]"
cachedDataType="i8"
cachedName="RequestDateTimeTransformSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateTimeTransformSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTimeTransformSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RequestDateSID]"
cachedDataType="i4"
cachedName="RequestDateSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[FileEntryDateTime]"
cachedDataType="dbTimeStamp2"
cachedName="FileEntryDateTime"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryDateTime]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTime]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[FileEntryVistaErrorDate]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="FileEntryVistaErrorDate"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryVistaErrorDate]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryVistaErrorDate]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[FileEntryDateTimeTransformSID]"
cachedDataType="i8"
cachedName="FileEntryDateTimeTransformSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryDateTimeTransformSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTimeTransformSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[FromLocationSID]"
cachedDataType="i4"
cachedName="FromLocationSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FromLocationSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RequestType]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RequestType"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestType]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestType]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ToStaffSID]"
cachedDataType="i4"
cachedName="ToStaffSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToStaffSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OrderStatusSID]"
cachedDataType="i4"
cachedName="OrderStatusSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderStatusSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[CPRSOrderSID]"
cachedDataType="i8"
cachedName="CPRSOrderSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSOrderSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[CPRSStatus]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="CPRSStatus"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSStatus]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSStatus]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RecentActivityTypeSID]"
cachedDataType="i4"
cachedName="RecentActivityTypeSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityTypeSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RecentActivityType]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="100"
cachedName="RecentActivityType"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityType]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityType]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[SendingStaffSID]"
cachedDataType="i4"
cachedName="SendingStaffSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SendingStaffSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[SignificantFindings]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="1"
cachedName="SignificantFindings"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SignificantFindings]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[SignificantFindings]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[UrgencyProtocolSID]"
cachedDataType="i4"
cachedName="UrgencyProtocolSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[UrgencyProtocolSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[Urgency]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="Urgency"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Urgency]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[Urgency]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ConsultPlaceProtocolSID]"
cachedDataType="i4"
cachedName="ConsultPlaceProtocolSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultPlaceProtocolSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[PlaceOfConsultation]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="PlaceOfConsultation"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PlaceOfConsultation]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PlaceOfConsultation]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[DisplayTextOfItemOrdered]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="100"
cachedName="DisplayTextOfItemOrdered"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[DisplayTextOfItemOrdered]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[DisplayTextOfItemOrdered]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OrderingInstitutionSID]"
cachedDataType="i4"
cachedName="OrderingInstitutionSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingInstitutionSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OrderingSta3n]"
cachedDataType="i2"
cachedName="OrderingSta3n"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingSta3n]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingSta3n]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[InpatOutpat]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="InpatOutpat"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[InpatOutpat]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[InpatOutpat]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ProvisionalDiagnosis]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="255"
cachedName="ProvisionalDiagnosis"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProvisionalDiagnosis]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosis]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ProvisionalDiagnosisCode]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ProvisionalDiagnosisCode"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProvisionalDiagnosisCode]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosisCode]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteRole]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RemoteRole"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteRole]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteRole]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteService]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="100"
cachedName="RemoteService"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteService]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteService]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteConsultInstitutionSID]"
cachedDataType="i4"
cachedName="RemoteConsultInstitutionSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultInstitutionSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteConsultSta3n]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RemoteConsultSta3n"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultSta3n]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSta3n]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteConsultSID]"
cachedDataType="i8"
cachedName="RemoteConsultSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[TIUDocumentSID]"
cachedDataType="i8"
cachedName="TIUDocumentSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[TIUDocumentSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[EarliestDate]"
cachedDataType="dbDate"
cachedName="EarliestDate"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestDate]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDate]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[EarliestVistaErrorDate]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="EarliestVistaErrorDate"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestVistaErrorDate]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestVistaErrorDate]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[EarliestDateTransformSID]"
cachedDataType="i8"
cachedName="EarliestDateTransformSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestDateTransformSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDateTransformSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ClinicalProcedureIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ClinicalProcedureIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ClinicalProcedureIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ConsultPlaceProtocolIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ConsultPlaceProtocolIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultPlaceProtocolIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[CPRSOrderIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="CPRSOrderIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSOrderIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[FromLocationIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="FromLocationIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FromLocationIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[GMRCProcedureIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="GMRCProcedureIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedureIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OrderingInstitutionIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="OrderingInstitutionIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingInstitutionIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OrderStatusIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="OrderStatusIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderStatusIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[PatientIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="PatientIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[PatientLocationIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="PatientLocationIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientLocationIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ProtocolIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ProtocolIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProtocolIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RecentActivityTypeIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RecentActivityTypeIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityTypeIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteConsultIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RemoteConsultIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteConsultInstitutionIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RemoteConsultInstitutionIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultInstitutionIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[SendingStaffIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="SendingStaffIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SendingStaffIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[TIUDocumentIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="TIUDocumentIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[TIUDocumentIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ToRequestServiceIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ToRequestServiceIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ToStaffIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ToStaffIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToStaffIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[UrgencyProtocolIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="UrgencyProtocolIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[UrgencyProtocolIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ResultIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ResultIEN"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultIEN]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultIEN]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ResultSID]"
cachedDataType="i8"
cachedName="ResultSID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultSID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ResultPointedToFileNumber]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ResultPointedToFileNumber"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultPointedToFileNumber]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultPointedToFileNumber]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OpCode]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="1"
cachedName="OpCode"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OpCode]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OpCode]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[VistaCreateDate]"
cachedDataType="dbTimeStamp"
cachedName="VistaCreateDate"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[VistaCreateDate]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaCreateDate]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[VistaEditDate]"
cachedDataType="dbTimeStamp"
cachedName="VistaEditDate"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[VistaEditDate]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaEditDate]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[extractBatchID]"
cachedDataType="i8"
cachedName="extractBatchID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ExtractBatchID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[extractBatchID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[BatchLogID]"
cachedDataType="i8"
cachedName="BatchLogID"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[BatchLogID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Outputs[Derived Column Output].Columns[BatchLogID]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ploc]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ploc"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ploc]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Match Output].Columns[ploc]" />
<inputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[floc]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="floc"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[floc]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Match Output].Columns[floc]" />
</inputColumns>
<externalMetadataColumns
isUsed="True">
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultSID]"
dataType="i8"
name="ConsultSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultIEN]"
codePage="1252"
dataType="str"
length="50"
name="ConsultIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Sta3n]"
dataType="i2"
name="Sta3n" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientSID]"
dataType="i4"
name="PatientSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientLocationSID]"
dataType="i4"
name="PatientLocationSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProtocolSID]"
dataType="i4"
name="ProtocolSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedureSID]"
dataType="i4"
name="GMRCProcedureSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedure]"
codePage="1252"
dataType="str"
length="100"
name="GMRCProcedure" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ClinicalProcedureSID]"
dataType="i4"
name="ClinicalProcedureSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceSID]"
dataType="i4"
name="ToRequestServiceSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceName]"
codePage="1252"
dataType="str"
length="100"
name="ToRequestServiceName" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateTime]"
dataType="dbTimeStamp2"
name="RequestDateTime"
scale="7" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="RequestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateTimeTransformSID]"
dataType="i8"
name="RequestDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateSID]"
dataType="i4"
name="RequestDateSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryDateTime]"
dataType="dbTimeStamp2"
name="FileEntryDateTime"
scale="7" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="FileEntryVistaErrorDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryDateTimeTransformSID]"
dataType="i8"
name="FileEntryDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FromLocationSID]"
dataType="i4"
name="FromLocationSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestType]"
codePage="1252"
dataType="str"
length="50"
name="RequestType" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToStaffSID]"
dataType="i4"
name="ToStaffSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderStatusSID]"
dataType="i4"
name="OrderStatusSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSOrderSID]"
dataType="i8"
name="CPRSOrderSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSStatus]"
codePage="1252"
dataType="str"
length="50"
name="CPRSStatus" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityTypeSID]"
dataType="i4"
name="RecentActivityTypeSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityType]"
codePage="1252"
dataType="str"
length="100"
name="RecentActivityType" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SendingStaffSID]"
dataType="i4"
name="SendingStaffSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SignificantFindings]"
codePage="1252"
dataType="str"
length="1"
name="SignificantFindings" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[UrgencyProtocolSID]"
dataType="i4"
name="UrgencyProtocolSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Urgency]"
codePage="1252"
dataType="str"
length="50"
name="Urgency" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultPlaceProtocolSID]"
dataType="i4"
name="ConsultPlaceProtocolSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PlaceOfConsultation]"
codePage="1252"
dataType="str"
length="50"
name="PlaceOfConsultation" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[DisplayTextOfItemOrdered]"
codePage="1252"
dataType="str"
length="100"
name="DisplayTextOfItemOrdered" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingInstitutionSID]"
dataType="i4"
name="OrderingInstitutionSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingSta3n]"
dataType="i2"
name="OrderingSta3n" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[InpatOutpat]"
codePage="1252"
dataType="str"
length="50"
name="InpatOutpat" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProvisionalDiagnosis]"
codePage="1252"
dataType="str"
length="255"
name="ProvisionalDiagnosis" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProvisionalDiagnosisCode]"
codePage="1252"
dataType="str"
length="50"
name="ProvisionalDiagnosisCode" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteRole]"
codePage="1252"
dataType="str"
length="50"
name="RemoteRole" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteService]"
codePage="1252"
dataType="str"
length="100"
name="RemoteService" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultInstitutionSID]"
dataType="i4"
name="RemoteConsultInstitutionSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultSta3n]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultSta3n" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultSID]"
dataType="i8"
name="RemoteConsultSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[TIUDocumentSID]"
dataType="i8"
name="TIUDocumentSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestDate]"
dataType="dbDate"
name="EarliestDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="EarliestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestDateTransformSID]"
dataType="i8"
name="EarliestDateTransformSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ClinicalProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
name="ClinicalProcedureIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultPlaceProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="ConsultPlaceProtocolIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSOrderIEN]"
codePage="1252"
dataType="str"
length="50"
name="CPRSOrderIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FromLocationIEN]"
codePage="1252"
dataType="str"
length="50"
name="FromLocationIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
name="GMRCProcedureIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
name="OrderingInstitutionIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderStatusIEN]"
codePage="1252"
dataType="str"
length="50"
name="OrderStatusIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientIEN]"
codePage="1252"
dataType="str"
length="50"
name="PatientIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientLocationIEN]"
codePage="1252"
dataType="str"
length="50"
name="PatientLocationIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="ProtocolIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityTypeIEN]"
codePage="1252"
dataType="str"
length="50"
name="RecentActivityTypeIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultIEN]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultInstitutionIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SendingStaffIEN]"
codePage="1252"
dataType="str"
length="50"
name="SendingStaffIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[TIUDocumentIEN]"
codePage="1252"
dataType="str"
length="50"
name="TIUDocumentIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceIEN]"
codePage="1252"
dataType="str"
length="50"
name="ToRequestServiceIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToStaffIEN]"
codePage="1252"
dataType="str"
length="50"
name="ToStaffIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[UrgencyProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="UrgencyProtocolIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultIEN]"
codePage="1252"
dataType="str"
length="50"
name="ResultIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultSID]"
dataType="i8"
name="ResultSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultPointedToFileNumber]"
codePage="1252"
dataType="str"
length="50"
name="ResultPointedToFileNumber" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ETLBatchID]"
dataType="i4"
name="ETLBatchID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OpCode]"
codePage="1252"
dataType="str"
length="1"
name="OpCode" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[VistaCreateDate]"
dataType="dbTimeStamp"
name="VistaCreateDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[VistaEditDate]"
dataType="dbTimeStamp"
name="VistaEditDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ExtractBatchID]"
dataType="i8"
name="ExtractBatchID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ploc]"
codePage="1252"
dataType="str"
length="100"
name="ploc" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[floc]"
codePage="1252"
dataType="str"
length="100"
name="floc" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[BatchLogID]"
dataType="i8"
name="BatchLogID" />
</externalMetadataColumns>
</input>
</inputs>
<outputs>
<output
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Outputs[OLE DB Destination Error Output]"
exclusionGroup="1"
isErrorOut="true"
name="OLE DB Destination Error Output"
synchronousInputId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input]">
<outputColumns>
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
<component
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source"
componentClassID="Microsoft.OLEDBSource"
contactInfo="OLE DB Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7"
description="OLE DB Source"
name="OLE DB Source"
usesDispositions="true"
version="7">
<properties>
<property
dataType="System.Int32"
description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out."
name="CommandTimeout">0</property>
<property
dataType="System.String"
description="Specifies the name of the database object used to open a rowset."
name="OpenRowset"></property>
<property
dataType="System.String"
description="Specifies the variable that contains the name of the database object used to open a rowset."
name="OpenRowsetVariable"></property>
<property
dataType="System.String"
description="The SQL command to be executed."
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91">Select
Con.*
,ext.extractBatchID
From con.Consult con
JOIN EB.ExtractBatch Ext on (CON.etlbatchID = ext.etlbatchID)
JOIN SPatient.Spatient Spat on (con.PatientSID = Spat.PatientSID)
where
--patientlocationSID in ('800024994'
--,'1000056290'
--,'458875')
--and
--fromlocationsid in ('10200039098','21269','435851'
--)
con.fileentrydatetime >= '2018-01-01'
and con.FileEntryDateTime < '2018-01-08'
and ext.viewnameconcat = 'Con.Consult'
and exists (select (1) from Spatient.SPatient pat
where con.PatientSID = pat.PatientSID
and CDWPossibleTestPatientFlag = 'N')</property>
<property
dataType="System.String"
description="The variable that contains the SQL command to be executed."
name="SqlCommandVariable"></property>
<property
dataType="System.Int32"
description="Specifies the column code page to use when code page information is unavailable from the data source."
name="DefaultCodePage">1252</property>
<property
dataType="System.Boolean"
description="Forces the use of the DefaultCodePage property value when describing character data."
name="AlwaysUseDefaultCodePage">false</property>
<property
dataType="System.Int32"
description="Specifies the mode used to access the database."
name="AccessMode"
typeConverter="AccessMode">2</property>
<property
dataType="System.String"
description="The mappings between the parameters in the SQL command and variables."
name="ParameterMapping"></property>
</properties>
<connections>
<connection
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Connections[OleDbConnection]"
connectionManagerID="Package.ConnectionManagers[
URL
.SPV]"
connectionManagerRefId="Package.ConnectionManagers[
URL
.SPV]"
description="The OLE DB runtime connection used to access the database."
name="OleDbConnection" />
</connections>
<outputs>
<output
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output]"
name="OLE DB Source Output">
<outputColumns>
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ETLBatchID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ETLBatchID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ETLBatchID]"
name="ETLBatchID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultSID]"
name="ConsultSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultIEN]"
name="ConsultIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[Sta3n]"
dataType="i2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[Sta3n]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[Sta3n]"
name="Sta3n"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientSID]"
name="PatientSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientLocationSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationSID]"
name="PatientLocationSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProtocolSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolSID]"
name="ProtocolSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedureSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureSID]"
name="GMRCProcedureSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedure]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedure]"
length="100"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedure]"
name="GMRCProcedure"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ClinicalProcedureSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureSID]"
name="ClinicalProcedureSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceSID]"
name="ToRequestServiceSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceName]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceName]"
length="100"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceName]"
name="ToRequestServiceName"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTime]"
dataType="dbTimeStamp2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateTime]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTime]"
name="RequestDateTime"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestVistaErrorDate]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestVistaErrorDate]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestVistaErrorDate]"
name="RequestVistaErrorDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTimeTransformSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateTimeTransformSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTimeTransformSID]"
name="RequestDateTimeTransformSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateSID]"
name="RequestDateSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTime]"
dataType="dbTimeStamp2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryDateTime]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTime]"
name="FileEntryDateTime"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryVistaErrorDate]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryVistaErrorDate]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryVistaErrorDate]"
name="FileEntryVistaErrorDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTimeTransformSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryDateTimeTransformSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTimeTransformSID]"
name="FileEntryDateTimeTransformSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FromLocationSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationSID]"
name="FromLocationSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestType]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestType]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestType]"
name="RequestType"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToStaffSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffSID]"
name="ToStaffSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderStatusSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusSID]"
name="OrderStatusSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSOrderSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderSID]"
name="CPRSOrderSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSStatus]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSStatus]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSStatus]"
name="CPRSStatus"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityTypeSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeSID]"
name="RecentActivityTypeSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityType]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityType]"
length="100"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityType]"
name="RecentActivityType"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SendingStaffSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffSID]"
name="SendingStaffSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[SignificantFindings]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SignificantFindings]"
length="1"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[SignificantFindings]"
name="SignificantFindings"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[UrgencyProtocolSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolSID]"
name="UrgencyProtocolSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[Urgency]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[Urgency]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[Urgency]"
name="Urgency"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultPlaceProtocolSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolSID]"
name="ConsultPlaceProtocolSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PlaceOfConsultation]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PlaceOfConsultation]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PlaceOfConsultation]"
name="PlaceOfConsultation"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[DisplayTextOfItemOrdered]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[DisplayTextOfItemOrdered]"
length="100"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[DisplayTextOfItemOrdered]"
name="DisplayTextOfItemOrdered"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingInstitutionSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionSID]"
name="OrderingInstitutionSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingSta3n]"
dataType="i2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingSta3n]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingSta3n]"
name="OrderingSta3n"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[InpatOutpat]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[InpatOutpat]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[InpatOutpat]"
name="InpatOutpat"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosis]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProvisionalDiagnosis]"
length="255"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosis]"
name="ProvisionalDiagnosis"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosisCode]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProvisionalDiagnosisCode]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosisCode]"
name="ProvisionalDiagnosisCode"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteRole]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteRole]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteRole]"
name="RemoteRole"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteService]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteService]"
length="100"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteService]"
name="RemoteService"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultInstitutionSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionSID]"
name="RemoteConsultInstitutionSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSta3n]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultSta3n]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSta3n]"
name="RemoteConsultSta3n"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSID]"
name="RemoteConsultSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[TIUDocumentSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentSID]"
name="TIUDocumentSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDate]"
dataType="dbDate"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestDate]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDate]"
name="EarliestDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestVistaErrorDate]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestVistaErrorDate]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestVistaErrorDate]"
name="EarliestVistaErrorDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDateTransformSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestDateTransformSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDateTransformSID]"
name="EarliestDateTransformSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ClinicalProcedureIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureIEN]"
name="ClinicalProcedureIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultPlaceProtocolIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolIEN]"
name="ConsultPlaceProtocolIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSOrderIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderIEN]"
name="CPRSOrderIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FromLocationIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationIEN]"
name="FromLocationIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedureIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureIEN]"
name="GMRCProcedureIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingInstitutionIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionIEN]"
name="OrderingInstitutionIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderStatusIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusIEN]"
name="OrderStatusIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientIEN]"
name="PatientIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientLocationIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationIEN]"
name="PatientLocationIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProtocolIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolIEN]"
name="ProtocolIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityTypeIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeIEN]"
name="RecentActivityTypeIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultIEN]"
name="RemoteConsultIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultInstitutionIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionIEN]"
name="RemoteConsultInstitutionIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SendingStaffIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffIEN]"
name="SendingStaffIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[TIUDocumentIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentIEN]"
name="TIUDocumentIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceIEN]"
name="ToRequestServiceIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToStaffIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffIEN]"
name="ToStaffIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[UrgencyProtocolIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolIEN]"
name="UrgencyProtocolIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultIEN]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultIEN]"
name="ResultIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultSID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultSID]"
name="ResultSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultPointedToFileNumber]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultPointedToFileNumber]"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultPointedToFileNumber]"
name="ResultPointedToFileNumber"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OpCode]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OpCode]"
length="1"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[OpCode]"
name="OpCode"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaCreateDate]"
dataType="dbTimeStamp"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[VistaCreateDate]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaCreateDate]"
name="VistaCreateDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaEditDate]"
dataType="dbTimeStamp"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[VistaEditDate]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaEditDate]"
name="VistaEditDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[extractBatchID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[extractBatchID]"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].Columns[extractBatchID]"
name="extractBatchID"
truncationRowDisposition="FailComponent" />
</outputColumns>
<externalMetadataColumns
isUsed="True">
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ETLBatchID]"
dataType="i4"
name="ETLBatchID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultSID]"
dataType="i8"
name="ConsultSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultIEN]"
codePage="1252"
dataType="str"
length="50"
name="ConsultIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[Sta3n]"
dataType="i2"
name="Sta3n" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientSID]"
dataType="i4"
name="PatientSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientLocationSID]"
dataType="i4"
name="PatientLocationSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProtocolSID]"
dataType="i4"
name="ProtocolSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedureSID]"
dataType="i4"
name="GMRCProcedureSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedure]"
codePage="1252"
dataType="str"
length="100"
name="GMRCProcedure" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ClinicalProcedureSID]"
dataType="i4"
name="ClinicalProcedureSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceSID]"
dataType="i4"
name="ToRequestServiceSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceName]"
codePage="1252"
dataType="str"
length="100"
name="ToRequestServiceName" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateTime]"
dataType="dbTimeStamp2"
name="RequestDateTime" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="RequestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateTimeTransformSID]"
dataType="i8"
name="RequestDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateSID]"
dataType="i4"
name="RequestDateSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryDateTime]"
dataType="dbTimeStamp2"
name="FileEntryDateTime" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="FileEntryVistaErrorDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryDateTimeTransformSID]"
dataType="i8"
name="FileEntryDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FromLocationSID]"
dataType="i4"
name="FromLocationSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestType]"
codePage="1252"
dataType="str"
length="50"
name="RequestType" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToStaffSID]"
dataType="i4"
name="ToStaffSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderStatusSID]"
dataType="i4"
name="OrderStatusSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSOrderSID]"
dataType="i8"
name="CPRSOrderSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSStatus]"
codePage="1252"
dataType="str"
length="50"
name="CPRSStatus" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityTypeSID]"
dataType="i4"
name="RecentActivityTypeSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityType]"
codePage="1252"
dataType="str"
length="100"
name="RecentActivityType" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SendingStaffSID]"
dataType="i4"
name="SendingStaffSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SignificantFindings]"
codePage="1252"
dataType="str"
length="1"
name="SignificantFindings" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[UrgencyProtocolSID]"
dataType="i4"
name="UrgencyProtocolSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[Urgency]"
codePage="1252"
dataType="str"
length="50"
name="Urgency" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultPlaceProtocolSID]"
dataType="i4"
name="ConsultPlaceProtocolSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PlaceOfConsultation]"
codePage="1252"
dataType="str"
length="50"
name="PlaceOfConsultation" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[DisplayTextOfItemOrdered]"
codePage="1252"
dataType="str"
length="100"
name="DisplayTextOfItemOrdered" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingInstitutionSID]"
dataType="i4"
name="OrderingInstitutionSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingSta3n]"
dataType="i2"
name="OrderingSta3n" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[InpatOutpat]"
codePage="1252"
dataType="str"
length="50"
name="InpatOutpat" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProvisionalDiagnosis]"
codePage="1252"
dataType="str"
length="255"
name="ProvisionalDiagnosis" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProvisionalDiagnosisCode]"
codePage="1252"
dataType="str"
length="50"
name="ProvisionalDiagnosisCode" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteRole]"
codePage="1252"
dataType="str"
length="50"
name="RemoteRole" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteService]"
codePage="1252"
dataType="str"
length="100"
name="RemoteService" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultInstitutionSID]"
dataType="i4"
name="RemoteConsultInstitutionSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultSta3n]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultSta3n" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultSID]"
dataType="i8"
name="RemoteConsultSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[TIUDocumentSID]"
dataType="i8"
name="TIUDocumentSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestDate]"
dataType="dbDate"
name="EarliestDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="EarliestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestDateTransformSID]"
dataType="i8"
name="EarliestDateTransformSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ClinicalProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
name="ClinicalProcedureIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultPlaceProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="ConsultPlaceProtocolIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSOrderIEN]"
codePage="1252"
dataType="str"
length="50"
name="CPRSOrderIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FromLocationIEN]"
codePage="1252"
dataType="str"
length="50"
name="FromLocationIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
name="GMRCProcedureIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
name="OrderingInstitutionIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderStatusIEN]"
codePage="1252"
dataType="str"
length="50"
name="OrderStatusIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientIEN]"
codePage="1252"
dataType="str"
length="50"
name="PatientIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientLocationIEN]"
codePage="1252"
dataType="str"
length="50"
name="PatientLocationIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="ProtocolIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityTypeIEN]"
codePage="1252"
dataType="str"
length="50"
name="RecentActivityTypeIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultIEN]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultInstitutionIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SendingStaffIEN]"
codePage="1252"
dataType="str"
length="50"
name="SendingStaffIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[TIUDocumentIEN]"
codePage="1252"
dataType="str"
length="50"
name="TIUDocumentIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceIEN]"
codePage="1252"
dataType="str"
length="50"
name="ToRequestServiceIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToStaffIEN]"
codePage="1252"
dataType="str"
length="50"
name="ToStaffIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[UrgencyProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="UrgencyProtocolIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultIEN]"
codePage="1252"
dataType="str"
length="50"
name="ResultIEN" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultSID]"
dataType="i8"
name="ResultSID" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultPointedToFileNumber]"
codePage="1252"
dataType="str"
length="50"
name="ResultPointedToFileNumber" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OpCode]"
codePage="1252"
dataType="str"
length="1"
name="OpCode" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[VistaCreateDate]"
dataType="dbTimeStamp"
name="VistaCreateDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[VistaEditDate]"
dataType="dbTimeStamp"
name="VistaEditDate" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[extractBatchID]"
dataType="i8"
name="extractBatchID" />
</externalMetadataColumns>
</output>
<output
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output]"
isErrorOut="true"
name="OLE DB Source Error Output">
<outputColumns>
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultSID]"
dataType="i8"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultSID]"
name="ConsultSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultIEN]"
name="ConsultIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[Sta3n]"
dataType="i2"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[Sta3n]"
name="Sta3n" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientSID]"
name="PatientSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientLocationSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientLocationSID]"
name="PatientLocationSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProtocolSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProtocolSID]"
name="ProtocolSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedureSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedureSID]"
name="GMRCProcedureSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedure]"
codePage="1252"
dataType="str"
length="100"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedure]"
name="GMRCProcedure" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ClinicalProcedureSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ClinicalProcedureSID]"
name="ClinicalProcedureSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceSID]"
name="ToRequestServiceSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceName]"
codePage="1252"
dataType="str"
length="100"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceName]"
name="ToRequestServiceName" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateTime]"
dataType="dbTimeStamp2"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateTime]"
name="RequestDateTime" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestVistaErrorDate]"
name="RequestVistaErrorDate" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateTimeTransformSID]"
dataType="i8"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateTimeTransformSID]"
name="RequestDateTimeTransformSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateSID]"
name="RequestDateSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryDateTime]"
dataType="dbTimeStamp2"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryDateTime]"
name="FileEntryDateTime" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryVistaErrorDate]"
name="FileEntryVistaErrorDate" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryDateTimeTransformSID]"
dataType="i8"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryDateTimeTransformSID]"
name="FileEntryDateTimeTransformSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FromLocationSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FromLocationSID]"
name="FromLocationSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestType]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestType]"
name="RequestType" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToStaffSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToStaffSID]"
name="ToStaffSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderStatusSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderStatusSID]"
name="OrderStatusSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSOrderSID]"
dataType="i8"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSOrderSID]"
name="CPRSOrderSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSStatus]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSStatus]"
name="CPRSStatus" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityTypeSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityTypeSID]"
name="RecentActivityTypeSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityType]"
codePage="1252"
dataType="str"
length="100"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityType]"
name="RecentActivityType" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SendingStaffSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SendingStaffSID]"
name="SendingStaffSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SignificantFindings]"
codePage="1252"
dataType="str"
length="1"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SignificantFindings]"
name="SignificantFindings" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[UrgencyProtocolSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[UrgencyProtocolSID]"
name="UrgencyProtocolSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[Urgency]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[Urgency]"
name="Urgency" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultPlaceProtocolSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultPlaceProtocolSID]"
name="ConsultPlaceProtocolSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PlaceOfConsultation]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PlaceOfConsultation]"
name="PlaceOfConsultation" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[DisplayTextOfItemOrdered]"
codePage="1252"
dataType="str"
length="100"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[DisplayTextOfItemOrdered]"
name="DisplayTextOfItemOrdered" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingInstitutionSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingInstitutionSID]"
name="OrderingInstitutionSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingSta3n]"
dataType="i2"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingSta3n]"
name="OrderingSta3n" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[InpatOutpat]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[InpatOutpat]"
name="InpatOutpat" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProvisionalDiagnosis]"
codePage="1252"
dataType="str"
length="255"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProvisionalDiagnosis]"
name="ProvisionalDiagnosis" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProvisionalDiagnosisCode]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProvisionalDiagnosisCode]"
name="ProvisionalDiagnosisCode" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteRole]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteRole]"
name="RemoteRole" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteService]"
codePage="1252"
dataType="str"
length="100"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteService]"
name="RemoteService" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultInstitutionSID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultInstitutionSID]"
name="RemoteConsultInstitutionSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultSta3n]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultSta3n]"
name="RemoteConsultSta3n" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultSID]"
dataType="i8"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultSID]"
name="RemoteConsultSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[TIUDocumentSID]"
dataType="i8"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[TIUDocumentSID]"
name="TIUDocumentSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestDate]"
dataType="dbDate"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestDate]"
name="EarliestDate" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestVistaErrorDate]"
name="EarliestVistaErrorDate" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestDateTransformSID]"
dataType="i8"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestDateTransformSID]"
name="EarliestDateTransformSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ClinicalProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ClinicalProcedureIEN]"
name="ClinicalProcedureIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultPlaceProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultPlaceProtocolIEN]"
name="ConsultPlaceProtocolIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSOrderIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSOrderIEN]"
name="CPRSOrderIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FromLocationIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FromLocationIEN]"
name="FromLocationIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedureIEN]"
name="GMRCProcedureIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingInstitutionIEN]"
name="OrderingInstitutionIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderStatusIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderStatusIEN]"
name="OrderStatusIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientIEN]"
name="PatientIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientLocationIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientLocationIEN]"
name="PatientLocationIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProtocolIEN]"
name="ProtocolIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityTypeIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityTypeIEN]"
name="RecentActivityTypeIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultIEN]"
name="RemoteConsultIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultInstitutionIEN]"
name="RemoteConsultInstitutionIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SendingStaffIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SendingStaffIEN]"
name="SendingStaffIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[TIUDocumentIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[TIUDocumentIEN]"
name="TIUDocumentIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceIEN]"
name="ToRequestServiceIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToStaffIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToStaffIEN]"
name="ToStaffIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[UrgencyProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[UrgencyProtocolIEN]"
name="UrgencyProtocolIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultIEN]"
name="ResultIEN" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultSID]"
dataType="i8"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultSID]"
name="ResultSID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultPointedToFileNumber]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultPointedToFileNumber]"
name="ResultPointedToFileNumber" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ETLBatchID]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ETLBatchID]"
name="ETLBatchID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OpCode]"
codePage="1252"
dataType="str"
length="1"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OpCode]"
name="OpCode" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[VistaCreateDate]"
dataType="dbTimeStamp"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[VistaCreateDate]"
name="VistaCreateDate" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[VistaEditDate]"
dataType="dbTimeStamp"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[VistaEditDate]"
name="VistaEditDate" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[extractBatchID]"
dataType="i8"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[extractBatchID]"
name="extractBatchID" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
</components>
<paths>
<path
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination.Paths[Derived Column Output]"
endId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination.Inputs[OLE DB Destination Input]"
name="Derived Column Output"
startId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Outputs[Derived Column Output]" />
<path
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination.Paths[Lookup Match Output]"
endId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column.Inputs[Derived Column Input]"
name="Lookup Match Output"
startId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Outputs[Lookup Match Output]" />
<path
refId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination.Paths[OLE DB Source Output]"
endId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup.Inputs[Lookup Input]"
name="OLE DB Source Output"
startId="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source.Outputs[OLE DB Source Output]" />
</paths>
</pipeline>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Lookup Transformation Cache\Data Flow Task"
DTS:CreationName="Microsoft.Pipeline"
DTS:Description="Data Flow Task"
DTS:DTSID="{84751c8e-0294-4057-8cde-a7ac2ce9e307}"
DTS:ExecutableType="Microsoft.Pipeline"
DTS:LocaleID="-1"
DTS:ObjectName="Data Flow Task"
DTS:TaskContact="Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1">
<DTS:Variables />
<DTS:ObjectData>
<pipeline
version="1">
<components>
<component
refId="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform"
componentClassID="Microsoft.Cache"
contactInfo="Cache Transform;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1"
description="Writes data to a cache (a .caw file) with the Cache Connection Manager. Reuse the cache between multiple Lookup transforms to reduce database load. Share the cache to reduce memory usage. Note: cache data is stored in clear text and not recommended for sensitive data."
name="Cache Transform"
version="1">
<properties>
<property
dataType="System.Boolean"
description="Determines whether duplicate keys in the reference data should be treated as errors when full cache mode is used."
name="TreatDuplicateKeysAsError">false</property>
</properties>
<connections>
<connection
refId="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform.Connections[CacheConnection]"
connectionManagerID="Package.ConnectionManagers[Cache Connection Manager 2]"
connectionManagerRefId="Package.ConnectionManagers[Cache Connection Manager 2]"
description="The connection used to access the cache."
name="CacheConnection" />
</connections>
<inputs>
<input
refId="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform.Inputs[Cache Input]"
hasSideEffects="true"
name="Cache Input">
<inputColumns>
<inputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform.Inputs[Cache Input].Columns[patientlocationsid]"
cachedDataType="i4"
cachedName="patientlocationsid"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[patientlocationsid]">
<properties>
<property
dataType="System.String"
description="The cache column associated with the input column."
name="CacheColumnName">patientlocationsid</property>
</properties>
</inputColumn>
<inputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform.Inputs[Cache Input].Columns[fromlocationsid]"
cachedDataType="i4"
cachedName="fromlocationsid"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[fromlocationsid]">
<properties>
<property
dataType="System.String"
description="The cache column associated with the input column."
name="CacheColumnName">fromlocationsid</property>
</properties>
</inputColumn>
<inputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform.Inputs[Cache Input].Columns[ploc]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ploc"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ploc]">
<properties>
<property
dataType="System.String"
description="The cache column associated with the input column."
name="CacheColumnName">ploc</property>
</properties>
</inputColumn>
<inputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform.Inputs[Cache Input].Columns[floc]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="floc"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[floc]">
<properties>
<property
dataType="System.String"
description="The cache column associated with the input column."
name="CacheColumnName">floc</property>
</properties>
</inputColumn>
</inputColumns>
<externalMetadataColumns />
</input>
</inputs>
<outputs>
<output
refId="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform.Outputs[Cache Output]"
name="Cache Output"
synchronousInputId="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform.Inputs[Cache Input]">
<externalMetadataColumns />
</output>
</outputs>
</component>
<component
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source"
componentClassID="Microsoft.OLEDBSource"
contactInfo="OLE DB Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7"
description="OLE DB Source"
name="OLE DB Source"
usesDispositions="true"
version="7">
<properties>
<property
dataType="System.Int32"
description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out."
name="CommandTimeout">0</property>
<property
dataType="System.String"
description="Specifies the name of the database object used to open a rowset."
name="OpenRowset"></property>
<property
dataType="System.String"
description="Specifies the variable that contains the name of the database object used to open a rowset."
name="OpenRowsetVariable"></property>
<property
dataType="System.String"
description="The SQL command to be executed."
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91">Select Distinct
con.patientlocationsid
,con.fromlocationsid
,ploc.locationname as ploc
,floc.locationname as floc
From con.consult con
join dim.location ploc on (con.patientlocationsid = ploc.locationsid)
join dim.location floc on (con.fromlocationsid = floc.locationsid)</property>
<property
dataType="System.String"
description="The variable that contains the SQL command to be executed."
name="SqlCommandVariable"></property>
<property
dataType="System.Int32"
description="Specifies the column code page to use when code page information is unavailable from the data source."
name="DefaultCodePage">1252</property>
<property
dataType="System.Boolean"
description="Forces the use of the DefaultCodePage property value when describing character data."
name="AlwaysUseDefaultCodePage">false</property>
<property
dataType="System.Int32"
description="Specifies the mode used to access the database."
name="AccessMode"
typeConverter="AccessMode">2</property>
<property
dataType="System.String"
description="The mappings between the parameters in the SQL command and variables."
name="ParameterMapping"></property>
</properties>
<connections>
<connection
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Connections[OleDbConnection]"
connectionManagerID="Package.ConnectionManagers[
URL
.SPV]"
connectionManagerRefId="Package.ConnectionManagers[
URL
.SPV]"
description="The OLE DB runtime connection used to access the database."
name="OleDbConnection" />
</connections>
<outputs>
<output
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output]"
name="OLE DB Source Output">
<outputColumns>
<outputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[patientlocationsid]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[patientlocationsid]"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[patientlocationsid]"
name="patientlocationsid"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[fromlocationsid]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[fromlocationsid]"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[fromlocationsid]"
name="fromlocationsid"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ploc]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ploc]"
length="50"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ploc]"
name="ploc"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[floc]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[floc]"
length="50"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[floc]"
name="floc"
truncationRowDisposition="FailComponent" />
</outputColumns>
<externalMetadataColumns
isUsed="True">
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[patientlocationsid]"
dataType="i4"
name="patientlocationsid" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[fromlocationsid]"
dataType="i4"
name="fromlocationsid" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ploc]"
codePage="1252"
dataType="str"
length="50"
name="ploc" />
<externalMetadataColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[floc]"
codePage="1252"
dataType="str"
length="50"
name="floc" />
</externalMetadataColumns>
</output>
<output
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output]"
isErrorOut="true"
name="OLE DB Source Error Output">
<outputColumns>
<outputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[patientlocationsid]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[patientlocationsid]"
name="patientlocationsid" />
<outputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[fromlocationsid]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[fromlocationsid]"
name="fromlocationsid" />
<outputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ploc]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ploc]"
name="ploc" />
<outputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[floc]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[floc]"
name="floc" />
<outputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
</components>
<paths>
<path
refId="Package\Lookup Transformation Cache\Data Flow Task.Paths[OLE DB Source Output]"
endId="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform.Inputs[Cache Input]"
name="OLE DB Source Output"
startId="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output]" />
</paths>
</pipeline>
</DTS:ObjectData>
</DTS:Executable>
</DTS:Executables>
<DTS:PrecedenceConstraints>
<DTS:PrecedenceConstraint
DTS:refId="Package\Lookup Transformation Cache.PrecedenceConstraints[Constraint]"
DTS:CreationName=""
DTS:DTSID="{7f3c84d3-3c83-4b23-ae19-ebe4090f7571}"
DTS:From="Package\Lookup Transformation Cache\Data Flow Task"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint"
DTS:To="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination" />
</DTS:PrecedenceConstraints>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Sequence Container"
DTS:CreationName="STOCK:SEQUENCE"
DTS:Description="Sequence Container"
DTS:DTSID="{9C874CE3-43FA-49A4-8EEC-2E6E79701E1B}"
DTS:ExecutableType="STOCK:SEQUENCE"
DTS:LocaleID="-1"
DTS:ObjectName="Sequence Container">
<DTS:Variables />
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Sequence Container\Get Batch Log ID"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{0FDF9EA6-33A9-4AE0-9287-193A4825AD33}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Get Batch Log ID"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{2322488E-4270-4638-A0DA-53D21A13C0C8}"
SQLTask:SqlStatementSource="EXEC uspSetBatchLogsReadyforBatch @rawTableName, @batchLogId OUTPUT" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Output"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@rawTableName"
SQLTask:DtsVariableName="User::rawTableName"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Sequence Container\Get Prior Max Source Batch ID"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{A7C62223-2950-4E99-918F-588C8964FF1E}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Get Prior Max Source Batch ID"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="1">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{2322488E-4270-4638-A0DA-53D21A13C0C8}"
SQLTask:SqlStatementSource="SELECT IsNull(MAX(SourceBatchNumber), 0) AS PriorSourceBatchNumber
FROM dbo.BatchLogs
WHERE TableName = @rawTableName
AND LoadStatus In('EXTCOMPLETE','INTCOMPLETE','INTPROCESSING')"
SQLTask:ResultType="ResultSetType_SingleRow" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ResultBinding
SQLTask:ResultName="0"
SQLTask:DtsVariableName="User::priorSourceBatchNumber" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@rawTableName"
SQLTask:DtsVariableName="User::rawTableName"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
</DTS:Executables>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Set Batch Log Status"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{B1E71948-8A42-41E6-AF97-D9C6CEFFBFA6}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Set Batch Log Status"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{2322488E-4270-4638-A0DA-53D21A13C0C8}"
SQLTask:SqlStatementSource="EXEC uspSetBatchLogStatus @batchLogId, @batchRecordCount, @maxSourceBatchNumber, @loadStatus, @filePathName;" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchRecordCount"
SQLTask:DtsVariableName="User::batchRecordCount"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@maxSourceBatchNumber"
SQLTask:DtsVariableName="User::maxSourceBatchNumber"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@loadStatus"
SQLTask:DtsVariableName="User::loadStatusComplete"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@filePathName"
SQLTask:DtsVariableName="User::filePathName"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Set BatchLogs EXTERROR"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{C4B7ECAB-2552-4DB9-9159-4BC64429A3F9}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Set BatchLogs EXTERROR"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="1">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{2322488E-4270-4638-A0DA-53D21A13C0C8}"
SQLTask:SqlStatementSource="EXEC uspSetBatchLogStatus @batchLogId, @batchRecordCount, @maxSourceBatchNumber, @loadStatus, @filePathName;" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchRecordCount"
SQLTask:DtsVariableName="User::batchRecordCount"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@maxSourceBatchNumber"
SQLTask:DtsVariableName="User::maxSourceBatchNumber"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@loadStatus"
SQLTask:DtsVariableName="User::loadStatusError"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@filePathName"
SQLTask:DtsVariableName="User::filePathName"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Set BatchLogs EXTERROR 2"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{C06C50EB-0211-4987-9861-B50B95930200}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Set BatchLogs EXTERROR 2"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="1">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{2322488E-4270-4638-A0DA-53D21A13C0C8}"
SQLTask:SqlStatementSource="EXEC uspSetBatchLogStatus @batchLogId, @batchRecordCount, @maxSourceBatchNumber, @loadStatus, @filePathName;" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchRecordCount"
SQLTask:DtsVariableName="User::batchRecordCount"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@maxSourceBatchNumber"
SQLTask:DtsVariableName="User::maxSourceBatchNumber"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@loadStatus"
SQLTask:DtsVariableName="User::loadStatusError"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@filePathName"
SQLTask:DtsVariableName="User::filePathName"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
</DTS:Executables>
<DTS:PrecedenceConstraints>
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint]"
DTS:CreationName=""
DTS:DTSID="{8EB5AD06-08FA-4337-84DD-A58919617B0F}"
DTS:EvalOp="1"
DTS:Expression="@[User::batchLogId] > 0"
DTS:From="Package\Sequence Container"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint"
DTS:To="Package\Do Delete Raw for BatchLogID in case of existing recs for that batch" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 1]"
DTS:CreationName=""
DTS:DTSID="{A78958DA-C328-4C41-B4A8-3CF2E189495A}"
DTS:From="Package\Do Delete Raw for BatchLogID in case of existing recs for that batch"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 1"
DTS:To="Package\Lookup Transformation Cache" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 2]"
DTS:CreationName=""
DTS:DTSID="{19060974-2AD5-4351-995A-41DCCE9A6CE7}"
DTS:From="Package\Get Max Source Batch ID and Batch Count (remember to change the hard-coded table name)"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 2"
DTS:To="Package\Set Batch Log Status" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 3]"
DTS:CreationName=""
DTS:DTSID="{F462EB03-49A0-4C11-B347-B6BC87591B40}"
DTS:From="Package\Lookup Transformation Cache"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 3"
DTS:To="Package\Get Max Source Batch ID and Batch Count (remember to change the hard-coded table name)" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 4]"
DTS:CreationName=""
DTS:DTSID="{3E3DCE37-3782-4ABC-88CA-DF0DC460F68F}"
DTS:From="Package\Lookup Transformation Cache"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 4"
DTS:To="Package\Set BatchLogs EXTERROR"
DTS:Value="1" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 5]"
DTS:CreationName=""
DTS:DTSID="{98055D8E-2D6B-4B3E-AF63-0BAD80BCD926}"
DTS:From="Package\Do Delete Raw for BatchLogID in case of existing recs for that batch"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 5"
DTS:To="Package\Set BatchLogs EXTERROR"
DTS:Value="1" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 6]"
DTS:CreationName=""
DTS:DTSID="{A4A14E14-B477-4D4D-81B8-2399E29A35F9}"
DTS:From="Package\Get Max Source Batch ID and Batch Count (remember to change the hard-coded table name)"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 6"
DTS:To="Package\Set BatchLogs EXTERROR 2"
DTS:Value="1" />
</DTS:PrecedenceConstraints>
<DTS:DesignTimeProperties><![CDATA[<?xml version="1.0"?>
<!--This CDATA section contains the layout information of the package. The section includes information such as (x,y) coordinates, width, and height.-->
<!--If you manually edit this section and make a mistake, you can delete it. -->
<!--The package will still be able to load normally but the previous layout information will be lost and the designer will automatically re-arrange the elements on the design surface.-->
<Objects
Version="8">
<!--Each node below will contain properties that do not affect runtime behavior.-->
<Package
design-time-name="Package">
<LayoutInfo>
<GraphLayout
Capacity="32" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mssgm="clr-namespace:Microsoft.SqlServer.Graph.Model;assembly=Microsoft.SqlServer.Graph">
<NodeLayout
Size="220,73"
Id="Package\Do Delete Raw for BatchLogID in case of existing recs for that batch"
TopLeft="421,57" />
<NodeLayout
Size="456,61"
Id="Package\Get Max Source Batch ID and Batch Count (remember to change the hard-coded table name)"
TopLeft="285,551" />
<NodeLayout
Size="160,42"
Id="Package\Sequence Container\Get Batch Log ID"
TopLeft="52,23" />
<NodeLayout
Size="224,42"
Id="Package\Sequence Container\Get Prior Max Source Batch ID"
TopLeft="34,92" />
<ContainerLayout
HeaderHeight="43"
IsExpanded="True"
PanelSize="269,189"
Size="269,232"
Id="Package\Sequence Container"
TopLeft="85,43" />
<NodeLayout
Size="179,42"
Id="Package\Set Batch Log Status"
TopLeft="287,710" />
<NodeLayout
Size="203,42"
Id="Package\Set BatchLogs EXTERROR"
TopLeft="582,239" />
<NodeLayout
Size="212,42"
Id="Package\Set BatchLogs EXTERROR 2"
TopLeft="604,683" />
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint]"
TopLeft="354,159">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="67,-65.5"
Start="0,0"
End="59.5,-65.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="29.5,0" />
<mssgle:CubicBezierSegment
Point1="29.5,0"
Point2="33.5,0"
Point3="33.5,-4" />
<mssgle:LineSegment
End="33.5,-61.5" />
<mssgle:CubicBezierSegment
Point1="33.5,-61.5"
Point2="33.5,-65.5"
Point3="37.5,-65.5" />
<mssgle:LineSegment
End="59.5,-65.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="25.5,1,16,16"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 2]"
TopLeft="438.333333333333,612">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="-61.8333333333333,98"
Start="0,0"
End="-61.8333333333333,90.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,35.4055944055944" />
<mssgle:CubicBezierSegment
Point1="0,35.4055944055944"
Point2="0,39.4055944055944"
Point3="-4,39.4055944055944" />
<mssgle:LineSegment
End="-57.8333333333333,39.4055944055944" />
<mssgle:CubicBezierSegment
Point1="-57.8333333333333,39.4055944055944"
Point2="-61.8333333333333,39.4055944055944"
Point3="-61.8333333333333,43.4055944055944" />
<mssgle:LineSegment
End="-61.8333333333333,90.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 5]"
TopLeft="566.333333333333,130">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="117.166666666667,109"
Start="0,0"
End="117.166666666667,101.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,40.072202166065" />
<mssgle:CubicBezierSegment
Point1="0,40.072202166065"
Point2="0,44.072202166065"
Point3="4,44.072202166065" />
<mssgle:LineSegment
End="113.166666666667,44.072202166065" />
<mssgle:CubicBezierSegment
Point1="113.166666666667,44.072202166065"
Point2="117.166666666667,44.072202166065"
Point3="117.166666666667,48.072202166065" />
<mssgle:LineSegment
End="117.166666666667,101.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="43.3419856770835,49.072202166065,30.4826953125,9.7490234375"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 6]"
TopLeft="587.666666666667,612">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="122.333333333333,71"
Start="0,0"
End="122.333333333333,63.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,24.5489510489511" />
<mssgle:CubicBezierSegment
Point1="0,24.5489510489511"
Point2="0,28.5489510489511"
Point3="4,28.5489510489511" />
<mssgle:LineSegment
End="118.333333333333,28.5489510489511" />
<mssgle:CubicBezierSegment
Point1="118.333333333333,28.5489510489511"
Point2="122.333333333333,28.5489510489511"
Point3="122.333333333333,32.5489510489511" />
<mssgle:LineSegment
End="122.333333333333,63.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="45.9253190104167,33.5489510489511,30.4826953125,9.7490234375"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
<AnnotationLayout
Text="There is still probably room for improvement on the error handling."
ParentId="Package"
FontInfo="{assembly:Null}"
Size="387,40"
Id="93b4425d-3980-4d2a-a138-cd2143f374e8"
TopLeft="385,16" />
<NodeLayout
Size="180,74"
Id="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination"
TopLeft="230,10" />
<NodeLayout
Size="151,42"
Id="Package\Lookup Transformation Cache\Data Flow Task"
TopLeft="27,20" />
<EdgeLayout
Id="Package\Lookup Transformation Cache.PrecedenceConstraints[Constraint]"
TopLeft="178,44">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="52,0"
Start="0,0"
End="44.5,0">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="44.5,0" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
<ContainerLayout
HeaderHeight="43"
IsExpanded="True"
PanelSize="600,139"
Size="600,182"
Id="Package\Lookup Transformation Cache"
TopLeft="227,338" />
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 1]"
TopLeft="495.666666666667,130">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="-67.3333333333333,208"
Start="0,0"
End="-67.3333333333333,200.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,100.591439688716" />
<mssgle:CubicBezierSegment
Point1="0,100.591439688716"
Point2="0,104.591439688716"
Point3="-4,104.591439688716" />
<mssgle:LineSegment
End="-63.3333333333333,104.591439688716" />
<mssgle:CubicBezierSegment
Point1="-63.3333333333333,104.591439688716"
Point2="-67.3333333333333,104.591439688716"
Point3="-67.3333333333333,108.591439688716" />
<mssgle:LineSegment
End="-67.3333333333333,200.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 3]"
TopLeft="527,520">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="-14,31"
Start="0,0"
End="-14,23.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,11.5" />
<mssgle:CubicBezierSegment
Point1="0,11.5"
Point2="0,15.5"
Point3="-4,15.5" />
<mssgle:LineSegment
End="-10,15.5" />
<mssgle:CubicBezierSegment
Point1="-10,15.5"
Point2="-14,15.5"
Point3="-14,19.5" />
<mssgle:LineSegment
End="-14,23.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 4]"
TopLeft="625.666666666667,338">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="57.8333333333334,-57"
Start="0,0"
End="57.8333333333334,-49.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,-18.8909574468085" />
<mssgle:CubicBezierSegment
Point1="0,-18.8909574468085"
Point2="0,-22.8909574468085"
Point3="4,-22.8909574468085" />
<mssgle:LineSegment
End="53.8333333333334,-22.8909574468085" />
<mssgle:CubicBezierSegment
Point1="53.8333333333334,-22.8909574468085"
Point2="57.8333333333334,-22.8909574468085"
Point3="57.8333333333334,-26.8909574468085" />
<mssgle:LineSegment
End="57.8333333333334,-49.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="13.6753190104167,-17.8909574468085,30.4826953125,9.7490234375"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
</GraphLayout>
</LayoutInfo>
</Package>
<TaskHost
design-time-name="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination">
<LayoutInfo>
<GraphLayout
Capacity="8" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mssgm="clr-namespace:Microsoft.SqlServer.Graph.Model;assembly=Microsoft.SqlServer.Graph">
<NodeLayout
Size="171,42"
Id="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Destination"
TopLeft="487.5,243.5" />
<NodeLayout
Size="241,42"
Id="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Add BatchlogID as derived column"
TopLeft="156,372" />
<NodeLayout
Size="113,42"
Id="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\Lookup"
TopLeft="182,179" />
<NodeLayout
Size="150,42"
Id="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination\OLE DB Source"
TopLeft="168,52" />
<EdgeLayout
Id="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination.Paths[Lookup Match Output]"
TopLeft="238.083333333333,221">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="0,151"
Start="0,0"
End="0,143.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,143.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="-48.19138671875,65.9453125,96.3827734375,11.609375"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination.Paths[OLE DB Source Output]"
TopLeft="240.75,94">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="0,85"
Start="0,0"
End="0,77.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,77.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="0,0,0,0"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package\Lookup Transformation Cache\* Get Data From Source And Send To Raw Table Destination.Paths[Derived Column Output]"
TopLeft="315.333333333333,372">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="257.666666666667,-86.5"
Start="0,0"
End="257.666666666667,-79">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,-30.9422918384171" />
<mssgle:CubicBezierSegment
Point1="0,-30.9422918384171"
Point2="0,-34.9422918384171"
Point3="4,-34.9422918384171" />
<mssgle:LineSegment
End="253.666666666667,-34.9422918384171" />
<mssgle:CubicBezierSegment
Point1="253.666666666667,-34.9422918384171"
Point2="257.666666666667,-34.9422918384171"
Point3="257.666666666667,-38.9422918384171" />
<mssgle:LineSegment
End="257.666666666667,-79" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="0,0,0,0"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
</GraphLayout>
</LayoutInfo>
</TaskHost>
<TaskHost
design-time-name="Package\Lookup Transformation Cache\Data Flow Task">
<LayoutInfo>
<GraphLayout
Capacity="4" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mssgm="clr-namespace:Microsoft.SqlServer.Graph.Model;assembly=Microsoft.SqlServer.Graph">
<NodeLayout
Size="150,42"
Id="Package\Lookup Transformation Cache\Data Flow Task\OLE DB Source"
TopLeft="540,197" />
<NodeLayout
Size="159,42"
Id="Package\Lookup Transformation Cache\Data Flow Task\Cache Transform"
TopLeft="542,324" />
<EdgeLayout
Id="Package\Lookup Transformation Cache\Data Flow Task.Paths[OLE DB Source Output]"
TopLeft="618.25,239">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="0,85"
Start="0,0"
End="0,77.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,77.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="0,0,0,0"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
</GraphLayout>
</LayoutInfo>
</TaskHost>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>