Table Detail Report

SI_DOCUMENT_RECIPIENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: SI_DOCUMENT_RECIPIENT_RELTN
Definition: This table stores the relationship between documents and their recipients along with the status of any email communication.
Table Type: ACTIVITY





Column Detail - SI_DOCUMENT_RECIPIENT_RELTN


Column Name Type Null? Definition
BOUNCE_BACK_IND DOUBLE N When valued, our system was sent an indicator that this document was unable to be delivered to the given recipient.
MESSAGE_IDENT VARCHAR(255) Y The message identifier generated at the time that the document was delievered to the recipient.
PARENT_ENTITY_ID DOUBLE N Foreign key relationships from the tables defined by the parent entity name
PARENT_ENTITY_NAME VARCHAR(32) N Name of parent entities that can relate to the document (CE_EVENT_PRSNL, CONTRIBUTOR_SYSTEM, CR_OUTPUT_DESTINATION, CR_REPORT_REQUEST, DEVICE, EMAIL_INFO, PRSNL)
RECIPIENT_TYPE VARCHAR(32) N The type of medium used to send the document to the given recipient. This will include: EMAIL, PRINT, FAX, FILE, CONTRIBUTOR_SYSTEM, DEVICE, MULTI, PUBLISH
SI_DOCUMENT_INFO_ID DOUBLE N Foreign key relationship to the si_document_info table.
SI_DOCUMENT_RECIPIENT_RELTN_ID DOUBLE N Unique generated number - Primary Key
SUBMISSION_DT_TM DATETIME N The date that the given document was sent to the given recipient
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_RECIPIENT_RELTN


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


SI_DOC_VALIDATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Document Validation
Definition: Stores the validation information associated with a document.
Table Type: ACTIVITY





Column Detail - SI_DOC_VALIDATION


Column Name Type Null? Definition
END_DT_TM DATETIME Y The date the validation completed/ended.
MEDIA_OBJECT_IDENTIFIER VARCHAR(64) N The unique identifier for the document in CAMM.
MEDIA_OBJECT_VERSION_NBR DOUBLE N The version of the document in CAMM.
SI_DOC_VALIDATION_ID DOUBLE N PRIMARY KEY
START_DT_TM DATETIME Y The date the validation occurred/started.
STATUS_FLAG DOUBLE N Status of the validation.0 = Unknown, 1 = In Progress, 2 = In Error, 3 = Complete
STATUS_TXT VARCHAR(500) N Detailed status text.
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.
VALID_IND DOUBLE N Indicates whether the document is valid.0 = Unknown or Failed, 1 = Valid
VAL_INFO_BLOB_ID DOUBLE N The validation information from the LONG_BLOB table



Relationship Detail - SI_DOC_VALIDATION


Child Column in SI_DOC_VALIDATION(FK) Parent Table Name Parent Column Name
Parents: VAL_INFO_BLOB_ID LONG_BLOB LONG_BLOB_ID


SI_ENTITY_TEMPLATE_GROUP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Device Output Template Relation
Definition: Stores template group information related to external entities such as Device_Output_Reltn.
Table Type: REFERENCE





Column Detail - SI_ENTITY_TEMPLATE_GROUP_R


Column Name Type Null? Definition
DEFAULT_IND DOUBLE N When this field is set to 1,the relationship is considered the default template group for the given entity.
PARENT_ENTITY_ID DOUBLE N The ID of the table that relates information to template groups. Initially it will be DEVICE_OUTPUT_RELTN
PARENT_ENTITY_NAME VARCHAR(30) N The name of the table that relates information to template groups.
REPORT_TEMPLATE_ID DOUBLE N foreign key value from the cr_report_template table.
RESULT_TYPE_FLAG DOUBLE N Indicates the type of report being generated. This is used as part of the decision porcess for finding Template Groups
SI_ENTITY_TEMPLATE_GROUP_R_ID DOUBLE N The primary Identifier
SI_TEMPLATE_GROUP_ID DOUBLE N Foreign key to the SI_TEMPLATE_GROUP table. This will tie the selected template group with the appropriate device/output combination.
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_ENTITY_TEMPLATE_GROUP_R


Child Column in SI_ENTITY_TEMPLATE_GROUP_R(FK) Parent Table Name Parent Column Name
Parents: REPORT_TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID
SI_TEMPLATE_GROUP_ID SI_TEMPLATE_GROUP SI_TEMPLATE_GROUP_ID


SI_EPA_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: SI Electronic Prior Authorization Log
Definition: Log of various elements of the request initiation and response so that it can be accessed for use in subsequent transactions
Table Type: ACTIVITY





Column Detail - SI_EPA_LOG


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.
CAMM_IDENT VARCHAR(50) Y Reference to an attached document in CAMM - this is a GUID field
CASE_IDENT VARCHAR(35) Y case identifier assigned by the payor. It must be echoed in all subsequent requests.
CREATE_DT_TM DATETIME Y Date/Time at which the row was originally written
DEADLINE_FOR_REPLY VARCHAR(50) Y This is an iso 8601 formatted date or date/time value. It must be echoed in subsequent requests in the exact same format.
LONG_BLOB_ID DOUBLE N Link to row on long_blob table
MESSAGE_IDENT VARCHAR(35) Y Transaction message identifier
MSG_TYPE_FLAG DOUBLE Y Indicator of whether this is the echo from PAInitationRequest (1), or the question set from: PAInitationRequest (1), PAInitiationResponse (2), PAResponse(3), PARequest(4), PACancel (5), Error(6), Status(7), PACancelResponse(8), RetrospectivePA (9), RetrospectiveClaimed (10), RxChangeRequest (11), Retrospective PA Response (12)
REFERENCE_IDENT VARCHAR(35) Y UUID assigned by the prescribing system on the initial transaction used as a tracking identifier on all subsequent request and response transactions
SI_EPA_LOG_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_EPA_LOG


Child Column in SI_EPA_LOG(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID


SI_EPRESCRIBE_REQ_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: SI ePrescribe Request Log
Definition: Full log of inbound ePrescribe message data for use in situations where that same data must be echoed back outbound
Table Type: ACTIVITY





Column Detail - SI_EPRESCRIBE_REQ_LOG


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y Date/Time at which the row was originally written
LONG_BLOB_ID DOUBLE N Link to row on long_blob table
MESSAGE_IDENT VARCHAR(35) N Transaction message identifier
SI_EPRESCRIBE_REQ_LOG_ID DOUBLE N Unique generated number that identifies a single row onthe table ( Primary Key )
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_EPRESCRIBE_REQ_LOG


Child Column in SI_EPRESCRIBE_REQ_LOG(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID