Period Mapping

You can select the type of period mapping for the file, which determines how the data is interpreted and aligned by period. These options are available:

  • Year
  • Year and Period
  • Time Mark
  • PPPP?YYYY
  • YYYY?PPPP
  • Date Time

This table shows a quick reference to help you select the appropriate option:

Period Mapping When to use Required columns
Year File has only a Period column Period
Year and Period File has separate year and period columns Year, Period, or custom names
Time Mark File has no date columns; uses a pre-defined time range None
PPPP?YYYY File has a combined period-year column Custom column
YYYY?PPPP File has a combined year-period column Custom column
Date Time File has actual calendar dates Custom column