Difference between revisions of "JCM: Database tables"

From Sherlock Software
 
(9 intermediate revisions by the same user not shown)
Line 3: Line 3:
! Schema !! Table Name !! Description
! Schema !! Table Name !! Description
|-
|-
| dbo || [[JCM Table: dbo.ADM_GroupedReportUsers|ADM_GroupedReportUsers]] ||  
| dbo || [[JCM Table: dbo.ADM_GroupedReportUsers|ADM_GroupedReportUsers]] || Records which user groups a user has joined.
|-
|-
| dbo || [[JCM Table: dbo.ADM_ReportAccessPermissions|ADM_ReportAccessPermissions]] ||  
| dbo || [[JCM Table: dbo.ADM_ReportAccessPermissions|ADM_ReportAccessPermissions]] || Records which user group can access which report.
|-
|-
| dbo || [[JCM Table: dbo.ADM_ReportCategory|ADM_ReportCategory]] ||  
| dbo || [[JCM Table: dbo.ADM_ReportCategory|ADM_ReportCategory]] || Records which category a report belongs to.
|-
|-
| dbo || [[JCM Table: dbo.ADM_Reports|ADM_Reports]] ||  
| dbo || [[JCM Table: dbo.ADM_Reports|ADM_Reports]] || Report master table.
|-
|-
| dbo || [[JCM Table: dbo.ADM_ReportsByCategory|ADM_ReportsByCategory]] ||  
| dbo || [[JCM Table: dbo.ADM_ReportsByCategory|ADM_ReportsByCategory]] || Stores relationship among reports, report categories, and institutions.
|-
|-
| dbo || [[JCM Table: dbo.ADM_ReportUserGroup|ADM_ReportUserGroup]] ||  
| dbo || [[JCM Table: dbo.ADM_ReportUserGroup|ADM_ReportUserGroup]] || Report user group master table.
|-
|-
| dbo || [[JCM Table: dbo.ADM_ReportUserType|ADM_ReportUserType]] ||  
| dbo || [[JCM Table: dbo.ADM_ReportUserType|ADM_ReportUserType]] || Type of report user look-up table.
|-
|-
| dbo || [[JCM Table: dbo.ADM_UserReportCategory|ADM_UserReportCategory]] ||  
| dbo || [[JCM Table: dbo.ADM_UserReportCategory|ADM_UserReportCategory]] || Records which report categories a user can access.
|-
|-
| dbo || [[JCM Table: dbo.AT_AccessLevel|AT_AccessLevel]] ||  
| dbo || [[JCM Table: dbo.AT_AccessLevel|AT_AccessLevel]] || The look-up table of access scope of the CRFs.
|-
|-
| dbo || [[JCM Table: dbo.AT_Answer|AT_Answer]] ||  
| dbo || [[JCM Table: dbo.AT_Answer|AT_Answer]] || Records answers to the question of a user asked in a CRF.
|-
|-
| dbo || [[JCM Table: dbo.AT_CaseStatus|AT_CaseStatus]] ||  
| dbo || [[JCM Table: dbo.AT_CaseStatus|AT_CaseStatus]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_FormDataReview|AT_FormDataReview]] ||  
| dbo || [[JCM Table: dbo.AT_FormDataReview|AT_FormDataReview]] || Records data adulting review results.
|-
|-
| dbo || [[JCM Table: dbo.AT_FormDataReviewStatus|AT_FormDataReviewStatus]] ||  
| dbo || [[JCM Table: dbo.AT_FormDataReviewStatus|AT_FormDataReviewStatus]] || Records data variable adulting review results in a CRF.
|-
|-
| dbo || [[JCM Table: dbo.AT_FormPages|AT_FormPages]] ||  
| dbo || [[JCM Table: dbo.AT_FormPages|AT_FormPages]] || Records the pages in a form.
|-
|-
| dbo || [[JCM Table: dbo.AT_FormQuestionCategory|AT_FormQuestionCategory]] ||  
| dbo || [[JCM Table: dbo.AT_FormQuestionCategory|AT_FormQuestionCategory]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_GroupCases|AT_GroupCases]] ||  
| dbo || [[JCM Table: dbo.AT_GroupCases|AT_GroupCases]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_Institution|AT_Institution]] ||  
| dbo || [[JCM Table: dbo.AT_Institution|AT_Institution]] || Master table of institutions.
|-
|-
| dbo || [[JCM Table: dbo.AT_InstitutionByFunction|AT_InstitutionByFunction]] ||  
| dbo || [[JCM Table: dbo.AT_InstitutionByFunction|AT_InstitutionByFunction]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_InstitutionCases|AT_InstitutionCases]] ||  
| dbo || [[JCM Table: dbo.AT_InstitutionCases|AT_InstitutionCases]] || Records study cases of the institution.
|-
|-
| dbo || [[JCM Table: dbo.AT_InstitutionForms|AT_InstitutionForms]] ||  
| dbo || [[JCM Table: dbo.AT_InstitutionForms|AT_InstitutionForms]] || Records CRFs available for an institution.
|-
|-
| dbo || [[JCM Table: dbo.AT_InstitutionFunction|AT_InstitutionFunction]] ||  
| dbo || [[JCM Table: dbo.AT_InstitutionFunction|AT_InstitutionFunction]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_InstitutionStudy|AT_InstitutionStudy]] ||  
| dbo || [[JCM Table: dbo.AT_InstitutionStudy|AT_InstitutionStudy]] || Store the studies the institution has participated in.
|-
|-
| dbo || [[JCM Table: dbo.AT_LastFileNo|AT_LastFileNo]] ||  
| dbo || [[JCM Table: dbo.AT_LastFileNo|AT_LastFileNo]] || Record the last patient file number used in an institution.
|-
|-
| dbo || [[JCM Table: dbo.AT_ObjectType|AT_ObjectType]] ||  
| dbo || [[JCM Table: dbo.AT_OperationType|AT_OperationType]] || Optional type control table.
|-
|-
| dbo || [[JCM Table: dbo.AT_OperationType|AT_OperationType]] ||  
| dbo || [[JCM Table: dbo.AT_PageDataCategory|AT_PageDataCategory]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_PageDataCategory|AT_PageDataCategory]] ||  
| dbo || [[JCM Table: dbo.AT_PageSettings|AT_PageSettings]] || CRF page settings
|-
|-
| dbo || [[JCM Table: dbo.AT_PageDesign|AT_PageDesign]] ||  
| dbo || [[JCM Table: dbo.AT_PageTopics|AT_PageTopics]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_PageLanguage|AT_PageLanguage]] ||  
| dbo || [[JCM Table: dbo.AT_Person|AT_Person]] || System personnel master table.
|-
|-
| dbo || [[JCM Table: dbo.AT_PageSettings|AT_PageSettings]] ||  
| dbo || [[JCM Table: dbo.AT_PersonGroup|AT_PersonGroup]] || Records persons in a personal group.
|-
|-
| dbo || [[JCM Table: dbo.AT_PageTopics|AT_PageTopics]] ||  
| dbo || [[JCM Table: dbo.AT_PersonGroupType|AT_PersonGroupType]] || Personal group control table.
|-
|-
| dbo || [[JCM Table: dbo.AT_Person|AT_Person]] ||  
| dbo || [[JCM Table: dbo.AT_Question|AT_Question]] || Records questions regarding a CRF form data.
|-
|-
| dbo || [[JCM Table: dbo.AT_PersonGroup|AT_PersonGroup]] ||  
| dbo || [[JCM Table: dbo.AT_QuestionCategory|AT_QuestionCategory]] || Question category control table.
|-
|-
| dbo || [[JCM Table: dbo.AT_PersonGroupType|AT_PersonGroupType]] ||  
| dbo || [[JCM Table: dbo.AT_SecureQuestion|AT_SecureQuestion]] || User login secure questions.
|-
|-
| dbo || [[JCM Table: dbo.AT_Question|AT_Question]] ||  
| dbo || [[JCM Table: dbo.AT_StageForms|AT_StageForms]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_QuestionCategory|AT_QuestionCategory]] ||  
| dbo || [[JCM Table: dbo.AT_ToolTree|AT_ToolTree]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_SecureQuestion|AT_SecureQuestion]] ||
| dbo || [[JCM Table: dbo.AT_TrustedComputerUser|AT_TrustedComputerUser]] || Record trusted user account and computer.
|-
| dbo || [[JCM Table: dbo.AT_StageForms|AT_StageForms]] ||
|-
| dbo || [[JCM Table: dbo.AT_ToolTree|AT_ToolTree]] ||
|-
| dbo || [[JCM Table: dbo.AT_TrustedComputerUser|AT_TrustedComputerUser]] ||  
|-
|-
| dbo || [[JCM Table: dbo.AT_User|AT_User]] || System users
| dbo || [[JCM Table: dbo.AT_User|AT_User]] || System users
|-
|-
| dbo || [[JCM Table: dbo.AT_UserAlterID|AT_UserAlterID]] ||  
| dbo || [[JCM Table: dbo.AT_UserAlterID|AT_UserAlterID]] || Records alternative user login name.
|-
|-
| dbo || [[JCM Table: dbo.AT_UserCaseTypes|AT_UserCaseTypes]] ||  
| dbo || [[JCM Table: dbo.AT_UserCaseTypes|AT_UserCaseTypes]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_UserInstitution|AT_UserInstitution]] ||  
| dbo || [[JCM Table: dbo.AT_UserInstitution|AT_UserInstitution]] || Records the institutions the user can access.
|-
|-
| dbo || [[JCM Table: dbo.AT_UserPTCasePermission|AT_UserPTCasePermission]] ||  
| dbo || [[JCM Table: dbo.AT_UserPTCasePermission|AT_UserPTCasePermission]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.AT_UserType|AT_UserType]] ||  
| dbo || [[JCM Table: dbo.AT_UserType|AT_UserType]] || Records alternative user login name.
|-
|-
| dbo || [[JCM Table: dbo.DD_Category|DD_Category]] ||  
| dbo || [[JCM Table: dbo.DD_Category|DD_Category]] || Category of data dictionary control table.
|-
|-
| dbo || [[JCM Table: dbo.DD_CategoryL2|DD_CategoryL2]] ||  
| dbo || [[JCM Table: dbo.DD_CategoryL2|DD_CategoryL2]] || Level 2 categor of data dictionary control table.
|-
|-
| dbo || [[JCM Table: dbo.DD_ItemAction|DD_ItemAction]] ||  
| dbo || [[JCM Table: dbo.DD_ItemAction|DD_ItemAction]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.DD_Items|DD_Items]] ||  
| dbo || [[JCM Table: dbo.DD_Items|DD_Items]] || Data dictionary items table.
|-
|-
| dbo || [[JCM Table: dbo.DD_Lookups|DD_Lookups]] ||  
| dbo || [[JCM Table: dbo.DD_Lookups|DD_Lookups]] || Data dictionary codelists table.
|-
|-
| dbo || [[JCM Table: dbo.DD_PageLayouts|DD_PageLayouts]] ||  
| dbo || [[JCM Table: dbo.DD_PageLayouts|DD_PageLayouts]] || Record how data variables are used in the CRF.
|-
|-
| dbo || [[JCM Table: dbo.EL_AccessType|EL_AccessType]] ||  
| dbo || [[JCM Table: dbo.EL_AccessType|EL_AccessType]] || System auditing logs access type control table.
|-
|-
| dbo || [[JCM Table: dbo.EL_Category|EL_Category]] ||  
| dbo || [[JCM Table: dbo.EL_Category|EL_Category]] || System auditing logs category control table.
|-
|-
| dbo || [[JCM Table: dbo.EL_EventLog|EL_EventLog]] || System auditing logs
| dbo || [[JCM Table: dbo.EL_EventLog|EL_EventLog]] || System auditing logs
|-
|-
| dbo || [[JCM Table: dbo.EL_Level|EL_Level]] ||  
| dbo || [[JCM Table: dbo.EL_Level|EL_Level]] || System auditing logs warning level control table.
|-
| dbo || [[JCM Table: dbo.EL_Source|EL_Source]] ||
|-
| dbo || [[JCM Table: dbo.LT_AccessType|LT_AccessType]] ||
|-
| dbo || [[JCM Table: dbo.LT_AnswerType|LT_AnswerType]] ||
|-
|-
| dbo || [[JCM Table: dbo.LT_CaseSubtype|LT_CaseSubtype]] ||  
| dbo || [[JCM Table: dbo.EL_Source|EL_Source]] || System auditing logs data source control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_CaseType|LT_CaseType]] ||  
| dbo || [[JCM Table: dbo.LT_AccessType|LT_AccessType]] || System auditing logs data source control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_Countries|LT_Countries]] ||  
| dbo || [[JCM Table: dbo.LT_AnswerType|LT_AnswerType]] || Question anwser type control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_CRFs|LT_CRFs]] ||  
| dbo || [[JCM Table: dbo.LT_CaseSubtype|LT_CaseSubtype]] || Study case subtype control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_DataCategory|LT_DataCategory]] ||  
| dbo || [[JCM Table: dbo.LT_CaseType|LT_CaseType]] || Study case type control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_DataCategoryL2|LT_DataCategoryL2]] ||  
| dbo || [[JCM Table: dbo.LT_Countries|LT_Countries]] || Country name control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_DataType|LT_DataType]] ||  
| dbo || [[JCM Table: dbo.LT_CRFs|LT_CRFs]] || CRF settings control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_DiseaseSeverity|LT_DiseaseSeverity]] ||  
| dbo || [[JCM Table: dbo.LT_DataCategory|LT_DataCategory]] || Study data variable category control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_DiseaseType|LT_DiseaseType]] ||  
| dbo || [[JCM Table: dbo.LT_DataCategoryL2|LT_DataCategoryL2]] || Level 2 data variable category control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_DiseaseValve|LT_DiseaseValve]] ||  
| dbo || [[JCM Table: dbo.LT_DataType|LT_DataType]] || Variable data type control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_DocType|LT_DocType]] ||  
| dbo || [[JCM Table: dbo.LT_DiseaseSeverity|LT_DiseaseSeverity]] || Disease severity control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_DrugClass|LT_DrugClass]] ||  
| dbo || [[JCM Table: dbo.LT_DiseaseType|LT_DiseaseType]] || Valve disease type control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_DrugName|LT_DrugName]] ||  
| dbo || [[JCM Table: dbo.LT_DiseaseValve|LT_DiseaseValve]] || Cariac disease valve control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_EQ5D5LIndex|LT_EQ5D5LIndex]] ||  
| dbo || [[JCM Table: dbo.LT_DocType|LT_DocType]] || Document type of attachment control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_FollowupStage|LT_FollowupStage]] ||  
| dbo || [[JCM Table: dbo.LT_DrugClass|LT_DrugClass]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.LT_FormType|LT_FormType]] ||  
| dbo || [[JCM Table: dbo.LT_DrugName|LT_DrugName]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.LT_ImageResource|LT_ImageResource]] ||  
| dbo || [[JCM Table: dbo.LT_EQ5D5LIndex|LT_EQ5D5LIndex]] || EQ-5D-5L scores index table.
|-
|-
| dbo || [[JCM Table: dbo.LT_Language|LT_Language]] ||  
| dbo || [[JCM Table: dbo.LT_FollowupStage|LT_FollowupStage]] || Patient follow-up visit timings control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_Lookup|LT_Lookup]] ||  
| dbo || [[JCM Table: dbo.LT_FormType|LT_FormType]] || Type of clinical trials form(CRF) control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_LookupCategory|LT_LookupCategory]] ||  
| dbo || [[JCM Table: dbo.LT_Language|LT_Language]] || Form language control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_PersonType|LT_PersonType]] ||  
| dbo || [[JCM Table: dbo.LT_PersonType|LT_PersonType]] || Personal type control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_ProcedureType|LT_ProcedureType]] ||  
| dbo || [[JCM Table: dbo.LT_ProcedureType|LT_ProcedureType]] || THV procedure type control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_ProcessStatus|LT_ProcessStatus]] ||  
| dbo || [[JCM Table: dbo.LT_ProcessStatus|LT_ProcessStatus]] || (Not in use)
|-
|-
| dbo || [[JCM Table: dbo.LT_Provinces|LT_Provinces]] ||  
| dbo || [[JCM Table: dbo.LT_Provinces|LT_Provinces]] || Province control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_QuestionCategory|LT_QuestionCategory]] ||  
| dbo || [[JCM Table: dbo.LT_QuestionCategory|LT_QuestionCategory]] || Question category control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_RowStatus|LT_RowStatus]] ||  
| dbo || [[JCM Table: dbo.LT_RowStatus|LT_RowStatus]] || Record status control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_Stages|LT_Stages]] ||  
| dbo || [[JCM Table: dbo.LT_Stages|LT_Stages]] || Study stages control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_Status|LT_Status]] ||  
| dbo || [[JCM Table: dbo.LT_Status|LT_Status]] || Study case status control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_StudyProtocol|LT_StudyProtocol]] ||  
| dbo || [[JCM Table: dbo.LT_StudyProtocol|LT_StudyProtocol]] || Study protocol control table.
|-
|-
| dbo || [[JCM Table: dbo.LT_VinVPosition|LT_VinVPosition]] ||  
| dbo || [[JCM Table: dbo.LT_VinVPosition|LT_VinVPosition]] || Valve-in-valve control table.
|-
|-
| dbo || [[JCM Table: dbo.PT_Case|PT_Case]] || Clinical trials study cases
| dbo || [[JCM Table: dbo.PT_Case|PT_Case]] || Clinical trials study cases

Latest revision as of 18:49, 3 January 2022

Schema Table Name Description
dbo ADM_GroupedReportUsers Records which user groups a user has joined.
dbo ADM_ReportAccessPermissions Records which user group can access which report.
dbo ADM_ReportCategory Records which category a report belongs to.
dbo ADM_Reports Report master table.
dbo ADM_ReportsByCategory Stores relationship among reports, report categories, and institutions.
dbo ADM_ReportUserGroup Report user group master table.
dbo ADM_ReportUserType Type of report user look-up table.
dbo ADM_UserReportCategory Records which report categories a user can access.
dbo AT_AccessLevel The look-up table of access scope of the CRFs.
dbo AT_Answer Records answers to the question of a user asked in a CRF.
dbo AT_CaseStatus (Not in use)
dbo AT_FormDataReview Records data adulting review results.
dbo AT_FormDataReviewStatus Records data variable adulting review results in a CRF.
dbo AT_FormPages Records the pages in a form.
dbo AT_FormQuestionCategory (Not in use)
dbo AT_GroupCases (Not in use)
dbo AT_Institution Master table of institutions.
dbo AT_InstitutionByFunction (Not in use)
dbo AT_InstitutionCases Records study cases of the institution.
dbo AT_InstitutionForms Records CRFs available for an institution.
dbo AT_InstitutionFunction (Not in use)
dbo AT_InstitutionStudy Store the studies the institution has participated in.
dbo AT_LastFileNo Record the last patient file number used in an institution.
dbo AT_OperationType Optional type control table.
dbo AT_PageDataCategory (Not in use)
dbo AT_PageSettings CRF page settings
dbo AT_PageTopics (Not in use)
dbo AT_Person System personnel master table.
dbo AT_PersonGroup Records persons in a personal group.
dbo AT_PersonGroupType Personal group control table.
dbo AT_Question Records questions regarding a CRF form data.
dbo AT_QuestionCategory Question category control table.
dbo AT_SecureQuestion User login secure questions.
dbo AT_StageForms (Not in use)
dbo AT_ToolTree (Not in use)
dbo AT_TrustedComputerUser Record trusted user account and computer.
dbo AT_User System users
dbo AT_UserAlterID Records alternative user login name.
dbo AT_UserCaseTypes (Not in use)
dbo AT_UserInstitution Records the institutions the user can access.
dbo AT_UserPTCasePermission (Not in use)
dbo AT_UserType Records alternative user login name.
dbo DD_Category Category of data dictionary control table.
dbo DD_CategoryL2 Level 2 categor of data dictionary control table.
dbo DD_ItemAction (Not in use)
dbo DD_Items Data dictionary items table.
dbo DD_Lookups Data dictionary codelists table.
dbo DD_PageLayouts Record how data variables are used in the CRF.
dbo EL_AccessType System auditing logs access type control table.
dbo EL_Category System auditing logs category control table.
dbo EL_EventLog System auditing logs
dbo EL_Level System auditing logs warning level control table.
dbo EL_Source System auditing logs data source control table.
dbo LT_AccessType System auditing logs data source control table.
dbo LT_AnswerType Question anwser type control table.
dbo LT_CaseSubtype Study case subtype control table.
dbo LT_CaseType Study case type control table.
dbo LT_Countries Country name control table.
dbo LT_CRFs CRF settings control table.
dbo LT_DataCategory Study data variable category control table.
dbo LT_DataCategoryL2 Level 2 data variable category control table.
dbo LT_DataType Variable data type control table.
dbo LT_DiseaseSeverity Disease severity control table.
dbo LT_DiseaseType Valve disease type control table.
dbo LT_DiseaseValve Cariac disease valve control table.
dbo LT_DocType Document type of attachment control table.
dbo LT_DrugClass (Not in use)
dbo LT_DrugName (Not in use)
dbo LT_EQ5D5LIndex EQ-5D-5L scores index table.
dbo LT_FollowupStage Patient follow-up visit timings control table.
dbo LT_FormType Type of clinical trials form(CRF) control table.
dbo LT_Language Form language control table.
dbo LT_PersonType Personal type control table.
dbo LT_ProcedureType THV procedure type control table.
dbo LT_ProcessStatus (Not in use)
dbo LT_Provinces Province control table.
dbo LT_QuestionCategory Question category control table.
dbo LT_RowStatus Record status control table.
dbo LT_Stages Study stages control table.
dbo LT_Status Study case status control table.
dbo LT_StudyProtocol Study protocol control table.
dbo LT_VinVPosition Valve-in-valve control table.
dbo PT_Case Clinical trials study cases
dbo PT_Demographic Patient demographics
dbo PT_Document Other attached documents
dbo PT_Form CRF data forms
Retrieved from "https://www.sherlocksoftwareinc.com/wiki/index.php?title=JCM:_Database_tables&oldid=428"