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 |