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 Generated through expression:
enrollment_id	text	No	Yes	Unique ID assigned to each new provider enrollment application Generated through expression:
ccn	text	No	No	CMS certification number Generated through expression:
name	text	No	No	Organization name Generated through expression:
doing_business_as	text	No	No	Name under which the provider is doing business Generated through expression:
incorporation_date	date	Yes	No	Date on which the organization was incorporated Generated through expression:
incorporation_state	text	No	No	State in which the organization was incorporated Generated through expression:
organization_structure	pecos_organization_structure_type	No	No	Type of organizational structure Generated through expression:
organization_structure_other_text	text	No	No	Description of the organization structure if the organization structure type is 'OTHER' Generated through expression:
is_non_profit	boolean	No	No	Whether the organization is registered as non-profit Generated through expression:
address_id	bigint	No	No	Address provided for the organization Generated through expression:
last_modified_date	date	No	No	- Generated through expression: