MCO PMSI Events

PMSI-MCO Events

The following describes all the available to extractions Events from PMSI-MCO table in SNDS. The link in the title redirects to the implementation of the Extractor. You can call that Extractor to get the Event.

CCAM Act during Hospital MCO stay

Values are coded in CCAM coding system.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_C	mco_ccam_act	Concatenation of ETA_NUM+RSA_NUM+SOR_ANN from MCO_C	CDC_ACT from MCO_A	1.0 (non used)	Adding of ENT_DAT from MCO_C and ENT_DAT_DEL(in days) from MCO_A	null(non used)

Main diagnosis during Hospital MCO stay

Values are coded in CIM-10 coding system.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_C	mco_main_diagnosis	Concatenation of ETA_NUM+RSA_NUM+SOR_ANN from MCO_C	DGN_PAL from MCO_B	1.0 (non used)	ENT_DAT from MCO_C	null(non used)

Linked diagnosis during Hospital MCO stay

Values are coded in CIM-10 coding system.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_C	mco_linked_diagnosis	Concatenation of ETA_NUM+RSA_NUM+SOR_ANN from MCO_C	DGN_REL from MCO_B	1.0 (non used)	ENT_DAT from MCO_C	null(non used)

Associated diagnosis during Hospital MCO stay

Values are coded in CIM-10 coding system.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_C	mco_associated_diagnosis	Concatenation of ETA_NUM+RSA_NUM+SOR_ANN from MCO_C	ASS_DGN from MCO_D	1.0 (non used)	ENT_DAT from MCO_C	null(non used)

MCO Hospital stay

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_C	mco_hospital_stay	Concatenation of ETA_NUM+RSA_NUM+SOR_ANN from MCO_C	null(not used)	Look below	EXE_SOI_DTD from MCO_C	EXE_SOI_DTF from MCO_C

The weight is a decimal with the following form A.B with the following meaning:

1. A=ENT_MOD from MCO_B. Possible values are:

• 0 - Transfer for ou after an act.
• 6 – Patient came from the another hospital in the same geographic unit.
• 7 – Patient came from the another hospital from a different geographic unit.
• 8 – Home.

2. B=ENT_PRV from MCO_B, when possible.

• 1 - Short stay from MCO.
• 2 - from SSR.
• 3 - Long stay (SLD).
• 4 - Psychiatry stay (PSY).
• 5 - Got through emergency.
• 6 - From Home Hospitalisation.
• 7 - From an aid structure like EHPAAD.
• 8 - From a reanimation unit.