Table Detail Report
ENCNTR_PLAN_COB
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Plan Coordination of Benefits |
Definition: | This table along with the encounter plan coordination of benefits relationship table are used to order and group encounter health plan coverages into sets for a particular type of coverage. The ordering should be based on which health plan payer has primary reimbursement responsibility for the type of coverage. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_PLAN_COB
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BEG_EFFECTIVE_TZ | DOUBLE | Y | The time zone associated with the beg_effective_dt_tm column. |
COB_TYPE_CD | DOUBLE | N | The code value indicates the type of health insurance coordination of benefits set for the encounter plan coordination of benefits row (i.e., professional, institutional, workman's comp). |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the related Encounter. |
ENCNTR_PLAN_COB_ID | DOUBLE | N | Uniquely identifies a set of health plan coordination of benefits for an encounter. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
END_EFFECTIVE_TZ | DOUBLE | Y | The time zone associated with the end_effective_dt_tm column. |
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_COB
Child Column in ENCNTR_PLAN_COB(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
Parent Column in ENCNTR_PLAN_COB (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENCNTR_PLAN_COB_ID | ENCNTR_PLAN_COB_HIST | ENCNTR_PLAN_COB_ID |
ENCNTR_PLAN_COB_RELTN | ENCNTR_PLAN_COB_ID | ||
PFT_ENCNTR | ENCNTR_PLAN_COB_ID |
ENCNTR_PLAN_COB_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Plan Coordination of Benefits History |
Definition: | Used for tracking history of changes to ENCNTR_PLAN_COB rows. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_PLAN_COB_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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BEG_EFFECTIVE_TZ | DOUBLE | Y | The time zone associated with the beg_effective_dt_tm column. |
CHANGE_BIT | DOUBLE | N | Identifies which columns have had a change. |
COB_TYPE_CD | DOUBLE | N | The code value indicates the type of health insurance coordination of benefits set for the encounter plan coordination of benefits row (i.e., professional, institutional, workman's comp). |
ENCNTR_PLAN_COB_HIST_ID | DOUBLE | N | This is the value of the unique primary identifier of the encntr_plan_cob_hist table. It is an internal system assigned number. |
ENCNTR_PLAN_COB_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter health plan coordination of benefits table. It is an internal system assigned number. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
END_EFFECTIVE_TZ | DOUBLE | Y | The time zone associated with the end_effective_dt_tm column. |
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. |
TRACKING_BIT | DOUBLE | N | Identifies which columns are being tracked for history. |
TRANSACTION_DT_TM | DATETIME | Y | ** OBSOLETE **. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time. |
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_COB_HIST
Child Column in ENCNTR_PLAN_COB_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_PLAN_COB_ID | ENCNTR_PLAN_COB | ENCNTR_PLAN_COB_ID |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID |
ENCNTR_PLAN_COB_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Plan Coordination of Benefits Relationship |
Definition: | The encounter health plan-coordination of benefits relationship table defines the set of encounter health plans that are a part of a particular insurance coordination of benefits set and their priority within the coordination of benefits set. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_PLAN_COB_RELTN
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. |
ENCNTR_PLAN_COB_ID | DOUBLE | N | Uniquely identifies the related encounter health plan coordination of benefits. |
ENCNTR_PLAN_COB_RELTN_ID | DOUBLE | N | Uniquely identifies a relationship between an encounter health plan and a particular insurance coordination of benefits set. |
ENCNTR_PLAN_RELTN_ID | DOUBLE | N | Uniquely identifies the related encounter health plan relationship. |
PRIORITY_SEQ | DOUBLE | N | This is a numeric number used to represent the order in which to consider this health plan for reimbursement for this insurance coordination of benefits, if the person is a member of more than one health plan. The priority_seq is 1-based. |
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_COB_RELTN
Child Column in ENCNTR_PLAN_COB_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_PLAN_COB_ID | ENCNTR_PLAN_COB | ENCNTR_PLAN_COB_ID |
ENCNTR_PLAN_RELTN_ID | ENCNTR_PLAN_RELTN | ENCNTR_PLAN_RELTN_ID |
Parent Column in ENCNTR_PLAN_COB_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENCNTR_PLAN_COB_RELTN_ID | ENCNTR_PLAN_COB_R_HIST | ENCNTR_PLAN_COB_RELTN_ID |
ENCNTR_PLAN_COB_R_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Plan Profile Relationship History |
Definition: | Used for tracking history of changes to ENCNTR_PLAN_COB_RELTN rows |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_PLAN_COB_R_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. |
ENCNTR_PLAN_COB_ID | DOUBLE | N | Uniquely identifies the related encounter health plan coordination of benefits. |
ENCNTR_PLAN_COB_RELTN_ID | DOUBLE | N | Uniquely identifies a relationship between an encounter health plan and a particular insurance coordination of benefits set. |
ENCNTR_PLAN_COB_R_HIST_ID | DOUBLE | N | Uniquely identifies a change to an encntr_plan_cob_reltn row. |
ENCNTR_PLAN_RELTN_ID | DOUBLE | N | Uniquely identifies the related encounter health plan relationship. |
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. |
PRIORITY_SEQ | DOUBLE | N | This is a numeric number used to represent the order in which to consider this health plan for reimbursement for this insurance profile, if the person is a member of more than one health plan. The priority_seq is 1-based. |
TRACKING_BIT | DOUBLE | N | Identifies which columns are being tracked for history. |
TRANSACTION_DT_TM | DATETIME | Y | ** Obsolete ** This column has been obsoleted. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time. |
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_COB_R_HIST
Child Column in ENCNTR_PLAN_COB_R_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_PLAN_COB_RELTN_ID | ENCNTR_PLAN_COB_RELTN | ENCNTR_PLAN_COB_RELTN_ID |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID |
ENCNTR_PLAN_DATE_PERIOD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Plan Date Period |
Definition: | The encounter health plan date period table is a generic table for storing date range(s) of various components of the encounter health plan data model (e.g. eligibilities and benefits etc...) . Information will typically be obtained from a payer via an X12 transaction but may also be added or modified directly by the end user. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_PLAN_DATE_PERIOD
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. |
DATE_PERIOD_TYPE_CD | DOUBLE | N | Identifies the type of date/time period for this row. |
ENCNTR_PLAN_DATE_PERIOD_ID | DOUBLE | N | This is the value of the unique primary identifier of the encntr_plan_date_period table. It's an internally assigned number and generally not revealed to the user. |
FIRST_DATE | DATETIME | Y | The first date in the period. Although this column 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 to this column. |
PARENT_ENTITY_ID | DOUBLE | N | The unique identifier of the parent table to which this data belongs. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The upper case name of the parent table to which this data belongs. |
SECOND_DATE | DATETIME | Y | The second date in the period. Although this column 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 to this column. |
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_DATE_PERIOD
Parent Column in ENCNTR_PLAN_DATE_PERIOD (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENCNTR_PLAN_DATE_PERIOD_ID | ENCNTR_PLAN_DATE_PRD_HIST | ENCNTR_PLAN_DATE_PERIOD_ID |