...
NAME | DESCRIPTION | DISPLAYTYPE_ID | VISUAL_ATTRIBUTE_TYPE_ID | USER_ROLE_CD | CLASSNAME |
PATIENT_DEMOGRAPHIC_REQUEST | Request Demographics Data | CATNUM | LR | DATA_LDS | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientRequest |
PATIENT_MEDICATIONDEMOGRAPHIC_REQUESTCSV | Request Medication Export Demographics Data | CATNUM | LRLX | DATA_LDSMANAGER | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientRequest |
PATIENT_PROCEDURE_REQUEST | Request Procedure Data | CATNUM | LR | DATA_LDS | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientRequest |
PATIENT_DIAGNOSIS_REQUEST | Request Diagnosis Data | CATNUM | LR | DATA_LDS | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientRequest |
PATIENT_LAB_REQUEST | Request Lab Data | CATNUM | LR | DATA_LDS | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientRequest |
PATIENT_MAPPING_REQUEST | Request Patient Mapping | CATNUM | LR | DATA_LDS | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientRequest |
PATIENT_DEMOGRAPHIC_CSV | Export Demographics Data | CATNUM | LX | MANAGER | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientDownload |
PATIENT_MEDICATION_CSV | Export Medication Data | CATNUM | LX | MANAGER | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientDownload |
PATIENT_PROCEDURE_CSV | Export Procedure Data | CATNUM | LX | MANAGER | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientDownload |
PATIENT_DIAGNOSIS_CSV | Export Diagnosis Data | CATNUM | LX | MANAGER | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientDownload |
PATIENT_LAB_CSV | Export Lab Data | CATNUM | LX | MANAGER | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientDownload |
PATIENT_MAPPING_CSV | Export Patient Mapping | CATNUM | LX | MANAGER | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientDownload |
QT_BREAKDOWN_PATH Name column hosts 2 type of parameters for each request type: The value column has XML file with email and file specifications
...
- <request name>_REQUEST has details on email notification generation
...
QueryResultPatientDownload |
QT_BREAKDOWN_PATH Name column hosts 2 type of parameters for each request type: The value column has XML file with email and file specifications
Name | Value |
---|
- <request name>_REQUEST has details on email notification generation
| <?xml version="1.0"?> <ValueExporter> <Version><version no></Version> <CreationDateTime>08/09/2024 12:00:00</CreationDateTime> <RequesterEmailLetter>< details sent to user on data request</RequesterEmailLetter> <RequestLetter><details sent to Manager on user data request> </RequestLetter> </ValueExporter> |
- <request name>_CSV has details on export file generation
| <?xml version="1.0"?> <ValueExporter> <Version><version no></Version> <CreationDateTime><date value></CreationDateTime> <RequesterEmailLetter>details sent to user on data request</RequesterEmailLetter> <RequestLetter>details sent to Manager on user data request </RequestLetter> <LetterFilename><name of the file></LetterFilename> <Letter> <letter content></Letter> <Table> <Filename>filename</Filename> <Query><SQL query to generate the data export content></Query> <SeparatorCharacter><file format seperator></SeparatorCharacter> </Table>
</ValueExporter> |
Example Request types
NAME | VALUE |
PATIENT_MEDICATION_CSV | <?xml version="1.0"?> <ValueExporter> Â <Version>3.02</Version> Â <CreationDateTime>08/09/2024 12:00:00</CreationDateTime> <RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}</RequesterEmailLetter> <RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT |
...
- <request name>_CSV has details on export file generation
...
Example Request types
NAME | VALUE |
PATIENT_MAPPING_CSV | <?xml version="1.0"?>
<ValueExporter>
 <Version>3.02</Version>
 <CreationDateTime>08/09/2024 12:00:00</CreationDateTime>
<RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}</RequesterEmailLetter>
<RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}.
</RequestLetter>
<LetterFilename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Readme.txt</LetterFilename>
<Letter>
Results of the i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, are available.
Important notes about your data:
- Total number of patients returned in your data request: {{{PATIENT_COUNT}}}
- i2b2 reviewer:
Only persons specifically authorized and selected (as listed at the top of this letter) can download these files. If additional user access is needed, please ensure the person is listed on your project IRB protocol and contact the i2b2 team.
Specifically:
- Remove all PHI from computer, laptop, or mobile device after analysis is completed.
- Do NOT share PHI or PII with anyone who is not listed on the IRB protocol.
Your guideline for the storage of Protected Health Information can be found at: https://www.site.com/guidelines_for_protecting_and_storing_phi.pdf
*To download these files*
- You must be logged onto your site
These results are the data that was requested under the authority of the Institutional Review Board. The query resulting in this identified patient data is included at the end of this letter. A copy of this letter is kept on file and is available to the IRB in the event of an audit.
Thank you,
The i2b2 Team </Letter>
<Table>
<Filename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/PatientMapping.csv</Filename>
<Query>SELECT DISTINCT to_char(a.PATIENT_NUM) as "I2B2_PATIENT_NUMBER"
,a.PATIENT_IDE_SOURCE as "PATIENT_SOURCE"
,a.PATIENT_IDE as "PATIENT_IDE"
FROM patient_mapping a, {{{DX}}} c
where a.patient_num = c.patient_num</Query>
<SeparatorCharacter>\t</SeparatorCharacter>
</Table>
</ValueExporter>PATIENT_MEDICATION_CSV | <?xml version="1.0"?>
<ValueExporter>
 <Version>3.02</Version>
 <CreationDateTime>08/09/2024 12:00:00</CreationDateTime>
<RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}</RequesterEmailLetter>
<RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}.
</RequestLetter>
<LetterFilename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Readme.txt</LetterFilename>
<Letter>
Results of the i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, are available.
Important notes about your data:
- Total number of patients returned in your data request: {{{PATIENT_COUNT}}}
- i2b2 reviewer:
Only persons specifically authorized and selected (as listed at the top of this letter) can download these files. If additional user access is needed, please ensure the person is listed on your project IRB protocol and contact the i2b2 team.
Specifically:
- Remove all PHI from computer, laptop, or mobile device after analysis is completed.
- Do NOT share PHI or PII with anyone who is not listed on the IRB protocol.
Your guideline for the storage of Protected Health Information can be found at: https://www.site.com/guidelines_for_protecting_and_storing_phi.pdf
*To download these files*
- You must be logged onto your site
These results are the data that was requested under the authority of the Institutional Review Board. The query resulting in this identified patient data is included at the end of this letter. A copy of this letter is kept on file and is available to the IRB in the event of an audit.
Thank you,
The i2b2 Team
</Letter>
<Table>
<Filename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Medication.csv</Filename>
<Query>SELECT to_char(a.PATIENT_NUM) as "I2B2_PATIENT_NUMBER"
,a.start_date as "START_DATE"
,a.start_date as "END_DATE"
,b.name_char as "MEDICATION_NAME"
,b.concept_cd as "NDC_CODE"
,a.units_cd as "UNIT"
,a.quantity_num as "DOSE_QUANTITY"
,a.modifier_cd as "MODIFIER"
,m.name_char as "MODIFIER_NAME"
,a.instance_num as "INSTANCE_NUM"
,a.location_cd as "FACILITY"
,case v.inout_cd when 'O' then 'Outpatient' when 'I' then 'Inpatient' else 'Unknown' end as "ENCOUNTER_TYPE"
,p.name_char as "PROVIDER"
,a.encounter_num as "ENCOUNTER_NUMBER"
FROM observation_fact a
INNER JOIN concept_dimension b on a.concept_cd = b.concept_cd and b.concept_path like '\i2b2\Medications\%'
JOIN {{{DX}}} c on a.patient_num = c.patient_num
LEFT OUTER JOIN provider_dimension p on a.provider_id = p.provider_id
JOIN visit_dimension v on a.encounter_num = v.encounter_num and a.patient_num = v.patient_num
LEFT OUTER JOIN modifier_dimension m on a.modifier_cd = m.modifier_cd</Query>
<SeparatorCharacter>\t</SeparatorCharacter>
</Table>
</ValueExporter>PATIENT_PROCEDURE_CSV | <?xml version="1.0"?>
<ValueExporter>
 <Version>3.02</Version>
 <CreationDateTime>08/09/2024 12:00:00</CreationDateTime>
<RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}</RequesterEmailLetter>
<RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}.
</RequestLetter>
<LetterFilename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Readme.txt</LetterFilename>
<Letter>
Results of the i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, are available.
Important notes about your data:
- Total number of patients returned in your data request: {{{PATIENT_COUNT}}}
- i2b2 reviewer:
Only persons specifically authorized and selected (as listed at the top of this letter) can download these files. If additional user access is needed, please ensure the person is listed on your project IRB protocol and contact the i2b2 team.
Specifically:
- Remove all PHI from computer, laptop, or mobile device after analysis is completed.
- Do NOT share PHI or PII with anyone who is not listed on the IRB protocol.
Your guideline for the storage of Protected Health Information can be found at: https://www.site.com/guidelines_for_protecting_and_storing_phi.pdf
*To download these files*
- You must be logged onto your site
These results are the data that was requested under the authority of the Institutional Review Board. The query resulting in this identified patient data is included at the end of this letter. A copy of this letter is kept on file and is available to the IRB in the event of an audit.
Thank you,
The i2b2 Team
</Letter>
<Table>
<Filename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Procedure.csv</Filename>
<Query>SELECT DISTINCT to_char(a.PATIENT_NUM) as "I2B2_PATIENT_NUMBER"
,m.patient_ide as â€PATIENT_ID"
,a.start_date as "START_DATE"
,a.start_date as "END_DATE"
,b.name_char as "PROCEDURE_NAME"
,b.concept_cd as "PROCEDURE_CODE"
,a.quantity_num as "QUANTITY"
,a.modifier_cd as "MODIFIER"
,a.location_cd as "FACILITY"
,case v.inout_cd when 'O' then 'Outpatient' when 'I' then 'Inpatient' else 'Unknown' end as "ENCOUNTER_TYPE"
,p.name_char as "PROVIDER"
,a.encounter_num as "ENCOUNTER_NUMBER"
FROM observation_fact a
INNER JOIN concept_dimension b on a.concept_cd = b.concept_cd and b.concept_path like '\i2b2\Procedures\%'
JOIN {{{DX}}} c on a.patient_num = c.patient_num
LEFT OUTER JOIN provider_dimension p on a.provider_id = p.provider_id
JOIN visit_dimension v on a.encounter_num = v.encounter_num and a.patient_num = v.patient_num
JOIN patient_mapping m on a.patient_num = m.patient_num
</Query>
<SeparatorCharacter>\t</SeparatorCharacter>
</Table>
</ValueExporter>PATIENT_LAB_CSV | <?xml version="1.0"?>
<ValueExporter>
 <Version>3.02</Version>
 <CreationDateTime>08/09/2024 12:00:00</CreationDateTime>
<RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}</RequesterEmailLetter>
<RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}.
</RequestLetter>
<LetterFilename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Readme.txt</LetterFilename>
<Letter>
Results of the i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, are available.
Important notes about your data:
- Total number of patients returned in your data request: {{{PATIENT_COUNT}}}
- i2b2 reviewer:
Only persons specifically authorized and selected (as listed at the top of this letter) can download these files. If additional user access is needed, please ensure the person is listed on your project IRB protocol and contact the i2b2 team.
Specifically:
- Remove all PHI from computer, laptop, or mobile device after analysis is completed.
- Do NOT share PHI or PII with anyone who is not listed on the IRB protocol.
Your guideline for the storage of Protected Health Information can be found at: https://www.site.com/guidelines_for_protecting_and_storing_phi.pdf
*To download these files*
- You must be logged onto your site
These results are the data that was requested under the authority of the Institutional Review Board. The query resulting in this identified patient data is included at the end of this letter. A copy of this letter is kept on file and is available to the IRB in the event of an audit.
Thank you,
The i2b2 Team
</Letter>
<Table>
<Filename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Lab.csv</Filename>
<Query>SELECT DISTINCT to_char(a.PATIENT_NUM) as "I2B2_PATIENT_NUMBER"
,m.patient_ide as â€PATIENT_ID"
,a.start_date as "START_DATE"
,a.start_date as "END_DATE"
,b.name_char as "LAB_NAME"
,b.concept_cd as "LAB_CODE"
,case when a.valtype_cd = 'T' then tval_char else to_char(nval_num) end as "LAB_RESULTS"
,a.modifier_cd as "MODIFIER"
,a.location_cd as "FACILITY"
,case v.inout_cd when 'O' then 'Outpatient' when 'I' then 'Inpatient' else 'Unknown' end as "ENCOUNTER_TYPE"
,p.name_char as "PROVIDER"
,a.encounter_num as "ENCOUNTER_NUMBER"
FROM observation_fact a
INNER JOIN concept_dimension b on a.concept_cd = b.concept_cd and b.concept_path like '\i2b2\Labtests\%'
JOIN {{{DX}}} c on a.patient_num = c.patient_num
LEFT OUTER JOIN provider_dimension p on a.provider_id = p.provider_id
JOIN visit_dimension v on a.encounter_num = v.encounter_num and a.patient_num = v.patient_num
JOIN patient_mapping m on a.patient_num = m.patient_num
</Query>
<SeparatorCharacter>\t</SeparatorCharacter>
</Table>
</ValueExporter>PATIENT_DEMOGRAPHIC_CSV | <?xml version="1.0"?>
<ValueExporter>
 <Version>3.02</Version>
 <CreationDateTime>08/09/2024 12:00:00</CreationDateTime>
<RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}</RequesterEmailLetter>
<RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}.
</RequestLetter>
<LetterFilename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Readme.txt</LetterFilename>
<Letter>
Results of the i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, are available.
Important notes about your data:
- Total number of patients returned in your data request: {{{PATIENT_COUNT}}}
- i2b2 reviewer:
Only persons specifically authorized and selected (as listed at the top of this letter) can download these files. If additional user access is needed, please ensure the person is listed on your project IRB protocol and contact the i2b2 team.
Specifically:
- Remove all PHI from computer, laptop, or mobile device after analysis is completed.
- Do NOT share PHI or PII with anyone who is not listed on the IRB protocol.
Your guideline for the storage of Protected Health Information can be found at: https://www.site.com/guidelines_for_protecting_and_storing_phi.pdf
*To download these files*
- You must be logged onto your site
These results are the data that was requested under the authority of the Institutional Review Board. The query resulting in this identified patient data is included at the end of this letter. A copy of this letter is kept on file and is available to the IRB in the event of an audit.
Thank you,
The i2b2 Team </Letter>
<Table>
<Filename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Demographics.csv</Filename>
<Query>SELECT to_char(a.PATIENT_NUM) as "I2B2_PATIENT_NUMBER"
,a.BIRTH_DATE as "BIRTH_DATE"
, a.DEATH_DATE as "DEATH_DATE"
,a.SEX_CD as "GENDER"
, a.AGE_IN_YEARS_NUM as "AGE_IN_YEARS"
,a.LANGUAGE_CD as "PRIMARY_SPOKEN_LANGUAGE"
,a.RACE_CD as "RACE"
,a.MARITAL_STATUS_CD as "MARTIAL_STATUS"
,a.RELIGION_CD as "RELIGION"
,a.ZIP_CD as "ZIP_CODE"
,a.STATECITYZIP_PATH as "STATE_CITY_ZIP"
,a.INCOME_CD as "INCOME"
,a.VITAL_STATUS_CD as "VITAL_STATUS"
FROM patient_dimension a, {{{DX}}} c
where a.patient_num = c.patient_num</Query>
<SeparatorCharacter>\t</SeparatorCharacter>
</Table>
</ValueExporter>PATIENT_DIAGNOSIS_CSV | <?xml version="1.0"?>
<ValueExporter>
 <Version>3.02</Version>
 <CreationDateTime>08/09/2024 12:00:00</CreationDateTime>
<RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}</RequesterEmailLetter>
<RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request
entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_ID}}}.
</RequestLetter>
<LetterFilename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Readme.txt</LetterFilename>
<Letter>
Results of the i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, are available.
Important notes about your data:
- Total number of patients returned in your data request: {{{PATIENT_COUNT}}}
- i2b2 reviewer:
Only persons specifically authorized and selected (as listed at the top of this letter) can download these files. If additional user access is needed, please ensure the person is listed on your project IRB protocol and contact the i2b2 team.
Specifically:
- Remove all PHI from computer, laptop, or mobile device after analysis is completed.
- Do NOT share PHI or PII with anyone who is not listed on the IRB protocol.
Your guideline for the storage of Protected Health Information can be found at: https://www.site.com/guidelines_for_protecting_and_storing_phi.pdf
*To download these files*
- You must be logged onto your site
These results are the data that was requested under the authority of the Institutional Review Board. The query resulting in this identified patient data is included at the end of this letter. A copy of this letter is kept on file and is available to the IRB in the event of an audit.
Thank you,
The i2b2 Team
</Letter>
<Table>
<Filename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}/Diagnosis.csv</Filename>
<Query>SELECT DISTINCT to_char(a.PATIENT_NUM) as "I2B2_PATIENT_NUMBER"
,m.patient_ide as â€PATIENT_ID"
,a.start_date as "START_DATE"
,a.start_date as "END_DATE"
,b.name_char as "DIAGNOSIS_NAME"
,b.concept_cd as "DIAGNOSIS_CODE"
,a.modifier_cd as "MODIFIER"
,a.location_cd as "FACILITY"
,case v.inout_cd when 'O' then 'Outpatient' when 'I' then 'Inpatient' else 'Unknown' end as "ENCOUNTER_TYPE"
,p.name_char as "PROVIDER"
,a.encounter_num as "ENCOUNTER_NUMBER"
FROM observation_fact a
INNER JOIN concept_dimension b on a.concept_cd = b.concept_cd and b.concept_path like '\i2b2\Diagnoses\%'
JOIN {{{DX}}} c on a.patient_num = c.patient_num
LEFT OUTER JOIN provider_dimension p on a.provider_id = p.provider_id
JOIN visit_dimension v on a.encounter_num = v.encounter_num and a.patient_num = v.patient_num
JOIN patient_mapping m on a.patient_num = m.patient_num
</Query>
<SeparatorCharacter>\t</SeparatorCharacter>
</Table>
</ValueExporter>PATIENT_MEDICATION_REQUEST | <?xml version="1.0"?> <ValueExporter> Â <Version>3.02</Version> Â <CreationDateTime>08/09/2024 12:00:00</CreationDateTime> <RequesterEmailLetter>Your request on {{{PROJECT_MASTER_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}. </RequesterEmailLetter>RequestLetter> <RequestLetter>This user <LetterFilename>/{{{USER_NAME}}} in project /{{{PROJECTQUERY_MASTER_ID}}} requested /Readme.txt</LetterFilename> <Letter> Results of the i2b2 request entitled entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}. </RequestLetter> </ValueExporter> |
PATIENT_MAPPING_REQUEST | <?xml version="1.0"?> <ValueExporter> Â <Version>3.02</Version> Â <CreationDateTime>08/09/2024 12:00:00</CreationDateTime> <RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}</RequesterEmailLetter> <RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}. </RequestLetter> </ValueExporter> |
PATIENT_PROCEDURE_REQUEST | <?xml version="1.0"?> <ValueExporter> Â <Version>3.02</Version> Â <CreationDateTime>08/09/2024 12:00:00</CreationDateTime> <RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of are available.
Important notes about your data: - Total number of patients returned in your data request: {{{PATIENT_COUNT}}} - i2b2 reviewer:
Only persons specifically authorized and selected (as listed at the top of this letter) can download these files. If additional user access is needed, please ensure the person is listed on your project IRB protocol and contact the i2b2 team.
Specifically: - Remove all PHI from computer, laptop, or mobile device after analysis is completed. - Do NOT share PHI or PII with anyone who is not listed on the IRB protocol.
Your guideline for the storage of Protected Health Information can be found at: https://www.site.com/guidelines_for_protecting_and_storing_phi.pdf
*To download these files* - You must be logged onto your site
These results are the data that was requested under the authority of the Institutional Review Board. The query resulting in this identified patient data is included at the end of this letter. A copy of this letter is kept on file and is available to the IRB in the event of an audit.
Thank you,
The i2b2 Team </Letter> <Table> <Filename>/{{{USER_NAME}}}/{{{QUERY_MASTER_ID}}}</RequesterEmailLetter> <RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}. </RequestLetter> </ValueExporter> |
PATIENT_LAB_REQUEST | <?xml version="1.0"?> <ValueExporter> Â <Version>3.02</Version> Â <CreationDateTime>08/09/2024 12:00:00</CreationDateTime> <RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}</RequesterEmailLetter> <RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}. </RequestLetter> </ValueExporter> |
PATIENT_DEMOGRAPHIC_REQUEST | <?xml version="1.0"?> <ValueExporter> Â <Version>3.02</Version> Â <CreationDateTime>08/09/2024 12:00:00</CreationDateTime> <RequesterEmailLetter>Your request on {{{PROJECT_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}</RequesterEmailLetter> <RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}. </RequestLetter> </ValueExporter> |
/Medication.csv</Filename> <Query>SELECT to_char(a.PATIENT_NUM) as "I2B2_PATIENT_NUMBER" ,a.start_date as "START_DATE" ,a.start_date as "END_DATE" ,b.name_char as "MEDICATION_NAME" ,b.concept_cd as "NDC_CODE" ,a.units_cd as "UNIT" ,a.quantity_num as "DOSE_QUANTITY" ,a.modifier_cd as "MODIFIER" ,m.name_char as "MODIFIER_NAME" ,a.instance_num as "INSTANCE_NUM" ,a.location_cd as "FACILITY" ,case v.inout_cd when 'O' then 'Outpatient' when 'I' then 'Inpatient' else 'Unknown' end as "ENCOUNTER_TYPE" ,p.name_char as "PROVIDER" ,a.encounter_num as "ENCOUNTER_NUMBER" FROM observation_fact a INNER JOIN concept_dimension b on a.concept_cd = b.concept_cd and b.concept_path like '\i2b2\Medications\%' JOIN {{{DX}}} c on a.patient_num = c.patient_num LEFT OUTER JOIN provider_dimension p on a.provider_id = p.provider_id JOIN visit_dimension v on a.encounter_num = v.encounter_num and a.patient_num = v.patient_num LEFT OUTER JOIN modifier_dimension m on a.modifier_cd = m.modifier_cd</Query> <SeparatorCharacter>\t</SeparatorCharacter> </Table>
</ValueExporter> |
PATIENT_MEDICATIONPATIENT_DIAGNOSIS_REQUEST | <?xml version="1.0"?> <ValueExporter> Â <Version>3.02</Version> Â Â <CreationDateTime>08/09/2024 12:00:00</CreationDateTime> <RequesterEmailLetter>Your request on {{{PROJECT_MASTER_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}</RequesterEmailLetter> <RequestLetter>This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested i2b2 request entitled - "{{{QUERY_NAME}}}", submitted on {{{QUERY_STARTDATE}}}, with the query master of {{{QUERY_MASTER_ID}}}. </RequestLetter> </ValueExporter> |
...