Files > ROR HISTORICAL DATA EXTRACTION

name
ROR HISTORICAL DATA EXTRACTION
number
799.6
location
^RORDATA(799.6,
description
Records of this file store parameters of the historical data extractions (backpulls) performed on the registries and reflect status of these data extractions. Records of the file are uniquely identified by the historical data extraction name (the "A" primary key and the uniqueness index "B" are used for that purpose).
Fields
#NameLocationTypeDetailsIndexDescription
.01name(+)0;1FREE TEXTYOU MUST NOT EDIT THIS FIELD IF IT IS PART OF A NATIONAL HISTORICAL DATA EXTRACTION DEFINITION! This field stores the unique name of the historical data extraction. If an extraction is initiated by a patch, it is a good idea to include the patch number.
.02type(+)0;2SET OF CODES1:Auto (HL7 messages)
2:Manual (host files)
YOU MUST NOT EDIT THIS FIELD IF IT IS PART OF A NATIONAL HISTORICAL DATA EXTRACTION DEFINITION! This field defines the type of data extraction. Automatic data extractions are initiated by the CCR patches. Data is extracted by the nightly task and sent via regular batch HL7 messages. Manual data extractions are initiated by the users using the options from the maintenance menu. They schedule the data extraction tasks and verify their completion. Data is written to host files, which are transferred to the AAC via FTP or any other means.
.03start date(+)0;3DATE-TIMEYOU MUST NOT EDIT THIS FIELD IF IT IS PART OF A NATIONAL HISTORICAL DATA EXTRACTION DEFINITION! This field indicates the start date for the historical data extraction.
.04end date0;4DATE-TIMEYOU MUST NOT EDIT THIS FIELD IF IT IS PART OF A NATIONAL HISTORICAL DATA EXTRACTION DEFINITION! This field indicates the end date for the historical data extraction.
.05patients per batch0;5NUMERICYOU MUST NOT EDIT THIS FIELD IF IT IS PART OF A NATIONAL HISTORICAL DATA EXTRACTION DEFINITION! The PATIENTS PER BATCH field holds the maximum number of patients whose data is written into a single historical data extraction output file.
.06maximum message size0;6NUMERICYOU MUST NOT EDIT THIS FIELD IF IT IS PART OF A NATIONAL HISTORICAL DATA EXTRACTION DEFINITION! This field stores the maximum size (in megabytes) of a batch HL7 message that can be sent to Austin Automation Center (AAC). If this field is empty or contains 0, the size is not limited.
.07activation date0;7DATE-TIMEThis field is used only for automatic data extractions. If it is empty, then the nightly task ignores this record completely. Otherwise, the data extraction will not start before the date and time stored in this field.
.08base file name0;8FREE TEXTThe base part for the output file names is stored in this field. It is populated either by a patch or by the user (if they are instructed to do so). The output file names will have the following structure: BASE-SSS-TT.HDT where 'BASE' is the value of this field, 'SSS' is the site number (3 digits), and 'TT' is the sequential number of the task (2 digits). If the task is restarted, the optional numeric modifier '##' (2 digits) will be added to the name so that the already extracted data will not be overwritten: BASE-SSS-TT-##.HDT
.09national0;9BOOLEAN0:NO
1:YES
ONLY AUTHORIZED NATIONAL REGISTRY DEVELOPERS CAN EDIT THIS FIELD! National historical data extractions (backpulls) must have this field set to "YES". This prevents local editing of other fields of the definitions.
1data area1;0MULTIPLE799.61YOU MUST NOT EDIT THIS FIELD IF IT IS PART OF A NATIONAL HISTORICAL DATA EXTRACTION DEFINITION! This multiple lists all data areas in which the data extraction will be performed. It can also contain additional time frames for these data areas.
2output directory2;E1,240FREE TEXTA directory must be created within the file system of the host operating system (VMS, Windows, etc.). Text files containing historical data in the HL7 format will be created in this directory by the data extraction tasks. The full name of the directory must be entered as a value of this field. For example, the value can look something like this: VA2$:[OUTPUT] - VAX VMS D:\Output\ - Windows, MS-DOS Because a file name will be concatenated to the directory name, the trailing slash in the Windows directory name is required. Do not forget to enable read/write access to this directory for M processes!
3registry name3;0MULTIPLE799.63This multiple references the registries that the data extraction will be performed for and indicates the extraction status.
4task4;0MULTIPLE799.64
5statusCOMPUTEDThis field indicates a generic status of the historical data extraction: "" Unknown/Undefined 0 Inactive 1 Pending/Active 2 Completed

Referenced by 1 types

  1. ROR REGISTRY PARAMETERS (798.1) -- automatic backpull