| # | Name | Location | Type | Details | Index | Description |
|---|---|---|---|---|---|---|
| .01 | sequence number(+) | 0;1 | NUMERIC | The record number for this extract entry. | ||
| 1 | year month | 0;2 | FREE TEXT | A six character string representing the year and the month for which this extract was performed. | ||
| 2 | extract number | 0;3 | POINTER | 727 | AC | The corresponding entry in the DSS EXTRACT LOG file (#727) for this extract. |
| 3 | facility | 0;4 | POINTER | 40.8 | This is the medical center division where the extract was performed. | |
| 4 | patient no. - dfn | 0;5 | POINTER | 2 | An identifying number for the patient at the local site. | |
| 5 | ssn | 0;6 | FREE TEXT | The patient's social security number. | ||
| 6 | name | 0;7 | FREE TEXT | The first four characters of the patient's last name. | ||
| 7 | in out patient indicator | 0;8 | SET OF CODES | I:INPATIENT O:OUTPATIENT | Indicates whether the patient was an inpatient or an outpatient for this extract entry. | |
| 8 | day | 0;9 | FREE TEXT | This 8-character string represents the date on which the Unit Dose event (dispense or return) occurred. | ||
| 9 | va drug classification | 0;10 | FREE TEXT | The VA Drug Classification for the item in this order. | ||
| 10 | quantity | 0;11 | NUMERIC | Drug quantity dispensed in the unit of issue for that drug. Unit of issue may vary from product to product and site to site. | ||
| 11 | ward | 0;12 | POINTER | 44 | Current ward where the patient is located when patient is an inpatient. | |
| 12 | provider | 0;13 | FREE TEXT | The provider assigned to this patient. | ||
| 13 | cost | 0;14 | NUMERIC | VA pharmacy supply cost of drug dispensed. | ||
| 14 | movement file # | 0;15 | POINTER | 405 | Current patient movement record associated with this extract record. | |
| 15 | treating specialty | 0;16 | FREE TEXT | The PTF CODE of the treating specialty associated with this extract record. | ||
| 16 | ndc | 0;17 | FREE TEXT | This is the National Drug Code for the drug/supply item in this order. | ||
| 17 | new feeder key | 0;18 | FREE TEXT | Code that uniquely identifies a DSS drug/supply product. | ||
| 18 | dea, special hdlg | 0;19 | SET OF CODES | I:INVESTIGATIONAL 1:SCHEDULE 1 ITEM 2:SCHEDULE 2 ITEM 3:SCHEDULE 3 ITEM 4:SCHEDULE 4 ITEM 5:SCHEDULE 5 ITEM | Indicates if the drug in this record is Investigational, or Schedule 1-5. | |
| 19 | udp time | 0;20 | FREE TEXT | Time that the drug was dispensed. | ||
| 20 | admission date | 0;21 | FREE TEXT | This 8-character numeric string represents the date on which the patient's admission occurred. | ||
| 21 | admission time | 0;22 | FREE TEXT | Time of day at which the patient admission occurred. | ||
| 22 | master patient index | 1;1 | FREE TEXT | Unique national VA patient identifier. | ||
| 23 | dss product department | 1;2 | FREE TEXT | The nationally defined DSS Intermediate Department Number designated to the Pharmacy care product. | ||
| 24 | placeholder | 1;3 | FREE TEXT | Currently NULL. | ||
| 25 | dom,prrtp and saartp indicator | 1;4 | SET OF CODES | P: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. | |
| 26 | observation patient indicator | 1;5 | SET OF CODES | NO:NO YES:YES | Indicates if patient is considered to be an observation patient. | |
| 27 | encounter number | 1;6 | FREE TEXT | The unique number assigned to each encounter within DSS. | ||
| 28 | production division code | 1;7 | FREE TEXT | Identifies the division/facility where the work was performed. | ||
| 29 | means test | 1;8 | SET OF CODES | A:CATEGORY A B:CATEGORY B C:CATEGORY C P:PENDING ADJUCATION 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. | |
| 30 | eligibility | 1;9 | FREE TEXT | Appropriate eligibility code based on veteran or non-veteran status. | ||
| 31 | date of birth | 1;10 | FREE TEXT | Patient's date of birth. | ||
| 32 | sex | 1;11 | SET OF CODES | M:MALE F:FEMALE | Patient's gender. | |
| 33 | state | 1;12 | FREE TEXT | The state in which the patient resides. | ||
| 34 | county | 1;13 | FREE TEXT | The county in which the patient resides. | ||
| 35 | zip+4 | 1;14 | FREE TEXT | The ZIP code for where the patient resides. The 5-character ZIP code is provided if ZIP+4 is not available. | ||
| 36 | veteran | 1;15 | BOOLEAN | Y:YES N:NO | Patient's veteran status. | |
| 37 | period of service | 1;16 | FREE TEXT | The period of service that best classifies the patient based on eligibility code. | ||
| 38 | pow status | 1;17 | SET OF CODES | Y:YES N:NO U:UKNOWN | Indicates if patient was confined as a Prisoner of War. | |
| 39 | pow location | 1;18 | POINTER | 22 | If 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 | |
| 40 | radiation status | 1;19 | SET OF CODES | Y:YES N:NO U:UNKNOWN | Indicates if patient claims exposure to ionizing radiation. | |
| 41 | agent orange status | 1;20 | SET OF CODES | Y:YES N:NO U:UNKNOWN | Indicates whether patient was exposed to Agent Orange. | |
| 42 | agent orange location | 1;21 | SET OF CODES | K:KOREAN DMZ V:VIETNAM O:OTHER | Indicates the location where the patient was exposed to Agent Orange. | |
| 43 | purple heart indicator | 1;22 | BOOLEAN | Y:YES N:NO | Indicates whether or not a patient is a Purple Heart recipient. | |
| 44 | mst status | 1;23 | SET OF CODES | Y: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. | |
| 45 | cnh status | 1;24 | SET OF CODES | YES:YES NO:NO | This field is used to indicate whether a patient is currently in a contract nursing home. | |
| 46 | enrollment location | 1;25 | FREE TEXT | The facility that the patient chooses to designate as his preferred location for care. | ||
| 47 | enrollment category | 1;26 | SET OF CODES | E:Enrolled N:Not Enrolled P:In Process | Patient's enrollment category. | |
| 48 | enrollment status | 1;27 | POINTER | 27.15 | Patient's enrollment status. | |
| 49 | shad status | 1;28 | SET OF CODES | Y:YES N:NO U:UNKNOWN | Indicates whether patient meets requirements for Shipboard Hazard and Defense (SHAD). | |
| 50 | primary care team | 1;29 | FREE TEXT | The primary care team assigned to this patient. | ||
| 51 | primary care provider | 1;30 | FREE TEXT | The primary care provider assigned to this patient through the PCMM module. | ||
| 52 | placeholder | 1;31 | FREE TEXT | Currently NULL. | ||
| 53 | pc provider person class | 1;32 | FREE TEXT | The VA code of the Person Class of the Primary Care Provider. | ||
| 54 | associate pc provider | 1;33 | FREE TEXT | The associate primary care provider assigned to this patient through the PCMM module. | ||
| 55 | placeholder | 1;34 | FREE TEXT | Currently NULL. | ||
| 56 | assoc. pc prov. person class | 1;35 | FREE TEXT | The VA code of the Person Class of the Associate Primary Care Provider as of the date of this extract record. | ||
| 57 | ordering date | 2;1 | FREE TEXT | The date the order was first dispensed. | ||
| 58 | ordering stop code | 2;2 | FREE TEXT | This field contains the stop code associated with the order. | ||
| 59 | head & neck cancer indicator | 2;3 | BOOLEAN | Y:YES N:NO | Identifies whether patient has head and/or neck cancer. | |
| 60 | ethnicity | 2;4 | FREE TEXT | The patient's PTF Ethnicity code. | ||
| 61 | race 1 | 2;5 | FREE TEXT | Self-reported by patient as recorded in VistA patient file. | ||
| 62 | placeholder | 2;6 | POINTER | 50 | Currently NULL. This field is not currently used. | |
| 63 | placeholder | 2;7 | NUMERIC | Currently NULL. This field is not currently used. | ||
| 64 | placeholder | 2;8 | FREE TEXT | Currently NULL. This field is not currently used. | ||
| 65 | placeholder | 2;9 | FREE TEXT | Currently NULL. This field is not currently used. | ||
| 66 | ordering provider person class | 2;10 | FREE TEXT | The VA code of the Person Class of the Ordering Provider as of the date of this extract record. | ||
| 67 | dss ip # | 2;11 | NUMERIC | The nationally defined DSS Intermediate Product Number designated to the patient care product. | ||
| 68 | enrollment priority | 2;12 | FREE TEXT | This field contains the enrollment priority group and the enrollment priority subgroup. | ||
| 69 | user enrollee | 2;13 | SET OF CODES | U:USER ENROLLED | Indicates whether a Veteran has User Enrollee status for the current or future fiscal year. | |
| 70 | patient type | 2;14 | SET OF CODES | AC: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. | |
| 71 | cv status eligibility | 2;15 | SET OF CODES | Y: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. | |
| 72 | cv eligibility end date | 2;16 | FREE TEXT | Records 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 | ||
| 73 | encounter cv | 2;17 | BOOLEAN | Y: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. | |
| 74 | national patient record flag | 2;18 | BOOLEAN | Y:YES | This field records whether the patient's record contains 1 or more active category 1 (National) Patient Record Flags. | |
| 75 | eri | 2;19 | FREE TEXT | This field identifies patients from impacted zip code areas designated by the Federal Emergency Management Agency (FEMA). | ||
| 76 | sw asia conditions | 2;20 | SET OF CODES | Y:YES N:NO U:UNKNOWN | This field is used to indicate if this visit represents treatment of a VA patient claiming exposure to Southwest Asia Conditions. | |
| 77 | oef/oif | 2;21 | FREE TEXT | The 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. | ||
| 78 | oef/oif return date | 2;22 | FREE TEXT | The date the patient left the OEF/OIF area, if known. Otherwise, it is the end date of military pay for this OEF/OIF deployment. This date field has a format equal to YYYYMMDD. | ||
| 79 | associate pc provider npi | 2;23 | FREE TEXT | A standard unique life-long identifier of the associate primary care provider. This field has a length of fifteen characters. | ||
| 80 | primary care provider npi | 2;24 | FREE TEXT | A standard unique life-long identifier of the primary care provider. This field has a length of fifteen characters. | ||
| 81 | provider npi | 2;25 | FREE TEXT | A standard unique life-long identifier of the individuals providing health care services. This field has a length of fifteen characters. | ||
| 82 | country code | 2;26 | FREE TEXT | The code for the country associated with the address. | ||
| 83 | patcat | 2;27 | SET OF CODES | AD: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. | |
| 84 | encounter sc | 2;28 | BOOLEAN | Y:YES N:NO | Indicates if treatment provided during this patient encounter is Service Connected. | |
| 85 | camp lejeune status | 2;29 | BOOLEAN | Y: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. | |
| 86 | encounter camp lejeune | 2;30 | BOOLEAN | Y: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. | |
| 87 | combat veteran indicator | 2;31 | BOOLEAN | Y:YES N:NO | Identifies if the patient served in a combat zone. | |
| 88 | combat veteran location | 2;32 | FREE TEXT | Identifies the war in which the combat service was incurred. | ||
| 89 | new script | 2;33 | BOOLEAN | Y:YES N:NO | Identifies those UDP pharmacy transactions where the pharmacist reviewed the patient's medications before a new prescription was filled or an existing one renewed. |
Not Referenced