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 |