JCM Table: dbo.AT Institution

TABLE NAME: dbo.AT_Institution

Master table of institutions.

Col ID	Name	Data Type	Description
1	InstitutionID	smallint	Institution identifier
2	InstitutionCode	varchar(5)	Institution code
3	InstitutionAbbrev	nvarchar(5)	Institution abbreviation
4	InstitutionName	nvarchar(100)	Institution full name
5	InstitutionDisplayName	nvarchar(100)	Institution name for display
6	HACode	char(2)	Health authorities code (not in use)
7	Address1	nvarchar(100)	Address line 1
8	Address2	nvarchar(100)	Address line 2
9	City	nvarchar(50)	City
10	Province	nvarchar(50)	Province
11	PostalCode	nvarchar(25)	Postal code
12	CountryID	smallint	Country id
13	Phone	nvarchar(25)	Main phone number
14	Fax	nvarchar(25)	Fax number
15	RowIsActive	bit	Row active indicator
16	InstitutionName_en	nvarchar(100)	Institution name (english)

---

Back to JCM Database tables