Table Detail Report

AUDIT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Audit event definition
Definition: The definitions of all possible audit events. Also indicates which events are being actively audited.
Table Type: REFERENCE





Column Detail - AUDIT_EVENT


Column Name Type Null? Definition
ADDED_DT_TM DATETIME Y The date the audit event was added..
AUDIT_EVENT_NBR DOUBLE N This is the primary key to the table. It is used in implementation and should not be exposed outside of the audit management system.
AUDIT_IND DOUBLE N Indicates whether the audit event is being actively audited. This field can be modified on the client site. Allowed values are 0 (not auditable) and 1 (auditable). The default value for all audit events is 0 (not auditable).
AUDIT_NAME_DEF_NBR DOUBLE N Foreign key to the audit_name_def table. This indicates which audit name definition is being used for the audit event record.
AUDIT_TYPE_DEF_NBR DOUBLE N Foreign key to the audit_type_def table. This indicates which audit type definition is being used for the audit event record.
COMPONENT_NAME VARCHAR(125) N The component that utilizes this audit event.
DESCRIPTION_TEXT VARCHAR(2000) Y Description of the audit event.
EVENT_STATE_CD DOUBLE N The state of the audit event. Examples include valid, recommended, best practice, obsolete, etc.
SOLUTION_FAMILY_NAME VARCHAR(125) N The family of solutions this event belongs to.
SOLUTION_NAME VARCHAR(128) Y The name of the solution with which the audit event is applicable.
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 - AUDIT_EVENT


Child Column in AUDIT_EVENT(FK) Parent Table Name Parent Column Name
Parents: AUDIT_NAME_DEF_NBR AUDIT_NAME_DEF AUDIT_NAME_DEF_NBR
AUDIT_TYPE_DEF_NBR AUDIT_TYPE_DEF AUDIT_TYPE_DEF_NBR




Parent Column in AUDIT_EVENT (PK) Child Table Name Child Column Name
Children: AUDIT_EVENT_NBR AUDIT_REQUEST AUDIT_EVENT_NBR
OMF_AUDIT_CAT AUDIT_EVENT_NBR


AUDIT_NAME_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Audit event name definition
Definition: The definitions of all possible audit event names
Table Type: REFERENCE





Column Detail - AUDIT_NAME_DEF


Column Name Type Null? Definition
AUDIT_NAME VARCHAR(64) N Each record represents a unique audit event name. This is the primary lookup field on the table.
AUDIT_NAME_DEF_NBR DOUBLE N This is the primary key to the table. It is used in implementation and should not be exposed outside of the audit management system.
DESCRIPTION VARCHAR(255) N The description of the audit event name
DISPLAY_NAME VARCHAR(255) N A unique field that represents how the name will appear in applications and logs
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 - AUDIT_NAME_DEF




Parent Column in AUDIT_NAME_DEF (PK) Child Table Name Child Column Name
Children: AUDIT_NAME_DEF_NBR AUDIT_EVENT AUDIT_NAME_DEF_NBR


AUDIT_REQUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Audit request definition
Definition: The mapping of requests to audit events.
Table Type: REFERENCE





Column Detail - AUDIT_REQUEST


Column Name Type Null? Definition
AUDIT_EVENT_NBR DOUBLE N Foreign key to the audit_event table. This indicates to which audit event the request is mapped.
AUDIT_REQUEST_NBR DOUBLE N This is the primary key to the table. It is used in implementation and should not be exposed outside of the audit management system
REQUEST_NBR DOUBLE N The request number that is being mapped to an audit event.
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 - AUDIT_REQUEST


Child Column in AUDIT_REQUEST(FK) Parent Table Name Parent Column Name
Parents: AUDIT_EVENT_NBR AUDIT_EVENT AUDIT_EVENT_NBR


AUDIT_TYPE_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Audit event type definition
Definition: The definitions of all possible audit event types
Table Type: REFERENCE





Column Detail - AUDIT_TYPE_DEF


Column Name Type Null? Definition
AUDIT_TYPE VARCHAR(64) N Each record represents a unique audit event type. This is the primary lookup field on the table.
AUDIT_TYPE_DEF_NBR DOUBLE N This is the primary key to the table. It is used in implementation and should not be exposed outside of the audit management system.
DESCRIPTION VARCHAR(255) N The description of the audit event type
DISPLAY_NAME VARCHAR(255) N A unique field that represents how the type will appear in applications and logs
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 - AUDIT_TYPE_DEF




Parent Column in AUDIT_TYPE_DEF (PK) Child Table Name Child Column Name
Children: AUDIT_TYPE_DEF_NBR AUDIT_EVENT AUDIT_TYPE_DEF_NBR


REQUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Request
Definition: A request is the level at which clients and servers communicate. Each request is identified by a name and a number. Requests have defined inputs and outputs and request a server to perform a given unit of work for the client.
Table Type: REFERENCE





Column Detail - REQUEST


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME Y This is the date the request was created, or the last date/time the active indicator was checked on.
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.
BINDING_OVERRIDE VARCHAR(50) Y This column is used to override the default binding defined on the entry in the transaction database. It allows transactions for the associated request to be routed to a different server as long as the new destination is capable of processing the transaction. Example - req with binding of cpmscript in tran db that needs to be routed to the cpm.scriptcache server.
CACHEGRACE DOUBLE Y This is the number of seconds the request will stay in memory before be considered stale. At this point, a thread will pick up the request and start refreshing the reply data. The client will still receive the cache data at this point.
CACHESTALE DOUBLE Y This is the additional time that the request will stay in the cache after the 'Cache Grace Time' has expired before it is considered dirty. As long as the server finds a cache entry with the grace + stale time, the cached data is returned. If the request is not in the cache or the grace + stale time is exceeded, a database query will be issued and the client will wait for the reply.
CACHETIME DOUBLE Y This is used to determine if the data from the request, the reply, should be cached by the client (> 0) and if so, for how many minutes. This is generally used to allow the client to cache reference type of data that will be static for several hours or even days.
CACHETRIM VARCHAR(20) Y not used at this time
DESCRIPTION VARCHAR(200) Y The description of the request as defined in AppReg.
EPILOG_SCRIPT VARCHAR(30) Y This is the script that performs post-processing on the request after the process server is finished with it.
INACTIVE_DT_TM DATETIME Y This date is filled out if the active indicator is not set.
PROCESSCLASS DOUBLE Y This value will be used for requests that are routed to the CPM Process server. The process class will be added to the standard binding string for the CPM Process server to create a new binding. The transaction will then be forwarded to an instance of the CPM Process server that is offering a service with this new binding.
PROLOG_SCRIPT VARCHAR(30) Y This is the script that performs pre-processing before the request is sent to the process server.
REQUESTCLASS DOUBLE Y Used to classify requests that are routed to the same service into service classes. The number canbe valued from 0 to 999 and each service can be suffixed with 000 to 999 to create classes with theservice. DO NOT CHANGE THIS FIELD WITHOUT CONSULTING CERNER!!!
REQUEST_NAME VARCHAR(30) Y This is the name of the script as defined in TDB. This used to be called request_module.
REQUEST_NUMBER DOUBLE N The unique number associated with this component.
TEXT VARCHAR(500) Y The free text area exposed to the user in AppReg.
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.
WRITE_TO_QUE_IND DOUBLE Y This determines whether or not the request message is written out to the CPM_Process_Queue table.



Relationship Detail - REQUEST




Parent Column in REQUEST (PK) Child Table Name Child Column Name
Children: REQUEST_NUMBER REQUEST_PROCESSING REQUEST_NUMBER