Stored Procedure List

After installation the following stored procedures will be installed on the databases

Image database

Stored Proc Name

URAAdmin

URAOperator

URAGuest

DeleteDiskRefImages

x

 

 

DeleteImage

x

 

 

GetAllmageDetailsForDiskRef

x

x

x

GetAlImageDetailsForVolunteer

x

x

x

GetImage

x

x

x

GetImageDetails

x

x

x

GetImageIDFromDICOMRef

x

x

x

InsertImage

x

x

 

UpdateImage

x

x

 

x = executed permissions granted

Patient (ukctocs) database

Stored Proc Name

URAAdmin

URAOperator

URAGuest

GetNameFromVolunteerRef

x

x

 

ListNameForVolunteerRef

x

x

 

ListScanDatesForVolunteerRef

x

x

 

ListVolunteerRefForNames

x

x

 

MatchScanDateForVolunteerRef

x

x

 

x = executed permissions granted