CCMDB Wiki

LAU Collection Project: Difference between revisions

← Older editNewer edit →
No edit summary
Line 3: Line 3:
== Collection Instructions ==
== Collection Instructions ==
* Population: Lisa has organized charts and will provide collectors with a list
* Population: Lisa has organized charts and will provide collectors with a list
* Use the next [[Pat ID]] in your series, there is no need to manage them separately for this project
* [[Boarding Loc]] - no [[Transfer Ready DtTm tmp entry]] for the LAU collection
* [[Boarding Loc]] - no [[Transfer Ready DtTm tmp entry]] for the LAU collection
* [[Service tmp entry]] - no special instructions
* [[Service tmp entry]] - no special instructions
Line 20: Line 21:
* '''If you open a previously entered record for e.g. HSC while in e.g. VHG setting, some fields (eg. service location) will appear emtpy. The data is still there, but the dropdown doesn’t have it so the dropdown-driven box can’t show it. When you switch back to your usual setting the data will be visible, and it will remain visible in [[centralized_data.mdb]] either way. '''
* '''If you open a previously entered record for e.g. HSC while in e.g. VHG setting, some fields (eg. service location) will appear emtpy. The data is still there, but the dropdown doesn’t have it so the dropdown-driven box can’t show it. When you switch back to your usual setting the data will be visible, and it will remain visible in [[centralized_data.mdb]] either way. '''


==setup==
==Setup==
* [[CCMDB.accdb Change Log 2025#2025-03-06]]
** [[Project Consults data]]
*** added automatic "not entered" record to [[s_tmp table]]
*** added [[Query check Project Consults data]]
** [[ACP Status Collection for LAU]]
*** added options to [[s_tmp table]]
*** added [[query check ACP Status Collection for LAU]]
** [[LAU collection readmission data]]
*** added [[query check_LAU_collection_readmission_data]]
* [[CCMDB.accdb Change Log 2025#2025-03-04]] - Added [[LAU collection readmission data]] and [[Project Consults data]] to [[s_tmp table]]
* [[CCMDB.accdb Change Log 2025#2025-03-04]] - Added [[LAU collection readmission data]] and [[Project Consults data]] to [[s_tmp table]]
* [[CCMDB.accdb Change Log 2025#2025-03-03]] - Added data items to the tables.
* [[CCMDB.accdb Change Log 2025#2025-03-03]] - Added data items to the tables.
Line 75: Line 85:
}}
}}


== possible problems using program = "LAU" ==
== Identifying the project dataset ==
{{Discuss |
* [[Service/Location]] joined with [[s_dispo table]] will have geoloc = "LAU"
I was going to set the service_location entries in for the this project as program{{=}}"LAU". Then Lisa pointed out that this would not show the ADL tab, since it only shows for records where program is "Med". That made me realize that we have a lot of other code such as cross-checks that will also not work right if I set program{{=}}"LAU".
** will have program = "Med" because a bunch of functionality is tied in with Program, so if we made it "LAU" or "Family Med" we would need to make major changes to code and queries
I am concerned that if I set program{{=}}"Med" we will similarly have these records show up mixed in with med data. For collection that will probably be fine since the cross checks etc should mostly be like for med records. But for anything Julie does with the data, this may be an issue.
** Julie is aware that this needs to be considered for the duration of the project collection
Once the collection project is complete we duplicate centralized_data.accdb and delete the LAU records from the master one, an only keep them in a project file. But: will this be a problem during the project? [[User:Ttenbergen|Ttenbergen]] 23:13, 5 March 2025 (CST)
** after collection we can split [[Centralized data.mdb]] so this sample becomes its own recordset, and delete the records from the master db
* Could we switch them to Facility_med, which Julie should be able to filter out, because they would be the 3 sites we don't normally collect? and in the tmp we will know if they are rehab vs LAU based on service, or there is probably alot more behind the scenes that I am missing???  [[User:Lkaita|Lisa Kaita]] 06:40, 6 March 2025 (CST)
*** this will need to be done before the next export to MCHP for sure
**As long as there is a data field which will identify the LAU's whether in tmp or in the service_location field (is this still active?) or serial number (have it started with high digit or with a letter followed by number) , I can filter them out if needed for analysis even if we keep them as Program {{=}}"Med".  The only concern is when we share the database to MCHP. Tina should remove those LAU's from Centralized data and PHI before I give them to MCHP.  --[[User:JMojica|JMojica]] 09:29, 6 March 2025 (CST)
* thanks Julie that makes sense, Tina should be ok then, or can you alter the serial numbers?  I think it is automated right? [[User:Lkaita|Lisa Kaita]] 10:08, 6 March 2025 (CST)
* Will make these program {{=}} med; We can filter them by the specific [[Service/Location]] they will be, eg "VGH LAU". No need to mess with serials, just start with 1 and you should be fine, I don't think any of the laptops should have <200 IDs on them right now. [[User:Ttenbergen|Ttenbergen]] 13:22, 6 March 2025 (CST)
* okay good point I was using add pt with serial so it was a continuation of the serial# on the laptop [[User:Lkaita|Lisa Kaita]] 14:33, 6 March 2025 (CST)
*wait that is the only way to enter someone manually isn't it? can I manually change the serial # in the pop up window, I tried and I can  [[User:Lkaita|Lisa Kaita]] 14:36, 6 March 2025 (CST)}}


== Processing / Analysis ==
== Processing / Analysis ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=LAU_Collection_Project"