TDM Portal: Which gtrep database tables are used for recording a reservation

book

Article ID: 223913

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Which gtrep database tables are used for recording a reservation. 

Environment

Release : 4.9

Component : Web Portal - Find & Reserve

Resolution

The main table in the gtrep database that has the userid, start date, end date, project and version is test_data_reservation.
The objects that are reserved are stored in the gtrep table test_data_reservation_lob
In test_data_reservation_lob there is one record for all objects reserved in the reservation.
If Data Prefetch is set to off, there is also a table <column>_reservations in the same database that has the data.
For example dept_reservation if the main column for the reservation is dept.
It has one record for each dept key that has a reservation.