Exporting People data - Column definitions

Follow

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.
Have more questions? Submit a request