trading_partner_extract_ncpdp

Information needed to process NCPDP prescription drug data.

Primary Key:

• trading_partner_extract_ncpdp_id

Foreign Keys:

• trading_partner_id => trading_partner.trading_partner_id

Indexes:

• trading_partner_extract_ncpdp_trading_partner_id_folder_nam_idx (Unique) - trading_partner_id, folder_name_filter, filename_filter, file_extension_filter
• trading_partner_extract_ncpdp_trading_partner_id_idx - trading_partner_id

Column	Data Type	Nullable	Indexed	Description
trading_partner_extract_ncpdp_id	bigint	No	Yes	Snowflake ID of the configuration for NCPDP data loading.
trading_partner_id	bigint	No	Yes	Link to the associated trading partner record.
folder_name_filter	text	No	Yes	-
filename_filter	text	No	Yes	-
file_extension_filter	text	No	Yes	-
file_suffix	text	No	No	-