Files > LABORATORY EXTRACT

name
LABORATORY EXTRACT
number
727.813
location
^ECX(727.813,
description
This file contains data elements as specified by the Decision Support System (DSS) Program Office for the Laboratory extract from existing DHCP files. Entries into this file are made by extracting data by two different methods depending upon whether or not LMIP codes are used. Using LMIP codes, the data are extracted, in large part, from the WKLD LOG file (#64.03) which is populated by a routine provided by the Laboratory development team. Not using LMIP codes, the data are derived from several Lab files as well as from several other DHCP 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;5NUMERICAn identifying number for the patient at the local site.
5ssn identifying number0;6FREE TEXTThe patient's social security number or the identifying number for a referral patient.
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 TEXTDate the last test/specimen was collected.
9accession area0;10FREE TEXTThe accession area where the lab specimen was received.
10abbreviation0;11FREE TEXTThe abbreviation for the accession area where the lab specimen was received.
11test0;12POINTER60The lab test performed.
12urgency of test0;13POINTER62.05The turnaround time requested.
13treating specialty0;14FREE TEXTThe PTF CODE of the treating specialty associated with this extract record.
14location0;15FREE TEXTThe service/location from which the original order came.
15provider0;16FREE TEXTThe provider assigned to this patient or entity.
16movement file #0;17POINTER405Movement number from the PATIENT MOVEMENT file (#405) associated with this event for a patient. This field will be set to null for non- patient or outpatient events.
17file0;18FREE TEXTParent file from which the patient information was extracted. Either the PATIENT file (#2) or REFERRAL PATIENT file (#67).
18time0;19FREE TEXTA 6-character numeric string that represents the time of day at which the Laboratory test was collected.
19workload code0;20FREE TEXTThis is the workload code for this event.
20primary care team0;21FREE TEXTThe primary care team assigned to this patient.
21primary care provider0;22FREE TEXTThe primary care provider assigned to this patient through the Primary Care Management Module (PCMM) module application on the accession date.
22master patient index1;1FREE TEXTUnique national VA patient identifier.
23dss product department1;2FREE TEXTThe nationally defined DSS Intermediate Department Number designated to the Laboratory care product.
24placeholder1;3FREE TEXTCurrently NULL.
25placeholder1;4FREE TEXTCurrently NULL.
26pc provider person class1;5FREE TEXTThe VA Code of the Person Class of the Primary Care Provider as of the date of this extract record.
27associate pc provider1;6FREE TEXTThe Associate Primary Care Provider assigned to this patient through the Primary Care Management Module (PCMM) module application.
28assoc. pc prov. person class1;7FREE TEXTVA Code of the Person Class of the patient's Associate Primary Care Provider.
29placeholder1;8FREE TEXTCurrently NULL.
30dom,prrtp and saartp indicator1;9SET 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. CWT/TR
Indicates if the patient is admitted to either a RRTP, PRRTP, or SARRTP at the time care is provided.
31observation patient indicator1;10SET OF CODESNO:NO
YES:YES
Indicates if patient is considered to be an observation patient.
32encounter number1;11FREE TEXTThe unique number assigned for DSS.
33ordering stop code1;12FREE TEXTThis field contains the stop code associated with the order.
34ordering date1;13FREE TEXTDate test was ordered.
35production division1;14FREE TEXTData represents the medical center division the work was performed in. This field corresponds to an entry in the INSTITUTION file (#4).
36dss ip #1;15NUMERICThe nationally defined DSS Intermediate Product Number designated to the patient care product.
37ordering provider person class1;16FREE TEXTVA code of the Person Class of the patient's Ordering Provider.
38eri1;17FREE TEXTThis field identifies patients from impacted zip code areas designated by the Federal Emergency Management Agency (FEMA).
39associate pc provider npi1;18FREE TEXTA standard unique life-long identifier of the associate primary care provider. This field has a length of fifteen characters.
40primary care provider npi1;19FREE TEXTA standard unique life-long identifier of the primary care provider. This field has a length of fifteen characters.
41provider npi1;20FREE TEXTA standard unique life-long identifier of the individuals providing health care services. This field has a length of fifteen characters.
42loinc code1;21FREE TEXTA universal coding standard for identifying laboratory observations.
43lab billable procedure1;22BOOLEANY:YES
N:NO
If a "Y" is entered it will indicate that the test is considered a billable LMIP procedure (lab billable means Lab staff workload).
44dss feeder key1;23BOOLEANY:YES
N:NO
If a "Y" is entered it indicates the WKLD Code should be used for DSS Laboratory data collection.
45data name2;1FREE TEXTThis field is the Lab Test Data Name.
46data location2;2FREE TEXTThe Data Location field is only populated if a test is a non-panel test and is part of the CHEM, HEM, TOX, SER, RIA, etc. area.
47patcat2;3SET 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.
48encounter sc2;4BOOLEANY:YES
N:NO
Indicates if treatment provided during this patient encounter is Service Connected.
49camp lejeune status2;5BOOLEANY: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.
50pathologist2;6FREE TEXTThis is the pathologist who performed the anatomic pathology workload for the record.
51pathologist person class2;7FREE TEXTThe VA Code of the Person Class of the pathologist associated with this record. The VA Code is always of the form "V"_six numeric digits; exactly 7.
52pathologist provider npi2;8FREE TEXTA standard unique life-long identifier of the pathologist.

Not Referenced