Data Dictionary

Column Type Label 描述
LICENSED_CERTIFIED text

LICENSED_CERTIFIED will identify if a facility has applied for state licensing or federal certification. See Lookup Table.

ELMS_FACID text

FACID is a 9-digit identifier. It is the primary key from the FACILITY table used to track facility information for all facilities stored in the Electronic Licensing Management System (ELMS) for CDPH Center of Healthcare Quality, Licensing and Certification Program.

LICENSE_NUMBER text

LICENSED_CERTIFIED will identify if a facility has applied for state licensing or federal certification. See Lookup Table.

LICENSE_STATUS_DESCRIPTION text
HCAI_ID text
ASPEN_FACID text

ASPEN_FACID is a state assigned identifier used to track facilities in the CDPH's federal data system: Automated Survey Processing Environment (ASPEN).

CCN text

CCN (CMS Certification Number) is a 6-digit facility identifier used by CMS to verify that a provider has been Medicare certified and for what type of services. In order to avoid confusion with the National Provider Identifier (NPI), the Medicare/Medicaid Provider Number (also known as the OSCAR Provider Number, Medicare Identification Number or Provider Number) had been renamed the CMS Certification Number (CCN). The first two digits are the numeric state code. NOTE: The CCN for ambulatory surgical centers is a 10-digit alphanumeric combination (######, ##A####, ##C#######). Note that nine of the facilities operate under the certification of a “parent” facility. Facilities in the same parent-child groups operate under the same CMS Certification Number (CCN), and the “child” facility’s surveys are attributed to the parent facility (based on the federal facility ID).

NPI text

"National Provider Indicator (NPI) is a 10-digit identifier for health care providers and health plans that was mandated by the Health Insurance Portability and Accountability Act of 1996 (HIPPA) for use in electronic transactions. Individuals or organizations apply for NPIs through the CMS National Plan and Provider Enumeration System (NPPES). Individual NPIs, also known as Type 1 NPIs, are for healthcare providers, such as dentists. Organizational, or Type 2 NPIs are for use by incorporated businesses, such group practices and clinics. Organizational NPIs can also be assigned to subparts. CDPH records one NPI per facility, even if a facility has multiple NPIs. "

ASPEN_STATUS text
FACNAME text

FACNAME is the facility name in the FACILITY table in ELMS, obtained from the facility's license application form.

FAC_TYPE_DESCRIPTION text

Facility Type Name.

FAC_FDR text

The facility type roll-up that is used in the Licensing and Certification Fee Development Report and is based on licensure facility types used in the ELMS system. See Lookup table.

FAC_FAC_RELATIONSHIP text

The facility parent/child relationship. See Lookup Table.

ELMS_PARENT_FACID text

ELMS PARENT FACID is a nine-digit identifier. It is the primary key from the FACILITY table used to track facility information for all facilities stored in the Electronic Licensing Management System (ELMS) for CDPH Center of Healthcare Quality, Licensing and Certification Program. This PARENT ELMS FACID only available when there is a parent/child relationship = FAC_FAC_RELATIONSHIP.

其他信息

价值
最后更新 未知
创建的 未知
格式 XLSX