CDE_MILL_META



Column Section Top of Page


Table-level Detail

Description: CDE_MILL_META
Definition: Contains metadata for PowerInsight
Table Type: REFERENCE





Column Detail - CDE_MILL_META


Column Name Type Null? Definition
CDE_MILL_META_ID DOUBLE N Unique generated number that identifies a single row on the CDE_MILL_META table.
FILE_TYPE VARCHAR(100) Y File type of the script
KEY_RS_CNTR_NAME VARCHAR(100) Y Name of the counter in the keys record structure
KEY_RS_FIELD_NAME VARCHAR(100) Y Name of the field in the keys record structure
KEY_RS_NAME VARCHAR(100) Y Name of the keys record structure
RAW_IND DOUBLE Y Raw CCL script indicator
SCRIPT_LVL_NBR DOUBLE Y Tells at what hierarchical level this scripts is at
SCRIPT_NAME VARCHAR(100) Y Name of the CCL script
SUBJECT_AREA_NAME VARCHAR(100) Y The name of the subject area.
TYPE_FLAG DOUBLE Y The type of the script
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.


CDE_MILL_META_RS



Column Section Top of Page


Table-level Detail

Description: CDE_MILL_META_RS
Definition: Contains record structure metadata for PowerInsight
Table Type: REFERENCE





Column Detail - CDE_MILL_META_RS


Column Name Type Null? Definition
CDE_MILL_META_RS_ID DOUBLE N Unique generated number that identifies a single row on the CDE_MILL_META_RS table.
FILE_TYPE VARCHAR(100) Y File type of the script.
PARENT_FILE_TYPE VARCHAR(100) Y The parent file type of the script.
PARENT_KEY_RS_CNTR_NAME VARCHAR(100) Y The name of the counter in the parents record structure.
PARENT_KEY_RS_FIELD_NAME VARCHAR(100) Y The name of the field in the parents record structure.
PARENT_KEY_RS_NAME VARCHAR(100) Y The parent record structure name.
SCRIPT_NAME VARCHAR(100) Y The name of the CCL script.
SUBJECT_AREA_NAME VARCHAR(100) Y The name of the subject area.
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.


CDE_MILL_PARENT_KEYS



Column Section Top of Page


Table-level Detail

Description: CDE_MILL_PARENT_KEYS
Definition: This table is used during the extract to hold parent id's for each script when initial enterprise is on.
Table Type: ACTIVITY





Column Detail - CDE_MILL_PARENT_KEYS


Column Name Type Null? Definition
CDE_MILL_PARENT_KEYS_ID DOUBLE N Unique generated number that identifies a single row on the CDE_MILL_PARENT_KEYS table.
FILE_TYPE VARCHAR(100) Y The file type of the script.
PARENT_IDENT VARCHAR(100) Y The Parent ID for the file_type
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.


CDE_MILL_RUN_LOG



Column Section Top of Page


Table-level Detail

Description: CDE_MILL_RUN_LOG
Definition: Contains extract run history for PowerInsight
Table Type: ACTIVITY





Column Detail - CDE_MILL_RUN_LOG


Column Name Type Null? Definition
CDE_MILL_RUN_LOG_ID DOUBLE N Unique generated number that identifies a single row on the CDE_MILL_RUN_LOG table.
CONFIG_BITMAP DOUBLE Y Is a bit mask used for configuration.
EXTRACT_BEGIN_DT_TM DATETIME Y The range begin date time for the extract.
EXTRACT_DT_TM DATETIME Y The date and time the extract started.
EXTRACT_END_DT_TM DATETIME Y The range end date time for the extract.
FILE_TYPE VARCHAR(100) Y File type of the script.
PARENT_PROCESS_NBR DOUBLE Y The parent process id from the Unix server.
PROCESS_NBR DOUBLE Y The process id from the Unix server.
RUN_FLAG DOUBLE Y The type of extract run. 1- Daily, 2 - Historical, 3 - Manual.
SCRIPT_BEGIN_DT_TM DATETIME Y The date and time the extract script started running.
SCRIPT_END_DT_TM DATETIME Y The date and time the extract script stopped running.
SCRIPT_NAME VARCHAR(100) Y Name of the extract CCL script
SOURCE_CNT DOUBLE Y The number of records the extracted scripted extracted.
STATUS_FLAG DOUBLE Y The status of the extract. 1 - Not run, 2 - Running, 3 - Succeeded, 4 - Failed, 5 - Skipped.
SUBJECT_AREA_NAME VARCHAR(100) Y The name of the subject area.
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.