Loading Multiple As-of-Date Data in a Single File

Stage Management Ledger tables support loading data for multiple As-of-Dates within a single data file. This applies to all six Stage Management Ledger tables and covers scenarios such as:

• Loading a revised snapshot for one or more past months together with the current month’s load
• Loading Manual Entry adjustments for past months
• Loading a full revised Forecast for all remaining months of the financial year
• Loading a full revised Budget for all months of the financial year

The behavior depends on whether the Incremental toggle switch is enabled on the file’s Data File Specification (see Creating a Data File Specification):

• Complete (non-incremental) load: If a new file uses the same file name as a prior load, the new As-of-Date data it contains replaces the existing data for that file name, per As-of-Date. No additional validation is performed.
• Incremental load: The loader checks incoming records against existing data for the same file name. New combinations are appended; matching combinations are overridden.

To load data that is logically a duplicate of already-loaded data for the same As-of-Date — for example, a separate Manual Entries adjustment file — use a distinct file name and a unique DATA_SOURCE_CODE value, since Management Ledger record uniqueness is evaluated across AS_OF_DATE, CONSOLIDATION_CODE, ISO_CURRENCY_CD, all seeded and placeholder KPDs, and DATA_SOURCE_CODE.

Note:

Example: On loading Actual data for Apr’26, a user also includes corrected Feb’26 and Mar’26 snapshots in the same file. If the file name matches the prior load and the load is non-incremental, the Feb’26 and Mar’26 data already in the table is replaced by the new snapshot for those months, while Apr’26 is loaded as new data. No change is made to any other month.