Skip to main content

sp_populate_new_var_appl_bus_reg_expired

sp_populate_new_var_appl_bus_reg_expired​

Parameters:​

  • p_user_id INT: User ID of the person executing the procedure.

Record Selection Criteria for Deletion:​

  • Entity: bus_reg (bus registration)
  • Status Filter: Selects records where the bus registration status is 'breg_s_expired'
  • Expiry Date Filter: Filters registrations based on the end_date being earlier than the current date minus the retention period defined in the data retention rules.

Summary:​

  • This procedure identifies bus registrations that have expired and whose end date is older than the defined retention period.