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.

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 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

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

Â