Primero - Progres IA Referral Exchange: Mapping Specifications [TEMPLATE]

	A	B	C	D	H	I	J	P	Q	R	S	T
1					ProGres v4: Business/Technical fields			Technical Primero fields
2	Flow	Shipping Process	System From	System To	Business Fields	Dynamics Entity	Dynamics Field name (v4 Dynamics SDK)	Primero field ID	Comment	IA Form	Required?	Localized?

3	2	Primero Referral to ProGres	Primero	v4	PoC Address	progres_interoperabilityreferral	progres_pocaddress	address_current		Care Arrangements	Y
4	2	Primero Referral to ProGres	Primero	v4	PoC Date of Birth	progres_interoperabilityreferral	progres_pocdateofbirth	date_of_birth		Child Details	Y
5	2	Primero Referral to ProGres	Primero	v4	Org. Email	progres_interoperabilityreferral	progres_orgemail	email	Owned By User email	User	Y
6	2	Primero Referral to ProGres	Primero	v4	Org. Referred By	progres_interoperabilityreferral	progres_orgreferredby	full_name		User	Y
7	2	Primero Referral to ProGres	Primero	v4	Org. Referral ID	progres_interoperabilityreferral	progres_orgreferralid	case_id + service.unique_id	49 character uuid that concatenates case_id + a substring of the last 12 digits of the service.unique_id for the service that is referred. This is because a custom uuid was needed for the case and service referred (not only the case, since 1 case might have multiple services referred).
8	2	Primero Referral to ProGres	Primero	v4	Comments	progres_interoperabilityreferral	progres_comments	language	Languages spoken - refer to languages mapping table.	Child Details		Yes - option values can change
9	2	Primero Referral to ProGres	Primero	v4	PoC First Name	progres_interoperabilityreferral	progres_pocfirstname	name_first		Child Details	Y
10	2	Primero Referral to ProGres	Primero	v4	PoC Last Name	progres_interoperabilityreferral	progres_poclastname	name_last		Child Details	Y
11	2	Primero Referral to ProGres	Primero	v4	PoC Middle Name	progres_interoperabilityreferral	progres_pocmiddlename	name_middle		Child Details
12	2	Primero Referral to ProGres	Primero	v4	Comments	progres_interoperabilityreferral	progres_comments	name_nickname		Child Details
13	2	Primero Referral to ProGres	Primero	v4	Organization From	progres_interoperabilityreferral	progres_organizationfrom	owned_by_agency_id	Defined on referrer's user record in Primero	User
14	2	Primero Referral to ProGres	Primero	v4	Org. Phone Number	progres_interoperabilityreferral	progres_orgphonenumber	phone	Defined on referrer's user record in Primero	User
15	2	Primero Referral to ProGres	Primero	v4	Org. Position	progres_interoperabilityreferral	progres_orgposition	position	Defined on referrer's user record in Primero	User
16	2	Primero Referral to ProGres	Primero	v4	Comments	progres_interoperabilityreferral	progres_comments	protection_concerns	Protection Concerns (refer to Protection Concerns mapping table)	Protection Concerns		Yes - option values can change
17	2	Primero Referral to ProGres	Primero	v4	SP Need Category	progres_interoperabilityreferral	progres_spneedcategory	protection_concerns	Protection Concerns (refer to Protection Concerns mapping table)	Protection Concerns		Yes - option values can change
18	2	Primero Referral to ProGres	Primero	v4	SP Need Sub Categories	progres_interoperabilityreferral	progres_spneedsubcategories	protection_concerns	Protection Concerns (refer to Protection Concerns mapping table)	Protection Concerns		Yes - option values can change
19	2	Primero Referral to ProGres	Primero	v4	Other Protection Concerns	progres_interoperabilityreferral	progres_otherprotectionconcerns	protection_concerns_other		Protection Concerns
20	2	Primero Referral to ProGres	Primero	v4	Business Unit	progres_interoperabilityreferral	progres_businessunit	service_implementing_agency	Confirmed with Diego August 27 that OpenFn will map all agencies to Ethiopia - Gambella as default value for Production and Alpha. (Refer to service_implementing_agency mapping table)	Nested Services		Yes - option values can change
21	2	Primero Referral to ProGres	Primero	v4	Reason for Referral	progres_interoperabilityreferral	progres_reasonforreferral	service_referral_notes		Nested Services
22	2	Primero Referral to ProGres	Primero	v4	Referral Date	progres_interoperabilityreferral	progres_referraldate	service_response_day_time		Nested Services
23	2	Primero Referral to ProGres	Primero	v4	Requested Services	progres_interoperabilityreferral	progres_requestedservice	service_type	Refer to service mapping table	Nested Services		Yes - option values can change
24	2	Primero Referral to ProGres	Primero	v4	Other Requested Services	progres_interoperabilityreferral	progres_otherrequestedservices	service_type_other		Nested Services
25	2	Primero Referral to ProGres	Primero	v4	PoC Sex	progres_interoperabilityreferral	progres_pocsex	sex		Child Details	Y
26	2	Primero Referral to ProGres	Primero	v4	PoC Phone Number	progres_interoperabilityreferral	progres_pocphonenumber	telephone_current		Child Details
27	2	Primero Referral to ProGres	Primero	v4	PoC Other ID Number	progres_interoperabilityreferral	progres_pocotheridnumber	unhcr_id_no	UNHCR Registration Group Number * Not Mandatory	Child Details
28	2	Primero Referral to ProGres	Primero	v4	UNHCR ID	progres_interoperabilityreferral	progres_unhcrid	unhcr_individual_no	UNHCR Individual ID	Child Details	Y
29	2	Primero Referral to ProGres - Decision proGRes	v4	Primero	N/A			type	Hardcoded default value: 'Referral' Primero requirement for syncing referrals via API.	Referral
30	2	Primero Referral to ProGres - Decision proGRes	v4	Primero	N/A			record_type	Hardcoded default value: 'case' Primero requirement for syncing referrals via API.	Referral
31	2	Primero Referral to ProGres - Decision proGRes	v4	Primero	Review Decision	progres_interoperabilityreferral	progres_reviewdecision	status	Field on the Referrals form. Progres-to-Primero mappings: 125080000 (Acknowledged): Accepted, 125080001 (Rejected): Rejected	Referral
32	2	Primero Referral to ProGres - Decision proGRes	v4	Primero	Referral Rejection Comment	progres_interoperabilityreferral	progres_interoperabiltyreferralrejectionreason	rejected_reason	Progresv4-to-Primero reason mapping: 125080000: 'Individual Not Found', 125080001: 'Individual Not Match UNHCR ID', 125080002: 'Not applicable' Contactenated with below field.	Referral
33	2	Primero Referral to ProGres - Decision proGRes	v4	Primero	Referral Rejection Comment	progres_interoperabilityreferral	progres_interoperabilityreferralrejectionomment	rejected_reason	If rejected, Progresv4 user may leave additional comments (free text). Contactenated with above field.	Referral
34	2	Primero Referral to ProGres - Decision proGRes	v4	Primero	Org. Referral ID	progres_interoperabilityreferral	progres_orgreferralid	id	Progres will provide a 49-character id in the format of `{case_id}#{service.unique_id_substring}` that OpenFn will parse and use to locate the unique id of the referral to update, matching on the service.unique_id. To query referrals via the API, the case id is also required, which is why this is also captured in Progres.
35	1	ProGres Referral To Primero	v4	Primero	Date of Birth	progres_individual	progres_dateofbirth	age	Age is a mandatory field in Primero. Age is calculated via progres_dateofbirth for Primero.	Child Details	Y
36	1	ProGres Referral To Primero	v4	Primero	Date of Birth	progres_individual	progres_dateofbirth	date_of_birth	Date of birth	Child Details
37	1	ProGres Referral To Primero	v4	Primero	Given Name	progres_individual	progres_givenname	first_name	First Name	Child Details	Y
38	1	ProGres Referral To Primero	v4	Primero	Middle Name	progres_individual	progres_middlename	middle_name	Middle Name	Child Details
39	1	ProGres Referral To Primero	v4	Primero	Common Usely Name	progres_individual	progres_commonyusedname	name_nickname	Nickname	Child Details
40	1	ProGres Referral To Primero	v4	Primero	Family Name	progres_individual	progres_familyname	last_name	Last Name	Child Details	Y
41	1	ProGres Referral To Primero	v4	Primero	Individual ID	progres_individual	progres_id	unhcr_individual_no	UNHCR Individual ID	Child Details	Y
42	1	ProGres Referral To Primero	v4	Primero	Registration Group	progres_individual	progres_registrationgroupid	unhcr_id_no	UNHCR Registration Group Number	Child Details
43	1	ProGres Referral To Primero	v4	Primero	Language Code Id	progres_language	progres_languagecodeid	language	Languages spoken - refer to languages mapping table.	Child Details		Yes - option values can change
44	1	ProGres Referral To Primero	v4	Primero	Sex	progres_individual	progres_sex	sex	Progres-to-Gambella option value mapping: 125080000: 'female', 125080001: 'male', 125080002: 'other_b25f252'	Child Details	Y	Yes - option values can change
45	1	ProGres Referral To Primero	v4	Primero	Primary Phone Number	progres_individual	progres_primaryphonenumber	telephone_current	Telephone	Child Details
46	1	ProGres Referral To Primero	v4	Primero	CoA Location Level 1	progres_individual	progres_coalocationlevel1	address_current	Multiple Progres location fiels are concentenated and mapped to Primero address_current field. Separate by comma the coalocation level's by admin level.	Care Arrangements	Y
47	1	ProGres Referral To Primero	v4	Primero	CoA Location Level 2	progres_individual	progres_coalocationlevel2	address_current	Multiple Progres location fields are concentenated and mapped to Primero address_current field. Separate by comma the coalocation level's by admin level.	Care Arrangements	Y
48	1	ProGres Referral To Primero	v4	Primero	CoA Location Level 3	progres_individual	progres_coalocationlevel3	address_current	Multiple Progres location fields are concentenated and mapped to Primero address_current field. Separate by comma the coalocation level's by admin level.	Care Arrangements	Y
49	1	ProGres Referral To Primero	v4	Primero	CoA Location Level 4	progres_individual	progres_coalocationlevel4	address_current	Multiple Progres location fields are concentenated and mapped to Primero address_current field. Separate by comma the coalocation level's by admin level.	Care Arrangements	Y
50	1	ProGres Referral To Primero	v4	Primero	CoA Location Level 5	progres_individual	progres_coalocationlevel5	address_current	Multiple Progres location fields are concentenated and mapped to Primero address_current field. Separate by comma the coalocation level's by admin level.	Care Arrangements	Y
51	1	ProGres Referral To Primero	v4	Primero	CoA Location Level 6	progres_individual	progres_coalocationlevel6	address_current	Multiple Progres location fields are concentenated and mapped to Primero address_current field. Separate by comma the coalocation level's by admin level.	Care Arrangements	Y
52	1	ProGres Referral To Primero	v4	Primero	Intervention Service Provider	progres_lpintervention	progres_interventionserviceprovider	owned_by	Organizational Focal Point User who is receiving the referral in Primero. Gambella user: 'progresv4_primero_intake' DOWNSTREAM: there might be other partners so we may need a mapping table of partners & focal point users (e.g, helpinghands_primero_intact) if multiple focal point users are required in Primero.	Case		Yes - username can change
53	1	ProGres Referral To Primero	v4	Primero	Specific Need Sub Category	progres_specificneeds	progres_spnsubcategory2.spnsubcategory2code	protection_concerns	Protection Concerns (refer to Protection Concerns mapping table)	Protection Concenrs		Yes - option values can change
54	1	ProGres Referral To Primero	v4	Primero	Intervention Number	progres_lpintervention	progres_interventionnumber	progres_interventionnumber	UNHCR Intervention Number	New! ADD TO IA "Nested Services" FORM?
55	1	ProGres Referral To Primero	v4	Primero	Partner	systemuser	progres_partner.Name	service_request_agency	Service Requestor Agency	Nested Services
56	1	ProGres Referral To Primero	v4	Primero	Primary Email	systemuser	internalemailaddress	service_request_email	Service Requestor Email	Nested Services
57	1	ProGres Referral To Primero	v4	Primero	NULL	NULL	NULL	service_request_external	Service request from an external system? Default value set by OpenFn: true	Nested Services
58	1	ProGres Referral To Primero	v4	Primero	Mobile Phone	systemuser	mobilephone	service_request_phone	Service Requestor Phone Number	Nested Services
59	1	ProGres Referral To Primero	v4	Primero	Title	systemuser	title	service_request_title	Service Requestor Title	Nested Services
60	1	ProGres Referral To Primero	v4	Primero	NULL	NULL	NULL	service_response_type	Type of response in Primero, default to "Service provision"	Nested Services
61	1	ProGres Referral To Primero	v4	Primero	Intervention Start Date	progres_lpintervention	progres_interventionstartdate	service_response_day_time	Service created on	Nested Services
62	1	ProGres Referral To Primero	v4	Primero	Intervention Type	progres_lpintervention	interventiontype.progres_description	service_type	Refer to service mapping table	Nested Services		Yes - option values can change
63	1	ProGres Referral To Primero	v4	Primero	Intervention Description	progres_lpintervention	progres_interventiondescription	service_referral_notes	1st of 2 Progres fields that is concatenated into this Primero text field. Provides info on reason for referral.	Nested Services
64	1	ProGres Referral To Primero	v4	Primero	Intervention By (Other)	progres_lpintervention	progres_interventionbyother	service_referral_notes	2nd of 2 Progres fields that is concatenated into this Primero text field. Provides info on service request notes from user in Progres system.	Nested Services
65	1	ProGres Referral To Primero - Decision PRIMERO	Primero	v4	Comments	progres_dtpdelivery	Message.comment	unhcr_referral_rejection_reason	formerly "closure_reason"	New! (Field name: If rejected, why?) Nested Services
66	1	ProGres Referral To Primero - Decision PRIMERO	Primero	v4	Primero ID	progres_dtpdelivery	Message.primero id	case_id
67	1	ProGres Referral To Primero - Decision PRIMERO	Primero	v4	Primero Case Worker	progres_dtpdelivery	Message.primero_user	owned_by	Field sent to Progres re-labled as "primero_user".
68	1	ProGres Referral To Primero - Decision PRIMERO	Primero	v4	Intervention Number	progres_dtpdelivery	Name	progres_interventionnumber
69	1	ProGres Referral To Primero - Decision PRIMERO	Primero	v4	Primero Transfer Status Date	progres_dtpdelivery	Message.decisiondate	service_response_type
70	1	ProGres Referral To Primero - Decision PRIMERO	Primero	v4	Primero Transfer Status	progres_dtpdelivery	Message.decision	unhcr_referral_status	Field sent to Progres re-labled as "status". Primero-to-Progres mappings: accepted: Acknowledged, rejected: Rejected, pending: Pending Acknowledgement	New! (Field name: UNHCR Referral Status) Nested Services
71	1	ProGres Referral To Primero	v4	Primero	NULL	NULL	NULL	created_by	No OpenFn mapping needed; case created_by defaults to OpenFn API user
72	1	ProGres Referral To Primero	v4	Primero	NULL	NULL	NULL	created_by	No OpenFn mapping needed; case created_by defaults to OpenFn API user
73	1	ProGres Referral To Primero	v4	Primero	NULL	NULL	NULL	created_by_organization	No OpenFn mapping needed; ProGres v4 will be the default value (because this is the Agency assigned that will be assigned to the OpenFn API user) and is configured on this user. Original mapping spec: created_by_source (but does not exist in Primero)
74	1	ProGres Referral To Primero	v4	Primero	Priority	progres_childprotectioncase	progres_priority	NULL	Not an option in this Primero instance			Yes - available in Progresv4, so can be mapped to Primero if desired
75	1	ProGres Referral To Primero	v4	Primero	Comprehension Level	progres_language	progres_comprehensionlevel	NULL	Not an option in this Primero instance			Yes - available in Progresv4, so can be mapped to Primero if desired
76	1	ProGres Referral To Primero	v4	Primero	Mother Tongue	progres_language	progres_mothertongue	NULL	Not an option in this Primero instance			Yes - available in Progresv4, so can be mapped to Primero if desired
77	1	ProGres Referral To Primero	v4	Primero	Read Level	progres_language	progres_readlevel	NULL	Not an option in this Primero instance			Yes - available in Progresv4, so can be mapped to Primero if desired
78	1	ProGres Referral To Primero	v4	Primero	Speak Level	progres_language	progres_speaklevel	NULL	Not an option in this Primero instance			Yes - available in Progresv4, so can be mapped to Primero if desired
79	1	ProGres Referral To Primero	v4	Primero	Write Level	progres_language	progres_writelevel	NULL	Not an option in this Primero instance			Yes - available in Progresv4, so can be mapped to Primero if desired
80	1	ProGres Referral To Primero	v4	Primero	Business Owner	progres_lpintervention	progres_businessowner	owned_by	UNHCR originally proposed recording the Progres v4 User that sent the referral. However, this seems redundant to the referrer information already captured on the Services form. Not recording this in Primero for now. UNICEF can update if UNHCR needs this. If we do need to record, will do so in a text field on service. Do not need to create Primero user accounts that correspond with proGres ones.
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100