pecos_enrollment_ownership_or_control

Information about ownership or control of provider enrollments

Primary Key:

• enrollment_id
• ownership_pac_id
• release_date

Foreign Keys:

• enrollment_id => pecos_enrollment.enrollment_id
• owner_role => pecos_ownership_or_control_type_lookup.role_code
• ownership_pac_id => pecos_associate.pac_id

Indexes:

• pecos_enrollment_ownership_or_control_owner_role_idx - owner_role
• pecos_enrollment_ownership_or_control_ownership_pac_id_idx - ownership_pac_id

Column	Data Type	Nullable	Indexed	Description
enrollment_id	text	No	Yes	Unique ID assigned to each new provider enrollment application
ownership_pac_id	bigint	No	Yes	An associate with ownership or managing control interest in the enrollment
owner_role	text	No	Yes	Code representing the nature of the associate's ownership or control relationship to the enrollment
owner_title	text	No	No	Title of owner
was_created_for_acquisition	boolean	No	No	Organization was created for acquisition purposes
association_date	date	No	No	Date the owner became associated with the enrollment
percentage_ownership	numeric	Yes	No	Percentage of ownership or control
release_date	date	No	Yes	-