Skip to main content

CCL Location Information Export

An optional export for patient room and bed data.

This export is an optional enhancement to the ADT feed and is only necessary if the existing ADT feed does not contain the patient's room and bed information throughout their ED visit.

The output should contain the following data elements:

Field

Definition

Format

MRN

The medical record number used to identify the patient within your system.

String

Encounter

The number used to identify the patient's visit/encounter within your system.

String

Facility

The facility from the patient's location record.

String

Department

The department from the patient's location record.

String

Room

The room from the patient's location record.

String

Bed

The bed (if available) from the patient's location record.

String

DateTimeUpdated

The timestamp from the patient's location record.

mm/dd/yyyy HH:MM:ss

Additional Details

  • Runs every 5 - 15 minutes

  • Each filename should be unique

  • Should include all ED patient location information for the past 1 hour

  • Timestamps must include seconds

  • Output should be a comma-separated values list, or .csv

  • Individual values should be surrounded by quotation marks (")

  • Individual values should be separated by commas (,)

  • All leading and trailing spaces should be eliminated

  • All records should be separated by a new line character

  • The first row in the file should be the header row

Sample Script and Output

A sample script and output can be found in our Integration Helpers repository.

Did this answer your question?