Files > BCMA EXTRACT

name

BCMA EXTRACT

number

727.833

location

^ECX(727.833,

description

This file contains data elements as specified by the Decision Support System (DSS) Program Office for the BCMA (Bar Code Medication Administration) extract from existing DHCP files. Entries into this file are made by extracting data from several files. The BCM MEDICATION LOG (#53.79) file is a major source of fields within this file. Once approved by the DSS site manager, entries in this file are loaded into an electronic mail message and sent to the commercial vendor. This file is intended to be used for validation purposes only. Entries should be made only by the extract load routine. Since validation techniques will be determined by the local site, it is intended that the site add whatever cross references deemed necessary. However, this file contains one nationally determined cross reference, the "AC" cross reference on the EXTRACT NUMBER (#2) field. This cross reference is used by the DSS Extracts software package as an essential feature for managing and purging data in this file and should not be modified. This file should NOT be modified directly using VA FileMan.

Fields

#	Name	Location	Type	Details	Index	Description
.01	sequence number(+)	0;1	NUMERIC		B	The record number for this extract entry.
1	year month	0;2	FREE TEXT			A six character string representing the year and the month for which this extract was performed.
2	extract number	0;3	POINTER	727	AC	The corresponding entry in the DSS EXTRACT LOG (#727) file for this extract.
3	facility	0;4	FREE TEXT			This is the facility/division where the extract was performed.
4	patient no. - dfn	0;5	POINTER	2		An identifying number for the patient at the local site.
5	ssn	0;6	FREE TEXT			This is the patient's social security number.
6	name	0;7	FREE TEXT			The first four characters of the patient's last name.
7	in out patient indicator	0;8	SET OF CODES	I:INPATIENT O:OUTPATIENT		Indicates whether the patient was an inpatient or an outpatient for this extract entry.
8	day	0;9	FREE TEXT			Date on which the patient was administered medication.
9	date of birth	0;10	FREE TEXT			The patient's date of birth.
10	sex	0;11	SET OF CODES	M:MALE F:FEMALE		Patient's gender
11	state	0;12	FREE TEXT			The state in which the patient resides.
12	county	0;13	FREE TEXT			This is the County in which the Patient resides.
13	zip +4	0;14	FREE TEXT			The ZIP code for where the patient resides. The 5-character ZIP code is provided if ZIP+4 is not available.
14	country code	0;15	FREE TEXT			This is the code for the country associated with the address.
15	ward	0;16	POINTER	44		Current ward where the patient is located.
16	treating specialty	0;17	FREE TEXT			The PTF CODE of the treating specialty associated with this extract record.
17	provider	0;18	FREE TEXT			The provider assigned to this patient through the PCMM module.
18	provider person class	0;19	FREE TEXT			The VA Code of the Person Class of the Provider associated with this record.
19	provider npi	0;20	FREE TEXT			A standard unique life-long identifier of the individuals providing health care services.
20	primary care provider	0;21	FREE TEXT			The primary care provider assigned to this patient through the PCMM module.
21	primary care provider pc	0;22	FREE TEXT			The VA Code of the Person Class of the Primary Care Provider associated with this record.
22	primary care provider npi	0;23	FREE TEXT			A standard unique life-long identifier of the primary care provider.
23	primary care team	0;24	POINTER	404.51		The primary care team assigned to this patient.
24	ordering stop code	0;25	FREE TEXT			The field contains the stop code with the order.
25	place order number	1;1	POINTER	53.79		This is the order number of the Patient's Barcode Medication Administration record.
26	order reference number	1;2	FREE TEXT			Contains the IEN to the actual order in the PHARMACY PATIENT (#55) followed by a U for Unit Dose or V for IV.
27	route	1;3	POINTER	51.2		This is the route of administration for Unit Dose or IV medication for a patient.
28	time	1;4	FREE TEXT			This field contains the actual time the medication was administered.
29	component code	1;5	VARIABLE-POINTER			The COMPONENT CODE contains either the dispensed drug, IV additive or IV solution that was administered for this patient.
30	component dose ordered	1;6	FREE TEXT			COMPONENT DOSE ORDERED contains either the dispensed drug, IV additive, or IV solution dose ordered, to which, this medication was administered for this patient.
31	component dose given	1;7	FREE TEXT			The COMPONENT DOSE GIVEN contains either the dispensed drug, IV additive, or IV solutions dose given, to which, this medication was administered for this patient.
32	component units	1;8	FREE TEXT			The Component Units contains either the dispensed drug, IV additive, or IV solutions unit of administration, to which this medication was administered for this patient.
33	component type	1;9	SET OF CODES	D:Dispensed Drug A:Additives S:Solutions		The Component Type is determined by the value destination of the Component Code.
34	action status	1;10	SET OF CODES	G:GIVEN H:HELD R:REFUSED N:NOT GIVEN RM:REMOVED I:INFUSING S:STOPPED C:COMPLETED M:MISSING DOSE		This is the status of the medication administration.
35	administration medication	1;11	POINTER	50.7		Administration Medication is the medication entered for the order.
36	scheduled administration date	1;12	FREE TEXT			If a continuous order this field will contain the actual administration date the medication was ordered for.
37	scheduled administration time	2;1	FREE TEXT			If a continuous order this field will contain the actual administration time the medication was ordered for.
38	order schedule	2;2	SET OF CODES	C:CONTINUOUS P:PRN O:ONE-TIME OC:ON-CALL		This is the schedule type of the order.
39	iv unique id	2;3	FREE TEXT			This is the unique ID number of an IV bag, which is generated from Inpatient Medications.
40	infusion rate	2;4	FREE TEXT			This is the infusion rate for an IV bag, which is passed by Inpatient Medications.
41	production division code	2;5	FREE TEXT			This is the facility of the ward where the patient received medication.
42	drug ien	2;6	POINTER	50.68		This is the drug administered to the patient.
43	ndc	2;7	FREE TEXT			This is the National Drug Code for the drug/supply item in this order.
44	dea, special hdlg	2;8	SET OF CODES	I:Investigational 1:SCHEDULE 1 ITEM 2:SCHEDULE 2 ITEM 3:SCHEDULE 3 ITEM 4:SCHEDULE 4 ITEM 5:SCHEDULE 5 ITEM		Indicates if the drug in this record is Investigational, or Schedule 1-5.
45	va drug classification	2;9	FREE TEXT			This is the VA Drug Classification for the item in this order.
46	master patient index	2;10	FREE TEXT			Unique national VA patient identifier.
47	dom, prrtp & saartp indicator	2;11	SET OF CODES	P:GEN. PRRTP T:PTSD PRRTP S:DOM. PRRTP H:HOMELESS CWT/TR A:SA CWT/TR D:DOMICILIARY B:PTSD CWT/TR C:GEN. CWT/TR		Indicates if the patient is admitted to either a RRTP, PRRTP, or SARRTP at the time care is provided.
48	observation patient indicator	2;12	SET OF CODES	NO:NO YES:YES		Indicates if a patient is considered to be an observation patient.
49	encounter number	2;13	FREE TEXT			The unique number assigned for DSS.
50	means test	2;14	FREE TEXT			The current means test category for this patient.
51	eligibility	2;15	FREE TEXT			A two or three digit numeric code indicating the Patient's Primary Eligibility.
52	enrollment location	2;16	FREE TEXT			The facility that the patient chooses to designate as his preferred location for care.
53	enrollment category	2;17	SET OF CODES	E:ENROLLED N:NOT ENROLLED P:IN PROCESS		Patient's enrollment category.
54	enrollment status	2;18	POINTER	27.15		Patient's enrollment status.
55	enrollment priority	2;19	FREE TEXT			This field contains the enrollment priority group and the enrollment priority subgroup.
56	user enrollee	2;20	SET OF CODES	U:USER ENROLLEE		Indicates whether a Veteran has User Enrollee status for the current or future fiscal year.
57	ethnicity	2;21	FREE TEXT			The patient's PTF Ethnicity code.
58	race 1	2;22	FREE TEXT			Self-reported by patient as recorded in VistA patient file.
59	veteran	2;23	SET OF CODES	Y:VETERAN N:NOT VETERAN		Patient's Veteran status.
60	period of service	2;24	FREE TEXT			The period of service, which best classifies this patient based on eligibility code.
61	pow status	2;25	SET OF CODES	Y:YES N:NO U:UNKNOWN		Indicates if patient was confined as a Prisoner of War.
62	pow location	2;26	POINTER	22		This is the location/period where the patient was a POW.
63	radiation status	2;27	SET OF CODES	Y:YES N:NO U:UNKNOWN		Indicates if patient claims exposure to ionizing radiation.
64	agent orange status	2;28	SET OF CODES	Y:YES N:NO U:UNKNOWN		Indicates whether patient was exposed to Agent Orange.
65	agent orange location	2;29	SET OF CODES	K:KOREAN DMZ V:VIETNAM O:OTHER		Indicates the location where the patient was exposed to Agent Orange.
66	purple heart indicator	2;30	BOOLEAN	Y:YES N:NO		This field Indicates whether or not a patient is a Purple Heart recipient.
67	mst status	2;31	SET OF CODES	Y:Yes, Screened reports MST N:No, Screened does not report MST U:Unknown, not screened D:Screened Declines to answer		Indicates the Military Sexual Trauma (MST) status of a patient on the date of the encounter.
68	cnh status	2;32	BOOLEAN	Y:YES N:NO		This field is used to indicate whether a patient is currently in a contract nursing home.
69	head & neck cancer indicator	2;33	BOOLEAN	Y:YES N:NO		Identifies whether patient's diagnosis was for Head and/or Neck Cancer.
70	shad status	2;34	BOOLEAN	Y:YES N:NO		Indicates whether patient meets requirements for Shipboard Hazard And Defense (SHAD).
71	patient type	3;1	FREE TEXT			PATIENT TYPE refers to the various types of patient which might be seen at a VA facility.
72	cv status eligibility	3;2	SET OF CODES	Y:YES E:ELIGIBILITY EXPIRED		This field indicates whether or not a patient can be considered a Combat Veteran (CV) at the time of treatment.
73	cv eligibility end date	3;3	FREE TEXT			This field is the patient's Combat Veteran (CV) eligibility end date.
74	encounter cv	3;4	BOOLEAN	Y:YES		This Field indicates if the patient is a Combat Veteran (CV) based on the treatment date and the end date of combat service.
75	national patient record flag	3;5	BOOLEAN	Y:YES		This field will indicate if the Patient has any type of a National Flag indicator.
76	eri	3;6	SET OF CODES	K:HURRICANE KATRINA		Identifies patients from impacted zip code areas designated by the Federal Emergency Management Agency (FEMA).
77	sw asia conditions	3;7	SET OF CODES	Y:YES N:NO U:UNKNOWN		This field is used to indicate if this visit represents treatment of a VA patient claiming exposure to Southwest Asia Conditions. The South West Asia Theater of operations is defined as: Iraq, Kuwait, Saudi Arabia, the neutral zone between Iraq and Saudi Arabia, Bahrain, Qatar, the United Arab Emirates, Oman, the Gulf of Aden, the Gulf of Oman, the Persian Gulf, the Arabian Sea, the Red Sea and the airspace above these locations.
78	oef/oif	3;8	FREE TEXT			The Military Operation(s) in which the patient was in combat. This field is a length of nine characters and reflects the OEF or OIF where this patient was in combat.
79	oef/oif return date	3;9	FREE TEXT			The date the patient left the OEF/OIF area, if known. Otherwise, it is the end date of military pay for this OEF/OIF deployment. This date field has a format equal to YYYYMMDD. In cases of multiple OEF/OIF tours, this field contains only most recent return date.
80	patcat	3;10	SET OF CODES	AD:Active Duty ADD:Active Duty Dependent FNRS:Former Non-Remarried Spouse RET:Retired RETD:Retiree Dependent RES:Reservist REC:Recruit TDRL:Temporary Disability TFL:TRICARE for Life		This is the Patient's category which will be used for FHCC (Federal Health Care Center) Reconciliation. DSS must capture and report DoD patients so that the FHCC reconciliation process can function as designed. "Reconciliation" is the process used within the new FHCC to determine which patients DoD pays for and which VA pays for.
81	encounter sc	3;11	BOOLEAN	Y:YES N:NO		Indicates if treatment provided during this patient encounter is Service Connected.
82	iv additive cost	3;12	NUMERIC			VA pharmacy supply cost, in dollars, of the IV Additive dispensed.
83	iv solution cost	3;13	NUMERIC			VA pharmacy supply cost, in dollars, of the IV Solution dispensed.
84	drug cost	3;14	NUMERIC			VA pharmacy supply cost, in dollars, of the Drug dispensed.
85	camp lejeune status	3;15	BOOLEAN	Y:YES N:NO		Indicates if patient was exposed to contaminated water while stationed at Camp Lejeune, NC between January 1, 1957 and December 31, 1987.
86	encounter camp lejeune	3;16	BOOLEAN	Y:YES N:NO		Indicates if episode of care is related to exposure to contaminated water while stationed at Camp Lejeune, NC between January 1, 1957 and December 31, 1987.
87	combat veteran indicator	3;17	BOOLEAN	Y:YES N:NO		Identifies if the patient served in a combat zone.
88	combat veteran location	3;18	FREE TEXT			Identifies the war in which the combat service was incurred.