Warehouse Performance (Pipe Delimited) Example - All Elements

Owned by Natalie Gesin (Deactivated)
Last updated: Nov 07, 2024 by Kinga Huszno
1 min read

Pipe-delimited messages are loaded without header elements.

Node Map

BATCH_ID|Status Flag|Update Source|Begin Date|Dict_level2|Dict_level3|Dict_level4|Dict_level5|Dict_level6|Dict_level7|Dict_level8|Sec_ID1|Sec_ID1_TYPE|Sec_ID2|Sec_ID2_TYPE|Sec_ID3|Sec_ID3_TYPE|Sec_ID4|Sec_ID4_TYPE|Sec_ID5|Sec_ID5_TYPE|Security_Alias|psr_user_float1| psr_user_float2|psr_user_float3|psr_user_float4|psr_user_float5|psr_user_float6|psr_user_float7|psr_user_float8|psr_user_float9|psr_user_float10|psr_user_float11|psr_user_float12|psr_user_float13|psr_user_float14|psr_user_float15| psr_user_float16|psr_user_float17|psr_user_float18|psr_user_float19|psr_user_float20|psr_user_float21|psr_user_float22|psr_user_float23|psr_user_float24|psr_user_float25|psr_user_float26|psr_user_float27|psr_user_float28| psr_user_float29|psr_user_float30|psr_user_float31|psr_user_float32|psr_user_float33|psr_user_float34|psr_user_float35|psr_user_float36|psr_user_float37|psr_user_float38|psr_user_float39|psr_user_float40|psr_user_float41| psr_user_float42|psr_user_float43|psr_user_float44|psr_user_float45|psr_user_float46|psr_user_float47|psr_user_float48|psr_user_float49|psr_user_float50|psr_user_float51|psr_user_float52|psr_user_float53|psr_user_float54| psr_user_float55|psr_user_float56|psr_user_float57|psr_user_float58|psr_user_float59|psr_user_float60|psr_user_float61|psr_user_float62|psr_user_float63|psr_user_float64|psr_user_float65|psr_user_float66|psr_user_char1| psr_user_char2|psr_user_char3|psr_user_char4|psr_user_char5|psr_user_date1|psr_user_date2|psr_user_date3|psr_user_int1|abal|accrued_income|after_tax_return|before_tax_return|currency|currency_code|daily_wtd_adj|dva|earned_income| fee_handling|fee_status|fees|field_attribute_id|flow_weighting|inc_adj_net|inc_adj_wtd|irr_return|irr_return_net|itd_after_tax_return|itd_before_tax_return|itd_irr_return|itd_irr_return_net|itd_mod_dietz_return| itd_mod_dietz_return_net|itd_prin_return|itd_tot_return|itd_tot_return_net|market_value|mod_dietz_return|mod_dietz_return_net|mtd_after_tax_return|mtd_before_tax_return|mtd_irr_return|mtd_irr_return_net|mtd_mod_dietz_return| mtd_mod_dietz_return_net|mtd_prin_return|mtd_tot_return|mtd_tot_return_net|net_adj_amt|prin_return|qtd_after_tax_return|qtd_before_tax_return|qtd_irr_return|qtd_irr_return_net|qtd_mod_dietz_return|qtd_mod_dietz_return_net| qtd_prin_return|qtd_tot_return|qtd_tot_return_net|record_type|return_type|tax_status|tot_return|tot_return_net|total_flows|unit_value_liq_prin|unit_value_liq_tot|unit_value_prin|unit_value_real_prin|unit_value_real_tot| unit_value_tot|ytd_after_tax_return|ytd_before_tax_return|ytd_irr_return|ytd_irr_return_net|ytd_mod_dietz_return|ytd_mod_dietz_return_net|ytd_prin_return|ytd_tot_return|ytd_tot_return_net

Examples - All Elements

KADE11^^20150604^EAGLE PACE^D^TestAl^P|P|KKUDRYASHOV|20150602|||||||||||||||||||1.11|2.11|3.11|4.11|5.11|6.11|7.11|8.11|9.11|10.11|11.11|12.11|13.11|14.11|15.11|16.11|17.11|18.11|19.11|20.11|21.11|22.11|23.11|24.11|25.11|26.11|27.11|28.11|29.11|30.11|31.11|32.11|33.11|34.11|35.11|36.11|37.11|38.11|39.11|40.11|41.11|42.11|43.11|44.11|45.11|46.11|47.11|48.11|49.11|50.11|51.11|52.11|53.11|54.11|55.11|56.11|57.11|58.11|59.11|60.11|61.11|62.11|63.11|64.11|65.11|66.11|char1|char2|char3|char4|char5|20140106|20140107|20140108|123|67.11|68.11|69.11|70.11|170|171|71.11|72.11|73.11|FeeH|74.11|75.11|76.11|77.11|78.11|79.11|80.11|81.11|82.11|83.11|84.11|85.11|86.11|87.11|88.11|89.11|90.11|91.11|92.11|93.11|94.11|95.11|96.11|97.11|98.11|99.11|100.11|101.11|102.11|103.11|104.11|105.11|106.11|107.11|108.11|109.11|110.11|111.11|112.11|113.11|RT|114.11|115.11|116.11|117.11|118.11|119.11|120.11|121.11|122.11|123.11|124.11|125.11|126.11|127.11|128.11|129.11|130.11|131.11|132.11|133.3
KADE11^^20150604^EAGLE PACE^D^TestAl^S|P|KKUDRYASHOV|20150602||||||||US0343931087|ISIN|034393108|CUSIP|USD|TICKER|2579746|SEDOL|FF000D509EB|BBID|381270|1.11|2.11|3.11|4.11|5.11|6.11|7.11|8.11|9.11|10.11|11.11|12.11|13.11|14.11|15.11|16.11|17.11|18.11|19.11|20.11|21.11|22.11|23.11|24.11|25.11|26.11|27.11|28.11|29.11|30.11|31.11|32.11|33.11|34.11|35.11|36.11|37.11|38.11|39.11|40.11|41.11|42.11|43.11|44.11|45.11|46.11|47.11|48.11|49.11|50.11|51.11|52.11|53.11|54.11|55.11|56.11|57.11|58.11|59.11|60.11|61.11|62.11|63.11|64.11|65.11|66.11|char1|char2|char3|char4|char5|20140106|20140107|20140108|123|67.11|68.11|69.11|70.11|170|171|71.11|72.11|73.11|FeeH|74.11|75.11|76.11|77.11|78.11|79.11|80.11|81.11|82.11|83.11|84.11|85.11|86.11|87.11|88.11|89.11|90.11|91.11|92.11|93.11|94.11|95.11|96.11|97.11|98.11|99.11|100.11|101.11|102.11|103.11|104.11|105.11|106.11|107.11|108.11|109.11|110.11|111.11|112.11|113.11|RT|114.11|115.11|116.11|117.11|118.11|119.11|120.11|121.11|122.11|123.11|124.11|125.11|126.11|127.11|128.11|129

Other Examples

Â