All public logs
From Sherlock Software
Combined display of all available logs of Sherlock Software. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)- 00:56, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT UserAlterID (Created page with "===TABLE NAME: dbo.AT_UserAlterID=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || UserName || nvarchar(50) || Login ID |- | 2 || UserID || i...")
- 00:52, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.LT DataCategory (Created page with "===TABLE NAME: dbo.LT_DataCategory=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CatAbbrev || char(1) || Data category code |- | 2 || Desc...")
- 00:44, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.LT Countries (Created page with "===TABLE NAME: dbo.LT_Countries=== Country name control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CountryID || smallint || |- | 2...")
- 00:38, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.LT EQ5D5LIndex (Created page with "===TABLE NAME: dbo.LT_EQ5D5LIndex=== EQ-5D-5L Index table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || HealthState || char(5) || Health stat...")
- 00:34, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.LT VinVPosition (Created page with "===TABLE NAME: dbo.LT_VinVPosition=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || VinVPositionID || smallint || |- | 2 || Desc || nvarchar(...")
- 00:31, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.LT CRFs (Created page with "===TABLE NAME: dbo.LT_CRFs=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ID || smallint || CRF id |- | 2 || Name || nvarchar(100) || CRF na...")
- 00:28, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.LT CaseType (Created page with "===TABLE NAME: dbo.LT_CaseType=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CaseTypeID || smallint || Study case type id |- | 2 || CaseTyp...")
- 00:25, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.LT AccessType (Created page with "===TABLE NAME: dbo.LT_AccessType=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || AccessTypeID || smallint || |- | 2 || AccessType || nvarcha...")
- 00:03, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.EL Source (Created page with "===TABLE NAME: dbo.EL_Source=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || SourceID || smallint || Source id |- | 2 || Desc || nvarchar(50)...")
- 20:25, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.EL Category (Created page with "===TABLE NAME: dbo.EL_Category=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CategoryID || tinyint || Category id |- | 2 || Desc || nvarcha...")
- 20:19, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.EL Level (Created page with "===TABLE NAME: dbo.EL_Level=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || LevelID || tinyint || Level id |- | 2 || Desc || nvarchar(50) ||...")
- 20:11, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.EL AccessType (Created page with "===TABLE NAME: dbo.EL_AccessType=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || AccessTypeID || tinyint || Activity type id |- | 2 || Desc |...") Tag: Visual edit: Switched
- 17:06, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.EL EventLog (Created page with "===TABLE NAME: dbo.EL_EventLog=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || EventLogID || bigint || Event log id |- | 2 || TimeCreated ||...")
- 16:57, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT Question (Created page with "===TABLE NAME: dbo.AT_Question=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || QuestionID || int || Question identifier |- | 2 || CategoryID...") Tag: Visual edit: Switched
- 16:50, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT User (Created page with "===TABLE NAME: dbo.AT_User=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || UserID || int || User identifier |- | 2 || UserType || tinyint ||...")
- 05:03, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.PT Case (Created page with "===TABLE NAME: dbo.PT_Case=== This table records the researched case and the main attributes related to the researched case. {| class="wikitable" |- ! Col ID !! Name !! Data T...")
- 04:52, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.PT Demographic (Created page with "===TABLE NAME: dbo.PT_Demographic=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || PatientID || int || Patient identifier |- | 2 || LastName |...")
- 04:46, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.PT Document (Created page with "===TABLE NAME: dbo.PT_Document=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || DocID || int || |- | 2 || CaseID || int || |- | 3 || DocType...")
- 04:11, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.PT Form (Created page with "===TABLE NAME: dbo.PT_Form=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || FormID || int || Form identifier |- | 2 || CaseID || int || Study...")
- 04:00, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT Institution (Created page with "===TABLE NAME: dbo.AT_Institution=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || InstitutionID || smallint || Institution identifier |- | 2...")
- 03:55, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT GroupCases (Created page with "===TABLE NAME: dbo.AT_GroupCases=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || GroupID || smallint || |- | 2 || PatientID || int || |- |...")
- 03:55, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT FormQuestionCategory (Created page with "===TABLE NAME: dbo.AT_FormQuestionCategory=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || FormTypeID || smallint || |- | 2 || PageNum || ti...")
- 03:54, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT FormPages (Created page with "===TABLE NAME: dbo.AT_FormPages=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || FormTypeID || smallint || |- | 2 || PageID || smallint || |...")
- 03:54, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT FormDataReviewStatus (Created page with "===TABLE NAME: dbo.AT_FormDataReviewStatus=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || FormID || int || |- | 2 || Complete || bit || |-...")
- 03:53, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT FormDataReview (Created page with "===TABLE NAME: dbo.AT_FormDataReview=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || FormID || int || |- | 2 || Category || nvarchar(255) ||...")
- 03:51, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT CaseStatus (Created page with "===TABLE NAME: dbo.AT_CaseStatus=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CaseTypeID || smallint || |- | 2 || StatusID || smallint ||...") Tag: Visual edit: Switched
- 03:49, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT Answer (Created page with "===TABLE NAME: dbo.AT_Answer=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || AnswerID || int || |- | 2 || QuestionID || int || |- | 3 || Us...")
- 03:49, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT AccessLevel (Created page with "===TABLE NAME: dbo.AT_AccessLevel=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || AccessLevelID || tinyint || |- | 2 || Desc || nvarchar(50)...")
- 03:49, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.ADM UserReportCategory (Created page with "===TABLE NAME: dbo.ADM_UserReportCategory=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || UserID || smallint || |- | 2 || ReportCategoryID |...")
- 03:48, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.ADM ReportUserType (Created page with "===TABLE NAME: dbo.ADM_ReportUserType=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || UserTypeID || tinyint || |- | 2 || Desc || nvarchar(50...")
- 03:48, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.ADM ReportUserGroup (Created page with "===TABLE NAME: dbo.ADM_ReportUserGroup=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || userGroupID || smallint || |- | 2 || desc || nvarchar...")
- 03:47, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.ADM ReportsByCategory (Created page with "===TABLE NAME: dbo.ADM_ReportsByCategory=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || categoryID || tinyint || |- | 2 || reportID || smal...")
- 03:47, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.ADM Reports (Created page with "===TABLE NAME: dbo.ADM_Reports=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || reportID || smallint || |- | 2 || reportName || nvarchar(100)...")
- 03:46, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.ADM ReportCategory (Created page with "===TABLE NAME: dbo.ADM_ReportCategory=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ID || tinyint || |- | 2 || Desc || nvarchar(50) || |-...")
- 03:46, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.ADM ReportAccessPermissions (Created page with "===TABLE NAME: dbo.ADM_ReportAccessPermissions=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || reportID || smallint || |- | 2 || userGroupID...")
- 03:45, 29 December 2021 Sherlock talk contribs created page JCM Table: dbo.ADM GroupedReportUsers (Created page with "===TABLE NAME: dbo.ADM_GroupedReportUsers=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || userID || smallint || |- | 2 || userGroupID || sma...")
- 03:45, 29 December 2021 Sherlock talk contribs created page JCM: Database tables (Created page with "{| class="wikitable" |- ! Schema !! Table Name !! Description |- | dbo || ADM_GroupedReportUsers || |- | dbo || JCM Table: dbo.ADM...")
- 15:23, 9 November 2021 Sherlock talk contribs deleted page File:Octofy Sum scatter.png (Deleted old revision 20211022140939!Octofy_Sum_scatter.png)
- 15:22, 9 November 2021 Sherlock talk contribs uploaded a new version of File:Octofy Sum scatter.png
- 15:22, 9 November 2021 Sherlock talk contribs deleted page File:Octofy Count scatter.png (Deleted old revision 20211022141013!Octofy_Count_scatter.png)
- 15:21, 9 November 2021 Sherlock talk contribs uploaded a new version of File:Octofy Count scatter.png
- 14:10, 22 October 2021 Sherlock talk contribs uploaded a new version of File:Octofy Count scatter.png
- 14:09, 22 October 2021 Sherlock talk contribs uploaded a new version of File:Octofy Sum scatter.png
- 23:36, 21 October 2021 Sherlock talk contribs uploaded File:Octofy Sum scatter.png (Octofy Sum scatter analysis)
- 23:36, 21 October 2021 Sherlock talk contribs created page File:Octofy Sum scatter.png (Octofy Sum scatter analysis)
- 23:36, 21 October 2021 Sherlock talk contribs uploaded File:Octofy Count scatter.png (Octofy Count scatter analysis)
- 23:36, 21 October 2021 Sherlock talk contribs created page File:Octofy Count scatter.png (Octofy Count scatter analysis)
- 23:57, 15 October 2021 Sherlock talk contribs created page File:Octofy Category distribution percentage.png (Octofy analysis type: category distribution percentage)
- 23:57, 15 October 2021 Sherlock talk contribs uploaded File:Octofy Category distribution percentage.png (Octofy analysis type: category distribution percentage)
- 19:59, 13 October 2021 Sherlock talk contribs uploaded File:Octofy Category percentile.png (Octory analysis type: Category percentiles and averages)