Reserved Database Fields across Solutions
- Nancy Cohn (Deactivated)
- Pamela Totas (Deactivated)
The following table lists the tag value, Eagle data warehouse table, field, and description of the database fields reserved from public use. While some clients can use these fields for their own purposes, other clients that use specific Eagle solutions should not use these fields for a custom purpose because the system natively populates these fields and leverages them for solution-specific purposes.
You can click any column heading to sort the rows by that column value.
Tag Value | Table | Field | Description | Reserved Use for |
|---|---|---|---|---|
4011 | RULESDBO.CLIENT | DISPLAY_NAME | Statutory Reporting Name | Insurance solution |
4025 | RULESDBO.CLIENT | USER_NUM1 | Weighted Average Portfolio Beta | Insurance solution |
4026 | RULESDBO.CLIENT | USER_NUM2 | Effective Tax Rate | Insurance solution |
4030 | RULESDBO.CLIENT | USER_CHAR1 | Reporting Rule 1 | Insurance solution |
4031 | RULESDBO.CLIENT | USER_CHAR2 | Reporting Rule 2 | Insurance solution |
4032 | RULESDBO.CLIENT | USER_CHAR3 | Cancel Open Election | Insurance solution |
4033 | RULESDBO.CLIENT | USER_CHAR4 | Annual Statement Vendor | Insurance solution |
4034 | RULESDBO.CLIENT | USER_CHAR5 | Reporting Company Type | Insurance solution |
4419 | RULESDBO.CLIENT | DUMMY_FLAG | Primary Asset ID Source | Insurance solution |
4428 | RULESDBO.CLIENT | OTHER_ACCOUNT_NBRS | SVO Company Code | Insurance solution |
5101 | RULESDBO.CLIENT | CLIENT_USER_CHAR6 | Non-Admitted Election | Insurance solution |
5102 | RULESDBO.CLIENT | USER_CHAR7 | Cash Dividend Tax/Reclaim | Insurance solution |
5103 | RULESDBO.CLIENT | CLIENT_USER_CHAR8 | Issuer Source | Insurance solution |
5104 | RULESDBO.CLIENT | CLIENT_USER_CHAR9 | NAIC Price Source | Insurance solution |
9608 | RULESDBO.CLIENT | CLIENT_ACCT_SYSTEM | NAIC Company Code | Insurance solution |
1323 | RULESDBO.ENTITY | CASH_BALANCE | Valuation Allowance | Insurance solution |
1330 | RULESDBO.ENTITY | USER_FLOAT8 | AVR Separate Account % | Insurance solution |
1862 | RULESDBO.ENTITY | USER_FIELD1 | Separate Account Company Type | Insurance solution |
1188 | SECURITYDBO.FIXED_ INCOME | NAIC_CODE | When Paid | Insurance solution |
1433 | SECURITYDBO.SECURITY_ MASTER | USER_GROUP_SECTOR2 | Affiliation/Passthrough Flag | Insurance solution |
1463 | SECURITYDBO.SECURITY_ MASTER_DETAIL | ALT_INVESTMENT_TYPE | Special Bond Classification | Insurance solution |
1465 | SECURITYDBO.SECURITY_ MASTER_DETAIL | ALT_MINOR_IND | Collateral Type | Insurance solution |
1466 | SECURITYDBO.SECURITY_ MASTER_DETAIL | ALT_TIER_IND | Bond Characteristic | Insurance solution |
1467 | SECURITYDBO.SECURITY_ MASTER_DETAIL | ALT_SECURITY_MINOR_TYPE | Foreign Type | Insurance solution |
1105 | RULESdbo.ENTITY_EXTENSION | USER_DESC1 | Override for Entity Description | Performance toolkit - Index |
1896 - | SECURITYdbo.SECURITY_MASTER | USER_GROUP_SECTOR1- | Custom | Performance toolkit - Index |
1505-3475 | SECURITYdbo.SECURITY_MASTER_DETAIL | USER_GROUP_CHAR1-25 | Custom | Performance toolkit - Index |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_CHAR1 | Currency Code used as the Yield Curve Identifier | Performance toolkit - Index, FIA attribution | |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_FLOAT60 | Effective Duration | Performance toolkit - Index, FIA attribution | |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_FLOAT61 | Effective Yield | Performance toolkit - Index, FIA attribution | |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_FLOAT62 | Effective Convexity | Performance toolkit - Index | |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_FLOAT50 | Net Return | Performance toolkit - Index, GIPS | |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_FLOAT32 | Local return | Performance toolkit - Index | |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_FLOAT7 | Gross investment base | Performance toolkit - Index, Reporting, GIPS, Attribution | |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_FLOAT8 | Gross return | Performance toolkit - Index, Reporting, GIPS, Attribution | |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_FLOAT1 | Opening Market Value (Index) Gross Beginning Market Value (GIPS) | Performance toolkit - Index, GIPS | |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_FLOAT2 | Closing Market Value (Index) Gross Ending Market Value (GIPS) | Performance toolkit - Index, GIPS | |
PERFORMdbo.PERF_SEC_RETURNS | PSR_USER_FLOAT5 | Gross Total Flows | Performance toolkit - GIPS | |
2614 | HOLDINGdbo.NAV | USER_DECIMAL1 | Alternative Reinvest Price | Performance toolkit - Retail Fund |
2615 | HOLDINGdbo.NAV | USER_DECIMAL2 | Section 1250 Gain | Performance toolkit - Retail Fund |
2616 | HOLDINGdbo.NAV | USER_DECIMAL3 | Retained Gain | Performance toolkit - Retail Fund |
2645 | HOLDINGdbo.NAV | USER_DATE2 | Section 1250 Reinvest Date | Performance toolkit - Retail Fund |
2646 | HOLDINGdbo.NAV | USER_DATE3 | Retained Cap Gain Reinvest Date | Performance toolkit - Retail Fund |
2664 | HOLDINGdbo.NAV | UD_PRICE1 | User price 1 | Performance toolkit - Retail Fund |
2665 | HOLDINGdbo.NAV | UD_PRICE2 | User price 2 | Performance toolkit - Retail Fund |
2666 | HOLDINGdbo.NAV | UD_PRICE3 | User price 3 | Performance toolkit - Retail Fund |
2667 | HOLDINGdbo.NAV | UD_PRICE4 | User price 4 | Performance toolkit - Retail Fund |
2674 | HOLDINGdbo.NAV | UD_INCDIST1 | User Income1 | Performance toolkit - Retail Fund |
2675 | HOLDINGdbo.NAV | UD_INCDIST2 | User Income2 | Performance toolkit - Retail Fund |
2676 | HOLDINGdbo.NAV | UD_INCDIST3 | User Income3 | Performance toolkit - Retail Fund |
2677 | HOLDINGdbo.NAV | UD_CAPGAIN1 | User CapGain1 | Performance toolkit - Retail Fund |
2678 | HOLDINGdbo.NAV | UD_CAPGAIN2 | User CapGain2 | Performance toolkit - Retail Fund |
2679 | HOLDINGdbo.NAV | UD_CAPGAIN3 | User CapGain3 | Performance toolkit - Retail Fund |
1433 | SECURITYDBO.SECURITY_MASTER | USER_GROUP_SECTOR2 | Affiliation/Pass Through | RDC package content |
1507 | SECURITYDBO.SECURITY_MASTER_DETAIL | USER_GROUP_CHAR3 | SIC Code (4-digit) | RDC package content |
8746 | SECURITYDBO.SECURITY_ANALYTICS_FI | USER_GROUP4 | User Group4 | RDC package content |
8744 | SECURITYDBO.SECURITY_ANALYTICS_FI | USER_GROUP1 | User Group 1 | RDC package content |
8760 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT9 | Fixed Income Float 9 | RDC package content |
8759 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT8 | Fixed Income Float 8 | RDC package content |
8758 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT7 | Key Rate Duration 7 (30-Year) | RDC package content |
8757 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT6 | Key Rate Duration 6 (20-Year) | RDC package content |
8756 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT5 | Key Rate Duration 5 (10-Year) | RDC package content |
8755 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT4 | Key Rate Duration 4 (5-Year) | RDC package content |
8754 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT3 | Key Rate Duration 3 (2-Year) | RDC package content |
8753 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT2 | Key Rate Duration 2 (6-Month) | RDC package content |
8768 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT17 | Fixed Income Float 17 | RDC package content |
8767 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT16 | Fixed Income Float 16 | RDC package content |
8766 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT15 | Fixed Income Float 15 | RDC package content |
8765 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT14 | Fixed Income Float 14 | RDC package content |
8764 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT13 | Fixed Income Float 13 | RDC package content |
8763 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT12 | Fixed Income Float 12 | RDC package content |
8762 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT11 | Fixed Income Float 11 | RDC package content |
8761 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT10 | Fixed Income Float 10 | RDC package content |
8752 | SECURITYDBO.SECURITY_ANALYTICS_FI | SA_FI_FLOAT1 | Key Rate Duration 1 (Cash) | RDC package content |
8751 | SECURITYDBO.SECURITY_ANALYTICS_FI | FI_DATE2 | Fixed Income Date 2 | RDC package content |
8750 | SECURITYDBO.SECURITY_ANALYTICS_FI | FI_DATE1 | Fixed Income Date 1 | RDC package content |
3331 | SECURITYDBO.EQUITY | EQUITY_FLOAT1 | Total Shares Outstanding | RDC package content |
3341 | SECURITYDBO.EQUITY | EQUITY_DATE1 | Shares Outstanding Date | RDC package content |