Table Detail Report

RAD_PROCEDURE_TIMES



Column Section Relationship Section Top of Page


Table-level Detail

Description: This tables associates an allowed time for each procedure.
Definition: Rad procedure times
Table Type: REFERENCE





Column Detail - RAD_PROCEDURE_TIMES


Column Name Type Null? Definition
ALLOWED_TIME DOUBLE Y Defines the amount of time that a patient is allowed in an exam room for a specified procedure.
CATALOG_CD DOUBLE N Defines the orderable in this 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 - RAD_PROCEDURE_TIMES


Child Column in RAD_PROCEDURE_TIMES(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD


RAD_TRACKING_CONTROLS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Tracking Controls
Definition: This table holds the reference data for Patinet tracking system controls
Table Type: REFERENCE





Column Detail - RAD_TRACKING_CONTROLS


Column Name Type Null? Definition
ALLOW_START_CREATE_IND DOUBLE Y Indicates if tracking can begin a exam completion time.
KEEP_HIST_NBR_DAYS DOUBLE Y Number of days to keep activity history
SERVICE_RESOURCE_CD DOUBLE N Defines the section that the controls apply to.
START_MOVE_PAT_IND DOUBLE Y Indicates if starting an exam should move a patient into the exam room.
UNAVAIL_ON_MON_TIME DOUBLE Y Time that unavailable patient should remain on the monitor.
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 - RAD_TRACKING_CONTROLS


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


RAD_TRACKING_ROOMS



Column Section Top of Page


Table-level Detail

Description: Rad Tracking Rooms
Definition: This table is stores referece data for those locations that are used in radiology patient tracking
Table Type: REFERENCE





Column Detail - RAD_TRACKING_ROOMS


Column Name Type Null? Definition
ALLOWED_TIME DOUBLE Y Time a patient is allowed in a specified room before they are considered over due.
CALL_TRANS_WAIT_ROOM_CD DOUBLE N Transport location that a patient will be moved to when a transport is called after exam completion.
LATE_REPORT_IND DOUBLE Y Indicates if this location should be used on late reports
LOG_OUT_ACTION DOUBLE Y Defines what action should be taken when an exam is completed for this location.
PARENT_ENTITY_ID DOUBLE N Defines a reference to a row on a table defined by the parent entity name.
PARENT_ENTITY_NAME VARCHAR(32) N Defines what table the parent_entity_id references
TRACKING_IND DOUBLE Y Attribute that defines if this location will be used in patient tracking.
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.


RAD_TRACK_EVENT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Track Event Detail
Definition: This table holds activity data for details associated with a tracking event.
Table Type: ACTIVITY





Column Detail - RAD_TRACK_EVENT_DETAIL


Column Name Type Null? Definition
COMMENTS_IND DOUBLE N Indicates if there comments associated with the order.
EVENT_STATUS_CD DOUBLE N Current status of the event.
IV_IND DOUBLE N Indicates if the patient is using an IV.
LOCATION_CD DOUBLE N Defines that location that the patient is to be transported to.
O2_IND DOUBLE N Indicates if the patient is using oxygen apparatus.
ORDER_ID DOUBLE N The Order_Id is a foreign key to the Orders table. It is used to uniquely identify an order.
TRACKING_EVENT_ID DOUBLE N Foreign key to the tracking event table.
TRANSPORT_MODE_CD DOUBLE N Describes the transportation type that is associated with the order.
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 - RAD_TRACK_EVENT_DETAIL


Child Column in RAD_TRACK_EVENT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: TRACKING_EVENT_ID TRACKING_EVENT TRACKING_EVENT_ID


RAD_TRANS_ROOM_REL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Trans Room Rel
Definition: This table describles the relationship between a transporter and a default tranport location.
Table Type: REFERENCE





Column Detail - RAD_TRANS_ROOM_REL


Column Name Type Null? Definition
LOCATION_CD DOUBLE N Identifies the transport location associated with this relationship.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - RAD_TRANS_ROOM_REL


Child Column in RAD_TRANS_ROOM_REL(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
PERSON_ID PRSNL PERSON_ID