wes_pds__patient.csv

Add Column

Add Node/Literal

Literal Node: wes_pds__patient.csv

Literal Type: NA
Language: NA
isUri: false

PyTransforms

consenter_uri

From column: MRN

import uuid
temp = uuid.uuid4().hex
return "consenter/" + temp

consenter_reg_uri_string

From column: MRN_FACILITY

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

#mrn_fac = getValue("MRN_FACILITY")
#if (mrn_fac == "HUP") :
#    return("http://transformunify.org/ontologies/TURBO_0000410")
#if (mrn_fac == "PMC") :
#    return("http://transformunify.org/ontologies/TURBO_0000411")
#if (mrn_fac == "PAH") :
#    return("http://transformunify.org/ontologies/TURBO_0000412")
#if (mrn_fac == "CCH") :
#    return("http://transformunify.org/ontologies/TURBO_0000413")
#else:
#    return("")

dob_xsd

From column: DOB_shift

from datetime import datetime
datestring = getValue("DOB")
datetime_object = datetime.strptime(datestring, '%Y-%m-%d %H:%M:%S')
justYear = datetime_object.year
if justYear > 2000 :
    cent_less = datetime(datetime_object.year - 100, *datetime_object.timetuple()[1:-2])
    datetime_object = cent_less
justDate = datetime_object.strftime("%Y-%m-%d")
return justDate

guid_uri_string

From column: GID

genderLiteral = getValue("GID")
if genderLiteral == "F":
    return("http://purl.obolibrary.org/obo/OMRSE_00000138")
elif genderLiteral == "M":
    return("http://purl.obolibrary.org/obo/OMRSE_00000141")
else:
    return("http://purl.obolibrary.org/obo/OMRSE_00000133")

Selections

Semantic Types

Column	Property	Class
DOB	turbo:TURBO_0000604	turbo:TURBO_00005021
GID	turbo:TURBO_0000606	turbo:TURBO_00005021
PK_PATIENT_ID	turbo:TURBO_0000608	turbo:TURBO_00005021
consenter_reg_uri_string	turbo:TURBO_0000610	turbo:TURBO_00005021
consenter_uri	uri	turbo:TURBO_00005021
dob_xsd	turbo:TURBO_0000605	turbo:TURBO_00005021
guid_uri_string	turbo:TURBO_0000607	turbo:TURBO_00005021

Links

From	Property	To
turbo:TURBO_00005021	turbo:TURBO_0000603	wes_pds__patient.csv