Subject Area : 390 - Business Process Template |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 390 - Business Process Template | Tables that hold definition templates for one or more container that constitute a Business Process Template. | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Logical | Column | ||||||||||||||||||||||||||||||||||||||||||||||||
. | Physical | Column |
# | Physical Name | Name | Logical Only | Do Not Generate | Definition | Attribute/Column | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | bus_proc | Business Process | false | A business process is a set of containers, items, business rules, etc created from a business process template. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | tmpl_package | Template Package | false | A template specification that can be used to create an Item, Container, or Group of Containers. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | tmpl_package_type | Template Package Type | false | A lookup table for the Template Package Type. Values include: BUSINESS_PROCESS, CONTAINER, ITEM | Details.. |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |