Footprints Data Model

Table
Name data_load_type
Comment 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.

Column
Name Datatype Comment Is PK Is FK
data_load_type_name varchar(20) The name of the Data Load Type. Yes No
load_proc_suffix varchar(30) The name of the Data Load Type. No No
data_load_type_descr varchar(512) A descriptive name of the Data Load Type. This descriptive name may be localized. No No