Data mapping fields
Data mapping of tables is necessary when ethics matter is transferred by the legal fulfiller to HR and an HR Employee Relations case is transferred to the Legal department.
Involved Party
Legal Table: sn_lg_investigate_involved_party.
HR Table: sn_hr_er_involved_party.
| Legal Fields | HR Fields |
|---|---|
| external_user | not_in_system |
| type | type |
| internal_party | user |
| external_party | name |
Allegations
Legal Table: sn_lg_investigate_allegation.
HR Table: sn_hr_er_allegation.
| Legal Fields | HR Fields |
|---|---|
| allegation_type | allegation_type |
| allegation_subtype | allegation_subtype |
| description | description |
Subjects of Allegation
Legal Table: sn_lg_investigate_m2m_allegation_party.
HR Table: sn_hr_er_m2m_allegation_party.
| Legal Fields | HR Fields |
|---|---|
| involved_party | involved_party |
| allegation | allegation |
| outcome | outcome |
Evidence/Artifact
Legal Table: sn_lg_matter artifact.
HR Table: sn_em_evidence.
| Legal Fields | HR Fields |
|---|---|
| sn_lg_matter_artifact.short_description | name |
| involved_party_users | subjects_of_allegation |
| submitted_by | submitted_by_involved_party |
Evidence of type link
Legal Table: sn_lg_matter_artifact_external_storage.
HR Table: sn_em_evidence.
| Legal Fields | HR Fields |
|---|---|
| sn_lg_matter_artifact_external_storage.short_description | name |
| link | url source |
Interviews
Legal Table: sn_lg_matter task.
HR Table: sn_hr_er_interview.
| Legal Fields | HR Fields |
|---|---|
| involved_party | interviewee |
| interview_notes | notes |
Corrective/Recommended Actions
Legal Table: sn_lg_matter task.
HR Table: sn_hr_er_corrective action.
| Legal Fields | HR Fields |
|---|---|
| involved_party | involved_party |
| also_present | also_present |
| discussion_date | discussion_date |
| description | description |
| state | status |
| recommended_action_type | corrective_action_type |
| due_date | due_date |
Note: The Description field includes Assigned to or Discussion held by fields for user name.
Parent Topic:Legal Investigations reference
--- title: Data mapping fields description: Data mapping of tables is necessary when ethics matter is transferred by the legal fulfiller to HR and an HR Employee Relations case is transferred to the Legal department. locale: en-US canonical_url: https://www.servicenow.com/docs/r/australia/employee-service-management/legal-investigations/deep-data-copy-mapping.html release: australia product: Legal Investigations classification: legal-investigations topic_type: reference last_updated: "2026-09-10" reading_time_minutes: 1 breadcrumb: [Reference, Legal Investigations, Legal Service Delivery Practice Applications, Legal Service Delivery, Legal and Contract Operations, Employee Service Management] --- # Data mapping fields Data mapping of tables is necessary when ethics matter is transferred by the legal fulfiller to HR and an HR Employee Relations case is transferred to the Legal department. ## Involved Party Legal Table: sn\_lg\_investigate\_involved\_party. HR Table: sn\_hr\_er\_involved\_party. |Legal Fields|HR Fields| |------------|---------| |external\_user|not\_in\_system| |type|type| |internal\_party|user| |external\_party|name| ## Allegations Legal Table: sn\_lg\_investigate\_allegation. HR Table: sn\_hr\_er\_allegation. |Legal Fields|HR Fields| |------------|---------| |allegation\_type|allegation\_type| |allegation\_subtype|allegation\_subtype| |description|description| ## Subjects of Allegation Legal Table: sn\_lg\_investigate\_m2m\_allegation\_party. HR Table: sn\_hr\_er\_m2m\_allegation\_party. |Legal Fields|HR Fields| |------------|---------| |involved\_party|involved\_party| |allegation|allegation| |outcome|outcome| ## Evidence/Artifact Legal Table: sn\_lg\_matter artifact. HR Table: sn\_em\_evidence. |Legal Fields|HR Fields| |------------|---------| |sn\_lg\_matter\_artifact.short\_description|name| |involved\_party\_users|subjects\_of\_allegation| |submitted\_by|submitted\_by\_involved\_party| ## Evidence of type link Legal Table: sn\_lg\_matter\_artifact\_external\_storage. HR Table: sn\_em\_evidence. |Legal Fields|HR Fields| |------------|---------| |sn\_lg\_matter\_artifact\_external\_storage.short\_description|name| |link|url source| ## Interviews Legal Table: sn\_lg\_matter task. HR Table: sn\_hr\_er\_interview. |Legal Fields|HR Fields| |------------|---------| |involved\_party|interviewee| |interview\_notes|notes| ## Corrective/Recommended Actions Legal Table: sn\_lg\_matter task. HR Table: sn\_hr\_er\_corrective action. |Legal Fields|HR Fields| |------------|---------| |involved\_party|involved\_party| |also\_present|also\_present| |discussion\_date|discussion\_date| |description|description| |state|status| |recommended\_action\_type|corrective\_action\_type| |due\_date|due\_date| **Note:** The **Description** field includes **Assigned to** or **Discussion held by** fields for user name. **Parent Topic:**[Legal Investigations reference](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/employee-service-management/legal-investigations/legal-investigations-reference.md)
| title | Data mapping fields |
| description | Data mapping of tables is necessary when ethics matter is transferred by the legal fulfiller to HR and an HR Employee Relations case is transferred to the Legal department. |
| locale | en-US |
| canonical_url | https://www.servicenow.com/docs/r/australia/employee-service-management/legal-investigations/deep-data-copy-mapping.html |
| release | australia |
| product | Legal Investigations |
| classification | legal-investigations |
| topic_type | reference |
| last_updated | 2026-09-10 |
| reading_time_minutes | 1 |
| breadcrumb | ReferenceLegal InvestigationsLegal Service Delivery Practice ApplicationsLegal Service DeliveryLegal and Contract OperationsEmployee Service Management |