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 |