JCM: Database tables
From Sherlock Software
| 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 | |
| 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 |
