Record Format Description

(Returned output fields follow the input fields)

We can work with any of your existing legacy formats.  For example, if you are currently sending a file to a credit reporting service, we can use that same file as input to our process.  Or, if you are using a competitive EDA service, you can more seamlessly and transparently integrate the use of our service by accepting as input the current record layout and providing back to you results formatted as you currently expect them back from your current service.

If you have the technical abilities in-house, however, data can most efficiently be processed by RealEDA if it can be formatted into either of the following formats.  Each record must be terminated by a CR/LF and can be either in the fixed field length indicated or using the field separator "|" commonly referred to as a "pipe" or "vertical bar" symbol.  DO NOT use any quotes or double quotes to identify "character" fields if possible.

Here's an example of a "pipe" delimited format record. 

Beginning Position and Length information are also provided if you would rather create the record in a fixed field length format instead of the pipe-delimited format.

We can also provide custom output files upon request.

# Field Name Beg Pos Len Comments 
1 iLastName 

OR

Bus Name

 1 50 May include entire name information if not available as individual fields - Utilized most correctly in the "LastName, FirstName MiddleName" format with a comma as a separator, however "FirstName MiddleName LastName format is acceptable also in addition to some other formats.  It is possible to mix formats and business and residence names in one file.   Business names would also be placed in this field.
2 iFirstName 51 25 Self Explanatory
3 iMiddleName 76 25 Self Explanatory
4 iHouseNum 101 10 Self Explanatory
5 iStreetName 111 50 May include complete street information if not available separated into individual fields such as HouseNum, StreetName, StreetSuffix, etc
6 iStreetSuffix 161 25 For example "Street", Rd.", "Blvd", etc
7 iCity 186 50 Self Explanatory
8 iState 236 2 2 character state
9 iZipCode 238 10 Can be 5 positions - not required but helpful in determining area code, etc
10 iPhone 248 12 Can be 9995551212 format or any other reasonable format
11 iMaxScreens 260 1 not currently in use
12 iUser Info 261 30 Some unique identifier such as acct #, etc
13 iUserID 291 6 User ID - not usually used for batch process - can be used to segment billing within one batch job
14 iPassword 297 6 Same as above
15 iAdaptive Code 303 1 see Adaptive Code
16 iUser Defined Best Match 304 3 Default score 80 - can be modified for unusual needs
17 iFuture1 307 20 for future use
18 iFuture2 327 20 for future use
19 iFuture3 347 20 for future use
This is the end of the input record and the beginning of the output record (returned information)
20 zLast Name 367 50  
21 zFirst Name 417 25  
22 zMiddle Name 442 25  
23 zCaption 467 25  
24 zHouse Num 492 10  
25 zStreet Name 502 50  
26 zStreet Suffix 552 25  
27 zCity 577 50  
28 zState 627 2  
29 zZipCode 629 10  
30 zPhone Number 639 10 10 digit telephone number
31 zScreen Count 649 1 This is the count which signifies a screen charge
32 zJobID 650 25 assigned by us at processing time
33 zProcessStatus 675 1 see Process Status
34 zProcessDateTime 676 20 Process Date & Time
35

zHighestScore

(A work field ONLY)

 696 3 An intermediate working field
36 zMatchLastName? 699 1 True or False
37 zMatchFirstName? 700 1 True or False
38 zMatchFirstInitial? 701 1 True or False
39 zMatchMiddleName? 702 1 True or False
40 zMatchHouseNum? 703 1 True or False
41 zMatchStreetName? 704 1 True or False
42 zMatchStreetSuffix? 705 1 True or False
43 zMatchCity? 706 1 True or False
44 zMatchState? 707 1 True or False
45 zMatchZipCode? 708 1 True or False
46 zMatchPhone? 709 1 True or False
47 zMatchTotal 710 3 Total Match Score - Maximum 100
48 zFuture1 713 20 for future use
49 zFuture2 733 20 for future use
The following fields are used to construct the request query
50 rLastName 753 50
51 rFirstName 803 25
52 rMiddleName 828 25
53 rHouseNum 853 10
54 rStreetName 863 50
55 rStreetSuffix 913 25
56 rCity 938 50
57 rState 988 2
58 rZipCode 990 10
59 rAreaCode 1000 3
60 rPhone 1003 10
61 rIndicator 1013 1 "R" for Residence or "B" for business - tells how the request was submitted
62 rFiller1 1014 20
63 rLecID 1034 3
64 rFiller2 1037 20
65

rRecord

Sequence

Number #

 1057 6 original input sequence number
66 rFuture1 1063 20
67 rFuture2 1083 20
The following fields are address standardized fields using the USPO address standardization database
68 nHouseNum 1103 10
69 nPre Direction 1113 10 such as East
70 nStreet Name 1123 50
71 nStreet Suffix 1173 20
72 nPost Direction 1193 10 such as E in 200 S 45th E
73 nPOB 1203 20
74 nRR 1223 20
75 nCity 1243 50
76 nState 1293 2
77 nZip - 5 1295 5
78 nZip + 4 1300 4
79 nCounty Name 1304 25
80 nCounty FIPS 1329 10
81 nCongress Dist 1339 10
82 nTime Zone 1349 3
83 nDPBC 1352 10 Address Bar Code
84 nFuture1 1362 20 for future use
85 nFuture2 1382 20 for future use
TOTAL LENGTH 1401 BYTES