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 |