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 |
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 |