Business Date Rule Inbound Interface

Owned by Dmitry Donosiyan (Unlicensed)
Nov 08, 2018
1 min read

BusinessDateRule is designed to load data to RULESDBO.DATERANGES table.

Stream Logic

Processing Sequence

Data is loaded via eagle_ml-2-0_default_in_xml_reference stream using xml-ref_daterule.xml rule.

BusinessDateRule resolution logic

Date Rule is resolved by its ID or Name. ID has a higher priority.

BUSINESS_CAL_FLAG calculation

BUSINESS_CAL_FLAG is a binary flag with decimal value in DB. It is calculated from businessStartDate/additionalCalendarFlag, businessStartDate/adjustmentCalendarFlag, businessStartDate/offsetCalendarFlag, businessEndDate/additionalCalendarFlag, businessEndDate/adjustmentCalendarFlag, businessEndDate/offsetCalendarFlag flags.

BusinessCalendar source resolution logic

Business Calendar source instance resolved based on PACE_MASTERDBO.INTERFACES and PACE_MASTERDBO.BUSINESS_CALENDAR tables. The relationship is:

SELECT INSTANCE FROM PACE_MASTERDBO.INTERFACES i
INNER JOIN PACE_MASTERDBO.BUSINESS_CALENDAR bc ON (i.INSTANCE = bc.SRC_INTFC_INST )
where i.SHORT_DESC = businessCalendarName

TimeZone ID resolution

TimeZone instance is resolved from PACE_MASTERDBO.TIME_ZONES table based on timeZoneCode data from incoming file that has “+/-hh:mm” format. In case many results are found, the first one is taken. Otherwise, the record with timeZoneName value (if it was set in incoming data file) in STANDART_NAME is taken.

businessStartDate/unadjustedDate and businessEndDate/unadjustedDate

If these fields are not empty then businessStartDate/dateTypeCode and businessEndDate/dateTypeCode are set to ‘FIXED’.