SELECT L_Log.Pat_ID, CDate(Nz([Service_DtTm],Nz([Accept_dttm],[Arrive_Dttm]))) AS Admit_DtTm FROM L_Log LEFT JOIN created_FirstService ON L_Log.Pat_ID = created_FirstService.Pat_ID;
This is implemented as Created_AdmitDtTm query.
GRA changed to this Oct 1 and everyone else Oct 15. Julie cleaned all the data so we don't need to worry about this: we can simply say if Service tmp DtTm is available, use it.
Data Integrity Checks (automatic list)
|Query check tmp Service and Boarding Loc during admission timeframe||CCMDB.accdb||implemented|
|Function long LOS()||CCMDB.accdb||needs review|
|Link suspect negative transit time query||Centralized data front end.accdb||implemented|
|List of related concepts|
Also see "what links here"
- 2022-04-04 confirmed that both CFE and CCMDB now use this as defined here.