TISS28.accdb Change Log: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb" |
||
| (20 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
This is the log of changes for [[TISS28. | {{LegacyContent | ||
|explanation=TISS is now collected as part of CCI, so collected in [[CCMDB.accdb]] and stored in [[CFE]] / [[Centralized_data.accdb]]. | |||
|successor=[[Change log]] | |||
|content= | |||
This is the log of changes for [[TISS28.accdb]]. | |||
== v2020-03-05 == | |||
* updated a bunch of things for [[Update of D ID to include a laptop identifier]] | |||
** specifically, how D_ID is made in query ''qryExportFix_Add_D_ID'' | |||
== v2019-02-11 == | |||
* updated [[Query TISS Errors missing days]] to '''include''' vetted | |||
* updated [[Query TISS Errors D ID not in CFE]] - changed to ckeck last 90 days now that Pagasa has explained that TISS collection might be far behind. | |||
* updated [[Query TISS Errors NrTISSDays NE LOS]] - changed to only look at discharges within the last 90 days, instead of admits since 2013 | |||
* updated [[Query TISS Errors TISS date out of admission]] - changed to only look at discharges within the last 90 days | |||
* updated [[Query TISS Errors duplicate Items]] - to check the last 90 days of TISS items rather than all since 2016 | |||
== v2019-01-10 == | |||
* changed reconnector to draw from "frozen" rather than live data | |||
== v2017-11-01 == | |||
* query ''TISS_Errors_D_ID_not_in_CFE'' for D_ID not in CFE Ttenbergen 16:16, 2017 November 1 (CDT) | |||
== v2017-06-21 == | == v2017-06-21 == | ||
| Line 28: | Line 51: | ||
** table ''tblPatientDateViewSAS'' | ** table ''tblPatientDateViewSAS'' | ||
** table ''TISS28 PROD 2012-12-11_ImportErrors'' | ** table ''TISS28 PROD 2012-12-11_ImportErrors'' | ||
** table ''tblTISSReference'', see [[ | ** table ''tblTISSReference'', see [[TISS Item List]] instead | ||
* changing processing from separate fields to D_ID: | * changing processing from separate fields to D_ID: | ||
| Line 37: | Line 60: | ||
* impacts: | * impacts: | ||
** query ''qryPatientDateView2'' - changed to use service_location | ** query ''qryPatientDateView2'' - changed to use service_location | ||
** linked in [[s_dispo table]] from c:\ccmdb_program\ccmdb. | ** linked in [[s_dispo table]] from c:\ccmdb_program\ccmdb.accdb | ||
** updated table ''tblTISPatient'' to have a D_ID field | ** updated table ''tblTISPatient'' to have a D_ID field | ||
** updated ''Function LoadTISSPatientData'' to update D_ID as well | ** updated ''Function LoadTISSPatientData'' to update D_ID as well | ||
* Replacing Julie's SAS: | * Replacing Julie's SAS: | ||
** | ** [[Query TISS Errors NrTISSDays NE LOS]] | ||
** TISS_Errors_TISS_date_out_of_admission | ** [[Query TISS_Errors_TISS_date_out_of_admission]] | ||
==Version 2013-02-28== | ==Version 2013-02-28== | ||
| Line 80: | Line 103: | ||
* Looking up a TISS form image file name (from the corresponding SERIAL number) | * Looking up a TISS form image file name (from the corresponding SERIAL number) | ||
[[Category:TISS28 | }} | ||
[[Category:TISS28.accdb]] | |||
[[Category:Development Documentation]] | [[Category:Development Documentation]] | ||