Program scope

The EXECUTE_VALIDATION program determines the scope as follows:

• If the TABLE_NAME parameter is specified, the program applies the following logic in order:
  • If the target table is inbox and the INCLUDE_USER_DATA parameter is set to N, the program:
    • Gets the current entity name (<current entity>).
    • Sets <current table name> to the inbox data table: SI_<current entity>.
    • Runs all inbox table validation rules where the target table is inbox (SI_<current entity>).
  • If the target table is inbox and the INCLUDE_USER_DATA parameter is set to Y, or if the target table is user data table, the program:
    • Gets the current entity name (<current entity>).
    • Sets <current table name> to the user data table: SM_<current entity>.
    • Runs all user data table validation rules where the target table is user data: SM_<current entity>.
    • Sets <current table name> to the inbox data table: SI_<current entity>.
    • Runs all inbox table validation rules where the target table is inbox (SI_<current entity>).
    • Considers only valid records from the user data table when applying the USERDATA rule.
• If the TABLE_GROUP_NAME parameter is specified, the program validates planning data in all tables included in the specified table group.
• If the TABLE_GROUP_NAME or TABLE_NAME parameter is not specified, the program validates the planning data in all Inbox tables in the SZ_REG_TABLE registry.