Files > ITEM MASTER

name

ITEM MASTER

number

441

location

^PRC(441,

description

This file contains descriptive information for any supply item that can be ordered. Contains information needed for purchasing or ordering the item. Any item that is purchased repetitively should be entered to this file.

Fields

#	Name	Location	Type	Details	Index	Description
.01	number(+)	0;1	NUMERIC		B	This is the item number.
.05	short description(+)	0;2	FREE TEXT		C	This is the short description of the item.
.06	case cart/tray/instrument kit	0;6	SET OF CODES	P:PURCHASEABLE S:CASE CART/TRAY/INSTRUMENT KIT		This field indicates whether an item is a case cart or instrument kit. Case cart and instrument kits should not be purchased from outside of the hospital. This is the purchaseable item indicator. 'P' stands for items purchased outside the hospital. 'S' stands for a set/pack assembled in hospital from purchased items.
.08	synonym	5;0	MULTIPLE	441.05
.1	description	1;0	WORD-PROCESSING			This is the description of the item.
1	fcp	4;0	MULTIPLE	441.03		This is the fund control point.
2	fsc(+)	0;3	POINTER	441.2		This is the federal supply classification.
3	inc	0;12	FREE TEXT			This field lists the Item Name Code for this item.
5	nsn	0;5	FREE TEXT		BB	This is the National Stock Number for the item.
5.5	nsn verified	3;6	DATE-TIME			The date that the National Stock Number was verified.
6	vendor	2;0	MULTIPLE	441.01		This is the vendor for the item.
7	hazardous material	0;14	SET OF CODES	HM:HAZARDOUS MATERIAL		This is a flag to state if this ITEM is hazardous.
9	last vendor ordered	0;4	POINTER	440		This is the last vendor ordered.
10	mandatory source	0;8	POINTER	440		This is the mandatory source for an item.
12	boc	0;10	POINTER	420.2		This is the BOC for this item.
13	set/pack assembled by	0;7	POINTER	445		When a Set/Pack type item is added to this file (by the Generic Inventory Package), the Inventory point that added the item is stuffed into this field by the program. It is then used as a screen to keep other inventory points from changing the data associated with the item.
14	date item created	0;9	DATE-TIME			This is the date the item was created.
15	created by	0;11	POINTER	200		This is the person who created the item.
16	inactivated item?	3;1	SET OF CODES	1:INACTIVATED		This is the set of codes for an inactivated item. This field is set to '1' by option to inactivate an item.
16.5	replacement item	3;4	POINTER	441		This is the replacement item for an inactivated item.
17	date inactivated	3;2	DATE-TIME			This is the date the item was inactivated.
18	inactivated by	3;3	POINTER	200		This is the person who inactivated the item.
19	mfg part no.	3;5	FREE TEXT			This is the Manufacturer's Part Number (#).
20	food group(+)	3;7	SET OF CODES	1:Meat, Fish, Poultry, Eggs & Convenience Entrees 2:Milk, Milk Products 3:Fruits, Vegetables 4:Bread, Flour, Cereal, etc. 5:Commercial Nutritional Products, Tube feedings & supplements 6:Miscellaneous, Foods		This is the catalog food group returned from ISMS by a catalog request.
21	sku	3;8	POINTER	420.5		This is the Stock Keeping Unit of Measure.
22	drug type code(+)	3;9	SET OF CODES	A:NARCOTIC L:CONTROLLED SUBSTANCE D:OTHER DRUGS		This is the set of drug type codes (Narcotic, Controlled substance, or Other) which will appear on the LOG code sheet.
23	reusable item	0;13	BOOLEAN	y:YES		This field is used for case carts/instrument kits. If an item is a reusable item (field set to YES), the item will not be charged to the inventory point during the ordering and posting process. Also, reusable items will not increment/decrement the quantity on-hand when assembling or disassembling case carts or instrument kits. If the field is not set to YES, the item is treated as a disposable item.
24	sic code	3;10	POINTER	444.2		The Standard Industrial Classification coding system categorizes organizations by type of economic activity. The SIC code is used in the Request for Quotation (RFQ) module to direct requests to the appropriate group of potential vendors.
50	pre nif long description	8;0	WORD-PROCESSING			This field stores the value of the DESCRIPTION field (#.1) prior to the overwriting of that field's value with the value from the National Item File (NIF) database. This field MUST NOT be edited. It is for historical record only.
51	nif item number	0;15	NUMERIC		I	This is the Item Number assigned to this item in the National Item File (NIF). This field is populated by a feed from the NIF and must not be user edited.
52	pre nif short description	9;1	FREE TEXT			This field stores the value of the SHORT DESCRIPTION field (#.05) prior to that field's overwrite with the value of the Brief Item Description from the National Item File (NIF). This field must not be edited. It is for historical record only.