You cannot permanently delete an employee who is not marked Is Deleted and who has associated sales or timecard records in the Oracle Hospitality Reporting and Analytics database. Employees are mapped between the Simphony and Reporting and Analytics databases using the object number from the EMC. Consider the following example:
-
Employee 12345, Ted Davis, has $500 in sales
-
Employee 12345 is deleted from the database
-
If the EMC allowed this employee to be permanently deleted, a new employee, Mary Smith, could be added at employee record 12345 and the new employee would essentially start with $500 in sales
Thus, the two-step employee deletion process preserves the object number between the two databases. Because of this potential scenario, object numbers are not reusable. If employee 12345 is marked as Is Deleted in the database, you cannot create a new employee record using number 12345.