How to import a CSV file

Column name	data type	Mandatory	Accepted Values	Description
dateOfBirth	Date	Yes		Date of birth cannot be after the date of death.
dateOfDeath	Date			Date of death cannot be before the date of birth.
patientID	String	Yes		The value must be unique.
lastname	String	Yes
firstname	String	Yes
gender	Enum		`MALE` `FEMALE` `UNDEFINED`
language	Enum		See languages data
race	Enum		`race.asian` `race.black` `race.chinese` `race.mixed` `race.white` `race.other`
race_other	String
addressLine1	String
addressLine2	String
postCode	String
city	String
country	String			Accept only short name country/code iso alpha 3 format.
phoneMobile	String
phoneHome	String
phoneWork	String
email	String
refusedAssessment	Boolean
medicallyUnfit	Boolean
reasonForRefusal	String

Column name	data type	Mandatory	Accepted Values	Description
assessmentDate	Date	Yes

Column name	data type	Mandatory	Accepted Values	Description
indexFracture_Date	Date	Yes
indexFracture_Hip	Boolean	^*		^* At least one value in either indexFracture_Hip, indexFracture_SpineBones or indexFracture_OtherBones is required.
indexFracture_SpineBones	Multiple	^*	See data spine bone
indexFracture_OtherBones	Multiple	^*	See data other bone
indexFracture_Type	Enum		`type.fracture.fragility` `type.fracture.atypical.hip.only` `type.fracture.periprosthetic` `type.fracture.metastatic` `type.fracture.other`
indexFracture_TypeOther	String			Will only be displayed if previous value indexFracture_Type was type.fracture.other.fracture
indexFracture_residenceTimeFracture	Enum		See residence data
indexFracture_howIdentified	Enum		`identified.emergency.room` `identified.trauma.clinic` `identified.trauma.ward` `identified.other.clinic` `identified.other.ward` `identified.radiology` `identified.other`
indexFracture_howIdentifiedOther	String			Will only be displayed if previous value indexFracture_howIdentified was identified.other

Column name	data type	Mandatory	Accepted Values	Description
previousFractures	Multiple		See previous Fractures data

Column name	data type	Accepted Values
frax_fraxScoreMajor	Float
frax_fraxScoreHip	Float
frax_fraxBmi	Float
frax_parentFracturedHip	Enum	`DONTKNOW` `NO` `YES`
frax_osteoporosis	Enum	`DONTKNOW` `NO` `YES`
frax_fragilityFracture	Enum	`DONTKNOW` `NO` `YES`
frax_smoker	Enum	`DONTKNOW` `NEVER` `EX` `CURRENT`
frax_alcohol	Enum	`DONTKNOW` `NO` `GREATER_THAN_3_UNITS`
frax_rheumatoidArthritis	Enum	`DONTKNOW` `NO` `YES`
frax_secondaryCauses	Multiple	`typeIDiabetes` `osteogenesis` `hyperthyroidism` `menopause` `malnutrition` `malabsorption`
frax_oralSteroids	Enum	`CURRENT` `EX_USER` `DONTKNOW`
frax_cancerTherapiesInhibitor	Enum	`DONTKNOW` `NO` `YES`
frax_cancerTherapiesDeprivation	Enum	`DONTKNOW` `NO` `YES`

Column name	data type	Accepted Values	Description
vertebral_backPain	Enum	`DONTKNOW` `NO` `YES`
vertebral_sites	Multiple	`cervical` `thoracic` `lumbar`
vertebral_maxPain	Integer		Integer between 0-10.
vertebral_heightLoss	Enum	`DONTKNOW` `NO` `YES`
vertebral_treatmentsBackPain	Multiple	`medication` `physiotherapy` `vertebroplasty` `otherTherapies`

Column name	data type	Mandatory	Accepted Values
previousOsteoporosisTherapy_prevOsteo	Enum	Yes	`DONTKNOW` `NO` `YES`
previousOsteoporosisTherapy_therapies	Multiple		See previousOsteoporosisTherapy data
previousOsteoporosisTherapy_supplement	Multiple		See calciumAndVitaminD data

Column name	data type	Mandatory	Accepted Values	Description
comorbidities_swallowTabletsWithWater	Enum		`DONTKNOW` `NO` `YES`
comorbidities_otherSwallowingProblems	Enum		`DONTKNOW` `NO` `YES`
comorbidities_indigestionFrequency	Enum		`DAILY` `WEEKLY` `MONTHLY` `NONE`
comorbidities_takingPPI	Boolean
comorbidities_upperGIUlcers	Enum		`WITHIN_6_MONTHS` `GREATER_THAN_6_MONTHS` `DONTKNOW` `NO`
comorbidities_ulcerDate	Date
comorbidities_barrettsOesophagitis	Enum		`DONTKNOW` `NO` `YES`
comorbidities_everOesophagealVarices	Enum		`DONTKNOW` `NO` `YES`
comorbidities_failureCKD	Enum		`DONTKNOW` `NO` `YES`
comorbidities_transplant	Enum		`DONTKNOW` `NO` `YES`
comorbidities_transplantDate	Date	^*		^*Mandatory only if comorbidities_transplant was YES
comorbidities_dialysis	Enum		`DONTKNOW` `NO` `EX` `CURRENT`
comorbidities_dialysisDate	Date	^*		^*Mandatory only if comorbidities_dialysis was EX
comorbidities_everCardiovascularDisease	Multiple		`NO` `MYOCARDIAL_INFARCTION_IN_LAST_12_MONTHS` `MYOCARDIAL_INFARCTION_MORE_THAN_A_YEAR_AGO` `STROKE_IN_LAST_12_MONTHS` `STROKE_MORE_THAN_A_YEAR_AGO` `OTHER` `DONTKNOW`
comorbidities_otherCardiovascularDisease	String			Will only be displayed if previous value comorbidities_everCardiovascularDisease was OTHER
comorbidities_dvt	Enum		`DONTKNOW` `NO` `YES`
comorbidities_pulmonary	Enum		`DONTKNOW` `NO` `YES`

Column name	data type	Mandatory	Accepted Values	Description
comorbiditiesGeneral_ontology	String

Column name	data type	Accepted Values
fallRisk_numberFalls	Integer
fallRisk_syncope	Enum	`DONTKNOW` `NO` `YES`
fallRisk_fearFalling	Enum	`DONTKNOW` `NO` `YES`
fallRisk_mobility	Enum	See data mobility

Column name	data type	Mandatory	Accepted Values	Description
calcium	Enum		`REPLETE_GREATER_THAN_700MG_DAY` `INTERMEDIATE_500_TO_700MG_DAY` `LOW_LESS_THAN_500MG_DAY`

Column name	data type	Accepted Values
examinationFindings_not_performed	Boolean
examinationFindings_kyphosis	Enum	`DONTKNOW` `NO` `YES`
examinationFindings_pulseRate	Enum	`NORMAL` `LESS_60_BPM` `IRREGULAR` `DONTKNOW`

Column name	data type	Mandatory	Accepted Values	Description
boneDensities	Multiple		See boneDensities data

Column name	data type	Mandatory	Accepted Values	Description
labTests_core	Multiple		See labTests data	Empty collection can be provided. However if a row is provided, it must have values for mandatory fields.
labTests_additional	Multiple		See labTests data	Empty collection can be provided. However if a row is provided, it must have values for mandatory fields.

Column name	data type	Mandatory	Accepted Values
treatmentRecommendations_antiOsteoTherapy_antiOsteoTherapyInfo	String	Yes	`INAPPROPRIATE` `DONTKNOW` `INFORMED_DECLINE` `REFERRED_TO_PRIMARY_CARE_PHYSICIAN_TO_DECODE_PRESCRIPTION` `REFERRED_FOR_FURTHER_CLINICAL_OPINION` `DRUGS`
treatmentRecommendations_antiOsteoTherapy_drugs	Multiple		See treatmentRecommendations_antiOsteoTherapy_drugs data
treatmentRecommendations_antiOsteoTherapy_calciumVitaminSupplement_supplementation	Multiple		See treatmentRecommendations_CalciumVitamins data
treatmentRecommendations_antiOsteoTherapy_fallsInterventionRecommendation	Object		See Falls_Intervention_Recommendation data

Column name	data type	Mandatory	Accepted Values	Description
monitorings	Multiple		See monitorings data	Empty collection can be provided. However if a row is provided, it must have values for mandatory fields.

Column name	data type	Accepted Values	Description
hipFracture_lifeStatus	Enum	`ALIVE` `DIED_PRE_SURGERY` `DIED_POST_SURGERY` `DONTKNOW`
hipFracture_asaGrade	Enum	`ASA1` `ASA2` `ASA3` `ASA4` `ASA5` `DONTKNOW`
hipFracture_fracture_sideFracture	String
hipFracture_fracture_pathological	Enum	`NO` `SUBTROCHANTERIC` `MALIGNANCY` `OTHER`
hipFracture_fracture_pathologicalOther	String		Only needed if `hipFracture_fracture_pathological` is `DONTKNOW`
hipFracture_fracture_type	Multiple	See data hip fracture type	Multiple value must be separeted by `;`. Example : `intracapsular;intertrochanteric;subtrochanateric`
hipFracture_admissionOrtho_admitted	Boolean
hipFracture_admissionOrtho_dateTime	DateTime
hipFracture_operationPerformed_arthroplasty	Multiple	See data arthroplasty	Multiple value must be separeted by `;`. Example : `revisionThrCemented;thrHybrid;thrUncemented`
hipFracture_operationPerformed_arthroplastyOther	String		Only needed if `hipFracture_operationPerformed_arthroplasty` is `other`
hipFracture_operationPerformed_internalFixation	Multiple	See data internal fixation	Multiple value must be separeted by `;`. Example : `slidingHipScrew;cannulatedScrews;imNailShort`
hipFracture_primarySurgery	DateTime
hipFracture_anaesthesia	Enum	`GENERAL` `SPINAL` `EPIDURAL` `INTRA_OPERATIVE_SEDATION` `INTRA_OPERATIVE_NERVE` `HIGH_VOLUME_PERIARTICULAR` `DONTKNOW`
hipFracture_pressureUlcers	Enum	`GRADE1` `GRADE2` `GRADE3` `GRADE4` `DONTKNOW`
hipFracture_acutePhasePhysicianInvolvement	Boolean		Physician / Geriatrician involvement in the care of the patient during the acute phase up to 72 hours post admission
hipFracture_firstDayMobilisation	Enum	`DAY_OF_OPERATION` `FOLLOWING_DAY` `DONTKNOW`	Able to sit or stand out of bed
hipFracture_dischargeOrtho_dateOfDischarge	Date
hipFracture_dischargeOrtho_dischargeDestination	Enum	`OWN_HOME` `RELATIVE_HOME` `HIP_RELATED` `REOPERATION`
hipFracture_dischargeOrtho_reoperation	Enum	`NONE` `REDUCTION` `WASHOUT` `IMPLANT_REMOVAL` `REVISION_INTERNAL` `REVISION_ARTHRO` `CONVERSION_HEMI` `CONVERSION_THR` `CONVERSION_GIRDLESTONE` `SURGERY` `DONTKNOW`	Only needed if `hipFracture_dischargeOrtho_dischargeDestination` is `REOPERATION`
hipFracture_dischargeOrtho_postAdmissions	Boolean		Alive at 30 days post admission
hipFracture_dischargeOrtho_postAdmissionsMobility	Enum	See data mobility	Only needed if `hipFracture_dischargeOrtho_postAdmissions` is `true`. Mobility at 30 days
hipFracture_dischargeOrtho_postAdmissionsResidence	Enum	See data residence	Residence at 30 days
hipFracture_dischargeOrtho_postAdmissionsResidenceOther	String		Only needed if `hipFracture_dischargeOrtho_postAdmissionsResidence` is `OTHER`

Column name	data type	Accepted Values	Description
previousFracture_Date	Date
previousFracture_Hip	Boolean
previousFracture_SpineBones	Multiple	See data spine bone	Multiple value must be separeted by `#`. Example : `bone.C1#bone.C2#bone.C3`
previousFracture_OtherBones	Multiple	See data other bone	Multiple value must be separeted by `#`. Example : `bone.clavicle#bone.shoulder`
previousFracture_Type	Enum	`type.fracture.fragility` `type.fracture.atypical.hip.only` `type.fracture.periprosthetic` `type.fracture.metastatic` `type.fracture.other.fracture`
previousFracture_residenceTimeFracture	Enum	See data residence

Column name	data type	Mandatory	Accepted Values	Description
previousOsteoporosisTherapy_nameOfDrug	String	Yes	See drug's name
previousOsteoporosisTherapy_dateStart	Date			Date start cannot be after the date finished.
previousOsteoporosisTherapy_dateFinished	Date			Date start cannot be after the date finished.
previousOsteoporosisTherapy_current	Boolean			If `true`, dateFinished will be ignored.
previousOsteoporosisTherapy_persistence	Boolean
previousOsteoporosisTherapy_compliance	Boolean
previousOsteoporosisTherapy_tolerability	String

Column name	data type	Mandatory	Accepted Values	Description
name	String	Yes	See lab test names	Must be unique acrros labtest_core and labtest_additional
testValue	String		`NORMAL` `ABNORMAL` `DONTKNOW`
level	String
action	String
externalLink	String
dateOfTest	Date

Column name	data type	Mandatory	Accepted Values	Description
nameOfDrug	Enum	Yes	See drug's name
duration	Float	Yes		In years, decimal. I.e. 1.5 = 1 year and 6 months.
tolerated	Boolean
forLife	Boolean
line	Integer

Column name	data type	Mandatory	Accepted Values
delayCardinality	Integer	Yes
delayUnit	Enum	Yes	`DAY` `WEEK` `MONTH` `YEAR`
contactOutcome	Enum		`YES_MONITORED` `NOT_MONITORED` `UNCONTACTABLE` `CONTACTED_BUT_DECLINED` `PATIENT_DIED`
residence	Enum		See residence data
comment	String
primaryOutcome	Multiple		`toleratedAndAdherent` `notStarted` `notAdherent` `notTolerated` `nowContraIndicated`
date	Date
howMonitored	Enum		`how.monitored.clinic` `how.monitored.letter` `how.monitored.telephone` `how.monitored.email` `how.monitored.routine.data` `how.monitored.sms`
continueCalciumVitamin	Enum		`DONTKNOW` `NO` `YES`
strengthBalanceClass	Enum		`DONTKNOW` `NO` `YES`
furtherFalls	Enum		`DONTKNOW` `NO` `YES`
furtherFractures	Enum		`DONTKNOW` `NO` `YES`
current_mobility	Enum		See Falls_Intervention_Recommendation data
additionalActions	String
medicationRecommendation	Multiple	Yes	See medication recommendation

Column name	data type	Accepted Values

fallsInterventionRecommendation_referralFallsService	Enum	`NO` `YES` `NOT_REQUIRED` `DONTKNOW`
fallsInterventionRecommendation_strengthBalance	Enum	`NO` `YES` `NOT_REQUIRED` `DONTKNOW`
fallsInterventionRecommendation_visionAssessment	Enum	`NO` `YES` `NOT_REQUIRED` `DONTKNOW`
fallsInterventionRecommendation_homeOccupationTherapy	Enum	`NO` `YES` `NOT_REQUIRED` `DONTKNOW`
fallsInterventionRecommendation_medicationReview	Enum	`NO` `YES` `NOT_REQUIRED` `DONTKNOW`

Column name	data type	Accepted Values	Description
primaryCarePhysician_title	String
primaryCarePhysician_lastname	String
primaryCarePhysician_firstname	String
primaryCarePhysician_language	Enum	See languages data
primaryCarePhysician_addressLine1	String
primaryCarePhysician_addressLine2	String
primaryCarePhysician_postCode	String
primaryCarePhysician_city	String
primaryCarePhysician_country	String		Accept only short name country/code iso alpha 3 format.
primaryCarePhysician_phoneMobile	String
primaryCarePhysician_phoneHome	String
primaryCarePhysician_phoneWork	String
primaryCarePhysician_email	String

Column name	data type	Accepted Values	Description
contactForMonitoring_sameAsPatient	Boolean
contactForMonitoring_agreesContact	Boolean
contactForMonitoring_relationType	String		This field and next ones are displayed only if sameAsPatient is false
contactForMonitoring_lastname	String
contactForMonitoring_firstname	String
contactForMonitoring_gender	Enum	`MALE` `FEMALE` `UNDEFINED`
contactForMonitoring_language	Enum	See languages data
contactForMonitoring_addressLine1	String
contactForMonitoring_addressLine2	String
contactForMonitoring_postCode	String
contactForMonitoring_city	String
contactForMonitoring_country	String		Accept only short name country/code iso alpha 3 format.
contactForMonitoring_phoneMobile	String
contactForMonitoring_phoneHome	String
contactForMonitoring_phoneWork	String
contactForMonitoring_email	String

Column name	data type	Mandatory	Accepted Values	Description
insuranceCoverage_companyNameInsurance	String
insuranceCoverage_insurancePolicyNumber	String
insuranceCoverage_memberIdInsurance	String
insuranceCoverage_groupIdInsurance	String
insuranceCoverage_phoneInsurance	String
insuranceCoverage_emailInsurance	String

Column name	data type	Mandatory	Accepted Values	Description
currentData_currentMedication	String
currentData_allergies	String

Column name	data type	Accepted Values
previousOsteoporosisTherapy_supplement	String
previousOsteoporosisTherapy_dose	String
previousOsteoporosisTherapy_frequency	Enum	`frequency.daily` `frequency.weekly` `frequency.monthly` `frequency.yearly`
previousOsteoporosisTherapy_frequency_times	Integer
previousOsteoporosisTherapy_persistence	Boolean

Column name	data type	Mandatory	Accepted Values	Description
boneDensities_dateOfDXA	Date
boneDensities_machine	String
boneDensities_tumbarSpineScore	Float
boneDensities_changeLS	Float
boneDensities_femoralNeck	Float
boneDensities_totalHip	Float
boneDensities_changeTH	Float
boneDensities_yearPrevDXA	Integer
boneDensities_externalLink	String

Column name	data type	Mandatory	Accepted Values	Description

medicationRecommendation	Multiple	Yes	`noLongerAppropriate`, `dontKnow`, `informedDecline`, `notOnForOtherReason` + See drug's name

¶ How to import a CSV file

¶ Specifications

¶ Format

¶ Columns

¶ Administrative

¶ Patient information

¶ Primary care physician

¶ Contact for monitoring

¶ Insurance Coverage

¶ Clinical Content

¶ Index fracture

¶ Other previous fragility fracture

¶ Fracture risk factors / FRAX score

¶ Vertebral fracture

¶ Previous osteoporosis therapy

¶ Comorbidities (specific that require exclusion)

¶ Comorbidities - General

¶ Falls risk factors

¶ Calcium intake

¶ Examination findings

¶ Bone density results

¶ Laboratory test results

¶ Other Medications and Allergies

¶ Treatment recommendations

¶ Monitorings

¶ Hip fracture

¶ Inner colmuns specifications

¶ previousFractures

¶ previousOsteoporosisTherapy

¶ prevOsteoCalciumVitaminD

¶ treatmentrecommendations_calciumvitamins

¶ boneDensities

¶ labTests_*

¶ treatmentRecommendations_antiOsteoTherapy_drugs

¶ monitorings

¶ Falls Intervention Recommendation

¶ Medication Recommendation

¶ Enums

¶ Spine bone

¶ Other bone

¶ Drug's name

¶ Lab test names (Core)

¶ Lab test names (Additional)

¶ Residence

¶ Hip Fracture type

¶ Arthroplasty

¶ Internal fixation

¶ Mobility

¶ Languages

¶ Example