Table Detail Report

CCL_FUNCTION_PARAMS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - CCL_FUNCTION_PARAMS


Column Name Type Null? Definition
FUNCTION_ID DOUBLE N Reference to function name on CCL_FUNCTIONS table
OPTIONAL_IND DOUBLE Y Indicates whether the parameter is optional
PARAM_DESCRIPTION VARCHAR(100) Y Description of parameter and its usage within the function
PARAM_SEQUENCE DOUBLE Y The sequence of the parameter within this
PARAM_TYPE VARCHAR(4) N Parameter type text for use in filtering available values for the parameter
TEMPLATE_ID DOUBLE N Unique function template identifier
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_PARAMS


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


CCL_LAYOUT_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: CCl layout section
Definition: CCl layout section
Table Type: REFERENCE





Column Detail - CCL_LAYOUT_SECTION


Column Name Type Null? Definition
DRIVER_OBJECT_ID DOUBLE N Linkage to driver object stored on CCL_REPORT_OBJECT. A driver object can be used to populate a record structure for use with a layout section.
SECTION_BLOB_ID DOUBLE N Identifier for section content stored in XML format on the LONG_BLOB table
SECTION_DESCRIPTION VARCHAR(2000) Y Layout section comments and report developer notes
SECTION_HEIGHT DOUBLE Y Height of section (default in inches)
SECTION_ID DOUBLE N primary key for sequencing/reference. Unique section identifier
SECTION_NAME VARCHAR(30) N The user-specified section name defined with Layout Builder
SECTION_TYPE_IND DOUBLE N Indicates pre-defined (0) or custom (1) layout section. Potentially other uses
SECTION_VERSION DOUBLE Y Version for report development history
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_LAYOUT_SECTION


Child Column in CCL_LAYOUT_SECTION(FK) Parent Table Name Parent Column Name
Parents: DRIVER_OBJECT_ID CCL_REPORT_OBJECT OBJECT_ID
SECTION_BLOB_ID LONG_BLOB LONG_BLOB_ID




Parent Column in CCL_LAYOUT_SECTION (PK) Child Table Name Child Column Name
Children: SECTION_ID CCL_REPORT_OBJECT_R SECTION_ID


CCL_PRODUCT_SECURITY



Column Section Top of Page


Table-level Detail

Description: CCL Product Security
Definition: Grants access to specific data model sections by position code. Describes relationship between posiiton codes, and data model sections.
Table Type: REFERENCE





Column Detail - CCL_PRODUCT_SECURITY


Column Name Type Null? Definition
DATA_MODEL_SECTION VARCHAR(80) N Defines a data model section from the DM_DATA_MODEL_SECTION table.
POSITION_CD DOUBLE N The position code that will have access to the data model section described in the DATA_MODEL_SECTION field.
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_DEFINITIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: CCL Prompt Definitions
Definition: Defines the prompts for a CCL program that has had a prompt library control defined.
Table Type: REFERENCE





Column Detail - CCL_PROMPT_DEFINITIONS


Column Name Type Null? Definition
CONTROL DOUBLE Y Numerical identifier of the form's control assigned by discern PromptLib.
DEFAULT_VALUE VARCHAR(100) Y Control defined textual representation of the default value.
DESCRIPTION VARCHAR(100) Y User defined status bar help text.
DISPLAY VARCHAR(100) Y User defined label text for the control and the command line display text.
EXCLUDE_IND DOUBLE Y Flag to exclude this prompt from the CCL command line execute statement.
GROUP_NO DOUBLE Y CCL group access number.
HEIGHT DOUBLE Y User definable height (in dialog units) of the control.
POSITION DOUBLE Y Prompt's order in the executable. 0 to n-1 where n is the total number of prompts.
PROGRAM_NAME VARCHAR(128) N CCL program object name this form is attached to.
PROMPT_ID DOUBLE N CCL program unique, system assigned prompt identifier.
PROMPT_NAME VARCHAR(30) N Unique user defined identifier for the prompt
RESULT_TYPE_IND DOUBLE Y Command line format indicator. 0=quoted string, 3=expression.
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.
WIDTH DOUBLE Y User definable width (in dialog units) of the control.



Relationship Detail - CCL_PROMPT_DEFINITIONS




Parent Column in CCL_PROMPT_DEFINITIONS (PK) Child Table Name Child Column Name
Children: PROMPT_ID CCL_PROMPT_PROPERTIES PROMPT_ID


CCL_PROMPT_FILE



Column Section Top of Page


Table-level Detail

Description: CCL PROMPT FILE
Definition: Stores large data files in 2000 blocks that are not associated with a component or property.
Table Type: REFERENCE





Column Detail - CCL_PROMPT_FILE


Column Name Type Null? Definition
COLLATION_SEQ DOUBLE N Ordering of blocks (0 - n-1 where n = total number of blocks).
CONTENT VARCHAR(2000) Y File data block up to 2000 bytes of unstructured data.
FILE_NAME VARCHAR(100) N File name must be unique to the folder.
FOLDER_NAME VARCHAR(100) N Unique file location name. Forward slash ('/') denotes sub-folder names.
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.