Table Detail Report

SHX_CATEGORY_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: SHX_CATEGORY_DEF
Definition: Each row on the table represents Social History category level information.
Table Type: REFERENCE





Column Detail - SHX_CATEGORY_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.
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.
COMMENT_IND DOUBLE N Indicates comment on the category.
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.
SHX_CATEGORY_DEF_ID DOUBLE N This is the table's primary key. The unique identifier for a Social History category. It will be used to uniquely identify a category.
SHX_CATEGORY_REF_ID DOUBLE N The unique identifier for a Social History categories. It will be used to uniquely identify a category. Foreign Key from SHX_CATEGORY_REF
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 - SHX_CATEGORY_DEF


Child Column in SHX_CATEGORY_DEF(FK) Parent Table Name Parent Column Name
Parents: SHX_CATEGORY_REF_ID SHX_CATEGORY_REF SHX_CATEGORY_REF_ID




Parent Column in SHX_CATEGORY_DEF (PK) Child Table Name Child Column Name
Children: SHX_CATEGORY_DEF_ID SHX_ACTIVITY SHX_CATEGORY_DEF_ID
SHX_ELEMENT SHX_CATEGORY_DEF_ID


SHX_CATEGORY_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: SHX_CATEGORY_REF
Definition: Each row on the table represents Social History sections.
Table Type: REFERENCE





Column Detail - SHX_CATEGORY_REF


Column Name Type Null? Definition
CATEGORY_CD DOUBLE N Code set 4002165. Category code value.
DESCRIPTION VARCHAR(100) N Indicates description for the category
SHX_CATEGORY_REF_ID DOUBLE N This is the table's primary key. The unique identifier for a Social History categories. It will be used to uniquely identify a category.
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 - SHX_CATEGORY_REF


Child Column in SHX_CATEGORY_REF(FK) Parent Table Name Parent Column Name
Parents: CATEGORY_CD CODE_VALUE CODE_VALUE




Parent Column in SHX_CATEGORY_REF (PK) Child Table Name Child Column Name
Children: SHX_CATEGORY_REF_ID SHX_ACTIVITY SHX_CATEGORY_REF_ID
SHX_CATEGORY_DEF SHX_CATEGORY_REF_ID


SHX_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SHX_COMMENT
Definition: Each row on the table represents relationship between the Patient's social history assessment record and the comment. This is to track comment History on a patient's history assessment.
Table Type: ACTIVITY





Column Detail - SHX_COMMENT


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.
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.
COMMENT_DT_TM DATETIME N COMMENT DATE AND TIME
COMMENT_DT_TM_TZ DOUBLE N COMMENT DATE TIME TIME ZONE
COMMENT_PRSNL_ID DOUBLE N Comment personnel id. This is the value of the unique primary identifier of the person table. it is an internal system assigned number.
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.
LONG_TEXT_ID DOUBLE N LONG TEXT ID FROM LONG_TEXT table
SHX_ACTIVITY_GROUP_ID DOUBLE N Activity group. This is the shx_activity_group_id value from the shx_activity table
SHX_ACTIVITY_ID DOUBLE N SEQUENCE NAME: PROBLEM_SEQ unique identifier for the SHX_ ACTIVITY table.
SHX_COMMENT_ID DOUBLE N SEQUENCE NAME: PROBLEM_SEQ This is the table's primary key. the unique identifier for a shx_long_text_r 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 - SHX_COMMENT


Child Column in SHX_COMMENT(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
COMMENT_PRSNL_ID PRSNL PERSON_ID
SHX_ACTIVITY_ID SHX_ACTIVITY SHX_ACTIVITY_ID


SHX_ELEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SHX_ELEMENT
Definition: Each row on the table represents Social History category view.
Table Type: REFERENCE





Column Detail - SHX_ELEMENT


Column Name Type Null? Definition
ELEMENT_SEQ DOUBLE N Identifies the ordering of this element relative to other elements contained within a section.
INPUT_TYPE_CD DOUBLE N Code set 4002169. Unique code value that identifies the default control type for the element.
REQUIRED_IND DOUBLE N Indicates if a response is required for the element. 1=True, 0=False
RESPONSE_LABEL VARCHAR(255) N Label that appears in the overall assessment of the category for a given element
RESPONSE_LABEL_LAYOUT_FLAG DOUBLE N Layout of the element label. It can be 0 - Before, 1 - After or 2 - Instead Result.
SHX_CATEGORY_DEF_ID DOUBLE N Foreign Key from the PROBLEM_SECTION_DEF table The unique identifier for a Social History category view. It will be used to uniquely identify a category.
SHX_ELEMENT_ID DOUBLE N This is the table's primary key. The unique identifier for a Social History category view. It will be used to uniquely identify a category and an element.
TASK_ASSAY_CD DOUBLE N Code set 14003. Unique code value that identifies a specific discrete task assay.
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 - SHX_ELEMENT


Child Column in SHX_ELEMENT(FK) Parent Table Name Parent Column Name
Parents: INPUT_TYPE_CD CODE_VALUE CODE_VALUE
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
SHX_CATEGORY_DEF_ID SHX_CATEGORY_DEF SHX_CATEGORY_DEF_ID


SHX_RESPONSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SHX_RESPONSE
Definition: Each row on the table represents discrete response for an assessment made
Table Type: ACTIVITY





Column Detail - SHX_RESPONSE


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.
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.
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.
RESPONSE_MODIFIER_FLAG DOUBLE N 0 - Actual Age, 1 - About Age, 2 - Before Age, 4 - After Age, 5 - Unknown
RESPONSE_TYPE VARCHAR(12) N Indicates the type of entry on the SHX_ RESPONSE table. It can be ALPHA, NUMERIC, DATE
RESPONSE_UNIT_CD DOUBLE N Unit of measure for responses which are numeric in nature
RESPONSE_VAL VARCHAR(255) N Numeric or Text Response value
SHX_ACTIVITY_ID DOUBLE N SEQUENCE NAME: PROBLEM_SEQ unique identifier for the SHX_ ACTIVITY table.
SHX_RESPONSE_ID DOUBLE N SEQUENCE NAME: PROBLEM_SEQ This is the table's primary key. the unique identifier for a shx_act_assessment table.
TASK_ASSAY_CD DOUBLE N Task Assay Code from Code set 14003.
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 - SHX_RESPONSE


Child Column in SHX_RESPONSE(FK) Parent Table Name Parent Column Name
Parents: SHX_ACTIVITY_ID SHX_ACTIVITY SHX_ACTIVITY_ID




Parent Column in SHX_RESPONSE (PK) Child Table Name Child Column Name
Children: SHX_RESPONSE_ID SHX_ALPHA_RESPONSE SHX_RESPONSE_ID