This is an example of an ADaM dataset designed to capture the reference data describing the initial population.
Dataset wrap |
---|
Dataset2 |
---|
| | STRVAL1 | | STRVAL2 | STRTM3 | STRVAL3 | 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 | PREVALENCE | 70 | PERCENT | initial population 2017.xlsx | 8 | AGE | 10 | SEX | M | RACE | WHITE | PREVALENCE | 68 | PERCENT | initial population 2017.xlsx | 9 | AGE | 20 | SEX | M | RACE | WHITE | PREVALENCE | 69 | PERCENT | initial population 2017.xlsx | 10 | AGE | 30 | SEX | M | RACE | WHITE | PREVALENCE | 70 | PERCENT | initial population 2017.xlsx | 11 | AGE | 40 | SEX | M | RACE | WHITE | PREVALENCE | 72 | PERCENT | initial population 2017.xlsx | 12 | AGE | 50 | SEX | M | RACE | WHITE | PREVALENCE | 71 | PERCENT | initial population 2017.xlsx |
|
Definexmltable |
---|
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 |
---|
| | 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 |
---|
| | 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 |
---|
| | text | White | Cond | populate with the STRTM3 values in the source data (Race in this example) |
---|
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 | | 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) |
---|
|
|
...
...
...