Organization

The data model designed for the Organization entity type is used to create, update, and manage data about organizations that sells/distributes the medicinal product.

Table 1. Entity-Level Properties - Organization
Property Value
URI configuration/entityTypes/Organization
Label Organization
Description  
Abstract  
extendsTypeURI  
Name Attribute Type Sub-Attribute Name Data Type Description
Name Simple   String Business Name of an Organization
CompanyType Simple   String Company Type
TradeStyleName Nested TradeStyleName Nested Trade Style Names of an Organization
TradeStyleName Nested Type String Trade Style Name Type. For example, Tradestyle1, Tradestyle2 or Doing Business as Name.
TradeStyleName Nested OrganizationName String Trade Style Name of the Organization
TradeStyleName Nested LanguageCode String 3 Digit Language Code in which the name is recorded.
TradeStyleName Nested FormerOrganizationPrimaryName String Former Business Name
TradeStyleName Nested DisplaySequence String A numeric value used to identify the relative importance of this Organization Name compared to the other Organization Names for this organization that are of the same type (For example, Trading Style). The lower the importance level number, the more important (preferred) is an Organization Name.
DoingBusinessAsName Simple   String Doing Business As Name of an Organization. This attribute is marked for deprecation. Tradestyle Name Nested attribute should be used for storing all names.
CUSIP Simple   String CUSIP
Sector Simple   String Sector
Industry Simple   String Industry
FoundedYear Simple   Int Founded Year
EndYear Simple   Int End Year
IPOYear Simple   Int IPO Year
Ticker Nested Symbol String Ticker
Ticker Nested StockExchange String Stock Exchange
Identifiers Nested   String Nested Attribute for storing several identifiers of an Organization.
Identifiers Nested Type String Type
Identifiers Nested ID String ID
Identifiers Nested Status String Status
Identifiers Nested DeactivationReasonCode String Deactivation Reason Code
Identifiers Nested ActivationDate String Activation Date
Identifiers Nested DeactivationDate String Deactivation Date
Identifiers Nested ReactivationDate String Reactivation Date
StatusUpdateDate Simple   String Status Update Date
StatusReasonCode Simple   String Status Reason Date
Partner Reference   Reference Partner
Competitor Reference   Reference Competitor
OwnsOrRents Simple   String Owns or Rents
FacilitySizeInSqFeet Simple   Int A number specifying the overall space covered by the premises described by the Premises Type Text used by the subject at the address. For example, the 2000 in 2000 square meters.
EmailDomain Simple   String  
TaxID Simple   String  
LegalStatusCode Simple     Text that describes the legal form or structure of a business, as registered with government authorities. For example, partnership, corporation, private limited company, government department, or proprietorship. Possible values: Code Table 197; Code Table 0 (with a selection of 0 Unknown)
MarketabilityIndicator Simple   String When 'True' this means the record satisfies D&B marketability rules. When 'false' the record does not satisfy D&B marketability rules; however, there is no requirement to create this tag to represent this fact.
LegalDomicile       Legal Domicile
DnBFullReportDate Simple DnBFullReportDate   The date when a complete review of all Business Information Report data was updated about the business. The format of the field is YYYYMMDD. Report Date does not reflect the age of the business data of the report.
DnBLastUpdateDate Simple DnBLastUpdate Date Date The date when the subject's record was last updated on D&B's system.
OrganizationDetail Nested OrganizationDetail   Organization Details
OrganizationDetail Nested MemberRole String Text describing the Subject plays and the role as a member of an ownership structured family tree. For example, a branch, division, a parent, headquarters, subsidiary, global ultimate, domestic ultimate. Possible values: Subsidiary; Branch; Division; Headquarters; Parent; Domestic Ultimate; Global Ultimate.
OrganizationDetail Nested Standalone Boolean When 'true' this means organization is not a member of a legal family tree. This also means it cannot play the role of a subsidiary, parent, headquarters or branch; that is , FamilyTreeMemberRoleText cannot be present. When 'false' this means organization is a member of a legal family tree. In this condition the FamilyTreeMemberRoleText must be present.
OrganizationDetail Nested ControlOwnershipDate Date The date when the current owners took over this business.
OrganizationDetail Nested OperatingStatus String Text describing this organization's functional state / trading status. For example, active, out of business, dormant. Possible values: Out of Business; Active; Dormant; Out of business-Unfavorable; Out of business-Favorable; Ceased trading; Assumed Out of Business-Unable to Confirm Active Operations.
OrganizationDetailNested Nested StartYear Int The year when operations undertaken by the organization commenced.
OrganizationDetail Nested FranchiseOperationType String Text that denotes whether the franchise rights are operated by a company or directly by the franchisee; that is franchisee, franchisor.
OrganizationDetail Nested BoneyardOrganization Boolean When 'true' indicates that data on the company is no longer collected and was covered by Hoover's Editorial staff before getting acquired or going out of business. When 'false' indicates that data on the company is still collected.
OrganizationDetail   OperatingStatusComment   Free form text which records the summary of the company's trading status.
IndustryCode Nested   Nested Industry Code
IndustryCode Nested DNBCode String DnB Code
IndustryCode Nested IndustryCode   An alphanumeric value identifying a business activity based on the scheme specified by the typeText. For instance, 1611 represents the highway and street construction industry in the U.S. SIC (Standard Industrial Classification) system. Clarification. Note: These are generally external codes created by an external authoritative body, like the U.S. Office of Management and Budget (OMB), but D&B may have created extensions to more precisely define an activity, as in the case of the SIC 2+2 (the last 4 digits of an 8-digit SIC).
IndustryCode Nested IndustryCodeDescription String Text that describes the business activity based on the scheme specified by the attribute typeText. For example, 'highway and street construction' is the description of industry code 1611 in the U.S. SIC (Standard Industrial Classification) system.
IndustryCode Nested IndustryCodeLanguageCode String (3) Digit Language Code Associated with the Industry Code
IndustryCode Nested IndustryCodeWritingScript String (4) Digit Writing Script Code
IndustryCode Nested DisplaySequence Int A number which may be used to define the order in which this industry code should be presented relative to other industry codes of the same type where the lower the number the earlier the data is presented.
IndustryCode Nested SalesPercentage Number The value of annual sales which are attributable to the operations defined by Industry Code Number as a percentage of total annual sales.
ActivitiesAndOperations Nested ActivitiesAndOperations   Organization Activities and Operations
ActivitiesAndOperations Nested LineOfBusinessDescription String Records the textual description of operations continued by a business.
ActivitiesAndOperations Nested LanguageCode String 3 Digit Language Code associated with this information.
ActivitiesAndOperations Nested WritingScriptCode String Writing Script associated with this information
ActivitiesAndOperations Nested ImportExportAgent String Import Export Agent
ActivitiesAndOperations Nested ImportIndicator Boolean When 'true' indicates that the subject company imports a quantity of goods from other countries.
ActivitiesAndOperations Nested AgentIndicator   When 'true' indicates that the subject acts as an agent promoting the goods or services of another organization. For example, Sales Agent, Purchasing Agent. When 'false' indicates that the subject does not act as an agent of another organization.
EmailDomain String Type String  
Email Nested Email Nested Email
Email Nested Rank Int Rank
Email Nested Type String Type
Email Nested Active Boolean Active
Email Nested Domain String Domain
Email Nested DomainType String Domain Type
Email Nested Username String Username
Email Nested Validation Status String Validation Status
EmployeeDetails Nested     Employee Details
EmployeeDetails Nested IndividualEmployeeFiguresDate    
EmployeeDetails Nested IndividualTotalEmployeeQuantity   A number that defines how many people are directly engaged and paid by the organization to perform or support its business operations.
EmployeeDetails Nested IndividualReliabilityText   Text that describes the integrity of the employee figures. For example, audited, actual, estimated, modeled.
EmployeeDetails Nested TotalEmployeeQuantity   A number that defines how many people are directly engaged and paid by the organization to perform or support its business operations.
EmployeeDetails Nested PrincipalsIncluded   Y=Included N=Not included
Ownership Simple   String  
ManualVerificationFlag Simple   Boolean If set to True, this profile will be selected for verification and enrichment by the batch program that will enrich this profile from an external source. For example, Dun & Bradstreet.
DoNotEnrich Simple   Boolean If set to True, this profile will not be selected for matching or enrichment from an external source.
VendorVerification Nested   Nested Recent Verification Status from an external source.
VendorVerification Nested VendorVerificationDate Date The date and time when this profile was last matched or enriched from an external vendor source.
VendorVerification Nested VendorVerificationStatus String The status value indicates the results of the matching and enrichment from an external source. Matching statuses are Match, No Match, and Match Error. Data enrichment statuses are Enriched, and Enrichment Error.
IsSubsidiary Simple   String 1 Digit. Indicates whether the subject business is more than 50% owned by another organization. Possible values are 0 = Not a subsidiary. 3 = Is a Subsidiary.
DUNSNumber Simple   String The D-U-N-S Number is D&B's identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S).
DnBGlobalUltimateIndicator Simple   String Global Ultimate Indicator. Possible values are Y=Global Ultimate, N=Not Global Ultimate.
DnBNumberOfFamilyMembersSimple Simple   Int DnB Number of Family Members
DnBDIASCode Simple   String DnB Dias Code
DnBHierarchyCode Simple   String Hierarchy Code
DUNSHierarchy Nested   Nested DUNS Hierarchy Information
DUNSHierarchy Nested GlobalUltimateDUNS String The D-U-N-S Number is D&B's identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S).
DUNSHierarchy Nested GlobalUltimateOrganization String Text recording a name of this organization in the specified language and/or writing script.
DUNSHierarchy Nested DomesticUltimateDUNS String The D-U-N-S Number is D&B's identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S).
DUNSHierarchy Nested DomesticUltimateOrganization String Text recording a name of this organization in the specified language and/or writing script.
DUNSHierarchy Nested ParentDUNS String The D-U-N-S Number is D&B's identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S).
DUNSHierarchy Nested ParentOrganization String Text recording a name of this organization in the specified language and/or writing script.
DUNSHierarchy Nested HeadquartersDUNS String The D-U-N-S Number is D&B's identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S).
DUNSHierarchy Nested HeadquartersOrganization String Text recording a name of this organization in the specified language and/or writing script.
IsManufacturing Simple   String Is this a manufacturing Organization Possible values are 0=Manufacturing 1=Non manufacturing.
IsMinorityOwnedSimple Simple   String Is this a Minority Owned organization Possible values are Y=true N=false.
IsPublicPrivate Simple   String Is this a Public or a Private organization. Possible values are Y=Public N=Private
FinancialStatement Nested   Nested Financial Statement Information
FinancialStatement Nested Type String Type of Financial Statement. For example, Balance Sheet.
FinancialStatement Nested CurrencyCode String The three-letter code, published by International Organization for Standardization (ISO), identifying the type of money that is primarily used by this subject.
FinancialStatement Nested CurrencyUnitOfSize String Text which identifies the unit of size in which the financial summary figures are provided. For example, in 1,000s; in 1,000,000s. The financial figures should be populated to the record with the 000's or 000,000's omitted. For example, If Sales are 54398 with 000's omitted then the figure of 54398 (NOT 54398000) should be populated.
FinancialStatement Nested StatementYear String The date when the accounting period ended. If the Reliability Code denotes the figures are projected (future), then this is the date when the accounting period will end.
FinancialStatement Nested FinancialPeriodDuration String Records the period of the Financial Summary when this cannot be expressed using 'Summary Date' and 'Number of Months'.
FinancialStatement Nested TotalAssetsAmount Number The combined value of Total Current Assets and Total Long Term Assets. This, therefore, includes all of the assets used by an organization; no matter how they are financed.
FinancialStatement Nested TotalLiabilitiesAmount Number The combined value of Total Current Liabilities and Total Long Term Liabilities. This, therefore, includes all of the liabilities of an organization no matter how they are incurred.
KeyFinancialFiguresOverview Nested KeyFinancialFigures Nested A nest of data which can repeat multiple times to record highlights of the financial statements (Balance sheet, Income statement, cash flow statement and so on) across years and gives a snapshot view of how the company has been performing on items in these financial statements.
KeyFinancialFiguresOverview Nested FinancialStatementToDate Date The date when the accounting period ended. If the Reliability Code denotes the figures are projected (future), then this is the date when the accounting period will end.
KeyFinancialFiguresOverview Nested FinancialPeriodDuration String Records the period of the Financial Summary when this cannot be expressed using 'Summary Date' and 'Number of Months'.
KeyFinancialFiguresOverview Nested SalesRevenueCurrency String Three digit currency code for recording Sales Revenue.
KeyFinancialFiguresOverview Nested SalesRevenueCurrencyCode String Sales Volume Reliability Code
KeyFinancialFiguresOverview Nested SalesRevenueReliabilityCode String Sales Volume Reliability Code
KeyFinancialFiguresOverview Nested SalesRevenueUnitOfSize String Text which identifies the unit of size in which the financial summary figures are provided. For example, in 1,000s; in 1,000,000s. The financial figures should be populated to the record with the 000's or 000,000's omitted. For example, If Sales are 54398 with 000's omitted then the figure of 54398 (NOT 54398000) should be populated.
KeyFinancialFiguresOverview Nested SalesRevenueAmount Number The monetary value of income received from customers from the sale of the business' goods and/or services. This means it is the gross sales minus any returns, rebates/discounts, allowances for damages or shortages, shipping expenses passed on to the customer, and amounts due where there is not a reasonable expectation of collection.
KeyFinancialFiguresOverview Nested ProfitOrLossCurrency String Profit Or Loss Currency
KeyFinancialFiguresOverview Nested ProfitOrLossReliabilityText String Profit Or Loss Reliability Text
KeyFinancialFiguresOverview Nested ProfitOrLossUnitOfSize String Profit or Loss Unit of Size
KeyFinancialFiguresOverview Nested ProfitOrLossAmount Number Profit Or Loss Amount
KeyFinancialFiguresOverview Nested SalesTurnoverGrowthRate Int Sales Turnover Growth Rate
KeyFinancialFiguresOverview Nested Sales3YryGrowthRate Int Sales Three Year Growth Rate
KeyFinancialFiguresOverview Nested Sales5YryGrowthRate Int Sales Five Year Growth Rate
KeyFinancialFiguresOverview Nested Employee3YryGrowthRate Int Employee Three Year Growth Rate
KeyFinancialFiguresOverview Nested Employee5YryGrowthRate Int Employee Five Year Growth Rate
Phone Nested   Nested Phone
Phone Nested Type String Type
Phone Nested Number String Number
Phone Nested Unreachable String Unreachable
Phone Nested CountryCode String Country Code
Phone Nested Extention String Extension
Phone Nested Formatted Number String Formatted Number
Phone Nested Rank Int Rank
Phone Nested Area Code String Area Code
Phone Nested Local Number String Local Number
Phone Nested Validation Status String Validation Status
Phone Nested Line Type String Line Type
Phone Nested Format Mask String Format Mask
Phone Nested Digit Count Int Digital Count
Phone Nested Geo Area String Geo Area
Phone Nested Geo Country String Geo Country
Phone Nested Active Boolean Active