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. |