Rule sets can be used to generate warnings if a content planning is in violation with one of the active rules. The same rules can also be used in the automatic planning (see Automatic planning). The available rules are (see rule set definitions for more details):
- Element must be greater than 0
- No remaining time in the hour
- Campaign is already planned in the hour
- Element is already scheduled in the hour
- Violation of youth protection
- Type is already scheduled in the hour
- Violation of period of use
- Violation of environmental regulations
- Violation of scheduling between 2 commercial blocks
- Violation of scheduling between 2 programs
- Violation of Just a trailer before advertising
- No scheduling between 1 and 9
In order to verify if a specific rule is broken, the user has to activate a rule set with the desired rule. Either use a rule set which includes the desired rule add the rule to an existing rule set or create an entirely new rule set. After setting a rule set to default, the user needs to activate the default rule set in the header above the plan. After enabling a rule set, rule breaks of newly planned elements issue a Broken rule warning.
Rule set management
Click the button to open the Rule set management dialog. Define a rule set as default by clicking the default checkbox in the rule set management dialog.
Click the button to create a new rule set. To modify an existing rule set click the
Update button or
Copy button to create a new rule set based on an existing one. Individual rule sets can be deleted by clicking the
Delete button. All rules sets can be deleted by clicking the
button.
Edit rule set
Click the add button to add a rule to the rule set.
Click the remove button to remove a rule from the rule set.
Click the save button to save the changes.
Rule set definitions
- Duration greater then 0
This rule will check if a duration of planned element is null or 0. In that case rule will be broken.
Element needs to have valid duration not to break this rule. - Remaining time in the hour
Check what is the remaining time in one hour. If planned element will make time smaller then 0, then
the rule is broken. Bumper from Channel should be already calculated in remaining time. If not, then
consider also Bumper time from channel. Check Attribute “Bumper_KPM” on Channel.
“(select * from par_kanal k, mrg_parameter_atribut a, mrg_parameter_atributtyp t
where k.kanal_id = a.merge_id and a.parameter_atributtyp_id = t.parameter_atributtyp_id
and t.key = 'BUMPER_KMP')”. Bumper time is time defined within Channel attribute, and it is in
seconds. It will allow us to plan as rest time – bumpertime. - Campaign already scheduled
Check if in current hour, there is already element from same campaign planned.
If Campaign has 5 elements. We plan first element in between 09:00-10:00. We take then second
element, and we plan also in between 09:00-10:00. Rule is broken. So, in one hour no two elements
from same campaign should be planned. - Campaign is Double
Check if same element from one campaign is planned in current hour. So, if it is duplicated within
hour. Rule is broken then. - Type is double
Campaign has several DSG and TRFSG elements. Every element has defined Trailer Version Type /
Design Type. If we plan element with same type in one hour, rule is broken. - Protection of Minors
Check if parental rating of planned element can be planned in defined time. So every element in campaign have
parental rating value. When we make planning, we chose on which channel we plan. Channel has a table
REF_FSK_KANAL. In this table there are properties: FreiVon, FreiBis, SperreVon, SperreBis. We first
check if planned datum in between SperreVon-SperreBis. If yes, then rule is not broken. If these fields
are null or empty, then we check fields FreiVon-FreiBis. If all these 4 fields are empty, or if FSK is not
contained in REF_FSK_KANAL, then we take same fields and same check but from PAR_FSK table, for
FSK value. If also these fields are null or empty, then rule is not Broken. Rule is broken if planned time
is outside of these ranges. In Case that SperreVon is 00:00 and SperreBis is 00:00 that means that rule
is automatically broken, because it is locked for 24 hours for planning. Same goes with FreiVon and
FreiBis - Period of Usage
Planned element have Period of Usage already defined. If planned time does not fit in any period of
usage time, rule Is broken. - Environment
When we are creating campaign, we can set Content and Genre to Campaign. Later when we do
planning, we need to check if planned element is in right environment. So let say we have one
Campaign with One Episode of Game of Thrones Serie and one episode of Gold Digger series. If we
plan now this element in within hour and there is Serie Game of Thrones planned, planning will be
valid, because campaign contains Game of thrones Episode and it is valid environment “Game of
Thrones” environment. If we plan then on some other time slot where within hour there is no gold
digger or game of thrones planned, rule is broken, because environment is not valid. Same goes with
Genre. If we have Action Genre with Campaigns and we plan in between one hour slot, and there are
only Comedies planned there, rule is broken, since it is not a good environment. - Not between 2 commercial breaks
Rule is broken if element is planned between 2 commercial breaks. - Not between 2 Programs
Rule is broken if we plan element in between 2 Content elements (Program, serie, sequence). - Only one Trailer before Commercials
So only one trailer is allowed to be planned before Commercial, If we have 2 element planned, rule is
broken. - No Scheduling between 1am and 9am
If an element is planned between 01:00 in night and 09:00 in morning, rule is broken