Table Detail Report

PROV_GENLAB_ENTY_PRTCPNT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_GENLAB_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_GENLAB_ENTY_PRTCPNT_ID DOUBLE N PRIMARY KEY
PROV_GEN_LAB_ENTITY_ID DOUBLE N PK Value of the related row from the provenance CONCEPT entity table
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_GENLAB_ENTY_PRTCPNT


Child Column in PROV_GENLAB_ENTY_PRTCPNT(FK) Parent Table Name Parent Column Name
Parents: PROV_GEN_LAB_ENTITY_ID PROV_GEN_LAB_ENTITY PROV_GEN_LAB_ENTITY_ID


PROV_GEN_LAB_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_GEN_LAB_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_GEN_LAB_ID DOUBLE N Pk for the Provenance_Gen_Lab table.
PROV_GEN_LAB_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_GEN_LAB_ENTITY


Child Column in PROV_GEN_LAB_ENTITY(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_GEN_LAB_ID PROVENANCE_GEN_LAB PROVENANCE_GEN_LAB_ID




Parent Column in PROV_GEN_LAB_ENTITY (PK) Child Table Name Child Column Name
Children: PROV_GEN_LAB_ENTITY_ID PROV_GENLAB_ENTY_PRTCPNT PROV_GEN_LAB_ENTITY_ID


PROV_GEN_LAB_PARTICIPANT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_GEN_LAB_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_GEN_LAB_ID DOUBLE N Pk for the Provenance_Gen_Lab table.
PROV_GEN_LAB_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_GEN_LAB_PARTICIPANT


Child Column in PROV_GEN_LAB_PARTICIPANT(FK) Parent Table Name Parent Column Name
Parents: PROVENANCE_GEN_LAB_ID PROVENANCE_GEN_LAB PROVENANCE_GEN_LAB_ID


PROV_IMMUN_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

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





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


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




Parent Column in PROV_IMMUN_ENTITY (PK) Child Table Name Child Column Name
Children: PROV_IMMUN_ENTITY_ID PROV_IMMUN_ENTY_PRTCPNT PROV_IMMUN_ENTITY_ID


PROV_IMMUN_ENTY_PRTCPNT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PROV_IMMUN_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_IMMUN_ENTITY_ID DOUBLE N PK Value of the related row from the provenance CONCEPT entity table
PROV_IMMUN_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_IMMUN_ENTY_PRTCPNT


Child Column in PROV_IMMUN_ENTY_PRTCPNT(FK) Parent Table Name Parent Column Name
Parents: PROV_IMMUN_ENTITY_ID PROV_IMMUN_ENTITY PROV_IMMUN_ENTITY_ID