Check Accept Loc Park: Difference between revisions

Revision as of 11:42, 22 September 2019

Data Integrity Checks
Summary:	if Previous Location = <your hospital> ER (parked) and Pre-admit Inpatient Institution = "NA / not applicable" then there must be a Accept_Loc_park entry.
Related:	Previous Location, Pre-admit Inpatient Institution, Accept Loc Park
Firmness:	hard check
Timing:
App:	CCMDB.accdb
Coding:	query s_tmp_Accept_Log_Park_prev_no_tmp
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-01-21
Backlogged:	true

Data Integrity Checks
Summary:	if there is an Accept_Loc_park entry, then the Previous Location must be <your hospital> ER (parked) and Pre-admit Inpatient Institution must be "NA / not applicable"
Related:	Previous Location, Pre-admit Inpatient Institution, Accept Loc Park
Firmness:	hard check
Timing:
App:	CCMDB.accdb
Coding:	query s_tmp_Accept_Log_Park_tmp_no_prev
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-01-21
Backlogged:	true

@@ Line 4: / Line 4: @@
 | DIC_firmness = hard check
 | DIC_timing =
-| DIC_app = CCMDB.mdb
+| DIC_app = CCMDB.accdb
 | DIC_coding = query ''s_tmp_Accept_Log_Park_prev_no_tmp''
 | DIC_status = implemented
@@ Line 15: / Line 15: @@
 | DIC_firmness = hard check
 | DIC_timing =
-| DIC_app = CCMDB.mdb
+| DIC_app = CCMDB.accdb
 | DIC_coding = query ''s_tmp_Accept_Log_Park_tmp_no_prev''
 | DIC_status = implemented