Files > PRESCRIPTION

name

PRESCRIPTION

number

52

location

^PSRX(

description

Contains all outpatient RX data used by the outpatient pharmacy package. As the above indicates, this is the hub of the outpatient system. It will easily be the largest pharmacy file in time and is pointed to very heavily. Deletion of an entry in this file must be handled VERY carefully and is not allowed if refills have been issued. Of particular interest is that essentially all the history pertaining to a particular Rx is contained in each Rx entry.

applicationGroups

PS;PSO

Fields

#	Name	Location	Type	Details	Index	Description
.01	rx #(+)	0;1	FREE TEXT		B	This is the prescription number.
1	issue date(+)	0;13	DATE-TIME		AC	Date when doctor wrote prescription.
2	patient(+)	0;2	POINTER	2		The patient receiving treatment.
3	patient status(+)	0;3	POINTER	53		This field is used to show the status of the patient at the time the medication was filled.
4	provider(+)	0;4	POINTER	200		Doctor who wrote the prescription.
5	clinic	0;5	POINTER	44		Clinic where treatment was given and prescription was written.
6	drug(+)	0;6	POINTER	50		The actual medication.
6.5	trade name	TN;1	FREE TEXT			Free Text that, if it exists, will replace the DRUG name on the RX label.
7	qty(+)	0;7	NUMERIC			This field is used to show the amount of medication that was dispensed.
8	days supply(+)	0;8	NUMERIC			Enter a whole number between 1 and 90. The maximum upper limit is 90, but may be lower based on the maximum specified for this patient status. This parameter is defined in the RX PATIENT STATUS file.
9	# of refills(+)	0;9	NUMERIC			The number of refills allowed per prescription.
10	sig(+)	SIG;1	FREE TEXT			Enter the medication instruction for this prescription. Entries should be no longer than 200 total characters, including spaces, with no one set of characters longer than 32 characters in length.
10.1	oerr sig	SIG;2	BOOLEAN	1:YES 0:NO		This field is used to determined if the original medication instructions was accepted. This field for all Rxs entered prior v7 will be null or no. This field is uneditable.
10.2	sig1	SIG1;0	MULTIPLE	52.04
10.3	order converted	0;19	SET OF CODES	1:ORDER CONVERTED 2:EXPIRATION TO CPRS		This field is used to indicate V7 order conversion complete to OERR. It's also used to indicate the updating of CPRS on expiration of the order.
10.6	copies(+)	0;18	NUMERIC			The number of copies made of the label for the prescription.
11	mail/window(+)	0;11	SET OF CODES	M:MAIL W:WINDOW		Indicates if the medication will be picked up or mailed to the patient.
12	remarks	3;7	FREE TEXT			Any additional comments.
14	administered in clinic	0;15	BOOLEAN	1:YES		This indicates if the medication was administered in a clinic instead of being dispensed to the patient.
16	entered by(+)	0;16	POINTER	200		This field will show who requested the rx.
17	unit price of drug(+)	0;17	NUMERIC			Price per dispense unit.
20	division(+)	2;9	POINTER	59		Tells which Outpatient Pharmacy Division filled the prescription.
21	login date(+)	2;1	DATE-TIME			The date the prescription was entered.
22	fill date	2;2	DATE-TIME			The date the prescription was filled.
23	pharmacist(+)	2;3	POINTER	200		This field is used to identify the pharmacist that filled the medication request.
24	lot #	2;4	FREE TEXT			The vendor code for this product. It is required to be on the label if the medication is sent to a nursing home.
25	dispensed date(+)	2;5	DATE-TIME			This field will be used to show the actual date the medication was dispensed.
26	expiration date	2;6	DATE-TIME		AG	The date the medication expires. This is required to be put on the labels of medication sent to a nursing home.
26.1	cancel date	3;5	DATE-TIME			This date is used to indicate when the medication was cancelled.
27	ndc	2;7	FREE TEXT			This field is used for the National Drug Code.
28	manufacturer	2;8	FREE TEXT			This field is used to enter the manufacturer of the drug issued.
29	drug expiration date	2;11	DATE-TIME			This date is used to show the expiration date of the medication. The date reflects the manufacturer's expiration date, not the date the Rx can no longer be filled.
30	generic provider	2;12	FREE TEXT			This field is used to to show a generic provider. A generic provider is a provider of care to the patient outside of the VA.
31	released date/time	2;13	DATE-TIME			This field is used to show the actual date and time the medication was released for inventory purposes and copay billing if applicable.
32	label date/time	L;0	MULTIPLE	52.032		This sub-file is used to indicate when labels are printed for this prescription.
32.1	returned to stock	2;15	DATE-TIME			This field is used to show when and if the medication was returned to stock because the patient did not pick up the meds or it was not mailed.
32.2	reprint	2;14	SET OF CODES	1:REPRINTED		This field is used to determined if the original fill was reprinted after being returned to stock. If fill was returned to stock and reprinted this fill will be re-released.
32.3	bingo wait time	2;16	NUMERIC			This field reflects, in minutes, the total wait time for bingo board purposes.
33	severity	DRI;1	FREE TEXT			This field is used to store the significant drug interactions encountered by technicians during new/renew order entry. The data will be stored in the form of a string, i.e., 23,43,201. Each number will represent the drug/drug interaction found in file #56. Data is not added directly by FileMan.
34	affected medication	DRI;2	FREE TEXT			This field is used to store the active medication pointer values that is considered to be drug interactions.
34.1	drug allergy indication	3;6	BOOLEAN	1:YES		This field is used to indicate if a drug allergy event occured.
34.11	drug allergy ingredients	DAI;0	MULTIPLE	52.03		This sub-file is used to store drug ingredients of a possible drug allergy and/or an adverse reaction to the medication dispensed in a Rx.
35	method of pick-up	MP;1	FREE TEXT			Enter any special instructions that should appear on mailing address portion of the label, specifing where, or when the RX(s) should be picked up.
36	archived	ARC;1	SET OF CODES	1:ARCHIVED		This field is used to indicate if the Rx has been archived. Once the Rx is marked to be archived and then actually saved to the archived device should this field be populated. This will later be used to determine if the Rx can be purged.
37	medication routes	MEDR;0	MULTIPLE	52.037		This subfile contains possible medication routes from OERR, from the Medication Instructions (SIG) or both.
37.1	schedules	SCH;0	MULTIPLE	52.038		This sub-file contains possible schedules from OERR, Medication Instructions or both.
38	finishing person	OR1;5	POINTER	200		This field is used to indicate the person who finished the order in Pharmacy.
38.1	filling person	OR1;6	POINTER	200		The name of the pharmacist who scanned the barcode before filling the medication request.
38.2	checking pharmacist	OR1;7	POINTER	200		The name of the pharmacist that checked the medication request.
38.3	finish date/time	OR1;8	DATE-TIME		AFDT	Date/time prescription is finished.
39	provider comments	PRC;0	WORD-PROCESSING			This field stores any provider comments that are passed to Pharmacy from CPRS.
39.1	pharmacy instructions	PI;0	WORD-PROCESSING			This field contains Pharmacy Instructions passed to Pharmacy from CPRS.
39.2	pharmacy orderable item	OR1;1	POINTER	50.7		This is the Pharmacy Orderable Item associated with the drug. This data should not be entered by using File Manager. If the Rx does not have a Pharmacy Orderable Item entered check the drug for the RX. If the drug is missing an orderable item match the drug not the Rx. Only matching the Rx will cause problems when renewing the Rx.
39.3	placer order #	OR1;2	NUMERIC		APL	This is the CPRS entry number for this order.
39.4	previous order #	OR1;3	POINTER	52	AO	This field is used to indicate rx number renewed from
39.5	forward order #	OR1;4	POINTER	52	AQ	This field is used to stored the pointer to the rx that was renewed.
40	activity log	A;0	MULTIPLE	52.3		Activity Log.
41	was the patient counseled	PC;1	BOOLEAN	1:YES 0:NO		This field indicates whether or not the patient received counseling about the prescription.
42	was counseling understood	PC;2	BOOLEAN	1:YES 0:NO		This field indicates whether or not the patient understood the counseling on the prescription, if the patient was counseled.
45.1	titration dose rx	TIT;1	POINTER	52		This is the Titration Dose Rx from which the corresponding Maintenance Dose Rx originated.
45.2	maintenance dose rx	TIT;2	POINTER	52		This is the Maintenance Dose Rx that was created from the corresponding Titration Dose Rx.
45.3	titration rx flag	TIT;3	BOOLEAN	1:YES		This flag indicates whether the prescription is being dispensed as a Titration Dose. It is intended to identify a Titration Dose Rx without a corresponding Maintenance Dose Rx.
52	refill	1;0	MULTIPLE	52.1		This is the date the prescription is refilled.
52.25	reject info	REJ;0	MULTIPLE	52.25
60	partial date	P;0	MULTIPLE	52.2		This sub-file is used to store data on partial prescriptions filled.
70	return to stock log	RTS;0	MULTIPLE	52.07		This sub-file contains a record for each fill returned to stock for the prescription.
81	daw code	EPH;1	FREE TEXT			Dispensed As Written code. This information is used for electronic claim transmission to third party payers (insurance companies).
82	re-transmit flag	EPH;2	BOOLEAN	1:YES		This field is used to indicate that a claim should be electronically re-transmitted to the 3rd party insurance. It will be primarily used by CMOP and local mail prescriptions.
83	date ndc validated	EPH;3	DATE-TIME			This field contains the date and time that the NDC was validated prior to release of the prescription fill.
84	ndc validated by	EPH;4	POINTER	200		This field will contain the user ID of the person who validated the NDC prior to release of the prescription fill.
85	billing eligibility indicator	EPH;5	SET OF CODES	T:TRICARE V:VETERAN C:CHAMPVA		This field is set when a prescription is third party insurance billable and will contain T for TRICARE, V for VETERAN or C for CHAMPVA.
86	epharmacy suspense hold date	EPH;6	DATE-TIME			This field is defined when a host reject error is received as a result of an ePharmacy claims submission. The prescription fill will be held on suspense until the next day.
99	hold reason(+)	H;1	SET OF CODES	1:INSUFFICIENT QTY IN STOCK 2:DRUG-DRUG INTERACTION 4:PROVIDER TO BE CONTACTED 6:ADVERSE DRUG REACTION 7:BAD ADDRESS 8:PER PATIENT REQUEST 9:CONSULT/PRIOR APPROVAL NEEDED 98:OTHER/TECH (NON-CLINICAL) 99:OTHER/RPH (CLINICAL)	AH	This field tells why the prescription was put on hold.
99.1	hold comments(+)	H;2	FREE TEXT			This field is used to enter brief comments on why the medication was placed on 'Hold' status.
99.2	hold date(+)	H;3	DATE-TIME			This field is used to indicate the date that a prescription was placed on hold.
100	status(+)	STA;1	SET OF CODES	0:ACTIVE 1:NON-VERIFIED 2:REFILL 3:HOLD 4:DRUG INTERACTIONS 5:SUSPENDED 10:DONE 11:EXPIRED 12:DISCONTINUED 13:DELETED 14:DISCONTINUED BY PROVIDER 15:DISCONTINUED (EDIT) 16:PROVIDER HOLD		This field represents the current status of the prescription.
100.1	discontinue type	7;1	SET OF CODES	1:HOSPITAL ADMISSION 2:EDITED BY PROVIDER		This field is used to distinguish what type of external discontinue action occurred.
101	last dispensed date	3;1	DATE-TIME			This field contains the last fill date.
102	next possible fill	3;2	DATE-TIME			This field contains the next possible fill date.
102.1	prior fill date	3;4	DATE-TIME			This field is used to indicate the last date the prescription was filled. The dates in this field will be the date of the last renew from a previous rx, and any subsequent fills.
102.2	pending next possible filldate	3;8	DATE-TIME			This field is to contain the next possible filldate if the Rx was discontinued prior to the original label printing. If the Rx is reinstated this date will be restored to field 102 (next possbile filldate).
103	new drug	DRG;1	FREE TEXT			This field is used to enter a new drug.
104	verifying pharmacist	2;10	POINTER	200		This field is used to show the pharmacist that verified the prescription
105	copay transaction type	IB;1	POINTER	350.1		This field contains the internal entry number of the pointer to the IB Action Type file (#350.1).
106	ib number	IB;2	POINTER	350		This field contains the internal entry number of the pointer to the Integrated Billing Action file (#350).
106.5	copay type audit	IB;3	FREE TEXT			This field serves as an audit of the original copay status. It is not changed or reset if the orignal status is changed.
106.6	copay exceeding cap	IB;4	POINTER	354.71		This field contains the internal entry number of the pointer to the IB COPAY TRANSACTIONS file (#354.71). There will only be data in this field if this Rx's copay exceeded the annual copay cap.
107	copay activity log	COPAY;0	MULTIPLE	52.0107
108	deletion comments(+)	D;1	FREE TEXT			This field is used to enter comments on why a prescription was marked as deleted.
109	cosigning physician	3;3	POINTER	200		This field identifies the cosigning physician for prescriptions written by a provider for whom a counter signature is required, for example a nurse practitioner.
110	type of rx	TYPE;1	NUMERIC			This field is used to indicate if the rx dispensed is a partial or normal process rx. If partial medication was dispensed this will be equal to the entry number else the field will be equal to zero.
111	poe rx	POE;1	BOOLEAN	1:YES		This field shall be set whenever a new/renew prescription is entered after the Pharmacy Ordering Enhancements software for Outpatient Pharmacy has been installed. This field will set to 1 for all pre-POE Rxs during the install of PSO*7*46.
112	original qty	3;9	NUMERIC			This field will hold the quantity that was filled for the original fill of the Rx.
113	medication instructions	6;0	MULTIPLE	52.0113		This sub-file will contain the dispense units per dosage ordered, dosage ordered, units, noun, duration and conjunction fields.
114	patient instructions	INS;1	FREE TEXT			The text in this field shall be used for the Patient Instructions in the Outpatient Pharmacy package when entering orders, if the Dispense Drug selected is matched to a Pharmacy Orderable Item with patient instructions.
114.1	other patient instructions	INSS;1	FREE TEXT			This field will be used to store the Other Language Patient Instructions when added.
115	expanded patient instructions	INS1;0	WORD-PROCESSING
116	service connected	IBQ;1	BOOLEAN	0:NO 1:YES		During Outpatient Pharmacy order entry, a pharmacist may be asked if the medication being prescribed is for a service connected condition. This field will store the pharmacist's response to this question. The value in this field will be used to evaluate whether or not a copay should be applied to the prescription. This value will also be used as a default should this question be raised again during the life of the prescription when a prescription fill is being released, or as the default for the question upon renewal of the prescription through CPRS or Outpatient Pharmacy.
117	military sexual trauma	IBQ;2	BOOLEAN	0:NO 1:YES		During Outpatient Pharmacy order entry, if a veteran has been identified as having been treated for Military Sexual Trauma, the pharmacist may be asked to identify whether or not the medication prescribed is being used to treat a condition related to Military Sexual Trauma. This field will store the pharmacist's response to this question. The value in this field will be used to evaluate whether or not a copay should be applied to the prescription. This value will also be used as a default should this question be raised again during the life of the prescription when a prescription fill is being released, or as the default for the question upon renewal of the prescription through CPRS or Outpatient Pharmacy.
118	agent orange exposure	IBQ;3	BOOLEAN	0:NO 1:YES		During Outpatient Pharmacy order entry, if a veteran has been identified as having been exposed to Agent Orange during Vietnam service, the pharmacist may be asked to identify whether or not the medication prescribed is being used to treat a condition due to this exposure. This field will store the pharmacist's response to this question. The value in this field will be used to evaluate whether or not a copay should be applied to the prescription. This value will also be used as a default should this question be raised again during the life of the prescription when a prescription fill is being released, or as the default for the question upon renewal of the prescription through CPRS or Outpatient Pharmacy.
119	ionizing radiation exposure	IBQ;4	BOOLEAN	0:NO 1:YES		During Outpatient Pharmacy order entry, if a veteran has been identified as having been exposed to ionizing radiation during military service, the pharmacist may be asked to identify whether or not the medication prescribed is being used to treat a condition due to this exposure. This field will store the pharmacist's response to this question. The value in this field will be used to evaluate whether or not a copay should be applied to the prescription. This value will also be used as a default should this question be raised again during the life of the prescription when a prescription fill is being released, or as the default for the question upon renewal of the prescription through CPRS or Outpatient Pharmacy.
120	southwest asia conditions	IBQ;5	BOOLEAN	0:NO 1:YES		During Outpatient Pharmacy order entry, if a veteran has been identified as having been exposed to Southwest Asia Conditions (formerly referred to as Environmental Contaminants), the pharmacist may be asked to identify whether or not the medication prescribed is being used to treat a condition due to this exposure. This field will store the pharmacist's response to this question. The value in this field will be used to evaluate whether or not a copay should be applied to the prescription. This value will also be used as a default should this question be raised again during the life of the prescription when a prescription fill is being released, or as the default for the question upon renewal of the prescription through CPRS or Outpatient Pharmacy.
120.01	ddstatus	DDSTA;1	FREE TEXT			This field will hold the status of the prescription at the time a date of death was entered.
120.02	date of death history	DDSTA;2	FREE TEXT			This field will be used to take a snapshot of the Rx at the time it was discontinued due to a date of death being entered for the patient. This data will be used to restore the Rx to the state before the date of death was entered.
121	head and/or neck cancer	IBQ;6	BOOLEAN	0:NO 1:YES		During Outpatient Pharmacy order entry, if a veteran has been identified as having been treated for Head and/or Neck Cancer due to nose or throat radium treatments while in the military, the pharmacist may be asked to identify whether or not the medication prescribed is being used to treat this condition. This field will store the pharmacist's response to this question. The value in this field will be used to evaluate whether or not a copay should be applied to the prescription. This value will also be used as a default should this question be raised again during the life of the prescription when a prescription fill is being released, or as the default for the question upon renewal of the prescription through CPRS or Outpatient Pharmacy.
122	combat veteran	IBQ;7	BOOLEAN	0:NO 1:YES		During Outpatient Pharmacy order entry, a pharmacist may be asked if the medication being prescribed is for a condition related to Combat Services while in the military. This field will store the pharmacist's response to this question. The value in this field will be used to evaluate whether or not a copay should be applied to the prescription. This value will also be used as a default should this question be raised again during the life of the prescription.
122.01	proj 112/shad	IBQ;8	BOOLEAN	0:NO 1:YES		During Outpatient Pharmacy order entry, a pharmacist may be asked if the medication being prescribed is for a condition related to PROJ 112/SHAD while in the military. This field will store the pharmacist's response to this question. The value in this field will be used to evaluate whether or not a copay should be applied to the prescription. This value will also be used as a default should this question be raised again during the life of the prescription.
123	external placer order number	EXT;1	FREE TEXT			This field represents the external system order number of this order. This field will only be populated if this order was originally received from an external system into Vista.
124	external application	EXT;2	FREE TEXT			This field represents the name of the external system from where the external order was received.
125	pfss account reference	PFS;1	POINTER	375		This is a reference number to an external medical billing system Account Number for the purposes of uniquely identifying prescription charges for 1st or 3rd party billing.
126	pfss charge id	PFS;2	NUMERIC			This is another unique identifier required when prescription charge messages are passed to the external billing system.
127	last dispensed date holder	3;10	DATE-TIME			This field is a holder for the last dispensed date.
201	tpb rx	TPB;1	BOOLEAN	1:YES 0:NO		If this field is set to 'Yes', that indicates that this prescription has been created as part of the Transitional Pharmacy Benefit project. This field is controlled by the software.
301	clozapine dosage (mg/day)	SAND;1	NUMERIC			This is the total daily dosage of clozapine if this prescription is for the drug clozapine. This is used only for clozapine.
302	wbc results	SAND;2	NUMERIC			This is the results of the WBC test which was used to authorize the clozapine prescription. This will exist only for clozapine prescriptions.
303	date of wbc test	SAND;3	DATE-TIME			This is the date of the WBC test which authorized the clozapine prescription. It is used only for clozapine prescriptions.
304	anc results	SAND;4	NUMERIC			This is the results of the ANC test that was used to authorize the clozapine prescription. This will exist only for clozapine prescriptions.
310	signature status	PKI;1	BOOLEAN	1:YES 0:NO		Digital Signature status indicator.
311	backdoor signature status	PKI;2	BOOLEAN	1:YES 0:NO		This field indicates whether a controlled substance order, schedule (I-V), was not digitally signed but entered via backdoor.
400	cmop event	4;0	MULTIPLE	52.01
401	lot/exp	5;0	MULTIPLE	52.0401
725	national data utility cleanup	NDUC;0	MULTIPLE	52.0725		This NATIONAL DATA UTILITY CLEANUP multiple is defined to store modifications to a prescription for Dosage and SIG as a result of a background clean-up utility. It can be used by other projects in the future. For its first use, Outpatient Pharmacy patch PSO*7*433 and Computerized Patient Record System (CPRS) Patch OR*3*378 addresses reported problems where the Drug Name and/or the date in VA FileMan format can mistakenly appear in the Dosage and Sig fields of an entry in PRESCRIPTION file (#52). The NATIONAL DATA UTILITY CLEANUP fields will only be defined when corrections to the Dosage and Sig fields are completed or attempted. For those prescriptions where a correction was unsuccessful, an error or comment will be stored in COMMENTS field (#5).
52311	icd diagnosis	ICD;0	MULTIPLE	52.052311
521011	hospital coverage		COMPUTED			This field is used to compute hospital coverage from MAS.