WIXLIB

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00to display the Query Checklist and begin a new Ad Hoc Query2.3.2. Select the Open icon(Fig. 2.7).2.3.3. Select the Table(s) to be included in the query. Multiple tables must be linked by theircommon data elements. Once the table(s) have been selected the Tables Stop Signwill change to Goto allow the user to continue.(Fig. 2.7)2.3.4. Select the desired database table(s) from the list of Available Items (Fig. 2.8) and movethem to the Selected Items. When completed select OK. Remember, multiple tablesmust be linked by common elements within the tables.(Fig. 2.8)2-4

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.002.3.5. Select Columns from the Query Checklist to select the data elements from within theselected tables.2.3.6. Database Columns are displayed (Fig. 2.9).(Fig. 2.9)2.3.7. Select the desired database columns from the Available Items list and move them to theSelected Items (Fig. 2.9).2.3.8. Items appearing in the Selected Items will appear on the query results in the order theyare displayed in the Selected Items box. To arrange items in the Selected Items box,select the item(s) and use the Move Item Up or Move Item Down buttons to arrange thedata elements in the order they should appear in the results.2.3.9. Both the Tables and Columns buttons on the Query Checklist should now be Go(Fig. 2.10).2.3.10. Now the Criteria, Calculations, Sort and Group options may be used to refine or limitthe query results (Fig. 2.10).2-5

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 2.10)2.3.11. Criteria allows the user to enter arguments that the query results must match in order tobe displayed in the query results (Fig. 2.11).(Fig. 2.11)2.3.12. On the Query Criteria screen (Fig. 2.11), select data elements from the Possible CriteriaItems. These are the data elements that the criteria will be applied to in order todetermine the query results.2.3.13. Select the Operator from the Operator list (Fig. 2.11). The Operator defines the criteria(ex. Equal To; Like; Greater Than; Equal To but Less Than etc ).2.3.14. Enter the Condition (Fig. 2.11). The condition defines the Operator.2.3.15. Once the Criteria Items, Operator and Conditions have been set, check Make Argumentand select Accept. The query is now ready to run (Fig. 2.12).2-6

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 2.12)2.3.16. Calculations, Sort options and Group options can also be set to further define, or displaythe query results in the desired manner (Fig. 2.12).2.3.17. Select Run Query to process the query. If an Argument was used in the Criteria, theEnter Arguments Values box will be displayed to allow the user to enter or change theArgument Values (Fig. 2.13).(Fig. 2.13)2.3.18. When Run is selected the Query Impact screen is displayed to show the user the impactof the query results and allows the user to select the Output, Suppress Repeated Rows,insert User Defined Headers, and Apply Screen Formatting for the query output (Fig.2.14).2.3.18.1. Query Results (Fig. 2.14):2.3.18.1.1. Num Rows tells the user how many rows of data the query produced.2.3.18.1.2. HSP Pages tells the user how many printed pages (standard 8.5x11) the queryproduced.2.3.18.1.3. Screen Pages tells the user how many computer screen pages the queryproduced.2-7

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 2.14)2.3.19. Select OK on the Query Impact screen (Fig. 2.14) to display the results (Fig. 2.15)(Fig. 2.15)2-8

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.002.3.20. From the Run/Execute Query screen (Fig. 2.15) the user can perform various functionswith the query results such as Analyze, Print, Preview, Close, navigate the results withthe Page Down, Page Up and Seek options, Save Data, Apply and Change Formatoptions, create Data Graphs, Compare data and Expand the data. Help is also availableon the Run/Execute Query screen.2.3.21. Ad Hoc Query Review. In the example above, we have created a simple query todisplay all stock items with an Allowance Type Code (ATC) of 8. In (Fig. 2.8) weselected the stock item (stock item) table. In (Fig. 2.9) we selected stock item.niin(stock item NIIN) and stock item.allowance type code (stock item allowance type code)database columns. In (Fig. 2.11) we defined the criteria to be “if thestock item.allowance type code” (Possible Query Item) is “( ) equal to” (Operator), 8(Condition or Argument), then display the query results and show all stock items NIINswith an ATC of 8. In (Fig. 2.13), the Enter Arguments Value, we can change theCondition as desired (ex. replace the 8 with a 4 and all stock items with an ATC of 4 willbe displayed). Ad Hoc Queries can range from very simple queries (like the one above)to extremely complex depending on the user’s skill and knowledge of the databaseschema. Most data required in day-to-day operations can be produced using the reportsalready contained in RSupply (ex. the same query results in this example can also beproduced using the JSL322 Master Stock Status and Locator (MSSL) Listing in theLogistics subsystem). Ad Hoc Queries are most often used to extract data for additionalreporting requirements or by fleet support personnel or TYCOM personnel to analyzedatabase problems. The RSupply Help Files contains a Data Element Dictionary to helpdecode the database table and columns naming conventions (ex “stock item.niin” stockitem NIIN).2.3.22. Queries can be saved and used over and over. To save a query, use the Save icon(Fig. 2.7) to name and save the query.2.3.23. Many Ad Hoc Queries have been developed and are available for download on theDownloads page of the Afloat Systems website at http://rsupply.salts.navy.mil.2.4. File Transfer. The File Transfer option (Fig. 2.16) allows you to transfer information to(upload) and from (download) the server.(Fig. 2.16)2.4.1. On the Batch File Transfer screen (Fig. 2.17), select Transfer To Server to copyinformation from an external media source (data tape, diskette, hard drive or CD ROM)2-9

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00to the server. Select Receive From Server to transfer information from the RSupplyserver to an external media source.(Fig. 2.17)2.4.2. Transfer To Server: When Transfer to Server is selected, the Transfer to Serveroptions are enabled. The Transfer to Server options include:2.4.2.1. Append to Existing File checkbox allows the user upload a file and merge it into anexisting file already resident on the server.2.4.2.2. Process allows the user to select the process the file to be uploaded will affect (Fig.2.18). Select the Process from the dropdown menu box that the file is associatedwith.(Fig. 2.18)2.4.2.3. File Name allows the user to enter the exact name of the file to be uploaded. Use theBrowse button(Process must be selected to enable the Browse button) tolocate the file to be uploaded.2.4.2.4. Enter the transfer file name and input drive path, or use the Browse Button to locatethe file on your system.2.4.2.5. This file must be an appropriate input file in the proper format for the processchosen. The file name must be entered exactly as it is written. The system is case2-10

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00sensitive. Using the Browse button is the best method to ensure the file is processedcorrectly.2.4.2.6. Select Apply to transfer (upload) the file to the server.2.4.2.7. Once the file has been uploaded, it must be processed. Processing files transferred tothe server is covered under the specific process the file is associated with (ex.Incoming Status for Supply is covered under Status Processing in Chapter 4 of thisguide).2.4.3. Receive From Server: When Receive From Server is selected (Fig. 2.19) the ReceiveFrom Server options are enabled. The Receive From Server options include:2.4.3.1. Report or File. Selecting the wrong option will cause the transfer to error out. If thefile to be received from the server is in the Reports Queue (Fig. 2.20) in RSupplyselect Report. If the file is in the Output Files select File.2.4.3.2. Batch Job Number. Input the Batch Job Number of the Report or File to betransferred.2.4.3.3. Select Transfer to Hard Drive or Transfer to Floppy Drive. If Transfer to HardDrive is selected, input the destination or path in the Drive data field ( \data\xfer\ isthe default directory). If Transfer to Floppy Drive is selected, the default drive willbe A:\.(Fig. 2.19)2-11

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 2.20)2.4.3.4. Select Apply to transfer the file.2.4.3.5. File transfer message complete message appears (Fig. 2.21). Select OK.(Fig. 2.21)2.5. Batch Review. The Batch Review option (Fig. 2.22) allows the user to review/delete contentsof batch files on the RSupply server.(Fig. 2.22)2.5.1. Select one of the available options (Fig. 2.23) to view the desired Batch Jobs. InputFiles will display all Batch Jobs that have been uploaded to the server from the FileTransfer option. Output Files will display those Batch Jobs that RSupply has staged inthe output queue. These are typically files that must be transmitted off site (ex.Financials, outgoing requisitions, outgoing status etc ). Reports are Batch Jobsgenerated by RSupply process that generates a report (ex. Requisitions Listing, InventoryListing, Requirements Review etc )(Fig. 2.23)2-12

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.002.5.2. Once the desired option has been selected, the Select Server File screen or queue (Fig.2.24) will be displayed.(Fig. 2.24)2.5.3. Select Server File window displays all Batch Jobs in the Batch Job queue. User’s accesslevel will determine which Batch Jobs the user has access to view.2.5.4. Select the Refresh buttonto refresh the server listing if needed.2.5.5. Clicking on the column headings, Name, Modified, Size or Owner will arrange the list inascending order. Clicking the heading again will arrange the list in descending order.2.5.6. Select on the Batch Job to gain access.2.5.7. Select OK.2-13

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00Chapter 3Help Files of Relational Supply Unit Level3Relational Supply Help Files3-13.1User’s Guide3-23.2Using the User’s Guide3-23.3Windows Help3-53.4Field Help3-63.5Books3-73.6Technical Support3-123.7Release Notes3-143.8About RSupply3-153.9Show Text3-163-i

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00Chapter 3Relational Supply Help Files3. Relational Supply Help Files. RSupply provides a variety of Help options within the application toassist users (Fig. 3.1). A User’s Guide, which covers all the functionality of RSupply. WindowHelp, which describes the purpose of each screen, its components, and the tasks that can beperformed from the window. Field Help, which provides help for each data field on a specificRSupply screen. Books (Fig. 3.2) provides documentation on Application Terms and othertechnical data for the RSupply application. Technical Support provides information and points ofcontact for all technical support issues. Release Notes provides documentation on the installedRSupply release. About RSupply (Fig. 3.3) provides the installed version (release) number. Each ofthese Help options will be discussed in detail in this chapter.(Fig. 3.1)(Fig. 3.2)3-1

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 3.3)3.1. Users Guide. The Users Guide can be accessed by selecting the User’s Guide iconorselecting User’s Guide from the drop down Help menu (Fig. 3.1). The User’s Guide describeshow to use the application and the purpose of each function. To access the User’s Guide:3.1.1. From any RSupply Window select the Users Guide icon.3.1.2. From any RSupply Window select Help from the drop down menus.3.2. Using the RSupply User’s Guide. The Users Guide (Fig. 3.4) is divided into three tabs.(Fig. 3.4)3-2

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.003.2.1. Contents. Contents (Fig. 3.4) lists help topics by group. With Contents selected, selecton the help topic you desire and select Display.3.2.2. Index. Index (Fig. 3.5) lists help topics in alphabetical order. Select the index entryfrom the alphabetic list and then select Display (or double-click the index entry) or typethe first few letters of the word or topic you are looking for and all index entries thatmatch will be displayed.(Fig. 3.5)3.2.3. Find. The Find tab (Fig. 3.6) allows the user to search for key words and then provideshelp topics related to the key word matches. Type the word or words you are searchingfor in block 1. A list of matching the user’s input is displayed in block 2. Select amatching word or words to narrow your search to related help topics. Select the helptopic entry that best matches what you are looking for from block 3 and Select Display(or double-click on the help topic entry you wish to view).3-3

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 3.6)3.2.3.1. Find Options. The Find Options (Fig. 3.7) allows the user to further refine theirsearch criteria.(Fig. 3.7)3-4

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.003.3. Window Help. Window Help (Fig. 3.8) describes the purpose of each window, its components,and the tasks that can be performed from the window. From the RSupply window you requirehelp on:3.3.1. Select Help from the drop down menus.3.3.2. Select Window Help.(Fig. 3.8)3.3.3. Help topics for that window are displayed (Fig. 3.9).(Fig. 3.9)3-5

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.003.3.4. Help icons in the top section of each Windows Help screen (Fig. 3.10) may provideaddition information for:3.3.4.1. Overview3.3.4.2. Table Information3.3.4.3. Business Rules3.3.4.4. Computations3.3.4.5. Exceptions3.3.4.6. Batch Parameters3.3.4.7. Input/Output(Fig. 3.10)3.3.5.Additional information available pertinent to the current window will be displayed as agreen hyperlinks (Fig. 3.9). Select the green hyperlinks to access additional information.3.4. Field Help. Field Help (Fig. 3.11) provides specific help and sample data to be entered in eachdata field within a window. To use field help:3.4.1. Select the field within the window that you desire help on.3.4.2. Select Help from the drop down menus.3.4.3. Select Field Help.3.4.4. Field Help for that field is displayed (Fig. 3.12).(Fig. 3.11)3-6

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 3.12)3.5. Books. The Books help option (Fig. 3.13) provide a selection of online technical referencematerials that may be helpful in using and understanding the application.(Fig. 3.13)3.5.1. Application Terms. Application Terms (Fig. 3.13) includes a list of terms andabbreviations in the application.3.5.1.1. From the Help menu, select Books.3.5.1.2. Select Application Terms.3.5.1.3. Select the Index tab (Fig. 3.14).3.5.1.4. Type the desired term.3.5.1.5. Double-click the index entry to view a definition (Fig. 3.15).3-7

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 3.14)(Fig. 3.15)3.5.2. Data Elements Dictionary. The Data Elements Dictionary (Fig. 3.16) contains adictionary for all data elements found in the various RSupply tables. Access the DataElements Dictionary from the Books Help option (Fig. 3.13).3-8

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 3.16)3.5.3. The Data Elements Dictionary has three tabs and works like the User’s Guide. Use theContents, Index or Find tab to locate the desired Data Element (Fig. 3.17). Select thedesired data element from the list and select Display, Print or Cancel.(Fig. 3.17)3-9

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.003.5.4. Select Display to display the definition for the selected data element (Fig. 3.18).(Fig. 3.18)3.5.5. Database Specifications (Fig. 3.19) and the Interface Design Document (Fig. 3.20) aretechnical documents that deal with the programming logic of the RSupply application.NTCSS System Admin Topics is currently not available.3-10

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 3.19)(Fig. 3.20)3-11

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.003.6. Technical Support. The Technical Support help section (Fig. 3.21) provides informationrequired to obtain technical support from the Central Design Agency (CDA), Space and NavalWarfare Systems Center (SPAWAR).(Fig. 3.21)3.6.1. The Technical Support help screen has three tabs and functions similar to the User’sGuide (Fig. 3.22). The Technical Support help screen contains information onSubmitting a Trouble Call (Fig. 3.23) and Points of Contact (Fig. 3.24).(Fig. 3.22)3-12

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 3.23)3-13

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 3.24)3.7. Release Notes. Release Notes (Fig. 3.25) provide the Release Highlights and Summary ofChanges (Fig. 3.26) for the current release installed. The Release Highlights and Summary ofChanges provides information on the highlights of the release and a summary of the changesfrom the prior release.3-14

RSupply Unit User’s Guide NAVSUP P-732Release 820-01.02.00(Fig. 3.25)(Fig. 3.26)3.8. About RSupply. About RSupply (Fig. 3.27) displays a screen with the version (re

RSupply Unit User’s Guide NAVSUP P-732 Release 820-01.02.00 1-1 Chapter 1 Introduction 1. Background: Relational Supply was deployed to the fleet in 1997.Force Level RSupply is the afloat logistics application used on al