Exporting People data - Column definitions

The below table contains definitions for each of the columns present in a People Data export (either from your watchlist or from the Prospector tool).

Please see this article for the definitions of the Company data export.

* Please note that the address supplied within this data is the entity's Registered address. We do not currently display both Registered and Trading addresses in these exports.

Column	Description
Registration Number	Unique number assigned to the company by Companies House.
Salutation	The Salutation of the contact, e.g. Mr
First Name	The Forename of the contact.
Second Name	The second name of the contact.
Third Name	The third name of the contact.
Initials	The first name initial for the contact.
Surname	The Surname of the contact.
Date Of Birth	The Date of Birth for the Director as shown on the Annual Return document.
Gender	A textual description of the gender of the contact, or an indicator that the director is a company, e.g. Male, Female, Company, or NULL.
Age	The age of the contact, derived from the date of birth.
Sole Director	Sole director flag, TRUE or FALSE.
Principal Contact At Site	This contact is the principal contact at site based on a hierarchy using job title to select the most appropriate contact for the given location, TRUE or FALSE.
Address Line 1	The first standard address line for the director’s address (or company secretary).
Address Line 2	The second standard address line for the director’s address (or company  secretary).
Address Line 3	The third standard address line for the director’s address (or company secretary).
Town	The town for the director’s address (or company secretary).
County	The county for the director’s address (or company secretary).
Postcode	The Postcode for the director’s address (or company secretary).
Region	The Geographical Region of the UK, derived from the Postcode, e.g. 'East Anglia', 'South West', etc.
Opted In To Mail Preference Service	A Y/N flag indicating whether the company is registered on the Mail Preference Service suppression file. 'Y' - Registered on MPS, 'N' or empty - Not registered on MPS.
Director Service Address Ind	Director Service Address indicator shows whether the address provided is a service address, TRUE or FALSE.
Job Title Role	The job title for the contact held on file, e.g. 'Academics'; 'Clergy'; 'Finance'; 'Fleet'; 'HR', etc.
Job Function	A high-level description of the job family of the contact.
Source Job Title Role	The job title of the director as stated on the Annual Return.
Title	The title for the director as stated on the Annual Return.
Director	Director flag indicating whether the contact is a director of the company or not, TRUE or FALSE
Company Secretary	Company Secretary flag indicator showing whether the contact is a company secretary of the company or not, TRUE or FALSE.
Nationality	The nationality for the director as stated on the Annual Return.
Directors Occupation	The occupation of the director as stated on the Annual Return.
Qualifications	The qualifications of the director as stated on the Annual Return.
Shares Flag	Shares flag indicator showing whether the director is also a shareholder or not, TRUE or FALSE.
Shares Text	A textual description of the values of the shareholding of the director.
Contact Tel Area Code	The STD telephone area code for the telephone number of the contact.
Contact Tel Number	The telephone number for the contact.
Opted in to Telephone Preference Service	Opted in to Telephone Preference Service indicator showing whether the location is registered on the Telephone Preference Service suppression file, TRUE (you cannot call), FALSE or no value.
Email	The e-mail address of the contact.
Email Type	An indicator to determine whether the e-mail address for the contact is named or generic, e.g. 'Named', 'Named/Generic'.
Location Type	Whether the location type is the 'HeadOffice', 'Branch', 'SingleSite', or 'None' location of a business.
Company Name	The Registered Company Name as filed at Companies House.
Company Address 1*	The first company standard address line for the location.
Company Address 2*	The second company standard address line for the location.
Company Address 3*	The third company standard address line for the location.
Company Town*	The company town for the location.
Company County*	The company county for the location.
Company Region*	The Company Geographical Region of the UK, derived from the Postcode, e.g. 'East Anglia', 'South West', etc.
Company Postcode*	The Company Postcode for the location.
Company District*	The Company Outer Postcode, containing the first half of the postcode, e.g. RG12
Company Mail Preference Service	A TRUE/FLASE flag indicating whether the company is registered on the Mail Preference Service suppression file. 'TRUE' - Registered on MPS, 'FALSE' or empty - Not registered on MPS.
Company Full Telephone Number	The full company telephone number, including dialling code that Thomson or Yell hold for the business.
Company Telephone Preference Service	A TRUE/FALSE flag indicating whether the company is registered on the Telephone Preference Service suppression file. 'TRUE' - Registered on TPS, 'FALSE' or empty - Not registered on TPS.
Location Type	Whether the location type is the 'HeadOffice', 'Branch', 'SingleSite', or 'None' location of a business.
Corporate Position	Indicates the position of the business within the corporate tree, e.g. Independent, Ultimate Parent, Intermediate Parent, Subsidiary
Employee Count	The number of employees for the business as a whole. Number could be an estimate.
Employee Count Estimated	Is the Employee Count an estimate? TRUE or FALSE
Currency Code	Currency that this set of accounts is displayed in.  Standard currency code as controlled by the International Organisation for Standardisation, e.g. GBP.
Turnover Value	The Total Turnover value for the business over the accounting period, whether actual or an estimate.
Turnover Estimated	Is the Turnover an estimate? TRUE or FALSE
Net Worth Value	The Net Worth of the business is an indication of the company’s long-term solvency.  This field forms a check that the company’s Shareholders Funds exceed Intangible Assets, i.e. is the company considered to have covered net losses in the longer term? This can be an actual or an estimated value.
Net Worth Estimated	Is the Net Worth an estimate? TRUE or FALSE
Pre Tax Profit	Pre-Tax Profit/Loss is the net trading profit (or loss) after deduction of all operating expenses, but before the deduction of Tax or Dividends, whether actual or an estimate.
Pre Tax Profit Estimated	Is the Pre-Tax Profit or Loss an estimate? TRUE or FALSE
Cash at Bank	This is the book balance of the cash on hand, and any positive current account balance, at the Balance Sheet date.
Hire Purchase Current	Hire Purchase (Current): The total amount of money tied up in Hire Purchase agreements. This figure appears in the Current Liabilities section of the Balance Sheet for monies covering the next 12 months.
Leasing Current	Leasing (Current Liabilities): The total amount of money tied up in Leasing arrangements. This may include rented property and equipment. This figure appears in the Current Liabilities section of the Balance Sheet.
Current Liabilities	Liabilities that have to be paid within the next 12 months.
Total HP And Leasing Long Term	Hire Purchase & Leasing (Long Term Liabilities): The total amount of money tied up in Hire Purchase agreements. This figure appears in the in the Long Term Liabilities section for those items covering period for monies due after the next 12 months.
Fiscal Year End	The last month of the year end for the company.
Latest Return Date	The date of the latest Annual Return filed at Companies House. Format DD/MM/YYYY 00:00
Latest Accounts Date	The date of the latest accounts filed at Companies House. Format DD/MM/YYYY 00:00
Cro Legal Status	A textual description of the legal status of the business. See Legal Status Reference Table
Age Years	The age, in years, of the business calculated from the earliest known date.
Auditors Name	Auditor Name
Bank Name	Bank Name
Delphi Score	The Experian commercial developed scorecard, scoring from 0-100, predicting the likelihood of business failure within the subsequent 12-month period. 100 equals no chance of business failure.
Delphi Credit Rating	The Experian commercial recommended maximum monthly credit exposure for the business.
Delphi Credit Limit	The Experian commercial recommended maximum outstanding credit exposure for the business.
Delphi Risk Band	An indicator to determine the commercial risk band assigned to the business by Experian, e.g. Risk Score Suppressed, Dissolved/Serious Advers Info, Maximum Risk, High Risk, Abover Average Risk, Below Average Risk, Low Risk and Minimum Risk.
Delphi Star Rating	The Experian Commercial Delphi Risk Band expressed as a 0-5 star rating. 5 is good.
1992 SIC Code 1	The 4-digit Standard Industry Classification (1992 version) for the business as a whole.
1992 SIC Code 1 Text	The description attributed to the first listed SIC Code (1992 version) for the business.
1992 SIC Code 2	The 2nd listed 4-digit Standard Industry Classification (1992 version) for the business as a whole.
1992 SIC Code 2 Text	The description attributed to the second listed SIC Code (1992 version) for the business.
1992 SIC Code 3	The 3rd listed 4-digit Standard Industry Classification (1992 version) for the business as a whole.
1992 SIC Code 3 Text	The description attributed to the third listed SIC Code (1992 version) for the business.
1992 SIC Code 4	The 4th listed 4-digit Standard Industry Classification (1992 version) for the business as a whole.
1992 SIC Code 4 Text	The description attributed to the fourth listed SIC Code (1992 version) for the business.
Broad Sectors	12 Experian defined business sectors derived from the businesses SIC 2007 Codes.
2007 SIC Code Group 1	First 3-digit Standard Industry Classification Group code and description (2007 version) for the business at all locations.
2007 SIC Code Group 2	Second 3-digit Standard Industry Classification Group code and description (2007 version) for the business at all locations.
2007 SIC Code Group 3	Third 3-digit Standard Industry Classification Group code and description (2007 version) for the business at all locations.
2007 SIC Code Group 4	Fourth 3-digit Standard Industry Classification Group code and description (2007 version) for the business at all locations.
2007 SIC Code 1	First Full Standard Industry Classification Code and description (2007 version) for the business at all locations.
2007 SIC Code 2	Second Full Standard Industry Classification Code and description (2007 version) for the business at all locations.
2007 SIC Code 3	Third Full Standard Industry Classification Code and description (2007 version) for the business at all locations.
2007 SIC Code 4	Fourth Full Standard Industry Classification Code and description (2007 version) for the business at all locations.
Principal Activity	The principal activities of the business, as described on the annual accounts.
Care Homes Flag	TRUE/FALSE Flag: is the business a care home?
Central Government Flag	TRUE/FALSE Flag: is the business part of Central Government?
Charity Flag	TRUE/FALSE Flag: Is the business a charity?
Defence Flag	TRUE/FALSE Flag: Is the business part of the military?
Emergency Services Flag	TRUE/FALSE Flag: is the business part of the Fire, Police or Ambulance services?
Hospitals Flag	TRUE/FALSE Flag: is the business a hospital?
Local Government Flag	TRUE/FALSE Flag: is the business part of local government?
Limited Companies	TRUE/FALSE Flag: The business is a limited company.
Non Limited Business Flag	TRUE/FALSE Flag: The business is a non-limited company.
Non Limited Group Flag	TRUE/FALSE Flag: The business is a group of non-limited companies.
Public Services Flag	TRUE/FALSE Flag: does the business provide a public service?
Schools Universities Flag	TRUE/FALSE Flag: is the business a school or university?
Total Tangible Fixed Assets	The total value of the company’s buildings, vehicles, equipment, fixtures and fittings. In general, assets held by the business for use in generating sales.
Total Stocks / Work In Progress	The value of stock held by the company. This includes goods or other assets purchased for re-sale, consumable stores, raw materials, finished goods and payments on accounts for items yet to be received. When looking at Stock it is important to recognise that not all items are intended for re-sale, e.g. consumable stores, like oil for machines, are included but will never be sold; they simply assist in the running of the business, plus Work in process (WIP) is the value of a company's partially finished goods waiting for completion and eventual sale.
Trade Debtors	The total amount of money owed to the company for sales rendered.
Total Long Term Liabilities	Liabilities that have to be paid further than the next 12 months.
Plant & Vehicles	The total value of plant and vehicle equipment owned by the company.
Current Ratio	The worth of a company derived as Current Assets divided by Current Liabilities. This ratio roughly measures a company’s financial risk. Logically the more the financial liabilities, the riskier the company. Thus, small Current Ratio values indicate high risk. Less than 1 is possibly a problem, around 2 is ideal, too big may be a sign of inefficiency.
Acid Test	The Acid Test is a measure of the company’s liquidity and is derived by deducting Stocks and Work In Progress from Current Assets. This figure is then divided by Current Liabilities. This approach is cautious as it recognises that stock is not always readily converted into cash at full value. An Acid test ratio of 0.75:1 or greater is preferred.
Working Capital By Sales	Percentage of annualised Turnover against Working Capital. Demonstrates the surplus or deficit of funds from normal trading activities, in relation to the company’s size measured by sales. Calculation: 100 * Working Capital / (52 * Total Turnover / Accounting Period).
Credit Period	Also known as Collection Period, measures the days a company takes to pay its debts, therefore assessing the effectiveness of the company’s credit control department. Calculation: 365 * Total Debtors / (52 * Total Turnover / Accounting Period)
Trade Creditors By Debtors Ratio	The ratio of trade creditors to trade debtors. Calculation: Trade Creditors / Total Debtors.
Auditor Fees	Auditor Fees is the Amount that the auditor was paid.
Growth Indicator	An indicator to determine whether the business is in growth or decline. Values can be Decline, Growth, Static or Unknown.
Mortgage Indicator	A Yes/No flag indicating the presence of a mortgage registered against the company, e.g. 'Y' - Mortgage registered against limited company, 'N' - No mortgage registered or non-limited business.
Domain	The website we have on record for the company.
EBIT	Earnings Before Interest and Taxes. This is calculated as EBITDA (see below) - Depreciation - Amortisation.
EBITDA	Earnings Before Interest, Taxes, Depreciation, and Amortization. This is calculated as Total Turnover - Cost of Sales - Total Expenses.
EBITDA Post Dividends	The former, once any dividends (distribution of profits to shareholders) have been applied.