hospital_instance
Description¶
This table contains healthcare centers or institutions. Each record represents a unique instance, serving as the top-level entity in the organizational hierarchy, with metadata for identification and linkage to downstream entities.
Columns¶
| Field | User Guide | ETL Conventions | Datatype | Required | Primary Key | Foreign Key | FK Table |
|---|---|---|---|---|---|---|---|
| id | Unique identifier | bigint(64) | Yes | Yes | No | ||
| code | Code of the instance | Should match instance_xxx_id in clinical tables. | varchar(30) | Yes | No | No | |
| name | Name of the instance | varchar(400) | Yes | No | No | ||
| upload_id | Identifier of the pipeline integration run, used to differentiate each batch of integrated data. | Defined at the start of the pipeline as datetime.now().strftime("%Y%m%d%H%M%S"). For example a batch integrated on 15/09/2025 at 00:00:00 has upload_id = 20250915000000. |
bigint(64) | No | No | No | |
| update_date | Date and time of the record’s last update. | timestamptz | No | No | No |