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 |