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   |
|---------------------:|:------------|:--------------------------------------------|:----------------------------------------------------------------|:-------------|:---------------------------|----------------:|:------------------------|:--------------|---------------:|:---------|:------------|:------------------------|:---------------------------|:---------|:--------------|:---------------------------------------------------------------------------|:--------------------------------------------------------|:------------------------|:--------------------------------------------------|-----------------------:|:----------------|:----------------|:---------------|
|               100560 | INFUOP-589  | https://jira.t-mobile.com/browse/INFUOP-589 | Qualys Agent Deployment on Linux servers_sprint-1_15            | Story        | Prabal Malla               |  20171211164215 | 2017-12-11 16:35:28.486 | INFUOP        |              3 |          | INFAOP-731  | 2018-01-26 17:13:31.836 | Ramesh Malempati           | Done     | yes           | INFUOP-589-Qualys Agent Deployment on Linux servers_sprint-1_15            | 2018 - Qualys Agent Deployment All Platforms            | Done                    | https://jira.t-mobile.com/rest/api/2/issue/124705 |                 124705 | pmalla2         | rmalemp         | Yes            |
|               103069 | INFUOP-631  | https://jira.t-mobile.com/browse/INFUOP-631 | Sudo script and vulnerability fixes on Solaris servers          | Story        | Ramesh Malempati           |  20180102103213 | 2018-01-02 10:30:59.203 | INFUOP        |              3 |          | INFUOP-827  | 2018-01-12 17:44:20.286 | Ramesh Malempati           | Done     | yes           | INFUOP-631-Sudo script and vulnerability fixes on Solaris servers          | Sudo modernization implementation - phase II            | Done                    | https://jira.t-mobile.com/rest/api/2/issue/127661 |                 127661 | rmalemp         | rmalemp         | Yes            |
|               103355 | INFUOP-633  | https://jira.t-mobile.com/browse/INFUOP-633 | ON-CALL LINUX 01_01_2018                                        | Story        | Venkata Rakesh Annapureddy |  20180103110213 | 2018-01-03 10:59:15.226 | INFUOP        |              3 |          | INFUOP-522  | 2018-01-15 09:40:39.546 | Venkata Rakesh Annapureddy | Done     | yes           | INFUOP-633-ON-CALL LINUX 01_01_2018                                        | UNIX Team On Call                                       | Done                    | https://jira.t-mobile.com/rest/api/2/issue/128233 |                 128233 | vannapu         | vannapu         | 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            |
|                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            |
|               103483 | INFUOP-635  | https://jira.t-mobile.com/browse/INFUOP-635 | DL Firmware upgrade - prdtsaf202                                | Story        | Venkatesh S                |  20180103233210 | 2018-01-03 23:24:55.306 | INFUOP        |              3 |          | INFUOP-620  | 2018-01-05 14:34:26.526 | Venkatesh S                | Done     | yes           | INFUOP-635-DL Firmware upgrade - prdtsaf202                                | LINUX Servers - Firmware upgrade on HP ProLiant servers | Done                    | https://jira.t-mobile.com/rest/api/2/issue/128369 |                 128369 | vs              | vs              | Yes            |
|               103712 | INFUOP-644  | https://jira.t-mobile.com/browse/INFUOP-644 | Rep-hub Convert Active-Passive cluster to Active-Active cluster | Story        | Venkata Rakesh Annapureddy |  20180104151210 | 2018-01-04 15:06:05.216 | INFUOP        |              3 |          | INFUOP-1034 | 2018-01-15 11:53:42.263 | Venkata Rakesh Annapureddy | Done     | yes           | INFUOP-644-Rep-hub Convert Active-Passive cluster to Active-Active cluster | 2018 - UNIX - General Operational Efficiencies          | Done                    | https://jira.t-mobile.com/rest/api/2/issue/128708 |                 128708 | vannapu         | vannapu         | 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            |
|               107094 | INFUOP-712  | https://jira.t-mobile.com/browse/INFUOP-712 | Decom /depot/usec and /depot/linux_x86                          | Story        | Mammar Rashid              |  20180124131210 | 2018-01-24 13:05:04.613 | INFUOP        |              3 |          | INFUOP-11   | 2018-03-08 13:05:58.876 | Mammar Rashid              | Done     | yes           | INFUOP-712-Decom /depot/usec and /depot/linux_x86                          | 2018 - NAS Migration                                    | Done                    | https://jira.t-mobile.com/rest/api/2/issue/132358 |                 132358 | 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   |
|---------------------:|:------------|:------------------------------------------|:-----------------------------------------------------------------|:-------------|:---------------------|----------------:|:------------------------|:--------------|:---------------|:---------|:-----------|:------------------------|:---------------------|:---------|:--------------|:-------------------------------------------------------------------------|:------------|:------------------------|:-------------------------------------------------|-----------------------:|:----------------|:----------------|
|                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         |
|                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        |
|                55945 | STOR-289    | https://jira.t-mobile.com/browse/STOR-289 | Install and evaluate Brocade Network Advisor for Fraud switches  | Story        | Patrick Olney        |  20170426102211 | 2017-04-26 10:15:36.420 | STOR          |                |          |            | 2018-03-02 14:06:32.443 | Unassigned           | Done     | no            | STOR-289-Install and evaluate Brocade Network Advisor for Fraud switches |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82921 |                  82921 | polney          | not matched     |
|                55957 | STOR-290    | https://jira.t-mobile.com/browse/STOR-290 | Cisco MDS 9718 ISL configuration                                 | Story        | Craig Dayton         |  20170426105214 | 2017-04-26 10:49:06.563 | STOR          |                |          |            | 2017-05-25 08:30:08.836 | Craig Dayton         | Done     | no            | STOR-290-Cisco MDS 9718 ISL configuration                                |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82933 |                  82933 | cdayton1        | cdayton1        |
|                56193 | STOR-291    | https://jira.t-mobile.com/browse/STOR-291 | New Trial Agreements for VMWare POD Storage                      | Story        | Robert Glasser       |  20170427101207 | 2017-04-27 10:03:52.360 | STOR          |                |          |            | 2017-07-27 15:55:18.180 | Robert Glasser       | Done     | no            | STOR-291-New Trial Agreements for VMWare POD Storage                     |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83324 |                  83324 | rglasse         | rglasse         |


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 |
|-------------------:|------------------------------:|
|              32639 |                        110094 |
|              32652 |                        110094 |
|              32657 |                        110103 |
|              32658 |                        110100 |
|              33812 |                        134782 |
|              37518 |                        110094 |
|              37933 |                        110094 |
|              56487 |                        110100 |
|              56501 |                        110101 |
|              61041 |                        110102 |


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


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-25 15:27:49.473 |


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   |
|---------------------:|:---------------|---------------:|--------------------:|:---------------------------|:------------|:--------------------------------------------|:--------------|:----------------------------------------------------------------|:------------------------|
|                95209 | Yes            |              3 |                   1 | Muqtadir Abdul             | INFAOP-139  | https://jira.t-mobile.com/browse/INFAOP-139 | INFAOP        | IBM Frame ttibm605 evacuation.                                  | Done                    |
|               103712 | Yes            |              3 |                   1 | Venkata Rakesh Annapureddy | INFUOP-644  | https://jira.t-mobile.com/browse/INFUOP-644 | INFUOP        | Rep-hub Convert Active-Passive cluster to Active-Active cluster | Done                    |
|               106877 | Yes            |              3 |                   1 | Bhuvan Madasamy            | INFUOP-705  | https://jira.t-mobile.com/browse/INFUOP-705 | INFUOP        | Upgrade Eng iLOs to latest Firmware version                     | Done                    |
|               107690 | Yes            |              3 |                   1 | Venkata Rakesh Annapureddy | INFUOP-722  | https://jira.t-mobile.com/browse/INFUOP-722 | INFUOP        | how to upgrade Dell firmware Document                           | Done                    |
|               107856 | Yes            |              3 |                   1 | Unassigned                 | INFAOP-401  | https://jira.t-mobile.com/browse/INFAOP-401 | INFAOP        | Adding check_aix with options to call functions as"Arg"         | Done                    |
|               110655 | Yes            |              3 |                   1 | Santhosh Padiyath          | INFAOP-435  | https://jira.t-mobile.com/browse/INFAOP-435 | INFAOP        | Qualys Agent deployment on AIX servers - Sprint 2/12            | Done                    |
|               111055 | Yes            |              3 |                   1 | Unassigned                 | INFUOP-773  | https://jira.t-mobile.com/browse/INFUOP-773 | INFUOP        | On Call - Linux / Solaris - Week 07 & 08                        | Done                    |
|               113731 | Yes            |              3 |                   1 | Azmath Khan                | INFAOP-497  | https://jira.t-mobile.com/browse/INFAOP-497 | INFAOP        | L2-L3 migration for Passive RPX DB nodes                        | Done                    |
|               114358 | Yes            |              3 |                   1 | Bhuvan Madasamy            | INFUOP-838  | https://jira.t-mobile.com/browse/INFUOP-838 | INFUOP        | Enable and Process puppet Service across all Linux Servers      | Done                    |
|               114524 | Yes            |              3 |                   1 | Venkatesh S                | INFAOP-515  | https://jira.t-mobile.com/browse/INFAOP-515 | INFAOP        | AIX Liveupdate testing on selected NPE servers - vs             | 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   | Initiative JIRA Key   | Initiative Summary   |
|---------------------:|:------------|:------------------------------------------|:-----------------------------------------------------------------|:-------------|:---------------|----------------:|:------------------------|:--------------|:---------------|:---------|:-----------|:------------------------|:---------------|:---------|:--------------|:-------------------------------------------------------------------------|:------------|:------------------------|:-------------------------------------------------|-----------------------:|:----------------|:----------------|:------------|:------------------------|:------------|:----------------------|:---------------------|
|                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         |             |                         |             |                       |                      |
|                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          |             |                         |             |                       |                      |
|                55945 | STOR-289    | https://jira.t-mobile.com/browse/STOR-289 | Install and evaluate Brocade Network Advisor for Fraud switches  | Story        | Patrick Olney  |  20170426102211 | 2017-04-26 10:15:36.420 | STOR          |                |          |            | 2018-03-02 14:06:32.443 | Unassigned     | Done     | no            | STOR-289-Install and evaluate Brocade Network Advisor for Fraud switches |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82921 |                  82921 | polney          | not matched     |             |                         |             |                       |                      |
|                55957 | STOR-290    | https://jira.t-mobile.com/browse/STOR-290 | Cisco MDS 9718 ISL configuration                                 | Story        | Craig Dayton   |  20170426105214 | 2017-04-26 10:49:06.563 | STOR          |                |          |            | 2017-05-25 08:30:08.836 | Craig Dayton   | Done     | no            | STOR-290-Cisco MDS 9718 ISL configuration                                |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82933 |                  82933 | cdayton1        | cdayton1        |             |                         |             |                       |                      |
|                56193 | STOR-291    | https://jira.t-mobile.com/browse/STOR-291 | New Trial Agreements for VMWare POD Storage                      | Story        | Robert Glasser |  20170427101207 | 2017-04-27 10:03:52.360 | STOR          |                |          |            | 2017-07-27 15:55:18.180 | Robert Glasser | Done     | no            | STOR-291-New Trial Agreements for VMWare POD Storage                     |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83324 |                  83324 | rglasse         | rglasse         |             |                         |             |                       |                      |
|                56194 | STOR-292    | https://jira.t-mobile.com/browse/STOR-292 | Decommission VPLEX from Replication Hub                          | Story        | Patrick Olney  |  20170427101207 | 2017-04-27 10:10:32.770 | STOR          |                |          |            | 2018-04-18 16:30:16.423 | Unassigned     | Done     | no            | STOR-292-Decommission VPLEX from Replication Hub                         |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83326 |                  83326 | polney          | not matched     |             |                         |             |                       |                      |
|                56199 | STOR-293    | https://jira.t-mobile.com/browse/STOR-293 | Finish Decomm/Removal of Orion and Polaris Violin arrays         | Story        | Patrick Olney  |  20170427102211 | 2017-04-27 10:17:23.700 | STOR          |                |          |            | 2017-11-27 16:49:26.513 | Patrick Olney  | Done     | no            | STOR-293-Finish Decomm/Removal of Orion and Polaris Violin arrays        |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83329 |                  83329 | polney          | polney          |             |                         |             |                       |                      |


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       |                     |
|                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         |                     |
|                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          |                     |
|                55945 | STOR-289    | https://jira.t-mobile.com/browse/STOR-289 | Install and evaluate Brocade Network Advisor for Fraud switches  | Story        | Patrick Olney  |  20170426102211 | 2017-04-26 10:15:36.420 | STOR          |                |          |            | 2018-03-02 14:06:32.443 | Unassigned     | Done     | no            | STOR-289-Install and evaluate Brocade Network Advisor for Fraud switches |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82921 |                  82921 | polney          | not matched     |                     |
|                55957 | STOR-290    | https://jira.t-mobile.com/browse/STOR-290 | Cisco MDS 9718 ISL configuration                                 | Story        | Craig Dayton   |  20170426105214 | 2017-04-26 10:49:06.563 | STOR          |                |          |            | 2017-05-25 08:30:08.836 | Craig Dayton   | Done     | no            | STOR-290-Cisco MDS 9718 ISL configuration                                |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/82933 |                  82933 | cdayton1        | cdayton1        |                     |
|                56193 | STOR-291    | https://jira.t-mobile.com/browse/STOR-291 | New Trial Agreements for VMWare POD Storage                      | Story        | Robert Glasser |  20170427101207 | 2017-04-27 10:03:52.360 | STOR          |                |          |            | 2017-07-27 15:55:18.180 | Robert Glasser | Done     | no            | STOR-291-New Trial Agreements for VMWare POD Storage                     |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83324 |                  83324 | rglasse         | rglasse         |                     |
|                56194 | STOR-292    | https://jira.t-mobile.com/browse/STOR-292 | Decommission VPLEX from Replication Hub                          | Story        | Patrick Olney  |  20170427101207 | 2017-04-27 10:10:32.770 | STOR          |                |          |            | 2018-04-18 16:30:16.423 | Unassigned     | Done     | no            | STOR-292-Decommission VPLEX from Replication Hub                         |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83326 |                  83326 | polney          | not matched     |                     |
|                56199 | STOR-293    | https://jira.t-mobile.com/browse/STOR-293 | Finish Decomm/Removal of Orion and Polaris Violin arrays         | Story        | Patrick Olney  |  20170427102211 | 2017-04-27 10:17:23.700 | STOR          |                |          |            | 2017-11-27 16:49:26.513 | Patrick Olney  | Done     | no            | STOR-293-Finish Decomm/Removal of Orion and Polaris Violin arrays        |             | Done                    | https://jira.t-mobile.com/rest/api/2/issue/83329 |                  83329 | polney          | polney          |                     |


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   | Graph_Today_SP   | Graph_Today_Issues   |   Added_SP |   Added_Issues |
|:-------------------|:------------------|:------------------------|:------------------------|:------------------------|---------:|---------------:|:--------------|:------------------|:-----------|:---------------|:-----------------|:---------------------|-----------:|---------------:|
| INFAOP             | INFUOP_2018-10-23 | 2018-10-24 00:00:00.000 | 2018-11-06 00:00:00.000 | 2018-10-24 00:00:00.000 |       16 |             42 | 42            | 16                | 42         | 16             | 42               | 16                   |         42 |             16 |
| INFAOP             | INFUOP_2018-10-23 | 2018-10-24 00:00:00.000 | 2018-11-06 00:00:00.000 | 2018-10-25 00:00:00.000 |       16 |             42 |               |                   |            |                | 42               | 16                   |         42 |             16 |
| INFAOP             | INFUOP_2018-10-23 | 2018-10-24 00:00:00.000 | 2018-11-06 00:00:00.000 | 2018-10-26 00:00:00.000 |       16 |             42 |               |                   |            |                |                  |                      |         42 |             16 |
| INFAOP             | INFUOP_2018-10-23 | 2018-10-24 00:00:00.000 | 2018-11-06 00:00:00.000 | 2018-10-27 00:00:00.000 |       16 |             42 |               |                   |            |                |                  |                      |         42 |             16 |
| INFAOP             | INFUOP_2018-10-23 | 2018-10-24 00:00:00.000 | 2018-11-06 00:00:00.000 | 2018-10-28 00:00:00.000 |       16 |             42 |               |                   |            |                |                  |                      |         42 |             16 |
| INFAOP             | INFUOP_2018-10-23 | 2018-10-24 00:00:00.000 | 2018-11-06 00:00:00.000 | 2018-10-29 00:00:00.000 |       16 |             42 |               |                   |            |                |                  |                      |         42 |             16 |
| INFAOP             | INFUOP_2018-10-23 | 2018-10-24 00:00:00.000 | 2018-11-06 00:00:00.000 | 2018-10-30 00:00:00.000 |       16 |             42 |               |                   |            |                |                  |                      |         42 |             16 |
| INFAOP             | INFUOP_2018-10-23 | 2018-10-24 00:00:00.000 | 2018-11-06 00:00:00.000 | 2018-10-31 00:00:00.000 |       16 |             42 |               |                   |            |                |                  |                      |         42 |             16 |
| INFAOP             | INFUOP_2018-10-23 | 2018-10-24 00:00:00.000 | 2018-11-06 00:00:00.000 | 2018-11-01 00:00:00.000 |       16 |             42 |               |                   |            |                |                  |                      |         42 |             16 |
| INFAOP             | INFUOP_2018-10-23 | 2018-10-24 00:00:00.000 | 2018-11-06 00:00:00.000 | 2018-11-02 00:00:00.000 |       16 |             42 |               |                   |            |                |                  |                      |         42 |             16 |


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   |
|------------:|:------------------------|:------------------------|:------------------------|:------------------------|:--------------|:----------------|:---------------|:----------------------|
|        1368 | INFOP_2018-03-27        | 2018-03-28 17:00:00.000 | 2018-04-10 15:06:34.000 | 2018-04-10 03:00:00.000 | None          | Completed       | Yes            | 2018-03-27            |
|        1436 | INFOP_2018-01-16        | 2018-01-17 23:14:00.000 | 2018-01-30 00:06:24.000 | 2018-01-29 20:01:00.000 | None          | Completed       | Yes            | 2018-01-16            |
|        1453 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Completed       | Yes            | CF Sprint 1           |
|        1690 | NAS_2018-03-27          | 2018-03-28 17:00:23.000 | 2018-04-03 18:16:56.000 | 2018-04-03 03:00:00.000 | None          | Completed       | Yes            | 2018-03-27            |
|        1720 | CF Sprint 7             | 2018-04-16 22:06:00.000 | 2018-04-30 15:00:50.000 | 2018-04-27 22:06:00.000 | None          | Completed       | Yes            | CF Sprint 7           |
|        1818 | CF Sprint 9             | 2018-05-14 21:00:00.000 | 2018-05-29 16:15:33.000 | 2018-05-26 00:30:00.000 | None          | Completed       | Yes            | CF Sprint 9           |
|        1862 | NAS_2018-05-22          | 2018-05-22 15:18:35.000 | 2018-05-29 17:03:45.000 | 2018-05-29 17:15:00.000 | None          | Completed       | Yes            | 2018-05-22            |
|        1885 | NAS_2018-05-29          | 2018-05-29 15:48:53.000 | 2018-06-05 17:07:08.000 | 2018-06-05 15:45:00.000 | None          | Completed       | Yes            | 2018-05-29            |
|        1941 | CF Sprint 13            | 2018-07-09 21:00:53.000 | 2018-07-23 16:00:23.000 | 2018-07-21 01:00:00.000 | None          | Completed       | Yes            | CF Sprint 13          |
|        1947 | NAS_2018-06-19          | 2018-06-19 21:19:06.000 | 2018-06-27 15:22:02.000 | 2018-06-26 18:00:00.000 | None          | Completed       | Yes            | 2018-06-19            |


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   |
|------------:|:-------------------|:------------------------|:------------------------|:------------------------|:------------------------|:--------------|:----------------|:---------------|
|        1453 | CF                 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Closed          | Yes            |
|        1453 | CF                 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Closed          | Yes            |
|        1453 | CF                 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Closed          | Yes            |
|        1453 | CF                 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Closed          | Yes            |
|        1453 | CF                 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Closed          | Yes            |
|        1453 | CF                 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Closed          | Yes            |
|        1453 | CF                 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Closed          | Yes            |
|        1453 | CF                 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Closed          | Yes            |
|        1453 | CF                 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Closed          | Yes            |
|        1453 | CF                 | CF Sprint 1             | 2018-01-22 23:14:00.000 | 2018-02-05 20:46:57.000 | 2018-02-03 01:00:00.000 | None          | Closed          | Yes            |


Table: StoryXComponent
|   DW Unique Issue ID | Issue Key   | Component   |   JIRA Unique Issue ID |
|---------------------:|:------------|:------------|-----------------------:|
|               103515 | CF-172      | OPS         |                  97246 |
|               103516 | CF-173      | OPS         |                  97251 |
|               103531 | CF-175      | OPS         |                  97265 |
|               103833 | CF-226      | OPS         |                  97579 |
|               103882 | CF-238      | OPS         |                  97622 |
|               103914 | CF-257      | OPS         |                  97661 |
|               103915 | CF-258      | OPS         |                  97662 |
|               103933 | CF-265      | OPS         |                  97682 |
|               104049 | CF-271      | OPS         |                  97796 |
|               104048 | CF-270      | OPS         |                  97798 |


Table: StoryXLabel
|   DW Unique Issue ID | Issue Key   | Label   | Current Year   |   JIRA Unique Issue ID |
|---------------------:|:------------|:--------|:---------------|-----------------------:|
|               154905 | NAS-578     | ACL     | Yes            |                 150276 |
|               162712 | NAS-781     | ACL     | Yes            |                 158464 |
|               162727 | NAS-813     | ACL     | Yes            |                 158498 |
|               162742 | NAS-789     | ACL     | Yes            |                 158465 |
|               162743 | NAS-793     | ACL     | Yes            |                 158496 |
|               162744 | NAS-795     | ACL     | Yes            |                 158492 |
|               162762 | NAS-821     | ACL     | Yes            |                 158453 |
|               162777 | NAS-841     | ACL     | Yes            |                 158547 |
|               162720 | NAS-797     | ACL     | Yes            |                 158508 |
|               162737 | NAS-783     | ACL     | Yes            |                 158500 |


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 |                92472 |                 114180 | STOR-571    |                | 2018-02-21 10:27:10.576 | Done     |
|        1494 |               100234 |                 124506 | STOR-616    |                | 2018-02-06 06:32:09.493 | Done     |
|        1494 |                55771 |                  82747 | STOR-286    |                | 2018-07-11 10:28:39.263 | Done     |
|        1494 |                41301 |                  67049 | STOR-234    |                | 2018-02-21 10:26:39.586 | Done     |
|        1494 |               103816 |                 128746 | STOR-678    |                | 2018-02-13 09:38:02.486 | Done     |
|        1494 |               104472 |                 129340 | STOR-692    |                | 2018-02-23 16:40:03.086 | Done     |
|        1494 |               106221 |                 131471 | STOR-725    |                | 2018-03-06 09:07:04.656 | 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   |
|---------------------:|:---------------|--------------------:|:---------------|
|                37639 | Yes            |                   1 |                |
|                92548 | Yes            |                   1 |                |
|                99882 | Yes            |                   1 |                |
|               100386 | Yes            |                   1 |                |
|               102081 | Yes            |                   1 |                |
|               103360 | Yes            |                   1 |                |
|               103594 | Yes            |                   1 |                |
|               103917 | Yes            |                   1 |                |
|               104060 | Yes            |                   1 |                |
|               104085 | 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   |
|:----------------|------------:|:------------------------|:------------------------|:-------------------|:-------------------------|:---------------|------------:|:------------------------|:------------------------|
| STOR_2018_01_22 |        1454 | project                 | Generated               | NAS                | True                     | Yes            |           0 | 2018-01-22 18:50:32.000 |                         |
| STOR_2018_01_22 |        1454 | description             | Generated               | NAS                | True                     | Yes            |           0 | 2018-01-22 18:50:32.000 |                         |
| STOR_2018_01_22 |        1454 | Sprint                  | Generated               | NAS                | True                     | Yes            |           0 | 2018-01-22 18:50:32.000 |                         |
| STOR_2018_01_22 |        1454 | Acceptance Criteria     | Generated               | NAS                | True                     | Yes            |           0 | 2018-01-22 18:50:32.000 |                         |
| STOR_2018_01_22 |        1454 | Story Points            | Generated               | NAS                | True                     | Yes            |           0 | 2018-01-22 18:50:32.000 |                         |
| STOR_2018_01_22 |        1454 | issuetype               | Generated               | NAS                | True                     | Yes            |           0 | 2018-01-22 18:50:32.000 |                         |
| STOR_2018_01_22 |        1454 | Blocked Reason          | Generated               | NAS                | True                     | Yes            |           0 | 2018-01-22 18:50:32.000 |                         |
| STOR_2018_01_22 |        1454 | summary                 | Generated               | NAS                | True                     | Yes            |           0 | 2018-01-22 18:50:32.000 |                         |
| STOR_2018_01_22 |        1454 | Expected Unblocked Date | Generated               | NAS                | True                     | Yes            |           0 | 2018-01-22 18:50:32.000 |                         |
| NAS_2018-03-12  |        1532 | project                 | Generated               | NAS                | True                     | Yes            |           0 | 2018-03-13 21:19:26.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 |             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    | 2EB86EDE-BD70-4B04-9356-6583D78784A9 | 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 |             115360 | NAS-101             | Sprint       | True                 |                              |                |           1722 | 2018-04-08 18:59:56.053     | 2018-03-02 09:39:00.553 | NAS                |                    | STOR_2018-04-02        | eengelman    | 4DC495F5-D648-4148-A4FF-9DB3A1B6D4CD | Emil Engelman           | Yes            |               115360 | NAS-101-migrate Atlanta Celerra Share almobilesales$ to SVM             | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-04-02 |        1722 |             115362 | NAS-112             | Sprint       | True                 |                              |                |           1722 | 2018-04-08 19:01:12.206     | 2018-03-02 09:41:07.626 | NAS                |                    | STOR_2018-04-02        | eengelman    | 77A1D003-31C5-4A95-8AA0-B19F7DDD7601 | Emil Engelman           | Yes            |               115362 | NAS-112-migrate Atlanta Celerra Share gaatlantasales$ 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    | 332FC319-EEC4-45FB-A380-6651CA85ADEF | Emil Engelman           | Yes            |               115354 | NAS-103-migrate Atlanta Celerra Share xrackdocs$ to SVM                 | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-04-02 |        1722 |             115363 | NAS-57              | Sprint       | True                 |                              |                |           1722 | 2018-04-08 19:01:58.986     | 2018-03-02 09:41:23.546 | NAS                |                    | STOR_2018-04-02        | eengelman    | D913AF27-8066-4093-A9BD-DFD0EC192E58 | Emil Engelman           | Yes            |               115363 | NAS-57-migrate Atlanta Celerra Share nccharlottesales$ to SVM           | 2018-04-10 15:05:57.000 | True                    |                     |
| NAS_2018-10-02 |        2326 |             116857 | NAS-226             | Sprint       | True                 |                              |                |           2326 | 2018-10-04 08:54:49.286     | 2018-03-08 14:45:44.926 | NAS                |                    | NAS_2018-10-02         | eengelman    | D3E0DD90-6BED-4CA2-92DD-2A682F109406 | Emil Engelman           | Yes            |               116857 | NAS-226-Migrate Philadelphia Celerra (paphiladna01) Share vanorfolkeng$ | 2018-10-09 16:57:54.000 | True                    |                     |
| NAS_2018-04-24 |        1777 |             116871 | NAS-94              | Sprint       | True                 |                              |                |           1777 | 2018-04-30 09:34:21.976     | 2018-03-08 15:21:14.966 | NAS                |                    | STOR_2018-04-24 (1777) | eengelman    | D368987C-2195-4483-9AE9-967D4DE63C59 | Emil Engelman           | Yes            |               116871 | NAS-94-Migrate Edgin Celerra(ilelginna01)Share ky-engapps$              | 2018-05-01 17:27:18.000 | True                    |                     |
| NAS_2018-04-24 |        1777 |             116885 | NAS-114             | Sprint       | True                 |                              |                |           1777 | 2018-04-30 09:34:21.370     | 2018-03-08 15:20:29.810 | NAS                |                    | STOR_2018-04-24 (1777) | eengelman    | AF483210-F5EB-49E1-8465-9CF59ED6C1C8 | Emil Engelman           | Yes            |               116885 | NAS-114-Migrate Edgin Celerra(ilelginna01)Share itohcleveland$          | 2018-05-01 17:27:18.000 | True                    |                     |
| NAS_2018-04-24 |        1777 |             116886 | NAS-1               | Sprint       | True                 |                              |                |           1777 | 2018-04-30 09:34:20.883     | 2018-03-08 15:20:43.030 | NAS                |                    | STOR_2018-04-24 (1777) | eengelman    | 66455915-6CB4-4F6B-B86E-6A3C0ED44A44 | Emil Engelman           | Yes            |               116886 | NAS-1-Migrate Edgin Celerra(ilelginna01)Share itohcolumbus$             | 2018-05-01 17:27:18.000 | True                    |                     |
| NAS_2018-04-24 |        1777 |             116889 | NAS-22              | Sprint       | True                 |                              |                |           1777 | 2018-04-30 09:34:20.290     | 2018-03-08 15:23:15.876 | NAS                |                    | STOR_2018-04-24 (1777) | eengelman    | 40B06897-6387-4F58-A227-96187F38545B | Emil Engelman           | Yes            |               116889 | NAS-22-Migrate Edgin Celerra(ilelginna01)Share MIScan$                  | 2018-05-01 17:27:18.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: InitiativeLink_Project
data: InitiativeLink_Project.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
InitiativeLink_Project
Project DWKey
JIRA_Projects
jira_proj_dwkey
InitiativeLink_Project
Epic DWKey
Epic_Xref
DW Unique Issue ID
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"
        },
        {
            "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"
        }
    ]
}