User:Ttenbergen/questions for tina: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (→To dos) |
||
(24 intermediate revisions by the same user not shown) | |||
Line 13: | Line 13: | ||
|order by=Discussions.question | |order by=Discussions.question | ||
|limit=1000 | |limit=1000 | ||
|default=No questions found | |default=No questions found | ||
|format=dynamic table | |format=dynamic table | ||
|rows per page= | |hidden fields=ModDate | ||
|column widths=10%,20%,80% | |||
|rows per page=200 | |||
}} | }} | ||
Line 23: | Line 24: | ||
tables=ToDo, _pageData | tables=ToDo, _pageData | ||
|join on=ToDo._pageName=_pageData._pageName | |join on=ToDo._pageName=_pageData._pageName | ||
|fields=ToDo._pageName=wiki page, question | |fields=ToDo._pageName=wiki page,question,todo_action=action | ||
|where= who = "Tina" | |where=who="Tina" | ||
|order by=question | |||
|limit=1000 | |limit=1000 | ||
|rows per page=200 | |rows per page=200 | ||
|default= | |default=No to do items found | ||
|format=table | |format=dynamic table | ||
}} | }} |
Latest revision as of 11:38, 2022 August 10
Questions
Toggle columns: ModDate
edit | page | question | ModDate |
---|---|---|---|
edit | page | question | ModDate |
edit | DSM Lab Extract |
| 2023-07-05 5:36:20 PM |
edit | Query NDC Bad Postal Code |
| 2023-05-04 5:03:24 PM |
edit | High-Obs Wards | Tina to add. | 2022-10-20 9:32:54 PM |
To dos
wiki page | question | action |
---|---|---|
wiki page | question | action |
R Filter Field | _after
| 2023-07-13 |
Blood Product Data | _after
| 2022-06-22 |
Direct Data Access for RIS/PACS | _after
| 2022-06-22 |
Query check long transfer delay | _after
| 2022-08-04 |
Arrive DtTm field | _after
| 2023-05-04 |
Accept DtTm field | _ccmdb_dev
| 2023-05-04 |
R Filter Field | _CFE_Data_reconsolidate
| 2023-07-13 |
Hospitalization ID | _CFE_Data_reconsolidate
| 2022-09-25 |
Cross Check Engine | _dev_CCMDB
| 2022-04-27 |
S Priorities table | _dev_CCMDB
| 2023-05-17 |
Problems related to event timing of data consistency checks | _dev_ccmdb
| 2022-04-13 |
ClientGUID field | _dev_ccmdb
| 2022-09-25 |
Centralized data.mdb Requested Changes | _dev_centralized_data
| 2023-05-09 |
Processing errors in patient data | _dev_CFE
Automate the populating of notes so button just does it.
| |
Centralized data front end.accdb Change Request | _dev_CFE
| |
Centralized data front end.accdb Change Request | _dev_CFE
| |
CFE Inline Integrity Checks | _dev_CFE
| 2022-09-06 |
S dispo Collector Location table | _Dev_CFE mgmt queries
| |
Query Mgmt Collector Admission Count | _Dev_CFE mgmt queries
| |
DC Treatment | _dev_CFE_Data
| 2023-05-04 |
Location metadata storage | _locationData
| 2022-02-09 |
Collection location documentation | _locationData
| |
Location metadata storage | _locationData
| 2022-06-22 |
Query maintenance s tmp deletables | _regular * this should be done regularly, maybe every 6 months | 2023-02-10 |
Template:Location dropdown cleanup | _regular
| 2022-03-05 |
S dispo table | _wiki housekeeping
| 2022-02-10 |
S ICD10 Chapter block pattern table | _wiki housekeeping
| |
Collection location documentation | _wiki_housekeeping
| 2021-09-01 |
LOS | _wiki_housekeeping
| 2022-03-01 |
Query check long transfer delay |
| |
ClientGUID field |
| 2022-06-30 |
High-Obs Wards |
| 2022-10-19 |
HSC-GA7S |
| |
APACHE Acute Diagnoses |
| |
HSC-GA7S |
| |
Transfusion of plasma products |
| 2023-09-30 |
HSC-GA7S |
| |
S Pathogens table |
| 2023-05-17 |
S AllDiagnoses table |
| 2023-05-17 |
"cannot open any more tables" in Access |
| 2022-12-07 |
Eliminating distinction between different ward types | CTU vs NTU - we decided at task that we wanted to eliminate the distinction. A lot of things are part of their network of information, so we will need to work out the details above before we can move ahead.
| |
APACHE Acute Diagnoses | just Tina's working notes:
Scenarios:
AND any admit procedure is EITHER: (a) of the form 1.AA.xx, 1.AB.xx, 1.AC.xx, 1.AE.xx, 1.AD.xx, 1.AG.xx, 1.AJ.xx, 1.AK.xx, 1.AN.xx, 1.AP.xx
or (b) 2.AA.71.yy, 2.AB.71.yy, 2.AC.71.yy, 2.AE.71.yy, 2.AD.71.yy, 2.AG.71.yy, 2.AJ.71.yy, 2.AK.71.yy, 2.AN.71.yy, 2.AP.71.yy
| |
STB-L2HA | locationData
| 2022-06-28 |
S LocationData table | locationData
---
| 2022-02-10 |
Query NDC Bad Postal Code | PWC
| 2022-07-15 |
Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb | The query to re-populate this one is now incomplete; don't delete it, just review the output of the re-generating query against this one until fixed; deleting and re-importing breaks TISS and other entry functionatlity. | |
EPR Analytics | z
| 2022-01-01 |
Questioning data back to collectors | z
This process is more automated and would need to be validated before we could implement. It would be the least work for all involved, though, I think. We keep discussing this, talked about it again today. Ttenbergen 17:44, 2016 December 1 (CST) |