Footprints Data Model

Table
Table Name Data Load Type
Table Definition A lookup table for the load type. Values include: FULL_LOAD Full deletion and re-adding of item data in the data mart INCR_LOAD Incremental deletion and re-adding of item data changed in the data mart.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Data Load Type Name The name of the Data Load Type. VARCHAR(20) Yes
Data Load Type Description A descriptive name of the Data Load Type. This descriptive name may be localized. VARCHAR(512) No
Load Process Suffix The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. VARCHAR(30) Yes