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 |