HH_OASIS_LOCK

Description:

Contains information on the locked status of Home Health Outcome and Assessment Information Set (OASIS) data sets.

Primary Key

Column Name	Ordinal Position
OASIS_SET_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	OASIS_SET_ID	NUMERIC	No
	Unique identifier for the OASIS data set.
2	CONTACT_DATE_REAL	FLOAT	No
	Unique identifier for this contact for this patient.
3	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
4	OASIS_LOCK_STAT_C_NAME	VARCHAR	No
	OASIS data set locked status, locked or unlocked. Links to category table ZC_OASIS_LOCK_STAT. May contain organization-specific values: No Category Entries: Unlocked Locked
5	OASIS_LOCK_USER_ID	VARCHAR	No
	User ID of the user who locked the OASIS data set. Links to table CLARITY_EMP.
6	OASIS_LOCK_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	OASIS_LOCK_INSTANT	DATETIME (Attached)	No
	Instant at which the OASIS data set was locked.
8	OASIS_SNAPSHOT_DAT	VARCHAR	No
	The contact pointer to the OASIS snapshot data.