Files > NUTRITION EXTRACT

name
NUTRITION EXTRACT
number
727.832
location
^ECX(727.832,
description
This file contains data elements as specified by the Decision Support System (DSS) Program Office for the Nutrition and Food Service extract from existing VistA 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;1NUMERICBThe record number for this extract entry.
1year month0;2FREE TEXTA six character numeric string representing the year and the month for which this extract was performed.
2extract number(+)0;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. - dfn(+)0;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 on which the service was provided.
9time0;10FREE TEXTTime the service was provided (6-digit military time).
10treating specialty0;11FREE TEXTThe PTF CODE of the treating specialty associated with this extract record form the SPECIALTY file (#42.4).
11ordering provider0;12FREE TEXTProvider ordering the patient feeding.
12ordering provider person class0;13FREE TEXTVA Code of the Person Class of the patient's Ordering Provider as of the date of this extract record.
13primary care provider0;14FREE TEXTThe primary care provider assigned to this patient through the Primary Care Management Module (PCMM) application.
14primary care prv person class0;15FREE TEXTVA Code of the Person Class of the Primary Care Provider as of the date of this extract record.
15primary care team0;16POINTER404.51The primary care team assigned to this patient in the PCMM module.
16master patient index0;17FREE TEXTUnique national VA patient identifier.
17date of birth0;18FREE TEXTPatient's date of birth.
18sex0;19SET OF CODESM:MALE
F:FEMALE
Patient's gender.
19race 10;20FREE TEXTSelf-reported by patient as recorded in VistA patient file.
20ethnicity0;21SET OF CODESD:DECLINED TO ANSWER
H:HISPANIC OR LATINO
N:NOT HISPANIC OR LATINO
U:UNKNOWN BY PATIENT
The patient's PTF ethnicity code.
21veteran0;22BOOLEANN:NO
Y:YES
Patient's veteran status.
22enrollment status0;23POINTER27.15Patient's enrollment status.
23enrollment location0;24FREE TEXTThe facility that the patient chooses to designate as his preferred location for care.
24enrollment category0;25FREE TEXTPatient's enrollment category.
25enrollment priority0;26FREE TEXTThis field contains the enrollment priority group and the enrollment priority subgroup.
26eligibility0;27FREE TEXTPatient's Primary Eligibility converted to NPCD eligibility code; Eligibility code is based on veteran or non-veteran status.
27period of service0;28FREE TEXTThe period of service, which best classifies this patient based on eligibility code.
28agent orange status0;29SET OF CODESN:NO
Y:YES
U:UNKNOWN
Indicates whether patient was exposed to Agent Orange.
29agent orange location0;30SET OF CODESK:KOREAN DMZ
V:VIETNAM
O:OTHER
Indicates the location where the patient was exposed to Agent Orange.
30radiation status0;31SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient claims exposure to ionizing radiation.
31sw asia conditions0;32SET OF CODESY:YES
N:NO
U:UNKNOWN
This field is used to indicate if patient claims exposure to Southwest Asia Conditions.
32mst status0;33SET OF CODESN:No, Screened does not report MST
Y:Yes, Screened reports 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.
33head & neck cancer indicator0;34BOOLEANY:YES
N:NO
Identifies whether patient has head and/or neck cancer.
34pow status0;35BOOLEANN:NO
Y:YES
Indicates if patient was confined as a Prisoner of War
35pow location0;36POINTER22If POW Status is indicated, this is the POW confinement location.
36purple heart indicator0;37BOOLEANY:YES
N:NO
Indicates whether or not a patient is a Purple Heart recipient.
37means test0;38SET 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.
38state code0;39FREE TEXTThe state in which the patient resides
39county code0;40FREE TEXTThe county in which the patient resides
40zip+41;1FREE TEXTThe ZIP code for where the patient resides. The 5-character ZIP code is provided if ZIP+4 is not available.
41observation patient indicator1;2SET OF CODESNO:NO
YES:YES
Indicates if patient is considered to be an observation patient.
42rrtp, prrtp, 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 the time care is provided.
43encounter number1;4FREE TEXTThe unique number assigned for DSS.
44patient division1;5FREE TEXTDivision in which patient's bed is located
45food production division1;6FREE TEXTStation number where the kitchen is located.
46delivery division1;7FREE TEXTStation number where the meal was delivered.
47product feeder key1;8FREE TEXTStandardized DSS product assigned by DSS NUTRITION PRODUCT worksheet.
48food production facility1;9FREE TEXTKitchen location where product was prepared.
49delivery location type1;10SET OF CODEST:TRAY
C:CAFETERIA
D:DINING ROOM
Delivery point for product associated with the specific diet that was delivered on the selected date.
50delivery feeder location1;11FREE TEXTDSS identifier indicating patient location where product was delivered.
51quantity1;12NUMERICProduct quantity.
52cboc status1;13BOOLEANY:YES
Indicates if the patient was seen at a Community Based Outpatient Clinic (CBOC).
53user enrollee1;14SET OF CODESU:USER ENROLLED
Indicates whether a veteran has user enrollee status for the current or future fiscal year.
54patient type1;15SET 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. Every patient in the system must have a TYPE specified.
55cv status eligibility1;16SET 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.
56national patient record flag1;17BOOLEANY:YES
This field records that the patient's record contains 1 or more Category 1 (National) Patient Record Flags.
57eri1;18SET OF CODESK:HURRICANE KATRINA
This field identifies patients from impacted ZIP code areas designated by the Federal Emergency Management Agency (FEMA).
58admission date1;19FREE TEXTDate on which the patient's admission occurred.
59oef/oif1;20FREE 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.
60oef/oif return date1;21FREE 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.
61tf units1;22SET OF CODESML:ML
GM:GM
Indicates the unit of measurement used for the tube feeding.
62ordering provider npi1;23FREE TEXTA standard unique life-long identifier of the ordering provider who ordered the patient feeding. This field has a length of fifteen characters.
63primary care provider npi1;24FREE TEXTA standard unique life-long identifier of the primary care provider. This field has a length of fifteen characters.
64country code1;25FREE TEXTThis is the code for the country associated with the address.
65shad status1;26SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates whether patient meets requirements for Shipboard Hazard and Defense (SHAD) status.
66patcat1;27SET 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.

Not Referenced