Table Detail Report

ORGANIZATION_RESOURCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Relationship between orgs and resources for reference lab concept in charting
Definition: Organization Resource
Table Type: REFERENCE





Column Detail - ORGANIZATION_RESOURCE


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.
ORG_RESOURCE_TYPE_CD DOUBLE N Identifies the type of relationship between organizations and resources. For this table, it will generally be "Reference Lab"
ORG_RES_ID DOUBLE N An unique internal identifier for the relationship.
PARENT_ENTITY_ID DOUBLE N The organization's id or the location's cd. Associated with the patient's location or organization.
PARENT_ENTITY_NAME VARCHAR(25) Y The table name for the parent entity id. Will most likely be either organization or location
REF_LAB_DESCRIPTION VARCHAR(100) Y A text description which should be used on the chart to identify the resource which performed the work
REF_LAB_IND DOUBLE Y If set to 0, the resource is considered part of the organization in the relationship and charting will not attempt to identify work done by the resource with a footnote since the chart header should be indicative of the organization. If set to 1, the resource is NOT considered part of the organization in the relationship and charting WILL identify work done by the resource with either a footnote or in a reference lab chart section of the chart format.
SERVICE_RESOURCE_CD DOUBLE N An internal identifier for the resource in the relationship.
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 - ORGANIZATION_RESOURCE


Child Column in ORGANIZATION_RESOURCE(FK) Parent Table Name Parent Column Name
Parents: ORG_RESOURCE_TYPE_CD CODE_VALUE CODE_VALUE
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


PRSNL_SERVICE_RESOURCE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Service Resource Relation
Definition: This table defines relationships between personnel (from the prsnl table) and service resources (from the service_resource table) for security purposes.
Table Type: REFERENCE





Column Detail - PRSNL_SERVICE_RESOURCE_RELTN


Column Name Type Null? Definition
PRSNL_ID DOUBLE N The unique identifier of the person who has been granted access to the service_resource.
SERVICE_RESOURCE_CD DOUBLE N The unique identifier for this service resource from the service_resource table and code set 221.
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 - PRSNL_SERVICE_RESOURCE_RELTN


Child Column in PRSNL_SERVICE_RESOURCE_RELTN(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


RESOURCE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Service Resource Group
Definition: Relationship table which associates one resource to another such as Institution to Department, Department to Section , etc.
Table Type: REFERENCE





Column Detail - RESOURCE_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_SERVICE_RESOURCE_CD DOUBLE N The "child" in a resource to resource relationship. If the relationship is Department to Section, Department is the "parent" and Section is the "child". It is a unique internal identifier.
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.
PARENT_SERVICE_RESOURCE_CD DOUBLE N The "parent" in a resource to resource relationship. If the relationship is Department to Section, Department is the "parent" and Section is the "child". It is a unique internal identifier.
RESOURCE_GROUP_TYPE_CD DOUBLE N The definition of the relationship. Generally it is the resource type associated with the parent's resource type. Each type has a Cerner defined cdf_meaning associated with it.
ROOT_SERVICE_RESOURCE_CD DOUBLE N Used when creating "views". It is the internal identifier for the highest resource node in the view. Used to programmatically retrieve all levels in a view quickly. If the view is the "Master", root code will be zero.
SEQUENCE DOUBLE Y An internal value to order or sequence multiple children of a single parent.
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 Y Precursor to root_service_resource_cd. Needed for the conversion utility "LOC_CONVERT_VIEW_TYPES". The attribute is not used and will be removed.



Relationship Detail - RESOURCE_GROUP


Child Column in RESOURCE_GROUP(FK) Parent Table Name Parent Column Name
Parents: ROOT_SERVICE_RESOURCE_CD CODE_VALUE CODE_VALUE
CHILD_SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
PARENT_SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in RESOURCE_GROUP (PK) Child Table Name Child Column Name
Children: CHILD_SERVICE_RESOURCE_CD SR_RESOURCE_GROUP_HIST CHILD_SERVICE_RESOURCE_CD
PARENT_SERVICE_RESOURCE_CD SR_RESOURCE_GROUP_HIST PARENT_SERVICE_RESOURCE_CD
RESOURCE_GROUP_TYPE_CD SR_RESOURCE_GROUP_HIST RESOURCE_GROUP_TYPE_CD
ROOT_SERVICE_RESOURCE_CD SR_RESOURCE_GROUP_HIST ROOT_SERVICE_RESOURCE_CD


ROLE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Role
Definition:
Table Type: REFERENCE





Column Detail - ROLE


Column Name Type Null? Definition
HOLD_DATA DOUBLE Y
SERVICE_RESOURCE_CD DOUBLE N
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.



Relationship Detail - ROLE


Child Column in ROLE(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


ROOM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Room
Definition: The room table is an extension to the location table which contains information specific to a room type of location. A room is specified within the context of a nurse unit or outpatient location.
Table Type: REFERENCE





Column Detail - ROOM


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.
CLASS_CD DOUBLE N User defined room class types. Examples include "private", "semi-private", "ward", etc.
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.
FIXED_BED_IND DOUBLE Y Set to TRUE, if this room has a set or fixed number of beds. Set to FALSE, if the number of beds in this room varies and they do not have specific numbers or identifiers. If false, the user does NOT define beds for the room.
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. User defined.
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. Unique internal identifier.
LOC_NURSE_UNIT_CD DOUBLE N The parent location for the room. Indicates the nurse unit associated with the room. Internal unique identifier.
MED_SERVICE_CD DOUBLE N The category of treatment, surgery, or general resources associated with the room. May be used during ATD transactions to validate whether the patient should be placed in the room.
TELEMETRY_IND DOUBLE Y Telemetry indicator. Not currently in use as of March 1997. To be deleted.
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 - ROOM


Child Column in ROOM(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
LOC_NURSE_UNIT_CD NURSE_UNIT LOCATION_CD




Parent Column in ROOM (PK) Child Table Name Child Column Name
Children: LOCATION_CD BED LOC_ROOM_CD