| FileMan FileNo | FileMan Filename | Package |
|---|---|---|
| 58.81 | DRUG ACCOUNTABILITY TRANSACTION | Drug Accountability |
| Package | Total | FileMan Files |
|---|---|---|
| Controlled Substances | 3 | CS WORKSHEET(#58.85)[7] CS DESTRUCTION(#58.86)[8] CS ERROR LOG(#58.89)[1] |
| Drug Accountability | 2 | DRUG ACCOUNTABILITY STATS(#58.8)[#58.800118(17), #58.800119(.01)] DRUG ACCOUNTABILITY TRANSACTION(#58.81)[69] |
| Package | Total | FileMan Files |
|---|---|---|
| Controlled Substances | 3 | CS ORDER STATUS(#58.82)[10] CS COMPLETION STATUS(#58.83)[11] CS DESTRUCTION(#58.86)[47] |
| Drug Accountability | 3 | DRUG ACCOUNTABILITY STATS(#58.8)[2, 17, 66] DRUG ACCOUNTABILITY TRANSACTION(#58.81)[69] DRUG ACCOUNTABILITY TRANSACTION TYPE(#58.84)[1] |
| IFCAP | 2 | PROCUREMENT & ACCOUNTING TRANSACTIONS(#442)[8] CONTROL POINT ACTIVITY(#410)[7] |
| Registration | 2 | SPECIALTY(#42.4)[105] PATIENT(#2)[73] |
| Kernel | 1 | NEW PERSON(#200)[6, 18, 20, 23, 25, 25.5, 29, 30, 32, 33, 49, 56, 63.6, 65, 68, 74, 78, 80, 81, 83, 84] |
| Outpatient Pharmacy | 1 | PRESCRIPTION(#52)[60] |
| Pharmacy Data Management | 1 | DRUG(#50)[4] |
| Field # | Name | Loc | Type | Details |
|---|---|---|---|---|
| .01 | TRANSACTION NUMBER | 0;1 | NUMBER | ************************REQUIRED FIELD************************
|
| 1 | TYPE | 0;2 | POINTER TO DRUG ACCOUNTABILITY TRANSACTION TYPE FILE (#58.84) | DRUG ACCOUNTABILITY TRANSACTION TYPE(#58.84)
|
| 2 | PHARMACY LOCATION | 0;3 | POINTER TO DRUG ACCOUNTABILITY STATS FILE (#58.8) | DRUG ACCOUNTABILITY STATS(#58.8)
|
| 3 | DATE/TIME | 0;4 | DATE |
|
| 4 | DRUG | 0;5 | POINTER TO DRUG FILE (#50) | DRUG(#50)
|
| 5 | QUANTITY | 0;6 | NUMBER |
|
| 6 | TRANSACTOR | 0;7 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 7 | CONTROL POINT ACTIVITY | 0;8 | POINTER TO CONTROL POINT ACTIVITY FILE (#410) | CONTROL POINT ACTIVITY(#410)
|
| 8 | PURCHASE ORDER NUMBER | 0;9 | POINTER TO PROCUREMENT & ACCOUNTING TRANSACTIONS FILE (#442) | PROCUREMENT & ACCOUNTING TRANSACTIONS(#442)
|
| 9 | BALANCE FORWARD | 0;10 | NUMBER |
|
| 10 | ORDER STATUS | 0;11 | POINTER TO CS ORDER STATUS FILE (#58.82) | CS ORDER STATUS(#58.82)
|
| 11 | COMPLETION STATUS | 0;12 | POINTER TO CS COMPLETION STATUS FILE (#58.83) | CS COMPLETION STATUS(#58.83)
|
| 12 | MANUFACTURER | 0;13 | FREE TEXT |
|
| 13 | LOT # | 0;14 | FREE TEXT |
|
| 14 | EXPIRATION DATE | 0;15 | DATE |
|
| 15 | REASON | 0;16 | FREE TEXT |
|
| 16 | PHARMACY DISPENSING # | 0;17 | FREE TEXT |
|
| 17 | NAOU | 0;18 | POINTER TO DRUG ACCOUNTABILITY STATS FILE (#58.8) | DRUG ACCOUNTABILITY STATS(#58.8)
|
| 18 | DISPENSED BY | 1;1 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 19 | PROCESSED DATE/TIME | 1;2 | DATE |
|
| 20 | ORDER RECEIVED BY | 1;3 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 21 | RECEIPT DATE/TIME | 1;4 | DATE |
|
| 22 | COMPLETION DATE/TIME | 0;19 | DATE |
|
| 23 | FILLED BY | 1;5 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 24 | REQUEST DATE/TIME | 1;6 | DATE |
|
| 25 | ORDERED BY | 1;7 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 25.5 | ORDERED BY PHARMACY | 1.5;1 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 26 | COMMENTS | 2;0 | WORD-PROCESSING #58.8126 |
|
| 27 | QUANTITY RECEIVED | 1;8 | NUMBER |
|
| 28 | DISCREPANCY UNRESOLVED | 1;9 | SET |
|
| 29 | COMPLETED BY NURSE | 1;10 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 29.5 | COMP BY NURSE DATE/TIME | 1.5;2 | DATE |
|
| 29.6 | D/T PLACED ON INSP HOLD | 1.5;3 | DATE |
|
| 29.7 | D/T INSP HOLD REMOVED | 1.5;4 | DATE |
|
| 29.8 | HOLD REMARKS | 1.6;1 | FREE TEXT |
|
| 30 | RECEIVED BY TECH | 1;11 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 31 | PICK UP DATE/TIME | 1;12 | DATE |
|
| 32 | PICKED UP BY | 1;13 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 33 | COMPLETED BY PHARMACIST | 1;14 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 34 | DATE/TIME RET TO STOCK | 3;1 | DATE |
|
| 35 | QUANTITY RET TO STOCK | 3;2 | NUMBER |
|
| 36 | REASON RETURNED TO STOCK | 3;3 | FREE TEXT |
|
| 37 | DATE/TIME TURN IN DESTROY | 3;4 | DATE |
|
| 38 | QUANTITY TURN IN FOR DESTROY | 3;5 | NUMBER |
|
| 39 | REASON TURN IN FOR DESTROY | 3;6 | FREE TEXT |
|
| 40 | REQUEST # | 0;20 | NUMBER |
|
| 41 | BALANCE FWD RET/STK | 3;7 | NUMBER |
|
| 47 | DEST HOLDING # | 3;8 | POINTER TO CS DESTRUCTION FILE (#58.86) | CS DESTRUCTION(#58.86)
|
| 48 | EDIT VERIFIED ORDER DATE/TIME | 4;1 | DATE |
|
| 49 | PHARMACIST EDITING | 4;2 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 50 | NEW QUANTITY | 4;3 | NUMBER |
|
| 51 | ADJUSTED BY QUANTITY | 4;4 | NUMBER |
|
| 52 | EDIT MFG/LOT/EXP.DATE | 4;5 | SET |
|
| 53 | REASON EDITED | 4;6 | FREE TEXT |
|
| 54 | BAL FWD EDIT VERIFIED ORDER | 4;7 | NUMBER |
|
| 55 | CANCEL VERIFIED ORD DATE/TIME | 5;1 | DATE |
|
| 56 | PHARMACIST CANCELLING | 5;2 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 57 | ADJUSTMENT QUANTITY | 5;3 | NUMBER |
|
| 58 | REASON CANCELLED | 5;4 | FREE TEXT |
|
| 59 | BAL FWD CANCEL VERIFIED ORD | 5;5 | NUMBER |
|
| 60 | RX # | 6;1 | POINTER TO PRESCRIPTION FILE (#52) | PRESCRIPTION(#52)
|
| 61 | REFILL # | 6;2 | NUMBER |
|
| 62 | PRESCRIPTION DATE | 6;3 | DATE |
|
| 63 | PARTIAL # | 6;4 | NUMBER |
|
| 63.5 | OUTPATIENT RX # | 6;5 | FREE TEXT |
|
| 63.6 | RELEASING PHARMACIST | 6;6 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 64 | TRANSFER FROM NAOU DATE/TIME | 7;1 | DATE |
|
| 65 | TRANSFER FROM NAOU NURSE | 7;2 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 66 | TRANSFER TO NAOU | 7;3 | POINTER TO DRUG ACCOUNTABILITY STATS FILE (#58.8) | DRUG ACCOUNTABILITY STATS(#58.8)
|
| 67 | TRANSFER TO NAOU DATE/TIME | 7;4 | DATE |
|
| 68 | TRANSFER TO NAOU NURSE | 7;5 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 69 | PREVIOUS TRANSACTION # | 7;6 | POINTER TO DRUG ACCOUNTABILITY TRANSACTION FILE (#58.81) | DRUG ACCOUNTABILITY TRANSACTION(#58.81)
|
| 70 | QUANTITY TRANSFERRED | 7;7 | NUMBER |
|
| 71 | PRIME VENDOR INVOICE | 8;1 | FREE TEXT |
|
| 72 | REFERRED REASON | 1;15 | FREE TEXT |
|
| 73 | PATIENT | 9;1 | POINTER TO PATIENT FILE (#2) | PATIENT(#2)
|
| 73.5 | FROM PATIENT ID LIST? | 9.5;1 | SET |
|
| 74 | NURSE ID | 9;2 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 75 | ORIGINAL COUNT | 9;3 | NUMBER |
|
| 76 | WASTED QUANTITY | 9;4 | NUMBER |
|
| 77 | LIQUID AMOUNT | 9;5 | NUMBER |
|
| 78 | SECOND NURSE ID | 9;6 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 79 | CORRECT COUNT | 9;7 | NUMBER |
|
| 80 | PHARMACIST ID | 9;8 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 81 | SECOND PHARMACIST ID | 9;9 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 82 | ACTUAL DATE/TIME | 9;10 | DATE |
|
| 83 | CS INSPECTOR | 9;11 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 84 | SECOND CS INSPECTOR | 9;12 | POINTER TO NEW PERSON FILE (#200) | NEW PERSON(#200)
|
| 85 | EMERGENCY | CS;6 | SET |
|
| 100 | CS TRANSACTION | CS;1 | SET |
|
| 101 | PRINTED 2320 | CS;2 | SET |
|
| 102 | PRINTED 2321 | CS;3 | DATE |
|
| 103 | PRINTED 2638 | CS;4 | SET |
|
| 104 | PRINTED LABEL | CS;5 | DATE |
|
| 105 | SPECIALTY | 9;13 | POINTER TO SPECIALTY FILE (#42.4) | SPECIALTY(#42.4)
|
| 106 | PRIME VENDOR ORDER NUMBER | 8;2 | FREE TEXT |
|
| ICR LINK | Subscribing Package(s) | Fields Referenced | Description |
|---|---|---|---|
| ICR #2520 | Transaction Number (.01). Access: Read w/Fileman Type (1). Access: Read w/Fileman Pharmacy Location (2). Access: Read w/Fileman Date/time (3). Access: Read w/Fileman Drug (4). Access: Read w/Fileman Quantity (5). Access: Read w/Fileman Purchase Order Number (8). Access: Read w/Fileman Manufacturer (12). Access: Read w/Fileman NAOU (17). Access: Read w/Fileman Edit Verified Order Date/time (48). Access: Read w/Fileman New Quantity (50). Access: Read w/Fileman Cancelled Verified Order Date/time (55). Access: Read w/Fileman Prime Vendor Invoice (71). Access: Read w/Fileman Prime Vendor Order Number (106). Access: Read w/Fileman Patient (73). Access: Read w/Fileman |
||
| ICR #2808 | |||
| ICR #5189 | |||
| ICR #5836 |
| Name | Field # of Occurrence |
|---|---|
| ^%DT | 3+1, 14+1, 19+1, 21+1, 22+1, 24+1, 29.5+1, 29.6+1, 29.7+1, 31+1 , 34+1, 37+1, 48+1, 55+1, 62+1, 64+1, 67+1, 82+1, 102+1, 104+1 |
| EN^DDIOL | .01DEL.01+1 |
| ^DIC | 2+1, 4+1, 17+1, 18+1, 20+1, 23+1, 25+1, 25.5+1, 29+1, 30+1 , 32+1, 33+1, 49+1, 56+1, 65+1, 66+1, 68+1, 69+1 |
| Y^DIQ | ID4+1, ID17+1 |
| KAD^PSDUTL | 10(XREF 1K) |
| KAF^PSDUTL | 3(XREF 1K) |
| KAFL^PSDUTL | 2(XREF 1K) |
| KAFT^PSDUTL | 1(XREF 1K) |
| SAD^PSDUTL | 10(XREF 1S) |
| SAF^PSDUTL | 3(XREF 1S) |
| SAFL^PSDUTL | 2(XREF 1S) |
| SAFT^PSDUTL | 1(XREF 1S) |
| KACT^PSDUTL1 | 3(XREF 2K) |
| KACT1^PSDUTL1 | 1(XREF 2K) |
| KACT2^PSDUTL1 | 2(XREF 2K) |
| KACT3^PSDUTL1 | 4(XREF 2K) |
| KACT4^PSDUTL1 | 34(XREF 1K) |
| KACT5^PSDUTL1 | 48(XREF 1K) |
| KACT6^PSDUTL1 | 55(XREF 1K) |
| KAD^PSDUTL1 | 17(XREF 1K) |
| SACT^PSDUTL1 | 3(XREF 2S) |
| SACT1^PSDUTL1 | 1(XREF 2S) |
| SACT2^PSDUTL1 | 2(XREF 2S) |
| SACT3^PSDUTL1 | 4(XREF 2S) |
| SACT4^PSDUTL1 | 34(XREF 1S) |
| SACT5^PSDUTL1 | 48(XREF 1S) |
| SACT6^PSDUTL1 | 55(XREF 1S) |
| SAD^PSDUTL1 | 17(XREF 1S) |
| KAG^PSDUTL2 | 11(XREF 1K) |
| KAG1^PSDUTL2 | 17(XREF 2K) |
| SAG^PSDUTL2 | 11(XREF 1S) |
| SAG1^PSDUTL2 | 17(XREF 2S) |
| KACT7^PSDUTL3 | 37(XREF 1K) |
| SACT7^PSDUTL3 | 37(XREF 1S) |
| KAK^PSDUTL4 | 21(XREF 1K) |
| KAK1^PSDUTL4 | 17(XREF 3K) |
| SAK^PSDUTL4 | 21(XREF 1S) |
| SAK1^PSDUTL4 | 17(XREF 3S) |
| KAEM^PSDUTL5 | 3(XREF 3K) |
| KAEM1^PSDUTL5 | 85(XREF 1K) |
| KAEM2^PSDUTL5 | 2(XREF 3K) |
| KAEM3^PSDUTL5 | 4(XREF 3K) |
| SAEM^PSDUTL5 | 3(XREF 3S) |
| SAEM1^PSDUTL5 | 85(XREF 1S) |
| SAEM2^PSDUTL5 | 2(XREF 3S) |
| SAEM3^PSDUTL5 | 4(XREF 3S) |
| Name | Line Occurrences (* Changed, ! Killed) |
|---|---|
| ^DD("DD" | 3OT+1 |
| ^DD(50 | ID4+1 |
| ^DD(58.8 | ID17+1 |
| ^PSD(58.8 - [#58.8] | ID17+1 |
| ^PSD(58.81 - [#58.81] | .01(XREF 1S), .01(XREF 1K), 4(XREF 1S), 4(XREF 1K), 7(XREF 1S), 7(XREF 1K), 8(XREF 1S), 8(XREF 1K), 16(XREF 1S), 16(XREF 1K) , 60(XREF 1S), 60(XREF 1K), 64(XREF 1S), 64(XREF 1K), 69(XREF 1S), 69(XREF 1K), 71(XREF 1S), 71(XREF 1K), 102(XREF 1S), 102(XREF 1K) , 103(XREF 1S), 103(XREF 1K), 104(XREF 1S), 104(XREF 1K) |
| ^PSDRUG - [#50] | ID4+1 |
| Name | Field # of Occurrence |
|---|---|
| ^(0 | ID4+1, ID17+1 |
| >> | Not killed explicitly |
| * | Changed |
| ! | Killed |
| ~ | Newed |
| Name | Field # of Occurrence |
|---|---|
| >> %DT | 3+1*, 14+1*, 19+1*, 21+1*, 22+1*, 24+1*, 29.5+1*, 29.6+1*, 29.7+1*, 31+1* , 34+1*, 37+1*, 48+1*, 55+1*, 62+1*, 64+1*, 67+1*, 82+1*, 102+1*, 104+1* |
| %I | ID4+1*!, ID17+1*! |
| >> C | ID4+1*, ID17+1* |
| >> DA | .01(XREF 1S), .01(XREF 1K), 4(XREF 1S), 4(XREF 1K), 7(XREF 1S), 7(XREF 1K), 8(XREF 1S), 8(XREF 1K), 16(XREF 1S), 16(XREF 1K) , 60(XREF 1S), 60(XREF 1K), 64(XREF 1S), 64(XREF 1K), 69(XREF 1S), 69(XREF 1K), 71(XREF 1S), 71(XREF 1K), 102(XREF 1S), 102(XREF 1K) , 103(XREF 1S), 103(XREF 1K), 104(XREF 1S), 104(XREF 1K) |
| DIC | ID4+1, ID17+1, 2+1!*, 4+1!*, 17+1!*, 18+1!*, 20+1!*, 23+1!*, 25+1!*, 25.5+1!* , 29+1!*, 30+1!*, 32+1!*, 33+1!*, 49+1!*, 56+1!*, 65+1!*, 66+1!*, 68+1!*, 69+1!* |
| DIC("S" | 2+1*, 2SCR+1*, 4+1*, 4SCR+1*, 17+1*, 17SCR+1*, 18+1*, 18SCR+1*, 20+1*, 20SCR+1* , 23+1*, 23SCR+1*, 25+1*, 25SCR+1*, 25.5+1*, 25.5SCR+1*, 29+1*, 29SCR+1*, 30+1*, 30SCR+1* , 32+1*, 32SCR+1*, 33+1*, 33SCR+1*, 49+1*, 49SCR+1*, 56+1*, 56SCR+1*, 65+1*, 65SCR+1* , 66+1*, 66SCR+1*, 68+1*, 68SCR+1*, 69+1*, 69SCR+1* |
| >> DIE | 2+1, 4+1, 17+1, 18+1, 20+1, 23+1, 25+1, 25.5+1, 29+1, 30+1 , 32+1, 33+1, 49+1, 56+1, 65+1, 66+1, 68+1, 69+1 |
| >> DINUM | .01+1* |
| >> PSDSITE | 2+1, 2SCR+1, 4+1, 4SCR+1 |
| U | ID4+1, ID17+1, 71(XREF 1S), 71(XREF 1K) |
| X | .01+1!, .01(XREF 1S), .01(XREF 1K), 2+1*!, 3+1*!, 4+1*!, 4(XREF 1S), 4(XREF 1K), 5+1!, 7(XREF 1S) , 7(XREF 1K), 8(XREF 1S), 8(XREF 1K), 9+1!, 12+1!, 13+1!, 14+1*!, 15+1!, 16+1!, 16(XREF 1S) , 16(XREF 1K), 17+1*!, 18+1*!, 19+1*!, 20+1*!, 21+1*!, 22+1*!, 23+1*!, 24+1*!, 25+1*! , 25.5+1*!, 27+1!, 29+1*!, 29.5+1*!, 29.6+1*!, 29.7+1*!, 29.8+1!, 30+1*!, 31+1*!, 32+1*! , 33+1*!, 34+1*!, 35+1!, 36+1!, 37+1*!, 38+1!, 39+1!, 40+1!, 41+1!, 48+1*! , 49+1*!, 50+1!, 51+1!, 53+1!, 54+1!, 55+1*!, 56+1*!, 57+1!, 58+1!, 59+1! , 60(XREF 1S), 60(XREF 1K), 61+1!, 62+1*!, 63+1!, 63.5+1!, 64+1*!, 64(XREF 1S), 64(XREF 1K), 65+1*! , 66+1*!, 67+1*!, 68+1*!, 69+1*!, 69(XREF 1S), 69(XREF 1K), 70+1!, 71+1!, 71(XREF 1S), 71(XREF 1K) , 72+1!, 75+1!, 76+1!, 77+1!, 79+1!, 82+1*!, 102+1*!, 102(XREF 1S), 102(XREF 1K), 103(XREF 1S) , 103(XREF 1K), 104+1*!, 104(XREF 1S), 104(XREF 1K), 106+1! |
| >> Y | ID4+1*, ID17+1*, 2+1, 3+1, 3OT+1, 4+1, 14+1, 17+1, 18+1, 19+1 , 20+1, 21+1, 22+1, 23+1, 24+1, 25+1, 25.5+1, 29+1, 29.5+1, 29.6+1 , 29.7+1, 30+1, 31+1, 32+1, 33+1, 34+1, 37+1, 48+1, 49+1, 55+1 , 56+1, 62+1, 64+1, 65+1, 66+1, 67+1, 68+1, 69+1, 82+1, 102+1 , 104+1 |
| >> Y(0 | 3OT+1* |