JCM Table: dbo.ADM ReportsByCategory
From Sherlock Software
TABLE NAME: dbo.ADM_ReportsByCategory
Stores relationship among reports, report categories, and institutions.
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | categoryID | tinyint | ID of report category |
| 2 | reportID | smallint | ID of report |
| 3 | institutionAbbrev | char(5) | Abbreviation of institution |
| 4 | sortOrder | tinyint | Display sort order |
Back to JCM Database tables
