Comprehensive logical model representing the Electronic Health Record (EHR) data structure for the EDSH (Entrepôt de Données de Santé Hospitalisé) core variables.

This model consolidates all healthcare dimensions into a unified structure supporting:

• Patient demographics and identity management
• Healthcare encounters and administrative data
• Clinical diagnostics and procedures
• Laboratory results and biological examinations
• Medication exposures and prescriptions
• Clinical care measurements and vital signs
• Lifestyle and behavioral factors

The model is optimized for healthcare data interoperability, research, and clinical analytics while maintaining alignment with FHIR standards and French healthcare requirements.

bundle logical id

Patient information consolidating identity data and geographic information. Based on FHIR Questionnaire linkIds: 2958000860428 (Patient Identity) and 3816475533472 (Geocoding). Maps to SQL table: patient

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique patient identifier (patient_id)

Patient last name - linkId: 8605698058770

Patient first name - linkId: 6214879623503

Numéro inscription au Répertoire (linkId: 5711960356160)

Identité Nationale de Santé (linkId: 3764723550987)

Date of birth (date_naissance) - linkId: 5036133558154

Gender consolidated from PMSI - linkId: 3894630481120

Date of death (date_deces) - linkId: 5633552097315

Source of death date (source_deces) - linkId: 9098810065693

Twin ranking (rang_gemellaire) - linkId: 6931296968515

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Depuis la table patient_addresse

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique identifier

Foreign key to patient (patient_id)

Latitude - linkId: 3709843054556

Longitude - linkId: 7651448032665

INSEE IRIS code (code_iris)

INSEE IRIS label (libelle_iris)

Geographic code of residence (code_geographique_residence)

Geographic label of residence (libelle_geographique_residence)

Date de recueil

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Healthcare encounters and administrative data from PMSI. Central linking entity for all clinical data. Based on linkId: 2825244231605. Maps to SQL table: donnees_pmsi

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique PMSI identifier (pmsi_id)

Foreign key to patient (patient_id)

Mode de sortie (mode_sortie)

Au cas ou la date de naissance n'est pas connue

Date début séjour (date_debut_sejour)

Date fin séjour (date_fin_sejour)

Mode d'entrée (mode_entree)

Établissement

Unité fonctionnelle (unite_fonctionnelle)

Service

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Diagnostic codes and information using ICD-10/CIM-10 classifications. Based on linkId: 9391816419630. Maps to SQL table: diagnostic

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique diagnostic identifier (diagnostic_id)

Foreign key to patient (patient_id)

Foreign key to donnees_pmsi (pmsi_id)

Code diagnostic ICD-10/CIM-10 (code_diagnostic)

Type de diagnostic (type_diagnostic)

Libellé du diagnostic (libelle_diagnostic)

Date recueil (date_recueil)

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Medical procedures and acts using CCAM classifications. Based on linkId: 591926901726. Maps to SQL table: actes

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique act identifier (acte_id)

Foreign key to patient (patient_id)

Foreign key to donnees_pmsi (pmsi_id)

Code acte CCAM (code_acte)

Libellé de l'acte (libelle_acte)

Date acte (date_acte)

Exécutant

Date recueil (date_recueil)

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Consolidated laboratory test results for all biological examinations. Based on linkId: 7702944131447. Maps to SQL table: biologie

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique biology identifier (biologie_id)

Foreign key to patient (patient_id)

Code LOINC (code_loinc)

Libellé du test (libelle_test)

Type examen (type_examen)

Valeur numérique

Unité

Valeur texte (valeur_texte)

Date prélèvement (date_prelevement)

Statut validation (statut_validation)

Borne inférieure normale (borne_inf_normale)

Borne supérieure normale (borne_sup_normale)

Laboratoire

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Prescription data with ATC coding. Based on linkId: 817801935685. Maps to SQL table: prescription

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique prescription identifier (prescription_id)

Foreign key to patient (patient_id)

Dénomination

Codé en ATC

Codé avec un Standard Term

Prescripteur

Date prescription (date_prescription)

Date début (date_debut)

Date fin (date_fin)

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Detailed dosing information. Based on linkId: 6348237104421. Maps to SQL table: posologie

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique posology identifier (posologie_id)

Foreign key to prescription (prescription_id)

Nombre prises par jour (nombre_prises_par_jour)

à correler avec l'unité

Si possible en UCUM, sinon en Standard terms

Date de la prise si prise 'instantanée'

DateHeure de fin de prise

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Administration Maps to SQL table: administration

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique administration identifier (administration_id)

Foreign key to patient (patient_id)

Foreign key to prescription (prescription_id)

DCI si possible

codé en ATC

Codé avec un Standard Term

Quantité administrée (quantite_administree)

codé en UCUM, subsidiairement en Standard Term

Date heure début (date_heure_debut)

Date heure fin (date_heure_fin)

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Clinical care measurements and observations. Based on linkId: 305831246173. Maps to SQL table: dossier_soin

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique care identifier (soin_id)

Foreign key to patient (patient_id)

codé avec LOINC

Libellé métier de l'observation

si quantitative

idéalement en UCUM

si qualitative

si textuelle

Date de mesure

Unité soins (unite_soins)

Professionnel

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Consolidated lifestyle information. Based on linkId: 1693164086678. Maps to SQL table: style_vie

Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.

May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions.

Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).

There can be no stigma associated with the use of extensions by any application, project, or standard - regardless of the institution or jurisdiction that uses or defines the extensions. The use of extensions is what allows the FHIR specification to retain a core level of simplicity for everyone.

Modifier extensions allow for extensions that cannot be safely ignored to be clearly distinguished from the vast majority of extensions which can be safely ignored. This promotes interoperability by eliminating the need for implementers to prohibit the presence of extensions. For further information, see the definition of modifier extensions.

Unique lifestyle identifier (style_vie_id)

Foreign key to patient (patient_id)

Consommation tabac (consommation_tabac)

Consommation alcool (consommation_alcool)

Consommation autres drogues (consommation_autres_drogues)

Activité physique (activite_physique)

Date recueil (date_recueil)

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Comprehensive logical model representing the Electronic Health Record (EHR) data structure for the EDSH (Entrepôt de Données de Santé Hospitalisé) core variables.

This model consolidates all healthcare dimensions into a unified structure supporting:

• Patient demographics and identity management
• Healthcare encounters and administrative data
• Clinical diagnostics and procedures
• Laboratory results and biological examinations
• Medication exposures and prescriptions
• Clinical care measurements and vital signs
• Lifestyle and behavioral factors

The model is optimized for healthcare data interoperability, research, and clinical analytics while maintaining alignment with FHIR standards and French healthcare requirements.

bundle logical id

Patient information consolidating identity data and geographic information. Based on FHIR Questionnaire linkIds: 2958000860428 (Patient Identity) and 3816475533472 (Geocoding). Maps to SQL table: patient

Unique patient identifier (patient_id)

Patient last name - linkId: 8605698058770

Patient first name - linkId: 6214879623503

Numéro inscription au Répertoire (linkId: 5711960356160)

Identité Nationale de Santé (linkId: 3764723550987)

Date of birth (date_naissance) - linkId: 5036133558154

Gender consolidated from PMSI - linkId: 3894630481120

Date of death (date_deces) - linkId: 5633552097315

Source of death date (source_deces) - linkId: 9098810065693

Twin ranking (rang_gemellaire) - linkId: 6931296968515

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Depuis la table patient_addresse

Unique identifier

Foreign key to patient (patient_id)

Latitude - linkId: 3709843054556

Longitude - linkId: 7651448032665

INSEE IRIS code (code_iris)

INSEE IRIS label (libelle_iris)

Geographic code of residence (code_geographique_residence)

Geographic label of residence (libelle_geographique_residence)

Date de recueil

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Healthcare encounters and administrative data from PMSI. Central linking entity for all clinical data. Based on linkId: 2825244231605. Maps to SQL table: donnees_pmsi

Unique PMSI identifier (pmsi_id)

Foreign key to patient (patient_id)

Mode de sortie (mode_sortie)

Au cas ou la date de naissance n'est pas connue

Date début séjour (date_debut_sejour)

Date fin séjour (date_fin_sejour)

Mode d'entrée (mode_entree)

Établissement

Unité fonctionnelle (unite_fonctionnelle)

Service

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Diagnostic codes and information using ICD-10/CIM-10 classifications. Based on linkId: 9391816419630. Maps to SQL table: diagnostic

Unique diagnostic identifier (diagnostic_id)

Foreign key to patient (patient_id)

Foreign key to donnees_pmsi (pmsi_id)

Code diagnostic ICD-10/CIM-10 (code_diagnostic)

Type de diagnostic (type_diagnostic)

Libellé du diagnostic (libelle_diagnostic)

Date recueil (date_recueil)

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Medical procedures and acts using CCAM classifications. Based on linkId: 591926901726. Maps to SQL table: actes

Unique act identifier (acte_id)

Foreign key to patient (patient_id)

Foreign key to donnees_pmsi (pmsi_id)

Code acte CCAM (code_acte)

Libellé de l'acte (libelle_acte)

Date acte (date_acte)

Exécutant

Date recueil (date_recueil)

Record creation timestamp (created_at)

Record update timestamp (updated_at)

Consolidated laboratory test results for all biological examinations. Based on linkId: 7702944131447. Maps to SQL table: biologie

Unique biology identifier (biologie_id)

Foreign key to patient (patient_id)

Code LOINC (code_loinc)

Libellé du test (libelle_test)

Type examen (type_examen)

Valeur numérique

Unité

Valeur texte (valeur_texte)

Date prélèvement (date_prelevement)

Statut validation (statut_validation)

Borne inférieure normale (borne_inf_normale)