Table Detail Report

TRANSACTION_ELIG_SERVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Eligibility Service
Definition: Table stores service types as submitted on the eligibility inquiry.
Table Type: ACTIVITY





Column Detail - TRANSACTION_ELIG_SERVICE


Column Name Type Null? Definition
SERVICE_TYPE_CD DOUBLE N The type of service for which eligibility was requested for a patient.
TRANSACTION_ELIGIBILITY_ID DOUBLE N Identifier of the transaction_eligibility table to which this service type is related.
TRANSACTION_ELIG_SERVICE_ID DOUBLE N Unique generated number that identifies a single row on the TRANSACTION_ELIG_SERVICE table.
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_SERVICE


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


TRANS_ELIG_AUTO_PLAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Eligibility Automatic Health Plan Deferred Rule Processing
Definition: Table is used to store the rule information necessary for automatic encounter or person health plan relatonship additions or updates that could not be processed immediately upon the receival of eligibility response.
Table Type: ACTIVITY





Column Detail - TRANS_ELIG_AUTO_PLAN


Column Name Type Null? Definition
AUTO_SECONDARY_INQ_IND DOUBLE Y Indicates if a secondary eligibility inquiry should be published automatically.
AUTO_SECONDARY_INQ_RANGE_DAYS DOUBLE Y The time range, in calendar days, used to search for past eligibility inquiries when determining if an automatic secondary eligibility inquiry should be published. If the Auto Secondary Inquiry Indicator is 1 and the Auto Secondary Inquiry Range Days is 0, ignore past eligibility inquiries and automatically publish a secondary inquiry.
AUTO_SEC_INQ_BEG_COV_DT_ISO VARCHAR(10) Y The plan coverage date for which eligibility is requested of the payer when publishing an automatic secondary eligibility inquiry. Date format is YYYY-MM-DD. Currently only a range of a single day is supported.
GROUP_NAME VARCHAR(200) Y The group name associated to the health plan identifier returned by the eligibility response rule. Used for automated processing of the health plan relationship.
GROUP_NBR VARCHAR(100) Y The group number associated to the health plan identifier returned by the eligibility response rule. Used for automated processing of the health plan relationship.
HEALTH_PLAN_ID DOUBLE N The Millennium health plan identifier returned by the eligibility response rules to be used for automated processing of the health plan relationship.
MEMBER_NBR VARCHAR(100) Y The member number associated to the health plan identifier returned by the eligibility response rule. Used for automated processing of the health plan relationship.
RULE_TYPE_CD DOUBLE N The type of rule used to determine how the health plan relationship should be processed based of the eligibility response. For example add or update.
STATUS_CD DOUBLE N Defines the current state of the eligibility response rule to determine if processing is still necessary.
TRANSACTION_ELIGIBILITY_ID DOUBLE N The identifier of the transaction_eligibility table to which this auto plan is related.
TRANS_ELIG_AUTO_PLAN_ID DOUBLE N Unique generated number that identifies a single row on the TRANS_ELIG_AUTO_PLAN table.
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 - TRANS_ELIG_AUTO_PLAN


Child Column in TRANS_ELIG_AUTO_PLAN(FK) Parent Table Name Parent Column Name
Parents: HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
TRANSACTION_ELIGIBILITY_ID TRANSACTION_ELIGIBILITY TRANSACTION_ELIGIBILITY_ID