Versions Compared

Key

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

...

Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes
STRTM1Stratum 1textyearYEARReqpopulate 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 (years 2000-2050 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 first part of the second column concept in this example

STRVAL2

Stratum 2 Value

textM;FCondpopulate with the STRTM2 values in the source data (M/F in this example for displayed data)
STRTM3Stratum 3textRaceRACECondpopulate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the second part of the second column concept in this example

STRVAL3

Stratum 3 Value

textTotalTOTAL;WhiteWHITECondpopulate with the STRTM3 values in the source data (Race in this example)
INPRMInput ParametertextBIRTH RATEReqpopulate 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 indentifying value
INPRMVALInput Parameter Valuefloat
Reqpopulate with the cell value from the referenced data that is being described by the STRMVALy values
INPRMUInput Parameter Unittext

RATIO / 10 PER 1000

Permpopulate with the unit describing the cell values if appropriate

...

REFSRCEReference Data Sourcetext


Permpopulate 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

STRVAL2STRTM3STRVAL3INPRMINPRMVALINPRMU
year
REFSRCE
YEAR2000
Sex
SEXF
Race
RACE
Total
TOTALBIRTH RATE

0.048156602

RATIO / 10 PER 1000

birthrate 2015.xslx

year
YEAR

2001

Sex
SEXF
Race
RACE
Total
TOTALBIRTH RATE0.050162384RATIO / 10 PER 1000
year
birthrate 2015.xslx
YEAR2002
Sex
SEXF
Race
RACE
Total
TOTALBIRTH RATE0.049912072RATIO / 10 PER 1000
year
birthrate 2015.xslx
YEAR2003
Sex
SEXF
Race
RACE
Total
TOTALBIRTH RATE0.049953214RATIO / 10 PER 1000birthrate 2015.xslx
year
YEAR2004
Sex
SEXF
Race
RACE
Total
TOTALBIRTH RATE0.050199534RATIO / 10 PER 1000birthrate 2015.xslx
year
YEAR
2000
2005
Sex

SEX

M

Race
RACE
Total
TOTALBIRTH RATE0.050497803RATIO / 10 PER 1000birthrate 2015.xslx
year
YEAR

2001

Sex
SEXM
Race
RACE
Total
TOTALBIRTH RATE0.052554053RATIO / 10 PER 1000
year
birthrate 2015.xslx
YEAR2002
Sex
SEXM
Race
RACE
Total
TOTALBIRTH RATE0.052289152RATIO / 10 PER 1000
year
birthrate 2015.xslx
YEAR2003
Sex
SEXM
Race
RACE
Total
TOTALBIRTH RATE0.052334712RATIO / 10 PER 1000
year
birthrate 2015.xslx
YEAR2004
Sex
SEXM
Race
RACE
Total
TOTALBIRTH RATE0.052594772RATIO / 10 PER 1000
year
birthrate 2015.xslx
YEAR2000
Sex
SEXF
Race
RACE
White
WHITEBIRTH RATE0.043829866RATIO / 10 PER 1000birthrate 2015.xslx
year
YEAR

2001

Sex
SEXF
Race
RACE
White
WHITEBIRTH RATE0.04509937RATIO / 10 PER 1000
year
birthrate 2015.xslx
YEAR2002
Sex
SEXF
Race
RACE
White
WHITEBIRTH RATE0.044711283RATIO / 10 PER 1000
year
birthrate 2015.xslx
YEAR2003
Sex
SEXF
Race
RACE
White
WHITEBIRTH RATE0.044899939RATIO / 10 PER 1000
year
birthrate 2015.xslx
YEAR2004
Sex
SEXF
Race
RACE
White
WHITEBIRTH RATE0.045284915RATIO / 10 PER 1000birthrate 2015.xslx