Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Organization Dimension

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 Dt

Accounting Period Start Dt

Address Line 1 Descr

Address Line 2 Descr

Address Line 3 Descr

Address Line 4 Descr

Address Text Descr

Address Type Cd

Address Type Code Sk

Address Type Descr

Address Use Cd

Address Use Code Sk

Address Use Descr

Annual Revenue

Attachments Allowed Ind

AWM Load Info Sk

Bed Size Cnt

Boarded Ind

Capital City Ind

City Nm

Company Type Cd

Company Type Code Descr

Company Type Code Sk

Competitor Ind

Contact Instructions

Contact Preference Priority Cd

Contact Preference Priority Code Descr

Contact Preference Priority Code Sk

Country Nm

County Nm

Current Ind

Dissolution Dt

DUNS Num

DWM Load Info Sk

Effective From Dt

Effective To Dt

Email Address Resource Locator Nm

Email Type Cd

Email Type Code Sk

Email Type Descr

Email Use Cd

Email Use Code Sk

Email Use Descr

End Dt

Equipment Type Cd

Equipment Type Code Sk

Equipment Type Descr

Fiscal Year End

Focus Area Cd

Focus Area Code Descr

Focus Area Code Sk

Foundation Dt

Franchised Ind

Health Rating Cd

Health Rating Code Descr

Health Rating Code Sk

HIBCC Subscriber Ind

HIN Status Cd

HIN Status Code Sk

HIN Status Descr

Industry Classification Cd

Industry Classification Code Sk

Industry Classification Descr

Language Cd

Language Code Descr

Language Code Sk

Listed Exchange Cd

Listed Exchange Code Sk

Listed Exchange Descr

Maximum Message Size

Membership Fee

Minority Owned End Dt

Minority Owned Ind

Minority Owned Start Dt

Number Of Customers

Number Of Employees

Number Of Members

Number Of Outlets

Organizational Structure Cd

Organizational Structure Code Sk

Organizational Structure Descr

Organization Bk

Organization Dk

Organization Legal Form Cd

Organization Legal Form Code Descr

Organization Legal Form Code Sk

Organization Master Num

Organization Nm

Organization Purpose Cd

Organization Purpose Code Descr

Organization Purpose Code Sk

Organization Size Cnt

Organization Sk

Organization Status Cd

Organization Status Code Descr

Organization Status Code Sk

Organization Status Reason Cd

Organization Status Reason Code Descr

Organization Status Reason Code Sk

Organization Type Cd

Organization Type Code Sk

Organization Type Descr

Organization Unit Function Cd

Organization Unit Function Code Descr

Organization Unit Function Code Sk

Party Introduction Method Cd

Party Introduction Method Code Descr

Party Introduction Method Code Sk

Phone Area Cd

Phone Country Cd

Phone Exchange Cd

Phone Extension Num

Phone Line Num

Phone Num

Phone Speed Dial Num

Phone Text Descr

Phone Type Cd

Phone Type Code Sk

Phone Type Descr

Phone Use Cd

Phone Use Code Sk

Phone Use Descr

Postal Cd

Preferred Payment Method Cd

Preferred Payment Method Code Descr

Preferred Payment Method Code Sk

Previous Refusal Ind

Primary Role Cd

Primary Role Code Descr

Primary Role Code Sk

Primary Service Cd

Primary Service Code Sk

Primary Service Descr

Profit After Tax

Public Private Ind

Receive Direct Mail Ind

Reprocessor Ind

Revenue

Small Business End Dt

Small Business Ind

Small Business Start Dt

Source Cd

Source Code Descr

Source Code Sk

Staffing Type Cd

Staffing Type Code Descr

Staffing Type Code Sk

State Province Cd

Tax Id

Tenant Sk

Text Only Ind

Turnover

Valid From Ts

Validity Check Dt

Validity Check Result Cd

Validity Check Result Code Descr

Validity Check Result Code Sk

Valid To Ts

Veteran Owned End Dt

Veteran Owned Ind

Veteran Owned Start Dt

Woman Owned End Dt

Woman Owned Ind

Woman Owned Start Dt

Primary Key

Organization Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

 Accounting Period End Dt

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 Dt

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

---

 Address Line 1 Descr

Description	First line of the address. Use for Primary Street and Building Number
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Line 2 Descr

Description	Second line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Line 3 Descr

Description	Third line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Line 4 Descr

Description	Fourth line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Text Descr

Description	Free form textual comments with respect to the telephone number.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Type Cd

Description	Identifies the type of the relationship as defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Type Code Sk

Description	Identifies the type of the relationship as defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Type Descr

Description	Identifies the type of the relationship as defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Use Cd

Description	Code for the contact use. e.g. Mailing Default Billing
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Use Code Sk

Description	Code for the contact use. e.g. Mailing Default Billing
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Use Descr

Description	Code for the contact use. e.g. Mailing Default Billing
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
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

---

 Attachments Allowed Ind

Description	Indicates whether the e-mail address accepts attachments. For example: 0 No 1 Yes
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

---

 AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Bed Size Cnt

Description	The total number of beds in a health care facility.
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

---

 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

---

 Capital City Ind

Description	Indicates whether or not a city is the capital city of a country. This applies only to a place whose administrative level corresponds to a city.
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

---

 City Nm

Description	Name for the city of the address.
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

---

 Company Type Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Company Type Code Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Company Type Code Sk

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/Surrogate Key [INTEGER]
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

---

 Contact Instructions

Description	The recorded advice which may be helpful when contacting the party using this email address.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Contact Preference Priority Cd

Description	Contact preference priority classifies the email address according to the relative priority of the email address with respect to other email addresses. For example: 1 (Main/primary preference) 5 (Low preference)
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Contact Preference Priority Code Descr

Description	Contact preference priority classifies the email address according to the relative priority of the email address with respect to other email addresses. For example: 1 (Main/primary preference) 5 (Low preference)
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Contact Preference Priority Code Sk

Description	Contact preference priority classifies the email address according to the relative priority of the email address with respect to other email addresses. For example: 1 (Main/primary preference) 5 (Low preference)
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Country Nm

Description	Name of the country for the address.
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

---

 County Nm

Description	Name of the county for the address.
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

---

 Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Dissolution Dt

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

---

 DWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Effective To Dt

Description	Ends a period of effectivity.
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

---

 Email Address Resource Locator Nm

Description	Email address string, representing the contact email address
Data Type	Standards - Data Domains.ddm/Data Domains/URL [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Email Type Cd

Description	Identifies the type of the relationship as defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Email Type Code Sk

Description	Identifies the type of the relationship as defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Email Type Descr

Description	Identifies the type of the relationship as defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Email Use Cd

Description	Indicates the way an address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Email Use Code Sk

Description	Indicates the way an address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Email Use Descr

Description	Indicates the way an address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 End Dt

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

---

 Equipment Type Cd

Description	Indicates the kind of telephone represented by the number.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Equipment Type Code Sk

Description	Indicates the kind of telephone represented by the number.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Equipment Type Descr

Description	Indicates the kind of telephone represented by the number.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
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

---

 Focus Area Cd

Description	The main area of interest of the advocacy organization. For example: Asthma Child health Diabetes Patient rights Prenatal care
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Focus Area Code Descr

Description	The main area of interest of the advocacy organization. For example: Asthma Child health Diabetes Patient rights Prenatal care
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Focus Area Code Sk

Description	The main area of interest of the advocacy organization. For example: Asthma Child health Diabetes Patient rights Prenatal care
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Foundation Dt

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

---

 Health Rating Cd

Description	Indicates the general level of healthiness that applies to the party where the party is a person. For an organization, this may be an overall rating based on the individual Health Ratings of the organization's members.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Health Rating Code Descr

Description	Indicates the general level of healthiness that applies to the party where the party is a person. For an organization, this may be an overall rating based on the individual Health Ratings of the organization's members.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Health Rating Code Sk

Description	Indicates the general level of healthiness that applies to the party where the party is a person. For an organization, this may be an overall rating based on the individual Health Ratings of the organization's members.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
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 Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 HIN Status Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 HIN Status Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Industry Classification Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Industry Classification Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Industry Classification Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Language Cd

Description	Indicates the natural language used in communication with the organization. For example: Chinese Dutch French Japanese US English
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Language Code Descr

Description	Indicates the natural language used in communication with the organization. For example: Chinese Dutch French Japanese US English
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Language Code Sk

Description	Indicates the natural language used in communication with the organization. For example: Chinese Dutch French Japanese US English
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Listed Exchange Cd

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

---

 Listed Exchange Code Sk

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

---

 Listed Exchange Descr

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

---

 Maximum Message Size

Description	The maximum size (in bytes) of an e-mail accepted by the email address. The size includes the body, all headers and attachments.
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

---

 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 Dt

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 Dt

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

---

 Organizational Structure Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organizational Structure Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organizational Structure Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Organization Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	true

---

 Organization Legal Form Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Legal Form Code Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Legal Form Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Master Num

Description	The universal business identifier for the organization.
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

---

 Organization Nm

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 Purpose Cd

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

---

 Organization Purpose Code Descr

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

---

 Organization Purpose Code Sk

Description	Indicates the purpose or format of the organization. For example: Supporting dangerous hobbies Travel assistance
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
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 Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Organization Status Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Status Code Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Status Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Status Reason Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Status Reason Code Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Status Reason Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Type Cd

Description	Identifies the detail entity represented by the anchor row.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Organization Type Code Sk

Description	Identifies the detail entity represented by the anchor row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Organization Type Descr

Description	Identifies the detail entity represented by the anchor row.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Organization Unit Function Cd

Description	Indicates the function performed by the organization unit.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Unit Function Code Descr

Description	Indicates the function performed by the organization unit.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Unit Function Code Sk

Description	Indicates the function performed by the organization unit.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Party Introduction Method Cd

Description	Indicates the manner in which the party is first introduced to the modeled organization. For example: Advertisement Business partner Mailshot campaign Newspaper Personal recommendation Television advertisement
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Party Introduction Method Code Descr

Description	Indicates the manner in which the party is first introduced to the modeled organization. For example: Advertisement Business partner Mailshot campaign Newspaper Personal recommendation Television advertisement
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Party Introduction Method Code Sk

Description	Indicates the manner in which the party is first introduced to the modeled organization. For example: Advertisement Business partner Mailshot campaign Newspaper Personal recommendation Television advertisement
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Phone Area Cd

Description	Indicates the area code for the telephone, cell, or pager number.
Data Type	Standards - Data Domains.ddm/Data Domains/Phone Area Code [VARCHAR(8)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Phone Country Cd

Description	Indicates the country code for the telephone, cell, or pager number.
Data Type	Standards - Data Domains.ddm/Data Domains/Phone Country Code [CHAR(3)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Phone Exchange Cd

Description	Indicates the telephone exchange code for the telephone, cell, or pager number.  For US telephone numbers the exchange code or Central Office Code refers to the first 3 digits of the local number (NNN-xxxx).
Data Type	Standards - Data Domains.ddm/Data Domains/Phone Exchange Code [VARCHAR(3)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Phone Extension Num

Description	A suffix for a telephone number to reach a specific phone in a main telephone network
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

---

 Phone Line Num

Description	Represents the telephone line number for the telephone, cell, or pager number.  For US telephone numbers the line number refers to the last 4 digits of the local number (xxx-NNNN).
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

---

 Phone Num

Description	Represents the actual number (without formatting) for the telephone, cell, or pager number.
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

---

 Phone Speed Dial Num

Description	The characters established within a company's internal telephone system used in place of the (external) telephone number to facilitate calling because its length is shorter than that of the telephone number. Note that digits, as well as special characters (for example, *, #) may be used.
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

---

 Phone Text Descr

Description	Free form textual comments with respect to the telephone number.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Phone Type Cd

Description	Identifies the type of the relationship as defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Phone Type Code Sk

Description	Identifies the type of the relationship as defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Phone Type Descr

Description	Identifies the type of the relationship as defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Phone Use Cd

Description	Indicates the way a telephone number is used by a party. For example: Default Alert Contact After Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Phone Use Code Sk

Description	Indicates the way a telephone number is used by a party. For example: Default Alert Contact After Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Phone Use Descr

Description	Indicates the way a telephone number is used by a party. For example: Default Alert Contact After Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Postal Cd

Description	Zip code and International Postal Code for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Postal Code [VARCHAR(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Preferred Payment Method Cd

Description	Indicates the preferred method of payment of the party. For example: Cash Credit card Direct debit Standing order Transfer Check
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Preferred Payment Method Code Descr

Description	Indicates the preferred method of payment of the party. For example: Cash Credit card Direct debit Standing order Transfer Check
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Preferred Payment Method Code Sk

Description	Indicates the preferred method of payment of the party. For example: Cash Credit card Direct debit Standing order Transfer Check
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Previous Refusal Ind

Description	Indicates whether (1) or not (0) the party has been refused a relationship with the modeled organization in the past. For example, a person may have been refused insurance or has had a policy cancelled or special terms imposed by a health insurance 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

---

 Primary Role Cd

Description	Indicates the main purpose of the party in relation to the modeled organization. For example: Intermediary Member Premium payer Solicitor Subscriber
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Primary Role Code Descr

Description	Indicates the main purpose of the party in relation to the modeled organization. For example: Intermediary Member Premium payer Solicitor Subscriber
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Primary Role Code Sk

Description	Indicates the main purpose of the party in relation to the modeled organization. For example: Intermediary Member Premium payer Solicitor Subscriber
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Primary Service Cd

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

---

 Primary Service Code Sk

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

---

 Primary Service Descr

Description	The main function the organization performs in the course of its business.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
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 Dt

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 Dt

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

---

 Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Source Code Descr

Description	The description that corresponds to the Source Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Staffing Type Cd

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

---

 Staffing Type Code Descr

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

---

 Staffing Type Code Sk

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

---

 State Province Cd

Description	Indicates the state or province for the address using a recognized set of codes or abbreviations.
Data Type	Standards - Data Domains.ddm/Data Domains/State Code [CHAR(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Tax Id

Description	The Tax Identification Number (TIN) of the health plan organization.
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

---

 Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Text Only Ind

Description	Indicates whether the e-mail address accepts text only e-mails (otherwise it could accept HTML or other embedded objects). For example: 0 No (HTML/other objects allowed) 1 Yes (text only allowed)
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

---

 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

---

 Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Validity Check Dt

Description	The date on which the validity of the contact preference was last checked.
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

---

 Validity Check Result Cd

Description	The conclusion of the most recent validity check. For example: Invalid Invalid but accepted Valid
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Validity Check Result Code Descr

Description	The conclusion of the most recent validity check. For example: Invalid Invalid but accepted Valid
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Validity Check Result Code Sk

Description	The conclusion of the most recent validity check. For example: Invalid Invalid but accepted Valid
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Veteran Owned End Dt

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 Dt

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 Dt

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 Dt

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

Primary Key Details

 Organization Dimension PK

Key Attribute

Organization Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model