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 |