Page Comparison

55 – Event Type

Required

CHAR

Required – defaults on panel. Used by message stream for identification of the event. Must be UPLOAD_POSITION.

n/a

n/a

1102 – Source Name

Conditional Required – if tag 1168 is null.

CHAR (15)

Used to resolve src_intfc_inst if tag 1168 is null.

n/a

n/a

1168 – Src_Intfc_inst

Conditionally Required – tag 1102 is null

INTEGER

HOLDING.POSITION

Src_Intfc_Inst

7001 – Resolve in Panel Flag

Optional

CHAR

Used by message stream to determine if entity ID and security alias should be resolved in the panel or the procedure. Valid Values: 1 – Resolve All, 2 – Resolve Entity Only, 3 – Resolve None (resolve using the procedure).
Default is 1.

n/a

n/a

1081 – Entity Translation Type

Optional

CHAR

Used to indicate that the entity cross reference or entity bank relationship is used to generate the entity identifier. Options include:

• NONE/NULL (default). No translation, the entity ID/Name value provided is used.
• BANK. The entity bank relationship lookup LENTBANKREL is performed using tag 16.
• XREFERENCE. The entity cross reference table lookup is performed using tags 7233 and 7234.

n/a

n/a

7233 – Entity Xref ID

Conditionally Required – used when tag 1081 is set to XREFERENCE and tag 1163 is NULL.

CHAR

Used for entity ID resolution. The value corresponds to the tag 1233 value used for entity cross reference lookup.

n/a

n/a

7234 – Entity Xref ID Type

Conditionally Required – used when tag 1081 is set to XREFERENCE and tag 1163 is NULL.

CHAR

Used for entity ID resolution. The value corresponds to the tag 1234 value used for entity cross reference lookup.

n/a

n/a

1233/14 – Security ID

Conditionally Required – tag 7001 = 1 or 2

CHAR (100)

Xreference lookup to resolve security alias.

n/a

n/a

1234 – Security ID Type

Conditionally Required – tag 7001 = 1 or 2

CHAR (30)

Xreference lookup to resolve security alias.

n/a

n/a

1952 – XID 1

Conditionally Required – tag 7001 = 3

CHAR (100)

Used to resolve security_alias.

n/a

n/a

1953 – XID Type 1

Optional

CHAR (30)

Used to resolve security_alias.

n/a

n/a

1955 – XID 2

Conditionally Required – tag 7001 = 3

CHAR (100)

Used to resolve security_alias.

n/a

n/a

1956 – XID Type 2

Optional

CHAR (30)

Used to resolve security_alias.

n/a

n/a

1958 – XID 3

Conditionally Required – tag 7001 = 3

CHAR (100)

Used to resolve security_alias.

n/a

n/a

1959 – XID Type 3

Optional

CHAR (30)

Used to resolve security_alias.

n/a

n/a

1961 – XID 4

Conditionally Required – tag 7001 = 3

CHAR (100)

Used to resolve security_alias.

n/a

n/a

1962 – XID Type 4

Optional

CHAR (30)

Used to resolve security_alias.

n/a

n/a

1964 – XID 5

Conditionally Required – tag 7001 = 3

CHAR

Used to resolve security_alias.

n/a

n/a

1965 – XID Type 5

Optional

CHAR

Used to resolve security_alias.

n/a

n/a

1967 – XID 6

Conditionally Required – tag 7001 = 3

CHAR

Used to resolve security_alias.

n/a

n/a

1968 – XID Type 6

Optional

CHAR

Used to resolve security_alias.

n/a

n/a

1970 – XID 7

Conditionally Required – tag 7001 = 3

CHAR

Used to resolve security_alias.

n/a

n/a

1971 – XID Type 7

Optional

CHAR

Used to resolve security_alias.

n/a

n/a

7052 – CUSIP Xref – ID

Not used if tag 7001 = 3

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution.

n/a

n/a

7053 – Xref – ID Type for 7052

Optional

CHAR

Xref ID type associated with tag 7052; defaults to CUSIP.

n/a

n/a

7055 – ISIN Xref – ID

Not used if tag 7001 = 3

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution.

n/a

n/a

7056 – Xref – ID Type for 7055

Optional

CHAR

Xref ID type associated with tag 7055; defaults to ISIN.

n/a

n/a

7058 – SEDOL Xref – ID

Not used if tag 7001 = 3

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution.

n/a

n/a

7059 – Xref – ID Type for 7058

Optional

CHAR

Xref ID type associated with tag 7058; defaults to SEDOL.

n/a

n/a

7061 – REUTERS Xref – ID

Not used if tag 7001 = 3

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution.

n/a

n/a

7062 – Xref – ID Type for 7061

Optional

CHAR

Xref ID type associated with tag 7061; defaults to RIC.

n/a

n/a

7064 – BLOOMBERG Xref – ID

Not used if tag 7001 = 3

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution.

n/a

n/a

7065 – Xref – ID Type for 7064

Optional

CHAR

Xref ID type associated with tag 7064; defaults to BBID.

n/a

n/a

7067 – SICOVM Xref – ID

Not used if tag 7001 = 3

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution.

n/a

n/a

7068 – Xref – ID Type for 7067

Optional

CHAR

Xref ID type associated with tag 7067; defaults to SICOVM.

n/a

n/a

7070 – VALOREN Xref – ID

Not used if tag 7001 = 3

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution.

n/a

n/a

7071 – Xref – ID Type for 7070

Optional

CHAR

Xref ID type associated with tag 7070; defaults to VALOREN.

n/a

n/a

7073 – CEDEL Xref – ID

Not used if tag 7001 = 3

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution.

n/a

n/a

7074 – Xref – ID Type for 7073

Optional

CHAR

Xref ID type associated with tag 7073; defaults to CEDEL.

n/a

n/a

7076 – INTERNAL Xref – ID

Not used if tag 7001 = 3

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution.

n/a

n/a

7077 – Xref – ID Type for 7076

Optional

CHAR

Xref ID type associated with tag 7076; defaults to INTERNAL.

n/a

n/a

7079 – CINS Xref – ID

Not used if tag 7001 = 3

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution.

n/a

n/a

7080 – Xref – ID Type for 7079

Optional

CHAR

Xref ID type associated with tag 7079; defaults to CINS.

n/a

n/a

1981 – Xreference Exchange

Optional

CHAR (8)

Used by the Xref ID lookup to further qualify the security resolution.

n/a

n/a

38 – Maturity Date

Optional

DATE

Date on which the security matures. Used by the Xref ID lookup to qualify security resolution.

n/a

n/a

11043 – Inactive flag

Optional

VARCHAR2 (255)

Valid values are Y = Yes or N = No. Used by the Xref ID lookup to qualify security resolution.

n/a

n/a

85 – Asset Currency

Optional

CHAR (30)

3-character currency code – Code Value. Used by the Xref ID lookup to qualify security resolution.

n/a

n/a

1981 – Xref Exchange

Optional

CHAR (8)

Used by the Xref ID lookup to further qualify the security resolution.

n/a

n/a

17 – Primary Exchange Code

Optional

CHAR (8)

Exchange on which the security is listed – Code Value.

n/a

n/a

21– acct basis

VARCHAR2(5)

HOLDING.POSITION

Acct_basis

1105 – entity_type

Optional

CHAR (4)

HOLDING.POSITION

Entity_flag_type

86 – base_currency

Optional

CHAR (3)

HOLDING.POSITION/POSITION_DETAIL

Base_Currency

10 – security_alias

Optional

NUMBER

HOLDING.POSITION_DETAIL

Security_Alias

85 – local_currency

Optional

CHAR (30)

HOLDING.POSITION_DETAIL

Local_Currency

1163 – Entity ID

Conditionally Required – either tag 1163 or tag 1164 must be sent, unless tag 1081 set to BANK or XREFERENCE.

CHAR (8)

POSITION

Entity_ID

1164 – Entity Name

Conditionally Required – either tag 1163 or tag 1164 must be sent, unless tag 1081 set to BANK or XREFERENCE.

CHAR (30)

n/a

n/a

221 – Effective Date

Required

DATE

POSITION/POSITION_DETAIL/POSITION_COST_DETAIL

effective_date

15 – Long/Short Indicator

Required

CHAR

POSITION_DETAIL

long_short_ind

24 – Cost Basis Type

Optional

CHAR

This value contains a value defining the cost basis type provided on the transaction.

HOLDING.POSITION_COST_DETAIL

Cost_basis_type

41 – Original Face

Optional

NUMBER(38,12)

Original face of the MBS position

HOLDING.POSITION_DETAIL

Orig_Face

49 – Accrued Interest TRD Local

Optional

MONEYL

This value is a rollup of the open lot total purchased accrued interest (Tag 49). This value reflects the accrual provided at the time of the opening trade.

HOLDING.POSITION_DETAIL

Interest_purchased

124 – Unit Avg Cost Local

Optional

DEC

Position average unit cost local

HOLDING.POSITION_COST_DETAIL

Local_gaap_unit_cost

125 – Unit Avg Cost Base

Optional

DEC

Position average unit cost base

HOLDING.POSITION_COST_DETAIL

Gaap_unit_cost

9278 – Cost Local (Current Cost)

Optional

MONEYL

The current position cost local

HOLDING.POSITION_COST_DETAIL

Local_gaap_cost_value

9277 – Cost Base (Current Cost).

Optional

MONEYB

The current position base

HOLDING.POSITION_COST_DETAIL

Gaap_cost_value

163 – Current Quantity

Optional

DEC

The current position quantity

HOLDING.POSITION_DETAIL

Share_par_value

274 – Settled Quantity

Optional

DEC

Total position contractually settled quantity as of the requested effective date

HOLDING.POSITION_DETAIL

Settle_quantity

465 – Accrued Income PTD Local

Optional

MONEYL

A rollup of the open lot total purchased accrued interest. This value reflects the accrual provided at the time of the opening trade.

HOLDING.POSITION_DETAIL

Interest_earned

475 – Accrued Interest TRD Base

Optional

MONEYB

A rollup of the open lot total purchased accrued interest. This value reflects the accrual provided at the time of the opening trade.

HOLDING.POSITION_DETAIL

Security_income

479 – Settle Amount Base

Optional

MONEYB

Base cost of the settled cash balance for a given cash position. This is populated only for cash balance records.

HOLDING.POSITION_DETAIL

Settlement_date_position_cost

481 – Market Price

Optional

NUMBER (28,12)

Market price of the asset

HOLDING.POSITION_DETAIL

Price

482 – Effective Date of Price

Optional

DATE

Effective date of the market price of the asset

HOLDING.POSITION_DETAIL

Price_date

484 – FX Rates from FX Rates table

Optional

DEC

FX Rates between the asset and the entity base currency.

HOLDING.POSITION_DETAIL

Mkt_exchange_rate

485 – Effective Date of FX Rates

Optional

DATE

Effective date of the FX Rates between the asset and entity base currency

HOLDING.POSITION_DETAIL

Exchange_rate_date

575 – OID Income LTD Local

Optional

MONEYL

Calculated life-to-date OID income in local currency

HOLDING.POSITION_COST_DETAIL

Oid_ltd_income_local

580 – Amortization Ltd Local

Optional

MONEYL

Total amortization life-to-date for the position. This is the calculated amortization in local currency.

HOLDING.POSITION_COST_DETAIL

Amort_ltd_local

588 – Accrued Income PTD Base

Optional

MONEYB

Total period-to-date accrual base. This value reflects the calculated accrual from either the settlement date of all the open lots rolled up or the base cost of the total accrual from the last coupon date.

HOLDING.POSITION_DETAIL

Interest_earned_base

590 – LTD OID Income Base

Optional

MONEYB

Calculated life-to-date OID income in base currency.

HOLDING.POSITION_COST_DETAIL

Oid_ltd_income

595 – Amortization Ltd Base

Optional

MONEYB

Total amortization life-to-date for the position. This is the calculated amortization in base currency.

HOLDING.POSITION_COST_DETAIL

Amort_ltd_base

4440 – LTD TIPS Income Local

Optional

MONEYL

STAR calculated life-to-date TIPS income in local currency

HOLDING.POSITION_DETAIL

Tip_ltd_income_local

4445 – LTD TIPS Income Base

Optional

MONEYB

Life-to-date TIPS income in base currency

HOLDING.POSITION_DETAIL

Tip_ltd_income

4483 – TIPS Current Index

Optional

DEC

Current index of the TIPS security

HOLDING.POSITION_DETAIL

Indx_weight

10044 – Settle Amount Local

Optional

CHAR

Settled cash balance local for a given cash position. This is populated only for cash balance records.

HOLDING.POSITION_DETAIL

Settlement_date_position_local

8952 – Sold Interest Local

Optional

MONEYL

Aggregate sold interest from all the close trades

HOLDING.POSITION_DETAIL

Interest_sold

8953 – Sold Interest Base

Optional

MONEYB

Base equivalent of the sold interest local

HOLDING.POSITION_DETAIL

Interest_sold_base

718 – Total Accrued Income PTD Local

Optional

MONEYL

Total period-to-date accrued income local of the position for the given effective date

HOLDING.POSITION_DETAIL

Accrued_income_local

487 – Local Market Value

Optional

MONEYL

Local market value of the position for the given effective date

HOLDING.POSITION_DETAIL

Local_market_value

488 – Base Market Value

Optional

MONEYB

Base market value of the position for the given effective date

HOLDING.POSITION_DETAIL

Market_value

489 – Total Unrealized Gain Loss Local

Optional

MONEYL

Unrealized gain/loss security local – the local market value less book cost local (cost and amortization (including TIPS income)).

HOLDING.POSITION_DETAIL

Local_unrealized_gl

491 – Unrealized Security Gain Loss Base

Optional

MONEYB

Security unrealized gain/loss base of the position

HOLDING.POSITION_DETAIL

Unrealized_sec_gl

492 – Total Unrealized Gain Loss Base

Optional

MONEYB

Unrealized gain/loss security base – the base market value less base book cost (cost and amortization (including TIPS income)).

HOLDING.POSITION_DETAIL

Base_unrealized_gl

493 – Unrealized Currency Gain Loss Base

Optional

MONEYB

Currency unrealized gain/loss base of the position.

HOLDING.POSITION_DETAIL

Unrealized_curr_gl

726 – Total Accrued Income PTD base

Optional

MONEYB

Total period-to-date accrued income base of the position for the given effective date. (Interest_earned + Interest_purchased – Interest_sold) / mkt_exchange_rate

HOLDING.POSITION_DETAIL

Accrued_income

1106 – Update Date

Optional

DATE

This field is populated with the time stamp for when the record was inserted into the PACE table.

HOLDING.POSITION HOLDING.POSITION_DETAIL

Update_date

4601 – Amortized Cost Local

Optional

MONEYL

Book cost local – the total of the current local cost + ltd amortization local + ltd TIPS income local and ltd OID income local.

HOLDING.POSITION_DETAIL

Book_value_local

4602 – Amortized Cost Base

Optional

MONEYB

Book cost base – the total of the current base cost + ltd amortization base + ltd TIPS income base and ltd OID income.

HOLDING.POSITION_DETAIL

Book_value

9424 – Market Value Income Local

Optional

MONEYL

Local market value + the total period-to-date accrued income local + all local income receivables for the position.

HOLDING.POSITION_DETAIL

Market_value_income_local

9426 – Market Value Income Base

Optional

MONEYB

Base market value + the total period-to-date accrued income base + all base income receivables for the position.

HOLDING.POSITION_DETAIL

Market_value_income

9498 – Dividend Receivable Local

Optional

MONEYL

Traded cash attributed to dividend income for a given security

HOLDING.POSITION_DETAIL

Dividend_receivable_local

9499 – Dividend Receivable

Optional

MONEYB

Traded cash attributed to dividend income for a given security

HOLDING.POSITION_DETAIL

Dividend_receivable

9500 – Coupon Receivable Local

Optional

MONEYL

Traded cash attributed to coupon income for a given security

HOLDING.POSITION_DETAIL

Coupon_receivable_local

9501 – Coupon Receivable

Optional

MONEYB

Traded cash attributed to coupon income for a given security

HOLDING.POSITION_DETAIL

Coupon_receivable

9502 – Reclaim Receivable Local

Optional

MONEYL

Traded cash attributed to reclaim income for a given security

HOLDING.POSITION_DETAIL

Reclaim_receivable_local

9503 – Reclaim Receivable

Optional

MONEYB

Traded cash attributed to reclaim income for a given security

HOLDING.POSITION_DETAIL

Reclaim_receivable

10767 – Misc Income Receivable Local

Optional

CHAR

Traded cash attributed to any income not captured in the other income fields for a given security

HOLDING.POSITION_DETAIL

Misc_inc_receivable_local

10768 – Misc Income Receivable

Optional

CHAR

Traded cash attributed to any income not captured in the other income fields for a given security

HOLDING.POSITION_DETAIL

Misc_inc_receivable

10043 – Settled date position base

Optional

CHAR

Field with the settled cash balance (base market value) for a given cash position accounting date

HOLDING.POSITION_DETAIL

Settlement_date_position

10791 – Notional Cost Local

Optional

CHAR

Notional cost local of the future position for the given effective date

HOLDING.POSITION_DETAIL

Notional_cost_local

10792 – Notional Cost Base

Optional

CHAR

Notional cost base of the future position for the given effective date

HOLDING.POSITION_DETAIL

Notional_cost

10793 – Notional Market Value Local

Optional

CHAR

Notional market value local of the future position for the given effective date

HOLDING.POSITION_DETAIL

Notional_market_value_local

10794 – Notional Market Value Base

Optional

CHAR

Notional market value base of the future position for the given effective date

HOLDING.POSITION_DETAIL

Notional_market_value

10795 – Notional Unrealized Gain/Loss Local

Optional

CHAR

Notional_market_value_local – Notional_cost_local

HOLDING.POSITION_DETAIL

Notional_local_unrealized_gl

10796 – Notional Unrealized Gain/Loss Base – Total

Optional

CHAR

Notional_market_value – Notional_cost

HOLDING.POSITION_DETAIL

Notional_unrealized_gl

10797 – Notional Unrealized Gain/Loss Base – Currency

Optional

CHAR

Notional_unrealized_gl – Notional_Unrealized_security_gl

HOLDING.POSITION_DETAIL

Notional_unrealized_curr_gl

10798 – Notional Unrealized Gain/Loss Base – Security

Optional

CHAR

Notional_local_unrealized_gl / Mkt_exchange_rate

HOLDING.POSITION_DETAIL

Notional_unrealized_sec_gl

11044 – Settled Unit Cost Local

Optional

VARCHAR2 (255)

HOLDING.POSITION_COST_DETAIL

settled_local_gaap_unit_cost

11045 – Settled Unit Cost Base

Optional

VARCHAR2 (255)

HOLDING.POSITION_COST_DETAIL

settled_gaap_unit_cost

11046 – Settled Cost Local

Optional

VARCHAR2 (255)

HOLDING.POSITION_COST_DETAIL

settled_local_gaap_cost_value

11047 – Settled Cost Base

Optional

VARCHAR2 (255)

HOLDING.POSITION_COST_DETAIL

settled_gaap_cost_value

11048 – Settled Market Value Local

Optional

VARCHAR2 (255)

HOLDING.POSITION_DETAIL

settled_local_market_value

11049 – Settled Market Value Base

Optional

VARCHAR2 (255)

HOLDING.POSITION_DETAIL

settled_market_value

11050 – Settled Urgl Sec Local

Optional

CHAR (4)

HOLDING.POSITION_DETAIL

settled_local_sec_urgl

11051 – Settled Urgl Sec Base

Optional

CHAR (4)

HOLDING.POSITION_DETAIL

settled_base_sec_urgl

11052 – Settled Urgl Currency Base

Optional

CHAR (4)

HOLDING.POSITION_DETAIL

settled_base_currency_urgl

11053 – Settled Urgl Total Base

Optional

CHAR (4)

HOLDING.POSITION_DETAIL

settled_base_total_urgl

944 – Update Source

Optional

VARCHAR2 (8)

HOLDING.POSITION/POSITION_DETAIL

update_source

9985 – Perform Flag

Optional

CHAR

HOLDING.POSITION

perform_flag

11668 – User_Group1

Optional

CHAR (50)

HOLDING.POSITION_DETAIL

user_group1

11669 – User_Group2

Optional

CHAR (50)

HOLDING.POSITION_DETAIL

user_group2

11728 – System Currency

Optional

VARCHAR2 (30)

HOLDING.POSITION_DETAIL

sys_currency

11729 – System Currency Exchange Rate

Optional

VARCHAR2 (30)

HOLDING.POSITION_DETAIL

sys_curr_fx_rate

11730 – System Currency Exchange Rate Date

Optional

VARCHAR2 (255)

HOLDING.POSITION_DETAIL

sys_curr_fx_rate_date

11731 – System Currency Accrued Income

Optional

VARCHAR2 (255)

HOLDING.POSITION_DETAIL

accrued_income_sys

11732 – System Currency Market Value

Optional

VARCHAR2 (255)

HOLDING.POSITION_DETAIL

market_value_sys

11733 – System Currency Dividend Receivable

Optional

VARCHAR2 (255)

HOLDING.POSITION_DETAIL

dividend_receivable_sys

11734 – System Currency Coupon Receivable

Optional

VARCHAR2 (255)

HOLDING.POSITION_DETAIL

coupon_receivable_sys

11735 – System Currency Reclaim Receiavble

Optional

VARCHAR2 (255)

HOLDING.POSITION_DETAIL

reclaim_receivable_sys

11737 – System Currency Market Value income

Optional

VARCHAR2 (255)

HOLDING.POSITION_DETAIL

market_value_income_sys

11736 – System Currency Misc Income Receivable

Optional

VARCHAR2 (255)

HOLDING.POSITION_DETAIL

misc_income_receivable_sys

869 – Orig Dividend Receivable

Optional

MONEYB

HOLDING.POSITION_DETAIL

orig_dividend_receivable

875 – Orig Coupon Receivable

Optional

MONEYB

HOLDING.POSITION_DETAIL

orig_coupon_receivable

876 – Orig Reclaim Receivable

Optional

MONEYB

HOLDING.POSITION_DETAIL

orig_reclaim_receivable

877 – Orig Misc Inc Receivable

Optional

MONEYB

HOLDING.POSITION_DETAIL

orig_misc_inc_receivable

9828 – User_Defined_Float1

Optional

DEC

User defined field

HOLDING.POSITION_DETAIL

user_float1

9829 – User_Defined_Float2

Optional

DEC

User defined field

HOLDING.POSITION_DETAIL

user_float2

1320 – User Defined Date1

Optional

DATE

User defined field

HOLDING.POSITION_DETAIL

user_date1

1321 – User Defined Date2

Optional

DATE

User defined field

HOLDING.POSITION_DETAIL

user_date2

11668 – User Defined Group1

Optional

CHAR (50)

User defined field

POSITION_DETAIL

user_group1

11669 – User Defined Group2

Optional

CHAR (50)

User defined field

POSITION_DETAIL

user_group2

16439 – User PDA Character 12