Table Detail Report

PERSON_PHR_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Personal Health Record Information
Definition: The person personal health record information table contains information specific to a patient's personal health record enrollment.
Table Type: ACTIVITY





Column Detail - PERSON_PHR_INFO


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.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
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_PHR_INFO_ID DOUBLE N This is the value of the unique primary identifier of the person personal health record information table. It is an internally assigned number and generally not revealed to the user.
PHR_STATUS_CD DOUBLE N Code value indicating the status of the patient's personal health record election (i.e. YES, NO)
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_PHR_INFO


Child Column in PERSON_PHR_INFO(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID




Parent Column in PERSON_PHR_INFO (PK) Child Table Name Child Column Name
Children: PERSON_PHR_INFO_ID PERSON_PHR_INFO_HIST PERSON_PHR_INFO_ID
PERSON_PHR_RELTN PERSON_PHR_INFO_ID
PERSON_PHR_RELTN_HIST PERSON_PHR_INFO_ID


PERSON_PHR_INFO_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Personal Health Record Information History
Definition: Used for tracking history of certain columns on the person_phr_info table.
Table Type: ACTIVITY





Column Detail - PERSON_PHR_INFO_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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.It is the ID of the patient.
PERSON_PHR_INFO_HIST_ID DOUBLE N This is the value of the unique primary identifier of the person_phr_info_hist table. It is an internal system assigned number.
PERSON_PHR_INFO_ID DOUBLE N This is the value of the unique primary identifier of the person personal health record information table. It is an internally assigned number and generally not revealed to the user.
PHR_STATUS_CD DOUBLE N Code value indicating the status of the patient's personal health record election (i.e. YES, NO)
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 Date and time the transaction, which triggered the history 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 - PERSON_PHR_INFO_HIST


Child Column in PERSON_PHR_INFO_HIST(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PERSON_PHR_INFO_ID PERSON_PHR_INFO PERSON_PHR_INFO_ID


PERSON_PHR_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Personal Health Record Relationship
Definition: The person personal health record relationship table relates a patient's personal health record information to a contributor system. This relationship represents the contributor systems to which a patient has elected to send their personal health record.
Table Type: ACTIVITY





Column Detail - PERSON_PHR_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
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.
PERSON_PHR_INFO_ID DOUBLE N The ID of the person's personal health record that is related to the contributor system. This relationship represents the contributor systems to which a patient has elected to send their personal health record.
PERSON_PHR_RELTN_ID DOUBLE N The unique primary key of this table.
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_PHR_RELTN


Child Column in PERSON_PHR_RELTN(FK) Parent Table Name Parent Column Name
Parents: CONTRIBUTOR_SYSTEM_CD CONTRIBUTOR_SYSTEM CONTRIBUTOR_SYSTEM_CD
PERSON_PHR_INFO_ID PERSON_PHR_INFO PERSON_PHR_INFO_ID




Parent Column in PERSON_PHR_RELTN (PK) Child Table Name Child Column Name
Children: PERSON_PHR_RELTN_ID PERSON_PHR_RELTN_HIST PERSON_PHR_RELTN_ID


PERSON_PHR_RELTN_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Personal Health Record Relationship History
Definition: Used for tracking history of certain columns on the person_phr_reltn table.
Table Type: ACTIVITY





Column Detail - PERSON_PHR_RELTN_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.
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.
PERSON_PHR_INFO_ID DOUBLE N This is the value of the unique primary identifier of the person personal health record information table. It is an internally assigned number and generally not revealed to the user.
PERSON_PHR_RELTN_HIST_ID DOUBLE N The unique primary key of this table.
PERSON_PHR_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the person personal health record relationship table. It is an internally assigned number and generally not revealed to the user.
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 Date and time the transaction, which triggered the history 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 - PERSON_PHR_RELTN_HIST


Child Column in PERSON_PHR_RELTN_HIST(FK) Parent Table Name Parent Column Name
Parents: CONTRIBUTOR_SYSTEM_CD CONTRIBUTOR_SYSTEM CONTRIBUTOR_SYSTEM_CD
PERSON_PHR_INFO_ID PERSON_PHR_INFO PERSON_PHR_INFO_ID
PERSON_PHR_RELTN_ID PERSON_PHR_RELTN PERSON_PHR_RELTN_ID


PERSON_PLAN_PROFILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Plan Profile
Definition: The person health plan profile table defines a set of health plan insurance profiles for a patient
Table Type: ACTIVITY





Column Detail - PERSON_PLAN_PROFILE


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_ID DOUBLE N Uniquely identifies the person related to this plan profile.
PERSON_PLAN_PROFILE_ID DOUBLE N Uniquely identifies a set of health plan insurance profiles for a person. This table along with the person plan profile relationship table can be used to order and group person health plan coverages into reimbursement units that can then be used as templates for the encounter health plan coverage.
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).
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


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




Parent Column in PERSON_PLAN_PROFILE (PK) Child Table Name Child Column Name
Children: PERSON_PLAN_PROFILE_ID PERSON_PLAN_PROFILE_HIST PERSON_PLAN_PROFILE_ID
PERSON_PLAN_PROFILE_RELTN PERSON_PLAN_PROFILE_ID
PERSON_PLAN_PROFILE_R_HIST PERSON_PLAN_PROFILE_ID
SCH_EVENT_PATIENT PERSON_PLAN_PROFILE_ID