Created
May 11, 2024 15:24
-
-
Save activated/4693515521fba87464ba214fe017b3e9 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"tables": [ | |
{ | |
"name": "ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS" | |
}, | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS" | |
}, | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.ACCOUNTS" | |
} | |
], | |
"primaryKey": { | |
"name": "SYS_C0012076", | |
"fields": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS" | |
} | |
] | |
}, | |
"foreignKeys": [ | |
{ | |
"name": "SYS_C0012078", | |
"mapping": { | |
"ORSON_TEST.ACCOUNTS.CUSTOMER_ID": { | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
} | |
} | |
} | |
] | |
}, | |
{ | |
"name": "ACCOUNTS_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "BRANCH_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.ACCOUNTS_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "ACCOUNTS_V3", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "ACCT_CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "EXT_ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "SANCTIONS_FLAG", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "PAYMENT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ACCOUNTS_V3" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "ADDRESSES_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ADDRESSES_V2" | |
}, | |
{ | |
"name": "STREET", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ADDRESSES_V2" | |
}, | |
{ | |
"name": "CITY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ADDRESSES_V2" | |
}, | |
{ | |
"name": "STATE_PROV", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ADDRESSES_V2" | |
}, | |
{ | |
"name": "ZIP_POSTAL", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.ADDRESSES_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "AUTO_KNW_ADDR", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ADDRESS_1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.AUTO_KNW_ADDR" | |
}, | |
{ | |
"name": "PHONE_ALL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.AUTO_KNW_ADDR" | |
}, | |
{ | |
"name": "AREA_CODE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.AUTO_KNW_ADDR" | |
}, | |
{ | |
"name": "PHONE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.AUTO_KNW_ADDR" | |
}, | |
{ | |
"name": "COUNTY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.AUTO_KNW_ADDR" | |
}, | |
{ | |
"name": "CITY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.AUTO_KNW_ADDR" | |
}, | |
{ | |
"name": "STATE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.AUTO_KNW_ADDR" | |
}, | |
{ | |
"name": "ZIP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.AUTO_KNW_ADDR" | |
}, | |
{ | |
"name": "REGION_1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.AUTO_KNW_ADDR" | |
}, | |
{ | |
"name": "REGION_2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.AUTO_KNW_ADDR" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BILLING", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING" | |
}, | |
{ | |
"name": "QTTY_LINES", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.BILLING" | |
}, | |
{ | |
"name": "BILLING_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING" | |
}, | |
{ | |
"name": "MOBILE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING" | |
}, | |
{ | |
"name": "SIM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BILLING_1", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING_1" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING_1" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING_1" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING_1" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING_1" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING_1" | |
}, | |
{ | |
"name": "QTTY_LINES", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.BILLING_1" | |
}, | |
{ | |
"name": "BILLING_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING_1" | |
}, | |
{ | |
"name": "MOBILE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING_1" | |
}, | |
{ | |
"name": "SIM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BILLING_1" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BRANCHES_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "BRANCH_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.BRANCHES_V2" | |
}, | |
{ | |
"name": "BRANCH_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BRANCHES_V2" | |
}, | |
{ | |
"name": "COUNTRY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BRANCHES_V2" | |
}, | |
{ | |
"name": "ACCOUNT_CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BRANCHES_V2" | |
}, | |
{ | |
"name": "GENERAL_LEDGER_ACCT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BRANCHES_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BRANCHES_V3", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BRANCHES_V3" | |
}, | |
{ | |
"name": "BRANCH_NBR", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.BRANCHES_V3" | |
}, | |
{ | |
"name": "BRANCH_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BRANCHES_V3" | |
}, | |
{ | |
"name": "MANAGER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.BRANCHES_V3" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CSV_SPECIAL_CHARS", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "VALUE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CSV_SPECIAL_CHARS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMERS", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
}, | |
{ | |
"name": "CUSTOMER_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
}, | |
{ | |
"name": "HAS_APP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
}, | |
{ | |
"name": "HAS_ONLINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
}, | |
{ | |
"name": "CLIENT_SINCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
} | |
], | |
"primaryKey": { | |
"name": "SYS_C0012077", | |
"fields": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS" | |
} | |
] | |
}, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMERS_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "CUSTOMER_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "ADDRESS1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "ADDRESS2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "HAS_APP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "HAS_ONLINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "CLIENT_SINCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.CUSTOMERS_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMER_DATA", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "CUST_MARKET_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "CUST_NUMBER", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "CUST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "ORG_SOURCE_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "SEG", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "PKT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "SLI", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "UIS_COVERAGES", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "COV_MAP", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "AM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "FM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "LT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "PF", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "ST", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "UDS_COVERAGE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.CUSTOMER_DATA" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMER_HISTORY", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "BAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMER_HISTORY_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "BAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "PIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ADDRESS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "CITY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "STATE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ZIP", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.CUSTOMER_HISTORY_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "DATE_ISSUE_TEST", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DATE_ISSUE_TEST" | |
}, | |
{ | |
"name": "START_DATE", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST.DATE_ISSUE_TEST" | |
}, | |
{ | |
"name": "END_DATE", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST.DATE_ISSUE_TEST" | |
} | |
], | |
"primaryKey": { | |
"name": "DATE_ISSUE_TEST_PK", | |
"fields": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DATE_ISSUE_TEST" | |
} | |
] | |
}, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "DTCC_MASKED_SAMPLE_TOUCH", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "TRADE_SIDE_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_CPTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_CPTY_REBOOK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_CPTY_TOUCH", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_PTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_PTY_REBOOK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_PTY_TOUCH", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_TD_CPTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_TD_PTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ASSETCLASSCD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BLK_CPTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_BRK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_IM", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_IM_BRK_LAG_HRS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_BRK_IM_LAG_HRS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IS_SDAMKT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "REGION", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BKR_MARKET_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BLK_PSET_BRK", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BLK_PTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BUY_SELL_IND_CODE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "COUPON_RATE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "CPTY_BIC", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "CPTY_DTL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "CPTY_LVL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "DEAL_PRICE_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "DEAL_PRICE_CURR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "INSTRUMENT_TYPE_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ISIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MAGR_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MARKET_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MATCH_BLK_TO_MAGR_HRS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MATCH_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "N_DETAILS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "OVERALL_TOUCH_RATE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PARTITION_KEY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PTY_BIC", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PTY_DTL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PTY_LVL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "QTY_BLOCK_TRADE_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "SECURITY_CODE_COUNTRY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "SETTLEMENT_DATE", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_ACCRUED_INTEREST_AMOUNT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_NET_CASH_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_AMT_CURR_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_CURR_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_SHARE_BASIS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TRADE_DATE_TIME_GMT", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "XTS_DAYS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "YIELD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOUCHED", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.DTCC_MASKED_SAMPLE_TOUCH" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "EMPLOYEES", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "EMPLOYEE_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "EMPLOYMENT_NUMBER", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "CUSTOMER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "CUST_NUMBER", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "DOJ", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "BIRTHDAY", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "COV", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "COV_MAP", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "FINEOS_CODE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "PKT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "SLI", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "GENDER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "MARITAL_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "ADDRESS_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "COUNTRY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "ADDRESS_LINE1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "ADDRESS_LINE2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "CITY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "STATE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "ZIPCODE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "TELEPHONE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "EMPLOYMENT_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "RETIRED", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
}, | |
{ | |
"name": "EDOC_JOB_TITLE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EMPLOYEES" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "EXTERNAL_ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EXTERNAL_ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EXTERNAL_ACCOUNTS" | |
}, | |
{ | |
"name": "SANCTIONS_FLAG", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EXTERNAL_ACCOUNTS" | |
}, | |
{ | |
"name": "PAYMENT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.EXTERNAL_ACCOUNTS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "KNW_AUTO_CTY", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ZIP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.KNW_AUTO_CTY" | |
}, | |
{ | |
"name": "COUNTY_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.KNW_AUTO_CTY" | |
}, | |
{ | |
"name": "STATE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.KNW_AUTO_CTY" | |
}, | |
{ | |
"name": "COUNTY_CODE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.KNW_AUTO_CTY" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "LOANS_LEASING", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.LOANS_LEASING" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING" | |
}, | |
{ | |
"name": "ELIGIBLE_FOR_UPGRADE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.LOANS_LEASING" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "LOANS_LEASING_1", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "PIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "ELIGIBLE_FOR_UPGRADE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.LOANS_LEASING_1" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MAIN_FILE", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "CLIENT_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MAIN_FILE" | |
}, | |
{ | |
"name": "CLIENT_SAMPLE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.MAIN_FILE" | |
}, | |
{ | |
"name": "SAMPLE_VARIANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.MAIN_FILE" | |
}, | |
{ | |
"name": "TRADE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.MAIN_FILE" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MOBILE_TEST_DATA", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ENVIRONMENT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "COUNT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "POOLING", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BAN_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "TENURE_CAT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "SOC", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "MSISDN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "PIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "QTTY_LINES", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "MOBILE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ELIGIBLE_FOR_UPGRADE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BILLING_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "SCENARIO", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.MOBILE_TEST_DATA" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "TDF_ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "CUSTID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "ACCTNUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "ACCTTYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.TDF_ACCOUNTS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "TDF_CUSTOMERS", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "CUSTID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "CUSTTYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "CUSTSINCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "FIRSTNAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "LASTNAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "HASAPP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "HASONLINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.TDF_CUSTOMERS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "TRANSACTIONS", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TRANSACTIONS" | |
}, | |
{ | |
"name": "AMOUNT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.TRANSACTIONS" | |
}, | |
{ | |
"name": "TRANSACTION_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.TRANSACTIONS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "UPDATEABLE_ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NO", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.UPDATEABLE_ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.UPDATEABLE_ACCOUNTS" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.UPDATEABLE_ACCOUNTS" | |
} | |
], | |
"primaryKey": { | |
"name": "UPDATEABLE_ACCOUNTS_PK", | |
"fields": [ | |
{ | |
"name": "ACCOUNT_NO", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.UPDATEABLE_ACCOUNTS" | |
} | |
] | |
}, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "V_CUSTOMERS_ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST", | |
"columns": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "CUSTOMER_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "ADDRESS1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "ADDRESS2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "HAS_APP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "HAS_ONLINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "CLIENT_SINCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST.V_CUSTOMERS_ACCOUNTS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS" | |
}, | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS" | |
}, | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.ACCOUNTS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "ACCOUNTS_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "BRANCH_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "ACCOUNTS_V3", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "ACCT_CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "EXT_ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "SANCTIONS_FLAG", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "PAYMENT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ACCOUNTS_V3" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "ADDRESSES_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ADDRESSES_V2" | |
}, | |
{ | |
"name": "STREET", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ADDRESSES_V2" | |
}, | |
{ | |
"name": "CITY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ADDRESSES_V2" | |
}, | |
{ | |
"name": "STATE_PROV", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ADDRESSES_V2" | |
}, | |
{ | |
"name": "ZIP_POSTAL", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.ADDRESSES_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BILLING", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING" | |
}, | |
{ | |
"name": "QTTY_LINES", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.BILLING" | |
}, | |
{ | |
"name": "BILLING_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING" | |
}, | |
{ | |
"name": "MOBILE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING" | |
}, | |
{ | |
"name": "SIM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BILLING_1", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING_1" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING_1" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING_1" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING_1" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING_1" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING_1" | |
}, | |
{ | |
"name": "QTTY_LINES", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.BILLING_1" | |
}, | |
{ | |
"name": "BILLING_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING_1" | |
}, | |
{ | |
"name": "MOBILE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING_1" | |
}, | |
{ | |
"name": "SIM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BILLING_1" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BRANCHES_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "BRANCH_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.BRANCHES_V2" | |
}, | |
{ | |
"name": "BRANCH_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BRANCHES_V2" | |
}, | |
{ | |
"name": "COUNTRY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BRANCHES_V2" | |
}, | |
{ | |
"name": "ACCOUNT_CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BRANCHES_V2" | |
}, | |
{ | |
"name": "GENERAL_LEDGER_ACCT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BRANCHES_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BRANCHES_V3", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BRANCHES_V3" | |
}, | |
{ | |
"name": "BRANCH_NBR", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.BRANCHES_V3" | |
}, | |
{ | |
"name": "BRANCH_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BRANCHES_V3" | |
}, | |
{ | |
"name": "MANAGER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.BRANCHES_V3" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMERS", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS" | |
}, | |
{ | |
"name": "CUSTOMER_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS" | |
}, | |
{ | |
"name": "HAS_APP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.CUSTOMERS" | |
}, | |
{ | |
"name": "HAS_ONLINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.CUSTOMERS" | |
}, | |
{ | |
"name": "CLIENT_SINCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.CUSTOMERS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMERS_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "CUSTOMER_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "ADDRESS1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "ADDRESS2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "HAS_APP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "HAS_ONLINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "CLIENT_SINCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.CUSTOMERS_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMER_DATA", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "CUST_MARKET_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "CUST_NUMBER", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "CUST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "ORG_SOURCE_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "SEG", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "PKT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "SLI", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "UIS_COVERAGES", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "COV_MAP", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "AM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "FM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "LT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "PF", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "ST", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "UDS_COVERAGE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.CUSTOMER_DATA" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMER_HISTORY", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "BAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMER_HISTORY_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "BAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "PIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ADDRESS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "CITY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "STATE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ZIP", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.CUSTOMER_HISTORY_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "DTCC_MASKED_SAMPLE_TOUCH", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "TRADE_SIDE_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_CPTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_CPTY_REBOOK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_CPTY_TOUCH", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_PTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_PTY_REBOOK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_PTY_TOUCH", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_TD_CPTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_TD_PTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ASSETCLASSCD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BLK_CPTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_BRK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_IM", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_IM_BRK_LAG_HRS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_BRK_IM_LAG_HRS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IS_SDAMKT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "REGION", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BKR_MARKET_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BLK_PSET_BRK", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BLK_PTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BUY_SELL_IND_CODE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "COUPON_RATE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "CPTY_BIC", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "CPTY_DTL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "CPTY_LVL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "DEAL_PRICE_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "DEAL_PRICE_CURR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "INSTRUMENT_TYPE_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ISIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MAGR_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MARKET_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MATCH_BLK_TO_MAGR_HRS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MATCH_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "N_DETAILS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "OVERALL_TOUCH_RATE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PARTITION_KEY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PTY_BIC", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PTY_DTL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PTY_LVL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "QTY_BLOCK_TRADE_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "SECURITY_CODE_COUNTRY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "SETTLEMENT_DATE", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_ACCRUED_INTEREST_AMOUNT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_NET_CASH_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_AMT_CURR_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_CURR_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_SHARE_BASIS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TRADE_DATE_TIME_GMT", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "XTS_DAYS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "YIELD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOUCHED", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.DTCC_MASKED_SAMPLE_TOUCH" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "EMPLOYEES", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "EMPLOYEE_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "EMPLOYMENT_NUMBER", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "CUSTOMER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "CUST_NUMBER", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "DOJ", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "BIRTHDAY", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "COV", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "COV_MAP", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "FINEOS_CODE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "PKT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "SLI", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "GENDER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "MARITAL_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "ADDRESS_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "COUNTRY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "ADDRESS_LINE1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "ADDRESS_LINE2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "CITY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "STATE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "ZIPCODE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "TELEPHONE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "EMPLOYMENT_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "RETIRED", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
}, | |
{ | |
"name": "EDOC_JOB_TITLE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EMPLOYEES" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "EXTERNAL_ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EXTERNAL_ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EXTERNAL_ACCOUNTS" | |
}, | |
{ | |
"name": "SANCTIONS_FLAG", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EXTERNAL_ACCOUNTS" | |
}, | |
{ | |
"name": "PAYMENT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.EXTERNAL_ACCOUNTS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "LOANS_LEASING", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.LOANS_LEASING" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING" | |
}, | |
{ | |
"name": "ELIGIBLE_FOR_UPGRADE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.LOANS_LEASING" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "LOANS_LEASING_1", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "PIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "ELIGIBLE_FOR_UPGRADE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.LOANS_LEASING_1" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MAIN_FILE", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "CLIENT_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MAIN_FILE" | |
}, | |
{ | |
"name": "CLIENT_SAMPLE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.MAIN_FILE" | |
}, | |
{ | |
"name": "SAMPLE_VARIANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.MAIN_FILE" | |
}, | |
{ | |
"name": "TRADE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.MAIN_FILE" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MOBILE_TEST_DATA", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ENVIRONMENT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "COUNT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "POOLING", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BAN_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "TENURE_CAT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "SOC", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "MSISDN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "PIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "QTTY_LINES", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "MOBILE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ELIGIBLE_FOR_UPGRADE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BILLING_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "SCENARIO", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.MOBILE_TEST_DATA" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "TDF_ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "CUSTID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "ACCTNUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "ACCTTYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.TDF_ACCOUNTS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "TDF_CUSTOMERS", | |
"catalog": null, | |
"schema": "ORSON_TEST2", | |
"columns": [ | |
{ | |
"name": "CUSTID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "CUSTTYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "CUSTSINCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "FIRSTNAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "LASTNAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST2.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "HASAPP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "HASONLINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST2.TDF_CUSTOMERS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS" | |
}, | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS" | |
}, | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.ACCOUNTS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "ACCOUNTS_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V2" | |
}, | |
{ | |
"name": "BRANCH_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "ACCOUNTS_V3", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "ACCT_CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "EXT_ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "SANCTIONS_FLAG", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V3" | |
}, | |
{ | |
"name": "PAYMENT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ACCOUNTS_V3" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "ADDRESSES_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ADDRESSES_V2" | |
}, | |
{ | |
"name": "STREET", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ADDRESSES_V2" | |
}, | |
{ | |
"name": "CITY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ADDRESSES_V2" | |
}, | |
{ | |
"name": "STATE_PROV", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ADDRESSES_V2" | |
}, | |
{ | |
"name": "ZIP_POSTAL", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.ADDRESSES_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BILLING", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING" | |
}, | |
{ | |
"name": "QTTY_LINES", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.BILLING" | |
}, | |
{ | |
"name": "BILLING_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING" | |
}, | |
{ | |
"name": "MOBILE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING" | |
}, | |
{ | |
"name": "SIM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BILLING_1", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING_1" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING_1" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING_1" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING_1" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING_1" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING_1" | |
}, | |
{ | |
"name": "QTTY_LINES", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.BILLING_1" | |
}, | |
{ | |
"name": "BILLING_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING_1" | |
}, | |
{ | |
"name": "MOBILE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING_1" | |
}, | |
{ | |
"name": "SIM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BILLING_1" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BRANCHES_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "BRANCH_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.BRANCHES_V2" | |
}, | |
{ | |
"name": "BRANCH_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BRANCHES_V2" | |
}, | |
{ | |
"name": "COUNTRY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BRANCHES_V2" | |
}, | |
{ | |
"name": "ACCOUNT_CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BRANCHES_V2" | |
}, | |
{ | |
"name": "GENERAL_LEDGER_ACCT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BRANCHES_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "BRANCHES_V3", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BRANCHES_V3" | |
}, | |
{ | |
"name": "BRANCH_NBR", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.BRANCHES_V3" | |
}, | |
{ | |
"name": "BRANCH_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BRANCHES_V3" | |
}, | |
{ | |
"name": "MANAGER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.BRANCHES_V3" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMERS", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS" | |
}, | |
{ | |
"name": "CUSTOMER_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS" | |
}, | |
{ | |
"name": "HAS_APP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.CUSTOMERS" | |
}, | |
{ | |
"name": "HAS_ONLINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.CUSTOMERS" | |
}, | |
{ | |
"name": "CLIENT_SINCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.CUSTOMERS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMERS_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "CUSTOMER_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "CUSTOMER_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "ADDRESS1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "ADDRESS2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "HAS_APP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "HAS_ONLINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.CUSTOMERS_V2" | |
}, | |
{ | |
"name": "CLIENT_SINCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.CUSTOMERS_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMER_DATA", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "CUST_MARKET_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "CUST_NUMBER", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "CUST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "ORG_SOURCE_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "SEG", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "PKT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "SLI", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "UIS_COVERAGES", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "COV_MAP", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "AM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "FM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "LT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "PF", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "ST", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
}, | |
{ | |
"name": "UDS_COVERAGE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.CUSTOMER_DATA" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMER_HISTORY", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "BAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "CUSTOMER_HISTORY_V2", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "BAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "PIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ADDRESS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "CITY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "STATE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
}, | |
{ | |
"name": "ZIP", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.CUSTOMER_HISTORY_V2" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "DTCC_MASKED_SAMPLE_TOUCH", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "TRADE_SIDE_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_CPTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_CPTY_REBOOK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_CPTY_TOUCH", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_PTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_PTY_REBOOK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_PTY_TOUCH", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_TD_CPTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ALC_TD_PTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ASSETCLASSCD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BLK_CPTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_BRK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_IM", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_IM_BRK_LAG_HRS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IN_FIRST_BRK_IM_LAG_HRS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "IS_SDAMKT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "REGION", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BKR_MARKET_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BLK_PSET_BRK", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BLK_PTY_AMEND", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "BUY_SELL_IND_CODE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "COUPON_RATE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "CPTY_BIC", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "CPTY_DTL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "CPTY_LVL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "DEAL_PRICE_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "DEAL_PRICE_CURR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "INSTRUMENT_TYPE_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "ISIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MAGR_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MARKET_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MATCH_BLK_TO_MAGR_HRS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "MATCH_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "N_DETAILS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "OVERALL_TOUCH_RATE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PARTITION_KEY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PTY_BIC", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PTY_DTL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "PTY_LVL_OBSERVED_CHANGES_TR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "QTY_BLOCK_TRADE_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "SECURITY_CODE_COUNTRY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "SETTLEMENT_DATE", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_ACCRUED_INTEREST_AMOUNT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_NET_CASH_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_AMT_CURR_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_AMT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_CURR_CD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_SHARE_BASIS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOTAL_TRADE_COMM_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TRADE_DATE_TIME_GMT", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "XTS_DAYS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "YIELD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
}, | |
{ | |
"name": "TOUCHED", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.DTCC_MASKED_SAMPLE_TOUCH" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "EMPLOYEES", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "EMPLOYEE_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "EMPLOYMENT_NUMBER", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "CUSTOMER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "CUST_NUMBER", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "DOJ", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "LAST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "FIRST_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "BIRTHDAY", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "COV", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "COV_MAP", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "FINEOS_CODE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "PKT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "SLI", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "GENDER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "MARITAL_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "ADDRESS_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "COUNTRY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "ADDRESS_LINE1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "ADDRESS_LINE2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "CITY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "STATE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "ZIPCODE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "TELEPHONE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "EMPLOYMENT_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "RETIRED", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
}, | |
{ | |
"name": "EDOC_JOB_TITLE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EMPLOYEES" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "EXTERNAL_ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_NUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EXTERNAL_ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EXTERNAL_ACCOUNTS" | |
}, | |
{ | |
"name": "SANCTIONS_FLAG", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EXTERNAL_ACCOUNTS" | |
}, | |
{ | |
"name": "PAYMENT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.EXTERNAL_ACCOUNTS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "LOANS_LEASING", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.LOANS_LEASING" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING" | |
}, | |
{ | |
"name": "ELIGIBLE_FOR_UPGRADE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.LOANS_LEASING" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "LOANS_LEASING_1", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "PIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "ELIGIBLE_FOR_UPGRADE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.LOANS_LEASING_1" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.LOANS_LEASING_1" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MAIN_FILE", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "CLIENT_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MAIN_FILE" | |
}, | |
{ | |
"name": "CLIENT_SAMPLE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MAIN_FILE" | |
}, | |
{ | |
"name": "SAMPLE_VARIANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MAIN_FILE" | |
}, | |
{ | |
"name": "TRADE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MAIN_FILE" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MD_APPLICATIONFILES", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "APPLICATIONS_ID_FK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "URI", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "STATE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "LANGUAGE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "LOC", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "SECURITY_GROUP_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "CREATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "CREATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "UPDATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
}, | |
{ | |
"name": "UPDATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
} | |
], | |
"primaryKey": { | |
"name": "MD_APPLICATIONFILES_PK", | |
"fields": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONFILES" | |
} | |
] | |
}, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MD_APPLICATIONS", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "DESCRIPTION", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "BASE_DIR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "OUTPUT_DIR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "BACKUP_DIR", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "INPLACE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "PROJECT_ID_FK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "SECURITY_GROUP_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "CREATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "CREATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "LAST_UPDATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
}, | |
{ | |
"name": "LAST_UPDATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
} | |
], | |
"primaryKey": { | |
"name": "MD_APPLICATIONS_PK", | |
"fields": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_APPLICATIONS" | |
} | |
] | |
}, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MD_FILE_ARTIFACTS", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "APPLICATIONFILES_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "PATTERN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "STRING_FOUND", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "STRING_REPLACED", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "LINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "PATTERN_START", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "PATTERN_END", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "DUE_DATE", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "DB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "CODE_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "DESCRIPTION", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "PRIORITY", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "SECURITY_GROUP_ID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "CREATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "CREATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "LAST_UPDATED", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
}, | |
{ | |
"name": "LAST_UPDATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
} | |
], | |
"primaryKey": { | |
"name": "MD_FILE_ARTIFACTS_PK", | |
"fields": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_FILE_ARTIFACTS" | |
} | |
] | |
}, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MD_REPOVERSIONS", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "REVISION", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_REPOVERSIONS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MD_TABLESPACES", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
}, | |
{ | |
"name": "SCHEMA_ID_FK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
}, | |
{ | |
"name": "TABLESPACE_NAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
}, | |
{ | |
"name": "NATIVE_SQL", | |
"javaClass": "java.lang.Object", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
}, | |
{ | |
"name": "NATIVE_KEY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
}, | |
{ | |
"name": "COMMENTS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
}, | |
{ | |
"name": "SECURITY_GROUP_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
}, | |
{ | |
"name": "CREATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
}, | |
{ | |
"name": "CREATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
}, | |
{ | |
"name": "LAST_UPDATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
}, | |
{ | |
"name": "LAST_UPDATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
} | |
], | |
"primaryKey": { | |
"name": "MD_TABLESPACES_PK", | |
"fields": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_TABLESPACES" | |
} | |
] | |
}, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MD_USERS", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "SCHEMA_ID_FK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "USERNAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "PASSWORD", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "NATIVE_SQL", | |
"javaClass": "java.lang.Object", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "NATIVE_KEY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "COMMENTS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "SECURITY_GROUP_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "CREATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "CREATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "LAST_UPDATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
}, | |
{ | |
"name": "LAST_UPDATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_USERS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MD_USER_PRIVILEGES", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_USER_PRIVILEGES" | |
}, | |
{ | |
"name": "USER_ID_FK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_USER_PRIVILEGES" | |
}, | |
{ | |
"name": "PRIVILEGE_ID_FK", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_USER_PRIVILEGES" | |
}, | |
{ | |
"name": "SECURITY_GROUP_ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_USER_PRIVILEGES" | |
}, | |
{ | |
"name": "CREATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_USER_PRIVILEGES" | |
}, | |
{ | |
"name": "CREATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_USER_PRIVILEGES" | |
}, | |
{ | |
"name": "LAST_UPDATED_ON", | |
"javaClass": "java.sql.Timestamp", | |
"tableName": "ORSON_TEST3.MD_USER_PRIVILEGES" | |
}, | |
{ | |
"name": "LAST_UDPATED_BY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MD_USER_PRIVILEGES" | |
} | |
], | |
"primaryKey": { | |
"name": "MD_USER_PRIVILEGES_PK", | |
"fields": [ | |
{ | |
"name": "ID", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MD_USER_PRIVILEGES" | |
} | |
] | |
}, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "MOBILE_TEST_DATA", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "ACCOUNT_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ENVIRONMENT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ACCOUNT_SUB_TYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "COUNT", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "POOLING", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BAN_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "TENURE_CAT", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "TENURE_MTHS", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "SUBSCRIBER_STATUS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "CREDIT_CLASS", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "SOC", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "PRICE_PLAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BAN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "MSISDN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "TAX_ID_SSN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "PIN", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ACCOUNT_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "QTTY_LINES", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "MOBILE_NUMBER", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "ELIGIBLE_FOR_UPGRADE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BILLING_SYSTEM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "SCENARIO", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.MOBILE_TEST_DATA" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "TDF_ACCOUNTS", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "CUSTID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "ACCTNUM", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "ACCTTYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "BALANCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "CURRENCY", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.TDF_ACCOUNTS" | |
}, | |
{ | |
"name": "PRINCIPAL", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.TDF_ACCOUNTS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
}, | |
{ | |
"name": "TDF_CUSTOMERS", | |
"catalog": null, | |
"schema": "ORSON_TEST3", | |
"columns": [ | |
{ | |
"name": "CUSTID", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "CUSTTYPE", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "CUSTSINCE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "FIRSTNAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "LASTNAME", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS1", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "ADDRESS2", | |
"javaClass": "java.lang.String", | |
"tableName": "ORSON_TEST3.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "HASAPP", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.TDF_CUSTOMERS" | |
}, | |
{ | |
"name": "HASONLINE", | |
"javaClass": "java.math.BigDecimal", | |
"tableName": "ORSON_TEST3.TDF_CUSTOMERS" | |
} | |
], | |
"primaryKey": null, | |
"foreignKeys": [] | |
} | |
] | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment