CSV file operations
LNRs can be added, updated, or deleted using a CSV file. To add a LNR you must create this CSV file from scratch. For existing LNRs, you can download the CSV file from the Lab Normals page to make edits or remove entries.
The CSV file a lab vendor contains the following 25 columns:
| Column | Description |
|---|---|
| Lab Vendor ID | This is the ID of the lab vendor for which LNRs are being uploaded. Lab vendor ID should already exist in a system. |
| Lab Vendor Name | Name of the lab vendor. |
| Lab Test | Name of the lab test for which LNR is being added. |
| Result Unit | LNR Unit. |
| Date Valid From (dd/MMM/yyyy) | LNR Effective Start Date. |
| Date Valid To (dd/MMM/yyyy) | LNR Effective End Date. |
| Specimen Type | Lab test specimen type (enter "N/A" if not applicable). |
| Range Type | LNR range type (character or numeric). |
| Numeric Oprtr | The operator value if the numeric range is without defined lower or upper ranges. |
| Lower Limit | Lower numeric range. |
| Upper Limit | Upper numeric range. |
| Acceptable Character Values | If Range Type is character-based, then the valid in-range character values must be separated by ";". |
| Unacceptable Character Values | If Range Type is character-based, then the invalid range character values must be separated by ";". |
| Gender | Gender value (Male/Female) if LNR is gender-dependent; otherwise, “Both”. |
| Lower Age | Lower age value if the LNR is age-dependent. |
| Upper Age | Upper age value if the LNR is age-dependent. |
| Lower Age Unit | Age unit (Days/Weeks/Months/Years). |
| Upper Age Unit | Age unit (Days/Weeks/Months/Years). |
| Valid Age Oprtr | The operator value if age is without a defined lower or upper age. |
| Valid Age | Age value the LNR is valid for. |
| Valid Age Unit | Age unit (Days/Weeks/Months/Years). |
| Comments | Any LNR-related comments. |
| LNRdbid | This is an internal database identifier for the LNR and is required for updates or deletions for existing LNRs. This is automatically populated in the CSV file when the CSV file is downloaded from the Lab Normals page. |
| TransactionType |
Only accepted values are:
Any other value will raise an error for that row. If no value is provided, application defaults to “I” (insert).
|
| ReasonForChange | This is used during updates or deletions of existing vendors. If not provided, the application defaults to “changed information”. |