Table Detail Report

TRANSACTION_BATCH_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Batch Log
Definition: The Transaction Batch Log links groups of transactions to the parent process that initiated the batch.
Table Type: ACTIVITY





Column Detail - TRANSACTION_BATCH_LOG


Column Name Type Null? Definition
COMPLETE_DT_TM DATETIME Y The date and time this batch completed processing.
PARENT_ENTITY_ID DOUBLE N The parent entity identifier to which the batch belongs.
PARENT_ENTITY_NAME VARCHAR(30) N The parent entity table name to which the batch belongs.
SUBMIT_DT_TM DATETIME N Date and time the batch was submitted for processing.
TRANSACTION_BATCH_LOG_ID DOUBLE N Unique generated number that identifies a single row on the TRANSACTION_BATCH_LOG table.
TRANSACTION_BATCH_RUN_TYPE_CD DOUBLE N Denotes what type of process triggered the batch process. (e.g.: Custom, System)
TRANSACTION_BATCH_TYPE_CD DOUBLE N The type of transaction that was processed in a batch. (e.g.: Eligibility)
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 - TRANSACTION_BATCH_LOG




Parent Column in TRANSACTION_BATCH_LOG (PK) Child Table Name Child Column Name
Children: TRANSACTION_BATCH_LOG_ID TRANSACTION_ELIGIBILITY TRANSACTION_BATCH_LOG_ID


TRANSACTION_ELIGIBILITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Eligibility
Definition: Table stores information to track eligibility transaction history for patients and encounters.
Table Type: ACTIVITY





Column Detail - TRANSACTION_ELIGIBILITY


Column Name Type Null? Definition
CACHE_DT_TM DATETIME Y The date and time the transaction was originally returned by the payer and cached within Transaction Services' system.
CACHE_EXPIRE_DT_TM DATETIME Y The date and time the cached transaction expires. After this point in time, the eligibility data from the response message is stale.
COVERAGE_STATUS_CD DOUBLE N The aggregate coverage status for all benefits within this eligibility transaction.
ENCNTR_ID DOUBLE N The unique identifier to the encounter table. If populated, eligibility was checked during the given encounter.
ENCNTR_PLAN_RELTN_ID DOUBLE N The identifier of the encounter plan relationship for which the eligibility transaction request was published.
EXT_PAYER_IDENT VARCHAR(100) Y The primary identifier of the organization providing the insurance plan (carrier) used by external systems to identify the organization and will only be populated when the organization does not exist in the Millennium build.
HEALTH_PLAN_ID DOUBLE Y Uniquely identifies the related Health Plan record on the HEALTH_PLAN table.
ORGANIZATION_ID DOUBLE N Uniquely identifies the facility organization that shall provide services to the patient. Identifying information for the facility that was sent to the payer.
ORIGINATING_TRANS_ELIG_ID DOUBLE Y The identifier of the transaction_eligibility table that identifies the eligibility transaction that initiated the publishing of this subsequent eligibility transaction. If this column is populated, this transaction was triggered from a secondary inquiry rule.
PAYER_ID DOUBLE N The unique identifier to the organization table defining the payer from which eligibility was requested.
PERSON_ID DOUBLE N The unique identifier to the person table for the patient whose eligibility was checked via this transaction.
PERSON_PLAN_RELTN_ID DOUBLE N The identifier of the person plan relationship for which the eligibility transaction request was published.
PROCESS_STATUS_CD DOUBLE N A code to define the current state of the automated processing of the transaction data.
REPLY_DT_TM DATETIME Y The date and time the eligibility transaction response was received inbound.
REQUESTED_BEG_COVERAGE_DT_TXT VARCHAR(10) Y The beginning of the plan coverage date range for which eligibility was requested of the payer. If only one date was provided, plan coverage information was requested for that single date. Date format is YYYY-MM-DD.
REQUESTED_END_COVERAGE_DT_TXT VARCHAR(10) Y The end of the plan coverage date range for which eligibility was requested of the payer. Date format is YYYY-MM-DD.
REVIEWER_LONG_TEXT_ID DOUBLE N The identifier of the long_text table row containing the reviewers comments.
REVIEWER_PRSNL_ID DOUBLE N The identifier of the personnel that last modified the manual reviewer status.
REVIEWER_STATUS_CD DOUBLE N The current transaction's manual processing status as defined by the latest reviewing personnel.
REVIEWER_UPDT_DT_TM DATETIME Y Date and time of the last status update by a reviewing personnel.
SENT_DT_TM DATETIME Y The date and time the eligibility transaction was sent outbound.
SUBMITTER_PRSNL_ID DOUBLE N This is the unique identifier of the personnel that initiated publishing of the transaction to request eligibility.
TRANSACTION_BATCH_LOG_ID DOUBLE N The primary key from the TRANSACTION_BATCH_LOG table. The identifier of the transaction_batch_log row to which this transaction is related.
TRANSACTION_ELIGIBILITY_ID DOUBLE N This is the primary identifier of the transaction_eligibility table.
TRANSACTION_SOURCE_IDENT VARCHAR(50) N The transaction identifier assigned by Transaction Services. Used to retrieve transaction details.
TRANSACTION_STATUS_CD DOUBLE N The high level status of the transaction.
TRANSACTION_TYPE_CD DOUBLE N The type of the eligibility transaction. It indicates from where the patient¿s eligibility transaction is requested and retrieved. For example, MED_ELIG is processed through Transaction Services while FC_MED_ELIG is processed through Financial Clearance.
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 - TRANSACTION_ELIGIBILITY


Child Column in TRANSACTION_ELIGIBILITY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_PLAN_RELTN_ID ENCNTR_PLAN_RELTN ENCNTR_PLAN_RELTN_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
REVIEWER_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PAYER_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PERSON_PLAN_RELTN_ID PERSON_PLAN_RELTN PERSON_PLAN_RELTN_ID
REVIEWER_PRSNL_ID PRSNL PERSON_ID
SUBMITTER_PRSNL_ID PRSNL PERSON_ID
TRANSACTION_BATCH_LOG_ID TRANSACTION_BATCH_LOG TRANSACTION_BATCH_LOG_ID
ORIGINATING_TRANS_ELIG_ID TRANSACTION_ELIGIBILITY TRANSACTION_ELIGIBILITY_ID




Parent Column in TRANSACTION_ELIGIBILITY (PK) Child Table Name Child Column Name
Children: TRANSACTION_ELIGIBILITY_ID TRANSACTION_ELIGIBILITY ORIGINATING_TRANS_ELIG_ID
TRANSACTION_ELIG_ALERT TRANSACTION_ELIGIBILITY_ID
TRANSACTION_ELIG_CLOB TRANSACTION_ELIGIBILITY_ID
TRANSACTION_ELIG_ERROR TRANSACTION_ELIGIBILITY_ID
TRANSACTION_ELIG_SERVICE TRANSACTION_ELIGIBILITY_ID
TRANS_ELIG_AUTO_PLAN TRANSACTION_ELIGIBILITY_ID


TRANSACTION_ELIG_ALERT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Eligibility Alert
Definition: Use this table to store details for transactions with alerts posted. An alert signifies that the eligibility response contains data that may need to be reviewed.
Table Type: ACTIVITY





Column Detail - TRANSACTION_ELIG_ALERT


Column Name Type Null? Definition
ALERT_CD DOUBLE N An alert signifies that a condition exists within an eligibility transaction that may warrant a manual review.
TRANSACTION_ELIGIBILITY_ID DOUBLE N The identifier of the TRANSACTION_ELIGIBILITY table to which this alert is related.
TRANSACTION_ELIG_ALERT_ID DOUBLE N The unique primary key of this table. It is an internally generated number.
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 - TRANSACTION_ELIG_ALERT


Child Column in TRANSACTION_ELIG_ALERT(FK) Parent Table Name Parent Column Name
Parents: TRANSACTION_ELIGIBILITY_ID TRANSACTION_ELIGIBILITY TRANSACTION_ELIGIBILITY_ID


TRANSACTION_ELIG_CLOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Eligibility Clob
Definition: Table stores the eligibility response for an eligibility transaction
Table Type: ACTIVITY





Column Detail - TRANSACTION_ELIG_CLOB


Column Name Type Null? Definition
TRANSACTION_ELIGIBILITY_ID DOUBLE N The identifier of the transaction_eligibility table to which this eligibility message is related.
TRANSACTION_ELIG_CLOB_ID DOUBLE N Unique generated number that identifies a single row on the TRANSACTION_ELIG_CLOB table.
TRANS_MESSAGE_CLOB LONGTEXT Y Contains the eligibility transaction response message.
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 - TRANSACTION_ELIG_CLOB


Child Column in TRANSACTION_ELIG_CLOB(FK) Parent Table Name Parent Column Name
Parents: TRANSACTION_ELIGIBILITY_ID TRANSACTION_ELIGIBILITY TRANSACTION_ELIGIBILITY_ID


TRANSACTION_ELIG_ERROR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Eligiblity Error
Definition: Use this table to store details for transactions in an error state.
Table Type: ACTIVITY





Column Detail - TRANSACTION_ELIG_ERROR


Column Name Type Null? Definition
ERROR_LOCATION_CD DOUBLE N The location code describes where the error occurred while processing the eligibility transaction.
FOLLOW_UP_ACTION_CD DOUBLE N This code instructs the recipient of the eligibility response about what action needs to be taken.
LONG_TEXT_ID DOUBLE N This is the identifier of the long_text table row containing the error's text message.
REJECT_REASON_CD DOUBLE N This code defines the reason why the transaction was unable to be processed successfully.
TRANSACTION_ELIGIBILITY_ID DOUBLE N The identifier of the TRANSACTION_ELIGIBILITY table to which this error is related.
TRANSACTION_ELIG_ERROR_ID DOUBLE N The unique primary key of this table. It is internally generated.
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 - TRANSACTION_ELIG_ERROR


Child Column in TRANSACTION_ELIG_ERROR(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
TRANSACTION_ELIGIBILITY_ID TRANSACTION_ELIGIBILITY TRANSACTION_ELIGIBILITY_ID