Page Comparison

Anchor

	top
	top

This section describes the fields in the PACE Performance data map as well as the PACE derived fields for Total, Segment, and Constituent Level Performance.

Background Color

color	#E0F0FF

Table of Contents

maxLevel	2
printable	false

PACE Performance Data Map

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

On this page

Table of Contents

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

back to top

Versions Compared

Old Version 3

New Version Current

Key

PACE Performance Data Map

PACE Derived Fields