S PatientFollow distribution table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The '''s_PatientFollow_distribution''' in [[CCMDB.accdb]] contains the data used to assign patients for the [[PatientFollow Project]]. | {{DISPLAYTITLE:s_PatientFollow_distribution table}}The '''s_PatientFollow_distribution''' in [[CCMDB.accdb]] contains the data used to assign patients for the [[PatientFollow Project]]. | ||
== Data Structure == | == Data Structure == | ||
| Line 9: | Line 9: | ||
|- | |- | ||
|| '''LastTwoDigits''' || integer || last two digits of [[chart]] | || '''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]]) | || '''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 [[ | || '''StartDtTm''' || date || start of assignment, relative to [[Admit DtTm]] | ||
|- | |- | ||
|| '''EndDtTm''' || date || end of assignment, relative to [[ | || '''EndDtTm''' || date || end of assignment, relative to [[Admit DtTm]] | ||
|} | |} | ||
| Line 22: | Line 20: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category: PatientFollow Project]] | [[Category:PatientFollow Project]] | ||
Latest revision as of 11:00, 30 July 2025
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 Admit DtTm |
| EndDtTm | date | end of assignment, relative to Admit DtTm |