Skip to content

Instantly share code, notes, and snippets.

@activated

activated/schema_oracle12c_db.json

Created May 11, 2024 15:24
Show Gist options
  • Save activated/4693515521fba87464ba214fe017b3e9 to your computer and use it in GitHub Desktop.
Save activated/4693515521fba87464ba214fe017b3e9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
schema_oracle12c_db.json
{
"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