Table Detail Report

PERSON_PLAN_PROFILE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Plan Profile History
Definition: Used for tracking history of changes to the person_plan_profile rows.
Table Type: ACTIVITY





Column Detail - PERSON_PLAN_PROFILE_HIST


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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
PERSON_PLAN_PROFILE_HIST_ID DOUBLE N Uniquely identifies a history record for the person_plan_profile table.
PERSON_PLAN_PROFILE_ID DOUBLE N Uniquely identifies the row to which this history is related.
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.
PROFILE_TYPE_CD DOUBLE N Indicates the type of health insurance profile for the person plan profile row (i.e., professional, institutional, workmen's comp).
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_PLAN_PROFILE_HIST


Child Column in PERSON_PLAN_PROFILE_HIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_PLAN_PROFILE_ID PERSON_PLAN_PROFILE PERSON_PLAN_PROFILE_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_PLAN_PROFILE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Plan Profile Relationship
Definition: The person health plan-profile relationship table defines the set of person health plans that are a part of a particular insurance profile and their priority within the profile.
Table Type: ACTIVITY





Column Detail - PERSON_PLAN_PROFILE_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.
PERSON_PLAN_PROFILE_ID DOUBLE N Uniquely identifies the related row on the person health plan profile table.
PERSON_PLAN_PROFILE_RELTN_ID DOUBLE N A person health plan-profile relationship defines the set of person health plans that are a part of a particular insurance profile and their priority within the profile.
PERSON_PLAN_RELTN_ID DOUBLE N Uniquely identifies the related row on the person_plan_reltn table.
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.
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_PLAN_PROFILE_RELTN


Child Column in PERSON_PLAN_PROFILE_RELTN(FK) Parent Table Name Parent Column Name
Parents: PERSON_PLAN_PROFILE_ID PERSON_PLAN_PROFILE PERSON_PLAN_PROFILE_ID
PERSON_PLAN_RELTN_ID PERSON_PLAN_RELTN PERSON_PLAN_RELTN_ID




Parent Column in PERSON_PLAN_PROFILE_RELTN (PK) Child Table Name Child Column Name
Children: PERSON_PLAN_PROFILE_RELTN_ID PERSON_PLAN_PROFILE_R_HIST PERSON_PLAN_PROFILE_RELTN_ID


PERSON_PLAN_PROFILE_R_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Plan Profile Relationship History
Definition: Used for tracking history of chages to the person_plan_profile_reltn rows.
Table Type: ACTIVITY





Column Detail - PERSON_PLAN_PROFILE_R_HIST


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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
PERSON_PLAN_PROFILE_ID DOUBLE N Uniquely identifies the related person plan profile to which this history is related.
PERSON_PLAN_PROFILE_RELTN_ID DOUBLE N Uniquely identifies the related person_plan_profile_reltn record for this history record.
PERSON_PLAN_PROFILE_R_HIST_ID DOUBLE N Uniquely tracks a history record of a change to the person_plan_profile_reltn table.
PERSON_PLAN_RELTN_ID DOUBLE N Uniquely identifies the row on the person_plan_reltn table related to this history record.
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 Identifies a sequencing priority to be used when a duplicate relationship of the same type is created
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_PLAN_PROFILE_R_HIST


Child Column in PERSON_PLAN_PROFILE_R_HIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_PLAN_PROFILE_ID PERSON_PLAN_PROFILE PERSON_PLAN_PROFILE_ID
PERSON_PLAN_PROFILE_RELTN_ID PERSON_PLAN_PROFILE_RELTN PERSON_PLAN_PROFILE_RELTN_ID
PERSON_PLAN_RELTN_ID PERSON_PLAN_RELTN PERSON_PLAN_RELTN_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_PLAN_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Health Plan Relationship
Definition: The person-health plan relation table contains pointers to health plan(s) which represent the current health plans for a person. This table along with the person table can be preloaded with member and plan data or populated as this information is
Table Type: ACTIVITY





Column Detail - PERSON_PLAN_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.
ALT_MEMBER_NBR VARCHAR(100) Y The alternate payer plan member number for the person.
ARCHIVE_DT_TM DATETIME Y The date and time at which the patient health plan relationship (coverage) was archived. Once the coverage is archived, it should not be allocated to future encounters.
ARCHIVE_PRSNL_ID DOUBLE Y The id of the personnel who archived the patient health plan relationship (coverage)
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.
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.
CONTRACT_CODE VARCHAR(100) Y Identifies a contract between a facility and a person's related health plan.
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.
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.
COVERAGE_TYPE_CD DOUBLE N The code value for the type of coverage of the plan.
DEDUCT_AMT DOUBLE Y The amount of the deductable for the plan.
DEDUCT_MET_AMT DOUBLE Y How much of the deductable has been met.
DEDUCT_MET_DT_TM DATETIME Y The date and time the deductable was met.
DENIAL_REASON_CD DOUBLE N The code value for the reason the claim was denied.
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).
FAM_DEDUCT_MET_AMT DOUBLE Y The amount of the family deductable that has been met.
FAM_DEDUCT_MET_DT_TM DATETIME Y The date and time the family deductable was met.
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_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.
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.
MAX_OUT_PCKT_AMT DOUBLE Y The maximum out of pocket amount the person is responsible for.
MAX_OUT_PCKT_DT_TM DATETIME Y The date and time the person met the out of pocket amount.
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_SERVICE_CD DOUBLE Y 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.
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.
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 person health plan relationship table. It is an internal system assigned number.
PERSON_PLAN_R_CD DOUBLE N Code value for the type of relationship between the insurance plan and the person. Examples are member and subscriber.
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.
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.;
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.
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.
SIGNATURE_ON_FILE_CD DOUBLE N Coed value that indicates what level a person is allowing the release of medical information. Some examples are , No, Informed Consent, Limited, etc.
SPONSOR_PERSON_ORG_RELTN_ID DOUBLE N ID of sponsor's relationship to the employer.
SUBSCRIBER_PERSON_ID DOUBLE N The person ID of the plan subscriber.
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 The ID of the person that did the verification
VERIFY_SOURCE_CD DOUBLE N The source by which the row was verified.
VERIFY_STATUS_CD DOUBLE N The status of the verification.



Relationship Detail - PERSON_PLAN_RELTN


Child Column in PERSON_PLAN_RELTN(FK) Parent Table Name Parent Column Name
Parents: 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
ARCHIVE_PRSNL_ID PRSNL PERSON_ID
VERIFY_PRSNL_ID PRSNL PERSON_ID




Parent Column in PERSON_PLAN_RELTN (PK) Child Table Name Child Column Name
Children: PERSON_PLAN_RELTN_ID ENCNTR_PLAN_RELTN PERSON_PLAN_RELTN_ID
PERSON_BENEFIT_R PERSON_PLAN_RELTN_ID
PERSON_PLAN_AUTH_R PERSON_PLAN_RELTN_ID
PERSON_PLAN_AUTH_R_HIST PERSON_PLAN_RELTN_ID
PERSON_PLAN_PROFILE_RELTN PERSON_PLAN_RELTN_ID
PERSON_PLAN_PROFILE_R_HIST PERSON_PLAN_RELTN_ID
PREEXIST_CONDITION PERSON_PLAN_RELTN_ID
REFERRAL_P_PLAN_RELTN PERSON_PLAN_RELTN_ID
TRANSACTION_ELIGIBILITY PERSON_PLAN_RELTN_ID


PERSON_PLAN_RELTN_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Plan Relationship History
Definition: History table for the Person Plan Relation table
Table Type: ACTIVITY





Column Detail - PERSON_PLAN_RELTN_HIST


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.
ALT_MEMBER_NBR VARCHAR(100) Y The alternate payer plan member number for the person.
ARCHIVE_DT_TM DATETIME Y The date and time at which the patient health plan relationship (coverage) was archived. Once the coverage is archived, it should not be allocated to future encounters.
ARCHIVE_PRSNL_ID DOUBLE Y The id of the personnel who archived the patient health plan relationship (coverage)
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.
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.
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.
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_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.
INS_OFFICE_ORG_ID DOUBLE N Identifier from the organization table of the health plan's insurance office.
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_SERVICE_CD DOUBLE Y 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.
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.
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_HIST_ID DOUBLE N Uniquely identifies history for a given person plan relationship.
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.
PERSON_PLAN_R_CD DOUBLE N Code value for the type of relationship between the insurance plan and the person. Examples are member and subscriber.
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.
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.
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.
SIGNATURE_ON_FILE_CD DOUBLE N Coed value that indicates what level a person is allowing the release of medical information. Some examples are , No, Informed Consent, Limited, etc.
SPONSOR_PERSON_ORG_RELTN_ID DOUBLE N ID of sponsor's relationship to the employer.
SUBSCRIBER_PERSON_ID DOUBLE N The person ID of the plan subscriber.
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.
VERIFY_DT_TM DATETIME Y The date and time the verification took place.
VERIFY_PRSNL_ID DOUBLE N The ID of the person that did the verification
VERIFY_SOURCE_CD DOUBLE N The source by which the row was verified.
VERIFY_STATUS_CD DOUBLE N The status of the verification.



Relationship Detail - PERSON_PLAN_RELTN_HIST


Child Column in PERSON_PLAN_RELTN_HIST(FK) Parent Table Name Parent Column Name
Parents: INS_OFFICE_ORG_ID ORGANIZATION ORGANIZATION_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID