hange-set operation="ClearCanvas.Ris.Application.Services.Admin.DiagnosticServiceAdmin.DiagnosticServiceAdminService.UpdateDiagnosticService">
  <action type="Update" class="ClearCanvas.Healthcare.DiagnosticService" oid="73d4ca7e-04ce-4dd9-8c12-9d84015b00bc" version="2">
    <property name="ProcedureTypes">
      <old-value />
      <new-value>
        <item>ClearCanvas.Healthcare.ProcedureType:2b61c28a-5e81-46e8-8121-9d84015ab7b7</item>
      </new-value>
    </property>
  </action>
</change-set>', @p9 = '23cebdb3-7a3a-48c3-880c-9d84015b112a'
2010-05-28 21:03:51,521 [10] DEBUG - select top 1 configurat0_.OID_ as OID1_19_, configurat0_.Version_ as Version2_19_, configurat0_.DocumentName_ as Document3_19_, configurat0_.DocumentVersionString_ as Document4_19_, configurat0_.User_ as User5_19_, configurat0_.InstanceKey_ as Instance6_19_ from RIS.dbo.ConfigurationDocument_ configurat0_ where ((configurat0_.DocumentName_=@p0 )and(configurat0_.InstanceKey_ is null )and(configurat0_.User_ is null )and(configurat0_.DocumentVersionString_=@p1 )); @p0 = 'ClearCanvas.Ris.Client.Admin.LocationSummaryComponent.val.xml', @p1 = '00002.00000'
2010-05-28 21:03:51,656 [10] DEBUG - Validating session for user 
2010-05-28 21:03:51,657 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:03:51,660 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:18:51', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'
2010-05-28 21:03:51,709 [10] DEBUG - select facility0_.OID_ as OID1_40_, facility0_.Version_ as Version2_40_, facility0_.Code_ as Code3_40_, facility0_.Name_ as Name4_40_, facility0_.InformationAuthority_ as Informat5_40_, facility0_.Deactivated_ as Deactiva6_40_ from RIS.dbo.Facility_ facility0_ where (facility0_.Deactivated_=@p0 ); @p0 = 'False'
2010-05-28 21:03:51,751 [10] DEBUG - Validating session for user 
2010-05-28 21:03:51,752 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:03:51,799 [10] DEBUG - select top 51 location0_.OID_ as OID1_119_, location0_.Version_ as Version2_119_, location0_.Id_ as Id3_119_, location0_.Name_ as Name4_119_, location0_.Description_ as Descript5_119_, location0_.FacilityOID_ as Facility6_119_, location0_.Building_ as Building7_119_, location0_.Floor_ as Floor8_119_, location0_.PointOfCare_ as PointOfC9_119_, location0_.Room_ as Room10_119_, location0_.Bed_ as Bed11_119_, location0_.Deactivated_ as Deactiv12_119_ from RIS.dbo.Location_ location0_ order by  location0_.Id_ asc
2010-05-28 21:04:02,253 [10] DEBUG - Validating session for user 
2010-05-28 21:04:02,257 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:19:02', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'
2010-05-28 21:04:02,287 [10] DEBUG - select top 1 configurat0_.OID_ as OID1_19_, configurat0_.Version_ as Version2_19_, configurat0_.DocumentName_ as Document3_19_, configurat0_.DocumentVersionString_ as Document4_19_, configurat0_.User_ as User5_19_, configurat0_.InstanceKey_ as Instance6_19_ from RIS.dbo.ConfigurationDocument_ configurat0_ where ((configurat0_.DocumentName_=@p0 )and(configurat0_.InstanceKey_ is null )and(configurat0_.User_ is null )and(configurat0_.DocumentVersionString_=@p1 )); @p0 = 'ClearCanvas.Ris.Application.Services.WorklistSettings', @p1 = '00002.00000'
2010-05-28 21:04:02,294 [10] DEBUG - select count_big(*) as x0_0_ from RIS.dbo.Procedure_ procedure0_ inner join RIS.dbo.Order_ order1_ on procedure0_.OrderOID_=order1_.OID_ inner join RIS.dbo.ProcedureType_ proceduret2_ on procedure0_.ProcedureTypeOID_=proceduret2_.OID_ inner join RIS.dbo.DiagnosticService_ diagnostic3_ on order1_.DiagnosticServiceOID_=diagnostic3_.OID_ inner join RIS.dbo.Visit_ visit4_ on order1_.VisitOID_=visit4_.OID_ inner join RIS.dbo.Patient_ patient5_ on order1_.PatientOID_=patient5_.OID_ inner join RIS.dbo.PatientProfile_ profiles6_ on patient5_.OID_=profiles6_.PatientOID_, RIS.dbo.Facility_ facility7_ where (((procedure0_.Status_=@p0 )and(procedure0_.ScheduledStartTime_ is null )and(procedure0_.DowntimeRecoveryMode_=@p1 ))and(profiles6_.MrnAssigningAuthority_=facility7_.InformationAuthority_  and procedure0_.PerformingFacilityOID_=facility7_.OID_)); @p0 = 'SC', @p1 = 'False'
2010-05-28 21:04:02,327 [10] DEBUG - Validating session for user 
2010-05-28 21:04:02,328 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:04:02,379 [10] DEBUG - Validating session for user 
2010-05-28 21:04:02,412 [10] DEBUG - select count_big(*) as x0_0_ from RIS.dbo.ProcedureStep_ protocolas0_ inner join RIS.dbo.Protocol_ protocol1_ on protocolas0_.ProtocolOID_=protocol1_.OID_ inner join RIS.dbo.Procedure_ procedure2_ on protocolas0_.ProcedureOID_=procedure2_.OID_ inner join RIS.dbo.Order_ order3_ on procedure2_.OrderOID_=order3_.OID_ inner join RIS.dbo.ProcedureType_ proceduret4_ on procedure2_.ProcedureTypeOID_=proceduret4_.OID_ inner join RIS.dbo.DiagnosticService_ diagnostic5_ on order3_.DiagnosticServiceOID_=diagnostic5_.OID_ inner join RIS.dbo.Visit_ visit6_ on order3_.VisitOID_=visit6_.OID_ inner join RIS.dbo.Patient_ patient7_ on order3_.PatientOID_=patient7_.OID_ inner join RIS.dbo.PatientProfile_ profiles8_ on patient7_.OID_=profiles8_.PatientOID_, RIS.dbo.Facility_ facility9_ where protocolas0_.Discriminator_='PROTOCOL_ASSIGNMENT' and ((((protocolas0_.State_ in(@p0 , @p1))and(procedure2_.Status_=@p2 )and(procedure2_.DowntimeRecoveryMode_=@p3 ))and(profiles8_.MrnAssigningAuthority_=facility9_.InformationAuthority_  and procedure2_.PerformingFacilityOID_=facility9_.OID_))); @p0 = 'SC', @p1 = 'IP', @p2 = 'SC', @p3 = 'False'
2010-05-28 21:04:02,441 [10] DEBUG - select count_big(*) as x0_0_ from RIS.dbo.ProcedureStep_ protocolas0_ inner join RIS.dbo.Protocol_ protocol1_ on protocolas0_.ProtocolOID_=protocol1_.OID_ inner join RIS.dbo.Procedure_ procedure2_ on protocolas0_.ProcedureOID_=procedure2_.OID_ inner join RIS.dbo.Order_ order3_ on procedure2_.OrderOID_=order3_.OID_ inner join RIS.dbo.ProcedureType_ proceduret4_ on procedure2_.ProcedureTypeOID_=proceduret4_.OID_ inner join RIS.dbo.DiagnosticService_ diagnostic5_ on order3_.DiagnosticServiceOID_=diagnostic5_.OID_ inner join RIS.dbo.Visit_ visit6_ on order3_.VisitOID_=visit6_.OID_ inner join RIS.dbo.Patient_ patient7_ on order3_.PatientOID_=patient7_.OID_ inner join RIS.dbo.PatientProfile_ profiles8_ on patient7_.OID_=profiles8_.PatientOID_, RIS.dbo.ProcedureCheckIn_ procedurec9_, RIS.dbo.Facility_ facility10_ where protocolas0_.Discriminator_='PROTOCOL_ASSIGNMENT' and ((((protocolas0_.State_=@p0 )and(procedure2_.ScheduledStartTime_ is null )and(procedure2_.Status_=@p1 )and(procedurec9_.CheckInTime_ is null  and procedure2_.ProcedureCheckInOID_=procedurec9_.OID_)and(procedure2_.DowntimeRecoveryMode_=@p2 ))and(profiles8_.MrnAssigningAuthority_=facility10_.InformationAuthority_  and procedure2_.PerformingFacilityOID_=facility10_.OID_))); @p0 = 'CM', @p1 = 'SC', @p2 = 'False'
2010-05-28 21:04:02,442 [10] DEBUG - Validating session for user 
2010-05-28 21:04:02,465 [10] DEBUG - select count_big(*) as x0_0_ from RIS.dbo.ProcedureStep_ protocolre0_ inner join RIS.dbo.Protocol_ protocol1_ on protocolre0_.ProtocolOID_=protocol1_.OID_ inner join RIS.dbo.Procedure_ procedure2_ on protocolre0_.ProcedureOID_=procedure2_.OID_ inner join RIS.dbo.Order_ order3_ on procedure2_.OrderOID_=order3_.OID_ inner join RIS.dbo.ProcedureType_ proceduret4_ on procedure2_.ProcedureTypeOID_=proceduret4_.OID_ inner join RIS.dbo.DiagnosticService_ diagnostic5_ on order3_.DiagnosticServiceOID_=diagnostic5_.OID_ inner join RIS.dbo.Visit_ visit6_ on order3_.VisitOID_=visit6_.OID_ inner join RIS.dbo.Patient_ patient7_ on order3_.PatientOID_=patient7_.OID_ inner join RIS.dbo.PatientProfile_ profiles8_ on patient7_.OID_=profiles8_.PatientOID_, RIS.dbo.Facility_ facility9_ where protocolre0_.Discriminator_='PROTOCOL_RESOLUTION' and ((((protocolre0_.State_=@p0 )and(procedure2_.DowntimeRecoveryMode_=@p1 ))and(profiles8_.MrnAssigningAuthority_=facility9_.InformationAuthority_  and procedure2_.PerformingFacilityOID_=facility9_.OID_))); @p0 = 'SC', @p1 = 'False'
2010-05-28 21:04:03,381 [10] DEBUG - Validating session for user 
2010-05-28 21:04:03,385 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:19:03', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'
2010-05-28 21:04:03,414 [10] DEBUG - SELECT order0_.OID_ as OID1_65_2_, order0_.Version_ as Version2_65_2_, order0_.PatientOID_ as PatientOID3_65_2_, order0_.VisitOID_ as VisitOID4_65_2_, order0_.PlacerNumber_ as PlacerNu5_65_2_, order0_.AccessionNumber_ as Accessio6_65_2_, order0_.DiagnosticServiceOID_ as Diagnost7_65_2_, order0_.EnteredTime_ as EnteredT8_65_2_, order0_.EnteredByOID_ as EnteredB9_65_2_, order0_.EnteredComment_ as Entered10_65_2_, order0_.SchedulingRequestTime_ as Schedul11_65_2_, order0_.ScheduledStartTime_ as Schedul12_65_2_, order0_.StartTime_ as StartTime13_65_2_, order0_.EndTime_ as EndTime14_65_2_, order0_.OrderingPractitionerOID_ as Orderin15_65_2_, order0_.OrderingFacilityOID_ as Orderin16_65_2_, order0_.ReasonForStudy_ as ReasonF17_65_2_, order0_.Priority_ as Priority18_65_2_, order0_.Status_ as Status19_65_2_, order0_.CancelReason_ as CancelR20_65_2_, order0_.CancelledByOID_ as Cancell21_65_2_, order0_.CancelComment_ as CancelC22_65_2_, order0_.ReplacementOrderOID_ as Replace23_65_2_, patient1_.OID_ as OID1_7_0_, patient1_.Version_ as Version2_7_0_, diagnostic2_.OID_ as OID1_63_1_, diagnostic2_.Version_ as Version2_63_1_, diagnostic2_.Id_ as Id3_63_1_, diagnostic2_.Name_ as Name4_63_1_, diagnostic2_.Deactivated_ as Deactiva5_63_1_ FROM RIS.dbo.Order_ order0_ inner join RIS.dbo.Patient_ patient1_ on order0_.PatientOID_=patient1_.OID_ inner join RIS.dbo.DiagnosticService_ diagnostic2_ on order0_.DiagnosticServiceOID_=diagnostic2_.OID_ WHERE order0_.OID_=@p0; @p0 = '11cc9eb3-c249-4e4c-90fe-9d840154380c'
2010-05-28 21:04:03,446 [10] DEBUG - Validating session for user 
2010-05-28 21:04:03,447 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:04:03,521 [10] DEBUG - SELECT order0_.OID_ as OID1_65_2_, order0_.Version_ as Version2_65_2_, order0_.PatientOID_ as PatientOID3_65_2_, order0_.VisitOID_ as VisitOID4_65_2_, order0_.PlacerNumber_ as PlacerNu5_65_2_, order0_.AccessionNumber_ as Accessio6_65_2_, order0_.DiagnosticServiceOID_ as Diagnost7_65_2_, order0_.EnteredTime_ as EnteredT8_65_2_, order0_.EnteredByOID_ as EnteredB9_65_2_, order0_.EnteredComment_ as Entered10_65_2_, order0_.SchedulingRequestTime_ as Schedul11_65_2_, order0_.ScheduledStartTime_ as Schedul12_65_2_, order0_.StartTime_ as StartTime13_65_2_, order0_.EndTime_ as EndTime14_65_2_, order0_.OrderingPractitionerOID_ as Orderin15_65_2_, order0_.OrderingFacilityOID_ as Orderin16_65_2_, order0_.ReasonForStudy_ as ReasonF17_65_2_, order0_.Priority_ as Priority18_65_2_, order0_.Status_ as Status19_65_2_, order0_.CancelReason_ as CancelR20_65_2_, order0_.CancelledByOID_ as Cancell21_65_2_, order0_.CancelComment_ as CancelC22_65_2_, order0_.ReplacementOrderOID_ as Replace23_65_2_, patient1_.OID_ as OID1_7_0_, patient1_.Version_ as Version2_7_0_, diagnostic2_.OID_ as OID1_63_1_, diagnostic2_.Version_ as Version2_63_1_, diagnostic2_.Id_ as Id3_63_1_, diagnostic2_.Name_ as Name4_63_1_, diagnostic2_.Deactivated_ as Deactiva5_63_1_ FROM RIS.dbo.Order_ order0_ inner join RIS.dbo.Patient_ patient1_ on order0_.PatientOID_=patient1_.OID_ inner join RIS.dbo.DiagnosticService_ diagnostic2_ on order0_.DiagnosticServiceOID_=diagnostic2_.OID_ WHERE order0_.OID_=@p0; @p0 = '11cc9eb3-c249-4e4c-90fe-9d840154380c'
2010-05-28 21:04:03,522 [10] DEBUG - select top 1 staff0_.OID_ as OID1_57_, staff0_.Version_ as Version2_57_, staff0_.Id_ as Id3_57_, staff0_.FamilyName_ as FamilyName4_57_, staff0_.GivenName_ as GivenName5_57_, staff0_.MiddleName_ as MiddleName6_57_, staff0_.Prefix_ as Prefix7_57_, staff0_.Suffix_ as Suffix8_57_, staff0_.Degree_ as Degree9_57_, staff0_.Sex_ as Sex10_57_, staff0_.Title_ as Title11_57_, staff0_.LicenseNumber_ as License12_57_, staff0_.BillingNumber_ as Billing13_57_, staff0_.Type_ as Type14_57_, staff0_.UserName_ as UserName15_57_, staff0_.Deactivated_ as Deactiv16_57_ from RIS.dbo.Staff_ staff0_ where (staff0_.UserName_=@p0 ); @p0 = 'admiralston'
2010-05-28 21:04:03,524 [10] DEBUG - SELECT procedures0_.OrderOID_ as OrderOID3_3_, procedures0_.OID_ as OID1_3_, procedures0_.OID_ as OID1_0_2_, procedures0_.Version_ as Version2_0_2_, procedures0_.OrderOID_ as OrderOID3_0_2_, procedures0_.ProcedureTypeOID_ as Procedur4_0_2_, procedures0_.Index_ as Index5_0_2_, procedures0_.ScheduledStartTime_ as Schedule6_0_2_, procedures0_.StartTime_ as StartTime7_0_2_, procedures0_.EndTime_ as EndTime8_0_2_, procedures0_.Status_ as Status9_0_2_, procedures0_.PerformingFacilityOID_ as Perform10_0_2_, procedures0_.Laterality_ as Laterality11_0_2_, procedures0_.Portable_ as Portable12_0_2_, procedures0_.ProcedureCheckInOID_ as Procedu13_0_2_, procedures0_.ImageAvailability_ as ImageAv14_0_2_, procedures0_.DowntimeRecoveryMode_ as Downtim15_0_2_, proceduret1_.OID_ as OID1_80_0_, proceduret1_.Version_ as Version2_80_0_, proceduret1_.Id_ as Id3_80_0_, proceduret1_.Name_ as Name4_80_0_, proceduret1_.BaseTypeOID_ as BaseType5_80_0_, proceduret1_.PlanXml_ as PlanXml6_80_0_, proceduret1_.Deactivated_ as Deactiva7_80_0_, procedurec2_.OID_ as OID1_54_1_, procedurec2_.Version_ as Version2_54_1_, procedurec2_.CheckInTime_ as CheckInT3_54_1_, procedurec2_.CheckOutTime_ as CheckOut4_54_1_ FROM RIS.dbo.Procedure_ procedures0_ inner join RIS.dbo.ProcedureType_ proceduret1_ on procedures0_.ProcedureTypeOID_=proceduret1_.OID_ left outer join RIS.dbo.ProcedureCheckIn_ procedurec2_ on procedures0_.ProcedureCheckInOID_=procedurec2_.OID_ WHERE procedures0_.OrderOID_=@p0; @p0 = '11cc9eb3-c249-4e4c-90fe-9d840154380c'
2010-05-28 21:04:03,526 [10] DEBUG - SELECT procedures0_.ProcedureOID_ as Procedur4_2_, procedures0_.OID_ as OID1_2_, procedures0_.OID_ as OID1_20_1_, procedures0_.Version_ as Version3_20_1_, procedures0_.ProcedureOID_ as Procedur4_20_1_, procedures0_.CreationTime_ as Creation5_20_1_, procedures0_.State_ as State6_20_1_, procedures0_.LastStateChangeTime_ as LastStat7_20_1_, procedures0_.ScheduledStartTime_ as Schedule8_20_1_, procedures0_.ScheduledEndTime_ as Schedule9_20_1_, procedures0_.ScheduledPerformerStaffOID_ as Schedul10_20_1_, procedures0_.PerformerStaffOID_ as Perform11_20_1_, procedures0_.StartTime_ as StartTime12_20_1_, procedures0_.EndTime_ as EndTime13_20_1_, procedures0_.LinkStepOID_ as LinkSte14_20_1_, procedures0_.ReportPartOID_ as ReportP15_20_1_, procedures0_.ProtocolOID_ as Protoco16_20_1_, procedures0_.FailureCount_ as Failure17_20_1_, procedures0_.LastFailureTime_ as LastFai18_20_1_, procedures0_.Description_ as Descrip19_20_1_, procedures0_.ModalityOID_ as Modalit20_20_1_, procedures0_.HasErrors_ as HasErrors21_20_1_, procedures0_.Discriminator_ as Discrimi2_20_1_, modality1_.OID_ as OID1_56_0_, modality1_.Version_ as Version2_56_0_, modality1_.Id_ as Id3_56_0_, modality1_.Name_ as Name4_56_0_, modality1_.Deactivated_ as Deactiva5_56_0_ FROM RIS.dbo.ProcedureStep_ procedures0_ left outer join RIS.dbo.Modality_ modality1_ on procedures0_.ModalityOID_=modality1_.OID_ WHERE procedures0_.ProcedureOID_=@p0; @p0 = '78f6ec90-200c-41c1-a868-9d8401543819'
2010-05-28 21:04:03,620 [10] DEBUG - Validating session for user 
2010-05-28 21:04:03,647 [10] DEBUG - SELECT patientpro0_.OID_ as OID1_9_1_, patientpro0_.Version_ as Version2_9_1_, patientpro0_.MrnId_ as MrnId3_9_1_, patientpro0_.MrnAssigningAuthority_ as MrnAssig4_9_1_, patientpro0_.HealthcardId_ as Healthca5_9_1_, patientpro0_.HealthcardAssigningAuthority_ as Healthca6_9_1_, patientpro0_.HealthcardVersionCode_ as Healthca7_9_1_, patientpro0_.HealthcardExpiryDate_ as Healthca8_9_1_, patientpro0_.FamilyName_ as FamilyName9_9_1_, patientpro0_.GivenName_ as GivenName10_9_1_, patientpro0_.MiddleName_ as MiddleName11_9_1_, patientpro0_.Prefix_ as Prefix12_9_1_, patientpro0_.Suffix_ as Suffix13_9_1_, patientpro0_.Degree_ as Degree14_9_1_, patientpro0_.DateOfBirth_ as DateOfB15_9_1_, patientpro0_.Sex_ as Sex16_9_1_, patientpro0_.PrimaryLanguage_ as Primary17_9_1_, patientpro0_.Religion_ as Religion18_9_1_, patientpro0_.DeathIndicator_ as DeathIn19_9_1_, patientpro0_.TimeOfDeath_ as TimeOfD20_9_1_, patientpro0_.PatientOID_ as PatientOID21_9_1_, patient1_.OID_ as OID1_7_0_, patient1_.Version_ as Version2_7_0_ FROM RIS.dbo.PatientProfile_ patientpro0_ inner join RIS.dbo.Patient_ patient1_ on patientpro0_.PatientOID_=patient1_.OID_ WHERE patientpro0_.OID_=@p0; @p0 = '4bdb5faa-7495-4940-8a45-9d84014a958f'
2010-05-28 21:04:03,648 [10] DEBUG - SELECT insurancea0_.Code_ as Code1_5_0_, insurancea0_.Value_ as Value2_5_0_, insurancea0_.Description_ as Descript3_5_0_, insurancea0_.DisplayOrder_ as DisplayO4_5_0_, insurancea0_.Deactivated_ as Deactiva5_5_0_ FROM RIS.dbo.InsuranceAuthorityEnum_ insurancea0_ WHERE insurancea0_.Code_=@p0; @p0 = 'X'
2010-05-28 21:04:03,648 [10] DEBUG - SELECT sexenum0_.Code_ as Code1_120_0_, sexenum0_.Value_ as Value2_120_0_, sexenum0_.Description_ as Descript3_120_0_, sexenum0_.DisplayOrder_ as DisplayO4_120_0_, sexenum0_.Deactivated_ as Deactiva5_120_0_ FROM RIS.dbo.SexEnum_ sexenum0_ WHERE sexenum0_.Code_=@p0; @p0 = 'M'
2010-05-28 21:04:03,649 [10] DEBUG - SELECT spokenlang0_.Code_ as Code1_93_0_, spokenlang0_.Value_ as Value2_93_0_, spokenlang0_.Description_ as Descript3_93_0_, spokenlang0_.DisplayOrder_ as DisplayO4_93_0_, spokenlang0_.Deactivated_ as Deactiva5_93_0_ FROM RIS.dbo.SpokenLanguageEnum_ spokenlang0_ WHERE spokenlang0_.Code_=@p0; @p0 = 'en'
2010-05-28 21:04:03,649 [10] DEBUG - SELECT religionen0_.Code_ as Code1_38_0_, religionen0_.Value_ as Value2_38_0_, religionen0_.Description_ as Descript3_38_0_, religionen0_.DisplayOrder_ as DisplayO4_38_0_, religionen0_.Deactivated_ as Deactiva5_38_0_ FROM RIS.dbo.ReligionEnum_ religionen0_ WHERE religionen0_.Code_=@p0; @p0 = 'VAR'
2010-05-28 21:04:03,649 [10] DEBUG - SELECT addresses0_.PatientProfileOID_ as PatientP1_0_, addresses0_.Street_ as Street2_0_, addresses0_.Unit_ as Unit3_0_, addresses0_.City_ as City4_0_, addresses0_.Province_ as Province5_0_, addresses0_.PostalCode_ as PostalCode6_0_, addresses0_.Country_ as Country7_0_, addresses0_.Type_ as Type8_0_, addresses0_.ValidFrom_ as ValidFrom9_0_, addresses0_.ValidUntil_ as ValidUntil10_0_, addresses0_.OID_ as OID11_0_ FROM RIS.dbo.PatientProfileAddress_ addresses0_ WHERE addresses0_.PatientProfileOID_=@p0; @p0 = '4bdb5faa-7495-4940-8a45-9d84014a958f'
2010-05-28 21:04:03,653 [10] DEBUG - SELECT addresstyp0_.Code_ as Code1_77_0_, addresstyp0_.Value_ as Value2_77_0_, addresstyp0_.Description_ as Descript3_77_0_, addresstyp0_.DisplayOrder_ as DisplayO4_77_0_, addresstyp0_.Deactivated_ as Deactiva5_77_0_ FROM RIS.dbo.AddressTypeEnum_ addresstyp0_ WHERE addresstyp0_.Code_=@p0; @p0 = 'R'
2010-05-28 21:04:03,654 [10] DEBUG - SELECT telephonen0_.PatientProfileOID_ as PatientP1_0_, telephonen0_.CountryCode_ as CountryC2_0_, telephonen0_.AreaCode_ as AreaCode3_0_, telephonen0_.Number_ as Number4_0_, telephonen0_.Extension_ as Extension5_0_, telephonen0_.Use_ as Use6_0_, telephonen0_.Equipment_ as Equipment7_0_, telephonen0_.ValidFrom_ as ValidFrom8_0_, telephonen0_.ValidUntil_ as ValidUntil9_0_, telephonen0_.OID_ as OID10_0_ FROM RIS.dbo.PatientProfileTelephoneNumber_ telephonen0_ WHERE telephonen0_.PatientProfileOID_=@p0; @p0 = '4bdb5faa-7495-4940-8a45-9d84014a958f'
2010-05-28 21:04:03,658 [10] DEBUG - SELECT notes0_.PatientOID_ as PatientOID3_1_, notes0_.OID_ as OID1_1_, notes0_.OID_ as OID1_41_0_, notes0_.Version_ as Version2_41_0_, notes0_.PatientOID_ as PatientOID3_41_0_, notes0_.CreationTime_ as Creation4_41_0_, notes0_.AuthorOID_ as AuthorOID5_41_0_, notes0_.CategoryOID_ as Category6_41_0_, notes0_.Comment_ as Comment7_41_0_, notes0_.ValidFrom_ as ValidFrom8_41_0_, notes0_.ValidUntil_ as ValidUntil9_41_0_ FROM RIS.dbo.PatientNote_ notes0_ WHERE notes0_.PatientOID_=@p0; @p0 = 'c3482ac8-3ded-446a-893e-9d84014a958f'
2010-05-28 21:04:03,659 [10] DEBUG - select patientpro0_.OID_ as OID1_9_0_, patient1_.OID_ as OID1_7_1_, patientpro0_.Version_ as Version2_9_0_, patientpro0_.MrnId_ as MrnId3_9_0_, patientpro0_.MrnAssigningAuthority_ as MrnAssig4_9_0_, patientpro0_.HealthcardId_ as Healthca5_9_0_, patientpro0_.HealthcardAssigningAuthority_ as Healthca6_9_0_, patientpro0_.HealthcardVersionCode_ as Healthca7_9_0_, patientpro0_.HealthcardExpiryDate_ as Healthca8_9_0_, patientpro0_.FamilyName_ as FamilyName9_9_0_, patientpro0_.GivenName_ as GivenName10_9_0_, patientpro0_.MiddleName_ as MiddleName11_9_0_, patientpro0_.Prefix_ as Prefix12_9_0_, patientpro0_.Suffix_ as Suffix13_9_0_, patientpro0_.Degree_ as Degree14_9_0_, patientpro0_.DateOfBirth_ as DateOfB15_9_0_, patientpro0_.Sex_ as Sex16_9_0_, patientpro0_.PrimaryLanguage_ as Primary17_9_0_, patientpro0_.Religion_ as Religion18_9_0_, patientpro0_.DeathIndicator_ as DeathIn19_9_0_, patientpro0_.TimeOfDeath_ as TimeOfD20_9_0_, patientpro0_.PatientOID_ as PatientOID21_9_0_, patient1_.Version_ as Version2_7_1_ from RIS.dbo.PatientProfile_ patientpro0_ inner join RIS.dbo.Patient_ patient1_ on patientpro0_.PatientOID_=patient1_.OID_ where ((patientpro0_.FamilyName_=@p0 )and(patientpro0_.GivenName_=@p1 )and(patientpro0_.DateOfBirth_=@p2 )and(patientpro0_.Sex_=@p3 )); @p0 = 'bloggs', @p1 = 'Joe', @p2 = '28/05/1989 00:00:00', @p3 = 'M'
2010-05-28 21:04:03,660 [10] DEBUG - SELECT profiles0_.PatientOID_ as PatientOID21_1_, profiles0_.OID_ as OID1_1_, profiles0_.OID_ as OID1_9_0_, profiles0_.Version_ as Version2_9_0_, profiles0_.MrnId_ as MrnId3_9_0_, profiles0_.MrnAssigningAuthority_ as MrnAssig4_9_0_, profiles0_.HealthcardId_ as Healthca5_9_0_, profiles0_.HealthcardAssigningAuthority_ as Healthca6_9_0_, profiles0_.HealthcardVersionCode_ as Healthca7_9_0_, profiles0_.HealthcardExpiryDate_ as Healthca8_9_0_, profiles0_.FamilyName_ as FamilyName9_9_0_, profiles0_.GivenName_ as GivenName10_9_0_, profiles0_.MiddleName_ as MiddleName11_9_0_, profiles0_.Prefix_ as Prefix12_9_0_, profiles0_.Suffix_ as Suffix13_9_0_, profiles0_.Degree_ as Degree14_9_0_, profiles0_.DateOfBirth_ as DateOfB15_9_0_, profiles0_.Sex_ as Sex16_9_0_, profiles0_.PrimaryLanguage_ as Primary17_9_0_, profiles0_.Religion_ as Religion18_9_0_, profiles0_.DeathIndicator_ as DeathIn19_9_0_, profiles0_.TimeOfDeath_ as TimeOfD20_9_0_, profiles0_.PatientOID_ as PatientOID21_9_0_ FROM RIS.dbo.PatientProfile_ profiles0_ WHERE profiles0_.PatientOID_=@p0; @p0 = 'c3482ac8-3ded-446a-893e-9d84014a958f'
2010-05-28 21:04:03,661 [10] DEBUG - select top 1 configurat0_.OID_ as OID1_19_, configurat0_.Version_ as Version2_19_, configurat0_.DocumentName_ as Document3_19_, configurat0_.DocumentVersionString_ as Document4_19_, configurat0_.User_ as User5_19_, configurat0_.InstanceKey_ as Instance6_19_ from RIS.dbo.ConfigurationDocument_ configurat0_ where ((configurat0_.DocumentName_=@p0 )and(configurat0_.InstanceKey_ is null )and(configurat0_.User_ is null )and(configurat0_.DocumentVersionString_=@p1 )); @p0 = 'ClearCanvas.Healthcare.Alerts.AlertsSettings', @p1 = '00002.00000'
2010-05-28 21:04:03,662 [10] DEBUG - select procedure0_.OID_ as OID1_0_0_, order1_.OID_ as OID1_65_1_, visit2_.OID_ as OID1_99_2_, procedure0_.Version_ as Version2_0_0_, procedure0_.OrderOID_ as OrderOID3_0_0_, procedure0_.ProcedureTypeOID_ as Procedur4_0_0_, procedure0_.Index_ as Index5_0_0_, procedure0_.ScheduledStartTime_ as Schedule6_0_0_, procedure0_.StartTime_ as StartTime7_0_0_, procedure0_.EndTime_ as EndTime8_0_0_, procedure0_.Status_ as Status9_0_0_, procedure0_.PerformingFacilityOID_ as Perform10_0_0_, procedure0_.Laterality_ as Laterality11_0_0_, procedure0_.Portable_ as Portable12_0_0_, procedure0_.ProcedureCheckInOID_ as Procedu13_0_0_, procedure0_.ImageAvailability_ as ImageAv14_0_0_, procedure0_.DowntimeRecoveryMode_ as Downtim15_0_0_, order1_.Version_ as Version2_65_1_, order1_.PatientOID_ as PatientOID3_65_1_, order1_.VisitOID_ as VisitOID4_65_1_, order1_.PlacerNumber_ as PlacerNu5_65_1_, order1_.AccessionNumber_ as Accessio6_65_1_, order1_.DiagnosticServiceOID_ as Diagnost7_65_1_, order1_.EnteredTime_ as EnteredT8_65_1_, order1_.EnteredByOID_ as EnteredB9_65_1_, order1_.EnteredComment_ as Entered10_65_1_, order1_.SchedulingRequestTime_ as Schedul11_65_1_, order1_.ScheduledStartTime_ as Schedul12_65_1_, order1_.StartTime_ as StartTime13_65_1_, order1_.EndTime_ as EndTime14_65_1_, order1_.OrderingPractitionerOID_ as Orderin15_65_1_, order1_.OrderingFacilityOID_ as Orderin16_65_1_, order1_.ReasonForStudy_ as ReasonF17_65_1_, order1_.Priority_ as Priority18_65_1_, order1_.Status_ as Status19_65_1_, order1_.CancelReason_ as CancelR20_65_1_, order1_.CancelledByOID_ as Cancell21_65_1_, order1_.CancelComment_ as CancelC22_65_1_, order1_.ReplacementOrderOID_ as Replace23_65_1_, visit2_.Version_ as Version2_99_2_, visit2_.PatientOID_ as PatientOID3_99_2_, visit2_.VisitNumberId_ as VisitNum4_99_2_, visit2_.VisitNumberAssigningAuthority_ as VisitNum5_99_2_, visit2_.Status_ as Status6_99_2_, visit2_.AdmitTime_ as AdmitTime7_99_2_, visit2_.DischargeTime_ as Discharg8_99_2_, visit2_.DischargeDisposition_ as Discharg9_99_2_, visit2_.PatientClass_ as Patient10_99_2_, visit2_.PatientType_ as Patient11_99_2_, visit2_.AdmissionType_ as Admissi12_99_2_, visit2_.FacilityOID_ as Facilit13_99_2_, visit2_.CurrentLocationOID_ as Current14_99_2_, visit2_.VipIndicator_ as VipIndi15_99_2_, visit2_.PreadmitNumber_ as Preadmi16_99_2_ from RIS.dbo.Procedure_ procedure0_ inner join RIS.dbo.Order_ order1_ on procedure0_.OrderOID_=order1_.OID_ inner join RIS.dbo.Visit_ visit2_ on order1_.VisitOID_=visit2_.OID_ where (order1_.PatientOID_=@p0 ); @p0 = 'c3482ac8-3ded-446a-893e-9d84014a958f'
2010-05-28 21:04:03,770 [10] DEBUG - SELECT externalpr0_.OID_ as OID1_81_0_, externalpr0_.Version_ as Version2_81_0_, externalpr0_.FamilyName_ as FamilyName3_81_0_, externalpr0_.GivenName_ as GivenName4_81_0_, externalpr0_.MiddleName_ as MiddleName5_81_0_, externalpr0_.Prefix_ as Prefix6_81_0_, externalpr0_.Suffix_ as Suffix7_81_0_, externalpr0_.Degree_ as Degree8_81_0_, externalpr0_.LicenseNumber_ as LicenseN9_81_0_, externalpr0_.BillingNumber_ as Billing10_81_0_, externalpr0_.Deactivated_ as Deactiv11_81_0_ FROM RIS.dbo.ExternalPractitioner_ externalpr0_ WHERE externalpr0_.OID_=@p0; @p0 = '3d2aeb9b-3c18-419e-b3c6-9d840143798e'
2010-05-28 21:04:03,771 [10] DEBUG - SELECT orderprior0_.Code_ as Code1_21_0_, orderprior0_.Value_ as Value2_21_0_, orderprior0_.Description_ as Descript3_21_0_, orderprior0_.DisplayOrder_ as DisplayO4_21_0_, orderprior0_.Deactivated_ as Deactiva5_21_0_ FROM RIS.dbo.OrderPriorityEnum_ orderprior0_ WHERE orderprior0_.Code_=@p0; @p0 = 'A'
2010-05-28 21:04:03,771 [10] DEBUG - SELECT orderstatu0_.Code_ as Code1_53_0_, orderstatu0_.Value_ as Value2_53_0_, orderstatu0_.Description_ as Descript3_53_0_, orderstatu0_.DisplayOrder_ as DisplayO4_53_0_, orderstatu0_.Deactivated_ as Deactiva5_53_0_ FROM RIS.dbo.OrderStatusEnum_ orderstatu0_ WHERE orderstatu0_.Code_=@p0; @p0 = 'SC'
2010-05-28 21:04:03,772 [10] DEBUG - SELECT patientcla0_.Code_ as Code1_39_0_, patientcla0_.Value_ as Value2_39_0_, patientcla0_.Description_ as Descript3_39_0_, patientcla0_.DisplayOrder_ as DisplayO4_39_0_, patientcla0_.Deactivated_ as Deactiva5_39_0_ FROM RIS.dbo.PatientClassEnum_ patientcla0_ WHERE patientcla0_.Code_=@p0; @p0 = 'E'
2010-05-28 21:04:03,773 [10] DEBUG - SELECT patienttyp0_.Code_ as Code1_104_0_, patienttyp0_.Value_ as Value2_104_0_, patienttyp0_.Description_ as Descript3_104_0_, patienttyp0_.DisplayOrder_ as DisplayO4_104_0_, patienttyp0_.Deactivated_ as Deactiva5_104_0_ FROM RIS.dbo.PatientTypeEnum_ patienttyp0_ WHERE patienttyp0_.Code_=@p0; @p0 = 'X'
2010-05-28 21:04:03,773 [10] DEBUG - SELECT admissiont0_.Code_ as Code1_121_0_, admissiont0_.Value_ as Value2_121_0_, admissiont0_.Description_ as Descript3_121_0_, admissiont0_.DisplayOrder_ as DisplayO4_121_0_, admissiont0_.Deactivated_ as Deactiva5_121_0_ FROM RIS.dbo.AdmissionTypeEnum_ admissiont0_ WHERE admissiont0_.Code_=@p0; @p0 = 'X'
2010-05-28 21:04:03,774 [10] DEBUG - SELECT visitstatu0_.Code_ as Code1_43_0_, visitstatu0_.Value_ as Value2_43_0_, visitstatu0_.Description_ as Descript3_43_0_, visitstatu0_.DisplayOrder_ as DisplayO4_43_0_, visitstatu0_.Deactivated_ as Deactiva5_43_0_ FROM RIS.dbo.VisitStatusEnum_ visitstatu0_ WHERE visitstatu0_.Code_=@p0; @p0 = 'PA'
2010-05-28 21:04:03,774 [10] DEBUG - SELECT procedurec0_.OID_ as OID1_54_0_, procedurec0_.Version_ as Version2_54_0_, procedurec0_.CheckInTime_ as CheckInT3_54_0_, procedurec0_.CheckOutTime_ as CheckOut4_54_0_ FROM RIS.dbo.ProcedureCheckIn_ procedurec0_ WHERE procedurec0_.OID_=@p0; @p0 = 'cb3526d7-7110-4a66-884b-9d8401543819'
2010-05-28 21:04:03,775 [10] DEBUG - SELECT procedures0_.Code_ as Code1_6_0_, procedures0_.Value_ as Value2_6_0_, procedures0_.Description_ as Descript3_6_0_, procedures0_.DisplayOrder_ as DisplayO4_6_0_, procedures0_.Deactivated_ as Deactiva5_6_0_ FROM RIS.dbo.ProcedureStatusEnum_ procedures0_ WHERE procedures0_.Code_=@p0; @p0 = 'SC'
2010-05-28 21:04:03,775 [10] DEBUG - SELECT laterality0_.Code_ as Code1_42_0_, laterality0_.Value_ as Value2_42_0_, laterality0_.Description_ as Descript3_42_0_, laterality0_.DisplayOrder_ as DisplayO4_42_0_, laterality0_.Deactivated_ as Deactiva5_42_0_ FROM RIS.dbo.LateralityEnum_ laterality0_ WHERE laterality0_.Code_=@p0; @p0 = 'N'
2010-05-28 21:04:03,784 [10] DEBUG - SELECT extendedpr0_.VisitOID_ as VisitOID1_0_, extendedpr0_.Value_ as Value2_0_, extendedpr0_.Name_ as Name3_0_ FROM RIS.dbo.VisitExtendedProperty_ extendedpr0_ WHERE extendedpr0_.VisitOID_=@p0; @p0 = '910fd851-bb80-4720-b30d-9d84014bdf0e'
2010-05-28 21:04:03,785 [10] DEBUG - SELECT locations0_.VisitOID_ as VisitOID1_1_, locations0_.LocationOID_ as Location2_1_, locations0_.Role_ as Role3_1_, locations0_.StartTime_ as StartTime4_1_, locations0_.EndTime_ as EndTime5_1_, locations0_.OID_ as OID6_1_, location1_.OID_ as OID1_119_0_, location1_.Version_ as Version2_119_0_, location1_.Id_ as Id3_119_0_, location1_.Name_ as Name4_119_0_, location1_.Description_ as Descript5_119_0_, location1_.FacilityOID_ as Facility6_119_0_, location1_.Building_ as Building7_119_0_, location1_.Floor_ as Floor8_119_0_, location1_.PointOfCare_ as PointOfC9_119_0_, location1_.Room_ as Room10_119_0_, location1_.Bed_ as Bed11_119_0_, location1_.Deactivated_ as Deactiv12_119_0_ FROM RIS.dbo.VisitLocation_ locations0_ inner join RIS.dbo.Location_ location1_ on locations0_.LocationOID_=location1_.OID_ WHERE locations0_.VisitOID_=@p0; @p0 = '910fd851-bb80-4720-b30d-9d84014bdf0e'
2010-05-28 21:04:03,785 [10] DEBUG - SELECT practition0_.VisitOID_ as VisitOID1_1_, practition0_.PractitionerOID_ as Practiti2_1_, practition0_.Role_ as Role3_1_, practition0_.StartTime_ as StartTime4_1_, practition0_.EndTime_ as EndTime5_1_, practition0_.OID_ as OID6_1_, externalpr1_.OID_ as OID1_81_0_, externalpr1_.Version_ as Version2_81_0_, externalpr1_.FamilyName_ as FamilyName3_81_0_, externalpr1_.GivenName_ as GivenName4_81_0_, externalpr1_.MiddleName_ as MiddleName5_81_0_, externalpr1_.Prefix_ as Prefix6_81_0_, externalpr1_.Suffix_ as Suffix7_81_0_, externalpr1_.Degree_ as Degree8_81_0_, externalpr1_.LicenseNumber_ as LicenseN9_81_0_, externalpr1_.BillingNumber_ as Billing10_81_0_, externalpr1_.Deactivated_ as Deactiv11_81_0_ FROM RIS.dbo.VisitPractitioner_ practition0_ inner join RIS.dbo.ExternalPractitioner_ externalpr1_ on practition0_.PractitionerOID_=externalpr1_.OID_ WHERE practition0_.VisitOID_=@p0; @p0 = '910fd851-bb80-4720-b30d-9d84014bdf0e'
2010-05-28 21:04:03,785 [10] DEBUG - SELECT ambulatory0_.VisitOID_ as VisitOID1_1_, ambulatory0_.AmbulatoryStatus_ as Ambulato2_1_, ambulatory1_.Code_ as Code1_118_0_, ambulatory1_.Value_ as Value2_118_0_, ambulatory1_.Description_ as Descript3_118_0_, ambulatory1_.DisplayOrder_ as DisplayO4_118_0_, ambulatory1_.Deactivated_ as Deactiva5_118_0_ FROM RIS.dbo.VisitAmbulatoryStatus_ ambulatory0_ left outer join RIS.dbo.AmbulatoryStatusEnum_ ambulatory1_ on ambulatory0_.AmbulatoryStatus_=ambulatory1_.Code_ WHERE ambulatory0_.VisitOID_=@p0; @p0 = '910fd851-bb80-4720-b30d-9d84014bdf0e'
2010-05-28 21:04:03,788 [10] DEBUG - SELECT stafftypee0_.Code_ as Code1_73_0_, stafftypee0_.Value_ as Value2_73_0_, stafftypee0_.Description_ as Descript3_73_0_, stafftypee0_.DisplayOrder_ as DisplayO4_73_0_, stafftypee0_.Deactivated_ as Deactiva5_73_0_ FROM RIS.dbo.StaffTypeEnum_ stafftypee0_ WHERE stafftypee0_.Code_=@p0; @p0 = 'SADH'
2010-05-28 21:04:03,788 [10] DEBUG - SELECT procedures0_.OrderOID_ as OrderOID3_3_, procedures0_.OID_ as OID1_3_, procedures0_.OID_ as OID1_0_2_, procedures0_.Version_ as Version2_0_2_, procedures0_.OrderOID_ as OrderOID3_0_2_, procedures0_.ProcedureTypeOID_ as Procedur4_0_2_, procedures0_.Index_ as Index5_0_2_, procedures0_.ScheduledStartTime_ as Schedule6_0_2_, procedures0_.StartTime_ as StartTime7_0_2_, procedures0_.EndTime_ as EndTime8_0_2_, procedures0_.Status_ as Status9_0_2_, procedures0_.PerformingFacilityOID_ as Perform10_0_2_, procedures0_.Laterality_ as Laterality11_0_2_, procedures0_.Portable_ as Portable12_0_2_, procedures0_.ProcedureCheckInOID_ as Procedu13_0_2_, procedures0_.ImageAvailability_ as ImageAv14_0_2_, procedures0_.DowntimeRecoveryMode_ as Downtim15_0_2_, proceduret1_.OID_ as OID1_80_0_, proceduret1_.Version_ as Version2_80_0_, proceduret1_.Id_ as Id3_80_0_, proceduret1_.Name_ as Name4_80_0_, proceduret1_.BaseTypeOID_ as BaseType5_80_0_, proceduret1_.PlanXml_ as PlanXml6_80_0_, proceduret1_.Deactivated_ as Deactiva7_80_0_, procedurec2_.OID_ as OID1_54_1_, procedurec2_.Version_ as Version2_54_1_, procedurec2_.CheckInTime_ as CheckInT3_54_1_, procedurec2_.CheckOutTime_ as CheckOut4_54_1_ FROM RIS.dbo.Procedure_ procedures0_ inner join RIS.dbo.ProcedureType_ proceduret1_ on procedures0_.ProcedureTypeOID_=proceduret1_.OID_ left outer join RIS.dbo.ProcedureCheckIn_ procedurec2_ on procedures0_.ProcedureCheckInOID_=procedurec2_.OID_ WHERE procedures0_.OrderOID_=@p0; @p0 = '11cc9eb3-c249-4e4c-90fe-9d840154380c'
2010-05-28 21:04:03,789 [10] DEBUG - SELECT imageavail0_.Code_ as Code1_115_0_, imageavail0_.Value_ as Value2_115_0_, imageavail0_.Description_ as Descript3_115_0_, imageavail0_.DisplayOrder_ as DisplayO4_115_0_, imageavail0_.Deactivated_ as Deactiva5_115_0_ FROM RIS.dbo.ImageAvailabilityEnum_ imageavail0_ WHERE imageavail0_.Code_=@p0; @p0 = 'X'
2010-05-28 21:04:03,790 [10] DEBUG - SELECT procedures0_.ProcedureOID_ as Procedur4_2_, procedures0_.OID_ as OID1_2_, procedures0_.OID_ as OID1_20_1_, procedures0_.Version_ as Version3_20_1_, procedures0_.ProcedureOID_ as Procedur4_20_1_, procedures0_.CreationTime_ as Creation5_20_1_, procedures0_.State_ as State6_20_1_, procedures0_.LastStateChangeTime_ as LastStat7_20_1_, procedures0_.ScheduledStartTime_ as Schedule8_20_1_, procedures0_.ScheduledEndTime_ as Schedule9_20_1_, procedures0_.ScheduledPerformerStaffOID_ as Schedul10_20_1_, procedures0_.PerformerStaffOID_ as Perform11_20_1_, procedures0_.StartTime_ as StartTime12_20_1_, procedures0_.EndTime_ as EndTime13_20_1_, procedures0_.LinkStepOID_ as LinkSte14_20_1_, procedures0_.ReportPartOID_ as ReportP15_20_1_, procedures0_.ProtocolOID_ as Protoco16_20_1_, procedures0_.FailureCount_ as Failure17_20_1_, procedures0_.LastFailureTime_ as LastFai18_20_1_, procedures0_.Description_ as Descrip19_20_1_, procedures0_.ModalityOID_ as Modalit20_20_1_, procedures0_.HasErrors_ as HasErrors21_20_1_, procedures0_.Discriminator_ as Discrimi2_20_1_, modality1_.OID_ as OID1_56_0_, modality1_.Version_ as Version2_56_0_, modality1_.Id_ as Id3_56_0_, modality1_.Name_ as Name4_56_0_, modality1_.Deactivated_ as Deactiva5_56_0_ FROM RIS.dbo.ProcedureStep_ procedures0_ left outer join RIS.dbo.Modality_ modality1_ on procedures0_.ModalityOID_=modality1_.OID_ WHERE procedures0_.ProcedureOID_=@p0; @p0 = '78f6ec90-200c-41c1-a868-9d8401543819'
2010-05-28 21:04:03,790 [10] DEBUG - SELECT activityst0_.Code_ as Code1_78_0_, activityst0_.Value_ as Value2_78_0_, activityst0_.Description_ as Descript3_78_0_, activityst0_.DisplayOrder_ as DisplayO4_78_0_, activityst0_.Deactivated_ as Deactiva5_78_0_ FROM RIS.dbo.ActivityStatusEnum_ activityst0_ WHERE activityst0_.Code_=@p0; @p0 = 'SC'
2010-05-28 21:04:03,791 [10] DEBUG - SELECT protocols0_.ProcedureOID_ as Procedur1_1_, protocols0_.ProtocolOID_ as Protocol2_1_, protocol1_.OID_ as OID1_48_0_, protocol1_.Version_ as Version2_48_0_, protocol1_.AuthorOID_ as AuthorOID3_48_0_, protocol1_.SupervisorOID_ as Supervis4_48_0_, protocol1_.Status_ as Status5_48_0_, protocol1_.Urgency_ as Urgency6_48_0_, protocol1_.RejectReason_ as RejectRe7_48_0_ FROM RIS.dbo.ProcedureProtocol_ protocols0_ left outer join RIS.dbo.Protocol_ protocol1_ on protocols0_.ProtocolOID_=protocol1_.OID_ WHERE protocols0_.ProcedureOID_=@p0; @p0 = '78f6ec90-200c-41c1-a868-9d8401543819'
2010-05-28 21:04:03,791 [10] DEBUG - select ordernote0_.OID_ as OID1_85_, ordernote0_.Version_ as Version3_85_, ordernote0_.Category_ as Category4_85_, ordernote0_.Body_ as Body5_85_, ordernote0_.Urgent_ as Urgent6_85_, ordernote0_.CreationTime_ as Creation7_85_, ordernote0_.AuthorOID_ as AuthorOID8_85_, ordernote0_.OnBehalfOfGroupOID_ as OnBehalf9_85_, ordernote0_.PostTime_ as PostTime10_85_, ordernote0_.IsFullyAcknowledged_ as IsFully11_85_, ordernote0_.OrderOID_ as OrderOID12_85_ from RIS.dbo.Note_ ordernote0_ where ordernote0_.Discriminator_='ORDER' and (((ordernote0_.OrderOID_=@p0 )and(ordernote0_.PostTime_ is not null ))); @p0 = '11cc9eb3-c249-4e4c-90fe-9d840154380c'
2010-05-28 21:04:04,775 [11] DEBUG - select top 20 publicatio0_.OID_ as OID1_90_, publicatio0_.Version_ as Version3_90_, publicatio0_.ProcedureOID_ as Procedur4_90_, publicatio0_.CreationTime_ as Creation5_90_, publicatio0_.State_ as State6_90_, publicatio0_.LastStateChangeTime_ as LastStat7_90_, publicatio0_.ScheduledStartTime_ as Schedule8_90_, publicatio0_.ScheduledEndTime_ as Schedule9_90_, publicatio0_.ScheduledPerformerStaffOID_ as Schedul10_90_, publicatio0_.PerformerStaffOID_ as Perform11_90_, publicatio0_.StartTime_ as StartTime12_90_, publicatio0_.EndTime_ as EndTime13_90_, publicatio0_.LinkStepOID_ as LinkSte14_90_, publicatio0_.ReportPartOID_ as ReportP16_90_, publicatio0_.FailureCount_ as Failure20_90_, publicatio0_.LastFailureTime_ as LastFai21_90_ from RIS.dbo.ProcedureStep_ publicatio0_ where publicatio0_.Discriminator_='PUBLICATION' and ((((publicatio0_.State_=@p0 )and(publicatio0_.ScheduledPerformerStaffOID_ is not null )and(publicatio0_.ScheduledStartTime_<@p1 )and(publicatio0_.LastFailureTime_ is null ))or((publicatio0_.State_=@p2 )and(publicatio0_.ScheduledPerformerStaffOID_ is not null )and(publicatio0_.ScheduledStartTime_<@p3 )and(publicatio0_.LastFailureTime_<@p4 )))) order by  publicatio0_.ScheduledStartTime_ asc; @p0 = 'SC', @p1 = '28/05/2010 21:04:04', @p2 = 'SC', @p3 = '28/05/2010 21:04:04', @p4 = '28/05/2010 20:59:04'
2010-05-28 21:04:05,626 [10] DEBUG - Validating session for user 
2010-05-28 21:04:05,630 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:19:05', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'
2010-05-28 21:04:05,658 [10] DEBUG - select visit0_.OID_ as OID1_99_, visit0_.Version_ as Version2_99_, visit0_.PatientOID_ as PatientOID3_99_, visit0_.VisitNumberId_ as VisitNum4_99_, visit0_.VisitNumberAssigningAuthority_ as VisitNum5_99_, visit0_.Status_ as Status6_99_, visit0_.AdmitTime_ as AdmitTime7_99_, visit0_.DischargeTime_ as Discharg8_99_, visit0_.DischargeDisposition_ as Discharg9_99_, visit0_.PatientClass_ as Patient10_99_, visit0_.PatientType_ as Patient11_99_, visit0_.AdmissionType_ as Admissi12_99_, visit0_.FacilityOID_ as Facilit13_99_, visit0_.CurrentLocationOID_ as Current14_99_, visit0_.VipIndicator_ as VipIndi15_99_, visit0_.PreadmitNumber_ as Preadmi16_99_ from RIS.dbo.Visit_ visit0_ where (visit0_.PatientOID_=@p0 ) order by  visit0_.AdmitTime_ desc; @p0 = 'c3482ac8-3ded-446a-893e-9d84014a958f'
2010-05-28 21:04:05,658 [10] DEBUG - SELECT patient0_.OID_ as OID1_7_0_, patient0_.Version_ as Version2_7_0_ FROM RIS.dbo.Patient_ patient0_ WHERE patient0_.OID_=@p0; @p0 = 'c3482ac8-3ded-446a-893e-9d84014a958f'
2010-05-28 21:04:05,663 [10] DEBUG - select facility0_.OID_ as OID1_40_, facility0_.Version_ as Version2_40_, facility0_.Code_ as Code3_40_, facility0_.Name_ as Name4_40_, facility0_.InformationAuthority_ as Informat5_40_, facility0_.Deactivated_ as Deactiva6_40_ from RIS.dbo.Facility_ facility0_ where (facility0_.Deactivated_=@p0 ); @p0 = 'False'
2010-05-28 21:04:05,663 [10] DEBUG - select orderprior0_.Code_ as Code1_21_, orderprior0_.Value_ as Value2_21_, orderprior0_.Description_ as Descript3_21_, orderprior0_.DisplayOrder_ as DisplayO4_21_, orderprior0_.Deactivated_ as Deactiva5_21_ from RIS.dbo.OrderPriorityEnum_ orderprior0_ where (Deactivated_=@p0 ) order by  DisplayOrder_ asc; @p0 = 'False'
2010-05-28 21:04:05,664 [10] DEBUG - select ordercance0_.Code_ as Code1_69_, ordercance0_.Value_ as Value2_69_, ordercance0_.Description_ as Descript3_69_, ordercance0_.DisplayOrder_ as DisplayO4_69_, ordercance0_.Deactivated_ as Deactiva5_69_ from RIS.dbo.OrderCancelReasonEnum_ ordercance0_ where (Deactivated_=@p0 ) order by  DisplayOrder_ asc; @p0 = 'False'
2010-05-28 21:04:05,665 [10] DEBUG - select laterality0_.Code_ as Code1_42_, laterality0_.Value_ as Value2_42_, laterality0_.Description_ as Descript3_42_, laterality0_.DisplayOrder_ as DisplayO4_42_, laterality0_.Deactivated_ as Deactiva5_42_ from RIS.dbo.LateralityEnum_ laterality0_ where (Deactivated_=@p0 ) order by  DisplayOrder_ asc; @p0 = 'False'
2010-05-28 21:04:06,231 [10] DEBUG - Validating session for user 
2010-05-28 21:04:06,231 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:04:06,234 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:19:06', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'
2010-05-28 21:04:06,261 [10] DEBUG - SELECT patientpro0_.OID_ as OID1_9_1_, patientpro0_.Version_ as Version2_9_1_, patientpro0_.MrnId_ as MrnId3_9_1_, patientpro0_.MrnAssigningAuthority_ as MrnAssig4_9_1_, patientpro0_.HealthcardId_ as Healthca5_9_1_, patientpro0_.HealthcardAssigningAuthority_ as Healthca6_9_1_, patientpro0_.HealthcardVersionCode_ as Healthca7_9_1_, patientpro0_.HealthcardExpiryDate_ as Healthca8_9_1_, patientpro0_.FamilyName_ as FamilyName9_9_1_, patientpro0_.GivenName_ as GivenName10_9_1_, patientpro0_.MiddleName_ as MiddleName11_9_1_, patientpro0_.Prefix_ as Prefix12_9_1_, patientpro0_.Suffix_ as Suffix13_9_1_, patientpro0_.Degree_ as Degree14_9_1_, patientpro0_.DateOfBirth_ as DateOfB15_9_1_, patientpro0_.Sex_ as Sex16_9_1_, patientpro0_.PrimaryLanguage_ as Primary17_9_1_, patientpro0_.Religion_ as Religion18_9_1_, patientpro0_.DeathIndicator_ as DeathIn19_9_1_, patientpro0_.TimeOfDeath_ as TimeOfD20_9_1_, patientpro0_.PatientOID_ as PatientOID21_9_1_, patient1_.OID_ as OID1_7_0_, patient1_.Version_ as Version2_7_0_ FROM RIS.dbo.PatientProfile_ patientpro0_ inner join RIS.dbo.Patient_ patient1_ on patientpro0_.PatientOID_=patient1_.OID_ WHERE patientpro0_.OID_=@p0; @p0 = '4bdb5faa-7495-4940-8a45-9d84014a958f'
2010-05-28 21:04:06,265 [10] DEBUG - SELECT addresses0_.PatientProfileOID_ as PatientP1_0_, addresses0_.Street_ as Street2_0_, addresses0_.Unit_ as Unit3_0_, addresses0_.City_ as City4_0_, addresses0_.Province_ as Province5_0_, addresses0_.PostalCode_ as PostalCode6_0_, addresses0_.Country_ as Country7_0_, addresses0_.Type_ as Type8_0_, addresses0_.ValidFrom_ as ValidFrom9_0_, addresses0_.ValidUntil_ as ValidUntil10_0_, addresses0_.OID_ as OID11_0_ FROM RIS.dbo.PatientProfileAddress_ addresses0_ WHERE addresses0_.PatientProfileOID_=@p0; @p0 = '4bdb5faa-7495-4940-8a45-9d84014a958f'
2010-05-28 21:04:06,266 [10] DEBUG - SELECT telephonen0_.PatientProfileOID_ as PatientP1_0_, telephonen0_.CountryCode_ as CountryC2_0_, telephonen0_.AreaCode_ as AreaCode3_0_, telephonen0_.Number_ as Number4_0_, telephonen0_.Extension_ as Extension5_0_, telephonen0_.Use_ as Use6_0_, telephonen0_.Equipment_ as Equipment7_0_, telephonen0_.ValidFrom_ as ValidFrom8_0_, telephonen0_.ValidUntil_ as ValidUntil9_0_, telephonen0_.OID_ as OID10_0_ FROM RIS.dbo.PatientProfileTelephoneNumber_ telephonen0_ WHERE telephonen0_.PatientProfileOID_=@p0; @p0 = '4bdb5faa-7495-4940-8a45-9d84014a958f'
2010-05-28 21:04:06,266 [10] DEBUG - SELECT notes0_.PatientOID_ as PatientOID3_1_, notes0_.OID_ as OID1_1_, notes0_.OID_ as OID1_41_0_, notes0_.Version_ as Version2_41_0_, notes0_.PatientOID_ as PatientOID3_41_0_, notes0_.CreationTime_ as Creation4_41_0_, notes0_.AuthorOID_ as AuthorOID5_41_0_, notes0_.CategoryOID_ as Category6_41_0_, notes0_.Comment_ as Comment7_41_0_, notes0_.ValidFrom_ as ValidFrom8_41_0_, notes0_.ValidUntil_ as ValidUntil9_41_0_ FROM RIS.dbo.PatientNote_ notes0_ WHERE notes0_.PatientOID_=@p0; @p0 = 'c3482ac8-3ded-446a-893e-9d84014a958f'
2010-05-28 21:04:06,267 [10] DEBUG - select patientpro0_.OID_ as OID1_9_0_, patient1_.OID_ as OID1_7_1_, patientpro0_.Version_ as Version2_9_0_, patientpro0_.MrnId_ as MrnId3_9_0_, patientpro0_.MrnAssigningAuthority_ as MrnAssig4_9_0_, patientpro0_.HealthcardId_ as Healthca5_9_0_, patientpro0_.HealthcardAssigningAuthority_ as Healthca6_9_0_, patientpro0_.HealthcardVersionCode_ as Healthca7_9_0_, patientpro0_.HealthcardExpiryDate_ as Healthca8_9_0_, patientpro0_.FamilyName_ as FamilyName9_9_0_, patientpro0_.GivenName_ as GivenName10_9_0_, patientpro0_.MiddleName_ as MiddleName11_9_0_, patientpro0_.Prefix_ as Prefix12_9_0_, patientpro0_.Suffix_ as Suffix13_9_0_, patientpro0_.Degree_ as Degree14_9_0_, patientpro0_.DateOfBirth_ as DateOfB15_9_0_, patientpro0_.Sex_ as Sex16_9_0_, patientpro0_.PrimaryLanguage_ as Primary17_9_0_, patientpro0_.Religion_ as Religion18_9_0_, patientpro0_.DeathIndicator_ as DeathIn19_9_0_, patientpro0_.TimeOfDeath_ as TimeOfD20_9_0_, patientpro0_.PatientOID_ as PatientOID21_9_0_, patient1_.Version_ as Version2_7_1_ from RIS.dbo.PatientProfile_ patientpro0_ inner join RIS.dbo.Patient_ patient1_ on patientpro0_.PatientOID_=patient1_.OID_ where ((patientpro0_.FamilyName_=@p0 )and(patientpro0_.GivenName_=@p1 )and(patientpro0_.DateOfBirth_=@p2 )and(patientpro0_.Sex_=@p3 )); @p0 = 'bloggs', @p1 = 'Joe', @p2 = '28/05/1989 00:00:00', @p3 = 'M'
2010-05-28 21:04:06,267 [10] DEBUG - SELECT profiles0_.PatientOID_ as PatientOID21_1_, profiles0_.OID_ as OID1_1_, profiles0_.OID_ as OID1_9_0_, profiles0_.Version_ as Version2_9_0_, profiles0_.MrnId_ as MrnId3_9_0_, profiles0_.MrnAssigningAuthority_ as MrnAssig4_9_0_, profiles0_.HealthcardId_ as Healthca5_9_0_, profiles0_.HealthcardAssigningAuthority_ as Healthca6_9_0_, profiles0_.HealthcardVersionCode_ as Healthca7_9_0_, profiles0_.HealthcardExpiryDate_ as Healthca8_9_0_, profiles0_.FamilyName_ as FamilyName9_9_0_, profiles0_.GivenName_ as GivenName10_9_0_, profiles0_.MiddleName_ as MiddleName11_9_0_, profiles0_.Prefix_ as Prefix12_9_0_, profiles0_.Suffix_ as Suffix13_9_0_, profiles0_.Degree_ as Degree14_9_0_, profiles0_.DateOfBirth_ as DateOfB15_9_0_, profiles0_.Sex_ as Sex16_9_0_, profiles0_.PrimaryLanguage_ as Primary17_9_0_, profiles0_.Religion_ as Religion18_9_0_, profiles0_.DeathIndicator_ as DeathIn19_9_0_, profiles0_.TimeOfDeath_ as TimeOfD20_9_0_, profiles0_.PatientOID_ as PatientOID21_9_0_ FROM RIS.dbo.PatientProfile_ profiles0_ WHERE profiles0_.PatientOID_=@p0; @p0 = 'c3482ac8-3ded-446a-893e-9d84014a958f'
2010-05-28 21:04:08,403 [10] DEBUG - Validating session for user 
2010-05-28 21:04:08,404 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:04:08,407 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:19:08', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'
2010-05-28 21:04:08,437 [10] DEBUG - select top 51 diagnostic0_.OID_ as OID1_63_, diagnostic0_.Version_ as Version2_63_, diagnostic0_.Id_ as Id3_63_, diagnostic0_.Name_ as Name4_63_, diagnostic0_.Deactivated_ as Deactiva5_63_ from RIS.dbo.DiagnosticService_ diagnostic0_ where (diagnostic0_.Deactivated_=@p0 ) order by  diagnostic0_.Id_ asc; @p0 = 'False'
2010-05-28 21:04:10,765 [10] DEBUG - Validating session for user 
2010-05-28 21:04:10,766 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:04:10,769 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:19:10', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'
2010-05-28 21:04:13,094 [10] DEBUG - SELECT proceduret0_.DiagnosticServiceOID_ as Diagnost1_1_, proceduret0_.ProcedureTypeOID_ as Procedur2_1_, proceduret1_.OID_ as OID1_80_0_, proceduret1_.Version_ as Version2_80_0_, proceduret1_.Id_ as Id3_80_0_, proceduret1_.Name_ as Name4_80_0_, proceduret1_.BaseTypeOID_ as BaseType5_80_0_, proceduret1_.PlanXml_ as PlanXml6_80_0_, proceduret1_.Deactivated_ as Deactiva7_80_0_ FROM RIS.dbo.DiagnosticServiceProcedureType_ proceduret0_ left outer join RIS.dbo.ProcedureType_ proceduret1_ on proceduret0_.ProcedureTypeOID_=proceduret1_.OID_ WHERE proceduret0_.DiagnosticServiceOID_=@p0; @p0 = '73d4ca7e-04ce-4dd9-8c12-9d84015b00bc'
2010-05-28 21:04:14,368 [10] DEBUG - Validating session for user 
2010-05-28 21:04:14,369 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:04:14,372 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:19:14', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'
2010-05-28 21:04:14,435 [10] DEBUG - select top 51 externalpr0_.OID_ as OID1_81_, externalpr0_.Version_ as Version2_81_, externalpr0_.FamilyName_ as FamilyName3_81_, externalpr0_.GivenName_ as GivenName4_81_, externalpr0_.MiddleName_ as MiddleName5_81_, externalpr0_.Prefix_ as Prefix6_81_, externalpr0_.Suffix_ as Suffix7_81_, externalpr0_.Degree_ as Degree8_81_, externalpr0_.LicenseNumber_ as LicenseN9_81_, externalpr0_.BillingNumber_ as Billing10_81_, externalpr0_.Deactivated_ as Deactiv11_81_ from RIS.dbo.ExternalPractitioner_ externalpr0_ where (externalpr0_.Deactivated_=@p0 ) order by  externalpr0_.FamilyName_ asc; @p0 = 'False'
2010-05-28 21:04:15,849 [10] DEBUG - Validating session for user 
2010-05-28 21:04:15,850 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:04:15,853 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:19:15', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'
2010-05-28 21:04:15,882 [10] DEBUG - SELECT contactpoi0_.PractitionerOID_ as Practiti3_1_, contactpoi0_.OID_ as OID1_1_, contactpoi0_.OID_ as OID1_15_0_, contactpoi0_.Version_ as Version2_15_0_, contactpoi0_.PractitionerOID_ as Practiti3_15_0_, contactpoi0_.Name_ as Name4_15_0_, contactpoi0_.Description_ as Descript5_15_0_, contactpoi0_.PreferredResultCommunicationMode_ as Preferre6_15_0_, contactpoi0_.IsDefaultContactPoint_ as IsDefaul7_15_0_, contactpoi0_.Deactivated_ as Deactiva8_15_0_ FROM RIS.dbo.ExternalPractitionerContactPoint_ contactpoi0_ WHERE contactpoi0_.PractitionerOID_=@p0; @p0 = '3d2aeb9b-3c18-419e-b3c6-9d840143798e'
2010-05-28 21:04:15,883 [10] DEBUG - SELECT telephonen0_.ExternalPractitionerContactPointOID_ as External1_0_, telephonen0_.CountryCode_ as CountryC2_0_, telephonen0_.AreaCode_ as AreaCode3_0_, telephonen0_.Number_ as Number4_0_, telephonen0_.Extension_ as Extension5_0_, telephonen0_.Use_ as Use6_0_, telephonen0_.Equipment_ as Equipment7_0_, telephonen0_.ValidFrom_ as ValidFrom8_0_, telephonen0_.ValidUntil_ as ValidUntil9_0_, telephonen0_.OID_ as OID10_0_ FROM RIS.dbo.ExternalPractitionerContactPointTelephoneNumber_ telephonen0_ WHERE telephonen0_.ExternalPractitionerContactPointOID_=@p0; @p0 = '8dc9479d-eb71-492f-81a8-9d84014379c1'
2010-05-28 21:04:15,883 [10] DEBUG - SELECT addresses0_.ExternalPractitionerContactPointOID_ as External1_0_, addresses0_.Street_ as Street2_0_, addresses0_.Unit_ as Unit3_0_, addresses0_.City_ as City4_0_, addresses0_.Province_ as Province5_0_, addresses0_.PostalCode_ as PostalCode6_0_, addresses0_.Country_ as Country7_0_, addresses0_.Type_ as Type8_0_, addresses0_.ValidFrom_ as ValidFrom9_0_, addresses0_.ValidUntil_ as ValidUntil10_0_, addresses0_.OID_ as OID11_0_ FROM RIS.dbo.ExternalPractitionerContactPointAddress_ addresses0_ WHERE addresses0_.ExternalPractitionerContactPointOID_=@p0; @p0 = '8dc9479d-eb71-492f-81a8-9d84014379c1'
2010-05-28 21:04:15,883 [10] DEBUG - SELECT emailaddre0_.ExternalPractitionerContactPointOID_ as External1_0_, emailaddre0_.Address_ as Address2_0_, emailaddre0_.ValidFrom_ as ValidFrom3_0_, emailaddre0_.ValidUntil_ as ValidUntil4_0_, emailaddre0_.OID_ as OID5_0_ FROM RIS.dbo.ExternalPractitionerContactPointEmailAddress_ emailaddre0_ WHERE emailaddre0_.ExternalPractitionerContactPointOID_=@p0; @p0 = '8dc9479d-eb71-492f-81a8-9d84014379c1'
2010-05-28 21:04:15,884 [10] DEBUG - SELECT resultcomm0_.Code_ as Code1_108_0_, resultcomm0_.Value_ as Value2_108_0_, resultcomm0_.Description_ as Descript3_108_0_, resultcomm0_.DisplayOrder_ as DisplayO4_108_0_, resultcomm0_.Deactivated_ as Deactiva5_108_0_ FROM RIS.dbo.ResultCommunicationModeEnum_ resultcomm0_ WHERE resultcomm0_.Code_=@p0; @p0 = 'ANY'
2010-05-28 21:04:15,885 [10] DEBUG - SELECT addresstyp0_.Code_ as Code1_77_0_, addresstyp0_.Value_ as Value2_77_0_, addresstyp0_.Description_ as Descript3_77_0_, addresstyp0_.DisplayOrder_ as DisplayO4_77_0_, addresstyp0_.Deactivated_ as Deactiva5_77_0_ FROM RIS.dbo.AddressTypeEnum_ addresstyp0_ WHERE addresstyp0_.Code_=@p0; @p0 = 'B'
2010-05-28 21:04:24,045 [10] DEBUG - Validating session for user 
2010-05-28 21:04:24,046 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:04:24,050 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:19:24', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'
2010-05-28 21:04:24,053 [10] DEBUG - Validating session for user 
2010-05-28 21:04:24,053 [10] DEBUG - select top 1 usersessio0_.OID_ as OID1_105_, usersessio0_.UserOID_ as UserOID2_105_, usersessio0_.HostName_ as HostName3_105_, usersessio0_.Application_ as Applicat4_105_, usersessio0_.SessionId_ as SessionId5_105_, usersessio0_.CreationTime_ as Creation6_105_, usersessio0_.ExpiryTime_ as ExpiryTime7_105_ from RIS.dbo.UserSession_ usersessio0_ where (usersessio0_.SessionId_=@p0 ); @p0 = 'be4ebd1e9d624c688d56262453dcbfc0'
2010-05-28 21:04:24,087 [10] DEBUG - select top 1 configurat0_.OID_ as OID1_19_, configurat0_.Version_ as Version2_19_, configurat0_.DocumentName_ as Document3_19_, configurat0_.DocumentVersionString_ as Document4_19_, configurat0_.User_ as User5_19_, configurat0_.InstanceKey_ as Instance6_19_ from RIS.dbo.ConfigurationDocument_ configurat0_ where ((configurat0_.DocumentName_=@p0 )and(configurat0_.InstanceKey_ is null )and(configurat0_.User_ is null )and(configurat0_.DocumentVersionString_=@p1 )); @p0 = 'ClearCanvas.Ris.Application.Services.OrderNoteSettings', @p1 = '00002.00000'
2010-05-28 21:04:24,089 [10] DEBUG - select count_big(*) as x0_0_ from RIS.dbo.Note_ ordernote0_ inner join RIS.dbo.NotePosting_ postings1_ on ordernote0_.OID_=postings1_.NoteOID_ inner join RIS.dbo.Order_ order2_ on ordernote0_.OrderOID_=order2_.OID_ inner join RIS.dbo.Patient_ patient3_ on order2_.PatientOID_=patient3_.OID_ inner join RIS.dbo.PatientProfile_ profiles4_ on patient3_.OID_=profiles4_.PatientOID_, RIS.dbo.Facility_ facility5_ where ordernote0_.Discriminator_='ORDER' and (((profiles4_.MrnAssigningAuthority_=facility5_.InformationAuthority_  and order2_.OrderingFacilityOID_=facility5_.OID_)and((postings1_.IsAcknowledged_=@p0 )and(postings1_.OID_=(select staffnotep6_.OID_ from RIS.dbo.NotePosting_ staffnotep6_ where staffnotep6_.Discriminator_='STAFF' and ((staffnotep6_.OID_=postings1_.OID_ )and(staffnotep6_.RecipientStaffOID_=@p1 ))))))); @p0 = 'False', @p1 = '71ffe599-4ea7-448a-8693-9d8401431a1b'
2010-05-28 21:04:24,091 [10] DEBUG - select count_big(*) as x0_0_ from RIS.dbo.Note_ ordernote0_ inner join RIS.dbo.Order_ order1_ on ordernote0_.OrderOID_=order1_.OID_ inner join RIS.dbo.Patient_ patient2_ on order1_.PatientOID_=patient2_.OID_ inner join RIS.dbo.PatientProfile_ profiles3_ on patient2_.OID_=profiles3_.PatientOID_, RIS.dbo.Facility_ facility4_ where ordernote0_.Discriminator_='ORDER' and (((profiles3_.MrnAssigningAuthority_=facility4_.InformationAuthority_  and order1_.OrderingFacilityOID_=facility4_.OID_)and((ordernote0_.IsFullyAcknowledged_=@p0 )and(ordernote0_.AuthorOID_=@p1 ))and((select count(postings5_.NoteOID_) from RIS.dbo.NotePosting_ postings5_ where ordernote0_.OID_=postings5_.NoteOID_)>0 ))); @p0 = 'False', @p1 = '71ffe599-4ea7-448a-8693-9d8401431a1b'
2010-05-28 21:04:24,115 [10] DEBUG - Validating session for user 
2010-05-28 21:04:24,144 [10] DEBUG - SELECT staffgroup0_.OID_ as OID1_35_0_, staffgroup0_.Version_ as Version2_35_0_, staffgroup0_.Name_ as Name3_35_0_, staffgroup0_.Description_ as Descript4_35_0_, staffgroup0_.Elective_ as Elective5_35_0_, staffgroup0_.Deactivated_ as Deactiva6_35_0_ FROM RIS.dbo.StaffGroup_ staffgroup0_ WHERE staffgroup0_.OID_=@p0; @p0 = 'd90cb7ec-f850-4535-aa6a-9d84014322f5'
2010-05-28 21:04:24,144 [10] DEBUG - select count_big(*) as x0_0_ from RIS.dbo.Note_ ordernote0_ inner join RIS.dbo.NotePosting_ postings1_ on ordernote0_.OID_=postings1_.NoteOID_ inner join RIS.dbo.Order_ order2_ on ordernote0_.OrderOID_=order2_.OID_ inner join RIS.dbo.Patient_ patient3_ on order2_.PatientOID_=patient3_.OID_ inner join RIS.dbo.PatientProfile_ profiles4_ on patient3_.OID_=profiles4_.PatientOID_, RIS.dbo.Facility_ facility5_ where ordernote0_.Discriminator_='ORDER' and (((profiles4_.MrnAssigningAuthority_=facility5_.InformationAuthority_  and order2_.OrderingFacilityOID_=facility5_.OID_)and((postings1_.IsAcknowledged_=@p0 )and(postings1_.OID_=(select groupnotep6_.OID_ from RIS.dbo.NotePosting_ groupnotep6_ where groupnotep6_.Discriminator_='GROUP' and ((groupnotep6_.OID_=postings1_.OID_ )and(groupnotep6_.RecipientGroupOID_=@p1 ))))))); @p0 = 'False', @p1 = 'd90cb7ec-f850-4535-aa6a-9d84014322f5'
2010-05-28 21:04:26,980 [10] DEBUG - Validating session for user 
2010-05-28 21:04:26,984 [10] DEBUG - UPDATE RIS.dbo.UserSession_ SET UserOID_ = @p0, HostName_ = @p1, Application_ = @p2, SessionId_ = @p3, CreationTime_ = @p4, ExpiryTime_ = @p5 WHERE OID_ = @p6; @p0 = '182e96aa-e026-4e39-9c1f-9d84014311c9', @p1 = 'DUNBAR-P', @p2 = 'RIS', @p3 = 'be4ebd1e9d624c688d56262453dcbfc0', @p4 = '28/05/2010 20:28:32', @p5 = '28/05/2010 21:19:26', @p6 = '9ab6640b-acce-4249-8f4f-9d8401516e2e'