installation manual oracle financial services economic ... economic... · oracle financial services...

Oracle Financial Services Software Confidential - Restricted

Installation Manual Oracle Financial Services Economic Capital Advanced

Release 1.1.2.0.0 May 2014

Oracle Financial Services Software Confidential - Restricted

Document Control

Version Number

Revision Date Changes Done

Version 1.1.2 Revised on May

2014

Updated the Environment and Generic Software

section to qualify on OEL/RHEL 5.3 / 5.8 - Oracle

11g R2 (11.2.0.2.0) - Web logic 10.3.5.0 /

Websphere 7.0.0.17 / Tomcat 7.0.19 (64 bit)

Created and

Edited by: Dilip

Reviewed By :

Satish C.S

Approved by : Kumaran Krishnan

Executive Summary

The document consists of all the installation, Pre and Post configuration procedures which have been structured considering all the 1.1.2 enhancements. You can find the latest copy of this document in OTN library which includes all the recent additions/revisions (if any) done till date.

Before you begin the installation, ensure that you have an access to Oracle Support Portal with the required login credentials to quickly notify us for any specific issues. You can obtain one by contacting Oracle Support.

http://docs.oracle.com/cd/E41282_01/homepage.htmhttps://support.oracle.com/

Installation Manual

Oracle Financial Services Software Confidential - Restricted `

Table of Contents

1. ABOUT THIS MANUAL ..................................................................................................................... 2

1.1 ORACLE FINANCIAL SERVICES ANALYTICAL APPLICATIONS INFRASTRUCTURE OVERVIEW ....................................... 2 1.2 ANALYTICAL APPLICATIONS OVERVIEW ...................................................................................................... 2 1.3 AUDIENCE ............................................................................................................................................ 2 1.4 SCOPE ................................................................................................................................................. 2 1.5 ORGANIZATION OF THE MANUAL .............................................................................................................. 2 1.6 CONVENTIONS USED IN THIS MANUAL ....................................................................................................... 3

2. PRE-INSTALLATION CONFIGURATION .............................................................................................. 4

2.1 PREREQUISITES ...................................................................................................................................... 4 2.2 ENVIRONMENT ...................................................................................................................................... 4 2.3 GENERIC SOFTWARE .............................................................................................................................. 8 2.4 PREINSTALLATION ACTIVITIES ................................................................................................................... 8 2.5 PRE-UPGRADE ACTIVITIES ..................................................................................................................... 13

3. INSTALLING THE ANALYTICAL APPLICATION ................................................................................... 17

3.1 KEY CONSIDERATIONS TO UPGRADE IN A CUSTOMIZED ENVIRONMENT: ........................................................... 17 3.2 OFS ECONOMIC CAPITAL ADVANCED RELEASE 1.1.2.0.0 INSTALLATION ........................................................ 17

3.2.1 Machine A Product Application Layer .................................................................................. 18 3.2.2 Machine B Product Database Layer ..................................................................................... 39 3.2.3 Machine C Product Web Layer ............................................................................................. 46

3.3 OFS ECONOMIC CAPITAL ADVANCED RELEASE 1.1.2.0.0 INSTALLATION- SILENT MODE ................................... 52 3.4 POST INSTALLATION ACTIVITIES .............................................................................................................. 52

4. OFS ECONOMIC CAPITAL ADVANCED V1.1.2.0.0 ANALYTICS CONFIGURATION ................................ 55

Installation Manual


1. About this Manual 1.1 Oracle Financial Services Analytical Applications Infrastructure

Overview

Oracle Financial Services Analytical Application Infrastructure (OFSAAI) is an analytical application platform which has been architected to be multi-tiered and open-systems compliant. OFSAAI is fully web-enabled. Its a 100% thin-client, browser-based interface with zero foot print which dramatically reduces the cost of application deployment. All OFSAAI processes, including those related to business, are metadata-driven, thereby providing a high degree of operational and usage flexibility, and a single consistent view of information to all users.

OFSAAI product suite includes a rules-framework designer engine, Unified Metadata Manager which has a semantic layer of metadata abstraction that is common over both relational and OLAP repositories.

1.2 Analytical Applications Overview

Analytical Applications like Oracle Financial Services Economic Capital Advanced are pre-packaged on OFSAAI and are ready to install.

The Oracle Financial Services Economic Capital Advanced Release 1.1.2.0.0 helps a firm calculate the capital level required by the bank to cover the losses within a given probability by using Economic Capital methodologies which can be applied across products, lines of business and other segments as required.

1.3 Audience

This manual is meant for the OFSAAI Application System Administrator as they play an integral part in installing the Oracle Financial Services Analytical Applications.

1.4 Scope

This manual provides a step-wise instruction to install the Oracle Financial Services Economic Capital Advanced Release 1.1.2.0.0, in an existing OFSAAI v7.3.3.3.0 Platform hosted on AIX 5.3/6.1, RHEL 5.3 /5.8, OEL 5.3/5.8 or Sun Solaris 5.10 Server Oracle 11g R2 (11.2.0.2.0) Tomcat 7.0.19, Websphere 7.0.0.17 or Web logic 10.3.5.0 64 bit environment-Oracle Business Intelligence Suite Enterprise Edition 11.1.1.7.1(Build 130605.1300 64-bit).

1.5 Organization of the Manual

The Installation Manual is organized into the following chapters:

Prerequisites section identifies the hardware and base software environment that is required for successful installation and functioning of Oracle Financial Services Economic Capital Advanced Release 1.1.2.0.0.

Installing the Application section details the pre-installation activities followed by a step-by-step instruction on the various installation options.

Installation Manual


Post Installation Activities section details the steps that are required to be performed after the successful installation of the Oracle Financial Services Economic Capital Advanced Release 1.1.2.0.0.

1.6 Conventions Used in this Manual

References to sections or chapters in the manual are displayed in Italics.

Screen names are displayed in the following manner:

Introduction screen

Options and buttons are displayed in Bold.

Notes are displayed as follows:

NOTE:

It is important that the password should be 6 characters long. If you do not adhere to this pre-requisite, you will see a system message that reads Password must be at least 6 characters long.

Installation Manual


2. Pre-installation Configuration The list of pre-configurations required to install and run the OFSAAI 7.3.3.3.0 Infrastructure is stated in this section. Further, the installation process requires certain environmental variables to be set prior to starting the installation. Ensure the following requirements are met before installation.

Prerequisites

Environment

Generic Software

Preinstallation Activities

Pre-Upgrade Activities

2.1 Prerequisites

Infrastructure version 7.3.3.3.0 should be installed, and the below patches should be applied.

o Bug 18396077

o Bug 18296748

o Bug 18504217

o Bug 18467042

o Bug 18357346

Refer to OFSAAI Installation and Configuration Guide.

2.2 Environment

RHEL 5.3 / 5.8 - OEL 5.3 / 5.8 - Oracle 11g R2 (11.2.0.2.0) - Web logic 10.3.5.0 / Websphere 7.0.0.17 / Tomcat 7.0.19 (64 bit)

Type Description

OS Red Hat Enterprise Linux Server release 5.8 (Tikanga) - 64 bit

Oracle Enterprise Linux Server release 5.8 (Carthage) - 64 bit

Red Hat Enterprise Linux Server release 5.3 (Tikanga) - 64 bit

Oracle Enterprise Linux Server release 5.3 (Carthage) - 64 bit

Installation Manual


Type Description

Infrastructure Application Server

Oracle Client 11g R2 (11.2.0.2.0) - 64 bit

Sun JRE Standard Edition 1.6.0_25 - 64 bit

Sun JDK Standard Edition 1.6.0_25 - 64 bit

Infrastructure Database Server

Oracle Database Server 11g Release 2 (11.2.0.2.0)-64 bit with or without RAC [Enterprise edition with partitioning capability]



Infrastructure Web Server

Oracle 11g R2 (11.2.0.2.0) JDBC driver (Oracle thin driver)



Web logic 10.3.5.0 with JDK Standard Edition 1.6.0_25 -64 bit

Websphere 7.0.0.17 with IBM Runtime, Java Technology JDK 1.6.0 (SR9 FP1) - 64 bit

Apache Tomcat 7.0.19 pointing to JDK Standard Edition 1.6.0_25 - 64 bit

Note the following:

Any one of the above mentioned web servers (Web logic, Websphere, or Apache Tomcat) installation is required based on the requirement.

Reporting Tool Oracle Business Intelligence Enterprise Edition Suite 11.1.1.7.1

Solaris 5.10 - Oracle 11g R2 (11.2.0.2.0) - Web logic 10.3.5.0 / Websphere 7.0.0.17 / Tomcat 7.0.19 (64 bit)

Type Description

OS Oracle Solaris v5.10 Update 9 (9/10 s10s_u9wos_14a) SPARC sun4v - 64 bit

Installation Manual


Type Description













Web logic 10.3.5.0 with JDK Standard Edition 1.6.0_25 -64 bit

Websphere 7.0.0.17 with IBM Runtime, Java Technology JDK 1.6.0 (SR9 FP1) - 64 bit

Apache Tomcat 7.0.19 pointing to JDK Standard Edition 1.6.0_25 - 64 bit

Note the following:



Installation Manual


AIX 5.3 (ML 12) & AIX 6.1 (ML 07) - Oracle 11g R2 (11.2.0.2.0) - Web logic 10.3.5.0 / Websphere 7.0.0.17 / Tomcat 7.0.19 (64 bit)

Type Description

OS AIX 5.3 (ML 12) - 64 bit

AIX 6.1 (ML 07) - 64 bit



IBM AIX Runtime, Java Technology JRE 1.6.0 (SR10) - 64 bit

IBM AIX Runtime, Java Technology JDK 1.6.0 (SR10) - 64 bit









Web logic 10.3.5.0 pointing to IBM AIX Runtime, Java Technology JDK 1.6.0 (SR10)- 64 bit

Websphere 7.0.0.17 pointing to IBM Runtime, Java Technology JDK 1.6.0 (SR9 FP1) - 64 bit

Apache Tomcat 7.0.19 pointing to IBM AIX Runtime, Java Technology JDK 1.6.0 (SR10)- 64 bit

Note the following:



Installation Manual


2.3 Generic Software

Type Description

Other Software OFSAAI is certified on both OPEN LDAP 2.2.29+ and Oracle Internet Directory v11.1.1.3.0. Ensure that you have installed any one of the following for OFSAAI authentication purposes.

Note:

OPEN LDAP needs to be installed on Microsoft Windows machine only.

Hummingbird Exceed 7.0 has to be installed on a Microsoft Windows machine as a simulator for remote installation.

Note:

Hummingbird Exceed is required for GUI Mode of installation.

Front End Access Microsoft Internet Explorer 8/9

Microsoft Office 2003/2007

Client Machines Windows XP SP3/Windows 7

The screen resolutions supported are 1024*768 and 1280*1024

Adobe Reader 8.0

Java Plug-in 1.6.0_21

Note:

Ensure that Java Plug-in is enabled in the browser settings.

Enable caching of static content (static files, images, CSS, etc) for browser client.

Cookies should be disabled.

NOTE:

The Oracle Financial Services Economic Capital Advanced Release 1.1.2.0.0 installer download contains the Erwin XML file only, which is required for uploading the model. This file is sufficient to install the application. However, you cannot open the XML file in the ERwin data modeler tool due to which it cannot be used for any data model customizations. The ERwin file is delivered as a patch and should be downloaded separately. This file can be used for any type of customizations of the data model.

2.4 Preinstallation Activities

The following is the preinstallation checklist to ensure the readiness to start installing Oracle

Installation Manual


Financial Services Analytical Applications:

Oracle Financial Services Analytical Applications Infrastructure Release 7.3.3.3.0 must be successfully installed on AIX 5.3/6.1, RHEL 5.3 /5.8, OEL 5.3/5.8 or Sun Solaris 5.10 Server Oracle 11g R2 (11.2.0.2.0) Tomcat 7.0.19, Websphere 7.0.0.17, and Web logic 10.3.5.0 64 bit environment.

NOTE:

Refer the Appendix B section in the OFSAAI 7.3.3.0.0 Installation Guide for customized memory settings for model upload, depending on the available hardware configuration. For guidance in altering the memory settings contact Oracle Support.

If the infrastructure is installed on a multitier environment, then execute the following commands in the DB Layer terminal:

chmod -R 777 < ftpshare folder >

Navigate to the ftpshare folder and set the umask shown as follows to ensure that all the new files created have 666 file permissions.

cd < ftpshare folder >

umask 0000

The config schema, atomic schema, and three sandbox schemas should be of distinct oracle database users.

Default and Temporary table space assigned to atomic schema user should be allocated with required space.

The Information Domain schema makes use of the tables from the configuration schema. To create a new infodom, execute the file /config_table_privileges_for_atomic_user.sql from the Infrastructure config database before creating the new infodom. These Privileges should be given to Production Schema and Sandbox Schemas (essentially all the Atomic schemas).

Add an Atomic schema TNS entry to TNSNames.ora.

The following grants must be given to atomic schema user (Both production and Sandbox)

grant create session to

grant create view to

grant create sequence to

grant create table to

grant create procedure to

grant create any index to

grant create trigger to

grant create synonym to

grant debug connect session to

http://docs.oracle.com/cd/E28070_01/books/Infrastructure/7.3.3.X.0/OFSAAI_7.3.3.0.0_Installation_Guide_UNIX.pdfhttps://support.oracle.com/

Installation Manual


grant debug any procedure to

grant create any materialized view to

The following grants must be given from Config User to Atomic User (Both production and Sandbox):

grant select on PR2_OBJECT_TL to

grant select on PR2_OBJECT_TYPES to

grant select on CSSMS_USR_PROFILE to

grant select on CSSMS_ROLE_MAST to

grant select on CSSMS_GROUP_MAST to

grant select on CSSMS_FUNCTION_MAST to

grant select on CSSMS_USR_GROUP_MAP to

grant select on CSSMS_USR_GROUP_DSN_SEG_MAP to

grant select on CSSMS_ROLE_FUNCTION_MAP to

grant select on CSSMS_GROUP_ROLE_MAP to

grant select on CSSMS_SEGMENT_MAST to

grant select on BATCH_TASK to

grant select on CSSMS_USR_DSN_SEG_MAP to

grant select on CSSMS_USR_ROLE_MAP to

grant select on CSSMS_METADATA_SEGMENT_MAP to

grant select on BATCH_RUN to

grant select on PR2_FILTERS to

grant select on PR2_TASK_FILTER to

grant select on PR2_TASK_FILTER_DETAIL to

grant select on ST_STRESS_MASTER to

grant select on ST_SCENARIO_MASTER to

grant select on ST_SHOCK_MASTER to

grant select on BATCH_MASTER to

grant select on ICC_MESSAGELOG to

grant select on PR2_MASTER to

grant select on PR2_RUN_REQUEST to

grant select on pr2_rule_map to

grant select on pr2_rule_map_pr to

grant select on pr2_rule_map_pr_tmp to

grant select on pr2_rule_map_exclude to

grant select on pr2_rule_map_exclude_pr to

grant select on pr2_rule_map_exclude_pr_tmp to

Installation Manual


grant select on pr2_run_object to

grant select on pr2_run_object_member to

grant select on pr2_run_map to

grant select on pr2_run_execution_b to

grant select on pr2_run_execution_filter to

grant select on pr2_firerun_filter to

grant select on pr2_filters to

grant select on configuration to

grant select on batch_parameter to

grant select on component_master to

grant select on FORMS_LOCALE_MASTER to

grant select on setupinfo to

grant select on LOCALEREPOSITORY to

Copy all the contents of the Oracle Financial Services Economic Capital Advanced Release 1.1.2.0.0 installer download directory to the server location (including the DataModel directory). Provide read, write and execute permission to all the files present in this directory.

Specify the log file path and name in the log4j.xml. Update the value attribute highlighted in the following xml:

Ensure the path given in the log4j.xml file has read, write or execute permission.

Execute the config_table_privileges_for_atomic_user.sql script in configuration schema. This file is present in the $FIC_HOME directory.

Ensure FICServer is up and running before proceeding for installation. From SYS DBA grant select permission to config and atomic user for V_$PARAMETER

table. grant select on V_$PARAMETER to &config_db_user;

grant select on V_$PARAMETER to &atomic_db_user;

grant select on V_$PARAMETER to &nonsandbox_db_user;

grant select on V_$PARAMETER to &secsandbox_db_user;

grant select on V_$PARAMETER to &cfsandbox_db_user;

Installation Manual


Check for "export LDR_CNTRL=MAXDATA=0x40000000" in the .profile, if present then comment it, execute the .profile then trigger the Setup.sh.

Following data model related information needs to be addressed, if any OFSAA application is installed on the existing infodom where already other OFSAA applications are installed.

o You have the option either to do an incremental or a sliced model upload.

o If you opt for sliced model upload then, you need to ensure that all the related child tables are part of the sliced model. If not, you need to merge the data model of application which needs to be installed with the data model available in the environment, take a slice out of it and use.

o If you opt for incremental model upload, then you need to merge the data model of application which needs to be installed with the data model available in the environment.

For a multitier installation, check if Reveleus.SEC file is present in $FIC_HOME/conf in web layer. If this file is not present in this path, then copy the file from $FIC_HOME/conf in app layer to $FIC_HOME/conf in web layer.

For a single tier installation, the installer is required to be loaded only once on the machine that hosts all the OFSAAI tiers.

Execute the below insert scripts in the existing Configuration Schema (this is applicable only for an upgrade activity, Ignore this step if entry already present in configuration table)

Note:

o Replace the ##PROD_INFODOM## to production information domain name and ##NONSAND_INFODOM## to nonsandbox information domain name in the below query.

INSERT INTO CONFIGURATION (PARAMNAME, PARAMVALUE, DESCRIPTION)VALUES('CREC_##PROD_INFODOM##_NONSAND','##NONSAND_INFODOM##', ' Sandbox dsnid(NONSAND) mapped to production infodom').

o Replace the ##PROD_INFODOM## to production information domain name and ##SECSAND_INFODOM## to secsandbox information domain name in the below query.

INSERT INTO CONFIGURATION (PARAMNAME, PARAMVALUE, DESCRIPTION)VALUES('CREC_##PROD_INFODOM##_SECSAND','##SECSAND_INFODOM##', ' Sandbox dsnid(SECSAND) mapped to production infodom').

o Replace the ##PROD_INFODOM## to production information domain name and ##CFSAND_INFODOM## to sandbox information domain name in the below query.

INSERT INTO CONFIGURATION (PARAMNAME, PARAMVALUE, DESCRIPTION)VALUES('CREC_##PROD_INFODOM##_CFSAND','##CFSAND_INFODOM##', ' Sandbox dsnid(CFSAND) mapped to production infodom').

Installation Manual


2.5 Pre-Upgrade Activities This section is applicable only for users upgrading from OFS Economic Capital Advanced version 1.1.0.0.0 to OFS Economic Capital Advanced version 1.1.2.0.0. Back-up of Database schema and Files

Back-up the existing config and atomic schema of the information domain that is upgraded. This can be used to restore the application, in case of any failures during upgrade.

Back-up FTPSHARE, $FIC_HOME and FIC_WEB_HOME webroot folders of the existing environment.

Back-up OBIEE related objects (Repository, Images, and Catalog file) that are upgraded.

Pre-Model steps:

1) Delete scripts for specific metadata objects that have an impact on the columns being dropped by the application. This will be executed by the installer as a pre-model upload step.

2) Data backup scripts for the application related tables are executed as part of pre-model upload scripts. The data is deleted from the back up tables. The installer executes these scripts.

3) Drop all the tables which were created using scripts in Economic Capital Advanced version 1.1.0.0.0 and which are a part of the Economic Capital Advanced version 1.1.2.0.0 data model. Pre model scripts include drop statements for these tables.

4) Delete scripts for the metadata, which has been updated or deleted. This will be executed as part of the pre-model upload scripts.

5) Installer will ignore the ORA errors specific to table already exists and table or view doesnt exist while executing the Pre-Model Scripts.

Upgrade from OFS Economic Capital Advanced 1.1.0.0.0

The following steps are applicable for customers upgrading from OFS Economic Capital Advanced version 1.1.0.0.0. You need to perform these steps before proceeding with installation.

Database changes 1) Create a backup of the table rev_etl_mapping in the config schema.

Create table rev_etl_mapping_11 as select * from rev_etl_mapping;

2) Execute the following scripts in the Config Schema. Data into this table is related to mapping information.

delete from rev_etl_mapping; commit; 1) The below scripts have to be executed in Config Schema:

ALTER TABLE PR2_RULE_MAP DISABLE CONSTRAINT FK_PR2_RULE_MAP_1

Installation Manual


/ ALTER TABLE PR2_RULE_OBJECT DISABLE CONSTRAINT FK_PR2_RULE_OBJECT_1 / ALTER TABLE PR2_RULE_QUERY DISABLE CONSTRAINT FK_PR2_RULE_QUERY_1 / ALTER TABLE PR2_RUN_OBJECT DISABLE CONSTRAINT FK_PR2_RUN_OBJECT_1 / ALTER TABLE PR2_RUN_OBJECT_PARAMETER DISABLE CONSTRAINT FK_PR2_RUN_OBJECT_PARAMETER_1 / ALTER TABLE PR2_RUN_OBJECT_MEMBER DISABLE CONSTRAINT FK_PR2_RUN_OBJECT_MEMBER_1 / ALTER TABLE PR2_RUN_MAP DISABLE CONSTRAINT FK_PR2_RUN_MAP_1 / ALTER TABLE PR2_RUN_EXECUTION_B DISABLE CONSTRAINT FK_PR2_RUN_EXECUTION_B_1 /

T2T changes The existing T2Ts will be replaced during upgrade installation. Hence, take a backup of existing T2Ts. The T2T definitions are present in the following folders: /STAGE //erwin/sources Following are the new T2T Definitions in OFS Economic Capital Advanced 1.1.2.0:

CALC_ACCT_HEAD_POP_EC CALC_ACCT_HEAD_RWA_POP_EC CAPITAL_CALC_ACCT_HEAD_POP CAPITAL_STANDARD_MAPPING_STANDARD_ACCT_HEAD_DATA_POP CAPITAL_STD_ACCT_HEAD_POP GL_CAPITAL_ACCT_HEAD_POPULATION_EC PARTY_FINANCIALS_DATA_POP PARTY_TYPE_RECLASSIFICATION_POPULATION_IRB

Following are the modified T2Ts:

CALC_STD_ACCT_HEAD_POP COUNTERPARTY_DATA_POPULATION COUNTERPARTY_EQUITY_POPULATION DIM_EXP_MINCOL_POPULATION DIST_TO_DEFAULT_POPULATION EC_CR_SUMMARY ECONOMIC_CAPITAL_SUMMARY ENTITY_INFO_DATA_POP ENTITY_SHR_HLD_PERCENT_POP EQUITY_EXP_LP_DATA_POPULATION EQUITY_OTHER_ASSET_LOSS_POPULATION EXP_MITIGANT_MAPPING_POP_NON_SEC EXPENSE_DATA_POPULATION GENERAL_MKT_DATA_POPULATION

Installation Manual


INCOME_DATA_POPULATION ISSUER_DATA_POPULATION ISSUER_EQUITY_POPULATION MITIGANT_DATA_POPULATION NET_POOL_EXPOSURE_CREATION NET_POOL_SUB_EXPOSURES NETTABLE_POOL_OTC_REPO_POPULATION NON_SEC_EQUITY_DATA_POPULATION NON_SEC_EXP_DATA_POPULATION NON_SEC_NET_POOL_POPULATION RAPM_POPULATION RATING_DETAILS_DATA_POPULATION RATING_TRANSITION_MATRIX_POPULATION RESERVE_DATA_POPULATION SEC_EXP_DATA_POPULATION SEC_POOL_DATA_POPULATION SUB_EXP_MINCOL_POPULATION SUB_EXPOSURES_NON_SEC SUB_EXPOSURES_SEC TIME_TO_DEFAULT_TO_PEAK_EXP TRANCHE_DATA_POPULATION UNCOV_NET_POOL_EXP_MAPPING. UNCOV_NET_POOL_MITIGANT UNCOV_NET_POOL_SUB_EXP UNCOV_NETTABLE_POOL UNCOV_NON_SEC_EXP_MAPPING UNCOV_NON_SEC_EXPOSURES UNCOV_NON_SEC_MITIGANT UNCOV_SEC_EXP_MAPPING UNCOV_SEC_EXPOSURES UNCOV_SEC_MITIGANT

Following are the deleted T2Ts:

CALC_ACCT_HEAD_POP CALC_ACCT_HEAD_RWA_POP COUNTERPARTY_DATA_POPULATION_BULK DEDUCTION_ASSET_EXP_POPULATION DIM_DEDUCTION_ASSET_EXP_POPULATION EC_STD_ACCT_HEAD_RWA_POPULATION EXP_MITIGANT_MAPPING_POP_SEC GL_ACCT_CAPITAL_HEAD_POPULATION GL_STD_ACCT_HEAD_POP ISSUER_DATA_POPULATION_BULK NET_POOL_EXP_MITIGANT_MAPPING STD_ACCOUNTING_HEAD_POPULATION STD_ACCT_HEAD_DED_POP

If any customizations were done on the earlier T2T's, then it needs to be done again on these T2T definitions. Data Model Changes

Installation Manual


If Data model is not customized, following steps will be done by the upgrade installer. The new RPD and Catalog needs to be deployed manually:

1) OFS Economic Capital Advanced version 1.1.2.0.0 sliced data model is uploaded in Sliced Model Upload mode.

2) Execute the Config and atomic scripts.

3) Replace XMLs, executables and other components

If Data Model is customized, then it is suggested to:

1. Open customized and out of box models using ERwin Data Modeler tool.

2. Go to "Tools" and select "Complete Compare".

3. Select the existing CREC Data model on Left Model, in the Compare window.

4. Select the extracted CREC Data model on Right Model.

5. In "Type Selection" check "Subject Area".

6. In "Advanced" option, un-check ALL except "Auto Close Database/Script Models" and click Compare.

7. Resolve differences by applying all the changes mentioned in the CREC_DataModel Difference v11-v112.xls file.

8. Click "Finish" and click Close.

9. Save the file as XML in "AllFusion Repository Format".

Example: CREC_Datamodel.xml

The list of tables that are backed up and restored can be found in Backup_restore.xlsx

Back_Restore.xlsx

CREC_DataModel

Difference v11-v112. The metadata and the PR2 objects that were available in OFS EC 1.1.0.0.0 and not used in any segments of OFS EC 1.1.2.0.0 are deleted during the pre upgrade process.

Sheet1

Table NameBackup Table NameBackup table scriptDelete Data scriptDrop table ScriptRestoration script

DIM_BUSINESS_UNITDIM_BUSINESS_UNIT_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlDIM_BUSINESS_UNIT.sql

DIM_CAPITAL_COMP_GROUPDIM_CAPITAL_COMP_GROUP_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFSI_CPTY_EXPECTED_EXPOSURE.sql

DIM_COUNTRYDIM_COUNTRY_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlDIM_COUNTRY.sql

DIM_SEC_FACILITY_TYPEDIM_SEC_FACILITY_TYPE_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlDIM_SEC_FACILITY_TYPE.sql

EXP_MITIGANT_MAPPINGEXP_MITIGANT_MAPPING_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlEXP_MITIGANT_MAPPING.sql

FCT_CALC_ACCT_HEADFCT_CALC_ACCT_HEAD_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_CALC_ACCT_HEAD.sql

FCT_COST_ACCOUNTING_HEADFCT_COST_ACCOUNTING_HEAD_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_COST_ACCOUNTING_HEAD.sql

FCT_COUNTERPARTY_DETAILSFCT_COUNTERPARTY_DETAILS_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_COUNTERPARTY_DETAILS.sql

FCT_CUSTOMER_DETAILSFCT_CUSTOMER_DETAILS_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_CUSTOMER_DETAILS.sql

FCT_DIST_TO_DEFAULTFCT_DIST_TO_DEFAULT_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_DIST_TO_DEFAULT.sql

FCT_EC_CR_SUMMARYFCT_EC_CR_SUMMARY_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_EC_CR_SUMMARY.sql

FCT_EC_SUMMARYFCT_EC_SUMMARY_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_EC_SUMMARY.sql

FCT_ENTITY_INFOFCT_ENTITY_INFO_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_ENTITY_INFO.sql

FCT_ENTITY_SHR_HLD_PERCENTFCT_ENTITY_SHR_HLD_PERCENT_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_ENTITY_SHR_HLD_PERCENT.sql

FCT_EQUITY_EXPOSURESFCT_EQUITY_EXPOSURES_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_EQUITY_EXPOSURES.sql

FCT_ISSUER_DETAILSFCT_ISSUER_DETAILS_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_ISSUER_DETAILS.sql

FCT_MITIGANTSFCT_MITIGANTS_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_MITIGANTS.sql

FCT_NETTABLE_POOLFCT_NETTABLE_POOL_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_NETTABLE_POOL.sql

FCT_NON_SEC_EXPOSURESFCT_NON_SEC_EXPOSURES_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_NON_SEC_EXPOSURES.sql

FCT_RAPMFCT_RAPM_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_RAPM.sql

FCT_RESERVESFCT_RESERVES_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_RESERVES.sql

FCT_SEC_EXPOSURESFCT_SEC_EXPOSURES_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_SEC_EXPOSURES.sql

FCT_SECURITIZATION_POOLFCT_SECURITIZATION_POOL_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_SECURITIZATION_POOL.sql

FCT_SECURITIZATION_TRANCHEFCT_SECURITIZATION_TRANCHE_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_SECURITIZATION_TRANCHE.sql

FCT_STANDARD_ACCT_HEADFCT_STANDARD_ACCT_HEAD_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_STANDARD_ACCT_HEAD.sql

FCT_SUB_EXPOSURESFCT_SUB_EXPOSURES_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_SUB_EXPOSURES.sql

FCT_TIME_TO_PEAK_EXPOSUREFCT_TIME_TO_PEAK_EXPOSURE_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_TIME_TO_PEAK_EXPOSURE.sql

FCT_TRANSITION_MATRIXFCT_TRANSITION_MATRIX_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlFCT_TRANSITION_MATRIX.sql

STG_ACCOUNTING_HEADSTG_ACCOUNTING_HEAD_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlSTG_ACCOUNTING_HEAD.sql

stg_securitization_poolstg_securitization_pool_UPdAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlstg_securitization_pool.sql

STG_SECURITIZATION_TRANCHESTG_SECURITIZATION_TRANCHE _UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlSTG_SECURITIZATION_TRANCHE.sql

STG_COUNTRY_MASTERSTG_COUNTRY_MASTER_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlSTG_COUNTRY_MASTER.sql

STG_SEC_FACILITY_TYPE_MASTERSTG_SEC_FACILITY_TYPE_MAST_UPDAtomic_Premodel.sqlAtomic_Premodel.sqlpost_instalation_drop_backup_tables.sqlSTG_SEC_FACILITY_TYPE_MASTER.sql

Sheet2

Sheet3

Back_Restore.xlsx

New tables

NEW_TABLES

FSI_ISSUE_RATING_DETAILS

DIM_METHODOLOGIES

DIM_VALUATION_METHOD

DIM_CURRENCY

STG_SOURCE_PARTY_PROFILES

DIM_POSITION_CATEGORY

FCT_PARTY_FINANCIALS

DIM_DATES

FSI_CAPITAL_STANDARD_MAPPING

FSI_PARTY_ROLE_MAP

DIM_BUSINESS_SEGMENT

STG_PARTY_TYPE_MASTER

STG_SOVEREIGN_RATING_DETAILS

STG_ORG_STRUCTURE_MASTER

DIM_COMMODITY

DIM_CREDIT_RATING

DIM_CONC_TYPE

DIM_PARTY_TYPE

DIM_CONC_MEASURE

RUN_PARAMETERS

FSI_EQUITY_TRADING_STATUS

STG_PARTY_MASTER

TEMP_OPTIMIZER_OUTPUT

FSI_SOVEREIGN_RATING_DETAILS

DIM_LOCATION

DIM_MORTGAGE_OCCUPANCY

DIM_MITIGANT_TREATMENT_TYPE

FSI_PARTY_TYPE_CLASSIFICATION

STG_ACCOUNT_RATING_DETAILS

STG_PARTY_FINANCIALS

DIM_STD_MITIGANT_TYPE

DIM_ISSUE

RUN_EXE_PARAMETERS

USR_DEFINED_RUN_PARAMETERS

DIM_INSTRUMENT_TYPE

DIM_STANDARD_PRODUCT_TYPE

STG_PARTY_ROLE_MAP

DIM_PARTY

DIM_FINANCIAL_YEAR

FCT_CONC_RISK_MEASURE

TEMP_POOLING_OUTPUT

DIM_STANDARD_PARTY_TYPE

DIM_IFSB_CONTRACT_TYPE

DIM_VEHICLE_TYPE

STG_INSTRUMENT_RATING_DETAILS

FSI_PARTY_RATING_DETAILS

DIM_CAPITAL_ACCT_HEAD

DIM_PD_BAND_USFR

DIM_BANDS

DIM_RISK_WEIGHT

DIM_CREDIT_STATUS

DIM_ACCT_STATUS

DIM_FINMA_NOGA

DIM_CLEARED_TXN_BANK_ROLE

DIM_PROPERTY_TYPE

FCT_CAPITAL_ACCT_HEAD

STG_PARTY_RATING_DETAILS

Dropped tables

DROP_TABLES

STG_GUARANTEES

STG_LC_CONTRACTS

STG_SWAPS_CONTRACTS

DIM_MARKET_RISK_REP_LINE

FCT_MARKET_RISK_SUMMARY

STG_BILLS_CONTRACTS

STG_LOAN_CONTRACTS

STG_NETTABLE_LIABILITIES

STG_RECEIVABLES_UNDERLYING

STG_SEC_INCEPTION_DATA

STG_ISSUE_DETAILS

STG_FUTURES

STG_BRANCH_MASTER

STG_CUSTOMER_DETAILS

STG_CARDS

STG_CUST_EDUCATION_MASTER

STG_HOME_OWNERSHIP_MASTER

STG_OPTION_CONTRACTS

STG_REPO_CONTRACTS

STG_RETAIL_EXPOSURES

STG_SEC_STATUS_MASTER

STG_COLLATERALS

STG_INVESTMENTS

STG_PRODUCT_TYPE_MASTER

STG_SEC_TYPE_MASTER

STG_SECURITIZATION_ACTIVITY

FCT_OPS_RISK_SUMMARY

STG_MM_CONTRACTS

STG_MARITAL_STATUS_MASTER

STG_SALES_CHANNEL_MASTER

Dropped Columns

TABLE_NAMECOLUMN_NAMEDATA_TYPENULLABLEIS_PKIS_FKDOMAINDEFAULT_VAL

EXP_MITIGANT_MAPPINGN_MITIGANT_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

EXP_MITIGANT_MAPPINGN_BASEL_COLL_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

EXP_MITIGANT_MAPPINGFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_CALC_ACCT_HEADFIC_MIS_DATEDATENOT NULLYESYESDATETIME

DIM_SEC_FACILITY_TYPEV_SEC_FACILITY_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_CUSTOMER_DETAILSFIC_MIS_DATEDATENOT NULLYESNODATETIME

FCT_DIST_TO_DEFAULTFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_COST_ACCOUNTING_HEADFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_COST_ACCOUNTING_HEADN_LEG_REP_SKEYNUMBER(5)NOT NULLYESYESSURROGATEKEY_MEDIUM

FCT_COUNTERPARTY_DETAILSN_D_CUST_AGE_BANDNUMBER(5)NULLNOYESNUMBER_SHORT

FCT_ENTITY_INFOFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_EQUITY_EXPOSURESFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_ENTITY_SHR_HLD_PERCENTFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_EC_CR_SUMMARYN_LEG_REP_SKEYNUMBER(5)NOT NULLYESYESSURROGATEKEY_MEDIUM

FCT_EC_CR_SUMMARYFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_EC_SUMMARYFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_EC_SUMMARYN_LEG_REP_SKEYNUMBER(5)NOT NULLYESYESSURROGATEKEY_MEDIUM

FCT_EQUITY_OTHER_ASSET_LOSSFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_EQUITY_EXPOSURESN_CUST_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_EQUITY_EXPOSURESN_CUST_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_EQUITY_EXPOSURESN_BASEL_CUST_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_INCOME_ACCOUNTING_HEADN_LEG_REP_SKEYNUMBER(5)NOT NULLYESYESSURROGATEKEY_MEDIUM

FCT_ISSUER_DETAILSN_D_ISSUER_AGE_BANDNUMBER(5)NULLNOYESNUMBER_SHORT

FCT_INCOME_ACCOUNTING_HEADFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_MITIGANTSN_BASEL_COLL_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_COLLATERAL_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_MITIGANTSV_RATING_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_NON_SEC_EXPOSURESV_RATING_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_NON_SEC_EXPOSURESFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_NETTABLE_POOLN_PD_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NETTABLE_POOLN_EL_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NETTABLE_POOLFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_MITIGANTSN_NUMBER_OF_CONTRACTSNUMBER(22)NULLNONONUMBER_GENERIC

FCT_MITIGANTSV_SOV_RATING_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_NON_SEC_EXPOSURESN_CUST_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_DELQ_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_EL_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_CUST_INCOME_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_INSTR_ISSUER_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_LTV_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_USFR_LTV_BAND_CODENUMBER(5)NULLNONO

FCT_NON_SEC_EXPOSURESN_PD_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_BASEL_CUST_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_BASEL_ISSUER_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_BASEL_INSTR_ISSUER_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_RESERVESFIC_MIS_DATEDATENULLNOYESDATETIME

FCT_RAPMN_LEG_REP_SKEYNUMBER(5)NOT NULLYESYESSURROGATEKEY_MEDIUM

FCT_RAPMFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_NON_SEC_EXPOSURESN_RW_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_BASEL_ISSUER_FRGN_CUR_RATINGNUMBER(5)NULLNONOCODE_NUMERIC_SHORT

FCT_NON_SEC_EXPOSURESN_BASEL_ISSUER_DOM_CUR_RATINGNUMBER(5)NULLNONOCODE_NUMERIC_SHORT

FCT_NON_SEC_EXPOSURESV_SOV_RATING_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_NON_SEC_EXPOSURESV_ISSUER_FOREIGN_CUR_RATING_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_NON_SEC_EXPOSURESV_ISSUER_DOM_CUR_RATING_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_SECURITIZATION_POOLFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_SECURITIZATION_TRANCHEV_RATING_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_SECURITIZATION_TRANCHEFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_STANDARD_ACCT_HEADFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_SEC_EXPOSURESFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_SEC_EXPOSURESV_RATING_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_SEC_EXPOSURESN_DELQ_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SEC_EXPOSURESN_RW_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_TRANSITION_MATRIXFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_TIME_TO_PEAK_EXPOSUREFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_SUB_EXPOSURESN_CUST_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SUB_EXPOSURESFIC_MIS_DATEDATENOT NULLYESYESDATETIME

FCT_SUB_EXPOSURESN_COLLATERAL_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SUB_EXPOSURESN_BASEL_COLL_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SUB_EXPOSURESN_PD_BAND_CODENUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

STG_SEC_FACILITY_TYPE_MASTERV_SEC_FACILITY_IDVARCHAR2(20)NOT NULLYESNOSTRING

New Columns

TABLE_NAMECOLUMN_NAMEDATA_TYPENULLABLEIS_PKIS_FKDOMAINDEFAULT_VAL

DIM_BASEL_PRODUCT_TYPEF_UNFUNDED_INDCHAR(1)NULLNONOFLAG

DIM_BUSINESS_UNITFIC_MIS_DATEDATENULLNONODATE

DIM_COUNTRYN_REGION_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

DIM_COUNTRYF_OECD_INDICATORCHAR(1)NULLNONOFLAG

DIM_COUNTRYF_DEFAULT_FLAGCHAR(1)NULLNONOFLAG

DIM_COUNTRYV_ISO_COUNTRY_CDVARCHAR2(3)NULLNONOCODE_SHORT

DIM_CUSTOMERV_D_INDUSTRY_CODE_TYPEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_CUSTOMERV_TICKER_SYMBOLVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_CUSTOMERV_STOCK_EXCHANGEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_CUSTOMERV_TAX_IDENTIFIERVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_CUSTOMERF_FINANCIAL_STMT_DISCLOSURECHAR(1)NULLNONOFLAG

DIM_CUSTOMERV_CUST_EMPLOYMENT_TYPE_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_CUSTOMERF_FRAUD_FLAGCHAR(1)NULLNONOFLAG

DIM_CUSTOMERF_BANKRUPTCY_FLAGCHAR(1)NULLNONOFLAG

DIM_CUSTOMERV_CUSTOMER_PARENT_GROUP_NAMEVARCHAR2(30)NULLNONOTEXT_SHORT_DESCRIPTION

DIM_CUSTOMERV_GOOGLEPLUS_ADDRESSVARCHAR2(100)NULLNONOTEXT_LONG_DESCRIPTION

DIM_CUSTOMERV_TWITTER_ADDRESSVARCHAR2(100)NULLNONOTEXT_LONG_DESCRIPTION

DIM_CUSTOMERV_FACEBOOK_ADDRESSVARCHAR2(100)NULLNONOTEXT_LONG_DESCRIPTION

DIM_CUSTOMERF_HARDSHIP_INDCHAR(1)NULLNONOFLAG

DIM_CUSTOMERV_DATA_ORIGINVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_CUSTOMERV_BENEFICIAL_OWNER_CATEGORYVARCHAR2(50)NULLNONOCODE_ALPHANUMERIC_LONG_TYPE3

DIM_CUSTOMER_TYPEV_CUST_CATEGORYVARCHAR2(1)NULLNONOINDICATOR

DIM_INDUSTRYV_D_INDUSTRY_SECTORVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_INDUSTRYV_GICS_CDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_INDUSTRYV_INDUSTRY_SUB_TYPE_DESCVARCHAR2(255)NULLNONODESCRIPTION

DIM_INDUSTRYV_INDUSTRY_SUB_TYPEVARCHAR2(30)NULLNONOTEXT_SHORT_DESCRIPTION

DIM_ISSUERV_ISSUER_RATING_CATEGORYVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_INDUSTRYV_INDUSTRY_SUB_CATEGORYVARCHAR2(30)NULLNONOTEXT_SHORT_DESCRIPTION

DIM_INDUSTRYV_INDUSTRY_SUB_CATEGORY_DESCVARCHAR2(255)NULLNONODESCRIPTION

DIM_INDUSTRYV_INDUSTRY_TYPEVARCHAR2(30)NULLNONOTEXT_SHORT_DESCRIPTION

DIM_INDUSTRYV_INDUSTRY_TYPE_DESCVARCHAR2(255)NULLNONODESCRIPTION

DIM_INDUSTRYV_NAICS_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_INDUSTRYV_SIC_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_INDUSTRYV_INDUSTRY_CATEGORYVARCHAR2(30)NULLNONOTEXT_SHORT_DESCRIPTION

DIM_INDUSTRYV_INDUSTRY_CATEGORY_DESCVARCHAR2(255)NULLNONODESCRIPTION

DIM_LOBN_LOB_IDNUMBER(14)NULLNONOID_NUMBER

DIM_ORG_STRUCTUREF_OPERATING_ENTITYCHAR(1)NULLNONOFLAG

DIM_ORG_STRUCTUREV_OCC_CHARTER_IDVARCHAR2(20)NULLNONOIDENTIFIER

DIM_ORG_STRUCTUREN_ORG_UNIT_IDNUMBER(14)NULLNONOID_NUMBER

DIM_ORG_STRUCTUREV_CAPITAL_ADEQUACY_REGULATORVARCHAR2(6)NULLNONOCODE_ALPHANUMERIC_SHORT_TYPE2

DIM_ORG_STRUCTUREF_FINANCIAL_SUBSIDIARY_INDCHAR(1)NULLNONOFLAG

DIM_ORG_STRUCTUREF_MERGED_ENTITY_INDCHAR(1)NULLNONOFLAG

DIM_ORG_STRUCTURED_MERGER_DATEDATENULLNONODATE

DIM_ORG_STRUCTUREV_FINANCIAL_INST_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_ORG_STRUCTUREV_CCAR_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_ORG_STRUCTUREF_REGULATORY_ENTITY_INDCHAR(1)NULLNONOFLAG

DIM_ORG_STRUCTUREV_PARTY_IDVARCHAR2(20)NULLNONOIDENTIFIER

DIM_MITIGANTV_MITIGANT_ADDRESS_STREET_NAMEVARCHAR2(255)NULLNONODESCRIPTION

DIM_MITIGANTV_CENSUS_TRACT_CODEVARCHAR2(50)NULLNONOCODE_ALPHANUMERIC_LONG_TYPE3

DIM_MITIGANTV_ORIG_LIEN_POSITION_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_MITIGANTV_ANCHOR_TENANT_NAMEVARCHAR2(100)NULLNONOSHORTNAME

DIM_MITIGANTN_PROPERTY_AREANUMBER(22,3)NULLNONONUMBER_VALUE

DIM_MITIGANTV_PROPERTY_AREA_UNITVARCHAR2(1)NULLNONOINDICATOR

DIM_MITIGANTV_MITIGANT_TYPEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_MITIGANTF_GUARANTEE_LIMITED_INDCHAR(1)NULLNONOFLAG

DIM_MITIGANTV_MITIGANT_REGION_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_MITIGANTV_ZIP_CODEVARCHAR2(10)NULLNONOCODE_ALPHANUMERIC_MEDIUM

DIM_MITIGANT_TYPEF_REAL_ESTATE_FLAGCHAR(1)NULLNONOFLAG

DIM_NETTING_AGREEMENTV_COUNTERPARTY_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_NETTING_AGREEMENTV_ENTITY_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_NETTING_AGREEMENTF_COLLATERALIZED_NETTING_SETCHAR(1)NULLNONOFLAG

DIM_NETTING_AGREEMENTV_COUNTRY_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_PRODUCTN_INTEREST_ONLY_TERMNUMBER(5)NULLNONOTERM

DIM_PRODUCTV_PROD_FMLY_CATEGORYVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_PRODUCTN_LOB_SKEYNUMBER(10)NULLNONOSURROGATEKEY_LONG

DIM_PRODUCTN_PRODUCT_LIMITNUMBER(22,3)NULLNONOAMOUNT

DIM_PRODUCTV_PROD_FMLY_SUB_CATEGORYVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_SEC_FACILITY_TYPEV_SEC_FACILITY_TYPE_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

DIM_REGIONV_REGION_DISPLAY_CODEVARCHAR2(5)NULLNONOCODE_ALPHANUMERIC_SHORT

DIM_REGIONV_PARENT_REGION_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

EXP_MITIGANT_MAPPINGN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_CALC_ACCT_HEADN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_CALC_ACCT_HEADV_RISK_TYPE_CODEVARCHAR2(20)NOT NULLYESNOCODE_ALPHANUMERIC_LONG

EXP_MITIGANT_MAPPINGF_EXP_MIT_POSITIVE_CORR_FLAGCHAR(1)NULLNONOFLAG

FCT_COST_ACCOUNTING_HEADN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_ENTITY_INFON_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_EC_SUMMARYN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_EC_CR_SUMMARYN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_DIST_TO_DEFAULTN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_CUSTOMER_DETAILSN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_COUNTERPARTY_DETAILSN_CUST_AGE_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_ENTITY_SHR_HLD_PERCENTF_THIRDPARTY_MINORITY_HOLD_INDCHAR(1)NULLNONOFLAG

FCT_ENTITY_SHR_HLD_PERCENTN_CONSOLIDATED_ASSETSNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_SHR_HLD_PERCENTV_CCY_CODEVARCHAR2(3)NULLNONOCODE_CURRENCY

FCT_ENTITY_SHR_HLD_PERCENTN_CONSOLIDATED_ASSETS_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_SHR_HLD_PERCENTN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_ENTITY_SHR_HLD_PERCENTN_EXCHANGE_RATENUMBER(11,6)NULLNONORATE

FCT_EQUITY_EXPOSURESN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_ENTITY_INFON_ADDITIONAL_TIER1_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFON_TIER2_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFON_NON_REG_ENTITY_PROP_EXPNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFON_COMMON_EQUITY_TIER1_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFON_LOSS_ABSORBENCY_BUCKETNUMBER(5)NULLNONONUMBER_SHORT

FCT_ENTITY_INFON_NON_REG_ENTITY_PCT_DED_CET1NUMBER(15,11)NULLNONOPERCENT_LONG

FCT_ENTITY_INFON_ACCOUNTING_CAPITAL_SURPLUSNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFON_CONSOLIDATED_ASSETSNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFOV_PARTY_IDVARCHAR2(40)NULLNONOCODE_ALPHANUMERIC_LONG_TYPE2

FCT_ENTITY_INFON_AVG_CONSOLIDATED_ASSETSNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFON_PARTY_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_ENTITY_INFOF_ULTIMATE_PARENT_ENTITY_FLAGCHAR(1)NULLNONOFLAG

FCT_ENTITY_INFON_AVG_CONSOLIDATED_ASSETS_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFON_EXCHANGE_RATENUMBER(11,6)NULLNONORATE

FCT_ENTITY_INFOV_CCY_CODEVARCHAR2(3)NULLNONOCODE_CURRENCY

FCT_ENTITY_INFON_COMMON_EQUITY_TIER1_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFON_ADDITIONAL_TIER1_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFOF_THIRDPARTY_MINORITY_HOLD_INDCHAR(1)NULLNONOFLAG

FCT_ENTITY_INFOF_REGULATORY_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_ENTITY_INFOF_SIGNIFICANT_INVESTMENT_INDCHAR(1)NULLNONOFLAG

FCT_ENTITY_INFOF_GSIB_FLAGCHAR(1)NULLNONOFLAG

FCT_ENTITY_INFOV_CAPITAL_ADEQUACY_REGULATORVARCHAR2(6)NULLNONOCODE_ALPHANUMERIC_SHORT_TYPE2

FCT_ENTITY_INFON_TIER2_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_ENTITY_INFON_THIRD_PARTY_INVST_T2_PCTNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_ENTITY_INFON_THIRD_PARTY_INVST_CET1_PCTNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_ENTITY_INFON_THIRD_PARTY_INVST_AT1_PCTNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_ENTITY_INFON_LOSS_ABS_OVERRIDENUMBER(15,11)NULLNONOPERCENT_LONG

FCT_INCOME_ACCOUNTING_HEADN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_INCOME_ACCOUNTING_HEADN_ENTITY_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_EQUITY_EXPOSURESN_PROVISION_AMOUNT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_PRIVATE_TRADED_EXP_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_REG_CAP_PARTCP_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_PUBLIC_TRADED_EXP_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_UNREAL_GAIN_INCL_REG_CAP_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_SBIC_EXP_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_UNREAL_GAIN_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESV_BOLI_ACCOUNT_TYPE_INDICATORVARCHAR2(1)NULLNONOINDICATOR

FCT_EQUITY_EXPOSURESN_LOCATION_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_EQUITY_EXPOSURESN_SURRENDER_CHARGENUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_CASH_SURRENDER_VALUENUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_SURRENDER_CHARGE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_CASH_SURRENDER_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESV_UNDERLYING_DATA_IDENTIFIERVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_EQUITY_EXPOSURESN_HEDGED_ACCT_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_EQUITY_EXPOSURESF_REGULATORY_PARTY_INDICATORCHAR(1)NULLNONOFLAG

FCT_EQUITY_EXPOSURESF_TREASURY_STOCK_INDICATORCHAR(1)NULLNONOFLAG

FCT_EQUITY_EXPOSURESN_COUNTERPARTY_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_EQUITY_EXPOSURESN_STD_COUNTERPARTY_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_EQUITY_EXPOSURESN_ADJ_CARRY_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_EXCHANGE_RATENUMBER(11,6)NULLNONORATE

FCT_EQUITY_EXPOSURESN_EXPOSURE_AMOUNT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_ISSUER_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_EQUITY_EXPOSURESN_LAST_REPORTED_T1_T2_AMTNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_NOTIONAL_PRINCIPAL_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_POST_OFFSET_EXP_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_POTENTIAL_ESTIMATE_LOSS_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESF_SUPERVISORY_DED_EXCLUSIONCHAR(1)NULLNONOFLAG

FCT_EQUITY_EXPOSURESN_ORIGINAL_ACCT_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_EQUITY_EXPOSURESF_FINANCIAL_SUBSIDIARY_INDCHAR(1)NULLNONOFLAG

FCT_EQUITY_EXPOSURESF_SIGNIFICANT_INVESTMENT_INDCHAR(1)NULLNONOFLAG

FCT_EQUITY_EXPOSURESN_CAP_NET_QUAL_OFFSET_AMTNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESN_CAP_NET_QUAL_OFFSET_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_EQUITY_EXPOSURESF_BUY_SELL_INDCHAR(1)NULLNONOFLAG

FCT_EQUITY_EXPOSURESF_CAPITAL_NETTING_QUAL_FLAGCHAR(1)NULLNONOFLAG

FCT_EQUITY_EXPOSURESF_FINANCIAL_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_EQUITY_EXPOSURESN_CAP_COMP_GROUP_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_EQUITY_OTHER_ASSET_LOSSN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_MITIGANTSF_MAIN_INDEX_INDCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_FINANCIAL_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_EQUITY_TRADED_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_CVA_HEDGECHAR(1)NULLNONOFLAG

FCT_MITIGANTSN_CDS_INDEX_RATINGNUMBER(5)NULLNONOCODE_NUMERIC_SHORT

FCT_MITIGANTSN_CDS_INDEX_AVG_SPREADNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_MITIGANTSF_SECURITIZED_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_RE_SECURITIZED_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSN_MIT_ACCT_COVERAGE_AMTNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_INSURANCE_VALUE_RCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_INSURANCE_VALUENUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_ISSUER_ANNUAL_SALESNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_BASIS_RISK_WEIGHTNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_MITIGANTSF_REGULATED_FIN_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_MITIGANTSN_MIT_ACCT_COVERAGE_AMT_RCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_PD_BAND_SKEYNUMBER(5)NULLNONOSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_RISK_WEIGHT_METHODNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_MITIGANT_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_PARENT_CDS_INDEX_SKEYNUMBER(10)NULLNONOSURROGATEKEY_LONG

FCT_MITIGANTSN_SHAREHOLDING_PERCENTNUMBER(11,6)NULLNONORATE

FCT_MITIGANTSF_INVESTMENT_GRADE_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSN_STD_MITIGANT_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSV_GROUP_CCY_CODEVARCHAR2(3)NULLNONOCODE_CURRENCY

FCT_MITIGANTSN_EXCHANGE_RATE_AVCNUMBER(11,6)NULLNONORATE

FCT_MITIGANTSN_GROUP_ASSET_SIZENUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_CDS_INDEX_WEIGHTNUMBER(11,6)NULLNONORATE

FCT_MITIGANTSN_EXCHANGE_RATENUMBER(11,6)NULLNONORATE

FCT_MITIGANTSN_ISSUE_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_INITIAL_BASEL_RATINGNUMBER(5)NULLNOYESCODE_NUMERIC_SHORT

FCT_MITIGANTSN_GROUP_ASSET_SIZE_IN_AVC_CCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_HEDGE_DISCOUNT_FACTORNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_MITIGANTSN_CLEARED_TXN_BANK_ROLE_IDNUMBER(3)NULLNOYESSURROGATEKEY_SHORT

FCT_MITIGANTSF_QUALIFIED_CCP_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSN_COLL_MKT_VALUENUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_COLL_AREANUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSD_REPOSSESSION_DATEDATENULLNONODATE

FCT_MITIGANTSN_HOLDING_PERIODNUMBER(5)NULLNONONUMBER_SHORT

FCT_MITIGANTSN_VEHICLE_TYPE_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_PROPERTY_LOCATION_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSF_ANCILLARY_OWN_FUNDS_INDCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_CONF_RESIDENTIAL_MRTGS_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSN_MAX_VALUE_GUARANTEE_AMT_LCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_ACCRUED_INTEREST_LCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_VALUATION_UNIT_PRICE_LCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_VALUATION_AMOUNT_LCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSF_COLL_COVERS_ALL_LOSSESCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_CLEARED_TRANSACTION_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSN_NETTING_AGREEMENT_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_MAX_VOL_HAIRCUT_30DAYS_PCTNUMBER(8,4)NULLNONOPERCENT

FCT_MITIGANTSN_MAX_PRICE_CHANGE_30DAYS_PCTNUMBER(8,4)NULLNONOPERCENT

FCT_MITIGANTSN_LOAN_TO_VALUENUMBER(8,4)NULLNONORATE

FCT_MITIGANTSF_SELF_ISSUED_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_MARKETABLE_SEC_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_ISSUER_RISK_RETENTION_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_ISSUER_FINANCIAL_ENTITY_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSN_COLL_REPOSSES_SALE_AMTNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSF_REAL_ESTATE_OWNED_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSN_OCCUPANCY_RATENUMBER(11,6)NULLNONORATE

FCT_MITIGANTSN_MITIGANT_SALE_PRICENUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_ORIG_MORTGAGE_OCCUPANY_SKEYNUMBER(3)NULLNOYESSURROGATEKEY_SHORT

FCT_MITIGANTSN_PROPERTY_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_INSTRUMENT_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_FIRST_LIEN_PERFORMANCE_SKEYNUMBER(3)NULLNONOSURROGATEKEY_SHORT

FCT_NETTABLE_POOLN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_MITIGANTSN_STANDARD_PRODUCT_TYPE_SKEYNUMBER(3)NULLNOYESSURROGATEKEY_SHORT

FCT_MITIGANTSN_REG_ISSUER_RISKWEIGHT_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_REG_MITIGANT_RISKWEIGHT_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_PROD_TYPE_SKEYNUMBER(5)NULLNONONUMBER_SHORT

FCT_MITIGANTSF_COMP_MAJOR_INDEX_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_DOMESTIC_CCY_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_EXCHANGE_TRADED_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_FULLY_RECOURSE_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_HOME_JURISDICTION_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSF_ISSU_PARENT_FINAN_ENTI_FLAGCHAR(1)NULLNONOFLAG

FCT_ISSUER_DETAILSN_ISSUER_AGE_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MARKET_VARIABLESN_MKT_VAR_VALUENUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_LAST_VALUATION_DATE_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_ORIG_VALUATION_DATE_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_MITIGANTSN_REF_ENTITY_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_SECURITY_ISSUER_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_COUNTERPARTY_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_CENTRAL_COUNTERPARTY_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_CLEARING_MEMBER_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_GUARANTOR_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_MITIGANTSN_STANDARD_GUARANTOR_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_STANDARD_ISSUER_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_GUARANTOR_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_QUANTITYNUMBER(22)NULLNONONUMBER_GENERIC

FCT_MITIGANTSN_INSURANCE_VAL_RCY_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_MITIGANT_AGE_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_MAX_PRICE_CHANGE_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_MAX_VOL_HAIRCUT_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_VALUATION_METHOD_SKEYNUMBER(3)NULLNOYESSURROGATEKEY_SHORT

FCT_MITIGANTSN_LIEN_POSITIONNUMBER(5)NULLNONONUMBER_SHORT

FCT_MITIGANTSN_MITIGANT_VALUE_LCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_MITIGANT_BOOK_VALUENUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_MITIGANT_AGENUMBER(5)NULLNONONUMBER_SHORT

FCT_MITIGANTSN_MITIGANT_BOOK_VALUE_RCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_MITIGANT_BOOK_VALUE_LCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSF_MITIGANT_REPOSSESSED_FLAGCHAR(1)NULLNONOFLAG

FCT_MITIGANTSN_LOAN_TO_VALUE_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_MITIGANTSN_ORIGINAL_MITIGANT_VALUE_RCYNUMBER(22,3)NULLNONOAMOUNT

FCT_MITIGANTSN_ORIGINAL_MITIGANT_VALUE_LCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_BASEL_PARTY_RATINGNUMBER(5)NULLNOYESCODE_NUMERIC_SHORT

FCT_NETTABLE_POOLF_SUPERVISORY_DED_EXCLUSIONCHAR(1)NULLNONOFLAG

FCT_NETTABLE_POOLN_GROUP_ASSET_SIZE_IN_AVC_CCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NETTABLE_POOLF_REGULATED_FIN_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_NETTABLE_POOLF_FINANCIAL_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_NETTABLE_POOLF_COUNTERPARTY_CMC_FLAGCHAR(1)NULLNONOFLAG

FCT_NETTABLE_POOLF_SPECIFIC_WRONG_WAY_RISK_INDCHAR(1)NULLNONOFLAG

FCT_NETTABLE_POOLN_SCALING_FACTORNUMBER(11,6)NULLNONONUMBER_FACTOR

FCT_NETTABLE_POOLN_HOLDING_PERIODNUMBER(5)NULLNONONUMBER_SHORT

FCT_NON_SEC_EXPOSURESN_ORIGINAL_ACCT_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_NON_SEC_EXPOSURESN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_NETTABLE_POOLF_SIGNIFICANT_INVESTMENT_INDCHAR(1)NULLNONOFLAG

FCT_NETTABLE_POOLN_RWA_UL_POST_DOUBLE_DEFAULTNUMBER(22,3)NULLNONOAMOUNT

FCT_NETTABLE_POOLN_POST_CRM_WEIGHTED_AVG_LGDNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_NETTABLE_POOLN_RWA_UL_POST_CD_BENEFITNUMBER(22,3)NULLNONOAMOUNT

FCT_NETTABLE_POOLN_STANDARD_PARTY_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NETTABLE_POOLN_PD_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NETTABLE_POOLN_NOTIONAL_WGTD_MATURITYNUMBER(11,6)NULLNONORATE

FCT_NETTABLE_POOLN_PARTY_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NETTABLE_POOLN_CLEARING_MEMBER_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_NETTABLE_POOLN_LOCATION_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_NETTABLE_POOLN_CENTRAL_COUNTERPARTY_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_NETTABLE_POOLN_INCURRED_CVA_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_NETTABLE_POOLF_QUALIFIED_CCP_FLAGCHAR(1)NULLNONOFLAG

FCT_NETTABLE_POOLN_CLEARED_TXN_BANK_ROLE_IDNUMBER(3)NULLNOYESSURROGATEKEY_SHORT

FCT_NETTABLE_POOLF_CLEARED_TRANSACTION_FLAGCHAR(1)NULLNONOFLAG

FCT_NETTABLE_POOLF_COLL_COVERS_ALL_LOSSESCHAR(1)NULLNONOFLAG

FCT_NETTABLE_POOLN_EAD_DISCOUNT_FACTORNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_NETTABLE_POOLN_BASEL_PARTY_RATINGNUMBER(5)NULLNONOCODE_NUMERIC_SHORT

FCT_NETTABLE_POOLN_MATURITY_ADJ_EADNUMBER(22,3)NULLNONOAMOUNT

FCT_NETTABLE_POOLN_EL_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NETTABLE_POOLN_GROUP_ASSET_SIZENUMBER(22,3)NULLNONOAMOUNT

FCT_NETTABLE_POOLN_EXCHANGE_RATE_AVCNUMBER(11,6)NULLNONONUMBER_FACTOR

FCT_NON_SEC_EXPOSURESN_MAXIMUM_POTENTIAL_LOSS_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_MAXIMUM_POTENTIAL_LOSSNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESF_MAIN_INDEX_INDCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_FINANCIAL_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_SIGNIFICANT_INVESTMENT_INDCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_LEASE_RESIDUAL_INDICATORCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_TREASURY_STOCK_INDICATORCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_REGULATORY_PARTY_INDICATORCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_RW_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_PD_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESF_INTRADAY_TRADED_FLAGCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_CUST_INCOME_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_DELQ_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_EL_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_LTV_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_CUST_ANNUAL_SALES_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_ALLOC_TRANS_RISK_RESERVE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_HAMISH_JIDDIYYAH_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_MORTGAGE_LENDING_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_UNPAID_PREMIUM_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_WRITE_OFF_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_EXCHANGE_RATENUMBER(11,6)NULLNONORATE

FCT_NON_SEC_EXPOSURESN_CONTRACT_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_EXP_UNREALIZED_LOSS_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_NOTIONAL_PRINCIPAL_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_PROVISION_AMOUNT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_UNDRAWN_AMOUNT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESF_REGULATED_FIN_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_ACCRUED_INT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_EXP_MTM_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_EXP_UNREALIZED_GAIN_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESV_MBS_BACKING_INDVARCHAR2(1)NULLNONOINDICATOR

FCT_NON_SEC_EXPOSURESN_CUSTOMER_ASSETSNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESF_BACKED_BY_MORTGAGECHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_FINANCIAL_STMT_DISCLOSURECHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_TOTAL_CUSTOMER_EXPOSURENUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_SURRENDER_CHARGENUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_CASH_SURRENDER_VALUENUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_CASH_SURRENDER_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_HEDGED_ACCT_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_NON_SEC_EXPOSURESF_EXP_MULTI_FAMILY_RESIDENCECHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_SURRENDER_CHARGE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_MIN_REPAYMENT_PERIODNUMBER(11,6)NULLNONONUMBER_FACTOR

FCT_NON_SEC_EXPOSURESF_PRE_SLD_RESIDENTIAL_UNIT_INDCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_LOCATION_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_NON_SEC_EXPOSURESN_CLEARING_MEMBER_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_NON_SEC_EXPOSURESF_TXN_GUARANTEE_FLAGCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_COUNTERPARTY_CMC_FLAGCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESV_DEAL_IDVARCHAR2(40)NULLNONOCODE_ALPHANUMERIC_LONG_TYPE2

FCT_NON_SEC_EXPOSURESN_HOLDING_PERIODNUMBER(5)NULLNONONUMBER_SHORT

FCT_NON_SEC_EXPOSURESV_BOLI_ACCOUNT_TYPE_INDICATORVARCHAR2(1)NULLNONOINDICATOR

FCT_NON_SEC_EXPOSURESF_SPECIFIC_WRONG_WAY_RISK_INDCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_CAP_NET_QUAL_OFFSET_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESV_OPTION_TYPEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_NON_SEC_EXPOSURESF_SUPERVISORY_DED_EXCLUSIONCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_UNDERLYING_CAP_INSTRUMENTCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_UNDERLYING_CAP_COMP_GRP_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESF_INVESTMENT_IN_OWN_SHARE_INDCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_OPERATING_INCOME_DEBT_RATIONUMBER(9,6)NULLNONORATIO

FCT_NON_SEC_EXPOSURESN_INTEREST_TYPENUMBER(5)NULLNONOSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_SEC_POOL_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESV_TREATMENT_CDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_NON_SEC_EXPOSURESF_DEF_DUE_CREDIT_WORTHINESSCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_FINANCIAL_SUBSIDIARY_INDCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_CAPITAL_NETTING_QUAL_FLAGCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_CAP_NET_QUAL_OFFSET_AMTNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_RWA_UL_POST_DOUBLE_DEFAULTNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_RWA_UL_POST_CD_BENEFITNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_POST_CRM_WEIGHTED_AVG_LGDNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_NON_SEC_EXPOSURESV_GROUP_CCY_CODEVARCHAR2(3)NULLNONOCODE_CURRENCY

FCT_NON_SEC_EXPOSURESN_RISK_WEIGHT_METHODNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_ISSUE_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_NON_SEC_EXPOSURESN_COUNTERPARTY_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_CAP_COMP_GROUP_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESN_EXP_LIMIT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_RESIDUAL_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_REG_CAP_PARTCP_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_OUTSTANDING_PRINCIPAL_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_GROUP_ASSET_SIZE_IN_AVC_CCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_GROUP_ASSET_SIZENUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_EXCHANGE_RATE_AVCNUMBER(11,6)NULLNONORATE

FCT_NON_SEC_EXPOSURESN_SUBJECT_MATTER_MKT_VAL_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESF_COLL_COVERS_ALL_LOSSESCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_QUALIFIED_CCP_FLAGCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_EXCHANGE_RATE_SMENUMBER(11,6)NULLNONORATE

FCT_NON_SEC_EXPOSURESF_CLEARED_TRANSACTION_FLAGCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESF_COLL_BANKRUPTCY_REMOTE_FLAGCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_COLLATERAL_FAIR_VALUE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_CLEARED_TXN_BANK_ROLE_IDNUMBER(3)NULLNOYESSURROGATEKEY_SHORT

FCT_NON_SEC_EXPOSURESF_CLEARED_TXN_COLLATERALCHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_CENTRAL_COUNTERPARTY_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_NON_SEC_EXPOSURESN_STD_COUNTERPARTY_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_NON_SEC_EXPOSURESF_PRIVATE_SECTOR_EXPOSURECHAR(1)NULLNONOFLAG

FCT_NON_SEC_EXPOSURESN_INCURRED_CVA_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_NON_SEC_EXPOSURESN_CREDIT_STATUS_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SEC_EXPOSURESF_SINGLE_UNDRLYNG_RETRANCHINGCHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESN_SEC_POOL_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SEC_EXPOSURESN_AMORTIZATION_AMOUNT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_FACILITY_AMOUNT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESF_RESECURITIZED_FLAGCHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESN_ACCRUED_INTEREST_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_POOL_EXPOSURE_AMTNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_UNDERLYING_EXP_AVG_RWNUMBER(11,6)NULLNONORATE

FCT_SEC_EXPOSURESN_RW_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SEC_EXPOSURESN_PROVISION_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_UNREALISED_GAIN_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_EXCHANGE_RATENUMBER(11,6)NULLNONORATE

FCT_SEC_EXPOSURESN_NOTIONAL_PRINCIPAL_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_SEC_EXP_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_UNDRAWN_AMOUNT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_GAIN_LOSS_ON_SALE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_HISTORICAL_ACQ_COST_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_DELQ_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SEC_EXPOSURESN_ORIGINATOR_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SEC_EXPOSURESN_ORIGINAL_ACCT_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SEC_EXPOSURESN_ORIGINATOR_PARTY_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_RESERVESN_RESERVE_AMT_LCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_RESERVESN_MIS_DATE_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_RESERVESN_BUSINESS_SEGMENT_SKEYNUMBER(3)NULLNOYESSURROGATEKEY_SHORT

FCT_RAPMN_VAR_DIVERSIFIED_EC_ULNUMBER(22,3)NULLNONOAMOUNT

FCT_RAPMN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_SEC_EXPOSURESN_CAP_COMP_GROUP_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SEC_EXPOSURESN_PARENT_ACCT_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_STANDARD_ACCT_HEADN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_SECURITIZATION_TRANCHEF_SINGLE_UNDRLYNG_RETRANCHINGCHAR(1)NULLNONOFLAG

FCT_SECURITIZATION_TRANCHEN_SUB_TRANCHE_IO_STRIP_AMTNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_TRANCHEN_ALL_TRAN_PURCH_PRICE_DIS_AMTNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_TRANCHEN_ORIGINAL_DEAL_SEC_POOL_SKEYNUMBER(10)NULLNONOSURROGATEKEY_LONG

FCT_SECURITIZATION_TRANCHEF_REREMIC_INDICATORCHAR(1)NULLNONOFLAG

FCT_STANDARD_ACCT_HEADN_LEV_RATIO_DED_GROUP_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_STANDARD_ACCT_HEADF_NON_QUALIFIED_CAP_INSTR_FLAGCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESN_ORIGINAL_ACCT_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SUB_EXPOSURESN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_SECURITIZATION_POOLV_CCY_CODEVARCHAR2(3)NOT NULLNONOCODE_CURRENCY

FCT_SECURITIZATION_POOLN_INITIAL_POOL_EXPOSURE_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_CUMULATIVE_DEFAULT_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_EXCHANGE_RATENUMBER(11,6)NULLNONORATE

FCT_SECURITIZATION_POOLN_POOL_FORECLOSURE_LOAN_BALNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_POOL_BANKRUPT_LOAN_BALANCENUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_POOL_DEFERRED_LOAN_BALANCENUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_POOL_PAST_DUE_LOAN_BALANCENUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_POOL_NONSEC_KGNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_POOLN_POOL_KGNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_POOLN_POOL_DEFAULTED_LOAN_BALANCENUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_POOL_REO_LOAN_BALANCENUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_SSFA_POOL_PARAMETER_WNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_POOLN_UNDERLYING_NONSEC_PERCENTNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_POOLN_UNDERLYING_SEC_PERCENTNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_POOLN_POOL_SEC_KGNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_POOLN_POOL_SEC_KIRBNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_POOLN_POOL_NONSEC_KIRBNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_POOLN_SSFA_POOL_PARAMETER_KANUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_POOLN_SSFA_POOL_PARAMETER_ANUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_POOLN_ISSUER_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SECURITIZATION_POOLN_ORIGINATOR_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SECURITIZATION_POOLN_RESEC_UNDERLYING_RWNUMBER(30,11)NULLNONOAMOUNT_LONG

FCT_SECURITIZATION_POOLN_NO_OF_UNDERLYINGSNUMBER(5)NULLNONONUMBER_SHORT

FCT_SECURITIZATION_TRANCHEN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_SECURITIZATION_TRANCHEN_ENTITY_SKEYNUMBER(10)NULLNONOSURROGATEKEY_LONG

FCT_SECURITIZATION_TRANCHEN_ATTACHMENT_POINTNUMBER(11,6)NULLNONONUMBER_FACTOR

FCT_SECURITIZATION_TRANCHEN_INITIAL_TRANCHE_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_TRANCHEN_ISSUE_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SECURITIZATION_TRANCHEN_RESIDUAL_MATURITYNUMBER(11,6)NULLNONONUMBER_FACTOR

FCT_SECURITIZATION_TRANCHEN_TRANCHE_AMOUNT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_TRANCHEV_CCY_CODEVARCHAR2(3)NULLNONOCODE_CURRENCY

FCT_SECURITIZATION_TRANCHEN_EXCHANGE_RATENUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_TRANCHEN_SSFA_TRANCHE_PARAMETER_ANUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_TRANCHEN_SSFA_TRANCHE_PARAMETER_DNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SECURITIZATION_TRANCHEN_FUNDED_RESERVE_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_TRANCHEN_SUBORDINATED_TRANCHES_AMTNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_TRANCHEF_FUNDED_RESERVE_FLAGCHAR(1)NULLNONOFLAG

FCT_SECURITIZATION_TRANCHEF_STRADDLED_TRANCHE_FLAGCHAR(1)NULLNONOFLAG

FCT_SECURITIZATION_TRANCHEV_ORIGINAL_DEAL_TRANCHE_IDVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_SECURITIZATION_POOLN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_SECURITIZATION_POOLN_INVESTOR_INTEREST_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_GAIN_LOSS_ON_SALE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_POOL_LARGEST_EXPOSURE_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_POOL_EXPOSURE_AMT_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SECURITIZATION_POOLN_ENTITY_SKEYNUMBER(10)NULLNONOSURROGATEKEY_LONG

FCT_SEC_EXPOSURESN_SSFA_TRANCHE_PARAMETER_ANUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SSFA_TRANCHE_PARAMETER_DNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SSFA_PARAMETER_UNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SSFA_PARAMETER_LNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_POOL_KGNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_KSSFANUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_CREDIT_ENHANCEMENT_LEVELNUMBER(8,4)NULLNONOPERCENT

FCT_SEC_EXPOSURESN_POOL_LARGEST_EXPOSURENUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_UNREALISED_LOSS_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_CONCENTRATION_RATIONUMBER(11,6)NULLNONORATE

FCT_SEC_EXPOSURESN_GRANULARITYNUMBER(11,6)NULLNONORATE

FCT_SEC_EXPOSURESN_ISSUE_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SEC_EXPOSURESN_UNDERLYING_EXP_MAX_RWNUMBER(8,4)NULLNONOPERCENT

FCT_SEC_EXPOSURESV_SEC_TRADING_BOOK_APPROACHVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

FCT_SEC_EXPOSURESN_SFA_POOL_PARAMETER_HNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_POOL_KKIRBNUMBER(9,6)NULLNONORATIO

FCT_SEC_EXPOSURESN_TRANCHE_KLPLUSTNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_TRANCHE_KLNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SFA_POOL_PARAMETER_DNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SFA_POOL_PARAMETER_FNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SFA_POOL_PARAMETER_CNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SFA_POOL_PARAMETER_VNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SSFA_POOL_PARAMETER_ANUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SSFA_POOL_PARAMETER_KANUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SSFA_POOL_PARAMETER_WNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESF_SSFA_QUALIFIED_FLAGCHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESN_DEFAULTED_POSITIONNUMBER(5)NULLNONONUMBER_SHORT

FCT_SEC_EXPOSURESN_NON_PERFORMING_EXP_BAL_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_NON_PERFORMING_EXP_BALNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESV_UNDERLYING_DATA_IDENTIFIERVARCHAR2(6)NULLNONOCODE_ALPHANUMERIC_SHORT_TYPE2

FCT_SEC_EXPOSURESF_SECURITISED_FLAGCHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESN_RW_METHOD_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SEC_EXPOSURESN_LOCATION_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SEC_EXPOSURESN_TRANCHE_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_STANDARD_PRODUCT_TYPE_SKEYNUMBER(3)NULLNOYESSURROGATEKEY_SHORT

FCT_SEC_EXPOSURESN_ECONOMIC_ZONE_SKEYNUMBER(3)NULLNONOSURROGATEKEY_SHORT

FCT_SEC_EXPOSURESN_STD_LOB_SKEYNUMBER(5)NULLNONOSURROGATEKEY_MEDIUM

FCT_SEC_EXPOSURESN_CREDIT_STATUS_SKEYNUMBER(5)NULLNONOSURROGATEKEY_MEDIUM

FCT_SEC_EXPOSURESN_TRANCHE_SLPLUSTNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_TRANCHE_SLNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_TRANCHE_THICKNESSNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_POOL_KIRBNUMBER(9,6)NULLNONORATIO

FCT_SEC_EXPOSURESN_POOL_LGD_PERCENTNUMBER(30,11)NULLNONOAMOUNT_LONG

FCT_SEC_EXPOSURESN_SFA_POOL_PARAMETER_GNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SFA_POOL_PARAMETER_ANUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESN_SFA_POOL_PARAMETER_BNUMBER(15,11)NULLNONOPERCENT_LONG

FCT_SEC_EXPOSURESF_INVESTMENT_IN_OWN_SHARE_INDCHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESF_INTERNAL_CUST_INDCHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESF_SUPERVISORY_DED_EXCLUSIONCHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESF_REG_CONSOLIDATION_PARTY_INDCHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESN_OUTSTANDING_PRINCIPAL_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_OUTSTANDING_INTEREST_NCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_TRANCHE_DELINQUENT_DAYSNUMBER(5)NULLNONONUMBER_SHORT

FCT_SEC_EXPOSURESF_TRANCHE_DEFAULTED_FLAGCHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESN_OUTSTANDING_INTERESTNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESN_OUTSTANDING_PRINCIPALNUMBER(22,3)NULLNONOAMOUNT

FCT_SEC_EXPOSURESF_RESEC_ALL_ULYNG_SEC_EXP_SSFACHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESN_HOLDING_PERIODNUMBER(5)NULLNONONUMBER_SHORT

FCT_SEC_EXPOSURESF_FINANCIAL_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_SEC_EXPOSURESF_SIGNIFICANT_INVESTMENT_INDCHAR(1)NULLNONOFLAG

FCT_TRANSITION_MATRIXN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_SUB_EXPOSURESN_CLEARING_MEMBER_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SUB_EXPOSURESN_CLEARED_TXN_BANK_ROLE_IDNUMBER(3)NULLNOYESSURROGATEKEY_SHORT

FCT_SUB_EXPOSURESN_HOLDING_PERIODNUMBER(5)NULLNONONUMBER_SHORT

FCT_SUB_EXPOSURESN_LOCATION_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SUB_EXPOSURESF_SIGNIFICANT_INVESTMENT_INDCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESF_SUPERVISORY_DED_EXCLUSIONCHAR(1)NULLNONOFLAG

FCT_TIME_TO_PEAK_EXPOSUREN_MIS_DATE_SKEYNUMBER(10)NOT NULLYESYESSURROGATEKEY_LONG

FCT_SUB_EXPOSURESN_CAP_COMP_GROUP_SKEYNUMBER(5)NULLNONOCODE

FCT_SUB_EXPOSURESF_PRIVATE_SECTOR_EXPOSURECHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESV_EXPOSURE_TYPEVARCHAR2(10)NULLNONOCODE_ALPHANUMERIC_MEDIUM

FCT_SUB_EXPOSURESN_PD_BAND_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SUB_EXPOSURESN_STD_MITIGANT_TYPE_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

FCT_SUB_EXPOSURESN_EXP_SENIORITYNUMBER(5)NULLNONOCODE_NUMERIC_SHORT

FCT_SUB_EXPOSURESN_GROUP_ASSET_SIZE_IN_AVC_CCYNUMBER(22,3)NULLNONOAMOUNT

FCT_SUB_EXPOSURESF_COLL_COVERS_ALL_LOSSESCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESF_QUALIFIED_CCP_FLAGCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESF_CLEARED_TXN_COLLATERALCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESF_COLL_BANKRUPTCY_REMOTE_FLAGCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESN_MITIGANT_POST_HAIRCUT_AMTNUMBER(22,3)NULLNONOAMOUNT

FCT_SUB_EXPOSURESF_CLEARED_TRANSACTION_FLAGCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESN_INCURRED_CVA_AMOUNTNUMBER(22,3)NULLNONOAMOUNT

FCT_SUB_EXPOSURESV_EXP_MIT_POOL_CARDINALITYVARCHAR2(3)NULLNONOCODE_SHORT

FCT_SUB_EXPOSURESF_FINANCIAL_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESN_GROUP_ASSET_SIZENUMBER(22,3)NULLNONOAMOUNT

FCT_SUB_EXPOSURESF_REGULATED_FIN_ENTITY_INDCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESF_MITIGANT_SECURITIZED_FLAGCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESF_ELIGIBILITY_FLAGCHAR(1)NULLNONOCHAR

FCT_SUB_EXPOSURESN_EXCHANGE_RATE_AVCNUMBER(11,6)NULLNONORATE

FCT_SUB_EXPOSURESN_CENTRAL_COUNTERPARTY_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SUB_EXPOSURESN_EXPOSURE_PARTY_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SUB_EXPOSURESN_EFFECTIVE_PARTY_SKEYNUMBER(10)NULLNOYESSURROGATEKEY_LONG

FCT_SUB_EXPOSURESN_EFFECTIVE_COUNTRY_SKEYNUMBER(5)NULLNONOSURROGATEKEY_MEDIUM

FCT_SUB_EXPOSURESN_ALLOCATION_RANKNUMBER(10)NULLNONONUMBER_MEDIUM

FCT_SUB_EXPOSURESF_RESECURITIZED_FLAGCHAR(1)NULLNONOFLAG

FCT_SUB_EXPOSURESN_EFFECTIVE_ASSET_CLASS_SKEYNUMBER(5)NULLNOYESSURROGATEKEY_MEDIUM

STG_CUSTOMER_MASTERF_FINANCIAL_STMT_DISCLOSURECHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERV_PARTNER_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

STG_CUSTOMER_MASTERV_HOUSEHOLD_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

STG_CUSTOMER_MASTERV_FACEBOOK_ADDRESSVARCHAR2(100)NULLNONOTEXT_LONG_DESCRIPTION

STG_CUSTOMER_MASTERV_TWITTER_ADDRESSVARCHAR2(100)NULLNONOTEXT_LONG_DESCRIPTION

STG_CUSTOMER_MASTERV_GOOGLEPLUS_ADDRESSVARCHAR2(100)NULLNONOTEXT_LONG_DESCRIPTION

STG_CUSTOMER_MASTERV_CUSTOMER_PARENT_GROUP_NAMEVARCHAR2(30)NULLNONOTEXT_SHORT_DESCRIPTION

STG_CUSTOMER_MASTERF_BANKRUPTCY_FLAGCHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERF_FRAUD_FLAGCHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERV_CUST_EMPLOYMENT_TYPE_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

STG_CUSTOMER_MASTERD_PWD_LAST_CHANGE_DATEDATENULLNONODATE

STG_CUSTOMER_MASTERV_DATA_JURISDICTIONVARCHAR2(5)NULLNONOCODE_ALPHANUMERIC_SHORT

STG_CUSTOMER_MASTERV_BUSINESS_DOMAINVARCHAR2(60)NULLNONOTEXT_MEDIUM_DESCRIPTION

STG_CUSTOMER_MASTERF_COMPENSATION_FLAGCHAR(1)NULLNONOFLAG

STG_ENTITY_SHR_HLD_PERCENTV_CCY_CODEVARCHAR2(3)NULLNONOCODE_CURRENCY

STG_ENTITY_SHR_HLD_PERCENTF_THIRDPARTY_MINORITY_HOLD_INDCHAR(1)NULLNONOFLAG

STG_ENTITY_SHR_HLD_PERCENTN_CONSOLIDATED_ASSETSNUMBER(22,3)NULLNONOAMOUNT

STG_CUSTOMER_TYPE_MASTERV_CUST_CATEGORYVARCHAR2(1)NULLNONOINDICATOR

STG_CUSTOMER_MASTERV_FATCA_EXEMPTION_CODEVARCHAR2(5)NULLNONOCODE_ALPHANUMERIC_SHORT

STG_CUSTOMER_MASTERF_THIRD_PARTY_CREDIT_REP_FLAGCHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERV_BENEFICIAL_OWNER_CATEGORYVARCHAR2(50)NULLNONOCODE_ALPHANUMERIC_LONG_TYPE3

STG_CUSTOMER_MASTERV_LOCATION_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

STG_CUSTOMER_MASTERF_HARDSHIP_INDCHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERN_ATM_MAX_WTHDRWL_LIAB_ACCTNUMBER(22,3)NULLNONOAMOUNT

STG_CUSTOMER_MASTERV_NAICS_CODEVARCHAR2(6)NULLNONOCODE_ALPHANUMERIC_SHORT_TYPE2

STG_CUSTOMER_MASTERN_RETIREMENT_YEARNUMBER(5)NULLNONONUMBER_SHORT

STG_CUSTOMER_MASTERF_FOREIGN_PUBLIC_OFFICIAL_FLAGCHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERV_ISO_COUNTRY_CDVARCHAR2(3)NULLNONOCODE_SHORT

STG_CUSTOMER_MASTERF_RECALCITRANT_FLAGCHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERF_NON_US_DOC_HOLDER_FLAGCHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERF_NON_US_CIT_RES_FLAGCHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERF_CERT_LOSS_NATIONALITY_FLAGCHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERV_FATCA_ORG_TYPEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

STG_CUSTOMER_MASTERF_EXCEPTED_NFFE_FLAGCHAR(1)NULLNONOFLAG

STG_CUSTOMER_MASTERF_FOREIGN_TAX_REP_CERT_FLAGCHAR(1)NULLNONOFLAG

STG_EQUITY_EXPOSURESV_ORG_UNIT_CODEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

STG_EQUITY_EXPOSURESV_CLASS_CODEVARCHAR2(15)NULLNONOCODE_ALPHANUMERIC_MEDIUM_TYPE2

STG_EQUITY_EXPOSURESV_ISSUER_TYPEVARCHAR2(20)NULLNONOCODE_ALPHANUMERIC_LONG

STG_EQUITY_EXPOSURESN_MARKET_VALUENUMBER(22,3)NULLNONOAMOUNT

STG_

installation manual oracle financial services economic ... economic... · oracle financial services...

Documents