Check function preAdmit NE Location: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
m Ttenbergen moved page Check function preAdmit NE Location() to Check function preAdmit NE Location without leaving a redirect
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = [[Pre-admit Inpatient Institution field]] can't be same as [[Service/Location field]]
|DIC_summary=[[Pre-admit Inpatient Institution field]] can't be same as [[Service/Location field]]
| DIC_related_concepts = Service/Location field; Pre-admit Inpatient Institution field
|DIC_related_concepts=Service/Location field; Pre-admit Inpatient Institution field
| DIC_firmness = hard check
|DIC_firmness=hard check
| DIC_timing = complete
|DIC_timing=complete
| DIC_app = CCMDB.mdb
|DIC_coding=function preAdmit_NE_Location()
| DIC_coding = function preAdmit_NE_Location()
|DIC_status=needs review
| DIC_status = implemented
|DIC_LProblem=No
| DIC_implementation_date =  
|DIC_app=CCMDB.mdb
}}
}}
== Failure for [[Service/Location]]s with the splitting letters at the end ==
{{Discuss | who = Tina | question =
* need to make sure concept ICUa is discussed on wiki somewhere.
* This cross check will not detect previous locations that correspond to current locations with a letter at the end. Could probably change it so that this works by using [[s_dispo table]].real_collection field. Would need to update Function ''preAdmit_NE_Location''.}}
** right now it just compares form fields, will need to change it to be a query based check


[[Category:Registry checks]]
[[Category:Registry checks]]

Revision as of 18:19, 30 October 2018

Data Integrity Checks
Summary: Pre-admit Inpatient Institution field can't be same as Service/Location field
Related: Service/Location field, Pre-admit Inpatient Institution field
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: function preAdmit_NE_Location()
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property.
  • Categories:  
  • form:

Failure for Service/Locations with the splitting letters at the end

  • need to make sure concept ICUa is discussed on wiki somewhere.
  • This cross check will not detect previous locations that correspond to current locations with a letter at the end. Could probably change it so that this works by using s_dispo table.real_collection field. Would need to update Function preAdmit_NE_Location.
  • SMW


  • Cargo


  • Categories
    • right now it just compares form fields, will need to change it to be a query based check
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Check_function_preAdmit_NE_Location&oldid=123223"