| # | Name | Location | Type | Details | Index | Description |
|---|---|---|---|---|---|---|
| .01 | transaction number(+) | 0;1 | NUMERIC | B | The internal entry number for this transaction. | |
| 1 | type | 0;2 | POINTER | 58.84 | A pointer to the name of this type transaction. | |
| 2 | pharmacy location | 0;3 | POINTER | 58.8 | This field contains a pointer to the Pharmacy location in the DRUG ACCOUNTABILITY STATS file (#58.8). The Controlled Substances module will recognize this location as the Narcotic Area of Use (NAOU), usually the pharmacy dispensing site (vault). | |
| 3 | date/time | 0;4 | DATE-TIME | The date/time of this transaction. For Controlled Substances dispensing transactions, this is the date/time the pharmacist verified this transaction. | ||
| 4 | drug | 0;5 | POINTER | 50 | F | A pointer to the drug for this transaction. |
| 5 | quantity | 0;6 | NUMERIC | The transaction quantity for this drug. If the transaction type is BALANCE ADJUSTMENT, this quantity may be a negative number. | ||
| 6 | transactor | 0;7 | POINTER | 200 | This field contains a pointer to the name of the person initiating this transaction. | |
| 7 | control point activity | 0;8 | POINTER | 410 | E | Posted (Warehouse) Issue activity that created this transaction. This field is a pointer to the CONTROL POINT ACTIVITY file (#410) and will be used mainly for receipt transactions. |
| 8 | purchase order number | 0;9 | POINTER | 442 | C | The Unposted (Non-Warehouse) Purchase Order from which this transaction was created. This field is a pointer to the PROCUREMENT & ACCOUNTING TRANSACTION file (#442) and will be used mainly for receipt transactions. |
| 9 | balance forward | 0;10 | NUMERIC | The pharmacy dispensing site (vault) inventory balance forward for this drug. This balance is used in listing pharmacy's "Daily Activity Log". | ||
| 10 | order status | 0;11 | POINTER | 58.82 | The processing status for the Controlled Substances order being updated in this transaction. This field is a pointer to the CS ORDER STATUS file (#58.82). | |
| 11 | completion status | 0;12 | POINTER | 58.83 | The completion status for this Controlled Substances order being updated by this transaction. This field is a pointer to the CS COMPLETION STATUS file (#58.83). | |
| 12 | manufacturer | 0;13 | FREE TEXT | The current manufacturer of this drug. | ||
| 13 | lot # | 0;14 | FREE TEXT | The current lot # of this drug. | ||
| 14 | expiration date | 0;15 | DATE-TIME | The current expiration date for this drug. | ||
| 15 | reason | 0;16 | FREE TEXT | Reason for creating this transaction. | ||
| 16 | pharmacy dispensing # | 0;17 | FREE TEXT | D | The pharmacy control number to identify and track this Controlled Substances transaction. This number may be manually entered in pharmacy or auto-generated by the CS software. | |
| 17 | naou | 0;18 | POINTER | 58.8 | The NAOU ordering this Controlled Substances drug. | |
| 18 | dispensed by | 1;1 | POINTER | 200 | A pointer to the name of the pharmacist dispensing this drug. | |
| 19 | processed date/time | 1;2 | DATE-TIME | The date/time this transaction was processed. For Controlled Substances dispensing transactions, this is the date/time a pharmacy technician processed this transaction. | ||
| 20 | order received by | 1;3 | POINTER | 200 | A pointer to the name of the person receiving this Controlled Substances drug into the ordering Narcotic Area of Use. | |
| 21 | receipt date/time | 1;4 | DATE-TIME | The date/time this drug was received into the ordering Narcotic Area of Use. | ||
| 22 | completion date/time | 0;19 | DATE-TIME | The date/time this Controlled Substances Green Sheet (VA FORM 10-2638) was reviewed as complete by pharmacy. | ||
| 23 | filled by | 1;5 | POINTER | 200 | A pointer to the name of the pharmacy technician processing this Controlled Substances transaction. | |
| 24 | request date/time | 1;6 | DATE-TIME | The date/time the Controlled Substances order request was generated. | ||
| 25 | ordered by | 1;7 | POINTER | 200 | A pointer to the name of the person requesting this Controlled Substances drug. | |
| 25.5 | ordered by pharmacy | 1.5;1 | POINTER | 200 | A pointer to the name of the pharmacy employee requesting the Controlled Substances order for nursing. | |
| 26 | comments | 2;0 | WORD-PROCESSING | Comments concerning this transaction. | ||
| 27 | quantity received | 1;8 | NUMERIC | The actual quantity of the drug received by the ordering NAOU. | ||
| 28 | discrepancy unresolved | 1;9 | BOOLEAN | 1:YES 0:NO | If the actual quantity of the drug received is different from the actual quantity pharmacy dispensed, then this field is set to "1" or "YES". | |
| 29 | completed by nurse | 1;10 | POINTER | 200 | A pointer to the name of the nurse returning the Green Sheet (VA FORM 10-2638) to pharmacy. | |
| 29.5 | comp by nurse date/time | 1.5;2 | DATE-TIME | The date/time this Green Sheet was completed by nursing and ready for pharmacy pickup. | ||
| 29.6 | d/t placed on insp hold | 1.5;3 | DATE-TIME | The date/time this Green Sheet was placed on hold for review by the Controlled Substances Inspector. | ||
| 29.7 | d/t insp hold removed | 1.5;4 | DATE-TIME | The date/time this Green Sheet was removed from hold by the Controlled Substances inspector. | ||
| 29.8 | hold remarks | 1.6;1 | FREE TEXT | This field contains information concerning the Green Sheet being held for CS inspector's review. | ||
| 30 | received by tech | 1;11 | POINTER | 200 | A pointer to the name of the pharmacy technician receiving this Controlled Substances drug into the NAOU. | |
| 31 | pick up date/time | 1;12 | DATE-TIME | The date/time pharmacy picked up the Green Sheet (VA FORM 10-2638) from the NAOU. | ||
| 32 | picked up by | 1;13 | POINTER | 200 | A pointer to the name of the pharmacy technician picking up the Green Sheet (VA FORM 10-2638) from the NAOU. | |
| 33 | completed by pharmacist | 1;14 | POINTER | 200 | A pointer to the name of the pharmacist or pharmacy technician completing the Green Sheet (VA FORM 10-2638). | |
| 34 | date/time ret to stock | 3;1 | DATE-TIME | The date/time this drug is being returned to stock. | ||
| 35 | quantity ret to stock | 3;2 | NUMERIC | The actual quantity of this drug being returned to stock. | ||
| 36 | reason returned to stock | 3;3 | FREE TEXT | The reason this drug is being returned to stock. | ||
| 37 | date/time turn in destroy | 3;4 | DATE-TIME | The date/time this drug is being turned in for destruction. | ||
| 38 | quantity turn in for destroy | 3;5 | NUMERIC | The actual quantity of this drug being turned in for destruction. | ||
| 39 | reason turn in for destroy | 3;6 | FREE TEXT | The reason this drug is being turned in for destruction. | ||
| 40 | request # | 0;20 | NUMERIC | The order request number from the ordering NAOU. | ||
| 41 | balance fwd ret/stk | 3;7 | NUMERIC | The inventory balance forward for this drug being returned to stock. This balance is used in listing pharmacy's "Daily Activity Log". | ||
| 47 | dest holding # | 3;8 | POINTER | 58.86 | A pointer to the destruction number for this drug being held for destruction. | |
| 48 | edit verified order date/time | 4;1 | DATE-TIME | The date/time this verified order is being edited. | ||
| 49 | pharmacist editing | 4;2 | POINTER | 200 | A pointer to name of the pharmacist editing this verified order. | |
| 50 | new quantity | 4;3 | NUMERIC | The actual quantity of this drug being dispensed, if quantity is being edited. | ||
| 51 | adjusted by quantity | 4;4 | NUMERIC | The difference in the original quantity dispensed and the edited quantity dispensed. The inventory balance will be adjusted by this amount. This quantity may be a negative number. | ||
| 52 | edit mfg/lot/exp.date | 4;5 | BOOLEAN | 1:Y 0:N | This field is set to "1" or "YES" if the manufacturer, lot #, or expiration date is being edited on this verified order. | |
| 53 | reason edited | 4;6 | FREE TEXT | The reason this verified order is being edited. | ||
| 54 | bal fwd edit verified order | 4;7 | NUMERIC | The inventory balance forward for this drug at the time this verified order is being edited. This balance is used in listing pharmacy's "Daily Activity Log". | ||
| 55 | cancel verified ord date/time | 5;1 | DATE-TIME | The date/time this verified order is being cancelled. | ||
| 56 | pharmacist cancelling | 5;2 | POINTER | 200 | A pointer to the name of the pharmacist cancelling this verified order. | |
| 57 | adjustment quantity | 5;3 | NUMERIC | The actual quantity of the drug for this cancelled order. The drug inventory balance will be increased by this adjustment quantity. | ||
| 58 | reason cancelled | 5;4 | FREE TEXT | The reason this verified order is being cancelled. | ||
| 59 | bal fwd cancel verified ord | 5;5 | NUMERIC | The inventory balance forward for this drug at the time this verified order is being cancelled. This balance is used in listing pharmacy's "Daily Activity Log". | ||
| 60 | rx # | 6;1 | POINTER | 52 | AOP | A pointer to the outpatient prescription number. |
| 61 | refill # | 6;2 | NUMERIC | If this prescription is a refill, this field will contain the refill number. | ||
| 62 | prescription date | 6;3 | DATE-TIME | The fill date for this prescription. | ||
| 63 | partial # | 6;4 | NUMERIC | If this prescription is a partial, this field contains the partial number. | ||
| 63.5 | outpatient rx # | 6;5 | FREE TEXT | This is the external form of the Outpatient prescription number. | ||
| 63.6 | releasing pharmacist | 6;6 | POINTER | 200 | This field is used to store the pharmacist responsible for the release of an Outpatient prescription in case it is a different person than the transactor. | |
| 64 | transfer from naou date/time | 7;1 | DATE-TIME | ATRN | The date/time the Controlled Substances drug was transferred from this NAOU to another NAOU. | |
| 65 | transfer from naou nurse | 7;2 | POINTER | 200 | A pointer to the name of the nurse or pharmacist transferring the Controlled Substances drug from this NAOU to another NAOU. | |
| 66 | transfer to naou | 7;3 | POINTER | 58.8 | The NAOU receiving this Controlled Substances drug from another NAOU. | |
| 67 | transfer to naou date/time | 7;4 | DATE-TIME | The date/time the Controlled Substances drug was transferred to this NAOU from another NAOU. | ||
| 68 | transfer to naou nurse | 7;5 | POINTER | 200 | A pointer to the name of the nurse receiving this transferred Controlled Substances drug from another NAOU. | |
| 69 | previous transaction # | 7;6 | POINTER | 58.81 | AE | The transaction number of the transferred from NAOU Controlled Substances drug. This is the previous transaction number for this drug. |
| 70 | quantity transferred | 7;7 | NUMERIC | The quantity of this Controlled Substances drug being transferred from an NAOU to another NAOU. | ||
| 71 | prime vendor invoice | 8;1 | FREE TEXT | To allow the entering of a Prime Vendor Invoice number for a receipt. The Integrated Funds Distribution, Control Point Activity, Accounting and Procurement (IFCAP) Purchase Order number may be used all month and there may not be a corresponding IFCAP transaction number for each Prime Vendor receipt. | ||
| 72 | referred reason | 1;15 | FREE TEXT | When a completed Green Sheet has been referred to a pharmacy supervisor for review, this field may contain comments about the reason. | ||
| 73 | patient | 9;1 | POINTER | 2 | This field contains a pointer to the name of the patient receiving this Controlled Substances medication. | |
| 73.5 | from patient id list? | 9.5;1 | BOOLEAN | 1:YES 0:NO | This field will be "YES" when the patient ID was picked up from the patient ID list. | |
| 74 | nurse id | 9;2 | POINTER | 200 | This field contains a pointer to the name of the nurse dispensing this Controlled Substances medication. | |
| 75 | original count | 9;3 | NUMERIC | This field contains the original count or balance of this drug when loaded into the TRAKKER for medication dispensing on the NAOU. | ||
| 76 | wasted quantity | 9;4 | NUMERIC | This field contains the quantity of this Controlled Substances drug that was wasted during dispensing at the NAOU. | ||
| 77 | liquid amount | 9;5 | NUMERIC | This field contains the liquid quantity of the drug dispensed at the NAOU. | ||
| 78 | second nurse id | 9;6 | POINTER | 200 | This field contains a pointer to the name of the nurse witnessing this Controlled Substances transaction. | |
| 79 | correct count | 9;7 | NUMERIC | This field contains the correct count or balance for a Controlled Substances drug on an NAOU. | ||
| 80 | pharmacist id | 9;8 | POINTER | 200 | This field contains a pointer to name of the pharmacist inventorying this Controlled Substances drug. | |
| 81 | second pharmacist id | 9;9 | POINTER | 200 | This field contains a pointer to the name of the pharmacist witnessing this Controlled Substances transaction. | |
| 82 | actual date/time | 9;10 | DATE-TIME | This field contains the actual date/time this transaction was performed using the barcode TRAKKER. | ||
| 83 | cs inspector | 9;11 | POINTER | 200 | This option contains a pointer to the name of the Controlled Substances inspector inventorying this CS drug. | |
| 84 | second cs inspector | 9;12 | POINTER | 200 | This field contains a pointer to the name of the Controlled Substances inspector witnessing the inventory of this CS drug. | |
| 85 | emergency | CS;6 | BOOLEAN | 1:YES 0:NO | A "YES" entry in this field will cause an order to print on the pharmacy emergency order printer and allow for expedited processing. | |
| 100 | cs transaction | CS;1 | BOOLEAN | 1:YES | This field will be set to "1" or "YES" if this is a Controlled Substances package transaction. This CS flag will be used when purging data within this file. | |
| 101 | printed 2320 | CS;2 | BOOLEAN | 1:YES 0:NO | This field is set to "1" or "YES" when this transaction is printed on pharmacy's VA FORM 10-2320 for this drug. | |
| 102 | printed 2321 | CS;3 | DATE-TIME | AC | This field is set to "1" or "YES" when this transaction is printed on the dispensing/receiving report (in lieu of VA FORM 10-2321). This flag is used in printing this transaction only once on the dispensing/receiving report. A reprint option is provided in the Controlled Substances module for additional copies to be printed. | |
| 103 | printed 2638 | CS;4 | BOOLEAN | 1:YES 0:NO | AH | This field is set to "1" or "YES" when a Green Sheet (VA FORM 10- 2638) is printed for this Controlled Substances order. This flag is used in printing this transaction only once. A reprint option is provided in the Controlled Substances module for additional copies to be printed. |
| 104 | printed label | CS;5 | DATE-TIME | AL | This field is set to the date/time when the label for this transaction is printed. This flag is used in printing labels only once for this transaction. A reprint label option is provided in the Controlled Substances module for additional labels to be printed. | |
| 105 | specialty | 9;13 | POINTER | 42.4 | For CDR reporting the specialty for the patient is stored at the time each dose is dispensed. | |
| 106 | prime vendor order number | 8;2 | FREE TEXT | The PRIME VENDOR ORDER NUMBER field contains the order number on which the drugs were purchased if the drug is not marked as a controlled substance. |