Table Detail Report

OMF_COST_PARAMS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores parameters used by the OMF cost feed.
Definition: omf_cost_params
Table Type: REFERENCE





Column Detail - OMF_COST_PARAMS


Column Name Type Null? Definition
BEG_FISCAL_DT_NBR DOUBLE Y Stores the beginning fiscal date used to store standard costs.
COST_BASIS_TYPE_CD DOUBLE N The type of basis to use for costing (ex. Revenue Code, Cost Center).
ORGANIZATION_ID DOUBLE N The unique identifier of the organization for which the costing parameters apply.
SCHEDULE_TYPE_CD DOUBLE N The cdm schedule for the bill items that are loaded for the OMF cost feed.
TOTAL_ONLY_IND DOUBLE Y Indicates whether only one total cost will be used for each cost basis value OR all of the cost "buckets" will be used (1=use only one total cost, 0=use cost buckets).
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 - OMF_COST_PARAMS


Child Column in OMF_COST_PARAMS(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


OMF_DATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: omf_date
Definition: Denormalized table of temporal groupings for each day. Each record represents a day.
Table Type: REFERENCE





Column Detail - OMF_DATE


Column Name Type Null? Definition
DATE_STR VARCHAR(10) Y String representation of the date represented by dt_nbr. (YYYY-MM-DD)
DAY_OF_MONTH DOUBLE Y Day of month the date_nbr falls in. Possible values: (1..28, 1..29, 1..30, 1..31) depending on year, and month.
DAY_OF_WEEK DOUBLE Y Day of week the dt_nbr fall in. (0..6)
DAY_STR VARCHAR(25) Y Stores the internationalized string for the day of the week.
DT_NBR DOUBLE N Julian date representation of date.
LAST_DAY_OF_MONTH_IND DOUBLE Y Indicates the date represented by dt_nbr falls on the last day of the month
MONTH DOUBLE Y Numeric month represented by dt_nbr.
MONTH_STR VARCHAR(25) Y Stores the internationalized month of year string
MONTH_YEAR_STR VARCHAR(10) Y The concatenation of month-year.
NBR_DAYS_IN_MONTH DOUBLE Y The number of days in the particular month.
OMF_FISCAL_CALENDAR_ID DOUBLE N Unique identifier for the row on the omf_fiscal_calendar table.
OMF_HOLIDAY_ID DOUBLE N *** OBSOLETE ***
QUARTER DOUBLE Y Calendar quarter of year the date falls in. 1..4, every 91 days
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.
WEEKDAY_IND DOUBLE Y Indicates the date falls on a weekday.
YEAR DOUBLE Y Numeric year the day fall in.



Relationship Detail - OMF_DATE




Parent Column in OMF_DATE (PK) Child Table Name Child Column Name
Children: DT_NBR RC_F_ADJUSTMENT ACTIVITY_DT_NBR
RC_F_ADJUSTMENT ADMIT_DT_NBR
RC_F_ADJUSTMENT GL_ACTIVITY_DT_NBR
RC_F_ADJUSTMENT GL_CREATED_DT_NBR
RC_F_ADJUSTMENT GL_IMPACT_DT_NBR
RC_F_ADJUSTMENT INTERFACE_DT_NBR
RC_F_ADJUSTMENT POST_DT_NBR
RC_F_ALL_AR_SMRY ACTIVITY_DT_NBR
RC_F_BALANCE_AR ACTIVITY_DT_NBR
RC_F_BALANCE_AR ADMIT_DT_NBR
RC_F_BALANCE_AR DISCHARGE_DT_NBR
RC_F_BALANCE_AR LAST_ADJUSTMENT_DT_NBR
RC_F_BALANCE_AR LAST_BILL_SUBMISSION_DT_NBR
RC_F_BALANCE_AR LAST_BILL_TRANSMISSION_DT_NBR
RC_F_BALANCE_AR LAST_CHARGE_DT_NBR
RC_F_BALANCE_AR LAST_PAYMENT_DT_NBR
RC_F_BALANCE_AR REG_DT_NBR
RC_F_CASH ACTIVITY_DT_NBR
RC_F_CASH ADMIT_DT_NBR
RC_F_CASH GL_ACTIVITY_DT_NBR
RC_F_CASH GL_CREATED_DT_NBR
RC_F_CASH GL_IMPACT_DT_NBR
RC_F_CASH INTERFACE_DT_NBR
RC_F_CASH PAYMENT_METHOD_DT_NBR
RC_F_CASH POST_DT_NBR
RC_F_CLAIM_EVENT CLAIM_EVENT_DT_NBR
RC_F_DAILY_CDM_SMRY ACTIVITY_DT_NBR
RC_F_DAILY_CENSUS ACTIVITY_DT_NBR
RC_F_DAILY_CENSUS ADMISSION_DT_NBR
RC_F_DAILY_CENSUS DISCHARGE_DT_NBR
RC_F_DAILY_CENSUS_SMRY ACTIVITY_DT_NBR
RC_F_DAILY_CLAIM_EVENT_SMRY ACTIVITY_DT_NBR
RC_F_DAILY_DENIAL_SMRY ACTIVITY_DT_NBR
RC_F_DAILY_ENCNTR_VISIT_SMRY ACTIVITY_DT_NBR
RC_F_DAILY_TRANS_SMRY ACTIVITY_DT_NBR
RC_F_DAYS_IN_AR_SMRY ACTIVITY_DT_NBR
RC_F_DENIAL ADMIT_DT_NBR
RC_F_DENIAL DENIAL_DT_NBR
RC_F_DENIAL DISCHARGE_DT_NBR
RC_F_DLY_CHRG_ASSOC_SMRY SERVICE_DT_NBR
RC_F_DLY_CODING_ACT_SMRY ACTIVITY_DT_NBR
RC_F_GENERAL_AR_BALANCE ACTIVITY_DT_NBR
RC_F_GENERAL_AR_BALANCE BEGIN_DT_NBR
RC_F_GENERAL_AR_BALANCE END_DT_NBR
RC_F_GENERAL_AR_BALANCE LAST_ADJUSTMENT_DT_NBR
RC_F_GENERAL_AR_BALANCE LAST_PAYMENT_DT_NBR
RC_F_GENERAL_AR_BAL_TRANS ACTIVITY_DT_NBR
RC_F_GENERAL_AR_BAL_TRANS POST_DT_NBR
RC_F_INVOICE_AR_BALANCE ACTIVITY_DT_NBR
RC_F_INVOICE_AR_BALANCE DISCHARGE_DT_NBR
RC_F_INVOICE_AR_BALANCE INVOICE_GENERATION_DT_NBR
RC_F_INVOICE_AR_BALANCE INVOICE_LAST_ADJUSTMENT_DT_NBR
RC_F_INVOICE_AR_BALANCE INVOICE_LAST_PAYMENT_DT_NBR
RC_F_INVOICE_AR_BALANCE INVOICE_SUBMISSION_DT_NBR
RC_F_INVOICE_AR_BALANCE INVOICE_TRANSMISSION_DT_NBR
RC_F_INVOICE_AR_BALANCE LAST_ADJUSTMENT_DT_NBR
RC_F_INVOICE_AR_BALANCE LAST_CHARGE_DT_NBR
RC_F_INVOICE_AR_BALANCE LAST_PAYMENT_DT_NBR
RC_F_INVOICE_AR_BAL_INV ACTIVITY_DT_NBR
RC_F_INVOICE_AR_BAL_INV GENERATION_DT_NBR
RC_F_INVOICE_AR_BAL_INV LAST_ADJUSTMENT_DT_NBR
RC_F_INVOICE_AR_BAL_INV LAST_PAYMENT_DT_NBR
RC_F_INVOICE_AR_BAL_INV SUBMISSION_DT_NBR
RC_F_INVOICE_AR_BAL_INV TRANSMISSION_DT_NBR
RC_F_INVOICE_AR_BAL_SMRY BEGIN_DT_NBR
RC_F_INVOICE_AR_BAL_SMRY END_DT_NBR
RC_F_INVOICE_AR_BAL_SMRY LAST_INVOICE_ADJUSTMENT_DT_NBR
RC_F_INVOICE_AR_BAL_SMRY LAST_INVOICE_DT_NBR
RC_F_INVOICE_AR_BAL_SMRY LAST_INVOICE_PAYMENT_DT_NBR
RC_F_NON_AR_BALANCE BEGIN_DT_NBR
RC_F_NON_AR_BALANCE END_DT_NBR
RC_F_NON_AR_BALANCE_TRANS ACTIVITY_DT_NBR
RC_F_NON_AR_BALANCE_TRANS POST_DT_NBR
RC_F_PATIENT_AR_BALANCE ACTIVITY_DT_NBR
RC_F_PATIENT_AR_BALANCE ADMIT_DT_NBR
RC_F_PATIENT_AR_BALANCE DISCHARGE_DT_NBR
RC_F_PATIENT_AR_BALANCE FINAL_CODED_DT_NBR
RC_F_PATIENT_AR_BALANCE LAST_PAYMENT_DT_NBR
RC_F_PATIENT_AR_BALANCE ZERO_BAL_DT_NBR
RC_F_PATIENT_AR_BAL_SMRY ACTIVITY_DT_NBR
RC_F_REVENUE ACTIVITY_DT_NBR
RC_F_REVENUE ADMIT_DT_NBR
RC_F_REVENUE DISCHARGE_DT_NBR
RC_F_REVENUE GL_ACTIVITY_DT_NBR
RC_F_REVENUE GL_CREATED_DT_NBR
RC_F_REVENUE GL_IMPACT_DT_NBR
RC_F_REVENUE GL_INTERFACE_DT_NBR
RC_F_REVENUE SERVICE_DT_NBR
RC_F_VARIANCE ACTIVITY_DT_NBR
RC_F_VARIANCE ADJUSTED_VARIANCE_DT_NBR
RC_F_VARIANCE ADMIT_DT_NBR
RC_F_VARIANCE CLAIM_TRANSMIT_DT_NBR
RC_F_VARIANCE DISCHARGE_DT_NBR
RC_F_VARIANCE LAST_PAYMENT_DT_NBR
RC_F_VARIANCE LAST_VAR_ACTIVITY_DT_NBR
RC_F_VARIANCE ORIG_VARIANCE_DT_NBR
RC_F_VAR_CLAIM_SMRY ACTIVITY_DT_NBR
RC_F_VAR_CLAIM_SMRY ADJUSTED_VARIANCE_DT_NBR
RC_F_VAR_CLAIM_SMRY ADMIT_DT_NBR
RC_F_VAR_CLAIM_SMRY DISCHARGE_DT_NBR
RC_F_VAR_CLAIM_SMRY LAST_APPEAL_DT_NBR
RC_F_VAR_CLAIM_SMRY LAST_VAR_ACTIVITY_DT_NBR
RC_F_VAR_CLAIM_SMRY ORIG_VARIANCE_DT_NBR
RC_F_VAR_LINE_ITEM_SMRY ACTIVITY_DT_NBR
RC_F_VAR_LINE_ITEM_SMRY ADJUSTED_VARIANCE_DT_NBR
RC_F_VAR_LINE_ITEM_SMRY ADMIT_DT_NBR
RC_F_VAR_LINE_ITEM_SMRY DISCHARGE_DT_NBR
RC_F_VAR_LINE_ITEM_SMRY LAST_APPEAL_DT_NBR
RC_F_VAR_LINE_ITEM_SMRY LAST_VAR_ACTIVITY_DT_NBR
RC_F_VAR_LINE_ITEM_SMRY ORIG_VARIANCE_DT_NBR
SHR_F_ENCOUNTER_VISIT ACTIVITY_DT_NBR
SHR_F_ENCOUNTER_VISIT ADMIT_DT_NBR
SHR_F_ENCOUNTER_VISIT DISCHARGE_DT_NBR
SHR_F_ENCOUNTER_VISIT FINAL_CODED_DT_NBR
SHR_F_ENCOUNTER_VISIT INS_VERIFIED_DT_NBR
SHR_F_ENCOUNTER_VISIT PRE_REG_DT_NBR
WHC_F_CHILD CHILD_BIRTH_DATE_NBR
WHC_F_CHILD NEONATE_ADMISSION_DATE_NBR
WHC_F_CHILD NEONATE_DISCHARGE_DATE_NBR
WHC_F_CHILD SKIN_SKIN_CONTCT_INT_DATE_NBR
WHC_F_DELIVERY CMPLT_CERV_DIALTN_DATE_NBR
WHC_F_DELIVERY EPIDURAL_BOLUS_ANES_DATE_NBR
WHC_F_DELIVERY EPIDURAL_BOLUS_PATNT_DATE_NBR
WHC_F_DELIVERY EPIDURAL_DISCONTINUED_DATE_NBR
WHC_F_DELIVERY EPIDURAL_START_DATE_NBR
WHC_F_DELIVERY EPIDURAL_TEST_DOSE_DATE_NBR
WHC_F_DELIVERY LABOR_ONSET_DATE_NBR
WHC_F_DELIVERY_CHILD DELIVERY_DATE_NBR
WHC_F_DELIVERY_CHILD PLACENTA_DELIVERY_DATE_NBR
WHC_F_DELIVERY_CHILD ROM_DATE_NBR
WHC_F_MOTHER_PREGNANCY ADMIT_DATE_NBR
WHC_F_MOTHER_PREGNANCY DISCHARGE_DATE_NBR
WHC_F_MOTHER_PREGNANCY ED_DATE_NBR
WHC_F_MOTHER_PREGNANCY PREGNANCY_CLOSE_DATE_NBR
WHC_F_MOTHER_PREGNANCY PREGNANCY_ONSET_DATE_NBR


OMF_DOWNTIME_Q



Column Section Top of Page


Table-level Detail

Description: Logs transactions during Care Profiling downtime (OCD installs).
Definition: Logs transactions during Care Profiling downtime.
Table Type: ACTIVITY





Column Detail - OMF_DOWNTIME_Q


Column Name Type Null? Definition
CHAR1 VARCHAR(255) Y Stores character data.
CHAR2 VARCHAR(255) Y Stores character data.
CHAR3 VARCHAR(255) Y Stores character data.
CHAR4 VARCHAR(255) Y Stores character data.
CHAR5 VARCHAR(255) Y Stores character data.
DATE1 DATETIME Y Stores dates.
DATE2 DATETIME Y Stores dates.
DATE3 DATETIME Y Stores dates.
DATE4 DATETIME Y Stores dates.
DATE5 DATETIME Y Stores dates.
NUM1_ID DOUBLE N Stores a millennium identifier.
NUM2_ID DOUBLE N Stores a millennium identifier.
NUM3_ID DOUBLE N Stores a millennium identifier.
NUM4_ID DOUBLE N Stores a millennium identifier.
NUM5_ID DOUBLE N Stores a millennium identifier.
PROCESS_FLAG DOUBLE Y Indicates whether or not the data has been processed by omf_downtime_load.
Q_ID DOUBLE N The unique identifier for the table.
REQUEST DOUBLE N The calling request that is responsible for populating the table.
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.


OMF_ENCNTR_PRSNL_RELTN_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF ENCNTR PRSNL RELTN ST
Definition: Summary table storing the relationships between encounter records and physicians
Table Type: ACTIVITY





Column Detail - OMF_ENCNTR_PRSNL_RELTN_ST


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_NBR DOUBLE Y The beginning effective date for the row.
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.
BEG_EFFECTIVE_MIN_NBR DOUBLE Y The beginning effective minute for the row
BEG_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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_PRSNL_RELTN_ID DOUBLE N The unique identifier for the table (from the encntr_prsnl_reltn table).
ENCNTR_PRSNL_R_CD DOUBLE N The code value for the relation between the encounter and the physician.
END_EFFECTIVE_DT_NBR DOUBLE Y The end effective date for the row.
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.
END_EFFECTIVE_MIN_NBR DOUBLE Y The end effective minute for the row.
END_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PRIORITY_SEQ DOUBLE Y The sequence in which records are written to the table for a given encounter/relation combination.
PRSNL_PERSON_FT_NAME VARCHAR(100) Y The free text name for the physician.
PRSNL_PERSON_GRP_CD DOUBLE N The grouping code for the physician as defined through the OMFGroupingTool.
PRSNL_PERSON_ID DOUBLE N The unique identifier for the person.
PRSNL_PERSON_KEY VARCHAR(125) Y The concatenation of the person_id and free text name for uniqueness within PowerVision.
PRSNL_PERSON_MED_SPEC_CD DOUBLE N The medical specialty code for the physician as defined through the OMFGroupingTool.
PRSNL_PERSON_POSITION_CD DOUBLE N The Cerner-defined position for the prsnl related to the 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 - OMF_ENCNTR_PRSNL_RELTN_ST


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


OMF_ENCNTR_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF ENCNTR ST
Definition: Prologue encounter level summary table.
Table Type: ACTIVITY





Column Detail - OMF_ENCNTR_ST


Column Name Type Null? Definition
ACCOMMODATION_CD DOUBLE N Accommodation code value
ADMIT_15D_LADMIT_IND DOUBLE Y Indicator identifying whether or not the patient had been readmitted within 15 days
ADMIT_24H_LADMIT_IND DOUBLE Y Indicator defining whether or not the patient was admitted w/in 24 hours of the last inpatient discharge.
ADMIT_30D_LADMIT_IND DOUBLE Y Indicator identifying whether or not the patient had been readmitted within 30 days
ADMIT_48D_LADMIT_IND DOUBLE Y Readmit count within 48 days. If the admission occurred within 48 days of the last inpatient discharge, the value in this column will be 1.
ADMIT_48H_LADMIT_IND DOUBLE Y Indicator defining whether or not the patient was admitted w/in 48 hours of the last inpatient discharge.
ADMIT_7D_LADMIT_IND DOUBLE Y Indicator identifying whether or not the patient had been readmitted within 7 days
ADMIT_DATE VARCHAR(25) Y The date that the patient was admitted
ADMIT_DAY DOUBLE Y The day of the week that the patient was admitted
ADMIT_DT_NBR DOUBLE Y The Cerner internal system date representation of the day the person was admitted.
ADMIT_DT_TM DATETIME Y The date/time that the patient was admitted
ADMIT_HOUR DOUBLE Y The hour of the day that the patient was admitted
ADMIT_IND DOUBLE Y Indicator identifying whether or not the patient was admitted to the facility
ADMIT_MIN_NBR DOUBLE Y The minute of day the person was admitted (1..1440).
ADMIT_MONTH DOUBLE Y The month that the patient was admitted
ADMIT_PAT_LOC_BDG_CD DOUBLE N The building to which the patient was admitted
ADMIT_PAT_LOC_BED_CD DOUBLE N The bed to which the patient was admitted
ADMIT_PAT_LOC_FAC_CD DOUBLE N The facility to which the patient was admitted
ADMIT_PAT_LOC_NU_CD DOUBLE N The nurse unit to which the patient was admitted
ADMIT_PAT_LOC_ROOM_CD DOUBLE N The room to which the patient was admitted
ADMIT_PHYS_FT_NAME VARCHAR(255) Y The free test name identifying the physician that admitted the patient
ADMIT_PHYS_GRP_CD DOUBLE N The client defined grouping to which the admitting physician belongs
ADMIT_PHYS_ID DOUBLE N Unique identification number of the physician that admitted the patient
ADMIT_PHYS_KEY VARCHAR(255) Y Unique identification number of the physician that admitted the patient (when the physician is free text)
ADMIT_PHYS_MED_SPEC_CD DOUBLE N The medical specialty for the admitting physician as defined within the OMF Grouping Tool.
ADMIT_PHYS_POSITION_CD DOUBLE N The Cerner-defined position for the admitting physician.
ADMIT_SHIFT_GRP_CD DOUBLE N The grouping code for the admit shift group as defined in the OMF Grouping Tool
ADMIT_SRC_CD DOUBLE N Identifies the place from which the patient came before admission
ADMIT_TYPE_CD DOUBLE N Identifies the circumstances under which the patient was admitted
AGE_DAYS DOUBLE Y The age of the patient in days
AGE_DAYS_GRP_CD DOUBLE N The grouping code for the age in days as defined in the OMF Grouping Tool
AGE_YEARS DOUBLE Y The age of the patient in years
AGE_YEARS_GRP_CD DOUBLE N The client defined grouping for which the patient's age in years qualifies
AMBULATORY_COND_CD DOUBLE N Describes the general physical condition, impairment, or limitation of the patient upon arrival
ANESTHESIOLOGIST_FT_NAME VARCHAR(255) Y The free text name for the anesthesiologist.
ANESTHESIOLOGIST_ID DOUBLE N The unique identifier for the anesthesiologist.
ANESTHESIOLOGIST_KEY VARCHAR(255) Y The combination of the free text name of unique id for the anesthesiologist.
ANESTH_POSITION_CD DOUBLE N The position of the anesthesiologist.
APRDRG_LOS DOUBLE Y The LOS assigned to the APR DRG.
APRDRG_MDC_CD DOUBLE N The code values for Major Diagnosis Code for 3M's APR-DRG codes.
APRDRG_NOMEN_ID DOUBLE N The unique identifier assigned to the aprdrg code.
APRDRG_ROM DOUBLE Y The APRDRG Risk of Mortality
APRDRG_ROM_CD DOUBLE N This is the code_value for risk of mortality
APRDRG_SOI DOUBLE Y The APRDRG Severity of Illness
APRDRG_SOI_CD DOUBLE N The code value referring to the severity of illness for the aprdrg
ATTEND_PHYS_POSITION_CD DOUBLE N The Cerner-defined position for the attending physician.
ATT_PHYS_FT_NAME VARCHAR(255) Y The free text name identifying the attending physician
ATT_PHYS_GRP_CD DOUBLE N The client defined grouping to which the admitting physician belongs
ATT_PHYS_ID DOUBLE N Unique identification number of the attending physician
ATT_PHYS_KEY VARCHAR(255) Y Unique identification number of the attending physician (when the physician is free text)
ATT_PHYS_MED_SPEC_CD DOUBLE N The medical specialty for the attending physician as defined within the OMF Grouping Tool.
BIRTH_DATE VARCHAR(25) Y The date on which the patient was born
BIRTH_DT_TM DATETIME Y The date/time on which the patient was born
CMG_NOMEN_ID DOUBLE N Unique identification number for the CMG code associated with the patient visit
COORDINATION_OF_BENEFITS_CD DOUBLE N Insurance coordination of benefits
CPT4_PROC_STR VARCHAR(255) Y Listing of CPT4 procedure codes associated with the patient visit
CURR_PAT_LOC_ARRIVE_DT_TM DATETIME Y The date/time at which the patient arrived at the nurse unit.
CURR_PAT_LOC_BDG_CD DOUBLE N The building in which the patient was located at the time of the transaction
CURR_PAT_LOC_BED_CD DOUBLE N The bed in which the patient was located at the time of the transaction
CURR_PAT_LOC_FAC_CD DOUBLE N The facility in which the patient was located at the time of the transaction
CURR_PAT_LOC_FAC_GRP_CD DOUBLE N The client defined grouping to which the facility belongs
CURR_PAT_LOC_NU_CD DOUBLE N The nurse unit in which the patient was located at the time of the transaction
CURR_PAT_LOC_NU_GRP2_CD DOUBLE N Second nurse unit grouping defined within the OMF Grouping Tool.
CURR_PAT_LOC_NU_GRP_CD DOUBLE N The client defined grouping to which the nurse unit belongs
CURR_PAT_LOC_ROOM_CD DOUBLE N The room in which the patient was located at the time of the transaction
DEATH_24H_ADMIT_IND DOUBLE Y Indicator identifying whether or not the patient expired within 24 hours of admission
DEATH_24H_PRIN_PROC_IND DOUBLE Y Indicator identifying whether or not the patient expired within 24 hours of having the ICD9 principal procedure performed
DEATH_24H_VISIT_IND DOUBLE Y Indicator identifying whether or not the patient expired within 24 hours of the start of the visit
DEATH_DATE VARCHAR(25) Y The date that the patient expired
DEATH_DT_NBR DOUBLE Y The Cerner internal system date representation of the day the person expired.
DEATH_DT_TM DATETIME Y The date/time that the patient expired
DEATH_IND DOUBLE Y Indicator identifying whether or not the patient has expired during the current encounter
DEATH_MIN_NBR DOUBLE Y The minute of day the person expired (1..1440).
DISCH_DATE VARCHAR(25) Y The date that the patient was discharged
DISCH_DAY DOUBLE Y The day of the week that the patient was discharged
DISCH_DISPOSITION_CD DOUBLE N The conditions under which the patient left the facility at the time of discharge
DISCH_DT_NBR DOUBLE Y The Cerner internal system date representation of the day the person was discharged.
DISCH_DT_TM DATETIME Y The date/time that the patient was discharged
DISCH_HOUR DOUBLE Y The hour of the day that the patient was discharged
DISCH_IND DOUBLE Y Indicator identifying whether or not the patient has been discharged
DISCH_MIN_NBR DOUBLE Y The minute of day the person was discharged (1..1440).
DISCH_MONTH DOUBLE Y The month that the patient was discharged
DISCH_SHIFT_GRP_CD DOUBLE N The grouping code for the discharge shift group as defined in the OMF Grouping Tool
DISCH_TO_LOCTN_CD DOUBLE N The location to which the patient was discharged
DPG_NOMEN_ID DOUBLE N Unique identification number for the DPG code associated with the patient visit
DRG_AMLOS DOUBLE Y The arithmetic mean length of stay assigned to the DRG.
DRG_ELOS DOUBLE Y The expected length of stay based on the encounter/drg.
DRG_GMLOS DOUBLE Y The geometric mean length of stay associated with the DRG.
DRG_GRP2_CD DOUBLE N Second grouping of DRGs (primarily used to report on DRG pairs)
DRG_GRP_CD DOUBLE N The client defined grouping to which the drg code belongs
DRG_NOMEN_ID DOUBLE N Unique identification number for the DRG code associated with the patient visit
DRG_WEIGHT DOUBLE Y The weight of the diagnostic related group determines the amount of reimbursement entitled to the organization.
EMP_ORGANIZATION_ID DOUBLE N The organization_id for the patient's employer.
ENCNTR_CLASS_CD DOUBLE N Encounter class defines how this row is being used in relation to the person table.
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_TYPE_CD DOUBLE N The code_value identifying the patient type
ENCNTR_TYPE_CLASS_CD DOUBLE N The code_value identifying the patient type grouping
EST_REIMBURSEMENT DOUBLE Y The estimated reimbursement for the encounter.
ETHNIC_GRP_CD DOUBLE N Identifies the cultural, religious, national , or racial group of the person
EXP_PM_DISCH_DT_NBR DOUBLE Y The expected discharge date based on the estimated depart date/time.
EXP_PM_DISCH_DT_TM DATETIME Y The expected discharge date/time based on the estimated depart date/time.
EXP_PM_DISCH_MIN_NBR DOUBLE Y The expected discharge time based on the estimated depart date/time.
FIN_CLASS_CD DOUBLE N Financial class code_value
ICD9_ADMIT_DIAG_NOMEN_ID DOUBLE N The ICD9 diagnosis code associated with the patient at the admission time
ICD9_PRIN_DIAG_GRP_CD DOUBLE N The client defined grouping to which the ICD9 principal diagnosis belongs
ICD9_PRIN_DIAG_NOMEN_ID DOUBLE N The ICD9 diagnosis code associated with the patient at admission time
ICD9_PRIN_PROC_DATE VARCHAR(25) Y The date that the ICD9 principal procedure was performed
ICD9_PRIN_PROC_DT_NBR DOUBLE Y The Cerner internal system date representation of the day the ICD9 principal procedure was performed.
ICD9_PRIN_PROC_DT_TM DATETIME Y The date/time that the ICD9 principal procedure was performed
ICD9_PRIN_PROC_GRP_CD DOUBLE N The client defined grouping to which the ICD9 principal procedure belongs
ICD9_PRIN_PROC_MINUTES DOUBLE Y The number of minutes that the ICD9 principal procedure took to perform
ICD9_PRIN_PROC_MIN_NBR DOUBLE Y The minute of day the ICD9 principal procedure was performed (1..1440).
ICD9_PRIN_PROC_NOMEN_ID DOUBLE N The ICD9 principal procedure code associated with the patient visit
ICD9_SECONDARY1_DIAG_NOMEN_ID DOUBLE N The first secondary ICD9 diagnosis code associated with the patient at admission time
ICD9_SEC_DIAG_STR VARCHAR(255) Y Listing of ICD9 secondary diagnosis codes associated with the patient visit
ICD9_SEC_PROC_STR VARCHAR(255) Y Listing of ICD9 secondary procedure codes associated with the patient visit
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.
LANGUAGE_CD DOUBLE N The code_value identifying the language of the patient
LAST_IP_DISCH_DT_NBR DOUBLE Y The Cerner internal system date representation of the day the person was last discharged.
LAST_IP_DISCH_DT_TM DATETIME Y The date/time that this patient was last discharged
LAST_IP_DISCH_MIN_NBR DOUBLE Y The minute of day the person was last discharged (1..1440).
MARITAL_STATUS_CD DOUBLE N The code_value identifying the marital status of the patient
MCC DOUBLE Y MCC number assigned by the encoder.
MCC_TEXT VARCHAR(255) Y MCC description assigned by the encoder.
MDC_CD DOUBLE N Major diagnostic category code
MED_SERV_CD DOUBLE N The category of treatment, surgery, or general resources
MED_SERV_GRP_CD DOUBLE N The client defined grouping to which the medical service belongs
MRD_NOMEN_ID DOUBLE N Most Responsible Diagnosis nomenclature id.
NBR_CONSULTS DOUBLE Y The number of consultations for the encounter.
NEXT_ENCNTR_ID DOUBLE N Encntr_id from the person's next visit.
NEXT_INP_ENCNTR_ID DOUBLE N Encntr_id from the person's next inpatient visit.
ONTARIO_CASE_WT DOUBLE Y Ontario Case Weight
ORGANIZATION_ID DOUBLE N The unique identifier for the organization.
OTHER_EMP_ORGANIZATION_ID DOUBLE N Other health plan employer/sponsor organization ID
OTHER_HEALTH_PLAN_GROUP_CD DOUBLE N The client defined grouping to which the other health plan belongs to.
OTHER_HEALTH_PLAN_ID DOUBLE N Other health plan ID
OTHER_INS_ASSIGN_BENEFITS_CD DOUBLE N Other insurance assignment of benefits
OTHER_INS_BEG_EFFECTIVE_DT_NBR DOUBLE Y The Cerner internal system date representation of the beginning effective day of the other health plan.
OTHER_INS_BEG_EFFECTIVE_DT_TM DATETIME Y The beginning effective DT/TM of the other health plan
OTHER_INS_BEG_EFFECTIVE_MN_NBR DOUBLE Y The beginning effective minute of day for the other health plan.
OTHER_INS_BIRTH_DT_TM DATETIME Y Other health plan subscriber's birth DT/TM
OTHER_INS_END_EFFECTIVE_DT_NBR DOUBLE Y The Cerner internal system date representation of the ending effective day of the other health plan.
OTHER_INS_END_EFFECTIVE_DT_TM DATETIME Y The ending effective DT/TM of the other health plan
OTHER_INS_END_EFFECTIVE_MN_NBR DOUBLE Y The ending effective minute of day for the other health plan.
OTHER_INS_GROUP_CD DOUBLE N The client defined grouping to which the other insurance company belongs to
OTHER_INS_ORGANIZATION_ID DOUBLE N Other insurance company organization ID
OTHER_INS_PERSON_ID DOUBLE N Other health plan subscriber's person ID
OTHER_INS_PERSON_RELTN_CD DOUBLE N Other health plan subscribers relationship to the person
OTHER_INS_PLAN_TYPE_CD DOUBLE N Other health plan type
OTHER_ORG_PLAN_RELTN_ID DOUBLE N Other Insurance Org Plan Reltn ID
PATIENT_STATUS_CD DOUBLE N Typical/Atypical patient status type code.
PCP_PHYS_FT_NAME VARCHAR(255) Y The free text name of the primary care physician.
PCP_PHYS_GRP_CD DOUBLE N The grouping assignment of the primary care physician.
PCP_PHYS_ID DOUBLE N The unique identification number for the primary care physician.
PCP_PHYS_KEY VARCHAR(255) Y The concatenation of the pcp_phys_id and the pcp_phys_ft_name used to create a unique identification number for PowerVision.
PCP_PHYS_MED_SPEC_CD DOUBLE N The medical specialty for the primary care physician as defined within the OMF Grouping Tool.
PCP_PHYS_POSITION_CD DOUBLE N The Cerner-defined position for the primary care physician.
PERSON_HOME_ZIPCODE_GRP_CD DOUBLE N Person's home zip code group (based on address.zipcode).
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PREV_ENCNTR_ID DOUBLE N Encntr_id from the person's previous visit.
PREV_INP_ENCNTR_ID DOUBLE N Encntr_id from the person's previous visit.
PREV_PAT_LOC_NU_CD DOUBLE N The previous nurse unit at which the patient was located.
PRIM_EMP_ORGANIZATION_ID DOUBLE N Primary health plan employer/sponsor organization ID
PRIM_HEALTH_PLAN_GROUP_CD DOUBLE N The client defined grouping to which the primary health plan belongs to.
PRIM_HEALTH_PLAN_ID DOUBLE N Primary health plan ID
PRIM_INS_ASSIGN_BENEFITS_CD DOUBLE N Primary insurance assignment of benefits
PRIM_INS_BEG_EFFECTIVE_DT_NBR DOUBLE Y The Cerner internal system date representation of the beginning effective day of the primary health plan.
PRIM_INS_BEG_EFFECTIVE_DT_TM DATETIME Y The beginning effective DT/TM of the primary health plan
PRIM_INS_BEG_EFFECTIVE_MIN_NBR DOUBLE Y The beginning effective minute of day for the primary health plan.
PRIM_INS_BIRTH_DT_TM DATETIME Y Primary health plan subscribers birth DT/TM
PRIM_INS_END_EFFECTIVE_DT_NBR DOUBLE Y The Cerner internal system date representation of the ending effective day of the primary health plan.
PRIM_INS_END_EFFECTIVE_DT_TM DATETIME Y The ending effective DT/TM of the primary health plan
PRIM_INS_END_EFFECTIVE_MIN_NBR DOUBLE Y The ending effective minute of day for the primary health plan.
PRIM_INS_GROUP_CD DOUBLE N The client defined grouping to which the primary insurance company belongs to
PRIM_INS_ORGANIZATION_ID DOUBLE N Primary insurance company organization ID
PRIM_INS_PERSON_ID DOUBLE N Primary health plan subscribers person ID
PRIM_INS_PERSON_RELTN_CD DOUBLE N Primary health plan subscribers relationship to the person
PRIM_INS_PLAN_TYPE_CD DOUBLE N Primary health plan type
PRIM_ORG_PLAN_RELTN_ID DOUBLE N Primary Insurance Org Plan Reltn ID
RACE_CD DOUBLE N The code_value identifying the race of the patient
READMIT_15D_30D_IND DOUBLE Y The patient was readmitted in between 15 days and 30 days of their last inpatient discharge.
READMIT_24H_48H_IND DOUBLE Y The patient was readmitted in between 24 hours and 48 hours of their last inpatient discharge.
READMIT_30D_48D_IND DOUBLE Y The patient was readmitted in between 30 days and 48 days of their last inpatient discharge.
READMIT_48H_72H_IND DOUBLE Y Indicates whether or not the patient has been readmitted in between 48-72 hours of a previous visit.
READMIT_7D_15D_IND DOUBLE Y The patient was readmitted in between 7 days and 15 days of their last inpatient discharge.
READMIT_GT_48D_IND DOUBLE Y The patient was readmitted in greater than 48 days of their last inpatient discharge.
READMIT_GT_48H_IND DOUBLE Y The patient was readmitted in greater than 48 hours of their last inpatient discharge.
READMIT_GT_72H_IND DOUBLE Y Indicates whether or not the patient has been readmitted in greater than 72 hours of a previous visit.
REASON_FOR_VISIT VARCHAR(255) Y The patient's reason for visit (used when they do not code the admitting diagnosis).
REF_PHYS_FT_NAME VARCHAR(255) Y The free text name identifying the referring physician
REF_PHYS_ID DOUBLE N Unique identification number of the referring physician
REF_PHYS_KEY VARCHAR(255) Y Unique identification number of the referring physician (when the physician is free text)
REF_PHYS_MED_SPEC_CD DOUBLE N The medical specialty for the referring physician as defined within the OMF Grouping Tool.
REF_PHYS_POSITION_CD DOUBLE N The Cerner-defined position for the referring physician.
RELATIVE_INDEX_WT DOUBLE Y Relative Index Weight
RELIGION_CD DOUBLE N The code_value identifying the religion of the patient
RETURN_ED_24H_48H_IND DOUBLE Y Indicates whether or not a patient returned to the ER in between 24 and 48 hours of a previous visit.
RETURN_ED_24H_IND DOUBLE Y Indicates whether or not a patient returned to the ER in less than 24 hours of a previous visit.
RETURN_ED_48H_IND DOUBLE Y Indicates whether or not a patient returned to the ER in less than 48 hours of a previous visit.
RETURN_ED_49H_72H_IND DOUBLE Y Indicates whether or not a patient returned to the ER in between 49 and 72 hours of a previous visit.
RETURN_ED_72H_IND DOUBLE Y Indicates whether or not a patient returned to the ER in less than 72 hours of a previous visit.
SEC_EMP_ORGANIZATION_ID DOUBLE N Secondary health plan employer/sponsor organization ID
SEC_HEALTH_PLAN_GROUP_CD DOUBLE N The client defined grouping to which the secondary health plan belongs to.
SEC_HEALTH_PLAN_ID DOUBLE N Secondary health plan ID
SEC_INS_ASSIGN_BENEFITS_CD DOUBLE N Secondary insurance assignment of benefits
SEC_INS_BEG_EFFECTIVE_DT_NBR DOUBLE Y The Cerner internal system date representation of the beginning effective day of the secondary health plan.
SEC_INS_BEG_EFFECTIVE_DT_TM DATETIME Y The beginning effective DT/TM of the secondary health plan
SEC_INS_BEG_EFFECTIVE_MIN_NBR DOUBLE Y The beginning effective minute of day for the secondary health plan.
SEC_INS_BIRTH_DT_TM DATETIME Y Secondary health plan subscriber's birth DT/TM
SEC_INS_END_EFFECTIVE_DT_NBR DOUBLE Y The Cerner internal system date representation of the ending effective day of the secondary health plan.
SEC_INS_END_EFFECTIVE_DT_TM DATETIME Y The ending effective DT/TM of the secondary health plan
SEC_INS_END_EFFECTIVE_MIN_NBR DOUBLE Y The ending effective minute of day for the secondary health plan.
SEC_INS_GROUP_CD DOUBLE N The client defined grouping to which the secondary insurance company belongs to.
SEC_INS_ORGANIZATION_ID DOUBLE N Secondary insurance company organization ID
SEC_INS_PERSON_ID DOUBLE N Primary health plan subscriber's person ID
SEC_INS_PERSON_RELTN_CD DOUBLE N Secondary health plan subscriber's relationship to the person
SEC_INS_PLAN_TYPE_CD DOUBLE N Secondary health plan type
SEC_ORG_PLAN_RELTN_ID DOUBLE N Secondary Insurance Org Plan Reltn ID
SERVICE_CATEGORY_CD DOUBLE N Codified field which identifies the current category of service the patient is receiving.
SEX_CD DOUBLE N The code_value identifying the gender of the patient
SURGEON_FT_NAME VARCHAR(255) Y The free text name for the surgeon.
SURGEON_GRP_CD DOUBLE N The client defined grouping to which the surgeon belongs
SURGEON_ID DOUBLE N Unique identification number for the surgeon
SURGEON_KEY VARCHAR(255) Y Unique identification number for the surgeon (when the entry is a free text entry).
SURGEON_MED_SPEC_CD DOUBLE N The medical specialty for the surgeon as defined within the OMF Grouping Tool.
SURGEON_POSITION_CD DOUBLE N The Cerner-defined position for the surgeon.
TOTAL_ACCUM_CHARGES DOUBLE Y Contains the total of all the item_extended_prices for a given encounter.
TOTAL_ACCUM_CHARGESF DOUBLE Y The total posted charges.
TOTAL_ACT_COST DOUBLE Y The total actual cost for the encounter.
TOTAL_ACT_DIRECT_FIX_COST DOUBLE Y The total actual direct fixed cost for the encounter
TOTAL_ACT_DIRECT_VAR_COST DOUBLE Y The total actual direct variable cost assigned to the encounter.
TOTAL_ACT_INDIRECT_FIX_COST DOUBLE Y The total actual indirect fixed cost for the encounter.
TOTAL_ACT_INDIRECT_VAR_COST DOUBLE Y The total actual indirect variable cost for the encounter.
TOTAL_STD_COST DOUBLE Y The total standard cost for the encounter.
TOTAL_STD_DIRECT_FIX_COST DOUBLE Y The total standard direct fix cost for the encounter.
TOTAL_STD_DIRECT_VAR_COST DOUBLE Y The total standard direct variable cost for the encounter.
TOTAL_STD_INDIRECT_FIX_COST DOUBLE Y The total standard indirect fix cost for the encounter.
TOTAL_STD_INDIRECT_VAR_COST DOUBLE Y The total standard indirect variable cost for the encounter.
TRANSFER_REASON_CD DOUBLE N Identifies the reason the person was transferred or moved from one location to another.
TRIAGE_CD DOUBLE N Type of triage related to 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.
VIP_CD DOUBLE N Indicated that the person is to be identified and possibly treated with special consideration during the active time of the encounter
VISIT_DATE VARCHAR(25) Y The date that the patient visit started
VISIT_DAY DOUBLE Y The day of the week that the patient visit started
VISIT_DT_NBR DOUBLE Y The Cerner internal system date representation of the day the person visit started.
VISIT_DT_TM DATETIME Y The date/time that the patient visit started
VISIT_HOUR DOUBLE Y The hour of the day that the patient visit started
VISIT_IND DOUBLE Y Indicator identifying whether or not a patient visit occurred
VISIT_MIN_NBR DOUBLE Y The minute of day the person's visit started (1..1440).
VISIT_MONTH DOUBLE Y The month that the patient visit started



Relationship Detail - OMF_ENCNTR_ST


Child Column in OMF_ENCNTR_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
OTHER_HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
PRIM_HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
SEC_HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
DRG_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
ICD9_ADMIT_DIAG_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
ICD9_PRIN_DIAG_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
ICD9_PRIN_PROC_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
ICD9_SECONDARY1_DIAG_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
MRD_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
EMP_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
OTHER_EMP_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
OTHER_INS_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRIM_EMP_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRIM_INS_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
SEC_EMP_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
SEC_INS_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
OTHER_ORG_PLAN_RELTN_ID ORG_PLAN_RELTN ORG_PLAN_RELTN_ID
PRIM_ORG_PLAN_RELTN_ID ORG_PLAN_RELTN ORG_PLAN_RELTN_ID
SEC_ORG_PLAN_RELTN_ID ORG_PLAN_RELTN ORG_PLAN_RELTN_ID
OTHER_INS_PERSON_ID PERSON PERSON_ID
PERSON_ID PERSON PERSON_ID
PRIM_INS_PERSON_ID PERSON PERSON_ID
SEC_INS_PERSON_ID PERSON PERSON_ID




Parent Column in OMF_ENCNTR_ST (PK) Child Table Name Child Column Name
Children: ENCNTR_ID OMF_ENCNTR_ST_EXT ENCNTR_ID