Information Systems:UWD Tables
UWD Tables
Instead of building individual files for each set of options for data fields that can be entered or selected by a maintenance or inquiry program (for example, substitution classes, or price types), the extensions use one data file that can contain multiple tables.
To find out the name of the table a program is using for a particular field, key a question mark (?) into that field and press enter.
10/26/15 10:15:27 uniPHARM --Volume test ISRIQ100/LISTCTL
ISS - Show Item Substitution Master Records VOLUME 1.00
Display Order Field Test Value
DATED By Eff Date Descending, I
Limit to: AND
Class Status Date Range AND
? AD 00 00 00 00 Curr
Source Item Containing Target Items(s) Usage Generic
_________________________________________________
MA=Main Info | TBRIQ120/SELECT |
CP=Copy | Start at UX ISSCLASS |
Item | ISS Substitution Class | EFF END
00162800 | 1=Select | DEC 31 50
02400588 | Element Description/Data | DEC 31 50
02052793 | BONUS Bonus | DEC 31 50
02430056 | GENER Generic | DEC 31 50
02430064 | REPLC Replacement | DEC 31 50
02430072 | SUGG Suggestion | DEC 31 50
02430080 | --END-- | DEC 31 50
02071066 | | DEC 31 50
02349819 | F5=Refresh F12=Previous | DEC 31 50 +
|_______________________________________________| 21=Srcn Reset
F3=Exit F5=Refresh F6=Add Substitution F12=Previous F24=Srcn Save
This show that the table (UX ISSCLASS) is used for item substitution class.
Go to -
Unity / Start uniPharm Extensions / VA Company / UWD Tables Menu
This menu shows multiple table types that were set up by the contractors that wrote the Extensions, but we are only using the UX extension tables.
Go into . Key in 'ISSC' for 'Start display at', and make sure 'Limit to system' is 'UX'. then press enter.
10/26/15 10:14:32 uniPHARM --Volume test TBRUP002/TABLECTL
(C) 2004 RCS Ltd. CSU -- Show List of Tables CSU Release 6.0
Display Order Table Library: RCSUTILVOL
A By application,then table
Start display at Limit to: Sys Search for Secure Type
ISSC UX
1=Display Layout 5=Elements C=Copy R=Rename W=Programs Use
2=Change Layout 9=Purge table H=HELP Z=Clear elements
A=Audit Info P=Print M=Merge table
Ty Sy Table Name Description # Password
U UX ISSCLASS ISS Substitution Class 4
U UX ISSEXCPTYP Substitution Exception Type Codes 2
U UX ISSOSRCINV Only if Source Inventory Codes 3
U UX ISSOTGTINV Only if Target Inventory Codes 3
U UX ISSSTATUS Substitution Status Codes 3
U UX ISSTYPE Type of System or Application Issue 5
U UX ISSUSAGE ISS - Substitution Usage Codes 2
R UX ISSVIEWSUG Item Suggestion View Type 3 +
P next to an application indicates a table which requires a password
F3=Exit F12=Previous F15=Copy a Table
F5=Refresh F6=Add a New Table F17=Rename Table