Table Detail Report

ENCNTR_LEGAL_STAT_REV_HIST



Column Section Top of Page


Table-level Detail

Description: ENCNTR LEGAL STAT REV HIST
Definition: Legal status review history.
Table Type: ACTIVITY





Column Detail - ENCNTR_LEGAL_STAT_REV_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.
DECISION_CD DOUBLE N The decision reached by the review board. ex. (guilty, not guilty)
DISPOSITION_RECVD_DT_TM DATETIME Y The date and time the disposition was received.
ENCNTR_LEGSTAT_REV_HIST_ID DOUBLE N Encounter legal status review relation id.
ENCNTR_LEG_STAT_REV_R_ID DOUBLE N The unique identifier for the encntr_legal_status_rev_r 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.
HEARING_DT_TM DATETIME Y The date and time of the hearing.
LEGAL_RECOMMENDATION_CD DOUBLE N Legal recommendation action.
LOCATION_CD DOUBLE N The location of the hearing.
OTHER_RECOMMENDATION_CD DOUBLE N Other recommended action.
REASON_RECVD_DT_TM DATETIME Y Date and time the reason was received.
RECOMMENDATION_CD DOUBLE N Recommended action.
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_LOCATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Location
Definition: Links a patient during an encounter to a permanent location within a specific period of time.
Table Type: ACTIVITY





Column Detail - ENCNTR_LOCATION


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.
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_LOCATION_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_LOCATION 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.
FACILITY_ORG_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. This column is valued with the facility organization for the encounter.
LOCATION_CD DOUBLE N Identifies the permanent location of the patient. The location for an inpatient will be valued with the lowest level location type in the hierarchy of facility, building, nurse unit, room, bed.
LOC_BED_CD DOUBLE N The patient location with a location type of bed.
LOC_BUILDING_CD DOUBLE N The patient location with a location type of building.
LOC_FACILITY_CD DOUBLE N The patient location with a location type of facility.
LOC_NURSE_UNIT_CD DOUBLE N The patient location with a location type of nurse unit or ambulatory.
LOC_ROOM_CD DOUBLE N The patient location with a location type of room.
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_LOCATION


Child Column in ENCNTR_LOCATION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LOCATION_CD LOCATION LOCATION_CD
LOC_BED_CD LOCATION LOCATION_CD
LOC_BUILDING_CD LOCATION LOCATION_CD
LOC_FACILITY_CD LOCATION LOCATION_CD
LOC_NURSE_UNIT_CD LOCATION LOCATION_CD
LOC_ROOM_CD LOCATION LOCATION_CD
FACILITY_ORG_ID ORGANIZATION ORGANIZATION_ID




Parent Column in ENCNTR_LOCATION (PK) Child Table Name Child Column Name
Children: ENCNTR_LOCATION_ID ENCNTR_LOCATION_HIST ENCNTR_LOCATION_ID


ENCNTR_LOCATION_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Location History
Definition: Used for tracking history of certain columns on the encntr_location table.
Table Type: ACTIVITY





Column Detail - ENCNTR_LOCATION_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.
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_LOCATION_HIST_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_LOCATION_HIST table.
ENCNTR_LOCATION_ID DOUBLE N This is the value of the unique primary identifier of the encounter location 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.
FACILITY_ORG_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. This column is valued with the facility organization for the encounter.
LOCATION_CD DOUBLE N The field identifies the location of the patient/encounter at the time the history row is written. The location will be valued with the lowest available level location type in the hierarchy of facility, building, nurse unit, room, bed.
LOC_BED_CD DOUBLE N The patient location with a location type of bed.
LOC_BUILDING_CD DOUBLE N The patient location with a location type of building.
LOC_FACILITY_CD DOUBLE N The patient location with a location type of facility.
LOC_NURSE_UNIT_CD DOUBLE N The patient location with a location type of nurse unit or ambulatory.
LOC_ROOM_CD DOUBLE N The patient location with a location type of room.
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 Y ** Obsolete ** This column has been obsoleted. 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_LOCATION_HIST


Child Column in ENCNTR_LOCATION_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_LOCATION_ID ENCNTR_LOCATION ENCNTR_LOCATION_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


ENCNTR_LOC_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Location History
Definition: Contains the history of location, encntr type, med service, and alt level of care changes for a specific encounter. This can be used for processes requiring patient encounter tracking information, for example, infection control.
Table Type: ACTIVITY





Column Detail - ENCNTR_LOC_HIST


Column Name Type Null? Definition
ACCOMMODATION_CD DOUBLE N Current type of accommodations in which the patient (encounter) has been placed. (e.g. Private, Semi Private, etc.)
ACCOMMODATION_REASON_CD DOUBLE N Describes why the accommodation the patient received was given. (e.g. Doctor requested, patient requested)
ACCOMMODATION_REQUEST_CD DOUBLE N Describes the accommodation that was requested, either by the patient or a staff member. This value may differ from the actual accommodation that the patient/encounter was given. For example, the patient may request a private room, but only receive a semi-private room because no private beds were available.
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 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.
ACTIVITY_DT_TM DATETIME Y This column holds the current date and time of the system that the row was inserted
ADMIT_TYPE_CD DOUBLE N Admit type indicates the circumstance under which the patient was admitted or will be admitted. (i.e., accident, emergent, routine, elective, labor/delivery, etc.)
ALC_DECOMP_DT_TM DATETIME Y Date and time the alternate level of care decompensation
ALC_REASON_CD DOUBLE N Reason the alternate level of care is being assigned or changed
ALT_LVL_CARE_CD DOUBLE N Level of care for the encounter at the time the history row is written, that signals a difference, or alternative, to the care signified by the encntr_type, med service, location, or combination therein. Used primarily as a billing function to trigger a change in charging rates.
ALT_LVL_CARE_DT_TM DATETIME Y The date and time the alternate level of care was assigned
ARRIVE_DT_TM DATETIME Y The actual date/time that the patient arrived at the facility. At the time of registration, if this field is null then it should be valued with the reg_dt_tm. Otherwise, the actual arrival date/time is captured.
ARRIVE_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the arrive_dt_tm.
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.
CHART_COMMENT_IND DOUBLE Y FUTURE USE.
COMMENT_TEXT VARCHAR(200) Y Textual column used to store free text information about the transaction which triggered the history row. For example, through a location transfer transaction, a description of the transfer can be captured.
DEPART_DT_TM DATETIME Y The actual date/time that the patient left from the facility. In many cases, this field may be null unless the user process requires capturing this data.
DEPART_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the depart_dt_tm.
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_LOC_HIST_ID DOUBLE N This is the value of the unique primary identifier of the encounter location history table. It is an internal system assigned number.
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type. Examples may include inpatient, outpatient, etc. For this table, it is the encounter type at the time the history row is written.
ENCNTR_TYPE_CLASS_CD DOUBLE N Encounter type class is used to categorize patients into more general groups than encounter type. (i.e., inpatient, outpatient, emergency, recurring outpatient). The values in this code set all have Cerner defined meanings.
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.
ISOLATION_CD DOUBLE N The isolation code indicates that some level of isolation or restricted access is required or in place for this patient indicating special procedure or consideration to be used when dealing with the patient.
LOCATION_CD DOUBLE N The field identifies the location of the patient/encounter at the time the history row is written. The location will be valued with the lowest available level location type in the hierarchy of facility, building, nurse unit, room, bed.
LOCATION_STATUS_CD DOUBLE N FUTURE USE
LOCATION_TEMP_IND DOUBLE Y NOT USED. Set to TRUE if the location value in the location_cd field is a location with a location type of temporary.
LOC_BED_CD DOUBLE N This field is the patient location with a location type of bed at the time the history row is written.
LOC_BUILDING_CD DOUBLE N This field is the patient location with a location type of building at the time the history row is written.
LOC_FACILITY_CD DOUBLE N This field is the patient location with a location type of facility at the time the history row is written.
LOC_NURSE_UNIT_CD DOUBLE N This field is the patient location with a location type of nurse unit at the time the history row is written.
LOC_ROOM_CD DOUBLE N This field is the patient location with a location type of room at the time the history row is written.
MED_SERVICE_CD DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter at the time the history row is written. The category may be of treatment type, surgery, general resources, or others.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. This column is either valued with the facility or the client organization for the encounter.
PLACEMENT_AUTH_PRSNL_ID DOUBLE N The id of the personnel who authorized the override of a patient placement into a location that had a "stop" attribute associated to it.
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.
PROGRAM_SERVICE_CD DOUBLE N The program service associated with the location of the patient
SECURITY_ACCESS_CD DOUBLE N Security Access Code value.
SERVICE_CATEGORY_CD DOUBLE N Codified field which identifies the current category of service the patient is receiving for this encounter.
SPECIALTY_UNIT_CD DOUBLE N The specialty associated with a program service
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME Y Date and time the transaction, which triggered the history row, occurred. This field can be system assigned or manually manipulated by users.
TRANSFER_REASON_CD DOUBLE N Identifies the reason the person was transferred or moved from one location to another.
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_LOC_HIST


Child Column in ENCNTR_LOC_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LOCATION_CD LOCATION LOCATION_CD
LOC_BED_CD LOCATION LOCATION_CD
LOC_BUILDING_CD LOCATION LOCATION_CD
LOC_FACILITY_CD LOCATION LOCATION_CD
LOC_NURSE_UNIT_CD LOCATION LOCATION_CD
LOC_ROOM_CD LOCATION LOCATION_CD
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
ARRIVE_PRSNL_ID PRSNL PERSON_ID
DEPART_PRSNL_ID PRSNL PERSON_ID
PLACEMENT_AUTH_PRSNL_ID PRSNL PERSON_ID




Parent Column in ENCNTR_LOC_HIST (PK) Child Table Name Child Column Name
Children: ENCNTR_LOC_HIST_ID AOAV_ENCNTR_LOC_HIST ENCNTR_LOC_HIST_ID
LH_CNT_IC_ADV_EVENT_LOC ENCNTR_LOC_HIST_ID


ENCNTR_MEDICARE_MGMT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Meidicare Management
Definition: Stores information to help with managing the Medicare health plan.
Table Type: ACTIVITY





Column Detail - ENCNTR_MEDICARE_MGMT


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.
AVAILABLE_DAYS DOUBLE Y The date and time at which the number of available days was verified.
AVAILABLE_DAYS_VERIFY_DT_TM DATETIME Y The date and time at which the number of available days was verified.
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_MEDICARE_MGMT_ID DOUBLE N Unique generated number that identifies a single row on the encntr_medicare_mgmt table.
IN_RESIDENCE_DAYS DOUBLE Y The total number of individual days that qualified as being in residence, and does not include future or planned days.
REMAINING_COVERED_DAYS DOUBLE Y The number of covered days remaining for Medicare in the current benefit period as of the current date.
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_MEDICARE_MGMT


Child Column in ENCNTR_MEDICARE_MGMT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in ENCNTR_MEDICARE_MGMT (PK) Child Table Name Child Column Name
Children: ENCNTR_MEDICARE_MGMT_ID ENCNTR_MEDICARE_MGMT_HIST ENCNTR_MEDICARE_MGMT_ID