| # | Name | Location | Type | Details | Index | Description |
|---|---|---|---|---|---|---|
| .01 | extract name(+) | 0;1 | FREE TEXT | B | The name of the extract. | |
| 1 | file number(+) | 0;2 | NUMERIC | AF | The number of the file into which this extract places data. | |
| 2 | frequency | 0;3 | SET OF CODES | D:DAILY W:WEEKLY M:MONTHLY | This field determines the frequency with which this extract will be run. Daily extracts are run for a single day, T-X, where X is the number entered in the DAYS AGO field in this file. Weekly extracts are run for the week ending on T-X. Monthly extracts are run for the previous month. | |
| 3 | days ago(+) | 0;4 | NUMERIC | This field is used for daily and weekly extracts to determine how many days ago the extract should look for data. For daily extracts, the date would be T-X, for weekly extracts, the date range would be from T-X-7 to T-X. | ||
| 4 | routine | ROU;1 | FREE TEXT | The name of the routine which performs this extract. Data is loaded into this field at creation time as should not be edited in the field | ||
| 5 | offset | 0;5 | NUMERIC | This field is used by the local daily extract to determine how many days back to look for data | ||
| 6 | queued | 0;6 | BOOLEAN | 1:YES | This field is set by the software when the extract is queued to run. Once this field is set, other data elements should be changed only with extreme care. Changing either the frequency or the days ago field could result in a date range being missed and not extracted for trasmission to TSI. | |
| 7 | type(+) | 0;7 | FREE TEXT | AC | This is the print name for the extract. It has an important use in supplying a data element to the TYPE field (#2) of the DSS EXTRACT LOG file (#727). | |
| 8 | header code(+) | 0;8 | FREE TEXT | C | The unique 3-letter identifier code for the extract type. Needed for the header record in each extract transmission. | |
| 9 | group(+) | 0;9 | FREE TEXT | This code identifies the data group to which the extract belongs. | ||
| 10 | audit description | 1;0 | WORD-PROCESSING | |||
| 11 | running piece(+) | 0;10 | NUMERIC | This numeric provides the position of the data element which indicates whether an extract of this type is currently running or is queued to run. | ||
| 12 | max. lines per message(+) | 0;11 | NUMERIC | This number is the maximum number of lines per transmission message allowed for this extract type. A default value of 200 is usually acceptable for most extracts. However, for some (e.g., CLI, ADM) lower values are recommended. It may be possible in some cases to set a value greater than 200, thus reducing the total number of transmission messages needed for the extract. However, if the transmission message becomes larger than 32 Kbytes, it will be rejected by AAC. | ||
| 13 | inactive | 0;12 | BOOLEAN | 1:YES 0:NO | Denotes whether or not this extract is considered inactive. |
Not Referenced