Table Detail Report

PROVENANCE_IMMUNIZATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Provenance for immunizations
Definition: Stores provenance information for the immunizations concept
Table Type: ACTIVITY





Column Detail - PROVENANCE_IMMUNIZATION


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.
CLIENT_IDENT VARCHAR(100) Y Unique identifier of the calling application.
GROUP_ID DOUBLE N This is a group identifier. It is the value of the PK of the first row in the group.
PARENT_ENTITY_ID DOUBLE N PK on the Concept table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Concept Table Name (CLINICAL_EVENT - IMMUNIZATION_EXT_DATA)
PERSONA_TXT VARCHAR(40) N Identifies the user's persona, e.g. PATIENT, PERSONNEL, SYSTEM.
PROVENANCE_IMMUNIZATION_ID DOUBLE N THE PRIMARY KEY
PROVENANCE_RECORDED_DT_TM DATETIME N The Date that the Provenance data was written into Millennium.
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 - PROVENANCE_IMMUNIZATION




Parent Column in PROVENANCE_IMMUNIZATION (PK) Child Table Name Child Column Name
Children: PROVENANCE_IMMUNIZATION_ID PROV_IMMUN_ENTITY PROVENANCE_IMMUNIZATION_ID
PROV_IMMUN_PARTICIPANT PROVENANCE_IMMUNIZATION_ID


PROVENANCE_MICROBIOLOGY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROVENANCE_MICROBIOLOGY
Definition: Provenance for MICROBIOLOGY
Table Type: ACTIVITY





Column Detail - PROVENANCE_MICROBIOLOGY


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.
CLIENT_IDENT VARCHAR(100) Y Unique identifier of the calling application.
GROUP_ID DOUBLE N This is a group identifier. It is the value of the PK of the first row in the group.
PARENT_ENTITY_ID DOUBLE N PK on the Concept table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Concept Table Name (tbd - tbd_EXT_DATA)
PERSONA_TXT VARCHAR(40) N Identifies the user's persona, e.g. PATIENT, PERSONNEL, SYSTEM.
PROVENANCE_MICROBIOLOGY_ID DOUBLE N THE PRIMARY KEY
PROVENANCE_RECORDED_DT_TM DATETIME N The Date that the Provenance data was written into Millennium.
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 - PROVENANCE_MICROBIOLOGY




Parent Column in PROVENANCE_MICROBIOLOGY (PK) Child Table Name Child Column Name
Children: PROVENANCE_MICROBIOLOGY_ID PROV_MICRO_ENTITY PROVENANCE_MICROBIOLOGY_ID
PROV_MICRO_PARTICIPANT PROVENANCE_MICROBIOLOGY_ID


PROVENANCE_ORDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Provenance for ORDERS
Definition: Stores provenance information for the ORDERS concept
Table Type: ACTIVITY





Column Detail - PROVENANCE_ORDER


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.
CLIENT_IDENT VARCHAR(100) Y Unique identifier of the calling application.
GROUP_ID DOUBLE N This is a group identifier. It is the value of the PK of the first row in the group.
PARENT_ENTITY_ID DOUBLE N PK on the Concept table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Concept Table Name (ORDER_STAGING - ORDERS)
PERSONA_TXT VARCHAR(40) N Identifies the user's persona, e.g. PATIENT, PERSONNEL, SYSTEM.
PROVENANCE_ORDER_ID DOUBLE N THE PRIMARY KEY
PROVENANCE_RECORDED_DT_TM DATETIME N The Date that the Provenance data was written into Millennium.
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 - PROVENANCE_ORDER




Parent Column in PROVENANCE_ORDER (PK) Child Table Name Child Column Name
Children: PROVENANCE_ORDER_ID PROV_ORDER_ENTITY PROVENANCE_ORDER_ID
PROV_ORDER_PARTICIPANT PROVENANCE_ORDER_ID


PROVENANCE_PATDEMO



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROVENANCE PATIENT DEMOGRAPHICS
Definition: Provenance for PATIENT DEMOGRAPHICS
Table Type: ACTIVITY





Column Detail - PROVENANCE_PATDEMO


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.
CLIENT_IDENT VARCHAR(100) Y Unique identifier of the calling application.
GROUP_ID DOUBLE N This is a group identifier. It is the value of the PK of the first row in the group.
PARENT_ENTITY_ID DOUBLE N PK on the Concept table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Concept Table Name ( PERSON )
PERSONA_TXT VARCHAR(40) N Identifies the user's persona, e.g. PATIENT, PERSONNEL, SYSTEM.
PROVENANCE_PATDEMO_ID DOUBLE N PRIMARY KEY
PROVENANCE_RECORDED_DT_TM DATETIME N The Date that the Provenance data was written into Millennium.
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 - PROVENANCE_PATDEMO




Parent Column in PROVENANCE_PATDEMO (PK) Child Table Name Child Column Name
Children: PROVENANCE_PATDEMO_ID PROV_PATDEMO_ENTITY PROVENANCE_PATDEMO_ID
PROV_PATDEMO_PARTICIPANT PROVENANCE_PATDEMO_ID


PROVENANCE_PATHOLOGY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROVENANCE_PATHOLOGY
Definition: Provenance for PATHOLOGY
Table Type: ACTIVITY





Column Detail - PROVENANCE_PATHOLOGY


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.
CLIENT_IDENT VARCHAR(100) Y Unique identifier of the calling application.
GROUP_ID DOUBLE N This is a group identifier. It is the value of the PK of the first row in the group.
PARENT_ENTITY_ID DOUBLE N PK on the Concept table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Concept Table Name (tbd - tbd_EXT_DATA)
PERSONA_TXT VARCHAR(40) N Identifies the user's persona, e.g. PATIENT, PERSONNEL, SYSTEM.
PROVENANCE_PATHOLOGY_ID DOUBLE N THE PRIMARY KEY
PROVENANCE_RECORDED_DT_TM DATETIME N The Date that the Provenance data was written into Millennium.
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 - PROVENANCE_PATHOLOGY




Parent Column in PROVENANCE_PATHOLOGY (PK) Child Table Name Child Column Name
Children: PROVENANCE_PATHOLOGY_ID PROV_PATH_ENTITY PROVENANCE_PATHOLOGY_ID
PROV_PATH_PARTICIPANT PROVENANCE_PATHOLOGY_ID