Skip to main content

sp_populate_irfo_psv_auth_expired

sp_populate_irfo_psv_auth_expired​

Parameters:​

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

Record Selection Criteria for Deletion:​

  • Entity: irfo_psv_auth
  • Expiry Filter: Selects records where the expiry_date of the PSV authorization is older than the current date minus the retention period parameter.

Summary:​

  • This procedure identifies expired IRFO PSV authorizations, selecting those whose expiry date is older than the current date minus the retention period.