Table Detail Report

SI_DIRECT_ATTACHMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Direct Message Attachment
Definition: Audit of file attached to each direct message either sent or received.
Table Type: ACTIVITY





Column Detail - SI_DIRECT_ATTACHMENT


Column Name Type Null? Definition
ARCHIVE_FILE_NAME VARCHAR(100) Y The name of the archive file that the attachment was stored in within the message.
ATTACHMENT_NAME VARCHAR(100) N The name of the attachment.
ATTACHMENT_SIZE DOUBLE N The size of the attachment.
CONTENT_TYPE_TXT VARCHAR(20) Y The CareAware Multimedia content type used for storing the attachment.
MEDIA_OBJECT_IDENT VARCHAR(64) Y The CareAware Multimedia identifier of the attachment.
MEDIA_OBJECT_VERSION_NBR DOUBLE N The version of the attachmen in CareAware Multimedia.
MIME_TYPE_TXT VARCHAR(100) Y The MIME content type of the attachment
SI_DIRECT_ATTACHMENT_ID DOUBLE N PRIMARY KEY
SI_DIRECT_MESSAGE_ID DOUBLE N Identifier to link the attachment to the si_direct_message table
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SI_DIRECT_ATTACHMENT


Child Column in SI_DIRECT_ATTACHMENT(FK) Parent Table Name Parent Column Name
Parents: SI_DIRECT_MESSAGE_ID SI_DIRECT_MESSAGE SI_DIRECT_MESSAGE_ID


SI_DIRECT_MESSAGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Direct Message
Definition: Audit of Direct messages coming into and sending out of Millennium.
Table Type: ACTIVITY





Column Detail - SI_DIRECT_MESSAGE


Column Name Type Null? Definition
APPLICATION_ENTITY_ID DOUBLE N The identifier for the application data model this message is linked to
APPLICATION_ENTITY_NAME VARCHAR(30) Y The name of the table the application_entity_id is from.
CREATE_DT_TM DATETIME N The date and time the row was created.
DIRECTION_TXT VARCHAR(10) Y The direction of the direct message in relation to the Millennium Domain
IN_REPLY_TO_IDENT VARCHAR(100) Y The identifier of the message this message is replying to.
LOGICAL_DOMAIN_ID DOUBLE N The logical domain that the message belongs to.
MEDIA_OBJECT_IDENTIFIER VARCHAR(64) Y The CareAware Multimedia identifier for the full MIME message.
MEDIA_OBJECT_VERSION_NBR DOUBLE Y The version of the message in CAMM.
MESSAGE_IDENT VARCHAR(100) Y Message identifier in the Direct message
MESSAGE_SIZE DOUBLE Y The size of the message
MESSAGE_TYPE_TXT VARCHAR(20) Y The type of message. For example: Reply, Forward, BounceBack, etc.
PERSON_ID DOUBLE N The patient id associated to the message. This only applies to outbound messages
PROCESS_TIME_SECS DOUBLE N The time it took to process the message in seconds.
RECEIVED_DT_TM DATETIME Y The date and time the message was received
REQUESTER_ID DOUBLE N The user that requested the direct message be sent. This may or may not be the same as the sender_entity_id.
SENDER_ADDRESS VARCHAR(100) N Email address of the sender of the message
SENDER_ENTITY_ID DOUBLE N The Millennium id associated to the sender's email address. Only applies to outbound messages
SENDER_ENTITY_NAME VARCHAR(30) Y The Millennium table that the sender entity id comes from.
SENT_DT_TM DATETIME N The date and time the message was sent
SI_DIRECT_MESSAGE_ID DOUBLE N PRIMARY KEY
STATUS_TXT VARCHAR(20) Y The current status of the message. It may be update by delivery notifications
SUBJECT_TXT VARCHAR(255) Y Subject line of the message
TRANSPORT_METHOD VARCHAR(20) N The method of transport for the Direct Message and its attachments. Possible values include DIRECT_SMTP, DIRECT_XDM, and DIRECT_XDR
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SI_DIRECT_MESSAGE


Child Column in SI_DIRECT_MESSAGE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PERSON_ID PERSON PERSON_ID
REQUESTER_ID PRSNL PERSON_ID




Parent Column in SI_DIRECT_MESSAGE (PK) Child Table Name Child Column Name
Children: SI_DIRECT_MESSAGE_ID SI_DIRECT_ATTACHMENT SI_DIRECT_MESSAGE_ID
SI_DIRECT_RECIPIENT SI_DIRECT_MESSAGE_ID


SI_DIRECT_RECIPIENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Direct Message Recipient
Definition: Audit of recipients of a direct message.
Table Type: ACTIVITY





Column Detail - SI_DIRECT_RECIPIENT


Column Name Type Null? Definition
RECIPIENT_ADDRESS VARCHAR(100) N The email address of the recipient
RECIPIENT_ENTITY_ID DOUBLE N The Millennium id of the recipient. Only applicable on inbound Direct Messages
RECIPIENT_ENTITY_NAME VARCHAR(30) Y The name of the table the recipient entity id is from. Only applicable on inbound Direct messages.
RECIPIENT_STATUS_DT_TM DATETIME Y The date and time that the recipient status was updated.
RECIPIENT_STATUS_TXT VARCHAR(20) N The current known status for the Direct message for the corresponding recipient. Will only be update for Outbound and only if configured to update on delivery notifications.
RECIPIENT_TYPE_TXT VARCHAR(20) N The type of email recipient (ie: To, CC, BC)
SI_DIRECT_MESSAGE_ID DOUBLE N Identifier to link the recipient to the si_direct_message table
SI_DIRECT_RECIPIENT_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 - SI_DIRECT_RECIPIENT


Child Column in SI_DIRECT_RECIPIENT(FK) Parent Table Name Parent Column Name
Parents: SI_DIRECT_MESSAGE_ID SI_DIRECT_MESSAGE SI_DIRECT_MESSAGE_ID


SI_DOCUMENT_IDENTIFIER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: SI Document Identifier Relation table
Definition: This relation table will store identifiers related to a given document from si_document_info
Table Type: ACTIVITY





Column Detail - SI_DOCUMENT_IDENTIFIER_R


Column Name Type Null? Definition
SI_DOCUMENT_IDENTIFIER_R_ID DOUBLE N PRIMARY KEY
SI_DOCUMENT_INFO_ID DOUBLE N The document that needs to have entities related to it.
SOURCE_NAME VARCHAR(30) N Name of the identifier related to the document, for example: REFERRAL_ORDER
SOURCE_TABLE VARCHAR(30) Y Table name related to the Source Value, for example: ORDERS
SOURCE_VALUE DOUBLE N Identifier that needs to be related to the given document. Value is related to the table or context identified in SOURCE_NAME
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SI_DOCUMENT_IDENTIFIER_R


Child Column in SI_DOCUMENT_IDENTIFIER_R(FK) Parent Table Name Parent Column Name
Parents: SI_DOCUMENT_INFO_ID SI_DOCUMENT_INFO SI_DOCUMENT_INFO_ID


SI_DOCUMENT_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Document Information
Definition: Document information for documents sent out from Millennium, this may include CAMM address for generated documents.
Table Type: ACTIVITY





Column Detail - SI_DOCUMENT_INFO


Column Name Type Null? Definition
BEGIN_QUAL_DT_TM DATETIME Y The beginning point for qualifying data for inclusion when asssembling an on demand CDA.
DOCUMENT_UUID VARCHAR(255) Y A system generated Unique Identifier for the document. Only assigned when the custodial organization does not have an OID
DOC_SET_ROOT_EXTENSION VARCHAR(255) N The set id for this CDA document.
DOC_VERSION_NBR DOUBLE Y The version number of current CDA document associated with the event_id.
ENCNTR_ID DOUBLE N Foreign key to Encounter Table, used for encounter level documents.
END_QUAL_DT_TM DATETIME Y The ending point for qualifying data for inclusion when asssembling an on demand CDA.
EVENT_ID DOUBLE N A unique identifier to an event, used for events level documents. From the CLINICAL_EVENT table EVENT_ID column.
MEDIA_OBJECT_IDENTIFIER VARCHAR(64) Y Identifier of the document object if stored in the multimedia storage.
MEDIA_OBJECT_VERSION_NBR DOUBLE N Version of the identified document object in the multimedia storage.
ON_DEMAND_IND DOUBLE N True when the document is to be generated on-demand
ORGANIZATION_ID DOUBLE N The organization responsible for stewardship of the document.
OUTPUT_CONTENT_TYPE_CD DOUBLE N This defines the type of document being registered.
PARENT_SI_DOCUMENT_INFO_ID DOUBLE N The related document in this table
PERSON_ID DOUBLE N Person related to the document being sent.
REPORT_TEMPLATE_ID DOUBLE N The Template Identifier used by CDG to build the dataset for transformation.
SCH_EVENT_ID DOUBLE N Foreign key to the SCH_EVENT table. This will be populated when documents are generated for visits.
SI_DOCUMENT_INFO_ID DOUBLE N Primary Key to the SI_Document_Info table.
SI_TEMPLATE_GROUP_ID DOUBLE N The Template Group used to create the document. This will be used for debugging and reporting purposes.
START_DT_TM DATETIME Y the 388 service call time where we can log the service invoke timestamp.
SUMMARY_CARE_TYPE_CD DOUBLE N This field will be populated if the generated document is marked as a summary of care document by the selected report template.
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.
VALIDATION_VAL DOUBLE Y Indicates whether the generated document is a valid document. It will use bit-operators to determine which sections were mandatory and failed validation.
VALID_FROM_DT_TM DATETIME Y Contains the Beginning Point of when the event is valid, used for event level documents.



Relationship Detail - SI_DOCUMENT_INFO


Child Column in SI_DOCUMENT_INFO(FK) Parent Table Name Parent Column Name
Parents: REPORT_TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
PARENT_SI_DOCUMENT_INFO_ID SI_DOCUMENT_INFO SI_DOCUMENT_INFO_ID
SI_TEMPLATE_GROUP_ID SI_TEMPLATE_GROUP SI_TEMPLATE_GROUP_ID




Parent Column in SI_DOCUMENT_INFO (PK) Child Table Name Child Column Name
Children: SI_DOCUMENT_INFO_ID SI_DOCUMENT_IDENTIFIER_R SI_DOCUMENT_INFO_ID
SI_DOCUMENT_INFO PARENT_SI_DOCUMENT_INFO_ID
SI_DOCUMENT_RECIPIENT_RELTN SI_DOCUMENT_INFO_ID
SI_DOCUMENT_TRANSACTION_LOG SI_DOCUMENT_INFO_ID
SI_REPO_REG_RELTN SI_DOCUMENT_INFO_ID