Table Detail Report

CCL_PROMPT_PROGRAMS



Column Section Top of Page


Table-level Detail

Description: CCL PROMPT PROGRAMS
Definition: List predefined programs that return data for Discern Prompt Library controls.
Table Type: REFERENCE





Column Detail - CCL_PROMPT_PROGRAMS


Column Name Type Null? Definition
CONTROL_CLASS_ID DOUBLE N A value of 0 indicates the program is a Discern prompt form data source program, and a value of 1 indicates the program is a Discern report prompt form
DESCRIPTION VARCHAR(128) Y Tool tip description for the program.
DISPLAY VARCHAR(128) Y User viewable name of the program.
GROUP_NO DOUBLE N CCL program group access code.
PROGRAM_NAME VARCHAR(128) N CCL program object 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.


CCL_PROMPT_PROPERTIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: CCL Prompt Properties
Definition: This table defines a prompt control's specific properties on a CCL form.
Table Type: REFERENCE





Column Detail - CCL_PROMPT_PROPERTIES


Column Name Type Null? Definition
COMPONENT_NAME VARCHAR(30) N Control sub component name storing this property.
PROMPT_ID DOUBLE N Foreign key references CCL_PROMPT_DEFINITIONS(PROMPT_ID).
PROPERTY_NAME VARCHAR(30) N Control sub-component property name. Must be unique to the component.
PROPERTY_VALUE VARCHAR(1000) Y Textual representation of the properties value(s).
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_PROMPT_PROPERTIES


Child Column in CCL_PROMPT_PROPERTIES(FK) Parent Table Name Parent Column Name
Parents: PROMPT_ID CCL_PROMPT_DEFINITIONS PROMPT_ID


CCL_REF_LOGGING



Column Section Top of Page


Table-level Detail

Description: used to log references to key system tables
Definition: used to log refs to key system tables
Table Type: ACTIVITY





Column Detail - CCL_REF_LOGGING


Column Name Type Null? Definition
REF_COMMAND VARCHAR(2000) Y command used in the reference to the table being tracked.
REF_ID DOUBLE N sequence of the audit record
REF_PRCNAME VARCHAR(30) Y procedure that caused the audit record
REF_RDBMSNAME VARCHAR(30) Y database name
REF_TABLE VARCHAR(31) Y affected table
REF_TYPE CHAR(1) Y type of access to affected table ( read, write, update, delete, insert )
REF_USERNAME VARCHAR(30) Y user that caused audit record
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.


CCL_REF_LOGGING_BIND



Column Section Top of Page


Table-level Detail

Description: Binding of ref log event to application/user information
Definition: binding of ref log event to application/user information
Table Type: ACTIVITY





Column Detail - CCL_REF_LOGGING_BIND


Column Name Type Null? Definition
PARAM_NUM DOUBLE N param num
REF_BIND_NUM DOUBLE N bind num
REF_ID DOUBLE N ref id
REF_TEXT VARCHAR(2000) Y reference text
REF_TYPE CHAR(1) Y type of reference
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.


CCL_REPORT_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CCL Report Audit
Definition: This table stores audit log details for all reports executed via DiscernReport dll. Includes auditing for Discern apps (but not limited to): ExplorerMenu, VisualExplorer, DiscernVisualDeveloper, ExpertSysTool.
Table Type: ACTIVITY





Column Detail - CCL_REPORT_AUDIT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
APPLICATION_NBR DOUBLE Y Calling application number from which the specified report was executed
BEGIN_DT_TM DATETIME Y Begin date/time of report execution
END_DT_TM DATETIME Y Completion date/time of report execution
LONG_TEXT_ID DOUBLE N A reference to the query text or OMF prose text for the query/view executed.
OBJECT_NAME VARCHAR(40) Y Discern Explorer report executed
OBJECT_PARAMS VARCHAR(2000) Y Report parameters passed to report for current execution
OBJECT_TYPE VARCHAR(12) Y Report type: REPORT (ASCII), REPORTPS (Postscript), REPORTRTF (RTF), REPORTPDF( PDF)
OMF_OBJECT_CD DOUBLE N The OMF Grid code that the report was built from. Applies to Powervision only.
OUTPUT_DEVICE VARCHAR(50) Y The output device specified for the report.
RECORDS_CNT DOUBLE Y Records returned for report execution
REPORT_EVENT_ID DOUBLE N Unique identifier for report instance
REQUEST_NBR DOUBLE N Stores the request number of the transaction which executed the event.
STATUS VARCHAR(12) Y Status of report execution. Values; SUCCESS, FAILED, ACTIVE
TEMPFILE VARCHAR(50) Y Temporary file name that contains report results for current execution.
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_AUDIT


Child Column in CCL_REPORT_AUDIT(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID