[cor_mpe_period_code]

Major periods roll up all of the periods to present a chronological list of periods. If periods overlap, the major periods shows the more serious period of the two. For example, if a respondent is given overlapping sentences parole and community detention, then parole would be shown in the major period.

Note: Events detail the specific interactions made with Corrections. These are presented in chronological order. For example, when the offender or offender identity track is remanded on initial charge, sentenced to prison, sentenced to community detention, released on parole, etc. Periods are the periods of time the offender or offender identity track spends in contact with Corrections. These periods of remand, prison, community detention, parole etc. Major periods roll up all of the periods to present a chronological list of periods. If periods overlap, the major periods shows the more serious period of the two. For example, if a respondent is given overlapping sentences parole and community detention, then parole would be shown in the major period. Major management periods roll up all of the major periods to show consistent periods. For example, if there are back-to-back periods of remand or community work, these are shown as a single major management period.

The individual tracks often have events that overlap or start on the same day. A single major track of periods (ov_rebuild_major_periods) is calculated using a ranking value in OV_PERIODS_DIM. This step involves slicing and then consolidating periods. The major track is then a contiguous timeline of non-sanctioned and sanctioned management periods from birth which best represents the offenders lifetime of episodes to date.

Multiple tracks of chronological periods with start/end events that relate to the individual track. Tracks are constructed independently. A track can be any of the following: • An offender identity keeping track of birth, deportation and death events. An offender can only have one identity track. • An aggregate sentence • A board order • A remand warrant

Periods from different tracks overlap in this fact table. This allows for analysis on concurrency of management directives, such as concurrent aggregate sentences. A single major chronological track of periods created by combining the individual tracks and using trumping rules to resolve concurrent periods into the period of highest management cost/risk.

This fact may contain repeated prison, community work or remand periods as the directive for those periods may change from one to the next. This fact allows for accurate point in time analysis of management activity and the reasons associated with it.