TABLE OF DATABASE FIELDS back

Following are fields of information available for plans in the database. Any or all fields can be exported into your word-processing, spreadsheet, contact manager or other software by pressing the Export button on the List or Detail screens.

5500 & 5500 C/R Database Fields          

Field

Description of Contents

Width

Type

Index

Information

Field Names

1

Sponsor's federal ID # and plan #

13

Character

Yes

Common field

SEINPNO

2

Plan year end

7

Character

Yes

 

YEAREND

3

Courtesy for first contact

3

Character

 

 

COURTESY

4

First name of first contact

15

Character

 

 

FIRSTNAME

5

Middle initial of first contact

1

Character

 

 

MIDDLEI

6

Last name of first contact

20

Character

 

 

LASTNAME

7

Title or suffix of first contact

15

Character

 

 

TITLE

8

Sponsor's name

35

Character

Yes

 

SNAME1

9

Sponsor's street address

35

Character

Yes

 

SSTREET

10

Sponsor's city

22

Character

Yes

 

SCITY

11

Sponsor's state

2

Character

Yes

 

SSTATE

12

Sponsor's zip code (First 5 digits)

5

Character

Yes

 

ZIPCODE

13

Sponsor's zip + 4

4

Character

 

 

ZIP4

14

Sponsor's delivery point code

3

Character

 

 

DELPTCODE

15

Sponsor's first contact name

40

Character

Yes

 

SSIGNATOR

16

Sponsor's phone number

12

Character

Yes

 

SPHONE

17

Administrator's name

35

Character

Yes

 

ANAME1

18

Administrator's street address

35

Character

 

 

ASTREET

19

Administrator's city

20

Character

 

 

ACITY

20

Administrator's state

2

Character

 

 

ASTATE

21

Adminstrator's zip code (First 5 digits)

5

Character

 

 

AZIP1

22

Administrator contact name

35

Character

 

 

ASIGNATOR

23

Administrator's phone number

12

Character

 

 

APHONE

24

Plan name

35

Character

Yes

 

PNAME1

25

Plan type

25

Character

Yes

See Key List

PBPTYPE

26

Retirement plan type

30

Character

Yes

See Key List

DCPTYPE

27

Welfare benefit plan code

50

Character

Yes

See Key List

WBPTYPE

28

Plan feature codes

50

Character

Yes

See Key List

FEATURES

29

401(k) indicator

3

Character

Yes

Yes/No Indicator

KTYPE401

30

Type of plan entity

1

Character

Yes

See Key List

ENTYTYPE

31

Sponsor's business code

50

Character

Yes

See Bus Code List

BUSCODE

32

Funding and benefit code

35

Character

Yes

See Key List

FUNDCODE

33

Total active participants

8

Numeric

Yes

 

PARTIC

34

Total employees

8

Numeric

Yes

 

TOTEMPLOYS

35

Number of highly compensated indvs.

8

Numeric

 

 

HIGHCOMP

36

Effective date of plan

10

Character

Yes

 

PLANDATE

37

Year plan terminated

4

Character

 

 

YEARTERM

38

Cusip number / stockticker symbol

6

Character

 

 

TICKRCUSIP

39

Labor management number 1

6

Character

Yes

 

LMNUMBER1

40

Labor management number 2

6

Character

Yes

 

LMNUMBER2

41

Labor management number 3

6

Character

Yes

 

LMNUMBER3

42

Distinct record indicator

1

Character

 

 

DISTINCT

43

Count of schedule A's (insurance)

3

Numeric

 

 

SCHEDA

44

Count of schedule C's (service provider info)

2

Numeric

 

 

SCHEDC

45

Type of CPA audit opinion

1

Character

 

See Key List

OPINIONTYP

46

Amount of ESOP dividends paid

13

Numeric

 

 

ESOPDIVS

47

Cash on hand

12

Numeric

 

 

CASH

48

Accounts receivable

12

Numeric

 

 

RECBLES

49

Money market funds

12

Numeric

 

 

MMFUNDS

50

Certificates of deposit

12

Numeric

 

 

CDS

51

U.S. gov't securities

12

Numeric

 

 

GOVTSEC

52

Corporate debt preferred

12

Numeric

 

 

CORPDEBTPF

53

Corporate debt other

12

Numeric

 

 

CORPBEBTOT

54

Corporate stock-preferred

12

Numeric

 

 

PREFSTOCK

55

Corporate stock-common

12

Numeric

 

 

COMMSTOCK

56

Total corporate debt and common stock

12

Numeric

Yes

 

CORPSEC

57

Partnerships and joint ventures

12

Numeric

Yes

 

PARTNRJV

58

Real estate-income producing

12

Numeric

Yes

 

REINCPROD

59

Real estate-non producing

12

Numeric

Yes

 

RENONPROD

60

Real estate - general

12

Numeric

Yes

REEOY

61

Mortgages-residential

12

Numeric

Yes

 

MORTRES

62

Mortgages-commercial

12

Numeric

 

 

MORTCOMM

63

Participant loan-mortgage

12

Numeric

 

 

PARTLNMORT

64

Participant loan-other

12

Numeric

 

 

PARTLNOTHR

65

Participant loan-general

12

Numeric

 

 

PARTLOANS

66

Other loans

12

Numeric

 

 

LOANOTHER

67

Common / collective trust investments

12

Numeric

 

 

COMMCOLLTR

68

Pooled separate accounts

12

Numeric

 

 

POOLSEPACT

69

Master trusts

12

Numeric

 

 

MASTTRST

70

103-12 investment arrangements

12

Numeric

 

 

INVSTARRGE

71

Regulated investment co.

12

Numeric

 

 

REGINVCO

72

Funds in insurance company general acct

12

Numeric

Yes

 

INSACCNT

73

Other investments

12

Numeric

 

 

OTHERINVST

74

Total general investments

12

Numeric

 

 

TOTGNINVST

75

Employer securities

12

Numeric

 

 

EMPSEC

76

Employer property

12

Numeric

 

 

EMPPROP

77

Bldgs & other prop in plan operations

12

Numeric

 

 

BLDGUSED

78

Other assets

12

Numeric

 

 

OTHERASSET

79

Total assets

12

Numeric

Yes

 

TOTASSETS

80

Benefits payable

12

Numeric

 

 

BENEPAYBL

81

Operating expense payable

12

Numeric

 

 

OPERPAYBL

82

Acquisition indebtedness

12

Numeric

 

 

ACQDEBT

83

Other liabilities

12

Numeric

 

 

OTHERLIAB

84

Total liabilities

12

Numeric

 

 

TOTLIAB

85

Net assets

12

Numeric

 

 

NETASSETS

86

Employer contributions

12

Numeric

 

 

CONTEMPLYR

87

Participant contributions

12

Numeric

Yes

 

CONTRPART

88

Other contributions

12

Numeric

 

 

CONTROTHER

89

Non-cash contributions

12

Numeric

 

 

CONTRNCASH

90

Total contributions

12

Numeric

Yes

 

TOTCONTRIB

91

Total interest income

12

Numeric

 

 

EARNINT

92

Total dividend income

12

Numeric

 

 

EARNDIVS

93

Total rents

12

Numeric

 

 

EARNRENTS

94

Investment earnings

12

Numeric

 

 

EARNINVEST

95

Capital gains realized

13

Numeric

 

 

EARNCAPGN

96

Capital gains unrealized

13

Numeric

 

 

EARNCGUN

97

Total other income

13

Numeric

 

 

EARNOTHER

98

Total income

13

Numeric

 

 

TOTINCOME

99

Payments to participants

12

Numeric

 

 

PAYTOPART

100

Payments to insurance carrier

12

Numeric

Yes

 

EXPINSUR

101

Other benefit payments

12

Numeric

 

 

OTHBENPYMT

102

Interest expense

12

Numeric

 

 

INTEXP

103

Admin exp - professional fees

12

Numeric

 

 

EXPPROFFEE

104

Admin exp - salaries & allowances

12

Numeric

 

 

EXPSALARY

105

Admin exp - accounting

12

Numeric

 

 

EXPACCT

106

Admin exp - actuary

12

Numeric

 

 

EXPACTRY

107

Admin exp - contract administrator

12

Numeric

 

 

EXPADMIN

108

Admin exp - investment advisor

12

Numeric

 

 

EXPINVADV

109

Admin exp - legal

12

Numeric

 

 

EXPLEGAL

110

Admin exp - valuation & appraisal

12

Numeric

 

 

EXPVALAPPR

111

Admin exp - trustee

12

Numeric

 

 

EXPTRUSTEE

112

Admin exp - other

12

Numeric

 

 

EXPOTHER

113

Total administration expenses

12

Numeric

 

 

EXPTOTADM

114

Total plan expenses

12

Numeric

 

 

EXPTOTPLN

115

Net income of plan

13

Numeric

 

 

PLANINCOME

             

Schedule A Database Fields          

Field

Description of Contents

Width

Type

Index

Information

Field Names

116

Plan name

50

Character

 

 

PLANNAME

117

Plan type

1

Character

 

 

PLANTYPE

118

Name of insurance carrier

50

Character

Yes

 

INSCARRIER

119

Number of individuals covered by plan

7

Numeric

 

 

INDIVCOVER

120

Beginning of policy year

10

Character

 

 

BEGINYEAR

121

End of policy year

10

Character

 

 

ENDYEAR

122

Name of insurance broker #1

35

Character

Yes

 

BROKER1

123

Address of insurance broker #1

35

Character

 

 

ADDRESS1

124

City of insurance broker #1

22

Character

Yes

 

CITY1

125

State of insurance broker #1

2

Character

Yes

 

STATE

126

Zip code of insurance broker #1

5

Character

 

 

ZIPCODE1

127

Broker #1 commissions

7

Numeric

Yes

 

COMMISS1

128

Broker #1 fees

8

Numeric

Yes

 

FEES1

129

Name of insurance broker #2

35

Character

Yes

 

BROKER2

130

Address of insurance broker #2

35

Character

 

 

ADDRESS2

131

City of insurance broker #2

22

Character

Yes

 

CITY2

132

State of insurance broker #2

2

Character

Yes

 

STATE2

133

Zipcode of insurance broker #2

5

Character

 

 

ZIPCODE2

134

Broker #2 commissions

7

Numeric

Yes

 

COMMISS2

135

Broker #2 fees

8

Numeric

Yes

 

FEES2

136

Total premium paid

9

Numeric

Yes

 

TOTPREMPD

137

Total welfare benefit plan premium

10

Numeric

Yes

 

WBPPREMIUM

             

Schedule B Database Fields          

Field

Description of Contents

Width

Type

Index

Information

Field Names

138

DB plan type indicator

1

Character

 

Sched B Item E

DBPLANIND

139

Actuarial valuation date

10

Character

 

Sched B Line 1a

BLNE1a

140

Current value of assets

13

Numeric

 

Sched B Line 1b1

BLNE1b1

141

Current value of assets as reported on 5500

13

Numeric

 

Sched B Line 2A

BLNE2A

142

Number of retirees

5

Numeric

 

Sched B Line2B1(i)

BLNE2b1i

143

Retirees and beneficiaries vested benefits

13

Numeric

 

Sched B Line2B1(ii)

BLNE2b1ii

144

Retirees and beneficiaries total benefits

13

Numeric

 

Sched B Line2B1(iii)

BLNE2b1iii

145

Number of terminated individuals

5

Numeric

 

Sched B Line2B2(i)

BLNE2b2i

146

Terminated participants vested benefits

13

Numeric

 

Sched B Line2B2(ii)

BLNE2b2ii

147

Terminated participants total benefits

13

Numeric

 

Sched B Line2B2(iii)

BLNE2b2iii

148

Number of active participants

5

Numeric

 

Sched B Line2B3(i)

BLNE2b3i

149

Active participants vested benefits

13

Numeric

 

Sched B Line2B3(ii)

BLNE2b3ii

150

Active participants total benefits

13

Numeric

 

Sched B Line2B3(iii)

BLNE2b3iii

151

Total participants

6

Numeric

 

Sched B Line2B4(i)

BLNE2b4i

152

Total vested benefits

13

Numeric

 

Sched B Line2B4(ii)

BLNE2b4ii

153

Total benefits

13

Numeric

 

Sched B Line2B4(iii)

BLNE2b4iii

154

Ratio of current assets to current liability

4

Numeric

 

Sched B Line 2c

BLNE2c

155

Actuary's enrollment number

4

Character

Yes

 

BENROLLNO

156

Actuary's name

35

Character

Yes

 

ACTNAME

157

Actuary's company

35

Character

Yes

 

ACTFIRM

158

Actuary's address

68

Character

Yes

 

ACTADDRESS

159

Actuary's phone number

12

Character

 

 

ACTPHONE

160

Actuarial cost method used

1

Character

 

Sched B Line 5

BLNE5

161

OBRA 87 CL

13

Numeric

 

Sched B Line 13a

BLNE13A

162

Adjusted value of assets

13

Numeric

 

Sched B Line 13b

BLNE13B

             

Schedule C Database Fields          

Field

Description of Contents

Width

Type

Index

Information

Field Names

163

Name of first service provider

35

Character

Yes

 

SPN1

164

Federal ID # of first service provider

9

Character

Yes

 

SPN1EIN

165

Salary or fee paid to first service provider

9

Numeric

Yes

 

SPN1FEE

166

Service code of first service provider

2

Character

Yes

See Key List

SPN1SC

167

Name of second service provider

35

Character

Yes

 

SPN2

168

Federal ID # of second service provider

9

Character

Yes

 

SPN2EIN

169

Salary or fee paid to second service provider

9

Numeric

Yes

 

SPN2FEE

170

Service code of second service provider

2

Character

Yes

See Key List

SPN2SC

171

Name of third service provider

35

Character

Yes

 

SPN3

172

Federal ID # of third service provider

9

Character

Yes

 

SPN3EIN

173

Salary or fee paid to third service provider

9

Numeric

Yes

 

SPN3FEE

174

Service code of third service provider

2

Character

Yes

See Key List

SPN3SC

175

Name of fourth service provider

35

Character

Yes

 

SPN4

176

Federal ID # of fourth service provider

9

Character

Yes

 

SPN4EIN

177

Salary or fee paid to fourth service provider

9

Numeric

Yes

 

SPN4FEE

178

Service code of fourth service provider

2

Character

Yes

See Key List

SPN4SC

179

Name of fifth service provider

35

Character

Yes

 

SPN5

180

Federal ID # of fifth service provider

9

Character

Yes

 

SPN5EIN

181

Salary or fee paid to fifth service provider

9

Numeric

Yes

 

SPN5FEE

182

Service code of fifth service provider

2

Character

Yes

See Key List

SPN5SC

183

Name of sixth service provider

35

Character

Yes

 

SPN6

184

Federal ID # of sixth service provider

9

Character

Yes

 

SPN6EIN

185

Salary or fee paid to sixth service provider

9

Numeric

Yes

 

SPN6FEE

186

Service code of sixth service provider

2

Character

Yes

See Key List

SPN6SC

187

Name of seventh service provider

35

Character

Yes

 

SPN7

188

Federal ID # of seventh service provider

9

Character

Yes

 

SPN7EIN

189

Salary or fee paid to seventh service provider

9

Numeric

Yes

 

SPN7FEE

190

Service code of seventh service provider

2

Character

Yes

See Key List

SPN7SC

191

Name of eighth service provider

35

Character

Yes

 

SPN8

192

Federal ID # of eighth service provider

9

Character

Yes

 

SPN8EIN

193

Salary or fee paid to eighth service provider

9

Numeric

Yes

 

SPN8FEE

194

Service code of eighth service provider

2

Character

Yes

See Key List

SPN8SC

195

Name of ninth service provider

35

Character

Yes

 

SPN9

196

Federal ID # of ninth service provider

9

Character

Yes

 

SPN9EIN

197

Salary or fee paid to ninth service provider

9

Numeric

Yes

 

SPN9FEE

198

Service code of ninth service provider

2

Character

Yes

See Key List

SPN9SC

199

Name of tenth service provider

35

Character

Yes

 

SPN10

200

Federal ID # of tenth service provider

9

Character

Yes

 

SPN10EIN

201

Salary or fee paid to tenth service provider

9

Numeric

Yes

 

SPN10FEE

202

Service code of tenth service provider

2

Character

Yes

See Key List

SPN10SC

203

Name of eleventh service provider

35

Character

Yes

 

SPN11

204

Federal ID # of eleventh service provider

9

Character

Yes

 

SPN11EIN

205

Salary or fee paid to eleventh service provider

9

Numeric

Yes

 

SPN11FEE

206

Service code of eleventh service provider

2

Character

Yes

See Key List

SPN11SC

207

Name of twelfth service provider

35

Character

Yes

 

SPN12

208

Federal ID # of twelfth service provider

9

Character

Yes

 

SPN12EIN

209

Salary or fee paid to twelfth service provider

9

Numeric

Yes

 

SPN12FEE

210

Service code of twelfth service provider

2

Character

Yes

See Key List

SPN12SC

211

Name of first trustee

35

String

Yes

 

TNAME1

212

Name of second trustee

35

String

Yes

 

TNAME2

213

Name of third trustee

35

String

Yes

 

TNAME3

214

Name of fourth trustee

35

String

Yes

 

TNAME4

215

Name of fifth trustee

35

String

Yes

 

TNAME5

216

Name of sixth trustee

35

String

Yes

 

TNAME6

             

Database Enhancements          

Field

Description of Contents

Width

Type

Index

Information

Field Names

217

Sponsor's county

25

Character

Yes

 

COUNTY

218

Sponsor's fax number

12

Character

 

 

SFAX

219

Second contact name

40

Character

Yes

 

CONTACT2ND

220

Third contact name

40

Character

Yes

 

CONTACT3RD

             

Analytical Enhancements          

Field

Description of Contents

Width

Type

Index

Information

Field Names

221

Average contribution per participant

12

Numeric

Yes

 

AVECONTRIB

222

Average account balance per participant

12

Numeric

Yes

 

AVEACCTBAL

223

Participation rate

3

Numeric

Yes

 

PARTICRATE

224

Number of eligible employees

8

Numeric

 

5500 & 5500C Line 21j

ELIGEMPLOY

             

Historical Enhancements          

Field

Description of Contents

Width

Type

Index

Information

Field Names

225

Plan year end 0

7

Character

 

Current filing

YEAREND0

226

Total active participants 0

8

Numeric

 

Current filing

PARTIC0

227

Total assets 0

12

Numeric

 

Current filing

TOTASSETS0

228

Employer contributions 0

12

Numeric

 

Current filing

CONTEMPLR0

229

Participant contributions 0

12

Numeric

 

Current filing

CONTRPART0

230

Investment earnings 0

12

Numeric

 

Current filing

TOTINVERN0

231

Total income 0

13

Numeric

 

Current filing

TOTINCOME0

232

Total plan expenses 0

12

Numeric

 

Current filing

EXPTOTPLN0

233

Administrative expenses 0

12

Numeric

 

Current filing

EXPADMIN0

234

Payments to participants 0

12

Numeric

 

Current filing

PAYTOPART0

235

Plan year end 1

7

Character

 

Filing prior to 222 - 231

YEAREND1

236

Total active participants 1

8

Numeric

 

Filing prior to 222 - 231

PARTIC1

237

Total assets 1

12

Numeric

 

Filing prior to 222 - 231

TOTASSETS1

238

Employer contributions 1

12

Numeric

 

Filing prior to 222 - 231

CONTEMPLR1

239

Participant contributions 1

12

Numeric

 

Filing prior to 222 - 231

CONTRPART1

240

Investment earnings 1

12

Numeric

 

Filing prior to 222 - 231

TOTINVERN1

241

Total income 1

13

Numeric

 

Filing prior to 222 - 231

TOTINCOME1

242

Total plan expenses 1

12

Numeric

 

Filing prior to 222 - 231

EXPTOTPLN1

243

Administrative expenses 1

12

Numeric

 

Filing prior to 222 - 231

EXPADMIN1

244

Payments to participants 1

12

Numeric

 

Filing prior to 222 - 231

PAYTOPART1

245

Plan year end 2

7

Character

 

Filing prior to 232 - 241

YEAREND2

246

Total active participants 2

8

Numeric

 

Filing prior to 232 - 241

PARTIC2

247

Total assets 2

12

Numeric

 

Filing prior to 232 - 241

TOTASSETS2

248

Employer contributions 2

12

Numeric

 

Filing prior to 232 - 241

CONTEMPLR2

249

Participant contributions 2

12

Numeric

 

Filing prior to 232 - 241

CONTRPART2

250

Investment earnings 2

12

Numeric

 

Filing prior to 232 - 241

TOTINVERN2

251

Total income 2

13

Numeric

 

Filing prior to 232 - 241

TOTINCOME2

252

Total plan expenses 2

12

Numeric

 

Filing prior to 232 - 241

EXPTOTPLN2

253

Administrative expenses 2

12

Numeric

 

Filing prior to 232 - 241

EXPADMIN2

254

Payments to participants 2

12

Numeric

 

Filing prior to 232 - 241

PAYTOPART2

255

Plan year end 3

7

Character

 

Filing prior to 242 - 251

YEAREND3

256

Total active participants 3

8

Numeric

 

Filing prior to 242 - 251

PARTIC3

257

Total assets 3

12

Numeric

 

Filing prior to 242 - 251

TOTASSETS3

258

Employer contributions 3

12

Numeric

 

Filing prior to 242 - 251

CONTEMPLR3

259

Participant contributions 3

12

Numeric

 

Filing prior to 242 - 251

CONTRPART3

260

Investment earnings 3

12

Numeric

 

Filing prior to 242 - 251

TOTINVERN3

261

Total income 3

13

Numeric

 

Filing prior to 242 - 251

TOTINCOME3

262

Total plan expenses 3

12

Numeric

 

Filing prior to 242 - 251

EXPTOTPLN3

263

Administrative expenses 3

12

Numeric

 

Filing prior to 242 - 251

EXPADMIN3

264

Payments to participants 3

12

Numeric

 

Filing prior to 242 - 251

PAYTOPART3

265

Plan year end 4

7

Character

 

Filing prior to 252 - 261

YEAREND4

266

Total active participants 4

8

Numeric

 

Filing prior to 252 - 261

PARTIC4

267

Total assets 4

12

Numeric

 

Filing prior to 252 - 261

TOTASSETS4

268

Employer contributions 4

12

Numeric

 

Filing prior to 252 - 261

CONTEMPLR4

269

Participant contributions 4

12

Numeric

 

Filing prior to 252 - 261

CONTRPART4

270

Investment earnings 4

12

Numeric

 

Filing prior to 252 - 261

TOTINVERN4

271

Total income 4

13

Numeric

 

Filing prior to 252 - 261

TOTINCOME4

272

Total plan expenses 4

12

Numeric

 

Filing prior to 252 - 261

EXPTOTPLN4

273

Administrative expenses 4

12

Numeric

 

Filing prior to 252 - 261

EXPADMIN4

274

Payments to participants 4

12

Numeric

 

Filing prior to 252 - 261

PAYTOPART4

             

Additional Schedule B fields          

Field

Description of Contents

Width

Type

Index

Information

Field Names

275

Item F

1

Character

 

 

ITEMF

276

Line 1B2

13

Numeric

 

 

B1B2

277

Line 1C1

13

Numeric

 

 

B1C1

278

Line 1C2A

13

Numeric

 

 

B1C2A

279

Line 1C2B

13

Numeric

 

 

B1C2B

280

Line 1C2C

13

Numeric

 

 

B1C2C

281

Line 1D1

13

Numeric

 

 

B1D1

282

Line 1D2A

13

Numeric

 

 

B1D2A

283

Line 1D2B

13

Numeric

 

 

B1D2B

284

Line 1D2C

13

Numeric

 

 

B1D2C

285

Line 1D2D

13

Numeric

 

 

B1D2D

286

Line 1D3A

13

Numeric

 

 

B1D3A

287

Line 1D3B

13

Numeric

 

 

B1D3B

288

Line 1D3C

13

Numeric

 

 

B1D3C

289

Line 1D4

13

Numeric

 

 

B1D4

290

REGPROMBOX

1

Character

 

 

REGPROMBOX

291

Line 3BTOTAL

13

Numeric

 

 

B3BTOTAL

292

Line 3CTOTAL

13

Numeric

 

 

B3CTOTAL

293

Line 4A

4

Numeric

 

 

B4A

294

Line 4B1

13

Numeric

 

 

B4B1

295

Line 4B2

13

Numeric

 

 

B4B2

296

Line 4B3

13

Numeric

 

 

B4B3

297

Line 4B4

13

Numeric

 

 

B4B4

298

Line 5DESC

35

Character

 

 

BLNE5DESC

299

Line 5I

1

Character

 

 

B5I

300

Line 5J

1

Character

 

 

B5J

301

Line 5K

10

Character

 

 

B5K

302

Line 6A1

4

Numeric

 

 

B6A1

303

Line 6A2

4

Numeric

 

 

B6A2

304

Line 6B

2

Numeric

 

 

B6B

305

Line 6CPRE

1

Character

 

 

B6CPRE

306

Line 6CPOST

1

Character

 

 

B6CPOST

307

Line 6D1 MALE PRE

7

Character

 

 

B6D1MPRE

308

Line 6D1 MALE POST

7

Character

 

 

B6D1MPOST

309

Line 6D2 FEMALE PRE

7

Character

 

 

B6D2FPRE

310

Line 6D2 FEMALE POST

7

Character

 

 

B6D2FPOST

311

Line 6EPRE

4

Numeric

 

 

B6EPRE

312

Line 6EPOST

4

Numeric

 

 

B6EPOST

313

Line 6FPRE

4

Numeric

 

 

B6FPRE

314

Line 6FPOST

4

Numeric

 

 

B6FPOST

315

Line 6G1 MALE

4

Numeric

 

 

B6G1MALE

316

Line 6G1 FEMALE

4

Numeric

 

 

B6G1FEMALE

317

Line 6G2 MALE

4

Numeric

 

 

B6G2MALE

318

Line 6G2 FEMALE

4

Numeric

 

 

B6G2FEMALE

319

Line 6G3 MALE

4

Numeric

 

 

B6G3MALE

320

Line 6G3 FEMALE

4

Numeric

 

 

B6G3FEMALE

321

Line 6H MALE

4

Numeric

 

 

B6HMALE

322

Line 6H FEMALE

4

Numeric

 

 

B6HFEMALE

323

Line 6I

5

Numeric

 

 

B6I

324

Line 71FIRST

1

Character

 

 

B71FIRST

325

Line 72FIRST

13

Numeric

 

 

B72FIRST

326

Line 73FIRST

13

Numeric

 

 

B73FIRST

327

Line 71SECOND

1

Character

 

 

B71SECOND

328

Line 72SECOND

13

Numeric

 

 

B72SECOND

329

Line 73SECOND

13

Numeric

 

 

B73SECOND

330

Line 71THIRD

1

Character

 

 

B71THIRD

331

Line 72THIRD

13

Numeric

 

 

B72THIRD

332

Line 73THIRD

13

Numeric

 

 

B73THIRD

333

Line 8A

10

Character

 

 

B8A

334

Line 8B

1

Character

 

 

B8B

335

Line 8C

1

Character

 

 

B8C

336

Line 9A

12

Numeric

 

 

B9A

337

Line 9B

13

Numeric

 

 

B9B

338

Line 9C1OUTBAL

13

Numeric

 

 

B9C1OUTBAL

339

Line 9C1TOTAL

13

Numeric

 

 

B9C1TOTAL

340

Line 9C2OUTBAL

13

Numeric

 

 

B9C2OUTBAL

341

Line 9C2TOTAL

13

Numeric

 

 

B9C2TOTAL

342

Line 9D

13

Numeric

 

 

B9D

343

Line 9E

13

Numeric

 

 

B9E

344

Line 9F

13

Numeric

 

 

B9F

345

Line 9G

13

Numeric

 

 

B9G

346

Line 9H

13

Numeric

 

 

B9H

347

Line 9I

13

Numeric

 

 

B9I

348

Line 9JOUTBAL

13

Numeric

 

 

B9JOUTBAL

349

Line 9JTOTAL

13

Numeric

 

 

B9JTOTAL

350

Line 9K

13

Numeric

 

 

B9K

351

Line 9L1

13

Numeric

 

 

B9L1

352

Line 9L2

13

Numeric

 

 

B9L2

353

Line 9L3

13

Numeric

 

 

B9L3

354

Line 9L4

13

Numeric

 

 

B9L4

355

Line 9L5

13

Numeric

 

 

B9L5

356

Line 9M1

12

Numeric

 

 

B9M1

357

Line 9M2

13

Numeric

 

 

B9M2

358

Line 9N

13

Numeric

 

 

B9N

359

Line 9O

13

Numeric

 

 

B9O

360

Line 9P

12

Numeric

 

 

B9P

361

Line 9Q1

13

Numeric

 

 

B9Q1

362

Line 9Q2

13

Numeric

 

 

B9Q2

363

Line 9Q3A

13

Numeric

 

 

B9Q3A

364

Line 9Q3B

13

Numeric

 

 

B9Q3B

365

Line 9Q4

13

Numeric

 

 

B9Q4

366

Line 10

12

Numeric

 

 

B10

367

Line 11

1

Character

 

 

B11

368

Line 12A

4

Numeric

 

 

B12A

369

Line 12AI

1

Character

 

 

B12AI

370

Line 12A11

1

Character

 

 

B12A11

371

Line 12AIII

1

Character

 

 

B12AIII

372

Line 12AIV

1

Character

 

 

B12AIV

373

Line 12B

13

Numeric

 

 

B12B

374

Line 12C

13

Numeric

 

 

B12C

375

Line 12D

4

Numeric

 

 

B12D

376

Line 12E

13

Numeric

 

 

B12E

377

Line 12F

13

Numeric

 

 

B12F

378

Line 12G

13

Numeric

 

 

B12G

379

Line 12H

13

Numeric

 

 

B12H

380

Line 12IPCT

4

Numeric

 

 

B12IPCT

381

Line 12ITOTAL

13

Numeric

 

 

B12ITOTAL

382

Line 12J

13

Numeric

 

 

B12J

383

Line 12K

13

Numeric

 

 

B12K

384

Line 12L

13

Numeric

 

 

B12L

385

Line 12M1

13

Numeric

 

 

B12M1

386

Line 12M2

4

Numeric

 

 

B12M2

387

Line 12M3

4

Numeric

 

 

B12M3

388

Line 12M4

13

Numeric

 

 

B12M4

389

Line 12M5

13

Numeric

 

 

B12M5

390

Line 12M6

13

Numeric

 

 

B12M6

391

Line 12M7

13

Numeric

 

 

B12M7

392

Line 12N

13

Numeric

 

 

B12N

393

Line 12O

13

Numeric

 

 

B12O

394

Line 12P

13

Numeric

 

 

B12P

395

Line 12Q

13

Numeric

 

 

B12Q

396

Line 12R

13

Numeric

 

 

B12R

397

Line 12S

13

Numeric

 

 

B12S

398

Line 12T

13

Numeric

 

 

B12T

399

Line 12UPCT

4

Numeric

 

 

B12UPCT

400

Line 12UAMT

13

Numeric

 

 

B12UAMT

401

Line 13C

4

Numeric

 

 

B13C

402

Line 13D

13

Numeric

 

 

B13D

403

Line 13E

13

Numeric

 

 

B13E

404

Line 13F

13

Numeric

 

 

B13F

405

Line 13G

13

Numeric

 

 

B13G

406

Line 13HPCT

4

Numeric

 

 

B13HPCT

407

Line 13HAMT

13

Numeric

 

 

B13HAMT

408

Line 13I

13

Numeric

 

 

B13I

409

Line 13J

13

Numeric

 

 

B13J

410

Line 13K

13

Numeric

 

 

B13K

411

Line 13L1

13

Numeric

 

 

B13L1

412

Line 13L2

4

Numeric

 

 

B13L2

413

Line 13L3

4

Numeric

 

 

B13L3

414

Line 13L4

13

Numeric

 

 

B13L4

415

Line 13L5

13

Numeric

 

 

B13L5

416

Line 13L6

13

Numeric

 

 

B13L6

417

Line 13M

13

Numeric

 

 

B13M

418

Line 13N

13

Numeric

 

 

B13N

419

Line 13O

13

Numeric

 

 

B13O

420

Line 13P

13

Numeric

 

 

B13P

421

Line 13Q

13

Numeric

 

 

B13Q

422

Line 14A

4

Numeric

 

 

B14A

423

Line 14B

4

Numeric

 

 

B14B

424

Line 14C

13

Numeric

 

 

B14C

425

Line 14D

13

Numeric

 

 

B14D

426

Line 14E

13

Numeric

 

 

B14E

             

Schedule D Database Fields          

Field

Description of Contents

Width

Type

Index

Information

Field Names

427

Fund Name 1

35

Character

Yes

 

ENTITY01NM

428

Sponsor Name 1

35

Character

Yes

 

SPONS01NM

429

Entity Code 1

1

Character

Yes

See Key List

ENTITY01CD

430

Value Invested 1

12

Numeric

Yes

 

INTEOY1AMT

431

Fund Name 2

35

Character

Yes

 

ENTITY02NM

432

Sponsor Name 2

35

Character

Yes

 

SPONS02NM

433

Entity Code 2

1

Character

Yes

See Key List

ENTITY02CD

434

Value Invested 2

12

Numeric

Yes

 

INTEOY2AMT

435

Fund Name 3

35

Character

Yes

 

ENTITY03NM

436

Sponsor Name 3

35

Character

Yes

 

SPONS03NM

437

Entity Code 3

1

Character

Yes

See Key List

ENTITY03CD

438

Value Invested 3

12

Numeric

Yes

 

INTEOY3AMT

439

Fund Name 4

35

Character

Yes

 

ENTITY04NM

440

Sponsor Name 4

35

Character

Yes

 

SPONS04NM

441

Entity Code 4

1

Character

Yes

See Key List

ENTITY04CD

442

Value Invested 4

12

Numeric

Yes

 

INTEOY4AMT

443

Fund Name 5

35

Character

Yes

 

ENTITY05NM

444

Sponsor Name 5

35

Character

Yes

 

SPONS05NM

445

Entity Code 5

1

Character

Yes

See Key List

ENTITY05CD

446

Value Invested 5

12

Numeric

Yes

 

INTEOY5AMT

447

Fund Name 6

35

Character

Yes

 

ENTITY06NM

448

Sponsor Name 6

35

Character

Yes

 

SPONS06NM

449

Entity Code 6

1

Character

Yes

See Key List

ENTITY06CD

450

Value Invested 6

12

Numeric

Yes

 

INTEOY6AMT

451

Fund Name 7

35

Character

Yes

 

ENTITY07NM

452

Sponsor Name 7

35

Character

Yes

 

SPONS07NM

453

Entity Code 7

1

Character

Yes

See Key List

ENTITY07CD

454

Value Invested 7

12

Numeric

Yes

 

INTEOY7AMT

455

Fund Name 8

35

Character

Yes

 

ENTITY08NM

456

Sponsor Name 8

35

Character

Yes

 

SPONS08NM

457

Entity Code 8

1

Character

Yes

See Key List

ENTITY08CD

458

Value Invested 8

12

Numeric

Yes

 

INTEOY8AMT

459

Fund Name 9

35

Character

Yes

 

ENTITY09NM

460

Sponsor Name 9

35

Character

Yes

 

SPONS09NM

461

Entity Code 9

1

Character

Yes

See Key List

ENTITY09CD

462

Value Invested 9

12

Numeric

Yes

 

INTEOY9AMT

463

Fund Name 10

35

Character

Yes

 

ENTITY10NM

464

Sponsor Name 10

35

Character

Yes

 

SPONS10NM

465

Entity Code 10

1

Character

Yes

See Key List

ENTITY10CD

466

Value Invested 10

12

Numeric

Yes

 

INTEOY10AT

467

Fund Name 11

35

Character

Yes

 

ENTITY11NM

468

Sponsor Name 11

35

Character

Yes

 

SPONS11NM

469

Entity Code 11

1

Character

Yes

See Key List

ENTITY11CD

470

Value Invested 11

12

Numeric

Yes

 

INTEOY11AT

471

Fund Name 12

35

Character

Yes

 

ENTITY12NM

472

Sponsor Name 12

35

Character

Yes

 

SPONS12NM

473

Entity Code 12

1

Character

Yes

See Key List

ENTITY12CD

474

Value Invested 12

12

Numeric

Yes

 

INTEOY12AT

475

Fund Name 13

35

Character

Yes

 

ENTITY13NM

476

Sponsor Name 13

35

Character

Yes

 

SPONS13NM

477

Entity Code 13

1

Character

Yes

See Key List

ENTITY13CD

478

Value Invested 13

12

Numeric

Yes

 

INTEOY13AT

479

Fund Name 14

35

Character

Yes

 

ENTITY14NM

480

Sponsor Name 14

35

Character

Yes

 

SPONS14NM

481

Entity Code 14

1

Character

Yes

See Key List

ENTITY14CD

482

Value Invested 14

12

Numeric

Yes

 

INTEOY14AT

483

Fund Name 15

35

Character

Yes

 

ENTITY15NM

484

Sponsor Name 15

35

Character

Yes

 

SPONS15NM

485

Entity Code 15

1

Character

Yes

See Key List

ENTITY15CD

486

Value Invested 15

12

Numeric

Yes

 

INTEOY15AT

487

Fund Name 16

35

Character

Yes

 

ENTITY16NM

488

Sponsor Name 16

35

Character

Yes

 

SPONS16NM

489

Entity Code 16

1

Character

Yes

See Key List

ENTITY16CD

490

Value Invested 16

12

Numeric

Yes

 

INTEOY16AT

491

Fund Name 17

35

Character

Yes

 

ENTITY17NM

492

Sponsor Name 17

35

Character

Yes

 

SPONS17NM

493

Entity Code 17

1

Character

Yes

See Key List

ENTITY17CD

494

Value Invested 17

12

Numeric

Yes

 

INTEOY17AT

495

Fund Name 18

35

Character

Yes

 

ENTITY18NM

496

Sponsor Name 18

35

Character

Yes

 

SPONS18NM

497

Entity Code 18

1

Character

Yes

See Key List

ENTITY18CD

498

Value Invested 18

12

Numeric

Yes

 

INTEOY18AT

499

Fund Name 19

35

Character

Yes

 

ENTITY19NM

500

Sponsor Name 19

35

Character

Yes

 

SPONS19NM

501

Entity Code 19

1

Character

Yes

See Key List

ENTITY19CD

502

Value Invested 19

12

Numeric

Yes

 

INTEOY19AT

503

Fund Name 20

35

Character

Yes

 

ENTITY20NM

504

Sponsor Name 20

35

Character

Yes

 

SPONS20NM

505

Entity Code 20

1

Character

Yes

See Key List

ENTITY20CD

506

Value Invested 20

12

Numeric

Yes

 

INTEOY20AT

507

Fund Name 21

35

Character

Yes

 

ENTITY21NM

508

Sponsor Name 21

35

Character

Yes

 

SPONS21NM

509

Entity Code 21

1

Character

Yes

See Key List

ENTITY21CD

510

Value Invested 21

12

Numeric

Yes

 

INTEOY21AT

511

Fund Name 22

35

Character

Yes

 

ENTITY22NM

512

Sponsor Name 22

35

Character

Yes

 

SPONS22NM

513

Entity Code 22

1

Character

Yes

See Key List

ENTITY22CD

514

Value Invested 22

12

Numeric

Yes

 

INTEOY22AT

515

Fund Name 23

35

Character

Yes

 

ENTITY23NM

516

Sponsor Name 23

35

Character

Yes

 

SPONS23NM

517

Entity Code 23

1

Character

Yes

See Key List

ENTITY23CD

518

Value Invested 23

12

Numeric

Yes

 

INTEOY23AT

519

Fund Name 24

35

Character

Yes

 

ENTITY24NM

520

Sponsor Name 24

35

Character

Yes

 

SPONS24NM

521

Entity Code 24

1

Character

Yes

See Key List

ENTITY24CD

522

Value Invested 24

12

Numeric

Yes

 

INTEOY24AT

523

Fund Name 25

35

Character

Yes

 

ENTITY25NM

524

Sponsor Name 25

35

Character

Yes

 

SPONS25NM

525

Entity Code 25

1

Character

Yes

See Key List

ENTITY25CD

526

Value Invested 25

12

Numeric

Yes

 

INTEOY25AT

527

Fund Name 26

35

Character

Yes

 

ENTITY26NM

528

Sponsor Name 26

35

Character

Yes

 

SPONS26NM

529

Entity Code 26

1

Character

Yes

See Key List

ENTITY26CD

530

Value Invested 26

12

Numeric

Yes

 

INTEOY26AT

531

Fund Name 27

35

Character

Yes

 

ENTITY27NM

532

Sponsor Name 27

35

Character

Yes

 

SPONS27NM

533

Entity Code 27

1

Character

Yes

See Key List

ENTITY27CD

534

Value Invested 27

12

Numeric

Yes

 

INTEOY27AT

535

Fund Name 28

35

Character

Yes

 

ENTITY28NM

536

Sponsor Name 28

35

Character

Yes

 

SPONS28NM

537

Entity Code 28

1

Character

Yes

See Key List

ENTITY28CD

538

Value Invested 28

12

Numeric

Yes

 

INTEOY28AT

539

Fund Name 29

35

Character

Yes

 

ENTITY29NM

540

Sponsor Name 29

35

Character

Yes

 

SPONS29NM

541

Entity Code 29

1

Character

Yes

See Key List

ENTITY29CD

542

Value Invested 29

12

Numeric

Yes

 

INTEOY29AT

543

Fund Name 30

35

Character

Yes

 

ENTITY30NM

544

Sponsor Name 30

35

Character

Yes

 

SPONS30NM

545

Entity Code 30

1

Character

Yes

See Key List

ENTITY30CD

546

Value Invested 30

12

Numeric

Yes

 

INTEOY30AT

547

Fund Name 31

35

Character

Yes

 

ENTITY31NM

548

Sponsor Name 31

35

Character

Yes

 

SPONS31NM

549

Entity Code 31

1

Character

Yes

See Key List

ENTITY31CD

550

Value Invested 31

12

Numeric

Yes

 

INTEOY31AT

551

Fund Name 32

35

Character

Yes

 

ENTITY32NM

552

Sponsor Name 32

35

Character

Yes

 

SPONS32NM

553

Entity Code 32

1

Character

Yes

See Key List

ENTITY32CD

554

Value Invested 32

12

Numeric

Yes

 

INTEOY32AT

555

Fund Name 33

35

Character

Yes

 

ENTITY33NM

556

Sponsor Name 33

35

Character

Yes

 

SPONS33NM

557

Entity Code 33

1

Character

Yes

See Key List

ENTITY33CD

558

Value Invested 33

12

Numeric

Yes

 

INTEOY33AT

559

Fund Name 34

35

Character

Yes

 

ENTITY34NM

560

Sponsor Name 34

35

Character

Yes

 

SPONS34NM

561

Entity Code 34

1

Character

Yes

See Key List

ENTITY34CD

562

Value Invested 34

12

Numeric

Yes

 

INTEOY34AT

563

Fund Name 35

35

Character

Yes

 

ENTITY35NM

564

Sponsor Name 35

35

Character

Yes

 

SPONS35NM

565

Entity Code 35

1

Character

Yes

See Key List

ENTITY35CD

566

Value Invested 35

12

Numeric

Yes

 

INTEOY35AT

567

Fund Name 36

35

Character

Yes

 

ENTITY36NM

568

Sponsor Name 36

35

Character

Yes

 

SPONS36NM

569

Entity Code 36

1

Character

Yes

See Key List

ENTITY36CD

570

Value Invested 36

12

Numeric

Yes

 

INTEOY36AT

571

Fund Name 37

35

Character

Yes

 

ENTITY37NM

572

Sponsor Name 37

35

Character

Yes

 

SPONS37NM

573

Entity Code 37

1

Character

Yes

See Key List

ENTITY37CD

574

Value Invested 37

12

Numeric

Yes

 

INTEOY37AT

575

Fund Name 38

35

Character

Yes

 

ENTITY38NM

576

Sponsor Name 38

35

Character

Yes

 

SPONS38NM

577

Entity Code 38

1

Character

Yes

See Key List

ENTITY38CD

578

Value Invested 38

12

Numeric

Yes

 

INTEOY38AT

579

Fund Name 39

35

Character

Yes

 

ENTITY39NM

580

Sponsor Name 39

35

Character

Yes

 

SPONS39NM

581

Entity Code 39

1

Character

Yes

See Key List

ENTITY39CD

582

Value Invested 39

12

Numeric

Yes

 

INTEOY39AT

583

Fund Name 40

35

Character

Yes

 

ENTITY40NM

584

Sponsor Name 40

35

Character

Yes

 

SPONS40NM

585

Entity Code 40

1

Character

Yes

See Key List

ENTITY40CD

586

Value Invested 40

12

Numeric

Yes

 

INTEOY40AT

587

Fund Name 41

35

Character

Yes

 

ENTITY41NM

588

Sponsor Name 41

35

Character

Yes

 

SPONS41NM

589

Entity Code 41

1

Character

Yes

See Key List

ENTITY41CD

590

Value Invested 41

12

Numeric

Yes

 

INTEOY41AT

591

Fund Name 42

35

Character

Yes

 

ENTITY42NM

592

Sponsor Name 42

35

Character

Yes

 

SPONS42NM

593

Entity Code 42

1

Character

Yes

See Key List

ENTITY42CD

594

Value Invested 42

12

Numeric

Yes

 

INTEOY42AT

595

Fund Name 43

35

Character

Yes

 

ENTITY43NM

596

Sponsor Name 43

35

Character

Yes

 

SPONS43NM

597

Entity Code 43

1

Character

Yes

See Key List

ENTITY43CD

598

Value Invested 43

12

Numeric

Yes

 

INTEOY43AT

599

Fund Name 44

35

Character

Yes

 

ENTITY44NM

600

Sponsor Name 44

35

Character

Yes

 

SPONS44NM

601

Entity Code 44

1

Character

Yes

See Key List

ENTITY44CD

602

Value Invested 44

12

Numeric

Yes

 

INTEOY44AT

603

Fund Name 45

35

Character

Yes

 

ENTITY45NM

604

Sponsor Name 45

35

Character

Yes

 

SPONS45NM

605

Entity Code 45

1

Character

Yes

See Key List

ENTITY45CD

606

Value Invested 45

12

Numeric

Yes

 

INTEOY45AT

Contents