User contributions for Sherlock
From Sherlock Software
- 16:27, 3 January 2022 diff hist +483 N 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(..." current
- 16:24, 3 January 2022 diff hist +355 N 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 diff hist +384 N 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..." current
- 16:21, 3 January 2022 diff hist +508 N 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..." current
- 16:19, 3 January 2022 diff hist +388 N 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..." current
- 16:18, 3 January 2022 diff hist +443 N 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..." current
- 16:15, 3 January 2022 diff hist −311 JCM: Database tables
- 16:15, 3 January 2022 diff hist +781 N 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 ||..." current
- 16:10, 3 January 2022 diff hist +430 N 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..." current
- 16:07, 3 January 2022 diff hist +1,162 N 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 ||..." current
- 16:00, 3 January 2022 diff hist +477 N 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..." current
- 15:57, 3 January 2022 diff hist +1,795 N 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 ||..." current
- 15:46, 3 January 2022 diff hist +4,227 N 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..." current
- 15:41, 3 January 2022 diff hist +1,697 N 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 |..." current
- 15:38, 3 January 2022 diff hist +334 N 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 ||..." current
- 15:28, 3 January 2022 diff hist +12 JCM Table: dbo.AT InstitutionStudy current
- 15:23, 3 January 2022 diff hist +13 JCM Table: dbo.LT CaseSubtype
- 15:22, 3 January 2022 diff hist +634 N 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 diff hist +429 N 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 diff hist +4,281 N 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 diff hist +779 N 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..." current
- 15:09, 3 January 2022 diff hist +598 N 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 |- |..." current
- 15:07, 3 January 2022 diff hist +402 N 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..." current
- 15:06, 3 January 2022 diff hist +424 N 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..." current
- 15:04, 3 January 2022 diff hist +448 N 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..." current
- 15:03, 3 January 2022 diff hist +442 N 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..." current
- 15:01, 3 January 2022 diff hist +569 N 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..." current
- 03:31, 31 December 2021 diff hist +8 JCM Table: dbo.AT LastFileNo current
- 03:30, 31 December 2021 diff hist +500 N 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 diff hist +408 N 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 diff hist +410 N 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 diff hist +379 N 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 |..." current
- 03:21, 31 December 2021 diff hist +321 N 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..." current
- 23:51, 30 December 2021 diff hist +321 JCM Table: dbo.AT AccessLevel current
- 23:43, 30 December 2021 diff hist +252 JCM Table: dbo.ADM ReportUserType current
- 23:40, 30 December 2021 diff hist +49 JCM: Database tables
- 23:39, 30 December 2021 diff hist +85 JCM Table: dbo.ADM UserReportCategory current
- 23:36, 30 December 2021 diff hist +31 JCM: Database tables
- 23:36, 30 December 2021 diff hist +60 JCM Table: dbo.ADM ReportUserGroup current
- 23:34, 30 December 2021 diff hist +105 JCM: Database tables
- 23:29, 30 December 2021 diff hist +51 JCM Table: dbo.ADM GroupedReportUsers current
- 23:26, 30 December 2021 diff hist +8 JCM Table: dbo.ADM ReportAccessPermissions current
- 23:24, 30 December 2021 diff hist +26 JCM Table: dbo.ADM ReportAccessPermissions
- 23:23, 30 December 2021 diff hist +22 JCM Table: dbo.ADM ReportAccessPermissions
- 23:22, 30 December 2021 diff hist +71 JCM Table: dbo.ADM ReportAccessPermissions
- 17:43, 30 December 2021 diff hist +48 JCM: Database tables
- 17:43, 30 December 2021 diff hist +50 JCM Table: dbo.ADM GroupedReportUsers
- 17:34, 30 December 2021 diff hist +39 JCM Table: dbo.AT User current
- 17:32, 30 December 2021 diff hist +1,373 N 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..." current
- 17:27, 30 December 2021 diff hist +496 N 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 |-..." current
