Anonymous Provider Data Mapping

Mapping details

Provider field	Example value	Mapped to
(anonymous field, considered as id)	1	ignored
Resource Verified Date	2018-08-28	ignored
Resource Created Date	2014-08-11	ignored
Resource Site Phone	18012333451	Phone.number
Program Category List	Health; Medication	ignored
Service ID	9876	ignored
Website	https://www.organization.com	Organization.email
Line 2	550 Example Street	added to "Line 1", with " " as prefix
Line 1	2800 Main St.	PhysicalAddress.address1, PostalAddress.address1, used to generate Location.name - details below the table
Is Capacity Sensitive	Yes	ignored
Resource Site Email	example@email.org	Organization.email
Eligibility List	Medical care; Memory care	Eligibility.eligibility
Is Wheelchair Accessible	No	AccessibilityForDisabilities.details; AccessibilityForDisabilities.accessibility is always set to: "Is Wheel Chair Accessible"
Program List	Social Supports; Youth	separated by "; " and each mapped to Program.name
Resource Site Phone Extension	606060	Phone.extension
Organization Name	Example Organization	Organization.name
Service Description	The service provides health insurance to people in need APPLICATION PROCEDURE Call for service. FEES/PAYMENT SOURCE There are no fees for service.	Service.description
Weekly Open Hours Raw	08:00AM-04:00PM, 07:45AM-04:00PM, 08:00AM-04:00PM, 08:00AM-04:00PM, 08:00AM-04:00PM, CLOSED, CLOSED	separated by ", " and each mapped to OpeningHours: Part before "-" - opensAt, Part after "-" - closesAt. If it's a custom value, without "-" (like "CLOSED") it's considered as a opensAt field. Additionally, each OpeningHours object has a weekday value, which is set according to the order of values (from 0).
Language List	Spanish; English	separated by "; " and each mapped to Language.language
Service Additional Info	Hours: On weekends, call service is active	added to "Service Description", with " " as prefix
Organization ID	14231	ignored
City	San Francisco	PhysicalAddress.city, PostalAddress.city, used to generate Location.name - details below the table
Geo Location	12.3454455,-128.32323	split by "," and mapped to: Location.latitude (1st part); Location.longitude (2nd part)
Service Name	Heath Service	Service.name
Resource Site ID	123456	ignored
Is Hidden (Yes / No)	No	ignored
Cost of Service Minimum	0	used to generate Service.fees - details below the table
State	CA	PhysicalAddress.stateProvince, PostalAddress.stateProvince, used to generate Location.name - details below the table
Required Item List	Insurance; Referral	Service.applicationProcess, with "Required items: " prefix
Cost of Service Maximum	0	used to generate Service.fees - details below the table
App URL	https://app.example.com/en/resource/1234	ignored
Service Next Steps	Call or go online	ignored

Additional info

Some values are generated from multiple fields. For now, only simple cases are covered, so if some data is missing, empty string will be used (like in Service.fees example).

Service.fees is generated from multiple fields:
"from " + cost of service minimum + " to " + cost of service maximum
Example: "from 0 to "

Location.name is generated from multiple fields:
line 1 + " - " + city + " (" + state + ")"
Example: "1234 Super Street - San Francisco (CA)"

Organization.active is always set to ture

Entities relationships

To ensure all required relationships between entities are set, each of them is listed below.

• Each Program has a reference to the Organization
• Each Language has a reference to the Service and Location
• AccessibilityForDisabilities has a reference to the Location
• Eligibility has a reference to the Service
• Phone has a reference to the Service and Location
• PhysicalAddress has a reference to the Location
• PostalAddress has a reference to the Location
• Service has a reference to the Organization
• Organization has a reference to the Location and the Source Document
• Each OpeningHours has a reference to the RegularSchedule
• RegularSchedule has a reference to the Serivce and Location