Table Detail Report

SHR_F_ENCOUNTER_VISIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Shared Fact Encounter Visit
Definition: This table contains data related to an encounter visit.
Table Type: ACTIVITY





Column Detail - SHR_F_ENCOUNTER_VISIT


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N A number representing the activity date. References the key in the OMF_DATE table.
ADMIT_DT_NBR DOUBLE N A number representing the admit date. References the key in the OMF_DATE table.
DISCHARGE_DT_NBR DOUBLE N A number representing the discharge date. References the key in the OMF_DATE table.
FINAL_CODED_DT_NBR DOUBLE N A number representing the final coded date. References the key in the OMF_DATE table.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
INS_VERIFIED_DT_NBR DOUBLE N A number representing the date the insurance was verified. References the key in the OMF_DATE table.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MILL_ENCOUNTER_ID DOUBLE N Uniquely identifies the Millennium Encounter record that relates to this fact row.
PRE_REG_DT_NBR DOUBLE N A number representing the dateof the pre registration. References the key in the OMF_DATE table.
RC_AF_PATIENT_AR_BALANCE_ID DOUBLE N Uniquely relates information on the Patient AR Balance information to this fact row.
RC_D_ACCOMMODATION_ID DOUBLE N Uniquely identifies accommodation information related to this fact row.
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies encounter type class information related to this fact row.
RC_D_FINANCIAL_CLASS_ID DOUBLE N Uniquely identifies financial class information related to this fact record.
RC_D_MEDICAL_SERVICE_ID DOUBLE N Uniquely identifies medical service information related to this fact row.
RC_D_PRI_HEALTH_PLAN_ID DOUBLE N Uniquely identifies information about the primary health plan related to this fact row.
SHR_D_ATTENDING_PHYSICIAN_ID DOUBLE N Uniquely identifies the attending physician related to this fact row.
SHR_D_LOCATION_ID DOUBLE N Uniquely identifies location information related to this fact row.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies person information related to this fact row.
SHR_D_VERIFY_PRSNL_ID DOUBLE N Uniquely identifies information about the verifying person for this fact row.
SHR_F_ENCOUNTER_VISIT_ID DOUBLE N Uniquely Identifies information related to an encounter visit.
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 - SHR_F_ENCOUNTER_VISIT


Child Column in SHR_F_ENCOUNTER_VISIT(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
ADMIT_DT_NBR OMF_DATE DT_NBR
DISCHARGE_DT_NBR OMF_DATE DT_NBR
FINAL_CODED_DT_NBR OMF_DATE DT_NBR
INS_VERIFIED_DT_NBR OMF_DATE DT_NBR
PRE_REG_DT_NBR OMF_DATE DT_NBR
RC_AF_PATIENT_AR_BALANCE_ID RC_AF_PATIENT_AR_BALANCE RC_AF_PATIENT_AR_BALANCE_ID
RC_D_ACCOMMODATION_ID RC_D_ACCOMMODATION RC_D_ACCOMMODATION_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_FINANCIAL_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_PRI_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_MEDICAL_SERVICE_ID RC_D_MEDICAL_SERVICE RC_D_MEDICAL_SERVICE_ID
SHR_D_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_ATTENDING_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_VERIFY_PRSNL_ID SHR_D_PERSON SHR_D_PERSON_ID


SHR_LONG_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Shared Long Text
Definition: This table is used to store long text informaiton
Table Type: ACTIVITY





Column Detail - SHR_LONG_TEXT


Column Name Type Null? Definition
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 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.
LONG_TEXT LONGTEXT Y Contains the actual long text.
LONG_TEXT_HASH_CODE DOUBLE N Stores the hash code value of corresponding long_text column. Used to uniquely identify rows as long_text column cannot be used (long data type)
LONG_TEXT_MD5_HASH_TXT VARCHAR(32) Y A text field which stores the MD5 hash code value of corresponding LONG_TEXT column. Used to uniquely identify distinct LONG_TEXT values.
PARENT_ENTITY_ID DOUBLE N Contains the unique identifier related to the parent entity table.
PARENT_ENTITY_NAME VARCHAR(32) N Uniquely identifies the parent table related to this row.
SHR_LONG_TEXT_ID DOUBLE N Uniquely identifies long text data.
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 - SHR_LONG_TEXT




Parent Column in SHR_LONG_TEXT (PK) Child Table Name Child Column Name
Children: SHR_LONG_TEXT_ID RC_CLN_AREA SHR_LONG_TEXT_ID