PACE Performance Data Map and PACE Derived Fields

PACE Performance Data Map

The following table describes the fields in the PACE Performance data map for Total, Segment, and Constituent Level Performance.

Field #	Header Row	Processing Logic	PACE DB	PACE Table	PACE Column	Req
1	BATCH_ID	Batch ID will be made up of ENTITY_ID^XREF TYPE (if required, leave blank if not)^END EFFECTIVE DATE^SOURCE NAME^FREQUENCY CODE^PERF MODEL^LEVEL TYPE. Please see batch Key logic section above for resolution details.				Y
2	Status Flag	Preliminary or Final (Values "F" or "P")	Perform	perf_summary	frequency_code	Y
3	Update Source	Text to define update source	Perform	perf_summary	update_source	Y
4	Begin Date	Not required, if not provide will be derived based on Frequency Code + End_effective_date provided. (EG: if 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 dictionary item id resolution section above	Rules	dictionary_detail	dict_l2_code_value	N
6	Dict_level3	refer to dictionary item id resolution section above	Rules	dictionary_detail	dict_l3_code_value	N
7	Dict_level4	refer to dictionary item id resolution section above	Rules	dictionary_detail	dict_l4_code_value	N
8	Dict_level5	refer to dictionary item id resolution section above	Rules	dictionary_detail	dict_l5_code_value	N
9	Dict_level6	refer to dictionary item id resolution section above	Rules	dictionary_detail	dict_l6_code_value	N
10	Dict_level7	refer to dictionary item id resolution section above	Rules	dictionary_detail	dict_l7_code_value	N
11	Dict_level8	refer to dictionary item id resolution section above	Rules	dictionary_detail	dict_l8_code_value	N
12	Sec_ID1	Security Id to be used in securitydbo.xreference resolution in combination with sec_id_type. Refer to security alias resolution section above	Perform	Perf_Sec_Return Perf_sec_rollup_relation Perf_sec_universe	Security_alias Security_alias	N
13	Sec_ID1_TYPE	Sec ID type to be used in combination with sec ID to resolve security alias	N/A	N/A	N/A	N
14	Sec_ID2	Security Id to be used in securitydbo.xreference resolution in combination with sec_id_type. Refer to security alias resolution section above	Perform	Perf_Sec_Return Perf_sec_rollup_relation Perf_sec_universe	Security_alias Security_alias Security_alias	N
15	Sec_ID2_TYPE	Sec ID type to be used in combination with sec ID to resolve security alias	N/A	N/A	N/A	N
16	Sec_ID3	Security Id to be used in securitydbo.xreference resolution in combination with sec_id_type. Refer to security alias resolution section above	Perform	Perf_Sec_Return Perf_sec_rollup_relation Perf_sec_universe	Security_alias Security_alias Security_alias	N
17	Sec_ID3_TYPE	Sec ID type to be used in combination with sec ID to resolve security alias	N/A	N/A	N/A	N
18	Sec_ID4	Security Id to be used in securitydbo.xreference resolution in combination with sec_id_type. Refer to security alias resolution section above	Perform	Perf_Sec_Return Perf_sec_rollup_relation Perf_sec_universe	Security_alias Security_alias Security_alias	N
19	Sec_ID4_TYPE	Sec ID type to be used in combination with sec ID to resolve security alias	N/A	N/A	N/A	N
20	Sec_ID5	Security Id to be used in securitydbo.xreference resolution in combination with sec_id_type. Refer to security alias resolution section above	Perform	Perf_Sec_Return Perf_sec_rollup_relation Perf_sec_universe	Security_alias Security_alias Security_alias	N
21	Sec_ID5_TYPE	Sec ID type to be 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

PACE Derived Fields

The following table describes PACE derived fields for Total, Segment, and Constituent Level Performance.

Derived Field	Description	Notes	PACE Database	PACE Table(s)	PACE Field
Update Date	Update Date	The procedure will populate the current system date in update_date. The update_date in perf_summary and Perf_Sec_Returns should always be the same, even when there is no change to the perf_summary record directly.	Perform	Perf_summary/ Perf_Sec_Returns	Update_date
Dictionary Id	Dictionary Id	Refer "Dictionary ID Resolution Logic"	Perform	Perf_Summary	Dictionary_id
Begin Effective Date	Begin Effective Date	The Begin effective date is derived from the end effective date. For example June 2004 would have a begin effective date of 06/01/2004.	Perform	Perf_Summary	Begin_Effective_date
LEVEL TYPE	Level Type	Refer to BATCH ID position #7	Perform	Perf_summary	Level_type
PERF SEC ROLLUP RELATION INSTANCE	Instance Number	Refer to Perf Sec Rollup Relation Instance Logic	Perform	Perf_sec_rollup_relation	Instance
PERF SEC UNIVERSE INSTANCE	Instance Number	Refer to Perf Sec Universe Instance Logic	Perform	Perf_sec_universe	Instance