| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCCMS Database Monitors for Oracle |
1 | SDBAR | DBA Resource Table | 6 | RESTYPE | Single-Character Indicator | nvarchar | 1 | 0 | | |
TOPClaims Management |
2 | ICLALAERES | Current Reserves (Settlement Expenses (ALAE) and Losses) | 13 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
3 | ICLCCEVPAY | Claim Bundle - Payment Sum | 3 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
4 | ICLCCEVRES | Claim Bundle - Reserve Sum | 3 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
5 | ICLINDRESA | Claim-Independent Reserve - Case Reserve - Assignment | 6 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
6 | ICLINDRESI | Claim-Independent Reserve | 4 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
7 | ICLRESERVE | Case Reserve | 5 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
8 | ICLULAEDRIVER1 | Reported Distribution Key 1 | 13 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
9 | ICL_CRESPROF | Reserve Profile Determination in Multiple Insurance | 5 | RESTYPE | Claim Reserve Type | nvarchar | 2 | 0 | | |
10 | ICSCCEVPAY | Claim Bundle - Payment Sum | 3 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
11 | ICSCCEVRES | Claim Bundle - Reserve Sum | 3 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
12 | ICSRESERVE | Case Reserve | 5 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
13 | TICL020 | Reserve Type | 2 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
14 | TICL020T | Reserve Type Text | 3 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
15 | TICL053 | Internal Claim Type: Permitted Reserve Type | 6 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
16 | TICL056 | Internal Claim Type: Permitted Benefit Type | 10 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
17 | TICL082 | Reserve General Ledger Account Determination | 2 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
18 | TICL110_RESTYP | Amount Authorizations Reserves (per Reserve Type) | 6 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
19 | TICL162 | Benefit Type Tree: Permitted Benefit Type | 9 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
20 | TICL819 | Reserve Type for Supplemental Reserves | 2 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
21 | TICL872 | Reserve Type for Supplemental Reserves | 3 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
TOPFinancial Services Localization |
22 | /GSINS/REU_RST | Reserve Types for Extraction | 5 | RESTYPE | Reserve Type | nvarchar | 2 | 0 | | |
TOPIndustry-Specific Component Automotive |
23 | RESKEYR3 | Resource Proxy ERP | 5 | RESTYPE | APO Resource Category | nvarchar | 1 | 0 | | |
TOPIntegrated Product and Process Engineering |
24 | CPNRES | Customizing Table for Resource Nodes | 3 | RESTYPE | Basic Type of Production Resource | nvarchar | 2 | 0 | | |
TOPWork Center |
25 | KAKO | Capacity Header Segment | 36 | RESTYPE | Resource Category | nvarchar | 1 | 0 | | |