JCM Table: dbo.LT Status
From Sherlock Software
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
