Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes
STRTM1Stratum 1textAgeAGEReqpopulate 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

integer??text
Reqpopulate with the STRTM1 values in the source data (Age in this example)
STRTM2Stratum 2

text

SexSEXCondpopulate 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

textM;FCondpopulate with the STRTM2 values in the source data (Sex in this example)
STRTM3Stratum 3textRaceCondpopulate 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

textWhiteCondpopulate with the STRTM3 values in the source data (Race in this example)
INPRMInput ParametertextINITIAL POPULATION COUNT;PREVALENCEReqpopulate 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
INPRMVALInput Parameter Valuefloat
Reqpopulate with the cell value from the referenced data that is being described by the STRMVALy values
INPRMUInput Parameter Unittext

COUNT/;PERCENT

Permpopulate with the unit describing the cell values if appropriate
REFSRCEReference Data SourceTEXTBIRTHRATE.xlsxPermpopulate 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)

STRTM1

STRVAL1

STRTM2

STRVAL2STRTM3STRVAL3
STRTM4
STRVAL4
INPRMINPRMVALINPRMU
AGE0SEXMRACEWHITEPOPULATION COUNT50COUNT
AGE10SEXMRACEWHITEPOPULATION COUNT48COUNT
AGE20SEXMRACEWHITEPOPULATION COUNT49COUNT
AGE30SEXMRACEWHITEPOPULATION COUNT50COUNT
AGE40SEXMRACEWHITEPOPULATION COUNT51COUNT
AGE50SEXMRACEWHITEPOPULATION COUNT52COUNT
AGE0SEXMRACEWHITE
PRODUCT USE STATE
NEVER
PREVALENCE
100
70PERCENT
AGE10SEXMRACEWHITE
PRODUCT USE STATE
NEVER
PREVALENCE
0
68PERCENT
AGE20SEXMRACEWHITE
PRODUCT USE STATENEVER
PREVALENCE
0
69PERCENT
AGE30SEXMRACEWHITE
PRODUCT USE STATENEVER
PREVALENCE
0
70PERCENT
AGE40SEXMRACEWHITE
PRODUCT USE STATENEVER
PREVALENCE
.001
72PERCENT
AGE50SEXMRACEWHITE
PRODUCT USE STATENEVER
PREVALENCE
.001
71PERCENT