Table Detail Report

ENCNTR_BENEFIT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Benefit Relationship table
Definition: This table contains specific encounter benefit-type information. We will allow encounter benefit information to be captured for each health plan.
Table Type: ACTIVITY





Column Detail - ENCNTR_BENEFIT_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
BENEFIT_PLAN_CD DOUBLE N Used to specify the level of benefit information being captured.
COINSURANCE_DAYS DOUBLE N Hospital days for which the subscriber is responsible for paying, according to a fixed percentage or amount. For example, for skilled nursing facility (SNF) benefits.
COINSURANCE_PCT DOUBLE N The percentage that the covered person is responsible for paying after payment of the deductible.
COINSURANCE_REMAIN_DAYS DOUBLE N The number of hospital days remaining for which the covered person is responsible for paying, according to a fixed percentage or amount.
COMMENT_ID DOUBLE N Encntr_benefit_reltn comment identifier.
COPAY_AMT DOUBLE N The portion of a claim or medical expense that a member must pay out of pocket, such as $10 in many HMOs.
COVERAGE_DAYS DOUBLE N Hospital days that are covered under the subscriber's policy.
COVERAGE_REMAIN_DAYS DOUBLE N The remaining hospital days that are covered under the subscriber's policy.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
DEDUCT_AMT DOUBLE N The amount of deductible for this benefit.
DEDUCT_MET_AMT DOUBLE N The amount insurer paid toward deductible.
DEDUCT_MET_DT_TM DATETIME Y The date and time the deductible was met.
DEDUCT_PCT DOUBLE N The percentage that must be met by the patient before the insurer will begin covering the cost of care.
DEDUCT_REMAIN_AMT DOUBLE N The amount of deductible remaining to be met by the patient before the insurer will begin covering the cost of care. Will be a static, manual-entry field for this project, with plans to discuss ways to automatically decrement in the future.
ENCNTR_BENEFIT_R_ID DOUBLE N Primary Key
ENCNTR_PLAN_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the encounter health plan relationship table.
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.
INTERNAL_SEQ DOUBLE N A numeric number used to represent the order in which to consider benefit information if the encounter has more than one set of benefits.
NON_COVERAGE_DAYS DOUBLE N Hospital days that are not covered under the subscriber's policy.
ROOM_COVERAGE_AMT DOUBLE N The amount allowed (covered by the insurer) for room charges, which varies based on the room type.
ROOM_COVERAGE_AMT_QUAL_CD DOUBLE N Designates the units entered in room coverage amount.
ROOM_COVERAGE_BOARD_INCL_CD DOUBLE N A y/n field indicating if room and board charges are included in the room coverage amount established by the insurer for the specific room type.
ROOM_COVERAGE_TYPE_CD DOUBLE N The room type specifically associated with the room coverage amount covered by the insurer.
SERVICE_TYPE_CD DOUBLE N Used to specify the level of benefit information being captured.
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_BENEFIT_R


Child Column in ENCNTR_BENEFIT_R(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_PLAN_RELTN_ID ENCNTR_PLAN_RELTN ENCNTR_PLAN_RELTN_ID
COMMENT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in ENCNTR_BENEFIT_R (PK) Child Table Name Child Column Name
Children: ENCNTR_BENEFIT_R_ID ENCNTR_BENEFIT_SCH_R ENCNTR_BENEFIT_R_ID


ENCNTR_BENEFIT_SCH_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Benefit Schedules Relationship
Definition: This table allows the user to capture a range of entries specific for each encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_BENEFIT_SCH_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
ENCNTR_BENEFIT_R_ID DOUBLE N This is the value of the unique primary identifier of the encounter benefit relation table. It is an internal system assigned number.
ENCNTR_BENEFIT_SCH_R_ID DOUBLE N Primary Key
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.
MEMBER_RESP_TYPE_CD DOUBLE N The responsibility type associated with the set.
RESP_RANGE_AMT DOUBLE N The amount associated with the member responsibility type and corresponding range (if entered).
RESP_RANGE_END_NBR DOUBLE N The ending value of each range associated with the member responsibility type.
RESP_RANGE_QUAL_CD DOUBLE N Descriptor of the values entered in each range indicated in the Type start and Type end.
RESP_RANGE_START_NBR DOUBLE N The starting value of each range associated with the member responsibility type.
RESP_TYPE_QUAL_CD DOUBLE N Descriptor of the values entered in each range indicated in the Type start and Type end.
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_BENEFIT_SCH_R


Child Column in ENCNTR_BENEFIT_SCH_R(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_BENEFIT_R_ID ENCNTR_BENEFIT_R ENCNTR_BENEFIT_R_ID


ENCNTR_CATCHMENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Catchment Relationship
Definition: The encounter-catchment relationship table contains pointers to catchment area (organization) of the patient. The kind of relationship (i.e., admission, inner Regional Support Networks (RSN), Discharge, etc.) defines how the encounter and organization are related.
Table Type: ACTIVITY





Column Detail - ENCNTR_CATCHMENT_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.
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.
CATCHMENT_ORG_ID DOUBLE N Identifier from the organization table of the catchment organization that administers and coordinates services for the patient during the catchment period.
CATCHMENT_RELTN_TYPE_CD DOUBLE N Identifies the type of catchment relationship (i.e., Admission, Inner Regional Support Networks, Discharge) between an encounter and the catchment area (organization).
COUNTY_CD DOUBLE N The county code is the code set value which identifies the county for the catchment area.
ENCNTR_CATCHMENT_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the ENCNTR_CATCHMENT_RELTN table. It is an internal system assigned number.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter 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.
LIAISON_PRSNL_ID DOUBLE N Identifies the personnel of the catchment area responsible for monitoring the patient.
OUTSIDE_CATCHMENT_IND DOUBLE N Information indicating if the patient is currently outside of the catchment area.
SUBREGION_ORG_ID DOUBLE N Identifier from the organization table representing a subdivison of the catchment area region.
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_CATCHMENT_RELTN


Child Column in ENCNTR_CATCHMENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
CATCHMENT_ORG_ID ORGANIZATION ORGANIZATION_ID
SUBREGION_ORG_ID ORGANIZATION ORGANIZATION_ID
LIAISON_PRSNL_ID PRSNL PERSON_ID




Parent Column in ENCNTR_CATCHMENT_RELTN (PK) Child Table Name Child Column Name
Children: ENCNTR_CATCHMENT_RELTN_ID ENCNTR_CATCHMENT_R_HIST ENCNTR_CATCHMENT_RELTN_ID


ENCNTR_CATCHMENT_R_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Catchment Relationship History
Definition: Used for tracking history of changes to encounter catchment relationship.
Table Type: ACTIVITY





Column Detail - ENCNTR_CATCHMENT_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.
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.
CATCHMENT_ORG_ID DOUBLE N Identifier from the organization table of the catchment organization that administers and coordinates services for the patient during the catchment period.
CATCHMENT_RELTN_TYPE_CD DOUBLE N Identifies the type of catchment relationship (i.e., Admission, Inner Regional Support Networks, Discharge) between an encounter and the catchment area (organization).
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
COUNTY_CD DOUBLE N The county code is the code set value which identifies the county for the catchment area.
ENCNTR_CATCHMENT_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the ENCNTR_CATCHMENT_RELTN table. It is an internal system assigned number.
ENCNTR_CATCHMENT_R_HIST_ID DOUBLE N This is the value of the unique primary identifier of the ENCNTR_CATCHMENT_RELTN table. It is an internal system assigned number.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter 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.
LIAISON_PRSNL_ID DOUBLE N Identifies the personnel of the catchment area responsible for monitoring the patient.
OUTSIDE_CATCHMENT_IND DOUBLE N Information indicating if the patient is currently outside of the catchment area.
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.
SUBREGION_ORG_ID DOUBLE N Identifier from the organization table representing a subdivison of thecatchment area region.
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_CATCHMENT_R_HIST


Child Column in ENCNTR_CATCHMENT_R_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_CATCHMENT_RELTN_ID ENCNTR_CATCHMENT_RELTN ENCNTR_CATCHMENT_RELTN_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
CATCHMENT_ORG_ID ORGANIZATION ORGANIZATION_ID
SUBREGION_ORG_ID ORGANIZATION ORGANIZATION_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
LIAISON_PRSNL_ID PRSNL PERSON_ID


ENCNTR_CLASSIFICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Classification
Definition: Stores encounter classification information
Table Type: ACTIVITY





Column Detail - ENCNTR_CLASSIFICATION


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.
CLASSIFICATION1_CD DOUBLE N Indicates a categorization of patients having a set of shared qualities or characteristics.
CLASSIFICATION2_CD DOUBLE N Indicates a categorization of patients having a set of shared qualities or characteristics. This code set may be configured via code value grouping to be hierarchically below patient classification 1 if desired by the client.
CLASSIFICATION3_CD DOUBLE N Indicates a categorization of patients having a set of shared qualities or characteristics. This code set may be configured via code value grouping to be hierarchically below patient classification 2 if desired by the client
CLASSIFICATION4_CD DOUBLE N Indicates a categorization of patients having a set of shared qualities or characteristics. This code set may be configured via code value grouping to be hierarchically below patient classification 3 if desired by the client
ENCNTR_CLASSIFICATION_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned 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 - ENCNTR_CLASSIFICATION


Child Column in ENCNTR_CLASSIFICATION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in ENCNTR_CLASSIFICATION (PK) Child Table Name Child Column Name
Children: ENCNTR_CLASSIFICATION_ID ENCNTR_CLASSIFICTN_HIST ENCNTR_CLASSIFICATION_ID