JCM Table: dbo.DD PageLayouts

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