Px Date

Data Element (edit)
Field Name:	Px Date
CCMDB Label:	Px Date
CCMDB tab:	CCI
Table:	L_CCI_Picklist table, L_CCI_Component table
Data type:	date
Length:	not stated
Program:	Med and CC
Created/Raw:	Raw
Start Date:	1988-07-11
End Date:	2300-01-01
Sort Index:	4

The date/time of a CCI procedure

• SMW

Legacy implementation right in the table

• Cargo

• Categories

• Forms

The Px Date is coded as part of the CCI Collection.

• mandatory for procedures with Px Type acquired / Acquired Procedure
• not allowed for procedures with Px Type admit / Admit Procedure

Don't enter the time that a procedure was done, just the date. The time component should only be used for #Moves.

Moves

In order to still be able to associate procedures and TISS entries with the location where they happen under PatientFollow Project, we use the time component of the Px Date to link the Px to a Boarding Loc.

For a patient who moves on the day of the procedure, enter the Px Date that corresponds to the Boarding Loc where the pt was at the time of the procedure:

• if pt is in a location where they were already yesterday, or for the only Boarding Loc that day, use 0:00
• for a procedure that happened while at a new location that day, enter as Px Date the same DtTm as used for the current Boarding Loc
  • if pt is at third location that day, use the third location's Boarding Loc, etc

1 There was an email exchange that people are not doing this consistently for all CCIs, especially in medicine. How should we do this going forward? Whatever we do there will affect query check_CCI_CXR_vs_LOS, so see that page as well for this discussion. Ttenbergen 15:50, 2021 September 2 (CDT)

• SMW

• Cargo

• Categories

Limitations to field formatting

There have been requests to change this field so collectors don't need to actually type the punctuation components of the date and time. The time component is only needed when there is a second entry on a different unit for the same day (actually, so far it's only required for TISS, see discussion above).

A field can either be set up as a date, which enables the calendar popup, or with more flexible entry filters that would not require the punctuation, but not both. We chose to set the Px Date up in a way that enables the pop-up calendar but requires punctuation.

Discussed 2021-04-21 and decided to keep the default to show the calendar rather than simplify punctuation.

Data Integrity Checks (automatic list)

	App	Status
Query check CCI Date	CCMDB.accdb	implemented