/
Digital Health Study Schema (Depricated)

Digital Health Study Schema (Depricated)

Oct 20, 2020

Synapse Table: syn21994974

 

Notes:

  • Need to select entries based on WHERE ((isDHProject IS NULL) OR (isDHProject <> 'TRUE')) AND (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

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

Data Access

dataAccessInstructions

N

 

 

Link to wiki

 

 

Link out to this page to governance and access instructions

 

dataCollectionMethod

N

Secondary_Label_7

 

 

 

 

 

 

deviceLocation

Y

Secondary_Label_9

6

 

 

 

 

 

devicePlatform

Y

Secondary_Label_8

5

 

 

 

 

 

deviceType

Y

Secondary_Label_5

3

 

 

 

 

 

diagnosis

Y

Secondary_Label_1

1

 

Y

e.g. Parkinson's

 

 

digitalAssessmentCategory

Y

Secondary_Label_10

8

 

Y

e.g. tremor

 

 

digitalAssessmentDetails

 

Secondary_Label_11

 

 

Y

e.g. walking

 

 

intervention

Y

Secondary_Label_2

2

 

Y

e.g. levodopa

 

 

investigator

 

Card_SubTitle

 

 

Y

e.g. LastName

 

 

keywords

 

Secondary_Label_13

 

 

Y

e.g. neurodegeneration

 

Individuals

numberParticipants

 

Secondary_Label_3

 

 

 

 

 

Clinical or Phenotypic Assessment

reportedOutcome

Y

Secondary_Label_4

7

 

Y

e.g. MDS-UPDRS

 

 

sensorDataType

 

Secondary_Label_12

 

 

 

 

 

 

sensorType

Y

Secondary_Label_6

4

 

 

 

 

Study Name

study

 

Card_Title

 

link to 'id'

Y

e.g. mPower

 

Data Description

studyDataDescriptionLocation

 

 

 

 

N

 

Data description similar to methods for AMP-AD

Study Description

studyDescriptionLocation

 

 

 

 

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:

 

Field

Column Name

Location

Study Information (example)

Note

Study Name

study

study card header

MJFF Levodopa Response Study

Link to id in Synapse

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

 

Comments