OMNINxG is a multi-company application with complete data isolation company-wise.
Companies are stored in omni_company_master.
All Stored Procedures, Queries for core entities must take as an argument the User Id of the logged in user and filter the fetched data according to the companies that this user has access to.
All Parent Tables must have the company_id as a NOT NULL foreign key – the inserts in the parent tables must take the company_id as a required parameter.
All Test Cases must check that company specific data is being displayed for different logged in Users.
There are two Role Groups already setup in OMNINxG
OMNI-Approval-Roles Group - All Approvals in the System MUST be setup as an Approval-Role as part of the Approval Role Group. For example there should be a Role called MR-Approver under the OMNI-Approval-Roles
OMNI-Roles - All other Roles used to control OMNI pages access must be under this role. For instance FinanceAdmin Role must be under the Role Group OMNI-Roles.