Data mapping fields

  • Freigeben Version: Australia
  • Aktualisiert 12. März 2026
  • 1 Minute Lesedauer

    • 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.

    Tabelle : 1. Involved Party field mapping
    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.

    Tabelle : 2. Allegations field mapping
    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.

    Tabelle : 3. Subjects of Allegation field mapping
    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​.

    Tabelle : 4. Evidence/Artifact field mapping
    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.

    Tabelle : 5. Evidence of type link field mapping
    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.

    Tabelle : 6. Interviews field maping
    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.

    Tabelle : 7. Corrective/Recommended Actions field mapping
    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
    Hinweis:
    The Description field includes Assigned to or Discussion held by fields for user name.