Table Detail Report

PROV_PROB_PARTICIPANT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Provenance PROBLEM Participant
Definition: Stores Participant information associated to the provenance PROBLEM concept
Table Type: ACTIVITY





Column Detail - PROV_PROB_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-PERSON
PARTICIPATION_TYPE_CD DOUBLE N How the participant contributed to the activity: Author or Transmitter..
PROVENANCE_PROBLEM_ID DOUBLE N Pk for the Provenance_Problem table.
PROV_PROB_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_PROB_PARTICIPANT


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


PROV_PROC_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_PROC_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_PROCEDURE_ID DOUBLE N Pk for the Provenance_Procedure table.
PROV_PROC_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_PROC_ENTITY


Child Column in PROV_PROC_ENTITY(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_PROCEDURE_ID PROVENANCE_PROCEDURE PROVENANCE_PROCEDURE_ID




Parent Column in PROV_PROC_ENTITY (PK) Child Table Name Child Column Name
Children: PROV_PROC_ENTITY_ID PROV_PROC_ENTY_PRTCPNT PROV_PROC_ENTITY_ID


PROV_PROC_ENTY_PRTCPNT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_PROC_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_PROC_ENTITY_ID DOUBLE N PK Value of the related row from the provenance CONCEPT entity table
PROV_PROC_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_PROC_ENTY_PRTCPNT


Child Column in PROV_PROC_ENTY_PRTCPNT(FK) Parent Table Name Parent Column Name
Parents: PROV_PROC_ENTITY_ID PROV_PROC_ENTITY PROV_PROC_ENTITY_ID


PROV_PROC_PARTICIPANT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Provenance PROCEDURE Participant
Definition: Stores Participant information associated to the provenance PROCEDURE concept
Table Type: ACTIVITY





Column Detail - PROV_PROC_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-PERSON
PARTICIPATION_TYPE_CD DOUBLE N How the participant contributed to the activity: Author or Transmitter.
PROVENANCE_PROCEDURE_ID DOUBLE N Pk for the Provenance_Procedure table.
PROV_PROC_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_PROC_PARTICIPANT


Child Column in PROV_PROC_PARTICIPANT(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_PROCEDURE_ID PROVENANCE_PROCEDURE PROVENANCE_PROCEDURE_ID


PROV_RAD_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROV_RAD_ENTITY
Definition: Stores information about entities associated to the provenance RADIOLOGY concept
Table Type: ACTIVITY





Column Detail - PROV_RAD_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_RADIOLOGY_ID DOUBLE N Pk for the Provenance_RADIOLOGY table.
PROV_RAD_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_RAD_ENTITY


Child Column in PROV_RAD_ENTITY(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_RADIOLOGY_ID PROVENANCE_RADIOLOGY PROVENANCE_RADIOLOGY_ID




Parent Column in PROV_RAD_ENTITY (PK) Child Table Name Child Column Name
Children: PROV_RAD_ENTITY_ID PROV_RAD_ENTY_PRTCPNT PROV_RAD_ENTITY_ID