Providers stored in the database can be viewed and edited in the Stored Providers editing screen. To open the Providers editor, click Manual Entry and then Stored Providers:
Stored providers menu option
A new window containing all providers stored in the StoredSource table will be opened. To create the StoredSource table, Creating the Receiver, Source and Patient table
Stored Provider editing screen
Left section list do contains all the records based on the query execution mentioned withing query box.On screen load,query box do have 'select *' query which will fetch all records from database table.
Through screen user can perform below actions.
| 1. | Execute query: Screen do contains 'Execute Query' button which do execute query mentioned within query box. User can modify the query and can filter records by using this action. Left side table do display the filtered records if user do perform this action. |
| 2. | Clear: Screen do contains 'Clear' button which remove the modification made in query and changed it to 'Select *(all records)' query and do execute it and load all table records within left table section. |
| 3. | Add new record: Click on Add new Icon, clear the right section.  "Stored Providers Screen- Add new Section" Screen do contains few mandatory fields and detail of such fields require to save the record into database. Without those fields, application do provide below validation message on click of 'Update Record' button.  "Add new Provider - Validation Message" Screen do contains 2 segments for the detail. If user fill detail within the segment, then user also require to associate detail required for that segment. Application do provide validation message if associated segment details are missing.  " Add New Provider - Segment validation" After filling all required fields and click on 'Update Record' button insert the record into database and provide success notification.  "Add Provider - Success Message" After the addition,newly added record get added within left side table and got selected.Its detail been added into right side section for modification.  "Provider Screen- added record open in edit mode after add" |
| 4. | View/Update record: User can select any record from left table section. This record selection load right section with selected record details. User can review detail and can modify any detail in right section. After the modification, click on 'Update Record' button to store the modification into database table. Update operation do perform all validation as mentioned within Add operation. |
| 5. | Delete record: To delete an existing provider, select the provider in the Stored Sources table and click the Delete icon button.  "Provider Screen - Delete Icon' Application do provide confirmation message which do prevent record deletion if user clicked the icon accidentally.  "Provider Screen - Delete confirmation message" Click on yes, delete the record and do provide success notification.  "Provider Screen- Success delete message" |
| 6. |