Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themeEclipse
title2. If no ACTIVE version, set the PENDING version to ACTIVE
update award set award_sequence_status='ACTIVE' where award_sequence_status='PENDING' and award_id='111111';


Fix Page Not Loading on Obligation Dates

Request: The award page gets stuck while loading, and attempting to move to another page results in a "The page has not finished loading" pop-up.

Example Ticket: INC0747018

Code Block
languagesql
themeEclipse
title1. Default the value of the Obligation Expiration Date to whatever the project end date is
-- Only run this on awards that don't have Time & Money already entered! If the award has dates and dollars, the problem is something else (and running this will overwrite the existing date data)
update award_amount_info set obligation_expiration_date=final_expiration_date where award_number='102734-00001';

Maintenance Tables

...

Add New State to State Table

...