wes_pds__encounter_by_pkpatid.csv

Add Column

Add Node/Literal

Literal Node: wes_pds__encounter_by_pkpatid.csv

Literal Type: NA
Language: NA
isUri: false

PyTransforms

enc_uri

From column: RAWTOHEX.PK_PATIENT_ENCOUNTER_ID.

temp = getValue("RAWTOHEX.PK_PATIENT_ENCOUNTER_ID.")
return "hcEncounter/" + temp

encoutner_reg_uri_string

From column: enc_uri

return("http://transformunify.org/ontologies/TURBO_0000440")

karma_height_cm

From column: HEIGHT_INCHES

totinches = float(getValue("HEIGHT_INCHES"))
cm = totinches * 2.54
return(str(cm))

selected_bmi

From column: BMI

temp = float(getValue("BMI"))
return(str(temp))

karma_weight_kg

From column: WEIGHT_LBS

lbs = float(getValue("WEIGHT_LBS"))
kgs = lbs / 2.205
return(str(kgs))

encounter_date_xsd

From column: ENC_DATE

from datetime import datetime
datestring = getValue("ENC_DATE")
#return(datestring)
datetime_object = datetime.strptime(datestring, '%Y-%m-%d %H:%M:%S')

# xsd = datetime_object.isoformat()
# return xsd
justDate = datetime_object.strftime("%Y-%m-%d")
return justDate

Selections

Semantic Types

Column	Property	Class
ENC_DATE	turbo:TURBO_0000644	obo:OGMS_00000971
RAWTOHEX.PK_PATIENT_ENCOUNTER_ID.	turbo:TURBO_0000648	obo:OGMS_00000971
enc_uri	uri	obo:OGMS_00000971
encounter_date_xsd	turbo:TURBO_0000645	obo:OGMS_00000971
encoutner_reg_uri_string	turbo:TURBO_0000650	obo:OGMS_00000971
karma_height_cm	turbo:TURBO_0000646	obo:OGMS_00000971
karma_weight_kg	turbo:TURBO_0000647	obo:OGMS_00000971
selected_bmi	turbo:TURBO_0000655	obo:OGMS_00000971

Links

From	Property	To
obo:OGMS_00000971	turbo:TURBO_0000643	wes_pds__encounter_by_pkpatid.csv