Project

General

Profile

Actions

Data Services #1846

closed

AVS SP modifications

Added by Venkata Suryateja Thripuraribhotla 3 months ago. Updated about 1 month ago.

Status:
Closed
Priority:
High
Start date:
12/03/2025
Due date:
% Done:

0%

Estimated time:
Deployed In:
Production Environment
Category:
Database

Description

As per the updated modifications in AVS base input table structures (like Road Inventory, Culverts, Furniture data ) we need to modify the SP's for AVS processing in the application.

Actions #1

Updated by Venkata Suryateja Thripuraribhotla 3 months ago

Initial modifications done to the SP's and testing has been done for East province data. All the attributes are successful with valuation but Road furniture data sp is having error in valuation because of changes in Lookup codes for furniture items shared by RDA during recent modifications done in September 2024.

Actions #2

Updated by Venkata Suryateja Thripuraribhotla 3 months ago

Furniture data SP has also been modified but there is still error in code conversion to int data type of the condition column in furniture data items. Not sure from which furniture item the error is generated. Need to verify all the furniture attributes.

Actions #3

Updated by Venkata Suryateja Thripuraribhotla about 1 month ago

  • Status changed from New to Closed
  • Deployed In changed from Demo Environment to Production Environment

As the proposed modifications are done, ticket is closed.

Actions

Also available in: Atom PDF