How to add data into or delete data from ‘Validation’ tables …

Background Knowledge:

Validation tables contain data that are used or passed during R-Supply transaction processes. These data are critical part of the process to ensure validity of transaction. Every R-Supply transaction is subjected to a series of validation before it is posted to R-Supply database tables. Any R-Supply transactions that do not pass during the validation process will be posted to one of the suspense table (depends what R-Supply function the transaction was processed from).

There are two types or categories of Validation tables. They are: Privilege and Non-privilege validation tables. Privilege Validation tables are tables that cannot be modified by the user. It contains data that are common to all Navy users (i.e. COG, UI, MCC, etc.). These validation tables can only be modified by SPAWAR personnel in which password is required to add or delete entries into/from the table. Password is unique and only works that particular day. If you know the password today, same password will not work the next day. Non-privilege validation tables are updated or maintained by the local user without any restrictions. Some of the data within these tables are unique to the local users (i.e. LMC, ARRC, IRC, etc.).

Procedures:

To add data into or delete data from the ‘Validation’ tables, follow the step-by-step procedure listed below:

Note: Display the icon descriptions for easy identification of the displayed icons. To display the description, point and right click on any of the displayed icon and select “Show Text”.

      A. To add data into the validation table, follow the steps listed below:

Step #1: LOGON to R-Supply and GoTo: Site>Validation Tables. The default 'Validation Table'

will be displayed.

Step #2: Click the dropdown menu to display the list of 'Validation Tables'. Scroll Up or Down to

locate the validation table to be updated.

Step #3: Select the “Validation” table you want updated.

Step #4: Click “Insert” icon on the icon toolbar. A blank data field will be displayed.

Step #5: Enter the required data on the blank data field.

Step #6: Click “Apply” icon to save the data.

Step #7: Verify data to ensure correctness of new added data into the validation table. To verify,

close the ‘Validation’ table screen then go back in and open the table you just updated.

      B. To delete data from the validation table, follow the steps listed below:

Step #1: LOGON to R-Supply and GoTo: Site>Validation Tables. The default 'Validation Table'

will be displayed.

Step #2: Click the dropdown menu to display the list of 'Validation Tables'. Scroll Up or Down to

locate the validation table to be updated.

 

Step #3: Select the “Validation” table you want updated.

Step #4: Select by highlighting the data to de deleted.

Step #5: Click “Delete” icon to delete the data.

Step #6: Click “Apply” icon to save the updated table.

Step #7: Verify data to ensure data was deleted from the validation table. To verify, close the

‘Validation’ table screen then go back in and open the table you just updated.

Any questions, feedback or comments, email Lonnie Auza.