Page History

...

Dataset wrap

Name	rfip

Rowcaps

Rows 1-6:	Show the counts of subjects in each combination of the population and therefore only STRTM1/STRTM2/STRM3 are populated in the example. These counts are independent of any tobacco usage (or non-usage) and therefore STRTM4/STRVAL4 and STRTM5/STRVAL5 columns are null. The INPRM value contains the concept captured in INPRMVAL and INPRMU captures the unit of the INPRMVAL value.
Rows 7-15:	Show initial tobacco usage status for several product combinations and the prevalence of each usage status.

Dataset2

tableid	RFIP

Row	STRTM1	STRVAL1	STRTM2	STRVAL2	STRTM3	STRVAL3	STRTM4	STRVAL4	STRTM5	STRVAL5	INPRM	INPRMVAL	INPRMU	REFSRCE
1	AGE	0	SEX	M	RACE	WHITE					POPULATION COUNT	50	COUNT	initial population 2017.xlsx
2	AGE	10	SEX	M	RACE	WHITE					POPULATION COUNT	48	COUNT	initial population 2017.xlsx
3	AGE	20	SEX	M	RACE	WHITE					POPULATION COUNT	49	COUNT	initial population 2017.xlsx
4	AGE	30	SEX	M	RACE	WHITE					POPULATION COUNT	50	COUNT	initial population 2017.xlsx
5	AGE	40	SEX	M	RACE	WHITE					POPULATION COUNT	51	COUNT	initial population 2017.xlsx
6	AGE	50	SEX	M	RACE	WHITE					POPULATION COUNT	52	COUNT	initial population 2017.xlsx
7	AGE	0	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	NEVER	PREVALENCE	70	PERCENT	initial population 2017.xlsx
8	AGE	10	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	NEVER	PREVALENCE	68	PERCENT	initial population 2017.xlsx
9	AGE	20	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	CURRENT	PREVALENCE	10	PERCENT	initial population 2017.xlsx
10	AGE	30	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	CURRENT	PREVALENCE	14	PERCENT	initial population 2017.xlsx
11	AGE	40	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	FORMER	PREVALENCE	16	PERCENT	initial population 2017.xlsx
12	AGE	50	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	FORMER	PREVALENCE	17	PERCENT	initial population 2017.xlsx
13	AGE	20	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE/ENDS	TOBACCO PRODUCT USE STATUS	FORMER/CURRENT	PREVALENCE	20	PERCENT	initial population 2017.xlsx
14	AGE	30	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE/ENDS	TOBACCO PRODUCT USE STATUS	FORMER/CURRENT	PREVALENCE	25	PERCENT	initial population 2017.xlsx
15	AGE	40	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS	CURRENT/CURRENT	PREVALENCE	10	PERCENT	initial population 2017.xlsx

...

Definexmltable

Dataset	RFIP
Name	RFIP

Variable Name	Variable Label	Type	Codelist/Controlled Terms	Core	Notes
STRTM1	Stratum 1	text	AGE	Req	populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the left-most column in this example
STRVAL1	Stratum 1 Value	text		Req	populate with the STRTM1 values in the source data (Age in this example)
STRTM2	Stratum 2	text	SEX	Cond	populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the lower level of the fifth column in this example
STRVAL2	Stratum 2 Value	text	M;F	Cond	populate with the STRTM2 values in the source data (Sex in this example)
STRTM3	Stratum 3	text	RACE	Cond	populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the upper level of the fifth column in this example
STRVAL3	Stratum 3 Value	text	WhiteWHITE	Cond	populate with the STRTM3 values in the source data (Race in this example)
STRTM4	Stratum 4	text	TOBACCO PRODUCT CATEGORY	Cond	populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier)
STRVAL4	Stratum 4 Value	text	CIGARETTE;CIGARETTE/ENDS;CIGARETTE/CIGAR	Cond	populate with the STRTM4 values in the source data
STRTM5	Stratum 5	text	TOBACCO PRODUCT USE STATUS	Cond	populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier)
STRVAL5	Stratum 5 Value	text	NEVER;CURRENT;FORMER;FORMER/CURRENT;CURRENT/CURRENT	Cond	populate with the STRTM5 values in the source data
INPRM	Input Parameter	text	POPULATION COUNT;PREVALENCE	Req	populate with the concept describing the value in the cell being captured in the dataset. it may come from a spreadsheet tab name, a spreadsheet name, or any desired parameter identifying value
INPRMVAL	Input Parameter Value	float		Req	populate with the cell value from the referenced data that is being described by the STRMVALy values
INPRMU	Input Parameter Unit	text	COUNT;PERCENT	Perm	populate with the unit describing the cell values if appropriate
REFSRCE	Reference Data Source	text	initial population 2017.xlsx	Perm	populate with the file that is the source of the reference data (the same columns and rows will change over time so identifying the source allows for traceability)

Page tree

Versions Compared

Old Version 49

New Version 50

Key