Calculating new routings

Each comparison criterion creates an individual tag even if there is only one version. The processing logic for calculating new routings is as follows:
  • Routing header: Creates a new record in SC_ROUTING for each routing_id calculated in step 1 of the Transform topic. These values are used for the generated routing record:
    • routing_id = <routing id>
    • version = <effective_from_date> + <new version value>
    • transformation_id = <current transformation ID>
    • created_by = TFORM_MAP_ROUTING_VERSION;
    • creation_time = <current timestamp in UTC>
    • modified_by = TFORM_MAP_ROUTING_VERSION;
    • modification_time = <current timestamp in UTC>
    • <remaining columns> = <corresponding columns from original routings>
  • Routing input item: Creates a new record in SC_ROUTING_INPUT_ITEM for each input item corresponding to the routing_id calculated in step 1 of the Transform topic. These values are used for the generated routing input item record:
    • routing_id = <routing id>
    • transformation_id = <current transformation ID>
    • operation_id = "0010"
    • created_by = TFORM_MAP_ROUTING_VERSION;
    • creation_time = <current timestamp in UTC>
    • modified_by = TFORM_MAP_ROUTING_VERSION;
    • modification_time = <current timestamp in UTC>
    • <remaining columns> = <corresponding columns from original routings>
  • Routing output item: Creates a new record in SC_ROUTING_OUTPUT_ITEM for each output item corresponding to the routing_id calculated in step 1 of the Transform topic. These values are used for the generated routing output item record:
    • routing_id = <routing id>
    • transformation_id = <current transformation ID>
    • operation_id = "0010"
    • created_by = TFORM_MAP_ROUTING_VERSION;
    • creation_time = <current timestamp in UTC>
    • modified_by = TFORM_MAP_ROUTING_VERSION;
    • modification_time = <current timestamp in UTC>
    • <remaining columns> = <corresponding columns from original routings>
  • Routing operation: Creates a new record in SC_ROUTING_OP for each routing_id calculated in step 1 of the Transform topic. This represents a dummy operation. These values are used for the generated routing operation record:
    • routing_id = <routing id>
    • transformation_id = <current transformation ID>
    • operation_id = "0010"
    • next_operation_id = Null
    • created_by = TFORM_MAP_ROUTING_VERSION;
    • creation_time = <current timestamp in UTC>
    • modified_by = TFORM_MAP_ROUTING_VERSION;
    • modification_time = <current timestamp in UTC>
  • Routing operation alternative: Creates a new record in SC_ROUTING_OP_ALT for each routing_id calculated in step 1 of the Transform topic. This represents a dummy operation. These values are used for the generated routing operation alternative record:
    • routing_id = <routing id>
    • transformation_id = <current transformation ID>
    • operation_id = "0010"
    • sequence_number = "0"
    • created_by = TFORM_MAP_ROUTING_VERSION;
    • creation_time = <current timestamp in UTC>
    • modified_by = TFORM_MAP_ROUTING_VERSION;
    • modification_time = <current timestamp in UTC>
    • <remaining columns> = Copy values from the last operation of the first routing calculated in step 1 of the Transform topic.
  • Routing resource alternative: Identifies the original routings for each routing_id calculated in step 1 of the Transform topic. Also, identifies the last operation in each original routing, and the resource alternatives linked to the last operation of the original routings. This process creates a new record in SC_ROUTING_RESOURCE_ALT for each alternative resource that is identified. Each record represents a dummy resource alternative. These values are used for the generated routing resource alternative record:
    • routing_id = <routing id>
    • transformation_id = <current transformation ID>
    • operation_id = "0010"
    • sequence_number = "0"
    • resource_id = <found resource id>
    • created_by = TFORM_MAP_ROUTING_VERSION;
    • creation_time = <current timestamp in UTC>
    • modified_by = TFORM_MAP_ROUTING_VERSION;
    • modification_time = <current timestamp in UTC>
    • <remaining columns> = Copy values from the identified alternative resource linked to the last operations of the original routings