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