Table Detail Report

DM_FLAGS_LOCAL



Column Section Top of Page


Table-level Detail

Description: DM_FLAGS_LOCAL
Definition: This is a duplicate (clone) of the DM_FLAGS table in the Admin DB. It will be used by solution code to look up column flag values and definition.
Table Type: REFERENCE





Column Detail - DM_FLAGS_LOCAL


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) N The FLAG or TFLG column being documented
DEFINITION VARCHAR(500) Y A long definition of he FLAG or TFLG column
DESCRIPTION VARCHAR(80) Y A short description of the flag value for a FLAG column or the textual value for the TFLG column
FLAG_VALUE DOUBLE N The numeric flag value associated to the FLAG column. Or just a sequential meaningless number for a TFLG column.
OWNER VARCHAR(30) N The schema owner. Defaults to V500
TABLE_NAME VARCHAR(30) N The table being documented
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.


DM_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM INFO
Definition: This is a generic place to store various configuration data.
Table Type: REFERENCE





Column Detail - DM_INFO


Column Name Type Null? Definition
INFO_CHAR VARCHAR(4000) Y Used to store the value part of the name value pair when the value portion is a character string.
INFO_DATE DATETIME Y Used to store the value part of the name value pair when the value portion is a date.
INFO_DOMAIN VARCHAR(80) N The domain for the name value pair.
INFO_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, if you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
INFO_LONG_ID DOUBLE N Used to store the value part of the name value pair when the value portion is a long stored on the long_text table.
INFO_NAME VARCHAR(255) N The name portion of the name value pair
INFO_NUMBER DOUBLE Y Used to store the value part of the name value pair when the value portion is a number.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
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.
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.
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.
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 - DM_INFO


Child Column in DM_INFO(FK) Parent Table Name Parent Column Name
Parents: INFO_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


DM_MERGE_TRANSLATE



Column Section Top of Page


Table-level Detail

Description: DM Merge Translation Table
Definition: Stores translated values for ID and CD columns
Table Type: REFERENCE





Column Detail - DM_MERGE_TRANSLATE


Column Name Type Null? Definition
ENV_SOURCE_ID DOUBLE N Environment ID for the Source database
ENV_TARGET_ID DOUBLE N Target Environment ID
ERROR_MSG VARCHAR(255) Y Column containing any error message
ERROR_NBR DOUBLE Y Column containing the error number
FROM_VALUE DOUBLE N The value from the source environment.
LOG_ID DOUBLE N Row in the DM_CHG_LOG table which caused the translation to be made.
MERGE_ID DOUBLE N Merge_id VALUE
STATUS_FLG DOUBLE Y A status flag.
TABLE_NAME VARCHAR(30) N Name of the table.
TO_VALUE DOUBLE N Target value.
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.


DM_MODEL_PROPERTIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management Model Properties
Definition: This table contains a list of model properties group by property set. This table is populate by a readme file and cannot be modified on a client domain.
Table Type: REFERENCE





Column Detail - DM_MODEL_PROPERTIES


Column Name Type Null? Definition
APPENDER_NAME VARCHAR(32) Y If valued, this appender will be called to lookup the value. This will only be used if property is not defined in the override table.
APPENDER_PARAM VARCHAR(2048) Y If an appender is defined, this column is used as an argument to the appender which is most likely the reference to the property value.
PROPERTY_NAME VARCHAR(32) N Name of property in the property set. Dots are not allowed.
PROPERTY_SET_NAME VARCHAR(64) N Dotted notation name used to group like configuration.
PROPERTY_TXT VARCHAR(2048) Y Model value. If Null, there is no model default and must be valued in override table. Must be printable characters.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - DM_MODEL_PROPERTIES


Child Column in DM_MODEL_PROPERTIES(FK) Parent Table Name Parent Column Name
Parents: PROPERTY_SET_NAME DM_PROPERTY_SET PROPERTY_SET_NAME




Parent Column in DM_MODEL_PROPERTIES (PK) Child Table Name Child Column Name
Children: PROPERTY_NAME DM_OVERRIDE_PROPERTIES PROPERTY_NAME
PROPERTY_SET_NAME DM_OVERRIDE_PROPERTIES PROPERTY_SET_NAME


DM_OVERRIDE_PROPERTIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management Override Properties
Definition: This table contains the property values managed in the client's domain. The values in this table describe properties of the running system, not of the data contained in the database. When refreshing a database these table should be truncated of source rows and repopulated with the destiation rows.
Table Type: REFERENCE





Column Detail - DM_OVERRIDE_PROPERTIES


Column Name Type Null? Definition
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PROPERTY_NAME VARCHAR(32) N Name of property in the property set. Dots are not allowed.
PROPERTY_SET_NAME VARCHAR(64) N Dotted notation name used to group like configuration.
PROPERTY_TXT VARCHAR(2048) Y Model value. If Null there is no model default and must be valued in override table. Must be printable.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - DM_OVERRIDE_PROPERTIES


Child Column in DM_OVERRIDE_PROPERTIES(FK) Parent Table Name Parent Column Name
Parents: PROPERTY_NAME DM_MODEL_PROPERTIES PROPERTY_NAME
PROPERTY_SET_NAME DM_MODEL_PROPERTIES PROPERTY_SET_NAME