---

INSERT INTO Employment_Record
(
    record_id,
    record_date,
    record_type,
    position,
    department,
    document_number,
    employment_book_id,
    specialist_id
)
VALUES
(
    1,
    '2016-06-10',
    'Hiring',
    'Manager',
    'Sales Department',
    'Order No. 101',
    1,
    1
),
(
    2,
    '2021-05-17',
    'Transfer',
    'Senior Manager',
    'Sales Department',
    'Order No. 57',
    2,
    2
),
(
    3,
    '2023-08-15',
    'Hiring',
    'Accountant',
    'Accounting Department',
    'Order No. 120',
    3,
    3
),
(
    4,
    '2024-11-30',
    'Dismissal',
    'Engineer',
    'Technical Department',
    'Order No. 145',
    4,
    4
),
(
    5,
    '2023-10-02',
    'Hiring',
    'HR Specialist',
    'HR Department',
    'Order No. 88',
    5,
    5
);