RECORD_TYPE String Identifies what information is stored in each row. The four available record types are: Last Good File the file name of last successful – Datamart extract Window Date The start date/time of the – 20 - processing window for last successful extract Window End Date– The end date/time of the processing window for last successful extract Line Count as separate line for each file contained in the – current extract FILE_NAME String For the Last_Good_File row, this field contains the Name of last successful Datamart extract (ie 50 - AppianDatamart_yymmdd_hhmmss.zip) For each Line Count row, this field contains the name of each data file in the current extract PHYSICAL_LINE_COUNT Integer Contains a physical row count of the number of rows in 10 0 each extract file. Design Rules: A processor will be run on completion of extraction of all current Datamart extract files that will determine a row count for each file. The row count that is indicated in the control file against each file type will be the physical row count in the csv file, including the header row. The record type Last_Good_File will contain the name of the last successful Datamart extract followed by the Window_Start_Date and Window_End_Date which defined the duration of the processing window for that file. After this, the names of each file contained in current extract will be listed against a Line_Count record type, sorted in ascending file name order. The time stamp of current extract will be shown against each current extract line, as will the row count of each file.
RECORD_TYPE String 20 - Identifies what information is stored in each row. The four available record types are: Last Good File – the file name of last successful Datamart extract Window Date – The start date/time of the processing window for last successful extract Window End Date– The end date/time of the processing window for last successful extract Line Count – as separate line for each file contained in the current extract FILE_NAME String 50 - For the Last_Good_File row, this field contains the Name of last successful Datamart extract (ie AppianDatamart_yymmdd_hhmmss.zip) For each Line Count row, this field contains the name of each data file in the current extract PHYSICAL_LINE_COUNT Integer 10 0 Contains a physical row count of the number of rows in each extract file. Design Rules: A processor will be run on completion of extraction of all current Datamart extract files that will determine a row count for each file. The row count that is indicated in the control file against each file type will be the physical row count in the csv file, including the header row. The record type Last_Good_File will contain the name of the last successful Datamart extract followed by the Window_Start_Date and Window_End_Date which defined the duration of the processing window for that file. After this, the names of each file contained in current extract will be listed against a Line_Count record type, sorted in ascending file name order. The time stamp of current extract will be shown against each current extract line, as will the row count of each file.
ConSol_Datamart_Specification_v5.1.docx