Table Detail Report

PROV_PATH_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROV_PATH_ENTITY
Definition: Stores information about entities associated to the provenance PATHOLOGY concept
Table Type: ACTIVITY





Column Detail - PROV_PATH_ENTITY


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.
ENTITY_ROLE_CD DOUBLE N Code value describing the entity role in the provenance activity - e.g. SOURCE.
PARENT_ENTITY_ID DOUBLE N Pk for the entity table identified in field PARENT_ENTITY_NAME.
PARENT_ENTITY_NAME VARCHAR(30) N Entity table name - e.g. SI_DOCUMENT_METADATA CLINICAL_EVENT
PROVENANCE_PATHOLOGY_ID DOUBLE N Pk for the Provenance_PATHOLOGY table.
PROV_PATH_ENTITY_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 - PROV_PATH_ENTITY


Child Column in PROV_PATH_ENTITY(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_PATHOLOGY_ID PROVENANCE_PATHOLOGY PROVENANCE_PATHOLOGY_ID




Parent Column in PROV_PATH_ENTITY (PK) Child Table Name Child Column Name
Children: PROV_PATH_ENTITY_ID PROV_PATH_ENTY_PRTCPNT PROV_PATH_ENTITY_ID


PROV_PATH_ENTY_PRTCPNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROV_PATH_ENTY_PRTCPNT
Definition: Stores Participant relationships to the concept entity
Table Type: ACTIVITY





Column Detail - PROV_PATH_ENTY_PRTCPNT


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.
PARTICIPANT_ENTITY_ID DOUBLE N PK value for a row in the participant table identified in column PARTICIPANT_ENTITY_NAME
PARTICIPANT_ENTITY_NAME VARCHAR(30) N Participant table name IE: PRSNL - ORGANIZATION
PARTICIPANT_ROLE_CD DOUBLE N Code value describing the participant's role in the provenance entity e.g. SOURCE - INFORMANT
PARTICIPANT_TYPE_CD DOUBLE Y The code identifies the type of participant to suppot patient writes. Examples are ORG PRSNL PATIENT RELATED-PERSON
PARTICIPATION_TYPE_CD DOUBLE N How the participant contributed to the allergy provenance entity e.g. Author - Custodian - Transmitter.
PROV_PATH_ENTITY_ID DOUBLE N PK Value of the related row from the provenance CONCEPT entity table
PROV_PATH_ENTY_PRTCPNT_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 - PROV_PATH_ENTY_PRTCPNT


Child Column in PROV_PATH_ENTY_PRTCPNT(FK) Parent Table Name Parent Column Name
Parents: PROV_PATH_ENTITY_ID PROV_PATH_ENTITY PROV_PATH_ENTITY_ID


PROV_PATH_PARTICIPANT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROV_PATH_PARTICIPANT
Definition: Stores Participant information associated to the provenance PATHOLOGY concept
Table Type: ACTIVITY





Column Detail - PROV_PATH_PARTICIPANT


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.
PARTICIPANT_ENTITY_ID DOUBLE N Pk for a row in the participant table identified in field PARTICIPANT_ENTITY_NAME.
PARTICIPANT_ENTITY_NAME VARCHAR(30) N Participant table name e.g. PRSNL ORGANIZATION
PARTICIPANT_ROLE_CD DOUBLE N Code value describing the participant role in the provenance activity e.g. SOURCE INFORMANT.
PARTICIPANT_TYPE_CD DOUBLE Y The code identifies the type of participant to suppot patient writes. Examples are ORG PRSNL PATIENT RELATED-PESON
PARTICIPATION_TYPE_CD DOUBLE N How the participant contributed to the activity: Author or Transmitter.
PROVENANCE_PATHOLOGY_ID DOUBLE N Pk for the Provenance_PATHOLOGY table.
PROV_PATH_PARTICIPANT_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 - PROV_PATH_PARTICIPANT


Child Column in PROV_PATH_PARTICIPANT(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_PATHOLOGY_ID PROVENANCE_PATHOLOGY PROVENANCE_PATHOLOGY_ID


PROV_PROB_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Provenance PROBLEM Entity
Definition: Stores information about entities associated to the provenance PROBLEM concept
Table Type: ACTIVITY





Column Detail - PROV_PROB_ENTITY


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.
ENTITY_ROLE_CD DOUBLE N Code value describing the entity role in the provenance activity - e.g. SOURCE.
PARENT_ENTITY_ID DOUBLE N Pk for the entity table identified in field PARENT_ENTITY_NAME.
PARENT_ENTITY_NAME VARCHAR(30) N Entity table name - e.g. SI_DOCUMENT_METADATA CLINICAL_EVENT
PROVENANCE_PROBLEM_ID DOUBLE N Pk for the Provenance_Problem table.
PROV_PROB_ENTITY_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 - PROV_PROB_ENTITY


Child Column in PROV_PROB_ENTITY(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_PROBLEM_ID PROVENANCE_PROBLEM PROVENANCE_PROBLEM_ID




Parent Column in PROV_PROB_ENTITY (PK) Child Table Name Child Column Name
Children: PROV_PROB_ENTITY_ID PROV_PROB_ENTY_PRTCPNT PROV_PROB_ENTITY_ID


PROV_PROB_ENTY_PRTCPNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROV_PROB_ENTY_PRTCPNT
Definition: Stores Participant relationships to the concept entity
Table Type: ACTIVITY





Column Detail - PROV_PROB_ENTY_PRTCPNT


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.
PARTICIPANT_ENTITY_ID DOUBLE N PK value for a row in the participant table identified in column PARTICIPANT_ENTITY_NAME
PARTICIPANT_ENTITY_NAME VARCHAR(30) N Participant table name IE: PRSNL - ORGANIZATION
PARTICIPANT_ROLE_CD DOUBLE N Code value describing the participant's role in the provenance entity e.g. SOURCE - INFORMANT
PARTICIPANT_TYPE_CD DOUBLE Y The code identifies the type of participant to suppot patient writes. Examples are ORG PRSNL PATIENT RELATED-PERSON
PARTICIPATION_TYPE_CD DOUBLE N How the participant contributed to the allergy provenance entity e.g. Author - Custodian - Transmitter.
PROV_PROB_ENTITY_ID DOUBLE N PK Value of the related row from the provenance CONCEPT entity table
PROV_PROB_ENTY_PRTCPNT_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 - PROV_PROB_ENTY_PRTCPNT


Child Column in PROV_PROB_ENTY_PRTCPNT(FK) Parent Table Name Parent Column Name
Parents: PROV_PROB_ENTITY_ID PROV_PROB_ENTITY PROV_PROB_ENTITY_ID