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 |