IP : 3.15.223.190Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
elgg4/
../
elgg33/
../
logic/
../
unmark/
../
projeqtor/
projeqtor.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Dumping data for table `[[dbprefix]]kpidefinition` --
INSERT INTO `[[dbprefix]]kpidefinition` VALUES (1, 'project duration KPI', 'duration', '\n<b>KPI for not ended project = [project planned duration] / [project validated duration]</b><br/>\n<b>KPI for ended project = [project real duration] / [project validated duration]</b><br/>\n<br/>\nKPI < 1 => project is shorter than expected<br/>\nKPI = 1 => project is exactly as long as expected<br/>\nKPI > 1 => project is longer than expected<br/>\n<br/>\nThis indicator is consolidated amongst projects (for organization) without weighting.', 0), (2, 'project workload KPI', 'workload', '\n<b>KPI for project = ( [project real work] + [project left work] / [project validated work]</b><br/>\n<br/>\nKPI < 1 => project workload is less than expected<br/>\nKPI = 1 => project workload is conform to expected<br/>\nKPI > 1 => project workload is more than expected<br/>\n<br/>\nThis indicator is consolidated amongst projects (for organization) with weighting on [project validated work].', 0), (3, 'project terms KPI', 'term', '\n<b>KPI for project = [sum of real amount for all project terms] / [sum of validated amount for all project terms]</b><br/>\n<br/>\nThis indicator has no intrinsic meaning but has some compared to project progress.<br/>\nSo for this indicator, thresholds will not be compared to KPI value directly but to : [project progress] - [KPI value] <br/>(that should then be as small as possible).<br/>\n<br/>\nThis indicator is not consolidated amongst projects (for organization).', 0), (4, 'project deliverables quality KPI', 'deliverable', '\n<b>KPI for deliverable = [Estimated quality value of deliverable] / [Nominal (max) quality value for deliverables]</b><br/>\nQuality value is defined in the deliverable status list, that will be selected on the deliverable.<br/>\nNominal quality value is the max of the values defined in the deliverable status list.<br/>\n<b>KPI consolidated on project = Sum of ([Estimated quality value of deliverables]*[Weighting of deliverable]) / Sum([Nominal (max) quality value of deliverables]*[Weighting of deliverable])</b><br/>\nWeigting value of deliverable is defined in the deliverable weighting list, that will be selected on the deliverable.<br/>\nConsolidated value may not be calculated if all deliverables have zero weight.<br/>\nUnitary value of KPI for single deliverable is not stored in KPI history. Only consolidated value for project is stored is KPI history.<br/>\n<br/>\nThis indicator is consolidated amongst projects (for organization) with weighting on global weight of deliverables on each project.', 0), (5, 'project incomings quality KPI', 'incoming', '\n<b>KPI for incoming = ( [Estimated Quality value of incoming] / [Nominal (max) Quality value for incomings]</b><br/>\nQuality value is defined in the incoming Status list, that will be selected on the incoming.<br/>\nNominal Quality value is the max of the values defined in the incoming Status list.<br/>\n<b>KPI consolidated on project = ( Sum of ([Estimated Quality value of incomings]*[Weighting of incoming]) / Sum([Nominal (max) Quality value of incomings]*[Weighting of incoming])</b><br/>\nWeigting value of incoming is defined in the incoming Weighting list, that will be selected on the incoming.<br/>\nConsolidated value may not be calculated if all incomings have zero weight.<br/>\nUnitary value of KPI for single incoming is not stored in KPI history. Only consolidated value for project is stored is KPI history.<br/>\n<br/>\nThis indicator is consolidated amongst projects (for organization) with weighting on global weight of incomings on each project.', 0);
-- -- Dumping data for table `[[dbprefix]]profile` --
INSERT INTO `[[dbprefix]]profile` VALUES (1, 'profileAdministrator', 'Has a visibility over all the projects', 'ADM', 100, 0), (2, 'profileSupervisor', 'Has a visibility over all the projects', 'SUP', 200, 0), (3, 'profileProjectLeader', 'Leads his owns project', 'PL', 310, 0), (4, 'profileTeamMember', 'Works for a project', 'TM', 320, 0), (5, 'profileGuest', 'Has limited visibility to a project', 'G', 500, 0), (6, 'profileExternalProjectLeader', NULL, 'EPL', 410, 0), (7, 'profileExternalTeamMember', NULL, 'ETM', 420, 0);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;