patients.csv

In the FHIR to Manifest operation, this file contains patient information extracted from the FHIR bundle. There will be one row per document in the set.

Available Columns

patient_id string

The unique patient ID from the FHIR bundle field patient.id. See Patient ID and Identifier.

identifier string

The primary business identifier for the patient. See Patient ID and Identifier.

lastname string

The patient’s last name.

firstname string

The patient’s first name.

middlename string

The patient’s middle name.

birthdate date

The patient’s date of birth in YYYY-MM-DD format.

gender string

The patient’s gender.

race_code, race_display, and race_string string

The patient’s race. If race information is present in the FHIR bundle as a coded concept (from the CDC Race And Ethnicity code system), code and display are present; otherwise, race_string is populated from any free-text race information available in the bundle.

ethnicity_code, ethnicity_display, and ethnicity_string string

The patient’s ethnicity. If ethnicity information is present in the FHIR bundle as a coded concept (from the CDC Race And Ethnicity code system), code and display are present; otherwise, ethnicity_string is populated from any free-text ethnicity information available in the bundle.

postalcode string

The postal code of the patient’s address.

primarycareprovider_npi, primarycareprovider_lastname, primarycareprovider_firstname, primarycareprovider_local_identifier, and primarycareprovider_id string

The NPI, last name, first name, business identifier, and unique identifier (from providers.csv) of the primary care provider for the patient.

metadata_id string

Reflects the origin of the data. Uniquely identifies a row in metadata.csv.

source_identifier string

The local identifier for the patient from the source system.

empi_identifier string

The identifier for the patient from the master patient index, if available.

page_number integer

In the custom PDF clinical data extraction workflow, the system can include page numbers referring to the original source documents.

Default Columns

The default manifest column settings include the following columns:

patient_id, identifier, lastname, firstname, middlename, birthdate, gender, race_code, race_display, race_string, ethnicity_code, ethnicity_display, ethnicity_string, postalcode, primarycareprovider_npi, primarycareprovider_lastname, primarycareprovider_firstname, primarycareprovider_local_identifier, primarycareprovider_id, metadata_id

Columns may be customized via client-specific settings.