FHX_ACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | FHX Action |
Definition: | Each row on the table represents clinician's access to the patient's family member's condition record. |
Table Type: | ACTIVITY |
Column Detail - FHX_ACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DT_TM | DATETIME | N | Action taken date time |
ACTION_TYPE_MEAN | VARCHAR(12) | N | Indicates the type of entry on the Family History personnel relation table. It can be REVIEW, CREATE, MODIFY |
ACTION_TZ | DOUBLE | N | Action Date Time Zone |
FHX_ACTION_ID | DOUBLE | N | This is the table's primary key. The unique identifier for a Family History personnel relation. Represents clinician's access to the patient's family member's condition record. |
FHX_ACTIVITY_ID | DOUBLE | N | The unique identifier for a patient Family History Activity table [FHX_ACTIVITY table]. |
PRSNL_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - FHX_ACTION
Child Column in FHX_ACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FHX_ACTIVITY_ID | FHX_ACTIVITY | FHX_ACTIVITY_ID |
PRSNL_ID | PRSNL | PERSON_ID |
FHX_ACTIVITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Family History Activity |
Definition: | Each row on the table represents a Family member's condition |
Table Type: | ACTIVITY |
Column Detail - FHX_ACTIVITY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
COURSE_CD | DOUBLE | N | CODE SET: 12039 Describes the progress of the condition, e.g. Improving, stable, or worsening. |
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. |
FHX_ACTIVITY_GROUP_ID | DOUBLE | N | Non unique identifier for the FHX_ ACTIVITY table. Each change or revision made to a family history detail creates a new family history detail instance. |
FHX_ACTIVITY_ID | DOUBLE | N | this is the table's primary key. The unique identifier for a FHX_ACTIVITY. It will be used to uniquely identify a family member's condition. Uniquely defines a family history detail within the FHX_ ACTIVITY table. The FHX_ ACTIVITY_ID can be associated with multiple family history detail instances. When a new family history detail is added to the FHX_ ACTIVITY table the FHX_ ACTIVITY_ID is assigned to the FHX_ ACTIVITY_GROUP_ID. |
FHX_VALUE_FLAG | DOUBLE | N | Indicates weather the condition for a Family member is positive, negative or unknown. 0 = Negative; 1 = Positive; 2 = Unknown; 3 = Unable to Obtain; 4 = Patient Adopted |
LIFE_CYCLE_STATUS_CD | DOUBLE | N | CODE SET: 12030 The current status of the condition. e.g. Active, Cancelled, Inactive, Resolved. |
NOMENCLATURE_ID | DOUBLE | N | Unique identifier for nomenclature item. Any clinically relevant subject to describe in relations to the family member. |
ONSET_AGE | DOUBLE | Y | Age at Onset |
ONSET_AGE_PREC_CD | DOUBLE | N | CODE SET:25320 Indicated to what level of accuracy the onset date time has been set. |
ONSET_AGE_UNIT_CD | DOUBLE | N | Onset age unit code from codeset 340 |
ORGANIZATION_ID | DOUBLE | N | The field will store org id for the user who writes out the data. We will use this field to enforce person data sharing rules. |
ORIGINATING_ENCNTR_ID | DOUBLE | N | The value of the unique primary identifier of the encounter 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. |
RELATED_PERSON_ID | DOUBLE | N | Related person ID from PERSON table |
SEVERITY_CD | DOUBLE | N | CODE SET: 12022 Severity of a condition reported, e.g. Mild, Moderate, Severe |
TYPE_MEAN | VARCHAR(12) | N | Indicates the type of entry on the FHX_ ACTIVITY table. It can be PERSON, RELTN, CONDITION |
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. |
UPDT_TZ | DOUBLE | Y | The time zone where the row was last inserted or updated. |
Relationship Detail - FHX_ACTIVITY
Child Column in FHX_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORIGINATING_ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
FHX_ACTIVITY_GROUP_ID | FHX_ACTIVITY | FHX_ACTIVITY_ID | |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID | |
RELATED_PERSON_ID | PERSON | PERSON_ID |
Parent Column in FHX_ACTIVITY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | FHX_ACTIVITY_ID | FHX_ACTION | FHX_ACTIVITY_ID |
FHX_ACTIVITY | FHX_ACTIVITY_GROUP_ID | ||
FHX_ACTIVITY_R | FHX_ACTIVITY_S_ID | ||
FHX_ACTIVITY_R | FHX_ACTIVITY_T_ID | ||
FHX_LONG_TEXT_R | FHX_ACTIVITY_GROUP_ID | ||
FHX_LONG_TEXT_R | FHX_ACTIVITY_ID |
FHX_ACTIVITY_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Family History Activity Relation |
Definition: | Each row on the table represents Family History Activity relation. |
Table Type: | ACTIVITY |
Column Detail - FHX_ACTIVITY_R
Column Name | Type | Null? | Definition |
---|---|---|---|
FHX_ACTIVITY_S_ID | DOUBLE | N | This is the value of the unique primary identifier on the FHX_ACTIVITY table. It is an internal system assigned number. |
FHX_ACTIVITY_T_ID | DOUBLE | N | This is the value of the unique primary identifier on the FHX_ACTIVITY table. It is an internal system assigned number. |
TYPE_MEAN | VARCHAR(10) | N | Indicates the type of relationship between the condition rows on FHX_ACTIVITY 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 - FHX_ACTIVITY_R
Child Column in FHX_ACTIVITY_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FHX_ACTIVITY_S_ID | FHX_ACTIVITY | FHX_ACTIVITY_ID |
FHX_ACTIVITY_T_ID | FHX_ACTIVITY | FHX_ACTIVITY_ID |
FHX_LONG_TEXT_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Family History Long Text Relation |
Definition: | Each row on the table represents relationship between the Patient's History condition record and the comment. This is to track comment History on a patient's history condition. |
Table Type: | ACTIVITY |
Column Detail - FHX_LONG_TEXT_R
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMENT_DT_TM | DATETIME | N | Comment added date time |
COMMENT_DT_TM_TZ | DOUBLE | N | Comment Date Time Zone |
COMMENT_PRSNL_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
FHX_ACTIVITY_GROUP_ID | DOUBLE | N | This is the FHX_ACTIVITY_GROUP_ID value from the FHX_ACTIVITY table. |
FHX_ACTIVITY_ID | DOUBLE | N | The unique identifier on the FHX_ACTIVITY table. |
FHX_LONG_TEXT_R_ID | DOUBLE | N | This is the table's primary key. The unique identifier for a family history comment. |
LONG_TEXT_ID | DOUBLE | N | The unique identifier on the LONG_TEXT table. It is an internal system assigned number. Comment on a patient's member condition on the long text table. |
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 - FHX_LONG_TEXT_R
Child Column in FHX_LONG_TEXT_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FHX_ACTIVITY_GROUP_ID | FHX_ACTIVITY | FHX_ACTIVITY_ID |
FHX_ACTIVITY_ID | FHX_ACTIVITY | FHX_ACTIVITY_ID | |
LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
COMMENT_PRSNL_ID | PRSNL | PERSON_ID |
FHX_SECTION_DEF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Section Definition |
Definition: | Each row on the table represents Family History component view. |
Table Type: | REFERENCE |
Column Detail - FHX_SECTION_DEF
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. |
CATEGORY_CD | DOUBLE | N | Category defined in the view. |
FHX_SECTION_DEF_ID | DOUBLE | N | This is the table's primary key. The unique identifier for a Family History section view. It will be used to uniquely identify a category and associated condition. |
NOMENCLATURE_ID | DOUBLE | N | Unique identifier for nomenclature item. Any clinically relevant subject to describe in relations to the family member. |
PRSNL_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - FHX_SECTION_DEF
Child Column in FHX_SECTION_DEF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |
PRSNL_ID | PRSNL | PERSON_ID |