I_1b_Pilot MUD IRS PWS_Appendix B - Data Extraction Reference Info and Requirements.pdf

Appendix B

Data Extraction Reference Information and Requirements

Fields for Data Extraction1

Field Key Field Description

1 Denomination The par or face value of the issued bond at maturity less any accrued interest: $25, $50, $100, etc..

2 Serial Number An assigned number unique to the Denomination and Series combination.

3 Series The type of bond issued: E, EE, H, HH, etc..

4 Issue Year The year the bond was originally issued.

5 Issue Month The month the bond was originally issued.

6 Owner One Name Name of the first owner listed on the bond registration. Usually an individual but may be an entity or trust.

7 Address 1 Line 1 of the address of one of the owners at date of issue.

8 Address 2 Line 2 of the address of one of the owners at date of issue.

9 City City of one of the owners at date of issue.

10 State State of one of the owners at date of issue.

11 Zip Zip code of one of the owners at date of issue.

12 Owner One TIN Tax Identification Number of the first owner on the bond registration. Can be either a Social Security Number (SSN) or Employer Identification Number (EIN).

13 2nd Owner Type In cases where a second owner registration exists, provides the type of ownership: OR, POD (Payable on death), Beneficiary

14 Owner Two Name Name of the second owner listed on the bond registration.

15 Owner Two TIN Tax Identification Number of the second owner on the bond registration. Can be either a Social Security Number (SSN) or Employer Identification Number (EIN).

1 Not all the fields listed will be provided on every image.

Field Level Information2

Field Frequency provided Potential Formats Denomination Always provided 1 alpha or numeric character Serial Number Always provided Numeric characters Series Usually provided – omitted on some COM 1 or 2 alpha characters Issue Year Always provided Four-digit year

Two-digit year Issue Month Always provided Two-digit month

Abbreviated characters Full character month

Owner One Name Always provided May contain prefix May contain suffix First, MI, Last First, Middle, Last Last, First, MI FI, MI, Last First, Last May contain 4 or 5 names (more than 1 last name) Last name may contain hyphen

Address 1 Usually provided May contain punctuation Address 2 Rarely provided May contain punctuation City Usually provided Abbreviated or full character State Always provided Abbreviated or full character Zip Usually provided 5-digit format

9-digit format (rare) Owner One TIN Usually provided SSN or EIN

Digits only Digits and dashes Digits and spaces

2nd Owner Type Sometimes provided Could be omitted even with Owner Two Name provided

POD

P.O.D.

Or Beneficiary

Owner Two Name Sometimes provided See Owner One Name above Owner Two TIN Sometimes provided

Could be omitted even with Owner Two Name provided

See Owner One TIN above

2 The government has provided an estimate for the frequency of image data fields and common formats seen. The government does not warrant the frequency rates provided. The government’s list of formats does not represent all potential data formats the contractors may find during data extraction.

Identified Field Anomalies3

Field(s) Anomaly TIN May be located above, to the right, or above right of Owner One Name.

May be omitted May be duplicated

Address, City, State, Zip

May be located under Owner Name One or Owner Name Two May be a U.S. territory May be a foreign address May be a military base address

Address 1 May be omitted City May be omitted Zip Code May be omitted Owner Two Type May be on the same line as or above Owner Name Two Owner One Name May be an entity or trust name displayed on multiple lines

May contain a name like “Mr and Mrs John E Doe” Serial Number May be duplicated Owner Names May contain a 3rd name (duplicates one of the listed names). For example, Name 1 then Name 2 is listed, then another Name 1 or Name 2 listed above the address information below the first set of names.

Series Omitted on some COM images

Extracted Data Requirements:

When extracting data, contractor shall:

o extract exactly what it is on bond stub for the identified fields below;

o not convert, reformat, or change any of the data on the issue stub;

o not remove any punctuation, hyphens, or spaces.

o for blank fields on the issue record image, record “BLANK” in data set for that field

The Government has a desired accuracy level as specified below for the following fields:

o Denomination – 95% o Serial Number – 95% o Series – 95% o Owner Name 1 – 75% o Owner 1 TIN – 95% o State - 95% o Owner 2 Name - 75% o Owner 2 TIN - 95%

The Government has a desired accuracy level of 95% for Denomination, Serial Number and Series all being correct in the same record.

3 The government has provided some known data anomalies. The government’s list does not represent all potential data anomalies the contractors may find during data extraction.

The following fields should be extracted to the best of the contractor’s ability; however, the Government has no specific desired accuracy level for these fields:

o Issue Year o Issue Month o Address Line one o Address Line two o City o Zip Code o Second owner type