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