Table Detail Report
ENCNTR_LEGAL_AUTH_R_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Legal Authority Relationship History |
Definition: | Used for tracking history of changes to encounter legal authority relationship. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_LEGAL_AUTH_R_HIST
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. |
CHANGE_BIT | DOUBLE | N | Identifies which columns have had a change. |
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. |
ENCNTR_LEGAL_AUTH_R_HIST_ID | DOUBLE | N | Unique generated number that identifies a single row on the ENCNTR_LEGAL_AUTH_R_HIST 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. |
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. |
TRACKING_BIT | DOUBLE | N | Identifies which columns are being tracked for history. |
TRANSACTION_DT_TM | DATETIME | N | ** OBSOLETE **. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time. |
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_LEGAL_AUTH_R_HIST
Child Column in ENCNTR_LEGAL_AUTH_R_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_LEGAL_AUTH_RELTN_ID | ENCNTR_LEGAL_AUTH_RELTN | ENCNTR_LEGAL_AUTH_RELTN_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
LEGAL_AUTHORITY_ID | LEGAL_AUTHORITY | LEGAL_AUTHORITY_ID | |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID |
ENCNTR_LEGAL_REVIEW_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Legal Status Review Relationship |
Definition: | This table will hold the relationship between legal statuses and Review Board history records |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_LEGAL_REVIEW_R
Column Name | Type | Null? | Definition |
---|---|---|---|
DECISION_CD | DOUBLE | N | Decision reached by the review board, e.g. GUILTY, NOT GUILTY Code Set 29445. |
DISPOSITION_RECVD_DT_TM | DATETIME | Y | The date and time the disposition was received |
ENCNTR_LEG_STAT_REV_R_ID | DOUBLE | N | The unique identifier for the ENCNTR_LEGAL_STATUS_REV_R table |
HEARING_DT_TM | DATETIME | Y | The date and time of the hearing |
LEGAL_RECOMMENDATION_CD | DOUBLE | N | The recommended legal action |
LEGAL_STATUS_R_ID | DOUBLE | N | Inherited Identifier for rows associated to the ENCNTR_LEGAL_STATUS_R table |
LOCATION_CD | DOUBLE | N | The location of the Hearing |
OTHER_RECOMMENDATION_CD | DOUBLE | N | Other recommended Legal action |
REASON_RECVD_DT_TM | DATETIME | Y | The Date and Time the reason was received |
RECOMMENDATION_CD | DOUBLE | N | Recommended action |
REVIEW_BOARD_CD | DOUBLE | N | The facility defined review board code |
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_REVIEW_R
Child Column in ENCNTR_LEGAL_REVIEW_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LEGAL_STATUS_R_ID | ENCNTR_LEGAL_STATUS_R | LEGAL_STATUS_R_ID |
ENCNTR_LEGAL_STATUS_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter legal status relation. |
Definition: | Holds the relationship between encounters and their corresponding legal statuses. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_LEGAL_STATUS_R
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. |
ADJOURNMENT_DT_TM | DATETIME | Y | The date and time the case was adjourned. |
COURT_DT_TM | DATETIME | Y | The court date and time. |
COURT_FILE_NUM | VARCHAR(40) | Y | The file number representing the court case. |
COURT_LOCATION_CD | DOUBLE | N | The location at which the court proceedings took place. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
END_DT_TM | DATETIME | Y | End Date and Time value |
LEGAL_STATUS_CD | DOUBLE | N | Legal Status Code |
LEGAL_STATUS_R_ID | DOUBLE | N | Unique identifier for the encntr_legal_status_r table. |
LEGAL_STAT_INACTIVE_IND | DOUBLE | Y | Indicates whether the legal status has been inactivated by the user. |
NEXT_REVIEW_DT_TM | DATETIME | Y | The date and time of the next review. |
PROBABLE_SENTENCE_DT_TM | DATETIME | Y | The date and time of the probable sentence. |
REFERRAL_DT_TM | DATETIME | Y | The referring datetime of the corresponding legal status. |
REFERRAL_FACILITY_CD | DOUBLE | N | The referring facility for the corresponding legal status. |
REFERRAL_SOURCE_CD | DOUBLE | N | The referral source for the corresponding legal status. |
REFERRAL_TYPE_CD | DOUBLE | N | The referral type for the corresponding legal status. |
REGION_CD | DOUBLE | N | The corresponding region of the legal status. |
REQ_EXTENSION_DT_TM | DATETIME | Y | The date and time a request for extension was made. |
SENTENCE_DT_TM | DATETIME | Y | The date and the time the sentence was or will be given. |
START_DT_TM | DATETIME | Y | The time the legal status was activated. |
STAY_OF_PROCEEDINGS_DT_TM | DATETIME | Y | The date and time of the stay of proceedings. |
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. |
VERBAL_STAY_DT_TM | DATETIME | Y | The date and time of the verbal stay. |
WRITTEN_STAY_DT_TM | DATETIME | Y | The date and time of the written stay. |
Relationship Detail - ENCNTR_LEGAL_STATUS_R
Child Column in ENCNTR_LEGAL_STATUS_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
Parent Column in ENCNTR_LEGAL_STATUS_R (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LEGAL_STATUS_R_ID | ENCNTR_LEGAL_REVIEW_R | LEGAL_STATUS_R_ID |
ENCNTR_LEGAL_STAT_CRIM_R | LEGAL_STATUS_R_ID | ||
ENCNTR_LEGAL_STAT_HIST | LEGAL_STATUS_R_ID |
ENCNTR_LEGAL_STAT_CRIM_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter legal status criminal relation. |
Definition: | This table will hold the relationship between legal statuses and criminal codes. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_LEGAL_STAT_CRIM_R
Column Name | Type | Null? | Definition |
---|---|---|---|
CRIMINAL_CD | DOUBLE | N | The facility defined criminal code. |
LEGAL_STATUS_CRIMINAL_R_ID | DOUBLE | N | The unique identifier for the encntr_legal_stat_crim_r table. |
LEGAL_STATUS_R_ID | DOUBLE | N | Unique identifier for the encntr_legal_status_r 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. |
Relationship Detail - ENCNTR_LEGAL_STAT_CRIM_R
Child Column in ENCNTR_LEGAL_STAT_CRIM_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LEGAL_STATUS_R_ID | ENCNTR_LEGAL_STATUS_R | LEGAL_STATUS_R_ID |
ENCNTR_LEGAL_STAT_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Legal Status Relation History |
Definition: | Holds the history of the relationships between encounters and their corresponding legal statuses |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_LEGAL_STAT_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ADJOURNMENT_DT_TM | DATETIME | Y | The date and time the case was adjourned |
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. |
COURT_DT_TM | DATETIME | Y | The Date and Time of the court hearing |
COURT_FILE_NUM | VARCHAR(40) | Y | The file number representing the court case |
COURT_LOCATION_CD | DOUBLE | N | The location at which the court proceedings took place |
END_DT_TM | DATETIME | Y | The time the legal status was inactivated |
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_HIST_ID | DOUBLE | N | Unique identifier for the ENCNTR_LEGAL_STATUS_HIST_R table |
LEGAL_STATUS_R_ID | DOUBLE | N | Inherited Identifier for rows associated from the ENCNTR_LEGAL_STATUS_R table |
NEXT_REVIEW_DT_TM | DATETIME | Y | The date and time of the next review |
PROBABLE_SENTENCE_DT_TM | DATETIME | Y | The date and time of the probable sentence |
REFERRAL_DT_TM | DATETIME | Y | The referring datetime of the corresponding legal status. |
REFERRAL_FACILITY_CD | DOUBLE | N | The referring facility for the corresponding legal status. |
REFERRAL_SOURCE_CD | DOUBLE | N | The referral source for the corresponding legal status. |
REFERRAL_TYPE_CD | DOUBLE | N | The referral type for the corresponding legal status. |
REGION_CD | DOUBLE | N | The corresponding region of the legal status. |
REQ_EXTENSION_DT_TM | DATETIME | Y | The date and time a request for extension was made |
SENTENCE_DT_TM | DATETIME | Y | The date and time the sentence was or will be given |
START_DT_TM | DATETIME | Y | The time the legal status was activated |
STAY_OF_PROCEEDINGS_DT_TM | DATETIME | Y | The date and time of the Stay of Proceedings |
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. |
VERBAL_STAY_DT_TM | DATETIME | Y | The date and time of the Verbal Stay |
WRITTEN_STAY_DT_TM | DATETIME | Y | The date and time of the Written Stay |
Relationship Detail - ENCNTR_LEGAL_STAT_HIST
Child Column in ENCNTR_LEGAL_STAT_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LEGAL_STATUS_R_ID | ENCNTR_LEGAL_STATUS_R | LEGAL_STATUS_R_ID |