CSV Bulk calculations specifications: TBS

This type of CSV allows to get, for each row, adjusted scores according to TBS value.

Adjusting conventional FRAX estimates of fracture probability according to TBS value (only available if Ge-Lunar or Hologic devices were chosen to compute T-score). If T-score is specified, you have to select the device used for measuring the BMD. Due to uncertainty in the adjustments for TBS at age extremes, the ranges of ages allowed are as follows; Hip fracture (50-80 years for GE-Lunar and Hologic; Major osteoporotic fracture (GE-Lunar 40-90 years, Hologic (50-90 years). For example, an 83 year old would have the TBS hip probability adjustment calculated as if age 80 years.

Input Variables

A CSV input file should always have 15 columns. An optional header can be sent as first line of the CSV file:

Score unit,Country,Age,Sex,BMI,Previous fracture,Parental history,Current smoker,Gluccocorticoid,Rheumatoid Arthritis,Secondary osteoporosis,Alcohol,Femoral neck BMD,Value,Scanning equipment

The first columns are the FRAX variables:

#	Col	Variable	Description	Possible Values
1	A	Score unit	Unit for variable 13	t: T-score, z: Z-score. Unit for parameter 13 (BMD) described below.
2	B	Country	Code for country and ethnicity	Integer. Get valid countries' id from the API.
3	C	Age	Age in years	Positive real number (40-90), can have decimals. Out of bound values will be capped.
4	D	Sex	Gender	0: men, 1: women
5	E	BMI	Body Mass Index	Positive real number (kg/m²), can have decimals
6	F	Previous fracture	History of previous fracture	0: no, 1: yes
7	G	Parental history	Parent(s) with hip fracture history	0: no, 1: yes
8	H	Current smoker	Current smoking status	0: no, 1: yes
9	I	Gluccocorticoid	Gluccocorticoid use	0: no, 1: yes
10	J	Rheumatoid Arthritis	Presence of rheumatoid arthritis	0: no, 1: yes
11	K	Secondary osteoporosis	Presence of secondary osteoporosis	0: no, 1: yes
12	L	Alcohol	More than two drinks a day	0: no, 1: yes
13	M	Femoral neck BMD	Bone mineral density measurement	Real number (T-score or Z-score). The T-score for both genders should be derived by comparing the individual BMD to the young normal FEMALE NHANES III reference range for the make of scanner that you are using.

Then we need the adjustment variable:

#	Col	Variable	Description	Possible Values
14	N	Value	Lumbar Spine TBS value. Please enter the Trabecular Bone Score to compute the ten year probability of fracture adjusted for TBS. Attention, TBS values are accurate only for patients (women and men) with a BMI in the range [15 – 37 kg/m²]	Real number from 0.5 to 2
15	O	Scanning equipment	The make of DXA scanning equipment used and then enter the actual femoral neck BMD.	LUN for GE-Lunar, HOL for Hologic

Output Results

Once processed, you will receive an output file with, for each row, the results append to the original line (the variables above).

#	Col	Result	Description
16	P	TBS MOF w BMD	Adjusted MOF with BMD according to TBS value and machine
17	Q	TBS Hip w BMD	Adjusted HIP with BMD according to TBS value and machine

Output warning or error reporting

If an error for any adjustments of the row has been triggered, a specific message will be added at the end of the line.

#	Col	Processor messages
18	R	Warning or error messages