CRIMINAL_CHARGES_DISP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Criminal Charges Disposition Relation
Definition: The associated court disposition for a criminal charge of an encounter.
Table Type: ACTIVITY





Column Detail - CRIMINAL_CHARGES_DISP_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.
COURT_DISPOSITION_CD DOUBLE N The court's disposition for a criminal charge
CRIMINAL_CHARGES_DISP_R_ID DOUBLE N Identifies the related associated court disposition for a criminal charge of an encounter.
OUTSTANDING_CHARGES_R_ID DOUBLE N Identifies the associated charge(s) related to an Encounter.
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 - CRIMINAL_CHARGES_DISP_R


Child Column in CRIMINAL_CHARGES_DISP_R(FK) Parent Table Name Parent Column Name
Parents: OUTSTANDING_CHARGES_R_ID ENCNTR_CRIMINAL_CHARGES_R OUTSTANDING_CHARGES_R_ID




Parent Column in CRIMINAL_CHARGES_DISP_R (PK) Child Table Name Child Column Name
Children: CRIMINAL_CHARGES_DISP_R_ID CRIMINAL_CHRGS_DISP_HIST CRIMINAL_CHARGES_DISP_R_ID


CRIMINAL_CHRGS_DISP_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Criminal Charges Disposition History
Definition: Transactional history of the associated court disposition for a criminal charge of an encounter.
Table Type: ACTIVITY





Column Detail - CRIMINAL_CHRGS_DISP_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.
COURT_DISPOSITION_CD DOUBLE N The court's disposition for a criminal charge
CRIMINAL_CHARGES_DISP_R_ID DOUBLE N Identifies the related associated court disposition for a criminal charge of an encounter.
CRIMINAL_CHRGS_DISP_HIST_ID DOUBLE N Identifies transactional history of an associated court disposition for a criminal charge of an encounter.
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.
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 - CRIMINAL_CHRGS_DISP_HIST


Child Column in CRIMINAL_CHRGS_DISP_HIST(FK) Parent Table Name Parent Column Name
Parents: CRIMINAL_CHARGES_DISP_R_ID CRIMINAL_CHARGES_DISP_R CRIMINAL_CHARGES_DISP_R_ID


ENCNTR_ACCIDENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Accident
Definition: The encounter accident table contains accident information related to a specific encounter. If necessary, there can be more than one encounter accident row for each encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_ACCIDENT


Column Name Type Null? Definition
ACCIDENT_CD DOUBLE N Identifies the type of accident (I.e., auto, work related, etc.)
ACCIDENT_DT_TM DATETIME Y The date and time the accident occurred.
ACCIDENT_LOCTN VARCHAR(100) Y The text description of the location where the accident occurred.
ACCIDENT_TEXT VARCHAR(255) Y A text field used to add additional information about the accident or persons involved.
ACC_COUNTRY_CD DOUBLE N The country where the accident occurred.
ACC_DEATH_CD DOUBLE N Defines how death was related to this encounter
ACC_EMPL_ORG_ID DOUBLE Y The organization id of the employer at the time of the accident
ACC_JOB_RELATED_CD DOUBLE N Describes how this accident was job related
ACC_STATE_CD DOUBLE N The country where the accident occurred.
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.
AMBULANCE_ARRIVE_CD DOUBLE Y Information regarding the arrival of the ambulance
AMBULANCE_GEO_CD DOUBLE Y Describes the geographic region the ambulance was from
AMBULANCE_SERV_NBR CHAR(20) Y The service number related to the ambulance visit
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.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
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_ACCIDENT_ID DOUBLE N This is the value of the unique primary identifier of the encounter accident table. It is an internal system assigned number.
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_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.
PLACE_CD DOUBLE N Place of the accident (ex. Client's or Patient's Home, Health Center, Hospice, Group Homeż etc.)
POLICE_BADGE_NBR CHAR(20) Y Badge Number of the officer involved with this encounter
POLICE_FORCE_CD DOUBLE Y Police force (department) that was involved with this encounter
POLICE_INVOLVE_CD DOUBLE Y Level of involvement the police had with this encounter
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_ACCIDENT


Child Column in ENCNTR_ACCIDENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ACC_EMPL_ORG_ID ORGANIZATION ORGANIZATION_ID


ENCNTR_ACP_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: ENCNTR ACP HIST
Definition: TRACKS THE HISTORY OF AUGMENTED CARE PERIODS WITHIN AN ENCOUNTER.
Table Type: ACTIVITY





Column Detail - ENCNTR_ACP_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.
AUGM_CARE_PERIOD_DISPOSAL_CD DOUBLE N The historical encounter's disposition of the respective augmented care period.
AUGM_CARE_PERIOD_PLAN_CD DOUBLE N An indication of whether any of an augmented care period was initiated as a planned event.
AUGM_CARE_PERIOD_SOURCE_CD DOUBLE N The source of the augmented care period.
AUGM_MEDICAL_SERVICE_CD DOUBLE N The type or category of medical service that the patient is receiving in relation to their augmented care period. The category may be of treatment type, surgery, general resources, or other.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
ENCNTR_ACP_HIST_ID DOUBLE N Primary Key for the ENCNTR_ACP_HIST table.
ENCNTR_AUGM_CARE_PERIOD_ID DOUBLE N FK from the encntr_augm_care_period table.
ENCNTR_ID DOUBLE N This column no longer used
HIGH_DEPEND_CARE_LVL_DAYS DOUBLE Y The number of days the patient received high dependency care within an augmented care period.
INTENSIVE_CARE_LVL_DAYS DOUBLE Y The number of days the patient received intensive care within an augmented care period.
NUM_ORGAN_SYS_SUPPORT_NBR DOUBLE Y The maximum number of organ systems supported during an augmented care period at any one time.
PERSON_ID DOUBLE N This column no longer used
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 Date and time the transaction, which triggered the history row, occurred. This field can be system assigned or manually manipulated by users.
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_ACP_HIST


Child Column in ENCNTR_ACP_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_AUGM_CARE_PERIOD_ID ENCNTR_AUGM_CARE_PERIOD ENCNTR_AUGM_CARE_PERIOD_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


ENCNTR_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Alias
Definition: The encounter alias table contains information used identify an encounter (i.e., financial number, requisition number, etc.). There can be many rows in the encounter alias table that are related to a single row in the encounter table.
Table Type: ACTIVITY





Column Detail - ENCNTR_ALIAS


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.
ALIAS VARCHAR(200) Y The alias is an identifier (I.e., financial number) for an encounter. The alias may be unique or non-unique depending on the type of alias.
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of encounter identifiers (I.e., numbers). The alias pool code also determines the accept/display format for the unique set of identifiers.
ASSIGN_AUTHORITY_SYS_CD DOUBLE Y This field identifies whether the ESI Server received a Person_Alias that was configured for Hold.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CHECK_DIGIT DOUBLE Y This is the value of the check digit calculated according to the check_digit_method_cd. If the check digit is stored as part of the alias number, which is typical, then the check digit field may be NULL.
CHECK_DIGIT_METHOD_CD DOUBLE N The check digit method code identifies a specific routine, using the alias field, to calculate a check digit.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
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_ALIAS_ID DOUBLE N This is the value of the unique primary identifier of the encounter alias table. It is an internal system assigned number.
ENCNTR_ALIAS_SUB_TYPE_CD DOUBLE N NOT USED
ENCNTR_ALIAS_TYPE_CD DOUBLE N Encounter alias type code identifies a kind or type of alias (i.e., Financial Number, Encounter Number, etc.). They are Cerner pre-defined meanings in the common data foundation table allowing HNA applications to look for a specific kind of alias.
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_EFFECTIVE_DT_TM DATETIME Y 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.
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_ALIAS




Parent Column in ENCNTR_ALIAS (PK) Child Table Name Child Column Name
Children: ENCNTR_ALIAS_ID ENCNTR_ALIAS_HIST ENCNTR_ALIAS_ID
FILL_PRINT_ORD_HX FINNBR_ID
FILL_PRINT_ORD_HX MEDREC_NBR_ID