Query check transfer DtTm during admission: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Ttenbergen moved page Query check transfer ready tmp GT Dispo to Query check check transfer DtTm during admission without leaving a redirect: combined several)
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = [[Transfer Ready DtTm tmp entry]] should never be later than [[Dispo DtTm]]
| DIC_summary = [[Transfer Ready DtTm tmp entry]] should never be earlier than first [[Boarding Loc]] dttm or later than [[Dispo DtTm]], and if the [[Transfer Ready DtTm tmp entry]] has no dttm its checbox has to be checked
| DIC_related_concepts = Transfer Ready DtTm tmp entry; Dispo DtTm field
| DIC_related_concepts = Transfer Ready DtTm tmp entry; Dispo DtTm field
| DIC_firmness = hard
| DIC_firmness = hard
| DIC_timing = incomplete
| DIC_timing = incomplete
| DIC_app = CCMDB.accdb
| DIC_app = CCMDB.accdb
| DIC_coding = query ''check_transfer_ready_tmp_GT_Dispo''
| DIC_coding = query ''check_transfer_DtTm_during_admission''
| DIC_status = ready to implement
| DIC_status = ready to implement
| DIC_implementation_date =  
| DIC_implementation_date = 2021-01-28
}}
}}
== Log ==
* 2021-01-28 implemented


== Related articles ==
== Related articles ==

Revision as of 19:35, 2021 January 28

Data Integrity Checks
Summary: Transfer Ready DtTm tmp entry should never be earlier than first Boarding Loc dttm or later than Dispo DtTm, and if the Transfer Ready DtTm tmp entry has no dttm its checbox has to be checked
Related: Transfer Ready DtTm tmp entry, Dispo DtTm field
Firmness: hard
Timing: incomplete
App: CCMDB.accdb
Coding: query check_transfer_DtTm_during_admission
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date: 2021-01-28
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

Log

  • 2021-01-28 implemented

Related articles

Related articles: