Query s tmp Boarding Loc date item: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check |DIC_summary=Validates entries for Borrow Loc |DIC_related_concepts=Boarding Loc, Service/Location, Arrive DtTm, Dispo DtTm |DIC_fir...") |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=Validates entries for [[ | |DIC_summary=Validates entries for [[Boarding Loc]] | ||
|DIC_related_concepts=[[Boarding Loc]], [[Service/Location]], [[Arrive DtTm]], [[Dispo DtTm]] | |DIC_related_concepts=[[Boarding Loc]], [[Service/Location]], [[Arrive DtTm]], [[Dispo DtTm]] | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding= | |||
|DIC_implementation_date=2020/06/03 | |||
|DIC_status=implemented | |DIC_status=implemented | ||
|DIC_LProblem= | |||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |||
}} | }} | ||
* Date_var and Time_var must not be before [[Arrive DtTm]] | * Date_var and Time_var must not be before [[Arrive DtTm]] | ||
* Date_var and Time_var must not be on or after Dispo DtTm | * Date_var and Time_var must not be on or after Dispo DtTm |
Revision as of 15:57, 2020 June 3
Data Integrity Checks | |
Summary: | Validates entries for Boarding Loc |
Related: | [[Boarding Loc, Service/Location, Arrive DtTm, Dispo DtTm]] |
Firmness: | hard check |
Timing: | complete |
App: | CCMDB.accdb |
Coding: | |
Uses L Problem table: | not relevant for this app |
Status: | implemented |
Implementation Date: | 2020/06/03 |
Backlogged: | No |
- Date_var and Time_var must not be before Arrive DtTm
- Date_var and Time_var must not be on or after Dispo DtTm
- Item should not be the same as the Service/Location for Medicine profile
- When having a boarding location, both date and time must be present. Should not have missing time.
Related articles
Related articles: |