PMSI.md

@@ -55,7 +55,22 @@ PMSI data are recorded and stored in DXCARE PMSI.
 
 ### DXCARE PMSI
 
-
+* **Schema**: PENSOINS
+* **Tables**:
+  * C_DIAG_M: Contains ICD10 codes (dictionnary)
+
+|COLUMN                                    |DESCRIPTION                                                                                          |
+|------------------------------------------|-----------------------------------------------------------------------------------------------------|
+|CODECIM                                   | ICD10 Code (i.e C34.9)                                                                              |
+|NI                                        | internal identifier for the code                                                                    |
+
+  * DIAG_CIM10: Contains coded instances (diagnostic effectively coded)
+
+|COLUMN                                    |DESCRIPTION                                                                                          |
+|------------------------------------------|-----------------------------------------------------------------------------------------------------|
+|TYPE_DIAG                                 | Type of the diagnoses (DP, DR, DAS, DAD)|
+|RETRAIT                                   | Is the diagnosis invalid                |
+|NIDIAGREF                                 | Foreign key for C_DIAG_M ==> points to the corresponding ICD10 code|
 
 # Data integration
 ## ETL