PACE Performance Data Map and PACE Derived Fields
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.
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
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/ | 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 |
Â