Centralized data front end.accdb Change Request: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
Line 2: Line 2:


This article contains requested changes for [[Centralized data front end.mdb]]. See [[Centralized data front end.mdb Change Log]] for it's change log.
This article contains requested changes for [[Centralized data front end.mdb]]. See [[Centralized data front end.mdb Change Log]] for it's change log.
===get rid of the diagnosis error list line===
 
===Please fix SPEED===
===Please fix SPEED===
*BOTH EDITS AND NDC QUERIES
*BOTH EDITS AND NDC QUERIES
**Edits: change VBA from executing queries to making tables. [[User:Bcloutier | Brad]]
**Edits: change VBA from executing queries to making tables. [[User:Bcloutier | Brad]]
===Sorting on Patient LIST Form===
===Sorting on Patient LIST Form===
Need to be able to sort by, LN, FN and may a third option if needed.  Only sorting by one column and not grouping it by first name.  This is a problematic for processor to find a same patient in the the patient list form.
Need to be able to sort by, LN, FN and may a third option if needed.  Only sorting by one column and not grouping it by first name.  This is a problematic for processor to find a same patient in the the patient list form.
* discussed with Pagasa, will combine as "<LN>, <FN>"
* discussed with Pagasa, will combine as "<LN>, <FN>"
===D_ID EDITS ===
D_ID cannot edit.
Var 1 and Var 2 no downlist to edit


===S_Locations table===
===S_Locations table===
Editing LOCATION field in centralized front end and drop down list is blank.  The table does not appear to be linked in?[[User:PTorres|PTorres]] 13:50, 2014 February 21 (CST)
Editing LOCATION field in centralized front end and drop down list is blank.  The table does not appear to be linked in?[[User:PTorres|PTorres]] 13:50, 2014 February 21 (CST)
*Trish and Pagasa hacking into layout, field properties. No luck. We were only able toto change it so we see Hosp and not location. Dont' understand what the TableQuery is doing here really.[[User:TOstryzniuk|Trish Ostryzniuk]] 14:51, 2014 February 21 (CST)
*Trish and Pagasa hacking into layout, field properties. No luck. We were only able toto change it so we see Hosp and not location. Dont' understand what the TableQuery is doing here really.[[User:TOstryzniuk|Trish Ostryzniuk]] 14:51, 2014 February 21 (CST)
=== ensure s_alldiagnoses part of re-linking ===
#* S_allDiagnosis is not hooked up to centralized front end.  Have to use link manager to link it in to front end.-[[User:TOstryzniuk|Trish Ostryzniuk]] 13:42, 2014 February 21 (CST)


=== HAP ===
=== HAP ===
#Please ADD the abbreviation HAP to code 3800 please, otherwise hard to search.[[User:PTorres|PTorres]] 15:47, 2014 February 20 (CST)
#Please ADD the abbreviation HAP to code 3800 please, otherwise hard to search.[[User:PTorres|PTorres]] 15:47, 2014 February 20 (CST)
=== add dx codes to dx lister ===
#Diagnosis is hard to edit.
#*Hard to find the codes.-[[User:PTorres|PTorres]] 16:00, 2014 February 20 (CST)
=== ensure s_alldiagnoses part of re-linking ===
#* S_allDiagnosis is not hooked up to centralized front end.  Have to use link manager to link it in to front end.-[[User:TOstryzniuk|Trish Ostryzniuk]] 13:42, 2014 February 21 (CST)


=== generate unique identifiers for child tables ===
=== generate unique identifiers for child tables ===

Revision as of 18:11, 24 February 2014

see the Development Documentation Category for other development logs

This article contains requested changes for Centralized data front end.mdb. See Centralized data front end.mdb Change Log for it's change log.

Please fix SPEED

  • BOTH EDITS AND NDC QUERIES
    • Edits: change VBA from executing queries to making tables. Brad

Sorting on Patient LIST Form

Need to be able to sort by, LN, FN and may a third option if needed. Only sorting by one column and not grouping it by first name. This is a problematic for processor to find a same patient in the the patient list form.

  • discussed with Pagasa, will combine as "<LN>, <FN>"

S_Locations table

Editing LOCATION field in centralized front end and drop down list is blank. The table does not appear to be linked in?PTorres 13:50, 2014 February 21 (CST)

  • Trish and Pagasa hacking into layout, field properties. No luck. We were only able toto change it so we see Hosp and not location. Dont' understand what the TableQuery is doing here really.Trish Ostryzniuk 14:51, 2014 February 21 (CST)

ensure s_alldiagnoses part of re-linking

    • S_allDiagnosis is not hooked up to centralized front end. Have to use link manager to link it in to front end.-Trish Ostryzniuk 13:42, 2014 February 21 (CST)

HAP

  1. Please ADD the abbreviation HAP to code 3800 please, otherwise hard to search.PTorres 15:47, 2014 February 20 (CST)

generate unique identifiers for child tables

adding records fails becaus the *_id is not autogenerated.

      • Editing DX: when adding complication code, example, HAP, would go into registry screen but would not allow to save, hanging program and could not close. Getting some Index or primary key cannot contain a NULL value, something or other message. Email sent to you Feb 20 with picture. Brad was here and may be able to explain.

other spot that might contain requirements...

TMSX MedTMS to Centralized go-live

SAS Views

After go-live

Email Generator

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Request&oldid=37046"