User contributions for Sherlock
From Sherlock Software
- 17:24, 30 December 2021 diff hist +25 JCM Table: dbo.LT FormType current
- 17:23, 30 December 2021 diff hist +1,139 N JCM Table: dbo.LT FormType Created page with "===TABLE NAME: dbo.LT_FormType=== Type of clinical trials form(CRF) control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || FormTypeID ||..."
- 17:15, 30 December 2021 diff hist +689 N JCM Table: dbo.LT DiseaseValve Created page with "===TABLE NAME: dbo.LT_DiseaseValve=== Cariac disease valve control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || DiseaseValveID || smal..." current
- 17:14, 30 December 2021 diff hist +931 N JCM Table: dbo.LT FollowupStage Created page with "===TABLE NAME: dbo.LT_FollowupStage=== Patient follow-up timings control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || StageID || tinyi..." current
- 17:10, 30 December 2021 diff hist +590 N JCM Table: dbo.LT Status Created page with "===TABLE NAME: dbo.LT_Status=== Study case status control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CaseStatusID || smallint || Cas..." current
- 17:08, 30 December 2021 diff hist +395 N JCM Table: dbo.LT StudyProtocol Created page with "===TABLE NAME: dbo.LT_StudyProtocol=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || StudyProtocolID || smallint || Study protocol id |- | 2 |..."
- 17:06, 30 December 2021 diff hist +402 N JCM Table: dbo.LT RowStatus Created page with "===TABLE NAME: dbo.LT_RowStatus=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || RowStatus || tinyint || Row status id |- | 2 || Desc || nvarc..."
- 01:07, 30 December 2021 diff hist +476 N JCM Table: dbo.LT DrugName Created page with "===TABLE NAME: dbo.LT_DrugName=== Medication name control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || DrugID || smallint || Medicatio..." current
- 01:06, 30 December 2021 diff hist +395 N JCM Table: dbo.LT DrugClass Created page with "===TABLE NAME: dbo.LT_DrugClass=== Medication class control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || DrugClassID || smallint || Me..." current
- 01:03, 30 December 2021 diff hist +511 N JCM Table: dbo.LT DocType Created page with "===TABLE NAME: dbo.LT_DocType=== Document type of attachment. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || DocTypeID || tinyint || Document t..."
- 01:01, 30 December 2021 diff hist +697 N JCM Table: dbo.LT DiseaseType Created page with "===TABLE NAME: dbo.LT_DiseaseType=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || DiseaseTypeID || smallint || Disease type ID |- | 2 || Dise..."
- 00:58, 30 December 2021 diff hist +576 N JCM Table: dbo.LT DiseaseSeverity Created page with "===TABLE NAME: dbo.LT_DiseaseSeverity=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || DiseaseSeverityID || smallint || Disease severity ID |-..."
- 00:56, 30 December 2021 diff hist +273 N 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 diff hist +1,421 N 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:47, 30 December 2021 diff hist +58 JCM Table: dbo.LT Countries →TABLE NAME: dbo.LT_Countries current
- 00:46, 30 December 2021 diff hist +13,301 JCM Table: dbo.LT Countries
- 00:44, 30 December 2021 diff hist +416 N 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:41, 30 December 2021 diff hist −193 JCM: Database tables
- 00:38, 30 December 2021 diff hist +772 N 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..." current
- 00:34, 30 December 2021 diff hist +415 N 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 diff hist +384 N 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 diff hist +580 N 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 diff hist +619 N 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 diff hist +798 N 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 diff hist +398 N 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:21, 29 December 2021 diff hist +28 JCM Table: dbo.EL EventLog current
- 20:19, 29 December 2021 diff hist +394 N 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:14, 29 December 2021 diff hist +33 JCM Table: dbo.EL EventLog
- 20:11, 29 December 2021 diff hist +948 N 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
- 19:55, 29 December 2021 diff hist +117 JCM: Database tables Tag: Visual edit
- 17:06, 29 December 2021 diff hist +883 N 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 diff hist +587 N 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:51, 29 December 2021 diff hist +9 JCM Table: dbo.AT User →TABLE NAME: dbo.AT_User Tag: Visual edit
- 16:50, 29 December 2021 diff hist +965 N 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 diff hist +2,092 N 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..." current
- 04:52, 29 December 2021 diff hist +1,549 N 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 |..." current
- 04:46, 29 December 2021 diff hist +639 N 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..." current
- 04:13, 29 December 2021 diff hist +1 JCM Table: dbo.PT Form current
- 04:12, 29 December 2021 diff hist +45 JCM Table: dbo.PT Form
- 04:11, 29 December 2021 diff hist +936 N 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:04, 29 December 2021 diff hist −213 JCM: Database tables
- 04:02, 29 December 2021 diff hist −144 JCM: Database tables
- 04:00, 29 December 2021 diff hist +1,127 N 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 diff hist +313 N 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 diff hist +306 N 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 diff hist +293 N 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 diff hist +289 N 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 diff hist +405 N 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 diff hist +261 N 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:50, 29 December 2021 diff hist −13 m JCM Table: dbo.AT Answer Tag: Visual edit