Page Comparison

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

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