mapping table medications_new - Fuenfgeld/DMA2022DataProjectB GitHub Wiki
Dimensionstabelle medications_new
| Spaltenname | Datentyp | Eigenschaften | Quelldatenbank | Quelltabelle | Quellspalte |
|---|---|---|---|---|---|
| MEDICATIONS_ID | INT | PRIMARY KEY | Datenbanktabellen | AUTOINCREMENT | -- |
| START | NVARCHAR(20) | NOT NULL | Datenbanktabellen | medications | START |
| STOP | nvarchar(20) | DEFAULT NULL | Datenbanktabellen | medications | STOP |
| PATIENT | NVARCHAR(36) | FOREIGN KEY, NOT NULL | Datenbanktabellen | patients_new | Id |
| PAYER | NVARCHAR(50) | NOT NULL | Datenbanktabellen | medications | PAYER |
| ENCOUNTER | NVARCHAR(50) | NOT NULL | Datenbanktabellen | medications | ENCOUNTER |
| CODE | INT | NOT NULL | Datenbanktabellen | medications | CODE |
| DESCRIPTION | NVARCHAR(256) | NOT NULL | Datenbanktabellen | medications | DESCRIPTION |
| BASE_COST | FLOAT | NOT NULL | Datenbanktabellen | medications | BASE_COST |
| PAYER_COVERAGE | FLOAT | NOT NULL | Datenbanktabellen | medications | PAYER_COVERAGE |
| DISPENSES | INT | NOT NULL | Datenbanktabellen | medications | DISPENSES |
| TOTALCOST | FLOAT | NOT NULL | Datenbanktabellen | medications | TOTALCOST |
| REASONCODE | FLOAT | NOT NULL | Datenbanktabellen | medications | REASONCODE |
| REASONDESCRIPTION | NVARCHAR(50) | NOT NULL | Datenbanktabellen | medications | REASONDESCRIPTION |