This repository was archived by the owner on Dec 16, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 6
LAAC Data Mapping
Oskar Hinc edited this page Feb 1, 2019
·
4 revisions
| LAAC field (type) | Example value | Mapped to (type) |
|---|---|---|
| Organization Name (string) | Organization Name | Organization.name (string) Service.name + " - Service" (string) Location.name + " - Location" (string) |
| Contact Name (string) | John Smith | Contact.name (string) |
| Phone (string) | (123) 123 - 4444 | Phone.number (string) |
| Authored by (string) | Anonymous | ignored |
| Authored on (string) | Mon, 01/21/2019 - 12:08 | Parsed with "EEE, MM/dd/yyyy - HH:mm" format to Organization.yearIncorporated (LocalData) |
| Address (string) | City, State 12341 County Address City, State 12342 Country Address Attention City, State 12342 Country |
PhysycalAddress (details below) |
| Areas Served (string) | Area10, Area11, Area12, Area13 | Location.description (string) |
| Description of Service Types (string) | Descrprion of service types | Service.description (string) |
| Eligibility (string) | Description of eligibility | Eligibility.eligibility (string) |
| Intake method (string) | Intake method | ignored |
| Legal Clinic Calendar URL (string) | ignored | |
| Legal Help Category (string) | ignored | |
| Legal Issues (string) | ignored | |
| Offers Legal Representation | Yes/No | ignored |
| Organization Type (string) | Type | ignored |
| Service Types (string) | Service type 1, Service type 2 | Service.type (string) |
| Spoken Languages | Russian / Росси́я, Spanish / Español | Each language separated by ',' is saved as distinct Language entity (with value mapped to Language.language) |
| Website (string) | www.org.com | Organization.url (string) |
| Who We Are (string) | Who we are | Organzation.description (string) |
| ID | b25571c6-f547-4ecf-ab3f-7890474b8a92 | Service.externalDbId (string) Location.externalDbId (string) Organization.externalDbId (string) Contact.externalDbId (string) ServiceAtLocation.externalDbId (string) |
PhysicallAddress entity can be mapped using below patterns. They must be delivered in one of those three forms.
| Supported address pattern | Result entity |
|---|---|
| City, State 12341 Country |
city = "City" stateProvince = "State" postalCode = "12341" country = "Country" address1 = "N/A" attention = null |
| Address City, State 12342 Country |
city = "City" stateProvince = "State" postalCode = "12341" country = "Country" address1 = "Address" attention = null |
| Address Attention City, State 12342 Country |
city = "City" stateProvince = "State" postalCode = "12341" country = "Country" address1 = "Address" attention = "Attention" |
A parsed data should respect all restrictions described below. If a part of the data does not apply to these rules, it should not be persisted.
| Field | Restrictions |
|---|---|
| Organization Name | not blank |
| Eligibility | not blank |
| Address | not blank |
| Contact Name | not blank |
| Spoken Languages | not blank |
| Phone | not blank |
- Organization is related to Locaton and Service
- Each Language is related to Service and Location
- Physical Address is related to Location
- Each Phone is related to Service and Location
- Service At Location is related to Serive and Location
- Eigibility is related to Service