Table Detail Report

LOCATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Location
Definition: The location table is a reference of all locations in the system. Examples of some types of locations include facility (institution), building, nurse unit, room bed, outpatient, inventory, lab, pharmacy, etc.
Table Type: REFERENCE





Column Detail - LOCATION


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 Y 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.
APACHE_RELTN_FLAG DOUBLE N Defines a relationship to be considered by Cerner Apache integrated Risk Adjustment software.0 - No defined relationship to Cerner Apache integrated Risk Adjustment software, 1 - Temporary procedural location used by Cerner Apache integrated Risk Adjustment software. A temporary procedural location is where a patient in an APACHE location may transfer to without being discharged from the current ICU encounter. An example of this is an operating room or a recovery room.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CENSUS_IND DOUBLE Y Set to TRUE, if this location is be included on the patient census report. Otherwise, set to FALSE.
CHART_FORMAT_ID DOUBLE Y Temporary mechanism to denote the chart format to be used for expedites when results should print at the location's printer
CONTRIBUTOR_SOURCE_CD DOUBLE Y The code value for the contributing system
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.
DISCIPLINE_TYPE_CD DOUBLE N Used with Service Area locations. Indicates the discipline (lab, rad, etc.) of the service area.
END_EFFECTIVE_DT_TM DATETIME N 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.
EXP_LVL_CD DOUBLE Y Temporary means to indicate when the expedite should be triggered (i.e., upon any result verification or only when the order is complete).
FACILITY_ACCN_PREFIX_CD DOUBLE N Used on facility location rows. Indicates the accession prefix (site prefix).
ICU_IND DOUBLE Y Indicates if this location should be considered an ICU location if/when the Cerner Apache integrated Risk Adjustment software is being used.
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient. The location for an inpatient will be valued with the lowest level location type in the hierarchy of facility, building, nurse unit, room, bed.
LOCATION_TYPE_CD DOUBLE N Location type defines the kind of location (I.e., nurse unit, room, inventory location, etc.). Location types have Cerner defined meanings in the common data foundation.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PATCARE_NODE_IND DOUBLE Y Used to filter patient care locations. If the user determines that they need to build facilities for their client organizations, this indicator would allow us to suppress displaying only those facilities that are hospitals.
REF_LAB_ACCT_NBR VARCHAR(20) Y This column is used to store the reference laboratory account number given to a location which uses the reference lab. It will be used for reference lab interfaces. It is a free text field.
REGISTRATION_IND DOUBLE Y Indicates whether it is applicable to register patients to this location at any given point in time.
RESERVE_IND DOUBLE N reserve indicator
RESOURCE_IND DOUBLE Y Set to TRUE, if this location has corresponding row(s) on the service resource table. Otherwise, set to FALSE.
TRANSFER_DT_TM_IND DOUBLE N Filled out for specimen tracking locations. Indicator for the system to know whether to update the culture start date time as transferred date time when the specimens are transferred to the location.Valid values:0 - Culture date time should be updated with login date time from specimen login application1 - Culture date time should be updated with transfer date time from transfer specimen application.
TRANSMIT_OUTBOUND_ORDER_IND DOUBLE Y Filled out for specimen tracking locations. Indicator for the system to know whether an outbound order should be triggered when specimens are transferred to the location (i.e., PTOP type of transaction).
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.
VIEW_TYPE_CD DOUBLE N OBSOLETE - Precursor to root_loc_cd on the LOCATION_GROUP table. Needed for the conversion utility "LOC_CONVERT_VIEW_TYPES". Once this utility has been executed, the attribute is not used and will be removed.



Relationship Detail - LOCATION


Child Column in LOCATION(FK) Parent Table Name Parent Column Name
Parents: CHART_FORMAT_ID CHART_FORMAT CHART_FORMAT_ID
LOCATION_CD CODE_VALUE CODE_VALUE
LOCATION_TYPE_CD CODE_VALUE CODE_VALUE
VIEW_TYPE_CD CODE_VALUE CODE_VALUE
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in LOCATION (PK) Child Table Name Child Column Name
Children: LOCATION_CD AC_CLASS_PERSON_RELTN LOCATION_CD
AOAV_FACILITY_PREF LOC_FACILITY_CD
AOAV_FACILITY_REF LOC_FACILITY_CD
AOAV_ICU_STAY INITIAL_LOC_NURSE_UNIT_CD
BB_SHIPMENT INVENTORY_AREA_CD
BB_SHIPMENT OWNER_AREA_CD
BED LOCATION_CD
BH_GROUP_DOC LOCATION_CD
BR_ADO_DETAIL FACILITY_CD
BR_CCN_LOC_RELTN LOCATION_CD
BR_CPC_LOC_RELTN LOCATION_CD
BR_HCO_LOC_RELTN LOCATION_CD
BR_MDRO_CAT_EVENT LOCATION_CD
BR_MDRO_CAT_ORGANISM LOCATION_CD
BR_MDRO_OUTBREAK LOCATION_CD
BR_SETUP_WIZARD_LOC_RELTN LOCATION_CD
CDI_FORM_FACILITY_RELTN FACILITY_CD
CDI_PENDING_DOCUMENT LOCATION_CD
CE_MED_ADMIN_IDENT INV_FILL_LOCATION_CD
CHART_SEQ_GROUP_RELTN LOCATION_CD
CMS_CRITICAL_LOCATION LOCATION_CD
CNT_WV_KEY LOCATION_CD
CONTRIBUTOR_SYSTEM LOC_FACILITY_CD
CR_STATIC_REGION_LOC_RELTN LOCATION_CD
DCP_SHIFT_ASSIGNMENT LOC_BED_CD
DCP_SHIFT_ASSIGNMENT LOC_BUILDING_CD
DCP_SHIFT_ASSIGNMENT LOC_FACILITY_CD
DCP_SHIFT_ASSIGNMENT LOC_ROOM_CD
DCP_SHIFT_ASSIGNMENT LOC_UNIT_CD
DISPENSE_HX DISP_LOC_CD
EEM_ABN_CHECK LOCATION_CD
EEM_ABN_LINK LOCATION_CD
EEM_MOH_DETAIL LOCATION_CD
EEM_PROFILE_LOCATION LOCATION_CD
EKS_ADVSR_EVENT LOCATION_CD
ENCNTR_DOMAIN LOC_BED_CD
ENCNTR_DOMAIN LOC_BUILDING_CD
ENCNTR_DOMAIN LOC_FACILITY_CD
ENCNTR_DOMAIN LOC_NURSE_UNIT_CD
ENCNTR_DOMAIN LOC_ROOM_CD
ENCNTR_LOCATION LOCATION_CD
ENCNTR_LOCATION LOC_BED_CD
ENCNTR_LOCATION LOC_BUILDING_CD
ENCNTR_LOCATION LOC_FACILITY_CD
ENCNTR_LOCATION LOC_NURSE_UNIT_CD
ENCNTR_LOCATION LOC_ROOM_CD
ENCNTR_LOC_HIST LOCATION_CD
ENCNTR_LOC_HIST LOC_BED_CD
ENCNTR_LOC_HIST LOC_BUILDING_CD
ENCNTR_LOC_HIST LOC_FACILITY_CD
ENCNTR_LOC_HIST LOC_NURSE_UNIT_CD
ENCNTR_LOC_HIST LOC_ROOM_CD
ENCNTR_PENDING PEND_BED_CD
ENCNTR_PENDING PEND_BUILDING_CD
ENCNTR_PENDING PEND_FACILITY_CD
ENCNTR_PENDING PEND_NURSE_UNIT_CD
ENCNTR_PENDING PEND_ROOM_CD
ENCNTR_PENDING_HIST PEND_BED_CD
ENCNTR_PENDING_HIST PEND_BUILDING_CD
ENCNTR_PENDING_HIST PEND_FACILITY_CD
ENCNTR_PENDING_HIST PEND_NURSE_UNIT_CD
ENCNTR_PENDING_HIST PEND_ROOM_CD
ENCOUNTER LOCATION_CD
ENCOUNTER LOC_BED_CD
ENCOUNTER LOC_BUILDING_CD
ENCOUNTER LOC_FACILITY_CD
ENCOUNTER LOC_NURSE_UNIT_CD
ENCOUNTER LOC_ROOM_CD
EXPEDITE_TRIGGER LOCATION_CD
FILL_BATCH LOC_FACILITY_CD
GL_TRANS_QUALIFIER LOC_BED_CD
GL_TRANS_QUALIFIER LOC_BUILDING_CD
GL_TRANS_QUALIFIER LOC_FACILITY_CD
GL_TRANS_QUALIFIER LOC_NURSE_UNIT_CD
GL_TRANS_QUALIFIER LOC_ROOM_CD
HIM_UNSIGNED_ORDERS FACILITY_CD
HP_FINANCIAL LOCATION_CD
ITEM_SR_LOC_R LOCATION_CD
LABEL_PRINTER_DEF LOCATION_CD
LH_CNT_IC_LOC_HIST BED_LOC_CD
LH_CNT_IC_LOC_HIST BUILD_LOC_CD
LH_CNT_IC_LOC_HIST FAC_LOC_CD
LH_CNT_IC_LOC_HIST NU_LOC_CD
LH_CNT_IC_LOC_HIST ROOM_LOC_CD
LH_CNT_IC_VAE EVENT_LOC_CD
LH_CNT_IC_VAE LOCATION_CD
LH_CNT_IC_VAE MV_LOC_CD
LH_CNT_LTD_DATA INSERT_LOC_BED_CD
LH_CNT_LTD_DATA INSERT_LOC_FAC_CD
LH_CNT_LTD_DATA INSERT_LOC_NURSE_UNIT_CD
LH_CNT_LTD_DATA INSERT_LOC_ROOM_CD
LH_CNT_NHSN_EVENT_METRIC LOC_FACILITY_CD
LH_CNT_NHSN_EVENT_METRIC LOC_UNIT_CD
LOCATION_GROUP CHILD_LOC_CD
LOCATION_GROUP PARENT_LOC_CD
LOCATION_INV_INFO LOCATION_CD
LOC_RESOURCE_R LOCATION_CD
MM_APPROVAL_QUEUE FILL_LOCATION_CD
MM_DISCREPANCY CLUSTER_CD
MM_DISCREPANCY FACILITY_CD
MM_DISCREPANCY LOCATION_CD
MM_DISCREPANCY LOCATOR_CD
MM_ITEM_ORG_COST_HIST ORG_LOCATION_CD
MM_PRICE_FORMULA_LOC_RELTN LOCATION_CD
MM_SUPPLY_CABINET LOC_CD
MM_TEMPLATE LOCATION_CD
MM_TRANS_LINE PERFORMING_LOC_CD
MM_XFI_INSTANCE STORAGE_LOCATION_CD
NURSE_UNIT LOCATION_CD
NURSE_UNIT LOC_BUILDING_CD
NURSE_UNIT LOC_FACILITY_CD
OMF_RADMGMT_ORDER_ST BED_AT_EXAM_CMPLT_CD
OMF_RADMGMT_ORDER_ST LOC_AT_EXAM_CMPLT_CD
OMF_RADMGMT_ORDER_ST ROOM_AT_EXAM_CMPLT_CD
ORDER_DAILY_REVIEW_RSPNL PATIENT_LOCATION_FACILITY_CD
ORDER_DAILY_REVIEW_RSPNL PATIENT_LOCATION_NURSE_UNIT_CD
ORDER_RESULTS_HOLD_CONFIG LOCATION_CD
ORD_LOC_PHARM_RELTN LOC_CD
OSM_FORM_PRINTING LOCATION_CD
OUTCOME_CAT_LOC_RELTN LOCATION_CD
PCT_CARE_TEAM FACILITY_CD
PERSON_DISMISSAL LOCATION_CD
PFT_ENCNTR LOC_FACILITY_CD
PFT_ENCNTR LOC_NURSE_UNIT_CD
PFT_ENCNTR_CENSUS_SUMMARY LOC_BUILDING_CD
PFT_ENCNTR_CENSUS_SUMMARY LOC_FACILITY_CD
PFT_ENCNTR_CENSUS_SUMMARY LOC_NURSE_UNIT_CD
PFT_REG_MOD LOC_FACILITY_CD
PHA_BATCH_REPORT LOC_FACILITY_CD
PHA_ORD_ACT_OBS_ST FUTURE_LOC_FACILITY_CD
PHA_ORD_ACT_OBS_ST FUTURE_LOC_NURSE_UNIT_CD
PM_AUTO_DISCH_PARM_SET_R LOC_FACILITY_CD
PM_LOC_ATTRIB LOCATION_CD
PM_LOC_ATTRIB_HIST LOCATION_CD
PM_MOH_INPAT_CENSUS LOCATION_CD
PM_RBC_PARM_SET_R LOC_FACILITY_CD
PM_RBC_RS_ENCNTR_CHARGE_R LOC_FACILITY_CD
PM_RBC_RS_ENCNTR_CHARGE_R PERF_LOC_CD
PM_ROOM_BED_CHARGE LOC_BED_CD
PM_ROOM_BED_CHARGE LOC_BUILDING_CD
PM_ROOM_BED_CHARGE LOC_FACILITY_CD
PM_ROOM_BED_CHARGE LOC_NURSE_UNIT_CD
PM_ROOM_BED_CHARGE LOC_ROOM_CD
PM_TRANSACTION N_LOCATION_CD
PM_TRANSACTION N_LOC_BED_CD
PM_TRANSACTION N_LOC_BUILDING_CD
PM_TRANSACTION N_LOC_FACILITY_CD
PM_TRANSACTION N_LOC_NURSE_UNIT_CD
PM_TRANSACTION N_LOC_ROOM_CD
PM_TRANSACTION O_LOCATION_CD
PM_TRANSACTION O_LOC_BED_CD
PM_TRANSACTION O_LOC_BUILDING_CD
PM_TRANSACTION O_LOC_FACILITY_CD
PM_TRANSACTION O_LOC_NURSE_UNIT_CD
PM_TRANSACTION O_LOC_ROOM_CD
PM_WAIT_LIST LOCATION_CD
PM_WAIT_LIST LOC_BED_CD
PM_WAIT_LIST LOC_BUILDING_CD
PM_WAIT_LIST LOC_FACILITY_CD
PM_WAIT_LIST LOC_NURSE_UNIT_CD
PM_WAIT_LIST LOC_ROOM_CD
PM_WAIT_LIST_HIST LOCATION_CD
PM_WAIT_LIST_HIST LOC_BED_CD
PM_WAIT_LIST_HIST LOC_BUILDING_CD
PM_WAIT_LIST_HIST LOC_FACILITY_CD
PM_WAIT_LIST_HIST LOC_NURSE_UNIT_CD
PM_WAIT_LIST_HIST LOC_ROOM_CD
PRSNL_CURRENT_LOC LOCATION_CD
PRSNL_LOCATION_R LOCATION_CD
PRSNL_LOC_RELTN LOC_BED_CD
PRSNL_LOC_RELTN LOC_BUILDING_CD
PRSNL_LOC_RELTN LOC_FACILITY_CD
PRSNL_LOC_RELTN LOC_NURSE_UNIT_CD
PRSNL_LOC_RELTN LOC_ROOM_CD
RAD_PROTOCOL_CONFIG FACILITY_CD
RAD_REPORT PERF_LOC_CD
RAD_TRANS_ROOM_REL LOCATION_CD
RAD_VDI_PACS_FACILITY FACILITY_CD
RC_CLOUD_SYNC LOCATION_CD
REFERRAL REFER_FROM_LOC_CD
ROBOTICS_ITEMS LOGIN_LOC_CD
ROOM LOCATION_CD
RXS_ACTIVITY_INDEX CLUSTER_CD
RXS_ACTIVITY_INDEX LOCATION_CD
RXS_ACTIVITY_INDEX LOCATOR_CD
RXS_ALERT LOCATOR_CD
RXS_ALERT OWNER_FACILITY_CD
RXS_ALERT_LOC_RELTN SVC_LOC_CD
RXS_EXTENDED_COUNT_PROP LOCATION_CD
RXS_FOREIGN_DEVICE_ALERT DEVICE_LOC_CD
RXS_FOREIGN_DEVICE_ALERT FACILITY_CD
RXS_FOREIGN_DEVICE_ALERT NURSE_UNIT_CD
RXS_GROUP_LOCATION_RELTN LOCATION_CD
RXS_ITEM_COUNTBACK CLUSTER_CD
RXS_ITEM_COUNTBACK FACILITY_CD
RXS_ITEM_COUNTBACK LOCATION_CD
RXS_ITEM_COUNTBACK LOCATOR_CD
RXS_LAST_LOCATOR_ACTIVITY CLUSTER_CD
RXS_LAST_LOCATOR_ACTIVITY LOCATION_CD
RXS_LAST_LOCATOR_ACTIVITY LOCATOR_CD
RXS_LOCATION_TASK CLUSTER_CD
RXS_LOCATION_TASK FACILITY_CD
RXS_LOCATION_TASK FILL_LOCATION_CD
RXS_LOCATION_TASK LOCATION_CD
RXS_LOCATION_TASK LOCATOR_CD
RXS_LOCATOR_ENCNTR CLUSTER_CD
RXS_LOCATOR_ENCNTR LOCATION_CD
RXS_LOCATOR_ENCNTR LOCATOR_CD
RXS_LOC_ACCESS_CONFIG LOC_CD
RXS_LOC_ATTR LOC_CD
RXS_LOC_SR_EVENT_RELTN LOCATION_CD
RXS_WORKLIST_LOCATION_R LOC_CD
RX_EXT_ORD_PRD_SYNC_RUN FACILITY_CD
RX_IMAGE DEVICE_FAC_CD
RX_IMAGE DEVICE_LOC_CD
RX_IMAGE_QUEUE_LOC_RELTN LOCATION_CD
RX_LOC_RESOURCE_RELTN LOCATION_CD
RX_MED_ORD_DETAIL FACILITY_CD
RX_PENDING_CREDIT PATIENT_FACILITY_CD
RX_PENDING_CREDIT PATIENT_NURSE_UNIT_CD
RX_PENDING_REFILL NURSE_UNIT_CD
RX_PERSON_OWE DISPENSE_FROM_CD
RX_PERSON_OWE INVENTORY_LOCATION_CD
RX_REFILL_HX NURSE_UNIT_CD
RX_THERAP_SBSTTN_FROM FACILITY_CD
RX_VIEW_CONFIG_DETAIL FACILITY_CD
RX_WORK_ITEM_QUEUE FACILITY_CD
RX_WORK_ITEM_QUEUE NURSE_UNIT_CD
RX_WS_FAC_RELTN FAC_CD
RX_WS_FAC_RELTN_HX FAC_CD
SCH_ACTION_LOC LOCATION_CD
SCH_APPT APPT_LOCATION_CD
SCH_APPT TEMPLATE_LOCATION_CD
SCH_APPT_COMP LOCATION_CD
SCH_APPT_INTER LOCATION_CD
SCH_APPT_LOC LOCATION_CD
SCH_APPT_NOTIFY LOCATION_CD
SCH_APPT_OPTION_CONFIG LOCATION_CD
SCH_APPT_ROUTING LOCATION_CD
SCH_AUTO_MSG LOCATION_CD
SCH_BOOKING LOCATION_CD
SCH_CAB_SERVICE LOCATION_CD
SCH_COMP_LOC COMP_LOCATION_CD
SCH_COMP_LOC LOCATION_CD
SCH_DEF_APPLY LOCATION_CD
SCH_DEF_LOC_R LOCATION_CD
SCH_GENERIC_LOC LOCATION_CD
SCH_LIST_LOC LOCATION_CD
SCH_LOCATION LOCATION_CD
SCH_LOC_BOOKING BED_CD
SCH_LOC_BOOKING BUILDING_CD
SCH_LOC_BOOKING FACILITY_CD
SCH_LOC_BOOKING NURSE_UNIT_CD
SCH_LOC_BOOKING ROOM_CD
SCH_LOC_QUOTA LOCATION_CD
SCH_MESSAGING LOCATION_CD
SCH_ORDER_INTER LOCATION_CD
SCH_ORDER_LOC LOCATION_CD
SCH_ORDER_ROLE LOCATION_CD
SCH_PEND_APPT LOCATION_CD
SCH_PEND_ENCNTR_DETAIL LOCATION_CD
SCH_PEND_LOC LOCATION_CD
SCH_RESOURCE ITEM_LOCATION_CD
SCH_RESOURCE_LIST LOCATION_CD
SCH_UNIT_ACTIVITY LOCATION_CD
SCH_UNIT_PHASE_SCHEDULE LOCATION_CD
SERVICE_RESOURCE LOCATION_CD
SN_PICKLIST_LOC_STATUS LOCATION_CD
SN_TISSUE_WORKFLOW LOCATION_CD
SPEC_LBL_PRINTER_DEF LOCATION_CD
TRACKING_ITEM BASE_LOC_CD
WF_STFG_HDR LOCATION_CD
WF_STFG_REQ LOCATION_CD


LOCATION_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Location Group
Definition: The location group table information about the hierachial relationship between different locations.
Table Type: REFERENCE





Column Detail - LOCATION_GROUP


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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CHILD_LOC_CD DOUBLE N This field is the location code which is the child in a relationship. If the relationship is facility to building, facility is the parent, building is child.
END_EFFECTIVE_DT_TM DATETIME N 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.
LOCATION_GROUP_TYPE_CD DOUBLE N The location group type identifies the kind of location associated with the parent location. Location group type codes have Cerner defined meanings in the common data foundation.
PARENT_LOC_CD DOUBLE N This field is the location code which is the parent in a relationship. If the relationship is facility to building, facility is the parent, building is child.
ROOT_LOC_CD DOUBLE N References the location code that is the highest level in a view's hierarchy. For patient care locations, the root code is 0.
SEQUENCE DOUBLE Y The relative position of the child location. Controls the order in which the child location displays relative to other children locations.
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.
VIEW_TYPE_CD DOUBLE N Precursor to root_location_cd. Needed for a conversion utility "LOC_CONVERT_VIEW_TYPES". No longer needed after the utility is performed. NO LONGER USED PROGRAMATICALLY



Relationship Detail - LOCATION_GROUP


Child Column in LOCATION_GROUP(FK) Parent Table Name Parent Column Name
Parents: ROOT_LOC_CD CODE_VALUE CODE_VALUE
CHILD_LOC_CD LOCATION LOCATION_CD
PARENT_LOC_CD LOCATION LOCATION_CD


LOC_RESOURCE_CALENDAR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Location Resource Calendar
Definition: Contains the calendar rows for a resource which indicate when the resource can accept work (routing). Attributes included in the calendar include service area, day of week, time of day, etc.
Table Type: REFERENCE





Column Detail - LOC_RESOURCE_CALENDAR


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 Y 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.
AGE_FROM_MINUTES DOUBLE Y The beginning age in minutes for the routing rule.
AGE_FROM_UNITS_CD DOUBLE N The units associated with the age_from_minutes such as days, months or years.
AGE_TO_MINUTES DOUBLE Y The ending age in minutes for the routing rule
AGE_TO_UNITS_CD DOUBLE N The units associated with the age_to_minutes such as days, months or years.
AVAIL_IND DOUBLE Y Whether the calendar is available. This will be removed in the future. Currently, all rows are set to 1.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CALENDAR_SEQ DOUBLE N The order in which a set of attributes should be considered for routing relative to other sets of attributes. The user may create information for a 5 day week, followed by information for the weekend. The rows associated with the 5 day week contain a calendar sequence lower than those rows associated with the weekend.
CLOSE_TIME DOUBLE Y The time of day which the resource is no longer available to have work routed to it. Possible values are 0 to 2359.
DESCRIPTION VARCHAR(200) Y Text which describes the calendar row for human interpretation.
DISPENSE_TYPE_CD DOUBLE N Used by PharmNet. The valid dispense types associated with the calendar row.
DOW DOUBLE Y Indicates the days of the week that the resource can accept work to be done. Valid values are 0 through 6 (Sun thru Sat). A value of indicates all days of the week.
END_EFFECTIVE_DT_TM DATETIME N 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.
LOCATION_CD DOUBLE N The location which is supported by the resource. For PathNet and RadNet this is usually a location with a cdf_meaning for Service Area.
LOC_RESOURCE_TYPE_CD DOUBLE N Indicates the product associated with the resource's calendar. Examples include Lab, Rad, etc.
OPEN_TIME DOUBLE Y Indicates when the resource is open or available to receive work on a 24 hour clock. Valid values are 0 to 2359
PRIORITY_CD DOUBLE N The reporting priorities associated with the resource's availability.
SEQUENCE DOUBLE N Sequence. Used to differentiate rows with the same resource and service area location. The user may create more than one calendar row with the same service area (may make the priorities, dow, time of day, etc. different but the service area is the same).
SERVICE_RESOURCE_CD DOUBLE N The resource for which the calendar is being built.
SPECIMEN_TYPE_CD DOUBLE N Used by PathNet. The specimen types associated with the resources availability.
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 - LOC_RESOURCE_CALENDAR


Child Column in LOC_RESOURCE_CALENDAR(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOC_RESOURCE_R LOCATION_CD
LOC_RESOURCE_TYPE_CD LOC_RESOURCE_R LOC_RESOURCE_TYPE_CD
SEQUENCE LOC_RESOURCE_R SEQUENCE
SERVICE_RESOURCE_CD LOC_RESOURCE_R SERVICE_RESOURCE_CD


LOC_RESOURCE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Location Service Resource Relationship
Definition: Indicates which locations a service resource can perform work for.
Table Type: REFERENCE





Column Detail - LOC_RESOURCE_R


Column Name Type Null? Definition
GROUP_SEQUENCE DOUBLE Y Used to reconstruct the user interface for building and maintaining calendars. The user can create multiple calendar scenarios for a resource. The group sequence is used to keep all of the data rows together for a given scenario
LOCATION_CD DOUBLE N The location which is being serviced by the resource.
LOC_RESOURCE_TYPE_CD DOUBLE N The product or discipline associated with the relationship. Examples include Lab, Rad, etc.
MM_VENDOR_CUSTOMER_ACCOUNT_ID DOUBLE N The Vendor's (service resource) customer account associated with the service relationship. Materials Management
SEQUENCE DOUBLE N Sequence. Used to differentiate rows with the same resource and service area location. The user may create more than one calendar row with the same service area (may make the priorities, dow, time of day, etc. different but the service area is the same).
SERVICE_RESOURCE_CD DOUBLE N The service resource which is providing service to the location.
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 - LOC_RESOURCE_R


Child Column in LOC_RESOURCE_R(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in LOC_RESOURCE_R (PK) Child Table Name Child Column Name
Children: LOCATION_CD LOC_RESOURCE_CALENDAR LOCATION_CD
LOC_RESOURCE_TYPE_CD LOC_RESOURCE_CALENDAR LOC_RESOURCE_TYPE_CD
SEQUENCE LOC_RESOURCE_CALENDAR SEQUENCE
SERVICE_RESOURCE_CD LOC_RESOURCE_CALENDAR SERVICE_RESOURCE_CD


NURSE_UNIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Nurse Unit
Definition: The nurse unit table is an extension to the location table which contains information specific to a nurse unit type of location. A nurse unit is a hospital inpatient grouping of rooms and beds and identified within the
Table Type: REFERENCE





Column Detail - NURSE_UNIT


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 Y 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.
ATD_REQ_LOC DOUBLE Y ATD Requisition Location. PharmNet. Not currently in use as of March 199. To be deleted.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CART_QTY_IND DOUBLE Y PharmNet. Not currently in use as of March 1997. To be deleted.
DISPENSE_WINDOW DOUBLE Y PharmNet. Not currently in use as of March 1997. To be deleted.
END_EFFECTIVE_DT_TM DATETIME N 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.
LOCATION_CD DOUBLE N The field identifies a patient location. The location for an inpatient will be valued with the lowest level location type in the hierarchy of facility, building, nurse unit, room, bed.
LOC_BUILDING_CD DOUBLE N Internal identifier for the building in which the nurse unit is physically located.
LOC_FACILITY_CD DOUBLE N Internal identifier for the facility in which the nurse unit is physically located.
LOC_OVERFLOW_CD DOUBLE N If the nurse unit is full, the suggested alternate location to be used for Admits and Transfers
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 - NURSE_UNIT


Child Column in NURSE_UNIT(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
LOC_BUILDING_CD LOCATION LOCATION_CD
LOC_FACILITY_CD LOCATION LOCATION_CD




Parent Column in NURSE_UNIT (PK) Child Table Name Child Column Name
Children: LOCATION_CD PM_AUTO_DISCH_PARM_SET_R LOC_NURSE_UNIT_CD
ROOM LOC_NURSE_UNIT_CD