Table Detail Report

PERSON_BENEFIT_R



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PERSON_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.
BALANCE_TYPE_CD DOUBLE N The balance type selected.
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.
COVERAGE_TYPE_CD DOUBLE N Describes the coverage type for the given relation.
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.
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.
FAM_DEDUCT_MET_AMT DOUBLE N The amount of deductible met for the family.
FAM_DEDUCT_MET_DT_TM DATETIME Y The Date and time the deductible was met.
INTERNAL_SEQ DOUBLE N This is a numeric number used to represent the order in which to consider benefit information if the person has more than one set of benefits
MAX_OUT_PCKT_AMT DOUBLE N The maximum out of pocket amount that the subscriber is responsible for.
MAX_OUT_PCKT_DT_TM DATETIME Y The date the maximum out of pocket amount was met.
NON_COVERAGE_DAYS DOUBLE N Hospital days that are not covered under the subscriber's policy.
PERSON_BENEFIT_R_ID DOUBLE N The unique primary key of this table. It is internally generated by Cerner.
PERSON_PLAN_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the person health plan relationship table. It is an internal system assigned number.
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 - PERSON_BENEFIT_R


Child Column in PERSON_BENEFIT_R(FK) Parent Table Name Parent Column Name
Parents: COMMENT_ID LONG_TEXT LONG_TEXT_ID
PERSON_PLAN_RELTN_ID PERSON_PLAN_RELTN PERSON_PLAN_RELTN_ID




Parent Column in PERSON_BENEFIT_R (PK) Child Table Name Child Column Name
Children: PERSON_BENEFIT_R_ID PERSON_BENEFIT_SCH_R PERSON_BENEFIT_R_ID


PERSON_BENEFIT_SCH_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Benefit Schedules Relationship
Definition: This table allows the user to capture a range of entries specific for each person benefit sets captured per Health Plan.
Table Type: ACTIVITY





Column Detail - PERSON_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.
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.
PERSON_BENEFIT_R_ID DOUBLE N This is the value of the unique primary identifier of the person benefit relation table. It is an internal system assigned number.
PERSON_BENEFIT_SCH_R_ID DOUBLE N Primary Key
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 - PERSON_BENEFIT_SCH_R


Child Column in PERSON_BENEFIT_SCH_R(FK) Parent Table Name Parent Column Name
Parents: PERSON_BENEFIT_R_ID PERSON_BENEFIT_R PERSON_BENEFIT_R_ID


PERSON_CODE_VALUE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: PERSON CODE VALUE R
Definition: Holds the multiple select code values on the person level.
Table Type: ACTIVITY





Column Detail - PERSON_CODE_VALUE_R


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.
CODE_SET DOUBLE N This is a code set that can have multiple values for one person.
CODE_VALUE DOUBLE N This is the code value for certain code sets that allow multiple selects.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
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.
PERSON_CODE_VALUE_R_ID DOUBLE N Unique identifier for the person_code_value_r_id table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - PERSON_CODE_VALUE_R


Child Column in PERSON_CODE_VALUE_R(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


PERSON_CODE_VALUE_R_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: PERSON CODE VALUE R HIST
Definition: Used for tracking history of changes to person_code_value_r rows.
Table Type: ACTIVITY





Column Detail - PERSON_CODE_VALUE_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 Y 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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CODE_SET DOUBLE N This is a code set that can have multiple values for one person.
CODE_VALUE DOUBLE N This is the code value for certain code sets that allow multiple selects.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PERSON_CODE_VALUE_R_H_ID DOUBLE N Sequence generated primary key.
PERSON_CODE_VALUE_R_ID DOUBLE N This is the value of the unique identifier of the person_code_value_r table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - PERSON_CODE_VALUE_R_HIST


Child Column in PERSON_CODE_VALUE_R_HIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_COMBINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Combine
Definition: The person combine table contains the audit trail for all persons that were either automatically or manually combined as a result of determining that two rows in the person table represent the same person.
Table Type: ACTIVITY





Column Detail - PERSON_COMBINE


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.
APPLICATION_FLAG DOUBLE Y Tells which type of application sends the transaction.
CMB_DT_TM DATETIME Y Date when combine finished
CMB_UPDT_ID DOUBLE Y Person who performed the combine
COMBINE_ACTION_CD DOUBLE N Action that was taken on the 'from' person record during the combine.
COMBINE_WEIGHT DOUBLE Y A value between 0 and 100 representing the confidence level of the match based on match parameters. This column is only filled out by an OPF suggested combine.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
FROM_ALIAS_POOL_CD DOUBLE N If from_mrn is used, this is the alias_pool_cd for the from_mrn.
FROM_ALIAS_TYPE_CD DOUBLE N If from_mrn is used, this is the alias_type_cd for the from_mrn.
FROM_MRN VARCHAR(200) Y This is the MRN of the from person. Currently only used for single-encntr person combines called from the esi server.
FROM_PERSON_ID DOUBLE N This is the value of the unique primary identifier from the person table of the FROM person that was combined. It is an internal system assigned number.
PERSON_COMBINE_ID DOUBLE N This is the value of the unique primary identifier of the person combine table. It is an internal system assigned number.
PREV_ACTIVE_IND DOUBLE Y Reference Data Domain Sync (RDDS) use for determining historical occurrences.
PREV_ACTIVE_STATUS_CD DOUBLE N The value of the active_status_cd prior to the row bein combined. Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
PREV_CONFID_LEVEL_CD DOUBLE N The value of the conf_level_cd prior to the row being combined. Confidential level identifies a level of security that may restrict access or release of information.
TO_ALIAS_POOL_CD DOUBLE N If to_mrn is used, this is the alias_pool_cd for the to_mrn.
TO_ALIAS_TYPE_CD DOUBLE N If to_mrn is used, this is the alias_type_cd for the to_mrn.
TO_MRN VARCHAR(200) Y This is the MRN of the to person. Currently only used for single-encntr person combines called from the esi server.
TO_PERSON_ID DOUBLE N This is the value of the unique primary identifier from the person table of the TO person that was combined. It is an internal system assigned number.
TRANSACTION_TYPE VARCHAR(8) Y The type of transaction that triggers the combine. For ESI transactions, the transaction_type will be the MSH event, e.g., ADT^A01, ADT^A02, etc. For Combine Tool transactions, the transaction_type will be CMBTOOL.
UCB_DT_TM DATETIME Y Date when uncombine finished
UCB_UPDT_ID DOUBLE Y Person who performed the uncombine
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 - PERSON_COMBINE


Child Column in PERSON_COMBINE(FK) Parent Table Name Parent Column Name
Parents: FROM_PERSON_ID PERSON PERSON_ID
TO_PERSON_ID PERSON PERSON_ID




Parent Column in PERSON_COMBINE (PK) Child Table Name Child Column Name
Children: PERSON_COMBINE_ID PERSON_COMBINE_BATCH PERSON_COMBINE_ID
PERSON_COMBINE_DET PERSON_COMBINE_ID