Table Detail Report

PROV_DOC_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_DOC_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_DOCUMENT_ID DOUBLE N Pk for the Provenance_Document table.
PROV_DOC_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_DOC_ENTITY


Child Column in PROV_DOC_ENTITY(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_DOCUMENT_ID PROVENANCE_DOCUMENT PROVENANCE_DOCUMENT_ID




Parent Column in PROV_DOC_ENTITY (PK) Child Table Name Child Column Name
Children: PROV_DOC_ENTITY_ID PROV_DOC_ENTY_PRTCPNT PROV_DOC_ENTITY_ID


PROV_DOC_ENTY_PRTCPNT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_DOC_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_DOC_ENTITY_ID DOUBLE N PK Value of the related row from the provenance CONCEPT entity table
PROV_DOC_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_DOC_ENTY_PRTCPNT


Child Column in PROV_DOC_ENTY_PRTCPNT(FK) Parent Table Name Parent Column Name
Parents: PROV_DOC_ENTITY_ID PROV_DOC_ENTITY PROV_DOC_ENTITY_ID


PROV_DOC_PARTICIPANT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_DOC_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_DOCUMENT_ID DOUBLE N Pk for the Provenance_dOCUMENT table.
PROV_DOC_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_DOC_PARTICIPANT


Child Column in PROV_DOC_PARTICIPANT(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_DOCUMENT_ID PROVENANCE_DOCUMENT PROVENANCE_DOCUMENT_ID


PROV_ENCNTR_ENTY_PRTCPNT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_ENCNTR_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_ENCNTR_ENTITY_ID DOUBLE N PK Value of the related row from the provenance CONCEPT entity table
PROV_ENCNTR_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_ENCNTR_ENTY_PRTCPNT


Child Column in PROV_ENCNTR_ENTY_PRTCPNT(FK) Parent Table Name Parent Column Name
Parents: PROV_ENCNTR_ENTITY_ID PROV_ENCNTR_ENTITY PROV_ENCNTR_ENTITY_ID


PROV_ENCNTR_PARTICIPANT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_ENCNTR_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_ENCOUNTER_ID DOUBLE N Pk for the Provenance_Encounter table.
PROV_ENCNTR_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_ENCNTR_PARTICIPANT


Child Column in PROV_ENCNTR_PARTICIPANT(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_ENCOUNTER_ID PROVENANCE_ENCOUNTER PROVENANCE_ENCOUNTER_ID