Check function preAdmit NE Location: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 12: Line 12:
{{Discuss | who = Tina | question =  
{{Discuss | who = Tina | question =  
* need to make sure concept ICUa is discussed on wiki somewhere.  
* 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''.}}
* 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
** 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:20, 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.
    • right now it just compares form fields, will need to change it to be a query based check
  • SMW


  • Cargo


  • Categories