Table Detail Report

DM_VSQL



Column Section Top of Page


Table-level Detail

Description: DM_VSQL
Definition: Store SQL snapshot data
Table Type: ACTIVITY





Column Detail - DM_VSQL


Column Name Type Null? Definition
BUFFER_GETS DOUBLE Y Oracle Buffer Gets Count
CCL_OPT_MODE DOUBLE N Cerner Optimizer Mode
CCL_QUERY_NBR DOUBLE N Cerner Query number
CCL_QUERY_NBR_TEXT VARCHAR(7) N Cerner Query Identifier
CCL_SCRIPT_NAME VARCHAR(30) N Cerner Script Name
CHILD_NUMBER DOUBLE Y Oracle Cursor Child Number
EXECUTIONS DOUBLE Y Oracle Execution Count
FIRST_LOAD_TIME VARCHAR(19) Y Oracle Cursor First Load Time
INST_HASH_ADD VARCHAR(100) Y Cerner combination of Oracle instance, Oracle hash_value, and Oracle address
LAST_LOAD_TIME VARCHAR(19) Y Oracle Cursor Last Load Time
PLAN_HASH_VALUE DOUBLE Y Oracle plan hash value
ROWS_PROCESSED DOUBLE Y Oracle rows processed count
SQLTEXT_HASH_VALUE DOUBLE N Cerner generated hash value on SQL_TEXT from GV$SQL
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.


DM_VSQLTEXT



Column Section Top of Page


Table-level Detail

Description: DM_VSQLTEXT
Definition: Stores SQLTEXT snapshot data
Table Type: ACTIVITY





Column Detail - DM_VSQLTEXT


Column Name Type Null? Definition
INST_HASH_ADD VARCHAR(100) N Cerner combination of Oracle instance, Oracle hash_value, and Oracle Address
PIECE_NUMBER DOUBLE N Oracle Piece Number
SQL_TEXT VARCHAR(64) N Oracle SQL_TEXT from GV$SQL
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.


JOB_EXECUTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Job Execution
Definition: Stores execution details for various jobs in our system. ;
Table Type: ACTIVITY





Column Detail - JOB_EXECUTION


Column Name Type Null? Definition
COMPLETION_DT_TM DATETIME Y The date and time this job last completed successfully.
CREATE_DT_TM DATETIME Y The date and time this row was created.
CREATE_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
JOB_EXECUTION_ID DOUBLE N Unique generated number that identifies a single row on the JOB_EXECUTION table.
JOB_GROUP_NAME VARCHAR(100) Y Text identifier of the team that owns this job.
JOB_NAME VARCHAR(50) Y The name of the job being tracked.
LAST_EXEC_DT_TM DATETIME Y The last time this job began execution.
LOGICAL_DOMAIN_ID DOUBLE Y The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PROCESS_TFLG VARCHAR(20) Y The status of the job.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.



Relationship Detail - JOB_EXECUTION


Child Column in JOB_EXECUTION(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
CREATE_ID PRSNL PERSON_ID




Parent Column in JOB_EXECUTION (PK) Child Table Name Child Column Name
Children: JOB_EXECUTION_ID MM_XFI_ASN_HEADER JOB_EXECUTION_ID


LONG_BLOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Long Binary Large Object
Definition: A core Table used to store large binary data (LONG RAW) from the corresponding table referenced in the PARENT_ENTITY_NAME column.
Table Type: ACTIVITY





Column Detail - LONG_BLOB


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BLOB_LENGTH DOUBLE N original length of the blob. This should be the uncompressed length if the blob is compressed.
COMPRESSION_CD DOUBLE N compression code from code set 120. This indicates the type of compression used, if blob is compressed.
LONG_BLOB LONGBLOB Y LONG RAW defined column stores large binary data from the corresponding table referenced in the PARENT_ENTITY_NAME column.
LONG_BLOB_ID DOUBLE N Unique Identifier for each row
PARENT_ENTITY_ID DOUBLE N The Unique Identifier from the corresponding table name referenced in PARENT_ENTITY_NAME for which the large binary data is stored.
PARENT_ENTITY_NAME VARCHAR(32) N The Referenced Table Name for which the large binary data is stored.
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.



Relationship Detail - LONG_BLOB




Parent Column in LONG_BLOB (PK) Child Table Name Child Column Name
Children: LONG_BLOB_ID ACT_PW_COMP DOSE_INFO_HIST_BLOB_ID
ACT_PW_COMP LONG_BLOB_ID
BB_EDN_ADMIN LONG_BLOB_ID
BH_GROUP_DOC GOALS_LONG_BLOB_ID
BH_GROUP_DOC NOTES_LONG_BLOB_ID
BLOB_SUMMARY_REF LONG_BLOB_ID
BR_LONG_BLOB_RELTN LONG_BLOB_ID
CCL_LAYOUT_SECTION SECTION_BLOB_ID
CHART_REQUEST_ARCHIVE LONG_BLOB_ID
CLINICAL_NOTE_TEMPLATE LONG_BLOB_ID
CR_REPORT_REQUEST DEBUG_ZIP_ID
CR_REPORT_REQUEST_ARCHIVE LONG_BLOB_ID
CT_DOCUMENT_VERSION LONG_BLOB_ID
DA_DOCUMENT GENERATED_DATA_ID
DA_DOCUMENT GENERATED_DOC_ID
DA_DOCUMENT REPORT_PARMS_ID
DD_EMR_EXTRACT EXTRACT_XML_BLOB_ID
DD_SDOC_ATTR_MENU_ITEM COMMENT_BLOB_ID
DD_SDOC_ATTR_MENU_ITEM RENDERED_TEXT_BLOB_ID
DIAGNOSIS LONG_BLOB_ID
DMS_MEDIA_INSTANCE LONG_BLOB_ID
DMS_MEDIA_SIGNATURE SIGNATURE_BLOB_ID
EEM_LOG_BLOB LONG_BLOB_ID
EKS_NOTIFICATION_BLOB_R LONG_BLOB_ID
ENCNTR_CLIN_REVIEW RESULT_XML_LONG_BLOB_ID
ENCNTR_CLIN_REVIEW_RESULT RESULT_LONG_BLOB_ID
ENCNTR_CLIN_REVIEW_RESULT RESULT_TEXT_LONG_BLOB_ID
ESI_LOG LONG_BLOB_ID
HE_KNOWLEDGEBASE VERSION_BLOB_ID
HE_OBJECT_ENTRY LONG_BLOB_ID
HE_SESSION LONG_BLOB_ID
INVTN_COMMUNICATION CONTENT_BLOB_ID
NURSING_ENCNTR_SCRATCHPAD LONG_BLOB_ID
ORM_ERROR_LOG REQUEST_LONG_BLOB_ID
PAT_ED_DOC_ACTIVITY LONG_TEXT_ID
PDOC_AUTOSAVE LONG_BLOB_ID
PDOC_TAG_TEXT LONG_BLOB_ID
PL_ORG_LOGO_XREF LONG_BLOB_ID
PROT_CRPC_BILLING PROT_KCW_LONG_BLOB_ID
PROT_CRPC_BILLING PROT_RPE_LONG_BLOB_ID
PW_PROCESSING_ACTION WORKFLOW_BLOB_ID
RX_CLAIM ATTACHMENT_BLOB_ID
SA_REF_ICON LONG_BLOB_ID
SI_DOC_VALIDATION VAL_INFO_BLOB_ID
SI_EPA_LOG LONG_BLOB_ID
SI_EPRESCRIBE_REQ_LOG LONG_BLOB_ID
SI_HAAD_FILE_DOWNLOAD FILE_CONTENT_ID
SN_COMMENT_TEXT LONG_BLOB_ID
UCM_REPORT REPORT_RTF_ID
UCM_SPECIMEN_COMMENT LONG_BLOB_ID


LONG_BLOB_REFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: LONG BLOB REFERENCE
Definition: Used to generically store LONG RAW columns that are reference in nature.
Table Type: REFERENCE





Column Detail - LONG_BLOB_REFERENCE


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
LONG_BLOB LONGBLOB Y LONG RAW defined column stores large binary data from the corresponding table referenced in the PARENT_ENTITY_NAME column.
LONG_BLOB_ID DOUBLE N Unique Identifier for each row
PARENT_ENTITY_ID DOUBLE N The Unique Identifier from the corresponding table name referenced in PARENT_ENTITY_NAME for which the large binary data is stored.
PARENT_ENTITY_NAME VARCHAR(32) N The referenced Table Name for which the large binary data is stored.
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 - LONG_BLOB_REFERENCE




Parent Column in LONG_BLOB_REFERENCE (PK) Child Table Name Child Column Name
Children: LONG_BLOB_ID CONCEPT_PROPERTY LONG_BLOB_ID
CR_REPORT_WATERMARK LONG_BLOB_ID
DD_REF_FILTER LONG_BLOB_REF_ID
DD_REF_FORMAT LONG_BLOB_REF_ID
DD_REF_TEMPLATE LONG_BLOB_REF_ID
DD_SREF_TEMPLATE XML_LONG_BLOB_REF_ID
DM_TEXT_FIND_DATA SERIALIZED_LONG_BLOB_ID
DM_TEXT_FIND_STRUCT LONG_BLOB_ID
DTA_VERSION LONG_BLOB_ID
INVTN_FRAGMENT CONTENT_BLOB_ID
MSG_LETTER_TEMPLATE LONG_BLOB_REF_ID
PFT_CLAIM_RULE RULE_TEMPLATE_ID
PFT_REPORT QUERY_BLOB_ID
PFT_RULESET LONG_BLOB_ID
PM_FLX_CONVERSATION END_RULE_LONG_BLOB_REF_ID
PM_FLX_CONVERSATION ICON_LONG_BLOB_REF_ID
PM_FLX_CONVERSATION START_RULE_LONG_BLOB_REF_ID
PM_FLX_CONV_OPTIONS VALUE_LONG_BLOB_REF_ID
PM_FLX_FORM INFO_LONG_TEXT_REF_ID
PM_FLX_PROMPT HELP_LONG_TEXT_ID
RCA_CONVERSATION LONG_BLOB_ID
RCA_MOBILE_PROFILE LONG_BLOB_ID
RCA_RULE ACTIONS_LONG_BLOB_ID
RCA_RULE CONDITION_LONG_BLOB_ID
RCA_RULE ELSE_ACTIONS_LONG_BLOB_ID
REF_TEXT_VERSION LONG_BLOB_ID
RX_MED_PROD_DESC LONG_BLOB_ID
SI_TEMPLATE_STYLE_SHEET LONG_BLOB_REFERENCE_ID
TRACK_FLOORPLAN LONG_BLOB_ID
UCMR_LAYOUT LAYOUT_RTF_ID
UCMR_WORKSHEET_STATEMENT_R NOTES_ID
VISITCODE_RULESET LONG_BLOB_ID