MCO ACE

MCO ACE

External activities of hospitals are details in this page.

This page list all extractable Events from the MCO-CE source in SNDS.

CCAM Act from MCO ACE

Values are coded in CCAM coding system.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_CSTC	mco_ccam_act	Concatenation of ETA_NUM+SEQ_NUM+year from MCO_CSTC	CCAM_COD from MCO_FMSTC	1.0 (non used)	EXE_SOI_DTD from MCO_CSTC	null(non used)

NGAP act from MCOCE_FBSTC table

Extracts NGAP listed in MCO FBSTC. MCO FBSTC inform about hospital services. Look at the referenced page in the beginning for more detailed information.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_CSTC	mco_ce_fbstc_act	Concatenation of ETA_NUM+SEQ_NUM+year from MCO_CSTC	Look below	1.0 (non used)	EXE_SOI_DTD from MCO_CSTC	null(non used)

value algorithm

Get ACT_COE from T_MCO FBSTC:

• if the result == null, then return "PmsiCe_"+ ACT_COD from MCO_FBSTC + "_0".
• else, then return "PmsiCe_"+ ACT_COD from MCO_FBSTC+ "_" + ACT_COE from MCO_FBSTC.

NGAP act from MCOCE_FCSTC table

Extracts NGAP listed in MCO FCSTC. MCO FCSTC inform external acts. Look at the referenced page in the beginning for more detailed information.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_CSTC	mco_ce_fcstc_act	Concatenation of ETA_NUM+SEQ_NUM+year from MCO_CSTC	Look below	1.0 (non used)	EXE_SOI_DTD from MCO_CSTC	null(non used)

value algorithm

Get ACT_COE from T_MCO FCSTC:

• if the result == null, then return "PmsiCe_"+ ACT_COD from MCO_FBSTC + "_0".
• else, then return "PmsiCe_"+ ACT_COD from MCO_FCSTC+ "_" + ACT_COE from MCO_FCSTC.

Practionner speciality act from MCOCE_FBSTC table

Extracts NGAP listed in MCO FBSTC. MCO FBSTC inform about hospital services. Look at the referenced page in the beginning for more detailed information.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_CSTC	mco_ce__fbstc_practitioner_claim	Concatenation of ETA_NUM+SEQ_NUM+year from MCO_CSTC	EXE_SPE from MCO_CE_FBTSC	1.0 (non used)	EXE_SOI_DTD from MCO_CSTC	null(non used)

Practionner speciality act from MCOCE_FCSTC table

Extracts NGAP listed in MCO FBSTC. MCO FBSTC inform about hospital services. Look at the referenced page in the beginning for more detailed information.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_CSTC	mco_ce__fcstc_practitioner_claim	Concatenation of ETA_NUM+SEQ_NUM+year from MCO_CSTC	EXE_SPE from MCO_CE_FCTSC	1.0 (non used)	EXE_SOI_DTD from MCO_CSTC	null(non used)

Emergency visit in MCO-Ce

Extracts emergency visits in MCO_CE_FBSTC. Keeps only rows where ACT_COD from MCO_FBSTC starts with ATU.

Event field	PatientID	category	groupID	value	weight	start	end
Mapping	NUM_ENQ from MCO_CSTC	mco_ce_emergency	Concatenation of ETA_NUM+SEQ_NUM+year from MCO_CSTC	null(not used)	1.0 (non used)	EXE_SOI_DTD from MCO_CSTC	EXE_SOI_DTF from MCO_CSTC