PATIENT_FYI_FLAGS

Description:

This table will extract Patient FYI flags from the Notes (HNO) database. These are notes with a Patient Flag Type (I HNO 560) that is not null.

Primary Key

Column Name	Ordinal Position
NOTE_ID	1

Column Information

	Name	Type	Discontinued?
1	NOTE_ID	VARCHAR	No
	The unique identifier of the note (HNO)
2	DELETED_CAT_C_NAME	VARCHAR	No
	Indicates the Deleted Status of this Note record in Chronicles. May contain organization-specific values: No Category Entries: DELETED Hidden DELETED and Hidden
3	ACTIVE_C_NAME	VARCHAR	No
	Indicates if this Patient FYI Flag will be shown as an Active or Inactive flag. May contain organization-specific values: No Category Entries: Active Inactive
4	ENTRY_PERSON_ID	VARCHAR	No
	The unique identifier of the user (EMP) who created this Patient FYI Flag.
5	ENTRY_PERSON_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	ACCT_NOTE_INSTANT	DATETIME (Local)	No
	The instant at which this FYI flag was created.
7	ACCT_NOTE_SUMMARY	VARCHAR	No
	The brief free text summary statement about the Patient FYI.
8	PAT_FLAG_TYPE_C_NAME	VARCHAR	No
	The type of Patient FYI Flag. This is a customer owned list. May contain organization-specific values: Yes Category Entries: General Release Restrictions Sedation Legal Review Externally-Entered Coverage Tracked Locked Restricted Data Test Patient Deprecated - Drug Seeker Deprecated - Research Participant Radiation Therapy Patient Opt Out of Payer Record Exchange PCP Change CMS RO Model CP-IS: Child Protection Plan CP-IS: Looked After Child CP-IS: Unborn Child Protection Plan Protection Order Custody Compliance Packager Patient NEHR Patient Properties Risk of Violence History of Violence Professional Billing Exchange Demographics Review Needed Known Non-Test Patient
9	PT_FG_PURGABLE_YN	VARCHAR	No
	Indicates whether a batch can purge this patient flag. A Y indicates the flag can be purged. N indicates the flag cannot be purged. May contain organization-specific values: No Category Entries: Yes No
10	PAT_ENC_CSN_ID	NUMERIC	No
	The Patient Encounter this Patient FYI is associated with. This field may be null, if the FYI is at the patient level rather than contact specific.