Table Detail Report

EXPLORER_MENU



Column Section Top of Page


Table-level Detail

Description: Explorer Menu
Definition: Menu items for discern explorer menu program
Table Type: REFERENCE





Column Detail - EXPLORER_MENU


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.
CCL_GROUP DOUBLE N The CCL group of this report object., which should match the object group shown in CCLPROT.
ITEM_DESC CHAR(40) Y The description of the menu option
ITEM_NAME CHAR(30) Y The name of the menu option item
ITEM_TYPE CHAR(1) Y The type of the menu option ( P-rogram or M-enu )
MENU_ID DOUBLE N The unique menu identifier
MENU_PARENT_ID DOUBLE Y If non-zero, this field indicates that it is a child of the specified menu.
PERSON_ID DOUBLE Y This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REPORT_SERVICE_CD DOUBLE N Reference to code set 4000601 (CclReportServiceBindings). A default of 0.0 indicates the CpmScriptBatch service is used for this report 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.


EXPLORER_MENU_SECURITY



Column Section Top of Page


Table-level Detail

Description: EXPLORER MENU SECURITY
Definition: Defines a relationship between explorer menu items and application groups
Table Type: REFERENCE





Column Detail - EXPLORER_MENU_SECURITY


Column Name Type Null? Definition
APP_GROUP_CD DOUBLE N The application group that will have access to the menu item
MENU_ID DOUBLE N The menu id that the application group will have access to.
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.