Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This section describes the Entity Setup data fields.
For add or change processing, the ENTITY, ENTITY_STAR_PROCESSING, and corresponding history tables in the RULES database are updated. You can use tag 1256 to control inserts to several additional tables:

  • Tag 1256 as ENTEXT inserts to the ENTITY_EXTENSION and corresponding history tables.
  • Tag 1256 as ENTEXTD inserts to the ENTITY_EXTENSION, ENTITY_EXTENSION_DETAIL, and corresponding history tables.

The validation level, tag 1081, controls the application of Eagle Accounting core validations.
For change processing which applies the Eagle Accounting core validations, you must send:

  • Tag 1081 as NULL
  • Tag 1076 as Y or B
  • Tag 1163 is required
  • Tag 55 as ADDENTITY (the rule determines to update or insert)

For change processing which bypasses the Eagle Accounting core validations, such as records loaded for use with Performance Measurement, you must send:

  • Tag 1081 as NONE
  • Tag 1109, tag 1163, and tag 1163 are required

For both STAR tag/value and CSV formats, Eagle recommends that you send only the values that are being changed, in addition to the three tags mentioned above.
To review processing results in the database, use the List Entities query under the Accounting category in Eagle Accounting.
The following table describes the required and optional data fields to set up an Entity. Fields that are loaded[ for use with Performance Measurement |#perf_measure]are listed after this table.

Tag # – Tag Name

Required/Optional

Data Type

Value/Description of Field

55 – Event Type

Required – must be ADDENTITY

CHAR

Used by message stream processing.

1081 – Validation Level(internal processing field)

Required

CHAR

Controls the application of Eagle Accounting core validations. Options include:
Null – Validations are applied using the core panels.
NONE – Validations are not applied. Additional fields are now required, including EFFECTIVE_DATE (tag 1109), ENTITY_ID (tag 1163), and ENTITY_TYPE (tag 1105).

21 – Accounting Basis

Required – default value is USTAX

VARCHAR2(5)

 

22 – Cost Method

Required

VARCHAR2 (2)

Valid values:
A = Average
I = Identified

27 – Lot Selection Method

Required

VARCHAR2 (5)

Valid values:
FIFO = FIFO
LIFO = LIFO
HCLOT = High Amortized Cost
LCLOT = Low Amortized Cost
HORIG = High Original Cost
LORIG = Low Original Cost
IDLOT = Identified Lot
BTAX = Best Tax
TXADV = Tax Advantage

29 – Entity Long Name

Optional

CHAR (60)

 

57 – Tech Short Eligible Indicator

Required – default value is Y

VARCHAR2 (2)

Valid values:
Y = Yes
N = No

58 – Auto Settle Indicator

Required – default value is N

VARCHAR2 (2)

Valid values:
N = No
Y = Yes

86 – Account Base Currency

Required

CHAR (3)

Must be a valid currency code.

301 – Lookup STIF Issue Name

Optional

CHAR

 

364 – Lookup STIF Asset ID

Optional

CHAR

 

527 – Settle Tolerance Income

Optional

NUMBER (28,12)

 

528 – Settle Tolerance Trade

Optional

NUMBER (28,12)

 

624 – Accounting Period Frequency

Required – default value is D

VARCHAR2 (30)

Valid values:
D = Daily
M = Monthly

632 – Net Futures Positions

Optional

VARCHAR2 (30)

Valid values:
Y = Yes
N = No

634 – Futures Clearing Broker Code

Optional

VARCHAR2 (30)

Code Value lookup based on code category CLEARING BROKER.

637 – Coupon Spreading Period

Required – default value is N

VARCHAR2 (30)

Valid values:
N = None
M = Monthly
C = Coupon

639 – Net Option Positions

Optional

VARCHAR2 (30)

Valid values:
Y = Yes
N = No

641 – Future Cost Ledger Method

Optional – default value is CORE

VARCHAR2 (30)

Valid values:
CORE = Core
UK = UK

675 – Forward Security Exists

Optional

VARCHAR2 (3)

Valid values:
Y = Yes
N = No

769 – Settle Percent Tolerance Income

Optional

NUMBER (28,12)

Must be whole number.

770 – Settle Percent Tolerance Trade

Optional

NUMBER (28,12)

Must be whole number.

775 – Wash Sale Inhibit Indicator

Required – default value is Y

VARCHAR2 (2)

Valid values:
Y = Yes
N = No

989 – History Processing Switch(internal processing field)

Optional

CHAR

This switch is used for loads of historical entity data. If it is set to HISTORY_ONLY, the procedure will check for a record in the ENTITY_HIST table with an EFFECTIVE_DATE greater than the value in tag 1109. If a match is found, the incoming record will be stored in the ENTITY_HIST table only and will not affect the ENTITY table. If no match is found, both the ENTITY and ENTITY_HIST tables will be populated.

1076 – Update Indicator

Required

CHAR

Y/N indicator used within message stream process. Valid values:
Y = UPDATE
N = NEW RECORD
B = Both. Check for existing match on entity ID. If found, update record; else insert.

1085 – Conversion Status

Optional

CHAR

Code Value lookup based on code category CONVERT STATUS.

1105 – Entity Type

Required – default value is PORT

CHAR (4)

Type of entity. Sample values include:
PORT = Portfolio
INDX = Benchmark
CIDX = Custom Benchmark
ACOM = Performance Composite

1109 – Effective Date

Required for thePerformance Toolkit

DATE

Controls the establishment and updating of ENTITY and ENTITY_HIST records, which are used by the Performance Toolkit.

1138 – Inception Date

Required

DATE

Used for Eagle Performance.

1143 – Taxable Indicator

Optional – default value is N

CHAR (30)

Valid values:
N = No
Y = Yes

1149 – Manager ID

Optional

CHAR (8)

 

1160 – Inception Value

Optional

NUMBER (28,12)

 

1161 – Termination Date

Optional

DATE

 

1162 – Fiscal End Date

Required

DATE

Used for year–end close processing.

1163 – Entity ID

Required

CHAR (8)

Must be Unique within database.

1164 – Entity Name

Required

CHAR (30)

 

1282 – Long Price Source

Required – default value is EAGLE PACE

CHAR (15)

Lookup based on INTERFACES_DETAIL table.

1283 – Entity Status

Required – default value is Y

VARCHAR2 (3)

Valid values:
Y = Active
N = Inactive

1304 – Contractual Cash Settlement Type

Required

VARCHAR2 (2)

Valid values:
T = Trades Only
I = Income Only
B = Both
N = None

1334 – Entity Partition Assignment

Required – defaults to 1

INTEGER

Dynamic lookup that retrieves available STAR partitions.

1341 – Tax ID Number

Optional

VARCHAR2 (50)

 

1342 – Country Of Tax Code

Required

CHAR (10)

Must be a valid ISO currency code.

1344 – FX Source

Required – default value is EAGLE PACE

CHAR (15)

Lookup based on INTERFACES_DETAIL table.

1641 – Chart of Account

Required – default value is STAR

VARCHAR2 (30)

Lookup based on custom chart of account name.

1859 – Entity Legal Name

Optional

VARCHAR2 (200)

 

1871 – Gain/Loss on Paydowns

Required

CHAR (2)

Valid values:
Y = Gain/Loss
N = Amortization

1872 – Short Term Price Method

Required – default value is M

CHAR (2)

Valid values:
M = Market
C = Cost

1941 – Calendar Name

Optional

VARCHAR2 (50)

Lookup based on valid calendars setup.

2198 – STAR Start Date

Required

DATE

Used to create STAR accounting periods.

2300 – Accounting Period Rule

Required – default value is 7

CHAR

Used to determine how to set the accounting date on transactions. Valid values:
3 = Entity
6 = Entity Group
7 = System Default

3197 – Primary Amortization/Accretion Rule

Required – default value is DEFAULTNONE

VARCHAR2(12)

Lookup based on accounting rules

3301 – Variable Rate Source

Required – default value is EAGLE PACE

VARCHAR2 (15)

Lookup based on INTERFACES_DETAIL table

3889 – Futures & Options with Margin Transaction Fees

Optional

VARCHAR2 (2)

Futures and options with margin transaction fees

3907 – Non Business Day Processing

Optional

VARCHAR2 (10)

Required if Calendar is being used. Valid values:
P = Process with previous day
N = Process with next day

3911 – Accrue Interest Tax Indicator

Optional

VARCHAR2 (3)

Valid values:
N = No
Y = Yes

3912 – Tax Accounting Method

Required – default value is GI

VARCHAR2 (10)

Valid values:
GI = Gross Income Method
GL = Gross Liability Method
NM = Net Method

3913 – Forward Position By Broker

Optional

VARCHAR2 (3)

Valid values:
Y = Yes
N = No

3915 – Conversion Date

Required

DATE

 

3916 – Live Date

Optional

DATE

 

3917 – Cost Allocation Indicator For Rights Issues

Optional

VARCHAR2 (3)

Valid values:
Y = Allocate Cost
N = Do Not Allocate Cost
R = Calculate 15 Rule

3919 – Contract Settle Indicator

Optional

VARCHAR2 (3)

Valid values:
0 = Contractual Settlement Date
1 = Contractual Settlement Date plus 1 day

3924 – Forward Close Eligible

Optional

VARCHAR2 (3)

Valid values:
Y = Yes
N = No

3926 – Forward Settlement Currency

Optional

VARCHAR2 (3)

Lookup based on currency code.

3928 – Cash Dividend Distribution

Optional

VARCHAR2 (3)

Valid values:
Y = Yes
N = No

3929 – Entity Tax Type

Optional

VARCHAR2 (20)

Code Value lookup based on code category ENTITY TAX TYPE.

3930 – Entity Tax Qualifier

Optional

VARCHAR2 (8)

Code Value lookup based on code category ETAX QUALIFIER.

3950 – Cash Suspense Processing

Required

VARCHAR2 (3)

Valid values:
Y = Yes
N = No

4303 – Accounting Date Rule Group

Conditionally Required if tag2300 = Entity Group

CHAR (20)

Dynamic lookup of Entity Groups.

4324 – Entity Code

Optional

VARCHAR2 (50)

 

4514 – Interest On Cash

Optional

VARCHAR2 (30)

Valid values:
N = No
Y = Yes

4515 – Cash Sweep

Optional – default value is N

VARCHAR2 (3)

Valid values:
N = No
Y = Yes

4519 – Paydown Gain/Loss Account

Conditionally Required if tag1871 = Y

VARCHAR2 (15)

Valid values:
CAPITAL = Capital
INCOME = Income

4605 – Expiration Delay Days

Required – default value is 0

INTEGER

Valid values are any non decimal numeric value.

4758 – S2P Delta Process Flag

Required – default value is N

VARCHAR2 (1)

Valid values:
N = No
Y = Yes

4896 – Process Center

Optional

VARCHAR2 (2)

Lookup based on Process Center.

5011 – MFP Conversion Calendar

Optional

NUMBER(38,12)

Maps to ENTITY_EXTENSION and ENTITY_EXTENSION_HIST tables.

5064 – MTM Rate Source

Optional

CHAR(15)

Mark to market rate source.

5089 – Legal Entity Indicator (LEI)

Optional

VARCHAR2 (20)

Alphameric LEI assignment for this entity. For example, GYP225J5YLMZZGHN2C97.

5090 - Legal Name

Optional

NVARCHAR2(255)

Legal Name

5091 - Entity Status

Optional

NVARCHAR2(30)

Entity Status

5092 - Legal Form

Optional

NVARCHAR2(30)

Legal Form

5093 - Assigned Date

Optional

DATE

Assigned Date

5094 - Last Update Date

Optional

DATE

Last Update Date

5095 - Disabled Date

Optional

DATE

Disabled Date

5096 - Record State

Optional

NVARCHAR2(30)

Record State

5097 - Certification State

Optional

NVARCHAR2(30)

Certification State

5098 - Street

Optional

NVARCHAR2(255)

Street

5099 - City

Optional

NVARCHAR2(255)

City

5100 - State

Optional

NVARCHAR2(255)

State

5180 - Zip

Optional

NVARCHAR2(255)

Zip

5181 - Country Code

Optional

NVARCHAR2(30)

Country Code

5161 – Month End Date Rule

Required – default value is DEFAULT

CHAR (10)

Lookup based on Month End rules.

5383 – Unrealized Gain/Loss Posting

Required – default value is Y

CHAR (1)

Valid values:
Y = Yes
N = No

5398 – S2P Create Performance Cash Flows In PACE

Required – default value is N

VARCHAR2 (1)

Valid values:
N = No
Y = Yes

5422 – Short Price Source

Required – default value is EAGLE PACE

CHAR (15)

Lookup based INTERFACES_DETAIL table.

5563 – S2P Store Cash Positions In PACE

Required – default value is N

VARCHAR2 (1)

Valid values:
N = No
Y = Yes

5825 – Bifurcation Method

Required – default value is N

VARCHAR2 (3)

Valid values:
N = No
Y = All
988 = Section 988

5830 – Net Cap Floor

Optional

VARCHAR2 (1)

Valid values:
Y = Yes
N = No

7101 – Accounting Basis Lot Selection Rule

Required – default value is B

CHAR

Valid values:
B = Use Basis Value unless event = IDLOT or VSP
E = Use Event Value
A = Always Use Basis Value
H = Use historical method unless event = IDLOT or VSP; else use event.

8141 – Stale Factor Processing

Required – default value is N

VARCHAR2(1)

Valid values:
N = No
Y = Yes

8251 – Treatment Of Fractional Shares Override

Optional

VARCHAR2 (1)

Valid values:
D = Round Down
N = Post Fractional Shares
U = Round Up
E = European
R = Round to Nearest Whole Share

8916 – Redemption Gain/Loss Indicator

Optional – default value is Y

VARCHAR2 (1)

Valid values:
Y = Gain/Loss
N = Amortization

8919 – Short Term Discount Accrual Flag

Optional – default value is N

VARCHAR2 (1)

Valid values:
N = Amortize
Y = Accrue Discount

8954 – Earn Thru Rule Name

Optional

CHAR

Required if Calendar is being used. Lookup based on Earn Thru rules.

9406 – TBA Cashflow

Required – default value is N

VARCHAR2(1)

Valid values:
N = No
Y = Yes

9676 – Month End Long Price

Conditionally Required if tag9697 = Y. Default value is EAGLE PACE.

CHAR (15)

Lookup based on sources.

9677 – Month End Short Price

Conditionally Required if tag9697 = Y. Default value is EAGLE PACE.

CHAR (15)

Lookup based on sources.

9697 – Month End Processing Indicator

Required – default value is N

VARCHAR2 (1)

Valid values:
N = No
Y = Yes

9705 – Corporate Action FX Rule

Optional

VARCHAR2 (1)

Valid values:
R = Recent
A = Actual

9921 – Awarded Rights Expiration Rule

Optional – default value is LOSS

VARCHAR2 (10)

Valid values:
LOSS = Loss
TRANSFER = Transfer

9922 – Cash Div Cash Entitlement Level

Optional – default value is LOT

VARCHAR2 (10)

Valid values:
LOT = Lot level
POSITION = Position level

9923 – Sinking Fund Payment Redemption Gain/Loss

Required – default value is Y

VARCHAR2 (1)

Valid values:
Y = Treat Gain/Loss from Sinking Fund Payment asGain/Loss
N = Treat Gain/Loss from Sinking Fund Payment as Accelerated Amortization
C = Capitalize Sinking Fund Payments
G = If Pro Rata Sinking Fund Capitalize; else Calculate Gain/Loss.
A = If Pro Rata Sinking Fund Capitalize; else Calculate Amortization.

9924 – Cost Method Cash

Required

VARCHAR2 (2)

Valid values:
A = Average
I = Identified

10070 – Final Close Income Recognition Date

Required – default value is S

INTEGER

Valid values:
S = Settle Date
T = Trade Date

10462 – Control Center Entity

Required – default value is N

VARCHAR2 (4)

Valid values:
N = No
Y = Yes

11408 – S2P Income Delta Process

Required – default value is None

CHAR

Valid values:
Income = Income
Cash = Cash
Both = Both
None = None

11454 – S2P Value At Cost – No Price Found

Required

VARCHAR2 (255)

Valid values:
Y = Yes
N = No

11495 – Non Tax Merger Close Method

Required – defaults to Pro Rata Method

CHAR (8)

Identifies method to use for closing Non Tax Mergers. Valid values:
PRM = Pro Rata Method
LSM = Lot Selection Method

11652 – Valuation FX Source

Required – defaults to Eagle PACE

CHAR (15)

FX Source to use for Valuation Purposes.

11664 – Primary Basis Mixed Cost Basis Indicator

Required – default value is N

CHAR (50)

Y/N indicator. Mixed cost basis processing allows you to specify different lot selection methods based on processing security type.

11666 – Primary Basis Mixed Cost Basis Rule Name

Conditionally Required if Tag11664 = Y. Tag 11666 must be populated with the rule name.

CHAR (50)

Dynamic lookup of mixed Cost Basis rules.

11708 – Postmatrix Type

Required – defaults to CORE

VARCHAR2 (30)

Designates which Postmatrix file is referenced for processing. Valid values:
CORE = Core
INS = Insurance

11833 – Contract Cash Settlement Rule Name

Required

DATE

Lookup based on Cash Processing Rules.

11852 – Coupon Cash Entitlement Level

Optional

CHAR (2)

Valid values:
LOT = Lot level
POSITION = Position level

824 – Calendar Business Days

Required – defaults to C

VARCHAR2(1)

Valid values:
B– Business
C– Calendar

1079 – Urgl Accounting Rule

Conditionally Required if tag 12387 = HFT, AFS, AFSC, FVO, LR, or HTM.

CHAR

Accounting Rule lookup

1184– Swap Accrual Method

Optional

VARCHAR2(1)

Valid values:
I – Income/Expense
U – Unrealized

10705– Expense & Capitalize Trans Costs for Opens & Closes

Optional

VARCHAR2 (4)

Valid values:
CC – Capitalize Trans Fees on Opens & Net Trans Fees against Proceeds on Closes
EC – Expense Trans Fees on Opens & Net Trans Fees against Proceeds on Closes
EE – Expense Trans Fees on Open & Close Trades

11081–Taxable Override Indicator

Optional

INTEGER

Y– Yes
N – No

12071–Cash Breakage Election

Required

NUMBER (28,12)

I – Income
PI– Both Principal and Income

12074 – Replay Suspense Activity

Required

NUMBER (28,12)

Y– Yes
N – No

12101 – Option And Futures Expire Delay Days

 

NUMBER (28,12)

 

2423 – Costcash Bulking Election*

 

VARCHAR2(1)

Valid Values:
N – No
Y – Yes

4623 – Entity Engine Number*

 

INTEGER

Engine Number code value.

12387 – Regulatory Category

 

CHAR

Lookup of regulatory categories

2925 – Principal Loss Paydown

Optional

CHAR

Principal loss paydown.

4519 – Paydown Gain/Loss Account

Optional

VARCHAR2 (15)

Paydown gain/loss account number.

12038 – Accrual Convention Offset

Optional

DATE

Specifies when Eagle Accounting begins earnings accruals. Options include:
Settlement Date. Default. Eagle Accounting accrues through the day prior to a coupon payment and then begins accruing for the new coupon on the coupon pay date.
Settlement Date + 1. Eagle Accounting begins earnings accruals using a one day lag. It accrues through the coupon date for the current period and pays it out that day, and then begins accruing for the new coupon on the coupon date plus one day so that the accrued income on the coupon date is zero. This method can apply to countries such as Canada.

5336 – Portfolio turnover Group Name

Optional

VARCHAR2(20)

Group name of portfolio exclude rules. Code value under PTGROUP code category and Eagle PACE.

2487 – Limit Gain Loss Eligible

Optional

CHAR

Indicates whether or not the accounting basis is eligible for merger gain/loss limitation provisions. Options include Yes and No.

3679 – Pending Trade Eligible Indicator

Optional

CHAR

Entity level indicator that determines if trades can be pended and not submitted directly to the STAR engine. Options include Yes and No.

Fields for Use with Performance Measurement

Validation Level (tag 1081) is a required field that controls whether to apply Eagle Accounting core validations. Options include:

  • Null – Validations are applied using the core panels.
  • NONE – Validations are not applied. Additional fields are now required, including Effective Date (tag 1109), Entity ID (tag 1163), and Entity Type (tag 1105).

The following fields are loaded for use with Performance Measurement.

Tag # – Tag Name

Data Type

Database

Field

1081 – Validation Level 

CHAR
Required

See note above.

 

2442 – Cumulative split ratio for retail performance

NUMBER(38,12)

ENTITY_EXTENSION

mfp_split_ratio

2508 I Discretionary Status

VARCHAR2 (10)

ENTITY_EXTENSION

discretionary_flag

2509 – Country where fund is managed

VARCHAR2 (10)

ENTITY_EXTENSION

domicile

2510 – Fee paying/non fee paying

VARCHAR2 (10)

ENTITY_EXTENSION

fee_flag

2511 – Industry – Standard

VARCHAR2 (10)

ENTITY_EXTENSION

industry

2512 – Minimum Cash Percent

NUMBER(38,12)

ENTITY_EXTENSION

minimum_cash_pct

2513 – Minimum MV

NUMBER(38,12)

ENTITY_EXTENSION

minimum_mv

2514 – Strategy

VARCHAR2 (10)

ENTITY_EXTENSION

strategy

2515 – Sub Strategy

VARCHAR2 (10)

ENTITY_EXTENSION

sub_strategy

2094 – General status of the account.

CHAR (20)

ENTITY

account_status

10745 – Entity.asset_class

VARCHAR2 (4)

ENTITY

asset_class

1988 – Contingent deferred sales charge as of year 1

NUMBER (28,12)

ENTITY

cdsc_load_year_1

11041 – Contingent deferred sales charge as of year 10

VARCHAR2 (255)

ENTITY

cdsc_load_year_10

1989 – Contingent deferred sales charge as of year 2

NUMBER (28,12)

ENTITY

cdsc_load_year_2

1990 – Contingent deferred sales charge as of year 3

NUMBER (28,12)

ENTITY

cdsc_load_year_3

1991 – Contingent deferred sales charge as of year 4

NUMBER (28,12)

ENTITY

cdsc_load_year_4

1992 – Contingent deferred sales charge as of year 5

NUMBER (28,12)

ENTITY

cdsc_load_year_5

1993 – Contingent deferred sales charge as of year 6

NUMBER (28,12)

ENTITY

cdsc_load_year_6

11038 – Contingent deferred sales charge as of year 7

CHAR (50)

ENTITY

cdsc_load_year_7

11039 – Contingent deferred sales charge as of year 8

CHAR (50)

ENTITY

cdsc_load_year_8

11040 – Contingent deferred sales charge as of year 9

VARCHAR2 (255)

ENTITY

cdsc_load_year_9

1864 – Entity table client_id

INTEGER

ENTITY

client_id

2072 – Flag account and/or holding as closed

CHAR (20)

ENTITY

closed_flag

2067 – Customer type

CHAR (20)

ENTITY

customer_type

1333

INTEGER

ENTITY

entity_alias

1863 – Entity table entity_build_flag

CHAR (2)

ENTITY

entity_build_flag

9510 – Entity_sub_type

VARCHAR2 (20)

ENTITY

entity_sub_type

1987 – Front end sales charge

NUMBER (28,12)

ENTITY

front_end_load

2073 – Flag no activity for 12 months

CHAR (20)

ENTITY

inactive_flag

9519 – Incentive_fee

NUMBER (28,12)

ENTITY

incentive_fee

2422 – Used to capture unique share class identifier

CHAR(8)

ENTITY

parent_fund_id

1855 – Portfolio type

CHAR (4)

ENTITY

portfolio_type_code

10738 – Reporting name

VARCHAR2 (4)

ENTITY

reporting_name

1168

INTEGER

ENTITY

src_intfc_inst

1857 – State code

CHAR (4)

ENTITY

state_code

1860

CHAR (30)

ENTITY

style

9518

NUMBER (28,12)

ENTITY

termination_market_value

1320

DATE

ENTITY

user_date1

1321

DATE

ENTITY

user_date2

1322

DATE

ENTITY

user_date3

1319

DATE

ENTITY

user_date4

1895

DATE

ENTITY

user_date5

1862

VARCHAR2 (10)

ENTITY

user_field1

1340

VARCHAR2 (10)

ENTITY

user_field11

1867

VARCHAR2 (10)

ENTITY

user_field15

1868

VARCHAR2 (10)

ENTITY

user_field16

1642

VARCHAR2 (10)

ENTITY

user_field17

1643

VARCHAR2 (10)

ENTITY

user_field18

1856

VARCHAR2 (10)

ENTITY

user_field2

1649

VARCHAR2 (20)

ENTITY

user_field24

1650

VARCHAR2 (20)

ENTITY

user_field25

1858

VARCHAR2 (10)

ENTITY

user_field3

1853

VARCHAR2 (10)

ENTITY

user_field4

1854

VARCHAR2 (10)

ENTITY

user_field5

1324

NUMBER (28,12)

ENTITY

user_float1

193

NUMBER (28,12)

ENTITY

user_float2

1326

NUMBER (28,12)

ENTITY

user_float3

1327

NUMBER (28,12)

ENTITY

user_float4

1328

NUMBER (28,12)

ENTITY

user_float5

1329

NUMBER (28,12)

ENTITY

user_float6

1332

NUMBER (28,12)

ENTITY

user_float7

1330

NUMBER (28,12)

ENTITY

user_float8

2449 – Annual expense waiver ratio

NUMBER(28,12)

ENTITY_EXTENSION

mfp_ann_expwaiver

2436 – Override for convertible return frequency

CHAR(2)

ENTITY_EXTENSION

mfp_conv_frequency

2437 – Convertible return parent id

CHAR(8)

ENTITY_EXTENSION

mfp_conv_parent_id

2438 – Override for convertible return period

NUMBER(38)

ENTITY_EXTENSION

mfp_conv_period

2439 – Derived reinvest date behavior for distributions

VARCHAR2(10)

ENTITY_EXTENSION

mfp_distribution_type

2448 – Annual expense ratio

NUMBER(28,12)

ENTITY_EXTENSION

mfp_exp_ratio

2440 – Fixed date for convertible return crossover

DATE

ENTITY_EXTENSION

mfp_fixed_conv_date

2450 – Override gross return accrual methodology

 VARCHAR2(2)

ENTITY_EXTENSION

mfp_gr_accrual

2441 – Open and closed end fund flag

VARCHAR2(10)

ENTITY_EXTENSION

mfp_open_closed_flag

2443 – Calendar for non business records and income spreading

NUMBER(38)

ENTITY_EXTENSION

mfp_spread_calendar

2444 – Override for income spreading methodology

VARCHAR2(3)

ENTITY_EXTENSION

mfp_spread_method

2445 – Synthetic inception

DATE

ENTITY_EXTENSION

mfp_syn_inception_date

2446 – Synthetic parent ID

CHAR(8)

ENTITY_EXTENSION

mfp_syn_parent_id

2447 – Tax/tax–exempt income flag

VARCHAR2(10)

ENTITY_EXTENSION

mfp_taxable_income_flag

2442 – Cumulative split ratio for retail performance

NUMBER(38,12)

ENTITY_EXTENSION

mfp_split_ratio

11506 – Amount of the redemption fee

VARCHAR2 (100)

ENTITY_EXTENSION

redemption_fee

11505 – Frequency basis for which a redemption fee is valid

VARCHAR2 (100)

ENTITY_EXTENSION

redemption_frequency

11504 – Period of time for which a redemption fee is valid

VARCHAR2 (100)

ENTITY_EXTENSION

redemption_period

1106 – Information last updated

DATE

ENTITY/ENTITY_EXTENSION

upd_date

944 – Source or userid last updating entity

VARCHAR2 (8)

ENTITY/ENTITY_EXTENSION

upd_user

8206

VARCHAR2 (20)

ENTITY_EXTENSION

user_char71

8207

VARCHAR2 (20)

ENTITY_EXTENSION

user_char72

8200

VARCHAR2 (100)

ENTITY_EXTENSION

user_desc1

5698

NUMBER (28,12)

ENTITY_EXTENSION

user_float2

4124

VARCHAR2 (3)

ENTITY_EXTENSION

user_ind1

4125

VARCHAR2 (3)

ENTITY_EXTENSION

user_ind2

5663

VARCHAR2 (50)

ENTITY_EXTENSION

user_sector1

5664

VARCHAR2 (50)

ENTITY_EXTENSION

user_sector2

8200

VARCHAR2 (100)

ENTITY_EXTENSION

user_desc1
  • No labels