Difference between revisions of "JCM Table: dbo.EL EventLog"
From Sherlock Software
| Line 8: | Line 8: | ||
| 2 || TimeCreated || datetime || Date and time the log was created | | 2 || TimeCreated || datetime || Date and time the log was created | ||
|- | |- | ||
| 3 || LevelID || tinyint || Log importance level | | 3 || [[JCM Table: dbo.EL_Level|LevelID]] || tinyint || Log importance level | ||
|- | |- | ||
| 4 || CategoryID || tinyint || Log category id | | 4 || CategoryID || tinyint || Log category id | ||
Latest revision as of 20:21, 29 December 2021
TABLE NAME: dbo.EL_EventLog
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | EventLogID | bigint | Event log id |
| 2 | TimeCreated | datetime | Date and time the log was created |
| 3 | LevelID | tinyint | Log importance level |
| 4 | CategoryID | tinyint | Log category id |
| 5 | SourceID | smallint | Source id |
| 6 | AccessTypeID | tinyint | Activity type id |
| 7 | PersonID | int | Log related user id |
| 8 | PatientID | int | Log related patient id |
| 9 | EntityID | int | Log related entity id |
| 10 | InstitutionID | smallint | Log related institution id |
| 11 | EventData | xml | Record backup before relevant content are modified |
| 12 | LastUpdateDate | timestamp | Timestamp for prevent tampering |
Back to JCM Database tables
