| # | Name | Location | Type | Details | Index | Description |
|---|---|---|---|---|---|---|
| .01 | inventory point(+) | 0;1 | FREE TEXT | B | This is the name of a warehouse, primary, or secondary inventory point. The name of the inventory point must be preceded with the station number and must be an unique name not already used. | |
| .5 | keep perpetual inventory?(+) | 0;2 | BOOLEAN | Y:YES N:NO | If KEEP PERPETUAL INVENTORY? is set to yes, the inventory point will track item quantities, usage, and receipts. | |
| .6 | keep detailed trx. history? | 0;6 | BOOLEAN | Y:YES N:NO | This field indicates whether the inventory will keep a detailed tracking history of its stocked items. If the field is set to yes, the item history will be tracked in the TRANSACTION REGISTER file 445.2. | |
| .7 | type of inventory point(+) | 0;3 | SET OF CODES | W:SUPPLY WAREHOUSE P:PRIMARY S:SECONDARY | AC | This field indicates whether the inventory point is a warehouse, a primary, or a secondary type inventory point. For each station number, there can only be one warehouse type inventory point. |
| .8 | abbreviated name(+) | 0;5 | FREE TEXT | CAB | This is the abbreviated name of the inventory point. The abbreviated name can be used when selecting an inventory point. The name must be unique for the inventory point (two inventory points cannot have the same abbreviated name). | |
| .9 | cost center | 0;7 | POINTER | 420.1 | This is the cost center for the inventory point. | |
| 1 | inventory item | 1;0 | MULTIPLE | 445.01 | This multiple field stores the items which are stored in the inventory point. The fields under the item multiple store the quantity on-hand, quantity due-out, quantity due-in, reorder points and levels, receipt and usage history, etc. | |
| 4 | distribution point | 2;0 | MULTIPLE | 445.03 | This field is used to store inventory distribution points to which it can distribute expendable supplies. The warehouse can only distribute to primary type inventory points and the primary can only distribute to secondary type inventory points. Secondaries cannot have distribution points. | |
| 5 | department number | 0;8 | FREE TEXT | This is the three digit number which identifies the inventory/distribution point to Austin. | ||
| 5.5 | issue book sort | 0;10 | SET OF CODES | A:ALPHA SORT N:NSN SORT S:SEQUENCE (NOT USED) | This information corresponds to the sort sequence for issue books used by the LOG I warehouse inventory system. This optional flag need only be set for those inventory points that need to receive issue books for Posted stock. Such inventory/distribution points should also have a department number entered in this file. | |
| 6 | inventory user | 4;0 | MULTIPLE | 445.04 | The first user for an inventory point must be entered by the user that establishes the inventory point. This user may then add other users. A user must be entered here before s/he can access the inventory point. | |
| 7 | print stock at critical level? | 0;9 | BOOLEAN | Y:YES N:NO | The program PRCPUEMS should be set up by the Site Manager to run at some interval defined by the Site Manager. It should run during non-peak times. This program searches the inventory file for EVERY inventory point. If it finds one item with a quantity at or below the Safety Stock Level, the inventory point is flagged. Then, the next time any user for that inventory point signs on, s/he will be notified that s/he needs to run the report of items at or below Safety Stock level. The message will keep coming up for each person that signs on, until the report has been run. | |
| 7.4 | last open balances set | 0;22 | DATE-TIME | This field is used to store the date the opening monthly balances are set. If the date the last opening balances set does not equal the current month and year, a message will be displayed to the users as they sign into the inventory point menus. | ||
| 7.5 | last purge usage | 0;14 | DATE-TIME | This date is automatically entered when the purge of monthly usage/ distribution totals by item is run. It is set to the last day of the month when the purge was run. The purge options should be run monthly in order to free up disk space. Failure to run the purge option for the current month will result in a message which is displayed at the top of the screen to all users. | ||
| 7.6 | last purge receipts | 0;17 | DATE-TIME | This date is automatically entered when the purge of monthly receipts history by item is run. It is set to the last day of the month when the purge was run. The purge options should be run monthly in order to free up disk space. Failure to run the purge option for the current month will result in a message which is displayed at the top of the screen to all users. | ||
| 7.7 | last purge trans register | 0;18 | DATE-TIME | This date is automatically entered when the purge of monthly transaction register purge is run. It is set to the last day of the month when the purge was run. The purge options should be run monthly in order to free up disk space. Failure to run the purge option for the current month will result in a message which is displayed at the top of the screen to all users. | ||
| 7.8 | last purge distribution | 0;19 | DATE-TIME | This date is automatically entered when the purge of monthly history by cost center purge is run. It is set to the last day of the month when the purge was run. The purge options should be run monthly in order to free up disk space. Failure to run the purge option for the current month will result in a message which is displayed at the top of the screen to all users. | ||
| 7.9 | automatic purge | 0;21 | BOOLEAN | Y:YES N:NO | If this field is set to YES, the taskmanager automatic purge option will purge inventory point data back 13 months. If the field is set to NO (or null), the manager of the inventory point will be responsible for purging the inventory point data. | |
| 8 | *enter item descriptions | 0;11 | BOOLEAN | Y:YES N:NO | This field is no longer used. | |
| 9 | regular whse. issues schedule | 0;4 | SET OF CODES | W:WEEKLY 2:EVERY 2 WEEKS M:MONTHLY O:OTHER | This field is entered by Personal Property Management, and holds the codes for weekly, biweekly, monthly, or other type distribution of warehouse issues. | |
| 10 | regular whse. issues due date | 0;12 | DATE-TIME | The date is set into this field in PPM, when they wish to notify Inventory/ Distribution points that their regularly scheduled whse.issues request is due. When the date is set, the user of the Inventory/Distribution point is notified that his/her whse. issues request is due. The date is cleared the next time the user generates an automatic request for posted stock. | ||
| 11 | mis costing section | 3;0 | MULTIPLE | 445.011 | For use in tracking costs of distributed supplies. | |
| 12 | mos inactive before item del. | 0;13 | NUMERIC | The only way to delete an item from your inventory file, is to set the 'DELETE ITEM WHEN INVENTORY 0' flag to 'Y'. During the automatic generation of a suggested order, if the program encounters an item with the flag set, it first makes sure that the inventory quantity on hand, the DUE-IN, and the DUE-OUT are all 0, and that the item does not exist on any of your secondary distribution points. If it meets the criteria, then the program checks this field, and if it contains a number, the program makes sure that there has been no activity for the item (i.e., usage, distribution or receiving) for at least the number of months specified in this field, before deleting the item from the inventory file. | ||
| 13 | *parameters can be edited by | 0;15 | POINTER | 445 | This field is no longer used. | |
| 14 | primary updated by warehouse | 0;16 | BOOLEAN | Y:YES N:NO | This is a switch controlled by the primary inventory point. If set to NO, the primary inventory point quantity on-hand will not be updated by the warehouse. The default is YES or null. | |
| 15 | special inventory point type | 0;20 | SET OF CODES | D:DRUG ACCOUNTABILITY S:SPD | ASPEC | This field is a switch controlled by the primary inventory point. If this field is set to 'D', it will update the pharmacy drug accountability file when the primary quantity on-hand is changed. |
| 16 | picking ticket printer | DEV;1 | FREE TEXT | This field stores the device which is used to automatically print the picking ticket in SPD for case cart/instrument kit distribution orders placed by Surgery. This field also stores the device used to automatically print the picking ticket for Warehouse issue books. | ||
| 19 | pre-conversion header (no edits) | SEC;1 | FREE TEXT | This field is automatically populated when the option to 'Convert Secondary to Primary' [PRCP CONVERT SECONDARY] is run. It is simply the content of the zero node of the inventory point as it existed before conversion. The only time it would ever be referenced is in cases where users mistakenly convert an inventory point and need to 'undo' the conversion. DATA CONTAINED IN THIS FIELD ARE NEVER USED IN ANY TYPE OF PRODUCTION APPLICATION. | ||
| 19.5 | converted by | SEC;2 | POINTER | 200 | This field is automatically populated when the option to 'Convert Secondary to Primary' [PRCP CONVERT SECONDARY] is run. It indicates who actually converted this inventory from a secondary to a primary. It is included solely for documentation. DATA CONTAINED IN THIS FIELD ARE NEVER USED IN ANY TYPE OF PRODUCTION APPLICATION. | |
| 19.6 | conversion date | SEC;3 | DATE-TIME | |||
| 19.7 | pre-conversion stocked by | SEC;4 | POINTER | 445 | The subject inventory (.01 field) needs to be a DISTRIBUTION POINT of this entry if the conversion is ever undone. | |
| 20 | pre-conversion item (no edits) | SECITM;0 | MULTIPLE | 445.08 | ||
| 21 | pre-conversion mis (no edits) | SECMIS;0 | MULTIPLE | 445.021 | ||
| 22 | ss provider | 5;1 | POINTER | 445.5 | AI | When an automated supply station stocks items within an inventory point, this field contains a pointer to the machine used, allowing GIP to correctly build and transmit information to the automated supply station by referencing file 445.5. |
| 23 | ss quantity last transmitted | 6;1 | DATE-TIME | This field will be updated by the receipt of a 'quantity on hand' message from the automated supply station. It will be referenced when users wish to print an exception report comparing the quantity of an item in GIP and in the automated supply station. | ||
| 24 | quantity replacement requestor | 7;1 | POINTER | 200 | The name of the authorized person requesting that the on hand quantities in GIP be adjusted to the values reported in the next supply station transaction. | |
| 25 | quantity replacement requested | 7;2 | DATE-TIME | This is the Date/Time that an authorized person requested the on hand quantities in GIP be adjusted to the values reported in the next supply station transaction. | ||
| 26 | quantity replacement user | 8;0 | MULTIPLE | 445.026 | Users in this section are authorized to request on hand quantity replacement updates from the values stored in the associated supply stations. | |
| 27 | on-demand users | 9;0 | MULTIPLE | 445.027 | This file will store the users designated by the application coordinator with the ability to modify an On-Demand Setting for any item in this inventory point. Because the On-Demand Setting applies only to items in the Primary and Secondary Inventory Points, this multiple will never be populated in the Warehouse. |