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 |