Program scope

The scope of the M3_EXECUTE_GENERATE_STAGING_ENTITY program is as follows:

• Considers the BOI_NAME:
  • If the value of BOI_NAME is specified, the specified BOI is only considered.
  • If the value of BOI_NAME is not specified, all BOIs with the specified BOI_DIRECTION, and Active status are considered. In addition, if the value of MODE is not specified, sc_indicator = C is considered.
• Validates the BOIs in scope:
  • If valid_flag is N, or NULL, the program validates the BOI and sets the valid_flag accordingly.
  • If validation fails, an error message is logged, and the execution is stopped.
  • If validation passes or if valid_flag is Y, the program continues with BOI execution.
• Determines which BOI definition to be used:
  • If sc_indicator is set to S and user_boi_xml is not populated, the definition in column boi_xml is considered.
  • If sc_indicator is set to S and user_boi_xml is populated, the definition in column user_boi_xml is considered.
  • If sc_indicator is set to C, the definition in column user_boi_xml is considered.