Medication Mappings from source data

Element	MP	TP	MPUU	TPUU	MPP	TPP	CTPP
code	sctId	sctId	sctId	sctId	sctId	sctId	sctId Pharmacode® GTIN
status							*
form			MPUU.ManufacturedDoseForm	TPUU.ManufacturedDoseForm
amount	Not populated
ingredients	Substances from MP -> substances	MP from TP -> TPUU -> MPUU -> MP Substances from MPs -> substances	MP from MPUU.MP Substances from MPUU.MP -> substances	MP From TPUU -> MPUU.MP	MPs From MPP -> MPUU.MP Substances From MPP -> MPUU.MP -> Substances	MPs From TPP -> TPUU -> MPUU.MP Substances From TPP -> TPUU -> MPUU.MP -> Substances	MPs From CTPP -> TPUU -> MPUU.MP Substances From CTPP -> TPUU -> MPUU.MP -> Substances
batch	Not populated
Extensions
Type	'mp'	'tp'	'mpuu'	'tpuu'	'mpp'	'tpp'	'ctpp'
CALs			MPUU -> CALs	TPUU -> MPUU -> CALs	MPP -> MPUU -> CALs	TPP -> TPUU -> MPUU -> CALs	CTPP -> TPPU -> MPUU -> CALs
atc	nzmt_atc_links
Unapproved							CTPP.is_section29
Legal Classification			*	**			CTPP -> ms_product.classification
Medsafe status							CTPP -> ms_package.pkg_status
Medsafe route of administration							CTPP -> ms_route_of_admin.route
Prescribe by brand			MPUU.prescribe_by_brand
Funding							PHARMAC tables, details to come
PHARMAC supply info	Based on sctid
Links - monographs	Monographs that include the associated MP

* A CTPP medication is deemed active if the following criteria is met and the medication is not deemed obsolete (via NZMT is_obsolete flag)

• Has some level of community funding or HML funding for any of the schedules associated with the medication (i.e. current or future)
• Is section 29
• Has no medsafe nzmt link
• Medsafe package summary is either "Active" or "Under Assessment" and Medsafe regSituation is either "Consent given" or "Provisional consent"

Document reference Mappings from source data

Element	Monographs	Special Authorities	Patient Information Leaflets	Datasheets	CMIs
identifier	Monograph id (e.g. nzf_2439)	Special Authority Number – e.g. SA1683
status	Current
docStatus	Final
date	Date of document reference creation
author	NZ Formulary	PHARMAC	NZ Formulary	Medsafe	Medsafe
type	'AdultMonograph' or 'ChildMonograph'	'SpecialAuthorityForm'	'PatientInformationLeaflet'	'Datasheet'	'CMI'
Description	Monograph title	Special Authority Form {SA Form Id}
content.url	Url to monograph	Url to Special Authority PDF	Url to PIL	Url to datasheet	Url to CMI
content.data		Request form xml
context.extension.formulary			Applicable formulary (e.g. nzf, nzfc)
context.extension.source			Source of PIL (e.g. mymedicines)
context.extension.indication			Indication that this PIL applies to
context.extension.dose-form			Doseform that this PIL applies to
context.extension.route-of-admin			Route of admin that this PIL applies to

* legal classifications for MPUUs are derived from their matching TPUU - see below

** legal classifications for TPUUs are derived from their associated CTPPs. If all CTPPs have the same classification then this is assigned to the TPUU. If not, then this is left blank