Files > DSS EXTRACTS

name
DSS EXTRACTS
number
728
location
^ECX(728,
description
This file contains various data extract information utilized by the DSS Extracts software. This data includes the last date an extract was run, the Austin queue receiving the extract data, and extract setup information. Data in this file should be entered and edited only by using the DSS software and not by direct access via VA FileMan. **TECH NOTE** When adding a new extract, make sure that the "LAST DATE XXX" is on same piece of the 7 node as the "XXX" field is on the 7.1 node.
Fields
#NameLocationTypeDetailsIndexDescription
.01name(+)0;1POINTER4BThis field contains a pointer to the corresponding location (station number) entry in the INSTITUTION file (#4).
.5lab lmipLMIP;1BOOLEAN0:NO
1:YES
This field is a flag that indicates whether a facility is ready to send LMIP codes for the LAB Extract. To answer "YES" to this question, the site must be able to answer "YES" to BOTH of the following questions: 1. They are in DSS Implementation Round 5 or higher, OR they are in IR1 through IR4 and are extracting data for FY97 or beyond. 2. All Lab CO directives for LMIP have been completed at their facility. This means that their Lab Service has matched all entries in the LABORATORY TEST file (#60) to an LMIP code and therefore they are ready to use the new DSS LAB Extract version that sends only the LMIP codes to DSS for their initial LAB Feeder Key Values. **NOTE** Once this field is set to "YES", the facility is not asked any of these questions again and will automatically use the new DSS LAB Extract version for all future extracts.
7last date lab7;1DATE-TIMEThis field contains the last date that Laboratory information was extracted to the DSS software.
8last date op pharmacy7;2DATE-TIMEThis field contains the last date that Outpatient Pharmacy information was extracted to the DSS software.
9last date ec7;3DATE-TIMEThis field contains the last date that Event Capture information was extracted to the DSS software.
10last date adt7;4DATE-TIMEThis field contains the last date that MAS admission/discharge/transfer information was extracted to the DSS software.
11last date surgery7;5DATE-TIMEThis field contains the last date that Surgery information was extracted to the DSS software.
12last date radiology7;6DATE-TIMEThis field contains the last date that Radiology information was extracted to the DSS software.
13last date nursing7;7DATE-TIMEThis field contains the last date that Nursing information was extracted to the DSS software.
14last date ud meds7;8DATE-TIMEThis field contains the last date that Pharmacy Unit Dose information was extracted to the DSS software.
15last date dental7;9DATE-TIMEThis field contains the last date that Dental information was extracted to the DSS software.
16last date ifcap7;10DATE-TIMEThis field contains the last date that IFCAP/DSS Unit information was extracted to the DSS software.
17last date clinic visits7;11DATE-TIMEThis field contains the last date that Clinic Visits information was extracted to the DSS software.
18last date ward stock7;12DATE-TIMEThis field contains the last date that Ward Stock information was extracted to the DSS software.
19last date admissions7;13DATE-TIMEThis field contains the last date that Patient Admissions information was extracted to the DSS software.
20last date movement7;14DATE-TIMEThis field contains the last date that Patient Movement information was extracted to the DSS software.
21last date no shows7;15DATE-TIMEThis field contains the last date that Clinic No-Shows information was extracted to the DSS software.
22lab7.1;1SET OF CODESR:RUNNING
This field contains data if the Laboratory extract is currently running.
23op7.1;2SET OF CODESR:RUNNING
This fields contains data if the Outpatient Pharmacy extract is currently running.
24ec7.1;3SET OF CODESR:RUNNING
This field contains data if the Event Capture extract is currently running.
25surgery7.1;5SET OF CODESR:RUNNING
This field contains data if the Surgery extract is currently running.
26radiology7.1;6SET OF CODESR:RUNNING
This field contains data if the Radiology extract is currently running.
27nursing7.1;7SET OF CODESR:RUNNING
This field contains data if the Nursing extract is currently running.
28ud7.1;8SET OF CODESR:RUNNING
This field contains data if the Pharmacy Unit Dose extract is currently running.
29adt7.1;4SET OF CODESR:RUNNING
This field contains data if the MAS Admission/Discharge/Transfer extract is currently running.
30dental7.1;9SET OF CODESR:RUNNING
This field contains data if the Dental extract is currently running.
31ifcap7.1;10SET OF CODESR:RUNNING
This field contains data if the IFCAP/DSS Unit extract is currently running.
32clinic7.1;11SET OF CODESR:RUNNING
This field contains data if the Clinic Visit extract is currently running.
33ward stock7.1;12SET OF CODESR:RUNNING
This field contains data if the Ward Stock extract is currently running.
34admissions7.1;13SET OF CODESR:RUNNING
This field contains data if the Patient Admissions extract is currently running.
35moves7.1;14SET OF CODESR:RUNNING
This field contains data if the Patient Movements extract is currently running.
36no show7.1;15SET OF CODESR:RUNNING
This field contains data if the Clinic No-Show extract is currently running.
37last date ivs7;16DATE-TIMEThis field contains the last date that the Pharmacy IV information was extracted to the DSS software.
38ivs7.1;16SET OF CODESR:RUNNING
This field contains data if the Pharmacy IV extract is currently running.
39last date treating specialty7;17DATE-TIMEThis field contains the last date that the Treating Specialty Change information was extracted to the DSS software.
40treating spec7.1;17SET OF CODESR:RUNNING
This field contains data if the Treating Specialty Change extract is currently running.
41last date ifcap summary7;18DATE-TIMEThis field contains the last date that IFCAP Summary information was extracted to the DSS software.
42ifcap summary7.1;18SET OF CODESR:RUNNING
This field comntains data if the IFCAP Summary extract is currently running.
43last date iv detail7;19DATE-TIMEThis field contains the last date that the Pharmacy IV Detail information was extracted to the DSS software.
44iv detail7.1;19SET OF CODESR:RUNNING
This field contains data if the Pharmacy IV Detail extract is currently running.
45setup dateS;1DATE-TIMEThis field contains the last date that the Setup information was extracted to the DSS software.
46setup runningS;2SET OF CODESR:RUNNING
This field contains data if the Setup extract is running.
47last date pai7;20DATE-TIMEThis field contains the last date that the PAI information was extracted to the DSS software.
48pai7.1;20SET OF CODESR:RUNNING
This field contains data if the PAI extract is currently running.
49austin queue nameQUEUE;1FREE TEXTThe name of the queue in Austin to which DSS data will be sent. This should be of the two characters DM followed by a single upper case letter.
50last date lab results7;21DATE-TIMEThis field contains the last date that the Laboratory Results information was extracted to the DSS software.
51lab results7.1;21SET OF CODESR:RUNNING
This field contains data if the Laboratory Results extract is currently running.
52recipientR1;1DATE-TIMEThis field contains the last date that the Recipient information was extracted to the Rational Meds software.
53providerR1;2DATE-TIMEThis field contains the last date that the Provider information was extracted to the Rational Meds software.
54pharmacyR1;3DATE-TIMEEnter the last date that Hospital Claim information was extracted.
55hospitalR1;4DATE-TIMEThis field contains the last date that the Hospital Claim information was extracted to the Rational Meds software.
56iv claimR1;5DATE-TIMEThe last date for which the Rational Meds IV claim was extracted.
57last date quasar7;22DATE-TIMEThis field contains the last date that Audiology and Speech Pathology information was extracted to the DSS software.
58quasar7.1;22SET OF CODESR:RUNNING
This field contains data if the QUASAR extract is currently running.
59last date prosthetics1;0MULTIPLE728.059This sub-file/field contains DSS Prosthetics divisions and their respective LAST DATE(s) extracted.
60prosthetics7.1;23SET OF CODESR:RUNNING
This field contains data if the PROSTHETICS extract is currently running.
61last date mental health7;24DATE-TIMEThe last date for which Mental Health data was extracted.
62mental health7.1;24SET OF CODESR:RUNNING
If the Mental Health extract is running or queued to run, that is indicated here.
63last date clinic i7;25DATE-TIMEThe last date for which Clinic Visit data was extracted.
64clinic i7.1;25SET OF CODESR:RUNNING
If the Clinic Visit extract is running or queued to run, that will be indicated here.
65last date clinic ii7;26DATE-TIMELast date for which Clinic Visit data was extracted.
66clinic ii7.1;26SET OF CODESR:RUNNING
If the Clinic Visit extract is running or queued to run, it will be indicated here.
67austin test queue nameQUEUE;2FREE TEXTThe name of the test queue in Austin to which DSS data will be sent. This should be 3 upper case letters and can not be the same value as AUSTIN QUEUE NAME (field #49).
68cboc report viewed indicator2;0MULTIPLE728.068
69last date lbb7;27DATE-TIMEThis field contains the last date that blood bank data was extracted to the DSS software.
70lbb status7.1;27SET OF CODESR:RUNNING
Used to inform the user that the extract is presently running.
71last date nut7;28DATE-TIMEThis field contains the last date that nutrition data was extracted to the DSS software.
72nut status7.1;28SET OF CODESR:RUNNING
Used to inform the user that the extract is presently running.
73fy versionS;3FREE TEXTThis field identifies the site as a test site for a DSS Fiscal Year Conversion patch. Only such a test site may allow users to perform testing extracts via menu option ECX FISCAL YEAR EXTRACT. When a new version of a DSS Fiscal Year Conversion patch is installed at the site, this field will be automatically updated as long as the patch install calls TESTON^ECXTREX as part of the post-installation process. When the nationally released version of the DSS Fiscal Year Conversion patch is installed, this field will be automatically updated with the released version's sequence number. Layout = patch#fy year#released patch sequence number.
74bcm7.1;29SET OF CODESR:RUNNING
75last date bcm7;29DATE-TIME

Not Referenced