APPT_CSN_COUNTS

Description:

This table contains the appointment contact serial numbers (CSNs) linked to an authorization as well as the counts used for each CSN.

Primary Key

Column Name	Ordinal Position
AUTH_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	AUTH_ID	NUMERIC	No
	The authorization ID for the authorization 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	LINKED_APPT_CSNS	NUMERIC	No
	The contact serial numbers (CSNs) of all the appointments which fall within the dates on the authorization record.
4	LINKED_APPT_COUNTS	INTEGER	No
	The used counts corresponding to a particular contact serial number (CSN) in the LINKED_APPT_CSN column linked to an Authorization record.
5	USR_OVR_VST_COUNT_YN	VARCHAR	No
	Flag to say user has overridden the visit counts. May contain organization-specific values: No Category Entries: No Yes