CCLRDBDIC



Column Section Top of Page


Table-level Detail

Description: CCL RDBMS Dictionary
Definition: Stores CCL dictionary data for compiled programs and EKMs. One-to-many rows may represent a single compiled object.
Table Type: REFERENCE





Column Detail - CCLRDBDIC


Column Name Type Null? Definition
CCLRDBDIC_ID DOUBLE N Unique generated number that identifies a single row on the CCLRDBDIC table.
DIC_DATA VARCHAR(810) Y A segment which represents a portion of compiled CCL dictionary object.
DIC_KEY VARCHAR(40) N The key value generated internally by CCL to identify a compiled dictionary object.
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.


CCLRDBDICBLOB



Column Section Top of Page


Table-level Detail

Description: CCL RDBMS Dictionary Blob
Definition: Stores CCL dictionary binary data for compiled programs and EKMs.
Table Type: REFERENCE





Column Detail - CCLRDBDICBLOB


Column Name Type Null? Definition
CCLRDBDICBLOB_ID DOUBLE N Unique generated number that identifies a single row on the CCLRDBDICBLOB table.
DIC_DATA LONGBLOB Y The binary data which represents a compiled CCL dictionary object
DIC_KEY VARCHAR(40) N The key value generated internally by CCL to identify a compiled dictionary object.
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_CUST_SCRIPT_OBJECTS



Column Section Top of Page


Table-level Detail

Description: CCL Custom Script Objects
Definition: Stores Discern Explorer custom script names to provide automatic service routing of custom scripts
Table Type: REFERENCE





Column Detail - CCL_CUST_SCRIPT_OBJECTS


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.
CCL_CUST_SCRIPT_OBJECTS_ID DOUBLE N Unique generated number that identifies a single row on the CCL_CUST_SCRIPT_OBJECTS table.
GROUP_NUMBER DOUBLE N The CCL group number of the custom script object (typically 0 or 1).
OBJECT_NAME VARCHAR(30) N The name of the custom script object.
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_FUNCTIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: ccl functions
Definition: ccl functions
Table Type: REFERENCE





Column Detail - CCL_FUNCTIONS


Column Name Type Null? Definition
FORMAT_IND DOUBLE N Indicates whether the function supports an attached format string
FUNCTION_DESCRIPTION VARCHAR(200) Y Details on the function and its usage
FUNCTION_ID DOUBLE N Unique function identifier
FUNCTION_NAME VARCHAR(30) N Discern Explorer function name
FUNCTION_TYPE VARCHAR(4) N Used to categorize function types. For example: AGG (Aggregate), BIT (Bitwise logic) MATH (Numeric), MISC, STR (String), DTTM (Date/Time), UAR
PLANJOIN_IND DOUBLE N Indicates whether the function's usage is valid in the qualifications portion of a query
QUALIFIER_IND DOUBLE N Indicates whether a function supports the WHERE clause syntax
RETURN_TYPE VARCHAR(4) N The data type returned when the function is evaluated. Example: NULL, INT, STR, DTTM, etc.
SELECT_IND DOUBLE N select indicator
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_FUNCTIONS




Parent Column in CCL_FUNCTIONS (PK) Child Table Name Child Column Name
Children: FUNCTION_ID CCL_FUNCTION_DET FUNCTION_ID
CCL_FUNCTION_PARAMS FUNCTION_ID


CCL_FUNCTION_DET



Column Section Relationship Section Top of Page


Table-level Detail

Description: ccl function detail
Definition: ccl function detail
Table Type: REFERENCE





Column Detail - CCL_FUNCTION_DET


Column Name Type Null? Definition
DETAIL_ID DOUBLE N Unique identifier for CCL function template identifier
DETAIL_TEXT VARCHAR(255) Y Detailed information available to user when building syntax for a CCL function.
DETAIL_TYPE VARCHAR(10) Y Reference to the type of information stored in Detail_Text. PARAM (parameter); BOOL (Yes/No choice); OPTION (list of; choices to select)
FUNCTION_ID DOUBLE N Reference to the function defined on CCL_FUNCTIONS table
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_FUNCTION_DET


Child Column in CCL_FUNCTION_DET(FK) Parent Table Name Parent Column Name
Parents: FUNCTION_ID CCL_FUNCTIONS FUNCTION_ID