1. One View Reporting User Guide
  2. Special Processing in the Header

Special Processing in the Header

  • Days Past, Days Ahead, and Days to Analyze

    You can define a time period to view contracts that have recently expired or are set to expire soon. You use the Days Past, Days Ahead, and Days to Analyze options and field to control how the expired and expiring columns are populated. These are not filters for the grid column.

    To view contracts that have recently expired, select the Days Past option, and enter the number of days you want to look back in the Days to Analyze field. For example, to view rental contracts that have expired within the last 30 days, select the Days Past option and enter 30 in the Days to Analyze field. The system includes the rental contracts that have expired within the last 30 days in the grid. For expired contracts, the system selects the option in the grid column Expired Contract. Compare the dates the rental contract expired with the actual end date on the contract.

    To view rental contracts that are set to expire soon, select the Days Ahead option and enter the number of days counting from today to the day that you want to look up in the Days to Analyze field. The system considers today as the first day of the days ahead. For expiring contracts, the system selects the option in the grid column Expiring Contract. Compare the expiring dates of the rental contracts with the projected ending date on the contract.

    If you select both the Days Past and the Days Ahead options, the system displays rental contracts that have recently expired and rental contracts that are set to expire, in the grid. You can enter any number between (and including) zero and 366 in the Days to Analyze field.

  • As If Currency Code and As of Exchange Rate Date

    The One View Rental Contract Inquiry application can report on the contract amount in a common currency. You can use the As If Currency Code and As of Exchange Rate Date fields to convert the extended amount from domestic currency to a common currency. The system converts and subsequently populates the As If Extended Amount column in the grid only if the As If Currency Code field has a valid value. The system uses the As of Exchange Rate Date field to get the exchange rate to do the conversion. The As If Currency and As of Exchange Rate Date fields are not filters for the grid column. If you are not using these fields, the conversion will not take place and the As If Extended Amount column will not appear in the grid.