STANDARD DATA DICTIONARY #791811 -- REMOTE INVENTORY PRODUCT FILE 6/27/25 PAGE 1
STORED IN ^RMPF(791811, (2431 ENTRIES) SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 2.0)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file contains all the products. that may be ordered from the Denver Distribution Center through the Remote Order/Entry System.
The file contains information about each item that is needed in the order process. Components, batteries, etc. that may be used
with each item are also stored in the file. This file is exported by the DDC. The file will be updated via patch as contracts are
updated. Since the unit cost of some items varies with discounts that occur on individual purchase orders for that item, the cost
field in this file may not exactly match the cost from the DDC at the time the order is filled, but should give the user a close
approximation of the cost. The file should not be edited by the local facility
DD ACCESS: @
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: @
IDENTIFIED BY: MAKE (#.02)
POINTED TO BY: ITEM NAME field (#.01) of the LINE ITEM sub-field (#791810.0101) of the STATION ORDER File (#791810)
CROSS
REFERENCED BY: PRODUCT GROUP(AC), ITEM NAME(B), NSN(C), MAKE(D), NSN(F)
791811,.01 ITEM NAME 0;1 FREE TEXT (Required)
INPUT TRANSFORM: K:$L(X)>30!($L(X)<2)!'(X'?1P.E) X
LAST EDITED: DEC 28, 1990
HELP-PROMPT: NAME MUST BE 2-30 CHARACTERS NOT STARTING WITH PUNCTUATION
DESCRIPTION:
This in the free text name of the item to be selected as part of a transaction.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 791811^B
1)= S ^RMPF(791811,"B",$E(X,1,30),DA)=""
2)= K ^RMPF(791811,"B",$E(X,1,30),DA)
Standard name cross-reference.
791811,.02 MAKE 0;2 FREE TEXT
INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>30!($L(X)<2) X
LAST EDITED: SEP 14, 1994
HELP-PROMPT: Answer must be 2-30 characters in length.
DESCRIPTION:
This is the free text name of the make of the item to be selected as part of a transaction.
CROSS-REFERENCE: 791811^D
1)= S ^RMPF(791811,"D",$E(X,1,30),DA)=""
2)= K ^RMPF(791811,"D",$E(X,1,30),DA)
This cross-reference allows models to be looked up by make.
791811,.03 PRODUCT GROUP 0;3 POINTER TO REMOTE PRODUCT GROUP FILE (#791811.1)
LAST EDITED: AUG 05, 1994
DESCRIPTION:
This is the DDC product group to which the item belongs.
CROSS-REFERENCE: 791811^AC
1)= S ^RMPF(791811,"AC",$E(X,1,30),DA)=""
2)= K ^RMPF(791811,"AC",$E(X,1,30),DA)
This cross-reference allows models to be sorted by product group.
791811,.04 COST 0;4 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999.9999)!(X<0)!(X?.E1"."5N.N) X
LAST EDITED: DEC 20, 1990
HELP-PROMPT: Type a Number between 0 and 99999.9999, 4 Decimal Digits
DESCRIPTION:
This is the approximate current cost of the item.
791811,.05 NSN 0;5 FREE TEXT
INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>16!($L(X)<16)!'(X?4N1"-"2N1"-"3N1"-"4N) X
LAST EDITED: FEB 16, 1994
HELP-PROMPT: Answer must be 16 characters in length.
DESCRIPTION:
This is the National Stock Number of the item.
CROSS-REFERENCE: 791811^C
1)= S ^RMPF(791811,"C",$E(X,1,30),DA)=""
2)= K ^RMPF(791811,"C",$E(X,1,30),DA)
This cross-reference allows a model to be looked up by National Stock Number.
CROSS-REFERENCE: 791811^F^MUMPS
1)= I $L(X)=16 S Z1=$E(X,13,16),^RMPF(791811,"F",Z1,DA)="" K Z1
2)= I $L(X)=16 S Z1=$E(X,13,16) K ^RMPF(791811,"F",Z1,DA),Z1
This cross-reference allows users to look up items by the last four numbers of the item's National
Stock Number.
791811,.06 CURRENT MARKUP 0;6 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>100)!(X<0)!(X?.E1"."5N.N) X
LAST EDITED: MAY 10, 1991
HELP-PROMPT: Type a Number between 0 and 100, 4 Decimal Digits
DESCRIPTION:
This is the current percentage of markup for the item.
791811,.07 REQUIRES SECOND BATTERY TYPE 0;7 SET
'0' FOR TWO BATTERY TYPES NOT ALLOWED;
'1' FOR TWO BATTERY TYPES ALLOWED;
LAST EDITED: OCT 07, 1991
DESCRIPTION:
This field will contain a '1' if the item ordered requires a second battery type.
791811,.08 UNIT OF ISSUE 0;8 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: FEB 16, 1994
HELP-PROMPT: Type a Number between 1 and 9999, 0 Decimal Digits
DESCRIPTION: If the item is issued in a specific quantity (6-pack of batteries), this field will contain the
smallest number issued. If there is no entry, the unit of issue is assumed to be one.
791811,.09 AMIS CODE FOR PROSTHETICS 0;9 SET
'01 A' FOR AIDS FOR THE BLIND UNDER $5000;
'01 B' FOR AIDS FOR THE BLIND OVER $5000;
'08' FOR FLEX-ORTHO;
'20' FOR PROSTHETIC SOCKS & HOSE;
'14 C' FOR SCROTAL SUPPORT;
'13 K' FOR EQUIPMENT, ALL OTHER;
LAST EDITED: JUN 30, 1994
DESCRIPTION:
This field contains the Prosthetics AMIS code for the line item.
791811,101 COMPONENT 101;0 POINTER Multiple #791811.0101 (Add New Entry without Asking)
DESCRIPTION:
This multiple field contains a list of the componenets that may be associated with an item.
791811.0101,.01 COMPONENT 0;1 POINTER TO HEARING AID COMPONENTS FILE (#791811.2) (Multiply asked)
LAST EDITED: FEB 20, 1991
DESCRIPTION:
This is a pointer to the Hearing Aid Components File for the component associated with the item.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 791811.0101^B
1)= S ^RMPF(791811,DA(1),101,"B",$E(X,1,30),DA)=""
2)= K ^RMPF(791811,DA(1),101,"B",$E(X,1,30),DA)
Standard name cross-reference. This cross-reference is used to look up components for an item.
791811.0101,.02 COST OF COMPONENT 0;2 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999.9999)!(X<0)!(X?.E1"."5N.N) X
LAST EDITED: DEC 20, 1990
HELP-PROMPT: Type a Number between 0 and 99999.9999, 4 Decimal Digits
DESCRIPTION:
This is the current cost of the component.
791811,102 BATTERY TYPE 102;0 POINTER Multiple #791811.0102 (Add New Entry without Asking)
DESCRIPTION:
This multiple field is a list of the specific batteries that may be associated with a line item.
791811.0102,.01 BATTERY TYPE 0;1 POINTER TO BATTERY FILE (#791811.3) (Multiply asked)
INPUT TRANSFORM: I $D(X) S DINUM=X
LAST EDITED: JUL 30, 1990
DESCRIPTION:
This is a pointer to the Battery File for a battery type associated with this line item.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 791811.0102^B
1)= S ^RMPF(791811,DA(1),102,"B",$E(X,1,30),DA)=""
2)= K ^RMPF(791811,DA(1),102,"B",$E(X,1,30),DA)
Standard name cross-reference. It is used to look up batteries for the item.
791811,999 INACTIVE I;1 SET
'1' FOR INACTIVE;
'0' FOR ACTIVE;
LAST EDITED: DEC 14, 1990
DESCRIPTION: If this field is set to 'Inactive', the line item will not be available for selection in the
order/entry process.
FILES POINTED TO FIELDS
BATTERY (#791811.3) BATTERY TYPE:BATTERY TYPE (#.01)
HEARING AID COMPONENTS (#791811.2) COMPONENT:COMPONENT (#.01)
REMOTE PRODUCT GROUP (#791811.1) PRODUCT GROUP (#.03)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):