---Table scripts for TRADE_ORDER_EMP_ALLOCATION ALTER TABLE TRADE_ORDER_EMP_ALLOCATION DROP PRIMARY KEY CASCADE / DROP TABLE TRADE_ORDER_EMP_ALLOCATION CASCADE CONSTRAINTS / CREATE TABLE TRADE_ORDER_EMP_ALLOCATION ( ID_TRADE_ORDER_EMP_ALLOCATION NUMBER(10) NOT NULL, NM_ARTEMIS_SOURCE_SYSTEM VARCHAR2(30 BYTE), ARTEMIS_SOURCE_SYSTEM_ID VARCHAR2(40 BYTE), ACTIVITY_DT DATE, TRADE_DT DATE, CD_EMPLOYEE_TYPE VARCHAR2(20 BYTE), SID VARCHAR2(20 BYTE), ID_EMPLOYEE_SUB_TYPE NUMBER(10) NOT NULL, CD_BOOK_KEY VARCHAR2(40 BYTE), ID_ARTEMIS_TRADE NUMBER(10), ID_TRADE_ORDER NUMBER(10), ID_ACTIVITY_DATE NUMBER(10) NOT NULL, ID_TRADE_DATE NUMBER(10) NOT NULL, ID_LATEST_ACTIVITY_DATE NUMBER(10) NOT NULL, LATEST_ACTIVITY_DATE DATE, ID_EMPLOYEE_ROLE NUMBER(10) NOT NULL, ID_EMPLOYEE NUMBER(10) NOT NULL, ID_TEAM NUMBER(10) NOT NULL, ID_SECURITY_PRIVILEGE NUMBER(10), TEAM_NODE_ID_0 INTEGER, NM_ALLOCATED_DESK VARCHAR2(100 BYTE), ID_MKTING_DESK NUMBER(10) NOT NULL, ID_CLIENT_ROLE NUMBER(10), AM_BLOCK_LOSS NUMBER(20,8), AM_BLOCK_LOSS_DELTA NUMBER(20,8), AM_BLOCK_LOSS_ASGN NUMBER(20,8), AM_BLOCK_LOSS_ASGN_DELTA NUMBER(20,8), AM_BLOCK_LOSS_ROLE_DELTA NUMBER(20,8), AM_BLOCK_LOSS_X_ROLE_DELTA NUMBER(20,8), AM_SOFT_DOLLAR NUMBER(20,8), AM_SOFT_DOLLAR_DELTA NUMBER(20,8), AM_SOFT_DOLLAR_ASGN_DELTA NUMBER(20,8), AM_SOFT_DOLLAR_ASGN NUMBER(20,8), AM_SOFT_DOLLAR_ROLE_DELTA NUMBER(20,8), AM_SOFT_DOLLAR_X_ROLE_DELTA NUMBER(20,8), AM_NET_CVA NUMBER(20,8), AM_NET_CVA_LOCAL_CURRENCY NUMBER(20,8), AM_NET_CVA_DELTA NUMBER(20,8), AM_NET_CVA_ASGN NUMBER(20,8), AM_NET_CVA_ASGN_DELTA NUMBER(20,8), AM_NET_CVA_ROLE_DELTA NUMBER(20,8), AM_NET_CVA_X_ROLE_DELTA NUMBER(20,8), AM_GROSS_CVA NUMBER(20,8), AM_GROSS_CVA_LOCAL_CURRENCY NUMBER(20,8), AM_GROSS_CVA_DELTA NUMBER(20,8), AM_GROSS_CVA_ASGN NUMBER(20,8), AM_GROSS_CVA_ASGN_DELTA NUMBER(20,8), AM_GROSS_CVA_ROLE_DELTA NUMBER(20,8), AM_GROSS_CVA_X_ROLE_DELTA NUMBER(20,8), AM_CRS NUMBER(20,8), AM_CRS_LOCAL_CURRENCY NUMBER(20,8), AM_CRS_DELTA NUMBER(20,8), AM_CRS_ASGN NUMBER(20,8), AM_CRS_ASGN_DELTA NUMBER(20,8), AM_CRS_ROLE_DELTA NUMBER(20,8), AM_CRS_X_ROLE_DELTA NUMBER(20,8), AM_IMPUTED_COMMISSION NUMBER(20,8), AM_IMPUTED_COMM_DELTA NUMBER(20,8), AM_IMPUTED_COMMISSION_ASGN NUMBER(20,8), AM_IMPUTED_COMM_ASGN_DELTA NUMBER(20,8), AM_IMPUTED_COMM_ROLE_DELTA NUMBER(20,8), AM_IMPUTED_COMM_X_ROLE_DELTA NUMBER(20,8), AM_JPM_COMM NUMBER(20,8), AM_JPM_COMM_DELTA NUMBER(20,8), AM_JPM_COMM_ASGN NUMBER(20,8), AM_JPM_COMM_ASGN_DELTA NUMBER(20,8), AM_JPM_COMM_ROLE_DELTA NUMBER(20,8), AM_JPM_COMM_X_ROLE_DELTA NUMBER(20,8), AM_CREDIT_COST NUMBER(20,8), AM_CREDIT_COST_DELTA NUMBER(20,8), AM_CREDIT_COST_ASGN NUMBER(20,8), AM_CREDIT_COST_ASGN_DELTA NUMBER(20,8), AM_CREDIT_COST_ROLE_DELTA NUMBER(20,8), AM_CREDIT_COST_X_ROLE_DELTA NUMBER(20,8), AM_INVESTOR_ATTRIB NUMBER(20,8), AM_INVESTOR_ATTRIB_DELTA NUMBER(20,8), AM_INVESTOR_ATTRIB_ASGN NUMBER(20,8), AM_INVESTOR_ATTRIB_ASGN_DELTA NUMBER(20,8), AM_INVESTOR_ATTRIB_ROLE_DELTA NUMBER(20,8), AM_INVESTOR_ATTRIB_X_ROLE_DELT NUMBER(20,8), AM_FX_HARD_MARKUP NUMBER(20,8), AM_FX_HARD_MARKUP_DELTA NUMBER(20,8), AM_FX_HARD_MARKUP_ASGN NUMBER(20,8), AM_FX_HARD_MARKUP_ASGN_DELTA NUMBER(20,8), AM_FX_HARD_MARKUP_ROLE_DELTA NUMBER(20,8), AM_FX_HARD_MARKUP_X_ROLE_DELTA NUMBER(20,8), AM_FX_CREDIT_CHARGE NUMBER(20,8), AM_FX_CREDIT_CHARGE_DELTA NUMBER(20,8), AM_FX_CREDIT_CHARGE_ASGN NUMBER(20,8), AM_FX_CREDIT_CHARGE_ASGN_DELTA NUMBER(20,8), AM_FX_CREDIT_CHARGE_ROLE_DELTA NUMBER(20,8), AM_FX_CREDIT_CHARGE_X_ROLE_DEL NUMBER(20,8), AM_FX_INPV NUMBER(20,8), AM_FX_INPV_DELTA NUMBER(20,8), AM_FX_INPV_ASGN NUMBER(20,8), AM_FX_INPV_ASGN_DELTA NUMBER(20,8), AM_FX_INPV_ROLE_DELTA NUMBER(20,8), AM_FX_INPV_X_ROLE_DELTA NUMBER(20,8), AM_FX_CORP_MARKUP NUMBER(20,8), AM_FX_CORP_MARKUP_DELTA NUMBER(20,8), AM_FX_CORP_MARKUP_ASGN NUMBER(20,8), AM_FX_CORP_MARKUP_ASGN_DELTA NUMBER(20,8), AM_FX_CORP_MARKUP_ROLE_DELTA NUMBER(20,8), AM_FX_CORP_MARKUP_X_ROLE_DELTA NUMBER(20,8), AM_BID_OFFER_SPREAD NUMBER(20,8), AM_BID_OFFER_SPREAD_DELTA NUMBER(20,8), AM_BID_OFFER_SPREAD_ASGN NUMBER(20,8), AM_BID_OFFER_SPREAD_ASGN_DELTA NUMBER(20,8), AM_BID_OFFER_SPREAD_ROLE_DELTA NUMBER(20,8), AM_BID_OFFER_SPREAD_X_ROLE_DEL NUMBER(20,8), AM_REVENUE_BO_INPV NUMBER(20,8), AM_REVENUE_BO_INPV_DELTA NUMBER(20,8), AM_REVENUE_BO_INPV_ASGN NUMBER(20,8), AM_REVENUE_BO_INPV_ASGN_DELTA NUMBER(20,8), AM_REVENUE_BO_INPV_ROLE_DELTA NUMBER(20,8), AM_REVENUE_BO_INPV_X_ROLE_DELT NUMBER(20,8), AM_BONUS NUMBER(20,8), AM_BONUS_DELTA NUMBER(20,8), AM_BONUS_ASGN NUMBER(20,8), AM_BONUS_ASGN_DELTA NUMBER(20,8), AM_BONUS_ROLE_DELTA NUMBER(20,8), AM_BONUS_X_ROLE_DELTA NUMBER(20,8), AM_MARKUP NUMBER(20,8), AM_MARKUP_DELTA NUMBER(20,8), AM_MARKUP_ASGN NUMBER(20,8), AM_MARKUP_ASGN_DELTA NUMBER(20,8), AM_MARKUP_ROLE_DELTA NUMBER(20,8), AM_MARKUP_X_ROLE_DELTA NUMBER(20,8), AM_INPV_ORIG NUMBER(20,8), AM_INPV_ORIG_DELTA NUMBER(20,8), AM_INPV_ORIG_ASGN NUMBER(20,8), AM_INPV_ORIG_ASGN_DELTA NUMBER(20,8), AM_INPV_ORIG_ROLE_DELTA NUMBER(20,8), AM_INPV_ORIG_X_ROLE_DELTA NUMBER(20,8), AM_FEES NUMBER(20,8), AM_FEES_DELTA NUMBER(20,8), AM_FEES_ASGN NUMBER(20,8), AM_FEES_ASGN_DELTA NUMBER(20,8), AM_FEES_ROLE_DELTA NUMBER(20,8), AM_FEES_X_ROLE_DELTA NUMBER(20,8), AM_RESERVE NUMBER(20,8), AM_RESERVE_DELTA NUMBER(20,8), AM_RESERVE_ASGN NUMBER(20,8), AM_RESERVE_ASGN_DELTA NUMBER(20,8), AM_RESERVE_ROLE_DELTA NUMBER(20,8), AM_RESERVE_X_ROLE_DELTA NUMBER(20,8), AM_FX_RATE NUMBER(20,8), AM_USD_PRINCIPAL NUMBER(20,8), AM_USD_PRINCIPAL_DELTA NUMBER(20,8), AM_USD_PRINCIPAL_ROLE_DELTA NUMBER(20,8), AM_USD_PRINCIPAL_X_ROLE_DELTA NUMBER(20,8), NUM_TRADE_QTY NUMBER(15), NUM_TRADE_QTY_DELTA NUMBER(15), NUM_TRADE_QTY_ROLE_DELTA NUMBER(20,8), NUM_TRADE_QTY_X_ROLE_DELTA NUMBER(20,8), NUM_ORDERS NUMBER(10), NUM_ORDERS_DELTA NUMBER(10), NUM_ORDERS_ROLE_DELTA NUMBER(20,8), NUM_ORDERS_X_ROLE_DELTA NUMBER(20,8), AM_USD_PRICE NUMBER(20,8), AM_USD_PRICE_DELTA NUMBER(20,8), AM_USD_PRICE_ROLE_DELTA NUMBER(20,8), AM_USD_PRICE_X_ROLE_DELTA NUMBER(20,8), ID_BATCH NUMBER(10) NOT NULL, IND_IS_RECORD_LOADED_SUCESSFUL CHAR(1 BYTE), IND_IS_BAD_RECORD CHAR(1 BYTE), IND_IS_RECENT CHAR(1 BYTE), TXT_EXCEPTION VARCHAR2(2000 BYTE), CD_PROCESSING_STATUS VARCHAR2(5 BYTE), IND_IS_DELETED CHAR(1 BYTE), IND_IS_MASK VARCHAR2(1 BYTE), DT_UPSTREAM_PROCESSED DATE, AM_OUTBOUND_SHARE NUMBER(20,8), AM_OUTBOUND_SHARE_ASGN NUMBER(20,8), AM_OUTBOUND_SHARE_ASGN_DELTA NUMBER(20,8), AM_OUTBOUND_SHARE_DELTA NUMBER(20,8), AM_OUTBOUND_SHARE_ROLE_DELTA NUMBER(20,8), AM_OUTBOUND_SHARE_X_ROLE_DELTA NUMBER(20,8), AM_INBOUND_SHARE NUMBER(20,8), AM_INBOUND_SHARE_ASGN NUMBER(20,8), AM_INBOUND_SHARE_ASGN_DELTA NUMBER(20,8), AM_INBOUND_SHARE_DELTA NUMBER(20,8), AM_INBOUND_SHARE_ROLE_DELTA NUMBER(20,8), AM_INBOUND_SHARE_X_ROLE_DELTA NUMBER(20,8), NUM_SECURITY_PRIV NUMBER(10), ID_BOOK NUMBER(10), ID_CTRY NUMBER(10), IND_IS_ACTIVE_EMPLOYEE VARCHAR2(1 BYTE), AM_CVA_LOCAL_CCY_ASGN NUMBER(20,8), AM_CVA_LOCAL_CCY_ASGN_DELT NUMBER(20,8), AM_CRS_LOCAL_CCY_ASGN NUMBER(20,8), AM_CRS_LOCAL_CCY_ASGN_DELT NUMBER(20,8), AM_BROKER_COMM NUMBER(20,8), AM_BROKER_COMM_ASGN NUMBER(20,8), AM_BROKER_COMM_ASGN_DELTA NUMBER(20,8), AM_BROKER_COMM_DELTA NUMBER(20,8), AM_TAX_STAMP_AMOUNT NUMBER(20,8), AM_TAX_STAMP_AMOUNT_ASGN NUMBER(20,8), AM_TAX_STAMP_AMOUNT_ASGN_DELTA NUMBER(20,8), AM_TAX_STAMP_AMOUNT_DELTA NUMBER(20,8), AM_BASIS_POINT_VAL NUMBER(20,8), AM_BASIS_POINT_VAL_DELTA NUMBER(20,8), AM_BASIS_POINT_VAL_ASGN NUMBER(20,8), AM_BASIS_POINT_VAL_ASGN_DELTA NUMBER(20,8), AM_HEADLINE_NOTNL NUMBER(20,8), AM_HEADLINE_NOTNL_DELTA NUMBER(20,8), AM_HEADLINE_NOTNL_ROLE_DELTA NUMBER(20,8), AM_HEADLINE_NOTNL_X_ROLE_DELTA NUMBER(20,8), AM_RETAIN_SHARE NUMBER(20,8), AM_RETAIN_SHARE_DELTA NUMBER(20,8), AM_RETAIN_SHARE_ASGN NUMBER(20,8), AM_RETAIN_SHARE_ASGN_DELTA NUMBER(20,8), AM_RETAIN_SHARE_ROLE_DELTA NUMBER(20,8), AM_RETAIN_SHARE_X_ROLE_DELTA NUMBER(20,8), NAPOLI_ID VARCHAR2(32 BYTE), ID_EMPLOYEE_LE_OU NUMBER(10), AM_EMP_ALLOC_PER NUMBER(20,8), AM_ERR_CV_ADJUST_ASGN NUMBER(20,8), AM_ERR_CV_ADJUST_ASGN_DELTA NUMBER(20,8), AM_ERR_CV_INFO_ASGN NUMBER(20,8), AM_ERR_CV_INFO_ASGN_DELTA NUMBER(20,8), AM_DEFAULTCV_CCY_ASGN NUMBER(20,8), AM_DEFAULTCV_CCY_ASGN_DELTA NUMBER(20,8), AM_DEFAULTCV_USD_ASGN NUMBER(20,8), AM_DEFAULTCV_USD_ASGN_DELTA NUMBER(20,8), AM_OVERRIDECV_CCY_ASGN NUMBER(20,8), AM_OVERRIDECV_CCY_ASGN_DELTA NUMBER(20,8), AM_OVERRIDECV_USD_ASGN NUMBER(20,8), AM_OVERRIDECV_USD_ASGN_DELTA NUMBER(20,8), AM_MARKCV_CCY_ASGN NUMBER(20,8), AM_MARKCV_CCY_ASGN_DELTA NUMBER(20,8), AM_MARKCV_USD_ASGN NUMBER(20,8), AM_MARKCV_USD_ASGN_DELTA NUMBER(20,8), AM_FORW_VOL_CR NUMBER(20,8), AM_FORW_VOL_CR_DELTA NUMBER(20,8), AM_FORW_VOL_CR_ASGN NUMBER(20,8), AM_FORW_VOL_CR_ASGN_DELTA NUMBER(20,8), AM_FORW_VOL_ROLE_DELTA NUMBER(20,8), AM_FORW_X_ROLE_DELTA NUMBER(20,8), IND_TO_BE_DELETED_EXISTING VARCHAR2(1 BYTE) ) PARTITION BY RANGE (ARTEMIS_SOURCE_SYSTEM_ID) ( PARTITION PART_MIN VALUES LESS THAN ('0') LOGGING, PARTITION PART_00 VALUES LESS THAN ('1') LOGGING, PARTITION PART_01 VALUES LESS THAN ('2') LOGGING, PARTITION PART_02 VALUES LESS THAN ('3') LOGGING, PARTITION PART_03 VALUES LESS THAN ('4') LOGGING, PARTITION PART_04 VALUES LESS THAN ('5') LOGGING, PARTITION PART_05 VALUES LESS THAN ('6') LOGGING, PARTITION PART_06 VALUES LESS THAN ('7') LOGGING, PARTITION PART_07 VALUES LESS THAN ('8') LOGGING, PARTITION PART_08 VALUES LESS THAN ('9') LOGGING, PARTITION PART_09 VALUES LESS THAN ('A') LOGGING, PARTITION PART_10 VALUES LESS THAN ('K') LOGGING, PARTITION PART_11 VALUES LESS THAN ('L') LOGGING, PARTITION PART_12 VALUES LESS THAN ('P') LOGGING, PARTITION PART_13 VALUES LESS THAN ('U') LOGGING, PARTITION PART_14 VALUES LESS THAN ('Z') LOGGING, PARTITION PART_15 VALUES LESS THAN ('f') LOGGING, PARTITION PART_16 VALUES LESS THAN ('l') LOGGING, PARTITION PART_17 VALUES LESS THAN ('p') LOGGING, PARTITION PART_18 VALUES LESS THAN ('u') LOGGING, PARTITION PART_19 VALUES LESS THAN ('z') LOGGING, PARTITION PART_MAX VALUES LESS THAN (MAXVALUE) LOGGING ) NOCOMPRESS NOCACHE PARALLEL ( DEGREE 8 INSTANCES 1 ) MONITORING ENABLE ROW MOVEMENT / CREATE UNIQUE INDEX XAK1TRADE_ORDER_EMP_ALLOCATION ON TRADE_ORDER_EMP_ALLOCATION (ARTEMIS_SOURCE_SYSTEM_ID, CD_BOOK_KEY, NM_ARTEMIS_SOURCE_SYSTEM, ACTIVITY_DT, TRADE_DT, CD_EMPLOYEE_TYPE, ID_EMPLOYEE_SUB_TYPE, SID) LOCAL ( PARTITION PART_MIN LOGGING, PARTITION PART_00 LOGGING, PARTITION PART_01 LOGGING, PARTITION PART_02 LOGGING, PARTITION PART_03 LOGGING, PARTITION PART_04 LOGGING, PARTITION PART_05 LOGGING, PARTITION PART_06 LOGGING, PARTITION PART_07 LOGGING, PARTITION PART_08 LOGGING, PARTITION PART_09 LOGGING, PARTITION PART_10 LOGGING, PARTITION PART_11 LOGGING, PARTITION PART_12 LOGGING, PARTITION PART_13 LOGGING, PARTITION PART_14 LOGGING, PARTITION PART_15 LOGGING, PARTITION PART_16 LOGGING, PARTITION PART_17 LOGGING, PARTITION PART_18 LOGGING, PARTITION PART_19 LOGGING, PARTITION PART_MAX LOGGING ) PARALLEL ( DEGREE 8 INSTANCES 1 ) / CREATE UNIQUE INDEX IDX_TOEA_PK ON TRADE_ORDER_EMP_ALLOCATION (ID_TRADE_ORDER_EMP_ALLOCATION) LOGGING NOPARALLEL / CREATE INDEX XIE4TRADE_ORDER_EMP_ALLOCATION ON TRADE_ORDER_EMP_ALLOCATION (ID_ARTEMIS_TRADE) GLOBAL PARTITION BY RANGE (ID_ARTEMIS_TRADE) ( PARTITION IND_PART_01 VALUES LESS THAN (5000000) NOLOGGING, PARTITION IND_PART_02 VALUES LESS THAN (10000000) NOLOGGING, PARTITION IND_PART_03 VALUES LESS THAN (15000000) NOLOGGING, PARTITION IND_PART_04 VALUES LESS THAN (20000000) NOLOGGING, PARTITION IND_PART_05 VALUES LESS THAN (25000000) NOLOGGING, PARTITION IND_PART_06 VALUES LESS THAN (30000000) NOLOGGING, PARTITION IND_PART_07 VALUES LESS THAN (35000000) NOLOGGING, PARTITION IND_PART_08 VALUES LESS THAN (40000000) NOLOGGING, PARTITION IND_PART_09 VALUES LESS THAN (45000000) NOLOGGING, PARTITION IND_PART_10 VALUES LESS THAN (50000000) NOLOGGING, PARTITION IND_PART_11 VALUES LESS THAN (55000000) NOLOGGING, PARTITION IND_PART_12 VALUES LESS THAN (60000000) NOLOGGING, PARTITION IND_PART_13 VALUES LESS THAN (65000000) NOLOGGING, PARTITION IND_PART_14 VALUES LESS THAN (70000000) NOLOGGING, PARTITION IND_PART_15 VALUES LESS THAN (75000000) NOLOGGING, PARTITION IND_PART_16 VALUES LESS THAN (80000000) NOLOGGING, PARTITION IND_PART_17 VALUES LESS THAN (85000000) NOLOGGING, PARTITION IND_PART_18 VALUES LESS THAN (90000000) NOLOGGING, PARTITION IND_PART_MAX VALUES LESS THAN (MAXVALUE) NOLOGGING ) PARALLEL ( DEGREE 4 INSTANCES 1 ) / CREATE BITMAP INDEX XIE2TRADE_ORDER_EMP_ALLOCATION ON TRADE_ORDER_EMP_ALLOCATION (CD_PROCESSING_STATUS) LOCAL ( PARTITION PART_MIN LOGGING, PARTITION PART_00 LOGGING, PARTITION PART_01 LOGGING, PARTITION PART_02 LOGGING, PARTITION PART_03 LOGGING, PARTITION PART_04 LOGGING, PARTITION PART_05 LOGGING, PARTITION PART_06 LOGGING, PARTITION PART_07 LOGGING, PARTITION PART_08 LOGGING, PARTITION PART_09 LOGGING, PARTITION PART_10 LOGGING, PARTITION PART_11 LOGGING, PARTITION PART_12 LOGGING, PARTITION PART_13 LOGGING, PARTITION PART_14 LOGGING, PARTITION PART_15 LOGGING, PARTITION PART_16 LOGGING, PARTITION PART_17 LOGGING, PARTITION PART_18 LOGGING, PARTITION PART_19 LOGGING, PARTITION PART_MAX LOGGING ) PARALLEL ( DEGREE 8 INSTANCES 1 ) / CREATE BITMAP INDEX XIE5TRADE_ORDER_EMP_ALLOCATION ON TRADE_ORDER_EMP_ALLOCATION (ID_BATCH) LOCAL ( PARTITION PART_MIN LOGGING, PARTITION PART_00 LOGGING, PARTITION PART_01 LOGGING, PARTITION PART_02 LOGGING, PARTITION PART_03 LOGGING, PARTITION PART_04 LOGGING, PARTITION PART_05 LOGGING, PARTITION PART_06 LOGGING, PARTITION PART_07 LOGGING, PARTITION PART_08 LOGGING, PARTITION PART_09 LOGGING, PARTITION PART_10 LOGGING, PARTITION PART_11 LOGGING, PARTITION PART_12 LOGGING, PARTITION PART_13 LOGGING, PARTITION PART_14 LOGGING, PARTITION PART_15 LOGGING, PARTITION PART_16 LOGGING, PARTITION PART_17 LOGGING, PARTITION PART_18 LOGGING, PARTITION PART_19 LOGGING, PARTITION PART_MAX LOGGING ) PARALLEL ( DEGREE 8 INSTANCES 1 ) / CREATE BITMAP INDEX XIE1TRADE_ORDER_EMP_ALLOCATION ON TRADE_ORDER_EMP_ALLOCATION (IND_IS_BAD_RECORD) LOCAL ( PARTITION PART_MIN LOGGING, PARTITION PART_00 LOGGING, PARTITION PART_01 LOGGING, PARTITION PART_02 LOGGING, PARTITION PART_03 LOGGING, PARTITION PART_04 LOGGING, PARTITION PART_05 LOGGING, PARTITION PART_06 LOGGING, PARTITION PART_07 LOGGING, PARTITION PART_08 LOGGING, PARTITION PART_09 LOGGING, PARTITION PART_10 LOGGING, PARTITION PART_11 LOGGING, PARTITION PART_12 LOGGING, PARTITION PART_13 LOGGING, PARTITION PART_14 LOGGING, PARTITION PART_15 LOGGING, PARTITION PART_16 LOGGING, PARTITION PART_17 LOGGING, PARTITION PART_18 LOGGING, PARTITION PART_19 LOGGING, PARTITION PART_MAX LOGGING ) PARALLEL ( DEGREE 8 INSTANCES 1 ) / CREATE INDEX XIE7TRADE_ORDER_EMP_ALLOCATION ON TRADE_ORDER_EMP_ALLOCATION (ID_EMPLOYEE, TRADE_DT) LOCAL ( PARTITION PART_MIN LOGGING, PARTITION PART_00 LOGGING, PARTITION PART_01 LOGGING, PARTITION PART_02 LOGGING, PARTITION PART_03 LOGGING, PARTITION PART_04 LOGGING, PARTITION PART_05 LOGGING, PARTITION PART_06 LOGGING, PARTITION PART_07 LOGGING, PARTITION PART_08 LOGGING, PARTITION PART_09 LOGGING, PARTITION PART_10 LOGGING, PARTITION PART_11 LOGGING, PARTITION PART_12 LOGGING, PARTITION PART_13 LOGGING, PARTITION PART_14 LOGGING, PARTITION PART_15 LOGGING, PARTITION PART_16 LOGGING, PARTITION PART_17 LOGGING, PARTITION PART_18 LOGGING, PARTITION PART_19 LOGGING, PARTITION PART_MAX LOGGING ) PARALLEL ( DEGREE 8 INSTANCES 1 ) / CREATE BITMAP INDEX TRADE_ORDER_EMP_ALLOC_TEAM_IDX ON TRADE_ORDER_EMP_ALLOCATION (ID_TEAM) LOCAL ( PARTITION PART_MIN LOGGING, PARTITION PART_00 LOGGING, PARTITION PART_01 LOGGING, PARTITION PART_02 LOGGING, PARTITION PART_03 LOGGING, PARTITION PART_04 LOGGING, PARTITION PART_05 LOGGING, PARTITION PART_06 LOGGING, PARTITION PART_07 LOGGING, PARTITION PART_08 LOGGING, PARTITION PART_09 LOGGING, PARTITION PART_10 LOGGING, PARTITION PART_11 LOGGING, PARTITION PART_12 LOGGING, PARTITION PART_13 LOGGING, PARTITION PART_14 LOGGING, PARTITION PART_15 LOGGING, PARTITION PART_16 LOGGING, PARTITION PART_17 LOGGING, PARTITION PART_18 LOGGING, PARTITION PART_19 LOGGING, PARTITION PART_MAX LOGGING ) PARALLEL ( DEGREE 8 INSTANCES 1 ) / CREATE INDEX XIE3TRADE_ORDER_EMP_ALLOCATION ON TRADE_ORDER_EMP_ALLOCATION (ID_TRADE_ORDER) NOLOGGING PARALLEL ( DEGREE DEFAULT INSTANCES DEFAULT ) / ALTER TABLE TRADE_ORDER_EMP_ALLOCATION ADD ( CONSTRAINT IDX_TOEA_PK PRIMARY KEY (ID_TRADE_ORDER_EMP_ALLOCATION)) / ALTER TABLE TRADE_ORDER_EMP_ALLOCATION ADD ( FOREIGN KEY (ID_EMPLOYEE_ROLE) REFERENCES REF_STA_EMPLOYEE_ROLE (ID_EMPLOYEE_ROLE)) / ALTER TABLE TRADE_ORDER_EMP_ALLOCATION ADD ( FOREIGN KEY (ID_MKTING_DESK) REFERENCES STAGE_ALLOCATED_MKTING_DESK (ID_MKTING_DESK)) / ALTER TABLE TRADE_ORDER_EMP_ALLOCATION ADD ( FOREIGN KEY (ID_LATEST_ACTIVITY_DATE) REFERENCES STAGE_DATE (ID_DATE)) / ALTER TABLE TRADE_ORDER_EMP_ALLOCATION ADD ( FOREIGN KEY (ID_TRADE_DATE) REFERENCES STAGE_DATE (ID_DATE)) / ALTER TABLE TRADE_ORDER_EMP_ALLOCATION ADD ( FOREIGN KEY (ID_EMPLOYEE) REFERENCES STAGE_EMPLOYEE (ID_EMPLOYEE)) / ALTER TABLE TRADE_ORDER_EMP_ALLOCATION ADD ( FOREIGN KEY (ID_ACTIVITY_DATE) REFERENCES STAGE_DATE (ID_DATE)) / ALTER TABLE TRADE_ORDER_EMP_ALLOCATION ADD ( FOREIGN KEY (ID_EMPLOYEE_SUB_TYPE) REFERENCES REF_STA_EMPLOYEE_SUB_TYPE (ID_EMPLOYEE_SUB_TYPE)) / ALTER TABLE TRADE_ORDER_EMP_ALLOCATION ADD ( FOREIGN KEY (ID_CLIENT_ROLE) REFERENCES STAGE_CLIENT_ROLE (ID_CLIENT_ROLE)) / -------------------------------------------------------------------------------------------- ---Table scripts for LOAD_TRADE_ORDER DROP TABLE LOAD_TRADE_ORDER CASCADE CONSTRAINTS / CREATE TABLE LOAD_TRADE_ORDER ( NM_ARTEMIS_SOURCE_SYSTEM VARCHAR2(30 BYTE), ARTEMIS_SOURCE_SYSTEM_ID VARCHAR2(40 BYTE), ACTIVITY_DT DATE, CD_BOOK_KEY VARCHAR2(40 BYTE), TRADE_DT DATE, SETTLEMENT_DT DATE, AUXILIARY_ID VARCHAR2(50 BYTE), FEED_LEADING_SOURCE_SYSTEM_ID VARCHAR2(100 BYTE), FEED_NM_LEADING_SOURCE_SYSTEM VARCHAR2(40 BYTE), FEED_INT_SOURCE_SYSTEM_ID VARCHAR2(100 BYTE), CD_BOOK VARCHAR2(40 BYTE), IS_BUY_OR_SELL VARCHAR2(1 BYTE), IND_CANCEL VARCHAR2(1 BYTE), CD_TRANSACTION_TYPE VARCHAR2(40 BYTE), IND_RISK VARCHAR2(1 BYTE), NUM_PRICE_PERCENT NUMBER(20,8), AM_LOCAL_PRICE NUMBER(20,8), AM_USD_PRICE NUMBER(20,8), AM_LOCAL_PRINCIPAL NUMBER(35,8), AM_USD_PRINCIPAL NUMBER(20,8), NUM_ORDERS NUMBER(10), NUM_TRADE_QTY NUMBER(15), NUM_AGENCY_SHARES NUMBER(15), NUM_MIXED_SHARES NUMBER(15), NUM_PRINCIPAL_SHARES NUMBER(15), NUM_RISKLESS_SHARES NUMBER(15), CD_RISK VARCHAR2(40 BYTE), NM_TRADE_QUALITY VARCHAR2(40 BYTE), AM_PRINCIPAL_COMMIT NUMBER(20,8), CD_MARKET_TYPE VARCHAR2(40 BYTE), CD_SECONDARY_MARKET_TYPE VARCHAR2(40 BYTE), NM_BUSINESS VARCHAR2(100 BYTE), CD_TRADE_CURRENCY VARCHAR2(3 BYTE), CD_APPROPRIATE_CLASS VARCHAR2(40 BYTE), REPO_ON_DT DATE, REPO_OFF_DT DATE, REPORTING_DATE DATE, ARRANGING_DESK_LE_ID VARCHAR2(4 BYTE), ARRANGING_DESK_OU_ID VARCHAR2(6 BYTE), TRADING_DESK_LE_ID VARCHAR2(4 BYTE), TRADING_DESK_OU_ID VARCHAR2(6 BYTE), NM_EXCHANGE VARCHAR2(100 BYTE), CD_SERVICE_TYPE VARCHAR2(40 BYTE), CD_COMPETITOR_CLASS VARCHAR2(40 BYTE), CD_TOKYO_CLASS VARCHAR2(40 BYTE), CD_CAPTIVE_CLASS VARCHAR2(40 BYTE), CD_MUNICIPAL_CLASS VARCHAR2(40 BYTE), CD_CLIENT_ROLE VARCHAR2(40 BYTE), CD_BROKER_CLASS VARCHAR2(40 BYTE), CD_TRADE_TYPE_CLASS VARCHAR2(40 BYTE), IND_IS_REVENUE_SHARED VARCHAR2(1 BYTE), AM_REVENUE_SHARE NUMBER(20,8), CD_MARKETER_CLASS VARCHAR2(40 BYTE), AM_BUY_NOMINAL NUMBER(35,8), AM_SELL_NOMINAL NUMBER(35,8), CD_BUY_CURRENCY VARCHAR2(3 BYTE), CD_SELL_CURRENCY VARCHAR2(3 BYTE), AM_BUY_SELL_FX_RATE NUMBER(20,8), CD_COMPETITIVE_CLASS VARCHAR2(40 BYTE), AM_FX_RATE NUMBER(20,8), TXT_REMARKS VARCHAR2(255 BYTE), NM_EXECUTING_DESK VARCHAR2(100 BYTE), NM_ORIGINATING_DESK VARCHAR2(100 BYTE), NM_PL_DESK VARCHAR2(100 BYTE), NM_PORTFOLIO VARCHAR2(100 BYTE), NM_PORTFOLIO_COUNTRY VARCHAR2(40 BYTE), MATURITY_DT DATE, FEED_INSTRUMENT_ID NUMBER(10), ISIN VARCHAR2(80 BYTE), CD_OPTION_CLASS VARCHAR2(40 BYTE), NM_SECURITY VARCHAR2(100 BYTE), TICKER VARCHAR2(80 BYTE), CD_COMPOSITE_PRODUCT_TYPE VARCHAR2(20 BYTE), PRODUCT_LEVEL_0 VARCHAR2(100 BYTE), REGION_LEVEL_1 VARCHAR2(100 BYTE), INSTRUMENT_ISSUE_DT DATE, INSTRUMENT_COUPON_RATE NUMBER(20,10), SP_INSTRUMENT_RATING VARCHAR2(20 BYTE), MOODY_INSTRUMENT_RATING VARCHAR2(20 BYTE), INSTRUMENT_ISSUER_SPN VARCHAR2(20 BYTE), CD_ETRADE_PLATFORM VARCHAR2(40 BYTE), IND_ETRADE VARCHAR2(1 BYTE), NUM_ELECTRONIC_SHARES NUMBER(20,5), NUM_MANUAL_SHARES NUMBER(20,5), NUM_ELECTRONIC_ORDERS NUMBER(20,5), NUM_MANUAL_ORDERS NUMBER(20,5), CASS_II_ID VARCHAR2(20 BYTE), CAS_ID VARCHAR2(20 BYTE), SPN_ID VARCHAR2(20 BYTE), CNT_PRTY_SPN_CLIENT_ID VARCHAR2(20 BYTE), ACRONYM VARCHAR2(40 BYTE), IND_IS_ACRONYM_PRIMARY CHAR(1 BYTE), UCN VARCHAR2(40 BYTE), AM_GROSS_CVA NUMBER(20,8), AM_GROSS_CVA_LOCAL_CURRENCY NUMBER(20,8), AM_BLOCK_LOSS NUMBER(20,8), AM_SOFT_DOLLAR NUMBER(20,8), AM_NET_CVA NUMBER(20,8), AM_NET_CVA_LOCAL_CURRENCY NUMBER(20,8), AM_CRS NUMBER(20,8), AM_CRS_LOCAL_CURRENCY NUMBER(20,8), AM_IMPUTED_COMMISSION NUMBER(20,8), AM_JPM_COMM NUMBER(20,8), AM_CREDIT_COST NUMBER(20,8), AM_INVESTOR_ATTRIB NUMBER(20,8), AM_FX_HARD_MARKUP NUMBER(20,8), AM_FX_CREDIT_CHARGE NUMBER(20,8), AM_FX_INPV NUMBER(20,8), AM_FX_CORPORATE_MARKUP NUMBER(20,8), AM_REVENUE_BO_INPV NUMBER(20,8), AM_BID_OFFER_SPREAD NUMBER(20,8), AM_BONUS NUMBER(20,8), AM_MARKUP NUMBER(20,8), AM_INPV_ORIG NUMBER(20,8), AM_FEES NUMBER(20,8), AM_RESERVE NUMBER(20,8), FEED_NM_INT_SOURCE_SYSTEM VARCHAR2(40 BYTE), AM_OUTBOUND_SHARE NUMBER(20,8), AM_INBOUND_SHARE NUMBER(20,8), IND_IS_ASIA_CLASS VARCHAR2(40 BYTE), ID_INITIATOR NUMBER(10), ID_TRADER_1 NUMBER(10), ID_TRADER_2 NUMBER(10), ID_TRADER_3 NUMBER(10), ID_TRADER_4 NUMBER(10), NUM_SECURITY_PRIV NUMBER(10), ID_ACTIVITY_DATE NUMBER(10), ID_TRADE_DATE NUMBER(10), ID_REPORTING_DATE NUMBER(10), ID_INDICATOR NUMBER(10), ID_MASKED_INDICATOR NUMBER(10), ID_ETRADE_PLATFORM NUMBER(10), ID_INT_SOURCE_SYSTEM NUMBER(10), ID_SOURCE_SYSTEM NUMBER(10), ID_TYPE NUMBER(10), ID_CLASSIFICATION NUMBER(10), ID_MUNICIP_TRADE_QUALITY NUMBER(10), ID_TRADE_QUALITY NUMBER(10), ID_EXCHANGE NUMBER(10), ID_CLIENT_ROLE NUMBER(10), ID_TRADE_CURRENCY NUMBER(10), ID_BUY_CURRENCY NUMBER(10), ID_SELL_CURRENCY NUMBER(10), ID_DESK NUMBER(10), ID_BUSINESS_NAME NUMBER(10), ID_MASKED_INSTRUMENT NUMBER(10), ID_INSTRUMENT NUMBER(10), ID_CLIENT NUMBER(10), ID_INSTRUMENT_PRODUCT NUMBER(10), ID_INSTRUMENT_REGION NUMBER(10), ID_CLIENT_PRTY_SPN NUMBER(10), ID_LEADING_SOURCE_SYSTEM NUMBER(10), ID_LE_OU_ARRANGING_DESK NUMBER(10), ID_LE_OU_TRADING_DESK NUMBER(10), ID_ARTEMIS_SOURCE_SYSTEM NUMBER(10), ID_CAPTIVE_CLASS NUMBER(10), ID_MARKETER_CLASS NUMBER(10), ID_BROKER_CLASS NUMBER(10), ID_INSTRUMENT_REGION_MASK NUMBER(10), ID_ARTEMIS_TRADE NUMBER(10), ID_TRADE_ORDER NUMBER(10), ID_ASIA_MUREX_JPMORGAN NUMBER(10), ID_TRADE_LINK_TYPE NUMBER(10), ID_YN_INDICATOR NUMBER(10), PRIMARY_ACROYNM_ID VARCHAR2(40 BYTE), PRIMARY_ACROYNM_NAME VARCHAR2(100 BYTE), SECONDARY_ACROYNM_ID VARCHAR2(40 BYTE), SECONDARY_ACROYNM_NAME VARCHAR2(100 BYTE), REVENUE_ACROYNM_ID VARCHAR2(40 BYTE), REVENUE_ACROYNM_NAME VARCHAR2(100 BYTE), DT_UPSTREAM_PROCESSED DATE, CD_ASIA_CLASS_2 VARCHAR2(100 BYTE), CD_HRR_CLASS VARCHAR2(100 BYTE), CD_MUREX_TRADE_CLASS VARCHAR2(100 BYTE), CD_MUREX_TRADE_STRATEGY VARCHAR2(100 BYTE), CD_JPMORGAN_ROLE_CLASS VARCHAR2(100 BYTE), CD_RETAIL_INDICATOR VARCHAR2(100 BYTE), CD_TRADE_LINK_TYPE VARCHAR2(100 BYTE), TRADE_LINK_DEAL_ID VARCHAR2(100 BYTE), CD_TRADE_LINK_LEAD_TRADE VARCHAR2(100 BYTE), CD_TRADE_LINK_COMPONENT VARCHAR2(100 BYTE), CD_TRADE_LINK_LEAD_COMPONENT VARCHAR2(100 BYTE), ID_ARCHIVE_TRADE_ORDER NUMBER(10), TEN_YEAR_EQUIVALENT NUMBER(10), IND_PRIME_BROKERAGE VARCHAR2(10 BYTE) NOT NULL, IND_IS_BAD_RECORD CHAR(1 BYTE), IND_IS_MASK VARCHAR2(1 BYTE), TRADE_INDICATOR VARCHAR2(1 BYTE), TXT_EXCEPTION VARCHAR2(2000 BYTE), ID_ISSUER_CLIENT NUMBER(10), ID_ACCOUNT_TYPE NUMBER(10), CD_ACCOUNT_TYPE VARCHAR2(100 BYTE), ID_DEAL_ORIGIN NUMBER(10), CD_DEAL_ORIGIN VARCHAR2(100 BYTE), ID_BOOK NUMBER(10), IND_NORMAL_PROCESSING VARCHAR2(1 BYTE), ID_IMNT_SYS_SRC VARCHAR2(40 BYTE), CD_BOOKING_TYPE VARCHAR2(15 BYTE), AM_TAX_STAMP_AMOUNT NUMBER(20,8), COST_CENTER VARCHAR2(15 BYTE), IND_STEP_OUT VARCHAR2(15 BYTE), AM_BROKER_COMM NUMBER(20,8), ID_TEAM_INITIATOR NUMBER(10), ID_TEAM_TRADER_1 NUMBER(10), FEED_INSTRUMENT_UNDERLYING_ID NUMBER(10), FEED_EXECUTIONER_ID VARCHAR2(10 BYTE), ID_INSTRUMENT_UNDERLYING NUMBER(10), ID_EXECUTIONER NUMBER(10), INSTRUMENT_TYPE VARCHAR2(100 BYTE), IND_IS_DMA_UPDATE VARCHAR2(1 BYTE), IND_GEN_ACTIVITY_DT VARCHAR2(1 BYTE), UPDATED_BY VARCHAR2(10 BYTE), UPDATED_DT DATE, CREATED_BY VARCHAR2(10 BYTE), CREATED_DT DATE, REASON_FOR_CHANGE VARCHAR2(100 BYTE), ID_USER_ACTION NUMBER(2), ORIG_ACTIVITY_DT DATE, IND_ACT_DT_GENERATED VARCHAR2(1 BYTE) DEFAULT 'N', IND_IS_PROCESSING VARCHAR2(1 BYTE), CD_FLOW_RATING_CLASS VARCHAR2(40 BYTE), CD_ROLL_CLASS VARCHAR2(40 BYTE), AM_BASIS_POINT_VAL NUMBER(20,8), NM_ARTEMIS_INST_SOURCE_SYSTEM VARCHAR2(30 BYTE), AM_HEADLINE_NOTNL NUMBER(20,8), AM_COMMOD_QTY NUMBER(20,8), COMMOD_QTY_UNIT VARCHAR2(40 BYTE), AM_BID_OFFER_RATE NUMBER(20,8), AM_MARKUP_RATE NUMBER(20,8), IND_VERVE_MANUAL VARCHAR2(10 BYTE), AM_EST_CREDIT_CHARGE NUMBER(20,8), CD_FX_GRID_OVERRIDE_CLASS VARCHAR2(15 BYTE), CD_GRID_RERUN_CLASS VARCHAR2(15 BYTE), CD_COVERAGE_RERUN_CLASS VARCHAR2(15 BYTE), CD_FX_VOL_CREDIT_ALLOC_CLASS VARCHAR2(15 BYTE), TRADE_MATURITY_DATE DATE, AM_ERR_CV_ADJUST NUMBER(20,8), AM_ERR_CV_INFO NUMBER(20,8), ID_COMM_TERM VARCHAR2(10 BYTE), AM_RETAIN_SHARE NUMBER(20,8), TOTAL_CV_INDICATOR VARCHAR2(10 BYTE), AM_DEFAULTCV_CCY NUMBER(20,8), AM_DEFAULTCV_USD NUMBER(20,8), AM_OVERRIDECV_CCY NUMBER(20,8), AM_OVERRIDECV_USD NUMBER(20,8), AM_MARKCV_CCY NUMBER(20,8), AM_MARKCV_USD NUMBER(20,8), PROTECT_BUY_SELL VARCHAR2(10 BYTE), NAPOLI_ID VARCHAR2(32 BYTE), AM_EXEC_COMM NUMBER(20,8), AM_CLEARING_COMM NUMBER(20,8), AM_CV_ADJUST_SHARE NUMBER(20,8), AM_TCRDT_CHARGE NUMBER(20,8), AM_DAP_FEE NUMBER(20,8), IND_HOTRUN VARCHAR2(8 BYTE), AM_FORW_VOL_CR NUMBER(20,8), IND_GIVE_UP VARCHAR2(40 BYTE), ID_OVERWRITE NUMBER(10) ) LOGGING NOCOMPRESS NOCACHE PARALLEL ( DEGREE 4 INSTANCES 1 ) MONITORING / CREATE INDEX XIE1LOAD_TRADE_ORDER ON LOAD_TRADE_ORDER (ARTEMIS_SOURCE_SYSTEM_ID, CD_BOOK_KEY, NM_ARTEMIS_SOURCE_SYSTEM, ACTIVITY_DT) LOGGING NOPARALLEL / CREATE INDEX XIE2LOAD_TRADE_ORDER ON LOAD_TRADE_ORDER (FEED_INSTRUMENT_ID, NM_ARTEMIS_SOURCE_SYSTEM) LOGGING NOPARALLEL / CREATE INDEX XIE3LOAD_TRADE_ORDER ON LOAD_TRADE_ORDER (CD_ETRADE_PLATFORM) LOGGING NOPARALLEL / CREATE INDEX XIE4LOAD_TRADE_ORDER ON LOAD_TRADE_ORDER (CD_BROKER_CLASS) LOGGING NOPARALLEL / CREATE INDEX XIE5LOAD_TRADE_ORDER ON LOAD_TRADE_ORDER (CD_MARKETER_CLASS) LOGGING NOPARALLEL / CREATE INDEX XIE6LOAD_TRADE_ORDER ON LOAD_TRADE_ORDER (NM_EXECUTING_DESK, NM_ORIGINATING_DESK, NM_PL_DESK) LOGGING NOPARALLEL / CREATE BITMAP INDEX XIE7LOAD_TRADE_ORDER ON LOAD_TRADE_ORDER (IND_CANCEL) LOGGING NOPARALLEL / --------------------------------------------------------------------------------------------