• Read more about Automated Data Cleansing from Foundation Technology.

KnownColumnTypes

Definition

            public enum KnownColumnTypes
            {
                Ignore,
                FullName,
                Title,
                FirstName,
                OtherName,
                Surname,
                Address1,
                Address2,
                Address3,
                Address4,
                Address5,
                Address6,
                Postcode,
                Telephone,
                CompanyName,
                Identifier,
                Email,
                Country
            }
        

Description

Identifies the type of information stored in a FormatColumn.

Each FormatColumn in a FileFormat must have one of these column types.

• Ignore - the information in this column is not used for the data cleansing process and will be passed through unchanged.
• FullName - this column contains a full individual name, e.g. "Mr John Smith". The individual parts of the name in the column will be split out automatically to enable matching to our reference data.
• Title - this column contains an individual's title, e.g. "Mr".
• FirstName - this column contains an individual's forename(s) or initial(s), e.g. "John", "J M" or "JM". If more than one forename is supplied, only the first will be used for matching.
• OtherName - this column contains additional (middle) names or initals, e.g. "Peter" or "RJ".
• Surname - this column contains an individual's surname, e.g. "Smith".
• Address1 - this column contains the first line of an address.
• Address2 - this column contains the second line of an address.
• Address3 - this column contains the third line of an address.
• Address4 - this column contains the fourth line of an address.
• Address5 - this column contains the fifth line of an address.
• Address6 - this column contains the sixth line of an address.
• Postcode - this column contains a postcode.
• Telephone - this column contains a telephone number.
• CompanyName - this column contains an organisation name.
• Identifier - this column contains a unique identifier for the record, e.g. "1", "2", "ABC001", "{521EE725-8DBF-4906-BC48-7875BAD8538F}".
• Email - this column contains an email address.
• Country - this column contains a country name or code, e.g. "United Kingdom", "USA", "FR".

Column Type Restrictions

When the DataType of the FileFormat is set to Residential, a column may not be set to CompanyName.

With the following exceptions, only one column in each FileFormat may be set to each KnownColumnType value:

• Ignore
• Telephone
• Email

If a FullName column is supplied, the FirstName, OtherName and Surname columns cannot be used and vice versa.

If the address in the source data is split over more than six columns, the client application should combine them into at most six columns with the data separated by commas.

Although any number of columns can be specified as Telephone numbers, only the first three telephone number columns will be screened against the telephone preference service.

At least a Surname column must be supplied for the majority of residential cleansing services to work correctly; both a FirstName and Surname column or FullName column are recommended.

At least a CompanyName column must be supplied for the majority of business cleansing services to work correctly.

File Format Store documentation