This is an example of an ADaM dataset designed to capture the reference data describing historical migration rates.
| Dataset wrap |
|---|
|
| Dataset2 |
|---|
| | | STRVAL1 | | STRVAL2 | | STRVAL3 | INPRM | INPRMVAL | INPRMU |
|---|
| 1 | YEAR | 2001 | SEX | F | RACE | TOTAL | | | COUNT | | 2 | YEAR | 2002 | SEX | F | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 3 | YEAR | 2003 | SEX | F | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 4 | YEAR | 2004 | SEX | F | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 5 | YEAR | 2005 | SEX | F | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 6 | YEAR | 2001 | SEX | M | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 7 | YEAR | 2002 | SEX | M | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 8 | YEAR | 2003 | SEX | M | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 9 | YEAR | 2004 | SEX | M | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 10 | YEAR | 2005 | SEX | M | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 11 | YEAR | 2001 | SEX | TOTAL | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 12 | YEAR | 2002 | SEX | TOTAL | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 13 | YEAR | 2003 | SEX | TOTAL | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 14 | YEAR | 2004 | SEX | TOTAL | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT | | 15 | YEAR | 2005 | SEX | TOTAL | RACE | TOTAL | NET MIGRATION RATE | 100 | COUNT |
|
|
| Definexmltable |
|---|
| Dataset | RFMIGRAT |
|---|
| Level | Dataset |
|---|
| Purpose | Analysis |
|---|
| Name | RFMIGRAT |
|---|
|
| Dataset | Description | Class | Structure | Purpose | Keys | Location | Documentation |
|---|
| RFMIGRAT | Reference Data for Migration Rates | REFERENCE DATA STRUCTURE | one record per input value | reference | STRTM1, STRM2, STRTM3 | rfmigrat.xpt | NA |
|
| Definexmltable |
|---|
| Dataset | RFMIGRAT |
|---|
| Level | Variable |
|---|
| Name | RFMIGRAT |
|---|
|
| Variable Name | Variable Label | Type | Codelist/Controlled Terms | Core | Notes |
|---|
| STRTM1 | Stratum 1 | text | YEAR | 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 | | | integer | Jira |
|---|
| showSummary | false |
|---|
| server | Issue Tracker (JIRA) |
|---|
| serverId | 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 |
|---|
| key | TOBA-133 |
|---|
|
|
| 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 first part of the second column concept in this example | | | text | M;F;TOTAL | Cond | populate with the STRTM2 values in the source data (F/M/Total in this example for displayed data) | | 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 second part of the second column concept in this example | | | text | TOTAL | Cond | populate with the STRTM3 values in the source data (Race in this example) | | INPRM | Input Parameter | text | NET MIGRATION RATE | 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 indentifying value | | INPRMVAL | Input Parameter Value | integer |
| Req | populate with the cell value from the referenced data that is being described by the STRMVALy values | | INPRMU | Input Parameter Unit | text | COUNT | Perm | populate with the unit describing the cell values if appropriate |
|
Source file: Example 4 - MigrationRate.xls (Working Files - Product Impact on Population Health)
...
...
...
...
...
2002
...
M
...
2
...
2002
...
2002
...