CLARITY_DEP

Description:

The CLARITY_DEP table contains high-level information about departments.

Primary Key

Column Name	Ordinal Position
DEPARTMENT_ID	1

Column Information

	Name	Type	Discontinued?
1	DEPARTMENT_ID	NUMERIC	No
	The unique ID number assigned to the department record.
2	DEPARTMENT_NAME	VARCHAR	No
	The name of the department.
3	EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.