Table Detail Report

ENCNTR_ALIAS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: ENCNTR ALIAS HIST
Definition: Used for tracking history of changes to encntr aliases.
Table Type: ACTIVITY





Column Detail - ENCNTR_ALIAS_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.
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.
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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
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_HIST_ID DOUBLE N Unique identifier for the Encntr_Alias_Hist table.
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_TYPE_CD DOUBLE N Identifies a kind or type of alias (i.e., financial number, encounter, 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.
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 More aptly named activity_dt_tm; holds the current date and time of the system when the row was inserted. This will match the create_dt_tm from the corresponding pm_hist_tracking row.
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_ALIAS_HIST


Child Column in ENCNTR_ALIAS_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ALIAS_ID ENCNTR_ALIAS ENCNTR_ALIAS_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


ENCNTR_AMBULANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Ambulance
Definition: Stores information about the ambulance associated to the encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_AMBULANCE


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.
COMPANY_NAME VARCHAR(100) Y The name of the ambulance company.
ENCNTR_AMBULANCE_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_AMBULANCE table.
ENCNTR_ID DOUBLE N The value of the primary identifier of the parent table to which the encounter's ambulance row is related.
HOME_REGION_CD DOUBLE N The information describing the geographical area typically served by the ambulance.
SERVICE_NUMBER_IDENT VARCHAR(100) Y The service number related to the ambulance visit.
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_AMBULANCE


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




Parent Column in ENCNTR_AMBULANCE (PK) Child Table Name Child Column Name
Children: ENCNTR_AMBULANCE_ID ENCNTR_AMBULANCE_HIST ENCNTR_AMBULANCE_ID


ENCNTR_AMBULANCE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Ambulance History
Definition: Contains history from the ENCNTR_AMBULANCE table.
Table Type: ACTIVITY





Column Detail - ENCNTR_AMBULANCE_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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
COMPANY_NAME VARCHAR(100) Y The name of the ambulance company.
ENCNTR_AMBULANCE_HIST_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_AMULANCE_HIST table.
ENCNTR_AMBULANCE_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_AMBULANCE table.
HOME_REGION_CD DOUBLE N The information describing the geographical area typically served by the ambulance.
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.
SERVICE_NUMBER_IDENT VARCHAR(100) Y The service number related to the ambulance visit.
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_AMBULANCE_HIST


Child Column in ENCNTR_AMBULANCE_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_AMBULANCE_ID ENCNTR_AMBULANCE ENCNTR_AMBULANCE_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


ENCNTR_APPEAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter appeal
Definition: The insurance appeal for an encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_APPEAL


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.
ADVISOR_PRSNL_ID DOUBLE N Uniquely identifies the advisor.
APPEAL_COMM_TYPE_CD DOUBLE N The type of communication used to send the appeal.
APPEAL_EXPECT_RESP_DT_TM DATETIME Y The date and time of when a response is expected for the appeal.
APPEAL_LEVEL_CD DOUBLE N The appeal level for the appeal.
APPEAL_OUTCOME_CD DOUBLE N The final outcome of the appeal.
APPEAL_OUTCOME_DT_TM DATETIME Y The date and time the final outcome was reached for the appeal.
APPEAL_PRSNL_ID DOUBLE N Unique generated number that identifies a single row on the Prsnl table for the personnel in charge of the appeal.
APPEAL_SENT_DT_TM DATETIME Y The date and time the appeal was sent.
APPEAL_STATUS_CD DOUBLE N The appeal status for the appeal.
APPEAL_VERIFIED_DT_TM DATETIME Y The date and time the appeal was verified.
COMMENT_LONG_TEXT_ID DOUBLE N Unique generated number that identifies a single row on the Long_text table that represents a comment for this relationship.
ENCNTR_APPEAL_ID DOUBLE N Unique generated number that identifies a single row on the Encntr_appeal table.
ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the Encounter table related to the appeal.
EXT_APPEAL_AGENCY_CD DOUBLE N The external appeal agency handling the appeal.
PAYER_ORG_ID DOUBLE N Unique generated number that identifies a single row on the Organization table for the payer of the appeal.
POST_APPEAL_LEVEL_OF_CARE_CD DOUBLE N The post-appeal level of care that was approved for encounter.
PRE_APPEAL_LEVEL_OF_CARE_CD DOUBLE N The pre-appeal level of care that was approved for encounter.
PROVIDED_LEVEL_OF_CARE_CD DOUBLE N The provided level of care that is being appealed for the encounter.
TRACKING_NBR_TEXT VARCHAR(255) Y The tracking number for the appeal communication.
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_APPEAL


Child Column in ENCNTR_APPEAL(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PAYER_ORG_ID ORGANIZATION ORGANIZATION_ID
ADVISOR_PRSNL_ID PRSNL PERSON_ID
APPEAL_PRSNL_ID PRSNL PERSON_ID




Parent Column in ENCNTR_APPEAL (PK) Child Table Name Child Column Name
Children: ENCNTR_APPEAL_ID ENCNTR_DENIAL_APPEAL_RELTN ENCNTR_APPEAL_ID


ENCNTR_AUGM_CARE_PERIOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Augmented Care Period
Definition: Represents augmeneted care periods within an encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_AUGM_CARE_PERIOD


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 encounter's disposition of their 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.
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.
ENCNTR_AUGM_CARE_PERIOD_ID DOUBLE N Unique identifier for this table.
ENCNTR_ID DOUBLE N The identifier of the encounter for the augmented care period.
ENCNTR_SLICE_ID DOUBLE N Identifies an Encounter as it relates to a time slice.
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.
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 OBSOLETE - This column no longer used.
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_AUGM_CARE_PERIOD


Child Column in ENCNTR_AUGM_CARE_PERIOD(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_SLICE_ID ENCNTR_SLICE ENCNTR_SLICE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in ENCNTR_AUGM_CARE_PERIOD (PK) Child Table Name Child Column Name
Children: ENCNTR_AUGM_CARE_PERIOD_ID ENCNTR_ACP_HIST ENCNTR_AUGM_CARE_PERIOD_ID