IMG_COMP_FILM_CHNG

Description:

This stores comparison film change amounts. It relates to table IMG_COMP_FILMS and they can be joined using the ORDER_ID and LINE columns.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier (.1 item) for the order 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	FILM_CHNG_AMT_C_NAME	VARCHAR	No
	Contains the amount of change from a comparison film. The actual film or chart record can be obtained by joining this table to IMG_COMP_FILMS using the ORDER_ID and LINE columns. May contain organization-specific values: Yes Category Entries: No Comparison No Significant Change Significant Change Not Otherwise Specified