Table Detail Report

ENCNTR_PLAN_DATE_PRD_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Plan Date Period History
Definition: Contains historical records from the ENCNTR_PLAN_DATE_PERIOD table.
Table Type: ACTIVITY





Column Detail - ENCNTR_PLAN_DATE_PRD_HIST


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
DATE_PERIOD_TYPE_CD DOUBLE N Identifies the type of date/time period for this row.
ENCNTR_PLAN_DATE_PERIOD_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_PLAN_DATE_PERIOD table for which this history is maintained.
ENCNTR_PLAN_DATE_PRD_HIST_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_PLAN_DATE_PRD_HIST table for which this history is maintained.
FIRST_DATE DATETIME Y The first date in the period. Although this is capable of storing the time component of a date, it should be ignored since date periods from an X12 transaction do not contain a time component. This date should be treated as an absolute date and the standard Millennium practice of utc/local time zone translations should not be applied when reading and writing.
PARENT_ENTITY_ID DOUBLE N The unique identifier of the parent table to which this data belongs.
PARENT_ENTITY_NAME VARCHAR(30) N The uppercase name of the parent table to which this data belongs.
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
SECOND_DATE DATETIME Y The second date in the period. Although this is capable of storing the time component of a date, it should be ignored since date periods from an X12 transaction do not contain a time component. This date should be treated as an absolute date and the standard Millennium practice of utc/local time zone translations should not be applied when reading and writing.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
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 - ENCNTR_PLAN_DATE_PRD_HIST


Child Column in ENCNTR_PLAN_DATE_PRD_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_PLAN_DATE_PERIOD_ID ENCNTR_PLAN_DATE_PERIOD ENCNTR_PLAN_DATE_PERIOD_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


ENCNTR_PLAN_ELIGIBILITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter PLan Eligibility
Definition: The encounter health plan table contains information about the various service type, coverage level, insurance type, and in plan network combinations for the health plan and the patient's eligibility status for each combination at the time of the visit. Information will typically be obtained from the payer via the X12 270/271 transaction but will on occasion be added or modified directly by the end user.
Table Type: ACTIVITY





Column Detail - ENCNTR_PLAN_ELIGIBILITY


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
AUTH_REQUIRED_CD DOUBLE N Indicates if an authorization is required for the given service per plan provisions.
COVERAGE_LEVEL_CD DOUBLE N The coverage level for which the eligibility and any associated benefits apply. It identifies the types and number of entities that are covered by the insurance plan.
ELIGIBILITY_STATUS_CD DOUBLE N The eligibility status of the patient.
ENCNTR_PLAN_ELIGIBILITY_ID DOUBLE N This is the value of the unique primary identifier of the encntr_plan_eligibility table. It is an internally assigned number and generally not revealed to the user.
ENCNTR_PLAN_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the encntr_plan_reltn table. It is an internal system assigned number.
INFO_SOURCE_CD DOUBLE N Designates the information source from which the benefit data was obtained.
INSURANCE_TYPE_CD DOUBLE N Type of insurance policy within a specific insurance program for which the eligibility and any associated benefits apply.
IN_PLAN_NETWORK_CD DOUBLE N Indicates if the eligibility and associated benefits apply in network or out of network.
PAYER_PROV_PLAN_NAME VARCHAR(100) Y The name of the health plan as provided by the payer (carrier).
PROC_NOMEN_ID DOUBLE N This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number. It identifies a HCPCS, CPT, ICD-9-CM or ICD-10-PCS procedure code.
SERVICE_TYPE_CD DOUBLE N The type of service for which the eligibility and any associated benefits apply.
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 - ENCNTR_PLAN_ELIGIBILITY


Child Column in ENCNTR_PLAN_ELIGIBILITY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_PLAN_RELTN_ID ENCNTR_PLAN_RELTN ENCNTR_PLAN_RELTN_ID
PROC_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID




Parent Column in ENCNTR_PLAN_ELIGIBILITY (PK) Child Table Name Child Column Name
Children: ENCNTR_PLAN_ELIGIBILITY_ID ENCNTR_PLAN_ELIG_BENEFIT ENCNTR_PLAN_ELIGIBILITY_ID
ENCNTR_PLAN_ELIG_BNFT_HIST ENCNTR_PLAN_ELIGIBILITY_ID
ENCNTR_PLAN_ELIG_HIST ENCNTR_PLAN_ELIGIBILITY_ID


ENCNTR_PLAN_ELIG_BENEFIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Health Plan Eligibility Benefit
Definition: The encounter health plan eligibility benefit table contains information about the benefits that a patient is offered via their health plan for a particular eligibility. Information will typically be obtained from the payer via the X12 270/271 transaction but will also be added or modified directly by the end user.
Table Type: ACTIVITY





Column Detail - ENCNTR_PLAN_ELIG_BENEFIT


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BENEFIT_COMMENTS_LONG_TEXT_ID DOUBLE N Comment identifier for free text stored on the LONG_TEXT table which representsadditional comments, description, or notes for the benefit.
BENEFIT_MONETARY_AMT DOUBLE Y The monetary amount associated with the benefit.
BENEFIT_PCT DOUBLE Y The numeric percentage associated with the benefit.
BENEFIT_QTY DOUBLE Y The quantity associated with the benefit.
BENEFIT_QTY_QUAL_CD DOUBLE N Qualifies the type of quantity associated with the benefit.Code Set: 26311
BENEFIT_TIME_PERIOD_QUAL_CD DOUBLE N Qualifies the time period of the benefits availability. Code Set: 26335
BENEFIT_TYPE_CD DOUBLE N Identifies the type of benefit for the benefit row.Code Set: 26307
ENCNTR_PLAN_ELIGIBILITY_ID DOUBLE N Identifies the row on the Encntr_plan_eligibility table that benefit is for.
ENCNTR_PLAN_ELIG_BENEFIT_ID DOUBLE N This is the value of the unique primary identifier of this table. It is an internal system assigned number.
INFO_SOURCE_CD DOUBLE N Represents from what information source the benefit data was obtained.Code Set: 4002563
SELECTED_IND DOUBLE N Indicates if the benefit has been selected as being directly applicable for the encounter.
TRANSACTION_SOURCE_IDENT VARCHAR(50) Y The transaction identifier assigned by transaction services which was the source of the benefit data.
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 - ENCNTR_PLAN_ELIG_BENEFIT


Child Column in ENCNTR_PLAN_ELIG_BENEFIT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_PLAN_ELIGIBILITY_ID ENCNTR_PLAN_ELIGIBILITY ENCNTR_PLAN_ELIGIBILITY_ID




Parent Column in ENCNTR_PLAN_ELIG_BENEFIT (PK) Child Table Name Child Column Name
Children: ENCNTR_PLAN_ELIG_BENEFIT_ID ENCNTR_PLAN_ELIG_BNFT_HIST ENCNTR_PLAN_ELIG_BENEFIT_ID


ENCNTR_PLAN_ELIG_BNFT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Plan Eligibility Benefit History
Definition: Table stores historical information on health plan eligibility benefit data for an encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_PLAN_ELIG_BNFT_HIST


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BENEFIT_COMMENTS_LONG_TEXT_ID DOUBLE N Comment identifier for free text stored on the LONG_TEXT table which represents additional comments, description, or notes for the benefit.
BENEFIT_MONETARY_AMT DOUBLE Y The monetary amount associated with the benefit.
BENEFIT_PCT DOUBLE Y The numeric percentage associated with the benefit.
BENEFIT_QTY DOUBLE Y The quantity associated with the benefit.
BENEFIT_QTY_QUAL_CD DOUBLE N Qualifies the type of quantity associated with the benefit.
BENEFIT_TIME_PERIOD_QUAL_CD DOUBLE N Qualifies the time period of the benefit's availablity
BENEFIT_TYPE_CD DOUBLE N Identifies the type of benefit for the benefit row.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
ENCNTR_PLAN_ELIGIBILITY_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_PLAN_ELIGIBILITY table to which this benefit applies.
ENCNTR_PLAN_ELIG_BENEFIT_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_PLAN_ELIG_BENEFIT table for which this history is maintained.
ENCNTR_PLAN_ELIG_BNFT_HIST_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_PLAN_ELIG_BNFT_HIST table.
INFO_SOURCE_CD DOUBLE N Designates the information source from which the benefit data was obtained.
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
SELECTED_IND DOUBLE N Indicates if the benefit has been selected as being directly applicable for the encounter.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_SOURCE_IDENT VARCHAR(50) Y The identifier of the transaction that was the source of this elegibility benefit data when a transaction was used to verify eligibility for a patient.
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 - ENCNTR_PLAN_ELIG_BNFT_HIST


Child Column in ENCNTR_PLAN_ELIG_BNFT_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_PLAN_ELIGIBILITY_ID ENCNTR_PLAN_ELIGIBILITY ENCNTR_PLAN_ELIGIBILITY_ID
ENCNTR_PLAN_ELIG_BENEFIT_ID ENCNTR_PLAN_ELIG_BENEFIT ENCNTR_PLAN_ELIG_BENEFIT_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


ENCNTR_PLAN_ELIG_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Plan Eligibility History
Definition: Table stores historical information on health plan eligibility benefit data for an encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_PLAN_ELIG_HIST


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
AUTH_REQUIRED_CD DOUBLE N Indicates if an authorization is required for the given service per plan provisions.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
COVERAGE_LEVEL_CD DOUBLE N The coverage level for which the eligibility and any associated benefits apply, it identifies the types and number of entities that are covered by the insurance plan.
ELIGIBILITY_STATUS_CD DOUBLE N The eligibility status of the patient.
ENCNTR_PLAN_ELIGIBILITY_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_PLAN_ELIGIBILITY table for which this history is maintained.
ENCNTR_PLAN_ELIG_HIST_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_PLAN_ELIG_HIST
ENCNTR_PLAN_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_PLAN_RELTN table. Identifies the health plan for which the patient's eligibility was verified.
INFO_SOURCE_CD DOUBLE N Designates the information source from which the eligibility benefit data was obtained.
INSURANCE_TYPE_CD DOUBLE N Type of insurance policy within a specific insurance program for which the eligibility and any associated benefits apply.
IN_PLAN_NETWORK_CD DOUBLE N Indicates if the eligibility and associated benefits apply in network or out of network.
PAYER_PROV_PLAN_NAME VARCHAR(100) Y The name of the health plan as provided by the payer (carrier).
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
PROC_NOMEN_ID DOUBLE N Unique generated number that identifies a single row on the NOMENCLATURE table. It identifies a hcpcs, cpt, icd-9-cm or icd-10-pcs procedure code for which the eligibility and any associated benefits apply.
SERVICE_TYPE_CD DOUBLE N The type of service for which the eligibility and any associated benefits apply.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
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 - ENCNTR_PLAN_ELIG_HIST


Child Column in ENCNTR_PLAN_ELIG_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_PLAN_ELIGIBILITY_ID ENCNTR_PLAN_ELIGIBILITY ENCNTR_PLAN_ELIGIBILITY_ID
ENCNTR_PLAN_RELTN_ID ENCNTR_PLAN_RELTN ENCNTR_PLAN_RELTN_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID