Versions Compared

Key

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

This is an example of an ADaM dataset designed to capture the reference data describing historical migration rates.

Dataset wrap
Namerfmigrat
Dataset2
tableidRFMIGRAT

Row

STRTM1

STRVAL1

STRTM2

STRVAL2

STRTM3

STRVAL3INPRMINPRMVALINPRMU
1
year
YEAR2001
Sex
SEXF
Race
RACE
Total
TOTAL

NET MIGRATION RATE

100

COUNT
2
year
YEAR

2002

Sex
SEXF
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
3
year
YEAR2003
Sex
SEXF
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
4
year
YEAR2004
Sex
SEXF
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
5
year
YEAR2005
Sex
SEXF
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
6
year
YEAR2001
Sex
SEX

M

Race
RACE
Total
TOTALNET MIGRATION RATE100

COUNT

7
year
YEAR

2002

Sex
SEXM
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
8
year
YEAR2003
Sex
SEXM
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
9
year
YEAR2004
Sex
SEXM
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
10
year
YEAR2005
Sex
SEXM
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
11
year
YEAR2001
Sex
SEX
Total
TOTAL
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
12
year
YEAR

2002

Sex
SEX
Total
TOTAL
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
13
year
YEAR2003
Sex
SEX
Total
TOTAL
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
14
year
YEAR2004
Sex
SEX
Total
TOTAL
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
15
year
YEAR2005
Sex
SEX
Total
TOTAL
Race
RACE
Total
TOTALNET MIGRATION RATE100COUNT
Definexmltable
DatasetRFMIGRAT
LevelDataset
PurposeAnalysis
NameRFMIGRAT
DatasetDescriptionClassStructurePurposeKeysLocationDocumentation
RFMIGRATReference Data for Migration RatesREFERENCE DATA STRUCTUREone record per input valuereferenceSTRTM1, STRM2, STRTM3rfmigrat.xptNA
PurposeAnalysis
Definexmltable
DatasetRFMIGRAT
LevelVariable
Name
RFMIGRAT
Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes
STRTM1Stratum 1text
Age
YEARReqpopulate 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

??

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-133


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

text

Sex
SEXCondpopulate 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;F;
Total
TOTALCondpopulate with the STRTM2 values in the source data (F/M/Total in this example for displayed data)
STRTM3Stratum 3text
Race
RACECondpopulate 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

text
Total
TOTALCondpopulate with the STRTM3 values in the source data (Race in this example)
INPRMInput ParametertextNET MIGRATION 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 Valueinteger
Reqpopulate with the cell value from the referenced data that is being described by the STRMVALy values
INPRMUInput Parameter UnittextCOUNTPermpopulate with the unit describing the cell values if appropriate