CV_EXT_IDENTIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cardiovascular External Identifier
Definition: This table holds the external identifiers for the document sent from external sources (e.g. FHIR)
Table Type: ACTIVITY





Column Detail - CV_EXT_IDENTIFIER


Column Name Type Null? Definition
ASSIGNER_ORG_ID DOUBLE Y Unique identifier of the EXTERNAL organization that issued/managed the external identifier.
CV_EXT_IDENTIFIER_ID DOUBLE N PRIMARY KEY
CV_STG_METADATA_ID DOUBLE Y Unique identifier of the staging metadata.
EVENT_ID DOUBLE Y Identifies an event from the clinical event table
EXT_IDENTIFIER_VALUE DOUBLE Y *** OBSOLETE ***The Value of the external identifier.
SYSTEM_URI VARCHAR(255) Y Namespace for the identifier value.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.
VALUE_TXT VARCHAR(255) Y Value of the external identifier.



Relationship Detail - CV_EXT_IDENTIFIER


Child Column in CV_EXT_IDENTIFIER(FK) Parent Table Name Parent Column Name
Parents: CV_STG_METADATA_ID CV_STG_METADATA CV_STG_METADATA_ID


CV_FINDINGS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cardiovascular Diagnosis findings
Definition: This table holds the details of the clinical diagnosis findings for the staged documents.
Table Type: ACTIVITY





Column Detail - CV_FINDINGS


Column Name Type Null? Definition
CODE_SYSTEM_TXT VARCHAR(255) Y The standard code system that defines the meaning of the symbol in the code.
CODE_TXT VARCHAR(80) Y The standard code value which is a symbol in syntax defined by the system.
CV_FINDINGS_ID DOUBLE N PRIMARY KEY
CV_STG_METADATA_ID DOUBLE Y The staging metadata identifier.
DISPLAY_TXT VARCHAR(255) Y The display text of the standard code that represents the meaning of the code in the system.
EVENT_ID DOUBLE Y Event Identifier for a parent row from clinical event which the finding is associated too.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - CV_FINDINGS


Child Column in CV_FINDINGS(FK) Parent Table Name Parent Column Name
Parents: CV_STG_METADATA_ID CV_STG_METADATA CV_STG_METADATA_ID


CV_STG_ACTION_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cardiovascular Staging Action Entity
Definition: This table holds the details of the actions taken by personnel/entities for respective staged documents.
Table Type: ACTIVITY





Column Detail - CV_STG_ACTION_ENTITY


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y ACTION DATE TIME
ACTION_ORG_ID DOUBLE Y Millennium identifier of the ORGANIZATION that took the specified action. The constraint has been dropped because the column could contain external data. We have a mechanism in our service to validate the Ids before we post any data to patient chart. If any invalid values found we want to continue to stage the data which is posting in this table.
ACTION_PRSNL_ID DOUBLE Y Millennium identifier of the personnel who took the specified action. The constraint has been dropped because the column could contain external data. We have a mechanism in our service to validate the Ids before we post any data to patient chart. If any invalid values found we want to continue to stage the data which is posting in this table.
ACTION_TYPE_CD DOUBLE Y Code value to represent the tpye of action.;
ACTION_TZ DOUBLE Y ACTION TZ
ACTIVE_IND DOUBLE Y 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.
CV_STG_ACTION_ENTITY_ID DOUBLE N PRIMARY KEY
CV_STG_METADATA_ID DOUBLE Y The staging metadata identifier.;
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.
UPDT_TZ DOUBLE Y UPDT TIME ZONE



Relationship Detail - CV_STG_ACTION_ENTITY


Child Column in CV_STG_ACTION_ENTITY(FK) Parent Table Name Parent Column Name
Parents: CV_STG_METADATA_ID CV_STG_METADATA CV_STG_METADATA_ID


CV_STG_DOCUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cardiovascular Staging Document
Definition: This table holds the details of the document provided through external sources (e.g. FHIR)
Table Type: ACTIVITY





Column Detail - CV_STG_DOCUMENT


Column Name Type Null? Definition
CONTENT_TYPE_TXT VARCHAR(255) Y Identifies the type of data in the attachment (e.g., application/pdf ).
CREATION_DT_TM DATETIME Y Date and time of diagnostic result creation.;
CREATION_TZ DOUBLE Y CREATION TZ
CV_STG_DOCUMENT_ID DOUBLE N PRIMARY KEY
CV_STG_METADATA_ID DOUBLE Y The staging diagnostic metadata identifier.;
DATA_SIZE DOUBLE Y The number of bytes of data that makes up the attachment.;
DATA_URL VARCHAR(255) Y URL of the diagnostic result data.;
DOCUMENT_HANDLE VARCHAR(255) Y Identifier of the document object. Media object identifier if stored in the multimedia storage.;
DOCUMENT_SCAN_STATUS_TXT VARCHAR(60) Y The scan status of the document (e.g., Safe, Unsafe, Skip, Timeout, Unknown).;
DOCUMENT_VERSION_TXT VARCHAR(80) Y Version of the identified document object in the multimedia storage.;
FORMAT_CD DOUBLE Y Allows a potential consumer to know how to render the specific media file format of the document and corresponds to the equivalent MIME type of the document as it was stored in CAMM.;
STORAGE_CD DOUBLE Y Identifies the location/device where the BLOB is stored (e.g., BLOB table, multimedia storage).;
TITLE_TEXT VARCHAR(255) Y A label or a set of text to represent the diagnostic result data.;
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.
UPDT_TZ DOUBLE Y UPDT TIME ZONE



Relationship Detail - CV_STG_DOCUMENT


Child Column in CV_STG_DOCUMENT(FK) Parent Table Name Parent Column Name
Parents: CV_STG_METADATA_ID CV_STG_METADATA CV_STG_METADATA_ID


CV_STG_METADATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cardiovascular Staging Metadata
Definition: This table holds the most recent version of metadata for a document sent from external sources (e.g. FHIR). Data retrieved from this table will be fed to other applications such as the reconciliation UI
Table Type: ACTIVITY





Column Detail - CV_STG_METADATA


Column Name Type Null? Definition
AUTHORING_ORG VARCHAR(255) Y A character filed which identifies the authoring organization.
AUTHORING_ORG_ID DOUBLE Y obsolete column - no longer used
CATEGORY_TXT VARCHAR(255) Y CATEGORY TXT
CLIENT_ID_TXT VARCHAR(255) Y Client ID of the incoming FHIR request
CONFIDENTIALTY_TXT VARCHAR(80) Y The sensitivity of the data held within the document.;
CONTRIBUTOR_SYSTEM_CD DOUBLE Y Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CV_STG_METADATA_ID DOUBLE N PRIMARY KEY
DOCUMENT_ACTION_STATUS_CD DOUBLE Y Code value that represents the status of the imported document.;
EFFECTIVE_END_DT_TM DATETIME Y The clinically relevant end date and time.
EFFECTIVE_END_TZ DOUBLE Y EFFECTIVE END TIME ZONE
EFFECTIVE_START_DT_TM DATETIME Y The clinically relevant start date and time.;
EFFECTIVE_START_TZ DOUBLE Y EFFECTIVE START TIME ZONE
ENCNTR_ID DOUBLE Y Unique identifier of the encounter.;
EVENT_CD DOUBLE Y Code value that represents the event associated with the diagnostic report.;
EVENT_ID DOUBLE Y Unique identifier of the event. This is from an EVENT_ID in the cinical_event table
INERROR_REASON_TXT VARCHAR(255) Y Reason for the Inerror action taken on the document.
ISSUED_DT_TM DATETIME Y The date and time at which this version of the document was issued.;
ISSUED_TZ DOUBLE Y ISSUED TIME ZONE
PERSON_ID DOUBLE Y Unique identifier for the patient / PERSON
RESOURCE_IDENT DOUBLE Y Unique identifier of the external resource.
RESOURCE_TYPE_TXT VARCHAR(255) Y The FHIR resource type (e.g., DocumentReference, DiagnosticReport).;
RESULT_STATUS_CD DOUBLE Y Code value that represents the status of the diagnostic report.;
STAGING_REASON_TXT VARCHAR(255) Y The reason for staging.;
TRANSMITTING_ORG VARCHAR(255) Y A character filed which identifies the transmitting organization.
TRANSMITTING_ORG_ID DOUBLE Y obsolete column - no longer used
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.
UPDT_TZ DOUBLE Y UPDT TIME ZONE
VERSION_TXT VARCHAR(80) Y Text representation of the Version number to identify the version of document stored.



Relationship Detail - CV_STG_METADATA


Child Column in CV_STG_METADATA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID




Parent Column in CV_STG_METADATA (PK) Child Table Name Child Column Name
Children: CV_STG_METADATA_ID CV_EXT_IDENTIFIER CV_STG_METADATA_ID
CV_FINDINGS CV_STG_METADATA_ID
CV_STG_ACTION_ENTITY CV_STG_METADATA_ID
CV_STG_DOCUMENT CV_STG_METADATA_ID