US-CA.BER (data source)

Property	Value
Identifiers	US-CA.BER (The ALEI prefix element is the ISO 3166-2 code for country and subdivision if applicable followed by the stop character <code>.</code>. This is followed by an acronym representing the register maintained by the administrative agency for the governing body of a nation, state, or community that assigned the identifier element. The prefix is assigned by ECCMA ALEI prefix), US_CA_BER (A technical identifier, unique in a certain context. Technical key)
Language-specific short name. Monolingual short name	California - Secretary of State (en)
Language-specific name. Monolingual name	California - Secretary of State (en)
An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short description	California - Secretary of State is a data source that helps CDQ customers validate and enrich business partner master data for compliance and data quality.
The country a linked concept is active or generally relevant for. Country scope	US (United States of America)
Data access	Secretary of the State, California (Provider or authority of a data source. Provider), website (URL that provides more information for a given concept. URL), FUZZY (Search type (data sources)<br/>Describes how data can be searched in a data source.<br/><code>FUZZY</code>: Data can be searched by address and name attributes.<br/><code>IDENTIFIER</code>: Data can be searched by business identifiers.<br/><code>INDEX</code>: Data can be searched by business identifiers. Search type)
nonetheless, we continue to offer the most recent available data., The release status in terms of development progress or maturity.<br/><code>EMPTY</code> (0): No feature considered yet, just a rough idea.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it.<br/><code>DISCONTINUED</code> (-4): The data source has ceased providing updates Release status	LIVE, COPY (Documents how a data source is integrated into the CDL with respect to data gathering:<br/><code>REMOTE ACCESS</code>: Data is not stored on CDL side but queried ad-hoc from the data source (e.g. webservices)<br/><code>COPY</code>: Data is replicated on CDL side (usually already transformed into the target CDL data model)<br/><code>UNDEFINED</code>: not yet known Integration type)
Content	BUSINESS_PARTNER (Specifies the category of a data source. The following categories are defined:<br/><code>BUSINESS_PARTNER</code>: The data source provides master data about companies.<br/><code>ADDRESS</code>: The data source provides address reference data.<br/><code>SANCTION_AND_WATCHLIST</code>: A data source that provides sanctioned or watched companies or persons.<br/><code>BANK_ACCOUNT</code>: The data source provides bank and bank account reference data.<br/><code>CERTIFICATE</code>: The data source provides information about business partner certifications.<br/><code>BENEFICIAL_OWNER</code>: The data source provides information about beneficial owners of companies.<br/><code>INSOLVENCY</code>: The data source provides information about insolvencies.<br/><code>HEALTHCARE_PROFESSIONAL</code>: The data source provides information about HCPs.<br/><code>HEALTHCARE_ORGANIZATION</code>: The data source provides information about HCOs. Data source category), 8,914,066 (Counts the number of company records available in the data source. Number of records) , 49 concepts, 38 terms
Legal classification	2020-01-01 (Date when a legal classification was approved (the last time). Legal approval), GOVERNMENTAL (Data ownership<br/>Categorizes legal right-holding by the type of the data owner, e.g. a private organization or a governmental authority.<br/><code>GOVERNMENTAL</code>: The data source is owned by a governmental body, e.g., a federal, state, or municipal authority.<br/><code>PRIVATE</code>: The data source is owned by a private body, e.g., a company or an association. Data ownership), OPEN (Data provision<br/>Categorizes restriction of data access, i.e., whether a data source provides "open" data or requires registration.<br/><code>COMMERCIAL</code>: Data is not provided for free, but users of the data source have to pay for downloading, querying, or using the data according to a commercial contract.<br/><code>FREE</code>: Data is provided for free, but the data source requires registration, i.e., authentication when data is downloaded or queried.<br/><code>OPEN</code>: Data is provided for free and unlimited access without registration or subscription. Data provision), NO_TERMS (Terms type<br/>A client or CDQ accepts the terms of use of a particular data source and the compliant use of its data.<br/><code>CDQ_CONTRACTED</code>: CDQ accepts the terms of a particular data source and the compliant use of its data.<br/><code>CLIENT_CONTRACTED</code>: A client (i.e., the data end user) accepts the terms of a particular data source and the compliant use of its data.<br/><code>EU_PRIVATE</code>: The data source is provided by a private organization under EU law, i.e., from "within" a EU member country.<br/><code>EU_PUBLIC</code>: The data source is provided by a governmental organization under EU law, i.e., from "within" a EU member country.<br/><code>NO_TERMS</code>: No specific terms of use are provided for a data source.<br/><code>STANDARD_LICENCE</code>: A standard licence is used, further details are provided by license type information of the data source. Terms type)
Quota	250,000 (The default maximum quota for a data source. Maximum Quota (default)), MONTH (Quota reset<br/>The default reset period of a defined quota for a data source.<br/><code>DAY</code>: The quota of the data source is reset daily.<br/><code>MONTH</code>: The quota of the data source is reset monthly.<br/><code>WEEK</code>: The quota of the data source is reset weekly.<br/><code>YEAR</code>: The quota of the data source is reset yearly. Quota reset (default)), CDQ (Quota control<br/>The control of changing the maximum quota and reset period for a data source.<br/><code>CDQ</code>: The quota of the data source can be higher than set by CDQ.<br/><code>CLIENT</code>: The quota of the data source can be set higher than the default.<br/><code>CREDENTIAL_DEPENDENT</code>: If a customer uses CDQ credentials to assess the data source then the quota can't be higher than the default, but if customers use their own credentials, then the quota can be increased. Quota control), NO (Quota enablement<br/>whether the quota management is turned on for a specific data source.<br/><code>NO</code>: The data source does not have an enabled quota.<br/><code>YES</code>: A quota is enabled for the data source. Quota enabled)
Linkage strategy	Linkage strategy for data source US-CA.BER and country US
Update monitoring	NO (Update monitor enablement<br/>whether the update monitoring is turned on for a specific data source.<br/><code>NO</code>: For the data source, no update monitor is enabled.<br/><code>YES</code>: An update monitor is enabled for the data source. Update monitoring enabled)

Managed business identifiers

Identifier	Technical name	Parent	Description	CDQ mapping
ENTITY_NUM (US-CA.BER)	ENTITY_NUM	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)

Data model concepts

Concept	Technical name	Parent	Description	CDQ mapping
AGENT_TYPE (US-CA.BER)	AGENT_TYPE	US-CA.BER/Data source/US-VA.BER/data model/record
ENTITY_NAME (US-CA.BER)	ENTITY_NAME	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
ENTITY_NUM (US-CA.BER)	ENTITY_NUM	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
ENTITY_STATUS (US-CA.BER)	ENTITY_STATUS	US-CA.BER/Data source/US-VA.BER/data model/record		Official Denotation (CDQ)
ENTITY_TYPE (US-CA.BER)	ENTITY_TYPE	US-CA.BER/Data source/US-VA.BER/data model/record		Legal Form (CDQ)
FILING_TYPE (US-CA.BER)	FILING_TYPE	US-CA.BER/Data source/US-VA.BER/data model/record
FIRST_NAME (US-CA.BER)	FIRST_NAME	US-CA.BER/Data source/US-VA.BER/data model/record
FOREIGN_NAME (US-CA.BER)	FOREIGN_NAME	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
INITIAL_FILING_DATE (US-CA.BER)	INITIAL_FILING_DATE	US-CA.BER/Data source/US-VA.BER/data model/record
JURISDICTION (US-CA.BER)	JURISDICTION	US-CA.BER/Data source/US-VA.BER/data model/record
LAST_NAME (US-CA.BER)	LAST_NAME	US-CA.BER/Data source/US-VA.BER/data model/record
LAST_SI_FILE_DATE (US-CA.BER)	LAST_SI_FILE_DATE	US-CA.BER/Data source/US-VA.BER/data model/record
LAST_SI_FILE_NUMBER (US-CA.BER)	LAST_SI_FILE_NUMBER	US-CA.BER/Data source/US-VA.BER/data model/record
LLC_MANAGEMENT_STRUCTURE (US-CA.BER)	LLC_MANAGEMENT_STRUCTURE	US-CA.BER/Data source/US-VA.BER/data model/record
MAILING_ADDRESS (US-CA.BER)	MAILING_ADDRESS	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
MAILING_ADDRESS2 (US-CA.BER)	MAILING_ADDRESS2	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
MAILING_ADDRESS3 (US-CA.BER)	MAILING_ADDRESS3	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
MAILING_CITY (US-CA.BER)	MAILING_CITY	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
MAILING_COUNTRY (US-CA.BER)	MAILING_COUNTRY	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
MAILING_POSTAL_CODE (US-CA.BER)	MAILING_POSTAL_CODE	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
MAILING_STATE (US-CA.BER)	MAILING_STATE	US-CA.BER/Data source/US-VA.BER/data model/record		Iso Code (CDQ)
MIDDLE_NAME (US-CA.BER)	MIDDLE_NAME	US-CA.BER/Data source/US-VA.BER/data model/record
ORG_NAME (US-CA.BER)	ORG_NAME	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PHYSICAL_ADDRESS1 (US-CA.BER)	PHYSICAL_ADDRESS1	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PHYSICAL_ADDRESS2 (US-CA.BER)	PHYSICAL_ADDRESS2	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PHYSICAL_ADDRESS3 (US-CA.BER)	PHYSICAL_ADDRESS3	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PHYSICAL_CITY (US-CA.BER)	PHYSICAL_CITY	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PHYSICAL_COUNTRY (US-CA.BER)	PHYSICAL_COUNTRY	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PHYSICAL_POSTAL_CODE (US-CA.BER)	PHYSICAL_POSTAL_CODE	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PHYSICAL_STATE (US-CA.BER)	PHYSICAL_STATE	US-CA.BER/Data source/US-VA.BER/data model/record		Iso Code (CDQ)
PRINCIPAL_ADDRESS (US-CA.BER)	PRINCIPAL_ADDRESS	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PRINCIPAL_ADDRESS_IN_CA (US-CA.BER)	PRINCIPAL_ADDRESS_IN_CA	US-CA.BER/Data source/US-VA.BER/data model/record
PRINCIPAL_ADDRESS2 (US-CA.BER)	PRINCIPAL_ADDRESS2	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PRINCIPAL_ADDRESS2_IN_CA (US-CA.BER)	PRINCIPAL_ADDRESS2_IN_CA	US-CA.BER/Data source/US-VA.BER/data model/record
PRINCIPAL_CITY (US-CA.BER)	PRINCIPAL_CITY	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PRINCIPAL_CITY_IN_CA (US-CA.BER)	PRINCIPAL_CITY_IN_CA	US-CA.BER/Data source/US-VA.BER/data model/record
PRINCIPAL_COUNTRY (US-CA.BER)	PRINCIPAL_COUNTRY	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PRINCIPAL_COUNTRY_IN_CA (US-CA.BER)	PRINCIPAL_COUNTRY_IN_CA	US-CA.BER/Data source/US-VA.BER/data model/record
PRINCIPAL_POSTAL_CODE (US-CA.BER)	PRINCIPAL_POSTAL_CODE	US-CA.BER/Data source/US-VA.BER/data model/record		Value (CDQ)
PRINCIPAL_POSTAL_CODE_IN_CA (US-CA.BER)	PRINCIPAL_POSTAL_CODE_IN_CA	US-CA.BER/Data source/US-VA.BER/data model/record
PRINCIPAL_STATE (US-CA.BER)	PRINCIPAL_STATE	US-CA.BER/Data source/US-VA.BER/data model/record		Iso Code (CDQ)
PRINCIPAL_STATE_IN_CA (US-CA.BER)	PRINCIPAL_STATE_IN_CA	US-CA.BER/Data source/US-VA.BER/data model/record
STANDING_AGENT (US-CA.BER)	STANDING_AGENT	US-CA.BER/Data source/US-VA.BER/data model/record
STANDING_FTB (US-CA.BER)	STANDING_FTB	US-CA.BER/Data source/US-VA.BER/data model/record
STANDING_SOS (US-CA.BER)	STANDING_SOS	US-CA.BER/Data source/US-VA.BER/data model/record
STANDING_VCFCF (US-CA.BER)	STANDING_VCFCF	US-CA.BER/Data source/US-VA.BER/data model/record
SUSPENSION_DATE (US-CA.BER)	SUSPENSION_DATE	US-CA.BER/Data source/US-VA.BER/data model/record
TYPE_OF_BUSINESS (US-CA.BER)	TYPE_OF_BUSINESS	US-CA.BER/Data source/US-VA.BER/data model/record
record (US-CA.BER)	record

Controlled vocabulary terms

Term (external)	Technical name	Parent	Description	CDQ mapping	Mapping target constant
Active (US-CA.BER)	Active	ENTITY_STATUS (US-CA.BER)	Active	ACTIVE (CDQ)
Active - Pending Future Effective Date (US-CA.BER)	Active - Pending Future Effective Date	ENTITY_STATUS (US-CA.BER)	Active - Pending Future Effective Date	ACTIVE (CDQ)
Active - Pending Merger (US-CA.BER)	Active - Pending Merger	ENTITY_STATUS (US-CA.BER)	Active - Pending Merger	ACTIVE (CDQ)
Active - Pending Termination (US-CA.BER)	Active - Pending Termination	ENTITY_STATUS (US-CA.BER)	Active - Pending Termination	ACTIVE (CDQ)
Converted Out (US-CA.BER)	Converted Out	ENTITY_STATUS (US-CA.BER)	Converted Out	INACTIVE (CDQ)
Forfeited - FTB (US-CA.BER)	Forfeited - FTB	ENTITY_STATUS (US-CA.BER)	Forfeited - FTB	DISSOLVED (CDQ)
Forfeited - FTB/SOS (US-CA.BER)	Forfeited - FTB/SOS	ENTITY_STATUS (US-CA.BER)	Forfeited - FTB/SOS	DISSOLVED (CDQ)
Forfeited - FTB/SOS/VCFCF (US-CA.BER)	Forfeited - FTB/SOS/VCFCF	ENTITY_STATUS (US-CA.BER)	Forfeited - FTB/SOS/VCFCF	DISSOLVED (CDQ)
Forfeited - SOS (US-CA.BER)	Forfeited - SOS	ENTITY_STATUS (US-CA.BER)	Forfeited - SOS	DISSOLVED (CDQ)
Forfeited - VCFCF (US-CA.BER)	Forfeited - VCFCF	ENTITY_STATUS (US-CA.BER)	Forfeited - VCFCF	DISSOLVED (CDQ)
Inactive (US-CA.BER)	Inactive	ENTITY_STATUS (US-CA.BER)	Inactive	INACTIVE (CDQ)
Limited Liability Company - CA (US-CA.BER)	Limited Liability Company - CA	ENTITY_TYPE (US-CA.BER)	Limited Liability Company - CA	US_6584 (CDQ)
Limited Liability Company - Out of State (US-CA.BER)	Limited Liability Company - Out of State	ENTITY_TYPE (US-CA.BER)	Limited Liability Company - Out of State	US_6584 (CDQ)
Limited Partnership - CA (US-CA.BER)	Limited Partnership - CA	ENTITY_TYPE (US-CA.BER)	Limited Partnership - CA	US_8454 (CDQ)
Limited Partnership - Out of State (US-CA.BER)	Limited Partnership - Out of State	ENTITY_TYPE (US-CA.BER)	Limited Partnership - Out of State	US_8454 (CDQ)
Merged Out (US-CA.BER)	Merged Out	ENTITY_STATUS (US-CA.BER)	Merged Out	INACTIVE (CDQ)
Name Reservation (US-CA.BER)	Name Reservation	ENTITY_TYPE (US-CA.BER)	Name Reservation	US_1151 (CDQ)
Nonprofit Corporation - CA - Mutual Benefit (US-CA.BER)	Nonprofit Corporation - CA - Mutual Benefit	ENTITY_TYPE (US-CA.BER)	Nonprofit Corporation - CA - Mutual Benefit	US_0983 (CDQ)
Nonprofit Corporation - CA - Mutual Benefit - Common Interest Development Corporation (US-CA.BER)	Nonprofit Corporation - CA - Mutual Benefit - Common Interest Development Corporation	ENTITY_TYPE (US-CA.BER)	Nonprofit Corporation - CA - Mutual Benefit - Common Interest Development Corporation	US_0983 (CDQ)
Nonprofit Corporation - CA - Public Benefit (US-CA.BER)	Nonprofit Corporation - CA - Public Benefit	ENTITY_TYPE (US-CA.BER)	Nonprofit Corporation - CA - Public Benefit	US_0983 (CDQ)
Nonprofit Corporation - CA - Religious (US-CA.BER)	Nonprofit Corporation - CA - Religious	ENTITY_TYPE (US-CA.BER)	Nonprofit Corporation - CA - Religious	US_0983 (CDQ)
Nonprofit Corporation - Out of State (US-CA.BER)	Nonprofit Corporation - Out of State	ENTITY_TYPE (US-CA.BER)	Nonprofit Corporation - Out of State	US_0983 (CDQ)
Stock Corporation - CA - Benefit (US-CA.BER)	Stock Corporation - CA - Benefit	ENTITY_TYPE (US-CA.BER)	Stock Corporation - CA - Benefit	US_6941 (CDQ)
Stock Corporation - CA - Close (US-CA.BER)	Stock Corporation - CA - Close	ENTITY_TYPE (US-CA.BER)	Stock Corporation - CA - Close	US_6941 (CDQ)
Stock Corporation - CA - General (US-CA.BER)	Stock Corporation - CA - General	ENTITY_TYPE (US-CA.BER)	Stock Corporation - CA - General	US_6941 (CDQ)
Stock Corporation - CA - Professional (US-CA.BER)	Stock Corporation - CA - Professional	ENTITY_TYPE (US-CA.BER)	Stock Corporation - CA - Professional	US_6941 (CDQ)
Stock Corporation - Out of State - Professional (US-CA.BER)	Stock Corporation - Out of State - Professional	ENTITY_TYPE (US-CA.BER)	Stock Corporation - Out of State - Professional	US_6941 (CDQ)
Stock Corporation - Out of State - Stock (US-CA.BER)	Stock Corporation - Out of State - Stock	ENTITY_TYPE (US-CA.BER)	Stock Corporation - Out of State - Stock	US_6941 (CDQ)
Suspended - FTB (US-CA.BER)	Suspended - FTB	ENTITY_STATUS (US-CA.BER)	Suspended - FTB	CDQ/Business Partner/Business Partner Status/Business Partner Status Type/SUSPENDED
Suspended - FTB/SOS (US-CA.BER)	Suspended - FTB/SOS	ENTITY_STATUS (US-CA.BER)	Suspended - FTB/SOS	CDQ/Business Partner/Business Partner Status/Business Partner Status Type/SUSPENDED
Suspended - FTB/SOS/VCFCF (US-CA.BER)	Suspended - FTB/SOS/VCFCF	ENTITY_STATUS (US-CA.BER)	Suspended - FTB/SOS/VCFCF	CDQ/Business Partner/Business Partner Status/Business Partner Status Type/SUSPENDED
Suspended - SOS (US-CA.BER)	Suspended - SOS	ENTITY_STATUS (US-CA.BER)	Suspended - SOS	CDQ/Business Partner/Business Partner Status/Business Partner Status Type/SUSPENDED
Suspended - VCFCF (US-CA.BER)	Suspended - VCFCF	ENTITY_STATUS (US-CA.BER)	Suspended - VCFCF	CDQ/Business Partner/Business Partner Status/Business Partner Status Type/SUSPENDED
Terminated (US-CA.BER)	Terminated	ENTITY_STATUS (US-CA.BER)	Terminated	INACTIVE (CDQ)
Terminated - FTB Admin (US-CA.BER)	Terminated - FTB Admin	ENTITY_STATUS (US-CA.BER)	Terminated - FTB Admin	INACTIVE (CDQ)
Terminated - SOS Admin (US-CA.BER)	Terminated - SOS Admin	ENTITY_STATUS (US-CA.BER)	Terminated - SOS Admin	INACTIVE (CDQ)
Terminated - Term Expired (US-CA.BER)	Terminated - Term Expired	ENTITY_STATUS (US-CA.BER)	Terminated - Term Expired	INACTIVE (CDQ)
Unincorporated Common Interest Development (US-CA.BER)	Unincorporated Common Interest Development	ENTITY_TYPE (US-CA.BER)	Unincorporated Common Interest Development	US_1151 (CDQ)