Table Detail Report

CCL_REPORT_OBJECT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CCL Report Object
Definition: CCL Report Object
Table Type: REFERENCE





Column Detail - CCL_REPORT_OBJECT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CCL_GROUP DOUBLE Y Internal CCL group of object (0=DBA, 1-non-DBA, etc.)
DRIVER_OBJECT_ID DOUBLE N Linkage to an optional driver object also stored on CCL_REPORT_OBJECT. A driver object can be used to populate a record structure for use with a formatted report
FILE_NAME VARCHAR(100) N The source file name for the report object.
OBJECT_DESCRIPTION VARCHAR(2000) Y Description, comments and usage of the report object
OBJECT_ID DOUBLE N object identifier
OBJECT_NAME VARCHAR(30) N Internal Object name used by CCL. This name matches the OBJECT_NAME on the DPROTECT table
OBJECT_TYPE VARCHAR(10) N Text description of object type. Example: REPORT,QUERY,REPORTAPI,LABEL,DRIVER, etc.
PRODUCT_CD DOUBLE N Optional application/product code for documentation purposes
REPORT_NAME VARCHAR(100) N The user-specified report name. This is directly related to Object_name but more descriptive.
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.



Relationship Detail - CCL_REPORT_OBJECT


Child Column in CCL_REPORT_OBJECT(FK) Parent Table Name Parent Column Name
Parents: DRIVER_OBJECT_ID CCL_REPORT_OBJECT OBJECT_ID




Parent Column in CCL_REPORT_OBJECT (PK) Child Table Name Child Column Name
Children: OBJECT_ID CCL_LAYOUT_SECTION DRIVER_OBJECT_ID
CCL_REPORT_OBJECT DRIVER_OBJECT_ID
CCL_REPORT_OBJECT_R OBJECT_ID


CCL_REPORT_OBJECT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: CCL Report Object relationship
Definition: CCL Report Object relationship
Table Type: REFERENCE





Column Detail - CCL_REPORT_OBJECT_R


Column Name Type Null? Definition
OBJECT_ID DOUBLE N Reference to object defined on CCL_REPORT_OBJECT
REP_OBJ_RELTN_ID DOUBLE N Report object relation identifier
SECTION_ID DOUBLE N Reference to Layout section defined in CCL_LAYOUT_SECTION
SECTION_SEQUENCE DOUBLE N The sequence of the section_id in relation to the Object_id which uses the section
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.



Relationship Detail - CCL_REPORT_OBJECT_R


Child Column in CCL_REPORT_OBJECT_R(FK) Parent Table Name Parent Column Name
Parents: SECTION_ID CCL_LAYOUT_SECTION SECTION_ID
OBJECT_ID CCL_REPORT_OBJECT OBJECT_ID


CCL_SYNCH_AUDIT



Column Section Top of Page


Table-level Detail

Description: CCL Synchronize Audit
Definition: Audits export and import activity for CCL dictionary objects within the RDDS/synchronization process
Table Type: REFERENCE





Column Detail - CCL_SYNCH_AUDIT


Column Name Type Null? Definition
BEGIN_DT_TM DATETIME N The Begin date and time of the operation
CCL_SYNCH_AUDIT_ID DOUBLE N Primary Key - Unique row identifier
END_DT_TM DATETIME N The End date and time of the operation
NODE_NAME VARCHAR(20) N UNIX/VMS node name
OBJECT_NAME VARCHAR(30) N Discern Explorer Object Name
OPERATION VARCHAR(10) N The name of the merge operation (IMPORT/EXPORT/etc.)
OP_MODE VARCHAR(1) N The mode passed to the import/export operation
STATUS VARCHAR(10) N The status of the import/export operation
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.


CCL_SYNCH_BACKUP



Column Section Top of Page


Table-level Detail

Description: CCL Synchronize Backup
Definition: Stores backup CCL dictionary objects for use in merging objects during upgrades and RDDS processing
Table Type: REFERENCE





Column Detail - CCL_SYNCH_BACKUP


Column Name Type Null? Definition
CCLGROUP DOUBLE N Discern Explorer Group
CCL_SYNCH_BACKUP_ID DOUBLE N Primary Key - Unique row identifier
CHECKSUM DOUBLE N calculated checksum value
DIC_DATA0 VARCHAR(810) N Discern Explorer data record, stored in little-endian format (VMS, Linux, Windows)
DIC_DATA1 VARCHAR(810) N Discern Explorer data, stored in big-endian format (AIX, HP-UX)
DIC_KEY0 VARCHAR(40) N Discern Explorer data key referencing DPROTECT or DCOMPILE key, stored in little-endian format (VMS, Linux, Windows)
DIC_KEY1 VARCHAR(40) N Discern Explorer data key referencing DPROTECT or DCOMPILE key, stored in big-endian format (AIX, HP-UX)
DIR_NAME VARCHAR(20) N The directory name the object was included from in the source domain
ENDIAN_PLATFORM DOUBLE N The endian type of the source export platform
MAJOR_VERSION DOUBLE N Discern Explorer major version
MINOR_VERSION DOUBLE N Discern Explorer minor version
NODE_NAME VARCHAR(20) N UNIX/VMS node name
OBJECT_NAME VARCHAR(30) N Discern Explorer Object Name
OBJECT_TYPE VARCHAR(1) N Discern Explorer Object Type
QUAL DOUBLE N Discern Explorer sequence value to maintain order of DCOMPILE rows
RCODE VARCHAR(1) N Discern Explorer rcode (DPROTECT rows= 5, DCOMPILE rows= 9)
TIMESTAMP_DT_TM DATETIME N The date/time stamp which indicates when the object was last modified in the source export domain.
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.


CCL_SYNCH_OBJECTS



Column Section Top of Page


Table-level Detail

Description: CCL Synchronize Objects
Definition: Stores CCL dictionary objects for use in merging objects during upgrades and RDDS processing
Table Type: REFERENCE





Column Detail - CCL_SYNCH_OBJECTS


Column Name Type Null? Definition
CCLGROUP DOUBLE N Discern Explorer Group
CCL_SYNCH_OBJECTS_ID DOUBLE N Primary Key - Unique row identifier
CHECKSUM DOUBLE N calculated checksum value
DIC_DATA0 VARCHAR(810) N Discern Explorer data record, stored in little-endian format (VMS, Linux, Windows)
DIC_DATA1 VARCHAR(810) N Discern Explorer data, stored in big-endian format (AIX, HP-UX)
DIC_KEY0 VARCHAR(40) N Discern Explorer data key referencing DPROTECT or DCOMPILE key, stored in little-endian format (VMS, Linux, Windows)
DIC_KEY1 VARCHAR(40) N Discern Explorer data key referencing DPROTECT or DCOMPILE key, stored in big-endian format (AIX, HP-UX)
DIR_NAME VARCHAR(20) N The directory name the object was included from in the source domain
ENDIAN_PLATFORM DOUBLE N Indicates the endian type of the source export platform
MAJOR_VERSION DOUBLE N Discern Explorer major version
MINOR_VERSION DOUBLE N Discern Explorer minor version
NODE_NAME VARCHAR(20) N UNIX/VMS node name
OBJECT_NAME VARCHAR(30) N Discern Explorer Object Name
OBJECT_TYPE VARCHAR(1) N Discern Explorer Object Type
QUAL DOUBLE N Discern Explorer sequence value to maintain order of DCOMPILE rows
RCODE VARCHAR(1) N Discern Explorer rcode (DPROTECT rows= 5, DCOMPILE rows= 9)
TIMESTAMP_DT_TM DATETIME N The date/time stamp which indicates when the object was last modified in the source export domain.
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.