--

-- Name: MAP_COUNTERPARTY_CLASS; Type: TABLE; Schema: ; Owner:

--

CREATE TABLE "".MAP_COUNTERPARTY_CLASS (

DESCRIPTION VARCHAR2(100),
COUNTERPARTY_CLASS VARCHAR2(20),
COUNTERPARTY_SUBCLASS VARCHAR2(30),
ENTITY_ID NUMBER(10),
customer_segment VARCHAR2(40),
bank_category VARCHAR2(32),
segment VARCHAR2(10),
source_name VARCHAR2(12),
other conditions VARCHAR2(300),
BANK_CODE1 VARCHAR2(65),
BANK_CODE2 VARCHAR2(32),
BANK_CODE3 VARCHAR2(40),
BANK_CODE4 VARCHAR2(40),
BANK_CODE5 VARCHAR2(40),
BANK_CODE6 VARCHAR2(32),
BANK_CODE7 VARCHAR2(32),
Rule VARCHAR2(32)
);

TABLESPACE STG_DATA01;

--
-- Name: MAP_PRODUCT_CLASS ; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".MAP_PRODUCT_CLASS (

STD_PRODUCT_CLASS VARCHAR2(32),
STD_PRODUCT_SUBCLASS VARCHAR2(40),
DESCRIPTION VARCHAR2(300),
ENTITY_ID NUMBER(10),
SEGMENT VARCHAR2(20),
PRODUCT_TYPE VARCHAR2(32),
instrument_type VARCHAR2(32),
Type VARCHAR2(32),
Source_name VARCHAR2(15),
other_conditions VARCHAR2(120),
BANK_CODE1 VARCHAR2(60),
BANK_CODE2 VARCHAR2(60),
BANK_CODE3 VARCHAR2(60),
BANK_CODE4 VARCHAR2(60),
BANK_CODE5 VARCHAR2(50),
Rule VARCHAR2(20),
SAS COMMENTS VARCHAR2(),
Modelling's Comment VARCHAR2()
);
TABLESPACE STG_DATA01;
--
-- Name: MAP_CCF_TYPE ; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".MAP_CCF_TYPE (

CCF_TYPE VARCHAR2(60),
DESCRIPTION VARCHAR2(150),
ENTITY_ID NUMBER(15),
BANK_CODE1 VARCHAR2(70),
BANK_CODE2 VARCHAR2(10),
BANK_CODE3 VARCHAR2(10),
BANK_CODE4 VARCHAR2(10),
BANK_CODE5 VARCHAR2(10)
);

TABLESPACE STG_DATA01;

--
-- Name: MAP_CRM_TYPE ; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".MAP_CRM_TYPE (

CRM_TYPE VARCHAR2(30),
CRM_SUBTYPE VARCHAR2(30),
ENTITY_ID VARCHAR2(15),
collateral_type VARCHAR2(30),
BANK_CODE1 VARCHAR2(40),
BANK_CODE2 VARCHAR2(40),
BANK_CODE3 VARCHAR2(15),
BANK_CODE4 VARCHAR2(15),
BANK_CODE5 VARCHAR2(15),
Rule VARCHAR2(10)
);

TABLESPACE STG_DATA01;

**01

--
-- Name: MST_ENTITY; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".MST_ENTITY(

ENTITY_ID VARCHAR2(32) NOT NULL,
ENTITY_NAME VARCHAR2(200) NOT NULL,
IS_ACTIVE CHAR(1) NOT NULL
);
TABLESPACE STG_DATA01;
**02

--
-- Name: MST_ENTITY_SUBIDIARY; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".MST_ENTITY_SUBIDIARY(

SUBSIDIARY_ID VARCHAR2(32) NOT NULL,
SUBSIDIARY_NAME VARCHAR2(200) NOT NULL,
ENTITY_ID VARCHAR(32) NOT NULL,
IS_ACTIVE CHAR(1) NOT NULL,
);
TABLESPACE STG_DATA01;

**03

--
-- Name: REF_ECONOMIC_SECTOR; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".REF_ECONOMIC_SECTOR(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(15) NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
ECONOMIC_SECTOR_CODE VARCHAR2(15) NOT NULL,
ECONOMIC_SECTOR_CODE_DESC VARCHAR2(100) NOT NULL,
SUB_ECONOMIC_SECTOR_CODE VARCHAR2(15) NULL,
SUB_ECONOMIC_SECTOR_CODE_DESC VARCHAR2(100) NULL
);
TABLESPACE STG_DATA01;

**04

--
-- Name: REF_INDUSTRY_SECTOR; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".REF_INDUSTRY_SECTOR(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(15)NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
INDUSTRY_CODE VARCHAR2(15) NOT NULL,
INDUSTRY_CODE_DESC VARCHAR2(100) NOT NULL,
SUB_INDUSTRY_CODE VARCHAR2(15) NULL,
SUB_INDUSTRY_CODE_DESC VARCHAR2(100) NULL

);
TABLESPACE STG_DATA01;

--
-- Name: COUNTRY_CURRENCY_MAPPING ; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".COUNTRY_CURRENCY_MAPPING (

COUNTRY_NAME VARCHAR2(45),
COUNTRY_CODE_ISO2 VARCHAR2(5),
COUNTRY_CODE_ISO3 VARCHAR2(5),
CURRENCY_CODE VARCHAR2(5),
CURRENCY_NAME VARCHAR2(40),
Country VARCHAR2(50),
Fitch VARCHAR2(8),
Moodys VARCHAR2(10),
S&P VARCHAR2(10),
CI VARCHAR2(10)
);

TABLESPACE STG_DATA01;

**05

--
-- Name: BalanceSheet_Budget; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".BalanceSheet_Budget(

BS_ITEM VARCHAR,
FYYYYY - M00 Numeric
);

--
-- Name: BalanceSheet_Budget_Total; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".BalanceSheet_Budget_Total(

BS_ITEM VARCHAR,
FYYYYY - M00 Numeric
);

--
-- Name: Off_BS_Trial; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".Off_BS_Trial(

GL VARCHAR,
Debit_Outstanding_Balance Numeric
);

--
-- Name: Paris_Branch; Type: TABLE; Schema: ; Owner:
--
CREATE TABLE "".Paris_Branch(
BS_ITEM VARCHAR,
FYYYYY - M00 Numeric
);

--
-- Name: Gulf_Branch; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".Gulf_Branch(

BS_ITEM VARCHAR,
FYYYYY - M00 Numeric
);

**06

--
-- Name: TB_CR_BANKMASTERDATA; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".TB_CR_BANKMASTERDATA(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(8) NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
bank_id VARCHAR2(8) NOT NULL,
BANK_NAME VARCHAR2(100) NOT NULL,
COUNTRY_CODE VARCHAR2(2) NULL,
TIER1_CET_RATIO NUMBER(14,2) NULL,
TIER1_LEVERAGE_RATIO NUMBER(14,2) NULL,
Swift_Code VARCHAR2(11) NOT NULL,
fitch VARCHAR2(4) NOT NULL,
moodys VARCHAR2(4) NOT NULL,
s_and_p VARCHAR2(4) NOT NULL,
ci VARCHAR2(4) NOT NULL,
Bank_type VARCHAR2(12) NOT NULL,
Country_of_risk VARCHAR2(50) NOT NULL,
Country_of_residence VARCHAR2(50) NOT NULL,
Parent_CODE VARCHAR2(8) NULL,
Parent_NAME VARCHAR2(100)NULL,
Bank_category VARCHAR2(30) NOT NULL,
Stage Numeric(1) NOT NULL,
country_rating_moodys VARCHAR2(4) NOT NULL,
country_rating_s_and_p VARCHAR2(4) NOT NULL,
country_rating_fitch VARCHAR2(4) NOT NULL,
country_rating_ci VARCHAR2(4) NOT NULL,
review_date DATE NOT NULL,
TYPE VARCHAR2(50) NOT NULL,
CATEGORY VARCHAR2(50) NOT NULL
);
TABLESPACE STG_DATA01;

**07

--
-- Name: TB_ALL_CUSTOMERDATA; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".TB_ALL_CUSTOMERDATA(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(15) NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
SOURCE_SYSTEM_CODE VARCHAR2(3) NULL,
BRANCH_CODE VARCHAR2(8) NULL,
CUSTOMER_GROUP_ID VARCHAR2(32) NULL,
CUSTOMER_ID VARCHAR(32) NOT NULL,
CUSTOMER_NAME VARCHAR2(100) NOT NULL,
COUNTERPARTY_TYPE_CODE VARCHAR2(50) NOT NULL,
COUNTERPARTY_SUB_TYPE_CODE VARCHAR2(50) NOT NULL,
COUNTRY_CODE VARCHAR2(2) NULL,
MSME_TIER VARCHAR2(10) NULL,
AGGREGATE_EXPOSURE NUMERIC(18,5) NULL,
ANNUAL_SALES_TURNOVER NUMERIC(18,5) NOT NULL,
SALES_TURNOVER_CURRENCY VARCHAR2(3) NOT NULL,
PROJECTED_TURNOVER NUMERIC(18,5) NULL,
TOTAL_ASSETS NUMERIC(18,5) NULL,
INDUSTRY_CODE VARCHAR2(5) NOT NULL,
SUB_INDUSTRY_CODE VARCHAR2(5) NOT NULL,
ECONOMIC_SECTOR_CODE VARCHAR2(5) NOT NULL,
SUB_ECONOMIC_SECTOR_CODE VARCHAR2(5) NOT NULL,
EMPLOYMENT_TYPE VARCHAR2(50) NULL,
SWIFT_CODE VARCHAR2(11) NULL,
FITCH VARCHAR2(4) NOT NULL,
MOODYS VARCHAR2(4) NOT NULL,
S_AND_P VARCHAR2(4) NOT NULL,
CI VARCHAR2(4) NOT NULL,
COUNTRY_OF_RISK VARCHAR2(50) NOT NULL,
COUNTRY_OF_RESIDENCE VARCHAR2(50) NOT NULL,
PARENT_CODE VARCHAR2(8) NULL,
PARENT_NAME VARCHAR2(100) NULL,
COUNTRY_RATING_MOODYS VARCHAR2(4) NOT NULL,
COUNTRY_RATING_S_AND_P VARCHAR2(4) NOT NULL,
COUNTRY_RATING_FITCH VARCHAR2(4) NOT NULL,
COUNTRY_RATING_CI VARCHAR2(4) NOT NULL,
REVIEW_DATE DATE NOT NULL,
STAGE Numeric(1) NOT NULL,
CBE_CODE Numeric(30) NOT NULL,
GROUP_NAME VARCHAR2(50) NOT NULL,
CUSTOMER_SEGMENT VARCHAR2(50) NOT NULL,
ISIN_NO VARCHAR2(50) NOT NULL,
NID Numeric(30) NOT NULL,
INDUSTRY_CODE_DESC VARCHAR2(100) NOT NULL,
SUB_INDUSTRY_CODE_DESC VARCHAR2(100) NOT NULL,
ECONOMIC_SECTOR_CODE_DESC VARCHAR2(100) NOT NULL,
SUB_ECONOMIC_SECTOR_CODE_DESC VARCHAR2(100) NOT NULL,
GCIS_Code VARCHAR(32) NOT NULL

);
TABLESPACE STG_DATA01;

**08
--
-- Name: TB_ALL_FUNDEDDATA; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".TB_ALL_FUNDEDDATA(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(15) NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
SOURCE_SYSTEM_CODE VARCHAR2(3) NULL,
BRANCH_CODE VARCHAR2(8) NULL,
CUSTOMER_ID VARCHAR(32) NOT NULL,
CONTRACT_ID VARCHAR2(50)NOT NULL,
TRANSACTION_ID VARCHAR2(16) NULL,
GL_CODE VARCHAR2(32) NULL,
PRODUCT_TYPE_CODE VARCHAR2(6) NOT NULL,
PRODUCT_SUB_TYPE_CODE VARCHAR2(6) NOT NULL,
CURRENCY_CODE VARCHAR2(3) NOT NULL,
RATE_OF_INTEREST NUMERIC(9,4) NULL,
ACCOUNT_OPEN_DATE DATE NULL,
MATURITY_DATE DATE NOT NULL,
SANCTIONED_DATE Date NULL,
SANCTIONED_LIMIT_FCY NUMERIC(18,5) NULL,
SANCTIONED_LIMIT_LCY NUMERIC(18,5) NULL,
DISBURSEMENT_DATE DATE NULL,
DISBURSEMENT_AMOUNT_FCY NUMERIC(18,5) NULL,
DISBURSEMENT_AMOUNT_LCY NUMERIC(18,5) NULL,
OUTSTANDING_BALANCE_FCY NUMERIC(18,5) NOT NULL,
OUTSTANDING_BALANCE_LCY NUMERIC(18,5) NOT NULL,
ACCURED_INTEREST_FCY NUMERIC(18,5) NULL,
ACCURED_INTEREST_LCY NUMERIC(18,5) NULL,
NPA_FLAG CHAR(1) NULL,
PAST_DUE_DAYS_COUNT NUMBER(4) NULL,
SPECIFIC_PROVISION_AMOUNT NUMERIC(18,5) NULL,
ASSET_CLASSIFICATION_CODE VARCHAR2(25) NULL,
DRAWING_POWER NUMERIC(18,5) NULL,
LTV_RATIO NUMBER(14,2) NULL,
PROPERTY_VALUE NUMERIC(18,5) NULL,
RESTRUCTURE_FLAG CHAR(1) NULL,
RESTRUCTURE_DATE DATE NULL,
RESTRUCTURE_AMOUNT NUMERIC(18,5) NULL,
RESCHEDULED_FLAG VARCHAR2(1) NULL,
INTREST_IN_SUSPENSE_AMOUNT NUMERIC(18,5) NULL,
WRITTEN_OFF_AMOUNT_LCY NUMERIC(18,5) NULL,
WRITTEN_OFF_DATE DATE NULL,
FEES NUMERIC(18,5) NULL,
INDUSTRY_CODE VARCHAR2(15)NOT NULL,
SUB_INDUSTRY_CODE VARCHAR2(15)NOT NULL,
ECONOMIC_SECTOR_CODE VARCHAR2(15)NOT NULL,
SUB_ECONOMIC_SECTOR_CODE VARCHAR2(15)NOT NULL,
UNCONDITIONAL_CANCELLABLE_FLAG VRACHAR2(1) NULL,
SENIORITY_FLAG CHAR(1) NULL,
REVOLVING_FLAG CHAR(1) NULL,
SPECIALISED_LENDING_TYPE VARCHAR2(20) NULL,
PROJECT_PHASE VARCHAR2(20) NULL,
PROJECT_QUALITY_FLAG CHAR(1) NULL,
TRANSACTORS_FLAG CHAR(1) NULL,
ADC_FLAG_100_RW CHAR(1) NULL,
ADC_FLAG_150_RW CHAR(1) NULL,
RRE_REAL_ESTATE_FLAG CHAR(1) NULL,
CRE_REAL_ESTATE_FLAG CHAR(1) NULL,
RRE_MATERIALLY_GENERATED_FLAG CHAR(1) NULL,
CRE_MATERIALLY_GENERATED_FLAG CHAR(1) NULL,
SPLITTING_APPROACH_FLAG CHAR(1) NULL,
UNHEDGED_RETAIL_FLAG CHAR(1) NULL,
BORROWER_SOURCE_INCOME_CUR_CODE CHAR(1) NULL,
CREDIT_CARD_TYPE VARCHAR2(25) NULL,
SHARIAH_FLAG CHAR(1) NULL,
STAGE Numeric(1) NOT NULL,
ECL NUMERIC(18,5) NOT NULL,
FITCH VARCHAR2(4) NOT NULL,
MOODYS VARCHAR2(4) NOT NULL,
S_AND_P VARCHAR2(4) NOT NULL,
CI VARCHAR2(4) NOT NULL,
COUNTRY_OF_RISK VARCHAR2(50) NOT NULL,
COUNTRY_OF_RESIDENCE VARCHAR2(50) NOT NULL,
PARENT_CODE VARCHAR2(8)NULL,
PARENT_NAME VARCHAR2(100)NULL,
COUNTRY_RATING_MOODYS VARCHAR2(4) NOT NULL,
COUNTRY_RATING_S_AND_P VARCHAR2(4) NOT NULL,
COUNTRY_RATING_FITCH VARCHAR2(4) NOT NULL,
COUNTRY_RATING_CI VARCHAR2(4) NOT NULL,
REVIEW_DATE DATE NOT NULL,
CBE_CODE Numeric(30) NOT NULL,
GROUP_NAME VARCHAR2(50) NOT NULL,
CUSTOMER_SEGMENT VARCHAR2(50) NOT NULL,
ISIN_NO VARCHAR2(50) NOT NULL,
NID Numeric(30) NOT NULL,
INDEX Numeric(30) NOT NULL,
COLLATERAL_CASH NUMERIC(18,5) NOT NULL,
COLLATERAL_CASH_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_FACILITY_GUARANTEE NUMERIC(18,5) NOT NULL,
COLLATERAL_FACILITY_GUARANTEE_CURRENCY VARCHAR2(3) NOT NULL,
SOURCE_NAME VARCHAR2(100) NOT NULL,
SWIFT_CODE VARCHAR2(11) NOT NULL,
BANK_NAME VARCHAR2(100) NOT NULL,
BANK_ID VARCHAR2(8) NOT NULL,
BANK_TYPE VARCHAR2(12) NOT NULL,
BANK_CATEGORY VARCHAR2(30) NOT NULL,
COLLATERAL_CASH NUMERIC(18,5) NOT NULL,
COLLATERAL_CASH_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_FACILITY_GUARANTEE NUMERIC(18,5) NOT NULL,
COLLATERAL_FACILITY_GUARANTEE_CURRENCY VARCHAR2(3) NOT NULL,
ACCRUAL_INTEREST NUMERIC(18,5) NOT NULL,
FIXED_OR_FLOATING VARCHAR2(50) NOT NULL,
REPRICING_DATE VARCHAR2(50) NOT NULL,
GUARANTOR_IS_A_MINUS_OR_HIGHER VARCHAR2(50) NOT NULL,
UNEARNED_DISCOUNT NUMERIC(18,5) NOT NULL,
CUSTOMER_NAME VARCHAR2(100) NOT NULL,
COLLATERAL_TYPE VARCHAR2(100) NOT NULL,
COLLATERAL_CURRENCY VARCHAR2(3) NOT NULL,
SELF_FINANCE_ASSET NUMERIC(18,5) NOT NULL,
PROJECT_LIABILITY NUMERIC(18,5) NOT NULL,
TRANSACTION_TYPE VARCHAR2(100) NOT NULL,
ANNUAL_SALES_TURNOVER NUMERIC(18,5) NOT NULL,
SALES_TURNOVER_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_CGC NUMERIC(18,5) NOT NULL,
COLLATERAL_MOF NUMERIC(18,5) NOT NULL,
 COLLATERAL_CGC_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_MOF_CURRENCY VARCHAR2(3) NOT NULL,
CASH_COVER NUMERIC(18,5) NOT NULL,
CASH_COVER_CURRENCY VARCHAR2(3) NOT NULL,
ISSUER_NAME VARCHAR2(100) NOT NULL,
BOOK_VALUE NUMERIC(18,5) NOT NULL,
FACE_BOOK_VALUE_CURRENCY VARCHAR2(3) NOT NULL,
INTEREST_NOT_DUE NUMERIC(18,5) NOT NULL,
COUPON_TYPE VARCHAR2(100) NOT NULL,
COUPON_RATE NUMERIC(18,5) NOT NULL,
INSTRUMENT_TYPE VARCHAR2(100) NOT NULL,
ISSUER_ID VARCHAR2(50) NOT NULL,
TYPE_OF_ENTITY VARCHAR2(50) NOT NULL,
PREMIUM_OR_DISCOUNT NUMERIC(18,5) NOT NULL,
SECURITY_ISSUER VARCHAR2(50) NOT NULL,
ACCRUAL_INTEREST_CURRENCY VARCHAR2(3) NOT NULL,
NID Numeric(30) NOT NULL,
PREMIUM_OR_DISCOUNT_OF_SECURITIZATION VARCHAR2(100) NOT NULL,
ITEM_NAME VARCHAR2(100) NOT NULL,
IFRS9_CLASSIFICATION VARCHAR(32) NOT NULL,
INTEREST_IN_SUSPENSE NUMERIC(18,5) NOT NULL,
FACE_VALUE NUMERIC(18,5) NOT NULL

);
TABLESPACE STG_DATA01;

**08

--
-- Name: TB_ALL_NONFUNDEDDATA; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".TB_ALL_NONFUNDEDDATA(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(15) NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
SOURCE_SYSTEM_CODE VARCHAR2(3) NULL,
BRANCH_CODE VARCHAR2(8) NOT NULL,
CUSTOMER_ID VARCHAR(32) NOT NULL,
CONTRACT_ID VARCHAR2(50) NOT NULL,
TRANSACTION_ID VARCHAR2(16) NULL,
CURRENCY_CODE VARCHAR2(3) NOT NULL,
FACILITY_START_DATE DATE NULL,
MATURITY_DATE DATE NOT NULL,
NATURE_OF_LIMIT VARCHAR2(25) NULL,
PRODUCT_TYPE_CODE VARCHAR2(6) NOT NULL,
PRODUCT_SUB_TYPE_CODE VARCHAR2(6) NULL,
SANCTIONED_DATE Date NULL,
SANCTIONED_LIMIT_FCY NUMERIC(18,5) NULL,
SANCTIONED_LIMIT_LCY NUMERIC(18,5) NULL,
FACILITY_AMOUNT_FCY NUMBER(20,4) NOT NULL,
FACILITY_AMOUNT_LCY NUMBER(20,4) NOT NULL,
INDUSTRY_CODE VARCHAR2(15) NULL,
SUB_INDUSTRY_CODE VARCHAR2(15) NULL,
ECONOMIC_SECTOR_CODE VARCHAR2(15) NULL,
SUB_ECONOMIC_SECTOR_CODE VARCHAR2(15) NULL,
NPA_FLAG CHAR(1) NULL,
PAST_DUE_DAYS_COUNT NUMBER(4) NULL,
REVOCABLE_FLAG CHAR(1) NULL,
UNCONDITIONAL_CANCELLABLE_FLAG VRACHAR2(1) NULL,
ASSET_CLASSIFICATION_CODE VARCHAR2(25) NULL,
GL_CODE VARCHAR2(32) NULL,
SPECIFIC_PROVISION_AMOUNT NUMERIC(18,5) NULL,
WRITTEN_OFF_AMOUNT_LCY NUMERIC(18,5) NULL,
WRITTEN_OFF_DATE DATE NULL,
RATE_OF_INTEREST NUMERIC(9,4) NULL,
STAGE Numeric(1) NOT NULL,
ECL NUMERIC(18,5) NOT NULL,
FITCH VARCHAR2(4) NOT NULL,
MOODYS VARCHAR2(4) NOT NULL,
S_AND_P VARCHAR2(4) NOT NULL,
CI VARCHAR2(4) NOT NULL,
COUNTRY_OF_RISK VARCHAR2(50) NOT NULL,
COUNTRY_OF_RESIDENCE VARCHAR2(50) NOT NULL,
PARENT_CODE VARCHAR2(8) NULL,
PARENT_NAME VARCHAR2(100) NULL,
COUNTRY_RATING_MOODYS VARCHAR2(4) NOT NULL,
COUNTRY_RATING_S_AND_P VARCHAR2(4) NOT NULL,
COUNTRY_RATING_FITCH VARCHAR2(4) NOT NULL,
COUNTRY_RATING_CI VARCHAR2(4) NOT NULL,
REVIEW_DATE DATE NOT NULL,
CBE_CODE Numeric(30) NOT NULL,
GROUP_NAME VARCHAR2(50) NOT NULL,
CUSTOMER_SEGMENT VARCHAR2(50) NOT NULL,
ISIN_NO VARCHAR2(50) NOT NULL,
NID Numeric(30) NOT NULL,
INDEX Numeric(30) NOT NULL,
COLLATERAL_CASH NUMERIC(18,5) NOT NULL,
COLLATERAL_CASH_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_FACILITY_GUARANTEE NUMERIC(18,5) NOT NULL,
COLLATERAL_FACILITY_GUARANTEE_CURRENCY VARCHAR2(3) NOT NULL,
SOURCE_NAME VARCHAR2(100) NOT NULL,
SWIFT_CODE VARCHAR2(11) NOT NULL,
BANK_NAME VARCHAR2(100) NOT NULL,
BANK_ID VARCHAR2(8) NOT NULL,
BANK_TYPE VARCHAR2(12) NOT NULL,
BANK_CATEGORY VARCHAR2(30) NOT NULL,
GUARANTOR_IS_A_MINUS_OR_HIGHER VARCHAR2(50) NOT NULL,
CUSTOMER_NAME VARCHAR2(100) NOT NULL,
COLLATERAL_TYPE VARCHAR2(100) NOT NULL,
COLLATERAL_CURRENCY VARCHAR2(3) NOT NULL,
SELF_FINANCE_ASSET NUMERIC(18,5) NOT NULL,
PROJECT_LIABILITY NUMERIC(18,5) NOT NULL,
TRANSACTION_TYPE VARCHAR2(100) NOT NULL,
ANNUAL_SALES_TURNOVER NUMERIC(18,5) NOT NULL,
SALES_TURNOVER_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_CGC NUMERIC(18,5) NOT NULL,
COLLATERAL_MOF NUMERIC(18,5) NOT NULL,
COLLATERAL_CGC_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_MOF_CURRENCY VARCHAR2(3) NOT NULL,
CASH_COVER NUMERIC(18,5) NOT NULL,
CASH_COVER_CURRENCY VARCHAR2(3) NOT NULL,
SECURITY_TYPE VARCHAR2(50) NOT NULL,
SECURITY_CURRENCY VARCHAR2(3) NOT NULL,
SECURITY_PERCENTAGE Percentage NOT NULL,
 COMMITMENT_TYPE VARCHAR2(50) NOT NULL
);
TABLESPACE STG_DATA01;

**09

--
-- Name: TB_CR_INSTRUMENTDATA; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".TB_CR_INSTRUMENTDATA(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(15) NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
SOURCE_SYSTEM_CODE VARCHAR2(3)NULL,
BRANCH_CODE VARCHAR2(8)NULL,
CUSTOMER_ID VARCHAR(32) NOT NULL,
CONTRACT_ID VARCHAR2(50) NOT NULL,
INSTRUMENT_ID VARCHAR2(16) NULL,
INSTRUMENT_TYPE VARCHAR2(20) NULL,
INSTRUMENT_CATEGORY VARCHAR2(10) NULL,
INSTRUMENT_SUB_CATEGORY VARCHAR2(10) NULL,
GL_CODE VARCHAR2(32) NULL,
PRODUCT_TYPE_CODE VARCHAR2(6) NOT NULL,
PRODUCT_SUB_TYPE_CODE VARCHAR2(6) NULL,
ISSUE_DATE DATE NULL,
MATURITY_DATE DATE NOT NULL,
CURRENCY_CODE VARCHAR2(3) NOT NULL,
BOOK_VALUE_FCY NUMERIC(18,5) NULL,
BOOK_VALUE_LCY NUMERIC(18,5) NULL,
FACE_VALUE_FCY NUMERIC(18,5) NULL,
FACE_VALUE_LCY NUMERIC(18,5) NULL,
MTM_FCY NUMERIC(18,5) NULL,
MTM_LCY NUMERIC(18,5) NULL,
COUPON NUMERIC(18,5) NULL,
INDUSTRY_CODE VARCHAR2(15) NULL,
SUB_INDUSTRY_CODE VARCHAR2(15) NULL,
ECONOMIC_SECTOR_CODE VARCHAR2(15) NULL,
SUB_ECONOMIC_SECTOR_CODE VARCHAR2(15) NULL,
MATURITY_DATE DATE NOT NULL,
PAST_DUE_DAYS_COUNT NUMBER(4) NULL,
PAST_DUE_AMOUNT NUMBER(18,5) NULL,
NPA_FLAG CHAR(1) NULL,
INDEX Numeric(30) NOT NULL,
SOURCE_NAME VARCHAR2(100) NOT NULL,
ISIN_NO VARCHAR2(50) NOT NULL,
SWIFT_CODE VARCHAR2(11) NOT NULL,
NAME VARCHAR2(11) NOT NULL,
SEGMENT VARCHAR2(11) NOT NULL,
MANAGER VARCHAR2(50) NOT NULL,
MARKET_COUNTRY VARCHAR2(50) NOT NULL,
TYPE VARCHAR2(50) NOT NULL,
LISTING VARCHAR2(50) NOT NULL,
 IFRS9_CLASSIFICATION VARCHAR2(50) NOT NULL,
ISSUED_CAPITAL NUMERIC(18,5) NOT NULL,
NUMBER_OF_PURCHASED_STOCKS Numeric NOT NULL,
FAIR_VALUE_PER_STOCK Numeric NOT NULL,
FACE_VALUE_PER_STOCK Numeric NOT NULL,
BOOK_VALUE_PER_STOCK Numeric NOT NULL,
VALUATION_METHODOLOGY VARCHAR2(50) NOT NULL,
VALUATION_DATE Date NOT NULL,
FUND_ASSETS Numeric NOT NULL,
FUND_LIABILITY Numeric NOT NULL,
TOTAL_OUTSTANDING_SHARES_PER_FUND Numeric NOT NULL,
OWN_INVESTMENT_(NO._OF_CERTIFICATES)_PER_FUND Numeric NOT NULL,
FAIR_VALUE_OF_FUND_PER_SHARE Numeric NOT NULL,
FUND_TYPE VARCHAR2(50) NOT NULL,
MANAGER_NAME VARCHAR2(50) NOT NULL,
GROUP_NAME VARCHAR2(50) NOT NULL,
MTM NUMBER(14,2) NOT NULL
);
TABLESPACE STG_DATA01;

**10

--
-- Name: TB_ALL_REPOS; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".TB_ALL_REPOS(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(15) NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
SOURCE_SYSTEM_CODE VARCHAR2(3) NULL,
BRANCH_CODE VARCHAR2(8) NOT NULL,
CUSTOMER_ID VARCHAR(32) NOT NULL,
CONTRACT_ID VARCHAR2(50) NOT NULL,
TRANSACTION_ID VARCHAR2(16) NULL,
GL_CODE VARCHAR2(32) NULL,
PRODUCT_TYPE_CODE VARCHAR2(6) NOT NULL,
PRODUCT_SUB_TYPE_CODE VARCHAR2(6) NULL,
TRANSACTION_TYPE VARCHAR2(50) NULL,
CURRENCY_CODE VARCHAR2(3) NOT NULL,
SECURITY_ID VARCHAR2(16) NULL,
SECURITY_TYPE VARCHAR(10) NUll,
SECURITY_VALUE_FCY NUMBER(14,2) NUll,
SECURITY_VALUE_LCY NUMBER(14,2) NUll,
ISSUE_DATE DATE NUll,
BOOK_VALUE_FCY NUMBER(14,2) NUll,
BOOK_VALUE_LCY NUMBER(14,2) NUll,
CLEARING_COUNTERPARTY_CCP CHAR(1) NUll,
CLEARING_CORPORATION CHAR(1) NUll,
INDUSTRY_CODE VARCHAR2(15) NUll,
SUB_INDUSTRY_CODE VARCHAR2(15) NUll,
ECONOMIC_SECTOR_CODE VARCHAR2(15) NUll,
SUB_ECONOMIC_SECTOR_CODE VARCHAR2(15) NUll,
GL_CODE VARCHAR2(32) NUll,
STAGE Numeric(1) NOT NULL,
ECL NUMERIC(18,5) NOT NULL,
FITCH VARCHAR2(4) NOT NULL,
MOODYS VARCHAR2(4) NOT NULL,
 S_AND_P VARCHAR2(4) NOT NULL,
CI VARCHAR2(4) NOT NULL,
COUNTRY_OF_RISK VARCHAR2(50) NOT NULL,
COUNTRY_OF_RESIDENCE VARCHAR2(50) NOT NULL,
PARENT_CODE VARCHAR2(8) NOT NULL,
PARENT_NAME VARCHAR2(100) NOT NULL,
COUNTRY_RATING_MOODYS VARCHAR2(4) NOT NULL,
COUNTRY_RATING_S_AND_P VARCHAR2(4) NOT NULL,
COUNTRY_RATING_FITCH VARCHAR2(4) NOT NULL,
COUNTRY_RATING_CI VARCHAR2(4) NOT NULL,
SWIFT_CODE VARCHAR2(11) NOT NULL,
INDEX Numeric(30) NOT NULL,
SOURCE_NAME VARCHAR2(100) NOT NULL,
REVIEW_DATE DATE NOT NULL,
CUSTOMER_NAME VARCHAR2(100) NOT NULL,
ISIN_NO VARCHAR2(50) NOT NULL,
TYPE VARCHAR2(50) NOT NULL,
CATEGORY VARCHAR2(50) NOT NULL,
TYPE_OF_FIN_INSTRUMENT VARCHAR2(50) NOT NULL,
TYPE_OF_REPO VARCHAR2(50) NOT NULL,
ORIGINAL_CONTRACT_ID VARCHAR2(50) NOT NULL,
FACE_VALUE Numeric NOT NULL,
FACE_VALUE_CURRENCY VARCHAR2(3) NOT NULL,
FINANCING_AMOUNT Numeric NOT NULL,
FINANCING_AMOUNT_CURRENCY VARCHAR2(3) NOT NULL,
FINANCING_REF VARCHAR2(50) NOT NULL,
MATURITY_FOR_FINANCING_AMOUNT DATE NOT NULL,
MARKET_VALUE_FOR_BILLS_OR_BONDS Numeric NOT NULL,
HAIRCUT_PERCENTAGE Numeric NOT NULL,
MATURITY_FOR_T_BILLS_OR_T_BONDS NUMERIC(18,5) NOT NULL

);
TABLESPACE STG_DATA01;

**11

--
-- Name: TB_ALL_COLLATERAL_DATA; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".TB_ALL_COLLATERAL_DATA(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(15) NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
SOURCE_SYSTEM_CODE VARCHAR2(3) NULL,
CUSTOMER_ID VARCHAR(32) NOT NULL,
CONTRACT_ID VARCHAR2(50) NOT NULL,
TRANSACTION_ID VARCHAR2(16) NULL,
INSTRUMENT_ID VARCHAR(32) NULL,
COLLATERAL_ID VARCHAR2(16) NULL,
COLLATERAL_TYPE_CODE VARCHAR2(8) NULL,
COLLATERAL_SUB_TYPE_CODE VARCHAR2(8) NULL,
COLLATERAL_ISSUE_DATE DATE NULL,
COLLATERAL_END_DATE DATE NULL,
GUARANTOR_ID VARCHAR2(16) NULL,
 CURRENCY_CODE VARCHAR2(8) NULL,
COLLATERAL_VALUE_FCY NUMERIC(18,5) NULL,
COLLATERAL_VALUE_LCY NUMERIC(18,5) NULL,
GOLD_NET_WEIGHT VARCHAR2(8) NULL,
TYPE_OF_EQUITY VARCHAR2(8) NULL,
EXTERNAL_RATING_AGENCY_NAME_EQT VARCHAR2(16) NULL,
EQUITY_RATING VARCHAR2(8) NULL,
RATING_START_DATE DATE NULL,
RATING_EXPIRY_DATE DATE NULL,
COLLATERAL_CASH NUMERIC(18,5) NOT NULL,
COLLATERAL_CASH_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_FACILITY_GUARANTEE NUMERIC(18,5) NOT NULL,
COLLATERAL_FACILITY_GUARANTEE_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_TYPE VARCHAR2(100) NOT NULL,
COLLATERAL_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_CGC NUMERIC(18,5) NOT NULL,
CGC_TYPE VARCHAR2(50) NOT NULL,
COLLATERAL_MOF NUMERIC(18,5) NOT NULL,
COLLATERAL_CGC_CURRENCY VARCHAR2(3) NOT NULL,
COLLATERAL_MOF_CURRENCY VARCHAR2(3) NOT NULL,
CASH_COVER NUMERIC(18,5) NOT NULL,
CASH_COVER_CURRENCY VARCHAR2(3) NOT NULL,
INDEX Numeric(30) NOT NULL,
SOURCE_NAME VARCHAR2(100) NOT NULL,
CBE_CODE Numeric(30) NOT NULL,
GUARANTOR_IS_A_MINUS_OR_HIGHER VARCHAR2(3) NOT NULL,
BANK_NAME VARCHAR2(100) NOT NULL,
BANK_ID VARCHAR2(8) NOT NULL,
CUSTOMER_NAME VARCHAR2(100) NOT NULL,
GROUP_NAME VARCHAR2(50) NOT NULL,
SECURITY_TYPE VARCHAR2(50) NOT NULL,
SECURITY_CURRENCY VARCHAR2(3) NOT NULL,
SECURITY_PERCENTAGE Percentage NOT NULL,
COLLATERAL_AMOUNT NUMERIC(18,5) NOT NULL

);
TABLESPACE STG_DATA01;

**12

--
-- Name: TB_ALL_RATING; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".TB_ALL_RATING(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(15) NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
SOURCE_SYSTEM_CODE VARCHAR2(3) NULL,
CUSTOMER_ID VARCHAR(32) NOT NULL,
BANK_ID VARCHAR(32) NOT NULL,
CONTRACT_ID VARCHAR2(50) NOT NULL,
TRANSACTION_ID VARCHAR(32) NULL,
INSTRUMENT_ID VARCHAR(32) NULL,
 EXTERNAL_RATING_AGENCY VARCHAR2(16) NULL,
EXTERNAL_RATING_DATE DATE NULL,
EXTERNAL_RATING_GRADE_LONG VARCHAR2(5) NULL,
EXTERNAL_RATING_GRADE_SHORT VARCHAR2(5) NULL,
EXTERNAL_RATING_EXPIRY_DATE DATE NULL,
INTERNAL_RATING_DATE DATE NULL,
INTERNAL_RATING_GRADE VARCHAR2(5) NULL,
INTERNAL_RATING_EXPIRY_DATE DATE NULL,
RATING_COUNTRY_CODE VARCHAR2(5) NULL,
GRADE VARCHAR2(5) NULL,
FITCH VARCHAR2(4) NOT NULL,
MOODYS VARCHAR2(4) NOT NULL,
S_AND_P VARCHAR2(4) NOT NULL,
CI VARCHAR2(4) NOT NULL,
COUNTRY_OF_RISK VARCHAR2(50) NOT NULL,
COUNTRY_OF_RESIDENCE VARCHAR2(50) NOT NULL,
COUNTRY_RATING_MOODYS VARCHAR2(4) NOT NULL,
COUNTRY_RATING_S_AND_P VARCHAR2(4) NOT NULL,
COUNTRY_RATING_FITCH VARCHAR2(4) NOT NULL,
COUNTRY_RATING_CI VARCHAR2(4) NOT NULL,
INDEX Numeric(30) NOT NULL,
SOURCE_NAME VARCHAR2(100) NOT NULL,
STAGE Numeric(1) NOT NULL,
BANK_NAME VARCHAR(100) NOT NULL,
CUSTOMER_NAME VARCHAR2(100) NOT NULL
);

**13

--
-- Name: TB_CR_SACCR_CVA; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".TB_CR_SACCR_CVA(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
ENTITY_ID VARCHAR2(15) NOT NULL,
SUBSIDIARY_ID VARCHAR2(15) NOT NULL,
contract_id VARCHAR2(50) NOT NULL,
Customer_ID VARCHAR2(20) NOT NULL,
Customer_Name VARCHAR2(20) NULL,
PARENT_COUNTERPARTY_ID VARCHAR2(20) NULL,
HEDGING_SET_ID VARCHAR2(20) NULL,
NETTING_SET_ID VARCHAR2(20) NULL,
COUNTERPARTYTYPECPDE VARCHAR2(50) NULL,
RATING_REFERENCE_GRADE VARCHAR2(6) NULL,
PRODUCT_TYPE VARCHAR2(20) NULL,
PRIMARY_RISK_DRIVER_CODE VARCHAR2(20) NULL,
COMMODITY_CLASS VARCHAR2(50) NULL,
COMMODITY_SUB_CLASS VARCHAR2(50) NULL,
COMMODITY_TYPE VARCHAR2(50) NULL,
START_DATE DATE NULL,
END_DATE DATE NULL,
TRADE_DATE DATE NULL,
BASE_CURRENCY VARCHAR2(5) NULL,
NOTIONAL_AMOUNT_LCY NUMBER(14,2) NULL,
MTM_VALUE_LCY NUMBER(14,2) NULL,
COLLATERAL_VALUE NUMBER(14,2) NULL,
 NICA_LCY NUMBER(14,2) NULL,
TH_LCY NUMBER(14,2) NULL,
MIN_TRANSFER_AMOUNT NUMBER(14,2) NULL,
POSITION VARCHAR2(20) NULL,
BUY_SELL_FLAG VARCHAR2(20) NULL,
MARGIN_UNMARGIN_FLAG VARCHAR2(20) NULL,
CCP_FLAG VARCHAR2(3) NULL,
UNDERLYING_PRICE NUMBER(14,2) NULL,
STRIKE_PRICE NUMBER(14,2) NULL,
SUPERVISIORY_OPTION NUMBER(14,2) NULL,
VOLATILITY_FLAG VARCHAR2(20) NULL,
PAY_CURR_NTNL_SHORT_SAR NUMBER(14,2) NULL,
REC_CURR_NTNL_LONG_SAR NUMBER(14,2) NULL,
SUPERVISORY_FACTOR NUMBER(14,2) NULL,
CORRELATION_FACTOR NUMBER(14,2) NULL,
VARIATION_MARGIN NUMBER(14,2) NULL,
RISK_WEIGHT NUMBER(14,2) NULL,
MARGIN_TYPE VARCHAR2(25) NULL,
MARGIN_VALUE NUMERIC(18,5) NULL,
MARGIN_FCY VARCHAR2(3) NULL,
HAIRCUT_VALUE NUMBER(14,2) NULL,
PAY_LEG_REF_FCY VARCHAR2(3) NULL,
PAY_CURR_NTNL_SHORT_LCY NUMERIC(18,5) NULL,
REC_LEG_REF_FCY VARCHAR2(3) NULL,
REC_CURR_NTNL_SHORT_LCY NUMERIC(18,5) NULL,
COUNTERPARTY_SECTOR VARCHAR2(100) NULL,
COUNTERPARTY_CREDIT_QUALITY NUMERIC(18,5) NULL,
Spot_Future_Price NUMBER(14,2) NULL,
fitch VARCHAR2(4) NOT NULL,
moodys VARCHAR2(4) NOT NULL,
s_and_p VARCHAR2(4) NOT NULL,
ci VARCHAR2(4) NOT NULL,
Country_of_risk VARCHAR2(50) NOT NULL,
Country_of_residence VARCHAR2(50) NOT NULL,
country_rating_moodys VARCHAR2(4) NOT NULL,
country_rating_s_and_p VARCHAR2(4) NOT NULL,
country_rating_fitch VARCHAR2(4) NOT NULL,
country_rating_ci VARCHAR2(4) NOT NULL,
Index Numeric(30) NOT NULL,
SOURCE_NAME VARCHAR2(100) NOT NULL,
contract_id VARCHAR2(50) NOT NULL,
swift_code VARCHAR2(11) NOT NULL,
type VARCHAR2(50) NOT NULL,
category VARCHAR2(50) NOT NULL,
review_date DATE NOT NULL,
type_of_fin_instrument VARCHAR2(50) NOT NULL,
notional_amount NUMBER(14,2) NOT NULL,
notional_amount_currency VARCHAR2(3) NOT NULL,
maturity_or_expiry_date DATE NOT NULL,
mtm NUMBER(14,2) NOT NULL,
market_value NUMBER(14,2) NOT NULL,
currency_pair_buy_or_sell NUMBER(14,2) NOT NULL,
sell_amount NUMBER(14,2) NOT NULL,
Market_Value_for_Bills_or_Bonds NUMBER(14,2) NOT NULL

);

**14
--
-- Name: TB_ALL_QUOTES; Type: TABLE; Schema: ; Owner:
--

CREATE TABLE "".TB_ALL_QUOTES(

REPORTING_DATE DATE NOT NULL,
EXTRACT_DATE DATE NOT NULL,
CURRENCY VARCHAR(3) NOT NULL,
EXCHANGE_RATE NUMERIC(18,5) NOT NULL
);