Files > PRESCRIPTION EXTRACT

name
PRESCRIPTION EXTRACT
number
727.81
location
^ECX(727.81,
description
This file contains data elements as specified by the Decision Support System (DSS) Program Office for the Pharmacy Outpatient (Prescription) 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;4FREE TEXTThis is the facility/division where the extract was performed.
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 entry.
8day0;9FREE TEXTThis 8-character string represents the date on which the Prescription fill/refill was released.
9division0;10POINTER59The outpatient pharmacy site for this extract entry.
10provider0;11FREE TEXTThe provider who wrote the new, refill, or partial refill prescription for this patient.
11va drug classification0;12FREE TEXTThe VA Drug Classification for the drug/supply item in this prescription.
12mail0;13SET OF CODES1:MAIL
2:CMOP
Identifies if prescription was mailed.
13provider person class0;14FREE TEXTThe VA code associate with the active Person Class of the provider.
14new0;15FREE TEXTData will be 1 if this is a new prescription.
15shad status0;16SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates whether patient meets requirements for Shipboard Hazard and Defense (SHAD).
16quantity0;17NUMERICDrug quantity dispensed in the unit of issue for that drug. Unit of issue may vary from product to product and site to site.
17cost0;18NUMERICVA pharmacy supply cost of drug dispensed.
18encounter shad0;19BOOLEANY:YES
N:NO
Indicates if treatment provided during the patient's encounter is related to the Shipboard Hazard And Defense (SHAD) condition.
19movement file #0;20POINTER405Current patient movement record associated with this extract record.
20treating specialty0;21FREE TEXTThe treating specialty PTF CODE assigned to this patient when the prescription was issued, if the patient was an inpatient at that time.
21placeholder40;22FREE TEXTThis field marked as a placeholder for future use.
22unit of issue0;23FREE TEXTThis units in which this item was dispensed.
23date of birth0;24FREE TEXTPatient's date of birth.
24eligibility(+)0;25FREE TEXTAppropriate eligibility code based on veteran or non-veteran status.
25veteran0;26BOOLEANY:YES
N:NO
Patient's Veteran status.
26copay(+)0;27BOOLEAN1:YES
0:NO
This field indicates whether this prescription was billed for copay.
27feeder key(+)0;28FREE TEXTCode that uniquely identifies a DSS drug/supply product.
28dea, special hdlg0;29SET 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.
29days supply0;30NUMERICThe number of days covered by this prescription.
30primary care team0;31POINTER404.51The primary care team assigned to this patient in the PCMM module.
31primary care provider0;32FREE TEXTThe primary care provider assigned to this patient through the PCMM module.
32time0;33FREE TEXTTime of day when the prescription fill/refill was released.
33race0;34FREE TEXTRace ABBREVIATION for this patient.
34master patient index1;1FREE TEXTUnique national VA patient identifier.
35dss product department1;2FREE TEXTThe nationally defined DSS Intermediate Department Number designated to the Pharmacy care product.
36sex1;3SET OF CODESM:MALE
F:FEMALE
Patient's gender.
37zip+41;4FREE TEXTThe ZIP code for where the patient resides. The 5-character ZIP code is provided if ZIP+4 is not available.
38placeholder1;5FREE TEXTCurrently NULL.
39placeholder1;6FREE TEXTCurrently NULL.
40state1;7FREE TEXTThe state in which the patient resides.
41county1;8FREE TEXTThe county in which the patient resides.
42pc provider person class1;9FREE TEXTThe VA Code of the Person Class of the Primary Care Provider as of the date of this extract record.
43pow status1;10SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient was confined as a Prisoner of War.
44pow location1;11POINTER22If 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
45radiation status1;12SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient claims exposure to ionizing radiation.
46agent orange status1;13SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates whether patient was exposed to Agent Orange.
47sharing agreement payor1;14FREE TEXTAn indicator used for patients participating in sharing agreements.
48sharing agreement insurance1;15POINTER36Indicates the first insurer for patients who participate in sharing agreements.
49mst status1;16SET OF CODESY:Yes, screened reports MST
N:Screened, does not report MST
D:Screened, declines to answer
U:Unknown, not screened
Military Sexual Trauma (MST) status of a patient on the date of the encounter.
50enrollment location1;17FREE TEXTThe facility that the patient chooses to designate as his preferred location for care.
51associate pc provider1;18FREE TEXTThe associate primary care provider assigned to this patient through the Primary Care Management Module (PCMM) application.
52assoc. pc prov. person class1;19FREE TEXTThe VA code of the Person Class of the Associate Primary Care Provider as of the date of this extract record.
53placeholder1;20FREE TEXTCurrently NULL.
54dom,prrtp and saartp indicator1;21SET 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.
55purple heart indicator1;22BOOLEANY:YES
N:NO
Indicates whether or not a patient is a Purple Heart recipient.
56enrollment category1;23FREE TEXTPatient's enrollment category.
57enrollment status1;24POINTER27.15Patient's enrollment status.
58placeholder1;25FREE TEXT
59cnhu status1;26BOOLEANY:YES
N:NO
Identifies if patient resides in a contract nursing home.
60period of service1;27FREE TEXTThe period of service that best classifies the patient based on eligibility code.
61observation patient indicator1;28SET OF CODESNO:NO
YES:YES
Indicates if patient is considered to be an observation patient.
62encounter number1;29FREE TEXTThe unique number assigned to each encounter within DSS.
63agent orange location1;30SET OF CODESK:KOREAN DMZ
V:VIETNAM
O:OTHER
Indicates the location where the patient was exposed to Agent Orange.
64ordering physician1;31FREE TEXTFor future development; currently set to null.
65ordering stop code1;32FREE TEXTThis field contains the stop code associated with the order.
66ordering date1;33FREE TEXTDate provider ordered the prescription.
67cnh status1;34SET OF CODESYES:YES
NO:NO
This field is used to indicate whether a patient is currently in a contract nursing home.
68production division code1;35FREE TEXTIdentifies the division/facility where the work was performed.
69means test1;36SET 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.
70head & neck cancer indicator1;37BOOLEANY:YES
N:NO
Identifies whether treatment was for head and/or neck cancer.
71ethnicity1;38FREE TEXTThe patient's PTF Ethnicity code.
72race 11;39FREE TEXTSelf-reported by patient as recorded in VistA patient file.
73dss ip #1;40NUMERICThe nationally defined DSS Intermediate Product Number designated to the patient care product.
74enrollment priority1;41FREE TEXTThis field contains the enrollment priority group and the enrollment priority subgroup.
75user enrollee1;42FREE TEXTUser enrollee is determined by checking the Patient Enrollment file 27.11, when a user has a current or future fiscal year in the VistA User Enrollee Status field set value to 'U' and Null if no date or a past year's value is contained.
76patient type2;1FREE TEXTPATIENT TYPE refers to the various types of patient which might be seen at a VA facility. It is determined by the TYPE field of the PATIENT File #2 which points to the TYPE OF PATIENT entries in File #391.
77cv status eligibility2;2SET 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.
78cv eligibility end date2;3FREE 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.
79encounter cv2;4BOOLEANY: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.
80national patient record flag2;5BOOLEANY:YES
This field records whether the patient's record contains 1 or more active category 1 (National) Patient Record Flags.
81rx patient status2;6SET OF CODESSC:SERVICE CONNECTED
AA:A&A
OTH:OTHER
INP:INPATIENT
NON:NON-VA
Indicates the status of the patient at the time the medication was filled.
82non va prescriber2;7SET OF CODESY:YES
0:NO
Indicates the provider prescribing the prescription is not a VA employee.
83rx order number2;8NUMERICThis field contains the prescription number which shall be a whole number between 1 and 999999999.
84eri2;9FREE TEXTThis field identifies patients from impacted zip code areas designated by the Federal Emergency Management Agency (FEMA).
85agent orange enc indicator2;10BOOLEANY:YES
N:NO
Indicates whether service provided during this patient encounter is related to exposure to Agent Orange.
86encounter swac2;11BOOLEANY:YES
N:NO
Indicates the appropriate response for Southwest Asia conditions as related to this patient's episode of care.
87enc head/neck ca2;12BOOLEANY:YES
N:NO
Indicates whether service provided during this patient encounter is related to head and/or neck cancer.
88encounter mst2;13BOOLEANN:NO
Y:YES
Indicates whether service provided during this patient encounter is related to military sexual trauma.
89sw asia conditions2;14SET 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.
90radiation encounter indicator2;15BOOLEANY:YES
N:NO
Indicates whether service provided during this patient encounter is related to exposure to ionizing radiation.
91service connected rx2;16BOOLEANY:YES
N:NO
This field will indicate whether this prescription is for a service connected condition.
92oef/oif2;17FREE 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.
93oef/oif return date2;18FREE 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.
94associate pc provider npi2;19FREE TEXTA standard unique life-long identifier of the associate primary care provider. This field has a length of fifteen characters.
95primary care provider npi2;20FREE TEXTA standard unique life-long identifier of the primary care provider. This field has a length of fifteen characters.
96provider npi2;21FREE TEXTA standard unique life-long identifier of the individuals providing health care services. This field has a length of fifteen characters.
97country code2;22FREE TEXTThe code for the country associated with the address.
98patcat2;23SET 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.
99encounter sc2;24BOOLEANY:YES
N:NO
Indicates if treatment provided during this patient encounter is Service Connected.
100vietnam2;25SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient is a Vietnam era veteran.
101camp lejeune status2;26BOOLEANY: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.
102encounter camp lejeune2;27BOOLEANY: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.
103combat veteran indicator2;28BOOLEANY:YES
N:NO
Identifies if the patient served in a combat zone.
104combat veteran location2;29FREE TEXTIdentifies the war in which the combat service was incurred.
105remarks2;30SET OF CODESC:CHOICE
This field is set based on whether the prescription is being filled by the VA as part of the Veteran's Choice program.

Not Referenced