Footprints Data Model

Table
Table Name Data Mart Request History
Table Definition A history table detailing the results of Data Mart request execution. It is also used to report the last run of the data mart on data mart reports. It may need to be purged from time to time as each request is logged even if no updates occur, and the frequency defaults to 10 minutes.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Data Mart Request History Id The automatically generated primary key of the data_mart_rqst_history table. LONG Yes
Item Definition Id A Foreign Key to the Definition table. LONG No
Data Mart Request State Id A Foreign Key to the Data Mart Request State table. INTEGER No
Request Begin Date Request Begin Date DATE No
Request Begin Date UTC String Begin Date as a UTC string to avoid JDBC/Hibernate errors. VARCHAR(23) No
Request End Date End Date DATE No
Request End Date UTC String End Date as a UTC string to avoid JDBC/Hibernate errors. VARCHAR(23) No
Data Mart Request Type Id A Foreign Key to the Data Mart Request Type table. INTEGER No