Page History
...
| NAME | VALUE |
|---|---|
RPDO_<Table_instance_id> Example: RPDO_144 | EXEC i2b2synthea8.dbo.usp_rpdo2 @TABLE_INSTANCE_ID=<Table_instance_id> @RESULT_INSTANCE_ID=541 @MIN_ROW=0 @MAX_ROW=10000 |
QT_XML_RESULT
When the create Metadata about data request queries and Data file stored procedure is executed, row is logged generation are stored in the QT_XML_Result for the result_instance_id with the details of Data table Definition in the Value columnRESULT table, in the XML_VALUE field
| Column Name | Value (example) |
|---|---|
| Result_Instance_Id | 541 |
| Value | <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ns10:i2b2_result_envelope xmlns:ns6="http://www.i2b2.org/xsd/cell/crc/psm/querydefinition/1.1/" xmlns:ns5="http://www.i2b2.org/xsd/hive/msg/1.1/" xmlns:ns8="http://www.i2b2.org/xsd/cell/pm/1.1/" xmlns:ns7="http://www.i2b2.org/xsd/cell/crc/psm/analysisdefinition/1.1/" xmlns:ns9="http://www.i2b2.org/xsd/cell/ont/1.1/" xmlns:ns10="http://www.i2b2.org/xsd/hive/msg/result/1.1/" xmlns:ns2="http://www.i2b2.org/xsd/hive/pdo/1.1/" xmlns:ns4="http://www.i2b2.org/xsd/cell/crc/psm/1.1/" xmlns:ns3="http://www.i2b2.org/xsd/cell/crc/pdo/1.1/"> <body> <ns10:result name="RPDO_144"> <data column="SUBMITTED" type="string">20250513_172906</data> <data column="EMAIL" type="string">act@gmail.com</data> </ns10:result> </body> </ns10:i2b2_result_envelope> |
Data file format/location and Email parameters set-up: HIVE_CELL_PARAMS
...
