EDRS-CommonTypes-v1-3

Version 1.3

Introduction

The schema is initially designed to support the activities of the Employer Data Service operated by the Learning and Skills Council. The service provides employer workplace data for England.

Dependencies

The schema draws on existing GovTalk schemas wherever possible, making use of existing types:

  • CommonSimpleTypes (v1.3)
    (
    DateType, EmailAddressType, TelephoneNumberType
  • OrganisationIdentifierTypes (v1.1)
    (
    OrganisationNameType, CompaniesHouseReferenceNumberType, StandardisedIndustrialClassificationNumberType
  • BS7666 (v2.0)
    (
    PostCodeType, LocalityType

Additionally, use is made of the LSC’s common library:

  • LSCCommonLibrary (v1.0)
    (
    Types: UkprnType

Updates

  • Addition of HierarchyStructure
    Types

URNType

The Unique reference Number for the employer.

Numbers starting with a 1 have been sourced through commerical data providers while those prefixed with a 9 were created as a result of requests from users of the service following verification.

The URN includes a modulus 11 check digit.

BlueSheepWorkplaceIdType

The unique identifier used by Blue Sheep for the workplace.

OriginalSourceIdType

The unique identifier used by original data supplier to identify the record.

These follow no strict format as each supplier operates their own nomenclature.

WebSiteAddressType

Represents a simple web address.

BranchInformationType

Describes the relationship of the workplace within a larger group structure.

ThomsonCodeType

A 5 digit Thomson Directory code indicating the principle activity for the employer.

USSICCodeType

A 4 digit US Standard Industrial Code (SIC).

UKSICCodeBandType

A UK Standard Industrial Code (SIC) banding. Represents the primary sector of trading.

BlueSheepSICBandType

A UK Standard Industrial Code (SIC) sector based banding. Provides a more detailed description of the sector of activity based on the first 2 or three characters of a UK 92 SIC

EmployeeNumberBandType

A banding based on the number of employees.

EmployerSizeBandType

A broad banding based on the number of employees.

TurnoverBandType

A banding based on the turnover.

ProfitBandType

A banding based on the profit.

GrowthBandType

Represents the growth of the employer.

OfficeTypeType

Represents the relationship of the address to the organisation.

CreditBandType

A banded representation of the employer's credit worthiness.

LegalStatusType

Represents the legal status of the employer.

AccountsFilingMonthType

Represents the month that the employer's accounts are filed with Companies House.

OrganisationType

Represents the form of company (e.g. PLC, Ltd, Charity etc).

WorkplaceStatusType

Represents the status of the workplace.

valid = the record has been researched and confirmed to be valid

no-longer-valid = the employer work place is no longer valid, e.g. closed down

not-validated = the record is in the process or being researched to check its validity

aliased = the record is aliased elsewhere in the database, this record is therefore redundant

ValidationStatusType

Represents the validation status of the URN.

invalid = the URN does not exist

valid = the URN exists and the record is valid

no-longer-valid = the URN exists but the employer workplace it relates to is no longer valid (e.g. closed down)

not-validated = the URN exists but the record is still being validated

aliased = the URN no longer exists and has been replaced with the new URN

EmployerCategoryType

Represents the type and status of the employer. Provides a broader indication of the nature of the employer than is possible with the Legal Status

EmployerTypeType

An indication of the employer type and the primary source of funding.

Complex Types

FinancialInformationStructure

Contains basic financial information about the employer including accounts filing date, turnover, profit, net worth and number of employees.

ConciseEmployerStructure

This cut-down structure contains concise details of an employer record.

DetailedEmployerStructure

This standard structure contains the full details of an employer record.

ValidationResultStructure

This cut-down structure contains concise details of an employer record.

HierarchyStructure

This structure details the organisational hierarchy for an employer.

Samples

<DetailedEmployerStructure>

<URN>118409417</URN>

<Name>Learning &amp; Skills Council</Name>

<Address>

<PAON>Cheylesmore House</PAON>

<StreetDescription>Quinton Road</StreetDescription>

<PostTown>Coventry</PostTown>

<Postcode>CV1 2WT</Postcode>

</Address>

<Phone>02476823501</Phone>

<Fax>02476823675</Fax>

<WebSite>

<Email />

<PrincipleActivity>Training &amp; Enterprise Council</PrincipleActivity>

<Importer>no</Importer>

<Exporter>no</Exporter>

<BlueSheepWorkplaceId>10031931</BlueSheepWorkplaceId>

<BlueSheepSourceId>CD697925</BlueSheepSourceId>

<IncorporationDate>1900-01-01</IncorporationDate>

<EstablishedDate>2001-03-01</EstablishedDate>

<BranchInformation>single-site</BranchInformation>

<SIC92Code>75120</SIC92Code>

<SIC92Code>91330</SIC92Code>

<SIC92Code>63300</SIC92Code>

<SICBand>service</SICBand>

<SIC80Code>91110</SIC80Code>

<SICUS>9999 </SICUS>

<BlueSheepSICBand>751 </BlueSheepSICBand>

<ThompsonCode>29300</ThompsonCode>

<SiteEmployees>600</SiteEmployees>

<SiteEmployeesBand>from-301-1000</SiteEmployeesBand>

<SiteTurnover>0</SiteTurnover>

<SiteTurnoverBand>upto-9k</SiteTurnoverBand>

<GroupEmployees>0</GroupEmployees>

<GroupEmployeesBand>unknown</GroupEmployeesBand>

<GroupTurnover>0</GroupTurnover>

<GroupTurnoverBand>unknown</GroupTurnoverBand>

<GroupProfit>0</GroupProfit>

<GroupProfitBand>unknown</GroupProfitBand>

<GrowthBand>healthy</GrowthBand>

<OfficeType>unknown</OfficeType>

<CompanyRegistration />

<ParentCompanyRegistration />

<ParentCompanyName />

<UtlimateCompanyRegistration />

<UtlimateCompanyName />

<CreditBand>unclassfied</CreditBand>

<LegalStatus>public</LegalStatus>

<AccountsFilingMonth>unknown</AccountsFilingMonth>

<WorkplaceStatus>valid</WorkplaceStatus>

<EmployerSizeBand>unknown</EmployerSizeBand>

<EmployerCategory>unknown</EmployerCategory>

<EmployerType>charity-or-voluntary-sector-organisation</EmployerType>

<UKPRN>0</UKPRN>

<CurrentFinancials>

<AccountsFiled>1900-01-01</AccountsFiled>

<Turnover>0</Turnover>

<PreTaxProfit>0</PreTaxProfit>

<NetWorth>0</NetWorth>

<EmployeeCount>0</EmployeeCount>

</CurrentFinancials>

<Previous1Financials>

<AccountsFiled>1900-01-01</AccountsFiled>

<Turnover>0</Turnover>

<PreTaxProfit>0</PreTaxProfit>

<NetWorth>0</NetWorth>

<EmployeeCount>0</EmployeeCount>

</Previous1Financials>

<Previous2Financials>

<AccountsFiled>1900-01-01</AccountsFiled>

<Turnover>0</Turnover>

<PreTaxProfit>0</PreTaxProfit>

<NetWorth>0</NetWorth>

<EmployeeCount>0</EmployeeCount>

</Previous2Financials>

<ChangesPending>no</ChangesPending>

<SkillsPledgeEmployees>10</SkillsPledgeEmployees

<UltimateEmployees>100</UltimateEmployees

<OrganisationType>charity</OrganisationType

</DetailedEmployerStructure>

<ValidationResultStructure>

<TestedURN>118409417</TestedURN>

<CorrectedURN>118409417</CorrectedURN>

<ValidationStatus>valid</ValidationStatus>

</ValidationResultStructure>

<ConciseEmployerStructure>

<URN>118409417</URN>

<Name>Learning &amp; Skills Council</Name>

<Address>

<PAON>Cheylesmore House</PAON>

<StreetDescription>Quinton Road</StreetDescription>

<PostTown>Coventry</PostTown>

<Postcode>CV1 2WT</Postcode>

</Address>

<Phone>02476823501</Phone>

<SiteEmployees>600</SiteEmployees>

<GroupEmployees>0</GroupEmployees>

<ChangesPending>no</ChangesPending>

<WorkplaceStatus>valid</WorkplaceStatus>

</ConciseEmployerStructure>

HierarchyStructure>

<URN>118409417</URN>

<Name>Learning &amp; Skills Council</Name>

<Level0</Level

</HierarchyStructure >