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: DimCargoStatus
|   CargoStatusKey | Name   |
|-----------------:|:-------|
|                1 | OPEN   |
|                2 | CLOSED |


Table: DimCompany
|   CompanyKey | Name     |
|-------------:|:---------|
|            1 | EEM (SG) |
|            2 | EEMSGP   |
|            3 | EMNA     |


Table: DimCounterparty
|   CounterpartyKey | Name                     | LegalName                |   ParentKey | Mnemonic   | BDR Client   | BDR Legal Identity   | Technical Counterparty   | DAI   | ClassKey   | TypeKey   | Changeable   | Counterparty Status   | Acer ID   | Comments      |
|------------------:|:-------------------------|:-------------------------|------------:|:-----------|:-------------|:---------------------|:-------------------------|:------|:-----------|:----------|:-------------|:----------------------|:----------|:--------------|
|                 1 | Engie LNG Paris          | Engie LNG Paris          |           1 |            |              |                      |                          |       |            |           | False        | INACTIVE              |           | to be deleted |
|                 2 | ENGIE S.A. (LNG)         | ENGIE S.A. (LNG)         |           2 |            |              |                      |                          |       |            |           | False        | INACTIVE              |           | to be deleted |
|                 3 | FX DESK                  | FX DESK                  |           3 | FXDESK     |              |                      |                          |       |            |           | False        | INACTIVE              |           | to be deleted |
|                 4 | Pending Creation         | Pending Creation         |           4 | PC         |              |                      |                          |       |            |           | False        | INACTIVE              |           | to be deleted |
|                 5 | test                     | test                     |           5 |            |              |                      |                          |       |            |           | False        | INACTIVE              |           | to be deleted |
|                 6 | Union Fenosa Gas SA      | Union Fenosa Gas         |           6 |            |              |                      |                          |       |            |           | False        | INACTIVE              |           | to be deleted |
|                 8 | Engie LNG London         | Engie LNG London         |           8 |            |              |                      |                          |       |            |           | False        | INACTIVE              |           | to be deleted |
|                 9 | Engie SA (LNG)           | Engie SA (LNG)           |           9 |            |              |                      |                          |       |            |           | False        | INACTIVE              |           | to be deleted |
|                10 | GDF SUEZ LNG Supply      | GDF SUEZ LNG Supply      |          10 |            |              |                      |                          |       |            |           | False        | INACTIVE              |           | to be deleted |
|                11 | GDF SUEZ LNG SUPPLY S.A. | GDF SUEZ LNG SUPPLY S.A. |           2 |            |              |                      |                          |       |            |           | False        | INACTIVE              |           | to be deleted |


Table: DimCounterpartyClass
|   ClassKey | Name        |
|-----------:|:------------|
|          1 | Other       |
|          2 | Client/Cpty |
|          3 | Guarantor   |
|          4 | Broker      |


Table: DimCounterpartyType
|   TypeKey | Name                     |
|----------:|:-------------------------|
|         1 | Autres                   |
|         2 | Oil & Gas Major          |
|         3 | Traders                  |
|         4 | Industriel               |
|         5 | Actionnaires et filiales |
|         6 | Operateur                |
|         7 | Producer                 |
|         8 | Utilities                |
|         9 | Banque                   |
|        10 | Broker                   |


Table: DimCreditParty
|   CreditPartyKey | Name                        |
|-----------------:|:----------------------------|
|                1 | NATURGY APROVISIONAMIENTOS  |
|                2 | ENGIE                       |
|                3 | TRAFIGURA PL                |
|                4 | ENGIE GAS & LNG             |
|                5 | BP GAS MARKETING/LONDON     |
|                6 | LNGFI                       |
|                7 | CHENIERE MARKETING INTERNAT |
|                8 | PAVILION GAS                |
|                9 | VITOL SA/GENEVE             |
|               10 | UNIPER GLOBAL COMMODITIES   |


Table: DimCreditRating
|   CreditRatingKey | Name   |
|------------------:|:-------|
|                 1 | BB+    |
|                 2 | BB     |
|                 3 | AA-    |
|                 4 | A-     |
|                 5 | 0      |
|                 6 | CCC+   |
|                 7 | BBB+   |
|                 8 | B+     |
|                 9 | A      |
|                10 | BBB-   |


Table: DimCreditTerm
|   CreditTermKey | Name                 |
|----------------:|:---------------------|
|               1 | OC                   |
|               2 | PCG / SBLC           |
|               3 | SBLC                 |
|               4 | See comments         |
|               5 | SBLC/Insurance Cover |
|               6 | PCG                  |
|               7 | Prepayment           |
|               8 | 0                    |
|               9 | PCG/SBLC             |
|              10 | Prepayment / SBLC    |


Table: DimCurrency
|   CurrencyKey | Name   |
|--------------:|:-------|
|             1 | USD    |


Table: DimDate
| Date                    |   Year |   Month |   Day | MonthName   | DayName   | DayAndFullDate             |   DateKey |
|:------------------------|-------:|--------:|------:|:------------|:----------|:---------------------------|----------:|
| 2000-01-01 00:00:00.000 |   2000 |       1 |     1 | January     | Saturday  | Saturday, January 1, 2000  |  20000101 |
| 2000-01-02 00:00:00.000 |   2000 |       1 |     2 | January     | Sunday    | Sunday, January 2, 2000    |  20000102 |
| 2000-01-03 00:00:00.000 |   2000 |       1 |     3 | January     | Monday    | Monday, January 3, 2000    |  20000103 |
| 2000-01-04 00:00:00.000 |   2000 |       1 |     4 | January     | Tuesday   | Tuesday, January 4, 2000   |  20000104 |
| 2000-01-05 00:00:00.000 |   2000 |       1 |     5 | January     | Wednesday | Wednesday, January 5, 2000 |  20000105 |
| 2000-01-06 00:00:00.000 |   2000 |       1 |     6 | January     | Thursday  | Thursday, January 6, 2000  |  20000106 |
| 2000-01-07 00:00:00.000 |   2000 |       1 |     7 | January     | Friday    | Friday, January 7, 2000    |  20000107 |
| 2000-01-08 00:00:00.000 |   2000 |       1 |     8 | January     | Saturday  | Saturday, January 8, 2000  |  20000108 |
| 2000-01-09 00:00:00.000 |   2000 |       1 |     9 | January     | Sunday    | Sunday, January 9, 2000    |  20000109 |
| 2000-01-10 00:00:00.000 |   2000 |       1 |    10 | January     | Monday    | Monday, January 10, 2000   |  20000110 |


Table: DimDescription
|   DescriptionKey | Description               |
|-----------------:|:--------------------------|
|                1 | Description               |
|                2 | Financing                 |
|                3 | Liquified Natural Gas SOD |
|                4 | Liquified Natural Gas NG  |
|                5 | Liquified Natural Gas BO  |
|                6 | Liquified Natural Gas HU  |
|                7 | Liquified Natural Gas CAS |
|                8 | Liquified Natural Gas BI  |
|                9 | Liquified Natural Gas MO  |
|               10 | Liquified Natural Gas SB  |


Table: DimEmployee
|   EmployeeKey | FullName       |
|--------------:|:---------------|
|             1 | Andrew Ng      |
|             2 | Thomas Barraud |
|             3 | Ruhui Kang     |


Table: DimExposure
|   ExposureTypeKey | Name     |
|------------------:|:---------|
|                 1 | MARKET   |
|                 2 | POSITION |


Table: DimKYCStatus
|   KYCStatusKey | Status   |
|---------------:|:---------|
|              1 | OK       |
|              2 | NO       |
|              3 | Pending  |
|              4 | 0        |


Table: DimLimitLevel
|   LimitLevelKey | Name   |
|----------------:|:-------|
|               1 | LEVEL1 |


Table: DimMarket
|   MarketAreaKey | Name      |
|----------------:|:----------|
|               1 | DES US    |
|               2 | DES SWE   |
|               3 | DES JKTC  |
|               4 | DES NWE   |
|               5 | DES LATAM |
|               6 | DES MEI   |


Table: DimParent
|   ParentKey | ParentName          |
|------------:|:--------------------|
|           1 | Engie LNG Paris     |
|           2 | ENGIE S.A.          |
|           3 | FX DESK             |
|           4 | Pending Creation    |
|           5 | test                |
|           6 | Union Fenosa        |
|           7 | Dummy Comp          |
|           8 | Engie LNG London    |
|           9 | Engie SA (LNG)      |
|          10 | GDF SUEZ LNG Supply |


Table: DimPaymentTerm
|   PaymentTermKey | PaymentTerm                   |
|-----------------:|:------------------------------|
|                1 | Payment terms                 |
|                2 | 0                             |
|                3 | Cargo - 10BD frm inv rcpt SIB |
|                4 | Cargo - 7BD frm inv rcpt US   |
|                5 | Cargo - 10BD frm inv rcpt LnB |
|                6 | 10 BD after actual            |
|                7 | 20 CD after delivery          |
|                8 | Cargo - 8BD frm inv rcpt SIB  |
|                9 | Cargo - 10CD frm inv rcpt SIB |


Table: DimPositionType
|   PositionTypeKey | Type      |
|------------------:|:----------|
|                 1 | INVENTORY |
|                 2 | BUY       |
|                 3 | SELL      |
|                 4 | SWAP      |


Table: DimRatingSource
|   CreditSourceKey | Name             |
|------------------:|:-----------------|
|                 1 | Internal Rating  |
|                 2 | 0                |
|                 3 | Standard & Poors |


Table: DimSecurity
|   SecurityKey | Name      |
|--------------:|:----------|
|             1 | OPEN      |
|             2 | LETTER    |
|             3 | GUARANTEE |
|             4 | PREPAY    |


Table: DimStatus
|   StatusKey | Status     |
|------------:|:-----------|
|           1 | APPROVED   |
|           2 | RESTRICTED |


Table: DimSwapType
|   SwapTypeKey | Type   |
|--------------:|:-------|
|             1 | 0      |
|             2 | SELL   |
|             3 | BUY    |


Table: DimTradeType
|   TradeTypeKey | Name       |
|---------------:|:-----------|
|              1 | 0          |
|              2 | Cargo      |
|              3 | Swap       |
|              4 | FX Forward |


Table: DimUnit
|   UnitKey | Name   |
|----------:|:-------|
|         1 | mmbtu  |


Table: DimValuation
|   ValuationKey |     Id | Mode    | Date                    |
|---------------:|-------:|:--------|:------------------------|
|              1 | 105645 | M2M_USD | 2020-11-02 00:00:00.000 |
|              2 | 105651 | M2M_USD | 2020-11-03 00:00:00.000 |
|              3 | 105657 | M2M_USD | 2020-11-04 00:00:00.000 |
|              4 | 105666 | M2M_USD | 2020-11-05 00:00:00.000 |
|              5 | 105677 | M2M_USD | 2020-11-06 00:00:00.000 |
|              6 | 105682 | M2M_USD | 2020-11-09 00:00:00.000 |
|              7 | 105688 | M2M_USD | 2020-11-10 00:00:00.000 |
|              8 | 105693 | M2M_USD | 2020-11-11 00:00:00.000 |
|              9 | 105699 | M2M_USD | 2020-11-12 00:00:00.000 |
|             10 | 105707 | M2M_USD | 2020-11-13 00:00:00.000 |


Table: DimValuationDesc
|   DescriptionKey | Description               |
|-----------------:|:--------------------------|
|                1 | To PE                     |
|                2 | Financing                 |
|                3 | SW_PLA_JKM_1NB_MBU_USD    |
|                4 | Fixed Price               |
|                5 | PF_LNG_NBP_1NB_USD_MBU_LD |
|                6 | GASAM_DB_USD_301_W_0.1123 |
|                7 | PLA_JKM_1NB_ORI_USD       |
|                8 | Pay USD                   |
|                9 | Receive EUR               |
|               10 | Receive USD               |


Table: DimValuationMode
|   ValuationModeKey | Name    |
|-------------------:|:--------|
|                  1 | M2M_USD |


Table: DimValuationType
|   ValuationTypeKey | Type   |
|-------------------:|:-------|
|                  1 | FINAL  |


Table: DimVessel
|   VesselKey | Name              |
|------------:|:------------------|
|           1 | 0                 |
|           2 | MARIA ENERGY      |
|           3 | HYUNDAI PEACEPIA  |
|           4 | EXEMPLAR          |
|           5 | BW BOSTON         |
|           6 | DUKHAN            |
|           7 | ARCTIC AURORA     |
|           8 | TESSALA           |
|           9 | TEMBEK            |
|          10 | CHEIKH EL MOKRANI |


Table: FactCredit
|   CreditKey |   CompanyKey |   CounterpartyKey |   RatingSourceKey |   CreditRatingKey | Begtime   | Endtime                 |   StatusKey |   MTM Limit |   RP Limit | RP Cargos   | Total Cargos   |   CurrencyKey |   SecurityKey |   Reverse Exposure Limit | Credit Contract   | Credit Product   | Credit Trade   |   LimitLevelKey | Trader   |   Reverse Quantity Limit |   Reverse Warning Level | Unit   |   Warning Level | Comments                                                    | Tenor in years   |
|------------:|-------------:|------------------:|------------------:|------------------:|:----------|:------------------------|------------:|------------:|-----------:|:------------|:---------------|--------------:|--------------:|-------------------------:|:------------------|:-----------------|:---------------|----------------:|:---------|-------------------------:|------------------------:|:-------|----------------:|:------------------------------------------------------------|:-----------------|
|           1 |            1 |                43 |                 1 |                 1 |           | 2019-07-31 00:00:00.000 |           1 |    63000000 |   84000000 | 2           | 7              |             1 |             1 |                        0 |                   |                  |                |               1 |          |                        0 |                       0 |        |               1 | Line closed                                                 | 2                |
|           2 |            1 |               139 |                 1 |                 2 |           | 2021-02-28 00:00:00.000 |           1 |    27000000 |          0 | 0           | 3              |             1 |             2 |                        0 |                   |                  |                |               1 |          |                        0 |                       0 |        |               1 |                                                             | 1                |
|           3 |            1 |                39 |                 1 |                 1 |           | 2019-03-31 00:00:00.000 |           1 |    36000000 |   42000000 | 1           | 4              |             1 |             1 |                        0 |                   |                  |                |               1 |          |                        0 |                       0 |        |               1 | Novation to Pavilion Energy T&S from 1st Apr 2019           |                  |
|           4 |            1 |                87 |                 1 |                 3 |           | 2021-09-30 00:00:00.000 |           1 |    36000000 |   84000000 | 2           | 4              |             1 |             1 |                        0 |                   |                  |                |               1 |          |                        0 |                       0 |        |               1 | Open term                                                   | 3                |
|           5 |            1 |               117 |                 1 |                 4 |           | 2021-07-31 00:00:00.000 |           1 |           0 |          0 |             |                |             1 |             1 |                        0 |                   |                  |                |               1 |          |                        0 |                       0 |        |               1 | Refer to TOTAL GAS & POWER LTD 's credit limit              |                  |
|           6 |            1 |               106 |                 1 |                 1 |           | 2020-12-31 00:00:00.000 |           1 |    36000000 |          0 | 0           | 4              |             1 |             2 |                        0 |                   |                  |                |               1 |          |                        0 |                       0 |        |               1 | Limit to be set aside from National Gas Company of Trinidad |                  |
|           7 |            2 |               108 |                 2 |                 5 |           | 2020-08-31 00:00:00.000 |           1 |           0 |          0 |             |                |             1 |             2 |                        0 |                   |                  |                |               1 |          |                        0 |                       0 |        |               1 | Under credit envelope                                       |                  |
|           8 |            2 |                65 |                 1 |                 6 |           | 2020-06-30 00:00:00.000 |           1 |     9000000 |          0 | 0           | 1              |             1 |             2 |                        0 |                   |                  |                |               1 |          |                        0 |                       0 |        |               1 | Buy only and covered  by SBLC                               | 0                |
|           9 |            2 |               121 |                 1 |                 7 |           | 2021-01-31 00:00:00.000 |           1 |    36000000 |   84000000 | 2           | 4              |             1 |             1 |                        0 |                   |                  |                |               1 |          |                        0 |                       0 |        |               1 | Fully open terms                                            | 1                |
|          10 |            2 |                85 |                 1 |                 7 |           | 2021-01-31 00:00:00.000 |           1 |    36000000 |   42000000 | 1           | 4              |             1 |             1 |                        0 |                   |                  |                |               1 |          |                        0 |                       0 |        |               1 | Fully open terms                                            | 2                |


Table: FactCreditCargo
|   PaymentTermKey | PaymentTerm                                    |
|-----------------:|:-----------------------------------------------|
|                1 | cst_credit_cargo                               |
|                2 | 0                                              |
|                3 | TGJun20_BHP BILLITON MARKETING/SGP             |
|                4 | TGJul20_BHP BILLITON MARKETING/SGP             |
|                5 | NLNGJuly20_2_NIGERIA LNG LIMITED               |
|                6 | JVEngieEspanaOct19_KOGAS INTERNATIONAL PTE LTD |
|                7 | JVEngieEspanaDec19_KOGAS INTERNATIONAL PTE LTD |
|                8 | borkirdec19_BORKIR INTERNATIONAL CO LTD        |
|                9 | NLNGSep20_NIGERIA LNG LIMITED                  |
|               10 | NLNGJune20_NIGERIA LNG LIMITED                 |


Table: FactMerge
|   MergeKey | Valuation Time          | Movement   |   Mark to Market |   CreditPartyKey |   CounterpartyKey | Fee type   |   PositionTypeKey | Swaptype   | Begtime                 | Settlement date   | Expected Due Date       | PaymentTermKey   |   ExposureKey | Price   | Marketprice   |    Quantity |   CreditCargoKey |   CargoStatusKey |   Valuation | Valuation Mode   |   TradeKey | Trade Date   |   TradeTypeKey |   PositionKey |   CompanyKey |   PackageKey |   Value |   ShipmentKey |   ValuationTypeKey |   DescriptionKey |   FinalCounterpartyKey |
|-----------:|:------------------------|:-----------|-----------------:|-----------------:|------------------:|:-----------|------------------:|:-----------|:------------------------|:------------------|:------------------------|:-----------------|--------------:|:--------|:--------------|------------:|-----------------:|-----------------:|------------:|:-----------------|-----------:|:-------------|---------------:|--------------:|-------------:|-------------:|--------:|--------------:|-------------------:|-----------------:|-----------------------:|
|          1 | 2020-12-14 00:00:00.000 | False      |        -93460.1  |               72 |                46 |            |                 2 |            | 2019-10-07 00:00:00.000 |                   | 2019-10-17 00:00:00.000 |                  |             2 |         |               | 5.9486e+06  |                2 |                2 |      105864 | M2M_USD          |          1 |              |              2 |           275 |            1 |           81 |       0 |            75 |                  1 |                2 |                     46 |
|          2 | 2020-12-14 00:00:00.000 | False      |        -60831.1  |               72 |                46 |            |                 2 |            | 2019-12-02 00:00:00.000 |                   | 2019-12-12 00:00:00.000 |                  |             2 |         |               | 5.8738e+06  |                2 |                2 |      105864 | M2M_USD          |          2 |              |              2 |           276 |            1 |           82 |       0 |            76 |                  1 |                2 |                     46 |
|          3 | 2020-12-14 00:00:00.000 | False      |        -22238.5  |               72 |                46 |            |                 2 |            | 2020-02-04 00:00:00.000 |                   | 2020-02-14 00:00:00.000 |                  |             2 |         |               | 5.86915e+06 |                2 |                2 |      105864 | M2M_USD          |          3 |              |              2 |           277 |            1 |           83 |       0 |            77 |                  1 |                2 |                     46 |
|          4 | 2020-12-14 00:00:00.000 | False      |         -3398.07 |               72 |                66 |            |                 2 |            | 2020-06-13 00:00:00.000 |                   | 2020-06-29 00:00:00.000 |                  |             2 |         |               | 3.87469e+06 |                2 |                2 |      105864 | M2M_USD          |          4 |              |              2 |           493 |            3 |          120 |       0 |           101 |                  1 |                2 |                     66 |
|          5 | 2020-12-14 00:00:00.000 | False      |         13217.8  |               72 |                58 |            |                 3 |            | 2020-06-13 00:00:00.000 |                   | 2020-06-26 00:00:00.000 |                  |             2 |         |               | 3.87469e+06 |                2 |                2 |      105864 | M2M_USD          |          5 |              |              2 |           409 |            3 |          120 |       0 |           101 |                  1 |                2 |                     58 |
|          7 | 2020-12-14 00:00:00.000 | False      |         -2618.96 |               72 |                66 |            |                 2 |            | 2020-07-16 00:00:00.000 |                   | 2020-08-04 00:00:00.000 |                  |             2 |         |               | 3.86954e+06 |                2 |                2 |      105864 | M2M_USD          |          6 |              |              2 |           497 |            3 |          121 |       0 |           102 |                  1 |                2 |                     66 |
|          8 | 2020-12-14 00:00:00.000 | False      |          9686.69 |               72 |                58 |            |                 3 |            | 2020-07-16 00:00:00.000 |                   | 2020-08-03 00:00:00.000 |                  |             2 |         |               | 3.86954e+06 |                2 |                2 |      105864 | M2M_USD          |          7 |              |              2 |           410 |            3 |          121 |       0 |           102 |                  1 |                2 |                     58 |
|         10 | 2020-12-14 00:00:00.000 | False      |         -1893.81 |               72 |                68 |            |                 2 |            | 2020-07-11 00:00:00.000 |                   | 2020-07-23 00:00:00.000 |                  |             2 |         |               | 3.80994e+06 |                2 |                2 |      105864 | M2M_USD          |          8 |              |              2 |           555 |            3 |          134 |       0 |           115 |                  1 |                2 |                     68 |
|         12 | 2020-12-14 00:00:00.000 | False      |        123032    |               72 |                15 |            |                 3 |            | 2019-10-01 00:00:00.000 |                   | 2019-10-17 00:00:00.000 |                  |             2 |         |               | 3.7842e+06  |                2 |                2 |      105864 | M2M_USD          |          9 |              |              2 |           199 |            3 |           64 |       0 |            60 |                  1 |                2 |                     15 |
|         13 | 2020-12-14 00:00:00.000 | False      |       -123032    |               72 |                39 |            |                 2 |            | 2019-10-01 00:00:00.000 |                   | 2019-10-17 00:00:00.000 |                  |             2 |         |               | 3.7842e+06  |                2 |                2 |      105864 | M2M_USD          |         10 |              |              2 |           198 |            3 |           64 |       0 |            60 |                  1 |                2 |                     39 |


Table: FactOpenLine
|   OpenLineKey |   CounterpartyKey |   CreditTermKey |   Credit Limits (RP - Number of Cargoes) |   Credit Limits (Total Number of Cargoes) | Tenor in years   | Comments                                                                                             |   KYCStatusKey | Credit Expiry Date      | KYC review date    |   CreditExpiryDate |
|--------------:|------------------:|----------------:|-----------------------------------------:|------------------------------------------:|:-----------------|:-----------------------------------------------------------------------------------------------------|---------------:|:------------------------|:-------------------|-------------------:|
|             1 |                 1 |               1 |                                        0 |                                         3 | 6 MTHS           | Buy only                                                                                             |              1 | 2021-01-31 00:00:00.000 | 11/20/2020         |           20210131 |
|             2 |                 2 |               1 |                                        0 |                                         6 |                  | Buy only. Limits base on existing contract novated from NORAM. NEW DEALS subject to credit approval. |              1 | 2021-02-28 00:00:00.000 | 10/7/2023          |           20210228 |
|             3 |                 3 |               2 |                                        0 |                                         4 | 1                | PCG from Axpo Holding AG or SBLC.                                                                    |              1 | 2021-07-31 00:00:00.000 | EGM                |           20210731 |
|             4 |                 4 |               1 |                                        2 |                                         4 | 1                | Fully open terms                                                                                     |              1 | 2021-10-31 00:00:00.000 | EGM                |           20211031 |
|             5 |                 5 |               1 |                                        2 |                                         4 | 1                | Fully open terms                                                                                     |              1 | 2021-01-31 00:00:00.000 | EGM                |           20210131 |
|             6 |                 6 |               1 |                                        1 |                                         4 | 2                | Fully open terms                                                                                     |              1 | 2021-01-31 00:00:00.000 | 8/26/2019          |           20210131 |
|             7 |                 7 |               3 |                                        0 |                                         2 | 1                | SBLC required for a sell.                                                                            |              1 | 2021-04-30 00:00:00.000 | 4/23/2026          |           20210430 |
|             8 |                 8 |               2 |                                        0 |                                         1 | 4 MTHS           | SBLC  / PCG from Centrica Plc                                                                        |              1 | 2020-12-31 00:00:00.000 | 8/31/2023          |           20201231 |
|             9 |                 9 |               4 |                                        0 |                                        12 | 1                | SBLC for a sell.  Open terms for buys.  No overlaps allowed even for buys                            |              1 | 2021-07-31 00:00:00.000 | 8/14/2022          |           20210731 |
|            10 |                10 |               1 |                                        1 |                                         4 | 2                | Fully open terms ( includes Chevron U.S.A Inc Singapore Branch )                                     |              1 | 2021-04-30 00:00:00.000 | 9/6/2021           |           20210430 |


Table: FactPackage
|   PackageKey | Name                 |
|-------------:|:---------------------|
|            1 | ConstellationDec23   |
|            2 | ConstellationDec24   |
|            3 | ConstellationFeb24_1 |
|            4 | ConstellationFeb24_2 |
|            5 | ConstellationJan24_1 |
|            6 | ConstellationJan24_2 |
|            7 | ConstellationJul23   |
|            8 | ConstellationJul24   |
|            9 | ConstellationMar24   |
|           10 | ConstellationMay24   |


Table: FactPhysicalExposure
|   PhysicalExposureKey |   valuation | shipment   | valuationtime           |   ValuationModeKey |   PackageKey | VesselKey   |   MarketKey |   quantity |   UnitKey | exposure_month          | count   |   CargoStatusKey |   duration | cargo_provision   |
|----------------------:|------------:|:-----------|:------------------------|-------------------:|-------------:|:------------|------------:|-----------:|----------:|:------------------------|:--------|-----------------:|-----------:|:------------------|
|                     2 |      105864 |            | 2020-12-14 00:00:00.000 |                  1 |            2 |             |           1 |     -3e+06 |         1 | 2024-12-01 00:00:00.000 |         |                1 |          0 |                   |
|                     3 |      105864 |            | 2020-12-14 00:00:00.000 |                  1 |            3 |             |           1 |     -3e+06 |         1 | 2024-02-01 00:00:00.000 |         |                1 |          0 |                   |
|                     4 |      105864 |            | 2020-12-14 00:00:00.000 |                  1 |            4 |             |           1 |     -3e+06 |         1 | 2024-02-01 00:00:00.000 |         |                1 |          0 |                   |
|                     5 |      105864 |            | 2020-12-14 00:00:00.000 |                  1 |            5 |             |           1 |     -3e+06 |         1 | 2024-01-01 00:00:00.000 |         |                1 |          0 |                   |
|                     6 |      105864 |            | 2020-12-14 00:00:00.000 |                  1 |            6 |             |           1 |     -3e+06 |         1 | 2024-01-01 00:00:00.000 |         |                1 |          0 |                   |
|                     8 |      105864 |            | 2020-12-14 00:00:00.000 |                  1 |            8 |             |           1 |     -3e+06 |         1 | 2024-07-01 00:00:00.000 |         |                1 |          0 |                   |
|                     9 |      105864 |            | 2020-12-14 00:00:00.000 |                  1 |            9 |             |           1 |     -3e+06 |         1 | 2024-03-01 00:00:00.000 |         |                1 |          0 |                   |
|                    10 |      105864 |            | 2020-12-14 00:00:00.000 |                  1 |           10 |             |           1 |     -3e+06 |         1 | 2024-05-01 00:00:00.000 |         |                1 |          0 |                   |
|                    12 |      105864 |            | 2020-12-14 00:00:00.000 |                  1 |           12 |             |           1 |     -3e+06 |         1 | 2024-11-01 00:00:00.000 |         |                1 |          0 |                   |
|                    13 |      105864 |            | 2020-12-14 00:00:00.000 |                  1 |           13 |             |           2 |      0     |         1 | 2021-04-01 00:00:00.000 |         |                2 |          0 |                   |


Table: FactPositions
|   PositionKey |   PositionId |   PositionTypeKey |
|--------------:|-------------:|------------------:|
|            14 |       828847 |                 4 |
|            15 |       828850 |                 4 |
|            19 |       828856 |                 4 |
|            20 |       828857 |                 4 |
|            21 |       828864 |                 4 |
|            44 |       828984 |                 4 |
|            45 |       828985 |                 4 |
|            46 |       828986 |                 4 |
|            47 |       828987 |                 4 |
|            48 |       828988 |                 4 |


Table: FactShipments
|   ShipmentKey |   ShipmentId |
|--------------:|-------------:|
|             1 |       102449 |
|             2 |       102450 |
|             3 |       102174 |
|             4 |       102180 |
|             5 |       102176 |
|             6 |       102177 |
|             7 |       102178 |
|             8 |       102228 |
|             9 |            0 |
|            10 |       102201 |


Table: FactTrades
|   TradeKey |   TradeId |
|-----------:|----------:|
|          1 |         0 |
|          2 |    811023 |
|          3 |    811024 |
|          4 |    811025 |
|          5 |    811026 |
|          6 |    811027 |
|          7 |    811028 |
|          8 |    811029 |
|          9 |    811030 |
|         10 |    811031 |


Table: FactValuationHist
|   ValuationHistKey | cst_credit_cargo   |   ValuationKey |   TradeKey | Trade Date   |   TradeTypeKey |   CreditPartyKey |   PositionKey |   SwapTypeKey |   CompanyKey |   CounterpartyKey | Begtime                 |   PackageKey |    Mark to Market | Expected Due Date   |   ExposureKey | Price   |   Quantity | Marketprice   |   Value |   ShipmentKey | Fee type   | Settlement date   |   PaymentTermKey | Movement   |   ValuationTypeKey |   DescriptionKey |   FinalCounterpartyKey |
|-------------------:|:-------------------|---------------:|-----------:|:-------------|---------------:|-----------------:|--------------:|--------------:|-------------:|------------------:|:------------------------|-------------:|------------------:|:--------------------|--------------:|:--------|-----------:|:--------------|--------:|--------------:|:-----------|:------------------|-----------------:|:-----------|-------------------:|-----------------:|-----------------------:|
|                  3 |                    |              1 |          2 |              |              2 |                2 |             3 |             1 |            2 |                 2 | 2018-07-19 00:00:00.000 |            3 | -992405           |                     |             2 |         |    3640307 |               |       0 |             3 |            |                   |                2 | False      |                  1 |                2 |                      2 |
|                  4 |                    |              1 |          3 |              |              2 |                3 |             4 |             1 |            2 |                 3 | 2018-08-27 00:00:00.000 |            3 |       1.21825e+06 |                     |             2 |         |   -3461787 |               |       0 |             3 |            |                   |                2 | False      |                  1 |                2 |                      3 |
|                  5 |                    |              1 |          4 |              |              2 |                3 |             5 |             1 |            2 |                 3 | 2018-07-10 00:00:00.000 |            4 |  852605           |                     |             2 |         |   -2916121 |               |       0 |             4 |            |                   |                2 | False      |                  1 |                2 |                      3 |
|                  6 |                    |              1 |          5 |              |              2 |                4 |             6 |             1 |            2 |                 4 | 2018-07-10 00:00:00.000 |            4 | -849937           |                     |             2 |         |    2916121 |               |       0 |             4 |            |                   |                2 | False      |                  1 |                2 |                      4 |
|                  7 |                    |              1 |          6 |              |              2 |                2 |             7 |             1 |            2 |                 2 | 2018-08-08 00:00:00.000 |            5 | -932866           |                     |             2 |         |    3477420 |               |       0 |             5 |            |                   |                2 | False      |                  1 |                2 |                      2 |
|                  8 |                    |              1 |          7 |              |              2 |                5 |             8 |             1 |            2 |                 5 | 2018-08-08 00:00:00.000 |            5 |  963471           |                     |             2 |         |   -3477420 |               |       0 |             5 |            |                   |                2 | False      |                  1 |                2 |                      5 |
|                  9 |                    |              1 |          8 |              |              2 |                2 |             9 |             1 |            2 |                 2 | 2018-08-01 00:00:00.000 |            6 |  891047           |                     |             2 |         |   -3117041 |               |       0 |             6 |            |                   |                2 | False      |                  1 |                2 |                      2 |
|                 10 |                    |              1 |          9 |              |              2 |                3 |            10 |             1 |            2 |                 3 | 2018-08-01 00:00:00.000 |            6 | -883898           |                     |             2 |         |    3117041 |               |       0 |             6 |            |                   |                2 | False      |                  1 |                2 |                      3 |
|                 11 |                    |              1 |         10 |              |              2 |                2 |            11 |             1 |            2 |                 2 | 2018-08-16 00:00:00.000 |            7 |       1.25353e+06 |                     |             2 |         |   -4808033 |               |       0 |             7 |            |                   |                2 | False      |                  1 |                2 |                      2 |
|                 12 |                    |              1 |         11 |              |              2 |                3 |            12 |             1 |            2 |                 3 | 2018-08-16 00:00:00.000 |            7 |      -1.33392e+06 |                     |             2 |         |    4808033 |               |       0 |             7 |            |                   |                2 | False      |                  1 |                2 |                      3 |


Table: FactVersionHistory
|   HistoryKey | VersionDate             | Comments                                                                                                 |   EmployeeKey |   DateKey |
|-------------:|:------------------------|:---------------------------------------------------------------------------------------------------------|--------------:|----------:|
|            1 | 2019-07-02 00:00:00.000 | 1) Added VersionHistory                                                                                  |             3 |  20190702 |
|              |                         | 2) Credit limit source updated                                                                           |               |           |
|            2 | 2019-07-23 00:00:00.000 | Cargo exposure points to Position instead of Trade (TBS: exposure of multi-discharges is over estimated) |             3 |  20190723 |
|            3 | 2019-08-16 00:00:00.000 | Reformat the table in Table Summary                                                                      |             3 |  20190816 |
|            4 | 2019-09-12 00:00:00.000 | 1) Added tradedate column                                                                                |             1 |  20190912 |
|              |                         | 2) Limit to only last 6 months valuation data                                                            |               |           |
|            5 | 2019-10-23 00:00:00.000 | Added credit cargo which enable manual split to the cargo if multiple discharges                         |             2 |  20191023 |
|            6 | 2019-12-13 00:00:00.000 | Name change to KYC status column                                                                         |             3 |  20191213 |
|            7 | 2020-05-29 00:00:00.000 | Updated to use v_report_* common views                                                                   |             1 |  20200529 |
|            8 | 2020-07-29 00:00:00.000 | Add a filter (Position Type not equal to Inventory) to the Total Exposure calculation                    |             3 |  20200729 |
|            9 | 2020-11-03 00:00:00.000 | Exclude CURRENT valuation type records from valuationExtract query                                       |             1 |  20201103 |
|           10 | 2020-12-03 00:00:00.000 | Add credit/KYC expiry date to Approved Credit Limit table                                                |             3 |  20201203 |

 


tables: name: DimCargoStatus
data: DimCargoStatus.csv
name: DimCompany
data: DimCompany.csv
name: DimCounterparty
data: DimCounterparty.csv
name: DimCounterpartyClass
data: DimCounterpartyClass.csv
name: DimCounterpartyType
data: DimCounterpartyType.csv
name: DimCreditParty
data: DimCreditParty.csv
name: DimCreditRating
data: DimCreditRating.csv
name: DimCreditTerm
data: DimCreditTerm.csv
name: DimCurrency
data: DimCurrency.csv
name: DimDate
data: DimDate.csv
name: DimDescription
data: DimDescription.csv
name: DimEmployee
data: DimEmployee.csv
name: DimExposure
data: DimExposure.csv
name: DimKYCStatus
data: DimKYCStatus.csv
name: DimLimitLevel
data: DimLimitLevel.csv
name: DimMarket
data: DimMarket.csv
name: DimParent
data: DimParent.csv
name: DimPaymentTerm
data: DimPaymentTerm.csv
name: DimPositionType
data: DimPositionType.csv
name: DimRatingSource
data: DimRatingSource.csv
name: DimSecurity
data: DimSecurity.csv
name: DimStatus
data: DimStatus.csv
name: DimSwapType
data: DimSwapType.csv
name: DimTradeType
data: DimTradeType.csv
name: DimUnit
data: DimUnit.csv
name: DimValuation
data: DimValuation.csv
name: DimValuationDesc
data: DimValuationDesc.csv
name: DimValuationMode
data: DimValuationMode.csv
name: DimValuationType
data: DimValuationType.csv
name: DimVessel
data: DimVessel.csv
name: FactCredit
data: FactCredit.csv
name: FactCreditCargo
data: FactCreditCargo.csv
name: FactMerge
data: FactMerge.csv
name: FactOpenLine
data: FactOpenLine.csv
name: FactPackage
data: FactPackage.csv
name: FactPhysicalExposure
data: FactPhysicalExposure.csv
name: FactPositions
data: FactPositions.csv
name: FactShipments
data: FactShipments.csv
name: FactTrades
data: FactTrades.csv
name: FactValuationHist
data: FactValuationHist.csv
name: FactVersionHistory
data: FactVersionHistory.csv
label: DimCounterparty
ParentKey
DimParent
ParentKey
DimCounterparty
ClassKey
DimCounterpartyClass
ClassKey
DimCounterparty
TypeKey
DimCounterpartyType
TypeKey
FactCredit
CreditRatingKey
DimCreditRating
CreditRatingKey
FactCredit
CurrencyKey
DimCurrency
CurrencyKey
FactCredit
LimitLevelKey
DimLimitLevel
LimitLevelKey
FactCredit
SecurityKey
DimSecurity
SecurityKey
FactCredit
StatusKey
DimStatus
StatusKey
DimCounterparty
CounterpartyKey
FactCredit
CounterpartyKey
DimVessel
Name
DimCreditRating
Name
FactPhysicalExposure
CargoStatusKey
DimCargoStatus
CargoStatusKey
FactPhysicalExposure
UnitKey
DimUnit
UnitKey
FactPhysicalExposure
ValuationModeKey
DimValuationMode
ValuationModeKey
FactPhysicalExposure
VesselKey
DimVessel
VesselKey
FactPhysicalExposure
PackageKey
FactPackage
PackageKey
FactPhysicalExposure
MarketKey
DimMarket
MarketAreaKey
FactCredit
RatingSourceKey
DimRatingSource
CreditSourceKey
FactOpenLine
CreditTermKey
DimCreditTerm
CreditTermKey
FactOpenLine
KYCStatusKey
DimKYCStatus
KYCStatusKey
FactMerge
CounterpartyKey
DimCounterparty
CounterpartyKey
FactMerge
CompanyKey
DimCompany
CompanyKey
FactMerge
CargoStatusKey
DimCargoStatus
CargoStatusKey
FactMerge
DescriptionKey
DimDescription
DescriptionKey
FactMerge
PaymentTermKey
FactCreditCargo
PaymentTermKey
FactMerge
PaymentTermKey
DimPaymentTerm
PaymentTermKey
FactMerge
PositionTypeKey
DimPositionType
PositionTypeKey
FactPositions
PositionTypeKey
DimPositionType
PositionTypeKey
FactMerge
ValuationTypeKey
DimValuationType
ValuationTypeKey
FactMerge
ExposureKey
DimExposure
ExposureTypeKey
FactMerge
TradeKey
FactTrades
TradeKey
FactMerge
ShipmentKey
FactShipments
ShipmentKey
FactValuationHist
CounterpartyKey
DimCounterparty
CounterpartyKey
FactValuationHist
CompanyKey
DimCompany
CompanyKey
FactValuationHist
CreditPartyKey
DimCreditParty
CreditPartyKey
FactValuationHist
DescriptionKey
DimValuationDesc
DescriptionKey
FactValuationHist
PaymentTermKey
FactCreditCargo
PaymentTermKey
FactValuationHist
PaymentTermKey
DimPaymentTerm
PaymentTermKey
FactValuationHist
TradeTypeKey
DimTradeType
TradeTypeKey
FactValuationHist
ValuationTypeKey
DimValuationType
ValuationTypeKey
FactValuationHist
TradeKey
FactTrades
TradeKey
FactValuationHist
PositionKey
FactPositions
PositionKey
FactValuationHist
ShipmentKey
FactShipments
ShipmentKey
FactValuationHist
SwapTypeKey
DimSwapType
SwapTypeKey
FactValuationHist
ValuationKey
DimValuation
ValuationKey
FactVersionHistory
EmployeeKey
DimEmployee
EmployeeKey
FactVersionHistory
DateKey
DimDate
DateKey
DimCounterparty
CounterpartyKey
FactOpenLine
CounterpartyKey
FactOpenLine
CreditExpiryDate
DimDate
DateKey
output: {
    "joins": [
        {
            "from_table": "DimCounterparty",
            "from_column": "ParentKey",
            "to_table": "DimParent",
            "to_column": "ParentKey"
        },
        {
            "from_table": "DimCounterparty",
            "from_column": "ClassKey",
            "to_table": "DimCounterpartyClass",
            "to_column": "ClassKey"
        },
        {
            "from_table": "DimCounterparty",
            "from_column": "TypeKey",
            "to_table": "DimCounterpartyType",
            "to_column": "TypeKey"
        },
        {
            "from_table": "FactCredit",
            "from_column": "CreditRatingKey",
            "to_table": "DimCreditRating",
            "to_column": "CreditRatingKey"
        },
        {
            "from_table": "FactCredit",
            "from_column": "CurrencyKey",
            "to_table": "DimCurrency",
            "to_column": "CurrencyKey"
        },
        {
            "from_table": "FactCredit",
            "from_column": "LimitLevelKey",
            "to_table": "DimLimitLevel",
            "to_column": "LimitLevelKey"
        },
        {
            "from_table": "FactCredit",
            "from_column": "SecurityKey",
            "to_table": "DimSecurity",
            "to_column": "SecurityKey"
        },
        {
            "from_table": "FactCredit",
            "from_column": "StatusKey",
            "to_table": "DimStatus",
            "to_column": "StatusKey"
        },
        {
            "from_table": "DimCounterparty",
            "from_column": "CounterpartyKey",
            "to_table": "FactCredit",
            "to_column": "CounterpartyKey"
        },
        {
            "from_table": "DimVessel",
            "from_column": "Name",
            "to_table": "DimCreditRating",
            "to_column": "Name"
        },
        {
            "from_table": "FactPhysicalExposure",
            "from_column": "CargoStatusKey",
            "to_table": "DimCargoStatus",
            "to_column": "CargoStatusKey"
        },
        {
            "from_table": "FactPhysicalExposure",
            "from_column": "UnitKey",
            "to_table": "DimUnit",
            "to_column": "UnitKey"
        },
        {
            "from_table": "FactPhysicalExposure",
            "from_column": "ValuationModeKey",
            "to_table": "DimValuationMode",
            "to_column": "ValuationModeKey"
        },
        {
            "from_table": "FactPhysicalExposure",
            "from_column": "VesselKey",
            "to_table": "DimVessel",
            "to_column": "VesselKey"
        },
        {
            "from_table": "FactPhysicalExposure",
            "from_column": "PackageKey",
            "to_table": "FactPackage",
            "to_column": "PackageKey"
        },
        {
            "from_table": "FactPhysicalExposure",
            "from_column": "MarketKey",
            "to_table": "DimMarket",
            "to_column": "MarketAreaKey"
        },
        {
            "from_table": "FactCredit",
            "from_column": "RatingSourceKey",
            "to_table": "DimRatingSource",
            "to_column": "CreditSourceKey"
        },
        {
            "from_table": "FactOpenLine",
            "from_column": "CreditTermKey",
            "to_table": "DimCreditTerm",
            "to_column": "CreditTermKey"
        },
        {
            "from_table": "FactOpenLine",
            "from_column": "KYCStatusKey",
            "to_table": "DimKYCStatus",
            "to_column": "KYCStatusKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "CounterpartyKey",
            "to_table": "DimCounterparty",
            "to_column": "CounterpartyKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "CompanyKey",
            "to_table": "DimCompany",
            "to_column": "CompanyKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "CargoStatusKey",
            "to_table": "DimCargoStatus",
            "to_column": "CargoStatusKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "DescriptionKey",
            "to_table": "DimDescription",
            "to_column": "DescriptionKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "PaymentTermKey",
            "to_table": "FactCreditCargo",
            "to_column": "PaymentTermKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "PaymentTermKey",
            "to_table": "DimPaymentTerm",
            "to_column": "PaymentTermKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "PositionTypeKey",
            "to_table": "DimPositionType",
            "to_column": "PositionTypeKey"
        },
        {
            "from_table": "FactPositions",
            "from_column": "PositionTypeKey",
            "to_table": "DimPositionType",
            "to_column": "PositionTypeKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "ValuationTypeKey",
            "to_table": "DimValuationType",
            "to_column": "ValuationTypeKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "ExposureKey",
            "to_table": "DimExposure",
            "to_column": "ExposureTypeKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "TradeKey",
            "to_table": "FactTrades",
            "to_column": "TradeKey"
        },
        {
            "from_table": "FactMerge",
            "from_column": "ShipmentKey",
            "to_table": "FactShipments",
            "to_column": "ShipmentKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "CounterpartyKey",
            "to_table": "DimCounterparty",
            "to_column": "CounterpartyKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "CompanyKey",
            "to_table": "DimCompany",
            "to_column": "CompanyKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "CreditPartyKey",
            "to_table": "DimCreditParty",
            "to_column": "CreditPartyKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "DescriptionKey",
            "to_table": "DimValuationDesc",
            "to_column": "DescriptionKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "PaymentTermKey",
            "to_table": "FactCreditCargo",
            "to_column": "PaymentTermKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "PaymentTermKey",
            "to_table": "DimPaymentTerm",
            "to_column": "PaymentTermKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "TradeTypeKey",
            "to_table": "DimTradeType",
            "to_column": "TradeTypeKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "ValuationTypeKey",
            "to_table": "DimValuationType",
            "to_column": "ValuationTypeKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "TradeKey",
            "to_table": "FactTrades",
            "to_column": "TradeKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "PositionKey",
            "to_table": "FactPositions",
            "to_column": "PositionKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "ShipmentKey",
            "to_table": "FactShipments",
            "to_column": "ShipmentKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "SwapTypeKey",
            "to_table": "DimSwapType",
            "to_column": "SwapTypeKey"
        },
        {
            "from_table": "FactValuationHist",
            "from_column": "ValuationKey",
            "to_table": "DimValuation",
            "to_column": "ValuationKey"
        },
        {
            "from_table": "FactVersionHistory",
            "from_column": "EmployeeKey",
            "to_table": "DimEmployee",
            "to_column": "EmployeeKey"
        },
        {
            "from_table": "FactVersionHistory",
            "from_column": "DateKey",
            "to_table": "DimDate",
            "to_column": "DateKey"
        },
        {
            "from_table": "DimCounterparty",
            "from_column": "CounterpartyKey",
            "to_table": "FactOpenLine",
            "to_column": "CounterpartyKey"
        },
        {
            "from_table": "FactOpenLine",
            "from_column": "CreditExpiryDate",
            "to_table": "DimDate",
            "to_column": "DateKey"
        }
    ]
}