Case 1
The leading period is the first period of the year and the first period in the data load file. Three periods are loaded. In this case, the first period is kept unchanged, while subsequent periodic data is obtained by subtracting the previous periods' periodic values from the current period YTD.
In this example, January is the first period of the year and the input file contains three periods consisting of January, February and March data. The row labeled YTD represents the data from the input file. The row labeled Periodic (P) represents the data as it will be loaded into the ICRepPer_Base table if the schedule line is a Mem_type = PR or PE (not BA, BL, or BE). Periodic (B) represents the data as it will be loaded into the table if the schedule line has a Mem_type = BA, BL, or BE.
| January | February | March | |
|---|---|---|---|
| YTD Data Loader | 10 | 21 | 33 |
| Periodic (P) | 10 | 11 | 12 |
| Periodic (B) | 10 | 21 | 33 |
Periodic calculation for a profit and loss line type (PR or PE):
- January=10
- February=21-10=11
- March=33-11-10=12
Balance sheet data is loaded directly as stated in the data loader line.
The Data Loader behaves the same way if the data is loaded in separate files for each period versus all periods in the same file.