Table Detail Report

PROV_IMMUN_PARTICIPANT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_IMMUN_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_IMMUNIZATION_ID DOUBLE N Pk for the Provenance_Immunization table.
PROV_IMMUN_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_IMMUN_PARTICIPANT


Child Column in PROV_IMMUN_PARTICIPANT(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_IMMUNIZATION_ID PROVENANCE_IMMUNIZATION PROVENANCE_IMMUNIZATION_ID


PROV_MICRO_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROV_MICRO_ENTITY
Definition: Stores information about entities associated to the provenanceMICROBIOLOGY concept
Table Type: ACTIVITY





Column Detail - PROV_MICRO_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_MICROBIOLOGY_ID DOUBLE N Pk for the Provenance_MICROBIOLOGY table.
PROV_MICRO_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_MICRO_ENTITY


Child Column in PROV_MICRO_ENTITY(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_MICROBIOLOGY_ID PROVENANCE_MICROBIOLOGY PROVENANCE_MICROBIOLOGY_ID




Parent Column in PROV_MICRO_ENTITY (PK) Child Table Name Child Column Name
Children: PROV_MICRO_ENTITY_ID PROV_MICRO_ENTY_PRTCPNT PROV_MICRO_ENTITY_ID


PROV_MICRO_ENTY_PRTCPNT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_MICRO_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_MICRO_ENTITY_ID DOUBLE N PK Value of the related row from the provenance CONCEPT entity table
PROV_MICRO_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_MICRO_ENTY_PRTCPNT


Child Column in PROV_MICRO_ENTY_PRTCPNT(FK) Parent Table Name Parent Column Name
Parents: PROV_MICRO_ENTITY_ID PROV_MICRO_ENTITY PROV_MICRO_ENTITY_ID


PROV_MICRO_PARTICIPANT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROV_MICRO_PARTICIPANT
Definition: Stores Participant information associated to the provenance MICROBIOLOGY concept
Table Type: ACTIVITY





Column Detail - PROV_MICRO_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_MICROBIOLOGY_ID DOUBLE N Pk for the Provenance_MICROBIOLOGY table.
PROV_MICRO_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_MICRO_PARTICIPANT


Child Column in PROV_MICRO_PARTICIPANT(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_MICROBIOLOGY_ID PROVENANCE_MICROBIOLOGY PROVENANCE_MICROBIOLOGY_ID


PROV_ORDER_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_ORDER_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_ORDER_ID DOUBLE N Pk for the Provenance_Order table.
PROV_ORDER_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_ORDER_ENTITY


Child Column in PROV_ORDER_ENTITY(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_ORDER_ID PROVENANCE_ORDER PROVENANCE_ORDER_ID




Parent Column in PROV_ORDER_ENTITY (PK) Child Table Name Child Column Name
Children: PROV_ORDER_ENTITY_ID PROV_ORDER_ENTY_PRTCPNT PROV_ORDER_ENTITY_ID