Table Detail Report

PIE_DWL_LIST_PERSON_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Worklist Patients
Definition: This table will store the list of all the patients tied to lists from pie_dwl_list table
Table Type: ACTIVITY





Column Detail - PIE_DWL_LIST_PERSON_R


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.
PERSON_ID DOUBLE N The ID of the PERSON/PATIENT for whom the worklist is related
PIE_DWL_LIST_ID DOUBLE N List ID from the pie_dwl_list table
PIE_DWL_LIST_PERSON_R_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.



Relationship Detail - PIE_DWL_LIST_PERSON_R


Child Column in PIE_DWL_LIST_PERSON_R(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PIE_DWL_LIST_ID PIE_DWL_LIST PIE_DWL_LIST_ID


PIE_EXT_SOURCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: External Source Schema
Definition: This table will store external sources that are configured through trust model
Table Type: REFERENCE





Column Detail - PIE_EXT_SOURCE


Column Name Type Null? Definition
LOGICAL_DOMAIN_ID DOUBLE N 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.
PIE_EXT_SOURCE_ID DOUBLE N PRIMARY KEY
SOURCE_TYPE_TXT VARCHAR(255) N Source Type Text with one of the value OID, CLIENT_ID or PERSONA
SOURCE_TYPE_VALUE VARCHAR(500) N Value of the source type
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 - PIE_EXT_SOURCE


Child Column in PIE_EXT_SOURCE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in PIE_EXT_SOURCE (PK) Child Table Name Child Column Name
Children: PIE_EXT_SOURCE_ID PIE_EXT_SOURCE_CONCEPT PIE_EXT_SOURCE_ID
PIE_EXT_SOURCE_EXCEPTION CHILD_EXT_SOURCE_ID
PIE_EXT_SOURCE_EXCEPTION PARENT_EXT_SOURCE_ID
PIE_EXT_SOURCE_INFO PIE_EXT_SOURCE_ID


PIE_EXT_SOURCE_CONCEPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: External Source Concept
Definition: Table stores relationship between the source and the concept
Table Type: REFERENCE





Column Detail - PIE_EXT_SOURCE_CONCEPT


Column Name Type Null? Definition
CONCEPT_TXT VARCHAR(255) N concept text which represents ALLERGY, PROBLEMS etc.,
PIE_EXT_SOURCE_CONCEPT_ID DOUBLE N PRIMARY KEY
PIE_EXT_SOURCE_ID DOUBLE N External Source Identifier
TRUST_TXT VARCHAR(255) N trust text which represents one of the value DIRECT_WRITE, STAGE or IGNORE
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 - PIE_EXT_SOURCE_CONCEPT


Child Column in PIE_EXT_SOURCE_CONCEPT(FK) Parent Table Name Parent Column Name
Parents: PIE_EXT_SOURCE_ID PIE_EXT_SOURCE PIE_EXT_SOURCE_ID


PIE_EXT_SOURCE_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PIE External Exception
Definition: This table will store exceptions on sources
Table Type: REFERENCE





Column Detail - PIE_EXT_SOURCE_EXCEPTION


Column Name Type Null? Definition
CHILD_EXT_SOURCE_ID DOUBLE N Child External Source info Identifier
EXCEPTION_TYPE_CD DOUBLE N Exception Type Code from code set
PARENT_EXT_SOURCE_ID DOUBLE N Parent External Source Identifier
PIE_EXT_SOURCE_EXCEPTION_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.



Relationship Detail - PIE_EXT_SOURCE_EXCEPTION


Child Column in PIE_EXT_SOURCE_EXCEPTION(FK) Parent Table Name Parent Column Name
Parents: CHILD_EXT_SOURCE_ID PIE_EXT_SOURCE PIE_EXT_SOURCE_ID
PARENT_EXT_SOURCE_ID PIE_EXT_SOURCE PIE_EXT_SOURCE_ID


PIE_EXT_SOURCE_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: EXTERNAL SOURCE INFORMATION
Definition: Stores information about external sources that are configured through the trust model
Table Type: REFERENCE





Column Detail - PIE_EXT_SOURCE_INFO


Column Name Type Null? Definition
PIE_EXT_SOURCE_ID DOUBLE N Foreign Key value from the primay key of a row in the External Source table
PIE_EXT_SOURCE_INFO_ID DOUBLE N PRIMARY KEY
SOURCE_DESC VARCHAR(255) Y Description of the external source that is beiing configured
SOURCE_NAME VARCHAR(255) Y Name of the source configured
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 - PIE_EXT_SOURCE_INFO


Child Column in PIE_EXT_SOURCE_INFO(FK) Parent Table Name Parent Column Name
Parents: PIE_EXT_SOURCE_ID PIE_EXT_SOURCE PIE_EXT_SOURCE_ID