Difference between revisions of "JCM: Database tables"

From Sherlock Software
Line 87: Line 87:
| dbo || [[JCM Table: dbo.AT_TrustedComputerUser|AT_TrustedComputerUser]] ||  
| dbo || [[JCM Table: dbo.AT_TrustedComputerUser|AT_TrustedComputerUser]] ||  
|-
|-
| dbo || [[JCM Table: dbo.AT_User|AT_User]] ||  
| dbo || [[JCM Table: dbo.AT_User|AT_User]] || System users
|-
|-
| dbo || [[JCM Table: dbo.AT_UserAlterID|AT_UserAlterID]] ||  
| dbo || [[JCM Table: dbo.AT_UserAlterID|AT_UserAlterID]] ||  
Line 115: Line 115:
| dbo || [[JCM Table: dbo.EL_Category|EL_Category]] ||  
| dbo || [[JCM Table: dbo.EL_Category|EL_Category]] ||  
|-
|-
| dbo || [[JCM Table: dbo.EL_EventLog|EL_EventLog]] ||  
| dbo || [[JCM Table: dbo.EL_EventLog|EL_EventLog]] || System auditing logs
|-
|-
| dbo || [[JCM Table: dbo.EL_Level|EL_Level]] ||  
| dbo || [[JCM Table: dbo.EL_Level|EL_Level]] ||  
Line 185: Line 185:
| dbo || [[JCM Table: dbo.LT_VinVPosition|LT_VinVPosition]] ||  
| dbo || [[JCM Table: dbo.LT_VinVPosition|LT_VinVPosition]] ||  
|-
|-
| dbo || [[JCM Table: dbo.PT_Case|PT_Case]] ||  
| dbo || [[JCM Table: dbo.PT_Case|PT_Case]] || Clinical trials study cases
|-
|-
| dbo || [[JCM Table: dbo.PT_Demographic|PT_Demographic]] ||  
| dbo || [[JCM Table: dbo.PT_Demographic|PT_Demographic]] || Patient demographics
|-
|-
| dbo || [[JCM Table: dbo.PT_Document|PT_Document]] ||  
| dbo || [[JCM Table: dbo.PT_Document|PT_Document]] || Other attached documents
|-
|-
| dbo || [[JCM Table: dbo.PT_Form|PT_Form]] ||  
| dbo || [[JCM Table: dbo.PT_Form|PT_Form]] || CRF data forms
|}
|}
[[Category: JCM]]
[[Category: JCM]]

Revision as of 19:55, 29 December 2021

Schema Table Name Description
dbo ADM_GroupedReportUsers
dbo ADM_ReportAccessPermissions
dbo ADM_ReportCategory
dbo ADM_ReportIcons
dbo ADM_Reports
dbo ADM_ReportsByCategory
dbo ADM_ReportUserGroup
dbo ADM_ReportUserType
dbo ADM_UserReportCategory
dbo AT_AccessGroup
dbo AT_AccessLevel
dbo AT_Answer
dbo AT_CaseStatus
dbo AT_DBColumns
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