Files > ADMISSION EXTRACT

name
ADMISSION EXTRACT
number
727.802
location
^ECX(727.802,
description
This file contains data elements as specified by the Decision Support System (DSS) Program Office for the MAS Admission 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 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.
8day0;9FREE TEXTThis 8-character string represents the date on which the admission occurred.
9primary care team0;10FREE TEXTThe primary care team assigned to this patient.
10sex0;11SET OF CODESM:MALE
F:FEMALE
Data is M if this patient is a male, or F if female.
11date of birth0;12FREE TEXTPatient's date of birth.
12religion0;13POINTER13The current religious preference of this patient.
13employment status0;14SET OF CODES1:EMPLOYED FULL TIME
2:EMPLOYED PART TIME
3:NOT EMPLOYED
4:SELF EMPLOYED
5:RETIRED
6:ACTIVE DUTY MILITARY
9:UNKNOWN
The patient's current employment status.
14health insurance0;15SET OF CODES1:INSURED
0:UNINSURED
Identifies if patient is covered by health insurance.
15state0;16FREE TEXTThe state in which the patient resides.
16county0;17FREE TEXTCounty in which the patient resides.
17zip+40;18FREE TEXTThe zip code for where the patient resides. The 5-character zip code is provided if zip+4 is not available.
18eligibility0;19FREE TEXTAppropriate eligibility code based on veteran or non-veteran status.
19veteran0;20BOOLEANY:YES
N:NO
Patient's Veteran status.
20vietnam0;21SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient is a Vietnam era veteran.
21agent orange status0;22SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates whether patient was exposed to Agent Orange.
22radiation status0;23SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if the patient claims exposure to ionizing radiation.
23pow status0;24SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient was confined as a Prisoner of War.
24period of service0;25FREE TEXTThe period of service which best classifies this patient based on eligibility code.
25means test0;26SET 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.
26marital status0;27POINTER11Current marital status for this patient.
27ward0;28POINTER44Current ward for this patient.
28treating specialty0;29FREE TEXTThe PTF CODE of the treating specialty associated with this extract record.
29attending physician0;30FREE TEXTThe attending physician assigned to this patient at the time of admission.
30movement file #0;31POINTER405Current movement number for this patient.
31drg0;32POINTER80.2The Diagnostic Related Group (DRG) for this admission.
32principal diagnosis0;33FREE TEXTPrincipal ICD diagnosis for this patient.
33time0;34FREE TEXTA 6-character numeric string which represents the time of day at which the admission occurred.
34primary care provider0;35FREE TEXTThe primary care provider assigned to this patient.
35race0;36FREE TEXTRace ABBREVIATION for this patient.
36primary ward provider0;37FREE TEXTThe provider assigned to the ward where the patient is located at the time of admission.
37master patient index1;1FREE TEXTUnique national VA patient identifier.
38dss dept.1;2FREE TEXTThe DSS Department code for the ward. Must contain at least four characters to be a valid code.
39placeholder1;3FREE TEXTCurrently NULL.
40placeholder1;4FREE TEXTCurrently NULL.
41placeholder1;5FREE TEXTCurrently NULL.
42admission eligibility1;6FREE TEXTThe eligibility of the patient for this specific admission.
43mst status1;7SET OF CODESY:Yes, screened reports MST
N:Screened, does not report MST
D:Screened, declines to answer
U:Unknown, not screened
The MST Status of the patient on the date of the patient's admission.
44shad status1;8SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates whether patient meets requirements for Shipboard Hazard and Defense (SHAD) status.
45sharing agreement payor1;9FREE TEXTAn indicator used for patients participating in sharing agreements.
46sharing agreement insurance1;10FREE TEXTUsed to indicate insurer, if patient participates in a sharing agreement.
47enrollment location1;11FREE TEXTThe facility that the patient chooses to designate as his preferred location for care.
48pc provider person class1;12FREE TEXTThe VA Code of the Person Class of the Primary Care Provider as of the date of this extract record.
49associate pc provider1;13FREE TEXTThe Associate Primary Care Provider assigned to this patient through the Primary Care Management Module (PCMM) application.
50assoc. pc prov. person class1;14FREE TEXTVA Code of the Person Class of the patient's Associate Primary Care Provider.
51placeholder1;15FREE TEXTCurrently NULL.
52dom, prrtp and saartp1;16SET 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.
53enrollment category1;17FREE TEXTPatient's enrollment category.
54enrollment status1;18FREE TEXTPatient's enrollment status.
55encounter shad1;19BOOLEANY:YES
N:NO
Indicates if treatment provided during the patient's admission is related to the Shipboard Hazard And Defense (SHAD) condition.
56purple heart indicator1;20BOOLEANY:YES
N:NO
Indicates whether or not a patient is a Purple Heart recipient.
57observation patient indicator1;21SET OF CODESNO:NO
YES:YES
Indicates if patient is considered to be an observation patient.
58encounter number1;22FREE TEXTThe unique number assigned for DSS.
59agent orange location1;23FREE TEXTIndicates the location where the patient was exposed to Agent Orange.
60production division code1;24FREE TEXTIdentifies the division/facility where the work was performed.
61pow location1;25POINTER22If 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
62source of admission1;26SET OF CODES1:HOSPITAL
2:NHCU
3:DOMICILIARY
4:MILITARY HOSPITAL
5:CNH
Indicates where the admission took place.
63head & neck cancer indicator1;27BOOLEANY:YES
N:NO
Identifies whether patient has head and/or neck cancer.
64ethnicity1;28FREE TEXTThe patient's PTF ethnicity code.
65race 11;29FREE TEXTSelf-reported by patient as recorded in VistA patient file.
66enrollment priority1;30FREE TEXTThis field contains the enrollment priority group and the enrollment priority subgroup.
67user enrollee1;31SET OF CODESU:USER ENROLLED
Indicates whether a Veteran has User Enrollee status for the current or future fiscal year.
68patient type1;32SET 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.
69cv status eligibility1;33SET 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.
70cv eligibility end date1;34FREE TEXTRecords the Combat Veteran eligibility expiration date of the 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.
71encounter cv1;35BOOLEANY: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.
72national patient record flag1;36BOOLEANY:YES
This field records whether the patient's record contains 1 or more active category 1 (National) Patient Record Flags.
73attending physician pc1;37FREE TEXTThe VA Code of the Person Class of the Attending Physician associated with this record.
74primary ward provider pc1;38FREE TEXTThe VA Code of the Person Class of the Primary Ward Provider associated with this record.
75sw asia conditions1;39SET OF CODESY:YES
N:NO
U:UNKNOWN
This field is used to indicate if this patient claims exposure to Southwest Asia Conditions.
76eri1;40FREE TEXTThis field identifies patients from impacted zip code areas designated by the Federal Emergency Management Agency (FEMA).
77agent orange enc indicator1;41BOOLEANY:YES
N:NO
Indicates whether service provided during this patient encounter is related to exposure to Agent Orange.
78encounter swac1;42FREE TEXTIndicates the appropriate response for exposure to Southwest Asia conditions as related to this patient's episode of care: Y = Yes N = No Null
79enc head/neck ca1;43FREE TEXTIndicates the appropriate response for head/neck cancer as related to this patient's episode of care: Y = Yes N = No Null
80encounter mst1;44FREE TEXTIndicates the appropriate response for military sexual trauma as related to this patient's episode of care: Y = Yes N = No Null
81radiation encounter indicator1;45FREE TEXTIndicates the appropriate response for ionizing radiation exposure as related to this patient's episode of care: Y = Yes N = No Null
82oef/oif2;1FREE 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;2FREE 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.
84associate pc provider npi2;3FREE TEXTStandard unique life-long identifier of the associate primary care provider. This field has a length of fifteen characters.
85attending physician npi2;4FREE TEXTStandard unique life-long identifier of the attending physician. This field has a length of fifteen characters.
86primary care provider npi2;5FREE TEXTA standard unique life-long identifier of the primary care provider. This field has a length of fifteen characters.
87primary ward provider npi2;6FREE TEXTA standard unique life-long identifier of the primary ward provider. This field has a length of fifteen characters.
88admit outpatient tx flag2;7BOOLEANY:YES
This field contains the patient's source of admission flag. YES, if admit outpatient treatment ('1P').
89country code2;8FREE TEXTThis is the code for the country associated with the address.
90patcat2;9SET 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.
91admit source2;10FREE TEXTThis field contains the source of admission for the PTF entry. This is a two character code in the format of 1 numeric and 1 alphanumeric.
92ed disposition code2;11SET OF CODESA:ADMIT
D:DECEASED
E:ERROR
L:LEFT
R:REFERRED
T:TRANSFERRED
U:UNKNOWN
N:NONE
Disposition code associated with the patient's emergency room visit.
93primary icd-10 code2;12FREE TEXTThe primary ICD-10 diagnosis code for this admission.
94camp lejeune status2;13BOOLEANY: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.
95encounter camp lejeune2;14BOOLEANY: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.
96encounter sc2;15BOOLEANY:YES
N:NO
Indicates if treatment provided during this patient encounter is Service Connected.
97combat veteran indicator2;16BOOLEANY:YES
N:NO
Identifies if the patient served in a combat zone.
98combat veteran location2;17FREE TEXTIdentifies the war in which the combat service was incurred.

Not Referenced