CW_DATA_CACHE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Common Well Data Cache
Definition: Cache CommonWell data to reduce the number of exernal calls made.
Table Type: ACTIVITY





Column Detail - CW_DATA_CACHE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
CW_DATA_CACHE_ID DOUBLE N PRIMARY KEY
ENROLLED_IND DOUBLE Y Determines if enrolled or not.
NEW_CONNECTIONS_CNT DOUBLE Y Number of new connections.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. This column is either valued with the facility or the client organization for the encounter.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. it is an internal system assigned number.
RETRIEVED_DT_TM DATETIME Y Date and time the status was retrieved from CommonWell.
RETRIEVED_STATUS_FLAG DOUBLE Y A value that identifies the retrieved status.
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 - CW_DATA_CACHE


Child Column in CW_DATA_CACHE(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID


EXT_DATA_CLOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: EXTERNAL DATA CLOB
Definition: This table stores structured external data in a CLOB field
Table Type: ACTIVITY





Column Detail - EXT_DATA_CLOB


Column Name Type Null? Definition
CLOB_TYPE_TXT VARCHAR(255) N Indicates the format of the content that this row refers to. Examples include "text/plain", "text/xml", etc.
DATA_CLOB LONGTEXT Y Structured content of the external data (stored in a CLOB field)
EXT_DATA_CLOB_ID DOUBLE N PRIMARY KEY
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 - EXT_DATA_CLOB




Parent Column in EXT_DATA_CLOB (PK) Child Table Name Child Column Name
Children: EXT_DATA_CLOB_ID EXT_DATA_INFO EXT_DATA_CLOB_ID


EXT_DATA_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: external data group
Definition: This table stores information about grouped external data.
Table Type: ACTIVITY





Column Detail - EXT_DATA_GROUP


Column Name Type Null? Definition
DATA_CONTRIB_CD DOUBLE N DATA CONTRIBUTOR CODE
DATA_GROUP_SOURCE_CD DOUBLE N The source of the grouped external data.
DATA_GROUP_STATUS_CD DOUBLE N Status of the grouped external data. Values include SUBMITTED, INPROGRESS, RECONCILED
EXT_DATA_GROUP_ID DOUBLE N PRIMARY KEY
PERSON_ID DOUBLE N The person related to the grouped external data.
SOURCE_REFERENCE_ID DOUBLE N The id on the table of the source of the grouped external data (from table named in SOURE_REFERENCE_NAME)
SOURCE_REFERENCE_NAME VARCHAR(30) Y The table name of the source of the grouped external data.
SUBMITTED_DT_TM DATETIME Y The date and time the grouped external data was submitted.
SUBMITTED_ENCNTR_ID DOUBLE N The encounter related to the grouped external data.
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 - EXT_DATA_GROUP


Child Column in EXT_DATA_GROUP(FK) Parent Table Name Parent Column Name
Parents: SUBMITTED_ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID




Parent Column in EXT_DATA_GROUP (PK) Child Table Name Child Column Name
Children: EXT_DATA_GROUP_ID EXT_DATA_INFO EXT_DATA_GROUP_ID


EXT_DATA_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: external data information
Definition: This table stores infromation about external data including status and links to the source document and chart data.
Table Type: ACTIVITY





Column Detail - EXT_DATA_INFO


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The date and time of the action
ACTION_PRSNL_ID DOUBLE N The personnel who performed the action
CHART_REFERENCE_ID DOUBLE N The id on the table of the charted data
CHART_REFERENCE_NAME VARCHAR(30) Y The table name of the charted data related to the external data.
DATA_SOURCE_CD DOUBLE N The source of the external data.
DATA_SOURCE_NAME VARCHAR(100) Y The name of the source for the external data
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_TYPE_CD DOUBLE N Type of the external data. ALLERGIES, IMMUNIZATION
ENCNTR_ID DOUBLE N The Encounter related to the External Data
EXT_DATA_CLOB_ID DOUBLE N The unique identifier for the external clob data.
EXT_DATA_GROUP_ID DOUBLE Y The unique identifier for the external grouped data.
EXT_DATA_INFO_ID DOUBLE N PRIMARY KEY
LONG_TEXT_ID DOUBLE N Identifier of the external data if stored in the long_text table.
PERSON_ID DOUBLE N The person related to the external data.
REQUESTED_ACTION_CD DOUBLE N Action requested for the data. Values include ADD, UPDATE, REMOVE
REQUESTED_ACTION_DT_TM DATETIME Y The date and time of the requested action.
REQUESTED_ACTION_DT_TM_FLAG DOUBLE Y Indicates precision of the requested_action_dt_tm.0 = date/time; 1 = date/time to second; 2 = date/time to minute; 3 = date/time to hour; 4 = date to day; 5 = date to month; 6 = date to year
SOURCE_REFERENCE_ID DOUBLE N The id on the table of the source of the external data.
SOURCE_REFERENCE_NAME VARCHAR(30) Y The table name of the source of the external data.
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 - EXT_DATA_INFO


Child Column in EXT_DATA_INFO(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
EXT_DATA_CLOB_ID EXT_DATA_CLOB EXT_DATA_CLOB_ID
EXT_DATA_GROUP_ID EXT_DATA_GROUP EXT_DATA_GROUP_ID
PERSON_ID PERSON PERSON_ID
ACTION_PRSNL_ID PRSNL PERSON_ID


PIE_DWL_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Worklists
Definition: This table will store the list of all the lists associated to the current user.
Table Type: ACTIVITY





Column Detail - PIE_DWL_LIST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
LIST_NAME VARCHAR(50) N Specified name for the list created by the user.
PIE_DWL_LIST_GROUP_ID DOUBLE N Unique identifier for the pie_dwl_list table. Each change or revision made creates a new instance within the group. The first instance id (PK value) is used for the group ID.
PIE_DWL_LIST_ID DOUBLE N PRIMARY KEY
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.
USER_PRSNL_ID DOUBLE N ID of the personnel who created the list.



Relationship Detail - PIE_DWL_LIST


Child Column in PIE_DWL_LIST(FK) Parent Table Name Parent Column Name
Parents: PIE_DWL_LIST_GROUP_ID PIE_DWL_LIST PIE_DWL_LIST_ID
USER_PRSNL_ID PRSNL PERSON_ID




Parent Column in PIE_DWL_LIST (PK) Child Table Name Child Column Name
Children: PIE_DWL_LIST_ID PIE_DWL_LIST PIE_DWL_LIST_GROUP_ID
PIE_DWL_LIST_PERSON_R PIE_DWL_LIST_ID