getDatabaseRecordTable

Description

Extract all Form Record Tables for a Database in "long" format

Usage

getDatabaseRecordTable(database.id = NA, as.single.table = FALSE)

Arguments

ArgumentDescription
database.idthe numeric id of the database
as.single.tablespecify whether to merge all Form Record Tables into a single table

Details

  • Columns for all Form Dimensions, including:

  • Sub-Form Name, Sub-Form Id, Sub-Form Record Id and Sub-Form Period (where applicable)

  • Reference Field Dimensions (where applicable)

  • Rows for every measured value, with the measure field name under "Measure" and the measured value under "Value"

Value

By default, returns a list of all Form Record Tables. If as.single.table is set to TRUE , all Form Record Tables will be concatenated into a single table, with missing values given as <NA> .