The lab order CSV specification defines a format for uploading lab orders to GenXys. The CSV file begins with a header row of defined column names (see below), followed by one or more data rows — one per lab order. Each column represents a specific attribute of the lab order, such as patient information, specimen details, or medication history. Together, these columns organize all required information into a structured format for seamless integration with GenXys.
The lab order CSV uses a comma as a delimiter between values. To include a comma within a value, enclose the entire value in double quotes. For example, enter the OrderedBy value Doc McDoctor, MD as "Doc McDoctor, MD" so the CSV parser treats the comma as part of the name, not as a delimiter.
Use YYYY-MM-DD as the preferred date format for all date fields. If you omit this format, the system falls back to M/D/YYYY (the US Excel default). If your dates use a different format, convert them to one of the supported formats — see DOB below for the full list.
resourceType, orderedBy, orderedByProviderID, orderedByInstitution_name, orderedByInstitution_addressLine1, orderedByInstitution_addressLine2, orderedByInstitution_city, orderedByInstitution_region, orderedByInstitution_postalCode, orderedByInstitution_country, clinicIdentifier, clinicType, clinicInstance, barcode, panel, tag, identifier, identifiers1_identifier_type, identifiers1_identifier_value, identifiers2_identifier_type, identifiers2_identifier_value, firstName, lastName, dob, sexAtBirth, email, addressLine1, addressLine2, city, region, postalCode, country, notes, footernote, sampleId, specimen_type, specimen_date, specimen_received, specimen_quality, ethnicity, ethnicity_coding_system, ethnicity_coding_code, medication1_name, medication1_dosage, medication1_coding_system, medication1_coding_code, medication1_indication_name, medication1_indication_coding_system, medication1_indication_coding_code, medication2_name, medication2_dosage, medication2_coding_system, medication2_coding_code, medication2_indication_name, medication2_indication_coding_system, medication2_indication_coding_code, consideredMedication1_name, consideredMedication1_dosage, consideredMedication1_coding_system, consideredMedication1_coding_code, consideredMedication1_indication_name, consideredMedication1_indication_coding_system, consideredMedication1_indication_coding_code
patient, "Doc McDoctor, MD", XYZ-123, McDocs Health, 123 Main Street, Unit 999, Springfield, IL, 90210, USA, HCP_CLINIC_IDENTIFIER, HCP_CLINIC_IDENTIFIER-TYPE, HCP_CLINIC_INSTANCE, LAB_IDENTIFIER, PANEL_IDENTIFIER, TAG_IDENTIFIER, DEF-456, DL, DL-111-222-333, MR, 999-777-555-333-111, Test2, Genxys, 1970-01-07, F, tgen@genxys.com, 123 Sesame Street, Unit 5, Anytown, CA, 90210, US, note text, footer text, SAMPLE-ID, swab, 2024-02-24, 2024-02-20, Extracted 3x, African/African American, gnomAD, AFR, ACH-ATORVASTATIN 40 MG TABLET, "1 Tablet, QD", DIN, 245776, Attention Deficit Hyperactivity Disorder, ICD9, 314.01, ACT CLOPIDOGREL 75 MG TABLET, "1 puff, Q12H", DIN, 2303027, Diabetes Mellitus Type 2, ICD9, 250, Acetaminophen 500 MG Oral Tablet, "1 Tablet, PRN", RxCUI, 209459, Chronic Pain - Low Back Pain, ICD9, 724.2
hcp - not supported in v1
The health care provider who has ordered the test
The health care provider identifier
Ordering Institution name and address defined by the columns: orderedByInstitution_name, orderedByInstitution_addressLine1, orderedByInstitution_addressLine2, orderedByInstitution_city, orderedByInstitution_region, orderedByInstitution_postalCode, orderedByInstitution_country
Name of the ordering institution
Ordering institution street address
Ordering institution street address continued
Ordering institution city
Ordering institution region
Ordering institution postal/zip code
Ordering institution country
GenXys clinic identifier is a required field that can be set to the lab's clinic identifier or the associated HCP's clinic identifier
GenXys clinic type is an optional value for a HCP the report should be associated with
GenXys clinic instance is an optional value for a HCP the report should be associated with
Barcode is the internal lab identifier for associating a patient order with corresponding results. If no barcode is specified, the patient identifier will be used for this field.
Panel identifier (optional) for multi-panel solutions. Will override default report templates if specified and matches a template of the same name.
Tag identifier (optional) for custom templates. Will override default report template if specified and matches a template of the same name.
Identifier is the patient identifier associated with a patient case in the GenXys Portal. It allows results to be pushed to an existing patient case in the GenXys Portal.
Identifiers are the patient identifiers associated with a patient case in the GenXys Portal. It allows results to be pushed to an existing patient case in the GenXys Portal.
To declare an identifiers group define two columns with the prefix 'identifiers' followed by a group number and then followed by the suffixes '_identifier_type' and '_identifier_value'.
For new identifiers groups, increment the identifiers group number by one each time.
Example of two identifiers groups:
identifiers1_identifier_type, identifiers1_identifier_value, identifiers2_identifier_type, identifiers2_identifier_value
DL, DL-111-222-333, MR, 999-777-555-333-111
Identifier Type
DL Driver's License
MR Medical Record Number
NH National Health Service
PHN Patient Health Number
PRN Provider Number
SB Social Beneficiary
Identifier Value
Value associated with identifier type.
Maximum length is 50 characters.
Patient name defined by the columns: firstName, lastName
First Name
Last Name
Patient Demographics defined by the columns: dob, sexAtBirth, email
Date of Birth
Valid values:
YYYY-MM-DD ISO 8601 2000-12-11
YYYY/MM/DD ISO 8601 variant 2000/12/11
DD-MMM-YYYY named month 11-Dec-2000
DD MMM YYYY named month space 11 Dec 2000
MMM DD YYYY named month space Dec 11 2000
MM/DD/YYYY US locale ONLY 12/11/2000
MM-DD-YYYY US variant 12-11-2000
M/D/YYYY US Excel default 12/11/2000
Sex at Birth
patient email address
Patient address defined by the columns: addressLine1, addressLine2, city, region, postalCode, country
patient street address
patient street address continued
City
Region
Postal Code
Country
Ethnicity defined by the columns: ethnicity, ethnicity_coding_system, ethnicity_coding_code
Ethnicity label for a given ancestry classification (e.g., 'East Asian', 'Sub-Saharan African')
The classification system or ontology used to define the ancestry groups
Code assigned to the ancestry group within the specified classification system
Sample specimen defined by the columns: sampleId, specimen_type, specimen_date, specimen_received, specimen_quality
The identifier associated with the sample specimen
The type of specimen (i.e. swab, blood etc)
The specimen collection date
The date the specimen was received from the patient
Specimen quality is an optional value detailing the quality of the sample
Patient Notes
Footer Note allows a lab to include a custom message on each report, either for a specific patient or a specific facility.
Maximum length is 5000 characters.
Patient Current Medications
To declare a current medications group define seven columns with the prefix 'medication' followed by a group number and then followed by the suffixes '_name', '_dosage', '_coding_system', '_coding_code', '_indication_name', '_indication_coding_system', '_indication_coding_code'.
For new current medications groups, increment the current medications group number by one each time.
Example of one current medications group:
medication1_name, medication1_dosage, medication1_coding_system, medication1_coding_code, medication1_indication_name, medication1_indication_coding_system, medication1_indication_coding_code
ACH-ATORVASTATIN 40 MG TABLET, "1 Tablet, QD", DIN, 245776, Attention Deficit Hyperactivity Disorder, ICD9, 314.01
Drug Name (Brand/Generic)
application application
bottle bottle
capsule capsule
dose dose
drop drop
g g
mg mg
package package
puff puff
spray spray
tablet tablet
unit unit
vial vial
1xMonth Once a month
1xWeek Once a week
1xYear Once a year
21/28D 21 out of 28 days
2xWeek 2 times a week
3xWeek 3 times a week
4xWeek 4 times a week
5xWeek 5 times a week
6xWeek 6 times a week
BID Two times daily
MWF Mon, Wed, Fri
ONCE One time only
PRN As needed
Q12H Every 12 hours
Q1-2H Every 1 to 2 hours
Q12W Every 12 weeks
Q2D Every other day
Q2H Every 2 hours
Q2W Every 2 weeks
Q4-6H Every 4 to 6 hours
Q4H Every 4 hours
Q4W Every 4 weeks
Q6-8H Every 6 to 8 hours
Q6H Every 6 hours
Q6W Every 6 weeks
Q8H Every 8 hours
Q8W Every 8 weeks
QAM Every morning
QD Once daily
QHS Every day at bedtime
QID Four times daily
QNOON Every day at noon
QPM Every evening
TID Three times daily
TTSS Tues, Thur, Sat, Sun
Dosage
Drug Identifier System
Drug Identifier
Condition name
Condition Encoding Identifier System
Condition Encoding Identifier
Medications under review or contemplated but are not part of the active prescription list.
To declare a considered medications group define seven columns with the prefix 'consideredMedication' followed by a group number and then followed by the suffixes '_name', '_dosage', '_coding_system', '_coding_code', '_indication_name', '_indication_coding_system', '_indication_coding_code'.
For new considered medications groups, increment the considered medications group number by one each time.
Example of one considered medications group:
consideredMedication1_name, consideredMedication1_dosage, consideredMedication1_coding_system, consideredMedication1_coding_code, consideredMedication1_indication_name, consideredMedication1_indication_coding_system, consideredMedication1_indication_coding_code
ACH-ATORVASTATIN 40 MG TABLET, "1 Tablet, QD", DIN, 245776, Attention Deficit Hyperactivity Disorder, ICD9, 314.01
Follow medication specification as described under Current Medications