MC_NOTIFICATIONS

Description:

This table contains information relating to Tapestry notifications sent to members.

Primary Key

Column Name	Ordinal Position
OUTREACH_ID	1
CONTACT_DATE_REAL	2

Column Information

	Name	Type	Discontinued?
1	OUTREACH_ID	NUMERIC	No
	The unique identifier (.1 item) for the outreach record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	PB_ACCT_ID	VARCHAR	No
	The premium billing account record ID associated with the member for this communication.
4	PAYMENT_ID	VARCHAR	No
	The premium payment record ID associated with the communication to the member.
5	PB_INVC_ID	VARCHAR	No
	The premium invoice record ID related to the communication being sent to the member.
6	COVERAGE_ID	NUMERIC	No
	The coverage record ID related to the communication being sent to the member.
7	ESTIMATE_ID	NUMERIC	No
	The estimate record ID related to the communication being sent to the member.
8	CLAIM_ID	NUMERIC	No
	The claim record ID related to the communication being sent to the member.
9	EOB_DOCUMENT_ID	VARCHAR	No
	The periodic Explanation of Benefits document record ID associated with the communication being sent.