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 |