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