Subject Area : 390 - Business Process Template
Subject Area Name Definition
390 - Business Process Template Tables that hold definition templates for one or more container that constitute a Business Process Template.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
bus_proc Business Process false A business process is a set of containers, items, business rules, etc created from a business process template.
Physical Name Attribute/Column Name Definition Physical Data Type
bus_proc_id Business Process Id The automatically generated primary key of the bus_proc table. bigint
bus_proc_name Business Process Name The name of the Business Process. nvarchar(4000)
bus_proc_descr Business Process Description A descriptive name of the Business Process. This descriptive name may be localized. nvarchar(4000)
bus_proc_tmpl_id Business Process Template Id A Foreign Key to the Template Package table. bigint
bus_proc_defn Business Process Definition false The collection of definitions associated with a business process that was created as a result of using a business process template to create a business process.
Physical Name Attribute/Column Name Definition Physical Data Type
bus_proc_defn_id Business Process Definition Id The automatically generated primary key of the bus_proc_defn table. bigint
bus_proc_id Business Process Id A Foreign Key to the Business Process table. bigint
defn_id Definition Id A Foreign Key to the Definition table. bigint
defn Definition false A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id The automatically generated primary key of the defn table. bigint
defn_name Definition Name The name of the Definition. nvarchar(4000)
dsble_date Disabled Date The date that this instance of Definition is logically deleted and disabled. datetime
defn_guid Definition GUID A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
defn_type_name Definition Type Name The unique string identifier for an instance of Definition 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)
defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
tmpl_export_guid Template Export GUID The value of a Definition, stored as a string. VARCHAR(50)
defn_subtype Definition Subtype false The subtype of the definition used as a discriminator for the class of definition. Each subtype will have different configuration settings and associated definitions. These include associated built-in field definitions for item subtypes. See the database view v_defn_subtype.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_subtype_name Definition Subtype Name The name of the Definition Subtype. varchar(255)
defn_subtype_descr Definition Subtype Description A descriptive name of the Definition Subtype. This descriptive name may be localized. varchar(512)
defn_subtype_id Definition Subtype Id The automatically generated primary key of the defn_subtype table. int
defn_parent_subtype_id definition parent subtype id A Foreign Key to the Definition Subtype table. int
defn_type_name Definition Type Name The unique string identifier for an instance of Definition 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)
max_in_parent Maximum In Parent A Foreign Key to the Definition Subtype table. int
tmpl_package Template Package false A template specification that can be used to create an Item, Container, or Group of Containers.
Physical Name Attribute/Column Name Definition Physical Data Type
tmpl_package_id Template Package Id The automatically generated primary key of the tmpl_package table. bigint
tmpl_package_content Template Package Content The value of a Template Package, stored as a long text object. varchar(max)
tmpl_package_name Template Package Name The name of the Template Package. varchar(255)
tmpl_package_type_id Template Package Type Id A Foreign Key to the Template Package Type table. int
defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
is_sys_tmpl Is System Template Indicates if Is System Template. bit
tmpl_package_intrnl_name Template Package Internal Name The value of a Template Package, stored as a string. varchar(255)
tmpl_package_type Template Package Type false A lookup table for the Template Package Type. Values include: BUSINESS_PROCESS, CONTAINER, ITEM
Physical Name Attribute/Column Name Definition Physical Data Type
tmpl_package_type_id Template Package Type Id The automatically generated primary key of the tmpl_package_type table. int
tmpl_package_type_name Template Package Type Name The name of the Template Package Type. varchar(255)