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 |