New pages

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

• 17:00, 3 January 2022 ‎JCM Table: dbo.AT UserPTCasePermission (hist | edit) ‎[321 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT UserCaseTypes (hist | edit) ‎[257 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT ToolTree (hist | edit) ‎[439 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT StageForms (hist | edit) ‎[272 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT QuestionCategory (hist | edit) ‎[451 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT PageTopics (hist | edit) ‎[307 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT PageDataCategory (hist | edit) ‎[313 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT InstitutionFunction (hist | edit) ‎[279 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT SecureQuestion (hist | edit) ‎[483 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT TrustedComputerUser (hist | edit) ‎[371 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.DD ItemAction (hist | edit) ‎[384 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT UserType (hist | edit) ‎[508 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT PersonGroupType (hist | edit) ‎[388 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT PersonGroup (hist | edit) ‎[443 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT PageSettings (hist | edit) ‎[781 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT OperationType (hist | edit) ‎[430 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.DD PageLayouts (hist | edit) ‎[1,162 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.DD Lookups (hist | edit) ‎[477 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.DD Items (hist | edit) ‎[1,795 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.DD CategoryL2 (hist | edit) ‎[4,227 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.DD Category (hist | edit) ‎[1,697 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT UserInstitution (hist | edit) ‎[334 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT CaseSubtype (hist | edit) ‎[681 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT AnswerType (hist | edit) ‎[434 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT DataCategoryL2 (hist | edit) ‎[4,289 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT DataType (hist | edit) ‎[779 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT Stages (hist | edit) ‎[598 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT QuestionCategory (hist | edit) ‎[402 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT Provinces (hist | edit) ‎[424 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT ProcessStatus (hist | edit) ‎[448 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT PersonType (hist | edit) ‎[442 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT ProcedureType (hist | edit) ‎[569 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT LastFileNo (hist | edit) ‎[508 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT InstitutionStudy (hist | edit) ‎[420 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT InstitutionForms (hist | edit) ‎[453 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT InstitutionCases (hist | edit) ‎[379 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT InstitutionByFunction (hist | edit) ‎[321 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.AT Person (hist | edit) ‎[1,373 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT Language (hist | edit) ‎[496 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT FormType (hist | edit) ‎[1,164 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT DiseaseValve (hist | edit) ‎[689 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT FollowupStage (hist | edit) ‎[931 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT Status (hist | edit) ‎[590 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT StudyProtocol (hist | edit) ‎[425 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT RowStatus (hist | edit) ‎[431 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT DrugName (hist | edit) ‎[476 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT DrugClass (hist | edit) ‎[395 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT DocType (hist | edit) ‎[525 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT DiseaseType (hist | edit) ‎[731 bytes] ‎Sherlock (talk | contribs) (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 ‎JCM Table: dbo.LT DiseaseSeverity (hist | edit) ‎[608 bytes] ‎Sherlock (talk | contribs) (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)