{"id":2800,"date":"2023-03-01T10:41:39","date_gmt":"2023-03-01T15:41:39","guid":{"rendered":"https:\/\/labs.icahn.mssm.edu\/msdw\/?page_id=2800"},"modified":"2025-04-03T13:07:36","modified_gmt":"2025-04-03T17:07:36","slug":"protected-patients-access","status":"publish","type":"page","link":"https:\/\/labs.icahn.mssm.edu\/msdw\/services\/protected-patients-access\/","title":{"rendered":"Protected Patients Access"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;3.22&#8243;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.9.0&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; custom_padding=&#8221;||0px||false|false&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;Breadcrumb&#8221; _builder_version=&#8221;4.9.0&#8243; _module_preset=&#8221;default&#8221;]<\/p>\n<p><a href=\"https:\/\/labs.icahn.mssm.edu\/minervalab\/scientific-computing-and-data\">Scientific Computing and Data<\/a>\u00a0\/\u00a0<a href=\"https:\/\/labs.icahn.mssm.edu\/msdw\">Mount Sinai Data Warehouse<\/a> \/ <a href=\"https:\/\/labs.icahn.mssm.edu\/msdw\/about-us\/\">About MSDW<\/a> \/ Access Protected Patients<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Protected Patients Content&#8221; _builder_version=&#8221;4.9.0&#8243; _module_preset=&#8221;default&#8221; header_font=&#8221;|700|||||||&#8221; header_text_color=&#8221;#221f72&#8243; header_2_text_color=&#8221;#00aeef&#8221; header_2_font_size=&#8221;24px&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h1>Access Protected Patient Information<\/h1>\n<h2>About Protected Patient Information<\/h2>\n<p>In compliance with HIPAA privacy and security, all data queries exclude the following protected patient categories:<\/p>\n<ul>\n<li>Special Status Patients<\/li>\n<li>HIV-Related Patients<\/li>\n<li>Substance Use Patients<\/li>\n<li>Community Connect Patients<\/li>\n<\/ul>\n<p>These records are excluded from de-identified OMOP data sets and from PHI data sets unless explicitly approved by the investigator\u2019s IRB (42 CFR Part 46). For more information on Protected Patients, <a href=\"https:\/\/labs.icahn.mssm.edu\/msdw\/about-us\/protected-patient-categories\/\">click here<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h2>Request SQL Server Access<\/h2>\n<p>If you already have access to Clarity or Caboodle, but wish to remove protected patients from your data set, you must:<\/p>\n<ol>\n<li>Submit your IRB Protocol to the Scientific Computing and Data team for review to confirm specific PHI data permissions<\/li>\n<li>Create a <a href=\"https:\/\/sailpoint.mountsinai.org\/login.jsf?prompt=true\">ticket in SailPoint<\/a> to request access:\n<ul>\n<li>School users (with @mssm.edu credentials) request access to &#8220;MSDW2 API protect for School Users&#8221;<\/li>\n<li>Hospital users (with (@mountsinai.org credentials) request access to &#8220;MSDW2 API protect for Hospital Users&#8221;<\/li>\n<\/ul>\n<\/li>\n<li>Access to the SQL Server will be approved through Scientific Computing and Data<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h2>SQL Server Database Access<\/h2>\n<p>Once you have access to the SQL Server Database, you may:<\/p>\n<ol>\n<li>Access the SQL Server Database:\n<ul>\n<li>Server name: msdw_prd.mountsinai.org<\/li>\n<li>Database name: API<\/li>\n<li>View name: [API].[protect].[protected_patient]<\/li>\n<\/ul>\n<\/li>\n<li>Query the data to pull all patients in the cohort (including protected patients). An example query:<br \/>\n<blockquote>\n<p><code><span style=\"color: #3366ff\">SELECT TOP<\/span> (1000) [person_id]<\/code><\/p>\n<p><code>,[xtn_epic_patient_id]<\/code><\/p>\n<p><code>,[xtn_patient_epic_mrn]<\/code><\/p>\n<p><code>,[xtn_is_epic_connect_patient]<\/code><\/p>\n<p><code>,[xtn_has_special_status] <span style=\"color: #339966\">-- They definitely want to exclude these patients as they are VIP &amp; colleagues<\/span><\/code><\/p>\n<p><code>,[xtn_is_42_cfr_part_2_patient]<\/code><\/p>\n<p><code>,[etl_patient_exclusion_update_datetime]<\/code><\/p>\n<p><code><span style=\"color: #3366ff\">FROM<\/span> [API].[protect].[protected_patient]<\/code><\/p>\n<p><code><span style=\"color: #3366ff\">WHERE<\/span>[xtn_has_special_status] &lt;&gt; 1<\/code><\/p>\n<\/blockquote>\n<\/li>\n<li>Join this data to your own data set, from which you can exclude protected patients.<\/li>\n<\/ol>\n<p>For more information on protected patients, <a href=\"https:\/\/labs.icahn.mssm.edu\/msdw\/about-us\/protected-patient-categories\/\">click here<\/a>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Scientific Computing and Data\u00a0\/\u00a0Mount Sinai Data Warehouse \/ About MSDW \/ Access Protected PatientsAccess Protected Patient Information About Protected Patient Information In compliance with HIPAA privacy and security, all data queries exclude the following protected patient categories: Special Status Patients HIV-Related Patients Substance Use Patients Community Connect Patients These records are excluded from de-identified OMOP [&hellip;]<\/p>\n","protected":false},"author":600,"featured_media":0,"parent":44,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-2800","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/pages\/2800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/users\/600"}],"replies":[{"embeddable":true,"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/comments?post=2800"}],"version-history":[{"count":6,"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/pages\/2800\/revisions"}],"predecessor-version":[{"id":3584,"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/pages\/2800\/revisions\/3584"}],"up":[{"embeddable":true,"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/pages\/44"}],"wp:attachment":[{"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/media?parent=2800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}