JCM Table: dbo.LT FormType
From Sherlock Software
TABLE NAME: dbo.LT_FormType
Type of clinical trials form(CRF) control table.
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | FormTypeID | smallint | Form type id |
| 2 | CaseTypeID | smallint | Study case type id |
| 3 | FormName | nvarchar(200) | Form name |
| 4 | FormLabel | nvarchar(200) | Form label |
| 5 | ObjectName | nvarchar(100) | Object name (not in use) |
| 6 | FormNS | nvarchar(255) | Form data xml name space |
| 7 | FormDef | xml | Form definitions (not in use) |
| 8 | SortOrder | smallint | Display sort order |
| 9 | AllowMultiple | bit | Allow multiple forms indicator |
| 10 | RowIsActive | bit | Row active indicator |
| 11 | Namespaces | varchar(255) | |
| 12 | formSettings | xml | Form settings |
| 13 | ExpiryDate | date | Form expiry date |
| 14 | Mutations | nvarchar(-1) | Mutations from base form definition |
| 15 | CRFID | smallint | CRF id |
| 16 | Timing | nvarchar(25) | Form timing |
| 17 | TimingZh | nvarchar(25) | Form timing (Chinese) |
Back to JCM Database tables
