| PID | VARCHAR | Up to 32-Character Alphanumeric Persistent ID | Persistent ID assigned to individuals identified in the Infutor Graph |
| HHID | VARCHAR | Up to 96-Character Alphanumeric Household ID | A household ID is an indicator that groups individuals living in the same household |
| FNAME | VARCHAR | First Name | First Name of the Individual |
| MNAME | VARCHAR | Middle Name | Middle name or initial of the individual if available |
| LNAME | VARCHAR | Surname | Last name of the individual |
| SUFFIX | VARCHAR | II, III, IV, IX, JR, SR, V, VI, VII, VIII | The generational suffix of the individual if available |
| GENDER | VARCHAR | Gender Code:M - MaleF - Female | The gender of an individual is typically gathered from self-reported or public information sources, or can be assigned based on the individuals name and/or title. In cases where the individual’s first name and title are unknown/ambiguous and no additional sources reflect gender, the gender will be coded as NULL |
| AGE | INTEGER | Estimated Age: 18-99 | Adult Estimated Age is calculated from date of birth data. Age data is applied at the individual level and is compiled from a variety of sources that may include public data, buying activities, and self-reported information. This is a calculation of age based on the individual’s year of birth. The calculation is current year minus the YOB. |
| DOB | VARCHAR | Date of Birth: 6-digit DOB (YYYYMM) or 4-digit DOB (YYYY) | The known month and Year of birth of the individual and date where availabe; in some cases where the birth month is unknown, this field value may contain only the 4 digit birth year. The Adult Date of Birth select will identify members of the household that meet the given birth date criteria. Dates must be entered for the birth month and year. Age data is applied at the individual level and is compiled from a variety of sources that may include public data, buying activities, and self-reported information. Exact age data is considered sensitive in nature and may require contractual restrictions. |
| ADDRID | VARCHAR | Up to 32-character Alphanumeric Address ID | Persistent ID assigned to addresses identified in the Infutor Graph |
| ADDRESS | VARCHAR | Full Address | All address components, including House Number, Directional, Street Name, etc. |
| HOUSE | VARCHAR | House Number: Can contain numbers, letters and characters (- and /) | Physical Street Number |
| PREDIR | VARCHAR | Street PreDirectional: E, N, NE, NW, S, SE, SW, W | An address element that indicates geographic location such as N, S, E, W, NE, NW, SE, and SW that is placed to the left of (before) the street name such as E HOOVER ST. |
| STREET | VARCHAR | Street Name, PO Box Name, RR # Box Name, or HC # Box Name | Information found in the primary name field of the USPS ZIP+4 file that identifies the street and forms the principal component of the delivery address line. A street name can include qualifiers such as directionals (e.g., North, SE) before or after the street name and suffixes (e.g., ST, AVE). Street names can be words or numbers. |
| STRTYPE | VARCHAR | Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc | An address component that qualifies the street name by type of street such as AVE (avenue), DR (drive), or RD (road). Sometimes a street may have a double suffix such as AVENUE DR. |
| POSTDIR | VARCHAR | Street Post Direction: E, N, NE, NW, S, SE, SW, W | An address element that indicates geographic location such as N, S, E, W, NE, NW, SE, and SW that is placed to the right of (after) the street name or street name suffix such as BAY DR W. |
| APTTYPE | VARCHAR | Unit Designator: APT, STE, UNIT, etc. | An address element in the delivery address line that indicates an apartment, office, suite, or some other division (e.g., 102 MAIN ST STE 202) |
| APTNBR | VARCHAR | Unit Number: Can contain numbers, letters and characters (- and /) | An address element in the delivery address line that indicates number of an apartment, office, suite, or some other division (e.g., 102 MAIN ST STE 202) |
| CITY | VARCHAR | City Name | As listed in USPS Publication 26, Directory of Post Offices. Post Office names in excess of 28 positions have been abbreviated by USPS. |
| STATE | VARCHAR | State Abbreviation: AL, FL, IL, NY, etc. | Two-position alpha FIPS State code |
| ZIP | VARCHAR | Zip Code: Five digit numbers only, e.g. 60614 | Five-position numeric as assigned in USPS publication 65, National Zip Code Directory |
| Z4 | VARCHAR | Zip+4 Code: Four digit numbers only, e.g. 5392 | Four-position numeric as assigned in USPS Publication 65, National Zip Code Directory |
| DPC | VARCHAR | Delivery Point Code with Check Digit | Delivery Point Code with Check Digit |
| Z4TYPE | VARCHAR | Zip+4 Type:F - Firm or company addressG - General delivery addressH - High-rise or business complexP - PO Box addressR - Rural route addressS - Street or residential address | USPS Zip+4 Record Type |
| CRTE | VARCHAR | Carrier Route Code | Carrier Route Code |
| DPV | VARCHAR | Delivery Point Validation Code:Y - Address DPV confirmed for both primary and (if present) secondary numbersD - Address DPV confirmed for the primary number only, and secondary number information was missingS - Address DPV confirmed for the primary number only, and secondary number information was present but unconfirmedN - Both Primary and (if present) Secondary number information failed to DPV Confirm | Delivery Point Validation |
| VACANT | VARCHAR | Vacant:Y - Physical Address Identified by USPS as vacantN - Someone living at that address | Designation by USPS of a vacant property |
