Table Detail Report
ENCNTR_INPTNT_REHAB_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Inpatient Rehab History |
Definition: | Used for tracking history of columns on the ENCNTR_INPATIENT_REHAB table. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_INPTNT_REHAB_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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 | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | Y | The person who caused the active_status_cd to be set or change. |
ADMIT_IMPAIR_GRP_CD | DOUBLE | Y | The physical, mental, or cognitive limitation category for the patient at the time of admission. Each impairment group may require different types of support, accommodations, and interventions to address the specific challenges and needs of individuals with those limitations. |
CHANGE_BIT | DOUBLE | Y | Identifies which columns have had a change. |
DISCH_IMPAIR_GRP_CD | DOUBLE | Y | The physical, mental, or cognitive limitation category for the patient at the time of discharge. Each impairment group may require different types of support, accommodations, and interventions to address the specific challenges and needs of individuals with those limitations. |
ENCNTR_INPTNT_REHAB_HIST_ID | DOUBLE | N | A system generated code used to uniquely identify a row on the ENCNTR_INPTNT_REHAB_HIST table. |
ENCNTR_INPTNT_REHAB_ID | DOUBLE | Y | A system generated number used to uniquely identify a row on the ENCNTR_INPTNT_REHAB table. |
PM_HIST_TRACKING_ID | DOUBLE | Y | ID used to uniquely identify the related row on the PM_HIST_TRACKING table. |
QUALIFYING_COND_CD | DOUBLE | Y | The condition that qualifies the patient for Medicare coverage at an inpatient rehab facility. |
TRACKING_BIT | DOUBLE | Y | Identifies which columns are being tracked for history. |
TRANSACTION_DT_TM | DATETIME | Y | More aptly named activity_dt_tm; holds the current date and time of the system when the row was inserted. This will match the create_dt_tm from the corresponding pm_hist_tracking row. |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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 - ENCNTR_INPTNT_REHAB_HIST
Child Column in ENCNTR_INPTNT_REHAB_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID |
ENCNTR_LEAVE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter leave. |
Definition: | Stores information relating to an encounter that has been put on leave from the facility. It is also used to capture information when the patient returns from leave, and any information relating to a cancel of the leave or return. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_LEAVE
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 | Y | 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. |
AUTO_DISCH_DT_TM | DATETIME | Y | Date and time the patient will be auto-discharged if patient is still on leave of absence. |
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. |
CANCEL_COMMENT | VARCHAR(255) | Y | Textual comment field to describe the reason the leave or return was cancelled. |
CANCEL_DT_TM | DATETIME | Y | Date and time the leave or return was cancelled. |
CANCEL_REASON_CD | DOUBLE | N | Codified reason for why the leave or return was cancelled. |
CANCEL_USER_ID | DOUBLE | N | User that cancelled the leave or return from leave. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENCNTR_LEAVE_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter leave 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. |
END_LEAVE_USER_ID | DOUBLE | N | User who documented that the patient's leave of absence has ended. |
EST_RETURN_DT_TM | DATETIME | Y | The date and time that the leave is estimated to be over and returned. This time may or may not reflect the true date and time that the patient returned from leave. |
HOLD_RMVL_DT_TM | DATETIME | Y | Date and time the room and bed will be removed if patient is still on leave of absence. |
LEAVE_COMMENT | VARCHAR(255) | Y | Free-text comment describing any notes or information relating to the encounter leave. |
LEAVE_DISPOSITION_CD | DOUBLE | N | Codified leave disposition code that indicates the condition under which the patient left the facility following the leave of absence. |
LEAVE_DT_TM | DATETIME | Y | The date and time the encounter was placed on leave. |
LEAVE_IND | DOUBLE | N | Indicator used to reflect the current status of the leave. 0 = not on leave (returned or cancelled) 1 = on leave |
LEAVE_LOCATION | VARCHAR(100) | Y | Text column used to store the location the patient/encounter is going while on leave. |
LEAVE_REASON_CD | DOUBLE | N | Codified reason for why the encounter was placed on leave. |
LEAVE_STATUS_CD | DOUBLE | N | Codified leave status of the patient's leave of absence. (i.e. on leave, did not return, returned from leave). |
LEAVE_TYPE_CD | DOUBLE | N | Codified leave type for the encounter that was placed on leave. |
LEAVE_USER_ID | DOUBLE | N | User who placed the encounter on leave. |
RETURN_COMMENT | VARCHAR(255) | Y | Textual comment describing notes or information regarding the encounter's return from leave. |
RETURN_DT_TM | DATETIME | Y | Date and time the encounter returned from leave. |
RETURN_LOCATION_CD | DOUBLE | N | Location, within the Location data model (facility), to which the encounter was returned. |
RETURN_REASON_CD | DOUBLE | N | Codified reason explaining the reason the encounter returned from leave. |
RETURN_USER_ID | DOUBLE | N | User who returned the encounter from leave. |
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 - ENCNTR_LEAVE
Child Column in ENCNTR_LEAVE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
END_LEAVE_USER_ID | PRSNL | PERSON_ID |
Parent Column in ENCNTR_LEAVE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENCNTR_LEAVE_ID | ENCNTR_LEAVE_HISTORY | ENCNTR_LEAVE_ID |
ENCNTR_LEAVE_HISTORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter leave history. |
Definition: | Stores historical information for an encounter that has been put on leave. As the encntr_leave table is updated, rows are written to this table to track the entire process from a historical perspective from leave to return including any cancels. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_LEAVE_HISTORY
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 | Y | 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. |
AUTO_DISCH_DT_TM | DATETIME | Y | Date and time the patient will be auto-discharged if patient is still on leave of absence. |
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. |
CANCEL_COMMENT | VARCHAR(255) | Y | Textual comment field to describe the reason the leave or return was cancelled. |
CANCEL_DT_TM | DATETIME | Y | Date and time the leave or return was cancelled. |
CANCEL_REASON_CD | DOUBLE | N | Codified reason for why the leave or return was cancelled. |
CANCEL_USER_ID | DOUBLE | N | User that cancelled the leave or return from leave. |
CHANGE_BIT | DOUBLE | N | Identifies which columns have had a change. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the related encounter. |
ENCNTR_LEAVE_HISTORY_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter leave history table. It is an internal system assigned number. |
ENCNTR_LEAVE_ID | DOUBLE | N | This is the value of the unique primary identifier of the row on the encounter leave table associated with this history row. 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. |
END_LEAVE_USER_ID | DOUBLE | N | User who documented that the patient's leave of absence has ended. |
EST_RETURN_DT_TM | DATETIME | Y | The date and time that the leave is estimated to be over and returned. This time may or may not reflect the true date and time that the patient returned from leave. |
HISTORY_DT_TM | DATETIME | N | Date and time the history row is written. |
HOLD_RMVL_DT_TM | DATETIME | Y | Date and time the room and bed will be removed if patient is still on leave of absence. |
LEAVE_COMMENT | VARCHAR(255) | Y | Free-text comment describing any notes or information relating to the encounter leave. |
LEAVE_DISPOSITION_CD | DOUBLE | N | Codified leave disposition code that indicates the condition under which the patient left the facility following the leave of absence. |
LEAVE_DT_TM | DATETIME | Y | The date and time the encounter was placed on leave. |
LEAVE_IND | DOUBLE | Y | Indicator used to reflect the current status of the leave. 0 = not on leave (returned or cancelled) 1 = on leave |
LEAVE_LOCATION | VARCHAR(100) | Y | Text column used to store the location the patient/encounter is going while on leave. |
LEAVE_REASON_CD | DOUBLE | N | Codified reason for why the encounter was placed on leave. |
LEAVE_STATUS_CD | DOUBLE | N | Codified leave status of the patient's leave of absence. (i.e. on leave, did not return, returned from leave). |
LEAVE_TYPE_CD | DOUBLE | N | Codified leave type for the encounter that was placed on leave. |
LEAVE_USER_ID | DOUBLE | N | User who placed the encounter on leave. |
PM_HIST_TRACKING_ID | DOUBLE | N | This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number. |
RETURN_COMMENT | VARCHAR(255) | Y | Textual comment describing notes or information regarding the encounter's return from leave. |
RETURN_DT_TM | DATETIME | Y | Date and time the encounter returned from leave. |
RETURN_LOCATION_CD | DOUBLE | N | Location, within the Location data model (facility), to which the encounter was returned. |
RETURN_REASON_CD | DOUBLE | N | Codified reason explaining the reason the encounter returned from leave. |
RETURN_USER_ID | DOUBLE | N | User who returned the encounter from leave. |
TRACKING_BIT | DOUBLE | N | Identifies which columns are being tracked for history. |
TRANSACTION_DT_TM | DATETIME | Y | More aptly named activity_dt_tm; holds the current date and time of the system when the row was inserted. This will match the create_dt_tm from the corresponding pm_hist_tracking row. |
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 - ENCNTR_LEAVE_HISTORY
Child Column in ENCNTR_LEAVE_HISTORY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_LEAVE_ID | ENCNTR_LEAVE | ENCNTR_LEAVE_ID |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID | |
END_LEAVE_USER_ID | PRSNL | PERSON_ID |
ENCNTR_LEGALSTAT_CRIM_HIST
Column Section | Top of Page |
Table-level Detail
Description: | Encounter legal status criminal history. |
Definition: | This table will hold the history of the relationship between legal statuses and criminal codes. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_LEGALSTAT_CRIM_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
LEGAL_STATUS_CRIMINAL_R_ID | DOUBLE | N | The unique identifier for the encntr_legal_stat_crim_r table. |
LEGAL_STAT_CRIM_HIST_ID | DOUBLE | N | The unique identifier for the encntr_legalstat_crim_hist table. |
OCCURRENCES_NBR | DOUBLE | Y | The number of occurrences of the offense. |
OFFENSE_DT_TM | DATETIME | Y | The date and time of the offense. |
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. |
ENCNTR_LEGAL_AUTH_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Legal Authority Relationship |
Definition: | The encounter legal authority relationship table contains pointers to legal authority associated with the encounter. Legal authority refers to the approval issued by the court for treating a patient who is committed to the facility for care. For both forensic (committed a crime) and civil (involuntarily hospitalized) patients, the facility requires the legal authority for treatment. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_LEGAL_AUTH_RELTN
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. |
COMMITMENT_CATEGORY_CD | DOUBLE | N | Identifies the category of the patient's commitment to the facility. |
COMMITMENT_PERIOD | DOUBLE | N | The length of time specified in the court order by which the facility has legal authority to hold the patient. |
COMMITMENT_PERIOD_UNIT_CD | DOUBLE | N | Identifies the unit qualifier (days, hours, etc.) for the commitment period. |
COMMITMENT_REASON_CD | DOUBLE | N | Identifies the reason for the patient's commitment to the facility. |
COMMITMENT_TYPE_FLIP_IND | DOUBLE | N | The information indicating if the commitment type for the patient has changed with respect to the previous legal authority for the encounter. |
COUNTY_CD | DOUBLE | N | The county code is the code set that value that represents the county which provided the legal authority to treat the patient. |
COURT_ORDER_NUMBER | VARCHAR(50) | Y | The identifying number of the court order(s) issued for the patient. |
COURT_ORDER_RECEIVE_DT_TM | DATETIME | Y | The date and time at which the facility received the issued court order. |
COURT_ORDER_SIGN_DT_TM | DATETIME | Y | The date and time at which the issued court order was signed. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENCNTR_LEGAL_AUTH_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the ENCNTR_LEGAL_AUTH_RELTN table. |
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. |
LEGAL_AUTHORITY_ID | DOUBLE | N | Identifier from the LEGAL_AUTHORITY table that contains various attributes representing the legal authority. |
NEXT_COURT_HEARING_DT_TM | DATETIME | Y | The date and time of the patient's next court hearing. |
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 - ENCNTR_LEGAL_AUTH_RELTN
Child Column in ENCNTR_LEGAL_AUTH_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
LEGAL_AUTHORITY_ID | LEGAL_AUTHORITY | LEGAL_AUTHORITY_ID |
Parent Column in ENCNTR_LEGAL_AUTH_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENCNTR_LEGAL_AUTH_RELTN_ID | ENCNTR_LEGAL_AUTH_R_HIST | ENCNTR_LEGAL_AUTH_RELTN_ID |