JCM: Database tables

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
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