Difference between revisions of "SL EPR Logs table"

From CCMDB Wiki
Jump to navigationJump to search
m (Ttenbergen moved page SL EPR Logs to SL EPR Logs table without leaving a redirect)
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:
  
 
== Data Structure ==
 
== Data Structure ==
 +
All fields are text fields to minimize problems during import.
 
{| class="wikitable sortable"  
 
{| class="wikitable sortable"  
 
|-
 
|-
Line 8: Line 9:
 
!| description
 
!| description
 
|-
 
|-
|| '''Name''' || Text(255) || Full Patient Name
+
|| '''PtName''' || Text(255) || Full Patient Name
 
|-
 
|-
|| '''Chart''' || Text(15) || [[Chart]]
+
|| '''Chart''' || Text(255) || [[Chart]]
 
|-
 
|-
|| '''DOB''' || date || [[DOB]]
+
|| '''DOB''' || Text(255) || [[DOB]]
 
|-
 
|-
|| '''Sex''' || Text(10) || [[Sex]]
+
|| '''Sex''' || Text(255) || [[Sex]]
 
|-
 
|-
|| '''Location''' || Text(10) || Location as per EPR output; this may or may not be  a place where we collect, and even if it is it may only be a patient movement
+
|| '''Location''' || Text(255) || Location as per EPR output; this may or may not be  a place where we collect, and even if it is it may only be a patient movement
 
|-
 
|-
|| '''Service''' || Text(10) || Service in charge of patient
+
|| '''Service''' || Text(255) || Service in charge of patient
 
|-
 
|-
|| '''Attending''' || Text(10) || Attending in charge of patient
+
|| '''Attending''' || Text(255) || Attending in charge of patient
 
|-
 
|-
|| '''FromLoc''' || Text(10) || Where patient came from; may be empty depending on source report
+
|| '''FromLoc''' || Text(255) || Where patient came from; may be empty depending on source report
 
|-
 
|-
|| '''AdmDate''' || Text(10) || When the patient arrived; may be empty depending on source report
+
|| '''AdmDtTm''' || Text(255) || When the patient arrived; may be empty depending on source report
 
|-
 
|-
|| '''DisDate''' || Text(10) || When the patient left; may be empty depending on source report
+
|| '''DisDtTm''' || Text(255) || When the patient left; may be empty depending on source report
 
|-
 
|-
|| '''ToLoc''' || Text(10) || Where the patient went; may be empty depending on source report
+
|| '''ToLoc''' || Text(255) || Where the patient went; may be empty depending on source report
 +
|-
 +
|| '''Garbage<number> || Text(255) || Several fields to store unneeded data to simplify cut-and-paste
 +
 
 
|}
 
|}
  

Latest revision as of 11:50, 2019 October 9

The sL_EPR_Logs table in CCMDB.accdb is the place where EPR Logs get stored temporarily to assign newly arrived patients as per PatientFollow Project. The table is strictly temporary and gets replaced with each new import, and each time CCMDB.mdb is updated.

Data Structure

All fields are text fields to minimize problems during import.

field type description
PtName Text(255) Full Patient Name
Chart Text(255) Chart
DOB Text(255) DOB
Sex Text(255) Sex
Location Text(255) Location as per EPR output; this may or may not be a place where we collect, and even if it is it may only be a patient movement
Service Text(255) Service in charge of patient
Attending Text(255) Attending in charge of patient
FromLoc Text(255) Where patient came from; may be empty depending on source report
AdmDtTm Text(255) When the patient arrived; may be empty depending on source report
DisDtTm Text(255) When the patient left; may be empty depending on source report
ToLoc Text(255) Where the patient went; may be empty depending on source report
Garbage<number> Text(255) Several fields to store unneeded data to simplify cut-and-paste

Related articles

Related articles: