Skip to end of banner
Go to start of banner

Digital Health Study Schema

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

Synapse Table: syn21994974


Notes:

  • Need to select entries based on WHERE ((isDHProject IS NULL) OR (isDHProject <> 'TRUE')) AND (dhPortalIndex = 'TRUE') 
  • 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 NameColumn NameFacet Y/NUI MappingFacet OrderDestinationSearchable Y/NSearch hint textNotes

id





Use this as link out to Synapse
Data AccessdataAccessInstructionsN

Link to wiki

Link out to this page to governance and access instructions

dataCollectionMethodNSecondary_Label_7





deviceLocationYSecondary_Label_96




devicePlatformYSecondary_Label_85




deviceTypeYSecondary_Label_53




diagnosisYSecondary_Label_11
Ye.g. Parkinson's

digitalAssessmentCategoryYSecondary_Label_108
Ye.g. tremor

digitalAssessmentDetails
Secondary_Label_11

Ye.g. walking

interventionYSecondary_Label_22
Ye.g. levodopa

investigator
Card_SubTitle

Ye.g. LastName

keywords
Secondary_Label_13

Ye.g. neurodegeneration
IndividualsnumberParticipants
Secondary_Label_3




Clinical or Phenotypic AssessmentreportedOutcomeYSecondary_Label_47
Ye.g. MDS-UPDRS

sensorDataType
Secondary_Label_12





sensorTypeYSecondary_Label_64



Study Namestudy
Card_Title
link to 'id'Ye.g. mPower
Data DescriptionstudyDataDescriptionLocation



N
Data description similar to methods for AMP-AD
Study DescriptionstudyDescriptionLocation



N
Full Study description for Study page

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:


FieldColumn NameLocationStudy Information (example)Note

Study Name

study

study card header

MJFF Levodopa Response StudyLink to id in Synapse

Study description

studyDescriptionLocationstudy 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')


  • No labels