Section 11
Price Maintenance Table

This table allows you to define price changes that will take effect on a future date. It is very useful if your fee schedule changes on a specific date and you want the changes to take effect on that date but want to have to do all the maintenance required in advance.

Setting up the planned price changes is very easy. For the most part, the fields are simply the values that will be updated in the trancodes table on the effective date of the price changes. Each time the RASWIN program starts, on any workstation, it will check the PRICE_MAINTENANCE table for any records that have an EFFECTIVE_DATE equal to the current date. If the STATUS is PENDING then the values in the table for that particular trancode will be applied to the TRANCODES table.

Each of the fields in the PRICE_MAINTENANCE table is explained below.

1. TRAN_CODE
   
   This is the TRAN_CODE that the values apply to. This specific TRAN_CODE must exist in the TRANCODES table in order for the updates to be applied.
   
   No error will occur if the value is not valid, but the changes will not be applied since there is no TRANCODES table record to apply them to.
   
   
2. EFFECTIVE_DATE
   
   This is the date the program will use to determine if it is time to apply the changes defined in the individual PRICE_MAINTENANCE table records. When the program starts, on any workstation, it checks to see if the current date matches the date defined in this field, and if the STATUS is PENDING it will update the values in the TRANCODES table using the values from the PRICE_MAINTENANCE table.
   
   
3. EXPIRES_DATE
   
   This is the value that will be applied to the corresponding field in the trancodes table.
   
   
4. FEE_RULE_CODE
   
   This is the value that will be applied to the corresponding field in the TRANCODES table.
   
   
5. DEFAULT_AMOUNT_1
   
   This is the value that will be applied to the corresponding field in the trancodes table.
   
   
6. DEFAULT_AMOUNT_2
   
   This is the value that will be applied to the corresponding field in the trancodes table.
   
   
7. STATUS
   
   When you add a new record to the PRICE_MAINTENANCE table the STATUS will automatically be set to PENDING. Once the change has been made, it will be set to COMPLETED.
   
   If you want to you can delete the COMPLETED records after they have been applied, or you can just leave them in place to keep a history of exactly which changes have been applied over time.
   
   

Note that the PRICE_MAINTENANCE function does not change the prices in the PROFILE_TRANSACTIONS table. These must be done using normal maintenance procedures.