Reserved Database Fields across Solutions

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

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 -
1425

SECURITYdbo.SECURITY_MASTER

USER_GROUP_SECTOR1-
15

Custom
Sectors 1-15

Performance toolkit - Index

1505-3475

SECURITYdbo.SECURITY_MASTER_DETAIL

USER_GROUP_CHAR1-25

Custom
Sectors 16-40

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