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 |