ENCNTR_ID_GTMP



Column Section Top of Page


Table-level Detail

Description: Encounter ID Global Temporary Table
Definition: This table is an Oracle global temporary table. It is used to improve performance for various queries. It typically will contain strings or other text values. The data in this table will be deleted by Oracle when a commit is executed.
Table Type: ACTIVITY





Column Detail - ENCNTR_ID_GTMP


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N Contains an ID from the Encounter table.


EVENT_CD_GTMP



Column Section Top of Page


Table-level Detail

Description: Event Code Global Temporary Table
Definition: This table is an Oracle global temporary table. It is used to improve performance for various queries. It typically will contain strings or other text values. The data in this table will be deleted by Oracle when a commit is executed.
Table Type: ACTIVITY





Column Detail - EVENT_CD_GTMP


Column Name Type Null? Definition
EVENT_CD DOUBLE N Contains a code from the CODE_VALUE table.
EVENT_SET_CD DOUBLE N Identifies the code set that the code value belongs to.


SHARED_BLOB_GTTD



Column Section Top of Page


Table-level Detail

Description: Shared BLOB Global Temporary Table
Definition: This table is an Oracle global temporary table. It is used to improve performance for various queries. It typically will contain ids or other numerical values that will be used in a join clause or in-list in a select statement. The data in this table will be deleted by Oracle when a commit is executed.
Table Type: ACTIVITY





Column Detail - SHARED_BLOB_GTTD


Column Name Type Null? Definition
SHARED_BLOB LONGBLOB Y The BLOB field value to be temporarily stored.


SHARED_LIST_GTTD



Column Section Top of Page


Table-level Detail

Description: Shared List Global Temporary Table
Definition: This table is an Oracle global temporary table. It is used to improve performance for various queries. It typically will contain ids or other numerical values that will be used in a join clause or in-list in a select statement. The data in this table will be deleted by Oracle when a commit is executed.
Table Type: ACTIVITY





Column Detail - SHARED_LIST_GTTD


Column Name Type Null? Definition
SOURCE_ENTITY_DT_TM DATETIME Y Contains Date/Time values.
SOURCE_ENTITY_ID DOUBLE N Contains numeric ID values. It will be an F8 in CCL. An example of these would be primary key ids from a table.
SOURCE_ENTITY_NBR DOUBLE Y Contains numeric values. Defined as a number data type so it will be an I4 in CCL.
SOURCE_ENTITY_SEQ DOUBLE Y Contains numeric sequence values. Defined as a float data type so it will be an F8 in CCL.
SOURCE_ENTITY_TXT VARCHAR(300) Y Contains text values.
SOURCE_ENTITY_VALUE DOUBLE Y Contains numeric values. Defined as a float data type so it will be an F8 in CCL.


SHARED_TXT_GTTD



Column Section Top of Page


Table-level Detail

Description: Shared Test Global Temporary Table Delete
Definition: This table is an Oracle global temporary table. It is used to improve performance for various queries. It typically will contain strings or other text values. The data in this table will be deleted by Oracle when a commit is executed.
Table Type: ACTIVITY





Column Detail - SHARED_TXT_GTTD


Column Name Type Null? Definition
SOURCE_ENTITY_NAME VARCHAR(100) Y Usually contains the name of where the shared_entity_txt comes from. An example of this would be the table name where the text string comes from. However, it does not have to be a table name. It can be anything to distinguish one set of text values from another set.
SOURCE_ENTITY_TXT VARCHAR(255) Y This contains the text string that is being stored.