Created AdmitDtTm query: Difference between revisions

Revision as of 15:57, 15 July 2021 view source Ttenbergen (talk \| contribs) CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators 92,362 edits mNo edit summary ← Older edit		Revision as of 15:07, 15 September 2021 view source Ttenbergen (talk \| contribs) CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators 92,362 edits mNo edit summary Newer edit →
Line 1:		Line 1:
	The query created_FirstService in [[CFE]] contains the "admit date and time" of a profile according to the different definitions used over time.		The query created_FirstService in [[CFE]] and [[DSM Labs Consistency check.accdb]] contains the "admit date and time" of a profile according to the different definitions used over time.

	That is: Nz([FirstService_DtTm],Nz([Accept_dttm],[Arrive_Dttm])), where FirstService_DtTm is the earliest [[Service tmp entry]] DtTm for the profile as taken from [[Created_FirstService query ]].		That is: Nz([FirstService_DtTm],Nz([Accept_dttm],[Arrive_Dttm])), where FirstService_DtTm is the earliest [[Service tmp entry]] DtTm for the profile as taken from [[Created_FirstService query ]].