Synapse Table: syn21994974
...
- 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 | |
|---|---|---|---|---|---|---|---|---|---|
| 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 | Y | e.g. tremorN | Data description similar to methods for AMP-AD | |||||
| Study Description | studyDescriptionLocation | YN | Full Study description for Study page | ||||||
| studyDescription | Card_Description |
Study Detail Page
Study Detail pages retrieve data from multiple tables.
...