Footprints Data Model

Table
Table Name Dynamic Table Script Type
Table Definition The type of Dynamic Table script, which is important for locating and re-running the script if need be. Examples include: Activity Data Mart Creation, Status Change Data Mart Creation. Generally, the scripts can be run post level (container, Item) creation using the Type Order and then the Script Order.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Dynamic Table Script Type Id The automatically generated primary key of the dyn_table_script_type table. LONG Yes
Dynamic Table Script Type Name The unique string identifier for an instance of Dynamic Table Script Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. VARCHAR(255) No
Dynamic Table Script Type Description A descriptive name of the Dynamic Table Script Type. This descriptive name may be localized. VARCHAR(512) No
Type Sort Order A sort number used to order a list of Dynamic Table Script Type. INTEGER No