Institutions and Locations

Institutions and locations can be imported into the RALS™ SYSTEM from a source file.

Jump to a heading on this page:
Select Source
Review Import

Select Source

When performing an institutions and locations import, source data must be in a TSV file. Institution and location data is included in the same import file but separated into different rows. The data in the import file is processed top to bottom, with each institution row processed before the subsequent location rows. If the location rows do not follow their parent institution, the import file will not be processed.

File Format

Institution and location import files must:

• be tab-delimited (TSV);
• contain the expected header row; and
• not exceed 10,000 rows.

Default Values

When importing institutions and locations, the following fields allow defaults to be set:

• Institution Active
• Institution Time Zone (if multiple time zone support is enabled)
  
• Institution CLIA License
• Institution CAP License
• Institution Patient ID Type
• Institution Medical Record Format
• Institution Account Format
• Institution Episode Format
• Institution Sample ID Matching
• Institution Enable A08 Processing
• Institution Permit A08 Admit
• Institution Medical Director
• Institution Clinician
• Institution Features
• Location Active
• Location Time Zone (if multiple time zone support is enabled)
  
• Location CLIA License
• Location CAP License
• Location Medical Director
• Location Clinician

Empty String Replacement

When importing institutions and locations, the following fields allow replacement with an empty string:

• Institution Address
• Institution CLIA License
• Institution CAP License
• Institution LIS Memo
• Institution Facility Code
• Institution Features
• Institution LIS Name
• Institution Medical Director
• Institution Clinician
• Institution Notes
• Institution Medical Record Format
• Institution Account Format
• Institution Episode Format
• Location Address
• Location Phone
• Location CLIA License
• Location CAP License
• Location LIS Memo
• Location Facility Code
• Location LIS Name
• Location LDAP Alias
• Location GEMweb Plus 500 Alias
• Location Supervisor
• Location Medical Director
• Location Clinician
• Location Notes

Case Sensitivity

When importing institutions and locations, the following fields in the file are NOT case sensitive (e.g., ABC is the same as aBC):

• Institution Patient ID Type
• Institution Sample ID Matching

Time Zones

The institutions and locations file must contain a column for time zone regardless of whether multiple time zone support is enabled.

• If multiple time zone support is NOT enabled, the time zone field must be blank.
• If multiple time zone support is enabled, the time zone field is required for new institutions and locations. It can be blank if a default value has been selected. The time zone of an existing institution or location can only be changed if the system setting for editing the time zone of an institution or location is enabled. If the time zone field for an existing institution or location is blank, the time zone will not be changed.
  

Review Import

Prior to import, you can preview changes and review institutions and locations import information, including:

• File name
• Language
• Number of new institutions
• Number of new locations
• Number of edited institutions
• Number of edited locations

If changes are unable to be made, the errors will be displayed in a table for your reference.