Table Detail Report
PROV_RAD_ENTY_PRTCPNT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PROV_RAD_ENTY_PRTCPNT |
Definition: | Stores Participant relationships to the concept entity |
Table Type: | ACTIVITY |
Column Detail - PROV_RAD_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_RAD_ENTITY_ID | DOUBLE | N | PK Value of the related row from the provenance CONCEPT entity table |
PROV_RAD_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_RAD_ENTY_PRTCPNT
Child Column in PROV_RAD_ENTY_PRTCPNT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROV_RAD_ENTITY_ID | PROV_RAD_ENTITY | PROV_RAD_ENTITY_ID |
PROV_RAD_PARTICIPANT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PROV_RAD_PARTICIPANT |
Definition: | Stores Participant information associated to the provenance RADIOLOGY concept |
Table Type: | ACTIVITY |
Column Detail - PROV_RAD_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_RADIOLOGY_ID | DOUBLE | N | Pk for the Provenance_RADIOLOGY table. |
PROV_RAD_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_RAD_PARTICIPANT
Child Column in PROV_RAD_PARTICIPANT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROVENANCE_RADIOLOGY_ID | PROVENANCE_RADIOLOGY | PROVENANCE_RADIOLOGY_ID |
PROV_VITAL_ENTITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Provenance VITALS Entity |
Definition: | Stores information about entities associated to the provenance VITALS concept |
Table Type: | ACTIVITY |
Column Detail - PROV_VITAL_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_VITAL_ID | DOUBLE | N | Pk for the Provenance_Vital table. |
PROV_VITAL_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_VITAL_ENTITY
Child Column in PROV_VITAL_ENTITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROVENANCE_VITAL_ID | PROVENANCE_VITAL | PROVENANCE_VITAL_ID |
Parent Column in PROV_VITAL_ENTITY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PROV_VITAL_ENTITY_ID | PROV_VITAL_ENTY_PRTCPNT | PROV_VITAL_ENTITY_ID |
PROV_VITAL_ENTY_PRTCPNT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PROV_VITAL_ENTY_PRTCPNT |
Definition: | Stores Participant relationships to the concept entity |
Table Type: | ACTIVITY |
Column Detail - PROV_VITAL_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_VITAL_ENTITY_ID | DOUBLE | N | PK Value of the related row from the provenance CONCEPT entity table |
PROV_VITAL_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_VITAL_ENTY_PRTCPNT
Child Column in PROV_VITAL_ENTY_PRTCPNT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROV_VITAL_ENTITY_ID | PROV_VITAL_ENTITY | PROV_VITAL_ENTITY_ID |
PROV_VITAL_PARTICIPANT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Provenance VITALS Participant |
Definition: | Stores Participant information associated to the provenance VITALS concept |
Table Type: | ACTIVITY |
Column Detail - PROV_VITAL_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_VITAL_ID | DOUBLE | N | Pk for the Provenance_Vital table. |
PROV_VITAL_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_VITAL_PARTICIPANT
Child Column in PROV_VITAL_PARTICIPANT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROVENANCE_VITAL_ID | PROVENANCE_VITAL | PROVENANCE_VITAL_ID |