When the conversion routine inserts the second record it will alter the expiry date of the first record already on the software table. The new expiry date will be set to the effective date of the current record minus one day. If the value of the expiry date of the existing record was after the expiry date of the new record, a gap in time of the date-sensitive table will be created. In order to resolve the gaps in time that are generated by loading these effective date-sensitive records in the software tables, an additional script must be run. Each date-sensitive table has a date adjustment script that can be accessed from the Utility menu of the Conversion Application. These adjustment scripts MUST be run for each date-sensitive table that is loaded with conversion data. These scripts will adjust the records within the P2K tables, not the interface tables. The expiry date of each record is altered to fill in the gaps generated by the effective date records. Since the effective date cannot be altered, record number one in the diagram will not be changed. Instead, a new record will be created to fill the gap in time. The new record will have an effective date of the Beginning of time, and an expiry date of the day prior to the effective date of record number one.
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation