Difference between revisions of "JCM Table: dbo.LT Status"
From Sherlock Software
(Created page with "===TABLE NAME: dbo.LT_Status=== Study case status control table. {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CaseStatusID || smallint || Cas...") |
(No difference)
|
Latest revision as of 17:10, 30 December 2021
TABLE NAME: dbo.LT_Status
Study case status control table.
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | CaseStatusID | smallint | Case status id |
| 2 | CaseStatusName | nvarchar(50) | Status name |
| 3 | CaseStatusDesc | nvarchar(200) | Description |
Table Values:
| CaseStatusID | CaseStatusName | CaseStatusDesc |
|---|---|---|
| 1 | Active | Active case |
| 8888 | Reopened | Re-opened case |
| 9999 | Closed | Closed case |
Back to JCM Database tables
