column name: name in data portal
synapse table name: corresponding name (e.g., for SQL query) in Synapse table view
facet: true if column_name should be faceted in data portal.
desired for CSBC/PS-ON: should this column be included in the CSBC data portal
Synapse table view source for this card: https://www.synapse.org/#!Synapse:syn10142562/tables/
There are extra rows in the above Synapse file view, which should be subsetted to those rows with grantType == U54 or U01
Several columns are missing from the above Synapse file view and are being added: centerSite, abstract, and keyInvestigators
| column name | synapse table name | facet | desired for CSBC/PS-ON | concept | example | required | column type | size | restricted values | comments | in AMP-AD table | desired for CSBC/PS-ON | Grant/Project Name | yes | largeText|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Grant Name | name | no | yes | The name of the grant/project. | Stanford University Center for Cancer Systems Biology | yes | string | CSBC/PS-ON will want this called "Grant Name" | yesyes | ||||||
| Grant NumberCenter Name | grantNumber | no | no | Grant NumberCA209971 | yes | string | yes | ||||||||
| Program | consortium | yes | yes | ProgramCSBC | yes | string | CSBC, PS-ON, AMP-AD, M2OVE-AD, MODEL-AD, Resilience-AD | yes | yes | ||||||
| Key Investigators | keyInvestigators | no | yes | Sylvia Plevritis, Garry Nolan, Ed Engleman, John Sunwoo | yes | string vector | yes | ||||||||
| Institutions | institution | no | yes | Stanford | yes | string vector | There may be multiple institutions associated with a grant. | yes | |||||||
| Link to Center Site | centerSite | no | yes | Link to an external URL representing the project/grant. | http://ccsb.stanford.edu | no | link | yes | |||||||
| Link to Synapse Site | id | no | entity? | yes | Abstractyes | Link to a Synapse URL (i.e., a Synapse project or more generally a Synapse Wiki) representing the project/grant. | syn7080714 | no | entity | ||||||
| Abstract | abstract | no | yes | yes | largeTextyes?This should be searchable. | yes | |||||||||
| Key Data Contributors | no | yesno | no | string vector | I don't think this is relevant for CSBC. | yes | |||||||||
| Grant Type | grantType | yes | yes | U54 | no? | string | U01, U54, U24, R01 | for For CSBC, it will be interesting and relevant to summarize/visualize data based on center type (i.e., in a facet). But it's probably not necessary to display it on the project card. | no | no? | |||||
| Funding Agency | fundingAgency | no | no | NCI | no | string | NCI | no | |||||||
| Synapse Team ID | teamProfileId | no | no | CSBC has a Synapse team for each grant/center. | https://www.synapse.org/#!Team:3346413 | no | string (url) or synapse entity | nono |
Until Synapse has a solution for multiple values in a single table cell (i.e., vectors), use pipe " | " to separate multiple values. Eg: fundingAgency: CTF | NTAP.