Difference between revisions of "JCM: Database tables"

From Sherlock Software
Line 43: Line 43:
| dbo || [[JCM Table: dbo.AT_InstitutionForms|AT_InstitutionForms]] ||  
| dbo || [[JCM Table: dbo.AT_InstitutionForms|AT_InstitutionForms]] ||  
|-
|-
| 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]] ||  
|-
| dbo || [[JCM Table: dbo.AT_ObjectType|AT_ObjectType]] ||
|-
|-
| dbo || [[JCM Table: dbo.AT_OperationType|AT_OperationType]] ||  
| dbo || [[JCM Table: dbo.AT_OperationType|AT_OperationType]] ||  
|-
|-
| dbo || [[JCM Table: dbo.AT_PageDataCategory|AT_PageDataCategory]] ||  
| dbo || [[JCM Table: dbo.AT_PageDataCategory|AT_PageDataCategory]] ||  
|-
| dbo || [[JCM Table: dbo.AT_PageDesign|AT_PageDesign]] ||
|-
| dbo || [[JCM Table: dbo.AT_PageLanguage|AT_PageLanguage]] ||
|-
|-
| dbo || [[JCM Table: dbo.AT_PageSettings|AT_PageSettings]] ||  
| dbo || [[JCM Table: dbo.AT_PageSettings|AT_PageSettings]] ||  
Line 85: Line 79:
| dbo || [[JCM Table: dbo.AT_UserAlterID|AT_UserAlterID]] ||  
| dbo || [[JCM Table: dbo.AT_UserAlterID|AT_UserAlterID]] ||  
|-
|-
| 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]] ||  
Line 150: Line 144:
|-
|-
| dbo || [[JCM Table: dbo.LT_FormType|LT_FormType]] ||  
| dbo || [[JCM Table: dbo.LT_FormType|LT_FormType]] ||  
|-
| dbo || [[JCM Table: dbo.LT_ImageResource|LT_ImageResource]] ||
|-
|-
| dbo || [[JCM Table: dbo.LT_Language|LT_Language]] ||  
| dbo || [[JCM Table: dbo.LT_Language|LT_Language]] ||  
|-
| dbo || [[JCM Table: dbo.LT_Lookup|LT_Lookup]] ||
|-
| dbo || [[JCM Table: dbo.LT_LookupCategory|LT_LookupCategory]] ||
|-
|-
| dbo || [[JCM Table: dbo.LT_PersonType|LT_PersonType]] ||  
| dbo || [[JCM Table: dbo.LT_PersonType|LT_PersonType]] ||  

Revision as of 16:15, 3 January 2022

Schema Table Name Description
dbo ADM_GroupedReportUsers Record which user groups a user has joined.
dbo ADM_ReportAccessPermissions Record which user group can access which report.
dbo ADM_ReportCategory Record which category a report belongs to.
dbo ADM_Reports Report master table.
dbo ADM_ReportsByCategory
dbo ADM_ReportUserGroup Report user group master table.
dbo ADM_ReportUserType
dbo ADM_UserReportCategory Record which report categories a user can access.
dbo AT_AccessLevel
dbo AT_Answer
dbo AT_CaseStatus
dbo AT_FormDataReview
dbo AT_FormDataReviewStatus
dbo AT_FormPages
dbo AT_FormQuestionCategory
dbo AT_GroupCases
dbo AT_Institution
dbo AT_InstitutionByFunction
dbo AT_InstitutionCases
dbo AT_InstitutionForms
dbo AT_InstitutionFunction (Not in use)
dbo AT_InstitutionStudy Store the studies the institution has participated in
dbo AT_LastFileNo
dbo AT_OperationType
dbo AT_PageDataCategory
dbo AT_PageSettings
dbo AT_PageTopics
dbo AT_Person
dbo AT_PersonGroup
dbo AT_PersonGroupType
dbo AT_Question
dbo AT_QuestionCategory
dbo AT_SecureQuestion
dbo AT_StageForms
dbo AT_ToolTree
dbo AT_TrustedComputerUser
dbo AT_User System users
dbo AT_UserAlterID
dbo AT_UserCaseTypes (Not in use)
dbo AT_UserInstitution
dbo AT_UserPTCasePermission
dbo AT_UserType
dbo DD_Category
dbo DD_CategoryL2
dbo DD_ItemAction
dbo DD_Items
dbo DD_Lookups
dbo DD_PageLayouts
dbo EL_AccessType
dbo EL_Category
dbo EL_EventLog System auditing logs
dbo EL_Level
dbo EL_Source
dbo LT_AccessType
dbo LT_AnswerType
dbo LT_CaseSubtype
dbo LT_CaseType
dbo LT_Countries
dbo LT_CRFs
dbo LT_DataCategory
dbo LT_DataCategoryL2
dbo LT_DataType
dbo LT_DiseaseSeverity
dbo LT_DiseaseType
dbo LT_DiseaseValve
dbo LT_DocType
dbo LT_DrugClass
dbo LT_DrugName
dbo LT_EQ5D5LIndex
dbo LT_FollowupStage
dbo LT_FormType
dbo LT_Language
dbo LT_PersonType
dbo LT_ProcedureType
dbo LT_ProcessStatus
dbo LT_Provinces
dbo LT_QuestionCategory
dbo LT_RowStatus
dbo LT_Stages
dbo LT_Status
dbo LT_StudyProtocol
dbo LT_VinVPosition
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=375"