provider table

provider

A description table for providers in the database referenced by provider_id. As of MIMIC-IV v2.2, this table simply lists all unique provider_id in the database.

Note that most tables contain a prefix before provider_id. All columns with a suffix link to provider_id, including:

• admit_provider_id
• enter_provider_id
• order_provider_id

Table columns

provider_id

provider_id lists all possible identifiers for providers used throughout the database. Provider identifiers follow a consistent pattern: the letter “P”, followed by either three numbers, followed by two letters or two numbers. For example, “P003AB”, “P00102”, “P1248B”, etc. Provider identifiers are randomly generated and do not have any inherent meaning aside from uniquely identifying the same provider across the database.