FRM_STATUS

Description:

This table stores status and update information for screening forms, including form status and last editing user and time.

Primary Key

Column Name	Ordinal Position
SCREENING_FORM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SCREENING_FORM_ID	NUMERIC	No
	The unique identifier for the screening form record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	FRM_STATUS_C_NAME	VARCHAR	No
	The screening form status category ID for the screening form. May contain organization-specific values: No Category Entries: Created In Progress Pending Signatures Completed Nurse Doc Complete
4	STATUS_AUD_USER_ID	VARCHAR	No
	The users who updated or edited the screening form.
5	STATUS_AUD_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	STATUS_AUD_DTTM	DATETIME (UTC)	No
	The times when the screening form was updated or edited.