Warehouse Performance (Pipe Delimited) Data Map Table

Field #	Header Row	Processing Logic	PACE DB	PACE Table	PACE Column	Req

Field #	Header Row	Processing Logic	PACE DB	PACE Table	PACE Column	Req
1	BATCH_ID	Batch ID is made up of ENTITY_ID^XREF TYPE(if required, leave blank if you do not need it)^END EFFECTIVE DATE^SOURCE NAME^FREQUENCY CODE^PERF MODEL^LEVEL TYPE. Please see batch Key logic section for resolution details				Y
2	Status Flag	Preliminary or Final (Values "F" or "P")	Perform	perf_summary	frequency_code	Y
3	Update Source	The text to define update source	Perform	perf_summary	update_source	Y
4	Begin Date	Not required. It will be derived based on Frequency Code + End_effective_date, if not provided. (EG: if the record is Daily and End Date is 1/31/15, then Begin Date will be derived as 1/30/15)	Perform	perf_summary	begin_effective_date	N
5	Dict_level2	refer to the dictionary item Id resolution section	Rules	dictionary_detail	dict_l2_code_value	N
6	Dict_level3				dict_l3_code_value
7	Dict_level4				dict_l4_code_value
8	Dict_level5				dict_l5_code_value
9	Dict_level6				dict_l6_code_value
10	Dict_level7				dict_l7_code_value
11	Dict_level8				dict_l8_code_value
12	Sec_ID1	Security Id is used in securitydbo.xreference resolution in combination with sec_id_type. Refer to the security alias resolution section	Perform	Perf_Sec_ReturnPerf_sec_rollup_relationPerf_sec_universe	Security_aliasSecurity_aliasSecurity_alias	N
13	Sec_ID1_TYPE	Sec ID type is used in combination with sec ID to resolve security alias	N/A	N/A	N/A	N
14	Sec_ID2	Security Id is used in securitydbo.xreference resolution in combination with sec_id_type. Refer to the security alias resolution section	Perform	Perf_Sec_ReturnPerf_sec_rollup_relationPerf_sec_universe	Security_aliasSecurity_aliasSecurity_alias	N
15	Sec_ID2_TYPE	Sec ID type is used in combination with sec ID to resolve security alias	N/A	N/A	N/A	N
16	Sec_ID3	Security Id is used in securitydbo.xreference resolution in combination with sec_id_type. Refer to the security alias resolution section	Perform	Perf_Sec_ReturnPerf_sec_rollup_relationPerf_sec_universe	Security_aliasSecurity_aliasSecurity_alias	N
17	Sec_ID3_TYPE	Sec ID type is used in combination with sec ID to resolve security alias	N/A	N/A	N/A	N
18	Sec_ID4	Security Id is used in securitydbo.xreference resolution in combination with sec_id_type. Refer to the security alias resolution section	Perform	Perf_Sec_ReturnPerf_sec_rollup_relationPerf_sec_universe	Security_aliasSecurity_aliasSecurity_alias	N
19	Sec_ID4_TYPE	Sec ID type to be used in combination with sec ID to resolvr security alias	N/A	N/A	N/A	N
20	Sec_ID5	Security Id is used in securitydbo.xreference resolution in combination with sec_id_type. Refer to the security alias resolution section	Perform	Perf_Sec_ReturnPerf_sec_rollup_relationPerf_sec_universe	Security_aliasSecurity_aliasSecurity_alias	N
21	Sec_ID5_TYPE	Sec ID type is used in combination with sec ID to resolve security alias	N/A	N/A	N/A	N
22	Security_Alias		N/A	N/A	N/A	N
23	psr_user_float1		Perform	perf_sec_returns	psr_user_float1	N
24	psr_user_float2		Perform	perf_sec_returns	psr_user_float2	N
25	psr_user_float3		Perform	perf_sec_returns	psr_user_float3	N
26	psr_user_float4		Perform	perf_sec_returns	psr_user_float4	N
27	psr_user_float5		Perform	perf_sec_returns	psr_user_float5	N
28	psr_user_float6		Perform	perf_sec_returns	psr_user_float6	N
29	psr_user_float7		Perform	perf_sec_returns	psr_user_float7	N
30	psr_user_float8		Perform	perf_sec_returns	psr_user_float8	N
31	psr_user_float9		Perform	perf_sec_returns	psr_user_float9	N
32	psr_user_float10		Perform	perf_sec_returns	psr_user_float10	N
33	psr_user_float11		Perform	perf_sec_returns	psr_user_float11	N
34	psr_user_float12		Perform	perf_sec_returns	psr_user_float12	N
35	psr_user_float13		Perform	perf_sec_returns	psr_user_float13	N
36	psr_user_float14		Perform	perf_sec_returns	psr_user_float14	N
37	psr_user_float15		Perform	perf_sec_returns	psr_user_float15	N
38	psr_user_float16		Perform	perf_sec_returns	psr_user_float16	N
39	psr_user_float17		Perform	perf_sec_returns	psr_user_float17	N
40	psr_user_float18		Perform	perf_sec_returns	psr_user_float18	N
41	psr_user_float19		Perform	perf_sec_returns	psr_user_float19	N
42	psr_user_float20		Perform	perf_sec_returns	psr_user_float20	N
43	psr_user_float21		Perform	perf_sec_returns	psr_user_float21	N
44	psr_user_float22		Perform	perf_sec_returns	psr_user_float22	N
45	psr_user_float23		Perform	perf_sec_returns	psr_user_float23	N
46	psr_user_float24		Perform	perf_sec_returns	psr_user_float24	N
47	psr_user_float25		Perform	perf_sec_returns	psr_user_float25	N
48	psr_user_float26		Perform	perf_sec_returns	psr_user_float26	N
49	psr_user_float27		Perform	perf_sec_returns	psr_user_float27	N
50	psr_user_float28		Perform	perf_sec_returns	psr_user_float28	N
51	psr_user_float29		Perform	perf_sec_returns	psr_user_float29	N
52	psr_user_float30		Perform	perf_sec_returns	psr_user_float30	N
53	psr_user_float31		Perform	perf_sec_returns	psr_user_float31	N
54	psr_user_float32		Perform	perf_sec_returns	psr_user_float32	N
55	psr_user_float33		Perform	perf_sec_returns	psr_user_float33	N
56	psr_user_float34		Perform	perf_sec_returns	psr_user_float34	N
57	psr_user_float35		Perform	perf_sec_returns	psr_user_float35	N
58	psr_user_float36		Perform	perf_sec_returns	psr_user_float36	N
59	psr_user_float37		Perform	perf_sec_returns	psr_user_float37	N
60	psr_user_float38		Perform	perf_sec_returns	psr_user_float38	N
61	psr_user_float39		Perform	perf_sec_returns	psr_user_float39	N
62	psr_user_float40		Perform	perf_sec_returns	psr_user_float40	N
63	psr_user_float41		Perform	perf_sec_returns	psr_user_float41	N
64	psr_user_float42		Perform	perf_sec_returns	psr_user_float42	N
65	psr_user_float43		Perform	perf_sec_returns	psr_user_float43	N
66	psr_user_float44		Perform	perf_sec_returns	psr_user_float44	N
67	psr_user_float45		Perform	perf_sec_returns	psr_user_float45	N
68	psr_user_float46		Perform	perf_sec_returns	psr_user_float46	N
69	psr_user_float47		Perform	perf_sec_returns	psr_user_float47	N
70	psr_user_float48		Perform	perf_sec_returns	psr_user_float48	N
71	psr_user_float49		Perform	perf_sec_returns	psr_user_float49	N
72	psr_user_float50		Perform	perf_sec_returns	psr_user_float50	N
73	psr_user_float51		Perform	perf_sec_returns	psr_user_float51	N
74	psr_user_float52		Perform	perf_sec_returns	psr_user_float52	N
75	psr_user_float53		Perform	perf_sec_returns	psr_user_float53	N
76	psr_user_float54		Perform	perf_sec_returns	psr_user_float54	N
77	psr_user_float55		Perform	perf_sec_returns	psr_user_float55	N
78	psr_user_float56		Perform	perf_sec_returns	psr_user_float56	N
79	psr_user_float57		Perform	perf_sec_returns	psr_user_float57	N
80	psr_user_float58		Perform	perf_sec_returns	psr_user_float58	N
81	psr_user_float59		Perform	perf_sec_returns	psr_user_float59	N
82	psr_user_float60		Perform	perf_sec_returns	psr_user_float60	N
83	psr_user_float61		Perform	perf_sec_returns	psr_user_float61	N
84	psr_user_float62		Perform	perf_sec_returns	psr_user_float62	N
85	psr_user_float63		Perform	perf_sec_returns	psr_user_float63	N
86	psr_user_float64		Perform	perf_sec_returns	psr_user_float64	N
87	psr_user_float65		Perform	perf_sec_returns	psr_user_float65	N
88	psr_user_float66		Perform	perf_sec_returns	psr_user_float66	N
89	psr_user_char1		Perform	perf_sec_returns	psr_user_char1	N
90	psr_user_char2		Perform	perf_sec_returns	psr_user_char2	N
91	psr_user_char3		Perform	perf_sec_returns	psr_user_char3	N
92	psr_user_char4		Perform	perf_sec_returns	psr_user_char4	N
93	psr_user_char5		Perform	perf_sec_returns	psr_user_char5	N
94	psr_user_date1		Perform	perf_sec_returns	psr_user_date1	N
95	psr_user_date2		Perform	perf_sec_returns	psr_user_date2	N
96	psr_user_date3		Perform	perf_sec_returns	psr_user_date3	N
97	psr_user_int1		Perform	perf_sec_returns	psr_user_int1	N
98	abal		Perform	perf_sec_returns	abal	N
99	accrued_income		Perform	perf_sec_returns	accrued_income	N
100	after_tax_return		Perform	perf_sec_returns	after_tax_return	N
101	before_tax_return		Perform	perf_sec_returns	before_tax_return	N
102	currency		Perform	perf_sec_returns	currency	N
103	currency_code		Perform	perf_sec_returns	currency_code	N
104	daily_wtd_adj		Perform	perf_sec_returns	daily_wtd_adj	N
105	dva		Perform	perf_sec_returns	dva	N
106	earned_income		Perform	perf_sec_returns	earned_income	N
107	fee_handling		Perform	perf_sec_returns	fee_handling	N
108	fee_status		Perform	perf_sec_returns	fee_status	N
109	fees		Perform	perf_sec_returns	fees	N
110	field_attribute_id		Perform	perf_sec_returns	field_attribute_id	N
111	flow_weighting		Perform	perf_sec_returns	flow_weighting	N
112	inc_adj_net		Perform	perf_sec_returns	inc_adj_net	N
113	inc_adj_wtd		Perform	perf_sec_returns	inc_adj_wtd	N
114	irr_return		Perform	perf_sec_returns	irr_return	N
115	irr_return_net		Perform	perf_sec_returns	irr_return_net	N
116	itd_after_tax_return		Perform	perf_sec_returns	itd_after_tax_return	N
117	itd_before_tax_return		Perform	perf_sec_returns	itd_before_tax_return	N
118	itd_irr_return		Perform	perf_sec_returns	itd_irr_return	N
119	itd_irr_return_net		Perform	perf_sec_returns	itd_irr_return_net	N
120	itd_mod_dietz_return		Perform	perf_sec_returns	itd_mod_dietz_return	N
121	itd_mod_dietz_return_net		Perform	perf_sec_returns	itd_mod_dietz_return_net	N
122	itd_prin_return		Perform	perf_sec_returns	itd_prin_return	N
123	itd_tot_return		Perform	perf_sec_returns	itd_tot_return	N
124	itd_tot_return_net		Perform	perf_sec_returns	itd_tot_return_net	N
125	market_value		Perform	perf_sec_returns	market_value	N
126	mod_dietz_return		Perform	perf_sec_returns	mod_dietz_return	N
127	mod_dietz_return_net		Perform	perf_sec_returns	mod_dietz_return_net	N
128	mtd_after_tax_return		Perform	perf_sec_returns	mtd_after_tax_return	N
129	mtd_before_tax_return		Perform	perf_sec_returns	mtd_before_tax_return	N
130	mtd_irr_return		Perform	perf_sec_returns	mtd_irr_return	N
131	mtd_irr_return_net		Perform	perf_sec_returns	mtd_irr_return_net	N
132	mtd_mod_dietz_return		Perform	perf_sec_returns	mtd_mod_dietz_return	N
133	mtd_mod_dietz_return_net		Perform	perf_sec_returns	mtd_mod_dietz_return_net	N
134	mtd_prin_return		Perform	perf_sec_returns	mtd_prin_return	N
135	mtd_tot_return		Perform	perf_sec_returns	mtd_tot_return	N
136	mtd_tot_return_net		Perform	perf_sec_returns	mtd_tot_return_net	N
137	net_adj_amt		Perform	perf_sec_returns	net_adj_amt	N
138	prin_return		Perform	perf_sec_returns	prin_return	N
139	qtd_after_tax_return		Perform	perf_sec_returns	qtd_after_tax_return	N
140	qtd_before_tax_return		Perform	perf_sec_returns	qtd_before_tax_return	N
141	qtd_irr_return		Perform	perf_sec_returns	qtd_irr_return	N
142	qtd_irr_return_net		Perform	perf_sec_returns	qtd_irr_return_net	N
143	qtd_mod_dietz_return		Perform	perf_sec_returns	qtd_mod_dietz_return	N
144	qtd_mod_dietz_return_net		Perform	perf_sec_returns	qtd_mod_dietz_return_net	N
145	qtd_prin_return		Perform	perf_sec_returns	qtd_prin_return	N
146	qtd_tot_return		Perform	perf_sec_returns	qtd_tot_return	N
147	qtd_tot_return_net		Perform	perf_sec_returns	qtd_tot_return_net	N
148	record_type		Perform	perf_sec_returns	record_type	N
149	return_type		Perform	perf_sec_returns	return_type	N
150	tax_status		Perform	perf_sec_returns	tax_status	N
151	tot_return		Perform	perf_sec_returns	tot_return	N
152	tot_return_net		Perform	perf_sec_returns	tot_return_net	N
153	total_flows		Perform	perf_sec_returns	total_flows	N
154	unit_value_liq_prin		Perform	perf_sec_returns	unit_value_liq_prin	N
155	unit_value_liq_tot		Perform	perf_sec_returns	unit_value_liq_tot	N
156	unit_value_prin		Perform	perf_sec_returns	unit_value_prin	N
157	unit_value_real_prin		Perform	perf_sec_returns	unit_value_real_prin	N
158	unit_value_real_tot		Perform	perf_sec_returns	unit_value_real_tot	N
159	unit_value_tot		Perform	perf_sec_returns	unit_value_tot	N
160	ytd_after_tax_return		Perform	perf_sec_returns	ytd_after_tax_return	N
161	ytd_before_tax_return		Perform	perf_sec_returns	ytd_before_tax_return	N
162	ytd_irr_return		Perform	perf_sec_returns	ytd_irr_return	N
163	ytd_irr_return_net		Perform	perf_sec_returns	ytd_irr_return_net	N
164	ytd_mod_dietz_return		Perform	perf_sec_returns	ytd_mod_dietz_return	N
165	ytd_mod_dietz_return_net		Perform	perf_sec_returns	ytd_mod_dietz_return_net	N
166	ytd_prin_return		Perform	perf_sec_returns	ytd_prin_return	N
167	ytd_tot_return		Perform	perf_sec_returns	ytd_tot_return	N
168	ytd_tot_return_net		Perform	perf_sec_returns	ytd_tot_return_net	N