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. |