| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FTBB_YCBSC_DREVT | Basis Spread Curve Derivation for Evaluation Curves (Texts) | 4 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
2 | FTBB_YCBSC_DRFWT | Basis Spread Curve Derivation for Forward Curves (Texts) | 4 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
3 | FTBB_YCCSC_DRBPT | Reference Entity Derivation for Business Partners (Texts) | 4 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
4 | FTBB_YCCSC_DROWT | Reference Entity Derivation for Your Own Companies (Texts) | 4 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
5 | TIMG4 | Status Field Descriptions | 3 | LBEZ | Text, 40 Characters Long | nvarchar | 40 | 0 | | |
TOPAssetLiability Management |
6 | JBAPLANVT | ALM Planning Variant: Text Table | 7 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
7 | JBASIMAT | ALM Simulation Type: Texts | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
8 | JBRABREGTABT | RM: Write-Down Rule for P+L Simulation (Texts) | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
9 | JBRBG2T | Text Table for Gap Type | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
10 | JBRIASZDT | Descriptions for Utilization Scenarios | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
11 | JBRLQSZHT | Texts for Liquidation Scenarios | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
12 | JBRLZBT | Maturity Band - Texts | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
13 | JBRPBLDT | Texts for Period Block - Definition | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
14 | JBRSIMZT | Texts for Simulated Interest Payments | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
TOPClinical System |
15 | N2DGAIVR | ISH*MED : Versionen Kerndatensatz Anästhesie | 5 | LBEZ | Langbezeichnung Version Kerndatensatz Anästhesie | nvarchar | 60 | 0 | | |
TOPLoans Management |
16 | TD17T | Branch office text table | 6 | LBEZ | Name | nvarchar | 50 | 0 | | |
17 | TD18T | Business region text table | 6 | LBEZ | Name | nvarchar | 50 | 0 | | |
TOPMarket Risk Analyzer |
18 | ATRFARTT | Risk factors - risk factor type texts | 4 | LBEZ | Risk factor type | nvarchar | 60 | 0 | | |
19 | ATRFT | Risk Factors - Definition of Risk Factor Name | 4 | LBEZ | Risk factor name | nvarchar | 60 | 0 | | |
20 | ATVO0T | Text Table for Name of Volatility | 4 | LBEZ | Text Field for Volatility Name | nvarchar | 60 | 0 | | |
21 | JBRBFARTT | Beta factor type texts | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
22 | JBREVALT | Risk Management evaluation type - texts | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
23 | JBRREGDT | Text Table Market Data Shift Definition | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
24 | JBRRHBAUMT | Texts for Tree Structure of Risk Hierarchy | 6 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
25 | JBRRHBAUMTH | Text for Tree Structure of Risk Hierarchy (History) | 7 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
26 | JBRRHBAUMT_BACK | Backup Table JBRRHBAUMT (Required for Transport Imports) | 6 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
27 | JBRRHT | Texts for Risk Hierarchy Check Table | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
28 | JBRRHTH | Texts for Risk Hierarchy Check Table (History) | 6 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
29 | JBRRHT_BACK | Backup Table JBRRHT (Required for Transport Imports) | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
TOPMaster Data |
30 | TD19T | Organizational Unit (Contract Management) | 6 | LBEZ | Name | nvarchar | 50 | 0 | | |
31 | TD30T | Distribution Channel | 6 | LBEZ | Name | nvarchar | 50 | 0 | | |
TOPPortfolio Analyzer |
32 | BMA_BMLAYERT | OLD CFM Benchmarking: Benchmark Layer (TEXTS) | 6 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
33 | BMA_BMT | OLD CFM Benchmarking: BM Central Master Data | 4 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
34 | BMA_CHT | OLD CFM Benchmarking: Characteristics (TEXTS) | 4 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
35 | BMA_CHVALT | OLD CFM Benchmarking: Characateristic Values (TEXTS) | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
TOPReal Estate Management |
36 | TIVBD | Print control classes fix./fitting charact. (texts) | 4 | LBEZ | Name | nvarchar | 50 | 0 | | |
TOPRisk Analysis |
37 | JBRALFDT | Texts for Due Date Scenario - Definition | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
38 | JBRBEWREGT | Valuation Rules for Evaluations (Texts) | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
39 | JBRBPT | Base Portfolio Definition: Text | 6 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
40 | JBRCFARTT | Texts for Description of Cash Flow Type | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
41 | JBRPHT | Portfolio hierarchy | 6 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
42 | JBRRHKNTT | Texts (only used for data definitions) | 6 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
43 | JBRRMBT | Text Table for Analysis Structure | 4 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
44 | JBRSARTT | Text Table for Balance Types | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
45 | JBRSIT | Dims texts | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
46 | JBRSPHT | Definition of Portfolio Hierarchy (Text Table) | 6 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
47 | JBRVREGT | Texts for Summarization Rule | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
TOPTreasury |
48 | ATKO1T | Text Table Correlation Type | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
49 | ATVO3T | Text Table Statistics Type | 5 | LBEZ | Long Name | nvarchar | 60 | 0 | | |
TOPVital Signs |
50 | N1VPST | Master Data Vital Signs (Language-Dependent Texts) | 6 | LBEZ | Vital Sign Long Text | nvarchar | 40 | 0 | | |