-- Table structure for table `Questionsmastervalues`
--

CREATE TABLE `Questionsmastervalues` (
  `id` int NOT NULL AUTO_INCREMENT,
  `masterDataType` varchar(255) NOT NULL,
  `isActive` tinyint(1) NOT NULL,
  `createdBy` varchar(255) NOT NULL,
  `updatedBy` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Questionsmastervalues`
--

INSERT INTO `Questionsmastervalues` VALUES (1,'Software_Product',1,'GCG','GCG','2024-02-27 08:00:11','2024-04-11 10:09:54'),(2,'Scope_mapping',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(3,'Working_hours',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(4,'Hosting_Type',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(5,'Server_type',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(6,'MainCSP',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(7,'Workload_Type',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(8,'Storage_Type',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(9,'Traffic_Type',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(10,'Shutdown_onDemand',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(11,'Application_Life',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(12,'Disaster_Recovery',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(13,'DeveloperAssessment_Rating',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(14,'DevOps_Maturity',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(15,'FinOps_Maturity',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(16,'Video_Tool',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(17,'Development_Repository',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(18,'APM_Tool',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(19,'Testing_Tool',1,'GCG','GCG','2024-02-27 08:00:11','2024-02-27 08:00:11'),(20,'Processor_manufacturer',1,'GCG','GCG','2024-02-27 08:01:55','2024-02-27 08:01:55'),(21,'Operating_System',1,'GCG','GCG','2024-02-27 08:01:55','2024-02-27 08:01:55'),(22,'Desktop_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,'ThinClient_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,'NSD_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,'Screen_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,'Laptop_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,'VOIP_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(28,'Smartphone_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(29,'Tablets_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,'Printer_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,'EFS_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(32,'RDS_TCS',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(33,'RDS_AppServer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(34,'Print_server',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,'Seq_Proc_Manuf',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(68,'Dumy',0,'GCG','GCG','2024-05-10 06:38:35','2024-05-10 06:38:35'),(69,'developer',1,'GCG','GCG','2024-05-10 11:20:43','2024-05-10 11:20:43'),(70,'developer',1,'GCG','GCG','2024-05-10 11:38:56','2024-05-10 11:38:56'),(71,'Check',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(72,'Assessment_type',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(74,'Mobile_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(75,'Tablet_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(76,'Printer_manufacturer',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(77,'PDU_rating',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00'),(78,'Confirmation',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `Report_Contents`
--

CREATE TABLE `Report_Contents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `OrderId` int NOT NULL,
  `ReportId` int NOT NULL,
  `head1` varchar(255) DEFAULT NULL,
  `isActive` tinyint(1) NOT NULL,
  `createdBy` varchar(255) NOT NULL,
  `updatedBy` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `contentDesc` mediumtext,
  PRIMARY KEY (`id`),
  KEY `ReportId` (`ReportId`),
  CONSTRAINT `Report_Contents_ibfk_1` FOREIGN KEY (`ReportId`) REFERENCES `Atlas_Reports` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=386 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Report_Contents`
--

INSERT INTO `Report_Contents` VALUES (221,1,8,'Summary Observations',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">GCG have performed the ATLAS™ screening utilising our corpus of previous assessment results and market trends we witness across the industry uncovering the following insights for Sample Digital Channels. - 1st August 2024</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Your largest impact by far is your Digital Channels followed closely by Payment Applications. There is a signifiant opportunity that can be realised as a result of decommissioning a percentage of these applications.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">There is also a significant reduction opportunity across your Keep/Hold applications in your Digital Channels and Payments Applications.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The Sample group transformation should seek to replace the decommissioned applications with more sustainable platforms, whilst also delivering reduction opportunities in the applications being retained.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">From previous assessments of similar software types, Software and Cloud &amp; Data Centre Services are major category areas where impact and efficiency can be gained. Focusing on Digital Channels and Payments and deep diving assessments utilising CEDAR™ assessments will identify the specific impacts and opportunities related to your applications.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">TThe estimated total reduction does not take into account the new platforms being introduced through your transformation. These will need to be assessed to provide an accurate view of your carbon impact.</p><br><ul style=\"{{\"><li><h6>48% of the impact, and 65% of your emission reduction opportunities could come from completing the decommissioning of your \'Sell/Retire\' application estate.</h6></li><li><h6>The greatest area of impact comes from your digital channel based applications, representing a 45% of all emissions.</h6></li><li><h6>The greatest reduction opportunity also comes from your digital channel based applications, equating to 50% of all emissions.</h6></li><li><h6>The greatest reduction opportunity in Use comes from your payments based applications, equating to 49% of total emissions.</h6></li></ul>'),(222,2,8,'Your Software Screening Summary',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<h5>Atlas TM Software Estimation</h5>'),(223,3,8,'Software Impact Analysis: Total',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<h5>The biggest carbon impact is estimated to be in your Digital Channels, focus on decarbonising these and your Payments Applications to maximise efficiency.</h5><br><h6 style=\"font-size: 18px; font-weight: 600; line-height= 2;\">From your application mapping, the following key screening estimation observations were found:</h6><br><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 45% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 21%.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Testing Applications is next highest number of applications v’s estimated impact size forming 8% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Mainframe which forms 9% , Other General &amp; Security which both form 8% and Other - Small Apps which form 1% of total emissions impact make up the remainder.</p>'),(224,4,8,'Software Impact Analysis: Decommission Only',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<h5>Focus on decommissioning applications, they are estimated to form over 48% of your total carbon emissions.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">From your application mapping, the following key screening estimation observations were found:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 50% of total emissions impact related to applications targeted for decommissioning.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 17%.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Testing Applications is next highest number of applications v’s estimated impact size forming 8% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Security &amp; Mainframe both forming 9% , Other General Apps forms 6% and Other - Small Apps forms 1% of total emissions impact have a positive relationship increasing in value together.</p>'),(225,5,8,'Software Impact Analysis: ICT Categories',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related impacts are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the cloud and data centre related emissions of Digital Channels and Payment Platforms, you could achieve up to 66% of total related reductions.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The remainder Mainframe, Security and Testing for cloud and data centre related emissions equates to 24% of the total related reductions.</p>'),(226,6,8,'Software Impact Analysis: SCOPE Categories',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related impacts are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the Scope 3 emissions related to Digital Channels and Payment Platforms you could achieve up to 66% of total related reductions.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The Scope 3 emissions for the remainder Mainframe, Security and Testing could help you achieve 30% of total related reductions.</p>'),(227,7,8,'Software Reduction Analysis: Release',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<h5>The significant reduction opportunities are expected to be realised in the release and iteration of your Digital Channels.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">From your application mapping, the following key screening estimation observations were found in Release phase:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 57% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 20% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">A cluster of Mainframe forming 10% , Other - General Apps forming 6% , Security forming 3% and Testing Applications forming 5% equates to a total remainder of 23% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Mainframe which forms 9% , Other General &amp; Security which both form 8% and Other - Small Apps which form 1% of total emissions impact make up the remainder.</p>'),(228,8,8,'Software Reduction Analysis: Use',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<h5>For your strategic applications, over 75% of the reduction opportunities in use phase areexpected from your Payments Applications and Digital Channels.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\"></h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payment Applications is by far the largest reduction opportunity in use forming 49% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels is next, forming 28% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Mainframe forms 9% and Other - General Apps forms 8% with the remainder Security Applications forming 3% of total emissions impact.</p>'),(229,9,8,'Software Reduction Estimates: ICT Categories',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related reductions are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the cloud and data centre related emissions of Digital Channels and Payments Applications, you could achieve up to 76% of total related reductions.</p>'),(230,10,8,'Software Reduction Estimates: SCOPE Categories',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following emission scope related reductions were observed:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the Scope 3 emissions related to Digital Channels and Payments Applications you could achieve up to 77% of total related reductions.</p>'),(231,11,8,'Software Screening - ICT Linkage Summary',1,'GCG','GCG','2024-08-01 10:11:09','2024-08-01 10:11:09','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">Mapping impact and action to the major ICT categories is key to determining areas to prioritise decarbonisation. The screening offers the following observations related to your software estate:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The greatest area of impact, 50% , is from software and people related emissions closely followed by Cloud and Data Centre Services at 35%.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Focusing on decommissioning the software you no longer need makes up nearly 66% of total reduction opportunities, with material savings in both Cloud and Data Centre and Software categories.</p>'),(232,1,9,'Summary Observations',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">GCG have performed the ATLAS™ screening utilising our corpus of previous assessment results and market trends we witness across the industry uncovering the following insights for Sample Digital Channels.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Your largest impact by far is your Digital Channels followed closely by Payment Applications. There is a signifiant opportunity that can be realised as a result of decommissioning a percentage of these applications.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">There is also a significant reduction opportunity across your Keep/Hold applications in your Digital Channels and Payments Applications.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The Sample group transformation should seek to replace the decommissioned applications with more sustainable platforms, whilst also delivering reduction opportunities in the applications being retained.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">From previous assessments of similar software types, Software and Cloud & Data Centre Services are major category areas where impact and efficiency can be gained. Focusing on Digital Channels and Payments and deep diving assessments utilising CEDAR™ assessments will identify the specific impacts and opportunities related to your applications.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">TThe estimated total reduction does not take into account the new platforms being introduced through your transformation. These will need to be assessed to provide an accurate view of your carbon impact.</p><br /><ul style={{ list-style: unset }}><li><h6>48% of the impact, and 65% of your emission reduction opportunities could come from completing the decommissioning of your \'Sell/Retire\' application estate.</h6></li><li><h6>The greatest area of impact comes from your digital channel based applications, representing a 45% of all emissions.</h6></li><li><h6>The greatest reduction opportunity also comes from your digital channel based applications, equating to 50% of all emissions.</h6></li><li><h6>The greatest reduction opportunity in Use comes from your payments based applications, equating to 49% of total emissions.</h6></li></ul>'),(233,2,9,'Your Software Screening Summary',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<h5>Atlas TM Software Estimation</h5>'),(234,3,9,'Software Impact Analysis: Total',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<h5>The biggest carbon impact is estimated to be in your Digital Channels, focus on decarbonising these and your Payments Applications to maximise efficiency.</h5><br /><h6 style=\"font-size: 18px; font-weight: 600; line-height= 2;\">From your application mapping, the following key screening estimation observations were found:</h6><br /><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 45% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 21%.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Testing Applications is next highest number of applications v’s estimated impact size forming 8% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Mainframe which forms 9% , Other General & Security which both form 8% and Other - Small Apps which form 1% of total emissions impact make up the remainder.</p>'),(235,4,9,'Software Impact Analysis: Decommission Only',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<h5>Focus on decommissioning applications, they are estimated to form over 48% of your total carbon emissions.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">From your application mapping, the following key screening estimation observations were found:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 50% of total emissions impact related to applications targeted for decommissioning.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 17%.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Testing Applications is next highest number of applications v’s estimated impact size forming 8% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Security & Mainframe both forming 9% , Other General Apps forms 6% and Other - Small Apps forms 1% of total emissions impact have a positive relationship increasing in value together.</p>'),(236,5,9,'Software Impact Analysis: ICT Categories',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related impacts are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the cloud and data centre related emissions of Digital Channels and Payment Platforms, you could achieve up to 66% of total related reductions.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The remainder Mainframe, Security and Testing for cloud and data centre related emissions equates to 24% of the total related reductions.</p>'),(237,6,9,'Software Impact Analysis: SCOPE Categories',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related impacts are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the Scope 3 emissions related to Digital Channels and Payment Platforms you could achieve up to 66% of total related reductions.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The Scope 3 emissions for the remainder Mainframe, Security and Testing could help you achieve 30% of total related reductions.</p>'),(238,7,9,'Software Reduction Analysis: Release',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<h5>The significant reduction opportunities are expected to be realised in the release and iteration of your Digital Channels.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">From your application mapping, the following key screening estimation observations were found in Release phase:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 57% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 20% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">A cluster of Mainframe forming 10% , Other - General Apps forming 6% , Security forming 3% and Testing Applications forming 5% equates to a total remainder of 23% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Mainframe which forms 9% , Other General & Security which both form 8% and Other - Small Apps which form 1% of total emissions impact make up the remainder.</p>'),(239,8,9,'Software Reduction Analysis: Use',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<h5>For your strategic applications, over 75% of the reduction opportunities in use phase areexpected from your Payments Applications and Digital Channels.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\"></h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payment Applications is by far the largest reduction opportunity in use forming 49% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels is next, forming 28% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Mainframe forms 9% and Other - General Apps forms 8% with the remainder Security Applications forming 3% of total emissions impact.</p>'),(240,9,9,'Software Reduction Estimates: ICT Categories',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related reductions are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the cloud and data centre related emissions of Digital Channels and Payments Applications, you could achieve up to 76% of total related reductions.</p>'),(241,10,9,'Software Reduction Estimates: SCOPE Categories',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following emission scope related reductions were observed:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the Scope 3 emissions related to Digital Channels and Payments Applications you could achieve up to 77% of total related reductions.</p>'),(242,11,9,'Software Screening - ICT Linkage Summary',1,'GCG','GCG','2024-08-02 11:48:35','2024-08-02 11:48:35','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">Mapping impact and action to the major ICT categories is key to determining areas to prioritise decarbonisation. The screening offers the following observations related to your software estate:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The greatest area of impact, 50% , is from software and people related emissions closely followed by Cloud and Data Centre Services at 35%.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Focusing on decommissioning the software you no longer need makes up nearly 66% of total reduction opportunities, with material savings in both Cloud and Data Centre and Software categories.</p>'),(353,1,10,'Summary Observations',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">GCG have performed the ATLAS™ screening utilising our corpus of previous assessment results and market trends we witness across the industry uncovering the following insights for Sample Digital Channels.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Your largest impact by far is your Digital Channels followed closely by Payment Applications. There is a signifiant opportunity that can be realised as a result of decommissioning a percentage of these applications.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">There is also a significant reduction opportunity across your Keep/Hold applications in your Digital Channels and Payments Applications.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The Sample group transformation should seek to replace the decommissioned applications with more sustainable platforms, whilst also delivering reduction opportunities in the applications being retained.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">From previous assessments of similar software types, Software and Cloud &amp; Data Centre Services are major category areas where impact and efficiency can be gained. Focusing on Digital Channels and Payments and deep diving assessments utilising CEDAR™ assessments will identify the specific impacts and opportunities related to your applications.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">TThe estimated total reduction does not take into account the new platforms being introduced through your transformation. These will need to be assessed to provide an accurate view of your carbon impact.</p><br><ul style=\"{{\"><li><h6>48% of the impact, and 65% of your emission reduction opportunities could come from completing the decommissioning of your \'Sell/Retire\' application estate.</h6></li><li><h6>The greatest area of impact comes from your digital channel based applications, representing a 45% of all emissions.</h6></li><li><h6>The greatest reduction opportunity also comes from your digital channel based applications, equating to 50% of all emissions.</h6></li><li><h6>The greatest reduction opportunity in Use comes from your payments based applications, equating to 49% of total emissions.</h6></li></ul>'),(354,2,10,'Your Software Screening Summary',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<h5>Atlas TM Software Estimation</h5>'),(355,3,10,'Software Impact Analysis: Total',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<h5>The biggest carbon impact is estimated to be in your Digital Channels, focus on decarbonising these and your Payments Applications to maximise efficiency.</h5><br><h6 style=\"font-size: 18px; font-weight: 600; line-height= 2;\">From your application mapping, the following key screening estimation observations were found:</h6><br><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 45% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 21%.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Testing Applications is next highest number of applications v’s estimated impact size forming 8% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Mainframe which forms 9% , Other General &amp; Security which both form 8% and Other - Small Apps which form 1% of total emissions impact make up the remainder.</p>'),(356,4,10,'Software Impact Analysis: Decommission Only',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<h5>Focus on decommissioning applications, they are estimated to form over 48% of your total carbon emissions.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">From your application mapping, the following key screening estimation observations were found:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 50% of total emissions impact related to applications targeted for decommissioning.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 17%.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Testing Applications is next highest number of applications v’s estimated impact size forming 8% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Security &amp; Mainframe both forming 9% , Other General Apps forms 6% and Other - Small Apps forms 1% of total emissions impact have a positive relationship increasing in value together.</p>'),(357,5,10,'Software Impact Analysis: ICT Categories',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related impacts are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the cloud and data centre related emissions of Digital Channels and Payment Platforms, you could achieve up to 66% of total related reductions.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The remainder Mainframe, Security and Testing for cloud and data centre related emissions equates to 24% of the total related reductions.</p>'),(358,6,10,'Software Impact Analysis: SCOPE Categories',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related impacts are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the Scope 3 emissions related to Digital Channels and Payment Platforms you could achieve up to 66% of total related reductions.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The Scope 3 emissions for the remainder Mainframe, Security and Testing could help you achieve 30% of total related reductions.</p>'),(359,7,10,'Software Reduction Analysis: Release',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<h5>The significant reduction opportunities are expected to be realised in the release and iteration of your Digital Channels.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">From your application mapping, the following key screening estimation observations were found in Release phase:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 57% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 20% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">A cluster of Mainframe forming 10% , Other - General Apps forming 6% , Security forming 3% and Testing Applications forming 5% equates to a total remainder of 23% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Mainframe which forms 9% , Other General &amp; Security which both form 8% and Other - Small Apps which form 1% of total emissions impact make up the remainder.</p>'),(360,8,10,'Software Reduction Analysis: Use',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<h5>For your strategic applications, over 75% of the reduction opportunities in use phase areexpected from your Payments Applications and Digital Channels.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\"></h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payment Applications is by far the largest reduction opportunity in use forming 49% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels is next, forming 28% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Mainframe forms 9% and Other - General Apps forms 8% with the remainder Security Applications forming 3% of total emissions impact.</p>'),(361,9,10,'Software Reduction Estimates: ICT Categories',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related reductions are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the cloud and data centre related emissions of Digital Channels and Payments Applications, you could achieve up to 76% of total related reductions.</p>'),(362,10,10,'Software Reduction Estimates: SCOPE Categories',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following emission scope related reductions were observed:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the Scope 3 emissions related to Digital Channels and Payments Applications you could achieve up to 77% of total related reductions.</p>'),(363,11,10,'Software Screening - ICT Linkage Summary',1,'GCG','GCG','2024-12-16 09:47:00','2024-12-16 09:47:00','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">Mapping impact and action to the major ICT categories is key to determining areas to prioritise decarbonisation. The screening offers the following observations related to your software estate:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The greatest area of impact, 50% , is from software and people related emissions closely followed by Cloud and Data Centre Services at 35%.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Focusing on decommissioning the software you no longer need makes up nearly 66% of total reduction opportunities, with material savings in both Cloud and Data Centre and Software categories.</p>'),(375,1,6,'Summary Observations',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\"><span style=\"font-family: &quot;Courier New&quot;, Courier, monospace;\">GCG have performed the ATLAS™ screening utilising our corpus of previous assessment results and market trends we witness across the industry uncovering the following insights for Sample Digital Channels.</span></p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">Your largest impact by far is your Digital Channels followed closely by Payment Applications. There is a signifiant opportunity that can be realised as a result of decommissioning a percentage of these applications.</p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">There is also a significant reduction opportunity across your Keep/Hold applications in your Digital Channels and Payments Applications.</p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">The Sample group transformation should seek to replace the decommissioned applications with more sustainable platforms, whilst also delivering reduction opportunities in the applications being retained.</p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">From previous assessments of similar software types, Software and Cloud &amp; Data Centre Services are major category areas where impact and efficiency can be gained. Focusing on Digital Channels and Payments and deep diving assessments utilising CEDAR™ assessments will identify the specific impacts and opportunities related to your applications.</p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">The estimated total reduction does not take into account the new platforms being introduced through your transformation. These will need to be assessed to provide an accurate view of your carbon impact.</p><br><ul style=\"{{\"><li><h6>48% of the impact, and 65% of your emission reduction opportunities could come from completing the decommissioning of your \'Sell/Retire\' application estate.</h6></li><li><h6>The greatest area of impact comes from your digital channel based applications, representing a 45% of all emissions.</h6></li><li><h6>The greatest reduction opportunity also comes from your digital channel based applications, equating to 50% of all emissions.</h6></li><li><h6>The greatest reduction opportunity in Use comes from your payments based applications, equating to 49% of total emissions.</h6></li></ul>'),(376,2,6,'Your Software Screening Summary',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<h5>Atlas TM Software Estimation Summary</h5>'),(377,3,6,'Software Impact Analysis: Total',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<h5><strong>The biggest carbon impact is estimated to be in your Digital Channels, focus on decarbonising these and your Payments Applications to maximise efficiency.</strong></h5><br><h6 style=\"font-weight: 600; font-size: 18px;\">From your application mapping, the following key screening estimation observations were found:</h6><br><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">Digital Channels form 45% of total emissions impact.</p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">Payments Applications is the next highest forming 21%.</p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">Testing Applications is next highest number of applications v’s estimated impact size forming 8% of total emissions impact.</p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">The cluster of Mainframe which forms 9% , Other General &amp; Security which both form 8% and Other - Small Apps which form 1% of total emissions impact make up the remainder.</p>'),(378,4,6,'Software Impact Analysis: Decommission Only',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<h5>Focus on decommissioning applications, they are estimated to form over 48% of your total carbon emissions.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">From your application mapping, the following key screening estimation observations were found:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 50% of total emissions impact related to applications targeted for decommissioning.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 17%.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Testing Applications is next highest number of applications v’s estimated impact size forming 8% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Security &amp; Mainframe both forming 9% , Other General Apps forms 6% and Other - Small Apps forms 1% of total emissions impact have a positive relationship increasing in value together.</p>'),(379,5,6,'Software Impact Analysis: ICT Categories',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related impacts are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the cloud and data centre related emissions of Digital Channels and Payment Platforms, you could achieve up to 66% of total related reductions.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The remainder Mainframe, Security and Testing for cloud and data centre related emissions equates to 24% of the total related reductions.</p>'),(380,6,6,'Software Impact Analysis: SCOPE Categories',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related impacts are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the Scope 3 emissions related to Digital Channels and Payment Platforms you could achieve up to 66% of total related reductions.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The Scope 3 emissions for the remainder Mainframe, Security and Testing could help you achieve 30% of total related reductions.</p>'),(381,7,6,'Software Reduction Analysis: Release',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<h5>The significant reduction opportunities are expected to be realised in the release and iteration of your Digital Channels.</h5><h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">From your application mapping, the following key screening estimation observations were found in Release phase:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Digital Channels form 57% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">Payments Applications is the next highest forming 20% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">A cluster of Mainframe forming 10% , Other - General Apps forming 6% , Security forming 3% and Testing Applications forming 5% equates to a total remainder of 23% of total emissions impact.</p><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">The cluster of Mainframe which forms 9% , Other General &amp; Security which both form 8% and Other - Small Apps which form 1% of total emissions impact make up the remainder.</p>'),(382,8,6,'Software Reduction Analysis: Use',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<h5>For your strategic applications, over 75% of the reduction opportunities in use phase areexpected from your Payments Applications and Digital Channels.</h5><h6 style=\"font-weight: 600; line-height: 2; font-size: 18px;\"><br></h6><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">Payment Applications is by far the largest reduction opportunity in use forming 49% of total emissions impact.</p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">Digital Channels is next, forming 28% of total emissions impact.</p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">Mainframe forms 9% and Other - General Apps forms 8% with the remainder Security Applications forming <strong>3%</strong> of total emissions impact.</p>'),(383,9,6,'Software Reduction Estimates: ICT Categories',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following key observations related to the flow through of ICT related reductions are:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the cloud and data centre related emissions of Digital Channels and Payments Applications, you could achieve up to 76% of total related reductions.</p>'),(384,10,6,'Software Reduction Estimates: SCOPE Categories',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<h6 style=\"font-size: 18px; font-weight: 600; line-height: 2;\">The following emission scope related reductions were observed:</h6><p style=\"font-size: 17px; font-weight: 500; line-height: 1.8;\">By targeting the Scope 3 emissions related to Digital Channels and Payments Applications you could achieve up to 77% of total related reductions.</p>'),(385,11,6,'Software Screening - ICT Linkage Summary',1,'GCG','GCG','2025-01-23 16:03:44','2025-01-23 16:03:44','<h6 style=\"font-weight: 600; line-height: 2; font-size: 18px;\"><span style=\"font-family: Helvetica, sans-serif;\">Mapping impact and action to the major ICT categories is key to determining areas to prioritise decarbonisation. The screening offers the following observations related to your software estate:</span></h6><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">The greatest area of impact, 50% , is from software and people related emissions closely followed by Cloud and Data Centre Services at 35%.</p><p style=\"font-weight: 500; line-height: 1.8; font-size: 17px;\">Focusing on decommissioning the software you no longer need makes up nearly 66% of total reduction opportunities, with material savings in both Cloud and Data Centre and Software categories.</p>');

--
-- Table structure for table `Reports`
--

CREATE TABLE `Reports` (
  `id` int NOT NULL AUTO_INCREMENT,
  `OrganizationId` int NOT NULL,
  `ProductId` int NOT NULL,
  `FormId` int NOT NULL,
  `ExcelLinks` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `EndPoint` varchar(255) NOT NULL,
  `AppID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `AppID` (`AppID`),
  CONSTRAINT `Reports_ibfk_1` FOREIGN KEY (`AppID`) REFERENCES `Applications` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Reports`
--

INSERT INTO `Reports` VALUES (8,68,2,2,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/8_27_Silk_Route_Sequoia_1.0_Sequoia_Form_V1.0_WebApplication.xlsx','2024-05-08 12:27:13','2024-05-08 12:27:13','8_27_Silk_Route_Sequoia_1.0_Sequoia_Form_V1.0_WebApplication.xlsx',NULL),(9,68,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/8_43_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_Accounting.xlsx','2024-05-08 12:43:31','2024-05-08 12:43:31','8_43_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_Accounting.xlsx',NULL),(10,68,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/8_48_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_CRM.xlsx','2024-05-08 12:48:50','2024-05-08 12:48:50','8_48_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_CRM.xlsx',NULL),(11,63,2,2,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/8_1_Citi_Corp_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaDesktopManagedServices.xlsx','2024-05-08 13:01:11','2024-05-08 13:01:11','8_1_Citi_Corp_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaDesktopManagedServices.xlsx',NULL),(12,68,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/8_22_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx','2024-05-08 16:22:33','2024-05-08 16:22:33','8_22_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx',NULL),(13,68,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/8_56_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx','2024-05-08 16:56:20','2024-05-08 16:56:20','8_56_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx',NULL),(14,68,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/8_9_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx','2024-05-08 17:09:48','2024-05-08 17:09:48','8_9_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx',NULL),(15,68,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/8_18_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx','2024-05-08 17:18:54','2024-05-08 17:18:54','8_18_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx',NULL),(16,3,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/9_40_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 05:40:20','2024-05-09 05:40:20','9_40_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(17,3,107,107,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_59_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 06:29:22','2024-05-09 06:29:22','9_59_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(18,3,107,107,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_0_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 06:30:17','2024-05-09 06:30:17','9_0_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(19,3,107,107,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_2_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 06:32:51','2024-05-09 06:32:51','9_2_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(20,3,107,107,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_13_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 06:43:53','2024-05-09 06:43:53','9_13_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(21,3,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/9_6_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 07:06:51','2024-05-09 07:06:51','9_6_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(22,3,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/9_10_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 07:10:27','2024-05-09 07:10:27','9_10_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(23,68,1,1,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_58_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx','2024-05-09 07:28:44','2024-05-09 07:28:44','9_58_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx',NULL),(24,68,1,1,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_59_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx','2024-05-09 07:29:30','2024-05-09 07:29:30','9_59_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx',NULL),(25,3,107,107,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_6_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 07:36:44','2024-05-09 07:36:44','9_6_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(26,68,1,1,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_21_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx','2024-05-09 07:51:34','2024-05-09 07:51:34','9_21_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx',NULL),(27,3,107,107,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_23_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 07:53:36','2024-05-09 07:53:36','9_23_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(28,3,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/9_52_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 08:52:23','2024-05-09 08:52:23','9_52_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(29,69,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/9_8_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 09:08:21','2024-05-09 09:08:21','9_8_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(30,69,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/9_12_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 09:12:43','2024-05-09 09:12:43','9_12_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(31,69,107,107,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_45_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 09:15:03','2024-05-09 09:15:03','9_45_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(32,69,107,107,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_55_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 09:25:09','2024-05-09 09:25:09','9_55_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(33,69,107,107,'D:\\Go-Code-Green\\GCG - DEV - API\\GCG - Backend\\excelFiles\\9_56_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 09:26:59','2024-05-09 09:26:59','9_56_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(34,3,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/9_10_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-09 10:10:58','2024-05-09 10:10:58','9_10_Modi_Xerox_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(35,63,2,2,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/9_23_Citi_Corp_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaDesktopManagedServices.xlsx','2024-05-09 11:23:24','2024-05-09 11:23:24','9_23_Citi_Corp_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaDesktopManagedServices.xlsx',NULL),(36,69,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/10_1_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-10 07:01:16','2024-05-10 07:01:16','10_1_HDFC_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(37,68,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/10_5_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx','2024-05-10 07:05:56','2024-05-10 07:05:56','10_5_Silk_Route_Cedar_4.0_Cedar_Form_V1.0_WebApplication.xlsx',NULL),(38,70,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/10_45_ICICI_Bank_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-05-10 10:45:03','2024-05-10 10:45:03','10_45_ICICI_Bank_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(39,70,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/19_30_ICICI_Bank_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-06-19 06:30:49','2024-06-19 06:30:49','19_30_ICICI_Bank_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(40,70,107,107,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/19_7_ICICI_Bank_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-06-19 07:07:21','2024-06-19 07:07:21','19_7_ICICI_Bank_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(41,74,107,107,'E:\\GCG\\GCG - Backend\\excelFiles\\8_44_Client4_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-07-08 08:14:01','2024-07-08 08:14:01','8_44_Client4_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(42,74,107,107,'E:\\GCG\\GCG - Backend\\excelFiles\\8_6_Client4_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx','2024-07-08 08:36:46','2024-07-08 08:36:46','8_6_Client4_Atlas_V1.0_Atlas_V1.0_AtlasScreeningEstimation.xlsx',NULL),(43,106,1,1,'E:\\Projects\\GCG\\GCG - Backend\\excelFiles\\19_53_IRFC_Cedar_4.0_Cedar_Form_V1.0_System.xlsx','2024-12-19 09:23:27','2024-12-19 09:23:27','19_53_IRFC_Cedar_4.0_Cedar_Form_V1.0_System.xlsx',NULL),(44,106,1,1,'E:\\Projects\\GCG\\GCG - Backend\\excelFiles\\19_55_IRFC_Cedar_4.0_Cedar_Form_V1.0_System.xlsx','2024-12-19 09:25:01','2024-12-19 09:25:01','19_55_IRFC_Cedar_4.0_Cedar_Form_V1.0_System.xlsx',NULL),(45,106,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/19_33_IRFC_Cedar_4.0_Cedar_Form_V1.0_System.xlsx','2024-12-19 09:33:14','2024-12-19 09:33:14','19_33_IRFC_Cedar_4.0_Cedar_Form_V1.0_System.xlsx',NULL),(46,106,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/19_36_IRFC_Cedar_4.0_Cedar_Form_V1.0_System.xlsx','2024-12-19 09:36:58','2024-12-19 09:36:58','19_36_IRFC_Cedar_4.0_Cedar_Form_V1.0_System.xlsx',NULL),(47,138,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\30_21_Fuji_Xerox_Cedar_4.0_Cedar_Form_V1.0_ICDBJapan.xlsx','2025-01-30 09:51:30','2025-01-30 09:51:30','30_21_Fuji_Xerox_Cedar_4.0_Cedar_Form_V1.0_ICDBJapan.xlsx',NULL),(48,162,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\2_4_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-02 05:34:23','2025-02-02 05:34:23','2_4_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',NULL),(49,162,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\3_59_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-03 16:29:17','2025-02-03 16:29:17','3_59_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',NULL),(50,162,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\3_0_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-03 16:30:57','2025-02-03 16:30:57','3_0_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',NULL),(51,162,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\3_7_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-03 16:37:48','2025-02-03 16:37:48','3_7_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',NULL),(52,162,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\3_10_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-03 16:40:16','2025-02-03 16:40:16','3_10_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',NULL),(53,162,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\3_16_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-03 16:46:10','2025-02-03 16:46:10','3_16_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',68),(54,162,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\3_18_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-03 16:48:57','2025-02-03 16:48:57','3_18_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',68),(55,162,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/4_15_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-04 05:15:32','2025-02-04 05:15:32','4_15_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',68),(56,138,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/4_14_Fuji_Xerox_Cedar_4.0_Cedar_Form_V1.0_ICDBJapan.xlsx','2025-02-04 06:14:15','2025-02-04 06:14:15','4_14_Fuji_Xerox_Cedar_4.0_Cedar_Form_V1.0_ICDBJapan.xlsx',60),(57,162,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/4_14_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-04 07:14:52','2025-02-04 07:14:52','4_14_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',68),(58,162,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/4_15_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-04 07:15:22','2025-02-04 07:15:22','4_15_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',68),(59,162,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\4_53_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-04 10:23:03','2025-02-04 10:23:03','4_53_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',68),(60,162,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\4_55_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-04 10:25:13','2025-02-04 10:25:13','4_55_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',68),(61,162,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/4_42_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-04 10:42:20','2025-02-04 10:42:20','4_42_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',68),(62,162,1,1,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\4_15_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-04 10:45:17','2025-02-04 10:45:17','4_15_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',68),(63,162,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/4_48_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx','2025-02-04 14:48:54','2025-02-04 14:48:54','4_48_Anshhh_Limited_Cedar_4.0_Cedar_Form_V1.0_MobileApplication.xlsx',68),(64,138,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/7_4_Fuji_Xerox_Cedar_4.0_Cedar_Form_V1.0_ICDBJapan.xlsx','2025-02-07 11:04:52','2025-02-07 11:04:52','7_4_Fuji_Xerox_Cedar_4.0_Cedar_Form_V1.0_ICDBJapan.xlsx',60),(65,164,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/8_30_ANSH_TECHNOLOGY_LTD_Cedar_4.0_Cedar_Form_V1.0_DesktopGamingApplication.xlsx','2025-02-08 12:30:18','2025-02-08 12:30:18','8_30_ANSH_TECHNOLOGY_LTD_Cedar_4.0_Cedar_Form_V1.0_DesktopGamingApplication.xlsx',70),(66,171,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/11_13_Hiscox_Cedar_4.0_Cedar_Form_V1.0_Unicorn.xlsx','2025-02-11 09:13:54','2025-02-11 09:13:54','11_13_Hiscox_Cedar_4.0_Cedar_Form_V1.0_Unicorn.xlsx',63),(67,164,2,2,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\17_33_ANSH_TECHNOLOGY_LTD_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaApplication.xlsx','2025-02-17 06:03:48','2025-02-17 06:03:48','17_33_ANSH_TECHNOLOGY_LTD_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaApplication.xlsx',NULL),(68,164,2,2,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\17_47_ANSH_TECHNOLOGY_LTD_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaApplication.xlsx','2025-02-17 07:17:46','2025-02-17 07:17:46','17_47_ANSH_TECHNOLOGY_LTD_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaApplication.xlsx',NULL),(69,164,2,2,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\17_55_ANSH_TECHNOLOGY_LTD_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaApplication.xlsx','2025-02-17 07:25:05','2025-02-17 07:25:05','17_55_ANSH_TECHNOLOGY_LTD_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaApplication.xlsx',NULL),(70,164,2,2,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/17_42_ANSH_TECHNOLOGY_LTD_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaApplication.xlsx','2025-02-17 07:42:58','2025-02-17 07:42:58','17_42_ANSH_TECHNOLOGY_LTD_Sequoia_1.0_Sequoia_Form_V1.0_SequoiaApplication.xlsx',NULL),(71,171,1,1,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/18_24_Hiscox_Cedar_4.0_Cedar_Form_V1.0_Unicorn.xlsx','2025-02-18 10:24:12','2025-02-18 10:24:12','18_24_Hiscox_Cedar_4.0_Cedar_Form_V1.0_Unicorn.xlsx',63),(72,164,111,109,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\20_13_ANSH_TECHNOLOGY_LTD_CYPRESS_CYPRESS_CypressApplication.xlsx','2025-02-20 05:43:21','2025-02-20 05:43:21','20_13_ANSH_TECHNOLOGY_LTD_CYPRESS_CYPRESS_CypressApplication.xlsx',NULL),(73,164,111,109,'E:\\Projects\\GOCODEGREEN\\BACK-END\\excelFiles\\20_40_ANSH_TECHNOLOGY_LTD_CYPRESS_CYPRESS_CypressApplication.xlsx','2025-02-20 06:10:38','2025-02-20 06:10:38','20_40_ANSH_TECHNOLOGY_LTD_CYPRESS_CYPRESS_CypressApplication.xlsx',NULL),(74,164,111,109,'/var/www/html/api.gcg-dev.misfitscommunications.com/excelFiles/20_19_ANSH_TECHNOLOGY_LTD_CYPRESS_CYPRESS_CypressApplication.xlsx','2025-02-20 07:19:11','2025-02-20 07:19:11','20_19_ANSH_TECHNOLOGY_LTD_CYPRESS_CYPRESS_CypressApplication.xlsx',NULL);

--
-- Table structure for table `Roles`
--

CREATE TABLE `Roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `roleName` varchar(255) NOT NULL,
  `roleDescription` text NOT NULL,
  `isActive` tinyint(1) NOT NULL,
  `createdBy` varchar(255) NOT NULL,
  `updatedBy` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Roles`
--

INSERT INTO `Roles` VALUES (1,'Super Admin','can create admins for all companies. Can create, edit and delete any data. Can create Editor of GCG who is responsible for editing reports. Can create Housekeeping for GCG who is responsible for archiving report, deleting old data etc.',1,'GCG','GCG','2024-02-27 07:47:05','2024-04-13 04:55:02'),(4,'Admin','Can create/edit/delete user for the company that the admin belongs to. Can edit and view reports.',0,'GCG','GCG','2024-02-27 07:54:42','2024-04-13 09:43:33'),(5,'GCG Author','Can upload spreadsheets on behalf of company/companies for generating reports',1,'GCG','GCG','2024-02-27 09:09:03','2024-04-13 09:43:43'),(6,'APIUser','Can fill-up the webform. Can run the API to process spreadsheets.',1,'GCG','GCG','2024-02-27 09:10:31','2024-05-10 05:35:11'),(7,'Editor','Can edit the reports of any client after data processing and before publishing of the report.',1,'GCG','GCG','2024-02-27 09:14:36','2024-02-27 09:14:36'),(8,'Housekeeping','Can delete old data after necessary approvals. Can archive old reports of clients.',0,'GCG','GCG','2024-02-27 09:15:58','2024-02-27 09:15:58');

--
-- Table structure for table `SchemaCodeValues`
--

CREATE TABLE `SchemaCodeValues` (
  `id` int NOT NULL AUTO_INCREMENT,
  `Value` float NOT NULL,
  `isActive` tinyint(1) NOT NULL,
  `createdBy` varchar(255) NOT NULL,
  `updatedBy` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `orgId` int NOT NULL,
  `productId` int NOT NULL,
  `schemaCode` varchar(255) NOT NULL,
  `applicationTypeId` int NOT NULL,
  `reportId` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `orgId_idx` (`orgId`),
  KEY `productId_idx` (`productId`),
  CONSTRAINT `SchemaCodeValues_ibfk_111` FOREIGN KEY (`orgId`) REFERENCES `Organizations` (`id`),
  CONSTRAINT `SchemaCodeValues_ibfk_112` FOREIGN KEY (`productId`) REFERENCES `Products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `SchemaCodeValues`
--

INSERT INTO `SchemaCodeValues` VALUES (1,2.5,1,'GCG','GCG','2024-05-06 10:51:50','2024-05-06 10:51:50',3,1,'DG-CI-PE-C-T20-00',1,1),(2,1.5,1,'GCG','GCG','2024-05-06 10:51:50','2024-05-06 10:51:50',3,1,'DG-CI-PE-C-PER-00',1,1);

--
-- Table structure for table `Schemas`
--

CREATE TABLE `Schemas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reportId` int NOT NULL,
  `Attribute1` varchar(255) NOT NULL,
  `Attribute2` varchar(255) NOT NULL,
  `Attribute3` varchar(255) NOT NULL,
  `Attribute4` varchar(255) NOT NULL,
  `Attribute5` varchar(255) NOT NULL,
  `Attribute6` varchar(255) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `isActive` tinyint(1) NOT NULL,
  `createdBy` varchar(255) NOT NULL,
  `updatedBy` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `reportId_idx` (`reportId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Schemas`
--

INSERT INTO `Schemas` VALUES (1,1,'Digital Product','Carbon Impact','Production Environment','Compute','tCO2e','','DG-CI-PE-C-T20-00',1,'GCG','GCG','2024-05-06 10:51:50','2024-05-06 10:51:50'),(2,107,'Digital Product','Carbon Impact','Production Environment','Compute','%','','DG-CI-PE-C-PER-00',1,'GCG','GCG','2024-05-06 10:51:50','0000-00-00 00:00:00');

--
-- Table structure for table `ScopeMapCategories`
--

CREATE TABLE `ScopeMapCategories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `scopeMapName` varchar(255) NOT NULL,
  `isActive` tinyint(1) NOT NULL,
  `createdBy` varchar(255) NOT NULL,
  `updatedBy` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ScopeMapCategories`
--

INSERT INTO `ScopeMapCategories` VALUES (1,'Scope 1',1,'GCG','GCG','2024-05-06 10:51:50','2024-05-06 10:51:50'),(2,'Scope 2',1,'GCG','GCG','2024-05-06 10:51:50','2024-05-06 10:51:50'),(3,'Scope 3',1,'GCG','GCG','2024-05-06 10:51:50','2024-05-06 10:51:50');

--
-- Table structure for table `Statuses`
--

CREATE TABLE `Statuses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `statusName` varchar(255) NOT NULL,
  `statusCode` varchar(255) NOT NULL,
  `statusDescription` varchar(255) NOT NULL,
  `isActive` tinyint(1) NOT NULL,
  `createdBy` varchar(255) NOT NULL,
  `updatedBy` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Statuses`
--

INSERT INTO `Statuses` VALUES (1,'Draft','D001','Report is in saved state',1,'GCG','GCG','2024-04-25 06:48:55','2024-04-25 06:48:55'),(2,'Published','P001','Report is published',1,'GCG','GCG','2024-05-08 12:27:13','2024-05-08 12:27:13'),(13,'Form submitted','1','form saved in database ',1,'','','2024-04-08 10:26:56','2024-04-08 10:28:18'),(15,'Form Reviewed','2','Form Reviewed By GCG',1,'','','2024-04-08 10:40:16','2024-04-08 10:40:53'),(21,'Form Approved','3','Form Approved by GCG',1,'','','2024-04-08 11:00:16','2024-04-08 11:00:51'),(26,'Report under Review','5','RUR',1,'','','2024-04-08 11:35:59','2024-04-08 11:36:26'),(28,'Form in Draft','F01','It is a draft',1,'GCG','GCG','2024-04-25 06:48:55','2024-04-25 06:48:55');

--
-- Table structure for table `SubGroupings`
--

CREATE TABLE `SubGroupings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subGroupName` varchar(255) NOT NULL,
  `subGroupDescription` varchar(255) NOT NULL,
  `isActive` tinyint(1) NOT NULL,
  `GroupId` int NOT NULL,
  `subGrpOrderId` int NOT NULL DEFAULT '0',
  `createdBy` varchar(255) NOT NULL,
  `updatedBy` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `GroupId` (`GroupId`),
  CONSTRAINT `SubGroupings_ibfk_1` FOREIGN KEY (`GroupId`) REFERENCES `Groupings` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1135 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `SubGroupings`
--

INSERT INTO `SubGroupings` VALUES (1,'General Server and hosting information','',1,3,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'General Server and hosting information','',1,4,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'General information','',1,7,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,'Server Information','',1,7,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'Hosting Information','',1,7,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,'Data Centre and Network Information','',1,7,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,'General Information','',1,2,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,'General Information','',1,90,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,'Server Information','',1,90,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,'Hosting Information','',1,90,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,'Data Centre and Network Information','',1,90,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,'General information','',1,8,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,'Hosting Information','',1,8,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(32,'Server Information','',1,8,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(33,'Data Centre and Network Information','',1,8,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(40,'People','',1,88,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(41,'Travel','',1,88,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(42,'Tools','',1,88,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(43,'People','',1,92,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(44,'Travel','',1,92,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(45,'Tools','',1,92,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(46,'Internal People','',1,94,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(47,'External People','',1,94,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(48,'Variables','',1,94,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(49,'Travel Internal Staff Related','',1,94,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(50,'Travel External Staff Related','',1,94,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(51,'Tooling','',1,94,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(52,'General Information','',1,100,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(53,'Hosting Information','',1,100,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(54,'Server Information','',1,100,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(55,'Data Centre and Network Information','',1,100,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(56,'General Information','',1,101,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(57,'Hosting Information','',1,101,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(58,'Server Information','',1,101,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(59,'Data Centre and Network Information','',1,101,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(60,'People','',1,102,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(61,'Travels','',1,102,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(62,'Tools','',1,102,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(63,'Engineering Factors','',1,6,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(64,'Engineering Factors','',1,103,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(65,'Engineering Factors','',1,10,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(66,'Engineering Factors','',1,93,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(99,'Dummy','',0,99,0,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(100,'People, Tools and Travels','',1,5,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(101,'CORE BANKING','CORE BANKING',1,104,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(102,'DEVELOPMENT PLATFORMS','DEVELOPMENT PLATFORMS',1,104,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(103,'DIGITAL CHANNEL','DIGITAL CHANNEL',1,104,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(104,'INTERNAL DATA PROCESSING','INTERNAL DATA PROCESSING',1,104,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(105,'MAINFRAME','MAINFRAME',1,104,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(106,'MICROSERVICES','MICROSERVICES',1,104,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(107,'PAYMENTS','PAYMENTS',1,104,7,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(108,'SAAS','SAAS',1,104,8,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(109,'SECURITY','SECURITY',1,104,9,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(110,'TESTING','TESTING',1,104,10,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(111,'TRADING & RISK ','TRADING & RISK ',1,104,11,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(112,'GRID COMPUTE','GRID COMPUTE',1,104,12,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(113,'REPORTING & ANALYTICS','REPORTING & ANALYTICS',1,104,13,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(114,'AI','AI',1,104,14,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(115,'OTHER GENERAL','OTHER GENERAL',1,104,15,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(116,'OTHER - SMALL','OTHER - SMALL',1,104,16,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(117,'CORE BANKING','CORE BANKING',1,105,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(118,'DEVELOPMENT PLATFORMS','DEVELOPMENT PLATFORMS',1,105,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(119,'DIGITAL CHANNEL','DIGITAL CHANNEL',1,105,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(120,'INTERNAL DATA PROCESSING','INTERNAL DATA PROCESSING',1,105,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(121,'MAINFRAME','MAINFRAME',1,105,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(122,'PAYMENTS','PAYMENTS',1,105,7,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(123,'SAAS','SAAS',1,105,8,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(124,'SECURITY','SECURITY',1,105,9,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(125,'TESTING','TESTING',1,105,10,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(126,'TRADING & RISK ','TRADING & RISK ',1,105,11,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(127,'GRID COMPUTE','GRID COMPUTE',1,105,12,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(128,'REPORTING & ANALYTICS','REPORTING & ANALYTICS',1,105,13,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(129,'AI','AI',1,105,14,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(130,'OTHER GENERAL','OTHER GENERAL',1,105,15,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(131,'OTHER - SMALL','OTHER - SMALL',1,105,16,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(132,'MICROSERVICES','MICROSERVICES',1,105,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(133,'Key Data Points','',1,23,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(134,'Desktop PCs','',1,106,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(135,'Thin Clients','',1,106,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(136,'Non-Standard Desktops','',1,106,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(137,'Screens','',1,106,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(138,'Laptops','',1,106,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(139,'VOIP Desktop Phones','',1,106,7,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(140,'Smartphones','',1,106,8,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(141,'Tablets','',1,106,9,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(142,'Printers','',1,106,10,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(147,'Operational Activities','',1,107,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1009,'Email and File Servers','',1,107,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1010,'RDS / Thin Client Servers','',1,107,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1011,'RDS Application Servers','',1,107,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1012,'Print Servers','',1,107,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1030,'Desktop PCs','',1,109,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1031,'Thin Clients','',1,109,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1032,'Non-Standard Desktops','',1,109,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1033,'Screens','',1,109,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1034,'Laptops','',1,109,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1035,'VOIP Desktop Phones','',1,109,7,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1036,'Smartphones','',1,109,8,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1037,'Tablets','',1,109,9,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1038,'Printers','',1,109,10,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1045,'Desktop PCs','',1,108,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1046,'Thin Clients','',1,108,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1047,'Non-Standard Desktops','',1,108,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1048,'Screens','',1,108,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1049,'Laptops','',1,108,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1050,'VOIP Desktop Phones','',1,108,7,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1051,'Smartphones','',1,108,8,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1052,'Tablets','',1,108,9,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1053,'Printers','',1,108,10,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1060,'Desktop PCs','',1,110,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1061,'Thin Clients','',1,110,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1062,'Non-Standard Desktops','',1,110,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1063,'Screens','',1,110,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1064,'Laptops','',1,110,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1065,'VOIP Desktop Phones','',1,110,7,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1066,'Smartphones','',1,110,8,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1067,'Tablets','',1,110,9,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1068,'Printers','',1,110,10,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1075,'Key Data Points - HO','',1,106,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1076,'Key Data Points - MDC','',1,107,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1077,'Key Data Points - Loc1','',1,108,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1078,'Key Data Points - Loc2','',1,109,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1079,'Key Data Points - Loc3','',1,110,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1080,'Key Data Points','',1,111,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1081,'Key Data Points - DCL1','',1,112,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1082,'Key Data Points - DCL2','',1,113,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1083,'Key Data Points - DCL3','',1,114,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1084,'Rack Cabinets','',1,112,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1085,'Tower Servers','',1,112,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1086,'Rack Servers','',1,112,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1087,'Blade Servers','',1,112,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1088,'Mid-Range Servers','',1,112,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1089,'Mainframe Servers','',1,112,7,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1090,'GPU Servers','',1,112,8,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1091,'Data Servers and Storage','',1,112,9,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1092,'On-Premise Private Cloud / HCI','',1,112,10,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1093,'Operational Activities','',1,112,11,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1094,'Racks Cabinets','',1,113,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1095,'Tower Servers','',1,113,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1096,'Rack Servers','',1,113,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1097,'Blade Servers','',1,113,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1098,'Mid-Range Servers','',1,113,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1099,'Mainframe Servers','',1,113,7,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1100,'GPU Servers','',1,113,8,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1101,'Data Servers and Storage','',1,113,9,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1102,'On-Premise Private Cloud / HCI','',1,113,10,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1103,'Operational Activities','',1,113,11,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1104,'Racks Cabinets','',1,114,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1105,'Tower Servers','',1,114,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1106,'Rack Servers','',1,114,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1107,'Blade Servers','',1,114,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1108,'Mid-Range Servers','',1,114,6,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1109,'Mainframe Servers','',1,114,7,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1110,'GPU Servers','',1,114,8,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1111,'Data Servers and Storage','',1,114,9,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1112,'On-Premise Private Cloud / HCI','',1,114,10,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1113,'Operational Activities','',1,114,11,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1114,'Key Data Points','',1,115,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1115,'Key Data Points - DCL','',1,116,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1116,'LAN - DCL','',1,116,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1117,'WAN - DCL','',1,116,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1118,'Servers - DCL','',1,116,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1119,'Operational Activities - DCL','',1,116,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1120,'Key Data Points - OL-1','',1,117,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1121,'LAN - OL-1','',1,117,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1122,'WAN - OL-1','',1,117,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1123,'Servers - OL-1','',1,117,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1124,'Operational Activities - OL-1','',1,117,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1125,'Key Data Points - OL-2','',1,118,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1126,'LAN - OL-2','',1,118,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1127,'WAN - OL-2','',1,118,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1128,'Servers - OL-2','',1,118,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1129,'Operational Activities - OL-2','',1,118,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1130,'Key Data Points - OL-3','',1,119,1,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1131,'LAN - OL-3','',1,119,2,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1132,'WAN - OL-3','',1,119,3,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1133,'Servers - OL-3','',1,119,4,'','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(1134,'Operational Activities - OL-3','',1,119,5,'','','0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `Use-General-Info1`
--

CREATE TABLE `Use-General-Info1` (
  `questionTitle` text,
  `questionDescription` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Use-General-Info1`
--

INSERT INTO `Use-General-Info1` VALUES ('If applicable, estimate the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs in the development server'),('Estimate the number of development environments originally installed','Enter the number of environments that were used for application development'),('State the location country where the development environments were installed','Enter the name of the country where development environments existed'),('Estimate the core build / release duration in working days','Enter the number of days spent in creating the original build of the application'),('Estimate the normal working hours per day - please select','Enter the working hours that an employee spend in office'),('State Hosting type for the original build - please select','Enter the hosting type for the application when it was built originally'),('Estimate the memory installed per environment (in GB)','Enter the total memory of the environment under consideration'),('Estimate the storage installed per environment (in TB)','Enter the total storage of the environment under consideration'),('Estimate the number of physical CPU provisioned in each test environment','Enter the total number of CPUs in test environment'),('If applicable, estimate the number of vCPU provisioned in each test environment','Enter the total number of virtual CPUs in test environment'),('Estimate the number of test environments installed ','Enter the total number of test environments installed'),('State the location country where the test environments are installed','Enter the name of the country where test environments are present'),('Estimate the core build / release duration in working days','Enter the number of days spent in testing the application'),('Estimate the normal working hours per day','Enter the working hours that an employee spend in office'),('State Hosting type for the original build - please select','Enter the hosting type for the application when it was built originally'),('Estimate the memory installed per environment (in GB)','Enter the total memory of the environment under consideration'),('Estimate the storage installed per environment (in TB)','Enter the total storage of the environment under consideration'),('State the main programming language used','Enter the programming language that was used for application development'),('Estimate the number of INTERNAL FTE - Enter data for Location 1','Enter the nuber of full time employees who worked on the application development'),('Estimate the number of INTERNAL FTE - Enter data for Location 2 if applicable','Enter the nuber of full time employees who worked on the application development'),('Estimate the number of INTERNAL FTE - Enter data for Location 3 if applicable','Enter the nuber of full time employees who worked on the application development'),('Estimate the number of EXTERNAL FTE - Enter data for Location 1 if applicable','Enter the nuber of full time employees who worked on the application development'),('Estimate the number of EXTERNAL FTE - Enter data for Location 2 if applicable','Enter the nuber of full time employees who worked on the application development'),('Estimate the number of EXTERNAL FTE - Enter data for Location 3 if applicable','Enter the nuber of full time employees who worked on the application development'),('Estimate the average % time allocated to the assessed product across all FTE','This value is calculated based on the data entered for full time employees'),('Estimate the % FTE in developer / software engineering roles from total FTE above','This value is calculated based on the data entered for full time employees'),('State the number of development servers','Enter the number of development servers used to build the application'),('State the server type used - please select','Select the kind of server used for development'),('State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced'),('Specify the main processor manufacturer - please select','Select the manufacturer who built the main processor'),('Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second'),('Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)'),('Specify the number of physical CPU provisioned in each development environment','Enter the number of CPUs present in the development servers'),('If applicable, specify the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs present in the development servers'),('State the operating system used - please select','Select the operating system running in the server'),('Specify the number of development environments installed','Enter the number of development environments used in the building of the application'),('State the location country where the development environments are installed','Enter the name of the country where test environments are present'),('State the region where the development environments are installed','Enter the name of the region in the country where test environments are present'),('State the city where the development environments are installed','Enter the name of the city in the country where test environments are present'),('State the core build / release duration in working days','Enter the number of days spent in testing the application'),('State the normal working hours per day - please select','Enter the working hours that an employee spend in office'),('State Hosting type - please select','Enter the hosting type for the application when it was built originally'),('State main CSP selected if on public cloud - please select','Select the name pf the main Cloud Service Provider'),('If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known','Select the machine family or tier or instance type as provided by Cloud service provoder'),('If hosting is via a CSP, state the number of instances provisioned','Enter the number of instances provided by the Cloud Service Provider'),('If hosting is via a CSP, state the workload type selected - leave blank if not known','Enter the workload type of the Cloud Service Provider'),('State the Power Usage Effectiveness (PUE) for the data centre','Enter the value for PUE of the data centre'),('State the average processor utilisation','Enter the percentage of time the processor is used to perform tasks.'),('State the memory installed per environment (in GB)','Enter the total memory of the environment under consideration'),('State the storage installed per environment (in TB)','Enter the total storage of the environment under consideration'),('State Storage type - please select','Select the storage type used for saving data'),('Data Traffic type - please select','Select the mode in which data move across the  network'),('Estimate the average data size per call (in KB)','Enter the amount of data used per call '),('Estimate the average number of data transfers per minute','Enter how much data is transferred in a minute'),('Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second'),('Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)'),('Specify the number of physical CPU provisioned in each development environment','Enter the total number of CPUs in test environment'),('If applicable, specify the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs in the development server'),('State the operating system used - please select','Select the operating system running in the server'),('Specify the number of development environments installed','Enter the number of development environments used in the building of the application'),('State the location country where the development environments are installed','Enter the name of the country where test environments are present'),('State the region where the development environments are installed','Enter the name of the region in the country where test environments are present'),('State the city where the development environments are installed','Enter the name of the city in the country where test environments are present'),('State the core build / release duration in working days','Enter the number of days spent in testing the application'),('State the normal working hours per day - please select','Enter the working hours that an employee spend in office'),('State Hosting type - please select','Enter the hosting type for the application when it was built originally'),('State main CSP selected if on public cloud - please select','Select the name pf the main Cloud Service Provider'),('If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known','Select the machine family or tier or instance type as provided by Cloud service provoder'),('If hosting is via a CSP, state the number of instances provisioned','Enter the number of instances provided by the Cloud Service Provider'),('If hosting is via a CSP, state the workload type selected - leave blank if not known','Enter the workload type of the Cloud Service Provider'),('State the Power Usage Effectiveness (PUE) for the data centre','Enter the value for PUE of the data centre'),('State the average processor utilisation','Enter the percentage of time the processor is used to perform tasks.'),('State the memory installed per environment (in GB)','Enter the total memory of the environment under consideration'),('State the storage installed per environment (in TB)','Enter the total storage of the environment under consideration'),('State Storage type - please select','Select the storage type used for saving data'),('Data Traffic type - please select','Select the mode in which data move across the  network'),('Estimate the average data size per call (in KB)','Enter the amount of data used per call '),('Estimate the average number of data transfers per minute','Enter how much data is transferred in a minute'),('Specify the main processor manufacturer','Select the manufacturer who built the main processor'),('State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced'),('State the server type used - please select','Select the kind of server used for development'),('State the number of test servers','Enter the number of test servers used to test the application'),('State the number of production servers','Enter the number of production servers for launching the application'),('State the server type used - please select','Select the kind of server used for development or testing of the application'),('State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced'),('Specify the main processor manufacturer - please select','Select the manufacturer who built the main processor'),('Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second'),('Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)'),('Specify whether software components are able to shutdown on idle or are able to use On-Demand Compute - please select',''),('If Yes to previous question, estimate the % of components able to shutdown on idle or utilise on-demand compute',''),('State the operating system used - please select','Select the operating system running in the server'),('Specify the number of Production environments installed','Enter the number of production environments used in the building of the application'),('State the location country where the production environments are installed','Enter the name of the country where production environments are present'),('State the region where the production environments are installed','Enter the name of the region in the country where production environments are present'),('State the city where the production environments are installed','Enter the name of the city in the country where production environments are present'),('State the product operating days per year','Enter the number of days the product or application is used in production'),('State the normal working hours per day - please select','Enter the number of hours employee spend in office in a day'),('State if hosted On-prem, Private Cloud or Public Cloud','Select the hosting type '),('State CSP selected if on public cloud','Select the name pf the main Cloud Service Provider'),('If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known','Select the machine family or tier or instance type as provided by Cloud service provoder'),('If hosting is via a CSP, state the number of instances provisioned','Enter the number of instances provided by the Cloud Service Provider'),('If hosting is via a CSP, state the workload type selected - leave blank if not known','Enter the workload type of the Cloud Service Provider'),('State the Power Usage Effectiveness (PUE) for the data centre','Enter the value for PUE of the data centre'),('State the average processor utilisation','Enter the percentage of time the processor is used to perform tasks.'),('State the memory installed per environment (in GB)','Enter the total memory of the environment under consideration'),('State the storage installed per environment (in TB)','Enter the total storage of the environment under consideration'),('State if storage is SSD or HDD','Select the storage type used for saving data'),('Is data traffic internal (on LAN) or external (on WAN)','Select the mode in which data move across the  network'),('Estimate the average data size per call (in KB)','Enter the amount of data used per call '),('Estimate the average number of data transfers per minute','Enter how much data is transferred in a minute'),('Specify the years since the application first went live','Enter the number of years since the application was launched'),('Specify the number of physical CPU provisioned in each prod environment','Enter the total number of CPUs in test environment'),('Specify the number of vCPU provisioned in each prod environment','Enter the number of virtual CPUs in the development server'),('Specify the number of disaster recovery environments provisioned','Enter the number of disaster recovery environments installed for this application'),('State the location country where the D/R environments are installed','Enter the name of the country where disaster recovery environment is present'),('State the region where the D/R environments are installed','Enter the name of the region in the country where disaster recovery environments are present'),('State the city where the D/R environments are installed','Enter the name of the city in the country where disaster recovery environments are present'),('State the D/R mode - please select','Select the disaster recovery mode'),('State the normal working hours per day','Enter the working hours that an employee spend in office'),('State the main programming language used','Enter the programming language that was used for application development'),('State the average Sustainable Software Engineering Assessment rating achieved for developers - please select',''),('Estimate the % of no-code assets used',''),('Estimate the % of code reuse ',''),('State the level of DevOps maturity - please select',''),('State the level of FinOps maturity - please select',''),('State the number of Developer, Test/Quality and directly associated product FTE in location',''),('State the number of Developer, Test/Quality and directly associated product FTE in location',''),('State the number of Developer, Test/Quality and directly associated product FTE in location',''),('State the number of Developer, Test/Quality and directly associated product FTE in location',''),('State the number of Developer, Test/Quality and directly associated product FTE in location',''),('State the number of Developer, Test/Quality and directly associated product FTE in location',''),('Estimate the average % time allocated to the assessed product across all FTE',''),('Estimate the % FTE in developer / software engineering roles from total FTE above',''),('State timeframe (working months)',''),('State calculated Scope 1 emissions per employee if known in tCO2e',''),('State calculated Scope 2 emissions per employee if known in tCO2e',''),('State calculated Scope 3 emissions per employee if known oil tCO2e',''),('Estimate total number of airmiles travelled during product phase',''),('Estimate the number of commute bus trips per person per day',''),('Estimate the number of commute train trips per person per day',''),('Estimate the number of commute car trips per person per day',''),('Estimate % time WFH',''),('Estimate % of time spent working from owned office premises vs. Third party facilities (e.g. WeWork)',''),('Select main video collaboration tool used',''),('Estimate the average hours per day using video collaboration tools',''),('State the main software development platform / code repository used - please select',''),('State the main Application Performance Monitoring (APM) tool used - please select',''),('State the main automated / continuous testing tool used - please select',''),('INTERNAL FTE - Enter data for Location 1',''),('INTERNAL FTE - Enter data for Location 2 if applicable',''),('INTERNAL FTE - Enter data for Location 3 if applicable',''),('EXTERNAL FTE- Enter data for Location 1 if applicable',''),('EXTERNAL FTE - Enter data for Location 2 if applicable',''),('EXTERNAL FTE - Enter data for Location 3 if applicable',''),('Estimate the average % time allocated to the assessed product across all FTE',''),('Estimate the % FTE in developer / software engineering roles from total FTE above',''),('Specifiy Time (months) effort to decommission applications',''),('Estimate total number of airmiles travelled during product phase',''),('Estimate the number of commute bus trips per person per day',''),('Estimate the number of commute train trips per person per day',''),('Estimate the number of commute car trips per person per day',''),('Estimate total number of airmiles travelled during product phase',''),('Estimate the number of commute bus trips per person per day',''),('Estimate the number of commute train trips per person per day',''),('Estimate the number of commute car trips per person per day',''),('Select main video collaboration tool used',''),('Estimate the average hours per day using video collaboration tools',''),('Please provide your company name',''),('Please provide the name of your software product / platform',''),('Please state the type of software product being assessed - please select',''),('Please add the date of the assessment',''),('Scope Mapping Category',''),('Specify service provider or team name',''),('Specify the country in which Office / Data Centre is located',''),('Specify the city in which Office / Data Centre is located',''),('Specify region / state in which the Office / Data Centre is located',''),('Estimate number of business users in each location',''),('Estimate the % of time employees spend in the office',''),('State business working days in year',''),('State normal working hours per day',''),('State the current EPC rating for Office locations / PUE for Data Centre',''),('Specify the location',''),('Years since product first went live',''),('Estimated number of users/customers of product',''),('Estimated volume of transactions/engagements per annum',''),('Are the Development, Test, and Production environments in the same location?',''),('If answer to the above question is Yes, please select the location here',''),('Is the hosting type the same for Development, Test, and Production environments?',''),('If the answer to the above question is Yes, please select the hosting type here',''),('What type of assessment you want to take - Please select',''),('Do you want to do End of Life Assessment ?',''),('State Hosting type for the original build - please select',''),('Estimate the number of physical CPU provisioned in each development environment','Enter the total number of CPUs in test environment'),('If applicable, estimate the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs in the development server'),('Estimate the memory installed per environment (in GB)',''),('Estimate the storage installed per environment (in TB)',''),('Estimate the number of development environments originally installed',''),('State the location country where the development environments were installed',''),('Estimate the core build / release duration in working days',''),('Estimate the normal working hours per day - please select',''),('State Hosting type for the original build - please select',''),('Estimate the number of physical CPU provisioned in each Test environment','Enter the total number of CPUs in test environment'),('If applicable, estimate the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs in the development server'),('Estimate the memory installed per environment (in GB)',''),('Estimate the storage installed per environment (in TB)',''),('State the location country where the Test environments were installed',''),('Estimate the core build / release duration in working days',''),('Estimate the normal working hours per day - please select',''),('Estimate the number of Test environments originally installed',''),('How many locations were used for development and testing?',''),('Estimate the number of INTERNAL FTE - ',''),('Estimate the number of EXTERNAL FTE - ',''),('Estimate the average % time allocated to the assessed product across all FTE ',''),('Estimate the % FTE in developer / software engineering roles from total FTE above ',''),('State the main programming language used','Enter the programming language that was used for application development'),('If hosting is via a CSP and serverless, state average COMPUTE HOURS per day',''),('Estimate the normal working hours per day - please select',''),('Specify the number of development environments installed','Enter the number of development environments used in the building of the application'),('State the location country where the development environments are installed',''),('State the region where the development environments are installed',''),('State the city where the development environments are installed',''),('State the core build / release duration in working days',''),('If applicable, specify the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs in the development server'),('State Hosting type - please select',''),('State main CSP selected if on public cloud - please select',''),('If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known',''),('If hosting is via a CSP, state the number of instances provisioned',''),('If hosting is via a CSP, state the workload type selected - leave blank if not known',''),('Specify the number of physical CPU provisioned in each development environment','Enter the total number of CPUs in test environment'),('If hosting is via a CSP and serverless, state average COMPUTE HOURS per day',''),('State the number of development servers',''),('State the server type used - please select',''),('State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced'),('Specify the main processor manufacturer - please select',''),('Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second'),('Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)'),('State the operating system used - please select','Select the operating system running in the server'),('State the average processor utilisation',''),('State the memory installed per environment (in GB)',''),('State the storage installed per environment (in TB)',''),('State Storage type - please select','Select the storage type used for saving data'),('State the Power Usage Effectiveness (PUE) for the data centre',''),('Data Traffic type - please select',''),('Estimate the average data size per call (in KB)',''),('Estimate the average number of data transfers per minute',''),('Enter Internal FTE for ',''),('Enter External FTE for ',''),('Estimate the average % time allocated to the assessed product across all FTE',''),('Estimate the % FTE in developer / software engineering roles from total FTE above',''),('State timeframe (working months)  (Full Assessment ->State the core build / release duration in working days) /12',''),('Estimate total number of airmiles travelled during product phase',''),('Estimate the number of commute bus trips per person per day',''),('Estimate the number of commute train trips per person per day',''),('Estimate the number of commute car trips per person per day',''),('Estimate % time WFH',''),('Estimate % of time spent working from owned office premises vs. Third party facilities (e.g. WeWork)',''),('Select main video collaboration tool used',''),('Estimate the average hours per day using video collaboration tools',''),('State the main software development platform / code repository used - please select',''),('State the main Application Performance Monitoring (APM) tool used - please select',''),('State the main automated / continuous testing tool used - please select',''),('State the normal working hours per day',''),('State the main programming language used','Enter the programming language that was used for application development'),('State the average Sustainable Software Engineering Assessment rating achieved for developers - please select',''),('Estimate the % of no-code assets used',''),('Estimate the % of code reuse ',''),('State the level of DevOps maturity - please select',''),('State the level of FinOps maturity - please select',''),('Estimate the normal working hours per day - please select',''),('Specify the number of production environments installed',''),('State the location country where the  production environments are installed',''),('State the region where the  production environments are installed',''),('State the city where the production environments are installed',''),('State the core build / release duration in working days',''),('State the number of  production servers',''),('State the server type used - please select',''),('State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced'),('Specify the main processor manufacturer - please select',''),('Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second'),('Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)'),('State the operating system used - please select','Select the operating system running in the server'),('State the average processor utilisation',''),('State the memory installed per environment (in GB)',''),('State the storage installed per environment (in TB)',''),('State Storage type - please select','Select the storage type used for saving data'),('If applicable, specify the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs in the development server'),('State Hosting type - please select',''),('State main CSP selected if on public cloud - please select',''),('If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known',''),('If hosting is via a CSP, state the number of instances provisioned',''),('If hosting is via a CSP, state the workload type selected - leave blank if not known',''),('Specify the number of physical CPU provisioned in each development environment','Enter the total number of CPUs in test environment'),('If hosting is via a CSP and serverless, state average COMPUTE HOURS per day',''),('State the Power Usage Effectiveness (PUE) for the data centre',''),('Data Traffic type - please select',''),('Estimate the average data size per call (in KB)',''),('Estimate the average number of data transfers per minute',''),('Enter Internal FTE for ',''),('Enter External FTE for ',''),('Estimate the average % time allocated to the assessed product across all FTE',''),('Estimate the % FTE in developer / software engineering roles from total FTE above',''),('State timeframe (working months)  (Full Assessment ->State the core build / release duration in working days) /12',''),('Estimate total number of airmiles travelled during product phase',''),('Estimate the number of commute bus trips per person per day',''),('Estimate the number of commute train trips per person per day',''),('Estimate the number of commute car trips per person per day',''),('Estimate % time WFH',''),('Estimate % of time spent working from owned office premises vs. Third party facilities (e.g. WeWork)',''),('Select main video collaboration tool used',''),('Estimate the average hours per day using video collaboration tools',''),('State the main software development platform / code repository used - please select',''),('State the main Application Performance Monitoring (APM) tool used - please select',''),('State the main automated / continuous testing tool used - please select',''),('State the normal working hours per day',''),('State the main programming language used','Enter the programming language that was used for application development'),('State the average Sustainable Software Engineering Assessment rating achieved for developers - please select',''),('Estimate the % of no-code assets used',''),('Estimate the % of code reuse ',''),('State the level of DevOps maturity - please select',''),('State the level of FinOps maturity - please select',''),('Internal FTE - Enter data for',''),('External FTE - Enter data for ',''),('Estimate the average % time allocated to the assessed product across all FTE',''),('Estimate the % FTE in developer / software engineering roles from total FTE above',''),('Specifiy Time (months) effort to decommission applications',''),('Estimate total number of airmiles travelled during product phase',''),('Estimate the number of commute bus trips per person per day',''),('Estimate the number of commute train trips per person per day',''),('Estimate the number of commute car trips per person per day',''),('Estimate total number of airmiles travelled during product phase',''),('Estimate the number of commute bus trips per person per day',''),('Estimate the number of commute train trips per person per day',''),('Estimate the number of commute car trips per person per day',''),('Select main video collaboration tool used',''),('Estimate the average hours per day using video collaboration tools',''),('Estimate the normal working hours per day - please select',''),('Specify the number of development environments installed','Enter the number of development environments used in the building of the application'),('State the location country where the  development environments are installed',''),('State the region where the  development environments are installed',''),('State the city where the development environments are installed',''),('State the core build / release duration in working days',''),('If applicable, specify the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs in the development server'),('State Hosting type - please select',''),('State main CSP selected if on public cloud - please select',''),('If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known',''),('If hosting is via a CSP, state the number of instances provisioned',''),('If hosting is via a CSP, state the workload type selected - leave blank if not known',''),('Specify the number of physical CPU provisioned in each development environment','Enter the total number of CPUs in test environment'),('If hosting is via a CSP and serverless, state average COMPUTE HOURS per day',''),('State the number of development servers',''),('State the server type used - please select',''),('State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced'),('Specify the main processor manufacturer - please select',''),('Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second'),('Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)'),('State the operating system used - please select','Select the operating system running in the server'),('State the average processor utilisation',''),('State the memory installed per environment (in GB)',''),('State the storage installed per environment (in TB)',''),('State Storage type - please select','Select the storage type used for saving data'),('State the Power Usage Effectiveness (PUE) for the data centre',''),('Data Traffic type - please select',''),('Estimate the average data size per call (in KB)',''),('Estimate the average number of data transfers per minute',''),('Enter Internal FTE for ',''),('Enter External FTE for ',''),('Estimate the average % time allocated to the assessed product across all FTE',''),('Estimate the % FTE in developer / software engineering roles from total FTE above',''),('State timeframe (working months)  (Full Assessment ->State the core build / release duration in working days) /12',''),('Estimate total number of airmiles travelled during product phase',''),('Estimate the number of commute bus trips per person per day',''),('Estimate the number of commute train trips per person per day',''),('Estimate the number of commute car trips per person per day',''),('Estimate % time WFH',''),('Estimate % of time spent working from owned office premises vs. Third party facilities (e.g. WeWork)',''),('Select main video collaboration tool used',''),('Estimate the average hours per day using video collaboration tools',''),('State the main software development platform / code repository used - please select',''),('State the main Application Performance Monitoring (APM) tool used - please select',''),('State the main automated / continuous testing tool used - please select',''),('State the normal working hours per day',''),('State the main programming language used','Enter the programming language that was used for application development'),('State the average Sustainable Software Engineering Assessment rating achieved for developers - please select',''),('Estimate the % of no-code assets used',''),('Estimate the % of code reuse ',''),('State the level of DevOps maturity - please select',''),('State the level of FinOps maturity - please select',''),('Estimate the normal working hours per day - please select',''),('Specify the number of test environments installed',''),('State the location country where the  test environments are installed',''),('State the region where the  test environments are installed',''),('State the city where the test environments are installed',''),('State the core build / release duration in working days',''),('If applicable, specify the number of vCPU provisioned in each test environment','Enter the number of virtual CPUs in the development server'),('State Hosting type - please select',''),('State main CSP selected if on public cloud - please select',''),('If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known',''),('If hosting is via a CSP, state the number of instances provisioned',''),('If hosting is via a CSP, state the workload type selected - leave blank if not known',''),('Specify the number of physical CPU provisioned in each test environment','Enter the total number of CPUs in test environment'),('If hosting is via a CSP and serverless, state average COMPUTE HOURS per day',''),('State the number of test servers',''),('State the server type used - please select',''),('State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced'),('Specify the main processor manufacturer - please select',''),('Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second'),('Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)'),('State the operating system used - please select','Select the operating system running in the server'),('State the average processor utilisation',''),('State the memory installed per environment (in GB)',''),('State the storage installed per environment (in TB)',''),('State Storage type - please select','Select the storage type used for saving data'),('State the Power Usage Effectiveness (PUE) for the data centre',''),('Data Traffic type - please select',''),('Estimate the average data size per call (in KB)',''),('Estimate the average number of data transfers per minute','');

--
-- Table structure for table `aws_processor_data`
--

CREATE TABLE `aws_processor_data` (
  `idaws_processor_data` int NOT NULL AUTO_INCREMENT,
  `instance_type` varchar(45) DEFAULT NULL,
  `memory` varchar(45) DEFAULT NULL,
  `processor_type` varchar(45) DEFAULT NULL,
  `processor` varchar(45) DEFAULT NULL,
  `vCPUs` varchar(45) DEFAULT NULL,
  `CPU_cores` varchar(45) DEFAULT NULL,
  `threads_per_core` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idaws_processor_data`)
) ENGINE=InnoDB AUTO_INCREMENT=222 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `aws_processor_data`
--

INSERT INTO `aws_processor_data` VALUES (1,'m5.large','8','Intel (x86_64)','Intel Xeon Platinum 8175','2','1','2'),(2,'m5.xlarge','16','Intel (x86_64)','Intel Xeon Platinum 8175','4','2','2'),(3,'m5.2xlarge','32','Intel (x86_64)','Intel Xeon Platinum 8175','8','4','2'),(4,'m5.4xlarge','64','Intel (x86_64)','Intel Xeon Platinum 8175','16','8','2'),(5,'m5.8xlarge','128','Intel (x86_64)','Intel Xeon Platinum 8175','32','16','2'),(6,'m5.12xlarge','192','Intel (x86_64)','Intel Xeon Platinum 8175','48','24','2'),(7,'m5.16xlarge','256','Intel (x86_64)','Intel Xeon Platinum 8175','64','32','2'),(8,'m5.24xlarge','384','Intel (x86_64)','Intel Xeon Platinum 8175','96','48','2'),(9,'m5.metal','384','Intel (x86_64)','Intel Xeon Platinum 8175','96','48','2'),(10,'m5a.large','8','AMD (x86_64)','AMD EPYC 7571','2','1','2'),(11,'m5a.xlarge','16','AMD (x86_64)','AMD EPYC 7571','4','2','2'),(12,'m5a.2xlarge','32','AMD (x86_64)','AMD EPYC 7571','8','4','2'),(13,'m5a.4xlarge','64','AMD (x86_64)','AMD EPYC 7571','16','8','2'),(14,'m5a.8xlarge','128','AMD (x86_64)','AMD EPYC 7571','32','16','2'),(15,'m5a.12xlarge','192','AMD (x86_64)','AMD EPYC 7571','48','24','2'),(16,'m5a.16xlarge','256','AMD (x86_64)','AMD EPYC 7571','64','32','2'),(17,'m5a.24xlarge','384','AMD (x86_64)','AMD EPYC 7571','96','48','2'),(18,'m5ad.large','8','AMD (x86_64)','AMD EPYC 7571','2','1','2'),(19,'m5ad.xlarge','16','AMD (x86_64)','AMD EPYC 7571','4','2','2'),(20,'m5ad.2xlarge','32','AMD (x86_64)','AMD EPYC 7571','8','4','2'),(21,'m5ad.4xlarge','64','AMD (x86_64)','AMD EPYC 7571','16','8','2'),(22,'m5ad.8xlarge','128','AMD (x86_64)','AMD EPYC 7571','32','16','2'),(23,'m5ad.12xlarge','192','AMD (x86_64)','AMD EPYC 7571','48','24','2'),(24,'m5ad.16xlarge','256','AMD (x86_64)','AMD EPYC 7571','64','32','2'),(25,'m5ad.24xlarge','384','AMD (x86_64)','AMD EPYC 7571','96','48','2'),(26,'m5d.large','8','Intel (x86_64)','Intel Xeon Platinum 8175','2','1','2'),(27,'m5d.xlarge','16','Intel (x86_64)','Intel Xeon Platinum 8175','4','2','2'),(28,'m5d.2xlarge','32','Intel (x86_64)','Intel Xeon Platinum 8175','8','4','2'),(29,'m5d.4xlarge','64','Intel (x86_64)','Intel Xeon Platinum 8175','16','8','2'),(30,'m5d.8xlarge','128','Intel (x86_64)','Intel Xeon Platinum 8175','32','16','2'),(31,'m5d.12xlarge','192','Intel (x86_64)','Intel Xeon Platinum 8175','48','24','2'),(32,'m5d.16xlarge','256','Intel (x86_64)','Intel Xeon Platinum 8175','64','32','2'),(33,'m5d.24xlarge','384','Intel (x86_64)','Intel Xeon Platinum 8175','96','48','2'),(34,'m5d.metal','384','Intel (x86_64)','Intel Xeon Platinum 8175','96','48','2'),(35,'m5dn.large','8','Intel (x86_64)','Intel Xeon Platinum 8259','2','1','2'),(36,'m5dn.xlarge','16','Intel (x86_64)','Intel Xeon Platinum 8259','4','2','2'),(37,'m5dn.2xlarge','32','Intel (x86_64)','Intel Xeon Platinum 8259','8','4','2'),(38,'m5dn.4xlarge','64','Intel (x86_64)','Intel Xeon Platinum 8259','16','8','2'),(39,'m5dn.8xlarge','128','Intel (x86_64)','Intel Xeon Platinum 8259','32','16','2'),(40,'m5dn.12xlarge','192','Intel (x86_64)','Intel Xeon Platinum 8259','48','24','2'),(41,'m5dn.16xlarge','256','Intel (x86_64)','Intel Xeon Platinum 8259','64','32','2'),(42,'m5dn.24xlarge','384','Intel (x86_64)','Intel Xeon Platinum 8259','96','48','2'),(43,'m5dn.metal','384','Intel (x86_64)','Intel Xeon Platinum 8259','96','48','2'),(44,'m5n.large','8','Intel (x86_64)','Intel Xeon Platinum 8259','2','1','2'),(45,'m5n.xlarge','16','Intel (x86_64)','Intel Xeon Platinum 8259','4','2','2'),(46,'m5n.2xlarge','32','Intel (x86_64)','Intel Xeon Platinum 8259','8','4','2'),(47,'m5n.4xlarge','64','Intel (x86_64)','Intel Xeon Platinum 8259','16','8','2'),(48,'m5n.8xlarge','128','Intel (x86_64)','Intel Xeon Platinum 8259','32','16','2'),(49,'m5n.12xlarge','192','Intel (x86_64)','Intel Xeon Platinum 8259','48','24','2'),(50,'m5n.16xlarge','256','Intel (x86_64)','Intel Xeon Platinum 8259','64','32','2'),(51,'m5n.24xlarge','384','Intel (x86_64)','Intel Xeon Platinum 8259','96','48','2'),(52,'m5n.metal','384','Intel (x86_64)','Intel Xeon Platinum 8259','96','48','2'),(53,'m5zn.large','8','Intel (x86_64)','Intel Xeon Platinum 8252','2','1','2'),(54,'m5zn.xlarge','16','Intel (x86_64)','Intel Xeon Platinum 8252','4','2','2'),(55,'m5zn.2xlarge','32','Intel (x86_64)','Intel Xeon Platinum 8252','8','4','2'),(56,'m5zn.3xlarge','48','Intel (x86_64)','Intel Xeon Platinum 8252','12','6','2'),(57,'m5zn.6xlarge','96','Intel (x86_64)','Intel Xeon Platinum 8252','24','12','2'),(58,'m5zn.12xlarge','192','Intel (x86_64)','Intel Xeon Platinum 8252','48','24','2'),(59,'m5zn.metal','192','Intel (x86_64)','Intel Xeon Platinum 8252','48','24','2'),(60,'m6a.large','8','AMD (x86_64)','AMD EPYC 7R13','2','1','2'),(61,'m6a.xlarge','16','AMD (x86_64)','AMD EPYC 7R13','4','2','2'),(62,'m6a.2xlarge','32','AMD (x86_64)','AMD EPYC 7R13','8','4','2'),(63,'m6a.4xlarge','64','AMD (x86_64)','AMD EPYC 7R13','16','8','2'),(64,'m6a.8xlarge','128','AMD (x86_64)','AMD EPYC 7R13','32','16','2'),(65,'m6a.12xlarge','192','AMD (x86_64)','AMD EPYC 7R13','48','24','2'),(66,'m6a.16xlarge','256','AMD (x86_64)','AMD EPYC 7R13','64','32','2'),(67,'m6a.24xlarge','384','AMD (x86_64)','AMD EPYC 7R13','96','48','2'),(68,'m6a.32xlarge','512','AMD (x86_64)','AMD EPYC 7R13','128','64','2'),(69,'m6a.48xlarge','768','AMD (x86_64)','AMD EPYC 7R13','192','96','2'),(70,'m6a.metal','768','AMD (x86_64)','AMD EPYC 7R13','192','96','2'),(71,'m6g.medium','4','AWS Graviton (arm64)','AWS Graviton2 processor','1','1','1'),(72,'m6g.large','8','AWS Graviton (arm64)','AWS Graviton2 processor','2','2','1'),(73,'m6g.xlarge','16','AWS Graviton (arm64)','AWS Graviton2 processor','4','4','1'),(74,'m6g.2xlarge','32','AWS Graviton (arm64)','AWS Graviton2 processor','8','8','1'),(75,'m6g.4xlarge','64','AWS Graviton (arm64)','AWS Graviton2 processor','16','16','1'),(76,'m6g.8xlarge','128','AWS Graviton (arm64)','AWS Graviton2 processor','32','32','1'),(77,'m6g.12xlarge','192','AWS Graviton (arm64)','AWS Graviton2 processor','48','48','1'),(78,'m6g.16xlarge','256','AWS Graviton (arm64)','AWS Graviton2 processor','64','64','1'),(79,'m6g.metal','256','AWS Graviton (arm64)','AWS Graviton2 processor','64','64','1'),(80,'m6gd.medium','4','AWS Graviton (arm64)','AWS Graviton2 processor','1','1','1'),(81,'m6gd.large','8','AWS Graviton (arm64)','AWS Graviton2 processor','2','2','1'),(82,'m6gd.xlarge','16','AWS Graviton (arm64)','AWS Graviton2 processor','4','4','1'),(83,'m6gd.2xlarge','32','AWS Graviton (arm64)','AWS Graviton2 processor','8','8','1'),(84,'m6gd.4xlarge','64','AWS Graviton (arm64)','AWS Graviton2 processor','16','16','1'),(85,'m6gd.8xlarge','128','AWS Graviton (arm64)','AWS Graviton2 processor','32','32','1'),(86,'m6gd.12xlarge','192','AWS Graviton (arm64)','AWS Graviton2 processor','48','48','1'),(87,'m6gd.16xlarge','256','AWS Graviton (arm64)','AWS Graviton2 processor','64','64','1'),(88,'m6gd.metal','256','AWS Graviton (arm64)','AWS Graviton2 processor','64','64','1'),(89,'m6i.large','8','Intel (x86_64)','Intel Xeon Ice Lake','2','1','2'),(90,'m6i.xlarge','16','Intel (x86_64)','Intel Xeon Ice Lake','4','2','2'),(91,'m6i.2xlarge','32','Intel (x86_64)','Intel Xeon Ice Lake','8','4','2'),(92,'m6i.4xlarge','64','Intel (x86_64)','Intel Xeon Ice Lake','16','8','2'),(93,'m6i.8xlarge','128','Intel (x86_64)','Intel Xeon Ice Lake','32','16','2'),(94,'m6i.12xlarge','192','Intel (x86_64)','Intel Xeon Ice Lake','48','24','2'),(95,'m6i.16xlarge','256','Intel (x86_64)','Intel Xeon Ice Lake','64','32','2'),(96,'m6i.24xlarge','384','Intel (x86_64)','Intel Xeon Ice Lake','96','48','2'),(97,'m6i.32xlarge','512','Intel (x86_64)','Intel Xeon Ice Lake','128','64','2'),(98,'m6i.metal','512','Intel (x86_64)','Intel Xeon Ice Lake','128','64','2'),(99,'m6id.large','8','Intel (x86_64)','Intel Xeon Ice Lake','2','1','2'),(100,'m6id.xlarge','16','Intel (x86_64)','Intel Xeon Ice Lake','4','2','2'),(101,'m6id.2xlarge','32','Intel (x86_64)','Intel Xeon Ice Lake','8','4','2'),(102,'m6id.4xlarge','64','Intel (x86_64)','Intel Xeon Ice Lake','16','8','2'),(103,'m6id.8xlarge','128','Intel (x86_64)','Intel Xeon Ice Lake','32','16','2'),(104,'m6id.12xlarge','192','Intel (x86_64)','Intel Xeon Ice Lake','48','24','2'),(105,'m6id.16xlarge','256','Intel (x86_64)','Intel Xeon Ice Lake','64','32','2'),(106,'m6id.24xlarge','384','Intel (x86_64)','Intel Xeon Ice Lake','96','48','2'),(107,'m6id.32xlarge','512','Intel (x86_64)','Intel Xeon Ice Lake','128','64','2'),(108,'m6id.metal','512','Intel (x86_64)','Intel Xeon Ice Lake','128','64','2'),(109,'m6idn.large','8','Intel (x86_64)','Intel Xeon Ice Lake','2','1','2'),(110,'m6idn.xlarge','16','Intel (x86_64)','Intel Xeon Ice Lake','4','2','2'),(111,'m6idn.2xlarge','32','Intel (x86_64)','Intel Xeon Ice Lake','8','4','2'),(112,'m6idn.4xlarge','64','Intel (x86_64)','Intel Xeon Ice Lake','16','8','2'),(113,'m6idn.8xlarge','128','Intel (x86_64)','Intel Xeon Ice Lake','32','16','2'),(114,'m6idn.12xlarge','192','Intel (x86_64)','Intel Xeon Ice Lake','48','24','2'),(115,'m6idn.16xlarge','256','Intel (x86_64)','Intel Xeon Ice Lake','64','32','2'),(116,'m6idn.24xlarge','384','Intel (x86_64)','Intel Xeon Ice Lake','96','48','2'),(117,'m6idn.32xlarge','512','Intel (x86_64)','Intel Xeon Ice Lake','128','64','2'),(118,'m6idn.metal','512','Intel (x86_64)','Intel Xeon Ice Lake','128','64','2'),(119,'m6in.large','8','Intel (x86_64)','Intel Xeon Ice Lake','2','1','2'),(120,'m6in.xlarge','16','Intel (x86_64)','Intel Xeon Ice Lake','4','2','2'),(121,'m6in.2xlarge','32','Intel (x86_64)','Intel Xeon Ice Lake','8','4','2'),(122,'m6in.4xlarge','64','Intel (x86_64)','Intel Xeon Ice Lake','16','8','2'),(123,'m6in.8xlarge','128','Intel (x86_64)','Intel Xeon Ice Lake','32','16','2'),(124,'m6in.12xlarge','192','Intel (x86_64)','Intel Xeon Ice Lake','48','24','2'),(125,'m6in.16xlarge','256','Intel (x86_64)','Intel Xeon Ice Lake','64','32','2'),(126,'m6in.24xlarge','384','Intel (x86_64)','Intel Xeon Ice Lake','96','48','2'),(127,'m6in.32xlarge','512','Intel (x86_64)','Intel Xeon Ice Lake','128','64','2'),(128,'m6in.metal','512','Intel (x86_64)','Intel Xeon Ice Lake','128','64','2'),(129,'m7a.medium','4','AMD (x86_64)','AMD EPYC 9R14','1','1','1'),(130,'m7a.large','8','AMD (x86_64)','AMD EPYC 9R14','2','2','1'),(131,'m7a.xlarge','16','AMD (x86_64)','AMD EPYC 9R14','4','4','1'),(132,'m7a.2xlarge','32','AMD (x86_64)','AMD EPYC 9R14','8','8','1'),(133,'m7a.4xlarge','64','AMD (x86_64)','AMD EPYC 9R14','16','16','1'),(134,'m7a.8xlarge','128','AMD (x86_64)','AMD EPYC 9R14','32','32','1'),(135,'m7a.12xlarge','192','AMD (x86_64)','AMD EPYC 9R14','48','48','1'),(136,'m7a.16xlarge','256','AMD (x86_64)','AMD EPYC 9R14','64','64','1'),(137,'m7a.24xlarge','384','AMD (x86_64)','AMD EPYC 9R14','96','96','1'),(138,'m7a.32xlarge','512','AMD (x86_64)','AMD EPYC 9R14','128','128','1'),(139,'m7a.48xlarge','768','AMD (x86_64)','AMD EPYC 9R14','192','192','1'),(140,'m7a.metal-48xl','768','AMD (x86_64)','AMD EPYC 9R14','192','192','1'),(141,'m7g.medium','4','AWS Graviton (arm64)','AWS Graviton3 processor','1','1','1'),(142,'m7g.large','8','AWS Graviton (arm64)','AWS Graviton3 processor','2','2','1'),(143,'m7g.xlarge','16','AWS Graviton (arm64)','AWS Graviton3 processor','4','4','1'),(144,'m7g.2xlarge','32','AWS Graviton (arm64)','AWS Graviton3 processor','8','8','1'),(145,'m7g.4xlarge','64','AWS Graviton (arm64)','AWS Graviton3 processor','16','16','1'),(146,'m7g.8xlarge','128','AWS Graviton (arm64)','AWS Graviton3 processor','32','32','1'),(147,'m7g.12xlarge','192','AWS Graviton (arm64)','AWS Graviton3 processor','48','48','1'),(148,'m7g.16xlarge','256','AWS Graviton (arm64)','AWS Graviton3 processor','64','64','1'),(149,'m7g.metal','256','AWS Graviton (arm64)','AWS Graviton3 processor','64','64','1'),(150,'m7gd.medium','4','AWS Graviton (arm64)','AWS Graviton3 processor','1','1','1'),(151,'m7gd.large','8','AWS Graviton (arm64)','AWS Graviton3 processor','2','2','1'),(152,'m7gd.xlarge','16','AWS Graviton (arm64)','AWS Graviton3 processor','4','4','1'),(153,'m7gd.2xlarge','32','AWS Graviton (arm64)','AWS Graviton3 processor','8','8','1'),(154,'m7gd.4xlarge','64','AWS Graviton (arm64)','AWS Graviton3 processor','16','16','1'),(155,'m7gd.8xlarge','128','AWS Graviton (arm64)','AWS Graviton3 processor','32','32','1'),(156,'m7gd.12xlarge','192','AWS Graviton (arm64)','AWS Graviton3 processor','48','48','1'),(157,'m7gd.16xlarge','256','AWS Graviton (arm64)','AWS Graviton3 processor','64','64','1'),(158,'m7gd.metal','256','AWS Graviton (arm64)','AWS Graviton3 processor','64','64','1'),(159,'m7i.large','8','Intel (x86_64)','Intel Xeon Sapphire Rapids','2','1','2'),(160,'m7i.xlarge','16','Intel (x86_64)','Intel Xeon Sapphire Rapids','4','2','2'),(161,'m7i.2xlarge','32','Intel (x86_64)','Intel Xeon Sapphire Rapids','8','4','2'),(162,'m7i.4xlarge','64','Intel (x86_64)','Intel Xeon Sapphire Rapids','16','8','2'),(163,'m7i.8xlarge','128','Intel (x86_64)','Intel Xeon Sapphire Rapids','32','16','2'),(164,'m7i.12xlarge','192','Intel (x86_64)','Intel Xeon Sapphire Rapids','48','24','2'),(165,'m7i.16xlarge','256','Intel (x86_64)','Intel Xeon Sapphire Rapids','64','32','2'),(166,'m7i.24xlarge','384','Intel (x86_64)','Intel Xeon Sapphire Rapids','96','48','2'),(167,'m7i.48xlarge','768','Intel (x86_64)','Intel Xeon Sapphire Rapids','192','96','2'),(168,'m7i.metal-24xl','384','Intel (x86_64)','Intel Xeon Sapphire Rapids','96','48','2'),(169,'m7i.metal-48xl','768','Intel (x86_64)','Intel Xeon Sapphire Rapids','192','96','2'),(170,'m7i-flex.large','8','Intel (x86_64)','Intel Xeon Sapphire Rapids','2','1','2'),(171,'m7i-flex.xlarge','16','Intel (x86_64)','Intel Xeon Sapphire Rapids','4','2','2'),(172,'m7i-flex.2xlarge','32','Intel (x86_64)','Intel Xeon Sapphire Rapids','8','4','2'),(173,'m7i-flex.4xlarge','64','Intel (x86_64)','Intel Xeon Sapphire Rapids','16','8','2'),(174,'m7i-flex.8xlarge','128','Intel (x86_64)','Intel Xeon Sapphire Rapids','32','16','2'),(175,'m7i-flex.12xlarge','192','Intel (x86_64)','Intel Xeon Sapphire Rapids','48','24','2'),(176,'m7i-flex.16xlarge','256','Intel (x86_64)','Intel Xeon Sapphire Rapids','64','32','2'),(177,'m8g.medium','4','AWS Graviton (arm64)','AWS Graviton4 processor','1','1','1'),(178,'m8g.large','8','AWS Graviton (arm64)','AWS Graviton4 processor','2','2','1'),(179,'m8g.xlarge','16','AWS Graviton (arm64)','AWS Graviton4 processor','4','4','1'),(180,'m8g.2xlarge','32','AWS Graviton (arm64)','AWS Graviton4 processor','8','8','1'),(181,'m8g.4xlarge','64','AWS Graviton (arm64)','AWS Graviton4 processor','16','16','1'),(182,'m8g.8xlarge','128','AWS Graviton (arm64)','AWS Graviton4 processor','32','32','1'),(183,'m8g.12xlarge','192','AWS Graviton (arm64)','AWS Graviton4 processor','48','48','1'),(184,'m8g.16xlarge','256','AWS Graviton (arm64)','AWS Graviton4 processor','64','64','1'),(185,'m8g.24xlarge','384','AWS Graviton (arm64)','AWS Graviton4 processor','96','96','1'),(186,'m8g.48xlarge','768','AWS Graviton (arm64)','AWS Graviton4 processor','192','192','1'),(187,'m8g.metal-24xl','384','AWS Graviton (arm64)','AWS Graviton4 processor','96','96','1'),(188,'m8g.metal-48xl','768','AWS Graviton (arm64)','AWS Graviton4 processor','192','192','1'),(189,'mac1.metal','32','Intel (x86_64_mac)','Intel Core i7-8700B','12','6','2'),(190,'mac2.metal','16','Apple (arm64_mac)','Apple M1 chip with 8-core CPU','8','4','2'),(191,'mac2-m1ultra.metal','128','Apple (arm64_mac)','Apple M1 Ultra with 20‑core CPU','20','20','1'),(192,'mac2-m2.metal','24','Apple (arm64_mac)','Apple M2 with 8‑core CPU','8','8','1'),(193,'mac2-m2pro.metal','32','Apple (arm64_mac)','Apple M2 Pro with 12‑core CPU','12','12','1'),(194,'t2.nano','0.5','Intel (x86_64)','Intel Xeon Family','1','1','1'),(195,'t2.micro','1','Intel (x86_64)','Intel Xeon Family','1','1','1'),(196,'t2.small','2','Intel (x86_64)','Intel Xeon Family','1','1','1'),(197,'t2.medium','4','Intel (x86_64)','Intel Broadwell E5-2686v4','2','2','1'),(198,'t2.large','8','Intel (x86_64)','Intel Broadwell E5-2686v4','2','2','1'),(199,'t2.xlarge','16','Intel (x86_64)','Intel Broadwell E5-2686v4','4','4','1'),(200,'t2.2xlarge','32','Intel (x86_64)','Intel Broadwell E5-2686v4','8','8','1'),(201,'t3.nano','0.5','Intel (x86_64)','Intel Skylake P-8175','2','1','2'),(202,'t3.micro','1','Intel (x86_64)','Intel Skylake P-8175','2','1','2'),(203,'t3.small','2','Intel (x86_64)','Intel Skylake P-8175','2','1','2'),(204,'t3.medium','4','Intel (x86_64)','Intel Skylake P-8175','2','1','2'),(205,'t3.large','8','Intel (x86_64)','Intel Skylake P-8175','2','1','2'),(206,'t3.xlarge','16','Intel (x86_64)','Intel Skylake P-8175','4','2','2'),(207,'t3.2xlarge','32','Intel (x86_64)','Intel Skylake P-8175','8','4','2'),(208,'t3a.nano','0.5','AMD (x86_64)','AMD EPYC 7571','2','1','2'),(209,'t3a.micro','1','AMD (x86_64)','AMD EPYC 7571','2','1','2'),(210,'t3a.small','2','AMD (x86_64)','AMD EPYC 7571','2','1','2'),(211,'t3a.medium','4','AMD (x86_64)','AMD EPYC 7571','2','1','2'),(212,'t3a.large','8','AMD (x86_64)','AMD EPYC 7571','2','1','2'),(213,'t3a.xlarge','16','AMD (x86_64)','AMD EPYC 7571','4','2','2'),(214,'t3a.2xlarge','32','AMD (x86_64)','AMD EPYC 7571','8','4','2'),(215,'t4g.nano','0.5','AWS Graviton (arm64)','AWS Graviton2 processor','2','2','1'),(216,'t4g.micro','1','AWS Graviton (arm64)','AWS Graviton2 processor','2','2','1'),(217,'t4g.small','2','AWS Graviton (arm64)','AWS Graviton2 processor','2','2','1'),(218,'t4g.medium','4','AWS Graviton (arm64)','AWS Graviton2 processor','2','2','1'),(219,'t4g.large','8','AWS Graviton (arm64)','AWS Graviton2 processor','2','2','1'),(220,'t4g.xlarge','16','AWS Graviton (arm64)','AWS Graviton2 processor','4','4','1'),(221,'t4g.2xlarge','32','AWS Graviton (arm64)','AWS Graviton2 processor','8','8','1');

--
-- Table structure for table `quest`
--

CREATE TABLE `quest` (
  `id` int NOT NULL DEFAULT '0',
  `questionOrder` int DEFAULT NULL,
  `masterDataType` varchar(255) DEFAULT NULL,
  `questionTitle` varchar(255) DEFAULT NULL,
  `questionDescription` varchar(255) DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT NULL,
  `createdBy` varchar(255) DEFAULT NULL,
  `updatedBy` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `FormId` int DEFAULT NULL,
  `isMandatory` tinyint(1) DEFAULT NULL,
  `questionType` varchar(255) DEFAULT NULL,
  `questionCode` varchar(255) DEFAULT NULL,
  `SubGroupId` int DEFAULT NULL,
  `GroupingId` int DEFAULT NULL,
  `PermaId` int DEFAULT NULL,
  `hostingType` varchar(255) DEFAULT NULL,
  `hidden` tinyint(1) NOT NULL DEFAULT '0',
  `QuestionRelatedId` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `quest`
--

INSERT INTO `quest` VALUES (29,15,'Working_hours','Estimate the normal working hours per day - please select','Enter the working hours that an employee spend in office',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,3,7,29,'42,44',0,NULL),(50,2,NULL,'Estimate the number of INTERNAL FTE : Location 1','Enter the nuber of full time employees who worked on the application development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','location-1',100,5,50,'42,44',0,NULL),(53,3,NULL,'Estimate the number of EXTERNAL FTE - Location 1:','Enter the nuber of full time employees who worked on the application development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number','location-1',100,5,53,'42,44',0,NULL),(58,1,NULL,'State the number of development servers','Enter the number of development servers used to build the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,8,7,58,'42',0,NULL),(59,2,'Server_type','State the server type used - please select','Select the kind of server used for development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,8,7,59,'42',0,NULL),(60,3,NULL,'State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,8,7,60,'42',0,NULL),(61,4,'Processor_manufacturer','Specify the main processor manufacturer - please select','Select the manufacturer who built the main processor',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,8,7,61,'42,44',0,NULL),(62,5,NULL,'Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,8,7,62,'42,44',0,NULL),(63,6,NULL,'Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,8,7,63,'42,44',0,NULL),(65,22,NULL,'If applicable, specify the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs present in the development servers',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,9,7,65,'44',0,NULL),(66,9,'Operating_System','State the operating system used - please select','Select the operating system running in the server',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,8,7,66,'42,44',0,NULL),(67,10,NULL,'Specify the number of development environments installed','Enter the number of development environments used in the building of the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,3,7,67,'42,44',0,NULL),(68,11,NULL,'State the location country where the development environments are installed','Enter the name of the country where test environments are present',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location',NULL,3,7,68,'42,44',0,NULL),(69,12,NULL,'State the region where the development environments are installed','Enter the name of the region in the country where test environments are present',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Region',NULL,3,7,69,'42,44',0,NULL),(70,13,NULL,'State the city where the development environments are installed','Enter the name of the city in the country where test environments are present',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,3,7,70,'42,44',0,NULL),(71,14,NULL,'State the core build / release duration in working days','Enter the number of days spent in testing the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,3,7,71,'42,44',0,NULL),(73,16,'Hosting_Type','State Hosting type - please select','Enter the hosting type for the application when it was built originally',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,9,7,73,'42,44',0,NULL),(74,17,'MainCSP','State main CSP selected if on public cloud - please select','Select the name pf the main Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,9,7,74,'44',0,NULL),(75,18,NULL,'If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known','Select the machine family or tier or instance type as provided by Cloud service provoder',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,9,7,75,'44',0,NULL),(76,19,NULL,'If hosting is via a CSP, state the number of instances provisioned','Enter the number of instances provided by the Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,9,7,76,'44',0,NULL),(77,20,'Workload_Type','If hosting is via a CSP, state the workload type selected - leave blank if not known','Enter the workload type of the Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,9,7,77,'44',0,NULL),(78,21,NULL,'State the Power Usage Effectiveness (PUE) for the data centre','Enter the value for PUE of the data centre',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,10,7,78,'42,44',0,NULL),(79,22,NULL,'State the average processor utilisation','Enter the percentage of time the processor is used to perform tasks.',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,8,7,79,'42,44',0,NULL),(80,23,NULL,'State the memory installed per environment (in GB)','Enter the total memory of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,8,7,80,'42,44',0,NULL),(81,24,NULL,'State the storage installed per environment (in TB)','Enter the total storage of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,8,7,81,'42,44',0,NULL),(82,25,'Storage_Type','State Storage type - please select','Select the storage type used for saving data',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,8,7,82,'42,44',0,NULL),(83,26,'Traffic_Type','Data Traffic type - please select','Select the mode in which data move across the  network',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,10,7,83,'42,44',0,NULL),(84,27,NULL,'Estimate the average data size per call (in KB)','Enter the amount of data used per call ',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,10,7,84,'42,44',0,NULL),(85,28,NULL,'Estimate the average number of data transfers per minute','Enter how much data is transferred in a minute',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,10,7,85,'42,44',0,NULL),(88,23,NULL,'Specify the number of physical CPU provisioned in each development environment','Enter the number of CPUs present in the development servers',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,9,7,88,'42',0,NULL),(427,1,NULL,'Years since product first went live','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,11,2,427,NULL,0,NULL),(428,2,NULL,'Estimated number of users/customers of product','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,11,2,428,NULL,0,NULL),(429,3,NULL,'Estimated volume of transactions/engagements per annum','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,11,2,429,NULL,0,NULL),(430,4,'Check','Are the Development, Test, and Production environments in the same location?','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Text',NULL,11,2,430,NULL,0,NULL),(432,6,'Check','Is the hosting type the same for Development, Test, and Production environments?','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Text',NULL,11,2,432,NULL,0,NULL),(433,7,'Hosting_Type','If the answer to the above question is Yes, please select the hosting type here','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,11,2,433,NULL,0,NULL),(434,8,'Assessment_type','What type of assessment you want to take - Please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Text',NULL,11,2,434,NULL,0,NULL),(435,9,'Check','Do you want to do End of Life Assessment ?','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Text',NULL,11,2,435,NULL,0,NULL),(438,3,NULL,'If applicable, estimate the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs in the development server',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,1,3,438,'44',0,NULL),(446,2,'Hosting_Type','State Hosting type for the original build - please select','Enter the hosting type for the application when it was built originally',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,2,4,446,'42,44',0,436),(447,3,NULL,'Estimate the number of physical CPU provisioned in each Test environment','Enter the total number of CPUs in test environment',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,2,4,447,'42',0,437),(448,4,NULL,'If applicable, estimate the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs in the development server',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,2,4,448,'44',0,438),(449,5,NULL,'Estimate the memory installed per environment (in GB)','Enter the total memory of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,2,4,449,'42,44',0,439),(450,6,NULL,'Estimate the storage installed per environment (in TB)','Enter the total storage of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,2,4,450,'42,44',0,440),(451,8,NULL,'State the location country where the Test environments were installed','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location',NULL,2,4,451,'42,44',0,442),(452,9,NULL,'Estimate the core build / release duration in working days','Enter the number of days spent in creating the original build of the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,2,4,452,'42,44',0,443),(453,10,'Working_hours','Estimate the normal working hours per day - please select','Enter the working hours that an employee spend in office',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,2,4,453,'42,44',0,444),(454,7,NULL,'Estimate the number of Test environments originally installed','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,2,4,454,'42,44',0,441),(458,10,NULL,'Estimate the average % time allocated to the assessed product across all FTE ','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',100,5,458,'42,44',0,NULL),(459,11,NULL,'Estimate the % FTE in developer / software engineering roles from total FTE above ','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',100,5,459,'42,44',0,NULL),(460,1,NULL,'State the main programming language used','Enter the programming language that was used for application development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,63,6,460,'42,44',0,NULL),(461,21,NULL,'If hosting is via a CSP and serverless, state average COMPUTE HOURS per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,9,7,461,'44',0,NULL),(462,6,'Working_hours','Estimate the normal working hours per day - please select','Enter the working hours that an employee spend in office',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,30,8,462,'42,44',0,NULL),(463,1,NULL,'Specify the number of development environments installed','Enter the number of development environments used in the building of the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,30,8,463,'42,44',0,NULL),(464,2,NULL,'State the location country where the development environments are installed','Enter the name of the country where test environments are present',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location',NULL,30,8,464,'42,44',0,NULL),(465,3,NULL,'State the region where the development environments are installed','Enter the name of the region in the country where test environments are present',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Region',NULL,30,8,465,'42,44',0,NULL),(466,4,NULL,'State the city where the development environments are installed','Enter the name of the city in the country where test environments are present',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,30,8,466,'42,44',0,NULL),(467,5,NULL,'State the core build / release duration in working days','Enter the number of days spent in testing the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,30,8,467,'42,44',0,NULL),(468,8,NULL,'If applicable, specify the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs present in the development servers',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,31,8,468,'44',0,NULL),(469,1,'Hosting_Type','State Hosting type - please select','Enter the hosting type for the application when it was built originally',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,31,8,469,'42,44',0,NULL),(470,2,'MainCSP','State main CSP selected if on public cloud - please select','Select the name pf the main Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,31,8,470,'44',0,NULL),(471,3,NULL,'If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known','Select the machine family or tier or instance type as provided by Cloud service provoder',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,31,8,471,'44',0,NULL),(472,4,NULL,'If hosting is via a CSP, state the number of instances provisioned','Enter the number of instances provided by the Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,31,8,472,'44',0,NULL),(473,5,'Workload_Type','If hosting is via a CSP, state the workload type selected - leave blank if not known','Enter the workload type of the Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,31,8,473,'44',0,NULL),(474,6,NULL,'Specify the number of physical CPU provisioned in each development environment','Enter the number of CPUs present in the development servers',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,31,8,474,'42',0,NULL),(475,7,NULL,'If hosting is via a CSP and serverless, state average COMPUTE HOURS per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,31,8,475,'44',0,NULL),(476,1,NULL,'State the number of development servers','Enter the number of development servers used to build the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,32,8,476,'42',0,NULL),(477,2,'Server_type','State the server type used - please select','Select the kind of server used for development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,32,8,477,'42',0,NULL),(478,3,NULL,'State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,32,8,478,'42,44',0,NULL),(479,4,'Processor_manufacturer','Specify the main processor manufacturer - please select','Select the manufacturer who built the main processor',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,32,8,479,'42,44',0,NULL),(480,5,NULL,'Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,32,8,480,'42,44',0,NULL),(481,6,NULL,'Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,32,8,481,'42,44',0,NULL),(482,7,'Operating_System','State the operating system used - please select','Select the operating system running in the server',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,32,8,482,'42,44',0,NULL),(483,8,NULL,'State the average processor utilisation','Enter the percentage of time the processor is used to perform tasks.',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,32,8,483,'42,44',0,NULL),(484,9,NULL,'State the memory installed per environment (in GB)','Enter the total memory of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,32,8,484,'42,44',0,NULL),(485,10,NULL,'State the storage installed per environment (in TB)','Enter the total storage of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,32,8,485,'42,44',0,NULL),(486,11,'Storage_Type','State Storage type - please select','Select the storage type used for saving data',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,32,8,486,'42,44',0,NULL),(487,1,NULL,'State the Power Usage Effectiveness (PUE) for the data centre','Enter the value for PUE of the data centre',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,33,8,487,'42,44',0,NULL),(488,2,'Traffic_Type','Data Traffic type - please select','Select the mode in which data move across the  network',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,33,8,488,'42,44',0,NULL),(489,3,NULL,'Estimate the average data size per call (in KB)','Enter the amount of data used per call ',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,33,8,489,'42,44',0,NULL),(490,4,NULL,'Estimate the average number of data transfers per minute','Enter how much data is transferred in a minute',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,33,8,490,'42,44',0,NULL),(491,2,NULL,'Enter Internal FTE : Location 1','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','location-1',40,88,491,'42,44',0,NULL),(492,3,NULL,'Enter External FTE : Location 1','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','location-1',40,88,492,'42,44',0,NULL),(493,10,NULL,'Estimate the average % time allocated to the assessed product across all FTE','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',40,88,493,'42,44',0,NULL),(494,11,NULL,'Estimate the % FTE in developer / software engineering roles from total FTE above','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',40,88,494,'42,44',0,NULL),(495,12,NULL,'State timeframe (core build / release duration in working days) /12','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',40,88,495,'42,44',0,NULL),(496,1,NULL,'Estimate total number of airmiles travelled during product phase','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',41,88,496,'42,44',0,NULL),(497,2,NULL,'Estimate the number of commute bus trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',41,88,497,'42,44',0,NULL),(498,3,NULL,'Estimate the number of commute train trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',41,88,498,'42,44',0,NULL),(499,4,NULL,'Estimate the number of commute car trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',41,88,499,'42,44',0,NULL),(500,5,NULL,'Estimate % time WFH','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',41,88,500,'42,44',0,NULL),(501,6,NULL,'Estimate % of time spent working from owned office premises vs. Third party facilities (e.g. WeWork)','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',41,88,501,'42,44',0,NULL),(502,1,'Video_Tool','Select main video collaboration tool used','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',42,88,502,'42,44',0,NULL),(503,2,NULL,'Estimate the average hours per day using video collaboration tools','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',42,88,503,'42,44',0,NULL),(504,3,'Development_Repository','State the main software development platform / code repository used - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',42,88,504,'42,44',0,NULL),(505,4,'APM_Tool','State the main Application Performance Monitoring (APM) tool used - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',42,88,505,'42,44',0,NULL),(506,5,'Testing_Tool','State the main automated / continuous testing tool used - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',42,88,506,'42,44',0,NULL),(507,1,'Working_hours','State the normal working hours per day','Enter the working hours that an employee spend in office',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,65,10,507,'42,44',0,NULL),(508,2,NULL,'State the main programming language used','Enter the programming language that was used for application development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,65,10,508,'42,44',0,NULL),(509,3,'DeveloperAssessment_Rating','State the average Sustainable Software Engineering Assessment rating achieved for developers - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,65,10,509,'42,44',0,NULL),(511,5,NULL,'Estimate the % of code reuse ','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,65,10,511,'42,44',0,NULL),(512,6,'DevOps_Maturity','State the level of DevOps maturity - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,65,10,512,'42,44',0,NULL),(513,7,'FinOps_Maturity','State the level of FinOps maturity - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,65,10,513,'42,44',0,NULL),(514,15,'Working_hours','Estimate the normal working hours per day - please select','Enter the working hours that an employee spend in office',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,16,90,514,'42,44',0,NULL),(515,10,NULL,'Specify the number of production environments installed','Enter the number of production environments used in the building of the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,16,90,515,'42,44',0,NULL),(516,11,NULL,'State the location country where the  production environments are installed','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location',NULL,16,90,516,'42,44',0,NULL),(517,12,NULL,'State the region where the  production environments are installed','Enter the name of the region in the country where production environments are present',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Region',NULL,16,90,517,'42,44',0,NULL),(518,13,NULL,'State the city where the production environments are installed','Enter the name of the city in the country where production environments are present',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,16,90,518,'42,44',0,NULL),(519,14,NULL,'State the core build / release duration in working days','Enter the number of days spent in testing the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,16,90,519,'42,44',0,NULL),(521,1,NULL,'State the number of  production servers','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,17,90,521,'42',0,NULL),(522,2,'Server_type','State the server type used - please select','Select the kind of server used for development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,17,90,522,'42',0,NULL),(523,3,NULL,'State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,17,90,523,'44',0,NULL),(524,4,'Processor_manufacturer','Specify the main processor manufacturer - please select','Select the manufacturer who built the main processor',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,17,90,524,'42,44',0,NULL),(525,5,NULL,'Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,17,90,525,'42,44',0,NULL),(526,6,NULL,'Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,17,90,526,'42,44',0,NULL),(527,7,'Operating_System','State the operating system used - please select','Select the operating system running in the server',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,17,90,527,'42,44',0,NULL),(528,8,NULL,'State the average processor utilisation','Enter the percentage of time the processor is used to perform tasks.',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,17,90,528,'42,44',0,NULL),(529,9,NULL,'State the memory installed per environment (in GB)','Enter the total memory of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,17,90,529,'42,44',0,NULL),(530,10,NULL,'State the storage installed per environment (in TB)','Enter the total storage of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,17,90,530,'42,44',0,NULL),(531,11,'Storage_Type','State Storage type - please select','Select the storage type used for saving data',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,17,90,531,'42,44',0,NULL),(536,22,NULL,'If applicable, specify the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs present in the development servers',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,18,90,536,'44',0,NULL),(537,16,'Hosting_Type','State Hosting type - please select','Enter the hosting type for the application when it was built originally',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,18,90,537,'42,44',0,NULL),(538,17,'MainCSP','State main CSP selected if on public cloud - please select','Select the name pf the main Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,18,90,538,'44',0,NULL),(539,18,NULL,'If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known','Select the machine family or tier or instance type as provided by Cloud service provoder',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,18,90,539,'44',0,NULL),(540,19,NULL,'If hosting is via a CSP, state the number of instances provisioned','Enter the number of instances provided by the Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,18,90,540,'44',0,NULL),(541,20,'Workload_Type','If hosting is via a CSP, state the workload type selected - leave blank if not known','Enter the workload type of the Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,18,90,541,'44',0,NULL),(542,23,NULL,'Specify the number of physical CPU provisioned in each development environment','Enter the number of CPUs present in the development servers',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,18,90,542,'42',0,NULL),(543,21,NULL,'If hosting is via a CSP and serverless, state average COMPUTE HOURS per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,18,90,543,'44',0,NULL),(551,1,NULL,'State the Power Usage Effectiveness (PUE) for the data centre','Enter the value for PUE of the data centre',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,19,90,551,'44',0,NULL),(552,2,'Traffic_Type','Data Traffic type - please select','Select the mode in which data move across the  network',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,19,90,552,'42,44',0,NULL),(553,3,NULL,'Estimate the average data size per call (in KB)','Enter the amount of data used per call ',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,19,90,553,'42,44',0,NULL),(554,4,NULL,'Estimate the average number of data transfers per minute','Enter how much data is transferred in a minute',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,19,90,554,'42,44',0,NULL),(558,2,NULL,'Enter Internal FTE : Location 1','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','location-1',43,92,558,'42,44',0,NULL),(559,3,NULL,'Enter External FTE : Location 1','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','location-1',43,92,559,'42,44',0,NULL),(560,10,NULL,'Estimate the average % time allocated to the assessed product across all FTE','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',43,92,560,'42,44',0,NULL),(561,11,NULL,'Estimate the % FTE in developer / software engineering roles from total FTE above','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',43,92,561,'42,44',0,NULL),(562,12,NULL,'State timeframe  ( core build / release duration in working days) /12','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',43,92,562,'42,44',0,NULL),(565,1,NULL,'Estimate total number of airmiles travelled during product phase','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,44,92,565,'42,44',0,NULL),(566,2,NULL,'Estimate the number of commute bus trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,44,92,566,'42,44',0,NULL),(567,3,NULL,'Estimate the number of commute train trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,44,92,567,'42,44',0,NULL),(568,4,NULL,'Estimate the number of commute car trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,44,92,568,'42,44',0,NULL),(569,5,NULL,'Estimate % time WFH','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,44,92,569,'42,44',0,NULL),(570,6,NULL,'Estimate % of time spent working from owned office premises vs. Third party facilities (e.g. WeWork)','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,44,92,570,'42,44',0,NULL),(572,1,'Video_Tool','Select main video collaboration tool used','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,45,92,572,'42,44',0,NULL),(573,2,NULL,'Estimate the average hours per day using video collaboration tools','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,45,92,573,'42,44',0,NULL),(574,3,'Development_Repository','State the main software development platform / code repository used - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,45,92,574,'42,44',0,NULL),(575,4,'APM_Tool','State the main Application Performance Monitoring (APM) tool used - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,45,92,575,'42,44',0,NULL),(576,5,'Testing_Tool','State the main automated / continuous testing tool used - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,45,92,576,'42,44',0,NULL),(579,1,'Working_hours','State the normal working hours per day','Enter the working hours that an employee spend in office',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,66,93,579,'42,44',0,NULL),(580,2,NULL,'State the main programming language used','Enter the programming language that was used for application development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,66,93,580,'42,44',0,NULL),(581,3,'DeveloperAssessment_Rating','State the average Sustainable Software Engineering Assessment rating achieved for developers - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,66,93,581,'42,44',0,NULL),(582,4,NULL,'Estimate the % of no-code assets used','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,66,93,582,'42,44',0,NULL),(583,5,NULL,'Estimate the % of code reuse ','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,66,93,583,'42,44',0,NULL),(584,6,'DevOps_Maturity','State the level of DevOps maturity - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,66,93,584,'42,44',0,NULL),(585,7,'FinOps_Maturity','State the level of FinOps maturity - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,66,93,585,'42,44',0,NULL),(586,2,NULL,'Enter Internal FTE - location 1','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,46,94,586,'42,44',0,NULL),(587,2,NULL,'Enter External FTE - location 1','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,47,94,587,'42,44',0,NULL),(588,3,NULL,'Estimate the average % time allocated to the assessed product across all FTE','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,48,94,588,'42,44',0,NULL),(589,4,NULL,'Estimate the % FTE in developer / software engineering roles from total FTE above','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,48,94,589,'42,44',0,NULL),(590,5,NULL,'Specifiy Time (months) effort to decommission applications','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,48,94,590,'42,44',0,NULL),(591,6,NULL,'Estimate total number of airmiles travelled during product phase','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,49,94,591,'42,44',0,NULL),(592,7,NULL,'Estimate the number of commute bus trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,49,94,592,'42,44',0,NULL),(593,8,NULL,'Estimate the number of commute train trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,49,94,593,'42,44',0,NULL),(594,9,NULL,'Estimate the number of commute car trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,49,94,594,'42,44',0,NULL),(595,10,NULL,'Estimate total number of airmiles travelled during product phase','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,50,94,595,'42,44',0,NULL),(596,11,NULL,'Estimate the number of commute bus trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,50,94,596,'42,44',0,NULL),(597,12,NULL,'Estimate the number of commute train trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,50,94,597,'42,44',0,NULL),(598,13,NULL,'Estimate the number of commute car trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,50,94,598,'42,44',0,NULL),(599,14,'Video_Tool','Select main video collaboration tool used','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,51,94,599,'42,44',0,NULL),(600,1,NULL,'Estimate the average hours per day using video collaboration tools','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,51,94,600,'42,44',0,NULL),(601,6,'Working_hours','Estimate the normal working hours per day - please select','Enter the working hours that an employee spend in office',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,52,100,601,'42,44',0,NULL),(602,1,NULL,'Specify the number of development environments installed','Enter the number of development environments used in the building of the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,52,100,602,'42,44',0,NULL),(603,2,NULL,'State the location country where the  development environments are installed','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location',NULL,52,100,603,'42,44',0,NULL),(604,3,NULL,'State the region where the  development environments are installed','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Region',NULL,52,100,604,'42,44',0,NULL),(605,4,NULL,'State the city where the development environments are installed','Enter the name of the city in the country where test environments are present',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,52,100,605,'42,44',0,NULL),(606,5,NULL,'State the core build / release duration in working days','Enter the number of days spent in testing the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,52,100,606,'42,44',0,NULL),(608,8,NULL,'If applicable, specify the number of vCPU provisioned in each development environment','Enter the number of virtual CPUs present in the development servers',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,53,100,608,'42,44',0,NULL),(609,1,'Hosting_Type','State Hosting type - please select','Enter the hosting type for the application when it was built originally',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,53,100,609,'42,44',0,NULL),(610,2,'MainCSP','State main CSP selected if on public cloud - please select','Select the name pf the main Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,53,100,610,'44',0,NULL),(611,3,NULL,'If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known','Select the machine family or tier or instance type as provided by Cloud service provoder',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,53,100,611,'44',0,NULL),(612,4,NULL,'If hosting is via a CSP, state the number of instances provisioned','Enter the number of instances provided by the Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,53,100,612,'44',0,NULL),(613,5,'Workload_Type','If hosting is via a CSP, state the workload type selected - leave blank if not known','Enter the workload type of the Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,53,100,613,'44',0,NULL),(614,7,NULL,'Specify the number of physical CPU provisioned in each development environment','Enter the number of CPUs present in the development servers',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,53,100,614,'44',0,NULL),(615,6,NULL,'If hosting is via a CSP and serverless, state average COMPUTE HOURS per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,53,100,615,'44',0,NULL),(623,1,NULL,'State the number of development servers','Enter the number of development servers used to build the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,54,100,623,'42',0,NULL),(624,2,'Server_type','State the server type used - please select','Select the kind of server used for development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,54,100,624,'42',0,NULL),(625,3,NULL,'State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,54,100,625,'42,44',0,NULL),(626,4,'Processor_manufacturer','Specify the main processor manufacturer - please select','Select the manufacturer who built the main processor',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,54,100,626,'42,44',0,NULL),(627,5,NULL,'Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,54,100,627,'42,44',0,NULL),(628,6,NULL,'Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,54,100,628,'42,44',0,NULL),(629,7,'Operating_System','State the operating system used - please select','Select the operating system running in the server',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,54,100,629,'42,44',0,NULL),(630,8,NULL,'State the average processor utilisation','Enter the percentage of time the processor is used to perform tasks.',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,54,100,630,'42,44',0,NULL),(631,9,NULL,'State the memory installed per environment (in GB)','Enter the total memory of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,54,100,631,'42,44',0,NULL),(632,10,NULL,'State the storage installed per environment (in TB)','Enter the total storage of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,54,100,632,'42,44',0,NULL),(633,11,'Storage_Type','State Storage type - please select','Select the storage type used for saving data',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,54,100,633,'42,44',0,NULL),(638,1,NULL,'State the Power Usage Effectiveness (PUE) for the data centre','Enter the value for PUE of the data centre',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,55,100,638,'42,44',0,NULL),(639,2,'Traffic_Type','Data Traffic type - please select','Select the mode in which data move across the  network',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,55,100,639,'42,44',0,NULL),(640,3,NULL,'Estimate the average data size per call (in KB)','Enter the amount of data used per call ',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,55,100,640,'42,44',0,NULL),(641,4,NULL,'Estimate the average number of data transfers per minute','Enter how much data is transferred in a minute',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,55,100,641,'42,44',0,NULL),(645,1,NULL,'Select location 1','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location','location-1',60,102,645,'42,44',0,NULL),(646,2,NULL,'Enter internall FTE for Location 1:','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','location-1',60,102,646,'42,44',0,NULL),(647,10,NULL,'Estimate the average % time allocated to the assessed product across all FTE','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',60,102,647,'42,44',0,NULL),(648,11,NULL,'Estimate the % FTE in developer / software engineering roles from total FTE above','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',60,102,648,'42,44',0,NULL),(649,12,NULL,'State timeframe  ( core build / release duration in working days) /12','This value is calculated based on the data entered for full time employees',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','OtherLocationCode',60,102,649,'42,44',0,NULL),(650,1,NULL,'Estimate total number of airmiles travelled during product phase','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,61,102,650,'42,44',0,NULL),(651,2,NULL,'Estimate the number of commute bus trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,61,102,651,'42,44',0,NULL),(652,3,NULL,'Estimate the number of commute train trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,61,102,652,'42,44',0,NULL),(653,4,NULL,'Estimate the number of commute car trips per person per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,61,102,653,'42,44',0,NULL),(654,5,NULL,'Estimate % time WFH','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,61,102,654,'42,44',0,NULL),(655,6,NULL,'Estimate % of time spent working from owned office premises vs. Third party facilities (e.g. WeWork)','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,61,102,655,'42,44',0,NULL),(656,1,'Video_Tool','Select main video collaboration tool used','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,62,102,656,'42,44',0,NULL),(657,2,NULL,'Estimate the average hours per day using video collaboration tools','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,62,102,657,'42,44',0,NULL),(658,3,'Development_Repository','State the main software development platform / code repository used - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,62,102,658,'42,44',0,NULL),(659,4,'APM_Tool','State the main Application Performance Monitoring (APM) tool used - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,62,102,659,'42,44',0,NULL),(660,5,'Testing_Tool','State the main automated / continuous testing tool used - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,62,102,660,'42,44',0,NULL),(676,1,'Working_hours','State the normal working hours per day','Enter the working hours that an employee spend in office',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,64,103,676,'42,44',0,NULL),(677,2,NULL,'State the main programming language used','Enter the programming language that was used for application development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,64,103,677,'42,44',0,NULL),(678,3,'DeveloperAssessment_Rating','State the average Sustainable Software Engineering Assessment rating achieved for developers - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,64,103,678,'42,44',0,NULL),(679,4,NULL,'Estimate the % of no-code assets used','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,64,103,679,'42,44',0,NULL),(680,5,NULL,'Estimate the % of code reuse ','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,64,103,680,'42,44',0,NULL),(681,6,'DevOps_Maturity','State the level of DevOps maturity - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,64,103,681,'42,44',0,NULL),(682,7,'FinOps_Maturity','State the level of FinOps maturity - please select','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,64,103,682,'42,44',0,NULL),(683,6,'Working_hours','Estimate the normal working hours per day - please select','Enter the working hours that an employee spend in office',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,56,101,683,'42,44',0,NULL),(684,1,NULL,'Specify the number of test environments installed','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,56,101,684,'42,44',0,NULL),(685,2,NULL,'State the location country where the  test environments are installed','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location',NULL,56,101,685,'42,44',0,NULL),(686,3,NULL,'State the region where the  test environments are installed','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Region',NULL,56,101,686,'42,44',0,NULL),(687,4,NULL,'State the city where the test environments are installed','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,56,101,687,'42,44',0,NULL),(688,5,NULL,'State the core build / release duration in working days','Enter the number of days spent in testing the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,56,101,688,'42,44',0,NULL),(689,8,NULL,'If applicable, specify the number of vCPU provisioned in each test environment','Enter the number of virtual CPUs in the development server',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,57,101,689,'44',0,NULL),(690,1,'Hosting_Type','State Hosting type - please select','Enter the hosting type for the application when it was built originally',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,57,101,690,'42,44',0,NULL),(691,2,'MainCSP','State main CSP selected if on public cloud - please select','Select the name pf the main Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,57,101,691,'44',0,NULL),(692,3,NULL,'If hosting is via a CSP, state the tier / machine family or instance type selected - leave blank if not known','Select the machine family or tier or instance type as provided by Cloud service provoder',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Text',NULL,57,101,692,'44',0,NULL),(693,4,NULL,'If hosting is via a CSP, state the number of instances provisioned','Enter the number of instances provided by the Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,57,101,693,'44',0,NULL),(694,5,'Workload_Type','If hosting is via a CSP, state the workload type selected - leave blank if not known','Enter the workload type of the Cloud Service Provider',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,57,101,694,'44',0,NULL),(695,7,NULL,'Specify the number of physical CPU provisioned in each test environment','Enter the total number of CPUs in test environment',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,57,101,695,'44',0,NULL),(696,6,NULL,'If hosting is via a CSP and serverless, state average COMPUTE HOURS per day','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,57,101,696,'44',0,NULL),(697,1,NULL,'State the number of test servers','Enter the number of test servers used to test the application',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,58,101,697,'42',0,NULL),(698,2,'Server_type','State the server type used - please select','Select the kind of server used for development',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,58,101,698,'42',0,NULL),(699,3,NULL,'State the average refresh cycle for servers (years)','Enter the number of years after which the server or its hardware is replaced',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,58,101,699,'44',0,NULL),(700,4,'Processor_manufacturer','Specify the main processor manufacturer - please select','Select the manufacturer who built the main processor',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,58,101,700,'42,44',0,NULL),(701,5,NULL,'Specify the processor clock speed (in GHZ) if known','Enter the number of cycles a computer\'s central processing unit (CPU) can perform per second',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,58,101,701,'42,44',0,NULL),(702,6,NULL,'Specify the number of Cores per processor if known','Enter the number of processing units in a central processing unit (CPU)',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,58,101,702,'42,44',0,NULL),(703,7,'Operating_System','State the operating system used - please select','Select the operating system running in the server',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,58,101,703,'42,44',0,NULL),(704,8,NULL,'State the average processor utilisation','Enter the percentage of time the processor is used to perform tasks.',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,58,101,704,'42,44',0,NULL),(705,9,NULL,'State the memory installed per environment (in GB)','Enter the total memory of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,58,101,705,'42,44',0,NULL),(706,10,NULL,'State the storage installed per environment (in TB)','Enter the total storage of the environment under consideration',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,58,101,706,'42,44',0,NULL),(707,11,'Storage_Type','State Storage type - please select','Select the storage type used for saving data',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,58,101,707,'42,44',0,NULL),(708,1,NULL,'State the Power Usage Effectiveness (PUE) for the data centre','Enter the value for PUE of the data centre',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,'Number',NULL,59,101,708,'42,44',0,NULL),(709,2,'Traffic_Type','Data Traffic type - please select','Select the mode in which data move across the  network',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,59,101,709,'42,44',0,NULL),(710,3,NULL,'Estimate the average data size per call (in KB)','Enter the amount of data used per call ',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,59,101,710,'42,44',0,NULL),(711,4,NULL,'Estimate the average number of data transfers per minute','Enter how much data is transferred in a minute',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,59,101,711,'42,44',0,NULL),(719,1,NULL,'Select location 1','Enter the location of the office where full time employees work',1,NULL,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location','location-1',100,5,719,'42,44',0,NULL),(733,1,NULL,'Select Location1',NULL,1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location','location-1',43,92,733,'42,44',0,NULL),(737,3,NULL,'Enter external FTE for Location 1:',NULL,1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number','location-1',60,102,737,'42,44',0,NULL),(745,1,NULL,'Select Location ',NULL,1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location',NULL,46,94,745,'42,44',0,NULL),(746,1,NULL,'Select Location',NULL,1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Location',NULL,47,94,746,'42,44',0,NULL),(747,3,NULL,'Enter Internal FTE - location 2','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,46,94,747,'42,44',0,NULL),(748,4,NULL,'Enter Internal FTE - location 3',NULL,1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,46,94,748,'42,44',0,NULL),(749,2,NULL,'Enter External FTE - location 2','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,47,94,749,'42,44',0,NULL),(750,3,NULL,'Enter External FTE - location 3','',1,'GCG','GCG','0000-00-00 00:00:00','0000-00-00 00:00:00',1,1,'Number',NULL,47,94,750,'42,44',0,NULL);


