Support

Support Options

Report a problem

About you
This is a randomly generated image of letters and numbers. Letters not clear? Click to renew CAPTCHA.
About the problem

ITMIG Prospective Patient Viewer Dashboard



View and Search your Prospective Patient Data by Case Report Form (CRF)

Each CRF has its own dataview for exploring and searching data. You can also download and audit data from each CRF.
  • Click the name or image of the CRF to explore, search, sort, filter and link data for patients
  • [Download] - downloads all patient data from the form to a spreadsheet
  • [Missing Data Count] - aggregates all data elements left blank on the form.

Patient Demographics
[Download]
[Missing Data Count]

Initial Presentation
[Download]
[Missing Data Count]

Imaging Reports
[Download]
[Missing Data Count]

Pathology Reports
[Download]
[Missing Data Count]

Surgeries
[Download]
[Missing Data Count]

Chemotherapy
[Download]
[Missing Data Count]

Radiotherapy
[Download]
[Missing Data Count]

Staging Information
[Download]
[Missing Data Count]

Follow-up
[Download]
[Missing Data Count]

All Episodes Patient Report
Includes Demographics, Diagnosis,
Surgeries, Staging, Follow-up

Tumor Bank Specimens
your hospital patients

Report & Image Repository
your hospital patients
     

 

 

View and Download ALL your Prospective Patient Data in 4 Spreadsheets

Search on Patient Episode Data and Imaging

Combined demographics, initial presentation, staging, surgery, follow-up
plus imaging initial and treatment assessment data --
across all patient episodes

 

Search on Patient Episode Data and Pathology

Combined demographics, initial presentation, staging, surgery, follow-up
plus pathology biopsy and resection data --
across all patient episodes

 

Search on Patient Episode Data and Chemotherapy

Combined demographics, initial presentation, staging, surgery, follow-up
plus chemotherapy treatment data --
across all patient episodes

 

Search on Patient Episode Data and Radiotherapy

Combined demographics, initial presentation, staging, surgery, follow-up
plus radiotherapy treatment data data --
across all patient episodes

Review your Patient Episodes for Completeness

These dataviews are used to audit patient episodes for completed submission of all required forms. Submitter names and email addresses are listed for each patient. You can use the dataviews to browse, search and explore data completeness for patients in your hospital. ITMIG administrators will see all patients from all hospitals in their dataviews.

 

Patient Episode
Completeness DataView



Patient Episode with Dates
Completeness DataView
Click on the Patient Episode Completeness DataView to review the sequence and completeness of forms submitted for patients by episode.
Click on the Patient Episode with Dates Completeness DataView to review completeness with form submission dates.


How do you answer important questions with these DataVIews?
Click a question on the left below, and see how to use DataViews to find the answer.
 
Which patient episodes with surgery do NOT have pathology resection?
Which patient episodes have NEITHER imaging nor biopsy before surgery?
Which patient episodes have NO staging information?
For patient episodes that have surgery but NO resection, what DATE was the surgery form submitted?


Need help getting answers? Email your ITMIG database team!
Ann Christine Catlin This email address is being protected from spambots. You need JavaScript enabled to view it.

Debug Console

Close6 MBRequestSessionTimelineDatabase33Events26
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /itmigdataviews, REDIRECT_SCRIPT_URI => https://itmig.curie.fr/... Array(
REDIRECT_SCRIPT_URL => /itmigdataviews,
REDIRECT_SCRIPT_URI => https://itmig.curie.fr/itmigdataviews,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => itmig.curie.fr,
REDIRECT_STATUS => 200,
SCRIPT_URL => /itmigdataviews,
SCRIPT_URI => https://itmig.curie.fr/itmigdataviews,
HTTPS => on,
SSL_TLS_SNI => itmig.curie.fr,
HTTP_ACCEPT => */*,
HTTP_USER_AGENT => claudebot,
HTTP_HOST => itmig.curie.fr,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.10 (Debian),
SERVER_NAME => itmig.curie.fr,
SERVER_ADDR => 192.168.25.26,
SERVER_PORT => 443,
REMOTE_ADDR => 18.221.187.121,
DOCUMENT_ROOT => /var/www/itmig,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/itmig,
SERVER_ADMIN => [no address given],
SCRIPT_FILENAME => /var/www/itmig/index.php,
REMOTE_PORT => 9567,
REDIRECT_URL => /itmigdataviews,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /itmigdataviews,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1713477424.64,
REQUEST_TIME => 1713477424
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 09386de0318205860ae14a200b7639a6
tracker.ssid 09386de0318205860ae14a200b7639a6
tracker.rsid 09386de0318205860ae14a200b7639a6
session.token 3e29d1330e13de8237c958eba3fc4d6a
  • site 0.015 seconds (+0.015); 3.75 MB (+3.750) - afterInitialise
  • site 0.023 seconds (+0.008); 4.25 MB (+0.500) - afterRoute
  • site 0.042 seconds (+0.020); 5.50 MB (+1.250) - afterDispatch
  • site 0.047 seconds (+0.005); 5.75 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.047 seconds (+0.000); 5.75 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.047 seconds (+0.000); 5.75 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.048 seconds (+0.001); 5.75 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.048 seconds (+0.000); 5.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.054 seconds (+0.006); 6.00 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.054 seconds (+0.000); 6.00 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.054 seconds (+0.001); 6.00 MB (0.000) - afterRenderModule mod_search (Search)
  • site 0.055 seconds (+0.000); 6.00 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.058 seconds (+0.004); 6.00 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.061 seconds (+0.003); 6.00 MB (0.000) - onAfterRender
  • site 0.063 seconds (+0.002); 6.00 MB (0.000) - sessionStore
6 MB

33 Queries Logged: 0.0032839775085449 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '5dcdae0ae33cb34f870f5719f20af532'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = '5dcdae0ae33cb34f870f5719f20af532'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '09386de0318205860ae14a200b7639a6'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '09386de0318205860ae14a200b7639a6'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('09386de0318205860ae14a200b7639a6','0','1713477424','18.221.187.121')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT con.`id`, cat.`alias`, cat.`path`
      FROM `jos_content` AS con
      LEFT JOIN `jos_categories` AS cat
      ON con.catid = cat.id
      WHERE con.state=1
      AND con.`alias` = 'itmigdataviews'
  13. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_menus'
  17. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  18. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'com_content'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  19. SELECT a.*,a.id,a.asset_id,a.title,a.alias,a.title_alias,a.introtext,a.fulltext,
      CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END AS state,a.mask,a.catid,a.created,a.created_by,a.created_by_alias,
      CASE WHEN a.modified IS NULL THEN a.created ELSE a.modified END AS modified,a.modified_by,a.checked_out,a.checked_out_time,a.publish_up,a.publish_down,a.images,a.urls,a.attribs,a.version,a.parentid,a.ordering,a.metakey,a.metadesc,a.access,a.hits,a.metadata,a.featured,a.language,a.xreference,c.title AS category_title,c.alias AS category_alias,c.access AS category_access,u.name AS author,parent.title AS parent_title,parent.id AS parent_id,parent.path AS parent_route,parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating,v.rating_count AS rating_count
      FROM `jos_content` AS `a`
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE `a`.`id` = '35'
      AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= '2024-04-18 21:57:04' )
      AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= '2024-04-18 21:57:04' )
      AND `a`.`state` IN ('1','2')
  20. SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jos_categories` AS `c`
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (`c`.`extension` = 'com_content' OR `c`.`extension` = 'system' )
      AND `c`.`access` IN ('1','1','4')
      AND `c`.`published` = '1'
      AND `s`.`id` = '2'
      AND badcats.id is null
      GROUP BY c.id,c.asset_id,c.access,c.alias,c.checked_out,c.checked_out_time,c.created_time,c.created_user_id,c.description,c.extension,c.hits,c.language,c.level,c.lft,c.metadata,c.metadesc,c.metakey,c.modified_time,c.note,c.params,c.parent_id,c.path,c.published,c.rgt,c.title,c.modified_user_id
      ORDER BY `c`.`lft` ASC
  21. SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jos_categories` AS `c`
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (`c`.`extension` = 'com_content' OR `c`.`extension` = 'system' )
      AND `c`.`access` IN ('1','1','4')
      AND `c`.`published` = '1'
      AND `s`.`id` = '2'
      AND badcats.id is null
      GROUP BY c.id,c.asset_id,c.access,c.alias,c.checked_out,c.checked_out_time,c.created_time,c.created_user_id,c.description,c.extension,c.hits,c.language,c.level,c.lft,c.metadata,c.metadesc,c.metakey,c.modified_time,c.note,c.params,c.parent_id,c.path,c.published,c.rgt,c.title,c.modified_user_id
      ORDER BY `c`.`lft` ASC
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  23. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  24. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= '2024-04-18 21:57:04' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-04-18 21:57:04' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '0' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  25. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  28. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  29. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  31. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  32. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  33. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713477424;s:18:\"session.timer.last\";i:1713477424;s:17:\"session.timer.now\";i:1713477424;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"09386de0318205860ae14a200b7639a6\";s:12:\"tracker.ssid\";s:32:\"09386de0318205860ae14a200b7639a6\";s:12:\"tracker.rsid\";s:32:\"09386de0318205860ae14a200b7639a6\";s:13:\"session.token\";s:32:\"3e29d1330e13de8237c958eba3fc4d6a\";}',`time` = '1713477424',`ip` = '18.221.187.121'
      WHERE `session_id` = '09386de0318205860ae14a200b7639a6'
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:45
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:44
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:46
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:46
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:138
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:46
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:46
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:46
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:46
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:46
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:46
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:60
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:49
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:59
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:50
  • onContentPrepare Method plgContentFormatwiki::onContentPrepare /core/plugins/content/formatwiki/formatwiki.php:88
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:130
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:65
  • onContentBeforeDisplay Method plgContentPagenavigation::onContentBeforeDisplay /core/plugins/content/pagenavigation/pagenavigation.php:49
  • onContentBeforeDisplay Method plgContentVote::onContentBeforeDisplay /core/plugins/content/vote/vote.php:57
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:47
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:85
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:49
  • onDisplay Method plgCaptchaImage::onDisplay /core/plugins/captcha/image/image.php:80
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:45