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 |