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