--- title: Overview description: "- [Overview](#DataExporter(v1.8.2)-Overview) - [Data Table Creation - User process](#DataExporter(v1.8.2)-DataTableCreation-Userprocess) - [Design Table](#DataExporter(v1.8.2)-DesignTable) - [Aggregate Options](#DataExporter(v1.8.2)-AggregateOptions) - [Preview Table](#DataExporter(v1.8.2)-PreviewTable) - [Save Table](#DataExporter(v1.8.2)-SaveTable) - [Load Table](#DataExporter(v1.8.2)-LoadTable) - [Data Request - User process](#DataExporter(v1.8.2)-DataRequest-Userprocess) - [Request 1.8.2 data exports](#DataExporter(v1.8.2)-Request1.8.2dataexports) - [Data Request Manager](#DataExporter(v1.8.2)-DataRequestManager) -…" url: "https://i2b2.org/docs/data-exporter-v-1-8-2/" updated: "2026-09-15" category: i2b2 Installation Guide / Chapter 10. Advanced Data Export Features / Data Exporter (v 1.8.2) --- # Overview - [Overview](#DataExporter(v1.8.2)-Overview) - [Data Table Creation - User process](#DataExporter(v1.8.2)-DataTableCreation-Userprocess) - [Design Table](#DataExporter(v1.8.2)-DesignTable) - [Aggregate Options](#DataExporter(v1.8.2)-AggregateOptions) - [Preview Table](#DataExporter(v1.8.2)-PreviewTable) - [Save Table](#DataExporter(v1.8.2)-SaveTable) - [Load Table](#DataExporter(v1.8.2)-LoadTable) - [Data Request - User process](#DataExporter(v1.8.2)-DataRequest-Userprocess) - [Request 1.8.2 data exports](#DataExporter(v1.8.2)-Request1.8.2dataexports) - [Data Request Manager](#DataExporter(v1.8.2)-DataRequestManager) - [User's Data Requests List](#DataExporter(v1.8.2)-User'sDataRequestsList) - [View Data Request Details](#DataExporter(v1.8.2)-ViewDataRequestDetails) - [Data Export - Manager process](#DataExporter(v1.8.2)-DataExport-Managerprocess) - [Data Request Manager](#DataExporter(v1.8.2)-DataRequestManager.1) - [Data Requests List](#DataExporter(v1.8.2)-DataRequestsList) - [View Data Request Details](#DataExporter(v1.8.2)-ViewDataRequestDetails.1) - [Create Data File(s)](#DataExporter(v1.8.2)-CreateDataFile(s)) - [User-created Demographics](#DataExporter(v1.8.2)-User-createdDemographics) - [User-created Labs](#DataExporter(v1.8.2)-User-createdLabs) - [Data Export Configuration](#DataExporter(v1.8.2)-DataExportConfiguration) - [Template Substitution Variables](#DataExporter(v1.8.2)-TemplateSubstitutionVariables) - [Design and Architecture](#DataExporter(v1.8.2)-DesignandArchitecture) - [Software Changes:](#DataExporter(v1.8.2)-SoftwareChanges:) ## Overview The Data Exporter functionality enables an i2b2 user to create a data table definition and request patient data for a desired cohort. First, a table of variables is designed using **create data table for export** tool. The defined data tables are then displayed under the **Data Request(s)**breakdown types that can be selected in the Run Query dialog, After the query run, the Manager user can view and manage the data requests under the **Data Request Manager** tool. i2b2 Users will be able to view their data requests  status and details .  An e-mail is generated for the Data Manager when the request is submitted. The Data Manager processes the request by generating the data file under the **Data Request Manager** tool. The patient data is exported as a file and stored in a specified location for retrieval, and the user is notified by e-mail. The patient data file  is generated as per the data table definition design specification Data Export Workflow ### Data Table Creation - User process The **Create Data Table for export** feature allows User to design a table of variables of interest using the Design table feature. The table design can then be saved as a template  that can be loaded and used to request data export. ![](https://i2b2.org/wp-content/uploads/i2b2-installation-guide/attachments/214704909/214706121.png) #### **Design Table** The **DESIGN TABLE** panel allows i2b2 User to create a data table definition with list of variables of interest. 1. User logs into the web client and accesses **create data table for export**tool under the **Tools** plugin 2. The **DESIGN TABLE** panel displays list of predefined variables that will be included by default in the data export file. These predefined variables are (by default) Gender, Age, Race 3. From the **Ontology Terms** tab, drag and drop additional variables of interest onto the **DESIGN TABLE** grid. These variables will be added as a list of variables included in the data export. The predefined variables are locked and cannot be unchecked since they are required for every data table.  Other variables can be deleted under **Actions** column to exclude them from the data file. 4. Aggregation method for the variable can be applied by clicking on the drop down box in the **Aggregation Method** column to assign aggregate options to each variable** ** ![](https://i2b2.org/wp-content/uploads/i2b2-installation-guide/attachments/214704909/214706123.png) #### **Aggregate Options** The availability of aggregation options depends on the type of concept it aggregates on. Example: - Aggregation options for a non-numeric variable such as Diagnosis*** ***are **Existence (Yes/No), Count: Number of Concepts, Count: Number of Dates, Count Number of Encounters, Count Number of Facts, Count Number of Providers,****Date (First), Date (Most Recent), Most Frequent Concept (Codes)** - Aggregation options for concepts that support numeric values such as labs*** ***include **Average, Min, Max, etc. in addition to all the functions available to normal variables** | **Aggregation Options** | **Explanation** | | --- | --- | | **Existence (Yes/No)** | Whether the patient has an observation of this concept. This is the default option. | | **Count: Number of Concepts** | Total number of concepts | | **Count: Number of Dates** | Total number of dates for the participant | | **Count: Number of Encounters** | Total number of encounters for the participant | | **Count: Number of Facts** | Total number of observations | | **Count: Number of Providers** | Total number of providers for the participant | | **Date: First Date** | Date of earliest observation | | **Date: Last Date** | Date of the most recent observation | | **Calc: First Value** | Minimum value of all numeric values observations | | **Calc: Last Value** | Maximum value of all numeric values observations | | **Calc: Number of Values** | Total numbe of all numeric values observations | | **Calc: Average Value** | Average value of all numeric values observations | | **Calc: Minimum Value** | Lowest value of all numeric values observations | | **Calc: Maximum Value** | Highest value of all numeric values observations | | **Calc: Median Value** | Median value of all numeric values observations | #### **Preview Table** Table Design can be previewed to get a preview of the data export file that will be generated. 1. User clicks on **PREVIEW TABLE**to verify the variables added are displayed in the data columns in the format desired. ![](https://i2b2.org/wp-content/uploads/i2b2-installation-guide/attachments/214704909/214705810.png) Design and Preview is an interactive, iterative process where User can add and remove variables as well as assign or edit Aggregate options #### **Save Table** 1. Click on **Save** 2. The table definition can be either saved under **MY TABLES**or **PROJECT SHARED TABLES** ![](https://i2b2.org/wp-content/uploads/i2b2-installation-guide/attachments/214704909/214706117.png) MY TABLES are editable and will appear as Run Query options only for the current user PROJECT SHARED TABLES are editable and will appear as Run Query options for any user in the current i2b2 project SYSTEM SHARED TABLES is editable only for Admins and are templates for i2b2 users' tables #### **Load Table** Load table definition enables the User to Load a saved table definition  1. User clicks on **Load** menu option to display Load Table Definition with  list of user saved definitions 2. Select desired table definition and clicks on LOAD button ![](https://i2b2.org/wp-content/uploads/i2b2-installation-guide/attachments/214704909/214705790.png) Data file definitions from **Load Table definitions** can be further refined and saved  ## Data Request - User process #### **Request 1.8.2 data exports ** 1. User logs into web client and creates a query. 2. In the Run Query dialog box, User created table definitions are displayed under **Data Request(s)**section 3. Select one or more data request checkboxes. 1. 1.8.2 requests (custom tables) appear as  **User Created: | TABLE_INSTANCE_ID | TABLE_INSTANCE_NAME | USER_ID | GROUP_ID | SET_INDEX | C_FACTTABLECOLUMN | C_TABLENAME | COLUMN_NAME | C_FULLPATH | C_COLUMNNAME | C_COLUMNDATATYPE | C_OPERATOR | C_DIMCODE | AGG_TYPE | CONSTRAIN_BY_DATE_TO | CONSTRAIN_BY_DATE_FROM | CONSTRAIN_BY_VALUE_OPERATOR | CONSTRAIN_BY_VALUE_CONSTRAINT | CONSTRAIN_BY_VALUE_UNIT_OF_MEASURE | CONSTRAIN_BY_VALUE_TYPE | CREATE_DATE | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | 7 | DEM_6_27 | demoManager | SQLServerLarge | 0 | sex_cd | patient_dimension | Gender | @ | @ | @ | @ | @ | Value | | | | | | | 37:14.3 | | 7 | DEM_6_27 | demoManager | SQLServerLarge | 1 | age_in_years_num | patient_dimension | Age | @ | @ | @ | @ | @ | Value | | | | | | | 37:14.3 | | 7 | DEM_6_27 | demoManager | SQLServerLarge | 2 | race_cd | patient_dimension | Race | @ | @ | @ | @ | @ | Value | | | | | | | 37:14.3 | | 7 | DEM_6_27 | demoManager | SQLServerLarge | 3 | patient_num | patient_dimension | (children) < 18 years old | \\ACT_DEMO\ACT\Demographics\Age\< 18 years old\ | birth_date | N | > | dateadd(YY, -18, GETDATE())  | Exists | | | | | | | 37:14.3 | | patient_num | Gender | Age | Race | (children) < 18 years old | 75-84 years old | >= 65 years old | | | | | | | | | | | | | | | | 26 | M | 72 | @ | No | Yes | Yes | | | | | | | | | | | | | | | | 53 | F | 55 | WHITE | No | No | No | | | | | | | | | | | | | | | | 87 | F | 59 | WHITE | No | No | No | | | | | | | | | | | | | | | | 92 | F | 88 | DECLINED | No | No | Yes | | | | | | | | | | | | | | | | 94 | F | 67 | ASIAN | No | No | Yes | | | | | | | | | | | | | | | | 153 | M | 77 | @ | No | Yes | Yes | | | | | | | | | | | | | | | | TABLE_INSTANCE_ID | TABLE_INSTANCE_NAME | USER_ID | GROUP_ID | SET_INDEX | C_FACTTABLECOLUMN | C_TABLENAME | COLUMN_NAME | C_FULLPATH | C_COLUMNNAME | C_COLUMNDATATYPE | C_OPERATOR | C_DIMCODE | AGG_TYPE | CONSTRAIN_BY_DATE_TO | CONSTRAIN_BY_DATE_FROM | CONSTRAIN_BY_VALUE_OPERATOR | CONSTRAIN_BY_VALUE_CONSTRAINT | CONSTRAIN_BY_VALUE_UNIT_OF_MEASURE | CONSTRAIN_BY_VALUE_TYPE | CREATE_DATE | | 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 0 | sex_cd | patient_dimension | Gender | @ | @ | @ | @ | @ | Value | | | | | | | 25:57.3 | | 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 1 | age_in_years_num | patient_dimension | Age | @ | @ | @ | @ | @ | Value | | | | | | | 25:57.3 | | 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 2 | race_cd | patient_dimension | Race | @ | @ | @ | @ | @ | Value | | | | | | | 25:57.3 | | 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 3 | race_cd | patient_dimension | Ethnicity | @ | @ | @ | @ | @ | Value | | | | | | | 25:57.3 | | 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 4 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | NumFacts | | | | | | 25:57.3 | | | patient_num | Gender | Age | Race | Ethnicity | Cholesterol (Group:CHOL) | | | | | | | | | | | | | | | | | 9 | M | 49 | white | white | 1 | | | | | | | | | | | | | | | | | 89 | F | 57 | white | white | 1 | | | | | | | | | | | | | | | | | 13 | F | 53 | white | white | 1 | | | | | | | | | | | | | | | | | 21 | F | 72 | white | white | 7 | | | | | | | | | | | | | | | | | 77 | F | 80 | white | white | 1 | | | | | | | | | | | | | | | | | **Cell ID** | **Parameter Name** | **Example Value** | **Notes** | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.smtp.host | [smtp.partners.org](http://smtp.partners.org) | SMTP host | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.smtp.port | 25 | SMTP port | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.smtp.ssl.enable | FALSE | TRUE will enable SSL | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.smtp.auth | FALSE | TRUE will enable SMTP authentication | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.smtp.username | none | SMTP username (required for SMTP authentication) | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.smtp.password | none | SMTP password (required for SMTP authentication) | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.smtp.enabled | FALSE | TRUE will enable e-mails | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.exportcsv.defaultescapecharacter | " | Escape character for export files | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.exportcsv.maxfetchrows | -1 | Maximum number of rows to export, or -1 for no limit | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.exportcsv.defaultlineend | \n | Line ending for export files (single escaped character, e.g., \n,  \r, \f, \t, \0) | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.exportcsv.defaultseperator | \t | Field separator for export files | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.exportcsv.resultfetchsize | 50000 | Number of records retrieved during each database fetch. | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.exportcsv.filename | {{{PROJECT_ID}}}/{{{DATE_yyyyMMdd}}}_{{{FULL_NAME}}}.tsv | Parameterized template for export file names. If the extension is .zip, the file is zipped. | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.exportcsv.defaultquotechar | " | Quote character for export files | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.exportcsv.workfolder | /tmp/i2b2 | Folder on the i2b2 server for data exports | | | | | | | | | | | | | | | | | | | CRC | edu.harvard.i2b2.crc.exportcsv.zipencryptmethod | none | Encryption method for the exported ZIP file. One of STANDARD, NONE, or AES. | | | | | | | | | | | | | | | | | | | **Parameter Name** | **Example Value** | **Notes** | | | | | | | | | | | | | | | | | | | | Data Request Template | `This user {{{USER_NAME}}} in project {{{PROJECT_ID}}} requested ...` | Template text for the body of the **request notification** email. This email is sent to the site's configured **Data Request Email Address**. Supports template variables. | | | | | | | | | | | | | | | | | | | | Data Request Email Address | `someone@somewhere.org` | Email address that receives the data export notifications. This is typically a data manager or project mailbox. | | | | | | | | | | | | | | | | | | | | Data Request Letter | `"Results of the i2b2 request entitled - '{{{QUERY_NAME}}}', ..."` | Template text for the **export-completion notification** email body, to be sent to the configured **Data Request Email Address (**not directly to the requesting user). Supports variables like {{{QUERY_NAME}}}. | | | | | | | | | | | | | | | | | | | | Data Request Subject | `i2b2 Data Request` | Subject line used for both the request notification email and the export-completion notification email. | | | | | | | | | | | | | | | | | | | | **Variable** | **Description** | **Example / Source** | | | | | | | | | | | | | | | | | | | | **`{{{USER_NAME}}}`** | Display name or username of the requester | Jon Smith | | | | | | | | | | | | | | | | | | | | **`{{{FULL_NAME}}}`** | The full legal name of the requester | Jonathan Smith | | | | | | | | | | | | | | | | | | | | **`{{{QUERY_STARTDATE}}}`** | Timestamp when the query was submitted | 2025-09-19 | | | | | | | | | | | | | | | | | | | | **`{{{QUERY_ENDDATE}}}`** | Timestamp when the file was generated | 03/11/2026, 4:47 PM | | | | | | | | | | | | | | | | | | | | **`{{{QUERY_NAME}}}`** | Name/title of the query executed | Hypertension Adults | | | | | | | | | | | | | | | | | | | | **`{{{QUERY_MASTER_ID}}}`** | Internal i2b2 Query Master ID | 5412 | | | | | | | | | | | | | | | | | | | | **`{{{QUERY_INSTANCE_ID}}}`** | Internal i2b2 Query Instance ID | 7721 | | | | | | | | | | | | | | | | | | | | **`{{{PROJECT_ID}}}`** | i2b2 project ID (e.g., ACT, DEMO) | ACT | | | | | | | | | | | | | | | | | | | | **`{{{PATIENT_COUNT}}}`** | Number of patients/records returned | 1999 | | | | | | | | | | | | | | | | | | | | **`{{{RESULT_INSTANCE_ID}}}`** | Specific ID for the result instance | 99432 | | | | | | | | | | | | | | | | | | | | User Role | Create Data Table | Data Request | Data Request Manager View Details | Data Export/Generate Data file  | Change Request Status | | | | | | | | | | | | | | | | | Obfuscated | | | | | | | | | | | | | | | | | | | | | | Aggregate | | | | | | | | | | | | | | | | | | | | | | Protected | Enabled | Enabled | Enabled | | | | | | | | | | | | | | | | | | | LDS | Enabled | Enabled | Enabled | | | | | | | | | | | | | | | | | | | Manager/No LDS | Enabled | Enabled | Enabled | | | | | | | | | | | | | | | | | | | Manager/LDS | Enabled | Enabled | Enabled | Enabled | Enabled | | | | | | | | | | | | | | | | | Admin | Enabled | Enabled | Enabled | Enabled | Enabled | | | | | | | | | | | | | | | | | Column Name | Data Type | | | | | | | | | | | | | | | | | | | | | Group_Id | Varchar (50) | | | | | | | | | | | | | | | | | | | | | RPDO_TABLE_REQUEST PARAMETERS | DATA TABLE Values | | | | | | | | | | | | | | | | | | | | | TABLE_REQUEST_ID | auto generated incremental value, corresponding to each concept in the data table. Unique for each concept example: 1282,1283, 1284 | | | | | | | | | | | | | | | | | | | | | TABLE_INSTANCE_ID | unique for each Data table ( same value for all the concepts underneath) example: 17 | | | | | | | | | | | | | | | | | | | | | TABLE_INSTANCE_NAME | Data table definition name | | | | | | | | | | | | | | | | | | | | | USER_ID | data request user | | | | | | | | | | | | | | | | | | | | | GROUP_ID | project id | | | | | | | | | | | | | | | | | | | | | SET_INDEX | auto incremented for each concept row for the table instance | | | | | | | | | | | | | | | | | | | | | C_FACTTABLECOLUMN | "concept_cd" for the fact table or "patient_num" for the patient_dimension | | | | | | | | | | | | | | | | | | | | | C_TABLENAME | corresponds to table storing concept_cd/patient_num( concept_dimension or patient_dimension ) | | | | | | | | | | | | | | | | | | | | | COLUMN_NAME | The column name of the data table definition | | | | | | | | | | | | | | | | | | | | | C_FULLPATH | corresponds to the concept's c_fullname in the ontology table | | | | | | | | | | | | | | | | | | | | | C_COLUMNNAME | usually "concept_path" for concept_dimension | | | | | | | | | | | | | | | | | | | | | C_COLUMNDATATYPE | corresponds to ontology table  column value | | | | | | | | | | | | | | | | | | | | | C_OPERATOR | corresponds to ontology table  column value | | | | | | | | | | | | | | | | | | | | | C_DIMCODE | corresponds to ontology table  column value | | | | | | | | | | | | | | | | | | | | | AGG_TYPE | corresponds to Aggregate option selection in data table definition | | | | | | | | | | | | | | | | | | | | | CONSTRAIN_BY_DATE_TO | corresponds to date constraint option selection in data table definition | | | | | | | | | | | | | | | | | | | | | CONSTRAIN_BY_DATE_FROM | corresponds to date constraint option selection in data table definition | | | | | | | | | | | | | | | | | | | | | CONSTRAIN_BY_VALUE_OPERATOR | corresponds to set value constraint selection in data table definition | | | | | | | | | | | | | | | | | | | | | CONSTRAIN_BY_VALUE_CONSTRAINT | corresponds to set value constraint selection in data table definition | | | | | | | | | | | | | | | | | | | | | CONSTRAIN_BY_VALUE_UNIT_OF_MEASURE | corresponds to set value constraint selection in data table definition | | | | | | | | | | | | | | | | | | | | | CONSTRAIN_BY_VALUE_TYPE | corresponds to set value constraint selection in data table definition | | | | | | | | | | | | | | | | | | | | | SHARED | Y (for project and system shared table definitions); N (User table definition) | | | | | | | | | | | | | | | | | | | | | DELETE_FLAG | Y (if deleted) or N  | | | | | | | | | | | | | | | | | | | | | C_VISUALATTRIBUTES | values are LA  or LH  (based on visibility table definitions in the panel) | | | | | | | | | | | | | | | | | | | | | REQUIRED | Y for default variables ( race, age, sex); N for other variables | | | | | | | | | | | | | | | | | | | | | JSON_DATA | logs the table definition variables details needed for the  execution of the stored procedure to create the data file | | | | | | | | | | | | | | | | | | | | | GENERATED_SQL | logs the SQL query that is generated by stored procedure call  for each variable | | | | | | | | | | | | | | | | | | | | | DELETE_DATE | date of table definition deletion | | | | | | | | | | | | | | | | | | | | | CREATE_DATE | date of table definition creation | | | | | | | | | | | | | | | | | | | | | UPDATE_DATE | date table last updated | | | | | | | | | | | | | | | | | | | | | USE_AS_COHORT | N by default; not used currently | | | | | | | | | | | | | | | | | | | | | RESULT_TYPE_ID | NAME | DESCRIPTION | DISPLAYTYPE_ID | VISUAL_ATTRIBUTE_TYPE_ID | USER_ROLE_CD | CLASSNAME | | | | | | | | | | | | | | | | Auto generated number example : 144 | RPDO_ example: RPDO_17 | User-created Request | CATNUM | LU (User tables) LP (Project shared tables) | DATA_LDS | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientRequest | | | | | | | | | | | | | | | | NAME | VALUE | Group_id | | | | | | | | | | | | | | | | | | | | RPDO_ Example: RPDO_17 | EXEC i2b2synthea8.dbo.usp_rpdo2 @TABLE_INSTANCE_ID= @RESULT_INSTANCE_ID={{{RESULT_INSTANCE_ID}}} @MIN_ROW=0 @MAX_ROW=10000 | SQLServerLarge | | | | | | | | | | | | | | | | | | | | Column Name | Value (Example) | | | | | | | | | | | | | | | | | | | | | Result_Type_ id | 144 | | | | | | | | | | | | | | | | | | | | | Result_instance_id | 1729 | | | | | | | | | | | | | | | | | | | | | NAME | VALUE | | | | | | | | | | | | | | | | | | | | | RPDO_ Example: RPDO_144 | EXEC i2b2synthea8.dbo.usp_rpdo2 @TABLE_INSTANCE_ID=17 @RESULT_INSTANCE_ID={{{RESULT_INSTANCE_ID}}},@MIN_ROW=0 @MAX_ROW=99999999 | | | | | | | | | | | | | | | | | | | | | Column Name  | Value (example) | | | | | | | | | | | | | | | | | | | | | Result_Instance_Id | 1729 | | | | | | | | | | | | | | | | | | | | | XML_Value |   http://www.i2b2.org/xsd/cell/crc/psm/analysisdefinition/1.1/" xmlns:ns5="[http://www.i2b2.org/xsd/hive/msg/1.1/](http://www.i2b2.org/xsd/hive/msg/1.1/)" xmlns:ns8="[http://www.i2b2.org/xsd/cell/pm/1.1/](http://www.i2b2.org/xsd/cell/pm/1.1/)" xmlns:ns7="[http://www.i2b2.org/xsd/cell/crc/psm/querydefinition/1.1/](http://www.i2b2.org/xsd/cell/crc/psm/querydefinition/1.1/)" xmlns:ns9="[http://www.i2b2.org/xsd/cell/ont/1.1/](http://www.i2b2.org/xsd/cell/ont/1.1/)" xmlns:ns10="[http://www.i2b2.org/xsd/hive/msg/result/1.1/](http://www.i2b2.org/xsd/hive/msg/result/1.1/)" xmlns:ns2="[http://www.i2b2.org/xsd/hive/pdo/1.1/](http://www.i2b2.org/xsd/hive/pdo/1.1/)" xmlns:ns4="[http://www.i2b2.org/xsd/cell/crc/psm/1.1/](http://www.i2b2.org/xsd/cell/crc/psm/1.1/)" xmlns:ns3="[http://www.i2b2.org/xsd/cell/crc/pdo/1.1/](http://www.i2b2.org/xsd/cell/crc/pdo/1.1/)">                         20250808_125429             rmetta@[mgb.org](http://mgb.org)             20250808_125631             20250808_125631             /opt/dataexport/SQLServerLarge/724             20250808_125633             demoManager             | | | | | | | | | | | | | | | | | | | |**