V_EHI_PBA_NOTES_MC_PBA

Description:

This view filters out account data that is not appropriate for member level EHI exports when group billing is used.

Primary Key

Column Name	Ordinal Position
NOTE_ID	1

Column Information

	Name	Type	Discontinued?
1	NOTE_ID	VARCHAR	No
	The unique identifier of a note attached to the account.
2	NOTE_DATE	DATETIME	No
	The date when the note was created. This column contains date information only. Column NOTE_DATETIME holds date and time information.
3	NOTE_USER_ID	VARCHAR	No
	The unique identifier of the user that created the note.
4	NOTE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	PB_ACCT_ID	VARCHAR	No
	The unique identifier of the Premium Billing account.
6	NOTE_LOCAL_DTTM	DATETIME (Local)	No
	The date and time the note was created.