FA_NOTES_QUERY

Description:

This table contains information about queries sent to retrieve financial information for patients and/or patient contacts in a financial assistance case record.

Primary Key

Column Name	Ordinal Position
NOTE_ID	1

Column Information

	Name	Type	Discontinued?
1	NOTE_ID	VARCHAR	No
	The unique identifier for the note record.
2	QUERY_PERSON_USER_ID	VARCHAR	No
	The unique ID associated with the user record who triggered the query. This column is frequently used to link to the CLARITY_EMP table.
3	QUERY_PERSON_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
4	QUERY_DATE	DATETIME	No
	The date when the query was triggered.
5	QUERY_TRIGGER_SOURCE_C_NAME	VARCHAR	No
	The trigger source category ID for the query. May contain organization-specific values: No Category Entries: User Background Process Batch Job