All public logs

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)

• 17:00, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT UserPTCasePermission (Created page with "===TABLE NAME: dbo.AT_UserPTCasePermission=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || PersonID || int || |- | 2 || CaseTypeID || smalli...")
• 16:59, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT UserCaseTypes (Created page with "===TABLE NAME: dbo.AT_UserCaseTypes=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || UserID || int || |- | 2 || CaseTypeID || smallint || |}...")
• 16:59, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT ToolTree (Created page with "===TABLE NAME: dbo.AT_ToolTree=== (Not in use) {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ID || smallint || |- | 2 || ParentID || smallint...")
• 16:59, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT StageForms (Created page with "===TABLE NAME: dbo.AT_StageForms=== (Not in use) {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || StageID || tinyint || |- | 2 || FormTypeID ||...")
• 16:58, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT QuestionCategory (Created page with "===TABLE NAME: dbo.AT_QuestionCategory=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CategoryID || smallint || |- | 2 || Category || varch...")
• 16:57, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT PageTopics (Created page with "===TABLE NAME: dbo.AT_PageTopics=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || PageID || smallint || |- | 2 || CategoryID || smallint ||...")
• 16:57, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT PageDataCategory (Created page with "===TABLE NAME: dbo.AT_PageDataCategory=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || PageID || smallint || |- | 2 || CategoryID || smallin...")
• 16:57, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT InstitutionFunction (Created page with "===TABLE NAME: dbo.AT_InstitutionFunction=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || FunctionID || smallint || |- | 2 || FunctionName |...")
• 16:27, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT SecureQuestion (Created page with "===TABLE NAME: dbo.AT_SecureQuestion=== User login secure questions. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || DomainUserName || nvarchar(...")
• 16:24, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT TrustedComputerUser (Created page with "===TABLE NAME: dbo.AT_TrustedComputerUser=== Record trusted computers. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CPUID || nvarchar(50) ||...")
• 16:23, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.DD ItemAction (Created page with "===TABLE NAME: dbo.DD_ItemAction=== (Not in use) {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ItemID || int || |- | 2 || ActionType || varch...")
• 16:21, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT UserType (Created page with "===TABLE NAME: dbo.AT_UserType=== User type control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || UserTypeID || tinyint || User type ID...")
• 16:19, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT PersonGroupType (Created page with "===TABLE NAME: dbo.AT_PersonGroupType=== Personal group control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || PersonGroupID || smallint...")
• 16:18, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT PersonGroup (Created page with "===TABLE NAME: dbo.AT_PersonGroup=== Record persons in a personal group. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || PersonGroupID || smalli...")
• 16:15, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT PageSettings (Created page with "===TABLE NAME: dbo.AT_PageSettings=== CRF page settings {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || pageID || smallint || Page ID |- | 2 ||...")
• 16:10, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT OperationType (Created page with "===TABLE NAME: dbo.AT_OperationType=== Optional type control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || TypeID || tinyint || Operati...")
• 16:07, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.DD PageLayouts (Created page with "===TABLE NAME: dbo.DD_PageLayouts=== Record how data variables are used in the CRF. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ID || int ||...")
• 16:00, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.DD Lookups (Created page with "===TABLE NAME: dbo.DD_Lookups=== Data dictionary codelists table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ItemID || int || ID of data di...")
• 15:57, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.DD Items (Created page with "===TABLE NAME: dbo.DD_Items=== Data dictionary items. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ID || int || Dictionary item ID |- | 2 ||...")
• 15:46, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.DD CategoryL2 (Created page with "===TABLE NAME: dbo.DD_CategoryL2=== Level 2 categor of data dictionary control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CatID || s...")
• 15:41, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.DD Category (Created page with "===TABLE NAME: dbo.DD_Category=== Category of data dictionary control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CatID || smallint |...")
• 15:38, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.AT UserInstitution (Created page with "===TABLE NAME: dbo.AT_UserInstitution=== Record the institutions the user can access. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || UserID ||...")
• 15:22, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.LT CaseSubtype (Created page with "===TABLE NAME: dbo.LT_CaseSubtype=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CaseSubtypeID || smallint || Study case subtype ID |- | 2 |...")
• 15:20, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.LT AnswerType (Created page with "===TABLE NAME: dbo.LT_AnswerType=== Anwser control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || AnswerTypeID || tinyint || Answer type...")
• 15:17, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.LT DataCategoryL2 (Created page with "===TABLE NAME: dbo.LT_DataCategoryL2=== Data variable category control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CatID || tinyint |...")
• 15:10, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.LT DataType (Created page with "===TABLE NAME: dbo.LT_DataType=== Variable data type control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || DataTypeID || tinyint || Dat...")
• 15:09, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.LT Stages (Created page with "===TABLE NAME: dbo.LT_Stages=== Study stages control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || StageID || tinyint || Stage ID |- |...")
• 15:07, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.LT QuestionCategory (Created page with "===TABLE NAME: dbo.LT_QuestionCategory=== Question category control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CategoryID || smallin...")
• 15:06, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.LT Provinces (Created page with "===TABLE NAME: dbo.LT_Provinces=== Province control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ProvinceID || smallint || Province ID...")
• 15:04, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.LT ProcessStatus (Created page with "===TABLE NAME: dbo.LT_ProcessStatus=== (Not in use) {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ProcessStatusID || tinyint || Process status...")
• 15:03, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.LT PersonType (Created page with "===TABLE NAME: dbo.LT_PersonType=== Personal type control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || PersonTypeID || tinyint || Pers...")
• 15:01, 3 January 2022 Sherlock talk contribs created page JCM Table: dbo.LT ProcedureType (Created page with "===TABLE NAME: dbo.LT_ProcedureType=== Procedure type control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ProcedureTypeID || smallint...")
• 03:30, 31 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT LastFileNo (Created page with "===TABLE NAME: dbo.AT_LastFileNo=== Record last patient file number used in an institution so that the system can generate next available file number automatically. {| class="...")
• 03:26, 31 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT InstitutionStudy (Created page with "===TABLE NAME: dbo.AT_InstitutionStudy=== Record studies a institution participated. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || Institution...")
• 03:23, 31 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT InstitutionForms (Created page with "===TABLE NAME: dbo.AT_InstitutionForms=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || InstitutionID || smallint || ID of institution |- | 2...")
• 03:22, 31 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT InstitutionCases (Created page with "===TABLE NAME: dbo.AT_InstitutionCases=== Record study cases of the institution. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || InstitutionID |...")
• 03:21, 31 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT InstitutionByFunction (Created page with "===TABLE NAME: dbo.AT_InstitutionByFunction=== (Not in use) {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || FunctionID || smallint || ID of func...")
• 17:32, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.AT Person (Created page with "===TABLE NAME: dbo.AT_Person=== System personnel master table. The table records all persons present in the system. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! De...")
• 17:27, 30 December 2021 Sherlock talk contribs created page JCM Table: dbo.LT Language (Created page with "===TABLE NAME: dbo.LT_Language=== Form language control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || ID || smallint || Language id |-...")
• 17:23, 30 December 2021 Sherlock talk contribs created page 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 Sherlock talk contribs created page 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...")
• 17:14, 30 December 2021 Sherlock talk contribs created page 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...")
• 17:10, 30 December 2021 Sherlock talk contribs created page 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...")
• 17:08, 30 December 2021 Sherlock talk contribs created page 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 Sherlock talk contribs created page 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 Sherlock talk contribs created page 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...")
• 01:06, 30 December 2021 Sherlock talk contribs created page 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...")
• 01:03, 30 December 2021 Sherlock talk contribs created page 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 Sherlock talk contribs created page 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 Sherlock talk contribs created page 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 |-...")

(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)