Entity Organization Detail

DescriptionA 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 DtAccounting Period End Dt
Accounting Period Start DtAccounting Period Start Dt
Annual RevenueAnnual Revenue
Bed Size CntBed Size Cnt
Boarded IndBoarded Ind
CLIA Certified IndCLIA Certified Ind
Company Type Code SkCompany Type Code Sk
Competitor IndCompetitor Ind
Dissolution DtDissolution Dt
DUNS NumDUNS Num
Effective From DtEffective From Dt
Effective To DtEffective To Dt
End DtEnd Dt
External IndExternal Ind
Fiscal Year EndFiscal Year End
Focus AreaFocus Area
Foundation DtFoundation Dt
Franchised IndFranchised Ind
Health Rating Code SkHealth Rating Code Sk
HIBCC Subscriber IndHIBCC Subscriber Ind
HIN Status Code SkHIN Status Code Sk
Industry Classification Code SkIndustry Classification Code Sk
Jurisdiction Authority Code SkJurisdiction Authority Code Sk
Language Code SkLanguage Code Sk
Listed Exchange Code SkListed Exchange Code Sk
Load Info SkLoad Info Sk
Membership FeeMembership Fee
Minority Owned End DtMinority Owned End Dt
Minority Owned IndMinority Owned Ind
Minority Owned Start DtMinority Owned Start Dt
Number Of CustomersNumber Of Customers
Number Of EmployeesNumber Of Employees
Number Of MembersNumber Of Members
Number Of OutletsNumber Of Outlets
Organizational Structure Code SkOrganizational Structure Code Sk
Organization DescrOrganization Descr
Organization Legal Form Code SkOrganization Legal Form Code Sk
Organization Master NumOrganization Master Num
Organization Purpose Code SkOrganization Purpose Code Sk
Organization Size CntOrganization Size Cnt
Organization SkOrganization Sk
Organization Status Code SkOrganization Status Code Sk
Organization Status Reason Code SkOrganization Status Reason Code Sk
Organization Type Code SkOrganization Type Code Sk
Organization Unit Function Code SkOrganization Unit Function Code Sk
Outpatient Clinic Type Code SkOutpatient Clinic Type Code Sk
Party Introduction Method Code SkParty Introduction Method Code Sk
Preferred Payment Method Code SkPreferred Payment Method Code Sk
Previous Refusal IndPrevious Refusal Ind
Primary Role Code SkPrimary Role Code Sk
Primary Service Code SkPrimary Service Code Sk
Professional Service Area Code SkProfessional Service Area Code Sk
Profit After TaxProfit After Tax
Public Private IndPublic Private Ind
Receive Direct Mail IndReceive Direct Mail Ind
Reprocessor IndReprocessor Ind
RevenueRevenue
Small Business End DtSmall Business End Dt
Small Business IndSmall Business Ind
Small Business Start DtSmall Business Start Dt
Source Code SkSource Code Sk
Staffing Type Code SkStaffing Type Code Sk
Tax IdTax Id
Tenant SkTenant Sk
TurnoverTurnover
Valid From TsValid From Ts
Valid To TsValid To Ts
Veteran Owned End DtVeteran Owned End Dt
Veteran Owned IndVeteran Owned Ind
Veteran Owned Start DtVeteran Owned Start Dt
Woman Owned End DtWoman Owned End Dt
Woman Owned IndWoman Owned Ind
Woman Owned Start DtWoman Owned Start Dt

Relationship
Organization Detail_Organization_FKOrganization Detail_Organization_FK

Primary Key
Organization Detail PKOrganization Detail PK

Dependencies
 
 
 
 

Reverse Dependencies
 

Attribute Details

 Accounting Period End Dt
DescriptionDate 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 TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Period Start Dt
DescriptionDate upon which the accounting period of the organization starts.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Annual Revenue
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Bed Size Cnt
DescriptionThe total number of beds in a health care facility.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Boarded Ind
DescriptionIndicates that an organization has a board of directors.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 CLIA Certified Ind
DescriptionIndicates that the laboratory is certified under the Clinical Laboratory Improvement Amendments (CLIA) program. The Centers for Medicare & Medicaid Services (CMS) regulates all laboratory testing (except research) performed on humans in the U.S. through the Clinical Laboratory Improvement Amendments (CLIA).
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Company Type Code Sk
DescriptionIndicates the primary type of activity undertaken by the organization.

For example:
Mail Order Company
Pharmacy Company
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Competitor Ind
DescriptionIndicates whether or not the organization competes with the modeled healthcare organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Dissolution Dt
DescriptionThe date upon which this organization ceased to legally exist.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 DUNS Num
DescriptionThe number assigned to the organization by Dun & Bradstreet.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 End Dt
DescriptionThe date upon which the organization becomes unavailable for use.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 External Ind
DescriptionIndicates if this organization is external or part of the modeling enterprise.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Fiscal Year End
DescriptionThe day and month upon which the company's fiscal year ends.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Focus Area
DescriptionThe main area of interest of the advocacy organization.

For example:
Asthma
Child health
Diabetes
Patient rights
Prenatal care
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Foundation Dt
DescriptionThe date upon which the organization was founded or created.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Franchised Ind
DescriptionIndicates whether or not the organization has a franchise for one or more companies.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Health Rating Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 HIBCC Subscriber Ind
DescriptionIndicates if the organization subscribes to the Health Industry Business Communication Council.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 HIN Status Code Sk
DescriptionIndicates the status of the organization in the NIH Heart, Lung and Blood Institute Health Information Network (HIN).
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Industry Classification Code Sk
DescriptionIndicates the classification of the organization within a recognized standard such as the North American Industry Classification System (NAICS).
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Jurisdiction Authority Code Sk
DescriptionSpecifies the type of governance over which an authority has to make laws and enforce them.

For Example:
The Food and Drug Administration (FDA) exercises responsibility for pharmacovigilance in the United States.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Language Code Sk
DescriptionIndicates the natural language used in communication with the organization.

For example:
Chinese
Dutch
French
Japanese
US English
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Listed Exchange Code Sk
DescriptionIndicates the equity exchange the stock for this company is traded on.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Membership Fee
DescriptionThe monetary amount of a single fee paid to become a member of an organization or affinity group.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Minority Owned End Dt
DescriptionThe date upon which the organization lost its minority owned designation.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Minority Owned Ind
DescriptionIndicates that the organization is legally registered as minority owned.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Minority Owned Start Dt
DescriptionThe date upon which the company was registered as minority owned.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Customers
DescriptionA 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 TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Employees
DescriptionA count of persons employed by the organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Members
DescriptionA 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 TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Outlets
DescriptionA count of the outlets (customer touch point locations) owned or operated by the organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organizational Structure Code Sk
DescriptionIndicates the nature of the ownership of an organization.

For example:
Stock Company
Wholly Owned
Cooperative
Joint Venture
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Descr
DescriptionA textual description of the organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Legal Form Code Sk
DescriptionIndicates the legal form or structure of the organization.

For example:
Limited company
Public limited company
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Master Num
DescriptionThe universal business identifier for the organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Purpose Code Sk
DescriptionIndicates the purpose or format of the organization.

For example:
Supporting dangerous hobbies
Travel assistance
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Size Cnt
DescriptionAn expression of the scale of an organization based on the number of employees, members or participants in the organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Sk
DescriptionAnchor surrogate key for the Organization data
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Status Code Sk
DescriptionIndicates the current state of the organization. It is used for all statuses other than foundation and dissolution.

For example:
Trading
Liquidated
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Status Reason Code Sk
DescriptionIndicates the reason why an organization is currently in a given organization status.

For example:
Risky investment
Insolvent
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Type Code Sk
DescriptionIndicates the type of organization.

For example:
corporation
government
non-profit
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Unit Function Code Sk
DescriptionIndicates the function performed by the organization unit.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Outpatient Clinic Type Code Sk
DescriptionIndicates the nature of the services provided in an outpatient clinic.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Party Introduction Method Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Preferred Payment Method Code Sk
DescriptionIndicates the preferred method of payment of the party.

For example:
Cash
Credit card
Direct debit
Standing order
Transfer
Check
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Previous Refusal Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Role Code Sk
DescriptionIndicates the main purpose of the party in relation to the modeled organization.

For example:
Intermediary
Member
Premium payer
Solicitor
Subscriber
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Service Code Sk
DescriptionThe main function the organization performs in the course of its business.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Professional Service Area Code Sk
DescriptionUniquely represents the service provided by a physician or center
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Profit After Tax
DescriptionThe monetary amount of the most recently reported profit after tax for the company.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Public Private Ind
DescriptionIndicates whether the organization is publicly or privately funded.

For example:
Private
Public
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Receive Direct Mail Ind
DescriptionIndicates if the company will receive direct mail or will need to be contacted via some parent organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Reprocessor Ind
DescriptionIndicates if the organization is identified as a reprocessor.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Revenue
DescriptionThe monetary amount of the total income received by a company over a period of one year.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Small Business End Dt
DescriptionDate upon which the organization lost the small business designation.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Small Business Ind
DescriptionIndicates that the organization is legally registered as a small business.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Small Business Start Dt
DescriptionDate upon which the company was registered as a small business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Staffing Type Code Sk
DescriptionIndicates the manner in which the organization is staffed.

For example:
Employees
Family-Run
Volunteers
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tax Id
DescriptionThe Tax Identification Number (TIN) of the health plan organization.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Turnover
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes 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 TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Veteran Owned End Dt
DescriptionDate upon which the organization lost the veteran owned designation.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Veteran Owned Ind
DescriptionIndicates that the organization is legally registered as veteran owned.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Veteran Owned Start Dt
DescriptionDate upon which the company was registered as veteran owned.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Woman Owned End Dt
DescriptionDate upon which the organization lost the woman owned designation.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Woman Owned Ind
DescriptionIndicates that the organization is legally registered as woman owned.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Woman Owned Start Dt
DescriptionDate upon which the company was registered as woman owned.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Organization Detail_Organization_FK
Is Identifying Relationshiptrue
Child TableOrganization Detail
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrganization
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Organization Detail PK
Key AttributeOrganization Sk
Key AttributeValid From Ts