pecos_facility_enrollment

Information about facility enrollments that CMS exports (about half)

Primary Key:

• enrollment_id

Column	Data Type	Nullable	Indexed	Description
pac_id	bigint	No	No	PECOS Associate Control ID - unique ID assigned to a unique SSN or EIN
enrollment_id	text	No	Yes	Unique ID assigned to each new provider enrollment application
ccn	text	No	No	CMS certification number
name	text	No	No	Organization name
doing_business_as	text	No	No	Name under which the provider is doing business
incorporation_date	date	Yes	No	Date on which the organization was incorporated
incorporation_state	text	No	No	State in which the organization was incorporated
organization_structure	pecos_organization_structure_type	No	No	Type of organizational structure
organization_structure_other_text	text	No	No	Description of the organization structure if the organization structure type is 'OTHER'
is_non_profit	boolean	No	No	Whether the organization is registered as non-profit
address_id	bigint	No	No	Address provided for the organization
last_modified_date	date	No	No	-