ASSIGNMENT_DATA

Description:

This table holds the patients and roster identifiers for whom specific roster assignment data was loaded.

Primary Key

Column Name	Ordinal Position
ASGN_DATA_ID	1

Column Information

	Name	Type	Discontinued?
1	ASGN_DATA_ID	NUMERIC	No
	The unique identifier (.1 item) for the assignment data record.
2	RECORD_STATUS_2_C_NAME	VARCHAR	No
	Stores the record status (hidden, soft-deleted, etc...) May contain organization-specific values: No Category Entries: Soft Deleted Hidden Hidden and Soft Deleted
3	ROSTER_IDENTIFIER_C_NAME	VARCHAR	No
	The roster population that this record contains tracking data for. May contain organization-specific values: Yes Category Entries: general LFM Rost CFB Roster
4	PAT_ID	VARCHAR	No
	The patient for whom this record contains roster tracking data.
5	ASSIGNMENT_EFF_DATE	DATETIME	No
	The start date of the roster assignment period.
6	ASSIGNMENT_TERM_DATE	DATETIME	No
	The end date of the roster assignment period.
7	ATTRIBUTED_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
8	LAST_MODIFIED_INSTANT_UTC_DTTM	DATETIME (UTC)	No
	The instant that this roster assignment period was last loaded or backed out.
9	EXTERNAL_DEMOG_ID	NUMERIC	No
	The unique ID of the External Demographic Set that this assignment is loaded to.
10	EXTERNAL_IDENT_BUNDLE_ID	NUMERIC	No
	The unique ID of the External System Identifier Bundle that this assignment is loaded to.