.01 | record number(+) | 0;1 | NUMERIC | | B | The record numbers will be sequential and be reused at some point
in the future. |
1 | extract date | 0;2 | DATE-TIME | | AC | The date the DSS extract was run. |
2 | type | 0;3 | FREE TEXT | | AD | The type of extract that was run. Example: Admission for MAS Admission
extract. |
3 | start date/time | 0;4 | DATE-TIME | | AE | The beginning date covered by the extract. |
4 | end date/time | 0;5 | DATE-TIME | | | The ending date covered by the extract. |
5 | number of records | 0;6 | NUMERIC | | | The number of records included in this extract. |
6 | header for message | HEAD;1 | FREE TEXT | | E | The header for the extract run. Example: ADMISSIONS/DEMOG for the
MAS Admissions extract. |
7 | file number | FILE;1 | NUMERIC | | | An indicator (pointer) of the file in ECX in which the data for this
extract can be found. |
8 | group | GRP;1 | FREE TEXT | | | The mail group to which this extract summary message was sent.
The actual mail group name will be "DSS-"group name.
Example: ADM for the mail group DSS-ADMS for the MAS Admission
extract. |
9 | purged | PURG;1 | DATE-TIME | | | The date on which the data for this extract was deleted from the local
extract file. |
10 | other ifcap extract | IFCAP;1 | POINTER | 727 | | The combined IFCAP extract consists of two separate extracts, the
detailed extract and the summary extract. This field is used to
link the two so that they can be purged simultaneously. Like all
fields in this file, it is set by the extract routines and should
not be edited. |
11 | queued | Q;1 | NUMERIC | | | This field will contain the number of the task (ZTSK) for this queued
transmission. It is set by the transmit routine (ECXTRANS) when the
job is queued and cleared by the same routine when the transmission is
completed. This field should not be edited directly via VA FileMan. |
12 | local extract | L;1 | SET OF CODES | L:LOCAL
| | This field will be set for any extract designed to be transmitted to
some local non-DHCP database rather than to the commercial vendor
database. If this field is set, this extract can not be chosen for
transmission to the commercial vendor. |
13 | version | VER;1 | FREE TEXT | | | This field contains a version identifier to be used as part of
the header in transmissions to Austin. It can then be used by
the SAS programs at Austin to change the processing logic as
versions change. |
14 | extract logic | VER;2 | FREE TEXT | | | Fiscal year extract logic used when extracting the data. Format of is the
extract year + an optional revision denotion (ex: "2004", "2004A",
"20041"). Note that "2004" and "2004 " are considered the same value. |
15 | division(+) | DIV;1 | POINTER | 4 | | This field indicates the division of the user that generated the extract.
This field will also indicate the division from which information was
extracted for prosthetics extracts. |
16 | user | 0;7 | POINTER | 200 | | Internal Entry Number (IEN) from the New Person File (#200) of the user
that ran the specified extract. |
300 | transmitted | TR;1 | DATE-TIME | | AT | This field is set when the entries for this file are transmitted to
the commercial vendor. This field and the cross reference are
essential for managing and purging data in this file. |
301 | message number | 1;0 | MULTIPLE | 727.0301 | | This multiple holds the message numbers sent to the Austin Automation
Center for this extract. |