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   |
|---------------------:|:------------|:--------------------------------------------|:------------------------------------------------------|:-------------|:---------------------------|----------------:|:------------------------|:--------------|---------------:|:---------|:------------|:------------------------|:---------------------------|:---------|:--------------|:-----------------------------------------------------------------|:--------------------------------------------------------|:------------------------|:--------------------------------------------------|-----------------------:|:----------------|:----------------|:---------------|
|                99755 | INFUOP-579  | https://jira.t-mobile.com/browse/INFUOP-579 | upgrading Enterprise Manager Ops Center- Solaris      | Story        | Ramesh Malempati           |  20171206104214 | 2017-12-06 10:35:33.476 | INFUOP        |              3 |          | INFUOP-1034 | 2018-04-06 10:48:42.756 | Ramesh Malempati           | Done     | yes           | INFUOP-579-upgrading Enterprise Manager Ops Center- Solaris      | 2018 - UNIX - General Operational Efficiencies          | Done                    | https://jira.t-mobile.com/rest/api/2/issue/123946 |                 123946 | rmalemp         | rmalemp         | Yes            |
|               101618 | INFUOP-608  | https://jira.t-mobile.com/browse/INFUOP-608 | Discovery on UNIX servers and file shares             | Story        | Bhuvan Madasamy            |  20171218111218 | 2017-12-18 11:02:42.920 | INFUOP        |              3 |          |             | 2017-12-21 09:44:44.633 | Bhuvan Madasamy            | Done     | yes           | INFUOP-608-Discovery on UNIX servers and file shares             |                                                         | Done                    | https://jira.t-mobile.com/rest/api/2/issue/126208 |                 126208 | bmadasa1        | bmadasa1        | No             |
|               103490 | INFUOP-636  | https://jira.t-mobile.com/browse/INFUOP-636 | DL Firmware upgrade - prdtsaf203                      | Story        | Venkatesh S                |  20180103233210 | 2018-01-03 23:25:21.996 | INFUOP        |              3 |          | INFUOP-620  | 2018-01-08 09:56:17.203 | Venkatesh S                | Done     | yes           | INFUOP-636-DL Firmware upgrade - prdtsaf203                      | LINUX Servers - Firmware upgrade on HP ProLiant servers | Done                    | https://jira.t-mobile.com/rest/api/2/issue/128370 |                 128370 | vs              | vs              | Yes            |
|               103505 | INFUOP-638  | https://jira.t-mobile.com/browse/INFUOP-638 | Meltdown/Specter exploits - Planning                  | Story        | Jon Christianson           |  20180104073209 | 2018-01-04 07:23:31.683 | INFUOP        |              3 |          | INFUOP-649  | 2018-02-12 10:28:14.113 | Jon Christianson           | Done     | yes           | INFUOP-638-Meltdown/Specter exploits - Planning                  | Spectre/Meltdown vulnerabilities                        | Done                    | https://jira.t-mobile.com/rest/api/2/issue/128518 |                 128518 | jchrist30       | jchrist30       | Yes            |
|               103489 | INFUOP-634  | https://jira.t-mobile.com/browse/INFUOP-634 | DL Firmware upgrade - prdtsaf201                      | Story        | Venkatesh S                |  20180103233210 | 2018-01-03 23:22:54.966 | INFUOP        |              3 |          | INFUOP-620  | 2018-01-04 10:54:26.403 | Venkatesh S                | Done     | yes           | INFUOP-634-DL Firmware upgrade - prdtsaf201                      | LINUX Servers - Firmware upgrade on HP ProLiant servers | Done                    | https://jira.t-mobile.com/rest/api/2/issue/128368 |                 128368 | vs              | vs              | Yes            |
|               105579 | INFUOP-673  | https://jira.t-mobile.com/browse/INFUOP-673 | New Server Build Approvals 1/15                       | Story        | Jon Christianson           |  20180116135212 | 2018-01-16 13:48:08.763 | INFUOP        |              3 |          | INFUOP-958  | 2018-03-08 13:15:47.513 | Jon Christianson           | Done     | yes           | INFUOP-673-New Server Build Approvals 1/15                       | 2018 - Server Approvals                                 | Done                    | https://jira.t-mobile.com/rest/api/2/issue/130692 |                 130692 | jchrist30       | jchrist30       | Yes            |
|               105614 | INFUOP-675  | https://jira.t-mobile.com/browse/INFUOP-675 | Q1 - Patching Validation - AIX , Linux & Solaris      | Story        | Bhuvan Madasamy            |  20180116150213 | 2018-01-16 14:58:00.376 | INFUOP        |              3 |          | INFUOP-403  | 2018-01-24 16:50:54.726 | Bhuvan Madasamy            | Done     | yes           | INFUOP-675-Q1 - Patching Validation - AIX , Linux & Solaris      | Linux Patching Standardization                          | Done                    | https://jira.t-mobile.com/rest/api/2/issue/130800 |                 130800 | bmadasa1        | bmadasa1        | Yes            |
|               104512 | INFUOP-650  | https://jira.t-mobile.com/browse/INFUOP-650 | Access to Engineering Servers                         | Story        | Venkata Rakesh Annapureddy |  20180109211212 | 2018-01-09 21:07:08.986 | INFUOP        |              3 |          | INFUOP-1034 | 2018-01-25 16:01:04.273 | Venkata Rakesh Annapureddy | Done     | yes           | INFUOP-650-Access to Engineering Servers                         | 2018 - UNIX - General Operational Efficiencies          | Done                    | https://jira.t-mobile.com/rest/api/2/issue/129365 |                 129365 | vannapu         | vannapu         | Yes            |
|               105612 | INFUOP-674  | https://jira.t-mobile.com/browse/INFUOP-674 | Engineering iLO Standardization - iLO Amplifier Setup | Story        | Bhuvan Madasamy            |  20180116150213 | 2018-01-16 14:53:58.250 | INFUOP        |              3 |          | INFUOP-10   | 2018-01-23 15:17:52.916 | Bhuvan Madasamy            | Done     | yes           | INFUOP-674-Engineering iLO Standardization - iLO Amplifier Setup | iLO Standardization                                     | Done                    | https://jira.t-mobile.com/rest/api/2/issue/130699 |                 130699 | bmadasa1        | bmadasa1        | Yes            |
|               107854 | INFUOP-728  | https://jira.t-mobile.com/browse/INFUOP-728 | NAS Migration 1/29 Depot_Master Polaris               | Story        | Mammar Rashid              |  20180129102208 | 2018-01-29 10:15:04.023 | INFUOP        |              3 |          | INFUOP-11   | 2018-02-12 09:27:21.043 | Mammar Rashid              | Done     | yes           | INFUOP-728-NAS Migration 1/29 Depot_Master Polaris               | 2018 - NAS Migration                                    | Done                    | https://jira.t-mobile.com/rest/api/2/issue/133064 |                 133064 | mrashid         | mrashid         | Yes            |


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   |
|---------------------:|:------------|:------------------------------------------|:-----------------------------------------------------------------|:-------------|:---------------------|----------------:|:------------------------|:--------------|:---------------|:---------|:-----------|:------------------------|:---------------------|:---------|:--------------|:-------------------------------------------------------------------------|:------------|:------------------------|:-------------------------------------------------|-----------------------:|:----------------|:----------------|
|                28815 | STOR-38     | https://jira.t-mobile.com/browse/STOR-38  | VMAX3 - Update VMAX0237 (RepHub) to NDM code level early January | Story        | Hans Loback          |  20161222123108 | 2016-12-14 10:40:14.643 | STOR          |                |          |            | 2017-01-20 10:49:18.026 | Hans Loback          | Done     | no            | STOR-38-VMAX3 - Update VMAX0237 (RepHub) to NDM code level early January |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/54082 |                  54082 | hloback1        | hloback1        |
|                28448 | STOR-6      | https://jira.t-mobile.com/browse/STOR-6   | Document Repository requirements needed                          | Story        | Clint Simmons        |  20161222123108 | 2016-12-13 10:45:43.746 | STOR          |                |          |            | 2017-06-02 10:05:13.526 | Jill Jenkins         | Done     | no            | STOR-6-Document Repository requirements needed                           |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/53920 |                  53920 | csimmon54       | jjenkin18       |
|                55475 | STOR-274    | https://jira.t-mobile.com/browse/STOR-274 | CyberArk - Native MPIO/DiskManager configuration                 | Story        | Clint Simmons        |  20170424125206 | 2017-04-24 12:48:02.090 | STOR          |                |          |            | 2017-05-26 10:51:46.403 | Clint Simmons        | Done     | no            | STOR-274-CyberArk - Native MPIO/DiskManager configuration                |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82450 |                  82450 | csimmon54       | csimmon54       |
|                55493 | STOR-276    | https://jira.t-mobile.com/browse/STOR-276 | Create and Install New SAN Switch Licenses                       | Story        | Robert Glasser       |  20170424141209 | 2017-04-24 14:08:14.180 | STOR          |                |          |            | 2017-04-24 14:59:19.206 | Robert Glasser       | Done     | no            | STOR-276-Create and Install New SAN Switch Licenses                      |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82468 |                  82468 | rglasse         | rglasse         |
|                45256 | STOR-242    | https://jira.t-mobile.com/browse/STOR-242 | Resolve Switch port issues in TT/PX                              | Story        | Chaitanya Uppalapati |  20170307101209 | 2017-03-07 10:08:50.193 | STOR          |                |          |            | 2017-03-31 19:07:23.820 | Chaitanya Uppalapati | Done     | yes           | STOR-242-Resolve Switch port issues in TT/PX                             |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/71091 |                  71091 | cuppala1        | cuppala1        |
|                55496 | STOR-279    | https://jira.t-mobile.com/browse/STOR-279 | Add new Storage Edge and Replication SAN switches to DNS         | Story        | Robert Glasser       |  20170424142212 | 2017-04-24 14:12:52.986 | STOR          |                |          |            | 2017-04-28 09:44:13.853 | Robert Glasser       | Done     | no            | STOR-279-Add new Storage Edge and Replication SAN switches to DNS        |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82472 |                  82472 | rglasse         | rglasse         |
|                55500 | STOR-282    | https://jira.t-mobile.com/browse/STOR-282 | Cisco SAN Switch Presentation                                    | Story        | Robert Glasser       |  20170424143207 | 2017-04-24 14:23:46.686 | STOR          |                |          |            | 2017-05-04 09:55:56.210 | Robert Glasser       | Done     | no            | STOR-282-Cisco SAN Switch Presentation                                   |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82475 |                  82475 | rglasse         | rglasse         |
|                39990 | STOR-227    | https://jira.t-mobile.com/browse/STOR-227 | Install Certificates on 3 Virtual Wisdom environments            | Story        | Patrick Olney        |  20170216105205 | 2017-02-16 10:51:19.243 | STOR          |                |          |            | 2017-03-14 09:07:12.686 | Patrick Olney        | Done     | no            | STOR-227-Install Certificates on 3 Virtual Wisdom environments           |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/65743 |                  65743 | polney          | polney          |
|                45257 | STOR-243    | https://jira.t-mobile.com/browse/STOR-243 | Clear SAN path violations that are reporting in OCI              | Story        | Chaitanya Uppalapati |  20170307101209 | 2017-03-07 10:11:55.193 | STOR          |                |          |            | 2017-03-31 19:07:39.210 | Chaitanya Uppalapati | Done     | yes           | STOR-243-Clear SAN path violations that are reporting in OCI             |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/71095 |                  71095 | cuppala1        | cuppala1        |
|                54195 | STOR-267    | https://jira.t-mobile.com/browse/STOR-267 | Polaris (old) Swing/Maint LUN removal from 2999.                 | Story        | Clint Simmons        |  20170419075211 | 2017-04-18 16:05:19.826 | STOR          |                |          |            | 2017-05-02 10:03:36.846 | Clint Simmons        | Done     | no            | STOR-267-Polaris (old) Swing/Maint LUN removal from 2999.                |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/80906 |                  80906 | csimmon54       | csimmon54       |


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   |
|-----------------------:|---------------------:|:-----------|:---------------------------------------------------------------------|:--------------|:------------------|:---------|:--------------------------------------------|:--------------------------------------------------|:--------------|:-------------|
|                  83667 |                56474 | INFAOP-212 | Automated Capacity Management                                        | INFAOP        |                   |          | https://jira.t-mobile.com/browse/INFAOP-212 | https://jira.t-mobile.com/rest/api/2/issue/83667  | N             | Epic         |
|                  83680 |                56487 | INFAOP-223 | PowerVM Automation                                                   | INFAOP        |                   |          | https://jira.t-mobile.com/browse/INFAOP-223 | https://jira.t-mobile.com/rest/api/2/issue/83680  | N             | Epic         |
|                  83686 |                56493 | INFUOP-528 | 2018 - UNIX - San Migration                                          | INFUOP        |                   |          | https://jira.t-mobile.com/browse/INFUOP-528 | https://jira.t-mobile.com/rest/api/2/issue/83686  | N             | Epic         |
|                  83691 |                56501 | INFUOP-10  | iLO Standardization                                                  | INFUOP        |                   |          | https://jira.t-mobile.com/browse/INFUOP-10  | https://jira.t-mobile.com/rest/api/2/issue/83691  | N             | Epic         |
|                  83693 |                56499 | INFUOP-11  | 2018 - NAS Migration                                                 | INFUOP        |                   |          | https://jira.t-mobile.com/browse/INFUOP-11  | https://jira.t-mobile.com/rest/api/2/issue/83693  | N             | Epic         |
|                  91642 |                64251 | INFAOP-211 | AIX upgrade from 6.1 to 7.2                                          | INFAOP        |                   |          | https://jira.t-mobile.com/browse/INFAOP-211 | https://jira.t-mobile.com/rest/api/2/issue/91642  | N             | Epic         |
|                  99596 |                71934 | INFUOP-192 | Veritas CVM , DG & VxFS version upgrades along with Veritas upgrades | INFUOP        |                   |          | https://jira.t-mobile.com/browse/INFUOP-192 | https://jira.t-mobile.com/rest/api/2/issue/99596  | N             | Epic         |
|                 113788 |                92153 | INFAOP-221 | IBM Tivoli Monitoring Administration                                 | INFAOP        |                   |          | https://jira.t-mobile.com/browse/INFAOP-221 | https://jira.t-mobile.com/rest/api/2/issue/113788 | N             | Epic         |
|                 114188 |                92489 | INFUOP-243 | Migration of the OSR environment                                     | INFUOP        |                   |          | https://jira.t-mobile.com/browse/INFUOP-243 | https://jira.t-mobile.com/rest/api/2/issue/114188 | N             | Epic         |
|                 114295 |                92403 | INFUOP-223 | HP Firmware ISO Image Web Server Build                               | INFUOP        |                   |          | https://jira.t-mobile.com/browse/INFUOP-223 | https://jira.t-mobile.com/rest/api/2/issue/114295 | N             | Epic         |


Table: InitiativeLink
|   jira_issue_dwkey |   initiative_jira_issue_dwkey |
|-------------------:|------------------------------:|
|              56474 |                        110100 |
|              56486 |                        110101 |
|              56499 |                        110094 |
|              61737 |                        110102 |
|              64251 |                        110094 |
|              71934 |                        110103 |
|              95391 |                        110103 |
|              98427 |                        134782 |
|             102089 |                        110178 |
|             102230 |                        110101 |


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            |
|               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            |
|               319 | Cloud Foundry                  |                           | software              | cklein3          | CF                 |                      |                 15201 | Y                       |  20171128105209 | 2017-11-28 18:52:14.350 |   20171128105209 | 2017-11-28 18:52:14.350 | 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             |
|:------------------------|
| 2018-10-15 11:44:42.936 |


Table: Merged_Count_AllStoryData
|   DW Unique Issue ID | Current_year   |   story_points |   Number of Sprints | Assignee                   | Issue Key   | Issue_URL                                   | Project Key   | summary                                               | resolution_short_desc   |
|---------------------:|:---------------|---------------:|--------------------:|:---------------------------|:------------|:--------------------------------------------|:--------------|:------------------------------------------------------|:------------------------|
|               103355 | Yes            |              3 |                   1 | Venkata Rakesh Annapureddy | INFUOP-633  | https://jira.t-mobile.com/browse/INFUOP-633 | INFUOP        | ON-CALL LINUX 01_01_2018                              | Done                    |
|               103489 | Yes            |              3 |                   1 | Venkatesh S                | INFUOP-634  | https://jira.t-mobile.com/browse/INFUOP-634 | INFUOP        | DL Firmware upgrade - prdtsaf201                      | Done                    |
|               103490 | Yes            |              3 |                   1 | Venkatesh S                | INFUOP-636  | https://jira.t-mobile.com/browse/INFUOP-636 | INFUOP        | DL Firmware upgrade - prdtsaf203                      | Done                    |
|               105579 | Yes            |              3 |                   1 | Jon Christianson           | INFUOP-673  | https://jira.t-mobile.com/browse/INFUOP-673 | INFUOP        | New Server Build Approvals 1/15                       | Done                    |
|               105612 | Yes            |              3 |                   1 | Bhuvan Madasamy            | INFUOP-674  | https://jira.t-mobile.com/browse/INFUOP-674 | INFUOP        | Engineering iLO Standardization - iLO Amplifier Setup | Done                    |
|               105614 | Yes            |              3 |                   1 | Bhuvan Madasamy            | INFUOP-675  | https://jira.t-mobile.com/browse/INFUOP-675 | INFUOP        | Q1 - Patching Validation - AIX , Linux & Solaris      | Done                    |
|               106065 | Yes            |              3 |                   1 | Prabal Malla               | INFUOP-683  | https://jira.t-mobile.com/browse/INFUOP-683 | INFUOP        | Install Selenium on Linux Server                      | Done                    |
|               107685 | Yes            |              3 |                   1 | Azmath Khan                | INFAOP-392  | https://jira.t-mobile.com/browse/INFAOP-392 | INFAOP        | Prepare test server for L3 network firewall testing   | Done                    |
|               107851 | Yes            |              3 |                   1 | Muhammad Jasim             | INFAOP-400  | https://jira.t-mobile.com/browse/INFAOP-400 | INFAOP        | Balance the LPARS accross the frames tthmc601a        | Done                    |
|               107853 | Yes            |              3 |                   1 | Mammar Rashid              | INFUOP-727  | https://jira.t-mobile.com/browse/INFUOP-727 | INFUOP        | NAS Migration 1/29 Depot_Master Titan                 | Done                    |


Table: 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   | Rest_URL                                         |   JIRA Unique Issue ID | Reporter_NTID   | Assignee_NTID   | Sprint ID   | sprint_name_corrected   | CY_Sprint   |
|---------------------:|:------------|:------------------------------------------|:-----------------------------------------------------------------|:-------------|:-------------------|----------------:|:------------------------|:--------------|:---------------|:---------|:-----------|:------------------------|:-------------------|:---------|:--------------|:-------------------------------------------------------------------------|:------------|:------------------------|:-------------------------------------------------|-----------------------:|:----------------|:----------------|:------------|:------------------------|:------------|
|                28815 | STOR-38     | https://jira.t-mobile.com/browse/STOR-38  | VMAX3 - Update VMAX0237 (RepHub) to NDM code level early January | Story        | Hans Loback        |  20161222123108 | 2016-12-14 10:40:14.643 | STOR          |                |          |            | 2017-01-20 10:49:18.026 | Hans Loback        | Done     | no            | STOR-38-VMAX3 - Update VMAX0237 (RepHub) to NDM code level early January |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/54082 |                  54082 | hloback1        | hloback1        |             |                         |             |
|                28448 | STOR-6      | https://jira.t-mobile.com/browse/STOR-6   | Document Repository requirements needed                          | Story        | Clint Simmons      |  20161222123108 | 2016-12-13 10:45:43.746 | STOR          |                |          |            | 2017-06-02 10:05:13.526 | Jill Jenkins       | Done     | no            | STOR-6-Document Repository requirements needed                           |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/53920 |                  53920 | csimmon54       | jjenkin18       |             |                         |             |
|                39995 | STOR-224    | https://jira.t-mobile.com/browse/STOR-224 | Install SSL certs for Unisphere                                  | Story        | Patrick Olney      |  20170216105205 | 2017-02-16 10:48:38.116 | STOR          |                |          |            | 2017-10-24 16:10:51.176 | Patrick Olney      | Done     | no            | STOR-224-Install SSL certs for Unisphere                                 |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/65737 |                  65737 | polney          | polney          |             |                         |             |
|                55475 | STOR-274    | https://jira.t-mobile.com/browse/STOR-274 | CyberArk - Native MPIO/DiskManager configuration                 | Story        | Clint Simmons      |  20170424125206 | 2017-04-24 12:48:02.090 | STOR          |                |          |            | 2017-05-26 10:51:46.403 | Clint Simmons      | Done     | no            | STOR-274-CyberArk - Native MPIO/DiskManager configuration                |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82450 |                  82450 | csimmon54       | csimmon54       |             |                         |             |
|                55493 | STOR-276    | https://jira.t-mobile.com/browse/STOR-276 | Create and Install New SAN Switch Licenses                       | Story        | Robert Glasser     |  20170424141209 | 2017-04-24 14:08:14.180 | STOR          |                |          |            | 2017-04-24 14:59:19.206 | Robert Glasser     | Done     | no            | STOR-276-Create and Install New SAN Switch Licenses                      |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82468 |                  82468 | rglasse         | rglasse         |             |                         |             |
|                55496 | STOR-279    | https://jira.t-mobile.com/browse/STOR-279 | Add new Storage Edge and Replication SAN switches to DNS         | Story        | Robert Glasser     |  20170424142212 | 2017-04-24 14:12:52.986 | STOR          |                |          |            | 2017-04-28 09:44:13.853 | Robert Glasser     | Done     | no            | STOR-279-Add new Storage Edge and Replication SAN switches to DNS        |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82472 |                  82472 | rglasse         | rglasse         |             |                         |             |
|                55500 | STOR-282    | https://jira.t-mobile.com/browse/STOR-282 | Cisco SAN Switch Presentation                                    | Story        | Robert Glasser     |  20170424143207 | 2017-04-24 14:23:46.686 | STOR          |                |          |            | 2017-05-04 09:55:56.210 | Robert Glasser     | Done     | no            | STOR-282-Cisco SAN Switch Presentation                                   |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82475 |                  82475 | rglasse         | rglasse         |             |                         |             |
|                55692 | STOR-285    | https://jira.t-mobile.com/browse/STOR-285 | Setup SAN Switch Backups in DCNM                                 | Story        | Robert Glasser     |  20170425114213 | 2017-04-25 11:34:05.026 | STOR          |                |          |            | 2017-07-27 16:15:31.146 | Robert Glasser     | Done     | no            | STOR-285-Setup SAN Switch Backups in DCNM                                |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82668 |                  82668 | rglasse         | rglasse         |             |                         |             |
|                56616 | STOR-301    | https://jira.t-mobile.com/browse/STOR-301 | SAN Migration - Preliminary Schedule                             | Story        | Jathin Dandeboyina |  20170501105208 | 2017-05-01 10:45:21.540 | STOR          |                |          |            | 2017-05-24 10:13:10.816 | Jathin Dandeboyina | Done     | no            | STOR-301-SAN Migration - Preliminary Schedule                            |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83809 |                  83809 | jdandeb         | jdandeb         |             |                         |             |
|                56617 | STOR-302    | https://jira.t-mobile.com/browse/STOR-302 | VIPR C - Capacity add script                                     | Story        | Jathin Dandeboyina |  20170501105208 | 2017-05-01 10:47:31.683 | STOR          |                |          |            | 2017-07-10 16:18:53.936 | Jathin Dandeboyina | Done     | no            | STOR-302-VIPR C - Capacity add script                                    |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83811 |                  83811 | jdandeb         | jdandeb         |             |                         |             |


Table: Merge_AllStoryData_NumberSprints
|   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   | Number of Sprints   |
|---------------------:|:------------|:------------------------------------------|:-----------------------------------------------------------------|:-------------|:-------------------|----------------:|:------------------------|:--------------|:---------------|:---------|:-----------|:------------------------|:-------------------|:---------|:--------------|:-------------------------------------------------------------------------|:------------|:------------------------|:-------------------------------------------------|-----------------------:|:----------------|:----------------|:--------------------|
|                28815 | STOR-38     | https://jira.t-mobile.com/browse/STOR-38  | VMAX3 - Update VMAX0237 (RepHub) to NDM code level early January | Story        | Hans Loback        |  20161222123108 | 2016-12-14 10:40:14.643 | STOR          |                |          |            | 2017-01-20 10:49:18.026 | Hans Loback        | Done     | no            | STOR-38-VMAX3 - Update VMAX0237 (RepHub) to NDM code level early January |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/54082 |                  54082 | hloback1        | hloback1        |                     |
|                28448 | STOR-6      | https://jira.t-mobile.com/browse/STOR-6   | Document Repository requirements needed                          | Story        | Clint Simmons      |  20161222123108 | 2016-12-13 10:45:43.746 | STOR          |                |          |            | 2017-06-02 10:05:13.526 | Jill Jenkins       | Done     | no            | STOR-6-Document Repository requirements needed                           |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/53920 |                  53920 | csimmon54       | jjenkin18       |                     |
|                39995 | STOR-224    | https://jira.t-mobile.com/browse/STOR-224 | Install SSL certs for Unisphere                                  | Story        | Patrick Olney      |  20170216105205 | 2017-02-16 10:48:38.116 | STOR          |                |          |            | 2017-10-24 16:10:51.176 | Patrick Olney      | Done     | no            | STOR-224-Install SSL certs for Unisphere                                 |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/65737 |                  65737 | polney          | polney          |                     |
|                55475 | STOR-274    | https://jira.t-mobile.com/browse/STOR-274 | CyberArk - Native MPIO/DiskManager configuration                 | Story        | Clint Simmons      |  20170424125206 | 2017-04-24 12:48:02.090 | STOR          |                |          |            | 2017-05-26 10:51:46.403 | Clint Simmons      | Done     | no            | STOR-274-CyberArk - Native MPIO/DiskManager configuration                |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82450 |                  82450 | csimmon54       | csimmon54       |                     |
|                55493 | STOR-276    | https://jira.t-mobile.com/browse/STOR-276 | Create and Install New SAN Switch Licenses                       | Story        | Robert Glasser     |  20170424141209 | 2017-04-24 14:08:14.180 | STOR          |                |          |            | 2017-04-24 14:59:19.206 | Robert Glasser     | Done     | no            | STOR-276-Create and Install New SAN Switch Licenses                      |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82468 |                  82468 | rglasse         | rglasse         |                     |
|                55496 | STOR-279    | https://jira.t-mobile.com/browse/STOR-279 | Add new Storage Edge and Replication SAN switches to DNS         | Story        | Robert Glasser     |  20170424142212 | 2017-04-24 14:12:52.986 | STOR          |                |          |            | 2017-04-28 09:44:13.853 | Robert Glasser     | Done     | no            | STOR-279-Add new Storage Edge and Replication SAN switches to DNS        |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82472 |                  82472 | rglasse         | rglasse         |                     |
|                55500 | STOR-282    | https://jira.t-mobile.com/browse/STOR-282 | Cisco SAN Switch Presentation                                    | Story        | Robert Glasser     |  20170424143207 | 2017-04-24 14:23:46.686 | STOR          |                |          |            | 2017-05-04 09:55:56.210 | Robert Glasser     | Done     | no            | STOR-282-Cisco SAN Switch Presentation                                   |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82475 |                  82475 | rglasse         | rglasse         |                     |
|                55692 | STOR-285    | https://jira.t-mobile.com/browse/STOR-285 | Setup SAN Switch Backups in DCNM                                 | Story        | Robert Glasser     |  20170425114213 | 2017-04-25 11:34:05.026 | STOR          |                |          |            | 2017-07-27 16:15:31.146 | Robert Glasser     | Done     | no            | STOR-285-Setup SAN Switch Backups in DCNM                                |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82668 |                  82668 | rglasse         | rglasse         |                     |
|                56616 | STOR-301    | https://jira.t-mobile.com/browse/STOR-301 | SAN Migration - Preliminary Schedule                             | Story        | Jathin Dandeboyina |  20170501105208 | 2017-05-01 10:45:21.540 | STOR          |                |          |            | 2017-05-24 10:13:10.816 | Jathin Dandeboyina | Done     | no            | STOR-301-SAN Migration - Preliminary Schedule                            |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83809 |                  83809 | jdandeb         | jdandeb         |                     |
|                56617 | STOR-302    | https://jira.t-mobile.com/browse/STOR-302 | VIPR C - Capacity add script                                     | Story        | Jathin Dandeboyina |  20170501105208 | 2017-05-01 10:47:31.683 | STOR          |                |          |            | 2017-07-10 16:18:53.936 | Jathin Dandeboyina | Done     | no            | STOR-302-VIPR C - Capacity add script                                    |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83811 |                  83811 | jdandeb         | jdandeb         |                     |


Table: S2_GraphActiveSprint
| jira_proj_key_cd   | sprint_name           | sprint_start_dt         | sprint_end_dt           | DayByDay                |   Issues |   Story Points | Burndown_SP   | Burndown_Issues   | Graph_SP   | Graph_Issues   |
|:-------------------|:----------------------|:------------------------|:------------------------|:------------------------|---------:|---------------:|:--------------|:------------------|:-----------|:---------------|
| NAS                | NAS_2018-10-09 (2373) | 2018-10-10 00:00:00.000 | 2018-10-16 00:00:00.000 | 2018-10-11 00:00:00.000 |        5 |              0 |               |                   | 0          | 5              |
| NAS                | NAS_2018-10-09 (2373) | 2018-10-10 00:00:00.000 | 2018-10-16 00:00:00.000 | 2018-10-12 00:00:00.000 |        5 |              0 |               |                   | 0          | 5              |
| NAS                | NAS_2018-10-09 (2373) | 2018-10-10 00:00:00.000 | 2018-10-16 00:00:00.000 | 2018-10-13 00:00:00.000 |        5 |              0 |               |                   | 0          | 5              |
| NAS                | NAS_2018-10-09 (2373) | 2018-10-10 00:00:00.000 | 2018-10-16 00:00:00.000 | 2018-10-14 00:00:00.000 |        5 |              0 |               |                   | 0          | 5              |
| NAS                | NAS_2018-10-09 (2373) | 2018-10-10 00:00:00.000 | 2018-10-16 00:00:00.000 | 2018-10-15 00:00:00.000 |        5 |              0 |               |                   |            |                |
| NAS                | NAS_2018-10-09 (2373) | 2018-10-10 00:00:00.000 | 2018-10-16 00:00:00.000 | 2018-10-16 00:00:00.000 |        5 |              0 | 0             | 0                 |            |                |
| NAS                | NAS_2018-10-09 (2373) | 2018-10-10 00:00:00.000 | 2018-10-16 00:00:00.000 | 2018-10-10 00:00:00.000 |        4 |              0 | 0             | 4                 | 0          | 4              |
| CF                 | CF Sprint 19          | 2018-10-01 00:00:00.000 | 2018-10-13 00:00:00.000 | 2018-10-03 00:00:00.000 |       11 |             44 |               |                   | 44         | 11             |
| CF                 | CF Sprint 19          | 2018-10-01 00:00:00.000 | 2018-10-13 00:00:00.000 | 2018-10-04 00:00:00.000 |       11 |             44 |               |                   | 44         | 11             |
| CF                 | CF Sprint 19          | 2018-10-01 00:00:00.000 | 2018-10-13 00:00:00.000 | 2018-10-05 00:00:00.000 |       11 |             44 |               |                   | 44         | 11             |


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   |
|------------:|:------------------------|:------------------------|:------------------------|:------------------------|:--------------|:----------------|:---------------|:----------------------|
|        1411 | INFOP_2018-01-02        | 2018-01-04 18:31:03.000 | 2018-01-16 22:56:36.000 | 2018-01-15 16:01:00.000 | None          | Completed       | Yes            | 2018-01-02            |
|        1469 | DO NOT USE EVER AGAIN   | 2018-03-27 15:57:12.000 | 2018-03-27 18:52:13.000 | 2018-04-08 15:57:00.000 | None          | Completed       | Yes            | DO NOT USE EVER AGAIN |
|        1514 | INFOP_2018-02-13        | 2018-02-13 20:35:22.000 | 2018-02-27 15:18:29.000 | 2018-02-26 08:35:00.000 | None          | Completed       | Yes            | 2018-02-13            |
|        1534 | CF Sprint 4             | 2018-03-12 16:10:16.000 | 2018-03-19 16:12:16.000 | 2018-03-16 16:10:00.000 | None          | Completed       | Yes            | CF Sprint 4           |
|        1612 | INFOP_2018-03-13        | 2018-03-13 20:12:00.000 | 2018-03-27 17:08:02.000 | 2018-03-27 04:02:00.000 | None          | Completed       | Yes            | 2018-03-13            |
|        1744 | INFOP_2018-04-10        | 2018-04-10 19:37:23.000 | 2018-04-24 19:16:45.000 | 2018-04-24 15:30:00.000 | None          | Completed       | Yes            | 2018-04-10            |
|        1745 | NAS_2018-04-10          | 2018-04-10 20:39:21.000 | 2018-04-17 17:30:16.000 | 2018-04-17 15:56:00.000 | None          | Completed       | Yes            | 2018-04-10            |
|        1834 | INFOP_2018-05-08        | 2018-05-08 19:13:14.000 | 2018-05-22 16:59:47.000 | 2018-05-22 15:30:00.000 | None          | Completed       | Yes            | 2018-05-08            |
|        1859 | INFOP_2018-05-22        | 2018-05-22 21:37:10.000 | 2018-06-05 20:07:15.000 | 2018-06-05 16:54:00.000 | None          | Completed       | Yes            | 2018-05-22            |
|        1892 | CF Sprint 11            | 2018-06-11 21:30:24.000 | 2018-06-23 00:55:47.000 | 2018-06-23 00:31:00.000 | None          | Completed       | Yes            | CF Sprint 11          |


Table: SprintsXProject
|   sprint_id | jira_proj_key_cd   | sprint_name_corrected   | sprint_start_dt         | sprint_complete_dt      | sprint_end_dt           | sprint_goal   | sprint_status   | Current_year   |
|------------:|:-------------------|:------------------------|:------------------------|:------------------------|:------------------------|:--------------|:----------------|:---------------|
|        2031 | NAS                | NAS_2018-07-10          | 2018-07-11 15:06:54.000 | 2018-07-17 20:48:26.000 | 2018-07-17 17:07:00.000 | None          | Closed          | Yes            |
|        2031 | NAS                | NAS_2018-07-10          | 2018-07-11 15:06:54.000 | 2018-07-17 20:48:26.000 | 2018-07-17 17:07:00.000 | None          | Closed          | Yes            |
|        2031 | NAS                | NAS_2018-07-10          | 2018-07-11 15:06:54.000 | 2018-07-17 20:48:26.000 | 2018-07-17 17:07:00.000 | None          | Closed          | Yes            |
|        2031 | NAS                | NAS_2018-07-10          | 2018-07-11 15:06:54.000 | 2018-07-17 20:48:26.000 | 2018-07-17 17:07:00.000 | None          | Closed          | Yes            |
|        2031 | NAS                | NAS_2018-07-10          | 2018-07-11 15:06:54.000 | 2018-07-17 20:48:26.000 | 2018-07-17 17:07:00.000 | None          | Closed          | Yes            |
|        2031 | NAS                | NAS_2018-07-10          | 2018-07-11 15:06:54.000 | 2018-07-17 20:48:26.000 | 2018-07-17 17:07:00.000 | None          | Closed          | Yes            |
|        2031 | NAS                | NAS_2018-07-10          | 2018-07-11 15:06:54.000 | 2018-07-17 20:48:26.000 | 2018-07-17 17:07:00.000 | None          | Closed          | Yes            |
|        2031 | NAS                | NAS_2018-07-10          | 2018-07-11 15:06:54.000 | 2018-07-17 20:48:26.000 | 2018-07-17 17:07:00.000 | None          | Closed          | Yes            |
|        2031 | NAS                | NAS_2018-07-10          | 2018-07-11 15:06:54.000 | 2018-07-17 20:48:26.000 | 2018-07-17 17:07:00.000 | None          | Closed          | Yes            |
|        2031 | NAS                | NAS_2018-07-10          | 2018-07-11 15:06:54.000 | 2018-07-17 20:48:26.000 | 2018-07-17 17:07:00.000 | None          | Closed          | Yes            |


Table: StoryXComponent
|   DW Unique Issue ID | Issue Key   | Component   |   JIRA Unique Issue ID |
|---------------------:|:------------|:------------|-----------------------:|
|               105687 | CF-339      | OPS         |                  99484 |
|               105770 | CF-342      | OPS         |                  99575 |
|               105772 | CF-345      | OPS         |                  99583 |
|               105771 | CF-343      | OPS         |                  99581 |
|               106541 | CF-353      | OPS         |                 100362 |
|               106623 | CF-366      | OPS         |                 100445 |
|               106624 | CF-367      | OPS         |                 100451 |
|               120109 | CF-531      | OPS         |                 114757 |
|               120744 | CF-551      | OPS         |                 115397 |
|               104616 | CF-315      | OPS         |                  98373 |


Table: StoryXLabel
|   DW Unique Issue ID | Issue Key   | Label   | Current Year   |   JIRA Unique Issue ID |
|---------------------:|:------------|:--------|:---------------|-----------------------:|
|               155511 | NAS-673     | ACL     | Yes            |                 150967 |
|               155513 | NAS-675     | ACL     | Yes            |                 150959 |
|               155520 | NAS-683     | ACL     | Yes            |                 150937 |
|               155522 | NAS-685     | ACL     | Yes            |                 150952 |
|               155527 | NAS-693     | ACL     | Yes            |                 150934 |
|               155529 | NAS-695     | ACL     | Yes            |                 150964 |
|               155536 | NAS-707     | ACL     | Yes            |                 150955 |
|               155543 | NAS-663     | ACL     | Yes            |                 150940 |
|               155561 | NAS-711     | ACL     | Yes            |                 150976 |
|               155568 | NAS-723     | ACL     | Yes            |                 150922 |


Table: StoryXSprint
|   sprint_id |   DW Unique Issue ID |   JIRA Unique Issue ID | Issue Key   | story_points   | resolution_dt           | Status   |
|------------:|---------------------:|-----------------------:|:------------|:---------------|:------------------------|:---------|
|        1494 |                39907 |                  65653 | STOR-216    |                | 2018-03-13 09:52:51.823 | Done     |
|        1494 |                63220 |                  90611 | STOR-361    |                | 2018-07-10 13:07:57.433 | Done     |
|        1494 |               100394 |                 124609 | STOR-638    |                | 2018-02-12 14:47:10.080 | Done     |
|        1494 |               107221 |                 132406 | STOR-757    |                | 2018-04-06 09:17:42.303 | Done     |
|        1494 |               107902 |                 133112 | STOR-766    |                | 2018-02-12 13:26:21.123 | Done     |
|        1494 |               108995 |                 134327 | STOR-774    |                | 2018-02-02 09:53:06.706 | Done     |
|        1494 |               109763 |                 135153 | STOR-778    |                | 2018-02-13 10:04:15.056 | Done     |
|        1494 |               109881 |                 135233 | STOR-781    |                | 2018-02-14 10:51:28.373 | Done     |
|        1494 |               110082 |                 135283 | STOR-783    |                | 2018-06-08 16:20:20.973 | Done     |
|        1494 |               115201 |                 141102 | STOR-823    |                | 2018-03-14 15:46:53.096 | Done     |


Table: StoryXSprintData
|   DW Unique Issue ID |   JIRA Unique Issue ID | Issue Key   | Story Points   |   Sprint ID | Resolution Date         | 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   |   Base |
|---------------------:|-----------------------:|:------------|:---------------|------------:|:------------------------|:---------|:---------------|:------------------------|:------------------------|:------------------------|:----------------|:---------------|:---------------|:--------------------------------|:-------------------|:-------------------|:------------------------|:----------------------|:-------------------------------------------------------------------------------------------------|--------------------:|------------------:|:--------------------|-----------:|:----------------|:----------------------|:---------------------|-------:|
|               155047 |                 186133 | NAS-606     |                |        2031 | 2018-07-16 17:08:53.770 | Done     | NAS_2018-07-10 | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 | 2018-07-17 20:48:26.000 | Closed          | Yes            | Done           |                                 |                    | NAS                | 2018-07-13 14:22:42.930 | 2018-07-10            | MetroPCS ACL Clean Up \\ttisi1prod.gsm1900.org\prod$\metropcs\drive_m\BO_CORP_FileStore\TDS_Info |                   1 |                 0 |                     |          0 |                 | Added                 | TRUE                 |      0 |
|               155044 |                 186132 | NAS-605     |                |        2031 | 2018-07-17 09:50:37.646 | Done     | NAS_2018-07-10 | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 | 2018-07-17 20:48:26.000 | Closed          | Yes            | Done           |                                 |                    | NAS                | 2018-07-13 14:21:33.470 | 2018-07-10            | MetroPCS ACL Clean Up \\ttisi1prod.gsm1900.org\prod$\metropcs\drive_m\disabledaccounts           |                   1 |                 0 |                     |          0 |                 | Added                 | TRUE                 |      0 |
|               155043 |                 186130 | NAS-603     |                |        2031 | 2018-07-17 09:36:16.216 | Done     | NAS_2018-07-10 | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 | 2018-07-17 20:48:26.000 | Closed          | Yes            | Done           |                                 |                    | NAS                | 2018-07-13 14:21:24.473 | 2018-07-10            | MetroPCS ACL Clean Up \\ttisi1prod.gsm1900.org\prod$\metropcs\drive_m\DW                         |                   1 |                 0 |                     |          0 |                 | Added                 | TRUE                 |      0 |
|               155041 |                 186128 | NAS-601     |                |        2031 | 2018-07-16 17:05:04.640 | Done     | NAS_2018-07-10 | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 | 2018-07-17 20:48:26.000 | Closed          | Yes            | Done           |                                 |                    | NAS                | 2018-07-13 14:21:15.260 | 2018-07-10            | MetroPCS ACL Clean Up \\ttisi1prod.gsm1900.org\prod$\metropcs\drive_m\BO_CORP_FileStore          |                   1 |                 0 |                     |          0 |                 | Added                 | TRUE                 |      0 |
|               155009 |                 185557 | NAS-583     |                |        2031 | 2018-07-17 09:58:41.263 | Done     | NAS_2018-07-10 | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 | 2018-07-17 20:48:26.000 | Closed          | Yes            | Done           |                                 |                    | NAS                | 2018-07-13 14:08:19.346 | 2018-07-10            | MetroPCS ACL Clean Up  \\gsm1900.org\public\metropcs\corp\ETL-SourceData\lerg6                   |                   1 |                 0 |                     |          0 |                 | Added                 | TRUE                 |      0 |
|               155008 |                 185556 | NAS-582     |                |        2031 | 2018-07-17 10:06:19.563 | Done     | NAS_2018-07-10 | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 | 2018-07-17 20:48:26.000 | Closed          | Yes            | Done           |                                 |                    | NAS                | 2018-07-13 14:07:45.363 | 2018-07-10            | MetroPCS ACL Clean Up \\gsm1900.org\public\metropcs\corp\ETL-SourceData\Callidus                 |                   1 |                 0 |                     |          0 |                 | Added                 | TRUE                 |      0 |
|               154264 |                 184257 | NAS-573     |                |        2031 | 2018-07-12 10:46:11.646 | Done     | NAS_2018-07-10 | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 | 2018-07-17 20:48:26.000 | Closed          | Yes            | Done           |                                 |                    | NAS                | 2018-07-11 13:41:41.430 | 2018-07-10            | ACL push for \\ttsvmnas001.gsm1900.org\MPCS_drive_F$\Vicky                                       |                   1 |                 0 |                     |          0 |                 |                       | TRUE                 |      0 |
|               154263 |                 184255 | NAS-571     |                |        2031 | 2018-07-12 10:46:03.926 | Done     | NAS_2018-07-10 | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 | 2018-07-17 20:48:26.000 | Closed          | Yes            | Done           |                                 |                    | NAS                | 2018-07-11 13:41:31.850 | 2018-07-10            | ACL push for \\ttsvmnas001.gsm1900.org\MPCS_drive_F$\VM Presentation Stuff                       |                   1 |                 0 |                     |          0 |                 |                       | TRUE                 |      0 |
|               154261 |                 184253 | NAS-569     |                |        2031 | 2018-07-12 10:46:02.553 | Done     | NAS_2018-07-10 | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 | 2018-07-17 20:48:26.000 | Closed          | Yes            | Done           |                                 |                    | NAS                | 2018-07-11 13:41:21.803 | 2018-07-10            | ACL push for \\ttsvmnas001.gsm1900.org\MPCS_drive_F$\XShang                                      |                   1 |                 0 |                     |          0 |                 |                       | TRUE                 |      0 |
|               154200 |                 184251 | NAS-567     |                |        2031 | 2018-07-12 10:46:05.960 | Done     | NAS_2018-07-10 | 2018-07-11 15:06:54.000 | 2018-07-17 17:07:00.000 | 2018-07-17 20:48:26.000 | Closed          | Yes            | Done           |                                 |                    | NAS                | 2018-07-11 13:41:11.936 | 2018-07-10            | ACL push for \\ttsvmnas001.gsm1900.org\MPCS_drive_F$\VSS Logs                                    |                   1 |                 0 |                     |          0 |                 |                       | TRUE                 |      0 |


Table: StoryXSprint_Count
|   DW Unique Issue ID | Current_year   |   Number of Sprints | story_points   |
|---------------------:|:---------------|--------------------:|:---------------|
|                41301 | Yes            |                   1 |                |
|                89750 | Yes            |                   1 |                |
|                99897 | Yes            |                   1 |                |
|               100363 | Yes            |                   1 |                |
|               100382 | Yes            |                   1 |                |
|               100915 | Yes            |                   1 |                |
|               101215 | Yes            |                   1 |                |
|               101715 | Yes            |                   1 |                |
|               102070 | Yes            |                   1 |                |
|               102635 | Yes            |                   1 |                |


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   |
|:---------------|------------:|:------------------------|:------------------------|:-------------------|:-------------------------|:---------------|------------:|:------------------------|:------------------------|
| NAS_2018-04-17 |        1773 | project                 | Generated               | NAS                | True                     | Yes            |           0 | 2018-04-17 17:37:31.000 |                         |
| NAS_2018-04-17 |        1773 | description             | Generated               | NAS                | True                     | Yes            |           0 | 2018-04-17 17:37:31.000 |                         |
| NAS_2018-04-17 |        1773 | Sprint                  | Generated               | NAS                | True                     | Yes            |           0 | 2018-04-17 17:37:31.000 |                         |
| NAS_2018-04-17 |        1773 | Acceptance Criteria     | Generated               | NAS                | True                     | Yes            |           0 | 2018-04-17 17:37:31.000 |                         |
| NAS_2018-04-17 |        1773 | Story Points            | Generated               | NAS                | True                     | Yes            |           0 | 2018-04-17 17:37:31.000 |                         |
| NAS_2018-04-17 |        1773 | issuetype               | Generated               | NAS                | True                     | Yes            |           0 | 2018-04-17 17:37:31.000 |                         |
| NAS_2018-04-17 |        1773 | Blocked Reason          | Generated               | NAS                | True                     | Yes            |           0 | 2018-04-17 17:37:31.000 |                         |
| NAS_2018-04-17 |        1773 | summary                 | Generated               | NAS                | True                     | Yes            |           0 | 2018-04-17 17:37:31.000 |                         |
| NAS_2018-04-17 |        1773 | Expected Unblocked Date | Generated               | NAS                | True                     | Yes            |           0 | 2018-04-17 17:37:31.000 |                         |
| NAS_2018-05-15 |        1858 | project                 | Generated               | NAS                | True                     | Yes            |           0 | 2018-05-15 18:47:58.000 |                         |


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   |
|:---------------|------------:|-------------------:|:--------------------|:-------------|:---------------------|:-----------------------------|:---------------|---------------:|:----------------------------|:------------------------|:-------------------|:-------------------|:-------------------|:-------------|:-------------------------------------|:------------------------|:---------------|---------------------:|:----------------------------------------------------------------|:------------------------|:------------------------|:--------------------|
| NAS_2018-04-02 |        1722 |             115316 | NAS-80              | Sprint       | True                 |                              |                |           1722 | 2018-04-08 18:55:40.586     | 2018-03-02 09:26:00.433 | NAS                |                    | STOR_2018-04-02    | eengelman    | 90878817-74F8-4C71-A7DA-1CDF35FDC48F | Emil Engelman           | Yes            |               115316 | NAS-80-migrate Atlanta Celerra Share Appsupport$ to SVM         | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-04-02 |        1722 |             115318 | NAS-116             | Sprint       | True                 |                              |                |           1722 | 2018-04-08 18:56:04.883     | 2018-03-02 09:26:54.916 | NAS                |                    | STOR_2018-04-02    | eengelman    | 62DEACFB-FC3B-4747-B87D-FEF9713FA17C | Emil Engelman           | Yes            |               115318 | NAS-116-migrate Atlanta Celerra Share revenuevalidation$ to SVM | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-04-02 |        1722 |             115322 | NAS-8               | Sprint       | True                 |                              |                |           1722 | 2018-04-08 18:56:34.116     | 2018-03-02 09:31:57.533 | NAS                |                    | STOR_2018-04-02    | eengelman    | FE0C9DB6-3688-492B-9E0F-0586530CD848 | Emil Engelman           | Yes            |               115322 | NAS-8-migrate Atlanta Celerra Share FLJacksonvilleit$ to SVM    | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-04-02 |        1722 |             115323 | NAS-108             | Sprint       | True                 |                              |                |           1722 | 2018-04-08 18:53:12.586     | 2018-03-02 09:22:26.190 | NAS                |                    | STOR_2018-04-02    | eengelman    | 4A6AA929-8B0D-49FF-A11E-4B1B5E8C6801 | Emil Engelman           | Yes            |               115323 | NAS-108-migrate Atlanta Celerra Share albirminghameng$ to SVM   | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-04-02 |        1722 |             115325 | NAS-131             | Sprint       | True                 |                              |                |           1722 | 2018-04-08 18:53:41.756     | 2018-03-02 09:23:28.426 | NAS                |                    | STOR_2018-04-02    | eengelman    | 3F7046DA-969B-441D-87ED-FD48566E8FBC | Emil Engelman           | Yes            |               115325 | NAS-131-migrate Atlanta Celerra Share flmiamieng$ to SVM        | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-04-02 |        1722 |             115338 | NAS-61              | Sprint       | True                 |                              |                |           1722 | 2018-04-08 18:57:30.993     | 2018-03-02 09:34:44.713 | NAS                |                    | STOR_2018-04-02    | eengelman    | 587CC1A8-182A-4B90-B44F-36A76B3E28C8 | Emil Engelman           | Yes            |               115338 | NAS-61-migrate Atlanta Celerra Share tnnashvilleit$ to SVM      | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-04-02 |        1722 |             115345 | NAS-102             | Sprint       | True                 |                              |                |           1722 | 2018-04-08 18:58:45.116     | 2018-03-02 09:38:42.446 | NAS                |                    | STOR_2018-04-02    | eengelman    | CE25A1F1-249E-4474-ADFA-4634563569FD | Emil Engelman           | Yes            |               115345 | NAS-102-migrate Atlanta Celerra Share albirminghamsales$ to SVM | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-04-02 |        1722 |             115351 | NAS-17              | Sprint       | True                 |                              |                |           1722 | 2018-04-08 18:56:58.773     | 2018-03-02 09:33:40.743 | NAS                |                    | STOR_2018-04-02    | eengelman    | F629BCE1-FC24-4BD4-93A5-12BD7E0FC431 | Emil Engelman           | Yes            |               115351 | NAS-17-migrate Atlanta Celerra Share gaatlantait$ to SVM        | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-04-02 |        1722 |             115354 | NAS-103             | Sprint       | True                 |                              |                |           1722 | 2018-04-08 18:57:58.616     | 2018-03-02 09:35:16.906 | NAS                |                    | STOR_2018-04-02    | eengelman    | 7B36FC28-AD0D-47A2-A1B3-37D270A6E977 | Emil Engelman           | Yes            |               115354 | NAS-103-migrate Atlanta Celerra Share xrackdocs$ to SVM         | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-03-27 |        1690 |             115355 | NAS-33              | Sprint       | True                 |                              |                |           1690 | 2018-03-29 13:06:54.103     | 2018-03-02 09:38:00.070 | NAS                |                    | STOR_2018-03-27    | eengelman    | BB958715-3C10-4A28-A252-006E7211CCDE | Emil Engelman           | Yes            |               115355 | NAS-33-migrate Atlanta Celerra Share ricoh$ to SVM              | 2018-04-03 18:16:56.000 | True                    |                     |

 


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: InitiativeLink
data: InitiativeLink.csv
name: JIRA_Projects
data: JIRA_Projects.csv
name: LastRefresh
data: LastRefresh.csv
name: Merged_Count_AllStoryData
data: Merged_Count_AllStoryData.csv
name: Merged_StoryXSprintData
data: Merged_StoryXSprintData.csv
name: Merge_AllStoryData_NumberSprints
data: Merge_AllStoryData_NumberSprints.csv
name: S2_GraphActiveSprint
data: S2_GraphActiveSprint.csv
name: Sprints
data: Sprints.csv
name: SprintsXProject
data: SprintsXProject.csv
name: StoryXComponent
data: StoryXComponent.csv
name: StoryXLabel
data: StoryXLabel.csv
name: StoryXSprint
data: StoryXSprint.csv
name: StoryXSprintData
data: StoryXSprintData.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
StoryXComponent
DW Unique Issue ID
All Story Data
DW Unique Issue ID
StoryXLabel
DW Unique Issue ID
All Story Data
DW Unique Issue ID
StoryXSprintData
Sprint ID
Sprints
sprint_id
StoryXSprint
sprint_id
Sprints
sprint_id
StoryXSprint
DW Unique Issue ID
All Story Data
DW Unique Issue ID
All Story Data
Epic Key
Epic_Xref
Epic Key
All Story Data - Current Year Marker
Epic Key
Epic_Xref
Epic Key
Story_ChangeRecords_Limited
sprint_id
Sprints
sprint_id
Story_ChangeRecords_Limited
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
SprintsXProject
sprint_id
Sprints
sprint_id
SprintsXProject
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 - Current Year Marker
Project Key
JIRA_Projects
jira_proj_key_cd
All Story Data
Project Key
JIRA_Projects
jira_proj_key_cd
Merge_AllStoryData_NumberSprints
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
StoryXLabel
Current Year
Current Year Control
Current Year
Merged_StoryXSprintData
Sprint ID
Sprints
sprint_id
Merged_StoryXSprintData
DW Unique Issue ID
All Story Data
DW Unique Issue ID
Merged_Count_AllStoryData
Current_year
Current Year Control
Current Year
Merged_Count_AllStoryData
DW Unique Issue ID
All Story Data
DW Unique Issue ID
S2_GraphActiveSprint
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
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": "StoryXComponent",
            "from_column": "DW Unique Issue ID",
            "to_table": "All Story Data",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "StoryXLabel",
            "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": "StoryXSprint",
            "from_column": "sprint_id",
            "to_table": "Sprints",
            "to_column": "sprint_id"
        },
        {
            "from_table": "StoryXSprint",
            "from_column": "DW Unique Issue ID",
            "to_table": "All Story Data",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "All Story Data",
            "from_column": "Epic Key",
            "to_table": "Epic_Xref",
            "to_column": "Epic Key"
        },
        {
            "from_table": "All Story Data - Current Year Marker",
            "from_column": "Epic Key",
            "to_table": "Epic_Xref",
            "to_column": "Epic Key"
        },
        {
            "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": "SprintsXProject",
            "from_column": "sprint_id",
            "to_table": "Sprints",
            "to_column": "sprint_id"
        },
        {
            "from_table": "SprintsXProject",
            "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 - Current Year Marker",
            "from_column": "Project Key",
            "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": "Merge_AllStoryData_NumberSprints",
            "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": "StoryXLabel",
            "from_column": "Current Year",
            "to_table": "Current Year Control",
            "to_column": "Current Year"
        },
        {
            "from_table": "Merged_StoryXSprintData",
            "from_column": "Sprint ID",
            "to_table": "Sprints",
            "to_column": "sprint_id"
        },
        {
            "from_table": "Merged_StoryXSprintData",
            "from_column": "DW Unique Issue ID",
            "to_table": "All Story Data",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "Merged_Count_AllStoryData",
            "from_column": "Current_year",
            "to_table": "Current Year Control",
            "to_column": "Current Year"
        },
        {
            "from_table": "Merged_Count_AllStoryData",
            "from_column": "DW Unique Issue ID",
            "to_table": "All Story Data",
            "to_column": "DW Unique Issue ID"
        },
        {
            "from_table": "S2_GraphActiveSprint",
            "from_column": "jira_proj_key_cd",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        }
    ]
}