Business Data Model Data Model

Entity

Entity Organization

Description

A specific legal entity. Examples include a corporation, corporate unit, not-for-profit corporation, government or governmental subdivision or agency, business trust, estate, trust, partnership or association, two or more persons having a joint or common interest, or any other legal entity.

Attributes
Accounting Period End Date
Accounting Period Start Date
Annual Revenue
Boarded Ind
Company Type
Competitor Ind
Display Name
Dissolution Date
DUNS Num
End Date
External Ind
Fiscal Year End
Foundation Date
Franchised Ind
GL Business Unit Cd
GL Department Cd
GL Location Cd
HIBCC Subscriber Ind
HIN Status
Industry Classification
Language
Listed Exchange
Member Ind
Membership Fee
Minority Owned End Date
Minority Owned Ind
Minority Owned Start Date
Number Of Customers
Number Of Employees
Number Of Members
Number Of Outlets
Org Abbr
Organizational Structure
Organization Legal Form
Organization Name
Organization Primary Service
Organization Purpose
Organization Size Cnt
Organization Status
Organization Status Reason
Organization Type
Org Descr
Profit After Tax
Public Private Ind
Receive Direct Mail Ind
Reprocessor Ind
Revenue
Small Business End Date
Small Business Ind
Small Business Start Date
Staffing Type
Turnover
Veteran Owned End Date
Veteran Owned Ind
Veteran Owned Start Date
Woman Owned End Date
Woman Owned Ind
Woman Owned Start Date

Relationship
Organization Hierarchy
contact Representative
Organization_NotificationReceiver_FK
Organization_MaterialIdentifier_FK

Generalization
Party Generalization

Dependencies
NONE

Reverse Dependencies

Attribute Details

Accounting Period End Date

Description	Date upon which the accounting period of the organization ends. Indicates the last date for which account entries will be reported as within the accounting period.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Accounting Period Start Date

Description	Date upon which the accounting period of the organization starts.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Annual Revenue

Description	The approximate monetary amount of the organization's annual revenue. This is typically based on published accounts unless the organization is a subsidiary or affiliate of the modeled healthcare organization in which case revenue values may be derived from management accounts.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Boarded Ind

Description	Indicates that an organization has a board of directors.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Company Type

Description	Indicates the primary type of activity undertaken by the organization. For example: Mail Order Company Pharmacy Company
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Competitor Ind

Description	Indicates whether or not the organization competes with the modeled healthcare organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Display Name

Description	A name that is chosen to be used for identification purposes when interacting with others. This name can be different to the actual/legal name.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dissolution Date

Description	The date upon which this organization ceased to legally exist.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

DUNS Num

Description	The number assigned to the organization by Dun & Bradstreet.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

End Date

Description	The date upon which the organization becomes unavailable for use.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

External Ind

Description	Indicates if this organization is external or part of the modeling enterprise.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Year End

Description	The day and month upon which the company's fiscal year ends.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Foundation Date

Description	The date upon which the organization was founded or created.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Franchised Ind

Description	Indicates whether or not the organization has a franchise for one or more companies.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

GL Business Unit Cd

Description	Identifies the organization business unit for general ledger reference.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

GL Department Cd

Description	Identifies the organization department for general ledger reference.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

GL Location Cd

Description	Identifies the organization location for general ledger reference.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

HIBCC Subscriber Ind

Description	Indicates if the organization subscribes to the Health Industry Business Communication Council.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

HIN Status

Description	Indicates the status of the organization in the NIH Heart, Lung and Blood Institute Health Information Network (HIN).
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Industry Classification

Description	Indicates the classification of the organization within a recognized standard such as the North American Industry Classification System (NAICS).
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Language

Description	Identifies a language an individual can speak, read and / or write. May also identify the language or dialect in which a comment or text is recorded.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Listed Exchange

Description	Indicates the equity exchange the stock for this company is traded on.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Member Ind

Description	Indicates whether or not the organization is a member of the modeled alliance.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Membership Fee

Description	The monetary amount of a single fee paid to become a member of an organization or affinity group.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Minority Owned End Date

Description	The date upon which the organization lost its minority owned designation.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Minority Owned Ind

Description	Indicates that the organization is legally registered as minority owned.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Minority Owned Start Date

Description	The date upon which the company was registered as minority owned.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Customers

Description	A count of the customers dealing with the organization. This information is derived and its value depends on the organization's definition of what a customer is.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Employees

Description	A count of persons employed by the organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Members

Description	A count of people who are members of the organization. This number often is an approximate number, because the number of members may in general change over time without the modeled organization being brought up to date.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Outlets

Description	A count of the outlets (customer touch point locations) owned or operated by the organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Org Abbr

Description	An abbreviation of the organization name by which it is commonly referred to.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organizational Structure

Description	Indicates the nature of the ownership of an organization. For example: Stock Company Wholly Owned Cooperative Joint Venture
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Legal Form

Description	Indicates the legal form or structure of the organization. For example: Limited company Public limited company
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Name

Description	The legal name of the organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Organization Primary Service

Description	The main function the organization performs in the course of its business.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Purpose

Description	Indicates the purpose or format of the organization. For example: Supporting dangerous hobbies Travel assistance
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Size Cnt

Description	An expression of the scale of an organization based on the number of employees, members or participants in the organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Status

Description	Indicates the current state of the organization. It is used for all statuses other than foundation and dissolution. For example: Trading Liquidated
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Status Reason

Description	Indicates the reason why an organization is currently in a given organization status. For example: Risky investment Insolvent
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Type

Description	Indicates the type of organization. For example: corporation government non-profit
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Org Descr

Description	A textual description of the organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Profit After Tax

Description	The monetary amount of the most recently reported profit after tax for the company.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Public Private Ind

Description	Indicates whether the organization is publicly or privately funded. For example: Private Public
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Receive Direct Mail Ind

Description	Indicates if the company will receive direct mail or will need to be contacted via some parent organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Reprocessor Ind

Description	Indicates if the organization is identified as a reprocessor.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Revenue

Description	The monetary amount of the total income received by a company over a period of one year.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Small Business End Date

Description	Date upon which the organization lost the small business designation.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Small Business Ind

Description	Indicates that the organization is legally registered as a small business.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Small Business Start Date

Description	Date upon which the company was registered as a small business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Staffing Type

Description	Indicates the manner in which the organization is staffed. For example: Employees Family-Run Volunteers
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Turnover

Description	The frequency with which employees resign, are fired or retired from a company, usually computed as the percentage of a company's employees at the beginning of the calendar year.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Veteran Owned End Date

Description	Date upon which the organization lost the veteran owned designation.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Veteran Owned Ind

Description	Indicates that the organization is legally registered as veteran owned.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Veteran Owned Start Date

Description	Date upon which the company was registered as veteran owned.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Woman Owned End Date

Description	Date upon which the organization lost the woman owned designation.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Woman Owned Ind

Description	Indicates that the organization is legally registered as woman owned.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Woman Owned Start Date

Description	Date upon which the company was registered as woman owned.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Organization Hierarchy

Description	Representation of the parentage in the legal hierarchical structure for the organization.
Is Identifying Relationship	false
Child Table	Organization
Child Role Name	is part of
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Organization
Parent Role Name	has part
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

contact Representative

Is Identifying Relationship	false
Child Table	Organization
Child Role Name	uses contact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Contact
Parent Role Name	is contact for
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Organization_NotificationReceiver_FK

Is Identifying Relationship	false
Child Table	Organization
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Notification Receiver
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Organization_MaterialIdentifier_FK

Is Identifying Relationship	false
Child Table	Organization
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Material Identifier
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Generalization Details

Party Generalization

Supertype	Party
Subtype	Organization
Transform As	TABLE

Overview

Top

Package

Entity

Business Data Model Data Model