Difference between revisions of "JCM Table: dbo.AT AccessLevel"
From Sherlock Software
(Created page with "===TABLE NAME: dbo.AT_AccessLevel=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || AccessLevelID || tinyint || |- | 2 || Desc || nvarchar(50)...") |
|||
| Line 1: | Line 1: | ||
===TABLE NAME: dbo.AT_AccessLevel=== | ===TABLE NAME: dbo.AT_AccessLevel=== | ||
The look-up table of access scope of the CRFs. | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Col ID !! Name !! Data Type !! Description | ! Col ID !! Name !! Data Type !! Description | ||
|- | |- | ||
| 1 || AccessLevelID || tinyint || | | 1 || AccessLevelID || tinyint || Access level ID | ||
|- | |- | ||
| 2 || Desc || nvarchar(50) || | | 2 || Desc || nvarchar(50) || Description | ||
|} | |} | ||
</br> | </br> | ||
Table Values: | |||
{| class="wikitable" | |||
|- | |||
! AccessLevelID !! Desc | |||
|- | |||
| 0 || Access to patients within a specified access group | |||
|- | |||
| 1 || Access to the CRFs of patients in the same hospital as the user | |||
|- | |||
| 2 || Access to CRFs of all patients | |||
|} | |||
</br> | |||
---- | ---- | ||
Back to [[JCM: Database tables|JCM Database tables]] | Back to [[JCM: Database tables|JCM Database tables]] | ||
[[Category: JCM]] | [[Category: JCM]] | ||
Latest revision as of 23:51, 30 December 2021
TABLE NAME: dbo.AT_AccessLevel
The look-up table of access scope of the CRFs.
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | AccessLevelID | tinyint | Access level ID |
| 2 | Desc | nvarchar(50) | Description |
Table Values:
| AccessLevelID | Desc |
|---|---|
| 0 | Access to patients within a specified access group |
| 1 | Access to the CRFs of patients in the same hospital as the user |
| 2 | Access to CRFs of all patients |
Back to JCM Database tables
