Files > IV DETAIL EXTRACT

name
IV DETAIL EXTRACT
number
727.819
location
^ECX(727.819,
description
This file contains data elements as specified by the Decision Support System (DSS) Program Office for the Pharmacy IV extract from existing DHCP files. Entries into this file are made by extracting data from several files. 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 field (#2). 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
#NameLocationTypeDetailsIndexDescription
.01sequence number(+)0;1NUMERICThe record number for this extract entry.
1year month0;2FREE TEXTA six character string representing the year and the month for which this extract was performed.
2extract number0;3POINTER727ACThe corresponding entry in the DSS EXTRACT LOG file (#727) for this extract.
3facility0;4POINTER40.8This is the medical center division where the IV room is located.
4patient no. - dfn0;5POINTER2An identifying number for the patient at the local site.
5ssn0;6FREE TEXTThe patient's social security number.
6name0;7FREE TEXTThe first four characters of the patient's last name.
7in out patient indicator0;8SET OF CODESI:INPATIENT
O:OUTPATIENT
Indicates whether the patient was an inpatient or an outpatient for this extract.
8day0;9FREE TEXTAn 8-character numeric string that represents the date on which the IV medication was dispensed.
9va drug classification0;10FREE TEXTThe VA Drug Classification for the item in this order.
10quantity0;11NUMERICDrug quantity dispensed in the unit of issue for that drug. Unit of issue may vary from product to product and site to site.
11ward0;12POINTER44Current ward where the patient is located.
13cost0;13NUMERICVA pharmacy supply cost of drug dispensed.
14movement file #0;14POINTER405Current patient movement record associated with this extract record.
15treating specialty0;15FREE TEXTThe PTF CODE of the treating specialty associated with this extract record.
16ndc0;16FREE TEXTThis is the National Drug Code for the drug/supply item in this order.
17dea, special hdlg0;17SET OF CODESI: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.
18pharmacy iv dispensing fee0;18SET OF CODESA:ADMIXTURE
P:PIGGYBACK
H:HYPERAL
S:SYRINGE
C:CHEMOTHERAPY
The type of IV dispensed.
19new feeder key0;19FREE TEXTCode that uniquely identifies a DSS drug/supply product.
20total doses per day0;20FREE TEXTThe total doses per day including units.
21primary care team0;21FREE TEXTThe primary care team assigned to this patient.
22primary care provider0;22FREE TEXTThe primary care provider assigned to this patient through the PCMM module.
23ivp time0;23FREE TEXTThe time of day when the IV medication was dispensed.
24admission date0;24FREE TEXTThis 8-character numeric string represents the date on which the patient's admission occurred.
25admission time0;25FREE TEXTTime of day at which the patient admission occurred.
26dss identifier for encounter0;26FREE TEXTPrimary and secondary stop codes associated with the clinic, if IV dispensed to outpatient.
27master patient index1;1FREE TEXTUnique national VA patient identifier.
28dss product department1;2FREE TEXTThe nationally defined DSS Intermediate Department Number designated to the Pharmacy care product.
29placeholder1;3FREE TEXTCurrently NULL.
30pc provider person class1;4FREE TEXTThe VA Code of the Person Class of the Primary Care Provider as of the date of this extract record.
31associate pc provider1;5FREE TEXTThe associate primary care provider assigned to this patient through the PCMM module.
32assoc. pc prov. person class1;6FREE TEXTThe VA code of the Person Class of the Associate Primary Care Provider as of the date of this extract record.
33placeholder1;7FREE TEXTCurrently NULL.
34dom,prrtp and saartp indicator1;8SET OF CODESP:GEN. PRRTP
T:PTSD PRRTP
S:DOM. PRRTP
H:HOMELESS CWT/TR
A:SA CWT/TR
D:DOMICILIARY
B:PTSD CWT/TR
C:GEN. CET/TR
Indicates if the patient is admitted to either a RRTP, PRRTP, or SARRTP at the time care is provided.
35observation patient indicator1;9SET OF CODESNO:NO
YES:YES
Indicates if patient is considered to be an observation patient.
36encounter number1;10FREE TEXTThe unique number assigned for DSS.
37ordering provider1;11FREE TEXTThe provider who ordered the IV product.
38ordering stop code1;12FREE TEXTThis field contains the stop code associated with the order.
39ordering date1;13FREE TEXTDate the order was verified by Nurse.
40requesting physician1;14FREE TEXTFor future development; currently set to null.
41production division code1;15FREE TEXTIdentifies the division/facility where the work was performed.
42means test1;16SET OF CODESA:CATEGORY A
B:CATEGORY B
C:CATEGORY C
P:PENDING ADJUDICATION
R:REQUIRES MEANS TEST
N:MEANS TEST NOT REQUIRED
E:EXEMPT
I:INCOMPLETE
L:NO LONGER APPLICABLE
M:NON-EXEMPT
The current means test category for this patient.
43eligibility1;17FREE TEXTAppropriate eligibility code based on veteran or non-veteran status.
44date of birth1;18FREE TEXTPatient's date of birth.
45sex1;19SET OF CODESM:MALE
F:FEMALE
Patient's gender.
46state1;20FREE TEXTThe state in which the patient resides.
47county1;21FREE TEXTThe county in which the patient resides.
48zip+41;22FREE TEXTThe ZIP code for where the patient resides. The 5-character ZIP code is provided if ZIP+4 is not available.
49veteran1;23BOOLEANY:YES
N:NO
Patient's Veteran status.
50period of service1;24FREE TEXTThe period of service that best classifies the patient based on eligibility code.
51pow status1;25SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient was confined as a Prisoner of War.
52pow location1;26POINTER22If POW Status is indicated, then this is the POW confinement location/period. 1 WORLD WAR I 2 WORLD WAR II - EUROPE 3 WORLD WAR II - PACIFIC 4 KOREAN 5 VIETNAM 6 OTHER
53radiation status1;27SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient claims exposure to ionizing radiation.
54agent orange status1;28SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates whether patient was exposed to Agent Orange.
55agent orange location1;29FREE TEXTIndicates the location where the patient was exposed to Agent Orange.
56purple heart indicator1;30BOOLEANY:YES
N:NO
Indicates whether or not a patient is a Purple Heart recipient.
57mst status1;31SET OF CODESY:Yes, screened reports MST
N:Screened, does not report MST
D:Screened, declines to answer
U:Unknown, not screened
Indicates the Military Sexual Trauma (MST) status of a patient on the date of the encounter.
58enrollment location1;32FREE TEXTThe facility that the patient chooses to designate as his preferred location for care.
59enrollment category1;33FREE TEXTPatient's enrollment category.
60enrollment status1;34FREE TEXTPatient's enrollment status.
61shad status1;35SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates whether patient meets requirements for Shipboard Hazard and Defense (SHAD).
62cnh status1;36SET OF CODESYES:YES
NO:NO
This field is used to indicate whether a patient is currently in a contract nursing home.
63placeholder1;37FREE TEXTCurrently NULL.
64head & neck cancer indicator2;1BOOLEANY:YES
N:NO
Identifies whether patient has head and/or neck cancer.
65ethnicity2;2FREE TEXTThe patient's PTF Ethnicity code.
66race 12;3FREE TEXTSelf-reported by patient as recorded in VistA patient file.
67placeholder2;4POINTER50Currently NULL. This field is not currently used.
68placeholder2;5NUMERICCurrently NULL. This field is not currently used.
69placeholder2;6FREE TEXTCurrently NULL. This field is not currently used.
70placeholder2;7BOOLEANY:YES
N:NO
Currently NULL. This field is not currently used.
71ordering provider person class2;8FREE TEXTThe VA code of the Person Class of the Ordering Provider as of the date of this extract record.
72dss ip #2;9NUMERICThe nationally defined DSS Intermediate Product Number designated to the patient care product.
73enrollment priority2;10FREE TEXTThis field contains the enrollment priority group and the enrollment priority subgroup.
74user enrollee2;11SET OF CODESU:USER ENROLLED
Indicates whether a Veteran has User Enrollee status for the current or future fiscal year.
75patient type2;12SET OF CODESAC:ACTIVE DUTY
AL:ALLIED VETERAN
CO:COLLATERAL
EM:EMPLOYEE
IN:INELIGIBLE
MI:MILITARY RETIREE
NO:NON-VETERAN (OTHER)
NS:NSC VETERAN
SC:SC VETERAN
TR:TRICARE
Refers to the various types of patient which may be seen at a VA facility.
76cv status eligibility2;13SET OF CODESY:YES
E:ELIGIBILITY EXPIRED
Records if veteran served on active duty in a theater of combat operations during a period of war after the Persian Gulf War or in combat against a hostile force during a period of hostilities after November 11, 1998.
77cv eligibility end date2;14FREE TEXTRecords the Combat Veteran eligibility expiration date or veteran who served on active duty in a theater of combat operations during a period of war after the Persian Gulf War or in combat against a hostile force during a period of hostilities after November 11, 1998.
78encounter cv2;15BOOLEANY:YES
Records if a Veteran served on active duty in a theater of combat operations during a period of war after the Persian Gulf War or in combat against a hostile force during a period of hostilities after November 11, 1998.
79national patient record flag2;16BOOLEANY:YES
This field records whether the patient's record contains 1 or more active category 1 (National) Patient Record Flags.
80eri2;17FREE TEXTThis field identifies patients from impacted zip code areas designated by the Federal Emergency Management Agency (FEMA).
81sw asia conditions2;18SET OF CODESY: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.
82oef/oif2;19FREE TEXTThe Military Operation in which the patient was in combat during the specified time period. This field is a length of nine characters and reflects the OEF or OIF where this patient was in combat.
83oef/oif return date2;20FREE TEXTThe 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.
84associate pc provider npi2;21FREE TEXTA standard unique life-long identifier of the associate primary care provider. This field has a length of fifteen characters.
85ordering provider npi2;22FREE TEXTA standard unique life-long identifier of the provider who ordered the intravenous product. This field has a length of fifteen characters.
86primary care provider npi2;23FREE TEXTA standard unique life-long identifier of the primary care provider. This field has a length of fifteen characters.
87country code2;24FREE TEXTThis is the code for the country associated with the address.
88patcat2;25SET OF CODESAD: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.
89encounter sc2;26BOOLEANY:YES
N:NO
Indicates if treatment provided during this patient encounter is Service Connected.
90camp lejeune status2;27BOOLEANY: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.
91encounter camp lejeune2;28BOOLEANY: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.
92combat veteran indicator2;29BOOLEANY:YES
N:NO
Identifies if the patient served in a combat zone.
93combat veteran location2;30FREE TEXTIdentifies the war in which the combat service was incurred.

Not Referenced