Table Detail Report

ENCNTR_PLAN_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Health Plan Relationship
Definition: The encounter-health plan relation table contains pointers to health plans for a specific encounter. This table is similar to the person health plan relation table, except that the health plans relate to a specific encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_PLAN_RELTN


Column Name Type Null? Definition
ACCEPT_ASSIGNMENT_CD DOUBLE N Provider acceptance for payment terms.
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.
ALT_MEMBER_NBR VARCHAR(100) Y The alternate payer plan member number for the person.
ASSIGN_BENEFITS_CD DOUBLE N Codified column representing the nature/status of benefit assignment for the use of the health plan on this encounter.
AUTH_REQUIRED_CD DOUBLE N Documents whether or not authorization is required for given encounter health plan relation
BALANCE_TYPE_CD DOUBLE N Status/Type of the billing balance for this encounter and this health plan.
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.
BENEFIT_VERIFY_DT_TM DATETIME Y The data and time at which the health plan benefits were last verified.
CARD_CATEGORY_CD DOUBLE N A categorization of the coverages and/or benefits available to the recipient. For some insurances this may be clearly identifiable based on characteristics of the beneficiary's coverage card.
CARD_ISSUE_NBR DOUBLE N The card issue number is used to track the number of cards dispensed. The original card is typically issue number 00, with subsequent cards incremented.
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.
COORD_BENEFITS_CD DOUBLE N Codified value representing the coordination of benefits for this health plan for this encounter.
COVERAGE_COMMENTS_LONG_TEXT_ID DOUBLE N An identifier that points to a row in the LONG_TEXT table where comments about the plan coverage are stored.
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 Y Amount of health plan deductible applied to this encounter.
DEDUCT_MET_AMT DOUBLE Y Amount of the deductible that has been met, or payed, by the subscriber.
DEDUCT_MET_DT_TM DATETIME Y Date and time that the deductible amount was payed.
DENIAL_REASON_CD DOUBLE N The reason for the denial.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_PLAN_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the encounter health plan relationship 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.
EXT_PAYER_IDENT VARCHAR(100) Y The primary identifier of the organization (that does not exist in the Millennium build) providing the insurance plan (carrier).
EXT_PAYER_NAME VARCHAR(100) Y The name of the organization (that does not exist in the Millennium build) providing the insurance plan (carrier).
GENERIC_HEALTH_PLAN_NAME VARCHAR(100) Y The name of the health plan when the health plan category is GENERIC.
GROUP_NAME VARCHAR(200) Y Name of the health plan group used for this encounter (patient) and their association to the health plan through their sponsor (employer).
GROUP_NBR VARCHAR(100) Y Number of the health plan group used for this encounter (patient) and their association to the health plan through their sponsor (employer).
HEALTH_CARD_EXPIRY_DT_TM DATETIME Y The date and time for which this health card becomes ineffective or expired.
HEALTH_CARD_ISSUE_DT_TM DATETIME Y The date and time for which this health card becomes effective or issued.
HEALTH_CARD_NBR CHAR(100) Y The number on the subscriber's/patient's health card (generally used in non-US sites).
HEALTH_CARD_PROVINCE CHAR(3) Y Province where the Health Card was issued (usually used in non-US sites such as Canada).
HEALTH_CARD_TYPE VARCHAR(32) Y Type of health card which has a certain category or style.
HEALTH_CARD_VER_CODE CHAR(3) Y Version code of the Health Card (usually used in non-U.S. sites such as Canada).
HEALTH_PLAN_ID DOUBLE N This is the value of the unique primary identifier of the health plan table. It is an internal system assigned number.
INSURED_CARD_NAME VARCHAR(100) Y Subscriber's/Patient's name as printed on the insurance card.
INSURED_CARD_NAME_FIRST VARCHAR(100) Y Person's first name as seen on the insurance card.
INSURED_CARD_NAME_LAST VARCHAR(100) Y Person's last name as seen on the insurance card.
INSURED_CARD_NAME_MIDDLE VARCHAR(100) Y Person's middle name as seen on the insurance card.
INSURED_CARD_NAME_SUFFIX VARCHAR(100) Y Person's name suffix as seen on the insurance card.
INSUR_SOURCE_INFO_CD DOUBLE N Codified value representing the source from which the insurance information for this health plan and encounter was obtained.
INS_CARD_COPIED_CD DOUBLE N A y/n field indicating whether a copy of the subscriber's insurance card has been obtained.
INS_OFFICE_ORG_ID DOUBLE N Identifier from the organization table of the health plan's insurance office.
LIFE_RSV_DAILY_DED_AMT DOUBLE N The daily deductible amount that is applicable when reserve days are used for coverage.
LIFE_RSV_DAILY_DED_QUAL_CD DOUBLE N The qualifier describing the amount entered in the Lifetime reserve daily deductible.
LIFE_RSV_DAYS DOUBLE N The predetermined number of coverage days held "in reserve" for use if needed. The reserve days can be used when all the days under a given service have been used, but continued coverage/care is needed. This number is static for the lifetime of the subscriber.
LIFE_RSV_REMAIN_DAYS DOUBLE N A static, manual-entry field obtained from taking the Lifetime reserve days and subtracting any days used from that reserve for coverage.
MEMBER_NBR VARCHAR(100) Y Patient's member number for this health plan.
MEMBER_PERSON_CODE VARCHAR(100) Y An additional attribute that the payer can use to uniquely identify the subscriber and their dependents within the context of a particular policy. The policy number in conjunction with the member person code typically comprise the member number.
MILITARY_BASE_LOCATION VARCHAR(100) Y Textual location of the military base on which the subscriber/patient resides.
MILITARY_RANK_CD DOUBLE N Military ranking of the subscriber/patient.
MILITARY_SERVICE_CD DOUBLE N The branch of military service through which the health plan coverage is being offered to the subscriber due to their current or past service. Examples may include, Army, Navy, Air Force, etc.
MILITARY_STATUS_CD DOUBLE N Military status of the subscriber/patient.
NOTIFY_DT_TM DATETIME Y Date and time the inpatient 278 Notification took place.
NOTIFY_PRSNL_ID DOUBLE N Personnel that ran the inpatient 278 Notification.
NOTIFY_SOURCE_CD DOUBLE N Source the inpatient 278 Notification came from. e.g. Phone, Electronic, etc.
ON_FILE_ADMIN_SEX_CD DOUBLE N The person's gender code as it appears on file with the carrier.
ON_FILE_BIRTH_DT_ISO VARCHAR(10) Y The patient's date of birth as it appears on the file with the carrier. Stored in standard ISO format.
ORGANIZATION_ID DOUBLE N Identifier from the organization table of the health plan's carrier.
ORIG_PRIORITY_SEQ DOUBLE Y This is a numeric number used to represent the order in which to considered this health plan for reimbursement, if the person is a member of more than one health plan. This is the original number from the person health plan relation 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.
PERSON_ORG_RELTN_ID DOUBLE N This this the ID from the PERSON_ORG_RELTN table for the person and the organization that are related to this ENCNTR_PLAN_RELTN row.
PERSON_PLAN_RELTN_ID DOUBLE N This is the ID from the PERSON_PLAN_RELTN row relating the PERSON and the HEALTH_PLAN to this ENCNTR_PLAN_RELTN row. For an encounter, a corresponding row can be maintained at the person level with the same information.
PLAN_CLASS_CD DOUBLE N The classification/grouping of the health plan. Generally indicates whether or not the plan is free text.
PLAN_TYPE_CD DOUBLE N Value that signifies the type/grouping of the health plan. Examples may include Medicare, Commercial, Champus, HMO, others.
POLICY_NBR VARCHAR(100) Y The policy number of the subscriber's health plan at the time of the visit. The policy number in conjunction with the member person code typically comprise the member number. Sometimes the individual's member number is referred to as their policy number so care should be taken in order to make sure that the correct field is being used given a particular use case.
PRICING_AGENCY_CD DOUBLE N A Pricing Agency is an entity that applies a discount to a claim based on a contract that the entity has negotiated with both providers and claims payers on behalf of the network.
PRIORITY_SEQ DOUBLE Y This is a numeric number used to represent the order in which to consider this health plan for reimbursement, if the person is a member of more than one health plan. This number may change from the original number depending on the encounter.
PROGRAM_STATUS_CD DOUBLE N Represents the set of coverages and/or benefits available to the recipient based on the recipient's reason for eligibility.
PROP_CASUALTY_CLAIM_NBR_TXT VARCHAR(100) Y This is the claim number the health plan has to the P&C claim. This number is submitted to the health plan along with, or in a place of, the policy number.
RESUBMIT_278N_CD DOUBLE N This field stores the responses for resubmitting eligibility.
RX_PLAN_COB_SEQ DOUBLE N Indicates the order in which a health plan is considered for pharmacy coordination of benefits for a particular encounter.
SIGNATURE_DT_TM DATETIME Y Patient signature date/time for claim form.
SIGNATURE_ON_FILE_CD DOUBLE N Indicates whether a patient's signature for insurance has been obtained
SIGNATURE_SOURCE_CD DOUBLE N Description of what claim form the patient signed.
SPONSOR_PERSON_ORG_RELTN_ID DOUBLE N Pointer to the relationship between the subscriber and their employer/sponsor organization.
SUBSCRIBER_TYPE_CD DOUBLE N Value that represents the type of subscriber being used for this health plan. Not used at this time.
SUBS_INSURED_CARD_FIRST_NAME VARCHAR(100) Y The Subscriber's first name as seen on the insurance card or as it appears on file with the carrier.
SUBS_INSURED_CARD_LAST_NAME VARCHAR(100) Y The Subscriber's last name as seen on the insurance card or as it appears on file with the carrier.
SUBS_INSURED_CARD_MIDDLE_NAME VARCHAR(100) Y The Subscriber's middle name as seen on the insurance card or as it appears on file with the carrier.
SUBS_INSURED_CARD_SUFFIX_NAME VARCHAR(100) Y The Subscriber's suffix name as seen on the insurance card or as it appears on file with the carrier.
SUBS_MEMBER_NBR VARCHAR(100) Y The member number of the subscriber to the health plan.
SUBS_ON_FILE_ADMIN_SEX_CD DOUBLE N The subscriber's gender code as it appears on file with the carrier.
SUBS_ON_FILE_BIRTH_DT_ISO VARCHAR(10) Y The subscriber's date of birth as it appears on file with the carrier. Stored in ISO format.
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.
VERIFY_DT_TM DATETIME Y Time that the row was last verified.
VERIFY_PRSNL_ID DOUBLE N Id of the prsnl who last updated the row.
VERIFY_SOURCE_CD DOUBLE N The source by which the row was verified.
VERIFY_STATUS_CD DOUBLE N The last verified status entered.



Relationship Detail - ENCNTR_PLAN_RELTN


Child Column in ENCNTR_PLAN_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
COVERAGE_COMMENTS_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
INS_OFFICE_ORG_ID ORGANIZATION ORGANIZATION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PERSON_ORG_RELTN_ID PERSON_ORG_RELTN PERSON_ORG_RELTN_ID
SPONSOR_PERSON_ORG_RELTN_ID PERSON_ORG_RELTN PERSON_ORG_RELTN_ID
PERSON_PLAN_RELTN_ID PERSON_PLAN_RELTN PERSON_PLAN_RELTN_ID
NOTIFY_PRSNL_ID PRSNL PERSON_ID




Parent Column in ENCNTR_PLAN_RELTN (PK) Child Table Name Child Column Name
Children: ENCNTR_PLAN_RELTN_ID ENCNTR_BENEFIT_R ENCNTR_PLAN_RELTN_ID
ENCNTR_PLAN_AUTH_R ENCNTR_PLAN_RELTN_ID
ENCNTR_PLAN_AUTH_R_HIST ENCNTR_PLAN_RELTN_ID
ENCNTR_PLAN_COB_RELTN ENCNTR_PLAN_RELTN_ID
ENCNTR_PLAN_ELIGIBILITY ENCNTR_PLAN_RELTN_ID
ENCNTR_PLAN_ELIG_HIST ENCNTR_PLAN_RELTN_ID
ENCNTR_PLAN_RELTN_HIST ENCNTR_PLAN_RELTN_ID
TRANSACTION_ADMIT_NOTIFY ENCNTR_PLAN_RELTN_ID
TRANSACTION_ELIGIBILITY ENCNTR_PLAN_RELTN_ID


ENCNTR_PLAN_RELTN_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Plan Relation History
Definition: Used for tracking history of certain columns on the encntr_plan_reltn table.
Table Type: ACTIVITY





Column Detail - ENCNTR_PLAN_RELTN_HIST


Column Name Type Null? Definition
ACCEPT_ASSIGNMENT_CD DOUBLE N Indicates the provider's acceptance for payment terms.
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.
ALT_MEMBER_NBR VARCHAR(100) Y The alternate payer plan member number for the person.
ASSIGN_BENEFITS_CD DOUBLE N codified column representing the nature/status of benefit assignment for the use of the health plan on this encounter.
AUTH_REQUIRED_CD DOUBLE N Documents whether or not authorization is required for given encounter health plan relation.
BALANCE_TYPE_CD DOUBLE N The type of balance
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.
BENEFIT_VERIFY_DT_TM DATETIME Y The data and time at which the health plan benefits were last verified.
CARD_CATEGORY_CD DOUBLE N A categorization of the coverages and/or benefits available to the recipient. For some insurances this may be clearly identifiable based on characteristics of the beneficiary's coverage card.
CARD_ISSUE_NBR DOUBLE N The card issue number is used to track the number of cards dispensed. The original card is typically issue number 00, with subsequent cards incremented.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
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.
COORD_BENEFITS_CD DOUBLE N codified value representing the coordination of benefits for this health plan for this encounter.
COVERAGE_COMMENTS_LONG_TEXT_ID DOUBLE N An identifier that points to a row in the LONG_TEXT table where comments about the plan coverage are stored.
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 Y The amount of health plan deductible applied to this encounter.
DEDUCT_MET_AMT DOUBLE Y The amount of the deductible that has been met, or payed, by the subscriber.
DEDUCT_MET_DT_TM DATETIME Y The date and time that the deductible amount was payed.
DENIAL_REASON_CD DOUBLE N The code value for the reason the claim was denied.
ENCNTR_ID DOUBLE N this is the value of the unique primary identifier of the encounter table. it is an internal system assigned number.
ENCNTR_PLAN_RELTN_HIST_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_PLAN_RELTN_HIST table.
ENCNTR_PLAN_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the parent table encntr_plan_reltn
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.
EXT_PAYER_IDENT VARCHAR(100) Y The primary identifier of the organization (that does not exist in the Millennium build) providing the insurance plan (carrier).
EXT_PAYER_NAME VARCHAR(100) Y The name of the organization (that does not exist in the Millennium build) providing the insurance plan (carrier).
GENERIC_HEALTH_PLAN_NAME VARCHAR(100) Y The name of the health plan when the health plan category is GENERIC.
GROUP_NAME VARCHAR(200) Y The group name of the plan.
GROUP_NBR VARCHAR(100) Y The group number of the plan.
HEALTH_CARD_EXPIRY_DT_TM DATETIME Y the date and time for which this health card becomes ineffective or expired.
HEALTH_CARD_ISSUE_DT_TM DATETIME Y the date and time for which this health card becomes effective or issued.
HEALTH_CARD_NBR CHAR(100) Y the number on the subscriber's/patient's health card (generally used in non-us sites).
HEALTH_CARD_PROVINCE CHAR(3) Y province where the health card was issued (usually used in non-us sites such as Canada).
HEALTH_CARD_TYPE VARCHAR(32) Y type of health card which has a certain category or style.
HEALTH_CARD_VER_CODE CHAR(3) Y version code of the health card (usually used in non-u.s. sites such as Canada).
HEALTH_PLAN_ID DOUBLE N This is the value of the unique primary identifier of the health plan table. It is an internal system assigned number.
INSURED_CARD_NAME VARCHAR(100) Y Person's Name as seen on the insurance card.
INSURED_CARD_NAME_FIRST VARCHAR(100) Y Person's first name as seen on the insurance card.
INSURED_CARD_NAME_LAST VARCHAR(100) Y Person's last name as seen on the insurance card.
INSURED_CARD_NAME_MIDDLE VARCHAR(100) Y Person's middle name as seen on the insurance card.
INSURED_CARD_NAME_SUFFIX VARCHAR(100) Y Person's name suffix as seen on the insurance card.
INSUR_SOURCE_INFO_CD DOUBLE N codified value representing the source from which the insurance information for this health plan and encounter was obtained.
INS_CARD_COPIED_CD DOUBLE N a y/n field indicating whether a copy of the subscriber's insurance card has been obtained.
INS_OFFICE_ORG_ID DOUBLE N Identifier from the organization table of the health plan's insurance office.
LIFE_RSV_DAILY_DED_AMT DOUBLE N The daily deductible amount that is applicable when reserve days are used for coverage.
LIFE_RSV_DAILY_DED_QUAL_CD DOUBLE N The qualifier describing the amount entered in the Lifetime reserve daily deductible.
LIFE_RSV_DAYS DOUBLE N The predetermined number of coverage days held ""in reserve"" for use if needed. The reserve days can be used when all the days under a given service have been used, but continued coverage/care is needed. This number is static for the lifetime of the subscriber.
LIFE_RSV_REMAIN_DAYS DOUBLE N A static, manual-entry field obtained from taking the Lifetime reserve days and subtracting any days used from that reserve for coverage.
MEMBER_NBR VARCHAR(100) Y The plan member number for the person.
MEMBER_PERSON_CODE VARCHAR(100) Y An additional attribute that the payer can use to uniquely identify the subscriber and their dependents within the context of a particular policy. The policy number in conjunction with the member person code typically comprise the member number.
MILITARY_BASE_LOCATION VARCHAR(100) Y textual location of the military base on which the subscriber/patient resides.
MILITARY_RANK_CD DOUBLE N military ranking of the subscriber/patient.
MILITARY_SERVICE_CD DOUBLE N The branch of military service through which the health plan coverage is being offered to the subscriber due to their current or past service. Examples may include, Army, Navy, Air Force, etc.
MILITARY_STATUS_CD DOUBLE N military status of the subscriber/patient.
NOTIFY_DT_TM DATETIME Y Date and time the inpatient 278 Notification took place.
NOTIFY_PRSNL_ID DOUBLE N Personnel that ran the inpatient 278 Notification.
NOTIFY_SOURCE_CD DOUBLE N Source the inpatient 278 Notification came from. e.g. Phone, Electronic, etc.
ON_FILE_ADMIN_SEX_CD DOUBLE N The person's gender code as it appears on file with the carrier.
ON_FILE_BIRTH_DT_ISO VARCHAR(10) Y The patient's date of birth as it appears on the file with the carrier. Stored in standard ISO format.
ORGANIZATION_ID DOUBLE N The ID of the organization providing the insurance plan.
ORIG_PRIORITY_SEQ DOUBLE Y this is a numeric number used to represent the order in which to considered this health plan for reimbursement, if the person is a member of more than one health plan. this is the original number from the person health plan relation 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.
PERSON_ORG_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the person organization relationship table. It is an internal system assigned number.
PERSON_PLAN_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the parent table Person_plan_reltn
PLAN_CLASS_CD DOUBLE N Code value that indicates if the health plan is in the reference list of health plans or not. FREETEXT indicates it is not in the list, HEALTHPLAN indicates it is.
PLAN_TYPE_CD DOUBLE N Code value that indicates the type of health plan. Examples are Medicaid, self pay, commercial, etc.
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.
POLICY_NBR VARCHAR(100) Y The policy number of the subscriber's health plan at the time of the visit. The policy number in conjunction with the member person code typically comprise the member number. Sometimes the individual's member number is referred to as their policy number so care should be taken in order to make sure that the correct field is being used given a particular use case.
PRICING_AGENCY_CD DOUBLE N a pricing agency is an entity that applies a discount to a claim based on a contract that the entity has negotiated with both providers and claims payers on behalf of the network.
PRIORITY_SEQ DOUBLE Y this is a numeric number used to represent the order in which to consider this health plan for reimbursement, if the person is a member of more than one health plan. this number may change from the original number depending on the encounter.
PROGRAM_STATUS_CD DOUBLE N Represents the set of coverages and/or benefits available to the recipient based on the recipient's reason for eligibility.
PROP_CASUALTY_CLAIM_NBR_TXT VARCHAR(100) Y this is the claim number the health plan has to the p&c claim. this number is submitted to the health plan along with, or in a place of, the policy number.
RESUBMIT_278N_CD DOUBLE N This field stores the responses for resubmitting eligibility.
RX_PLAN_COB_SEQ DOUBLE N indicates the order in which a health plan is considered for pharmacy coordination of benefits for a particular encounter.
SIGNATURE_DT_TM DATETIME Y patient signature date/time for claim form.
SIGNATURE_ON_FILE_CD DOUBLE N indicates whether a patient's signature for insurance has been obtained
SIGNATURE_SOURCE_CD DOUBLE N description of what claim form the patient signed.
SPONSOR_PERSON_ORG_RELTN_ID DOUBLE N pointer to the relationship between the subscriber and their employer/sponsor organization.
SUBSCRIBER_TYPE_CD DOUBLE N value that represents the type of subscriber being used for this health plan. not used at this time.
SUBS_INSURED_CARD_FIRST_NAME VARCHAR(100) Y The Subscriber's first name as seen on the insurance card or as it appears on file with the carrier.
SUBS_INSURED_CARD_LAST_NAME VARCHAR(100) Y The Subscriber's last name as seen on the insurance card or as it appears on file with the carrier.
SUBS_INSURED_CARD_MIDDLE_NAME VARCHAR(100) Y The Subscriber's middle name as seen on the insurance card or as it appears on file with the carrier.
SUBS_INSURED_CARD_SUFFIX_NAME VARCHAR(100) Y The Subscriber's suffix name as seen on the insurance card or as it appears on file with the carrier.
SUBS_MEMBER_NBR VARCHAR(100) Y the member number of the subscriber to the health plan.
SUBS_ON_FILE_ADMIN_SEX_CD DOUBLE N The subscriber's gender code as it appears on file with the carrier.
SUBS_ON_FILE_BIRTH_DT_ISO VARCHAR(10) Y The subscriber's date of birth as it appears on file with the carrier. Stored in ISO format.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME Y More aptly named activity_dt_tm; holds the current date and time of the system when the row was inserted. This will match the create_dt_tm from the corresponding pm_hist_tracking row.
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.
VERIFY_DT_TM DATETIME Y The date and time the verification took place.
VERIFY_PRSNL_ID DOUBLE N id of the prsnl who last updated the row.
VERIFY_SOURCE_CD DOUBLE N The source by which the row was verified.
VERIFY_STATUS_CD DOUBLE N The status of the verification. Examples are Yes and No.



Relationship Detail - ENCNTR_PLAN_RELTN_HIST


Child Column in ENCNTR_PLAN_RELTN_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_PLAN_RELTN_ID ENCNTR_PLAN_RELTN ENCNTR_PLAN_RELTN_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
NOTIFY_PRSNL_ID PRSNL PERSON_ID


ENCNTR_PROCEDURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Procedure Table
Definition: Contains the planned procedures for an encounters
Table Type: ACTIVITY





Column Detail - ENCNTR_PROCEDURE


Column Name Type Null? Definition
CATALOG_CD DOUBLE N Order catalog code planned for an encounter.
CONCURRENT_IND DOUBLE N Concurrent Indicator - Specifies that the procedure is concurrent with the previous procedure in the sequence.
ENCNTR_ID DOUBLE N Encounter which the planned procedures are for.
ENCNTR_PROCEDURE_ID DOUBLE N Unique identifier for the Encntr_procedure table.
NCEPOD_CD DOUBLE N The NCEPOD (National Confidential Enquiry into Patient Outcome and Death) Classification categorizes the urgency of the patient's intervention.
PRIORITY_SEQ DOUBLE N Priority of the order. 0 = primary, 1 = secondary, etc.
PROC_START_DT_TM DATETIME Y The start time for the procedure.
PROC_TEXT VARCHAR(255) Y Comments about the procedure.
SCHED_ANESTH_TYPE_CD DOUBLE N The default anesthesia type associated with this surgical procedure and area.
SCHED_DUR DOUBLE N The scheduled length of the procedure.
SCHED_PRIMARY_IND DOUBLE N Used for Surgery Management Reporting. Indicates whether this procedure was scheduled as the primary procedure.
SCHED_PRIMARY_SURGEON_ID DOUBLE N The ID of the primary surgeon scheduled for this procedure. Associated to a row on the PRSNL table.
SCHED_PRIORITY_CD DOUBLE N The priority of the scheduled procedure. Some examples are rush, stat, routine, etc.
SCHED_SURGE_AREA_CD DOUBLE N The surgical area associated with this procedure.
SCHED_SURGICAL_MOD1_CD DOUBLE N Stores Surgical Procedure modifiers are used to describe the procedure location/procedure attributes. An example would be left, deep, inner, etc. Each procedure can have multiple descriptions.
SCHED_SURGICAL_MOD2_CD DOUBLE N Stores Surgical Procedure modifiers are used to describe the procedure location/procedure attributes. An example would be left, deep, inner, etc. Each procedure can have multiple descriptions.
SCHED_SURGICAL_MOD3_CD DOUBLE N Stores Surgical Procedure modifiers are used to describe the procedure location/procedure attributes. An example would be left, deep, inner, etc. Each procedure can have multiple descriptions.
SCHED_SURGICAL_ORDER_COMMENT VARCHAR(255) Y Stores comments about surgical orders.
SCHED_XRAY_IND DOUBLE N An indicator of whether an x-ray is required for this surgical procedure and area.
SCHED_XRAY_TECH_IND DOUBLE N An indicator of whether an Xray technician is required for this surgical procedure and area.
SYNONYM_ID DOUBLE N The order synonym associated to the procedure.
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_PROCEDURE


Child Column in ENCNTR_PROCEDURE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
SCHED_PRIMARY_SURGEON_ID PRSNL PERSON_ID


ENCNTR_PRSNL_GRP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter personnel group relationships.
Definition: Stores relationships between an encounter and the personnel groups that have access to the encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_PRSNL_GRP_RELTN


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.
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.
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.
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_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_PRSNL_GRP_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the encounter personnel group relationship table. It is an internal system assigned number.
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.
PRSNL_GROUP_ID DOUBLE N This is the value of the unique primary identifier of the personnel group table. It is an internal system assigned number. This is the personnel group associated to this encounter.
RELTN_TYPE_CD DOUBLE N NOT USED. Code set not defined.
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_PRSNL_GRP_RELTN


Child Column in ENCNTR_PRSNL_GRP_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


ENCNTR_PRSNL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Personnel Relationship
Definition: The encounter-personnel relationship table contains pointers to related personnel in the personnel table. The kind of relationship (i.e., admitting physician, attending, etc.) defines how the encounter and personnel are related.
Table Type: ACTIVITY





Column Detail - ENCNTR_PRSNL_RELTN


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.
ACTIVITY_DT_TM DATETIME Y This column holds the current system date and time that the row was inserted.
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.
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.
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_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_PRSNL_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the encounter-person relationship table. It is an internally assigned number and generally not revealed to the user.
ENCNTR_PRSNL_R_CD DOUBLE N Relationship of the prsnl to the encounter
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type. Examples may include inpatient, outpatient, etc.
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.
EXPIRATION_IND DOUBLE Y Indicates whether the relationship between the encounter and the personnel has expired.
EXPIRE_DT_TM DATETIME Y Date/Time that the relationship has been expired from encounter. Primarily used to prevent the relationship from appearing in PowerChart application.
FREE_TEXT_CD DOUBLE N Value that shows the type of free text relationship information that is present between the encounter and personnel. When set to a meaning of 'FTBRIEF', this indicates that the prsnl_person_id is NULL, meaning that there is no reference to the personnel table.
FT_PRSNL_NAME VARCHAR(100) Y The name of the personnel in the 'free text' relationship indicated by the free_text_ind in the row being set to 'TRUE'.
INTERNAL_SEQ DOUBLE N Used within Cerner applications, if necessary, to order encounter personnel relation rows.
MANUAL_CREATE_BY_ID DOUBLE N Person Id of the person who manually created the relationship.
MANUAL_CREATE_DT_TM DATETIME Y Date and time the encounter personnel relationship was manually created.
MANUAL_CREATE_IND DOUBLE N Indicates whether the row was manually created.
MANUAL_INACT_BY_ID DOUBLE N The person_id of the person who inactivated the relationship.
MANUAL_INACT_DT_TM DATETIME Y Date and time the row was manually inactivated.
MANUAL_INACT_IND DOUBLE N Indicates whether the row was manually inactivated.
NOTIFICATION_CD DOUBLE N Personnel preferred method of notification for issues concerning related person.
PRIORITY_SEQ DOUBLE N The priority given to the relation type if more than one of the same type exists
PRSNL_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the personnel table. This is a 'role' name for the reference to person_id in the personnel table and used to differentiate between other references to person_id in this table.
TRANSACTION_DT_TM DATETIME Y Date and time the transaction, which triggered the row, occurred. This field can be system assigned or manually manipulated by users.
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_PRSNL_RELTN


Child Column in ENCNTR_PRSNL_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PRSNL_PERSON_ID PRSNL PERSON_ID




Parent Column in ENCNTR_PRSNL_RELTN (PK) Child Table Name Child Column Name
Children: ENCNTR_PRSNL_RELTN_ID ENCNTR_PRSNL_RELTN_HISTORY ENCNTR_PRSNL_RELTN_ID
TRACKING_ENCNTR_PRSNL_RELTN ENCNTR_PRSNL_RELTN_ID