| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /RPM/CAP_LVL_CD | Tracking Level for Capacity Planning Change Documents | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
2 | /RPM/FIN_LVL_CD | Tracking Level for Financial Planning Change Documents | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
3 | /RPM/PORT_INI_MP | Mapping: Initiative Types with Portfolio Types(Note 1748331) | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
4 | /RPM/PORT_ITM_MP | Mapping: Item Types with Portfolio Types (Note 1748331) | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
TOPCommon Functions |
5 | INM_NAV_CTX | INM Navigation Context | 3 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
6 | INM_NAV_CTX_W | INM Navigation Context Workcenter | 3 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
TOPLoans Management |
7 | VDCBR_RES_DATA | Table of Data Reported to Credit Bureau (Per Loan) | 14 | PORTFOLIO_TYPE | Loan Type | nvarchar | 1 | 0 | | |
TOPPortfolio Management |
8 | /RPM/CAP_CHART | Capacity Charting | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
9 | /RPM/CAP_VIEWMAP | Capacity view types for the portfolio type | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
10 | /RPM/DASHBOARD | Dashboard Attributes | 3 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
11 | /RPM/DASH_ROLE | Dashboard Attributes Override Table | 6 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
12 | /RPM/DSH_MET_ROL | Dashboard Metric Attributes | 6 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
13 | /RPM/DSH_PRS_ROL | Dashboard Customization Override Table | 6 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
14 | /RPM/FIN_CHART | Financial Charting | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
15 | /RPM/FIN_VIEWMAP | Financial view types for the portfolio types | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
16 | /RPM/FISCAL_VAR | Fiscal Year Variant | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
17 | /RPM/OBJ_GRPLINK | Object type- Group link definition | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
18 | /RPM/PORTFOLIO_D | Portfolio Operational persisted data | 8 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
19 | /RPM/PORT_CAPGRP | Linking Portfolio type and Capacity Category | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
20 | /RPM/PORT_CYCLE | Linking Portfolio type and Life Cycle | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
21 | /RPM/PORT_FI_GRP | Linking of Portfolio type and Financial Category | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
22 | /RPM/PORT_TYPE | Portfolio type definition | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
23 | /RPM/PORT_TYPE_T | Portfolio Text | 3 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
24 | /RPM/RV_STATUS | Review Status | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
25 | /RPM/RV_STATUS_N | Review Status : Next possible statuses | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
26 | /RPM/RV_STATUS_T | Review Status Text | 3 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
27 | /RPM/WHATIF_STAT | WhatIf Status | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
28 | /RPM/WHATIF_ST_N | Whatif Status : Next possible statuses | 2 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
29 | /RPM/WHATIF_ST_T | Whatif Status Text | 3 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |
30 | RPM_PORTFOLIO_CD | Portfolio attributes - Pseudo table for change documents | 8 | PORTFOLIO_TYPE | Portfolio | nvarchar | 15 | 0 | | |