ASSIGNMENT_DATA_LOADS

Description:

This table holds information about the individual loads that have contributed specific periods of roster assignment and provider attribution.

Primary Key

Column Name	Ordinal Position
ASGN_DATA_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ASGN_DATA_ID	NUMERIC	No
	The unique identifier (.1 item) for the assignment data 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	ASGN_LOAD_ID	NUMERIC	No
	The individual data loads that have contributed to this roster assignment period.
4	ASGN_LOAD_DEMOG_ID	NUMERIC	No
	The demographic set that this assignment data was received with in the individual data load.
5	LOAD_MESSAGE_ID	NUMERIC	No
	Holds the ID of the AMS record that most recently loaded data for a given timestamp.