S PatientFollow distribution table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (Created page with "The '''{{PAGENAME}}''' in CCMDB.accdb contains the data used to assign patients for the PatientFollow Project. == Data Structure == {| class="wikitable sortable" |-...") |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
The ''' | The '''s_PatientFollow_distribution''' in [[CCMDB.accdb]] contains the data used to assign patients for the [[PatientFollow Project]]. | ||
== Data Structure == | == Data Structure == | ||
Revision as of 10:53, 2019 October 9
The s_PatientFollow_distribution in CCMDB.accdb contains the data used to assign patients for the PatientFollow Project.
Data Structure
| field | type | description |
|---|---|---|
| LastTwoDigits | integer | last two digits of chart |
| Laptop | Long Integer | laptop that pt with those last two digits in chart would be collected on (links to s_laptops table) |
| StartDtTm | date | start of assignment, relative to Arrive DtTm |
| EndDtTm | date | end of assignment, relative to Arrive DtTm |