JCM: Database tables

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