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