Service/Location field
| Data Element (edit) | |
| Field Name: | Service_Location |
| CCMDB Label: | Service Location |
| CCMDB tab: | Dispo |
| Table: | L_Log table |
| Data type: | number |
| Length: | long integer |
| Program: | Med and CC |
| Created/Raw: | Raw |
| Start Date: | 2016-07-01 |
| End Date: | 2300-01-01 |
| Sort Index: | 40 |
| Data Dependencies(Reports/Indicators/Data Elements): | |
Collection location a patient is admitted to.
Collection Instruction
Enter the physical location of the patient.
If you know the location exactly, you can type it. otherwise use the "?" button. The dropdown is limited to locations where a laptop collects.
Only service locations allowed to be collected on this laptop based on its Settings (CCMBD.mdb) will be listed.
Patients in bed borrow locations on other wards or units are coded as the home unit. Collectors can use "record" field for tracking actual location.
Minimal Data Set
This entry is part of the Minimal Data Set. Special collection instructions apply, see that page for more info.
Adding a new service/location entry
- add to s_dispo table
- add to s_locations_allowed_collection table
- consider all checks in Category:Site/Location check to see if they need to be modified to work right for the new location.
Data Use / Purpose
See Site and Location table for possible entries.
Use to determine the location or services the patient went during a hospital stay.
Use to categorize/stratify the distribution of patients across hospitals and wards/units when reporting summary statistics.
Integrity checks
Data Integrity Checks (automatic list)
| App | Status | |
|---|---|---|
| Query check minimal data set incomplete | CCMDB.accdb | implemented |
| Check function location NE dispo | CCMDB.accdb | implemented |
| Check function previous NE Location | CCMDB.accdb | implemented |
| Check function preAdmit NE Location | CCMDB.accdb | implemented |
| Query s tmp ABO TEE checks | CCMDB.accdb | implemented |
| Query send check centralized is owner | CCMDB.accdb | implemented |
| Query s tmp EuroSCORE II checks | CCMDB.accdb | implemented |
| Query Check_from_ED_and_prev_location_same_site | CCMDB.accdb | ready to implement |
| Query s tmp Boarding Loc no borrow but entry | CCMDB.accdb | retired |
| PL SameCHART Site Diff PHIN | Centralized data front end.accdb | implemented |
| Link suspect mismatch pre inpt ours incomplete query | Centralized data front end.accdb | implemented |
| Link_suspect_not_same_visitAdmitDtTm query | Centralized data front end.accdb | implemented |
| Reconnect check orphans query | Centralized data front end.accdb | implemented |
| Link_suspect_visitAdmitDtTm_mult_to-from-home query | Centralized data front end.accdb | ready to implement |
Reports
To be filled in
Implementation
The field is populated with options from the s_dispo table.
Legacy
This field is part of the 2016 Time and Place changes and corresponds to to the old Location field, resp L_Log.R_Location.