CMN_IMPORT_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Configuration Management Import Activity
Definition: Activity table for tracking the import activities of configuration management entities
Table Type: ACTIVITY





Column Detail - CMN_IMPORT_ACTIVITY


Column Name Type Null? Definition
CMN_IMPORT_ACTIVITY_ID DOUBLE N PRIMARY KEY
CMN_IMPORT_TYPE VARCHAR(15) Y The type of Import eg Mpage or views
IMPORT_DT_TM DATETIME Y DATE AND TIME OF THE IMPORT
PERFORMING_PRSNL_ID DOUBLE N The user ID that performed the activity
PROCESS_GUID VARCHAR(50) N GUID for identifying a batch import operation
REPLACEMENT_NAME VARCHAR(150) Y The replacement of the imported or swapped Entity
REPL_PARENT_ENTITY_ID DOUBLE N ID VALUE ASSOCIATED TO THE PK OF THE TABLE IDENTIFIED IN COLUMN REPLACEMENT_PARENT_ENTITY_NAME
REPL_PARENT_ENTITY_NAME VARCHAR(30) N The table from which an ID value is used for REPL_PARENT_ENTITY_ID - either BR_DATAMART_CATEGORY or MP_VIEWPOINT
REQUESTED_NAME VARCHAR(150) Y The requested name of the imported or swapped Entity
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - CMN_IMPORT_ACTIVITY


Child Column in CMN_IMPORT_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: PERFORMING_PRSNL_ID PRSNL PERSON_ID




Parent Column in CMN_IMPORT_ACTIVITY (PK) Child Table Name Child Column Name
Children: CMN_IMPORT_ACTIVITY_ID CMN_NAME_SWAP_ACTIVITY CMN_IMPORT_ACTIVITY_ID


CMN_NAME_SWAP_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Configuration Management Name Swap Activity
Definition: Activity table for tracking the name swap activities of configuration management entities
Table Type: ACTIVITY





Column Detail - CMN_NAME_SWAP_ACTIVITY


Column Name Type Null? Definition
CMN_IMPORT_ACTIVITY_ID DOUBLE N Unique Identifier in CMN_IMPORT_ACTIVITY table used as a parent ID for Name swap activity.
CMN_NAME_SWAP_ACTIVITY_ID DOUBLE N PRIMARY KEY
NAME_SWAP_DT_TM DATETIME Y The date and time the name swap was done
PERFORMING_PRSNL_ID DOUBLE N The User ID that performed the activity
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - CMN_NAME_SWAP_ACTIVITY


Child Column in CMN_NAME_SWAP_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: CMN_IMPORT_ACTIVITY_ID CMN_IMPORT_ACTIVITY CMN_IMPORT_ACTIVITY_ID
PERFORMING_PRSNL_ID PRSNL PERSON_ID


CNFG_CLOB_GTTD



Column Section Top of Page


Table-level Detail

Description: Configuration Management CLOB Global Temp Table
Definition: Used by Smart Template Wizard framework to assist in producing Report documentation
Table Type: ACTIVITY





Column Detail - CNFG_CLOB_GTTD


Column Name Type Null? Definition
CNFG_CLOB LONGTEXT Y A CLOB data type to store report documentation temporarily so it can be edited and combined with other CLOB data
CNFG_CLOB_DT_TM DATETIME Y A column that stores the date/time that the row was inserted into the table.
CNFG_CLOB_FLAG DOUBLE N A column to help denote the status of the CLOB. 0 = No data in CNFG_CLOB column. 1 = The data held in CNFG_CLOB is a portion of total CLOB. 2 = The data held in CNFG_CLOB is complete
CNFG_CLOB_ID DOUBLE Y PRIMARY KEY


CNFG_MGR_GRP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Configuration Manager groups
Definition: Defines the list of groups containing a set of sub groups.
Table Type: REFERENCE





Column Detail - CNFG_MGR_GRP


Column Name Type Null? Definition
CNFG_MGR_GRP_ID DOUBLE N PRIMARY KEY
COLLATION_SEQ DOUBLE N Defines the order sequence of the group.
GRP_KEY_TXT VARCHAR(100) Y Unique string key to identify each group.
PARENT_GRP_ID DOUBLE N Parent group ID of the group.
TITLE_TXT VARCHAR(100) N Name of the group.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CNFG_MGR_GRP


Child Column in CNFG_MGR_GRP(FK) Parent Table Name Parent Column Name
Parents: PARENT_GRP_ID CNFG_MGR_GRP CNFG_MGR_GRP_ID




Parent Column in CNFG_MGR_GRP (PK) Child Table Name Child Column Name
Children: CNFG_MGR_GRP_ID CNFG_MGR_GRP PARENT_GRP_ID
CNFG_MGR_TOOL CNFG_MGR_GRP_ID


CNFG_MGR_TOOL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Configuration Manager tool
Definition: Provides information about a tool and its parent group in Configuration Manager
Table Type: REFERENCE





Column Detail - CNFG_MGR_TOOL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CNFG_MGR_GRP_ID DOUBLE N ID of parent group
CNFG_MGR_TOOL_ID DOUBLE N PRIMARY KEY
COLLATION_SEQ DOUBLE N Defines the order of the tools for a tool
HELP_TXT VARCHAR(500) N Help Text - Describes what tool does.
REPORT_NAME VARCHAR(100) N Name of the script to call when opening the tool.
REPORT_PARAM VARCHAR(255) N Describes what parameters to pass into the script when opening a tool.
TITLE_TXT VARCHAR(100) N Unique value which is the NAME of the Tool
TOOL_KEY_TXT VARCHAR(100) N Unique string key to identify each tool.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CNFG_MGR_TOOL


Child Column in CNFG_MGR_TOOL(FK) Parent Table Name Parent Column Name
Parents: CNFG_MGR_GRP_ID CNFG_MGR_GRP CNFG_MGR_GRP_ID