Difference between revisions of "JCM: Database tables"

From Sherlock Software
Line 8: Line 8:
|-
|-
| dbo || [[JCM Table: dbo.ADM_ReportCategory|ADM_ReportCategory]] ||  
| dbo || [[JCM Table: dbo.ADM_ReportCategory|ADM_ReportCategory]] ||  
|-
| dbo || [[JCM Table: dbo.ADM_ReportIcons|ADM_ReportIcons]] ||
|-
|-
| dbo || [[JCM Table: dbo.ADM_Reports|ADM_Reports]] ||  
| dbo || [[JCM Table: dbo.ADM_Reports|ADM_Reports]] ||  
Line 20: Line 18:
|-
|-
| dbo || [[JCM Table: dbo.ADM_UserReportCategory|ADM_UserReportCategory]] ||  
| dbo || [[JCM Table: dbo.ADM_UserReportCategory|ADM_UserReportCategory]] ||  
|-
| dbo || [[JCM Table: dbo.AT_AccessGroup|AT_AccessGroup]] ||
|-
|-
| dbo || [[JCM Table: dbo.AT_AccessLevel|AT_AccessLevel]] ||  
| dbo || [[JCM Table: dbo.AT_AccessLevel|AT_AccessLevel]] ||  
Line 28: Line 24:
|-
|-
| dbo || [[JCM Table: dbo.AT_CaseStatus|AT_CaseStatus]] ||  
| dbo || [[JCM Table: dbo.AT_CaseStatus|AT_CaseStatus]] ||  
|-
| dbo || [[JCM Table: dbo.AT_DBColumns|AT_DBColumns]] ||
|-
|-
| dbo || [[JCM Table: dbo.AT_FormDataReview|AT_FormDataReview]] ||  
| dbo || [[JCM Table: dbo.AT_FormDataReview|AT_FormDataReview]] ||  

Revision as of 00:41, 30 December 2021

Schema Table Name Description
dbo ADM_GroupedReportUsers
dbo ADM_ReportAccessPermissions
dbo ADM_ReportCategory
dbo ADM_Reports
dbo ADM_ReportsByCategory
dbo ADM_ReportUserGroup
dbo ADM_ReportUserType
dbo ADM_UserReportCategory
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
dbo AT_InstitutionStudy
dbo AT_LastFileNo
dbo AT_ObjectType
dbo AT_OperationType
dbo AT_PageDataCategory
dbo AT_PageDesign
dbo AT_PageLanguage
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
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_ImageResource
dbo LT_Language
dbo LT_Lookup
dbo LT_LookupCategory
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