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 |