Files > PROSTHETICS EXTRACT

name
PROSTHETICS EXTRACT
number
727.826
location
^ECX(727.826,
description
This file contains the data elements as specified by the Decision Support System (DSS) Program Office for the Prosthetics extract from existing VISTA files. Entries into this file are made by extracting data that originates in the Prosthetics RECORD OF PROS APPLIANCE/REPAIR file (#660). Information respective to the patient for which Prosthetic information is extracted is pulled from the PIMS Patient file (#2). Once the extracts (making up the records in this file) are approved by the extract manager, entries in this file are loaded into mail messages and transmitted to the commercial vendor. This file is intended to be used for validation purposes only. Entries in this file 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.
applicationGroups
ECX
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.
3facility(+)0;4FREE TEXTThis is the facility/division where the extract was performed.
4patient no. dfn(+)0;5POINTER2This is the patient to whom this extract record pertains.
5ssn(+)0;6FREE TEXTThe patient's Social Security Number.
6name0;7FREE TEXTThe first four characters of the patient's last name.
7in outpatient indicator0;8SET OF CODESI:INPATIENT
O:OUTPATIENT
Indicates whether the patient was an inpatient or an outpatient for this extract.
8date of service(+)0;9FREE TEXTDate on which the new or repaired prosthetic appliance was delivered and accepted by the patient.
9feeder location(+)0;10FREE TEXTLocation within a facility where the product is produced.
10feeder key(+)0;11FREE TEXTCode that uniquely identifies a DSS product.
11quantity0;12NUMERICThe number of units issued or units repaired as indicated in the patient's prosthetic record.
12primary care team0;13FREE TEXTThe IEN of the primary care team assigned to this patient in the PCMM module.
13primary care provider0;14FREE TEXTThe primary care provider assigned to this patient through the Primary Care Management Module (PCMM) application.
14pce cpt/hcpcs code & modifiers(+)0;15FREE TEXTHCPCS code for the item selected.
15icd-9 code0;16FREE TEXTICD-9 CODE is the diagnostic code for the patient's prosthetic record.
16secondary icd-9 code 10;17FREE TEXTThis field contains the ICD9 diagnostic code for this extract record.
17secondary icd-9 code 20;18FREE TEXTThis field contains the ICD9 diagnostic code for this extract record.
18secondary icd-9 code 30;19FREE TEXTThis field contains the ICD9 diagnostic code for this extract record.
19secondary icd-9 code 40;20FREE TEXTThis field contains the ICD9 diagnostic code for this extract record.
20agent orange status0;21SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates whether patient was exposed to Agent Orange.
21radiation exposure status0;22SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient claims exposure to ionizing radiation.
22sw asia conditions0;23SET OF CODESY:YES
N:NO
U:UNKNOWN
This field is used to indicate if patient claims exposure to Southwest Asia Conditions.
23patient eligibility0;24FREE TEXTPATIENT ELIGIBILITY is the patient's primary eligibility code.
24cost of transaction0;25FREE TEXTCost to produce the prosthetic.
25lab labor cost0;26FREE TEXTThe total cost of labor to perform the job.
26lab material cost0;27FREE TEXTThe cost of all materials required to perform the job.
27billing status0;28SET OF CODES1:SC/OP (Service Connected Outpatient)
2:SC/IP (Service Connected Inpatient)
3:NSC/IP (Non Service Connected Inpatient)
4:NSC/OP (Non Service Connected Outpatient)
5:Other (Patient Category unknown)
Patient's billing status.
28vet/non vet0;29SET OF CODESY:Patient is a veteran
N:Patient is not a veteran
Patient's veteran status.
29type of transaction0;30SET OF CODESI:Initial issue
R:Replacement
S:Spare
X:Repair
5:Rental
The code that best describes the prosthetic transaction.
30requesting station0;31FREE TEXTThe facility that initiates the request for a Lab prosthetic.
31receiving station0;32FREE TEXTThe Lab facility that fills the Lab request and provides the prosthetic to the requesting station.
32psas hcpcs code0;33FREE TEXTThis field is used to hold the PSAS HCPCS Code from the Prosthetics record being extracted.
33zip code1;1FREE TEXTThe ZIP code for where the patient resides. The 5-character ZIP code is provided if ZIP+4 is not available.
34date of birth1;2FREE TEXTPatient's date of birth.
35sex1;3SET OF CODESM:MALE
F:FEMALE
Patient's gender.
36amis grouper1;4NUMERICAMIS GROUPER holds the AMIS Grouper number that indicates what items combine to create a prosthetic device.
37placeholder1;5FREE TEXTCurrently NULL.
38master patient index1;6FREE TEXTUnique national VA patient identifier.
39dss product department1;7FREE TEXTThe nationally defined DSS Intermediate Department Number designated to the patient care product being provided.
40pc provider person class1;8FREE TEXTThe VA Code of the Person Class of the Primary Care Provider as of the date of this extract record.
41race1;9FREE TEXTRace ABBREVIATION for this patient.
42pow status1;10SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient was confined as a Prisoner of War.
43pow location1;11FREE TEXTIf 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
44sharing agreement payor1;12FREE TEXTAn indicator used for patients participating in sharing agreements.
45sharing agreement insurance1;13POINTER36Indicates the first insurer for patients who participate in sharing agreements.
46mst status1;14SET OF CODESY:Yes, screened reports MST
N:Screened, does not report MST
D:Screened, declines to answer
U:Unknown, not screened
Indicates the Military Sexual Trauma (MST) status of a patient on the date of the encounter.
47enrollment location1;15FREE TEXTThe facility that the patient chooses to designate as his preferred location for care.
48state1;16FREE TEXTThe state in which the patient resides.
49county1;17FREE TEXTThe county in which the patient resides.
50associate pc provider1;18FREE TEXTThe Associate Primary Care Provider assigned to this patient through the Primary Care Management Module (PCMM) application.
51assoc. pc prov. person class1;19FREE TEXTVA Code of the Person Class of the patient's Associate Primary Care Provider.
52placeholder1;20FREE TEXTCurrently NULL.
53dom,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.
54enrollment category1;22FREE TEXTPatient's enrollment category.
55enrollment status1;23POINTER27.15Patient's enrollment status.
56placeholder1;24FREE TEXT
57purple heart indicator1;25BOOLEANY:YES
N:NO
Indicates whether or not a patient is a Purple Heart recipient.
58period of service1;26FREE TEXTThe period of service that best classifies the patient based on eligibility code.
59observation patient indicator1;27SET OF CODESNO:NO
YES:YES
Indicates if patient is considered to be an observation patient.
60encounter number1;28FREE TEXTThe unique number assigned for DSS.
61agent orange location1;29FREE TEXTIndicates the location where the patient was exposed to Agent Orange.
62cnh status1;30SET OF CODESYES:YES
NO:NO
This field is used to indicate whether a patient is currently in a contract nursing home.
63production division code1;31FREE TEXTIdentifies the division/facility where the work was performed.
64head & neck cancer indicator1;32BOOLEANY:YES
N:NO
Indicates whether patient has head and/or neck cancer.
65ethnicity1;33FREE TEXTThe patient's PTF Ethnicity code.
66race 11;34FREE TEXTSelf-reported by patient as recorded in VistA patient file.
67dss ip #1;35NUMERICThe nationally defined DSS Intermediate Product Number designated to the patient care product.
68enrollment priority1;36FREE TEXTThis field contains the enrollment priority group and the enrollment priority subgroup.
69user enrollee1;37SET OF CODESU:USER ENROLLED
Indicates whether a Veteran has User Enrollee status for the current or future fiscal year.
70patient type1;38SET 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.
71cv status eligibility1;39SET 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.
72cv eligibility end date1;40FREE TEXTRecords the Combat Veteran eligibility expiration date of 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.
73encounter cv1;41BOOLEANY:YES
Records is 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.
74national patient record flag1;42BOOLEANY:YES
This field records whether the patient's record contains 1 or more active category 1 (National) Patient Record Flags.
75eri1;43FREE TEXTThis field identifies patients from impacted zip code areas designated by the Federal Emergency Management Agency (FEMA).
76agent orange enc indicator1;44BOOLEANY:YES
N:NO
Indicates whether service provided during this patient encounter is related to exposure to Agent Orange.
77encounter swac1;45BOOLEANY:YES
N:NO
This field indicates whether treatment provided during this patient encounter is related to exposure to Southwest Asia conditions while serving in the Southwest Asia Theater of operations.
78enc head/neck ca1;46BOOLEANY:YES
N:NO
Indicates whether service provided during this patient encounter is related to head and/or neck cancer.
79encounter mst1;47BOOLEANY:YES
N:NO
Indicates whether service provided during this patient encounter is related to military sexual trauma.
80radiation encounter indicator1;48BOOLEANY:YES
N:NO
Indicates whether service provided during this patient encounter is related to ionizing radiation.
81oef/oif2;1FREE TEXTThe Military Operation in which the patient was in combat during the specified time period. This field reflects the OEF or OIF where this patient was in combat.
82oef/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.
83nppd code2;3FREE TEXTThe National Prosthetics Product Database (NPPD) report line number to which the HCPCS are assigned.
84nppd entry date2;4FREE TEXTThe date the entry was first made in the VistA Prosthetics Package.
85associate pc provider npi2;5FREE TEXTA standard unique life-long identifier of the associate primary care provider. This field has a length of fifteen characters.
86primary care provider npi2;6FREE TEXTA standard unique life-long identifier of the primary care provider. This field has a length of fifteen characters.
87country code2;7FREE TEXTThe code for the country associated with the address.
88shad status2;8SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates whether patient meets requirements for Shipboard Hazard and Defense (SHAD).
89encounter shad2;9BOOLEANY:YES
N:NO
Indicates if treatment provided during this patient encounter is related to exposure PROJ 112/SHAD condition. Values: Y=YES, N=NO
90labor hours2;10NUMERICThis is the number of hours spent on the job.
91patcat2;11SET 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.
92primary icd-10 code2;12FREE TEXTThe primary ICD-10 code for the procedure performed. Not available in PRO extract.
93secondary icd-10 code #12;13FREE TEXTThe first secondary ICD-10 code for the procedure performed. Not available in PRO extract.
94secondary icd-10 code #22;14FREE TEXTThe second secondary ICD-10 code for the procedure performed. Not available in PRO extract.
95secondary icd-10 code #32;15FREE TEXTThe third secondary ICD-10 code for the procedure performed. Not available in PRO extract.
96secondary icd-10 code #42;16FREE TEXTThe fourth secondary ICD-10 code for the procedure performed. Not available in PRO extract.
97encounter sc2;17BOOLEANY:YES
N:NO
Indicates if treatment provided during this patient encounter is Service Connected.
98vietnam2;18SET OF CODESY:YES
N:NO
U:UNKNOWN
Indicates if patient is a Vietnam era veteran.
99camp lejeune status2;19BOOLEANY: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.
100encounter camp lejeune2;20BOOLEANY: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.
101combat veteran indicator2;21BOOLEANY:YES
N:NO
Identifies if the patient served in a combat zone.
102combat veteran location2;22FREE TEXTIdentifies the war in which the combat service was incurred.
103form requested on2;23FREE TEXTIdentifies which form was used to enter a prosthetics request.

Not Referenced