Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: All Story Data - Current Year Marker
|   DW Unique Issue ID | Issue Key   | Issue_URL                                   | summary                                                         | Issue Type   | Reporter          |   Created By ID | Issue Created           | Project Key   | Story Points   | Labels   | Epic Key    | Resolution Date         | Assignee         | Status   | InAnySprint   | CombinedSummary                                                          | Epic_Name                                                       | resolution_short_desc   | Rest_URL                                          |   JIRA Unique Issue ID | Reporter_NTID   | Assignee_NTID   | current_year   | priority_desc   |
|---------------------:|:------------|:--------------------------------------------|:----------------------------------------------------------------|:-------------|:------------------|----------------:|:------------------------|:--------------|:---------------|:---------|:------------|:------------------------|:-----------------|:---------|:--------------|:-------------------------------------------------------------------------|:----------------------------------------------------------------|:------------------------|:--------------------------------------------------|-----------------------:|:----------------|:----------------|:---------------|:----------------|
|                41301 | STOR-234    | https://jira.t-mobile.com/browse/STOR-234   | Upgrade pxeitnas to OneFS GA release                            | Story        | Luke Medcalf      |  20170222121209 | 2017-02-22 12:10:30.480 | STOR          |                |          | STOR-65     | 2018-02-21 10:26:39.586 | Yasaswi Mahadasu | Done     | yes           | STOR-234-Upgrade pxeitnas to OneFS GA release                            | 2018 - Keep the Lights On (STOR)                                | Done                    | https://jira.t-mobile.com/rest/api/2/issue/67049  |                  67049 | lmedcal         | ymahada         | No             | Medium          |
|                92472 | STOR-571    | https://jira.t-mobile.com/browse/STOR-571   | Node firmware upgrade on pxnas001                               | Story        | Yasaswi Mahadasu  |  20171023101207 | 2017-10-23 10:11:05.760 | STOR          |                |          | STOR-65     | 2018-02-21 10:27:10.576 | Yasaswi Mahadasu | Done     | yes           | STOR-571-Node firmware upgrade on pxnas001                               | 2018 - Keep the Lights On (STOR)                                | Done                    | https://jira.t-mobile.com/rest/api/2/issue/114180 |                 114180 | ymahada         | ymahada         | No             | Medium          |
|               100194 | STOR-615    | https://jira.t-mobile.com/browse/STOR-615   | Sprint Placeholder                                              | Config Item  | Stephen Costanzo  |  20171208103208 | 2017-12-08 10:31:48.046 | STOR          |                |          |             |                         | Stephen Costanzo | To Do    | yes           | STOR-615-Sprint Placeholder                                              |                                                                 |                         | https://jira.t-mobile.com/rest/api/2/issue/124319 |                 124319 | scostan         | scostan         | No             | Medium          |
|               101405 | INFAOP-325  | https://jira.t-mobile.com/browse/INFAOP-325 | Migrate SAP NPE servers mail relay server to AD                 | Story        | Santhosh Padiyath |  20171215114221 | 2017-12-15 11:34:23.826 | INFAOP        | 2              |          | INFUOP-1045 |                         | Muqtadir Abdul   | To Do    | yes           | INFAOP-325-Migrate SAP NPE servers mail relay server to AD               | 2018 - UNIX - General Platform Modernization                    |                         | https://jira.t-mobile.com/rest/api/2/issue/125770 |                 125770 | spadiya1        | mabdul1         | Yes            | Medium          |
|               105970 | STOR-723    | https://jira.t-mobile.com/browse/STOR-723   | Upgrade ENG VMAX3 Arrays to Cypress code level w/latest build   | Story        | Steven Thaanum    |  20180118101212 | 2018-01-18 10:10:37.016 | STOR          |                |          | STOR-65     | 2018-03-07 09:12:46.880 | Steven Thaanum   | Done     | yes           | STOR-723-Upgrade ENG VMAX3 Arrays to Cypress code level w/latest build   | 2018 - Keep the Lights On (STOR)                                | Done                    | https://jira.t-mobile.com/rest/api/2/issue/131126 |                 131126 | sthaanu1        | sthaanu1        | No             | Medium          |
|               107956 | STOR-767    | https://jira.t-mobile.com/browse/STOR-767   | Analyze VS2 Vplex arrays in Polaris and Titan                   | Story        | Hochoon Lee       |  20180129132223 | 2018-01-29 13:15:41.666 | STOR          |                |          | STOR-806    | 2018-04-04 09:54:17.476 | Hochoon Lee      | Done     | yes           | STOR-767-Analyze VS2 Vplex arrays in Polaris and Titan                   | 2018 SAN Migration to new storage                               | Done                    | https://jira.t-mobile.com/rest/api/2/issue/133215 |                 133215 | hlee33          | hlee33          | No             | Medium          |
|               108577 | STOR-770    | https://jira.t-mobile.com/browse/STOR-770   | Attach EMCTTN10 to SE servers/Unisphere and configure the array | Story        | Hochoon Lee       |  20180131132213 | 2018-01-31 13:16:02.440 | STOR          |                |          | STOR-65     | 2018-02-08 10:09:02.603 | Hochoon Lee      | Done     | yes           | STOR-770-Attach EMCTTN10 to SE servers/Unisphere and configure the array | 2018 - Keep the Lights On (STOR)                                | Done                    | https://jira.t-mobile.com/rest/api/2/issue/133952 |                 133952 | hlee33          | hlee33          | No             | Medium          |
|               109195 | STOR-775    | https://jira.t-mobile.com/browse/STOR-775   | SnapVX - daily script                                           | Story        | Clint Simmons     |  20180202100215 | 2018-02-02 10:00:40.076 | STOR          |                |          | STOR-805    | 2018-05-07 12:12:09.786 | Clint Simmons    | Done     | yes           | STOR-775-SnapVX - daily script                                           | Automation of SAN Storage Processes                             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/134474 |                 134474 | csimmon54       | csimmon54       | No             | Medium          |
|               109607 | STOR-777    | https://jira.t-mobile.com/browse/STOR-777   | Decomm PX VMAX 1296                                             | Story        | Patrick Olney     |  20180205161208 | 2018-02-05 16:02:57.570 | STOR          |                |          | STOR-51     | 2018-03-21 10:37:54.696 | Patrick Olney    | Done     | yes           | STOR-777-Decomm PX VMAX 1296                                             | Infrastructure Transformation - LDOS                            | Done                    | https://jira.t-mobile.com/rest/api/2/issue/134696 |                 134696 | polney          | polney          | No             | Medium          |
|               109877 | STOR-779    | https://jira.t-mobile.com/browse/STOR-779   | Upgrade PCC/PCF SAN Switches to 8.2.1                           | Story        | Robert Glasser    |  20180206163212 | 2018-02-06 16:27:15.123 | STOR          |                |          | STOR-1371   | 2018-02-13 10:15:17.696 | Robert Glasser   | Done     | yes           | STOR-779-Upgrade PCC/PCF SAN Switches to 8.2.1                           | Work associated with set up and support of new pod environments | Done                    | https://jira.t-mobile.com/rest/api/2/issue/135230 |                 135230 | rglasse         | rglasse         | No             | Medium          |


Table: All Story Data
|   DW Unique Issue ID | Issue Key   | Issue_URL                                  | summary                                                                           | Issue Type   | Reporter   |   Created By ID | Issue Created           | Project Key   | Story Points   | Labels   | Epic Key   | Resolution Date   | Assignee   | Status   | InAnySprint   | CombinedSummary                                                                             | Epic_Name   | resolution_short_desc   | Rest_URL                                          |   JIRA Unique Issue ID | Reporter_NTID   | Assignee_NTID   | Epic Unique ID   | priority_desc   |
|---------------------:|:------------|:-------------------------------------------|:----------------------------------------------------------------------------------|:-------------|:-----------|----------------:|:------------------------|:--------------|:---------------|:---------|:-----------|:------------------|:-----------|:---------|:--------------|:--------------------------------------------------------------------------------------------|:------------|:------------------------|:--------------------------------------------------|-----------------------:|:----------------|:----------------|:-----------------|:----------------|
|               171473 | SNOW-5306   | https://jira.t-mobile.com/browse/SNOW-5306 | Verify Search for a server in cmdb                                                | Test         | Ankit Shah |  20180904055217 | 2018-09-04 05:52:23.976 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5306-Verify Search for a server in cmdb                                                |             |                         | https://jira.t-mobile.com/rest/api/2/issue/205324 |                 205324 | ashah34         | ashah34         |                  | Major           |
|               171823 | SNOW-5323   | https://jira.t-mobile.com/browse/SNOW-5323 | Verify Search of KB article in knowledge base                                     | Test         | Ankit Shah |  20180904225208 | 2018-09-04 22:51:21.530 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5323-Verify Search of KB article in knowledge base                                     |             |                         | https://jira.t-mobile.com/rest/api/2/issue/205470 |                 205470 | ashah34         | ashah34         |                  | Major           |
|               171833 | SNOW-5326   | https://jira.t-mobile.com/browse/SNOW-5326 | Validate Request for Non-Standard Server                                          | Test         | Ankit Shah |  20180905005220 | 2018-09-05 00:48:06.576 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5326-Validate Request for Non-Standard Server                                          |             |                         | https://jira.t-mobile.com/rest/api/2/issue/205473 |                 205473 | ashah34         | ashah34         |                  | Major           |
|               173008 | SNOW-5384   | https://jira.t-mobile.com/browse/SNOW-5384 | ServiceNow - New Non-Standard Server request - User Manager Rejection             | Test         | Ankit Shah |  20180910005313 | 2018-09-10 00:52:12.350 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5384-ServiceNow - New Non-Standard Server request - User Manager Rejection             |             |                         | https://jira.t-mobile.com/rest/api/2/issue/206574 |                 206574 | ashah34         | ashah34         |                  | Major           |
|               173012 | SNOW-5387   | https://jira.t-mobile.com/browse/SNOW-5387 | Validate New Non-Standard Server request for Non Virtual Server                   | Test         | Ankit Shah |  20180910020214 | 2018-09-10 01:55:35.623 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5387-Validate New Non-Standard Server request for Non Virtual Server                   |             |                         | https://jira.t-mobile.com/rest/api/2/issue/206578 |                 206578 | ashah34         | ashah34         |                  | Major           |
|               173013 | SNOW-5388   | https://jira.t-mobile.com/browse/SNOW-5388 | ServiceNow - New Non-Standard Server - Close complete task status                 | Test         | Ankit Shah |  20180910023212 | 2018-09-10 02:24:27.246 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5388-ServiceNow - New Non-Standard Server - Close complete task status                 |             |                         | https://jira.t-mobile.com/rest/api/2/issue/206579 |                 206579 | ashah34         | ashah34         |                  | Major           |
|               174007 | SNOW-5425   | https://jira.t-mobile.com/browse/SNOW-5425 | Verify Submit Request for Access Troubleshooting Request                          | Test         | Ankit Shah |  20180912064210 | 2018-09-12 06:33:48.583 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5425-Verify Submit Request for Access Troubleshooting Request                          |             |                         | https://jira.t-mobile.com/rest/api/2/issue/208177 |                 208177 | ashah34         | ashah34         |                  | Major           |
|               174403 | SNOW-5433   | https://jira.t-mobile.com/browse/SNOW-5433 | Verify Submit Request for Manage and Resolve Application Security Vulnerabilities | Test         | Ankit Shah |  20180912234208 | 2018-09-12 23:36:37.393 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5433-Verify Submit Request for Manage and Resolve Application Security Vulnerabilities |             |                         | https://jira.t-mobile.com/rest/api/2/issue/208649 |                 208649 | ashah34         | ashah34         |                  | Major           |
|               174451 | SNOW-5440   | https://jira.t-mobile.com/browse/SNOW-5440 | Validate the completion flow for Application Capacity Assessment                  | Test         | Ankit Shah |  20180913042212 | 2018-09-13 04:22:20.173 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5440-Validate the completion flow for Application Capacity Assessment                  |             |                         | https://jira.t-mobile.com/rest/api/2/issue/208664 |                 208664 | ashah34         | ashah34         |                  | Major           |
|               174472 | SNOW-5448   | https://jira.t-mobile.com/browse/SNOW-5448 | Verify Submit Request for Application Support                                     | Test         | Ankit Shah |  20180913064211 | 2018-09-13 06:37:07.326 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5448-Verify Submit Request for Application Support                                     |             |                         | https://jira.t-mobile.com/rest/api/2/issue/208679 |                 208679 | ashah34         | ashah34         |                  | Major           |


Table: Current Year Control
| Current Year   |
|:---------------|
| Yes            |
| No             |


Table: Epic_Xref
|   JIRA Unique Issue ID |   DW Unique Issue ID | Epic Key   | Epic Summary                                                                      | Project Key   | Initiative Link   | Labels   | Epic_URL                                   | Rest_URL                                          | Epic Closed   | Issue Type   |
|-----------------------:|---------------------:|:-----------|:----------------------------------------------------------------------------------|:--------------|:------------------|:---------|:-------------------------------------------|:--------------------------------------------------|:--------------|:-------------|
|                  73520 |                47665 | SNOW-7206  | Agile/Scrum                                                                       | SNOW          |                   |          | https://jira.t-mobile.com/browse/SNOW-7206 | https://jira.t-mobile.com/rest/api/2/issue/73520  |               | Epic         |
|                  92628 |                65234 | SNOW-7205  | Strategic                                                                         | SNOW          |                   |          | https://jira.t-mobile.com/browse/SNOW-7205 | https://jira.t-mobile.com/rest/api/2/issue/92628  |               | Epic         |
|                 131188 |               106103 | SNOW-7215  | Test Plan                                                                         | SNOW          |                   |          | https://jira.t-mobile.com/browse/SNOW-7215 | https://jira.t-mobile.com/rest/api/2/issue/131188 |               | Epic         |
|                 132387 |               107177 | SNOW-7214  | Test Plan                                                                         | SNOW          |                   |          | https://jira.t-mobile.com/browse/SNOW-7214 | https://jira.t-mobile.com/rest/api/2/issue/132387 |               | Epic         |
|                 133250 |               108046 | SNOW-7210  | Test Plan                                                                         | SNOW          |                   |          | https://jira.t-mobile.com/browse/SNOW-7210 | https://jira.t-mobile.com/rest/api/2/issue/133250 |               | Epic         |
|                 135303 |               109890 | SNOW-7104  | Relaince form 763 SAP R3 H1 - New Emergency Access Request (EIT) requirements     | SNOW          |                   |          | https://jira.t-mobile.com/browse/SNOW-7104 | https://jira.t-mobile.com/rest/api/2/issue/135303 |               | Epic         |
|                 136723 |               111333 | SNOW-7213  | Test Plan                                                                         | SNOW          |                   |          | https://jira.t-mobile.com/browse/SNOW-7213 | https://jira.t-mobile.com/rest/api/2/issue/136723 |               | Epic         |
|                 139375 |               113859 | SNOW-7202  | Catalog Item: Computer: Move/Relocate/Setup Bugs                                  | SNOW          |                   |          | https://jira.t-mobile.com/browse/SNOW-7202 | https://jira.t-mobile.com/rest/api/2/issue/139375 |               | Epic         |
|                 139636 |               114005 | SNOW-7212  | Test Plan                                                                         | SNOW          |                   |          | https://jira.t-mobile.com/browse/SNOW-7212 | https://jira.t-mobile.com/rest/api/2/issue/139636 |               | Epic         |
|                 140700 |               114890 | SNOW-7211  | Test plan 2   Reliance Form: Desk Phone: New Phone / Extension - Corporate/Market | SNOW          |                   |          | https://jira.t-mobile.com/browse/SNOW-7211 | https://jira.t-mobile.com/rest/api/2/issue/140700 |               | Epic         |


Table: ForecastedBacklogCompletion
| jira_proj_key_cd   | RemainingStoryPoints   |   Pointed_Stories |   Total_Stories | Average_Velocity   |   Average_Issue_Velocity | proj_forecast_method   |   RemainingSprints | UnestimatedIssues   |   Avg_Velocity |   Remain_For_Estimate | PercNotEstimated    |
|:-------------------|:-----------------------|------------------:|----------------:|:-------------------|-------------------------:|:-----------------------|-------------------:|:--------------------|---------------:|----------------------:|:--------------------|
| INFAOP             | 159                    |                39 |              41 | 37                 |                       13 | Story Points           |                  5 | 2                   |             37 |                   159 | 0.04878048780487805 |
| INFUOP             | 184                    |                26 |              40 | 38                 |                       16 | Story Points           |                  5 | 14                  |             38 |                   184 | 0.35                |
| NAS                |                        |                 0 |             100 |                    |                       15 | Issues                 |                  7 |                     |             15 |                   100 |                     |
| STOR               | 57                     |                16 |             110 | 15                 |                       13 | Issues                 |                  9 |                     |             13 |                   110 |                     |
| SNOW               | 283                    |                61 |            1368 | 12                 |                        5 |                        |                274 |                     |              5 |                  1368 |                     |


Table: InitiativeLink_Project
|   Initiative DWKey | Initiative JIRA Key   | Initiative Summary     |   Epic DWKey | Epic JIRA Key   | Epic Summary                                                  | Project   |   Project DWKey |   Component Name |
|-------------------:|:----------------------|:-----------------------|-------------:|:----------------|:--------------------------------------------------------------|:----------|----------------:|-----------------:|
|             110094 | UI-453                | Platform Modernization |        32639 | STOR-45         | Install and migration of NAS for active use                   | STOR      |             142 |             2018 |
|             110094 | UI-453                | Platform Modernization |        32652 | STOR-53         | Retire all remaining Celerra devices at HUB sites             | STOR      |             142 |             2018 |
|             110094 | UI-453                | Platform Modernization |        37518 | STOR-153        | Modify and Deploy  Isilon "A" cluster in Polaris(pxnas001)    | STOR      |             142 |             2018 |
|             110094 | UI-453                | Platform Modernization |        37933 | STOR-182        | Migrate Atlanta Celerra data to new SVM                       | STOR      |             142 |             2018 |
|             110094 | UI-453                | Platform Modernization |        56493 | INFUOP-528      | 2018 - UNIX - San Migration                                   | INFUOP    |             222 |             2018 |
|             110094 | UI-453                | Platform Modernization |        56499 | INFUOP-11       | 2018 - NAS Migration                                          | INFUOP    |             222 |             2018 |
|             110094 | UI-453                | Platform Modernization |        64251 | INFAOP-211      | 2018 - AIX upgrade from 6.1 to 7.2                            | INFAOP    |             317 |             2018 |
|             110094 | UI-453                | Platform Modernization |        65004 | STOR-403        | ENG SAN DECOMMS                                               | STOR      |             142 |             2018 |
|             110094 | UI-453                | Platform Modernization |        68871 | STOR-453        | Deploy Cisco MDS 9718 in new Core w/ 32GB modules and support | STOR      |             142 |             2018 |
|             110094 | UI-453                | Platform Modernization |        87814 | STOR-538        | Migrate VSWPublic from VNX to NetApp                          | STOR      |             142 |             2018 |


Table: JIRA_Projects
|   jira_proj_dwkey | jira_proj_name                 | jira_proj_category_name   | jira_proj_type_desc   | jira_proj_lead   | jira_proj_key_cd   | product_owner_name   |   source_jira_proj_id | proj_active_indicator   |   created_by_id | created_dt              |   modified_by_id | modified_dt             | active_flg   |
|------------------:|:-------------------------------|:--------------------------|:----------------------|:-----------------|:-------------------|:---------------------|----------------------:|:------------------------|----------------:|:------------------------|-----------------:|:------------------------|:-------------|
|               142 | Storage Team                   | Infrastructure Services   | software              | csimmon54        | STOR               |                      |                 11906 | Y                       |  20161222123108 | 2016-12-22 20:31:11.030 |   20170823064216 | 2017-08-23 13:42:20.486 | Y            |
|               156 | ServiceNow                     | TWS Customer Facing       | software              | mfly             | SNOW               | tglass               |                 12201 | Y                       |  20170117142210 | 2017-01-17 22:22:13.920 |   20181010134226 | 2018-10-10 20:42:29.846 | Y            |
|               222 | Infrastructure Unix Operations |                           | software              | vstapon          | INFUOP             |                      |                 13100 | Y                       |  20170419075211 | 2017-04-19 14:52:14.106 |   20171027142218 | 2017-10-27 21:22:23.956 | Y            |
|               317 | Infrastructure AIX Operations  |                           | software              | spadiya1         | INFAOP             |                      |                 15200 | Y                       |  20171113125214 | 2017-11-13 20:52:18.290 |   20180327084211 | 2018-03-27 15:42:16.656 | Y            |
|               426 | Network Attached Storage       |                           | software              | scostan          | NAS                |                      |                 19601 | Y                       |  20180627092207 | 2018-06-27 16:22:10.940 |   20180705115212 | 2018-07-05 18:52:18.653 | Y            |


Table: LastRefresh
| LastRefresh_ServerTime   | LastRefresh_Local       |
|:-------------------------|:------------------------|
| 2019-01-08 08:15:31.850  | 2019-01-08 08:14:56.000 |


Table: Range366
| Title      | Rolling_Months   |   Sorting |
|:-----------|:-----------------|----------:|
| Rolling 3  | Last 3 Months    |         1 |
| Rolling 6  | Last 3 Months    |         2 |
| Rolling 6  | Last 6 Months    |         2 |
| Rolling 12 | Last 12 Months   |         3 |
| Rolling 12 | Last 3 Months    |         3 |
| Rolling 12 | Last 6 Months    |         3 |


Table: rpt_ActiveSprintData
| jira_proj_key_cd   | sprint_name      | sprint_start_dt         | sprint_end_dt           | DayByDay                |   Issues |   Story Points | Burndown_SP   | Burndown_Issues   | Graph_SP   | Graph_Issues   | Graph_Today_SP   | Graph_Today_Issues   | Added_SP   | Added_Issues   |
|:-------------------|:-----------------|:------------------------|:------------------------|:------------------------|---------:|---------------:|:--------------|:------------------|:-----------|:---------------|:-----------------|:---------------------|:-----------|:---------------|
| INFAOP             | INFOP_2019-01-01 | 2019-01-03 00:00:00.000 | 2019-01-15 00:00:00.000 | 2019-01-04 00:00:00.000 |       11 |             37 |               |                   | 37         | 11             |                  |                      | 5          | 1              |
| INFAOP             | INFOP_2019-01-01 | 2019-01-03 00:00:00.000 | 2019-01-15 00:00:00.000 | 2019-01-05 00:00:00.000 |       11 |             37 |               |                   | 37         | 11             |                  |                      | 5          | 1              |
| INFAOP             | INFOP_2019-01-01 | 2019-01-03 00:00:00.000 | 2019-01-15 00:00:00.000 | 2019-01-06 00:00:00.000 |       11 |             37 |               |                   | 37         | 11             |                  |                      | 5          | 1              |
| INFAOP             | INFOP_2019-01-01 | 2019-01-03 00:00:00.000 | 2019-01-15 00:00:00.000 | 2019-01-07 00:00:00.000 |       11 |             37 |               |                   | 37         | 11             | 37               | 11                   | 5          | 1              |
| INFAOP             | INFOP_2019-01-01 | 2019-01-03 00:00:00.000 | 2019-01-15 00:00:00.000 | 2019-01-08 00:00:00.000 |       11 |             37 |               |                   |            |                | 37               | 11                   | 5          | 1              |
| INFAOP             | INFOP_2019-01-01 | 2019-01-03 00:00:00.000 | 2019-01-15 00:00:00.000 | 2019-01-09 00:00:00.000 |       11 |             37 |               |                   |            |                |                  |                      |            |                |
| INFAOP             | INFOP_2019-01-01 | 2019-01-03 00:00:00.000 | 2019-01-15 00:00:00.000 | 2019-01-10 00:00:00.000 |       11 |             37 |               |                   |            |                |                  |                      |            |                |
| INFAOP             | INFOP_2019-01-01 | 2019-01-03 00:00:00.000 | 2019-01-15 00:00:00.000 | 2019-01-11 00:00:00.000 |       11 |             37 |               |                   |            |                |                  |                      |            |                |
| INFAOP             | INFOP_2019-01-01 | 2019-01-03 00:00:00.000 | 2019-01-15 00:00:00.000 | 2019-01-12 00:00:00.000 |       11 |             37 |               |                   |            |                |                  |                      |            |                |
| INFAOP             | INFOP_2019-01-01 | 2019-01-03 00:00:00.000 | 2019-01-15 00:00:00.000 | 2019-01-13 00:00:00.000 |       11 |             37 |               |                   |            |                |                  |                      |            |                |


Table: rpt_Merged_Story
|   DW Unique Issue ID | Issue Key   | Issue_URL                                  | summary                                                                                 | Issue Type   | Reporter   |   Created By ID | Issue Created           | Project Key   | Story Points   | Labels   | Epic Key   | Epic DWKey   | Resolution Date   | Assignee   | Status   | InAnySprint   | CombinedSummary                                                                                   | Epic_Name   | resolution_short_desc   | Story_Rest_URL                                    |   JIRA Unique Issue ID | Reporter_NTID   | Assignee_NTID   | Component Name   | Initiative DWKey   | Initiative JIRA Key   | Initiative Summary   | Initiative Combined   |   Matrix_Order | priority_desc   |
|---------------------:|:------------|:-------------------------------------------|:----------------------------------------------------------------------------------------|:-------------|:-----------|----------------:|:------------------------|:--------------|:---------------|:---------|:-----------|:-------------|:------------------|:-----------|:---------|:--------------|:--------------------------------------------------------------------------------------------------|:------------|:------------------------|:--------------------------------------------------|-----------------------:|:----------------|:----------------|:-----------------|:-------------------|:----------------------|:---------------------|:----------------------|---------------:|:----------------|
|               171478 | SNOW-5307   | https://jira.t-mobile.com/browse/SNOW-5307 | Verify the selection of server in cmdb                                                  | Test         | Ankit Shah |  20180904062206 | 2018-09-04 06:15:11.130 | SNOW          |                |          |            |              |                   | Ankit Shah | Pending  | no            | SNOW-5307-Verify the selection of server in cmdb                                                  |             |                         | https://jira.t-mobile.com/rest/api/2/issue/205326 |                 205326 | ashah34         | ashah34         |                  |                    |                       |                      |                       |              1 | Major           |
|               171828 | SNOW-5324   | https://jira.t-mobile.com/browse/SNOW-5324 | Verify the Knowledge base data on selection of  record                                  | Test         | Ankit Shah |  20180904234234 | 2018-09-04 23:40:58.526 | SNOW          |                |          |            |              |                   | Ankit Shah | Pending  | no            | SNOW-5324-Verify the Knowledge base data on selection of  record                                  |             |                         | https://jira.t-mobile.com/rest/api/2/issue/205471 |                 205471 | ashah34         | ashah34         |                  |                    |                       |                      |                       |              1 | Major           |
|               173007 | SNOW-5383   | https://jira.t-mobile.com/browse/SNOW-5383 | ServiceNow - New Non-Standard Server request - User Manager Approval                    | Test         | Ankit Shah |  20180910005313 | 2018-09-10 00:47:04.366 | SNOW          |                |          |            |              |                   | Ankit Shah | Pending  | no            | SNOW-5383-ServiceNow - New Non-Standard Server request - User Manager Approval                    |             |                         | https://jira.t-mobile.com/rest/api/2/issue/206573 |                 206573 | ashah34         | ashah34         |                  |                    |                       |                      |                       |              1 | Major           |
|               173014 | SNOW-5389   | https://jira.t-mobile.com/browse/SNOW-5389 | ServiceNow - New Non-Standard Server - Closed Incomplete task status                    | Test         | Ankit Shah |  20180910024212 | 2018-09-10 02:40:49.363 | SNOW          |                |          |            |              |                   | Ankit Shah | Pending  | no            | SNOW-5389- ServiceNow - New Non-Standard Server - Closed Incomplete task status                   |             |                         | https://jira.t-mobile.com/rest/api/2/issue/206580 |                 206580 | ashah34         | ashah34         |                  |                    |                       |                      |                       |              1 | Major           |
|               174397 | SNOW-5430   | https://jira.t-mobile.com/browse/SNOW-5430 | Verify Submit Request for  Auditing and Compliance                                      | Test         | Ankit Shah |  20180912232211 | 2018-09-12 23:18:47.516 | SNOW          |                |          |            |              |                   | Ankit Shah | Pending  | no            | SNOW-5430-Verify Submit Request for  Auditing and Compliance                                      |             |                         | https://jira.t-mobile.com/rest/api/2/issue/208643 |                 208643 | ashah34         | ashah34         |                  |                    |                       |                      |                       |              1 | Major           |
|               175280 | SNOW-5463   | https://jira.t-mobile.com/browse/SNOW-5463 | Verify Submit Request for Production Release                                            | Test         | Ankit Shah |  20180917003218 | 2018-09-17 00:31:37.140 | SNOW          |                |          |            |              |                   | Ankit Shah | Pending  | no            | SNOW-5463-Verify Submit Request for Production Release                                            |             |                         | https://jira.t-mobile.com/rest/api/2/issue/209717 |                 209717 | ashah34         | ashah34         |                  |                    |                       |                      |                       |              1 | Major           |
|               175287 | SNOW-5465   | https://jira.t-mobile.com/browse/SNOW-5465 | Verify Submit Request for Web Content Service                                           | Test         | Ankit Shah |  20180917013207 | 2018-09-17 01:22:48.343 | SNOW          |                |          |            |              |                   | Ankit Shah | Pending  | no            | SNOW-5465-Verify Submit Request for Web Content Service                                           |             |                         | https://jira.t-mobile.com/rest/api/2/issue/209724 |                 209724 | ashah34         | ashah34         |                  |                    |                       |                      |                       |              1 | Major           |
|               175338 | SNOW-5471   | https://jira.t-mobile.com/browse/SNOW-5471 | Verify Submit Request for Cloud Tools                                                   | Test         | Ankit Shah |  20180917055317 | 2018-09-17 05:46:57.270 | SNOW          |                |          |            |              |                   | Ankit Shah | Pending  | no            | SNOW-5471-Verify Submit Request for Cloud Tools                                                   |             |                         | https://jira.t-mobile.com/rest/api/2/issue/209626 |                 209626 | ashah34         | ashah34         |                  |                    |                       |                      |                       |              1 | Major           |
|               175730 | SNOW-5475   | https://jira.t-mobile.com/browse/SNOW-5475 | Verify Submit Request for  Data Backup & Restore Request  -- Enable new server backup   | Test         | Ankit Shah |  20180917222319 | 2018-09-17 22:22:44.973 | SNOW          |                |          |            |              |                   | Ankit Shah | Pending  | no            | SNOW-5475-Verify Submit Request for  Data Backup & Restore Request  -- Enable new server backup   |             |                         | https://jira.t-mobile.com/rest/api/2/issue/209936 |                 209936 | ashah34         | ashah34         |                  |                    |                       |                      |                       |              1 | Major           |
|               175731 | SNOW-5476   | https://jira.t-mobile.com/browse/SNOW-5476 | Verify Submit Request for  Data Backup & Restore Request  -- Restore server from backup | Test         | Ankit Shah |  20180917223208 | 2018-09-17 22:24:43.166 | SNOW          |                |          |            |              |                   | Ankit Shah | Pending  | no            | SNOW-5476-Verify Submit Request for  Data Backup & Restore Request  -- Restore server from backup |             |                         | https://jira.t-mobile.com/rest/api/2/issue/209937 |                 209937 | ashah34         | ashah34         |                  |                    |                       |                      |                       |              1 | Major           |


Table: rpt_Merged_StoryXSprintData
|   DW Unique Issue ID | Issue Key   | Issue_URL                                  | summary                                                                                 | Issue Type   | Reporter   |   Created By ID | Issue Created           | Project Key   | Story Points   | Labels   | Epic Key   | Resolution Date   | Assignee   | Status   | InAnySprint   | CombinedSummary                                                                                   | Epic_Name   | resolution_short_desc   | Story_Rest_URL                                    |   JIRA Unique Issue ID | Reporter_NTID   | Assignee_NTID   | Sprint ID   | sprint_name_corrected   | CY_Sprint   | Initiative JIRA Key   | Initiative Summary   | Initiative Combined   | Epic DWKey   |   Matrix_Order | Component Name   | Initiative DWKey   | priority_desc   |
|---------------------:|:------------|:-------------------------------------------|:----------------------------------------------------------------------------------------|:-------------|:-----------|----------------:|:------------------------|:--------------|:---------------|:---------|:-----------|:------------------|:-----------|:---------|:--------------|:--------------------------------------------------------------------------------------------------|:------------|:------------------------|:--------------------------------------------------|-----------------------:|:----------------|:----------------|:------------|:------------------------|:------------|:----------------------|:---------------------|:----------------------|:-------------|---------------:|:-----------------|:-------------------|:----------------|
|               171478 | SNOW-5307   | https://jira.t-mobile.com/browse/SNOW-5307 | Verify the selection of server in cmdb                                                  | Test         | Ankit Shah |  20180904062206 | 2018-09-04 06:15:11.130 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5307-Verify the selection of server in cmdb                                                  |             |                         | https://jira.t-mobile.com/rest/api/2/issue/205326 |                 205326 | ashah34         | ashah34         |             |                         |             |                       |                      |                       |              |              1 |                  |                    | Major           |
|               171828 | SNOW-5324   | https://jira.t-mobile.com/browse/SNOW-5324 | Verify the Knowledge base data on selection of  record                                  | Test         | Ankit Shah |  20180904234234 | 2018-09-04 23:40:58.526 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5324-Verify the Knowledge base data on selection of  record                                  |             |                         | https://jira.t-mobile.com/rest/api/2/issue/205471 |                 205471 | ashah34         | ashah34         |             |                         |             |                       |                      |                       |              |              1 |                  |                    | Major           |
|               173007 | SNOW-5383   | https://jira.t-mobile.com/browse/SNOW-5383 | ServiceNow - New Non-Standard Server request - User Manager Approval                    | Test         | Ankit Shah |  20180910005313 | 2018-09-10 00:47:04.366 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5383-ServiceNow - New Non-Standard Server request - User Manager Approval                    |             |                         | https://jira.t-mobile.com/rest/api/2/issue/206573 |                 206573 | ashah34         | ashah34         |             |                         |             |                       |                      |                       |              |              1 |                  |                    | Major           |
|               173014 | SNOW-5389   | https://jira.t-mobile.com/browse/SNOW-5389 | ServiceNow - New Non-Standard Server - Closed Incomplete task status                    | Test         | Ankit Shah |  20180910024212 | 2018-09-10 02:40:49.363 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5389- ServiceNow - New Non-Standard Server - Closed Incomplete task status                   |             |                         | https://jira.t-mobile.com/rest/api/2/issue/206580 |                 206580 | ashah34         | ashah34         |             |                         |             |                       |                      |                       |              |              1 |                  |                    | Major           |
|               174397 | SNOW-5430   | https://jira.t-mobile.com/browse/SNOW-5430 | Verify Submit Request for  Auditing and Compliance                                      | Test         | Ankit Shah |  20180912232211 | 2018-09-12 23:18:47.516 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5430-Verify Submit Request for  Auditing and Compliance                                      |             |                         | https://jira.t-mobile.com/rest/api/2/issue/208643 |                 208643 | ashah34         | ashah34         |             |                         |             |                       |                      |                       |              |              1 |                  |                    | Major           |
|               175280 | SNOW-5463   | https://jira.t-mobile.com/browse/SNOW-5463 | Verify Submit Request for Production Release                                            | Test         | Ankit Shah |  20180917003218 | 2018-09-17 00:31:37.140 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5463-Verify Submit Request for Production Release                                            |             |                         | https://jira.t-mobile.com/rest/api/2/issue/209717 |                 209717 | ashah34         | ashah34         |             |                         |             |                       |                      |                       |              |              1 |                  |                    | Major           |
|               175287 | SNOW-5465   | https://jira.t-mobile.com/browse/SNOW-5465 | Verify Submit Request for Web Content Service                                           | Test         | Ankit Shah |  20180917013207 | 2018-09-17 01:22:48.343 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5465-Verify Submit Request for Web Content Service                                           |             |                         | https://jira.t-mobile.com/rest/api/2/issue/209724 |                 209724 | ashah34         | ashah34         |             |                         |             |                       |                      |                       |              |              1 |                  |                    | Major           |
|               175338 | SNOW-5471   | https://jira.t-mobile.com/browse/SNOW-5471 | Verify Submit Request for Cloud Tools                                                   | Test         | Ankit Shah |  20180917055317 | 2018-09-17 05:46:57.270 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5471-Verify Submit Request for Cloud Tools                                                   |             |                         | https://jira.t-mobile.com/rest/api/2/issue/209626 |                 209626 | ashah34         | ashah34         |             |                         |             |                       |                      |                       |              |              1 |                  |                    | Major           |
|               175730 | SNOW-5475   | https://jira.t-mobile.com/browse/SNOW-5475 | Verify Submit Request for  Data Backup & Restore Request  -- Enable new server backup   | Test         | Ankit Shah |  20180917222319 | 2018-09-17 22:22:44.973 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5475-Verify Submit Request for  Data Backup & Restore Request  -- Enable new server backup   |             |                         | https://jira.t-mobile.com/rest/api/2/issue/209936 |                 209936 | ashah34         | ashah34         |             |                         |             |                       |                      |                       |              |              1 |                  |                    | Major           |
|               175731 | SNOW-5476   | https://jira.t-mobile.com/browse/SNOW-5476 | Verify Submit Request for  Data Backup & Restore Request  -- Restore server from backup | Test         | Ankit Shah |  20180917223208 | 2018-09-17 22:24:43.166 | SNOW          |                |          |            |                   | Ankit Shah | Pending  | no            | SNOW-5476-Verify Submit Request for  Data Backup & Restore Request  -- Restore server from backup |             |                         | https://jira.t-mobile.com/rest/api/2/issue/209937 |                 209937 | ashah34         | ashah34         |             |                         |             |                       |                      |                       |              |              1 |                  |                    | Major           |


Table: Sprints
|   sprint_id | sprint_name_corrected   | sprint_start_dt         | sprint_complete_dt   | sprint_end_dt           | sprint_goal   | sprint_status   | Current_year   | Display JIRA Sprint   | Rolling_Months   |
|------------:|:------------------------|:------------------------|:---------------------|:------------------------|:--------------|:----------------|:---------------|:----------------------|:-----------------|
|        2651 | SNOW - Sprint 37        | 2019-01-06 22:20:00.000 |                      | 2019-01-20 22:20:00.000 | None          | Active          | Yes            | SNOW - Sprint 37      | Last 3 Months    |
|        2637 | INFOP_2019-01-01        | 2019-01-03 18:00:07.000 |                      | 2019-01-15 18:00:00.000 | None          | Active          | Yes            | 2019-01-01            | Last 3 Months    |


Table: StoryXSprintData
|   DW Unique Issue ID |   JIRA Unique Issue ID | Issue Key   |   Story Points |   Sprint ID | Resolution Date   | Item_Status   | Sprint Name      | Sprint Start Date       | Sprint End Date         | Sprint Complete Date   | Sprint Status   | Current Year   | Reset Status   |   Sprint Completed Story Points |   Committed Points | jira_proj_key_cd   | issue_creation_dt       | Display JIRA Sprint   | Summary                                                                                      | Number of Sprints   |   AddedToSprintSP |   Orig_Committed_SP |   Added_SP | AddedToSprint   | Sprint Modification   | Added_DuringSprint   |   Numeric_AddedToSprint | Issue_URL                                    | Assignee_NTID   | Rolling_Months   |   Sprint_Status_SP |   AddedToSprint_NumericIssue |   FinalOrder |   ResetOrder |   Orig_Committed_Issue | priority_desc   |
|---------------------:|-----------------------:|:------------|---------------:|------------:|:------------------|:--------------|:-----------------|:------------------------|:------------------------|:-----------------------|:----------------|:---------------|:---------------|--------------------------------:|-------------------:|:-------------------|:------------------------|:----------------------|:---------------------------------------------------------------------------------------------|:--------------------|------------------:|--------------------:|-----------:|:----------------|:----------------------|:---------------------|------------------------:|:---------------------------------------------|:----------------|:-----------------|-------------------:|-----------------------------:|-------------:|-------------:|-----------------------:|:----------------|
|               101405 |                 125770 | INFAOP-325  |              2 |        2637 |                   | To Do         | INFOP_2019-01-01 | 2019-01-03 18:00:07.000 | 2019-01-15 18:00:00.000 |                        | Active          | Yes            | To Do          |                               0 |                  2 | INFAOP             | 2017-12-15 11:34:23.826 | 2019-01-01            | Migrate SAP NPE servers mail relay server to AD                                              |                     |                 0 |                   2 |          0 |                 |                       |                      |                       1 | https://jira.t-mobile.com/browse/INFAOP-325  | mabdul1         |                  |                  2 |                            0 |            4 |            4 |                      1 | Medium          |
|               111000 |                 136363 | INFAOP-451  |              5 |        2637 |                   | In Progress   | INFOP_2019-01-01 | 2019-01-03 18:00:07.000 | 2019-01-15 18:00:00.000 |                        | Active          | Yes            | In Progress    |                               0 |                  5 | INFAOP             | 2018-02-12 08:40:27.286 | 2019-01-01            | PXIBM210 Frame Rebuild -Phase 2                                                              |                     |                 0 |                   5 |          0 |                 |                       |                      |                       1 | https://jira.t-mobile.com/browse/INFAOP-451  | mabdul1         |                  |                  5 |                            0 |            6 |            6 |                      1 | Medium          |
|               124227 |                 150931 | INFAOP-624  |              2 |        2637 |                   | To Do         | INFOP_2019-01-01 | 2019-01-03 18:00:07.000 | 2019-01-15 18:00:00.000 |                        | Active          | Yes            | To Do          |                               0 |                  2 | INFAOP             | 2018-04-04 20:06:35.400 | 2019-01-01            | automate maint_off after 7 days                                                              |                     |                 0 |                   2 |          0 |                 |                       |                      |                       1 | https://jira.t-mobile.com/browse/INFAOP-624  | spadiya1        |                  |                  2 |                            0 |            4 |            4 |                      1 | Medium          |
|               151002 |                 180032 | SNOW-4493   |              5 |        2651 |                   | To Do         | SNOW - Sprint 37 | 2019-01-06 22:20:00.000 | 2019-01-20 22:20:00.000 |                        | Active          | Yes            | To Do          |                               0 |                  5 | SNOW               | 2018-07-02 11:28:14.000 | SNOW - Sprint 37      | Store 09342 Shows as FTLN when store is open                                                 |                     |                 0 |                   5 |          0 |                 |                       |                      |                       1 | https://jira.t-mobile.com/browse/SNOW-4493   | pcramer         |                  |                  5 |                            0 |            4 |            4 |                      1 | Critical        |
|               164727 |                 197934 | SNOW-6658   |              2 |        2651 |                   | Blocked       | SNOW - Sprint 37 | 2019-01-06 22:20:00.000 | 2019-01-20 22:20:00.000 |                        | Active          | Yes            | Blocked        |                               0 |                  0 | SNOW               | 2018-08-10 14:16:55.950 | SNOW - Sprint 37      | Publishing to Deep IO                                                                        |                     |                 0 |                   0 |          0 |                 |                       |                      |                       1 | https://jira.t-mobile.com/browse/SNOW-6658   | lsauced7        |                  |                  0 |                            0 |            3 |            3 |                      1 | Medium          |
|               187755 |                 222525 | SNOW-6242   |              3 |        2651 |                   | To Do         | SNOW - Sprint 37 | 2019-01-06 22:20:00.000 | 2019-01-20 22:20:00.000 |                        | Active          | Yes            | To Do          |                               0 |                  3 | SNOW               | 2018-10-25 11:02:15.903 | SNOW - Sprint 37      | Automate Service Group Creation and User addition to existing groups for the Magentabox team |                     |                 0 |                   3 |          0 |                 |                       |                      |                       1 | https://jira.t-mobile.com/browse/SNOW-6242   | not matched     |                  |                  3 |                            0 |            4 |            4 |                      1 | Medium          |
|               191437 |                 226282 | SNOW-6433   |              5 |        2651 |                   | To Do         | SNOW - Sprint 37 | 2019-01-06 22:20:00.000 | 2019-01-20 22:20:00.000 |                        | Active          | Yes            | To Do          |                               0 |                  5 | SNOW               | 2018-11-06 13:47:33.733 | SNOW - Sprint 37      | SiteScope Monitoring decom through MAST                                                      |                     |                 0 |                   5 |          0 |                 |                       |                      |                       1 | https://jira.t-mobile.com/browse/SNOW-6433   | not matched     |                  |                  5 |                            0 |            4 |            4 |                      1 | Medium          |
|               192162 |                 227656 | SNOW-8243   |              1 |        2651 |                   | In Progress   | SNOW - Sprint 37 | 2019-01-06 22:20:00.000 | 2019-01-20 22:20:00.000 |                        | Active          | Yes            | In Progress    |                               0 |                  1 | SNOW               | 2018-11-08 13:32:18.720 | SNOW - Sprint 37      | Create  reference between lb pool member's ip address and a server record                    |                     |                 0 |                   1 |          0 |                 |                       |                      |                       1 | https://jira.t-mobile.com/browse/SNOW-8243   | pcramer         |                  |                  1 |                            0 |            6 |            6 |                      1 | Medium          |
|               196856 |                 232474 | INFAOP-990  |              3 |        2637 |                   | In Progress   | INFOP_2019-01-01 | 2019-01-03 18:00:07.000 | 2019-01-15 18:00:00.000 |                        | Active          | Yes            | In Progress    |                               0 |                  3 | INFAOP             | 2018-11-29 11:57:59.920 | 2019-01-01            | update remaining dev_pipeline systems for alt_patching/liveupdate                            |                     |                 0 |                   3 |          0 |                 |                       |                      |                       1 | https://jira.t-mobile.com/browse/INFAOP-990  | akhan130        |                  |                  3 |                            0 |            6 |            6 |                      1 | Medium          |
|               198021 |                 233932 | INFUOP-1362 |              3 |        2637 |                   | In Progress   | INFOP_2019-01-01 | 2019-01-03 18:00:07.000 | 2019-01-15 18:00:00.000 |                        | Active          | Yes            | In Progress    |                               0 |                  3 | INFUOP             | 2018-12-03 23:49:43.496 | 2019-01-01            | EIS Security Deployment servers LDAP to AD conversions                                       |                     |                 0 |                   3 |          0 |                 |                       |                      |                       1 | https://jira.t-mobile.com/browse/INFUOP-1362 | vannapu         |                  |                  3 |                            0 |            6 |            6 |                      1 | Medium          |


Table: StoryXSprintData_RemainAddxProject
| jira_proj_key_cd   |   Sprint ID | Done    | Sprint End Date         |   InitialSP |   AddedSP |   Max_SP |   Days Remaining |   AddedSPNotDone |   AddedIssuesNotDone |   Max_Committed_SP |   Max_Added_SP |   Max_Added_Issues |   Max_Committed_Issues | Perc_ToGo_SP        |   Perc_ScopeCreep_SP |   Perc_ScopeCreep_Issues |   Perc_CreepRemaining_SP |   Perc_CreepRemaining_Issues |   InitialIssuesNotDone |   ToGo_SP |   ToGo_Issues |
|:-------------------|------------:|:--------|:------------------------|------------:|----------:|---------:|-----------------:|-----------------:|---------------------:|-------------------:|---------------:|-------------------:|-----------------------:|:--------------------|---------------------:|-------------------------:|-------------------------:|-----------------------------:|-----------------------:|----------:|--------------:|
| INFAOP             |        2637 | NotDone | 2019-01-15 18:00:00.000 |          32 |         5 |       37 |                7 |                5 |                    1 |                 32 |              5 |                  1 |                     10 | 1                   |              0.15625 |                      0.1 |                        1 |                            1 |                     10 |        37 |            11 |
| SNOW               |        2651 | NotDone | 2019-01-20 22:20:00.000 |          19 |         0 |       21 |               12 |                0 |                    0 |                 19 |              0 |                  0 |                      8 | 0.90476190476190477 |              0       |                      0   |                        0 |                            0 |                      8 |        19 |             8 |
| INFUOP             |        2637 | NotDone | 2019-01-15 18:00:00.000 |          38 |         0 |       49 |                7 |                0 |                    0 |                 47 |              0 |                  0 |                     20 | 0.77551020408163263 |              0       |                      0   |                        0 |                            0 |                     15 |        38 |            15 |
| INFUOP             |        2637 | Done    | 2019-01-15 18:00:00.000 |           9 |         0 |       49 |                7 |                0 |                    0 |                 47 |              0 |                  0 |                     20 |                     |              0       |                      0   |                        0 |                            0 |                      0 |         0 |             0 |


Table: StoryXSprint_Count
|   DW Unique Issue ID | Current_year   |   Number of Sprints | story_points   | Rolling_Months   | Earliest Sprint         | Latest Sprint           |
|---------------------:|:---------------|--------------------:|:---------------|:-----------------|:------------------------|:------------------------|
|               131137 | No             |                   1 |                | Last 6 Months    | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 |
|               131140 | No             |                   1 |                | Last 6 Months    | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 |
|               131141 | No             |                   1 |                | Last 6 Months    | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 |
|               131150 | No             |                   1 |                | Last 6 Months    | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 |
|               131152 | No             |                   1 |                | Last 6 Months    | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 |
|               131153 | No             |                   1 |                | Last 6 Months    | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 |
|               131155 | No             |                   1 |                | Last 6 Months    | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 |
|               131156 | No             |                   1 |                | Last 6 Months    | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 |
|               131157 | No             |                   1 |                | Last 6 Months    | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 |
|               131158 | No             |                   1 |                | Last 6 Months    | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 |


Table: Story_ChangedRecords_Limited_Counts
| sprint_name     |   sprint_id | field_name              | Who_Changed_Full_Name   | jira_proj_key_cd   | Occurred_During_Sprint   | Current_year   |   Instances | sprint_start_dt   | Occurred_DuringSprint   |
|:----------------|------------:|:------------------------|:------------------------|:-------------------|:-------------------------|:---------------|------------:|:------------------|:------------------------|
| SNOW - Sprint 3 |         623 | project                 | Generated               | SNOW               | True                     | No             |           0 |                   |                         |
| SNOW - Sprint 3 |         623 | description             | Generated               | SNOW               | True                     | No             |           0 |                   |                         |
| SNOW - Sprint 3 |         623 | Sprint                  | Generated               | SNOW               | True                     | No             |           0 |                   |                         |
| SNOW - Sprint 3 |         623 | Acceptance Criteria     | Generated               | SNOW               | True                     | No             |           0 |                   |                         |
| SNOW - Sprint 3 |         623 | Story Points            | Generated               | SNOW               | True                     | No             |           0 |                   |                         |
| SNOW - Sprint 3 |         623 | issuetype               | Generated               | SNOW               | True                     | No             |           0 |                   |                         |
| SNOW - Sprint 3 |         623 | Blocked Reason          | Generated               | SNOW               | True                     | No             |           0 |                   |                         |
| SNOW - Sprint 3 |         623 | summary                 | Generated               | SNOW               | True                     | No             |           0 |                   |                         |
| SNOW - Sprint 3 |         623 | Expected Unblocked Date | Generated               | SNOW               | True                     | No             |           0 |                   |                         |
| SNOW - Sprint 4 |         633 | project                 | Generated               | SNOW               | True                     | No             |           0 |                   |                         |


Table: Story_ChangeRecords_Limited
| sprint_name                 |   sprint_id |   jira_issue_dwkey | jira_issue_key_cd   | field_name   | Added_DuringSprint   | Issue_Created_DuringSprint   | old_value_id   | new_value_id   | source_created_dt_history   | issue_creation_dt       | jira_proj_key_cd   | old_value_string   |   new_value_string | changed_by   | history_ID                           | Who_Changed_Full_Name   | Current_year   |   DW Unique Issue ID | CombinedSummary                                                                                  | sprint_complete_dt      | Occurred_DuringSprint   |   Added_StoryPoints |
|:----------------------------|------------:|-------------------:|:--------------------|:-------------|:---------------------|:-----------------------------|:---------------|:---------------|:----------------------------|:------------------------|:-------------------|:-------------------|-------------------:|:-------------|:-------------------------------------|:------------------------|:---------------|---------------------:|:-------------------------------------------------------------------------------------------------|:------------------------|:------------------------|--------------------:|
| SNOW - Sprint 9             |         774 |              61237 | SNOW-1585           | Story Points |                      |                              |                |                | 2017-05-22 13:19:02.720     | 2017-05-22 13:12:03.086 | SNOW               |                    |                  5 | lgustaf2     | AA176BDF-48AF-4916-89E7-3BDC964C31CF | Lesley Gustafson        | No             |                61237 | SNOW-1585-Modify Service Account updates                                                         | 2017-07-11 22:19:34.000 | False                   |                   0 |
| SNOW - Sprint 10            |         874 |              61237 | SNOW-1585           | Story Points |                      |                              |                |                | 2017-05-22 13:19:02.720     | 2017-05-22 13:12:03.086 | SNOW               |                    |                  5 | lgustaf2     | 865C0C8E-2004-4083-84BA-FB2EE8837C25 | Lesley Gustafson        | No             |                61237 | SNOW-1585-Modify Service Account updates                                                         | 2017-07-25 23:04:38.000 | False                   |                   0 |
| SNOW - Sprint 10            |         874 |              61240 | SNOW-1586           | Story Points |                      |                              |                |                | 2017-05-22 13:34:38.203     | 2017-05-22 13:12:44.386 | SNOW               |                    |                  5 | lgustaf2     | F6304F73-1AE4-4B09-91A1-AEC6545AF5C3 | Lesley Gustafson        | No             |                61240 | SNOW-1586-Remove Service Account requirements                                                    | 2017-07-25 23:04:38.000 | False                   |                   0 |
| SNOW - Sprint 12            |        1014 |              64210 | SNOW-1680           | Story Points |                      |                              |                |                | 2017-06-09 15:57:27.993     | 2017-06-09 09:44:58.140 | SNOW               |                    |                  5 | lgustaf2     | 459B1412-C821-42F8-9568-5AA5DE9414E9 | Lesley Gustafson        | No             |                64210 | SNOW-1680-Bulk upload of server to business service relationships                                | 2017-08-22 22:14:28.000 | False                   |                   0 |
| SNOW - Sprint 21            |        1348 |              65023 | SNOW-1752           | Story Points |                      |                              |                |                | 2017-12-04 14:16:47.983     | 2017-06-15 12:33:04.490 | SNOW               |                    |                  5 | lgustaf2     | E5BC2342-6997-40E6-BF7F-0AC0F0D7945B | Lesley Gustafson        | No             |                65023 | SNOW-1752-Integrate vRealize Automation with ServiceNow                                          | 2017-12-27 17:20:19.000 | False                   |                   0 |
| SNOW - Sprint 15            |        1058 |              68378 | SNOW-1843           | Story Points |                      |                              |                |                | 2017-08-16 10:05:34.356     | 2017-07-11 10:41:03.646 | SNOW               |                    |                  5 | lgustaf2     | DCBA5DF2-8B2A-4279-B4AA-16B479E0DEAD | Lesley Gustafson        | No             |                68378 | SNOW-1843-Newly created workstations are not created in the Installed status by default          | 2017-10-03 23:38:08.000 | False                   |                   0 |
| SNOW - Sprint 22            |        1366 |              69150 | SNOW-1885           | Story Points |                      |                              |                |                | 2017-12-18 14:35:05.670     | 2017-07-17 12:56:41.543 | SNOW               |                    |                  5 | lgustaf2     | 14849FE9-54B6-43B2-9D05-EE2D822B29C6 | Lesley Gustafson        | No             |                69150 | SNOW-1885-Create an enterprise process around how to create/gain access to a file share via SNOW | 2018-01-09 23:03:37.000 | False                   |                   0 |
| SNOW - Sprint 19 - Offshore |        1261 |              70760 | SNOW-1944           | Story Points |                      |                              |                |                | 2017-08-16 10:26:16.706     | 2017-07-26 15:20:06.306 | SNOW               |                    |                  5 | lgustaf2     | BF5C47D6-8105-4F59-85FC-3FF034E4717D | Lesley Gustafson        | No             |                70760 | SNOW-1944-Server build provisioning task typos                                                   | 2017-11-27 21:38:35.000 | False                   |                   0 |
| SNOW - Sprint 20 - Offshore |        1311 |              70760 | SNOW-1944           | Story Points |                      |                              |                |                | 2017-08-16 10:26:16.706     | 2017-07-26 15:20:06.306 | SNOW               |                    |                  5 | lgustaf2     | 0E6B1C53-124B-4160-ABDC-4F8CEA85F65A | Lesley Gustafson        | No             |                70760 | SNOW-1944-Server build provisioning task typos                                                   | 2017-12-14 21:41:51.000 | False                   |                   0 |
| SNOW - Sprint 13            |        1016 |              73868 | SNOW-2080           | Story Points |                      |                              |                |                | 2017-08-16 11:28:59.856     | 2017-08-09 15:22:56.286 | SNOW               |                    |                  5 | lgustaf2     | 6AFF4FF2-EB19-4C6E-873A-C189FFF4C1F0 | Lesley Gustafson        | No             |                73868 | SNOW-2080-Provide UNIX team server status access                                                 | 2017-09-06 01:43:15.000 | False                   |                   0 |

 


tables: name: All Story Data - Current Year Marker
data: All Story Data - Current Year Marker.csv
name: All Story Data
data: All Story Data.csv
name: Current Year Control
data: Current Year Control.csv
name: Epic_Xref
data: Epic_Xref.csv
name: ForecastedBacklogCompletion
data: ForecastedBacklogCompletion.csv
name: InitiativeLink_Project
data: InitiativeLink_Project.csv
name: JIRA_Projects
data: JIRA_Projects.csv
name: LastRefresh
data: LastRefresh.csv
name: Range366
data: Range366.csv
name: rpt_ActiveSprintData
data: rpt_ActiveSprintData.csv
name: rpt_Merged_Story
data: rpt_Merged_Story.csv
name: rpt_Merged_StoryXSprintData
data: rpt_Merged_StoryXSprintData.csv
name: Sprints
data: Sprints.csv
name: StoryXSprintData
data: StoryXSprintData.csv
name: StoryXSprintData_RemainAddxProject
data: StoryXSprintData_RemainAddxProject.csv
name: StoryXSprint_Count
data: StoryXSprint_Count.csv
name: Story_ChangedRecords_Limited_Counts
data: Story_ChangedRecords_Limited_Counts.csv
name: Story_ChangeRecords_Limited
data: Story_ChangeRecords_Limited.csv
label: StoryXSprintData
DW Unique Issue ID
All Story Data
DW Unique Issue ID
StoryXSprint_Count
DW Unique Issue ID
All Story Data
DW Unique Issue ID
StoryXSprintData
Sprint ID
Sprints
sprint_id
Story_ChangeRecords_Limited
sprint_id
Sprints
sprint_id
Story_ChangeRecords_Limited
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
Story_ChangedRecords_Limited_Counts
sprint_id
Sprints
sprint_id
Story_ChangedRecords_Limited_Counts
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
All Story Data
Project Key
JIRA_Projects
jira_proj_key_cd
Sprints
Current_year
Current Year Control
Current Year
StoryXSprint_Count
Current_year
Current Year Control
Current Year
rpt_Merged_StoryXSprintData
Sprint ID
Sprints
sprint_id
rpt_ActiveSprintData
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
InitiativeLink_Project
Project DWKey
JIRA_Projects
jira_proj_dwkey
InitiativeLink_Project
Epic DWKey
Epic_Xref
DW Unique Issue ID
All Story Data - Current Year Marker
current_year
Current Year Control
Current Year
All Story Data - Current Year Marker
DW Unique Issue ID
All Story Data
DW Unique Issue ID
ForecastedBacklogCompletion
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
All Story Data
Epic Unique ID
Epic_Xref
DW Unique Issue ID
rpt_Merged_StoryXSprintData
Project Key
JIRA_Projects
jira_proj_key_cd
rpt_Merged_StoryXSprintData
Epic DWKey
Epic_Xref
DW Unique Issue ID
rpt_Merged_Story
DW Unique Issue ID
All Story Data
DW Unique Issue ID
StoryXSprintData_RemainAddxProject
Sprint ID
Sprints
sprint_id
StoryXSprintData_RemainAddxProject
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
StoryXSprint_Count
Rolling_Months
Range366
Rolling_Months
Sprints
Rolling_Months
Range366
Rolling_Months
output: {
    "joins": [
        {
            "from_table": "StoryXSprintData",
            "from_column": "DW Unique Issue ID",
            "to_table": "All Story Data",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "StoryXSprint_Count",
            "from_column": "DW Unique Issue ID",
            "to_table": "All Story Data",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "StoryXSprintData",
            "from_column": "Sprint ID",
            "to_table": "Sprints",
            "to_column": "sprint_id"
        },
        {
            "from_table": "Story_ChangeRecords_Limited",
            "from_column": "sprint_id",
            "to_table": "Sprints",
            "to_column": "sprint_id"
        },
        {
            "from_table": "Story_ChangeRecords_Limited",
            "from_column": "jira_proj_key_cd",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "Story_ChangedRecords_Limited_Counts",
            "from_column": "sprint_id",
            "to_table": "Sprints",
            "to_column": "sprint_id"
        },
        {
            "from_table": "Story_ChangedRecords_Limited_Counts",
            "from_column": "jira_proj_key_cd",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "All Story Data",
            "from_column": "Project Key",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "Sprints",
            "from_column": "Current_year",
            "to_table": "Current Year Control",
            "to_column": "Current Year"
        },
        {
            "from_table": "StoryXSprint_Count",
            "from_column": "Current_year",
            "to_table": "Current Year Control",
            "to_column": "Current Year"
        },
        {
            "from_table": "rpt_Merged_StoryXSprintData",
            "from_column": "Sprint ID",
            "to_table": "Sprints",
            "to_column": "sprint_id"
        },
        {
            "from_table": "rpt_ActiveSprintData",
            "from_column": "jira_proj_key_cd",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "InitiativeLink_Project",
            "from_column": "Project DWKey",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_dwkey"
        },
        {
            "from_table": "InitiativeLink_Project",
            "from_column": "Epic DWKey",
            "to_table": "Epic_Xref",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "All Story Data - Current Year Marker",
            "from_column": "current_year",
            "to_table": "Current Year Control",
            "to_column": "Current Year"
        },
        {
            "from_table": "All Story Data - Current Year Marker",
            "from_column": "DW Unique Issue ID",
            "to_table": "All Story Data",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "ForecastedBacklogCompletion",
            "from_column": "jira_proj_key_cd",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "All Story Data",
            "from_column": "Epic Unique ID",
            "to_table": "Epic_Xref",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "rpt_Merged_StoryXSprintData",
            "from_column": "Project Key",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "rpt_Merged_StoryXSprintData",
            "from_column": "Epic DWKey",
            "to_table": "Epic_Xref",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "rpt_Merged_Story",
            "from_column": "DW Unique Issue ID",
            "to_table": "All Story Data",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "StoryXSprintData_RemainAddxProject",
            "from_column": "Sprint ID",
            "to_table": "Sprints",
            "to_column": "sprint_id"
        },
        {
            "from_table": "StoryXSprintData_RemainAddxProject",
            "from_column": "jira_proj_key_cd",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "StoryXSprint_Count",
            "from_column": "Rolling_Months",
            "to_table": "Range366",
            "to_column": "Rolling_Months"
        },
        {
            "from_table": "Sprints",
            "from_column": "Rolling_Months",
            "to_table": "Range366",
            "to_column": "Rolling_Months"
        }
    ]
}