RDPWin

 

Audit/Day End - Transfer to Historical Files (DOS-910)

Click here for Night Audit tutorials

Click here for a complete list of audit procedures

Overview

Select Transfer to Historical Files from the System | File Utilities submenu.  In order to keep RDPWin running as quickly as possible old reservations are archived by moving the database records into backup database files so that the main database files are kept small and clean.  This is the RDPWin version of the RDP-DOS 910 Utility.

Checkbox Settings

Keep Cancelled Reservations Until Their Departure Date (Switch 109-11)
See Switch 109-11.
Transfer Reservations to Non-active if Balance is Less than $1.00 (Switch 426-08)
See Switch 426-08.
Keep Reservations for XX Days After Departure Date
See Keep Reservations for details.

Buttons

Transfer All
Transfer all reservations meeting the criteria. When complete, the system prompts with an option to clean-up and optimize the reservation-related database files. This is recommended but optional, since the process can take some time.  Cancelled reservations with active transactions are never deleted but moved to non-active history instead.
Transfer Res
Specify a specific reservation to transfer. NO criteria checks are performed. When the selected reservation is part of a group, the whole group will be transferred.  A warning displays prior to the transfer.
Transfer Res From Non-active
Transfer a reservation back from Non-Active History back to Active.  If you select a Group member it will transfer back the group.
Clean Up Files
Optimize the reservation related database files.  Orphan records are deleted.

Archive Process

The following files are archived:
Active Database File Archive Database File
HReserve BookHist
HExpense HExpHist
ItinCurr ItinHist
HReserveComment BookHistComment
NoteFile

  • HReserve
  • HExpense
  • ItinCurr
 

The system uses the C1 910 record to determine how many days worth of reservations to keep. The number of days must be greater than zero and less than or equal to 365. Reservations with the following status are archived:

The exceptions to these rules are:

Reason Description
Balance Due Not archived when reservation has a balance due on the folio.
Travel Agent Not Processed Not archived when field is blank
Owner Not Processed Not archived when field is blank
Group Reservations When one or more reservations in the group has any of the following, then NO reservations are archived:

  • Reservation has not checked out
  • Folio has a balance due
  • Change Date and Departure Date are not past the transfer date
  • Security Deposit due
  • Travel Agent Not Processed
  • Owner Not Processed
Cancelled Reservation Transactions Not Processed Not archived when PrePostedFlag = Blank and ExplodeFlag900 = blank on any transaction.

 

Switches Affecting Archival

The following are the switches used in the system. Some have UI Security elements that can be overridden to show the actual date such as "Check-outs with a departure and ‘Last Changed By’ date before 01/15/98 will be transferred. OK?".

The checkboxes on the screen cannot be changed but reflect the values of the associated switches. The number of days to keep the reservation is stored in the C1-910 record. The number of days to keep the reservations can be increased but not decreased.  To change the default value, the value in the C1-910 record must be changed.

Switch No. Description
Record C1 910 Keep Reservations for XX Days After Departure Date (Record C1 910)  
Switch 109-11 Keep cancelled reservations until the departure date
  • When checked, cancelled reservations will be transferred or deleted* (depending on Switch 219-14) on the reservation departure date .
  • When NOT checked, cancelled reservations will transferred or deleted* (depending on Switch 219-14)on system date the 910 program is ran.
Switch 426-08 Transfer reservations to non-active when balance is <$1.00.

Note:  Cancelled reservations with processed transactions are NEVER deleted regardless of switch setting. Cancelled reservations with processed transactions are ALWAYS transferred.


Click these links for Frequently Asked Questions or Troubleshooting assistance.

Last Updated 11/10/2008


© 1983-2004 Resort Data Processing, Inc. All rights reserved.