Example

TOBA-52 - Getting issue details... STATUS

Row 1:Shows a value collected in 1 unit, but converted to selected standard unit.
Rows 2-4:Show 2 records for alkaline phosphatase that were collected 1 day apart and are expected to be reported together. Row 4 shows how to create a derived record (average of the rows 2 and 3) and flag it as derived (LBDRVFL = "Y") as well as the record to use as baseline (LBBLFL = "Y").
Rows 6-7:Show a suggested use of the LBSCAT variable. It could be used to further classify types of tests within a laboratory panel (e.g., "DIFFERENTIAL").
Row 9:Shows the proper use of the LBSTAT variable to indicate "NOT DONE," when the fact that the test was done was documented.
Row 12:The subject had cholesterol measured. The normal range for this test is <200 mg/dL. The value <200 may not be used in the normal range variables LBORNRHI or LBSTNRHI; however, an applicant may decide, for example, to enter "0" into LBORNRLO and "199" in LBORNRHI. The applicant must define the appropriate value for all of the normal range variables.
Row 13:Shows the use of LBUSCHFL to indicate that the test result was obtained from an unscheduled blood collection. In this case, the subject was moribund and a blood sample was taken prior to sacrifice.
Rows 1, 6:Use records in the SUPPLB dataset example to show biological significance assigned by the investigator for test results.

lb.xpt

lb.xpt

RowSTUDYIDDOMAINUSUBJIDLBSEQLBTESTCDLBTESTLBCATLBSCATLBORRESLBORRESULBSTRESCLBSTRESNLBSTRESULBSTNRLOLBSTNRHILBNRINDLBSTATLBREASNDLBSPECLBMETHODLBBLFLLBFASTLBDRVFLLBUSCHFLLBDTCLBDYLBNOMDYLBNOMLBL
1ABCLBABC-001-0011ALBAlbuminCLINICAL CHEMISTRYLIVER FUNCTION30kg/m33.03g/dL3.55LOW

SERUM
YY

2006-07-19T08:3011Chemistry Day 1
2ABCLBABC-001-0012ALPAlkaline PhosphataseCLINICAL CHEMISTRYGENERAL398U/L398398U/L40160


SERUM

Y

2006-07-19T08:3011Chemistry Day 1
3ABCLBABC-001-0013ALPAlkaline PhosphataseCLINICAL CHEMISTRYGENERAL350U/L350350U/L40160


SERUM

Y

2006-07-20T12:3021Chemistry Day 1
4ABCLBABC-001-0014ALPAlkaline PhosphataseCLINICAL CHEMISTRYGENERAL374U/L374374U/L40160


SERUM
YYY
2006-07-19T08:3011Chemistry Day 1
5ABCLBABC-001-0015WBCLeukocytesHEMATOLOGY
5.910^9/L5.95.910^9/L411


WHOLE BLOOD
YY

2006-07-19T08:3011Hematology Day 1
6ABCLBABC-001-0016LYMLELymphocytes/ LeukocytesHEMATOLOGYDIFFERENTIAL6.7%6.76.7%2540LOW

WHOLE BLOOD
YY

2006-07-19T08:3011Hematology Day 1
7ABCLBABC-001-0017NEUTNeutrophilsHEMATOLOGYDIFFERENTIAL5.110^9/L5.15.110^9/L28


WHOLE BLOOD
YY

2006-07-19T08:3011Hematology Day 1
8ABCLBABC-001-0018PHpHURINALYSIS
7.5
7.57.5
5.009.00


URINE
YY

2006-07-19T08:3011Urinalysis Day 1
9ABCLBABC-001-0019ALBAlbuminCLINICAL CHEMISTRYLIVER FUNCTION







NOT DONEInsufficient sampleSERUM




2006-07-24T09:0066Chemistry Day 6
10ABCLBABC-001-00110CREATCreatinineCLINICAL CHEMISTRY
0.9mg/dL8080umol/L44.201114.9226


SERUM




2006-07-24T09:0066Chemistry Day 6
11ABCLBABC-001-00111WBCLeukocytesHEMATOLOGY
5.910^9/L5.95.910^9/L411


WHOLE BLOOD

Y

2006-07-24T09:0066Hematology Day 6
12ABCLBABC-001-00112CHOLCholesterolCLINICAL CHEMISTRY
229mg/dL229229mg/dL0199HIGH

SERUM




2006-07-24T09:0066Chemistry Day 6
13ABCLBABC-001-00113WBCLeukocytesHEMATOLOGY
9.810^9/L9.89.810^9/L411


WHOLE BLOOD



Y2006-07-27T06:4299Unscheduled Hematology Day 9
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

$titleHtml

supplb.xpt

RowSTUDYIDRDOMAINUSUBJIDIDVARIDVARVALQNAMQLABELQVALQORIGQEVAL
1ABCLBABC-001-001LBSEQ1BIOSIGBiological SignificanceNOTHERPRINCIPAL INVESTIGATOR
2ABCLBABC-001-001LBSEQ6BIOSIGBiological SignificanceNOTHERPRINCIPAL INVESTIGATOR
$warningHtml

Example

Rows 1-3:Show urine analysis for glucose.
Row 1:Shows an example of a predose urine collection interval (from 4 hours prior to dosing until 15 minutes prior to dosing) with a negative value for LBELTM that reflects the end of the interval in reference to dosing (LBTPTREF), the date of which is recorded in LBRFTDTC.
Rows 2-3:Show an example of postdose urine collection intervals with values for LBELTM that reflect the end of the intervals in reference to the fixed reference LBTPTREF, the date of which is recorded in LBRFTDTC.
Row 4:Shows an assessment of color was also included for the sample collected from 8 to 16 hours postdose.

lb.xpt

lb.xpt

RowSTUDYIDDOMAINUSUBJIDLBSEQLBTESTCDLBTESTLBCATLBORRESLBORRESULBORNRLOLBORNRHILBSTRESCLBSTRESNLBSTRESULBSTNRLOLBSTNRHILBSPECLBMETHODLBBLFLLBDTCLBENDTCLBDYLBENDYLBNOMDYLBTPTLBTPTNUMLBELTMLBTPTREFLBRFTDTC
1ABCLBABC-001-0011GLUCOSEGlucoseURINALYSIS7mg/dL1150.390.39mmol/L0.060.83URINE

2006-07-19T04:002006-07-19T07:45111Predose1-P15MDay 1 dose2006-07-19T08:00
2ABCLBABC-001-0012GLUCOSEGlucoseURINALYSIS11mg/dL1150.610.61mmol/L0.060.83URINE

2006-07-19T08:002006-07-19T16:001110-8 hours after dosing2P8HDay 1 dose2006-07-19T08:00
3ABCLBABC-001-0013GLUCOSEGlucoseURINALYSIS9mg/dL1150.500.50mmol/L0.060.83URINE

2006-07-19T16:002006-07-20T00:001218-16 hours after dosing3P16HDay 1 dose2006-07-19T08:00
4ABCLBABC-001-0014COLORColorURINALYSISYELLOW


YELLOW



URINE

2006-07-19T16:002006-07-20T00:001218-16 hours after dosing3P16HDay 1 dose2006-07-19T08:00
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Example

This is an example of urine glucose test records, 1 with a result and 1 with no result because the test was not performed due to sample being insufficient.

Row 1:Shows an example of a urine glucose test record that was originally recoded in the collection system as "-" (negative sign). Instead, the results show the text value associated with that code in both LBORRES and LBSTRESC.
Row 2:Shows an example of a serum glucose test that was not performed because the sample was exhausted, and the applicant felt it was necessary to report a record documenting the reason why the test was not performed.

lb.xpt

lb.xpt

RowSTUDYIDDOMAINUSUBJIDLBSEQLBTESTCDLBTESTLBCATLBORRESLBORRESULBSTRESCLBSTRESNLBSTRESULBSTATLBREASNDLBSPECLBMETHODLBBLFLLBDTCLBDYLBNOMDY
1ABCLBABC-001-0011GLUCOSEGlucoseURINALYSISNEGATIVE
NEGATIVE



URINE

2006-07-19T04:0011
2ABCLBABC-001-0021GLUCOSEGlucoseCLINICAL CHEMISTRY




NOT DONESAMPLE EXHAUSTEDSERUM

2006-07-24T08:0055
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Example

This is an example of albumin tests done for pooled subjects. Samples from subjects ABC-009, ABC-010, and ABC-011 were pooled, and their results were reported as pooled results. The associated POOLDEF rows follow, to illustrate the pool definition.

Rows 1-3: Show the results pooled from subjects ABC-009, ABC-010, and ABC-011, with POOLID of POOL001.


lb.xpt

lb.xpt

RowSTUDYIDDOMAINUSUBJIDPOOLIDLBSEQLBTESTCDLBTESTLBCATLBORRESLBORRESULBSTRESCLBSTRESNLBSTRESULBSPECLBMETHODLBBLFLLBDTCLBDYLBNOMDY
1ABCLB
POOL0011ALBAlbuminCLINICAL CHEMISTRY3.0g/dL3.03.0g/dLSERUM

2006-07-19T04:0011
$warningHtml
$titleHtml

pooldef.xpt

RowSTUDYIDPOOLIDUSUBJID
1ABCPOOL001ABC-009
2ABCPOOL001ABC-010
3ABCPOOL001ABC-011
$warningHtml

TOBA-278 - Getting issue details... STATUS

Example

The following example shows cases of categorical data that cannot be considered as numeric, even though in some cases it appears that the data includes a number. The allowed values in these ranges should be defined in the data definition file. Samples were collected at one point and not over a given interval.

Rows 1-2:Show an example of urine ketones tests performed for 2 animals. The test's values are categorical, using a list (i.e., NEGATIVE, TRACE, SMALL, MODERATE, LARGE), the range of which is referenced in LBSTRNRC. LBSTRESN is left null.
Rows 3-4:Show an example of urine bilirubin tests performed for 2 animals. The test's values are categorical, using a list (i.e., NEGATIVE, 1+, 2+, 3+) which represents qualitative levels. Although the 1+, 2+, and 3+ values could be converted to numbers, the values represent a nonnumeric category based on an arbitrary scale; therefore, LBSTRESN is left blank.
Rows 5-6:Show an example of urine protein tests performed for 2 animals. The test's values are categorical, using a list (i.e., NEGATIVE, TRACE, 30, 100). Although the 30 and 100 values could be converted as numbers, the values represent a nonnumeric label of the result; therefore, LBSTRESN is left blank.

lb.xpt

lb.xpt

RowSTUDYIDDOMAINUSUBJIDLBSEQLBTESTCDLBTESTLBCATLBORRESLBORRESULBSTRESCLBSTRESNLBSTRESULBSTNRCLBSPECLBMETHODLBBLFLLBDTCLBDYLBNOMDY
1ABCLBABC-001-0011KETONESKetonesURINALYSISSMALL
SMALL

NEGATIVE TO LARGEURINE

2006-07-1911
2ABCLBABC-001-0022KETONESKetonesURINALYSISLARGE
LARGE

NEGATIVE TO LARGEURINE

2006-07-1911
3ABCLBABC-001-0013BILIBilirubinURINALYSISNEGATIVE
NEGATIVE

NEGATIVE TO 3+URINE

2006-07-1911
4ABCLBABC-001-0024BILIBilirubinURINALYSIS2+
2+

NEGATIVE TO 3+URINE

2006-07-1911
5ABCLBABC-001-0015PROTProteinURINALYSISTRACE
TRACE

NEGATIVE TO 100URINE

2006-07-1911
6ABCLBABC-001-0026PROTProteinURINALYSIS30
30

NEGATIVE TO 100URINE

2006-07-1911
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

  • No labels