CCMDB Data Structure: Difference between revisions

m Text replacement - "L PHI" to "L_PHI table"
m Text replacement - "table table" to "table"
Line 4: Line 4:
=== actual data ===
=== actual data ===
* [[L Log table]] links to the following on [[D_ID]]
* [[L Log table]] links to the following on [[D_ID]]
** [[L_PHI table table]]
** [[L_PHI table]]
** [[L Como table]]
** [[L Como table]]
** [[L Dxs table]]
** [[L Dxs table]]
** [[L_Labs_Flowsheet table table table]]
** [[L_Labs_Flowsheet table table]]
** [[L_Pharm_Flowsheet table table]]
** [[L_Pharm_Flowsheet table]]
** [[L TISS Item table]]
** [[L TISS Item table]]
** [[L TmpV2 table]]
** [[L TmpV2 table]]
Line 67: Line 67:
* L_Como.ComorbidCode = S AllDiagnoses.DiagnosisCode
* L_Como.ComorbidCode = S AllDiagnoses.DiagnosisCode


==== [[L_Dxs table table]] ====
==== [[L_Dxs table]] ====
[[L_Como table]] links to [[S AllDiagnoses]] table as  
[[L_Como table]] links to [[S AllDiagnoses]] table as  
* L_Dxs table.DiagnosisCode = S AllDiagnoses.DiagnosisCode
* L_Dxs table.DiagnosisCode = S AllDiagnoses.DiagnosisCode