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 |