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