Pipe Delimited Input / Output Record

This is a sample input record received from a RealEDA customer.

 

Remember, we can work with any existing record formats you are currently creating, if necessary. We would merely convert it in-house to the following "pipe delimited" format before processing.  And then reconvert it from the following output format to a format easier for you to work with.

 

ABRAMOWITZ|HYMAN|||26 BROOKSIDE CIR||MARLBORO|NJ|07746||3||GARYC1||C|80||||

 

This is the output portion of the record which RealEDA appends (ignore all cr/lf except final one)

 

ABRAMOWITZ|HYMAN|||26|BROOKSIDE|

CIR|MARLBORO|NJ|07746|7325362671|1|GARYC1000322134819|0|3/22/00 1:48:27 PM|100|True|True|True|False|True|True|True|True|True|True|False|100|||ABRAMOWITZ|HYMAN||

26|BROOKSIDE|CIR|MARLBORO|NJ|07746|732||R|2|BA|FALSE|1|||26||BROOKSIDE|CIR||||

MARLBORO|NJ|07746|1603|MONMOUTH|025|12|EST|268||

 

This is a sample of the complete actual record which is received back from RealEDA

 

ABRAMOWITZ|HYMAN|||26 BROOKSIDE

CIR||MARLBORO|NJ|07746||3||GARYC1||C|80||||ABRAMOWITZ|HYMAN|||26|BROOKSIDE|

CIR|MARLBORO|NJ|07746|7325362671|1|GARYC1000322134819|0|3/22/00 1:48:27 PM|100|True|True|True|False|True|True|True|True|True|True|False|100|||ABRAMOWITZ|HYMAN||

26|BROOKSIDE|CIR|MARLBORO|NJ|07746|732||R|2|BA|FALSE|1|||26||BROOKSIDE|CIR||||

MARLBORO|NJ|07746|1603|MONMOUTH|025|12|EST|268||

 

This is a disassembled sample record

The fields names are used internally for processing and
are only provided here for reference purposes.  In general the fields that begin

with "i" are user input fields, "n" fields are address standardization fields, 

"z" fields are the results and match results fields,  with the "r" fields created during the 

request processing.

 

Input and output records do not at this time provide for any field
descriptions inherent to the data and will not until we provide XML

integration in the near future

This is the input portion
*******************************************************
1  iLastName = ABRAMOWITZ
2  iFirstName = HYMAN
3  iMiddleName = 
4  iHouseNum = 
5  iStreetName = 26 BROOKSIDE CIR
6  iStreetSuffix = 
7  iCity = MARLBORO
8  iState = NJ
9  iZipCode = 07746
10 iPhone = 
11 iMaxScreens = 3
12 iUserInfo = 
13 iUserID = GARYC1
14 iPassword = 
15 iAdaptiveCode = C
16 iUserDefinedBestMatchScore = 80
17 iFuture1 = 
18 iFuture2 = 
19 iFuture3= 

Output portion begins here
*******************************************************
Number of fields in record #1 are 85
20 zLastName = ABRAMOWITZ
21 zFirstName = HYMAN
22 zMiddleName =
23 zCaption =
24 zHouseNum = 26
25 zStreetName = BROOKSIDE
26 zStreetSuffix = CIR
27 zCity = MARLBORO
28 zState = NJ
29 zZipCode = 07746
30 zPhone = 7325362671
31 zScreenCount = 1
32 zJobID = GARYC1000322134819
33 zProcessStatus = 0
34 zProcessDateTime = 3/22/00 1:48:27 PM
35 zHighestScoreSoFar = 100
36 zMatchLastName = TRUE
37 zMatchFirstName = TRUE
38 zMatchFirstInitial = TRUE
39 zMatchMiddleName = FALSE
40 zMatchHouseNum = TRUE
41 zMatchStreetName = TRUE
42 zMatchStreetSuffix = TRUE
43 zMatchCity = TRUE
44 zMatchState = TRUE
45 zMatchZipCode = TRUE
46 zMatchPhone = FALSE
47 zMatchTotal = 100
48 zFuture1 =
49 zFuture2 =
50 rLastName = ABRAMOWITZ
51 rFirstName = HYMAN
52 rMiddleName =
53 rHouseNum = 26
54 rStreetName = BROOKSIDE
55 rStreetSuffix = CIR
56 rCity = MARLBORO
57 rState = NJ
58 rZipCode = 07746
59 rAreaCode = 732
60 rPhone =
61 rIndicator = R
62 rDatabase = 2
63 rLecID = BA
64 rCreditApproved = FALSE
65 rRecordSequenceNumber = 1
66 rFuture1 =
67 rFuture2 =
68 nHouseNum = 26
69 nPreDirection =
70 nStreetName = BROOKSIDE
71 nStreetSuffix = CIR
72 nPostDirection =
73 nPOB =
74 nRR =
75 nCity = MARLBORO
76 nState = NJ
77 nZipCode5 = 07746
78 nZipCode4 = 1603
79 nCountyName = MONMOUTH
80 nCountFIPS = 025
81 nCongressionalDistrict = 12
82 nTimeZone = EST
83 nDPBC = 268
84 nFuture1 =
85 nFuture2 =