Datatype mismatch between datalink and workbook

April 02, 2020 15:26

I'm not sure how to fix a datatype mismatch between a datalink and a workbook. This is the error.

datameer.dap.common.exception.ComputationException: Column Latest_022820!expected_aoci is of type BigDecimalValueType{precision=null, scale=null}, but column data is of type FLOAT.

Comments

13 comments

Konsta Danyliuk

April 02, 2020 15:39
Hello Thomas.

When exactly do you face this exception - while creating a Workbook or while running it? Or perhaps Datameer drops some records with this exception?

This might be also a data issue - e.g. during the DataLink setup the column's expected_aoci type has been automatically detected or manually set as BigDecimal, but the actual values have FLOAT type.
0

Comment actions Permalink
thomas lee

April 02, 2020 15:47
I original had setup the datalink a few months ago and manually changed some of the quantitative fields to type 'FLOAT', yesterday I changed those same fields to big_decimal in the datalink and added new fields to the schema as well. What I found in the workbooks is that it seems to refer to the old data type.
0

Comment actions Permalink
Konsta Danyliuk

April 02, 2020 15:51

Edited
Hello Thomas.
Just to confirm, have you rerun the DataLink, after you've made those changes to the schema? And what Datameer version do you have?
0

Comment actions Permalink
thomas lee

April 02, 2020 16:00
The jobs have been re-running since the morning but are very slow. I'm also hoping this will resolve the issues. I'm on Datameer version: 7.4.6
0

Comment actions Permalink
Konsta Danyliuk

April 02, 2020 17:06

Edited
Hello Thomas.
Please let me know whether rerunning the DataLink and the subsequent Workbook helps to reflect the schema changes.
0

Comment actions Permalink
thomas lee

April 03, 2020 13:20
Refreshing the datalink worked but now whenever I change a sql query or formula in the workbook, I will get datatype errors like this until I re-run the book.

RecordSource for sheet 'Missing_Reference' (das.internal.SqlSheetType) of incorrect type. Is RecordType{[STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, INTEGER, STRING, STRING, STRING, STRING, STRING, STRING, BigDecimalValueType{precision=null, scale=null}, BigDecimalValueType{precision=null, scale=null}]} but expected RecordType{[STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, INTEGER, STRING, STRING, STRING, STRING, STRING, STRING, BigDecimalValueType{precision=null, scale=null}, STRING]}.
0

Comment actions Permalink
Konsta Danyliuk

April 03, 2020 13:49
Hello Thomas.

Any change you could attach your DataLink's and Workbook's job-definition.json files? You could retrieve them from a JobTrace. How to Collect a Job Trace.
0

Comment actions Permalink
thomas lee

April 03, 2020 14:23
INFO [2020-04-03 10:21:06.138] [qtp693632176-4588991] (JobTraceCollector.java:123) - Including single history artifact JOB_DEFINITION
INFO [2020-04-03 10:21:06.164] [qtp693632176-4588991] (JobTraceCollector.java:129) - No artifacts of type JOB_DEFINITION do exist!
INFO [2020-04-03 10:21:06.165] [qtp693632176-4588991] (JobTraceCollector.java:123) - Including single history artifact JOB_LOG
INFO [2020-04-03 10:21:06.179] [qtp693632176-4588991] (JobTraceCollector.java:170) - Copying 'job.log' from 'JobStorageFile{jobhistory/101687/3842247/job.log}' to '/app/software/Datameer/Datameer-7.4.6-hdp-2.6.5-hive1/temp/cache/dfscache/795/job-3842247/job.log'
INFO [2020-04-03 10:21:06.187] [qtp693632176-4588991] (JobTraceCollector.java:123) - Including single history artifact JOB_PLAN_ORIGINAL
INFO [2020-04-03 10:21:06.193] [qtp693632176-4588991] (JobTraceCollector.java:129) - No artifacts of type JOB_PLAN_ORIGINAL do exist!
INFO [2020-04-03 10:21:06.193] [qtp693632176-4588991] (JobTraceCollector.java:123) - Including single history artifact JOB_PLAN_COMPILED
INFO [2020-04-03 10:21:06.216] [qtp693632176-4588991] (JobTraceCollector.java:129) - No artifacts of type JOB_PLAN_COMPILED do exist!
INFO [2020-04-03 10:21:06.217] [qtp693632176-4588991] (JobTraceCollector.java:123) - Including single history artifact JOB_CONF
INFO [2020-04-03 10:21:06.237] [qtp693632176-4588991] (JobTraceCollector.java:129) - No artifacts of type JOB_CONF do exist!
INFO [2020-04-03 10:21:06.238] [qtp693632176-4588991] (JobTraceCollector.java:123) - Including single history artifact JOB_EXECUTION_TRACE
INFO [2020-04-03 10:21:06.259] [qtp693632176-4588991] (JobTraceCollector.java:129) - No artifacts of type JOB_EXECUTION_TRACE do exist!
INFO [2020-04-03 10:21:06.260] [qtp693632176-4588991] (JobTraceCollector.java:123) - Including single history artifact CLUSTER_JOBS
INFO [2020-04-03 10:21:06.282] [qtp693632176-4588991] (JobTraceCollector.java:129) - No artifacts of type CLUSTER_JOBS do exist!
INFO [2020-04-03 10:21:06.283] [qtp693632176-4588991] (JobTraceCollector.java:123) - Including single history artifact JOB_PAYLOAD
INFO [2020-04-03 10:21:06.308] [qtp693632176-4588991] (JobTraceCollector.java:129) - No artifacts of type JOB_PAYLOAD do exist!
INFO [2020-04-03 10:21:06.309] [qtp693632176-4588991] (JobTraceCollector.java:137) - Including multi history artifact ERROR_LOG
INFO [2020-04-03 10:21:06.345] [qtp693632176-4588991] (JobTraceCollector.java:142) - No artifacts of type ERROR_LOG do exist!
INFO [2020-04-03 10:21:06.346] [qtp693632176-4588991] (JobTraceCollector.java:137) - Including multi history artifact TASK_LOG
INFO [2020-04-03 10:21:06.362] [qtp693632176-4588991] (JobTraceCollector.java:142) - No artifacts of type TASK_LOG do exist!
INFO [2020-04-03 10:21:06.363] [qtp693632176-4588991] (JobTraceCollector.java:137) - Including multi history artifact JOB_INPUT_DEFINITION
INFO [2020-04-03 10:21:06.461] [qtp693632176-4588991] (JobTraceCollector.java:142) - No artifacts of type JOB_INPUT_DEFINITION do exist!
INFO [2020-04-03 10:21:06.462] [qtp693632176-4588991] (JobTraceCollector.java:137) - Including multi history artifact JOB_CONF_CLUSTER
INFO [2020-04-03 10:21:06.493] [qtp693632176-4588991] (JobTraceCollector.java:142) - No artifacts of type JOB_CONF_CLUSTER do exist!
0

Comment actions Permalink
Konsta Danyliuk

April 03, 2020 14:36
Hello Thomas.
Looks like the JobTrace is not complete for some reason. There is an alternative way to the artifact's definition.

Workbook
- Open the Workbook in Datameer UI.
- Change the page's address in the browser from http://<host>:<port>/workbook/<id> to http://<host>:<port>/rest/workbook/<id>
- This returns the Workbooks definition as a JSON file.
DataLink
- Click once on the DataLink in UI, note the ID value at the Inspector's Information tab (left side of the page).
- Open ImportJob's configuration.
- Change the page's address in the browser from http://<host>:<port>/import-job/chooseConnection to http://<host>:<port>/rest/import-job/<ID>
- This returns the Workbooks definition as a JSON file.
0

Comment actions Permalink

thomas lee

April 03, 2020 14:41

These are long so i'll send them in separate comments:

Workbook JSON:

{
  "version": "7.4.6",
  "className": "datameer.dap.common.entity.WorkbookConfigurationImpl",
  "file": {
    "uuid": "7cddfcbf-2f38-45f5-ac3b-a281f233ee6a",
    "path": "/Teams/FinanceCore/Finance/ESP/Reports/Exception Reports/Feb 2020/Reference Exception Report.wbk",
    "description": "",
    "name": "Reference Exception Report"
  },
  "pullType": "WHEN_NEW_DATA_COMES_IN",
  "schedule": "0 10 * * 0-6",
  "minKeepCount": 1,
  "properties": {},
  "hadoopProperties": "",
  "notificationAddresses": "",
  "notificationSuccessAddresses": "",
  "sheets": [
    {
      "name": "Latest_022820",
      "sheetId": "86dfd55e-47b5-4c01-a0d9-76fc00811201",
      "sheetType": "das.internal.ExternalWorkbookSheetType",
      "keep": false,
      "runTriggeringConfiguration": {
        "runTrigger": true
      },
      "referencedSheet": {
        "name": "Latest_022820",
        "sheetId": "8ae2f066-38e7-4287-a27f-1111998bdddd",
        "workbook": {
          "path": "/Teams/FinanceCore/Finance/ESP/Reports/Latest ESP View/Latest 022920 ESP View Workbook.wbk",
          "uuid": "a23e6e58-1644-4e7a-802f-d0b8d2df96ce"
        }
      },
      "columnStyles": [
        {
          "columnId": "source_batch_id",
          "name": "source_batch_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "as_at_date",
          "name": "as_at_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_key",
          "name": "business_key",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecl_old_record_id",
          "name": "ecl_old_record_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "region",
          "name": "region",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_system_id",
          "name": "source_system_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eod_position_id",
          "name": "eod_position_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "record_origin",
          "name": "record_origin",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eodc_asset_class_type",
          "name": "eodc_asset_class_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eodc_product_type",
          "name": "eodc_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eodc_product_sub_type",
          "name": "eodc_product_sub_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "aa7f9b761bac6dedd2077dd090ffbf6c",
          "name": "source_product_classification",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d543f8a9e396ada8ea06b8128d6bb4d6",
          "name": "lrm_product_classification_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "market_sector",
          "name": "market_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_type_indicator",
          "name": "security_type_indicator",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecpt_code",
          "name": "ecpt_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecpt_name",
          "name": "ecpt_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecpt_parent_code",
          "name": "ecpt_parent_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "external_product_type",
          "name": "external_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_classification",
          "name": "country_classification",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_sector",
          "name": "b2_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_bs_60200_rollup",
          "name": "b2_bs_60200_rollup",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_product_type_1",
          "name": "b2_product_type_1",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_product_type_2",
          "name": "b2_product_type_2",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "gdal_sector",
          "name": "gdal_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "agency",
          "name": "agency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_type",
          "name": "position_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_level_name",
          "name": "position_level_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "instrument_currency",
          "name": "instrument_currency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "reporting_currency",
          "name": "reporting_currency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "instrument_srdr_id",
          "name": "instrument_srdr_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "isin_id",
          "name": "isin_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bloomberg_unique_id",
          "name": "bloomberg_unique_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cusip_id",
          "name": "cusip_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sedol_id",
          "name": "sedol_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_instrument_id",
          "name": "source_instrument_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_trade_group_id",
          "name": "source_trade_group_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_trade_id",
          "name": "source_trade_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "4733727496358f00c356a56a8bb44b3c",
          "name": "source_contract_version_number",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "involved_party_id",
          "name": "involved_party_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9d9ba992405dd18bc0be7b001e7722cc",
          "name": "involved_party_id_source_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d9f3cd8b0f9a7479045c140d0d041129",
          "name": "source_counterparty_short_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_short_long_code",
          "name": "position_short_long_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "pay_receive_code",
          "name": "pay_receive_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_quantity",
          "name": "position_quantity",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_decorator_id",
          "name": "position_decorator_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_decorator_type",
          "name": "position_decorator_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issue_date",
          "name": "issue_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "maturity_date",
          "name": "maturity_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fcecf63c351f588a2ab251bb1cb425a9",
          "name": "original_term_to_maturity_days",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "28111b933bd48408a09002e419f21f69",
          "name": "residual_term_to_maturity_days",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_settlement_date",
          "name": "position_settlement_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cc00e3f46e0426d27f6c548222ee2f0e",
          "name": "issue_rating_moody_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "4ff8da698d29a6eabc31fc48741b67b8",
          "name": "issue_rating_sp_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f13d373b39cd2fcb7c198b95992c51f6",
          "name": "issue_rating_fitch_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "a16bebf5c160b5096576ae743ed49f63",
          "name": "issue_rating_dbrs_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_cdr_id",
          "name": "issuer_cdr_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_bbg_id",
          "name": "issuer_bbg_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_srf",
          "name": "issuer_srf",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_name",
          "name": "issuer_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "e32efe965d0939ea5a9f01a44c5ac1c9",
          "name": "issuer_ultimate_parent_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_industry",
          "name": "issuer_industry",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c27c46c7c43729733dbf1f89ffbcd618",
          "name": "issuer_dom_country_short_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_province",
          "name": "issuer_province",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_rbcsic",
          "name": "issuer_rbcsic",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f94dd9356af18de78e4d06161f4db018",
          "name": "issuer_business_risk_rating",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_rating_sp_lt_fc",
          "name": "issuer_rating_sp_lt_fc",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_rating_sp_lt_li",
          "name": "issuer_rating_sp_lt_li",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "729d51542b944e081037ecb4876043bd",
          "name": "issuer_rating_fitch_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "39ba424f65a0d00efd7f24732ba0c9e3",
          "name": "issuer_rating_moody_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8f8317e02b7a4d0135c5696e9312754e",
          "name": "issuer_rating_dbrs_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_cdr_id",
          "name": "guarantor_cdr_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_bbg_id",
          "name": "guarantor_bbg_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_srf",
          "name": "guarantor_srf",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_name",
          "name": "guarantor_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c48b9a06ea964c06f156acf4ae9290cf",
          "name": "guarantor_ultimate_parent_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_rbcsic",
          "name": "guarantor_rbcsic",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8c4941ca145a9db2a5459ec62992f781",
          "name": "guarantor_business_risk_rating",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "coupon_rate",
          "name": "coupon_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "coupon_type",
          "name": "coupon_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "last_coupon_reset_date",
          "name": "last_coupon_reset_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "next_coupon_reset_date",
          "name": "next_coupon_reset_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "coupon_reset_frequency",
          "name": "coupon_reset_frequency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "reset_index",
          "name": "reset_index",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "rbc_issued_flag",
          "name": "rbc_issued_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_product_type",
          "name": "security_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_product_type",
          "name": "bbg_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_product_subtype",
          "name": "bbg_product_subtype",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_description",
          "name": "security_description",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_sector",
          "name": "bbg_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_industry_group",
          "name": "bbg_industry_group",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_industry_sub_group",
          "name": "bbg_industry_sub_group",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sector_immediate_risk",
          "name": "sector_immediate_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sector_ultimate_risk",
          "name": "sector_ultimate_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "collateral_type",
          "name": "collateral_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ticker",
          "name": "ticker",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "mortg_deal_type",
          "name": "mortg_deal_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "mortg_issuer_fullname",
          "name": "mortg_issuer_fullname",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "compliance_code",
          "name": "compliance_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "tranche_type_description",
          "name": "tranche_type_description",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "is_subordinated",
          "name": "is_subordinated",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_of_domicile",
          "name": "country_of_domicile",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_of_risk",
          "name": "country_of_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_ultimate_risk",
          "name": "country_ultimate_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_of_guarantor",
          "name": "country_of_guarantor",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bdr_book_id",
          "name": "bdr_book_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_book_id",
          "name": "source_book_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_book_name",
          "name": "source_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_sub_book_name",
          "name": "source_sub_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "slim_app_book_cd",
          "name": "slim_app_book_cd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "slim_app_book_name",
          "name": "slim_app_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_number",
          "name": "transit_number",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_desc",
          "name": "transit_desc",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "3690b5a2ec60a81854286caea077d726",
          "name": "source_booking_transit_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_short_name",
          "name": "transit_short_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "master_book_name",
          "name": "master_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "master_book_desc",
          "name": "master_book_desc",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sub_branch_code",
          "name": "sub_branch_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_unit_name",
          "name": "business_unit_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "legal_entity_name",
          "name": "legal_entity_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "desk_name",
          "name": "desk_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7c5f0abcb20e5c53eb01fa0fa1efad19",
          "name": "functional_reporting_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "segment",
          "name": "segment",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "processing_center",
          "name": "processing_center",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "control_unit",
          "name": "control_unit",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "18587f33d97f1c2376a912fac6ddaa52",
          "name": "processing_center_country_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9be35045804f4280d7b57d042734c842",
          "name": "legal_entity_country_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "disposition_type",
          "name": "disposition_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "disposition_amount",
          "name": "disposition_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "disposition_amount_cad",
          "name": "disposition_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "purchase_date",
          "name": "purchase_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "units_purchased",
          "name": "units_purchased",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "purchase_amount",
          "name": "purchase_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "purchase_amount_cad",
          "name": "purchase_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "52c2308e807c3b3d359483972bb2fac6",
          "name": "expected_credit_loss_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9c11f32422038d6a9f141e170cefb16a",
          "name": "expected_credit_loss_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "60b82bb30e44cea462fad9f3a80f16dc",
          "name": "expected_credit_loss_stage",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "expected_aoci",
          "name": "expected_aoci",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5aa52cd8a8d22609ba595cf859f1e575",
          "name": "provision_credit_loss_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "08b1384aa13962ef5ff0b1ca3d090cf1",
          "name": "provision_credit_loss_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "proxy_flag",
          "name": "proxy_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "74516af4b183b213cde293d23619776b",
          "name": "fair_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fair_value_amount",
          "name": "fair_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c04dba5f52b456962cdeba96e80bbdc1",
          "name": "fair_value_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5eb76be99416aae745e28b7e4e8a2c7e",
          "name": "fair_value_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fair_value_amount_cad",
          "name": "fair_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7124be6b6ed16cbc9dc0ff827b9a22e5",
          "name": "fair_value_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c88fa08e0df52956399b49afca38e9a7",
          "name": "book_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "book_value_amount",
          "name": "book_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "0ca35f56fdc968d1b75b98d92987dfec",
          "name": "book_value_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "644373c17345eeeabecdbfd2b9bc6a83",
          "name": "book_value_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "book_value_amount_cad",
          "name": "book_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "efd21ee9989ec32fc0280e12aa1c50bb",
          "name": "book_value_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f94e29e71f663e8f7d8e902b103372de",
          "name": "net_carrying_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "648dd4dc0a2f478d5d2e9e970036ac0a",
          "name": "net_carrying_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "89516cf5111e1c34f14817044d11a8dc",
          "name": "net_carrying_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "6a0b722276cc70ca336912a9ce70dbfe",
          "name": "gross_carrying_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "964fc1e5ca360efa935891a9724f1de5",
          "name": "gross_carrying_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "6ce365e75eb84b2159f780e5c2e9c1d7",
          "name": "gross_carrying_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bs_egl_account",
          "name": "bs_egl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bs_egl_account_name",
          "name": "bs_egl_account_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "634cd26692e26b61d4743ed843ec3987",
          "name": "accounting_classification",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7c4e7267fc91d6a3cb90b20e7cae3694",
          "name": "mark_to_market_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "mark_to_market_amount",
          "name": "mark_to_market_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1dbdcc669ef3eccf97440ef39893d5ff",
          "name": "mark_to_market_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "618bf2913fb3756454129762628145b3",
          "name": "clean_mark_to_market_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "297c9bf5e4f034c86ff308d142723623",
          "name": "clean_mark_to_market_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cf2a8cf23eb8c0ad178b8b99b5033f7b",
          "name": "clean_mark_to_market_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "900383ed5ed54544a5af32b8dac9a8ef",
          "name": "dirty_mark_to_market_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5005370c3e0e7f2476e7e1a6711e22c2",
          "name": "dirty_mark_to_market_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "971ac8e914336412ccd2445ed9be2a2c",
          "name": "dirty_mark_to_market_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8abbcd1abc06c788d84495142763f83d",
          "name": "notional_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "notional_amount",
          "name": "notional_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "notional_amount_cad",
          "name": "notional_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f43f019ab7c64061470f5bfcae089d36",
          "name": "accrued_interest_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "accrued_interest_amount",
          "name": "accrued_interest_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f9788eb99c2540eaa761392ada92a8a8",
          "name": "accrued_interest_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "33a23e5d44f59b8d835af829df4e0d51",
          "name": "accrued_interest_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eeb7902f4beb762fe83f2a04825c2b6d",
          "name": "accrued_interest_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ec584d6dfc9a250dda7c3a4b197b7c70",
          "name": "accrued_interest_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "a02bf80ec8714f6b603bfab2a809fb3c",
          "name": "accrued_interest_amount_dly_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1975b13c377123672d989bbd9b218ab3",
          "name": "accrued_interest_amount_dly",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bb9a2c46440a7263c2838d1cd3a86791",
          "name": "accrued_interest_amount_dly_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "2a74c48a3bd581e877c347a0589000c8",
          "name": "accrued_interest_amount_mtd_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8c990759fe92c6e0518fb39c78edd37c",
          "name": "accrued_interest_amount_mtd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "405a4161214c60a499ad342f936801ba",
          "name": "accrued_interest_amount_mtd_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ee1e9225b09d54914dacd1d3005c83e2",
          "name": "cost_basis_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cost_basis_amount",
          "name": "cost_basis_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cost_basis_amount_cad",
          "name": "cost_basis_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b36ac5df56abd47280d900e2289d5611",
          "name": "current_ltd_hedge_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "oci_adjustment_amount",
          "name": "oci_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "14b90d80ab80c9e524917986f69dcb02",
          "name": "purchase_price_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "75e2ce61a5350dbe5addb1f0d91543d6",
          "name": "tax_credit_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "80e7520582b31d10881219cfcdf49c8d",
          "name": "unrealized_pnl_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "unrealized_pnl",
          "name": "unrealized_pnl",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "unrealized_pnl_cad",
          "name": "unrealized_pnl_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b266670d919cd88ba6a9604a477c6301",
          "name": "realized_pnl_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl",
          "name": "realized_pnl",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5ace8bb0e6c488e602c524f68ef519e0",
          "name": "realized_pnl_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_adjusted",
          "name": "realized_pnl_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_cad",
          "name": "realized_pnl_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7871d5487af3845ea0e843c8f99dd3be",
          "name": "realized_pnl_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1121e32c409c24d33d0e71c16f77d2d9",
          "name": "realized_pnl_mtd_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_mtd",
          "name": "realized_pnl_mtd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_mtd_cad",
          "name": "realized_pnl_mtd_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ece2f01fddf68eba08cc82f38ef9ccc8",
          "name": "realized_pnl_ytd_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_ytd",
          "name": "realized_pnl_ytd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_ytd_cad",
          "name": "realized_pnl_ytd_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d7e6fa92c29f51230aeabf388b6f5c06",
          "name": "amortized_cost_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "amortized_cost_amount",
          "name": "amortized_cost_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "a406e5c5f43d5bcdfcfb041eb3de6e79",
          "name": "amortized_cost_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "783bc1a102f2a2fe69887a02f0860701",
          "name": "amortized_premium_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "amortized_premium_amount",
          "name": "amortized_premium_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bad77fba1c06088f6aef476a2a8d757e",
          "name": "amortized_premium_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "68aa1b3dee212458547e7cba56d448e1",
          "name": "amortized_premium_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9abfa9efd1958f57b0a4c7adb95d0a0e",
          "name": "amortized_premium_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "34fd508b9323b6b2a84d06e441c14bb9",
          "name": "amortized_premium_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8b76b70b955be75e6b9b152707080b19",
          "name": "unamortized_premium_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fbd579b29622d35a0fb04ee12611cec0",
          "name": "unamortized_premium_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "76ca9d0b5ac50a274e816004a8c1d05c",
          "name": "unaccreted_discount_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "40c9bd41aca4b41eb31ebd7a29652d6e",
          "name": "unaccreted_discount_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bc52b9039b9263f176745dda51c80939",
          "name": "accreted_discount_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "accreted_discount_amount",
          "name": "accreted_discount_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "444a32987b6f2fe11cb09c3dea0881a6",
          "name": "accreted_discount_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d8c831b452da718c8b476ae51940eb22",
          "name": "accreted_discount_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "16465aad295f22d527a0a8f2548db2a0",
          "name": "accreted_discount_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "84d58d21f11a8a681af06726bcb675c6",
          "name": "accreted_discount_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bff9a39027e967ef067ffe050341cd9e",
          "name": "interest_income_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "interest_income_amount",
          "name": "interest_income_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "333e64d32bd22cd7dd16378a17e15586",
          "name": "interest_income_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "acec69cc30a376f81b3e29472eb2d20c",
          "name": "dividend_receivable_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c2da8d1c003dff0d8b03af62d4b93360",
          "name": "dividend_receivable_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1ccfcce00fc16dccb146390501b8f9e6",
          "name": "dividend_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "dividend_amount",
          "name": "dividend_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_key",
          "name": "ipv_key",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_currency",
          "name": "ipv_currency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_market_value",
          "name": "ipv_market_value",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_adjustment_amount",
          "name": "ipv_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_egl_sd_amount",
          "name": "ipv_egl_sd_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_egl_sd_amount_1",
          "name": "ipv_egl_sd_amount_1",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_egl_sd_amount_2",
          "name": "ipv_egl_sd_amount_2",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "57f3c903aafcceb8e659fc73a0026b68",
          "name": "ipv_fair_value_hierarchy_level",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d0264d3c59a78f2a4ddb1897dab06802",
          "name": "ipv_sensitivity_test_min_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "2699a3fd34551a710244dd77df9fb089",
          "name": "ipv_sensitivity_test_max_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_price",
          "name": "ipv_level3_price",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d6e4d8fdb6877f918877bf4765279aa7",
          "name": "ipv_level3_valuation_technique",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_product_type",
          "name": "ipv_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_credit_spread",
          "name": "ipv_level3_credit_spread",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_yield",
          "name": "ipv_level3_yield",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_discount_rate",
          "name": "ipv_level3_discount_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_pe_multiple",
          "name": "ipv_level3_pe_multiple",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "e807866835586aeb4f31c2cdd571cecd",
          "name": "ipv_level3_ev_rev_multiple",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "12f30e8002dd374ec4e664433cde0134",
          "name": "ipv_level3_prepayment_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c2c7ba11c4d8ff109433bc2b1c007299",
          "name": "ipv_level3_discount_margin",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1ae9a1dc8ceb84f361c0b681d40d7cf8",
          "name": "ipv_level3_loss_severity_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_default_rate",
          "name": "ipv_level3_default_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b77f1c89dc6294958c2bb967e1cd5596",
          "name": "ipv_level3_deferment_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "32b4bab06ea151b1508519af9773d12f",
          "name": "ipv_level3_redemption_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_recovery_rate",
          "name": "ipv_level3_recovery_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "691a79a0258e11a43f2c3c0ebc2068ff",
          "name": "ipv_level3_capitalization_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "456f6daabc7d93e1e7717ea019874de2",
          "name": "ipv_level3_credit_enhancement",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8f0862d592d89f5b463f3d1e1e96d617",
          "name": "ipv_level3_liquidity_discount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "0a3367c706c3dd889663a4af17ec35d3",
          "name": "ipv_level3_ev_ebitda_multiple",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_forbearance",
          "name": "ipv_level3_forbearance",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "local_fx_rate_region",
          "name": "local_fx_rate_region",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fx_rate_booked_to_ho_cad",
          "name": "fx_rate_booked_to_ho_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "is_deleted_flag",
          "name": "is_deleted_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "account_for_ecl_mapping",
          "name": "account_for_ecl_mapping",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_acl_account",
          "name": "st_1_acl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_acl_name",
          "name": "st_1_acl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_acl_account",
          "name": "st_2_acl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_acl_name",
          "name": "st_2_acl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_pcl_account",
          "name": "st_1_pcl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_pcl_name",
          "name": "st_1_pcl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_pcl_account",
          "name": "st_2_pcl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_pcl_name",
          "name": "st_2_pcl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "stage_3_flag",
          "name": "stage_3_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_sub_account",
          "name": "re_sub_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_sub_account_name",
          "name": "re_sub_account_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_le_account",
          "name": "re_le_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_le_account_name",
          "name": "re_le_account_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_key_hash",
          "name": "business_key_hash",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_date",
          "name": "business_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "au_batch_id",
          "name": "au_batch_id",
          "width": 100,
          "thousandSeparator": true
        }
      ]
    },
    {
      "name": "System_Summary",
      "sheetId": "f93f53a0-75cd-4fc9-80f3-485c945219f6",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "connector": "AND",
      "filterArguments": [
        {
          "column": "net_carrying_value_amount_cad",
          "filterExpression": "NOT_EQUALS",
          "value": "0.0",
          "type": "CONSTANT"
        }
      ],
      "formulas": [
        {
          "columnName": "Error_description",
          "columnId": "Error_description",
          "columnIndex": 0,
          "formulaString": "\u003dgroupby(#UnionSheet!Error_description)"
        },
        {
          "columnName": "source_system_id",
          "columnId": "source_system_id",
          "columnIndex": 1,
          "formulaString": "\u003dgroupby(#UnionSheet!source_system_id)"
        },
        {
          "columnName": "net_carrying_value_amount_cad",
          "columnId": "89516cf5111e1c34f14817044d11a8dc",
          "columnIndex": 2,
          "formulaString": "\u003dGROUPSUM(#UnionSheet!net_carrying_value_amount_cad)"
        },
        {
          "columnName": "SRDR_ID_Error_Type",
          "columnId": "ID_Error_Type",
          "columnIndex": 3,
          "formulaString": "\u003dgroupby(#UnionSheet!SRDR_ID_Error_Type)"
        },
        {
          "columnName": "BDR_ID_Error_Type",
          "columnId": "F",
          "columnIndex": 4,
          "formulaString": "\u003dgroupby(#UnionSheet!BDR_ID_Error_Type)"
        },
        {
          "columnName": "CDR_ID_Error_Type",
          "columnId": "CDR_ID_Error_Type",
          "columnIndex": 5,
          "formulaString": "\u003dgroupby(#UnionSheet!CDR_ID_Error_Type)"
        },
        {
          "columnName": "Count",
          "columnId": "Count",
          "columnIndex": 6,
          "formulaString": "\u003dGROUPCOUNT()"
        }
      ],
      "columnStyles": [
        {
          "columnId": "Error_description",
          "name": "Error_description",
          "width": 274,
          "thousandSeparator": true
        },
        {
          "columnId": "source_system_id",
          "name": "source_system_id",
          "width": 138,
          "thousandSeparator": true
        },
        {
          "columnId": "89516cf5111e1c34f14817044d11a8dc",
          "name": "net_carrying_value_amount_cad",
          "width": 242,
          "thousandSeparator": true
        }
      ]
    },
    {
      "name": "Transit_Summary",
      "sheetId": "960b4c55-8442-4e72-9eac-0a5f91da92bd",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "connector": "AND",
      "filterArguments": [
        {
          "column": "net_carrying_value_amount_cad",
          "filterExpression": "NOT_EQUALS",
          "value": "0.0",
          "type": "CONSTANT"
        }
      ],
      "formulas": [
        {
          "columnName": "Error_description",
          "columnId": "Error_description",
          "columnIndex": 0,
          "formulaString": "\u003dgroupby(#UnionSheet!Error_description)"
        },
        {
          "columnName": "source_system_id",
          "columnId": "source_system_id",
          "columnIndex": 1,
          "formulaString": "\u003dgroupby(#UnionSheet!source_system_id)"
        },
        {
          "columnName": "transit_number",
          "columnId": "transit_number",
          "columnIndex": 2,
          "formulaString": "\u003dgroupby(#UnionSheet!transit_number)"
        },
        {
          "columnName": "net_carrying_value_amount_cad",
          "columnId": "89516cf5111e1c34f14817044d11a8dc",
          "columnIndex": 3,
          "formulaString": "\u003dGROUPSUM(#UnionSheet!net_carrying_value_amount_cad)"
        },
        {
          "columnName": "SRDR_ID_Error_Type",
          "columnId": "ID_Error_Type",
          "columnIndex": 4,
          "formulaString": "\u003dgroupby(#UnionSheet!SRDR_ID_Error_Type)"
        },
        {
          "columnName": "BDR_ID_Error_Type",
          "columnId": "F",
          "columnIndex": 5,
          "formulaString": "\u003dgroupby(#UnionSheet!BDR_ID_Error_Type)"
        },
        {
          "columnName": "CDR_ID_Error_Type",
          "columnId": "CDR_ID_Error_Type",
          "columnIndex": 6,
          "formulaString": "\u003dgroupby(#UnionSheet!CDR_ID_Error_Type)"
        },
        {
          "columnName": "Count",
          "columnId": "Count",
          "columnIndex": 7,
          "formulaString": "\u003dGROUPCOUNT()"
        }
      ],
      "columnStyles": [
        {
          "columnId": "Error_description",
          "name": "Error_description",
          "width": 274,
          "thousandSeparator": true
        },
        {
          "columnId": "source_system_id",
          "name": "source_system_id",
          "width": 138,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_number",
          "name": "transit_number",
          "width": 122,
          "thousandSeparator": true
        },
        {
          "columnId": "89516cf5111e1c34f14817044d11a8dc",
          "name": "net_carrying_value_amount_cad",
          "width": 242,
          "thousandSeparator": true
        }
      ]
    },
    {
      "name": "Missing_Reference",
      "sheetId": "b68ce07d-c7ec-4e79-9d1f-da8d19561faf",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "UnionSheet",
      "sheetId": "e7bbd1fe-59e5-4e53-a817-6363b30b0858",
      "sheetType": "das.internal.UnionSheetType",
      "keep": true,
      "sheetDefinition": {
        "unionSources": [
          "Transit",
          "Domicile",
          "Risk",
          "CP",
          "CT",
          "MT",
          "SIC",
          "Level",
          "EPT",
          "Inst_cur",
          "SRDRID",
          "BDR_ID",
          "Long_short",
          "EGL",
          "Acct_Class",
          "ECPT",
          "Source_System",
          "B2PT1",
          "B2PT2",
          "B2Sector",
          "GDAL",
          "rollup_6020",
          "Segment",
          "MoodyIssue",
          "SPIssue",
          "FitchIssue",
          "BusinessRisk",
          "SPIssuer",
          "FitchIssuer",
          "MoodyIssuer",
          "CombinedIssueRating",
          "CombinedIssuerRating"
        ]
      },
      "columnStyles": []
    },
    {
      "name": "Ref_MoM",
      "sheetId": "eccf6fab-98b4-4ca5-9c77-fafb2100966f",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": [
        {
          "columnId": "ref_data_changed",
          "name": "ref_data_changed",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_system_id",
          "name": "source_system_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_number",
          "name": "transit_number",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "market_sector",
          "name": "market_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_short_long_code",
          "name": "position_short_long_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_batch_id",
          "name": "source_batch_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_key",
          "name": "business_key",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "648dd4dc0a2f478d5d2e9e970036ac0a",
          "name": "net_carrying_value_amount",
          "width": 100,
          "thousandSeparator": true
        }
      ]
    },
    {
      "name": "Transit",
      "sheetId": "4edbd488-960e-488e-98fe-0be71af29a53",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "Domicile",
      "sheetId": "5b35d6e8-173b-4cb3-bf57-470f531d2a4c",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "Risk",
      "sheetId": "1980118e-4574-4c59-ad59-9533ebfb18ae",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "CP",
      "sheetId": "fe0a18f3-e4b2-446d-bfe9-5083bed1aa9d",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "CT",
      "sheetId": "584ad0ed-5a26-4248-a33b-304ef13c42e9",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "MT",
      "sheetId": "3893720e-72ad-449e-95e7-42b319bdee7c",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "SIC",
      "sheetId": "36e607f3-e63f-4e63-9888-00fe2aa10f68",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "Level",
      "sheetId": "dedd7474-3080-4b24-aa95-17f3ae65428b",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "EPT",
      "sheetId": "1fde504a-b706-4647-9ef1-07bb54fd8444",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "Inst_cur",
      "sheetId": "2618ccee-bf4b-46ba-9e66-033c93110166",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "SRDRID",
      "sheetId": "3ef95be9-07b3-40e4-9a1f-b28033d57f9b",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "BDR_ID",
      "sheetId": "58e88ebc-7be1-4012-94af-3ebed12fb7b0",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "Long_short",
      "sheetId": "d1dee194-60bb-4cc1-a96c-1960462e843b",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "EGL",
      "sheetId": "5024c8f4-a7d9-491b-aed6-260f9b291a60",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "Acct_Class",
      "sheetId": "e02706e0-9c3f-4e46-b9b0-820101252f35",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "ECPT",
      "sheetId": "91c5c0b6-2f83-4cbd-b629-3865c84a7419",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "Source_System",
      "sheetId": "3b9e64c9-105c-409b-9425-90def44f4d6c",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "B2PT1",
      "sheetId": "1e235c32-43e3-4dca-a9d2-501000fab4cc",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "B2PT2",
      "sheetId": "044f2fb9-1786-41eb-b075-26f79ebc63cb",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "B2Sector",
      "sheetId": "f673efcb-fd6c-4a6b-8fce-82c59cab8ecd",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "GDAL",
      "sheetId": "f9478fd1-8260-40e0-9ce4-5dff90573bb6",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "rollup_6020",
      "sheetId": "e33749ff-d443-49ae-a82f-6674894846c0",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "Segment",
      "sheetId": "cee37d5d-caf8-4b28-bad1-de03c85575df",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "MoodyIssue",
      "sheetId": "bb7c6897-2a19-4c5f-a1ad-1c647e6280d3",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "SPIssue",
      "sheetId": "84b789e4-6d00-4c8f-a4d8-d6cda206788f",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "FitchIssue",
      "sheetId": "48737b0b-f2e2-4897-af5c-0903ede5b339",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "BusinessRisk",
      "sheetId": "35924f90-387a-458e-92f1-c3cf19275daa",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "SPIssuer",
      "sheetId": "8eb2f692-7497-4145-b891-207c5cbec883",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "FitchIssuer",
      "sheetId": "7d92affa-34cc-4147-8710-1c236349cea5",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "MoodyIssuer",
      "sheetId": "d6111209-4127-459d-833f-8821785cd33c",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "CombinedIssueRating",
      "sheetId": "13e2055c-f0d9-4ab5-b3e2-948187fe74a7",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    },
    {
      "name": "CombinedIssuerRating",
      "sheetId": "3a36c76c-4546-4475-be14-6d9b92fd66c5",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": []
    }
  ],
  "advancedSchedulingInUse": true,
  "errorHandlingMode": "IGNO

thomas lee

April 03, 2020 14:43

The workbook above reference a sheet from another workbook:

{
  "version": "7.4.6",
  "className": "datameer.dap.common.entity.WorkbookConfigurationImpl",
  "file": {
    "uuid": "a23e6e58-1644-4e7a-802f-d0b8d2df96ce",
    "path": "/Teams/FinanceCore/Finance/ESP/Reports/Latest ESP View/Latest 022920 ESP View Workbook.wbk",
    "description": "",
    "name": "Latest 022920 ESP View Workbook"
  },
  "pullType": "SCHEDULED",
  "schedule": "0 6 * * 0-6",
  "minKeepCount": 1,
  "properties": {},
  "hadoopProperties": "",
  "notificationAddresses": "",
  "notificationSuccessAddresses": "",
  "sheets": [
    {
      "name": "ESP_DataLink",
      "sheetId": "cd1d6e28-971d-41aa-ad63-3060127b35de",
      "sheetType": "das.internal.DataSourceSheetType",
      "keep": false,
      "datasource": {
        "path": "/Teams/FinanceCore/Finance/ESP/Datalinks/ESP DataLink.lnk",
        "uuid": "59bf639b-dcd9-4beb-ba35-835a04c8e599"
      },
      "columnStyles": [
        {
          "columnId": "source_batch_id",
          "name": "source_batch_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "as_at_date",
          "name": "as_at_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_key",
          "name": "business_key",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecl_old_record_id",
          "name": "ecl_old_record_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "region",
          "name": "region",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_system_id",
          "name": "source_system_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eod_position_id",
          "name": "eod_position_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "record_origin",
          "name": "record_origin",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eodc_asset_class_type",
          "name": "eodc_asset_class_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eodc_product_type",
          "name": "eodc_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eodc_product_sub_type",
          "name": "eodc_product_sub_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "aa7f9b761bac6dedd2077dd090ffbf6c",
          "name": "source_product_classification",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d543f8a9e396ada8ea06b8128d6bb4d6",
          "name": "lrm_product_classification_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "market_sector",
          "name": "market_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_type_indicator",
          "name": "security_type_indicator",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecpt_code",
          "name": "ecpt_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecpt_name",
          "name": "ecpt_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecpt_parent_code",
          "name": "ecpt_parent_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "external_product_type",
          "name": "external_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_classification",
          "name": "country_classification",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_sector",
          "name": "b2_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_bs_60200_rollup",
          "name": "b2_bs_60200_rollup",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_product_type_1",
          "name": "b2_product_type_1",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_product_type_2",
          "name": "b2_product_type_2",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "gdal_sector",
          "name": "gdal_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "agency",
          "name": "agency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_type",
          "name": "position_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_level_name",
          "name": "position_level_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "instrument_currency",
          "name": "instrument_currency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "reporting_currency",
          "name": "reporting_currency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "instrument_srdr_id",
          "name": "instrument_srdr_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "isin_id",
          "name": "isin_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bloomberg_unique_id",
          "name": "bloomberg_unique_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cusip_id",
          "name": "cusip_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sedol_id",
          "name": "sedol_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_instrument_id",
          "name": "source_instrument_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_trade_group_id",
          "name": "source_trade_group_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_trade_id",
          "name": "source_trade_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "4733727496358f00c356a56a8bb44b3c",
          "name": "source_contract_version_number",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "involved_party_id",
          "name": "involved_party_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9d9ba992405dd18bc0be7b001e7722cc",
          "name": "involved_party_id_source_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d9f3cd8b0f9a7479045c140d0d041129",
          "name": "source_counterparty_short_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_short_long_code",
          "name": "position_short_long_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "pay_receive_code",
          "name": "pay_receive_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_quantity",
          "name": "position_quantity",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_decorator_id",
          "name": "position_decorator_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_decorator_type",
          "name": "position_decorator_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issue_date",
          "name": "issue_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "maturity_date",
          "name": "maturity_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fcecf63c351f588a2ab251bb1cb425a9",
          "name": "original_term_to_maturity_days",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "28111b933bd48408a09002e419f21f69",
          "name": "residual_term_to_maturity_days",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_settlement_date",
          "name": "position_settlement_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cc00e3f46e0426d27f6c548222ee2f0e",
          "name": "issue_rating_moody_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "4ff8da698d29a6eabc31fc48741b67b8",
          "name": "issue_rating_sp_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f13d373b39cd2fcb7c198b95992c51f6",
          "name": "issue_rating_fitch_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "a16bebf5c160b5096576ae743ed49f63",
          "name": "issue_rating_dbrs_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_cdr_id",
          "name": "issuer_cdr_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_bbg_id",
          "name": "issuer_bbg_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_srf",
          "name": "issuer_srf",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_name",
          "name": "issuer_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "e32efe965d0939ea5a9f01a44c5ac1c9",
          "name": "issuer_ultimate_parent_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_industry",
          "name": "issuer_industry",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c27c46c7c43729733dbf1f89ffbcd618",
          "name": "issuer_dom_country_short_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_province",
          "name": "issuer_province",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_rbcsic",
          "name": "issuer_rbcsic",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f94dd9356af18de78e4d06161f4db018",
          "name": "issuer_business_risk_rating",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_rating_sp_lt_fc",
          "name": "issuer_rating_sp_lt_fc",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_rating_sp_lt_li",
          "name": "issuer_rating_sp_lt_li",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "729d51542b944e081037ecb4876043bd",
          "name": "issuer_rating_fitch_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "39ba424f65a0d00efd7f24732ba0c9e3",
          "name": "issuer_rating_moody_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8f8317e02b7a4d0135c5696e9312754e",
          "name": "issuer_rating_dbrs_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_cdr_id",
          "name": "guarantor_cdr_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_bbg_id",
          "name": "guarantor_bbg_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_srf",
          "name": "guarantor_srf",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_name",
          "name": "guarantor_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c48b9a06ea964c06f156acf4ae9290cf",
          "name": "guarantor_ultimate_parent_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_rbcsic",
          "name": "guarantor_rbcsic",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8c4941ca145a9db2a5459ec62992f781",
          "name": "guarantor_business_risk_rating",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "coupon_rate",
          "name": "coupon_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "coupon_type",
          "name": "coupon_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "last_coupon_reset_date",
          "name": "last_coupon_reset_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "next_coupon_reset_date",
          "name": "next_coupon_reset_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "coupon_reset_frequency",
          "name": "coupon_reset_frequency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "reset_index",
          "name": "reset_index",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "rbc_issued_flag",
          "name": "rbc_issued_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_product_type",
          "name": "security_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_product_type",
          "name": "bbg_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_product_subtype",
          "name": "bbg_product_subtype",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_description",
          "name": "security_description",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_sector",
          "name": "bbg_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_industry_group",
          "name": "bbg_industry_group",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_industry_sub_group",
          "name": "bbg_industry_sub_group",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sector_immediate_risk",
          "name": "sector_immediate_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sector_ultimate_risk",
          "name": "sector_ultimate_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "collateral_type",
          "name": "collateral_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ticker",
          "name": "ticker",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "mortg_deal_type",
          "name": "mortg_deal_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "mortg_issuer_fullname",
          "name": "mortg_issuer_fullname",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "compliance_code",
          "name": "compliance_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "tranche_type_description",
          "name": "tranche_type_description",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "is_subordinated",
          "name": "is_subordinated",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_of_domicile",
          "name": "country_of_domicile",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_of_risk",
          "name": "country_of_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_ultimate_risk",
          "name": "country_ultimate_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_of_guarantor",
          "name": "country_of_guarantor",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bdr_book_id",
          "name": "bdr_book_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_book_id",
          "name": "source_book_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_book_name",
          "name": "source_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_sub_book_name",
          "name": "source_sub_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "slim_app_book_cd",
          "name": "slim_app_book_cd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "slim_app_book_name",
          "name": "slim_app_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_number",
          "name": "transit_number",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_desc",
          "name": "transit_desc",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "3690b5a2ec60a81854286caea077d726",
          "name": "source_booking_transit_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_short_name",
          "name": "transit_short_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "master_book_name",
          "name": "master_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "master_book_desc",
          "name": "master_book_desc",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sub_branch_code",
          "name": "sub_branch_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_unit_name",
          "name": "business_unit_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "legal_entity_name",
          "name": "legal_entity_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "desk_name",
          "name": "desk_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7c5f0abcb20e5c53eb01fa0fa1efad19",
          "name": "functional_reporting_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "segment",
          "name": "segment",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "processing_center",
          "name": "processing_center",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "control_unit",
          "name": "control_unit",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "18587f33d97f1c2376a912fac6ddaa52",
          "name": "processing_center_country_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9be35045804f4280d7b57d042734c842",
          "name": "legal_entity_country_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "disposition_type",
          "name": "disposition_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "disposition_amount",
          "name": "disposition_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "disposition_amount_cad",
          "name": "disposition_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "purchase_date",
          "name": "purchase_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "units_purchased",
          "name": "units_purchased",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "purchase_amount",
          "name": "purchase_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "purchase_amount_cad",
          "name": "purchase_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "52c2308e807c3b3d359483972bb2fac6",
          "name": "expected_credit_loss_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9c11f32422038d6a9f141e170cefb16a",
          "name": "expected_credit_loss_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "60b82bb30e44cea462fad9f3a80f16dc",
          "name": "expected_credit_loss_stage",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "expected_aoci",
          "name": "expected_aoci",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5aa52cd8a8d22609ba595cf859f1e575",
          "name": "provision_credit_loss_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "08b1384aa13962ef5ff0b1ca3d090cf1",
          "name": "provision_credit_loss_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "proxy_flag",
          "name": "proxy_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "74516af4b183b213cde293d23619776b",
          "name": "fair_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fair_value_amount",
          "name": "fair_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c04dba5f52b456962cdeba96e80bbdc1",
          "name": "fair_value_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5eb76be99416aae745e28b7e4e8a2c7e",
          "name": "fair_value_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fair_value_amount_cad",
          "name": "fair_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7124be6b6ed16cbc9dc0ff827b9a22e5",
          "name": "fair_value_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c88fa08e0df52956399b49afca38e9a7",
          "name": "book_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "book_value_amount",
          "name": "book_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "0ca35f56fdc968d1b75b98d92987dfec",
          "name": "book_value_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "644373c17345eeeabecdbfd2b9bc6a83",
          "name": "book_value_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "book_value_amount_cad",
          "name": "book_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "efd21ee9989ec32fc0280e12aa1c50bb",
          "name": "book_value_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f94e29e71f663e8f7d8e902b103372de",
          "name": "net_carrying_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "648dd4dc0a2f478d5d2e9e970036ac0a",
          "name": "net_carrying_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "89516cf5111e1c34f14817044d11a8dc",
          "name": "net_carrying_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "6a0b722276cc70ca336912a9ce70dbfe",
          "name": "gross_carrying_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "964fc1e5ca360efa935891a9724f1de5",
          "name": "gross_carrying_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "6ce365e75eb84b2159f780e5c2e9c1d7",
          "name": "gross_carrying_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bs_egl_account",
          "name": "bs_egl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bs_egl_account_name",
          "name": "bs_egl_account_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "634cd26692e26b61d4743ed843ec3987",
          "name": "accounting_classification",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7c4e7267fc91d6a3cb90b20e7cae3694",
          "name": "mark_to_market_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "mark_to_market_amount",
          "name": "mark_to_market_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1dbdcc669ef3eccf97440ef39893d5ff",
          "name": "mark_to_market_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "618bf2913fb3756454129762628145b3",
          "name": "clean_mark_to_market_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "297c9bf5e4f034c86ff308d142723623",
          "name": "clean_mark_to_market_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cf2a8cf23eb8c0ad178b8b99b5033f7b",
          "name": "clean_mark_to_market_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "900383ed5ed54544a5af32b8dac9a8ef",
          "name": "dirty_mark_to_market_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5005370c3e0e7f2476e7e1a6711e22c2",
          "name": "dirty_mark_to_market_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "971ac8e914336412ccd2445ed9be2a2c",
          "name": "dirty_mark_to_market_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8abbcd1abc06c788d84495142763f83d",
          "name": "notional_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "notional_amount",
          "name": "notional_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "notional_amount_cad",
          "name": "notional_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f43f019ab7c64061470f5bfcae089d36",
          "name": "accrued_interest_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "accrued_interest_amount",
          "name": "accrued_interest_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f9788eb99c2540eaa761392ada92a8a8",
          "name": "accrued_interest_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "33a23e5d44f59b8d835af829df4e0d51",
          "name": "accrued_interest_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eeb7902f4beb762fe83f2a04825c2b6d",
          "name": "accrued_interest_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ec584d6dfc9a250dda7c3a4b197b7c70",
          "name": "accrued_interest_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "a02bf80ec8714f6b603bfab2a809fb3c",
          "name": "accrued_interest_amount_dly_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1975b13c377123672d989bbd9b218ab3",
          "name": "accrued_interest_amount_dly",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bb9a2c46440a7263c2838d1cd3a86791",
          "name": "accrued_interest_amount_dly_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "2a74c48a3bd581e877c347a0589000c8",
          "name": "accrued_interest_amount_mtd_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8c990759fe92c6e0518fb39c78edd37c",
          "name": "accrued_interest_amount_mtd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "405a4161214c60a499ad342f936801ba",
          "name": "accrued_interest_amount_mtd_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ee1e9225b09d54914dacd1d3005c83e2",
          "name": "cost_basis_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cost_basis_amount",
          "name": "cost_basis_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cost_basis_amount_cad",
          "name": "cost_basis_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b36ac5df56abd47280d900e2289d5611",
          "name": "current_ltd_hedge_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "oci_adjustment_amount",
          "name": "oci_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "14b90d80ab80c9e524917986f69dcb02",
          "name": "purchase_price_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "75e2ce61a5350dbe5addb1f0d91543d6",
          "name": "tax_credit_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "80e7520582b31d10881219cfcdf49c8d",
          "name": "unrealized_pnl_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "unrealized_pnl",
          "name": "unrealized_pnl",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "unrealized_pnl_cad",
          "name": "unrealized_pnl_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b266670d919cd88ba6a9604a477c6301",
          "name": "realized_pnl_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl",
          "name": "realized_pnl",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5ace8bb0e6c488e602c524f68ef519e0",
          "name": "realized_pnl_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_adjusted",
          "name": "realized_pnl_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_cad",
          "name": "realized_pnl_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7871d5487af3845ea0e843c8f99dd3be",
          "name": "realized_pnl_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1121e32c409c24d33d0e71c16f77d2d9",
          "name": "realized_pnl_mtd_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_mtd",
          "name": "realized_pnl_mtd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_mtd_cad",
          "name": "realized_pnl_mtd_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ece2f01fddf68eba08cc82f38ef9ccc8",
          "name": "realized_pnl_ytd_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_ytd",
          "name": "realized_pnl_ytd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_ytd_cad",
          "name": "realized_pnl_ytd_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d7e6fa92c29f51230aeabf388b6f5c06",
          "name": "amortized_cost_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "amortized_cost_amount",
          "name": "amortized_cost_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "a406e5c5f43d5bcdfcfb041eb3de6e79",
          "name": "amortized_cost_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "783bc1a102f2a2fe69887a02f0860701",
          "name": "amortized_premium_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "amortized_premium_amount",
          "name": "amortized_premium_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bad77fba1c06088f6aef476a2a8d757e",
          "name": "amortized_premium_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "68aa1b3dee212458547e7cba56d448e1",
          "name": "amortized_premium_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9abfa9efd1958f57b0a4c7adb95d0a0e",
          "name": "amortized_premium_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "34fd508b9323b6b2a84d06e441c14bb9",
          "name": "amortized_premium_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8b76b70b955be75e6b9b152707080b19",
          "name": "unamortized_premium_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fbd579b29622d35a0fb04ee12611cec0",
          "name": "unamortized_premium_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "76ca9d0b5ac50a274e816004a8c1d05c",
          "name": "unaccreted_discount_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "40c9bd41aca4b41eb31ebd7a29652d6e",
          "name": "unaccreted_discount_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bc52b9039b9263f176745dda51c80939",
          "name": "accreted_discount_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "accreted_discount_amount",
          "name": "accreted_discount_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "444a32987b6f2fe11cb09c3dea0881a6",
          "name": "accreted_discount_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d8c831b452da718c8b476ae51940eb22",
          "name": "accreted_discount_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "16465aad295f22d527a0a8f2548db2a0",
          "name": "accreted_discount_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "84d58d21f11a8a681af06726bcb675c6",
          "name": "accreted_discount_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bff9a39027e967ef067ffe050341cd9e",
          "name": "interest_income_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "interest_income_amount",
          "name": "interest_income_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "333e64d32bd22cd7dd16378a17e15586",
          "name": "interest_income_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "acec69cc30a376f81b3e29472eb2d20c",
          "name": "dividend_receivable_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c2da8d1c003dff0d8b03af62d4b93360",
          "name": "dividend_receivable_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1ccfcce00fc16dccb146390501b8f9e6",
          "name": "dividend_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "dividend_amount",
          "name": "dividend_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_key",
          "name": "ipv_key",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_currency",
          "name": "ipv_currency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_market_value",
          "name": "ipv_market_value",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_adjustment_amount",
          "name": "ipv_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_egl_sd_amount",
          "name": "ipv_egl_sd_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_egl_sd_amount_1",
          "name": "ipv_egl_sd_amount_1",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_egl_sd_amount_2",
          "name": "ipv_egl_sd_amount_2",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "57f3c903aafcceb8e659fc73a0026b68",
          "name": "ipv_fair_value_hierarchy_level",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d0264d3c59a78f2a4ddb1897dab06802",
          "name": "ipv_sensitivity_test_min_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "2699a3fd34551a710244dd77df9fb089",
          "name": "ipv_sensitivity_test_max_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_price",
          "name": "ipv_level3_price",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d6e4d8fdb6877f918877bf4765279aa7",
          "name": "ipv_level3_valuation_technique",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_product_type",
          "name": "ipv_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_credit_spread",
          "name": "ipv_level3_credit_spread",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_yield",
          "name": "ipv_level3_yield",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_discount_rate",
          "name": "ipv_level3_discount_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_pe_multiple",
          "name": "ipv_level3_pe_multiple",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "e807866835586aeb4f31c2cdd571cecd",
          "name": "ipv_level3_ev_rev_multiple",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "12f30e8002dd374ec4e664433cde0134",
          "name": "ipv_level3_prepayment_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c2c7ba11c4d8ff109433bc2b1c007299",
          "name": "ipv_level3_discount_margin",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1ae9a1dc8ceb84f361c0b681d40d7cf8",
          "name": "ipv_level3_loss_severity_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_default_rate",
          "name": "ipv_level3_default_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b77f1c89dc6294958c2bb967e1cd5596",
          "name": "ipv_level3_deferment_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "32b4bab06ea151b1508519af9773d12f",
          "name": "ipv_level3_redemption_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_recovery_rate",
          "name": "ipv_level3_recovery_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "691a79a0258e11a43f2c3c0ebc2068ff",
          "name": "ipv_level3_capitalization_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "456f6daabc7d93e1e7717ea019874de2",
          "name": "ipv_level3_credit_enhancement",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8f0862d592d89f5b463f3d1e1e96d617",
          "name": "ipv_level3_liquidity_discount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "0a3367c706c3dd889663a4af17ec35d3",
          "name": "ipv_level3_ev_ebitda_multiple",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_forbearance",
          "name": "ipv_level3_forbearance",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "local_fx_rate_region",
          "name": "local_fx_rate_region",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fx_rate_booked_to_ho_cad",
          "name": "fx_rate_booked_to_ho_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "is_deleted_flag",
          "name": "is_deleted_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "account_for_ecl_mapping",
          "name": "account_for_ecl_mapping",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_acl_account",
          "name": "st_1_acl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_acl_name",
          "name": "st_1_acl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_acl_account",
          "name": "st_2_acl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_acl_name",
          "name": "st_2_acl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_pcl_account",
          "name": "st_1_pcl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_pcl_name",
          "name": "st_1_pcl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_pcl_account",
          "name": "st_2_pcl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_pcl_name",
          "name": "st_2_pcl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "stage_3_flag",
          "name": "stage_3_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_sub_account",
          "name": "re_sub_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_sub_account_name",
          "name": "re_sub_account_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_le_account",
          "name": "re_le_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_le_account_name",
          "name": "re_le_account_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_key_hash",
          "name": "business_key_hash",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "unrealized_pnl_adjusted",
          "name": "unrealized_pnl_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_id",
          "name": "security_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "413fd227ce4150199e78de958e599883",
          "name": "fair_value_enterprise_netted_adjustment_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "aee9d8f206cbacbd0ada9a2a3c0c3274",
          "name": "fair_value_amount_enterprise_netted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "41c54825464399f91cd362cf707f8110",
          "name": "fair_value_enterprise_netted_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "e21c8cb3bb7a9a4c662d293841b11016",
          "name": "fair_value_amount_enterprise_netted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "enterprise_netting_flag",
          "name": "enterprise_netting_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "97ec31844656e7d8481dc8995d818764",
          "name": "fair_value_legal_entity_netted_adjustment_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "28a0e18c71698e21d0cef8871301bcb3",
          "name": "fair_value_amount_legal_entity_netted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bab39ca998144821d6bc9c0f97efceb8",
          "name": "fair_value_legal_entity_netted_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cbd202e585d30371531e2364a14e5283",
          "name": "fair_value_amount_legal_entity_netted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1204065eb017d9dbca7cafbf3feca2d0",
          "name": "book_value_enterprise_netted_adjustment_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ab4a83d37bbf774aed94a8e56d92a18e",
          "name": "book_value_amount_enterprise_netted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "11613ca0d7c3cca30975fb770dc56518",
          "name": "book_value_enterprise_netted_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "faa09863dcbb9ae66f9cddd0adc162a6",
          "name": "book_value_amount_enterprise_netted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8d9ed6d7b216761f0cf5b24cea3ac2ac",
          "name": "book_value_legal_entity_netted_adjustment_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "3fd958cf47b8d1810cdf376d6af1c52d",
          "name": "book_value_amount_legal_entity_netted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "939f5dc500fdf85b266779f8cc184afa",
          "name": "book_value_legal_entity_netted_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "02b95d2e10950a467797d142fedf6239",
          "name": "book_value_amount_legal_entity_netted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "hierarchy_id_enterprise",
          "name": "hierarchy_id_enterprise",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "hierarchy_id_legal",
          "name": "hierarchy_id_legal",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "level3_rollup",
          "name": "level3_rollup",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "level9_rollup",
          "name": "level9_rollup",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_date",
          "name": "business_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "au_batch_id",
          "name": "au_batch_id",
          "width": 100,
          "thousandSeparator": true
        }
      ]
    },
    {
      "name": "Latest_022820",
      "sheetId": "8ae2f066-38e7-4287-a27f-1111998bdddd",
      "sheetType": "das.internal.SqlSheetType",
      "keep": true,
      "columnStyles": [
        {
          "columnId": "source_batch_id",
          "name": "source_batch_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "as_at_date",
          "name": "as_at_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_key",
          "name": "business_key",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecl_old_record_id",
          "name": "ecl_old_record_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "region",
          "name": "region",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_system_id",
          "name": "source_system_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eod_position_id",
          "name": "eod_position_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "record_origin",
          "name": "record_origin",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eodc_asset_class_type",
          "name": "eodc_asset_class_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eodc_product_type",
          "name": "eodc_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eodc_product_sub_type",
          "name": "eodc_product_sub_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "aa7f9b761bac6dedd2077dd090ffbf6c",
          "name": "source_product_classification",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d543f8a9e396ada8ea06b8128d6bb4d6",
          "name": "lrm_product_classification_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "market_sector",
          "name": "market_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_type_indicator",
          "name": "security_type_indicator",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecpt_code",
          "name": "ecpt_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecpt_name",
          "name": "ecpt_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ecpt_parent_code",
          "name": "ecpt_parent_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "external_product_type",
          "name": "external_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_classification",
          "name": "country_classification",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_sector",
          "name": "b2_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_bs_60200_rollup",
          "name": "b2_bs_60200_rollup",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_product_type_1",
          "name": "b2_product_type_1",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b2_product_type_2",
          "name": "b2_product_type_2",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "gdal_sector",
          "name": "gdal_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "agency",
          "name": "agency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_type",
          "name": "position_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_level_name",
          "name": "position_level_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "instrument_currency",
          "name": "instrument_currency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "reporting_currency",
          "name": "reporting_currency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "instrument_srdr_id",
          "name": "instrument_srdr_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "isin_id",
          "name": "isin_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bloomberg_unique_id",
          "name": "bloomberg_unique_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cusip_id",
          "name": "cusip_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sedol_id",
          "name": "sedol_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_instrument_id",
          "name": "source_instrument_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_trade_group_id",
          "name": "source_trade_group_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_trade_id",
          "name": "source_trade_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "4733727496358f00c356a56a8bb44b3c",
          "name": "source_contract_version_number",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "involved_party_id",
          "name": "involved_party_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9d9ba992405dd18bc0be7b001e7722cc",
          "name": "involved_party_id_source_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d9f3cd8b0f9a7479045c140d0d041129",
          "name": "source_counterparty_short_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_short_long_code",
          "name": "position_short_long_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "pay_receive_code",
          "name": "pay_receive_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_quantity",
          "name": "position_quantity",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_decorator_id",
          "name": "position_decorator_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_decorator_type",
          "name": "position_decorator_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issue_date",
          "name": "issue_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "maturity_date",
          "name": "maturity_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fcecf63c351f588a2ab251bb1cb425a9",
          "name": "original_term_to_maturity_days",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "28111b933bd48408a09002e419f21f69",
          "name": "residual_term_to_maturity_days",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "position_settlement_date",
          "name": "position_settlement_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cc00e3f46e0426d27f6c548222ee2f0e",
          "name": "issue_rating_moody_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "4ff8da698d29a6eabc31fc48741b67b8",
          "name": "issue_rating_sp_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f13d373b39cd2fcb7c198b95992c51f6",
          "name": "issue_rating_fitch_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "a16bebf5c160b5096576ae743ed49f63",
          "name": "issue_rating_dbrs_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_cdr_id",
          "name": "issuer_cdr_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_bbg_id",
          "name": "issuer_bbg_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_srf",
          "name": "issuer_srf",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_name",
          "name": "issuer_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "e32efe965d0939ea5a9f01a44c5ac1c9",
          "name": "issuer_ultimate_parent_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_industry",
          "name": "issuer_industry",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c27c46c7c43729733dbf1f89ffbcd618",
          "name": "issuer_dom_country_short_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_province",
          "name": "issuer_province",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_rbcsic",
          "name": "issuer_rbcsic",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f94dd9356af18de78e4d06161f4db018",
          "name": "issuer_business_risk_rating",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_rating_sp_lt_fc",
          "name": "issuer_rating_sp_lt_fc",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "issuer_rating_sp_lt_li",
          "name": "issuer_rating_sp_lt_li",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "729d51542b944e081037ecb4876043bd",
          "name": "issuer_rating_fitch_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "39ba424f65a0d00efd7f24732ba0c9e3",
          "name": "issuer_rating_moody_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8f8317e02b7a4d0135c5696e9312754e",
          "name": "issuer_rating_dbrs_long_term",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_cdr_id",
          "name": "guarantor_cdr_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_bbg_id",
          "name": "guarantor_bbg_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_srf",
          "name": "guarantor_srf",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_name",
          "name": "guarantor_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c48b9a06ea964c06f156acf4ae9290cf",
          "name": "guarantor_ultimate_parent_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "guarantor_rbcsic",
          "name": "guarantor_rbcsic",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8c4941ca145a9db2a5459ec62992f781",
          "name": "guarantor_business_risk_rating",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "coupon_rate",
          "name": "coupon_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "coupon_type",
          "name": "coupon_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "last_coupon_reset_date",
          "name": "last_coupon_reset_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "next_coupon_reset_date",
          "name": "next_coupon_reset_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "coupon_reset_frequency",
          "name": "coupon_reset_frequency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "reset_index",
          "name": "reset_index",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "rbc_issued_flag",
          "name": "rbc_issued_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_product_type",
          "name": "security_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_product_type",
          "name": "bbg_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_product_subtype",
          "name": "bbg_product_subtype",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_description",
          "name": "security_description",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_sector",
          "name": "bbg_sector",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_industry_group",
          "name": "bbg_industry_group",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bbg_industry_sub_group",
          "name": "bbg_industry_sub_group",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sector_immediate_risk",
          "name": "sector_immediate_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sector_ultimate_risk",
          "name": "sector_ultimate_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "collateral_type",
          "name": "collateral_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ticker",
          "name": "ticker",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "mortg_deal_type",
          "name": "mortg_deal_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "mortg_issuer_fullname",
          "name": "mortg_issuer_fullname",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "compliance_code",
          "name": "compliance_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "tranche_type_description",
          "name": "tranche_type_description",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "is_subordinated",
          "name": "is_subordinated",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_of_domicile",
          "name": "country_of_domicile",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_of_risk",
          "name": "country_of_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_ultimate_risk",
          "name": "country_ultimate_risk",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "country_of_guarantor",
          "name": "country_of_guarantor",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bdr_book_id",
          "name": "bdr_book_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_book_id",
          "name": "source_book_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_book_name",
          "name": "source_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "source_sub_book_name",
          "name": "source_sub_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "slim_app_book_cd",
          "name": "slim_app_book_cd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "slim_app_book_name",
          "name": "slim_app_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_number",
          "name": "transit_number",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_desc",
          "name": "transit_desc",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "3690b5a2ec60a81854286caea077d726",
          "name": "source_booking_transit_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "transit_short_name",
          "name": "transit_short_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "master_book_name",
          "name": "master_book_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "master_book_desc",
          "name": "master_book_desc",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "sub_branch_code",
          "name": "sub_branch_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_unit_name",
          "name": "business_unit_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "legal_entity_name",
          "name": "legal_entity_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "desk_name",
          "name": "desk_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7c5f0abcb20e5c53eb01fa0fa1efad19",
          "name": "functional_reporting_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "segment",
          "name": "segment",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "processing_center",
          "name": "processing_center",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "control_unit",
          "name": "control_unit",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "18587f33d97f1c2376a912fac6ddaa52",
          "name": "processing_center_country_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9be35045804f4280d7b57d042734c842",
          "name": "legal_entity_country_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "disposition_type",
          "name": "disposition_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "disposition_amount",
          "name": "disposition_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "disposition_amount_cad",
          "name": "disposition_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "purchase_date",
          "name": "purchase_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "units_purchased",
          "name": "units_purchased",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "purchase_amount",
          "name": "purchase_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "purchase_amount_cad",
          "name": "purchase_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "52c2308e807c3b3d359483972bb2fac6",
          "name": "expected_credit_loss_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9c11f32422038d6a9f141e170cefb16a",
          "name": "expected_credit_loss_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "60b82bb30e44cea462fad9f3a80f16dc",
          "name": "expected_credit_loss_stage",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "expected_aoci",
          "name": "expected_aoci",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5aa52cd8a8d22609ba595cf859f1e575",
          "name": "provision_credit_loss_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "08b1384aa13962ef5ff0b1ca3d090cf1",
          "name": "provision_credit_loss_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "proxy_flag",
          "name": "proxy_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "74516af4b183b213cde293d23619776b",
          "name": "fair_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fair_value_amount",
          "name": "fair_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c04dba5f52b456962cdeba96e80bbdc1",
          "name": "fair_value_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5eb76be99416aae745e28b7e4e8a2c7e",
          "name": "fair_value_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fair_value_amount_cad",
          "name": "fair_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7124be6b6ed16cbc9dc0ff827b9a22e5",
          "name": "fair_value_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c88fa08e0df52956399b49afca38e9a7",
          "name": "book_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "book_value_amount",
          "name": "book_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "0ca35f56fdc968d1b75b98d92987dfec",
          "name": "book_value_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "644373c17345eeeabecdbfd2b9bc6a83",
          "name": "book_value_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "book_value_amount_cad",
          "name": "book_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "efd21ee9989ec32fc0280e12aa1c50bb",
          "name": "book_value_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f94e29e71f663e8f7d8e902b103372de",
          "name": "net_carrying_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "648dd4dc0a2f478d5d2e9e970036ac0a",
          "name": "net_carrying_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "89516cf5111e1c34f14817044d11a8dc",
          "name": "net_carrying_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "6a0b722276cc70ca336912a9ce70dbfe",
          "name": "gross_carrying_value_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "964fc1e5ca360efa935891a9724f1de5",
          "name": "gross_carrying_value_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "6ce365e75eb84b2159f780e5c2e9c1d7",
          "name": "gross_carrying_value_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bs_egl_account",
          "name": "bs_egl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bs_egl_account_name",
          "name": "bs_egl_account_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "634cd26692e26b61d4743ed843ec3987",
          "name": "accounting_classification",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7c4e7267fc91d6a3cb90b20e7cae3694",
          "name": "mark_to_market_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "mark_to_market_amount",
          "name": "mark_to_market_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1dbdcc669ef3eccf97440ef39893d5ff",
          "name": "mark_to_market_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "618bf2913fb3756454129762628145b3",
          "name": "clean_mark_to_market_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "297c9bf5e4f034c86ff308d142723623",
          "name": "clean_mark_to_market_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cf2a8cf23eb8c0ad178b8b99b5033f7b",
          "name": "clean_mark_to_market_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "900383ed5ed54544a5af32b8dac9a8ef",
          "name": "dirty_mark_to_market_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5005370c3e0e7f2476e7e1a6711e22c2",
          "name": "dirty_mark_to_market_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "971ac8e914336412ccd2445ed9be2a2c",
          "name": "dirty_mark_to_market_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8abbcd1abc06c788d84495142763f83d",
          "name": "notional_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "notional_amount",
          "name": "notional_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "notional_amount_cad",
          "name": "notional_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f43f019ab7c64061470f5bfcae089d36",
          "name": "accrued_interest_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "accrued_interest_amount",
          "name": "accrued_interest_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "f9788eb99c2540eaa761392ada92a8a8",
          "name": "accrued_interest_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "33a23e5d44f59b8d835af829df4e0d51",
          "name": "accrued_interest_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "eeb7902f4beb762fe83f2a04825c2b6d",
          "name": "accrued_interest_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ec584d6dfc9a250dda7c3a4b197b7c70",
          "name": "accrued_interest_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "a02bf80ec8714f6b603bfab2a809fb3c",
          "name": "accrued_interest_amount_dly_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1975b13c377123672d989bbd9b218ab3",
          "name": "accrued_interest_amount_dly",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bb9a2c46440a7263c2838d1cd3a86791",
          "name": "accrued_interest_amount_dly_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "2a74c48a3bd581e877c347a0589000c8",
          "name": "accrued_interest_amount_mtd_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8c990759fe92c6e0518fb39c78edd37c",
          "name": "accrued_interest_amount_mtd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "405a4161214c60a499ad342f936801ba",
          "name": "accrued_interest_amount_mtd_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ee1e9225b09d54914dacd1d3005c83e2",
          "name": "cost_basis_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cost_basis_amount",
          "name": "cost_basis_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cost_basis_amount_cad",
          "name": "cost_basis_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b36ac5df56abd47280d900e2289d5611",
          "name": "current_ltd_hedge_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "oci_adjustment_amount",
          "name": "oci_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "14b90d80ab80c9e524917986f69dcb02",
          "name": "purchase_price_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "75e2ce61a5350dbe5addb1f0d91543d6",
          "name": "tax_credit_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "80e7520582b31d10881219cfcdf49c8d",
          "name": "unrealized_pnl_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "unrealized_pnl",
          "name": "unrealized_pnl",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "unrealized_pnl_cad",
          "name": "unrealized_pnl_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b266670d919cd88ba6a9604a477c6301",
          "name": "realized_pnl_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl",
          "name": "realized_pnl",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "5ace8bb0e6c488e602c524f68ef519e0",
          "name": "realized_pnl_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_adjusted",
          "name": "realized_pnl_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_cad",
          "name": "realized_pnl_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "7871d5487af3845ea0e843c8f99dd3be",
          "name": "realized_pnl_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1121e32c409c24d33d0e71c16f77d2d9",
          "name": "realized_pnl_mtd_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_mtd",
          "name": "realized_pnl_mtd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_mtd_cad",
          "name": "realized_pnl_mtd_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ece2f01fddf68eba08cc82f38ef9ccc8",
          "name": "realized_pnl_ytd_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_ytd",
          "name": "realized_pnl_ytd",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "realized_pnl_ytd_cad",
          "name": "realized_pnl_ytd_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d7e6fa92c29f51230aeabf388b6f5c06",
          "name": "amortized_cost_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "amortized_cost_amount",
          "name": "amortized_cost_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "a406e5c5f43d5bcdfcfb041eb3de6e79",
          "name": "amortized_cost_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "783bc1a102f2a2fe69887a02f0860701",
          "name": "amortized_premium_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "amortized_premium_amount",
          "name": "amortized_premium_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bad77fba1c06088f6aef476a2a8d757e",
          "name": "amortized_premium_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "68aa1b3dee212458547e7cba56d448e1",
          "name": "amortized_premium_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "9abfa9efd1958f57b0a4c7adb95d0a0e",
          "name": "amortized_premium_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "34fd508b9323b6b2a84d06e441c14bb9",
          "name": "amortized_premium_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8b76b70b955be75e6b9b152707080b19",
          "name": "unamortized_premium_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fbd579b29622d35a0fb04ee12611cec0",
          "name": "unamortized_premium_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "76ca9d0b5ac50a274e816004a8c1d05c",
          "name": "unaccreted_discount_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "40c9bd41aca4b41eb31ebd7a29652d6e",
          "name": "unaccreted_discount_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bc52b9039b9263f176745dda51c80939",
          "name": "accreted_discount_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "accreted_discount_amount",
          "name": "accreted_discount_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "444a32987b6f2fe11cb09c3dea0881a6",
          "name": "accreted_discount_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d8c831b452da718c8b476ae51940eb22",
          "name": "accreted_discount_amount_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "16465aad295f22d527a0a8f2548db2a0",
          "name": "accreted_discount_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "84d58d21f11a8a681af06726bcb675c6",
          "name": "accreted_discount_amount_adjusted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bff9a39027e967ef067ffe050341cd9e",
          "name": "interest_income_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "interest_income_amount",
          "name": "interest_income_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "333e64d32bd22cd7dd16378a17e15586",
          "name": "interest_income_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "acec69cc30a376f81b3e29472eb2d20c",
          "name": "dividend_receivable_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c2da8d1c003dff0d8b03af62d4b93360",
          "name": "dividend_receivable_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1ccfcce00fc16dccb146390501b8f9e6",
          "name": "dividend_amount_currency_code",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "dividend_amount",
          "name": "dividend_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_key",
          "name": "ipv_key",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_currency",
          "name": "ipv_currency",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_market_value",
          "name": "ipv_market_value",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_adjustment_amount",
          "name": "ipv_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_egl_sd_amount",
          "name": "ipv_egl_sd_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_egl_sd_amount_1",
          "name": "ipv_egl_sd_amount_1",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_egl_sd_amount_2",
          "name": "ipv_egl_sd_amount_2",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "57f3c903aafcceb8e659fc73a0026b68",
          "name": "ipv_fair_value_hierarchy_level",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d0264d3c59a78f2a4ddb1897dab06802",
          "name": "ipv_sensitivity_test_min_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "2699a3fd34551a710244dd77df9fb089",
          "name": "ipv_sensitivity_test_max_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_price",
          "name": "ipv_level3_price",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "d6e4d8fdb6877f918877bf4765279aa7",
          "name": "ipv_level3_valuation_technique",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_product_type",
          "name": "ipv_product_type",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_credit_spread",
          "name": "ipv_level3_credit_spread",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_yield",
          "name": "ipv_level3_yield",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_discount_rate",
          "name": "ipv_level3_discount_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_pe_multiple",
          "name": "ipv_level3_pe_multiple",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "e807866835586aeb4f31c2cdd571cecd",
          "name": "ipv_level3_ev_rev_multiple",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "12f30e8002dd374ec4e664433cde0134",
          "name": "ipv_level3_prepayment_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "c2c7ba11c4d8ff109433bc2b1c007299",
          "name": "ipv_level3_discount_margin",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1ae9a1dc8ceb84f361c0b681d40d7cf8",
          "name": "ipv_level3_loss_severity_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_default_rate",
          "name": "ipv_level3_default_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "b77f1c89dc6294958c2bb967e1cd5596",
          "name": "ipv_level3_deferment_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "32b4bab06ea151b1508519af9773d12f",
          "name": "ipv_level3_redemption_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_recovery_rate",
          "name": "ipv_level3_recovery_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "691a79a0258e11a43f2c3c0ebc2068ff",
          "name": "ipv_level3_capitalization_rate",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "456f6daabc7d93e1e7717ea019874de2",
          "name": "ipv_level3_credit_enhancement",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8f0862d592d89f5b463f3d1e1e96d617",
          "name": "ipv_level3_liquidity_discount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "0a3367c706c3dd889663a4af17ec35d3",
          "name": "ipv_level3_ev_ebitda_multiple",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ipv_level3_forbearance",
          "name": "ipv_level3_forbearance",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "local_fx_rate_region",
          "name": "local_fx_rate_region",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "fx_rate_booked_to_ho_cad",
          "name": "fx_rate_booked_to_ho_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "is_deleted_flag",
          "name": "is_deleted_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "account_for_ecl_mapping",
          "name": "account_for_ecl_mapping",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_acl_account",
          "name": "st_1_acl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_acl_name",
          "name": "st_1_acl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_acl_account",
          "name": "st_2_acl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_acl_name",
          "name": "st_2_acl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_pcl_account",
          "name": "st_1_pcl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_1_pcl_name",
          "name": "st_1_pcl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_pcl_account",
          "name": "st_2_pcl_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "st_2_pcl_name",
          "name": "st_2_pcl_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "stage_3_flag",
          "name": "stage_3_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_sub_account",
          "name": "re_sub_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_sub_account_name",
          "name": "re_sub_account_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_le_account",
          "name": "re_le_account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "re_le_account_name",
          "name": "re_le_account_name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_key_hash",
          "name": "business_key_hash",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "unrealized_pnl_adjusted",
          "name": "unrealized_pnl_adjusted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "security_id",
          "name": "security_id",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "413fd227ce4150199e78de958e599883",
          "name": "fair_value_enterprise_netted_adjustment_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "aee9d8f206cbacbd0ada9a2a3c0c3274",
          "name": "fair_value_amount_enterprise_netted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "41c54825464399f91cd362cf707f8110",
          "name": "fair_value_enterprise_netted_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "e21c8cb3bb7a9a4c662d293841b11016",
          "name": "fair_value_amount_enterprise_netted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "enterprise_netting_flag",
          "name": "enterprise_netting_flag",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "97ec31844656e7d8481dc8995d818764",
          "name": "fair_value_legal_entity_netted_adjustment_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "28a0e18c71698e21d0cef8871301bcb3",
          "name": "fair_value_amount_legal_entity_netted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "bab39ca998144821d6bc9c0f97efceb8",
          "name": "fair_value_legal_entity_netted_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "cbd202e585d30371531e2364a14e5283",
          "name": "fair_value_amount_legal_entity_netted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1204065eb017d9dbca7cafbf3feca2d0",
          "name": "book_value_enterprise_netted_adjustment_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "ab4a83d37bbf774aed94a8e56d92a18e",
          "name": "book_value_amount_enterprise_netted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "11613ca0d7c3cca30975fb770dc56518",
          "name": "book_value_enterprise_netted_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "faa09863dcbb9ae66f9cddd0adc162a6",
          "name": "book_value_amount_enterprise_netted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "8d9ed6d7b216761f0cf5b24cea3ac2ac",
          "name": "book_value_legal_entity_netted_adjustment_amount_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "3fd958cf47b8d1810cdf376d6af1c52d",
          "name": "book_value_amount_legal_entity_netted_cad",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "939f5dc500fdf85b266779f8cc184afa",
          "name": "book_value_legal_entity_netted_adjustment_amount",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "02b95d2e10950a467797d142fedf6239",
          "name": "book_value_amount_legal_entity_netted",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "hierarchy_id_enterprise",
          "name": "hierarchy_id_enterprise",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "hierarchy_id_legal",
          "name": "hierarchy_id_legal",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "level3_rollup",
          "name": "level3_rollup",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "level9_rollup",
          "name": "level9_rollup",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "business_date",
          "name": "business_date",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "au_batch_id",
          "name": "au_batch_id",
          "width": 100,
          "thousandSeparator": true
        }
      ]
    }
  ],
  "advancedSchedulingInUse": true,
  "errorHandlingMode": "IGNORE"
}

thomas lee

April 03, 2020 14:45

Datalink:

{
  "version": "7.4.6",
  "className": "datameer.dap.common.entity.DataSourceConfigurationImpl",
  "file": {
    "uuid": "59bf639b-dcd9-4beb-ba35-835a04c8e599",
    "path": "/Teams/FinanceCore/Finance/ESP/Datalinks/ESP DataLink.lnk",
    "description": "",
    "name": "ESP DataLink"
  },
  "pullType": "MANUALLY",
  "minKeepCount": 1,
  "properties": {
    "GenericConfigurationImpl.temp-file-store": [
      "10e215ab-912c-412b-adae-8772b64ee25e"
    ],
    "ObfuscatedColumns": [
      ""
    ],
    "characterEncoding": [
      "UTF-8"
    ],
    "datameer.dap.common.entity.DataSourceConfigurationImpl.preventPreviewDataStorage": [
      "false"
    ],
    "incrementalMode": [
      "false"
    ],
    "jdbc.property.schema": [
      "prod_vyc0_itfc"
    ],
    "jdbc.property.select.sql.action": [
      "TABLE"
    ],
    "jdbc.property.table": [
      "\u0027prod_vyc0_itfc\u0027.\u0027enriched_securities_position\u0027"
    ],
    "orderColumn": [
      "$NO_APPROPRIATE_ORDER_COLUMN$"
    ],
    "request_data_for_field_detection": [
      "true"
    ]
  },
  "hadoopProperties": "",
  "dataStore": {
    "path": "/Teams/FinanceCore/Finance/Connection/HIVE Connection.dst",
    "uuid": "ca26e9a5-9418-47ff-81fb-dcea9b1a9871"
  },
  "errorHandlingMode": "DROP_RECORD",
  "maxLogErrors": 1000,
  "maxMappers": 1,
  "maxPreviewRecords": 5000,
  "notificationAddresses": "",
  "notificationSuccessAddresses": "",
  "fields": [
    {
      "acceptEmpty": true,
      "id": 2541173,
      "include": true,
      "name": "source_batch_id",
      "origin": "enriched_securities_position.source_batch_id",
      "valueType": "{\"type\":\"INTEGER\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541174,
      "include": true,
      "name": "as_at_date",
      "origin": "enriched_securities_position.as_at_date",
      "pattern": "",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541175,
      "include": true,
      "name": "business_key",
      "origin": "enriched_securities_position.business_key",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541176,
      "include": true,
      "name": "ecl_old_record_id",
      "origin": "enriched_securities_position.ecl_old_record_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541177,
      "include": true,
      "name": "region",
      "origin": "enriched_securities_position.region",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541178,
      "include": true,
      "name": "source_system_id",
      "origin": "enriched_securities_position.source_system_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541179,
      "include": true,
      "name": "eod_position_id",
      "origin": "enriched_securities_position.eod_position_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541180,
      "include": true,
      "name": "record_origin",
      "origin": "enriched_securities_position.record_origin",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541181,
      "include": true,
      "name": "eodc_asset_class_type",
      "origin": "enriched_securities_position.eodc_asset_class_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541182,
      "include": true,
      "name": "eodc_product_type",
      "origin": "enriched_securities_position.eodc_product_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541183,
      "include": true,
      "name": "eodc_product_sub_type",
      "origin": "enriched_securities_position.eodc_product_sub_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541184,
      "include": true,
      "name": "source_product_classification",
      "origin": "enriched_securities_position.source_product_classification",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541185,
      "include": true,
      "name": "lrm_product_classification_id",
      "origin": "enriched_securities_position.lrm_product_classification_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541186,
      "include": true,
      "name": "market_sector",
      "origin": "enriched_securities_position.market_sector",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541187,
      "include": true,
      "name": "security_type_indicator",
      "origin": "enriched_securities_position.security_type_indicator",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541188,
      "include": true,
      "name": "ecpt_code",
      "origin": "enriched_securities_position.ecpt_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541189,
      "include": true,
      "name": "ecpt_name",
      "origin": "enriched_securities_position.ecpt_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541190,
      "include": true,
      "name": "ecpt_parent_code",
      "origin": "enriched_securities_position.ecpt_parent_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541191,
      "include": true,
      "name": "external_product_type",
      "origin": "enriched_securities_position.external_product_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541192,
      "include": true,
      "name": "country_classification",
      "origin": "enriched_securities_position.country_classification",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541193,
      "include": true,
      "name": "b2_sector",
      "origin": "enriched_securities_position.b2_sector",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541194,
      "include": true,
      "name": "b2_bs_60200_rollup",
      "origin": "enriched_securities_position.b2_bs_60200_rollup",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541195,
      "include": true,
      "name": "b2_product_type_1",
      "origin": "enriched_securities_position.b2_product_type_1",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541196,
      "include": true,
      "name": "b2_product_type_2",
      "origin": "enriched_securities_position.b2_product_type_2",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541197,
      "include": true,
      "name": "gdal_sector",
      "origin": "enriched_securities_position.gdal_sector",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541198,
      "include": true,
      "name": "agency",
      "origin": "enriched_securities_position.agency",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541199,
      "include": true,
      "name": "position_type",
      "origin": "enriched_securities_position.position_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541200,
      "include": true,
      "name": "position_level_name",
      "origin": "enriched_securities_position.position_level_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541201,
      "include": true,
      "name": "instrument_currency",
      "origin": "enriched_securities_position.instrument_currency",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541202,
      "include": true,
      "name": "reporting_currency",
      "origin": "enriched_securities_position.reporting_currency",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541203,
      "include": true,
      "name": "instrument_srdr_id",
      "origin": "enriched_securities_position.instrument_srdr_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541204,
      "include": true,
      "name": "isin_id",
      "origin": "enriched_securities_position.isin_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541205,
      "include": true,
      "name": "bloomberg_unique_id",
      "origin": "enriched_securities_position.bloomberg_unique_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541206,
      "include": true,
      "name": "cusip_id",
      "origin": "enriched_securities_position.cusip_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541207,
      "include": true,
      "name": "sedol_id",
      "origin": "enriched_securities_position.sedol_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541208,
      "include": true,
      "name": "source_instrument_id",
      "origin": "enriched_securities_position.source_instrument_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541209,
      "include": true,
      "name": "source_trade_group_id",
      "origin": "enriched_securities_position.source_trade_group_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541210,
      "include": true,
      "name": "source_trade_id",
      "origin": "enriched_securities_position.source_trade_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541211,
      "include": true,
      "name": "source_contract_version_number",
      "origin": "enriched_securities_position.source_contract_version_number",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541212,
      "include": true,
      "name": "involved_party_id",
      "origin": "enriched_securities_position.involved_party_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541213,
      "include": true,
      "name": "involved_party_id_source_type",
      "origin": "enriched_securities_position.involved_party_id_source_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541214,
      "include": true,
      "name": "source_counterparty_short_name",
      "origin": "enriched_securities_position.source_counterparty_short_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541215,
      "include": true,
      "name": "position_short_long_code",
      "origin": "enriched_securities_position.position_short_long_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541216,
      "include": true,
      "name": "pay_receive_code",
      "origin": "enriched_securities_position.pay_receive_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541217,
      "include": true,
      "name": "position_quantity",
      "origin": "enriched_securities_position.position_quantity",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541218,
      "include": true,
      "name": "position_decorator_id",
      "origin": "enriched_securities_position.position_decorator_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541219,
      "include": true,
      "name": "position_decorator_type",
      "origin": "enriched_securities_position.position_decorator_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541220,
      "include": true,
      "name": "issue_date",
      "origin": "enriched_securities_position.issue_date",
      "pattern": "",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541221,
      "include": true,
      "name": "maturity_date",
      "origin": "enriched_securities_position.maturity_date",
      "pattern": "",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541222,
      "include": true,
      "name": "original_term_to_maturity_days",
      "origin": "enriched_securities_position.original_term_to_maturity_days",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541223,
      "include": true,
      "name": "residual_term_to_maturity_days",
      "origin": "enriched_securities_position.residual_term_to_maturity_days",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541224,
      "include": true,
      "name": "position_settlement_date",
      "origin": "enriched_securities_position.position_settlement_date",
      "pattern": "",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541225,
      "include": true,
      "name": "issue_rating_moody_long_term",
      "origin": "enriched_securities_position.issue_rating_moody_long_term",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541226,
      "include": true,
      "name": "issue_rating_sp_long_term",
      "origin": "enriched_securities_position.issue_rating_sp_long_term",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541227,
      "include": true,
      "name": "issue_rating_fitch_long_term",
      "origin": "enriched_securities_position.issue_rating_fitch_long_term",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541228,
      "include": true,
      "name": "issue_rating_dbrs_long_term",
      "origin": "enriched_securities_position.issue_rating_dbrs_long_term",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541229,
      "include": true,
      "name": "issuer_cdr_id",
      "origin": "enriched_securities_position.issuer_cdr_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541230,
      "include": true,
      "name": "issuer_bbg_id",
      "origin": "enriched_securities_position.issuer_bbg_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541231,
      "include": true,
      "name": "issuer_srf",
      "origin": "enriched_securities_position.issuer_srf",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541232,
      "include": true,
      "name": "issuer_name",
      "origin": "enriched_securities_position.issuer_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541233,
      "include": true,
      "name": "issuer_ultimate_parent_id",
      "origin": "enriched_securities_position.issuer_ultimate_parent_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541234,
      "include": true,
      "name": "issuer_industry",
      "origin": "enriched_securities_position.issuer_industry",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541235,
      "include": true,
      "name": "issuer_dom_country_short_code",
      "origin": "enriched_securities_position.issuer_dom_country_short_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541236,
      "include": true,
      "name": "issuer_province",
      "origin": "enriched_securities_position.issuer_province",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541237,
      "include": true,
      "name": "issuer_rbcsic",
      "origin": "enriched_securities_position.issuer_rbcsic",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541238,
      "include": true,
      "name": "issuer_business_risk_rating",
      "origin": "enriched_securities_position.issuer_business_risk_rating",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541239,
      "include": true,
      "name": "issuer_rating_sp_lt_fc",
      "origin": "enriched_securities_position.issuer_rating_sp_lt_fc",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541240,
      "include": true,
      "name": "issuer_rating_sp_lt_li",
      "origin": "enriched_securities_position.issuer_rating_sp_lt_li",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541241,
      "include": true,
      "name": "issuer_rating_fitch_long_term",
      "origin": "enriched_securities_position.issuer_rating_fitch_long_term",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541242,
      "include": true,
      "name": "issuer_rating_moody_long_term",
      "origin": "enriched_securities_position.issuer_rating_moody_long_term",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541243,
      "include": true,
      "name": "issuer_rating_dbrs_long_term",
      "origin": "enriched_securities_position.issuer_rating_dbrs_long_term",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541244,
      "include": true,
      "name": "guarantor_cdr_id",
      "origin": "enriched_securities_position.guarantor_cdr_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541245,
      "include": true,
      "name": "guarantor_bbg_id",
      "origin": "enriched_securities_position.guarantor_bbg_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541246,
      "include": true,
      "name": "guarantor_srf",
      "origin": "enriched_securities_position.guarantor_srf",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541247,
      "include": true,
      "name": "guarantor_name",
      "origin": "enriched_securities_position.guarantor_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541248,
      "include": true,
      "name": "guarantor_ultimate_parent_id",
      "origin": "enriched_securities_position.guarantor_ultimate_parent_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541249,
      "include": true,
      "name": "guarantor_rbcsic",
      "origin": "enriched_securities_position.guarantor_rbcsic",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541250,
      "include": true,
      "name": "guarantor_business_risk_rating",
      "origin": "enriched_securities_position.guarantor_business_risk_rating",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541251,
      "include": true,
      "name": "coupon_rate",
      "origin": "enriched_securities_position.coupon_rate",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541252,
      "include": true,
      "name": "coupon_type",
      "origin": "enriched_securities_position.coupon_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541253,
      "include": true,
      "name": "last_coupon_reset_date",
      "origin": "enriched_securities_position.last_coupon_reset_date",
      "pattern": "",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541254,
      "include": true,
      "name": "next_coupon_reset_date",
      "origin": "enriched_securities_position.next_coupon_reset_date",
      "pattern": "",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541255,
      "include": true,
      "name": "coupon_reset_frequency",
      "origin": "enriched_securities_position.coupon_reset_frequency",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541256,
      "include": true,
      "name": "reset_index",
      "origin": "enriched_securities_position.reset_index",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541257,
      "include": true,
      "name": "rbc_issued_flag",
      "origin": "enriched_securities_position.rbc_issued_flag",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541258,
      "include": true,
      "name": "security_product_type",
      "origin": "enriched_securities_position.security_product_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541259,
      "include": true,
      "name": "bbg_product_type",
      "origin": "enriched_securities_position.bbg_product_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541260,
      "include": true,
      "name": "bbg_product_subtype",
      "origin": "enriched_securities_position.bbg_product_subtype",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541261,
      "include": true,
      "name": "security_description",
      "origin": "enriched_securities_position.security_description",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541262,
      "include": true,
      "name": "bbg_sector",
      "origin": "enriched_securities_position.bbg_sector",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541263,
      "include": true,
      "name": "bbg_industry_group",
      "origin": "enriched_securities_position.bbg_industry_group",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541264,
      "include": true,
      "name": "bbg_industry_sub_group",
      "origin": "enriched_securities_position.bbg_industry_sub_group",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541265,
      "include": true,
      "name": "sector_immediate_risk",
      "origin": "enriched_securities_position.sector_immediate_risk",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541266,
      "include": true,
      "name": "sector_ultimate_risk",
      "origin": "enriched_securities_position.sector_ultimate_risk",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541267,
      "include": true,
      "name": "collateral_type",
      "origin": "enriched_securities_position.collateral_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541268,
      "include": true,
      "name": "ticker",
      "origin": "enriched_securities_position.ticker",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541269,
      "include": true,
      "name": "mortg_deal_type",
      "origin": "enriched_securities_position.mortg_deal_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541270,
      "include": true,
      "name": "mortg_issuer_fullname",
      "origin": "enriched_securities_position.mortg_issuer_fullname",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541271,
      "include": true,
      "name": "compliance_code",
      "origin": "enriched_securities_position.compliance_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541272,
      "include": true,
      "name": "tranche_type_description",
      "origin": "enriched_securities_position.tranche_type_description",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541273,
      "include": true,
      "name": "is_subordinated",
      "origin": "enriched_securities_position.is_subordinated",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541274,
      "include": true,
      "name": "country_of_domicile",
      "origin": "enriched_securities_position.country_of_domicile",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541275,
      "include": true,
      "name": "country_of_risk",
      "origin": "enriched_securities_position.country_of_risk",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541276,
      "include": true,
      "name": "country_ultimate_risk",
      "origin": "enriched_securities_position.country_ultimate_risk",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541277,
      "include": true,
      "name": "country_of_guarantor",
      "origin": "enriched_securities_position.country_of_guarantor",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541278,
      "include": true,
      "name": "bdr_book_id",
      "origin": "enriched_securities_position.bdr_book_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541279,
      "include": true,
      "name": "source_book_id",
      "origin": "enriched_securities_position.source_book_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541280,
      "include": true,
      "name": "source_book_name",
      "origin": "enriched_securities_position.source_book_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541281,
      "include": true,
      "name": "source_sub_book_name",
      "origin": "enriched_securities_position.source_sub_book_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541282,
      "include": true,
      "name": "slim_app_book_cd",
      "origin": "enriched_securities_position.slim_app_book_cd",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541283,
      "include": true,
      "name": "slim_app_book_name",
      "origin": "enriched_securities_position.slim_app_book_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541284,
      "include": true,
      "name": "transit_number",
      "origin": "enriched_securities_position.transit_number",
      "valueType": "{\"type\":\"INTEGER\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541285,
      "include": true,
      "name": "transit_desc",
      "origin": "enriched_securities_position.transit_desc",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541286,
      "include": true,
      "name": "source_booking_transit_id",
      "origin": "enriched_securities_position.source_booking_transit_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541287,
      "include": true,
      "name": "transit_short_name",
      "origin": "enriched_securities_position.transit_short_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541288,
      "include": true,
      "name": "master_book_name",
      "origin": "enriched_securities_position.master_book_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541289,
      "include": true,
      "name": "master_book_desc",
      "origin": "enriched_securities_position.master_book_desc",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541290,
      "include": true,
      "name": "sub_branch_code",
      "origin": "enriched_securities_position.sub_branch_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541291,
      "include": true,
      "name": "business_unit_name",
      "origin": "enriched_securities_position.business_unit_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541292,
      "include": true,
      "name": "legal_entity_name",
      "origin": "enriched_securities_position.legal_entity_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541293,
      "include": true,
      "name": "desk_name",
      "origin": "enriched_securities_position.desk_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541294,
      "include": true,
      "name": "functional_reporting_currency_code",
      "origin": "enriched_securities_position.functional_reporting_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541295,
      "include": true,
      "name": "segment",
      "origin": "enriched_securities_position.segment",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541296,
      "include": true,
      "name": "processing_center",
      "origin": "enriched_securities_position.processing_center",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541297,
      "include": true,
      "name": "control_unit",
      "origin": "enriched_securities_position.control_unit",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541298,
      "include": true,
      "name": "processing_center_country_code",
      "origin": "enriched_securities_position.processing_center_country_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541299,
      "include": true,
      "name": "legal_entity_country_code",
      "origin": "enriched_securities_position.legal_entity_country_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541300,
      "include": true,
      "name": "disposition_type",
      "origin": "enriched_securities_position.disposition_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541301,
      "include": true,
      "name": "disposition_amount",
      "origin": "enriched_securities_position.disposition_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541302,
      "include": true,
      "name": "disposition_amount_cad",
      "origin": "enriched_securities_position.disposition_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541303,
      "include": true,
      "name": "purchase_date",
      "origin": "enriched_securities_position.purchase_date",
      "pattern": "",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541304,
      "include": true,
      "name": "units_purchased",
      "origin": "enriched_securities_position.units_purchased",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541305,
      "include": true,
      "name": "purchase_amount",
      "origin": "enriched_securities_position.purchase_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541306,
      "include": true,
      "name": "purchase_amount_cad",
      "origin": "enriched_securities_position.purchase_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541307,
      "include": true,
      "name": "expected_credit_loss_amount",
      "origin": "enriched_securities_position.expected_credit_loss_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541308,
      "include": true,
      "name": "expected_credit_loss_amount_cad",
      "origin": "enriched_securities_position.expected_credit_loss_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541309,
      "include": true,
      "name": "expected_credit_loss_stage",
      "origin": "enriched_securities_position.expected_credit_loss_stage",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541310,
      "include": true,
      "name": "expected_aoci",
      "origin": "enriched_securities_position.expected_aoci",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541311,
      "include": true,
      "name": "provision_credit_loss_amount",
      "origin": "enriched_securities_position.provision_credit_loss_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541312,
      "include": true,
      "name": "provision_credit_loss_amount_cad",
      "origin": "enriched_securities_position.provision_credit_loss_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541313,
      "include": true,
      "name": "proxy_flag",
      "origin": "enriched_securities_position.proxy_flag",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541314,
      "include": true,
      "name": "fair_value_amount_currency_code",
      "origin": "enriched_securities_position.fair_value_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541315,
      "include": true,
      "name": "fair_value_amount",
      "origin": "enriched_securities_position.fair_value_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541316,
      "include": true,
      "name": "fair_value_adjustment_amount",
      "origin": "enriched_securities_position.fair_value_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541317,
      "include": true,
      "name": "fair_value_amount_adjusted",
      "origin": "enriched_securities_position.fair_value_amount_adjusted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541318,
      "include": true,
      "name": "fair_value_amount_cad",
      "origin": "enriched_securities_position.fair_value_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541319,
      "include": true,
      "name": "fair_value_amount_adjusted_cad",
      "origin": "enriched_securities_position.fair_value_amount_adjusted_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541320,
      "include": true,
      "name": "book_value_amount_currency_code",
      "origin": "enriched_securities_position.book_value_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541321,
      "include": true,
      "name": "book_value_amount",
      "origin": "enriched_securities_position.book_value_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541322,
      "include": true,
      "name": "book_value_adjustment_amount",
      "origin": "enriched_securities_position.book_value_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541323,
      "include": true,
      "name": "book_value_amount_adjusted",
      "origin": "enriched_securities_position.book_value_amount_adjusted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541324,
      "include": true,
      "name": "book_value_amount_cad",
      "origin": "enriched_securities_position.book_value_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541325,
      "include": true,
      "name": "book_value_amount_adjusted_cad",
      "origin": "enriched_securities_position.book_value_amount_adjusted_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541326,
      "include": true,
      "name": "net_carrying_value_amount_currency_code",
      "origin": "enriched_securities_position.net_carrying_value_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541327,
      "include": true,
      "name": "net_carrying_value_amount",
      "origin": "enriched_securities_position.net_carrying_value_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541328,
      "include": true,
      "name": "net_carrying_value_amount_cad",
      "origin": "enriched_securities_position.net_carrying_value_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541329,
      "include": true,
      "name": "gross_carrying_value_amount_currency_code",
      "origin": "enriched_securities_position.gross_carrying_value_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541330,
      "include": true,
      "name": "gross_carrying_value_amount",
      "origin": "enriched_securities_position.gross_carrying_value_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541331,
      "include": true,
      "name": "gross_carrying_value_amount_cad",
      "origin": "enriched_securities_position.gross_carrying_value_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541332,
      "include": true,
      "name": "bs_egl_account",
      "origin": "enriched_securities_position.bs_egl_account",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541333,
      "include": true,
      "name": "bs_egl_account_name",
      "origin": "enriched_securities_position.bs_egl_account_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541334,
      "include": true,
      "name": "accounting_classification",
      "origin": "enriched_securities_position.accounting_classification",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541335,
      "include": true,
      "name": "mark_to_market_amount_currency_code",
      "origin": "enriched_securities_position.mark_to_market_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541336,
      "include": true,
      "name": "mark_to_market_amount",
      "origin": "enriched_securities_position.mark_to_market_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541337,
      "include": true,
      "name": "mark_to_market_amount_cad",
      "origin": "enriched_securities_position.mark_to_market_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541338,
      "include": true,
      "name": "clean_mark_to_market_amount_currency_code",
      "origin": "enriched_securities_position.clean_mark_to_market_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541339,
      "include": true,
      "name": "clean_mark_to_market_amount",
      "origin": "enriched_securities_position.clean_mark_to_market_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541340,
      "include": true,
      "name": "clean_mark_to_market_amount_cad",
      "origin": "enriched_securities_position.clean_mark_to_market_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541341,
      "include": true,
      "name": "dirty_mark_to_market_amount_currency_code",
      "origin": "enriched_securities_position.dirty_mark_to_market_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541342,
      "include": true,
      "name": "dirty_mark_to_market_amount",
      "origin": "enriched_securities_position.dirty_mark_to_market_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541343,
      "include": true,
      "name": "dirty_mark_to_market_amount_cad",
      "origin": "enriched_securities_position.dirty_mark_to_market_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541344,
      "include": true,
      "name": "notional_amount_currency_code",
      "origin": "enriched_securities_position.notional_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541345,
      "include": true,
      "name": "notional_amount",
      "origin": "enriched_securities_position.notional_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541346,
      "include": true,
      "name": "notional_amount_cad",
      "origin": "enriched_securities_position.notional_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541347,
      "include": true,
      "name": "accrued_interest_amount_currency_code",
      "origin": "enriched_securities_position.accrued_interest_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541348,
      "include": true,
      "name": "accrued_interest_amount",
      "origin": "enriched_securities_position.accrued_interest_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541349,
      "include": true,
      "name": "accrued_interest_adjustment_amount",
      "origin": "enriched_securities_position.accrued_interest_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541350,
      "include": true,
      "name": "accrued_interest_amount_adjusted",
      "origin": "enriched_securities_position.accrued_interest_amount_adjusted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541351,
      "include": true,
      "name": "accrued_interest_amount_cad",
      "origin": "enriched_securities_position.accrued_interest_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541352,
      "include": true,
      "name": "accrued_interest_amount_adjusted_cad",
      "origin": "enriched_securities_position.accrued_interest_amount_adjusted_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541353,
      "include": true,
      "name": "accrued_interest_amount_dly_currency_code",
      "origin": "enriched_securities_position.accrued_interest_amount_dly_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541354,
      "include": true,
      "name": "accrued_interest_amount_dly",
      "origin": "enriched_securities_position.accrued_interest_amount_dly",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541355,
      "include": true,
      "name": "accrued_interest_amount_dly_cad",
      "origin": "enriched_securities_position.accrued_interest_amount_dly_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541356,
      "include": true,
      "name": "accrued_interest_amount_mtd_currency_code",
      "origin": "enriched_securities_position.accrued_interest_amount_mtd_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541357,
      "include": true,
      "name": "accrued_interest_amount_mtd",
      "origin": "enriched_securities_position.accrued_interest_amount_mtd",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541358,
      "include": true,
      "name": "accrued_interest_amount_mtd_cad",
      "origin": "enriched_securities_position.accrued_interest_amount_mtd_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541359,
      "include": true,
      "name": "cost_basis_amount_currency_code",
      "origin": "enriched_securities_position.cost_basis_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541360,
      "include": true,
      "name": "cost_basis_amount",
      "origin": "enriched_securities_position.cost_basis_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541361,
      "include": true,
      "name": "cost_basis_amount_cad",
      "origin": "enriched_securities_position.cost_basis_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541362,
      "include": true,
      "name": "current_ltd_hedge_adjustment_amount",
      "origin": "enriched_securities_position.current_ltd_hedge_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541363,
      "include": true,
      "name": "oci_adjustment_amount",
      "origin": "enriched_securities_position.oci_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541364,
      "include": true,
      "name": "purchase_price_adjustment_amount",
      "origin": "enriched_securities_position.purchase_price_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541365,
      "include": true,
      "name": "tax_credit_adjustment_amount",
      "origin": "enriched_securities_position.tax_credit_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541366,
      "include": true,
      "name": "unrealized_pnl_currency_code",
      "origin": "enriched_securities_position.unrealized_pnl_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541367,
      "include": true,
      "name": "unrealized_pnl",
      "origin": "enriched_securities_position.unrealized_pnl",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541368,
      "include": true,
      "name": "unrealized_pnl_cad",
      "origin": "enriched_securities_position.unrealized_pnl_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541369,
      "include": true,
      "name": "realized_pnl_currency_code",
      "origin": "enriched_securities_position.realized_pnl_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541370,
      "include": true,
      "name": "realized_pnl",
      "origin": "enriched_securities_position.realized_pnl",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541371,
      "include": true,
      "name": "realized_pnl_adjustment_amount",
      "origin": "enriched_securities_position.realized_pnl_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541372,
      "include": true,
      "name": "realized_pnl_adjusted",
      "origin": "enriched_securities_position.realized_pnl_adjusted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541373,
      "include": true,
      "name": "realized_pnl_cad",
      "origin": "enriched_securities_position.realized_pnl_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541374,
      "include": true,
      "name": "realized_pnl_adjusted_cad",
      "origin": "enriched_securities_position.realized_pnl_adjusted_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541375,
      "include": true,
      "name": "realized_pnl_mtd_currency_code",
      "origin": "enriched_securities_position.realized_pnl_mtd_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541376,
      "include": true,
      "name": "realized_pnl_mtd",
      "origin": "enriched_securities_position.realized_pnl_mtd",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541377,
      "include": true,
      "name": "realized_pnl_mtd_cad",
      "origin": "enriched_securities_position.realized_pnl_mtd_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541378,
      "include": true,
      "name": "realized_pnl_ytd_currency_code",
      "origin": "enriched_securities_position.realized_pnl_ytd_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541379,
      "include": true,
      "name": "realized_pnl_ytd",
      "origin": "enriched_securities_position.realized_pnl_ytd",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541380,
      "include": true,
      "name": "realized_pnl_ytd_cad",
      "origin": "enriched_securities_position.realized_pnl_ytd_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541381,
      "include": true,
      "name": "amortized_cost_amount_currency_code",
      "origin": "enriched_securities_position.amortized_cost_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541382,
      "include": true,
      "name": "amortized_cost_amount",
      "origin": "enriched_securities_position.amortized_cost_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541383,
      "include": true,
      "name": "amortized_cost_amount_cad",
      "origin": "enriched_securities_position.amortized_cost_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541384,
      "include": true,
      "name": "amortized_premium_amount_currency_code",
      "origin": "enriched_securities_position.amortized_premium_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541385,
      "include": true,
      "name": "amortized_premium_amount",
      "origin": "enriched_securities_position.amortized_premium_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541386,
      "include": true,
      "name": "amortized_premium_adjustment_amount",
      "origin": "enriched_securities_position.amortized_premium_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541387,
      "include": true,
      "name": "amortized_premium_amount_adjusted",
      "origin": "enriched_securities_position.amortized_premium_amount_adjusted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541388,
      "include": true,
      "name": "amortized_premium_amount_cad",
      "origin": "enriched_securities_position.amortized_premium_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541389,
      "include": true,
      "name": "amortized_premium_amount_adjusted_cad",
      "origin": "enriched_securities_position.amortized_premium_amount_adjusted_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541390,
      "include": true,
      "name": "unamortized_premium_amount_currency_code",
      "origin": "enriched_securities_position.unamortized_premium_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541391,
      "include": true,
      "name": "unamortized_premium_amount",
      "origin": "enriched_securities_position.unamortized_premium_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541392,
      "include": true,
      "name": "unaccreted_discount_amount_currency_code",
      "origin": "enriched_securities_position.unaccreted_discount_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541393,
      "include": true,
      "name": "unaccreted_discount_amount",
      "origin": "enriched_securities_position.unaccreted_discount_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541394,
      "include": true,
      "name": "accreted_discount_amount_currency_code",
      "origin": "enriched_securities_position.accreted_discount_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541395,
      "include": true,
      "name": "accreted_discount_amount",
      "origin": "enriched_securities_position.accreted_discount_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541396,
      "include": true,
      "name": "accreted_discount_adjustment_amount",
      "origin": "enriched_securities_position.accreted_discount_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541397,
      "include": true,
      "name": "accreted_discount_amount_adjusted",
      "origin": "enriched_securities_position.accreted_discount_amount_adjusted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541398,
      "include": true,
      "name": "accreted_discount_amount_cad",
      "origin": "enriched_securities_position.accreted_discount_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541399,
      "include": true,
      "name": "accreted_discount_amount_adjusted_cad",
      "origin": "enriched_securities_position.accreted_discount_amount_adjusted_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541400,
      "include": true,
      "name": "interest_income_amount_currency_code",
      "origin": "enriched_securities_position.interest_income_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541401,
      "include": true,
      "name": "interest_income_amount",
      "origin": "enriched_securities_position.interest_income_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541402,
      "include": true,
      "name": "interest_income_amount_cad",
      "origin": "enriched_securities_position.interest_income_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541403,
      "include": true,
      "name": "dividend_receivable_amount_currency_code",
      "origin": "enriched_securities_position.dividend_receivable_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541404,
      "include": true,
      "name": "dividend_receivable_amount",
      "origin": "enriched_securities_position.dividend_receivable_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541405,
      "include": true,
      "name": "dividend_amount_currency_code",
      "origin": "enriched_securities_position.dividend_amount_currency_code",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541406,
      "include": true,
      "name": "dividend_amount",
      "origin": "enriched_securities_position.dividend_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541407,
      "include": true,
      "name": "ipv_key",
      "origin": "enriched_securities_position.ipv_key",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541408,
      "include": true,
      "name": "ipv_currency",
      "origin": "enriched_securities_position.ipv_currency",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541409,
      "include": true,
      "name": "ipv_market_value",
      "origin": "enriched_securities_position.ipv_market_value",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541410,
      "include": true,
      "name": "ipv_adjustment_amount",
      "origin": "enriched_securities_position.ipv_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541411,
      "include": true,
      "name": "ipv_egl_sd_amount",
      "origin": "enriched_securities_position.ipv_egl_sd_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541412,
      "include": true,
      "name": "ipv_egl_sd_amount_1",
      "origin": "enriched_securities_position.ipv_egl_sd_amount_1",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541413,
      "include": true,
      "name": "ipv_egl_sd_amount_2",
      "origin": "enriched_securities_position.ipv_egl_sd_amount_2",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541414,
      "include": true,
      "name": "ipv_fair_value_hierarchy_level",
      "origin": "enriched_securities_position.ipv_fair_value_hierarchy_level",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541415,
      "include": true,
      "name": "ipv_sensitivity_test_min_amount",
      "origin": "enriched_securities_position.ipv_sensitivity_test_min_amount",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541416,
      "include": true,
      "name": "ipv_sensitivity_test_max_amount",
      "origin": "enriched_securities_position.ipv_sensitivity_test_max_amount",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541417,
      "include": true,
      "name": "ipv_level3_price",
      "origin": "enriched_securities_position.ipv_level3_price",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541418,
      "include": true,
      "name": "ipv_level3_valuation_technique",
      "origin": "enriched_securities_position.ipv_level3_valuation_technique",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541419,
      "include": true,
      "name": "ipv_product_type",
      "origin": "enriched_securities_position.ipv_product_type",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541420,
      "include": true,
      "name": "ipv_level3_credit_spread",
      "origin": "enriched_securities_position.ipv_level3_credit_spread",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541421,
      "include": true,
      "name": "ipv_level3_yield",
      "origin": "enriched_securities_position.ipv_level3_yield",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541422,
      "include": true,
      "name": "ipv_level3_discount_rate",
      "origin": "enriched_securities_position.ipv_level3_discount_rate",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541423,
      "include": true,
      "name": "ipv_level3_pe_multiple",
      "origin": "enriched_securities_position.ipv_level3_pe_multiple",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541424,
      "include": true,
      "name": "ipv_level3_ev_rev_multiple",
      "origin": "enriched_securities_position.ipv_level3_ev_rev_multiple",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541425,
      "include": true,
      "name": "ipv_level3_prepayment_rate",
      "origin": "enriched_securities_position.ipv_level3_prepayment_rate",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541426,
      "include": true,
      "name": "ipv_level3_discount_margin",
      "origin": "enriched_securities_position.ipv_level3_discount_margin",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541427,
      "include": true,
      "name": "ipv_level3_loss_severity_rate",
      "origin": "enriched_securities_position.ipv_level3_loss_severity_rate",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541428,
      "include": true,
      "name": "ipv_level3_default_rate",
      "origin": "enriched_securities_position.ipv_level3_default_rate",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541429,
      "include": true,
      "name": "ipv_level3_deferment_rate",
      "origin": "enriched_securities_position.ipv_level3_deferment_rate",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541430,
      "include": true,
      "name": "ipv_level3_redemption_rate",
      "origin": "enriched_securities_position.ipv_level3_redemption_rate",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541431,
      "include": true,
      "name": "ipv_level3_recovery_rate",
      "origin": "enriched_securities_position.ipv_level3_recovery_rate",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541432,
      "include": true,
      "name": "ipv_level3_capitalization_rate",
      "origin": "enriched_securities_position.ipv_level3_capitalization_rate",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541433,
      "include": true,
      "name": "ipv_level3_credit_enhancement",
      "origin": "enriched_securities_position.ipv_level3_credit_enhancement",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541434,
      "include": true,
      "name": "ipv_level3_liquidity_discount",
      "origin": "enriched_securities_position.ipv_level3_liquidity_discount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541435,
      "include": true,
      "name": "ipv_level3_ev_ebitda_multiple",
      "origin": "enriched_securities_position.ipv_level3_ev_ebitda_multiple",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541436,
      "include": true,
      "name": "ipv_level3_forbearance",
      "origin": "enriched_securities_position.ipv_level3_forbearance",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541437,
      "include": true,
      "name": "local_fx_rate_region",
      "origin": "enriched_securities_position.local_fx_rate_region",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541438,
      "include": true,
      "name": "fx_rate_booked_to_ho_cad",
      "origin": "enriched_securities_position.fx_rate_booked_to_ho_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541439,
      "include": true,
      "name": "is_deleted_flag",
      "origin": "enriched_securities_position.is_deleted_flag",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541440,
      "include": true,
      "name": "account_for_ecl_mapping",
      "origin": "enriched_securities_position.account_for_ecl_mapping",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541441,
      "include": true,
      "name": "st_1_acl_account",
      "origin": "enriched_securities_position.st_1_acl_account",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541442,
      "include": true,
      "name": "st_1_acl_name",
      "origin": "enriched_securities_position.st_1_acl_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541443,
      "include": true,
      "name": "st_2_acl_account",
      "origin": "enriched_securities_position.st_2_acl_account",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541444,
      "include": true,
      "name": "st_2_acl_name",
      "origin": "enriched_securities_position.st_2_acl_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541445,
      "include": true,
      "name": "st_1_pcl_account",
      "origin": "enriched_securities_position.st_1_pcl_account",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541446,
      "include": true,
      "name": "st_1_pcl_name",
      "origin": "enriched_securities_position.st_1_pcl_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541447,
      "include": true,
      "name": "st_2_pcl_account",
      "origin": "enriched_securities_position.st_2_pcl_account",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541448,
      "include": true,
      "name": "st_2_pcl_name",
      "origin": "enriched_securities_position.st_2_pcl_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541449,
      "include": true,
      "name": "stage_3_flag",
      "origin": "enriched_securities_position.stage_3_flag",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541450,
      "include": true,
      "name": "re_sub_account",
      "origin": "enriched_securities_position.re_sub_account",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541451,
      "include": true,
      "name": "re_sub_account_name",
      "origin": "enriched_securities_position.re_sub_account_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541452,
      "include": true,
      "name": "re_le_account",
      "origin": "enriched_securities_position.re_le_account",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541453,
      "include": true,
      "name": "re_le_account_name",
      "origin": "enriched_securities_position.re_le_account_name",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541454,
      "include": true,
      "name": "business_key_hash",
      "origin": "enriched_securities_position.business_key_hash",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2612945,
      "include": true,
      "name": "unrealized_pnl_adjusted",
      "origin": "enriched_securities_position.unrealized_pnl_adjusted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633381,
      "include": true,
      "name": "security_id",
      "origin": "enriched_securities_position.security_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633382,
      "include": true,
      "name": "fair_value_enterprise_netted_adjustment_amount_cad",
      "origin": "enriched_securities_position.fair_value_enterprise_netted_adjustment_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633383,
      "include": true,
      "name": "fair_value_amount_enterprise_netted_cad",
      "origin": "enriched_securities_position.fair_value_amount_enterprise_netted_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633384,
      "include": true,
      "name": "fair_value_enterprise_netted_adjustment_amount",
      "origin": "enriched_securities_position.fair_value_enterprise_netted_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633385,
      "include": true,
      "name": "fair_value_amount_enterprise_netted",
      "origin": "enriched_securities_position.fair_value_amount_enterprise_netted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633386,
      "include": true,
      "name": "enterprise_netting_flag",
      "origin": "enriched_securities_position.enterprise_netting_flag",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633387,
      "include": true,
      "name": "fair_value_legal_entity_netted_adjustment_amount_cad",
      "origin": "enriched_securities_position.fair_value_legal_entity_netted_adjustment_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633388,
      "include": true,
      "name": "fair_value_amount_legal_entity_netted_cad",
      "origin": "enriched_securities_position.fair_value_amount_legal_entity_netted_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633389,
      "include": true,
      "name": "fair_value_legal_entity_netted_adjustment_amount",
      "origin": "enriched_securities_position.fair_value_legal_entity_netted_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633390,
      "include": true,
      "name": "fair_value_amount_legal_entity_netted",
      "origin": "enriched_securities_position.fair_value_amount_legal_entity_netted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633391,
      "include": true,
      "name": "book_value_enterprise_netted_adjustment_amount_cad",
      "origin": "enriched_securities_position.book_value_enterprise_netted_adjustment_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633392,
      "include": true,
      "name": "book_value_amount_enterprise_netted_cad",
      "origin": "enriched_securities_position.book_value_amount_enterprise_netted_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633393,
      "include": true,
      "name": "book_value_enterprise_netted_adjustment_amount",
      "origin": "enriched_securities_position.book_value_enterprise_netted_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633394,
      "include": true,
      "name": "book_value_amount_enterprise_netted",
      "origin": "enriched_securities_position.book_value_amount_enterprise_netted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633395,
      "include": true,
      "name": "book_value_legal_entity_netted_adjustment_amount_cad",
      "origin": "enriched_securities_position.book_value_legal_entity_netted_adjustment_amount_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633396,
      "include": true,
      "name": "book_value_amount_legal_entity_netted_cad",
      "origin": "enriched_securities_position.book_value_amount_legal_entity_netted_cad",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633397,
      "include": true,
      "name": "book_value_legal_entity_netted_adjustment_amount",
      "origin": "enriched_securities_position.book_value_legal_entity_netted_adjustment_amount",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633398,
      "include": true,
      "name": "book_value_amount_legal_entity_netted",
      "origin": "enriched_securities_position.book_value_amount_legal_entity_netted",
      "valueType": "{\"type\":\"BIG_DECIMAL\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633399,
      "include": true,
      "name": "hierarchy_id_enterprise",
      "origin": "enriched_securities_position.hierarchy_id_enterprise",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633400,
      "include": true,
      "name": "hierarchy_id_legal",
      "origin": "enriched_securities_position.hierarchy_id_legal",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633401,
      "include": true,
      "name": "level3_rollup",
      "origin": "enriched_securities_position.level3_rollup",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2633402,
      "include": true,
      "name": "level9_rollup",
      "origin": "enriched_securities_position.level9_rollup",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541455,
      "include": true,
      "name": "business_date",
      "origin": "enriched_securities_position.business_date",
      "pattern": "",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": true,
      "id": 2541456,
      "include": true,
      "name": "au_batch_id",
      "origin": "enriched_securities_position.au_batch_id",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    },
    {
      "acceptEmpty": false,
      "id": 2541457,
      "include": false,
      "name": "dasJobExecutionId",
      "origin": "jobexecutionInfo.id",
      "valueType": "{\"type\":\"INTEGER\"}",
      "version": 3
    },
    {
      "acceptEmpty": false,
      "id": 2541458,
      "include": false,
      "name": "dasJobExecutionStartTime",
      "origin": "jobexecutionInfo.starttime",
      "valueType": "{\"type\":\"STRING\"}",
      "version": 3
    }
  ]
}

Konsta Danyliuk

April 23, 2020 13:59
Hello Thomas.
I hope you are doing fine and staying safe. I'm sorry for the delayed response.

I finally had a chance to set up similar artifacts you have hoping to reproduce the error, but unfortunately with no luck so far. I really need to take a look at the artifacts to say more.

If the issue is still on-going, please log in to https://support.datameer.com/ with your corporate email address and raise a support ticket via Contact Support -> Submit New ticket.
0

Comment actions Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?