Files > LAB RESULTS EXTRACT

name
LAB RESULTS EXTRACT
number
727.824
location
^ECX(727.824,
description
This file contains data elements as specified by the Decision Support System (DSS) Program Office for the Laboratory Results 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 TEXTDate the Lab Test/Specimen was collected.
9test code(+)0;10FREE TEXTThe coded value of the lab test as specified by the vendor.
10results0;11NUMERICThe result of the lab test.
12hi/lo indicator0;12SET OF CODESH:HIGH
L:LOW
Indicates High or Low test result.
13date ordered0;13FREE TEXTAn 8-character numeric string that represents the date on which the Laboratory test was ordered.
14time ordered0;14FREE TEXTA 6-character numeric string that represents the time of day at which the Laboratory test was ordered.
15date results ready0;15FREE TEXTAn 8-character numeric string that represents the date on which the Laboratory test result was ready for reporting.
16time results ready(+)0;16FREE TEXTA 6-character numeric string that represents the time of day at which the Laboratory test result was ready for reporting.
17movement file #0;17POINTER405Current patient movement record associated with this extract record.
18treating specialty0;18FREE TEXTThe PTF CODE of the treating specialty associated with this extract record.
19workload code0;19FREE TEXTThe LMIP/NLT workload code for this record. May correspond to a College of American Pathologists (CAP) code.
20master patient index1;1FREE TEXTA national VA system identifier which uniquely identifies a patient.
21dss dept.1;2FREE TEXTThe DSS Department Code for the Laboratory product.
22dom,prrtp and saartp indicator1;3SET 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 time care is provided.
23time collected1;4FREE TEXTTime of day specimen was collected.
24observation patient indicator1;5SET OF CODESNO:NO
YES:YES
Indicates if patient is considered to be an observation patient.
25encounter number1;6FREE TEXTThe unique number assigned for DSS.
26production division code1;7FREE TEXTIdentifies the division/facility where the work was performed.
27lab results translation1;8FREE TEXTThe translation code for free text entries in the RESULTS field (#10).
28ordering provider1;9FREE TEXTThe provider ordering this lab test.
29ordering provider person class1;10FREE TEXTThe VA Code of the Person Class of the Ordering Provider as of the date of this extract record.
30ordering provider npi1;11FREE TEXTA standard unique life-long identifier of the provider who ordered the lab test. This field has a length of fifteen characters.
31loinc code1;12FREE TEXTA universal coding standard for identifying laboratory observations.
32patcat1;13SET 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.
33encounter sc1;14BOOLEANY:YES
N:NO
Indicates if treatment provided during this patient encounter is Service Connected.
34camp lejeune status1;15BOOLEANY: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.
35encounter camp lejeune1;16BOOLEANY: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.

Not Referenced