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_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 Generated through expression:
ownership_pac_id	bigint	No	Yes	An associate with ownership or managing control interest in the enrollment Generated through expression:
owner_role	text	No	No	Code representing the nature of the associate's ownership or control relationship to the enrollment Generated through expression:
owner_title	text	No	No	Title of owner Generated through expression:
was_created_for_acquisition	boolean	No	No	Organization was created for acquisition purposes Generated through expression:
association_date	date	No	No	Date the owner became associated with the enrollment Generated through expression:
percentage_ownership	numeric	Yes	No	Percentage of ownership or control Generated through expression:
release_date	date	No	Yes	- Generated through expression: