JCM Table: dbo.DD PageLayouts
From Sherlock Software
TABLE NAME: dbo.DD_PageLayouts
Record how data variables are used in the CRF.
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | ID | int | Identifier |
| 2 | PageID | smallint | ID of CRF page |
| 3 | DataCategory | nvarchar(50) | Data category |
| 4 | DDItemID | int | ID of data dictionary item |
| 5 | Code | varchar(10) | System code |
| 6 | Locations | varchar(100) | (internal use) |
| 7 | Attributes | varchar(255) | (internal use) |
| 8 | Caption | nvarchar(1024) | Caption of the variable |
| 9 | Caption_zh | nvarchar(1024) | Caption of the variable (Chinese, not in use) |
| 10 | CaptionLocation | varchar(50) | (internal use) |
| 11 | CaptionAttributes | varchar(255) | (internal use) |
| 12 | SortOrder | smallint | (internal use) |
| 13 | OptionValues | nvarchar(1024) | (internal use) |
| 14 | ControlName | varchar(100) | (internal use) |
| 15 | DataFieldName | varchar(100) | Data field name in the XML document |
| 16 | CategoryID | smallint | ID of the category |
Back to JCM Database tables
