Table: AMS_USER_STATUSES_B

Product:	AMS - Marketing
Description:	Stores User status information
Implementation/DBA Data:	AMS.AMS_USER_STATUSES_B

Primary Key: AMS_USER_STATUSES_B_PK

1. USER_STATUS_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AMS_ACT_RESOURCES		AMS_USER_STATUSES_B	AMS_ACT_RESOURCES.USER_STATUS_ID
AMS_ACT_WF_REQUESTS		AMS_USER_STATUSES_B	AMS_ACT_WF_REQUESTS.USER_STATUS_ID
AMS_CAMPAIGNS_ALL_B		AMS_USER_STATUSES_B	AMS_CAMPAIGNS_ALL_B.USER_STATUS_ID
AMS_CAMPAIGN_SCHEDULES_B		AMS_USER_STATUSES_B	AMS_CAMPAIGN_SCHEDULES_B.USER_STATUS_ID
AMS_CAMPAIGN_SCHEDULES		AMS_USER_STATUSES_B	AMS_CAMPAIGN_SCHEDULES.USER_STATUS_ID
AMS_DELIVERABLES_ALL_B		AMS_USER_STATUSES_B	AMS_DELIVERABLES_ALL_B.USER_STATUS_ID
AMS_DIALOGS_ALL_B		AMS_USER_STATUSES_B	AMS_DIALOGS_ALL_B.USER_STATUS_ID
AMS_DM_MODELS_ALL_B		AMS_USER_STATUSES_B	AMS_DM_MODELS_ALL_B.USER_STATUS_ID
AMS_DM_SCORES_ALL_B		AMS_USER_STATUSES_B	AMS_DM_SCORES_ALL_B.USER_STATUS_ID
AMS_EVENT_HEADERS_ALL_B		AMS_USER_STATUSES_B	AMS_EVENT_HEADERS_ALL_B.USER_STATUS_ID
AMS_EVENT_HEADERS_ALL_B		AMS_USER_STATUSES_B	AMS_EVENT_HEADERS_ALL_B.EVENT_HEADER_ID
AMS_EVENT_OFFERS_ALL_B		AMS_USER_STATUSES_B	AMS_EVENT_OFFERS_ALL_B.USER_STATUS_ID
AMS_EVENT_OFFERS_ALL_B		AMS_USER_STATUSES_B	AMS_EVENT_OFFERS_ALL_B.EVENT_OFFER_ID
AMS_EVENT_REGISTRATIONS		AMS_USER_STATUSES_B	AMS_EVENT_REGISTRATIONS.USER_STATUS_ID
AMS_EVENT_REGISTRATIONS		AMS_USER_STATUSES_B	AMS_EVENT_REGISTRATIONS.USER_STATUS_ID
AMS_IMP_LIST_HEADERS_ALL		AMS_USER_STATUSES_B	AMS_IMP_LIST_HEADERS_ALL.USER_STATUS_ID
AMS_OFFERS		AMS_USER_STATUSES_B	AMS_OFFERS.USER_STATUS_ID
AMS_PRICE_LIST_ATTRIBUTES		AMS_USER_STATUSES_B	AMS_PRICE_LIST_ATTRIBUTES.USER_STATUS_ID
AMS_USER_STATUSES_TL		AMS_USER_STATUSES_B	AMS_USER_STATUSES_TL.USER_STATUS_ID
OZF_OFFERS		AMS_USER_STATUSES_B	OZF_OFFERS.USER_STATUS_ID
OZF_PRICE_LIST_ATTRIBUTES		AMS_USER_STATUSES_B	OZF_PRICE_LIST_ATTRIBUTES.USER_STATUS_ID
PV_PARTNER_PROGRAM_B		AMS_USER_STATUSES_B	PV_PARTNER_PROGRAM_B.USER_STATUS_ID