Digital Health Collections Schema
- Solly Sieberts
Owned by Solly Sieberts
Synapse Table: syn21994974
Notes:
- Need to select entries based on WHERE (dhPortalIndex = 'TRUE')
- Need to sort based on ORDER BY 'study'
- Wiki text often come from main project wikis and subpages (in contrast to other projects in which they come from folder and file wikis)
| Display Name | Column Name | Facet Y/N | UI Mapping | Facet Order | Destination | Searchable Y/N | Search hint text | Notes |
|---|---|---|---|---|---|---|---|---|
| id | Use this as link out to Synapse | |||||||
| collectionType | Y | Secondary_Label_1 | ||||||
| Data Access | dataAccessInstructions | N | Link to wiki | Link out to this page to governance and access instructions | ||||
| dataCollectionMethod | N | Secondary_Label_8 | ||||||
| dataUsed | N | Secondary_Label_14 | ||||||
| deviceLocation | Y | Secondary_Label_10 | 6 | |||||
| devicePlatform | Y | Secondary_Label_9 | 5 | |||||
| deviceType | Y | Secondary_Label_6 | 3 | |||||
| diagnosis | Y | Secondary_Label_2 | 1 | Y | e.g. Parkinson's | |||
| digitalAssessmentCategory | Y | Secondary_Label_11 | 8 | Y | e.g. tremor | |||
| digitalAssessmentDetails | Secondary_Label_12 | Y | e.g. walking | |||||
| intervention | Y | Secondary_Label_3 | 2 | Y | e.g. levodopa | |||
| investigator | Card_SubTitle | Y | e.g. LastName | |||||
| keywords | Secondary_Label_15 | Y | e.g. neurodegeneration | |||||
| Individuals | numberParticipants | Secondary_Label_4 | ||||||
| Clinical or Phenotypic Assessment | reportedOutcome | Y | Secondary_Label_5 | 7 | Y | e.g. MDS-UPDRS | ||
| sensorDataType | Secondary_Label_13 | |||||||
| sensorType | Y | Secondary_Label_7 | 4 | |||||
| Collection Name | study | Card_Title | link to 'id' | Y | e.g. mPower | |||
| Data Description | studyDataDescriptionLocation | N | Data description similar to methods for AMP-AD | |||||
| Collection Description | studyDescriptionLocation | N | Full Study description for Study page | |||||
| Collection Description | studyDescription | Card_Description |
Study Detail Page
Study Detail pages retrieve data from multiple tables.
Study Name (study), Study Description, dataAccessInstructions (hyperlink to synapse with text "How to access the data"), and Data Description come from Study/Projects table.
Data from other sections come from the Digital Health Data File View, Digital Health Tools File View and Digital Health Publications tables.
The configuration for each section with example queries is shown here:
| Field | Column Name | Location | Study Information (example) | Note |
|---|---|---|---|---|
Collection Name | study | study card header | MJFF Levodopa Response Study | Link to id in Synapse |
Collection description | studyDescriptionLocation | study card body | Pull content from wiki link | |
Access requirements | accessRequirements | study page body | Hyperlink to Synapse using text "How to access the data" | |
| Data description | studyDataDescriptionLocation | study card body | Pull content from wiki link | |
Data files | study page body, table | select * from syn21994970 where ((dhPortalIndex = 'TRUE') AND (projectId = 'syn20681023')) | Or replace '*' with appropriate column selection | |
Suggested Tools | study page body, as cards | SELECT * FROM syn22014091 WHERE suggestedStudies HAS ('syn9746170') | ||
Publications | study page body, as cards | SELECT * FROM syn22017695 WHERE synID HAS ('syn9746170') |