S PatientFollow distribution table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Data Structure) |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 14: | Line 14: | ||
|| '''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]] | ||
|} | |} | ||
Revision as of 15:53, 2022 April 19
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 |
hosp | text | 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 Admit DtTm |
EndDtTm | date | end of assignment, relative to Admit DtTm |