Table Detail Report

DM_CODE_SET_LOCAL



Column Section Top of Page


Table-level Detail

Description: DM CODE SET LOCAL
Definition: This table holds administrative data regarding code_sets
Table Type: REFERENCE





Column Detail - DM_CODE_SET_LOCAL


Column Name Type Null? Definition
CDF_OP_IND DOUBLE Y Preference for tool used to promote code_sets through the software factory. Does not apply at client sites.
CODE_SET DOUBLE N Code_set from code_value_set table
CRMIMPEXP_IND DOUBLE Y Indicates if code_set needs code_value_aliases on its code_values.
CSE_OP_IND DOUBLE Y Preference for tool used to promote code_sets through the software factory. Does not apply at client sites.
CVA_OP_IND DOUBLE Y Preference for tool used to promote code_sets through the software factory. Does not apply at client sites.
CVE_OP_IND DOUBLE Y Preference for tool used to promote code_sets through the software factory. Does not apply at client sites.
CVS_OP_IND DOUBLE Y Preference for tool used to promote code_sets through the software factory. Does not apply at client sites.
CV_OP_IND DOUBLE Y Preference for tool used to promote code_sets through the software factory. Does not apply at client sites.
DESCRIPTION VARCHAR(60) Y Description of code_set.
NO_COMBINE_IND DOUBLE Y If set to 1, DMAuthMaint will not allow code_values in this code_set to be combined.
OWNER_NAME VARCHAR(30) Y Owner of code_set.
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_COLSTRING_PARM



Column Section Top of Page


Table-level Detail

Description: Database Management Column String Parameters
Definition: Stores list of columns that go into DM_CHG_LOG.COLSTRING
Table Type: REFERENCE





Column Detail - DM_COLSTRING_PARM


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) N Holds column name
DATA_TYPE VARCHAR(20) N Holds the data type of the column
PARM_NBR DOUBLE N Indicates the order that the columns appear in COLSTRING
TABLE_NAME VARCHAR(30) N Holds table name
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_COLUMNS_DOC_LOCAL



Column Section Top of Page


Table-level Detail

Description: DM COLUMNS DOC LOCAL
Definition: This table is a copy of the existing dm_columns_doc table that resides in admin
Table Type: REFERENCE





Column Detail - DM_COLUMNS_DOC_LOCAL


Column Name Type Null? Definition
CODE_SET DOUBLE Y Code set
COLUMN_NAME VARCHAR(30) N Column_name
CONSTANT_VALUE VARCHAR(255) Y Constant value
DEFINING_ATTRIBUTE_IND DOUBLE Y Defining_attribute_ind
DEFINITION VARCHAR(500) Y Definition
DESCRIPTION VARCHAR(80) Y Description
EXCEPTION_FLG DOUBLE Y Exception_Flg
FLAG_IND DOUBLE Y Flag_ind
MERGE_DELETE_IND DOUBLE Y Merge Delete Indicator
MERGE_UPDATEABLE_IND DOUBLE Y MERGE_UPDATEABLE_IND
NLS_COL_IND DOUBLE Y NLS_COL_IND
PARENT_ENTITY_COL VARCHAR(30) Y PARENT_ENTITY_COL
ROOT_ENTITY_ATTR VARCHAR(30) Y ROOT_ENTITY_ATTR
ROOT_ENTITY_NAME VARCHAR(30) Y ROOT_ENTITY_NAME
SEQUENCE_NAME VARCHAR(30) Y SEQUENCE_NAME
TABLE_NAME VARCHAR(30) N TABLE_NAME
UNIQUE_IDENT_IND DOUBLE Y UNIQUE_IDENT_IND
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_CONSTRAINT_EXCEPTIONS



Column Section Top of Page


Table-level Detail

Description: DM CONSTRAINT EXCEPTONS
Definition: Store row information for constraint violations
Table Type: ACTIVITY





Column Detail - DM_CONSTRAINT_EXCEPTIONS


Column Name Type Null? Definition
CONSTRAINT VARCHAR(30) Y Constraint name of violating row
OWNER VARCHAR(30) Y Owner of the Table (i.e., V500)
ROW_ID VARCHAR(18) Y ROWID of the violating row. Not a normal ID columns as in Millennium. No sequence.
TABLE_NAME VARCHAR(30) Y Table Name of the violating row


DM_CSM_SCRIPT_INFO



Column Section Top of Page


Table-level Detail

Description: DM_CSM_SCRIPT_INFO
Definition: Stores information about custom CCL scripts which are being staged as part of an App-Tier Migration.
Table Type: ACTIVITY





Column Detail - DM_CSM_SCRIPT_INFO


Column Name Type Null? Definition
COMPILE_DT_TM DATETIME N Date CCL Script was compiled. Read from DPROTECT.
DM_CSM_SCRIPT_INFO_ID DOUBLE N Unique generated number that identifies a single row on the DM_CSM_SCRIPT_INFO table.
SCRIPT_GROUP DOUBLE N User group for staged CCL script
SCRIPT_NAME VARCHAR(40) N Name of staged CCL script
SOURCE_NAME VARCHAR(80) Y Source location - if one exists - for staged script. Read from DPROTECT.
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.
USER_NAME VARCHAR(20) Y User who compiled staged CCL script - if one exists. Read from DPROTECT.