BH_GROUP_DOC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Behavioral Health Group Documentation |
Definition: | Information about a particular Behavioral Health Group session. |
Table Type: | ACTIVITY |
Column Detail - BH_GROUP_DOC
Column Name | Type | Null? | Definition |
---|---|---|---|
BEGIN_DT_TM | DATETIME | N | Therapy session begin date and time |
BH_GROUP_DOC_ID | DOUBLE | N | Unique generated number that identifies a single row on the BH_GROUP_DOC table. |
BILL_ITEM_CATALOG_CD | DOUBLE | N | Refers to a selected charge (bill_item) in Therapy Notes. |
CREATED_BY_ID | DOUBLE | N | Foreign Key value to PRSNL table - the person who created the note. |
CREATED_DT_TM | DATETIME | N | Create date and time of the Therapeutic Note |
DOC_STATUS_CD | DOUBLE | N | The status of the documentation. |
END_DT_TM | DATETIME | N | Therapy session end date and time. |
GOALS_LONG_BLOB_ID | DOUBLE | N | Goals set for the group. |
GROUP_SLOT_LINK_VALUE | DOUBLE | N | An identifier to link all the slots or/and appointments in the same group session together. |
LOCATION_CD | DOUBLE | N | The Location where the session was held. |
NOTES_LONG_BLOB_ID | DOUBLE | N | Narrative documentation for the group. |
NOTES_REFUSE_COMMENT_TXT | VARCHAR(1000) | Y | The reason a physician refused to accept the therapy session notes. |
NOTES_REFUSE_IND | DOUBLE | N | Indicates whether the physician refused to accept the notes submitted by a student. |
ORIG_BH_GROUP_DOC_ID | DOUBLE | N | Used for building a hierarchy within the documents.Indvidual patient deails like behavior, notes, goalsetc. are available to capture initially, whereas a few patients details would be pending. So the note would be signed in batches and these batches will be related through this column. |
PATIENT_LIST_ID | DOUBLE | N | Foreign key from DCP_PATIENT_LIST. Identifies from which Patient List Group document the patients should be pulled. |
PRI_FCLTR_PRSNL_ID | DOUBLE | N | Primary facilitator who conducts the therapy session |
PROPOSED_BILL_ITEM_ID | DOUBLE | N | The charte item that the physician chose for the therapy session. |
SCH_APPT_ID | DOUBLE | N | Schedule identifier connected to the Therapeutic Note. |
SCH_APPT_TYPE_FLAG | DOUBLE | Y | Appointment Type connected to Therapeutic Notes through Revenue cycle and scheduling |
SERVICE_TOPIC_CD | DOUBLE | N | The topic for the therapy session. |
SERVICE_TYPE_CD | DOUBLE | N | The service type for the therapy session. |
SESSION_LENGTH_MINS | DOUBLE | N | The length of the session in minutes. |
SESSION_MODE_CD | DOUBLE | N | Therapy session mode of facilitation. |
SESSION_MODIFIER_CD | DOUBLE | N | Refersto a Charge modifier (bill_item) connected to the Therapeutic Note. Session Modifier is an additional item for dropping charge, another bill_item for the session. This additional charge may or may not be selected by the user. |
SESSION_NAME | VARCHAR(255) | N | The title of the session. |
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. |
VERIFIED_BY_ID | DOUBLE | N | Personnel ID that verified a Therapeutic Note. |
VOLUNTEER_INVOLVED_CD | DOUBLE | N | Indicates if any volunteer was involved in the therapy session. |
Relationship Detail - BH_GROUP_DOC
Child Column in BH_GROUP_DOC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORIG_BH_GROUP_DOC_ID | BH_GROUP_DOC | BH_GROUP_DOC_ID |
PROPOSED_BILL_ITEM_ID | BILL_ITEM | BILL_ITEM_ID | |
PATIENT_LIST_ID | DCP_PATIENT_LIST | PATIENT_LIST_ID | |
LOCATION_CD | LOCATION | LOCATION_CD | |
GOALS_LONG_BLOB_ID | LONG_BLOB | LONG_BLOB_ID | |
NOTES_LONG_BLOB_ID | LONG_BLOB | LONG_BLOB_ID | |
CREATED_BY_ID | PRSNL | PERSON_ID | |
PRI_FCLTR_PRSNL_ID | PRSNL | PERSON_ID | |
VERIFIED_BY_ID | PRSNL | PERSON_ID | |
SCH_APPT_ID | SCH_APPT | SCH_APPT_ID |
Parent Column in BH_GROUP_DOC (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BH_GROUP_DOC_ID | BH_GROUP_DOC | ORIG_BH_GROUP_DOC_ID |
BH_GROUP_DOC_PATIENT | BH_GROUP_DOC_ID | ||
BH_GROUP_DOC_PRSNL | BH_GROUP_DOC_ID |
BH_GROUP_DOC_PATIENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Behavioral Health Group Documentation Patient |
Definition: | The patient that participates in the group therapy session. |
Table Type: | ACTIVITY |
Column Detail - BH_GROUP_DOC_PATIENT
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. |
ATTEND_CD | DOUBLE | N | Identifier if the patient attended the therapy session. |
BEGIN_DT_TM | DATETIME | N | The date and time the patient arrived for the session. |
BH_GROUP_DOC_ID | DOUBLE | N | The session that this patient was scheduled to attend. |
BH_GROUP_DOC_PATIENT_ID | DOUBLE | N | Unique generated number that identifies a single row on the BH_GROUP_DOC_PATIENT table. |
ENCNTR_ID | DOUBLE | N | The encounter for this patient in this session. |
END_DT_TM | DATETIME | N | The date and time the patient left the therapy session. |
EVENT_ID | DOUBLE | N | The clinical note created for the patient. |
HIGH_PRIORITY_IND | DOUBLE | N | To flag specific clinical notes as important for easier referenceability and review at a later date. |
PERSON_ID | DOUBLE | N | The patient that is scheduled for this therapy session. |
SESSION_LENGTH_MINS | DOUBLE | N | The number of minutes this patient attended the session. |
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 - BH_GROUP_DOC_PATIENT
Child Column in BH_GROUP_DOC_PATIENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BH_GROUP_DOC_ID | BH_GROUP_DOC | BH_GROUP_DOC_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in BH_GROUP_DOC_PATIENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BH_GROUP_DOC_PATIENT_ID | BH_GROUP_DOC_PATIENT_ATTR | BH_GROUP_DOC_PATIENT_ID |
BH_GROUP_DOC_PATIENT_CS | BH_GROUP_DOC_PATIENT_ID |
BH_GROUP_DOC_PATIENT_ATTR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Behavioral Health Group Documentation Patient Attribute |
Definition: | Information that pertains to the patient schedule for the therapy session. |
Table Type: | ACTIVITY |
Column Detail - BH_GROUP_DOC_PATIENT_ATTR
Column Name | Type | Null? | Definition |
---|---|---|---|
BH_GROUP_DOC_PATIENT_ATTR_ID | DOUBLE | N | Unique generated number that identifies a single row on the BH_GROUP_DOC_PATIENT_ATTR table. |
BH_GROUP_DOC_PATIENT_ID | DOUBLE | N | The patient that the information on this row pertains to. |
COLLATION_SEQ | DOUBLE | N | Used to define ordering of section. Example : If more than one goal is defined for a patient, Goal1, Goal2, Goal3, etc. collation_seq used to decide the order. |
MPAGE_SECTION_NAME | VARCHAR(255) | N | The name of the mPage section. |
PARENT_ENTITY_ID | DOUBLE | N | The Unique Identifier from the corresponding table referenced in PARENT_ENTITY_NAME which identifies patient attribute. Example : If a goal defined for a patient, Patient's achievement for the goal will be a code value. In this case PARENT_ENTITY_NAME will be CODE_VALUE and parent_entity_id will be its identifier. |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The name of the table used to find the information recorded in parent_entity_name. |
SECTION_TITLE_TXT | VARCHAR(255) | N | Used for dynamic titles of certain attributes. |
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 - BH_GROUP_DOC_PATIENT_ATTR
Child Column in BH_GROUP_DOC_PATIENT_ATTR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BH_GROUP_DOC_PATIENT_ID | BH_GROUP_DOC_PATIENT | BH_GROUP_DOC_PATIENT_ID |
BH_GROUP_DOC_PATIENT_CS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Behavioral Health Group Doc Patient Charge Services |
Definition: | The charges (bill items) for each patient and their encounter for the therapy session. |
Table Type: | ACTIVITY |
Column Detail - BH_GROUP_DOC_PATIENT_CS
Column Name | Type | Null? | Definition |
---|---|---|---|
BH_GROUP_DOC_PATIENT_CS_ID | DOUBLE | N | Unique generated number that identifies a single row on the BH_GROUP_DOC_PATIENT_CS table. |
BH_GROUP_DOC_PATIENT_ID | DOUBLE | N | The patient that the information on this row pertains to. |
BILL_ITEM_ID | DOUBLE | N | Selection of a charge(bill_item) to drop charges; |
BILL_ITEM_STATUS_CD | DOUBLE | N | Status of the bill item (in-progress, dropped, etc.) |
EVENT_ID | DOUBLE | N | The ID of the clinical event associated to this medication admin event. |
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 - BH_GROUP_DOC_PATIENT_CS
Child Column in BH_GROUP_DOC_PATIENT_CS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BH_GROUP_DOC_PATIENT_ID | BH_GROUP_DOC_PATIENT | BH_GROUP_DOC_PATIENT_ID |
BILL_ITEM_ID | BILL_ITEM | BILL_ITEM_ID |
BH_GROUP_DOC_PRSNL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Behavioral Health Group Documentation Personnel |
Definition: | The personnel that are assoicated to a Behavioral Health Group. |
Table Type: | ACTIVITY |
Column Detail - BH_GROUP_DOC_PRSNL
Column Name | Type | Null? | Definition |
---|---|---|---|
ASSOC_PRSNL_FULL_NAME | VARCHAR(200) | N | Name of personnel if they are not part of the organization. |
ASSOC_PRSNL_ID | DOUBLE | N | The person who is a part of the therapy session as either a facilitator or a cosigner. |
ASSOC_PRSNL_TYPE_FLAG | DOUBLE | N | The role that this personnel plays in the group. |
BH_GROUP_DOC_ID | DOUBLE | N | The group that this personnel is assigned a role for. |
BH_GROUP_DOC_PRSNL_ID | DOUBLE | N | Unique, generated number that identifies a single row on the BH_GROUP_DOC_PRSNL 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. |
VOLUNTEER_IND | DOUBLE | N | Indicates if this person is volunteering on the group. |
Relationship Detail - BH_GROUP_DOC_PRSNL
Child Column in BH_GROUP_DOC_PRSNL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BH_GROUP_DOC_ID | BH_GROUP_DOC | BH_GROUP_DOC_ID |
ASSOC_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in BH_GROUP_DOC_PRSNL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BH_GROUP_DOC_PRSNL_ID | BH_GROUP_DOC_PRSNL_ACT | BH_GROUP_DOC_PRSNL_ID |