Subject Area : 390 - Business Process Template
Subject Area(s) of Model "Renoir Domain Model Detail"
# 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..
ER Diagram(s) of Subject Area "390 - Business Process Template"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "390 - Business Process Template"
# 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..
Attribute/Column(s) of Entity/Table "Business Process"
# 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
Attribute/Column(s) of Entity/Table "Business Process Definition"
# 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
Attribute/Column(s) of Entity/Table "Definition"
# 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)
Attribute/Column(s) of Entity/Table "Definition Subtype"
# 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
Attribute/Column(s) of Entity/Table "Template Package"
# 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)
Attribute/Column(s) of Entity/Table "Template Package Type"
# 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)