Rate Availability Clean Up Ckit Testing Results

CHECK DATA AFTER FINISHING EOD

Business Rule

 Delete all records in table ptavail, profrc where todate is less than 1 month ago

 Protel date is 26/01/2012 after finishing EOD

 All records in table ptavail, profrc where todate is less than 26/12/2011 would be deleted

 

Input

 Query all records in ptavail table where todate is less than 26/12/2011

 

Query all records in ptavail table where todate is less than 25/12/2011

 

 

After running EOD, Protel date is 26/01/2011

 

Output

 All records in table ptavail where todate is less than 26/12/2011 are deleted

 

 

All records in table profrc where todate is less than 26/12/2011 are deleted

 

 

Backup table of ptavail

 

 

Backup table of profrc

 

Have more questions? Submit a request

Comments

Powered by Zendesk