Project

General

Profile

Actions
Copy link

Data Services #1846

open

AVS SP modifications

Added by Venkata Suryateja Thripuraribhotla 29 days ago. Updated 29 days ago.

Status:
New
Priority:
High
Assignee:
Venkata Suryateja Thripuraribhotla
Start date:
12/03/2025
Due date:
% Done:

0%

Estimated time:
Deployed In:
Demo 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
Copy link
 #1

Updated by Venkata Suryateja Thripuraribhotla 29 days 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
Copy link
 #2

Updated by Venkata Suryateja Thripuraribhotla 29 days 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
Copy link

Also available in: Atom PDF