Unsure if this is the right forum, please route me to the appropriate.
We have a requirement to convert one of the vitals, Richmond Agitation Sedation Scale (RASS) score to CDM ending in measurement table. The actual score can range from -5 to +5.
The measurement table field, value_as_number has the convention to not store negative values rather store null with some exceptions @ https://ohdsi.github.io/CommonDataModel/cdm531.html#MEASUREMENT
a) Is the solution then to store the value into value_source_value field ?
b) We also thought about leveraging the vaue_as_concept_id field by finding LOINC codes for the scores, but they seem too generic for this recognized standard scale.
e.g. RASS score +1 --> restless - concept ID 45881739
Appreciate your feedback,