New pages
From Sherlock Software
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
- 00:56, 30 December 2021 JCM Table: dbo.AT UserAlterID (hist | edit) [309 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.LT DataCategory (hist | edit) [1,465 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.LT Countries (hist | edit) [13,775 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.LT EQ5D5LIndex (hist | edit) [772 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.LT VinVPosition (hist | edit) [445 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.LT CRFs (hist | edit) [412 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.LT CaseType (hist | edit) [611 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.LT AccessType (hist | edit) [660 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.EL Source (hist | edit) [846 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.EL Category (hist | edit) [443 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.EL Level (hist | edit) [444 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.EL AccessType (hist | edit) [996 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.EL EventLog (hist | edit) [944 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT Question (hist | edit) [632 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT User (hist | edit) [1,013 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.PT Case (hist | edit) [2,092 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.PT Demographic (hist | edit) [1,549 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.PT Document (hist | edit) [639 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.PT Form (hist | edit) [982 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT Institution (hist | edit) [1,157 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT GroupCases (hist | edit) [326 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT FormQuestionCategory (hist | edit) [319 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT FormPages (hist | edit) [360 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT FormDataReviewStatus (hist | edit) [392 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT FormDataReview (hist | edit) [554 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT CaseStatus (hist | edit) [306 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT Answer (hist | edit) [576 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.AT AccessLevel (hist | edit) [585 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.ADM UserReportCategory (hist | edit) [358 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.ADM ReportUserType (hist | edit) [556 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.ADM ReportUserGroup (hist | edit) [329 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.ADM ReportsByCategory (hist | edit) [496 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.ADM Reports (hist | edit) [635 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.ADM ReportCategory (hist | edit) [323 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.ADM ReportAccessPermissions (hist | edit) [403 bytes] Sherlock (talk | contribs) (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 JCM Table: dbo.ADM GroupedReportUsers (hist | edit) [370 bytes] Sherlock (talk | contribs) (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 JCM: Database tables (hist | edit) [8,488 bytes] Sherlock (talk | contribs) (Created page with "{| class="wikitable" |- ! Schema !! Table Name !! Description |- | dbo || ADM_GroupedReportUsers || |- | dbo || JCM Table: dbo.ADM...")
