documentation:next_cdm:metadata
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
documentation:next_cdm:metadata [2017/04/04 13:49] vojtechhuser [new METADATA table] |
documentation:next_cdm:metadata [2017/04/04 13:50] vojtechhuser |
||
|---|---|---|---|
| Line 37: | Line 37: | ||
| | NAME |Name of the CONCEPT_ID stored in METADATA_CONCEPT_ID or in the event there is not an applicable CONCEPT_ID NAME can be used to represent the data stored (e.g. CDM_BUILDER VERSION) |VARCHAR(250) | | | NAME |Name of the CONCEPT_ID stored in METADATA_CONCEPT_ID or in the event there is not an applicable CONCEPT_ID NAME can be used to represent the data stored (e.g. CDM_BUILDER VERSION) |VARCHAR(250) | | ||
| | VALUE_AS_STRING |Store the metadata value (string)|NVCHAR | | | VALUE_AS_STRING |Store the metadata value (string)|NVCHAR | | ||
| - | | VALUE_AS_CONCEPT_ID |OMOP Vocabulary CONCEPT_ID that reflects the metadata value |NVCHAR | No | | + | | VALUE_AS_CONCEPT_ID |OMOP Vocabulary CONCEPT_ID that reflects the metadata value |int | No | |
| | METADATA_DATETIME | The date and time associated with metadata |datetime | No | | | METADATA_DATETIME | The date and time associated with metadata |datetime | No | | ||
| | METADATA_DATE | date |date | No | | | METADATA_DATE | date |date | No | | ||
documentation/next_cdm/metadata.txt ยท Last modified: 2017/07/10 16:26 by clairblacketer
Page Tools
