ROSTER_FILE_PERIOD

Description:

Contains a list of changes to a patient's roster status over time. The current values are also stored in the ROSTER_PERIOD table.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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	ROSTER_IDENTIFIER_C_NAME	VARCHAR	No
	The identifier of the roster file that included this patient. May contain organization-specific values: Yes
4	ROSTER_START_DATE	DATETIME	No
	The effective date of the roster period as indicated by the roster file.
5	ROSTER_TERM_DATE	DATETIME	No
	The termination date of the roster period as indicated by the roster file.
6	ROSTER_UPDATE_UTC_DTTM	DATETIME (UTC)	No
	The UTC instant when this roster line was added/updated.